Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| cof_packinglist_line_id | numeric | 10 | √ | null |
|
|
||
| cof_packinglist_line_uu | varchar | 36 | √ | null |
|
|
||
| ad_client_id | numeric | 10 | √ | null |
|
|
||
| ad_org_id | numeric | 10 | √ | null |
|
|
||
| isactive | bpchar | 1 | √ | null |
|
|
||
| created | timestamp | 29,6 | √ | null |
|
|
||
| createdby | numeric | 10 | √ | null |
|
|
||
| updated | timestamp | 29,6 | √ | null |
|
|
||
| updatedby | numeric | 10 | √ | null |
|
|
||
| cof_packinglist_id | numeric | 10 | √ | null |
|
|
||
| m_inout_id | numeric | 10 | √ | null |
|
|
||
| cof_grossweight | numeric | 0 | √ | null |
|
|
||
| cof_deliveryrestriction_id | numeric | 10 | √ | null |
|
|
||
| cof_deliverydate | timestamp | 29,6 | √ | null |
|
|
||
| cof_deliveryoccurrence_id | numeric | 10 | √ | null |
|
|
||
| line | numeric | 10 | √ | null |
|
|
||
| c_bpartner_id | numeric | 10 | √ | null |
|
|
||
| c_bpartner_location_id | numeric | 10 | √ | null |
|
|
||
| c_order_id | numeric | 10 | √ | null |
|
|
||
| cof_localseparation_id | numeric | 10 | √ | null |
|
|
||
| description | varchar | 255 | √ | null |
|
|
||
| lbr_docfiscal_id | numeric | 10 | √ | null |
|
|
||
| name | varchar | 500 | √ | null |
|
|
||
| m_rma_id | numeric | 10 | √ | null |
|
|
||
| cof_sequenciaentrega | numeric | 10 | √ | null |
|
|
||
| cof_m_shipregion_id | numeric | 10 | √ | null |
|
|
||
| cof_observacoesembarque | varchar | 255 | √ | null |
|
|
||
| cof_dfe_id | numeric | 10 | √ | null |
|
|
||
| cof_permiteestorno | bpchar | 1 | √ | null |
|
|
||
| cof_empresacabecalho_id | numeric | 10 | √ | null |
|
|
||
| cof_organizacaocabecalho_id | numeric | 10 | √ | null |
|
|
||
| documentno | varchar | 30 | √ | null |
|
|
||
| cof_packingtype | varchar | 2 | √ | null |
|
|
||
| cof_packingdate | timestamp | 29,6 | √ | null |
|
|
||
| startdate | timestamp | 29,6 | √ | null |
|
|
||
| cof_regentregacabecalho_id | numeric | 10 | √ | null |
|
|
||
| cof_equipments_id | numeric | 10 | √ | null |
|
|
||
| cof_driver_id | numeric | 10 | √ | null |
|
|
||
| cof_situacaoembarque | varchar | 2 | √ | null |
|
|
||
| cof_fase | varchar | 3 | √ | null |
|
|
||
| cof_distanciatotal | numeric | 0 | √ | null |
|
|
||
| cof_tempototal | numeric | 10 | √ | null |
|
|
||
| cof_tempoalmoco | numeric | 10 | √ | null |
|
|
||
| cof_datainicioplanejamento | timestamp | 29,6 | √ | null |
|
|
||
| cof_datafimplanejamento | timestamp | 29,6 | √ | null |
|
|
||
| cof_combustivel | numeric | 0 | √ | null |
|
|
||
| cof_manutencao | numeric | 0 | √ | null |
|
|
||
| cof_maoobra | numeric | 0 | √ | null |
|
|
||
| cof_pedagio | numeric | 0 | √ | null |
|
|
||
| cof_custototal | numeric | 0 | √ | null |
|
|
||
| cof_custototalkm | numeric | 0 | √ | null |
|
|
||
| cof_distancia | numeric | 0 | √ | null |
|
|
||
| cof_peso | numeric | 0 | √ | null |
|
|
||
| cof_porcentagemcarga | numeric | 0 | √ | null |
|
|
||
| cof_tempotrajetomin | numeric | 0 | √ | null |
|
|
||
| cof_tempoesperamin | numeric | 0 | √ | null |
|
|
||
| cof_tempodescargamin | numeric | 0 | √ | null |
|
|
||
| cof_tempoadicional | numeric | 0 | √ | null |
|
|
||
| cof_tempototalclientemin | numeric | 0 | √ | null |
|
|
||
| cof_chegadacliente | timestamp | 29,6 | √ | null |
|
|
||
| cof_saidacliente | timestamp | 29,6 | √ | null |
|
|
||
| cof_combustivelentrega | numeric | 0 | √ | null |
|
|
||
| cof_manutencaoveiculo | numeric | 0 | √ | null |
|
|
||
| cof_pedagioentrega | numeric | 0 | √ | null |
|
|
||
| cof_maoobraentrega | numeric | 0 | √ | null |
|
|
||
| cof_custototalentrega | numeric | 0 | √ | null |
|
|
||
| cof_isincluiralmoco | bpchar | 1 | √ | null |
|
|
||
| cof_duracaoalmoco | timestamp | 29,6 | √ | null |
|
|
||
| status | varchar | 2 | √ | null |
|
|
||
| salesrep_id | numeric | 10 | √ | null |
|
|
||
| cof_pedidovenda_id | numeric | 0 | √ | null |
|
|