m_inout

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_inout_id numeric 10 null
c_landedcost.m_inout_id minout_clandedcost R
cof_packinglist_line.m_inout_id minout_cofpackinglistline R
m_inout.ref_inout_id minout_ref R
m_inout.reversal_id reversal_minout R
m_inoutconfirm.m_inout_id minout_minoutconfirm C
m_inoutline.m_inout_id minout_minoutline C
m_package.m_inout_id minout_mpackage R
m_rma.inout_id minout_mrma R
m_shippingtransaction.m_inout_id minout_mshippingtransaction R
r_request.m_inout_id minout_rrequest R
r_requestaction.m_inout_id minout_mrequestaction R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_minout R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
issotrx bpchar 1 'Y'::bpchar
documentno varchar 30 null
docaction bpchar 2 null
docstatus bpchar 2 null
posted bpchar 1 'N'::bpchar
processing bpchar 1 √ null
processed bpchar 1 'N'::bpchar
c_doctype_id numeric 10 null
c_doctype.c_doctype_id cdoctype_minout R
description varchar 500 √ null
c_order_id numeric 10 √ null
c_order.c_order_id corder_minout R
dateordered timestamp 29,6 √ null
isprinted bpchar 1 'N'::bpchar
movementtype bpchar 2 null
movementdate timestamp 29,6 null
dateacct timestamp 29,6 null
c_bpartner_id numeric 10 null
c_bpartner.c_bpartner_id cbpartner_minout R
c_bpartner_location_id numeric 10 null
c_bpartner_location.c_bpartner_location_id vbplocation_minout R
m_warehouse_id numeric 10 null
m_warehouse.m_warehouse_id mwarehouse_minout R
poreference varchar 20 √ null
deliveryrule bpchar 1 null
freightcostrule bpchar 1 null
freightamt numeric 0 √ 0
deliveryviarule bpchar 1 null
m_shipper_id numeric 10 √ null
m_shipper.m_shipper_id mshipper_minout R
c_charge_id numeric 10 √ null
c_charge.c_charge_id ccharge_minout R
chargeamt numeric 0 √ 0
priorityrule bpchar 1 null
dateprinted timestamp 29,6 √ null
c_invoice_id numeric 10 √ null
c_invoice.c_invoice_id cinvoice_minout R
createfrom bpchar 1 √ null
generateto bpchar 1 √ null
sendemail bpchar 1 'N'::bpchar
ad_user_id numeric 10 √ null
ad_user.ad_user_id aduser_minout R
salesrep_id numeric 10 √ null
ad_user.ad_user_id aduser_sr_minout R
nopackages numeric 10 √ (1)::numeric
pickdate timestamp 29,6 √ null
shipdate timestamp 29,6 √ null
trackingno varchar 60 √ null
ad_orgtrx_id numeric 10 √ null
ad_org.ad_org_id adorgtrx_minout R
c_project_id numeric 10 √ null
c_project.c_project_id cproject_minout R
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id ccampaign_minout R
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_minout R
user1_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celementvalueuser1_minout R
user2_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celementvalueuser2_minout R
datereceived timestamp 29,6 √ null
isintransit bpchar 1 'N'::bpchar
ref_inout_id numeric 10 √ null
m_inout.m_inout_id minout_ref R
createconfirm bpchar 1 √ null
createpackage bpchar 1 √ null
isapproved bpchar 1 'N'::bpchar
isindispute bpchar 1 'N'::bpchar
volume numeric 0 √ null
weight numeric 0 √ null
m_rma_id numeric 10 √ null
m_rma.m_rma_id mrma_minout R
reversal_id numeric 10 √ null
m_inout.m_inout_id reversal_minout R
isdropship bpchar 1 √ 'N'::bpchar
dropship_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id dropshipbpartner_minout R
dropship_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id dropshiplocation_minout R
dropship_user_id numeric 10 √ null
ad_user.ad_user_id dropshipuser_minout R
processedon numeric 0 √ null
m_inout_uu varchar 36 √ NULL::character varying
freightcharges varchar 10 √ NULL::character varying
shipperaccount varchar 40 √ NULL::character varying
insurance bpchar 1 √ NULL::bpchar
fob varchar 10 √ NULL::character varying
isalternatereturnaddress bpchar 1 'N'::bpchar
returnbpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id returnbpartner_minout R
returnlocation_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id returnlocation_minout R
returnuser_id numeric 10 √ NULL::numeric
ad_user.ad_user_id returnuser_minout R
lbr_nfentrada varchar 20 √ null
cof_grossweight numeric 0 √ (0)::numeric
cof_netweight numeric 0 √ (0)::numeric
cof_volumetype varchar 60 √ null
cof_brand varchar 60 √ NULL::character varying
lbr_docfiscal_id numeric 10 √ null
lbr_docfiscal.lbr_docfiscal_id lbrdocfiscal_minout N
cof_deliverynote varchar 255 √ NULL::character varying
cof_isgeneratenftransp bpchar 1 √ NULL::bpchar
cof_m_shipregion_id numeric 10 √ NULL::numeric
cof_m_shipregion.cof_m_shipregion_id cofmshipregion_minout R
cof_isindustrialization bpchar 1 √ 'N'::bpchar
cof_emtratamento bpchar 1 'N'::bpchar
cof_leituraemmassa text 2147483647 √ null
createlinesfrom bpchar 1 √ NULL::bpchar
cof_localizacaocomplementar_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id coflocalizacaocomplementar_min R
cof_agrupamento bpchar 1 √ NULL::bpchar
cof_chaveagrupamento varchar 255 √ NULL::character varying
cof_isgeradoporpontoderemessa bpchar 1 'N'::bpchar
cof_notalogistica varchar 255 √ NULL::character varying
cof_pontoremessa_id numeric 10 √ NULL::numeric
cof_pontoremessa.cof_pontoremessa_id cofpontoremessa_minout R

Indexes

Constraint Name Type Sort Column(s)
m_inout_pkey Primary key Asc m_inout_id
idxm_inout_proc_on Performance Asc/Asc/Asc/Asc posted + processed + processedon + ad_client_id
m_inout_bpartner Performance Asc c_bpartner_id
m_inout_c_invoice_id_idx Performance Asc c_invoice_id
m_inout_docstatus Performance Asc/Asc/Asc docstatus + issotrx + m_warehouse_id
m_inout_documentno Performance Asc documentno
m_inout_order Performance Asc c_order_id
m_inout_uu_idx Must be unique Asc m_inout_uu

Check Constraints

Constraint Name Constraint
m_inout_cof_isindustrialization_check ((cof_isindustrialization = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inout_isdropship_check ((isdropship = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inout_issotrx_check ((issotrx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inout_cof_emtratamento_check ((cof_emtratamento = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inout_generateto_check ((generateto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inout_isprinted_check ((isprinted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inout_isalternatereturnaddress_check ((isalternatereturnaddress = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inout_cof_isgeradoporpontoderemessa_check ((cof_isgeradoporpontoderemessa = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inout_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inout_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inout_createfrom_check ((createfrom = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation