m_inout

0 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
cof_rv_detalheslistaembarque.m_inout_id Implied Constraint R
cof_rv_docfiscal.m_inout_id Implied Constraint R
cof_rv_infodevolucao.m_inout_id Implied Constraint R
cof_rv_requestpartner.m_inout_id Implied Constraint R
i_inout.m_inout_id Implied Constraint R
lbr_docfiscal.m_inout_id Implied Constraint R
m_inout.ref_inout_id minout_ref R
m_inout.reversal_id reversal_minout R
m_inout_header_v.m_inout_id Implied Constraint R
m_inout_header_vt.m_inout_id Implied Constraint R
m_inout_line_v.m_inout_id Implied Constraint R
m_inout_line_vt.m_inout_id Implied Constraint R
m_inout_lineconfirm_v.m_inout_id Implied Constraint R
m_inout_lineconfirm_vt.m_inout_id Implied Constraint R
m_inoutconfirm.m_inout_id minout_minoutconfirm C
m_inoutconfirm_v.m_inout_id Implied Constraint R
m_inoutconfirm_vt.m_inout_id Implied Constraint R
m_inoutline.m_inout_id minout_minoutline C
m_inoutlinema_v.m_inout_id Implied Constraint R
m_inoutlinema_vt.m_inout_id Implied Constraint R
m_movement.m_inout_id Implied Constraint R
m_package.m_inout_id minout_mpackage R
m_packagelines_avail_v.m_inout_id Implied Constraint R
m_rma.inout_id minout_mrma R
m_rma_createfrom_v.m_inout_id Implied Constraint R
m_shippingtransaction.m_inout_id minout_mshippingtransaction R
m_transaction_v.m_inout_id Implied Constraint R
r_request.m_inout_id minout_rrequest R
r_request_v.m_inout_id Implied Constraint R
r_requestaction.m_inout_id minout_mrequestaction R
rv_inoutconfirm.m_inout_id Implied Constraint R
rv_inoutdetails.m_inout_id Implied Constraint R
rv_inoutlineconfirm.m_inout_id Implied Constraint R
rv_transaction.m_inout_id Implied Constraint R
rv_transaction.m_inoutline_m_inout_id Implied Constraint R
t_transaction.m_inout_id Implied Constraint R
x_packagelineweight.m_inout_id Implied Constraint 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 255 √ 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::numeric
lbr_docfiscal.lbr_docfiscal_id lbrdocfiscal_minout C
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

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_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_isalternatereturnaddress_check ((isalternatereturnaddress = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inout_cof_emtratamento_check ((cof_emtratamento = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inout_isdropship_check ((isdropship = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inout_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inout_issotrx_check ((issotrx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inout_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inout_isprinted_check ((isprinted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inout_createfrom_check ((createfrom = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inout_cof_isindustrialization_check ((cof_isindustrialization = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inout_generateto_check ((generateto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation