cof_packinglist

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cof_packinglist_id numeric 10 null
c_order.cof_packinglist_id cofpackinglist_corder R
cof_mdfe.cof_packinglist_id cofpackinglist_cofmdfe R
cof_ocorrenciaembdes.cof_packinglist_id cofpackinglist_cofocorrenciaem R
cof_packinglist_line.cof_packinglist_id cofpackinglist_cofpackinglistl C
cof_packinglist_uu varchar 36 √ NULL::character varying
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 null
createdby numeric 10 null
updated timestamp 29,6 null
updatedby numeric 10 null
status varchar 2 'OP'::character varying
cof_packingtype varchar 2 null
cof_packingdate timestamp 29,6 √ null
startdate timestamp 29,6 √ null
enddate timestamp 29,6 √ null
cof_driver_id numeric 10 √ NULL::numeric
cof_driver.cof_driver_id cofdriver_cofpackinglist R
cof_licensenumber varchar 11 √ NULL::character varying
lbr_cpf varchar 14 √ NULL::character varying
cof_equipments_id numeric 10 √ NULL::numeric
cof_equipments.cof_equipments_id cofequipments_cofpackinglist R
cof_chassi varchar 17 √ NULL::character varying
cof_platenumber varchar 8 √ NULL::character varying
cof_kminitial numeric 0 √ null
cof_kmfinal numeric 0 √ null
m_shipper_id numeric 10 √ NULL::numeric
m_shipper.m_shipper_id mshipper_cofpackinglist R
description varchar 255 √ NULL::character varying
weight numeric 0 √ null
documentno varchar 30 √ NULL::character varying
cof_processing bpchar 1 √ NULL::bpchar
processing bpchar 1 √ NULL::bpchar
cof_stateplate_id numeric 10 √ NULL::numeric
c_region.c_region_id cofstateplate_cofpackinglist R
linkurl varchar 2000 √ null
html text 2147483647 √ null
cof_isprinted bpchar 1 'N'::bpchar
cof_m_shipregion_id numeric 10 √ NULL::numeric
cof_m_shipregion.cof_m_shipregion_id cofmshipregion_cofpackinglist R
cof_porteiroentrada_id numeric 10 √ null
ad_user.ad_user_id cofporteiroentrada_cofpackingl R
cof_porteirosaida_id numeric 10 √ null
ad_user.ad_user_id cofporteirosaida_cofpackinglis R
cof_kmentrada numeric 10 √ NULL::numeric
cof_kmsaida numeric 10 √ NULL::numeric
cof_toleranciaadsaida numeric 0 √ null
cof_toleranciaadentrada numeric 0 √ null
cof_situacaoembarque varchar 2 'AP'::character varying
issotrx bpchar 1 'Y'::bpchar
cof_pesocarregamento numeric 15 √ null
cof_pesoentrada_id numeric 15 √ null
cof_pesosaida_id numeric 15 √ null
cof_tara numeric 15 √ null
cof_fase varchar 3 √ NULL::character varying
cof_helper varchar 40 √ NULL::character varying
cof_warehouseto_id numeric 10 √ NULL::numeric
m_warehouse.m_warehouse_id cofwarehouseto_cofpackinglist R
cof_warehouse_id numeric 10 √ NULL::numeric
m_warehouse.m_warehouse_id cofwarehouse_cofpackinglist R
cof_variacaopermitidakgacima numeric 0 √ '0'::numeric
cof_variacaoentrada numeric 0 √ '0'::numeric
cof_variacaosaida numeric 0 √ null
cof_taraequipamento numeric 0 √ '0'::numeric
cof_variacaopermitidakgabaixo numeric 0 √ '0'::numeric
cof_ocorrenciaspesagem text 2147483647 √ null
cof_tempototal numeric 10 √ NULL::numeric
cof_distanciatotal numeric 0 √ null
cof_tempoalmoco numeric 10 √ NULL::numeric
cof_datafimplanejamento timestamp 29,6 √ null
cof_datainicioplanejamento 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_helper_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cofhelper_cofpackinglist R
cte_tipofrete varchar 2 √ NULL::character varying
cte_valorfretepeso numeric 0 √ '0'::numeric
cte_porcentagem numeric 0 √ '0'::numeric
cte_valorfretetotal numeric 0 √ '0'::numeric
cte_isremetenteemissor bpchar 1 'N'::bpchar
cte_istomadoremissor bpchar 1 'N'::bpchar
cte_istomadorremetenteeminfe bpchar 1 'N'::bpchar
cte_cte_id numeric 10 √ NULL::numeric
cte_cte.cte_cte_id ctecte_cofpackinglist C
cof_iscteautomatizado bpchar 1 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
cof_packinglist_key Primary key Asc cof_packinglist_id
cof_packinglist_uu_idx Must be unique Asc cof_packinglist_uu

Check Constraints

Constraint Name Constraint
cof_packinglist_cof_isprinted_check ((cof_isprinted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_packinglist_issotrx_check ((issotrx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_packinglist_cte_istomadoremissor_check ((cte_istomadoremissor = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_packinglist_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_packinglist_cof_iscteautomatizado_check ((cof_iscteautomatizado = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_packinglist_cte_istomadorremetenteeminfe_check ((cte_istomadorremetenteeminfe = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_packinglist_cte_isremetenteemissor_check ((cte_isremetenteemissor = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation