m_inoutline

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_inoutline_id numeric 10 null
a_asset.m_inoutline_id minoutline_aasset R
a_asset_addition.m_inoutline_id minoutline_aassetaddition R
a_asset_delivery.m_inoutline_id moutline_aassetdelivery C
c_invoiceline.m_inoutline_id minoutline_cinvoiceline R
c_landedcost.m_inoutline_id minoutline_clandedcost R
c_landedcostallocation.m_inoutline_id minoutline_clandedcostallocati R
c_projectissue.m_inoutline_id minoutline_cprojectissue R
cof_itemsubstituto.m_inoutline_id minoutline_cofitemsubstituto R
cof_rv_docfiscal.m_inoutline_id Implied Constraint R
cof_rv_infodevolucao.m_inoutline_id Implied Constraint R
i_inout.m_inoutline_id Implied Constraint R
lbr_docfiscal_line.m_inoutline_id minoutline_lbrdocfiscalline R
m_costdetail.m_inoutline_id minoutline_mcostdetail R
m_costmovement_v.m_inoutline_id Implied Constraint R
m_inout_line_v.m_inoutline_id Implied Constraint R
m_inout_line_vt.m_inoutline_id Implied Constraint R
m_inout_lineconfirm_v.m_inoutline_id Implied Constraint R
m_inout_lineconfirm_vt.m_inoutline_id Implied Constraint R
m_inoutline.ref_inoutline_id minoutline_ref R
m_inoutline.reversalline_id reversalline_minoutline R
m_inoutlineconfirm.m_inoutline_id minoutline_minoutconfirm C
m_inoutlinema.m_inoutline_id minoutline_minoutlinema C
m_inoutlinema_returned.m_inoutline_id Implied Constraint R
m_inoutlinema_v.m_inoutline_id Implied Constraint R
m_inoutlinema_vt.m_inoutline_id Implied Constraint R
m_matchinv.m_inoutline_id minoutline_mmatchinv R
m_matchpo.m_inoutline_id minoutline_mmatchpo R
m_packageline.m_inoutline_id minoutline_mpackageline R
m_packagelines_avail_v.m_inoutline_id Implied Constraint R
m_production.m_inoutline_id minoutline_mproduction R
m_rma_createfrom_v.m_inoutline_id Implied Constraint R
m_rmaline.m_inoutline_id minoutline_mrmaline R
m_transaction.m_inoutline_id minoutline_mtransaction R
m_transaction_v.m_inoutline_id Implied Constraint R
m_transactionallocation.m_inoutline_id minoutline_mtrxalloc R
m_transactionallocation.out_m_inoutline_id minoutlineout_mtrxalloc R
rv_asset_delivery.m_inoutline_id Implied Constraint R
rv_c_invoiceline.m_inoutline_id Implied Constraint R
rv_commissionrundetail.m_inoutline_id Implied Constraint R
rv_costdetail.m_inoutline_id Implied Constraint R
rv_inoutdetails.m_inoutline_id Implied Constraint R
rv_inoutlineconfirm.m_inoutline_id Implied Constraint R
rv_m_transaction.m_inoutline_id Implied Constraint R
rv_projectlineissue.m_inoutline_id Implied Constraint R
rv_transaction.c_prjctissue_m_inoutline_id Implied Constraint R
rv_transaction.m_inoutline_id Implied Constraint R
t_transaction.m_inoutline_id minoutline_ttransaction C
x_packagelineweight.m_inoutline_id Implied Constraint R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_minoutline R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
line numeric 10 null
description varchar 255 √ null
m_inout_id numeric 10 null
m_inout.m_inout_id minout_minoutline C
c_orderline_id numeric 10 √ null
c_orderline.c_orderline_id corderline_minout R
m_locator_id numeric 10 √ null
m_locator.m_locator_id mlocator_minoutline R
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_minoutline R
c_uom_id numeric 10 null
c_uom.c_uom_id cuom_minoutline R
movementqty numeric 0 0
isinvoiced bpchar 1 'N'::bpchar
m_attributesetinstance_id numeric 10 √ 0
m_attributesetinstance.m_attributesetinstance_id mattrsetinst_minoutline R
isdescription bpchar 1 'N'::bpchar
confirmedqty numeric 0 √ 0
pickedqty numeric 0 √ 0
scrappedqty numeric 0 √ 0
targetqty numeric 0 √ 0
ref_inoutline_id numeric 10 √ null
m_inoutline.m_inoutline_id minoutline_ref R
processed bpchar 1 'N'::bpchar
qtyentered numeric 0 null
c_charge_id numeric 10 √ null
c_charge.c_charge_id ccharge_minoutline R
c_project_id numeric 10 √ null
c_project.c_project_id cproject_minoutline R
c_projectphase_id numeric 10 √ null
c_projectphase.c_projectphase_id c_projectphase_minoutline R
c_projecttask_id numeric 10 √ null
c_projecttask.c_projecttask_id cprojecttask_minoutline R
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id ccampaign_minoutline R
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_minoutline R
user1_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celemenrvalueuser1_minoutline R
user2_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celemenrvalueuser2_minoutline R
ad_orgtrx_id numeric 10 √ null
ad_org.ad_org_id adorgtrx_minoutline R
m_rmaline_id numeric 10 √ null
m_rmaline.m_rmaline_id mrmaline_minoutline R
reversalline_id numeric 10 √ null
m_inoutline.m_inoutline_id reversalline_minoutline R
m_inoutline_uu varchar 36 √ NULL::character varying
qtyoverreceipt numeric 0 √ 0
cof_netweight numeric 0 '0'::numeric
cof_grossweight numeric 0 '0'::numeric
lbr_docfiscal_line_id numeric 10 √ NULL::numeric
lbr_docfiscal_line.lbr_docfiscal_line_id lbrdocfiscalline_minoutline C
cof_pdevol numeric 0 √ null
cof_sourceqty numeric 0 √ null
cof_qtydelivery numeric 0 √ '0'::numeric
isautoproduce bpchar 1 √ 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
m_inoutline_pkey Primary key Asc m_inoutline_id
m_inoutline_inout Performance Asc m_inout_id
m_inoutline_orderline_idx Performance Asc c_orderline_id
m_inoutline_product Performance Asc m_product_id
m_inoutline_uu_idx Must be unique Asc m_inoutline_uu

Check Constraints

Constraint Name Constraint
m_inoutline_isinvoiced_check ((isinvoiced = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inoutline_isautoproduce_check ((isautoproduce = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_inoutline_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation