SchemaSpy Analysis of idempiere11.adempiere - ColumnsCosting | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:47 +0100 |
| |||||
|
idempiere11.adempiere contains 1206 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default |
---|---|---|---|---|---|---|
c_invoiceline | a_asset_group_id | numeric | 10 | √ | null | |
m_product_category | a_asset_group_id | numeric | 10 | √ | null | |
c_invoiceline | a_asset_id | numeric | 10 | √ | null | |
c_invoiceline | a_capvsexp | varchar | 3 | √ | null | |
c_invoiceline | a_createasset | bpchar | 1 | √ | 'N'::bpchar | |
c_invoiceline | a_processed | bpchar | 1 | √ | 'N'::bpchar | |
c_acctschema | ad_client_id | numeric | 10 | |||
c_allocationline | ad_client_id | numeric | 10 | |||
c_invoice | ad_client_id | numeric | 10 | |||
c_invoiceline | ad_client_id | numeric | 10 | |||
c_landedcost | ad_client_id | numeric | 10 | |||
c_landedcostallocation | ad_client_id | numeric | 10 | |||
c_order | ad_client_id | numeric | 10 | |||
c_orderlandedcost | ad_client_id | numeric | 10 | |||
c_orderlandedcostallocation | ad_client_id | numeric | 10 | |||
c_orderline | ad_client_id | numeric | 10 | |||
c_projectissue | ad_client_id | numeric | 10 | |||
c_projectissuema | ad_client_id | numeric | 10 | |||
m_attributesetinstance | ad_client_id | numeric | 10 | |||
m_cost | ad_client_id | numeric | 10 | |||
m_costdetail | ad_client_id | numeric | 10 | |||
m_costelement | ad_client_id | numeric | 10 | |||
m_costhistory | ad_client_id | numeric | 10 | |||
m_costmovement_v | ad_client_id | numeric | 10 | √ | null | |
m_costqueue | ad_client_id | numeric | 10 | |||
m_costtype | ad_client_id | numeric | 10 | |||
m_inout | ad_client_id | numeric | 10 | |||
m_inoutline | ad_client_id | numeric | 10 | |||
m_inoutlinema | ad_client_id | numeric | 10 | |||
m_inventoryline | ad_client_id | numeric | 10 | |||
m_inventorylinema | ad_client_id | numeric | 10 | |||
m_locator | ad_client_id | numeric | 10 | |||
m_matchinv | ad_client_id | numeric | 10 | |||
m_matchpo | ad_client_id | numeric | 10 | |||
m_movementline | ad_client_id | numeric | 10 | |||
m_movementlinema | ad_client_id | numeric | 10 | |||
m_product | ad_client_id | numeric | 10 | |||
m_product_acct | ad_client_id | numeric | 10 | |||
m_product_category | ad_client_id | numeric | 10 | |||
m_product_category_acct | ad_client_id | numeric | 10 | |||
m_product_po | ad_client_id | numeric | 10 | |||
m_productionline | ad_client_id | numeric | 10 | |||
m_productionlinema | ad_client_id | numeric | 10 | |||
m_transaction | ad_client_id | numeric | 10 | |||
m_warehouse | ad_client_id | numeric | 10 | |||
m_warehouse_acct | ad_client_id | numeric | 10 | |||
s_resource | ad_client_id | numeric | 10 | |||
t_inventoryvalue | ad_client_id | numeric | 10 | √ | null | |
c_acctschema | ad_org_id | numeric | 10 | |||
c_allocationline | ad_org_id | numeric | 10 | |||
c_invoice | ad_org_id | numeric | 10 | |||
c_invoiceline | ad_org_id | numeric | 10 | |||
c_landedcost | ad_org_id | numeric | 10 | |||
c_landedcostallocation | ad_org_id | numeric | 10 | |||
c_order | ad_org_id | numeric | 10 | |||
c_orderlandedcost | ad_org_id | numeric | 10 | |||
c_orderlandedcostallocation | ad_org_id | numeric | 10 | |||
c_orderline | ad_org_id | numeric | 10 | |||
c_projectissue | ad_org_id | numeric | 10 | |||
c_projectissuema | ad_org_id | numeric | 10 | |||
m_attributesetinstance | ad_org_id | numeric | 10 | |||
m_cost | ad_org_id | numeric | 10 | |||
m_costdetail | ad_org_id | numeric | 10 | |||
m_costelement | ad_org_id | numeric | 10 | |||
m_costhistory | ad_org_id | numeric | 10 | |||
m_costmovement_v | ad_org_id | numeric | 10 | √ | null | |
m_costqueue | ad_org_id | numeric | 10 | |||
m_costtype | ad_org_id | numeric | 10 | |||
m_inout | ad_org_id | numeric | 10 | |||
m_inoutline | ad_org_id | numeric | 10 | |||
m_inoutlinema | ad_org_id | numeric | 10 | |||
m_inventoryline | ad_org_id | numeric | 10 | |||
m_inventorylinema | ad_org_id | numeric | 10 | |||
m_locator | ad_org_id | numeric | 10 | |||
m_matchinv | ad_org_id | numeric | 10 | |||
m_matchpo | ad_org_id | numeric | 10 | |||
m_movementline | ad_org_id | numeric | 10 | |||
m_movementlinema | ad_org_id | numeric | 10 | |||
m_product | ad_org_id | numeric | 10 | |||
m_product_acct | ad_org_id | numeric | 10 | |||
m_product_category | ad_org_id | numeric | 10 | |||
m_product_category_acct | ad_org_id | numeric | 10 | |||
m_product_po | ad_org_id | numeric | 10 | |||
m_productionline | ad_org_id | numeric | 10 | |||
m_productionlinema | ad_org_id | numeric | 10 | |||
m_transaction | ad_org_id | numeric | 10 | |||
m_warehouse | ad_org_id | numeric | 10 | |||
m_warehouse_acct | ad_org_id | numeric | 10 | |||
s_resource | ad_org_id | numeric | 10 | |||
t_inventoryvalue | ad_org_id | numeric | 10 | √ | null | |
c_acctschema | ad_orgonly_id | numeric | 10 | √ | null | |
c_invoice | ad_orgtrx_id | numeric | 10 | √ | null | |
c_invoiceline | ad_orgtrx_id | numeric | 10 | √ | null | |
c_order | ad_orgtrx_id | numeric | 10 | √ | null | |
c_orderline | ad_orgtrx_id | numeric | 10 | √ | null | |
m_inout | ad_orgtrx_id | numeric | 10 | √ | null | |
m_inoutline | ad_orgtrx_id | numeric | 10 | √ | null | |
t_inventoryvalue | ad_pinstance_id | numeric | 10 | |||
m_product_category | ad_printcolor_id | numeric | 10 | √ | null | |
c_invoice | ad_user_id | numeric | 10 | √ | null | |
c_order | ad_user_id | numeric | 10 | √ | null | |
m_inout | ad_user_id | numeric | 10 | √ | null | |
s_resource | ad_user_id | numeric | 10 | √ | null | |
c_allocationline | allocationno | numeric | 10 | √ | null | |
c_allocationline | amount | numeric | 0 | 0 | ||
c_order | amountrefunded | numeric | 22,2 | √ | null | |
c_order | amounttendered | numeric | 22,2 | √ | null | |
c_landedcostallocation | amt | numeric | 0 | 0 | ||
c_orderlandedcost | amt | numeric | 0 | (0)::numeric | ||
c_orderlandedcostallocation | amt | numeric | 0 | |||
m_costdetail | amt | numeric | 0 | 0 | ||
m_costmovement_v | amt | numeric | 0 | √ | null | |
c_acctschema | autoperiodcontrol | bpchar | 1 | 'N'::bpchar | ||
c_landedcostallocation | base | numeric | 0 | 0 | ||
c_orderlandedcostallocation | base | numeric | 0 | |||
c_order | bill_bpartner_id | numeric | 10 | √ | null | |
c_order | bill_location_id | numeric | 10 | √ | null | |
c_order | bill_user_id | numeric | 10 | √ | null | |
c_invoiceline | c_1099box_id | numeric | 10 | √ | NULL::numeric | |
c_acctschema | c_acctschema_id | numeric | 10 | |||
m_cost | c_acctschema_id | numeric | 10 | |||
m_costdetail | c_acctschema_id | numeric | 10 | |||
m_costmovement_v | c_acctschema_id | numeric | 10 | √ | null | |
m_costqueue | c_acctschema_id | numeric | 10 | |||
m_product_acct | c_acctschema_id | numeric | 10 | |||
m_product_category_acct | c_acctschema_id | numeric | 10 | |||
m_warehouse_acct | c_acctschema_id | numeric | 10 | |||
c_acctschema | c_acctschema_uu | varchar | 36 | √ | NULL::character varying | |
c_invoice | c_activity_id | numeric | 10 | √ | null | |
c_invoiceline | c_activity_id | numeric | 10 | √ | null | |
c_order | c_activity_id | numeric | 10 | √ | null | |
c_orderline | c_activity_id | numeric | 10 | √ | null | |
m_inout | c_activity_id | numeric | 10 | √ | null | |
m_inoutline | c_activity_id | numeric | 10 | √ | null | |
c_allocationline | c_allocationhdr_id | numeric | 10 | |||
c_allocationline | c_allocationline_id | numeric | 10 | |||
c_allocationline | c_allocationline_uu | varchar | 36 | √ | NULL::character varying | |
c_allocationline | c_banktransfer_id | numeric | 10 | √ | NULL::numeric | |
c_allocationline | c_bpartner_id | numeric | 10 | √ | null | |
c_invoice | c_bpartner_id | numeric | 10 | |||
c_order | c_bpartner_id | numeric | 10 | |||
c_orderline | c_bpartner_id | numeric | 10 | √ | null | |
m_inout | c_bpartner_id | numeric | 10 | |||
m_product_po | c_bpartner_id | numeric | 10 | |||
c_invoice | c_bpartner_location_id | numeric | 10 | |||
c_order | c_bpartner_location_id | numeric | 10 | |||
c_orderline | c_bpartner_location_id | numeric | 10 | √ | null | |
m_inout | c_bpartner_location_id | numeric | 10 | |||
c_invoice | c_campaign_id | numeric | 10 | √ | null | |
c_invoiceline | c_campaign_id | numeric | 10 | √ | null | |
c_order | c_campaign_id | numeric | 10 | √ | null | |
c_orderline | c_campaign_id | numeric | 10 | √ | null | |
m_inout | c_campaign_id | numeric | 10 | √ | null | |
m_inoutline | c_campaign_id | numeric | 10 | √ | null | |
c_allocationline | c_cashline_id | numeric | 10 | √ | null | |
c_invoice | c_cashline_id | numeric | 10 | √ | null | |
c_order | c_cashline_id | numeric | 10 | √ | null | |
c_invoice | c_cashplanline_id | numeric | 10 | √ | NULL::numeric | |
c_order | c_cashplanline_id | numeric | 10 | √ | NULL::numeric | |
c_allocationline | c_charge_id | numeric | 10 | √ | NULL::numeric | |
c_invoice | c_charge_id | numeric | 10 | √ | null | |
c_invoiceline | c_charge_id | numeric | 10 | √ | null | |
c_order | c_charge_id | numeric | 10 | √ | null | |
c_orderline | c_charge_id | numeric | 10 | √ | null | |
m_inout | c_charge_id | numeric | 10 | √ | null | |
m_inoutline | c_charge_id | numeric | 10 | √ | null | |
m_inventoryline | c_charge_id | numeric | 10 | √ | null | |
c_invoice | c_conversiontype_id | numeric | 10 | √ | null | |
c_order | c_conversiontype_id | numeric | 10 | √ | null | |
c_acctschema | c_currency_id | numeric | 10 | |||
c_invoice | c_currency_id | numeric | 10 | |||
c_order | c_currency_id | numeric | 10 | |||
c_orderline | c_currency_id | numeric | 10 | |||
m_product_po | c_currency_id | numeric | 10 | √ | null | |
t_inventoryvalue | c_currency_id | numeric | 10 | √ | null | |
c_invoice | c_doctype_id | numeric | 10 | |||
c_order | c_doctype_id | numeric | 10 | |||
m_inout | c_doctype_id | numeric | 10 | |||
c_invoice | c_doctypetarget_id | numeric | 10 | |||
c_order | c_doctypetarget_id | numeric | 10 | |||
c_invoice | c_dunninglevel_id | numeric | 10 | √ | null | |
c_allocationline | c_invoice_id | numeric | 10 | √ | null | |
c_invoice | c_invoice_id | numeric | 10 | |||
c_invoiceline | c_invoice_id | numeric | 10 | |||
m_inout | c_invoice_id | numeric | 10 | √ | null | |
c_invoice | c_invoice_uu | varchar | 36 | √ | NULL::character varying | |
c_invoiceline | c_invoiceline_id | numeric | 10 | |||
c_landedcost | c_invoiceline_id | numeric | 10 | |||
c_landedcostallocation | c_invoiceline_id | numeric | 10 | |||
m_costdetail | c_invoiceline_id | numeric | 10 | √ | null | |
m_costmovement_v | c_invoiceline_id | numeric | 10 | √ | null | |
m_matchinv | c_invoiceline_id | numeric | 10 | |||
m_matchpo | c_invoiceline_id | numeric | 10 | √ | null | |
c_invoiceline | c_invoiceline_uu | varchar | 36 | √ | NULL::character varying | |
c_landedcost | c_landedcost_id | numeric | 10 | |||
c_landedcost | c_landedcost_uu | varchar | 36 | √ | NULL::character varying | |
c_landedcostallocation | c_landedcostallocation_id | numeric | 10 | |||
c_landedcostallocation | c_landedcostallocation_uu | varchar | 36 | √ | NULL::character varying | |
m_warehouse | c_location_id | numeric | 10 | |||
c_order | c_opportunity_id | numeric | 10 | √ | NULL::numeric | |
c_allocationline | c_order_id | numeric | 10 | √ | null | |
c_invoice | c_order_id | numeric | 10 | √ | null | |
c_order | c_order_id | numeric | 10 | |||
c_orderlandedcost | c_order_id | numeric | 10 | |||
c_orderline | c_order_id | numeric | 10 | |||
m_inout | c_order_id | numeric | 10 | √ | null | |
c_order | c_order_uu | varchar | 36 | √ | NULL::character varying | |
c_orderlandedcost | c_orderlandedcost_id | numeric | 10 | |||
c_orderlandedcostallocation | c_orderlandedcost_id | numeric | 10 | |||
c_orderlandedcost | c_orderlandedcost_uu | varchar | 36 | √ | NULL::character varying | |
c_orderlandedcostallocation | c_orderlandedcostallocation_id | numeric | 10 | |||
c_orderlandedcostallocation | c_orderlandedcostallocation_uu | varchar | 36 | √ | NULL::character varying | |
c_invoiceline | c_orderline_id | numeric | 10 | √ | null | |
c_orderlandedcostallocation | c_orderline_id | numeric | 10 | |||
c_orderline | c_orderline_id | numeric | 10 | |||
m_costdetail | c_orderline_id | numeric | 10 | √ | null | |
m_costmovement_v | c_orderline_id | numeric | 10 | √ | null | |
m_inoutline | c_orderline_id | numeric | 10 | √ | null | |
m_matchpo | c_orderline_id | numeric | 10 | |||
c_orderline | c_orderline_uu | varchar | 36 | √ | NULL::character varying | |
c_order | c_ordersource_id | numeric | 10 | √ | null | |
c_allocationline | c_payment_id | numeric | 10 | √ | null | |
c_invoice | c_payment_id | numeric | 10 | √ | null | |
c_order | c_payment_id | numeric | 10 | √ | null | |
c_invoice | c_paymentterm_id | numeric | 10 | |||
c_order | c_paymentterm_id | numeric | 10 | |||
c_acctschema | c_period_id | numeric | 10 | √ | null | |
c_order | c_pos_id | numeric | 10 | √ | null | |
c_invoice | c_project_id | numeric | 10 | √ | null | |
c_invoiceline | c_project_id | numeric | 10 | √ | null | |
c_order | c_project_id | numeric | 10 | √ | null | |
c_orderline | c_project_id | numeric | 10 | √ | null | |
c_projectissue | c_project_id | numeric | 10 | |||
m_inout | c_project_id | numeric | 10 | √ | null | |
m_inoutline | c_project_id | numeric | 10 | √ | null | |
c_projectissue | c_projectissue_id | numeric | 10 | |||
c_projectissuema | c_projectissue_id | numeric | 10 | |||
m_costdetail | c_projectissue_id | numeric | 10 | √ | null | |
m_costmovement_v | c_projectissue_id | numeric | 10 | √ | null | |
m_transaction | c_projectissue_id | numeric | 10 | √ | null | |
c_projectissue | c_projectissue_uu | varchar | 36 | √ | NULL::character varying | |
c_projectissuema | c_projectissuema_uu | varchar | 36 | √ | NULL::character varying | |
c_invoiceline | c_projectphase_id | numeric | 10 | √ | null | |
c_orderline | c_projectphase_id | numeric | 10 | √ | null | |
m_inoutline | c_projectphase_id | numeric | 10 | √ | null | |
c_invoiceline | c_projecttask_id | numeric | 10 | √ | null | |
c_orderline | c_projecttask_id | numeric | 10 | √ | null | |
m_inoutline | c_projecttask_id | numeric | 10 | √ | null | |
m_product | c_revenuerecognition_id | numeric | 10 | √ | null | |
m_product | c_subscriptiontype_id | numeric | 10 | √ | null | |
c_invoiceline | c_tax_id | numeric | 10 | √ | null | |
c_orderline | c_tax_id | numeric | 10 | |||
m_product | c_taxcategory_id | numeric | 10 | |||
c_invoiceline | c_uom_id | numeric | 10 | √ | null | |
c_orderline | c_uom_id | numeric | 10 | |||
m_inoutline | c_uom_id | numeric | 10 | |||
m_product | c_uom_id | numeric | 10 | |||
m_product_po | c_uom_id | numeric | 10 | √ | null | |
s_resource | chargeableqty | numeric | 0 | √ | 0 | |
c_invoice | chargeamt | numeric | 0 | √ | 0 | |
c_order | chargeamt | numeric | 0 | √ | 0 | |
m_inout | chargeamt | numeric | 0 | √ | 0 | |
m_product | classification | varchar | 12 | √ | null | |
c_acctschema | commitmenttype | bpchar | 1 | 'N'::bpchar | ||
m_inoutline | confirmedqty | numeric | 0 | √ | 0 | |
m_movementline | confirmedqty | numeric | 0 | √ | 0 | |
c_invoice | copyfrom | bpchar | 1 | √ | null | |
c_order | copyfrom | bpchar | 1 | √ | null | |
m_product | copyfrom | bpchar | 1 | √ | NULL::bpchar | |
t_inventoryvalue | cost | numeric | 0 | √ | 0 | |
t_inventoryvalue | costamt | numeric | 0 | √ | 0 | |
m_costelement | costelementtype | bpchar | 1 | |||
c_acctschema | costinglevel | bpchar | 1 | 'C'::bpchar | ||
m_product_category_acct | costinglevel | bpchar | 1 | √ | null | |
c_acctschema | costingmethod | bpchar | 1 | |||
m_costelement | costingmethod | bpchar | 1 | √ | null | |
m_product_category_acct | costingmethod | bpchar | 1 | √ | null | |
m_product_po | costperorder | numeric | 0 | √ | 0 | |
t_inventoryvalue | coststandard | numeric | 0 | √ | 0 | |
t_inventoryvalue | coststandardamt | numeric | 0 | √ | 0 | |
m_inout | createconfirm | bpchar | 1 | √ | null | |
c_acctschema | created | timestamp | 29,6 | now() | ||
c_allocationline | created | timestamp | 29,6 | now() | ||
c_invoice | created | timestamp | 29,6 | now() | ||
c_invoiceline | created | timestamp | 29,6 | now() | ||
c_landedcost | created | timestamp | 29,6 | now() | ||
c_landedcostallocation | created | timestamp | 29,6 | now() | ||
c_order | created | timestamp | 29,6 | now() | ||
c_orderlandedcost | created | timestamp | 29,6 | statement_timestamp() | ||
c_orderlandedcostallocation | created | timestamp | 29,6 | statement_timestamp() | ||
c_orderline | created | timestamp | 29,6 | now() | ||
c_projectissue | created | timestamp | 29,6 | now() | ||
c_projectissuema | created | timestamp | 29,6 | now() | ||
m_attributesetinstance | created | timestamp | 29,6 | now() | ||
m_cost | created | timestamp | 29,6 | now() | ||
m_costdetail | created | timestamp | 29,6 | now() | ||
m_costelement | created | timestamp | 29,6 | now() | ||
m_costhistory | created | timestamp | 29,6 | statement_timestamp() | ||
m_costmovement_v | created | timestamp | 29,6 | √ | null | |
m_costqueue | created | timestamp | 29,6 | now() | ||
m_costtype | created | timestamp | 29,6 | now() | ||
m_inout | created | timestamp | 29,6 | now() | ||
m_inoutline | created | timestamp | 29,6 | now() | ||
m_inoutlinema | created | timestamp | 29,6 | now() | ||
m_inventoryline | created | timestamp | 29,6 | now() | ||
m_inventorylinema | created | timestamp | 29,6 | now() | ||
m_locator | created | timestamp | 29,6 | now() | ||
m_matchinv | created | timestamp | 29,6 | now() | ||
m_matchpo | created | timestamp | 29,6 | now() | ||
m_movementline | created | timestamp | 29,6 | now() | ||
m_movementlinema | created | timestamp | 29,6 | now() | ||
m_product | created | timestamp | 29,6 | now() | ||
m_product_acct | created | timestamp | 29,6 | now() | ||
m_product_category | created | timestamp | 29,6 | now() | ||
m_product_category_acct | created | timestamp | 29,6 | now() | ||
m_product_po | created | timestamp | 29,6 | now() | ||
m_productionline | created | timestamp | 29,6 | now() | ||
m_productionlinema | created | timestamp | 29,6 | now() | ||
m_transaction | created | timestamp | 29,6 | now() | ||
m_warehouse | created | timestamp | 29,6 | now() | ||
m_warehouse_acct | created | timestamp | 29,6 | now() | ||
s_resource | created | timestamp | 29,6 | now() | ||
c_acctschema | createdby | numeric | 10 | |||
c_allocationline | createdby | numeric | 10 | |||
c_invoice | createdby | numeric | 10 | |||
c_invoiceline | createdby | numeric | 10 | |||
c_landedcost | createdby | numeric | 10 | |||
c_landedcostallocation | createdby | numeric | 10 | |||
c_order | createdby | numeric | 10 | |||
c_orderlandedcost | createdby | numeric | 10 | |||
c_orderlandedcostallocation | createdby | numeric | 10 | |||
c_orderline | createdby | numeric | 10 | |||
c_projectissue | createdby | numeric | 10 | |||
c_projectissuema | createdby | numeric | 10 | |||
m_attributesetinstance | createdby | numeric | 10 | |||
m_cost | createdby | numeric | 10 | |||
m_costdetail | createdby | numeric | 10 | |||
m_costelement | createdby | numeric | 10 | |||
m_costhistory | createdby | numeric | 10 | |||
m_costmovement_v | createdby | numeric | 10 | √ | null | |
m_costqueue | createdby | numeric | 10 | |||
m_costtype | createdby | numeric | 10 | |||
m_inout | createdby | numeric | 10 | |||
m_inoutline | createdby | numeric | 10 | |||
m_inoutlinema | createdby | numeric | 10 | |||
m_inventoryline | createdby | numeric | 10 | |||
m_inventorylinema | createdby | numeric | 10 | |||
m_locator | createdby | numeric | 10 | |||
m_matchinv | createdby | numeric | 10 | |||
m_matchpo | createdby | numeric | 10 | |||
m_movementline | createdby | numeric | 10 | |||
m_movementlinema | createdby | numeric | 10 | |||
m_product | createdby | numeric | 10 | |||
m_product_acct | createdby | numeric | 10 | |||
m_product_category | createdby | numeric | 10 | |||
m_product_category_acct | createdby | numeric | 10 | |||
m_product_po | createdby | numeric | 10 | |||
m_productionline | createdby | numeric | 10 | |||
m_productionlinema | createdby | numeric | 10 | |||
m_transaction | createdby | numeric | 10 | |||
m_warehouse | createdby | numeric | 10 | |||
m_warehouse_acct | createdby | numeric | 10 | |||
s_resource | createdby | numeric | 10 | |||
c_invoice | createfrom | bpchar | 1 | √ | null | |
m_inout | createfrom | bpchar | 1 | √ | null | |
c_invoice | createlinesfrom | bpchar | 1 | √ | NULL::bpchar | |
m_inout | createlinesfrom | bpchar | 1 | √ | NULL::bpchar | |
m_inout | createpackage | bpchar | 1 | √ | null | |
c_orderline | createproduction | bpchar | 1 | √ | 'N'::bpchar | |
c_orderline | createshipment | bpchar | 1 | √ | 'N'::bpchar | |
m_cost | cumulatedamt | numeric | 0 | √ | 0 | |
m_costdetail | cumulatedamt | numeric | 0 | √ | null | |
m_cost | cumulatedqty | numeric | 0 | √ | 0 | |
m_costdetail | cumulatedqty | numeric | 0 | √ | null | |
c_invoice | currencyrate | numeric | 0 | √ | null | |
m_cost | currentcostprice | numeric | 0 | |||
m_costdetail | currentcostprice | numeric | 0 | √ | null | |
m_costqueue | currentcostprice | numeric | 0 | 0 | ||
m_inventoryline | currentcostprice | numeric | 0 | √ | (0)::numeric | |
m_cost | currentcostpricell | numeric | 0 | √ | 0 | |
m_cost | currentqty | numeric | 0 | 0 | ||
m_costdetail | currentqty | numeric | 0 | √ | null | |
m_costqueue | currentqty | numeric | 0 | 0 | ||
m_product | customstariffnumber | varchar | 20 | √ | null | |
s_resource | dailycapacity | numeric | 0 | √ | null | |
c_invoice | dateacct | timestamp | 29,6 | |||
c_order | dateacct | timestamp | 29,6 | |||
m_inout | dateacct | timestamp | 29,6 | |||
m_matchinv | dateacct | timestamp | 29,6 | √ | null | |
m_matchpo | dateacct | timestamp | 29,6 | √ | null | |
c_orderline | datedelivered | timestamp | 29,6 | √ | null | |
c_invoice | dateinvoiced | timestamp | 29,6 | |||
c_orderline | dateinvoiced | timestamp | 29,6 | √ | null | |
m_inoutlinema | datematerialpolicy | timestamp | 29,6 | |||
m_inventorylinema | datematerialpolicy | timestamp | 29,6 | |||
m_movementlinema | datematerialpolicy | timestamp | 29,6 | |||
m_productionlinema | datematerialpolicy | timestamp | 29,6 | |||
c_invoice | dateordered | timestamp | 29,6 | √ | null | |
c_order | dateordered | timestamp | 29,6 | |||
c_orderline | dateordered | timestamp | 29,6 | |||
m_inout | dateordered | timestamp | 29,6 | √ | null | |
c_invoice | dateprinted | timestamp | 29,6 | √ | null | |
c_order | dateprinted | timestamp | 29,6 | √ | null | |
m_inout | dateprinted | timestamp | 29,6 | √ | null | |
c_order | datepromised | timestamp | 29,6 | √ | null | |
c_orderline | datepromised | timestamp | 29,6 | √ | null | |
m_inout | datereceived | timestamp | 29,6 | √ | null | |
c_allocationline | datetrx | timestamp | 29,6 | √ | null | |
m_matchinv | datetrx | timestamp | 29,6 | |||
m_matchpo | datetrx | timestamp | 29,6 | |||
t_inventoryvalue | datevalue | timestamp | 29,6 | √ | null | |
m_movementline | dd_orderline_id | numeric | 10 | √ | null | |
c_order | deliveryrule | bpchar | 1 | |||
m_inout | deliveryrule | bpchar | 1 | |||
m_product_po | deliverytime_actual | numeric | 10 | √ | null | |
m_product_po | deliverytime_promised | numeric | 10 | √ | null | |
c_order | deliveryviarule | bpchar | 1 | |||
m_inout | deliveryviarule | bpchar | 1 | |||
m_costdetail | deltaamt | numeric | 0 | √ | 0 | |
m_costmovement_v | deltaamt | numeric | 0 | √ | null | |
m_costdetail | deltaqty | numeric | 0 | √ | 0 | |
m_costmovement_v | deltaqty | numeric | 0 | √ | null | |
c_acctschema | description | varchar | 255 | √ | null | |
c_invoice | description | varchar | 255 | √ | null | |
c_invoiceline | description | varchar | 255 | √ | null | |
c_landedcost | description | varchar | 255 | √ | null | |
c_order | description | varchar | 255 | √ | null | |
c_orderlandedcost | description | varchar | 255 | √ | NULL::character varying | |
c_orderline | description | varchar | 255 | √ | null | |
c_projectissue | description | varchar | 255 | √ | null | |
m_attributesetinstance | description | varchar | 255 | √ | null | |
m_cost | description | varchar | 255 | √ | null | |
m_costdetail | description | varchar | 255 | √ | null | |
m_costelement | description | varchar | 255 | √ | null | |
m_costmovement_v | description | varchar | 255 | √ | null | |
m_costtype | description | varchar | 255 | √ | null | |
m_inout | description | varchar | 255 | √ | null | |
m_inoutline | description | varchar | 255 | √ | null | |
m_inventoryline | description | varchar | 255 | √ | null | |
m_matchinv | description | varchar | 255 | √ | null | |
m_matchpo | description | varchar | 255 | √ | null | |
m_movementline | description | varchar | 255 | √ | null | |
m_product | description | varchar | 255 | √ | null | |
m_product_category | description | varchar | 255 | √ | null | |
m_productionline | description | varchar | 255 | √ | null | |
m_warehouse | description | varchar | 255 | √ | null | |
s_resource | description | varchar | 255 | √ | null | |
m_product | descriptionurl | varchar | 120 | √ | null | |
m_product | discontinued | bpchar | 1 | √ | 'N'::bpchar | |
m_product_po | discontinued | bpchar | 1 | √ | 'N'::bpchar | |
m_product | discontinuedat | timestamp | 29,6 | √ | null | |
m_product_po | discontinuedat | timestamp | 29,6 | √ | null | |
m_product | discontinuedby | timestamp | 29,6 | √ | null | |
m_product_po | discontinuedby | timestamp | 29,6 | √ | null | |
c_orderline | discount | numeric | 0 | √ | null | |
c_allocationline | discountamt | numeric | 0 | 0 | ||
c_invoice | docaction | bpchar | 2 | |||
c_order | docaction | bpchar | 2 | |||
c_projectissue | docaction | bpchar | 2 | 'CO'::bpchar | ||
m_inout | docaction | bpchar | 2 | |||
c_invoice | docstatus | bpchar | 2 | |||
c_order | docstatus | bpchar | 2 | |||
c_projectissue | docstatus | varchar | 2 | 'DR'::character varying | ||
m_inout | docstatus | bpchar | 2 | |||
c_invoice | documentno | varchar | 30 | |||
c_order | documentno | varchar | 30 | |||
m_inout | documentno | varchar | 30 | |||
m_matchinv | documentno | varchar | 30 | √ | null | |
m_matchpo | documentno | varchar | 30 | √ | null | |
m_product | documentnote | varchar | 2000 | √ | null | |
m_product | downloadurl | varchar | 120 | √ | null | |
c_order | dropship_bpartner_id | numeric | 10 | √ | null | |
m_inout | dropship_bpartner_id | numeric | 10 | √ | null | |
c_order | dropship_location_id | numeric | 10 | √ | null | |
m_inout | dropship_location_id | numeric | 10 | √ | null | |
c_order | dropship_user_id | numeric | 10 | √ | null | |
m_inout | dropship_user_id | numeric | 10 | √ | null | |
c_invoice | dunninggrace | timestamp | 29,6 | √ | null | |
m_inout | fob | varchar | 10 | √ | NULL::character varying | |
c_order | freightamt | numeric | 0 | √ | 0 | |
c_orderline | freightamt | numeric | 0 | 0 | ||
m_inout | freightamt | numeric | 0 | √ | 0 | |
m_inout | freightcharges | varchar | 10 | √ | NULL::character varying | |
c_order | freightcostrule | bpchar | 1 | |||
m_inout | freightcostrule | bpchar | 1 | |||
m_cost | futurecostprice | numeric | 0 | √ | null | |
m_cost | futurecostpricell | numeric | 0 | √ | null | |
c_acctschema | gaap | bpchar | 2 | |||
c_invoice | generateto | bpchar | 1 | √ | null | |
m_inout | generateto | bpchar | 1 | √ | null | |
c_invoice | grandtotal | numeric | 0 | 0 | ||
c_order | grandtotal | numeric | 0 | 0 | ||
m_product | group1 | varchar | 255 | √ | null | |
m_product | group2 | varchar | 255 | √ | null | |
m_attributesetinstance | guaranteedate | timestamp | 29,6 | √ | null | |
m_product | guaranteedays | numeric | 10 | √ | null | |
m_product | guaranteedaysmin | numeric | 10 | √ | null | |
c_acctschema | hasalias | bpchar | 1 | 'Y'::bpchar | ||
c_acctschema | hascombination | bpchar | 1 | 'Y'::bpchar | ||
m_costtype | help | varchar | 2000 | √ | null | |
m_product | help | varchar | 2000 | √ | null | |
m_product | imageurl | varchar | 120 | √ | null | |
m_inout | insurance | bpchar | 1 | √ | NULL::bpchar | |
m_inventoryline | inventorytype | bpchar | 1 | 'D'::bpchar | ||
c_invoice | invoicecollectiontype | bpchar | 1 | √ | null | |
c_order | invoicerule | bpchar | 1 | |||
c_acctschema | isaccrual | bpchar | 1 | 'Y'::bpchar | ||
c_acctschema | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_allocationline | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_invoice | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_invoiceline | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_order | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_orderlandedcost | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_orderlandedcostallocation | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_orderline | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_projectissue | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_projectissuema | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_attributesetinstance | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_cost | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_costdetail | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_costelement | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_costhistory | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_costmovement_v | isactive | bpchar | 1 | √ | null | |
m_costqueue | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_costtype | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_inout | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_inoutline | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_inoutlinema | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_inventoryline | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_inventorylinema | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_locator | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_matchinv | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_matchpo | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_movementline | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_movementlinema | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_product | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_product_acct | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_product_category | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_product_category_acct | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_product_po | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_productionline | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_productionlinema | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_transaction | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_warehouse | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_warehouse_acct | isactive | bpchar | 1 | 'Y'::bpchar | ||
s_resource | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_acctschema | isadjustcogs | bpchar | 1 | 'N'::bpchar | ||
c_acctschema | isallownegativeposting | bpchar | 1 | √ | 'Y'::bpchar | |
m_inout | isalternatereturnaddress | bpchar | 1 | 'N'::bpchar | ||
c_invoice | isapproved | bpchar | 1 | 'N'::bpchar | ||
c_order | isapproved | bpchar | 1 | 'N'::bpchar | ||
c_projectissue | isapproved | bpchar | 1 | 'N'::bpchar | ||
m_inout | isapproved | bpchar | 1 | 'N'::bpchar | ||
m_matchpo | isapproved | bpchar | 1 | √ | 'Y'::bpchar | |
m_inoutlinema | isautogenerated | bpchar | 1 | √ | 'N'::bpchar | |
m_inventorylinema | isautogenerated | bpchar | 1 | √ | 'N'::bpchar | |
m_movementlinema | isautogenerated | bpchar | 1 | √ | 'N'::bpchar | |
m_inoutline | isautoproduce | bpchar | 1 | √ | 'N'::bpchar | |
m_product | isautoproduce | bpchar | 1 | 'N'::bpchar | ||
s_resource | isavailable | bpchar | 1 | 'Y'::bpchar | ||
m_product | isbom | bpchar | 1 | 'N'::bpchar | ||
m_costelement | iscalculated | bpchar | 1 | 'N'::bpchar | ||
m_cost | iscostfrozen | bpchar | 1 | √ | 'N'::bpchar | |
c_order | iscreditapproved | bpchar | 1 | 'N'::bpchar | ||
m_product_po | iscurrentvendor | bpchar | 1 | 'Y'::bpchar | ||
m_locator | isdefault | bpchar | 1 | 'N'::bpchar | ||
m_product_category | isdefault | bpchar | 1 | 'N'::bpchar | ||
c_order | isdelivered | bpchar | 1 | 'N'::bpchar | ||
c_invoiceline | isdescription | bpchar | 1 | 'N'::bpchar | ||
c_orderline | isdescription | bpchar | 1 | 'N'::bpchar | ||
m_inoutline | isdescription | bpchar | 1 | 'N'::bpchar | ||
m_warehouse | isdisallownegativeinv | bpchar | 1 | 'N'::bpchar | ||
c_acctschema | isdiscountcorrectstax | bpchar | 1 | 'N'::bpchar | ||
c_invoice | isdiscountprinted | bpchar | 1 | 'Y'::bpchar | ||
c_order | isdiscountprinted | bpchar | 1 | 'Y'::bpchar | ||
c_order | isdropship | bpchar | 1 | 'N'::bpchar | ||
m_inout | isdropship | bpchar | 1 | √ | 'N'::bpchar | |
m_product | isdropship | bpchar | 1 | 'N'::bpchar | ||
m_productionline | isendproduct | bpchar | 1 | √ | NULL::bpchar | |
m_product | isexcludeautodelivery | bpchar | 1 | 'N'::bpchar | ||
c_acctschema | isexplicitcostadjustment | bpchar | 1 | 'N'::bpchar | ||
c_invoice | isfixedassetinvoice | bpchar | 1 | √ | null | |
c_invoiceline | isfixedassetinvoice | bpchar | 1 | √ | null | |
c_invoice | isindispute | bpchar | 1 | 'N'::bpchar | ||
m_inout | isindispute | bpchar | 1 | 'N'::bpchar | ||
m_inout | isintransit | bpchar | 1 | 'N'::bpchar | ||
m_warehouse | isintransit | bpchar | 1 | √ | 'N'::bpchar | |
c_order | isinvoiced | bpchar | 1 | 'N'::bpchar | ||
m_inoutline | isinvoiced | bpchar | 1 | 'N'::bpchar | ||
m_product | isinvoiceprintdetails | bpchar | 1 | 'N'::bpchar | ||
m_product | iskanban | bpchar | 1 | 'N'::bpchar | ||
c_allocationline | ismanual | bpchar | 1 | √ | 'N'::bpchar | |
m_product | ismanufactured | bpchar | 1 | 'N'::bpchar | ||
s_resource | ismanufacturingresource | bpchar | 1 | √ | 'N'::bpchar | |
c_invoice | isoverridecurrencyrate | bpchar | 1 | 'N'::bpchar | ||
m_product | isownbox | bpchar | 1 | 'N'::bpchar | ||
c_invoice | ispaid | bpchar | 1 | 'N'::bpchar | ||
c_invoice | ispayschedulevalid | bpchar | 1 | 'N'::bpchar | ||
c_order | ispayschedulevalid | bpchar | 1 | 'N'::bpchar | ||
m_product | isphantom | bpchar | 1 | √ | 'N'::bpchar | |
m_product | ispicklistprintdetails | bpchar | 1 | 'N'::bpchar | ||
c_acctschema | ispostifclearingequal | bpchar | 1 | √ | 'Y'::bpchar | |
c_acctschema | ispostservices | bpchar | 1 | 'N'::bpchar | ||
c_invoice | isprinted | bpchar | 1 | 'N'::bpchar | ||
c_invoiceline | isprinted | bpchar | 1 | 'Y'::bpchar | ||
c_order | isprinted | bpchar | 1 | 'N'::bpchar | ||
m_inout | isprinted | bpchar | 1 | 'N'::bpchar | ||
c_order | ispriviledgedrate | bpchar | 1 | 'N'::bpchar | ||
m_product | ispurchased | bpchar | 1 | 'Y'::bpchar | ||
c_order | isselected | bpchar | 1 | 'N'::bpchar | ||
c_invoice | isselfservice | bpchar | 1 | 'N'::bpchar | ||
c_order | isselfservice | bpchar | 1 | 'N'::bpchar | ||
m_product | isselfservice | bpchar | 1 | 'Y'::bpchar | ||
m_product_category | isselfservice | bpchar | 1 | 'Y'::bpchar | ||
m_product | issold | bpchar | 1 | 'Y'::bpchar | ||
c_invoice | issotrx | bpchar | 1 | 'Y'::bpchar | ||
c_order | issotrx | bpchar | 1 | 'Y'::bpchar | ||
m_costdetail | issotrx | bpchar | 1 | 'Y'::bpchar | ||
m_inout | issotrx | bpchar | 1 | 'Y'::bpchar | ||
m_product | isstocked | bpchar | 1 | 'Y'::bpchar | ||
m_product | issummary | bpchar | 1 | 'N'::bpchar | ||
c_invoice | istaxincluded | bpchar | 1 | 'N'::bpchar | ||
c_order | istaxincluded | bpchar | 1 | 'N'::bpchar | ||
m_product | istoformule | bpchar | 1 | √ | null | |
c_acctschema | istradediscountposted | bpchar | 1 | 'N'::bpchar | ||
c_invoice | istransferred | bpchar | 1 | 'N'::bpchar | ||
c_order | istransferred | bpchar | 1 | 'N'::bpchar | ||
m_product | isverified | bpchar | 1 | 'N'::bpchar | ||
m_product | iswebstorefeatured | bpchar | 1 | 'N'::bpchar | ||
c_landedcost | landedcostdistribution | bpchar | 1 | |||
c_orderlandedcost | landedcostdistribution | bpchar | 1 | 'Q'::bpchar | ||
c_invoiceline | line | numeric | 10 | |||
c_orderline | line | numeric | 10 | |||
c_projectissue | line | numeric | 10 | |||
m_inoutline | line | numeric | 10 | |||
m_inventoryline | line | numeric | 10 | √ | null | |
m_movementline | line | numeric | 10 | √ | null | |
m_productionline | line | numeric | 10 | |||
c_invoiceline | linenetamt | numeric | 0 | 0 | ||
c_orderline | linenetamt | numeric | 0 | 0 | ||
c_invoiceline | linetotalamt | numeric | 0 | √ | 0 | |
c_order | link_order_id | numeric | 10 | √ | null | |
c_orderline | link_orderline_id | numeric | 10 | √ | null | |
m_attributesetinstance | lot | varchar | 40 | √ | null | |
m_product | lowlevel | numeric | 10 | (0)::numeric | ||
m_attributesetinstance | m_attributeset_id | numeric | 10 | √ | null | |
m_product | m_attributeset_id | numeric | 10 | √ | null | |
c_invoiceline | m_attributesetinstance_id | numeric | 10 | √ | 0 | |
c_landedcostallocation | m_attributesetinstance_id | numeric | 10 | √ | null | |
c_orderline | m_attributesetinstance_id | numeric | 10 | √ | 0 | |
c_projectissue | m_attributesetinstance_id | numeric | 10 | √ | 0 | |
c_projectissuema | m_attributesetinstance_id | numeric | 10 | |||
m_attributesetinstance | m_attributesetinstance_id | numeric | 10 | |||
m_cost | m_attributesetinstance_id | numeric | 10 | |||
m_costdetail | m_attributesetinstance_id | numeric | 10 | |||
m_costhistory | m_attributesetinstance_id | numeric | 10 | |||
m_costmovement_v | m_attributesetinstance_id | numeric | 10 | √ | null | |
m_costqueue | m_attributesetinstance_id | numeric | 10 | |||
m_inoutline | m_attributesetinstance_id | numeric | 10 | √ | 0 | |
m_inoutlinema | m_attributesetinstance_id | numeric | 10 | |||
m_inventoryline | m_attributesetinstance_id | numeric | 10 | √ | 0 | |
m_inventorylinema | m_attributesetinstance_id | numeric | 10 | |||
m_matchinv | m_attributesetinstance_id | numeric | 10 | √ | null | |
m_matchpo | m_attributesetinstance_id | numeric | 10 | √ | null | |
m_movementline | m_attributesetinstance_id | numeric | 10 | √ | null | |
m_movementlinema | m_attributesetinstance_id | numeric | 10 | |||
m_product | m_attributesetinstance_id | numeric | 10 | √ | 0 | |
m_productionline | m_attributesetinstance_id | numeric | 10 | √ | 0 | |
m_productionlinema | m_attributesetinstance_id | numeric | 10 | |||
m_transaction | m_attributesetinstance_id | numeric | 10 | 0 | ||
t_inventoryvalue | m_attributesetinstance_id | numeric | 10 | |||
m_attributesetinstance | m_attributesetinstance_uu | varchar | 36 | √ | NULL::character varying | |
m_movementline | m_attributesetinstanceto_id | numeric | 10 | √ | null | |
m_cost | m_cost_uu | varchar | 36 | √ | NULL::character varying | |
m_costdetail | m_costdetail_id | numeric | 10 | |||
m_costhistory | m_costdetail_id | numeric | 10 | |||
m_costmovement_v | m_costdetail_id | numeric | 10 | √ | null | |
m_costdetail | m_costdetail_uu | varchar | 36 | √ | NULL::character varying | |
c_landedcost | m_costelement_id | numeric | 10 | |||
c_landedcostallocation | m_costelement_id | numeric | 10 | |||
c_orderlandedcost | m_costelement_id | numeric | 10 | |||
m_cost | m_costelement_id | numeric | 10 | |||
m_costdetail | m_costelement_id | numeric | 10 | √ | null | |
m_costelement | m_costelement_id | numeric | 10 | |||
m_costhistory | m_costelement_id | numeric | 10 | |||
m_costmovement_v | m_costelement_id | numeric | 10 | √ | null | |
m_costqueue | m_costelement_id | numeric | 10 | |||
t_inventoryvalue | m_costelement_id | numeric | 10 | √ | null | |
m_costelement | m_costelement_uu | varchar | 36 | √ | NULL::character varying | |
m_costhistory | m_costhistory_id | numeric | 10 | |||
m_costmovement_v | m_costhistory_id | numeric | 10 | √ | null | |
m_costhistory | m_costhistory_uu | varchar | 36 | |||
m_costqueue | m_costqueue_id | numeric | 10 | |||
m_costqueue | m_costqueue_uu | varchar | 36 | √ | NULL::character varying | |
c_acctschema | m_costtype_id | numeric | 10 | √ | null | |
m_cost | m_costtype_id | numeric | 10 | |||
m_costhistory | m_costtype_id | numeric | 10 | |||
m_costmovement_v | m_costtype_id | numeric | 10 | √ | null | |
m_costqueue | m_costtype_id | numeric | 10 | |||
m_costtype | m_costtype_id | numeric | 10 | |||
m_costtype | m_costtype_uu | varchar | 36 | √ | NULL::character varying | |
c_order | m_freightcategory_id | numeric | 10 | √ | NULL::numeric | |
m_product | m_freightcategory_id | numeric | 10 | √ | null | |
c_landedcost | m_inout_id | numeric | 10 | √ | null | |
m_inout | m_inout_id | numeric | 10 | |||
m_inoutline | m_inout_id | numeric | 10 | |||
m_inout | m_inout_uu | varchar | 36 | √ | NULL::character varying | |
c_invoiceline | m_inoutline_id | numeric | 10 | √ | null | |
c_landedcost | m_inoutline_id | numeric | 10 | √ | null | |
c_landedcostallocation | m_inoutline_id | numeric | 10 | √ | NULL::numeric | |
c_projectissue | m_inoutline_id | numeric | 10 | √ | null | |
m_costdetail | m_inoutline_id | numeric | 10 | √ | null | |
m_costmovement_v | m_inoutline_id | numeric | 10 | √ | null | |
m_inoutline | m_inoutline_id | numeric | 10 | |||
m_inoutlinema | m_inoutline_id | numeric | 10 | |||
m_matchinv | m_inoutline_id | numeric | 10 | √ | null | |
m_matchpo | m_inoutline_id | numeric | 10 | √ | null | |
m_transaction | m_inoutline_id | numeric | 10 | √ | null | |
m_inoutline | m_inoutline_uu | varchar | 36 | √ | NULL::character varying | |
m_inoutlinema | m_inoutlinema_uu | varchar | 36 | √ | NULL::character varying | |
m_inventoryline | m_inventory_id | numeric | 10 | |||
m_costdetail | m_inventoryline_id | numeric | 10 | √ | null | |
m_costmovement_v | m_inventoryline_id | numeric | 10 | √ | null | |
m_inventoryline | m_inventoryline_id | numeric | 10 | |||
m_inventorylinema | m_inventoryline_id | numeric | 10 | |||
m_transaction | m_inventoryline_id | numeric | 10 | √ | null | |
m_inventoryline | m_inventoryline_uu | varchar | 36 | √ | NULL::character varying | |
m_inventorylinema | m_inventorylinema_uu | varchar | 36 | √ | NULL::character varying | |
c_projectissue | m_locator_id | numeric | 10 | |||
m_inoutline | m_locator_id | numeric | 10 | √ | null | |
m_inventoryline | m_locator_id | numeric | 10 | √ | null | |
m_locator | m_locator_id | numeric | 10 | |||
m_movementline | m_locator_id | numeric | 10 | |||
m_product | m_locator_id | numeric | 10 | √ | null | |
m_productionline | m_locator_id | numeric | 10 | |||
m_transaction | m_locator_id | numeric | 10 | |||
m_locator | m_locator_uu | varchar | 36 | √ | NULL::character varying | |
m_movementline | m_locatorto_id | numeric | 10 | |||
m_locator | m_locatortype_id | numeric | 10 | √ | NULL::numeric | |
m_attributesetinstance | m_lot_id | numeric | 10 | √ | null | |
m_costdetail | m_matchinv_id | numeric | 10 | √ | NULL::numeric | |
m_costmovement_v | m_matchinv_id | numeric | 10 | √ | null | |
m_matchinv | m_matchinv_id | numeric | 10 | |||
m_matchinv | m_matchinv_uu | varchar | 36 | √ | NULL::character varying | |
m_matchpo | m_matchpo_id | numeric | 10 | |||
m_matchpo | m_matchpo_uu | varchar | 36 | √ | NULL::character varying | |
m_movementline | m_movement_id | numeric | 10 | |||
m_costdetail | m_movementline_id | numeric | 10 | √ | null | |
m_costmovement_v | m_movementline_id | numeric | 10 | √ | null | |
m_movementline | m_movementline_id | numeric | 10 | |||
m_movementlinema | m_movementline_id | numeric | 10 | |||
m_transaction | m_movementline_id | numeric | 10 | √ | null | |
m_movementline | m_movementline_uu | varchar | 36 | √ | NULL::character varying | |
m_movementlinema | m_movementlinema_uu | varchar | 36 | √ | NULL::character varying | |
m_product | m_parttype_id | numeric | 10 | √ | NULL::numeric | |
c_invoice | m_pricelist_id | numeric | 10 | |||
c_order | m_pricelist_id | numeric | 10 | |||
t_inventoryvalue | m_pricelist_version_id | numeric | 10 | √ | null | |
m_product_acct | m_product_acct_uu | varchar | 36 | √ | NULL::character varying | |
m_product_category_acct | m_product_category_acct_uu | varchar | 36 | √ | NULL::character varying | |
m_product | m_product_category_id | numeric | 10 | |||
m_product_category | m_product_category_id | numeric | 10 | |||
m_product_category_acct | m_product_category_id | numeric | 10 | |||
m_product_category | m_product_category_parent_id | numeric | 10 | √ | null | |
m_product_category | m_product_category_uu | varchar | 36 | √ | NULL::character varying | |
c_invoiceline | m_product_id | numeric | 10 | √ | null | |
c_landedcost | m_product_id | numeric | 10 | √ | null | |
c_landedcostallocation | m_product_id | numeric | 10 | |||
c_orderline | m_product_id | numeric | 10 | √ | null | |
c_projectissue | m_product_id | numeric | 10 | |||
m_cost | m_product_id | numeric | 10 | |||
m_costdetail | m_product_id | numeric | 10 | |||
m_costhistory | m_product_id | numeric | 10 | √ | NULL::numeric | |
m_costmovement_v | m_product_id | numeric | 10 | √ | null | |
m_costqueue | m_product_id | numeric | 10 | |||
m_inoutline | m_product_id | numeric | 10 | √ | null | |
m_inventoryline | m_product_id | numeric | 10 | |||
m_matchinv | m_product_id | numeric | 10 | √ | null | |
m_matchpo | m_product_id | numeric | 10 | √ | null | |
m_movementline | m_product_id | numeric | 10 | |||
m_product | m_product_id | numeric | 10 | |||
m_product_acct | m_product_id | numeric | 10 | |||
m_product_po | m_product_id | numeric | 10 | |||
m_productionline | m_product_id | numeric | 10 | |||
m_transaction | m_product_id | numeric | 10 | |||
t_inventoryvalue | m_product_id | numeric | 10 | |||
m_product_po | m_product_po_uu | varchar | 36 | √ | NULL::character varying | |
m_product | m_product_uu | varchar | 36 | √ | NULL::character varying | |
m_productionline | m_production_id | numeric | 10 | √ | null | |
m_costdetail | m_productionline_id | numeric | 10 | √ | null | |
m_costmovement_v | m_productionline_id | numeric | 10 | √ | null | |
m_productionline | m_productionline_id | numeric | 10 | |||
m_productionlinema | m_productionline_id | numeric | 10 | |||
m_transaction | m_productionline_id | numeric | 10 | √ | null | |
m_productionline | m_productionline_uu | varchar | 36 | √ | NULL::character varying | |
m_productionlinema | m_productionlinema_uu | varchar | 36 | √ | NULL::character varying | |
m_productionline | m_productionplan_id | numeric | 10 | √ | null | |
c_orderline | m_promotion_id | numeric | 10 | √ | null | |
m_warehouse | m_reservelocator_id | numeric | 10 | √ | NULL::numeric | |
c_invoice | m_rma_id | numeric | 10 | √ | null | |
m_inout | m_rma_id | numeric | 10 | √ | null | |
c_invoiceline | m_rmaline_id | numeric | 10 | √ | null | |
m_inoutline | m_rmaline_id | numeric | 10 | √ | null | |
c_order | m_shipper_id | numeric | 10 | √ | null | |
c_orderline | m_shipper_id | numeric | 10 | √ | null | |
m_inout | m_shipper_id | numeric | 10 | √ | null | |
m_transaction | m_transaction_id | numeric | 10 | |||
m_transaction | m_transaction_uu | varchar | 36 | √ | NULL::character varying | |
m_warehouse_acct | m_warehouse_acct_uu | varchar | 36 | √ | NULL::character varying | |
c_order | m_warehouse_id | numeric | 10 | |||
c_orderline | m_warehouse_id | numeric | 10 | |||
m_inout | m_warehouse_id | numeric | 10 | |||
m_locator | m_warehouse_id | numeric | 10 | |||
m_warehouse | m_warehouse_id | numeric | 10 | |||
m_warehouse_acct | m_warehouse_id | numeric | 10 | |||
s_resource | m_warehouse_id | numeric | 10 | |||
t_inventoryvalue | m_warehouse_id | numeric | 10 | |||
m_warehouse | m_warehouse_uu | varchar | 36 | √ | NULL::character varying | |
m_warehouse | m_warehousesource_id | numeric | 10 | √ | null | |
m_product_po | manufacturer | varchar | 30 | √ | null | |
s_resource | manufacturingresourcetype | bpchar | 2 | √ | null | |
m_product_category | mmpolicy | bpchar | 1 | 'F'::bpchar | ||
c_projectissue | movementdate | timestamp | 29,6 | |||
m_inout | movementdate | timestamp | 29,6 | |||
m_transaction | movementdate | timestamp | 29,6 | |||
c_projectissue | movementqty | numeric | 0 | 0 | ||
c_projectissuema | movementqty | numeric | 0 | 0 | ||
m_inoutline | movementqty | numeric | 0 | 0 | ||
m_inoutlinema | movementqty | numeric | 0 | (1)::numeric | ||
m_inventorylinema | movementqty | numeric | 0 | (1)::numeric | ||
m_movementline | movementqty | numeric | 0 | 0 | ||
m_movementlinema | movementqty | numeric | 0 | √ | (1)::numeric | |
m_productionline | movementqty | numeric | 0 | 0 | ||
m_productionlinema | movementqty | numeric | 0 | 0 | ||
m_transaction | movementqty | numeric | 0 | 0 | ||
m_inout | movementtype | bpchar | 2 | |||
m_transaction | movementtype | bpchar | 2 | |||
c_acctschema | name | varchar | 60 | |||
m_costelement | name | varchar | 60 | |||
m_costtype | name | varchar | 60 | |||
m_product | name | varchar | 255 | |||
m_product_category | name | varchar | 60 | |||
m_warehouse | name | varchar | 60 | |||
s_resource | name | varchar | 60 | |||
m_costhistory | newcamt | numeric | 0 | √ | null | |
m_costmovement_v | newcamt | numeric | 0 | √ | null | |
m_costhistory | newcostprice | numeric | 0 | |||
m_costmovement_v | newcostprice | numeric | 0 | √ | null | |
m_inventoryline | newcostprice | numeric | 0 | √ | (0)::numeric | |
m_costhistory | newcqty | numeric | 0 | √ | null | |
m_costmovement_v | newcqty | numeric | 0 | √ | null | |
m_costhistory | newqty | numeric | 0 | |||
m_costmovement_v | newqty | numeric | 0 | √ | null | |
m_inout | nopackages | numeric | 10 | √ | (1)::numeric | |
m_costhistory | oldcamt | numeric | 0 | √ | null | |
m_costmovement_v | oldcamt | numeric | 0 | √ | null | |
m_costhistory | oldcostprice | numeric | 0 | |||
m_costmovement_v | oldcostprice | numeric | 0 | √ | null | |
m_costhistory | oldcqty | numeric | 0 | √ | null | |
m_costmovement_v | oldcqty | numeric | 0 | √ | null | |
m_costhistory | oldqty | numeric | 0 | |||
m_costmovement_v | oldqty | numeric | 0 | √ | null | |
m_product_po | order_min | numeric | 0 | √ | 0 | |
m_product_po | order_pack | numeric | 0 | √ | 0 | |
c_order | ordertype | varchar | 510 | √ | null | |
c_allocationline | overunderamt | numeric | 0 | √ | 0 | |
m_product_acct | p_asset_acct | numeric | 10 | |||
m_product_category_acct | p_asset_acct | numeric | 10 | |||
m_product_acct | p_averagecostvariance_acct | numeric | 10 | √ | NULL::numeric | |
m_product_category_acct | p_averagecostvariance_acct | numeric | 10 | √ | NULL::numeric | |
m_product_acct | p_burden_acct | numeric | 10 | √ | null | |
m_product_category_acct | p_burden_acct | numeric | 10 | √ | null | |
m_product_acct | p_cogs_acct | numeric | 10 | |||
m_product_category_acct | p_cogs_acct | numeric | 10 | |||
m_product_acct | p_costadjustment_acct | numeric | 10 | √ | null | |
m_product_category_acct | p_costadjustment_acct | numeric | 10 | √ | null | |
m_product_acct | p_costofproduction_acct | numeric | 10 | √ | null | |
m_product_category_acct | p_costofproduction_acct | numeric | 10 | √ | null | |
m_product_acct | p_expense_acct | numeric | 10 | |||
m_product_category_acct | p_expense_acct | numeric | 10 | |||
m_product_acct | p_floorstock_acct | numeric | 10 | √ | null | |
m_product_category_acct | p_floorstock_acct | numeric | 10 | √ | null | |
m_product_acct | p_inventoryclearing_acct | numeric | 10 | √ | null | |
m_product_category_acct | p_inventoryclearing_acct | numeric | 10 | √ | null | |
m_product_acct | p_invoicepricevariance_acct | numeric | 10 | |||
m_product_category_acct | p_invoicepricevariance_acct | numeric | 10 | |||
m_product_acct | p_labor_acct | numeric | 10 | √ | null | |
m_product_category_acct | p_labor_acct | numeric | 10 | √ | null | |
m_product_acct | p_landedcostclearing_acct | numeric | 10 | √ | NULL::numeric | |
m_product_category_acct | p_landedcostclearing_acct | numeric | 10 | √ | NULL::numeric | |
m_product_acct | p_methodchangevariance_acct | numeric | 10 | √ | null | |
m_product_category_acct | p_methodchangevariance_acct | numeric | 10 | √ | null | |
m_product_acct | p_mixvariance_acct | numeric | 10 | √ | null | |
m_product_category_acct | p_mixvariance_acct | numeric | 10 | √ | null | |
m_product_acct | p_outsideprocessing_acct | numeric | 10 | √ | null | |
m_product_category_acct | p_outsideprocessing_acct | numeric | 10 | √ | null | |
m_product_acct | p_overhead_acct | numeric | 10 | √ | null | |
m_product_category_acct | p_overhead_acct | numeric | 10 | √ | null | |
m_product_acct | p_purchasepricevariance_acct | numeric | 10 | |||
m_product_category_acct | p_purchasepricevariance_acct | numeric | 10 | |||
m_product_acct | p_ratevariance_acct | numeric | 10 | √ | null | |
m_product_category_acct | p_ratevariance_acct | numeric | 10 | √ | null | |
m_product_acct | p_revenue_acct | numeric | 10 | |||
m_product_category_acct | p_revenue_acct | numeric | 10 | |||
m_product_acct | p_scrap_acct | numeric | 10 | √ | null | |
m_product_category_acct | p_scrap_acct | numeric | 10 | √ | null | |
m_product_acct | p_tradediscountgrant_acct | numeric | 10 | |||
m_product_category_acct | p_tradediscountgrant_acct | numeric | 10 | |||
m_product_acct | p_tradediscountrec_acct | numeric | 10 | |||
m_product_category_acct | p_tradediscountrec_acct | numeric | 10 | |||
m_product_acct | p_usagevariance_acct | numeric | 10 | √ | null | |
m_product_category_acct | p_usagevariance_acct | numeric | 10 | √ | null | |
m_product_acct | p_wip_acct | numeric | 10 | √ | null | |
m_product_category_acct | p_wip_acct | numeric | 10 | √ | null | |
c_order | pay_bpartner_id | numeric | 10 | √ | null | |
c_order | pay_location_id | numeric | 10 | √ | null | |
c_invoice | paymentrule | bpchar | 1 | |||
c_order | paymentrule | bpchar | 1 | |||
m_cost | percent | numeric | 10 | √ | 0 | |
s_resource | percentutilization | numeric | 0 | (100)::numeric | ||
c_acctschema | period_openfuture | numeric | 10 | √ | null | |
c_acctschema | period_openhistory | numeric | 10 | √ | null | |
m_inout | pickdate | timestamp | 29,6 | √ | null | |
m_inoutline | pickedqty | numeric | 0 | √ | 0 | |
m_product_category | plannedmargin | numeric | 0 | |||
m_productionline | plannedqty | numeric | 0 | √ | null | |
s_resource | planninghorizon | numeric | 10 | √ | (0)::numeric | |
c_invoice | poreference | varchar | 20 | √ | null | |
c_order | poreference | varchar | 20 | √ | null | |
m_inout | poreference | varchar | 20 | √ | null | |
c_invoice | posted | bpchar | 1 | 'N'::bpchar | ||
c_order | posted | bpchar | 1 | 'N'::bpchar | ||
c_projectissue | posted | bpchar | 1 | 'N'::bpchar | ||
m_inout | posted | bpchar | 1 | 'N'::bpchar | ||
m_matchinv | posted | bpchar | 1 | 'N'::bpchar | ||
m_matchpo | posted | bpchar | 1 | 'N'::bpchar | ||
c_orderline | pp_cost_collector_id | numeric | 10 | √ | null | |
m_costdetail | pp_cost_collector_id | numeric | 10 | √ | null | |
m_transaction | pp_cost_collector_id | numeric | 10 | √ | null | |
c_invoiceline | priceactual | numeric | 0 | 0 | ||
c_orderline | priceactual | numeric | 0 | 0 | ||
c_orderline | pricecost | numeric | 0 | √ | null | |
m_product_po | priceeffective | timestamp | 29,6 | √ | null | |
c_invoiceline | priceentered | numeric | 0 | |||
c_orderline | priceentered | numeric | 0 | |||
m_product_po | pricelastinv | numeric | 0 | √ | 0 | |
m_product_po | pricelastpo | numeric | 0 | √ | 0 | |
c_invoiceline | pricelimit | numeric | 0 | 0 | ||
c_orderline | pricelimit | numeric | 0 | 0 | ||
t_inventoryvalue | pricelimit | numeric | 0 | √ | 0 | |
t_inventoryvalue | pricelimitamt | numeric | 0 | √ | 0 | |
c_invoiceline | pricelist | numeric | 0 | 0 | ||
c_orderline | pricelist | numeric | 0 | 0 | ||
m_product_po | pricelist | numeric | 0 | √ | 0 | |
t_inventoryvalue | pricelist | numeric | 0 | √ | 0 | |
t_inventoryvalue | pricelistamt | numeric | 0 | √ | 0 | |
m_matchpo | pricematchdifference | numeric | 0 | √ | null | |
m_product_po | pricepo | numeric | 0 | √ | 0 | |
t_inventoryvalue | pricepo | numeric | 0 | √ | 0 | |
t_inventoryvalue | pricepoamt | numeric | 0 | √ | 0 | |
t_inventoryvalue | pricestd | numeric | 0 | √ | 0 | |
t_inventoryvalue | pricestdamt | numeric | 0 | √ | 0 | |
m_locator | priorityno | numeric | 10 | |||
c_order | priorityrule | bpchar | 1 | |||
m_inout | priorityrule | bpchar | 1 | |||
c_invoice | processed | bpchar | 1 | 'N'::bpchar | ||
c_invoiceline | processed | bpchar | 1 | 'N'::bpchar | ||
c_order | processed | bpchar | 1 | 'N'::bpchar | ||
c_orderlandedcost | processed | bpchar | 1 | 'N'::bpchar | ||
c_orderlandedcostallocation | processed | bpchar | 1 | 'N'::bpchar | ||
c_orderline | processed | bpchar | 1 | 'N'::bpchar | ||
c_projectissue | processed | bpchar | 1 | 'N'::bpchar | ||
m_costdetail | processed | bpchar | 1 | 'N'::bpchar | ||
m_inout | processed | bpchar | 1 | 'N'::bpchar | ||
m_inoutline | processed | bpchar | 1 | 'N'::bpchar | ||
m_inventoryline | processed | bpchar | 1 | 'N'::bpchar | ||
m_matchinv | processed | bpchar | 1 | 'N'::bpchar | ||
m_matchpo | processed | bpchar | 1 | 'N'::bpchar | ||
m_movementline | processed | bpchar | 1 | 'N'::bpchar | ||
m_productionline | processed | bpchar | 1 | 'N'::bpchar | ||
c_invoice | processedon | numeric | 0 | √ | null | |
c_order | processedon | numeric | 0 | √ | null | |
c_projectissue | processedon | numeric | 0 | √ | null | |
m_inout | processedon | numeric | 0 | √ | null | |
m_matchinv | processedon | numeric | 0 | √ | null | |
m_matchpo | processedon | numeric | 0 | √ | null | |
c_acctschema | processing | bpchar | 1 | √ | null | |
c_invoice | processing | bpchar | 1 | √ | null | |
c_landedcost | processing | bpchar | 1 | √ | null | |
c_order | processing | bpchar | 1 | √ | null | |
c_projectissue | processing | bpchar | 1 | √ | null | |
m_inout | processing | bpchar | 1 | √ | null | |
m_matchinv | processing | bpchar | 1 | |||
m_matchpo | processing | bpchar | 1 | |||
m_product | processing | bpchar | 1 | √ | null | |
m_product_category_acct | processing | bpchar | 1 | √ | null | |
m_product | producttype | bpchar | 1 | 'I'::bpchar | ||
c_order | promotioncode | varchar | 30 | √ | null | |
c_landedcostallocation | qty | numeric | 0 | 0 | ||
c_orderlandedcostallocation | qty | numeric | 0 | |||
m_costdetail | qty | numeric | 0 | 0 | ||
m_costmovement_v | qty | numeric | 0 | √ | null | |
m_matchinv | qty | numeric | 0 | 0 | ||
m_matchpo | qty | numeric | 0 | 0 | ||
m_inventoryline | qtybook | numeric | 0 | 0 | ||
m_inventoryline | qtycount | numeric | 0 | 0 | ||
m_inventoryline | qtycsv | numeric | 0 | 0 | ||
c_orderline | qtydelivered | numeric | 0 | 0 | ||
c_invoiceline | qtyentered | numeric | 0 | |||
c_orderline | qtyentered | numeric | 0 | |||
m_inoutline | qtyentered | numeric | 0 | |||
m_inventoryline | qtyinternaluse | numeric | 0 | √ | null | |
c_invoiceline | qtyinvoiced | numeric | 0 | 0 | ||
c_orderline | qtyinvoiced | numeric | 0 | 0 | ||
c_orderline | qtylostsales | numeric | 0 | 0 | ||
t_inventoryvalue | qtyonhand | numeric | 0 | √ | 0 | |
c_orderline | qtyordered | numeric | 0 | 0 | ||
m_inoutline | qtyoverreceipt | numeric | 0 | √ | 0 | |
c_orderline | qtyreserved | numeric | 0 | 0 | ||
m_productionline | qtyused | numeric | 0 | √ | null | |
m_product_po | qualityrating | numeric | 0 | √ | null | |
s_resource | queuingtime | numeric | 0 | √ | null | |
c_order | quotationorder_id | numeric | 10 | √ | NULL::numeric | |
m_product | r_mailtext_id | numeric | 10 | √ | null | |
m_inout | ref_inout_id | numeric | 10 | √ | null | |
m_inoutline | ref_inoutline_id | numeric | 10 | √ | null | |
c_invoice | ref_invoice_id | numeric | 10 | √ | null | |
c_invoiceline | ref_invoiceline_id | numeric | 10 | √ | null | |
m_matchinv | ref_matchinv_id | numeric | 10 | √ | NULL::numeric | |
m_matchpo | ref_matchpo_id | numeric | 10 | √ | NULL::numeric | |
c_order | ref_order_id | numeric | 10 | √ | null | |
c_orderline | ref_orderline_id | numeric | 10 | √ | null | |
c_invoice | relatedinvoice_id | numeric | 10 | √ | NULL::numeric | |
m_warehouse | replenishmentclass | varchar | 60 | √ | null | |
m_inout | returnbpartner_id | numeric | 10 | √ | NULL::numeric | |
m_inout | returnlocation_id | numeric | 10 | √ | NULL::numeric | |
m_inout | returnuser_id | numeric | 10 | √ | NULL::numeric | |
c_invoice | reversal_id | numeric | 10 | √ | null | |
c_projectissue | reversal_id | numeric | 10 | √ | null | |
m_inout | reversal_id | numeric | 10 | √ | null | |
m_matchinv | reversal_id | numeric | 10 | √ | NULL::numeric | |
m_matchpo | reversal_id | numeric | 10 | √ | NULL::numeric | |
m_inoutline | reversalline_id | numeric | 10 | √ | null | |
m_inventoryline | reversalline_id | numeric | 10 | √ | null | |
m_movementline | reversalline_id | numeric | 10 | √ | null | |
m_product_po | royaltyamt | numeric | 0 | √ | 0 | |
c_invoiceline | rramt | numeric | 0 | √ | null | |
c_orderline | rramt | numeric | 0 | √ | null | |
c_invoiceline | rrstartdate | timestamp | 29,6 | √ | null | |
c_orderline | rrstartdate | timestamp | 29,6 | √ | null | |
m_product | s_expensetype_id | numeric | 10 | √ | null | |
m_product | s_resource_id | numeric | 10 | √ | null | |
s_resource | s_resource_id | numeric | 10 | |||
s_resource | s_resource_uu | varchar | 36 | √ | NULL::character varying | |
c_invoiceline | s_resourceassignment_id | numeric | 10 | √ | null | |
c_orderline | s_resourceassignment_id | numeric | 10 | √ | null | |
s_resource | s_resourcetype_id | numeric | 10 | |||
c_projectissue | s_timeexpenseline_id | numeric | 10 | √ | null | |
c_invoice | salesrep_id | numeric | 10 | √ | null | |
c_order | salesrep_id | numeric | 10 | √ | null | |
m_inout | salesrep_id | numeric | 10 | √ | null | |
m_product | salesrep_id | numeric | 10 | √ | null | |
m_inoutline | scrappedqty | numeric | 0 | √ | 0 | |
m_movementline | scrappedqty | numeric | 0 | √ | 0 | |
c_invoice | sendemail | bpchar | 1 | 'N'::bpchar | ||
c_order | sendemail | bpchar | 1 | 'N'::bpchar | ||
m_inout | sendemail | bpchar | 1 | 'N'::bpchar | ||
c_acctschema | separator | bpchar | 1 | |||
m_warehouse | separator | bpchar | 1 | |||
m_attributesetinstance | serno | varchar | 40 | √ | null | |
m_product | shelfdepth | numeric | 10 | √ | null | |
m_product | shelfheight | numeric | 0 | √ | null | |
m_product | shelfwidth | numeric | 10 | √ | null | |
m_inout | shipdate | timestamp | 29,6 | √ | null | |
m_inout | shipperaccount | varchar | 40 | √ | NULL::character varying | |
c_order | shippingrateinquiry | bpchar | 1 | √ | NULL::bpchar | |
m_product | sku | varchar | 30 | √ | null | |
t_inventoryvalue | t_inventoryvalue_uu | varchar | 36 | √ | NULL::character varying | |
m_inoutline | targetqty | numeric | 0 | √ | 0 | |
m_movementline | targetqty | numeric | 0 | √ | 0 | |
c_invoiceline | taxamt | numeric | 0 | √ | 0 | |
c_acctschema | taxcorrectiontype | bpchar | 1 | √ | null | |
c_invoice | totallines | numeric | 0 | 0 | ||
c_order | totallines | numeric | 0 | 0 | ||
m_inout | trackingno | varchar | 60 | √ | null | |
m_product | unitsperpack | numeric | 10 | 1 | ||
m_product | unitsperpallet | numeric | 0 | √ | null | |
m_product | upc | varchar | 30 | √ | null | |
m_product_po | upc | varchar | 20 | √ | null | |
c_acctschema | updated | timestamp | 29,6 | now() | ||
c_allocationline | updated | timestamp | 29,6 | now() | ||
c_invoice | updated | timestamp | 29,6 | now() | ||
c_invoiceline | updated | timestamp | 29,6 | now() | ||
c_landedcost | updated | timestamp | 29,6 | now() | ||
c_landedcostallocation | updated | timestamp | 29,6 | now() | ||
c_order | updated | timestamp | 29,6 | now() | ||
c_orderlandedcost | updated | timestamp | 29,6 | statement_timestamp() | ||
c_orderlandedcostallocation | updated | timestamp | 29,6 | statement_timestamp() | ||
c_orderline | updated | timestamp | 29,6 | now() | ||
c_projectissue | updated | timestamp | 29,6 | now() | ||
c_projectissuema | updated | timestamp | 29,6 | now() | ||
m_attributesetinstance | updated | timestamp | 29,6 | now() | ||
m_cost | updated | timestamp | 29,6 | now() | ||
m_costdetail | updated | timestamp | 29,6 | now() | ||
m_costelement | updated | timestamp | 29,6 | now() | ||
m_costhistory | updated | timestamp | 29,6 | statement_timestamp() | ||
m_costmovement_v | updated | timestamp | 29,6 | √ | null | |
m_costqueue | updated | timestamp | 29,6 | now() | ||
m_costtype | updated | timestamp | 29,6 | now() | ||
m_inout | updated | timestamp | 29,6 | now() | ||
m_inoutline | updated | timestamp | 29,6 | now() | ||
m_inoutlinema | updated | timestamp | 29,6 | now() | ||
m_inventoryline | updated | timestamp | 29,6 | now() | ||
m_inventorylinema | updated | timestamp | 29,6 | now() | ||
m_locator | updated | timestamp | 29,6 | now() | ||
m_matchinv | updated | timestamp | 29,6 | now() | ||
m_matchpo | updated | timestamp | 29,6 | now() | ||
m_movementline | updated | timestamp | 29,6 | now() | ||
m_movementlinema | updated | timestamp | 29,6 | now() | ||
m_product | updated | timestamp | 29,6 | now() | ||
m_product_acct | updated | timestamp | 29,6 | now() | ||
m_product_category | updated | timestamp | 29,6 | now() | ||
m_product_category_acct | updated | timestamp | 29,6 | now() | ||
m_product_po | updated | timestamp | 29,6 | now() | ||
m_productionline | updated | timestamp | 29,6 | now() | ||
m_productionlinema | updated | timestamp | 29,6 | now() | ||
m_transaction | updated | timestamp | 29,6 | now() | ||
m_warehouse | updated | timestamp | 29,6 | now() | ||
m_warehouse_acct | updated | timestamp | 29,6 | now() | ||
s_resource | updated | timestamp | 29,6 | now() | ||
c_acctschema | updatedby | numeric | 10 | |||
c_allocationline | updatedby | numeric | 10 | |||
c_invoice | updatedby | numeric | 10 | |||
c_invoiceline | updatedby | numeric | 10 | |||
c_landedcost | updatedby | numeric | 10 | |||
c_landedcostallocation | updatedby | numeric | 10 | |||
c_order | updatedby | numeric | 10 | |||
c_orderlandedcost | updatedby | numeric | 10 | |||
c_orderlandedcostallocation | updatedby | numeric | 10 | |||
c_orderline | updatedby | numeric | 10 | |||
c_projectissue | updatedby | numeric | 10 | |||
c_projectissuema | updatedby | numeric | 10 | |||
m_attributesetinstance | updatedby | numeric | 10 | |||
m_cost | updatedby | numeric | 10 | |||
m_costdetail | updatedby | numeric | 10 | |||
m_costelement | updatedby | numeric | 10 | |||
m_costhistory | updatedby | numeric | 10 | |||
m_costmovement_v | updatedby | numeric | 10 | √ | null | |
m_costqueue | updatedby | numeric | 10 | |||
m_costtype | updatedby | numeric | 10 | |||
m_inout | updatedby | numeric | 10 | |||
m_inoutline | updatedby | numeric | 10 | |||
m_inoutlinema | updatedby | numeric | 10 | |||
m_inventoryline | updatedby | numeric | 10 | |||
m_inventorylinema | updatedby | numeric | 10 | |||
m_locator | updatedby | numeric | 10 | |||
m_matchinv | updatedby | numeric | 10 | |||
m_matchpo | updatedby | numeric | 10 | |||
m_movementline | updatedby | numeric | 10 | |||
m_movementlinema | updatedby | numeric | 10 | |||
m_product | updatedby | numeric | 10 | |||
m_product_acct | updatedby | numeric | 10 | |||
m_product_category | updatedby | numeric | 10 | |||
m_product_category_acct | updatedby | numeric | 10 | |||
m_product_po | updatedby | numeric | 10 | |||
m_productionline | updatedby | numeric | 10 | |||
m_productionlinema | updatedby | numeric | 10 | |||
m_transaction | updatedby | numeric | 10 | |||
m_warehouse | updatedby | numeric | 10 | |||
m_warehouse_acct | updatedby | numeric | 10 | |||
s_resource | updatedby | numeric | 10 | |||
c_invoice | user1_id | numeric | 10 | √ | null | |
c_invoiceline | user1_id | numeric | 10 | √ | null | |
c_order | user1_id | numeric | 10 | √ | null | |
c_orderline | user1_id | numeric | 10 | √ | null | |
m_inout | user1_id | numeric | 10 | √ | null | |
m_inoutline | user1_id | numeric | 10 | √ | null | |
c_invoice | user2_id | numeric | 10 | √ | null | |
c_invoiceline | user2_id | numeric | 10 | √ | null | |
c_order | user2_id | numeric | 10 | √ | null | |
c_orderline | user2_id | numeric | 10 | √ | null | |
m_inout | user2_id | numeric | 10 | √ | null | |
m_inoutline | user2_id | numeric | 10 | √ | null | |
m_locator | value | varchar | 40 | |||
m_product | value | varchar | 510 | |||
m_product_category | value | varchar | 40 | |||
m_warehouse | value | varchar | 40 | |||
s_resource | value | varchar | 40 | |||
m_product_po | vendorcategory | varchar | 30 | √ | null | |
m_product_po | vendorproductno | varchar | 40 | |||
m_product | versionno | varchar | 20 | √ | null | |
c_order | volume | numeric | 0 | √ | null | |
m_inout | volume | numeric | 0 | √ | null | |
m_product | volume | numeric | 0 | √ | 0 | |
m_warehouse_acct | w_differences_acct | numeric | 10 | |||
m_warehouse_acct | w_invactualadjust_acct | numeric | 10 | √ | null | |
m_warehouse_acct | w_inventory_acct | numeric | 10 | √ | null | |
m_warehouse_acct | w_revaluation_acct | numeric | 10 | √ | null | |
s_resource | waitingtime | numeric | 0 | √ | null | |
c_order | weight | numeric | 0 | √ | null | |
m_inout | weight | numeric | 0 | √ | null | |
m_product | weight | numeric | 0 | √ | 0 | |
c_allocationline | writeoffamt | numeric | 0 | 0 | ||
m_locator | x | varchar | 60 | √ | null | |
m_locator | y | varchar | 60 | √ | null | |
m_locator | z | varchar | 60 | √ | null |