View idempiere11.adempiere.m_inout_line_vt
M_InOut_Line_vt

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
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
ad_language varchar 6  √  null
m_inout_id numeric 10  √  null
m_inoutline_id numeric 10  √  null
line numeric 0  √  null
m_product_id numeric 10  √  null
movementqty numeric 0  √  null
qtyentered numeric 0  √  null
uomsymbol varchar 2147483647  √  null
qtyordered numeric 0  √  null
qtydelivered numeric 0  √  null
qtybackordered numeric 0  √  null
name text 2147483647  √  null
description varchar 2147483647  √  null
documentnote varchar 2000  √  null
upc varchar 30  √  null
sku varchar 30  √  null
productvalue varchar 510  √  null
m_locator_id numeric 10  √  null
m_warehouse_id numeric 10  √  null
x varchar 60  √  null
y varchar 60  √  null
z varchar 60  √  null
m_attributesetinstance_id numeric 10  √  null
m_attributeset_id numeric 10  √  null
serno varchar 40  √  null
lot varchar 40  √  null
m_lot_id numeric 10  √  null
guaranteedate timestamp 29,6  √  null
productdescription varchar 255  √  null
imageurl varchar 120  √  null
c_campaign_id numeric 10  √  null
c_project_id numeric 10  √  null
c_activity_id numeric 10  √  null
c_projectphase_id numeric 10  √  null
c_projecttask_id numeric 10  √  null
ad_orgtrx_id numeric 10  √  null
c_charge_id numeric 10  √  null
confirmedqty numeric 0  √  null
c_orderline_id numeric 10  √  null
m_inoutline_c_uom_id numeric 10  √  null
m_inoutline_isdescription bpchar 1  √  null
isinvoiced bpchar 1  √  null
m_rmaline_id numeric 10  √  null
pickedqty numeric 0  √  null
m_inoutline_processed bpchar 1  √  null
ref_inoutline_id numeric 10  √  null
reversalline_id numeric 10  √  null
scrappedqty numeric 0  √  null
targetqty numeric 0  √  null
m_inoutline_user1_id numeric 10  √  null
m_inoutline_user2_id numeric 10  √  null
m_product_ad_org_id numeric 10  √  null
classification varchar 12  √  null
m_product_copyfrom bpchar 1  √  null
m_product_created timestamp 29,6  √  null
m_product_createdby numeric 10  √  null
c_revenuerecognition_id numeric 10  √  null
c_subscriptiontype_id numeric 10  √  null
m_product_c_taxcategory_id numeric 10  √  null
m_product_c_uom_id numeric 10  √  null
descriptionurl varchar 120  √  null
discontinued bpchar 1  √  null
discontinuedat timestamp 29,6  √  null
group1 varchar 255  √  null
group2 varchar 255  √  null
guaranteedays numeric 10  √  null
guaranteedaysmin numeric 10  √  null
help varchar 2000  √  null
m_product_isactive bpchar 1  √  null
isbom bpchar 1  √  null
isdropship bpchar 1  √  null
isexcludeautodelivery bpchar 1  √  null
isinvoiceprintdetails bpchar 1  √  null
ispicklistprintdetails bpchar 1  √  null
ispurchased bpchar 1  √  null
m_product_isselfservice bpchar 1  √  null
issold bpchar 1  √  null
isstocked bpchar 1  √  null
m_product_issummary bpchar 1  √  null
isverified bpchar 1  √  null
iswebstorefeatured bpchar 1  √  null
lowlevel numeric 10  √  null
m_product_m_attributeset_id numeric 10  √  null
m_product_m_asi_id numeric 10  √  null
m_freightcategory_id numeric 10  √  null
m_product_m_locator_id numeric 10  √  null
m_product_m_prod_category_id numeric 10  √  null
m_product_processing bpchar 1  √  null
producttype bpchar 1  √  null
r_mailtext_id numeric 10  √  null
m_product_salesrep_id numeric 10  √  null
s_expensetype_id numeric 10  √  null
shelfdepth numeric 10  √  null
shelfheight numeric 0  √  null
shelfwidth numeric 10  √  null
m_product_s_resource_id numeric 10  √  null
unitsperpack numeric 10  √  null
unitsperpallet numeric 0  √  null
m_product_updated timestamp 29,6  √  null
m_product_updatedby numeric 10  √  null
versionno varchar 20  √  null
volume numeric 0  √  null
weight numeric 0  √  null
c_uom_ad_org_id numeric 10  √  null
costingprecision numeric 10  √  null
c_uom_description varchar 255  √  null
c_uom_isactive bpchar 1  √  null
c_uom_isdefault bpchar 1  √  null
c_uom_name varchar 60  √  null
stdprecision numeric 10  √  null
uomtype varchar 2  √  null
x12de355 varchar 4  √  null
m_asi_ad_org_id numeric 10  √  null
m_asi_created timestamp 29,6  √  null
m_asi_createdby numeric 10  √  null
m_asi_description varchar 255  √  null
m_asi_isactive bpchar 1  √  null
m_asi_updated timestamp 29,6  √  null
m_asi_updatedby numeric 10  √  null
m_locator_ad_org_id numeric 10  √  null
m_locator_isactive bpchar 1  √  null
isdefault bpchar 1  √  null
priorityno numeric 10  √  null
m_locator_value varchar 40  √  null
c_orderline_ad_org_id numeric 0  √  null
c_orderline_ad_orgtrx_id numeric 0  √  null
c_orderline_c_activity_id numeric 0  √  null
c_orderline_c_bpartner_id numeric 0  √  null
c_orderline_c_bp_location_id numeric 0  √  null
c_orderline_c_charge_id numeric 0  √  null
c_orderline_c_currency_id numeric 0  √  null
c_order_id numeric 0  √  null
c_orderline_c_project_id numeric 0  √  null
c_orderline_c_projectphase_id numeric 0  √  null
c_orderline_c_projecttask_id numeric 0  √  null
c_orderline_created timestamp 29,6  √  null
c_orderline_createdby numeric 0  √  null
c_orderline_c_tax_id numeric 0  √  null
c_orderline_c_uom_id numeric 0  √  null
datedelivered timestamp 29,6  √  null
dateinvoiced timestamp 29,6  √  null
dateordered timestamp 29,6  √  null
c_orderline_datepromised timestamp 29,6  √  null
c_orderline_description varchar 2147483647  √  null
discount numeric 0  √  null
c_orderline_freightamt numeric 0  √  null
c_orderline_isactive bpchar 2147483647  √  null
c_orderline_isdescription bpchar 2147483647  √  null
c_orderline_line numeric 0  √  null
linenetamt numeric 0  √  null
link_orderline_id numeric 0  √  null
c_orderline_m_asi_id numeric 0  √  null
c_orderline_m_product_id numeric 0  √  null
m_promotion_id numeric 0  √  null
c_orderline_m_shipper_id numeric 0  √  null
c_orderline_warehouse_id numeric 0  √  null
priceactual numeric 0  √  null
pricecost numeric 0  √  null
priceentered numeric 0  √  null
pricelimit numeric 0  √  null
pricelist numeric 0  √  null
c_orderline_processed bpchar 2147483647  √  null
c_orderline_qtyentered numeric 0  √  null
qtyinvoiced numeric 0  √  null
qtylostsales numeric 0  √  null
qtyreserved numeric 0  √  null
ref_orderline_id numeric 0  √  null
rramt numeric 0  √  null
rrstartdate timestamp 29,6  √  null
s_resourceassignment_id numeric 0  √  null
c_orderline_updated timestamp 29,6  √  null
c_orderline_updatedby numeric 0  √  null
c_orderline_user1_id numeric 0  √  null
c_orderline_user2_id numeric 0  √  null
c_charge_c_org_id numeric 0  √  null
c_charge_c_bpartner_id numeric 0  √  null
c_chargetype_id numeric 0  √  null
c_charge_chargeamt numeric 0  √  null
c_charge_c_taxcategory_id numeric 0  √  null
c_charge_description varchar 2147483647  √  null
c_charge_isactive bpchar 2147483647  √  null
issamecurrency bpchar 2147483647  √  null
issametax bpchar 2147483647  √  null
c_charge_istaxincluded bpchar 2147483647  √  null

Analyzed at 2024-01-03 13:53 +0100