SchemaSpy Analysis of idempiere9.adempiere - ColumnsProject | Generated by Quality Systems & Solutions |
Generated on 2021-12-25 14:54 +0100 |
| |||||
|
idempiere9.adempiere contains 1000 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default |
---|---|---|---|---|---|---|
c_project | projinvoicerule | bpchar | 1 | '-'::bpchar | ||
c_paymentterm | paymenttermusage | bpchar | 1 | 'B'::bpchar | ||
c_projectissue | docaction | bpchar | 2 | 'CO'::bpchar | ||
c_projectissue | docstatus | varchar | 2 | 'DR'::character varying | ||
m_product | producttype | bpchar | 1 | 'I'::bpchar | ||
a_asset | a_asset_action | varchar | 2 | 'MD'::character varying | ||
a_asset | a_assettype | varchar | 3 | 'MFX'::character varying | ||
c_invoiceline | a_createasset | bpchar | 1 | √ | 'N'::bpchar | |
c_invoiceline | a_processed | bpchar | 1 | √ | 'N'::bpchar | |
c_orderline | createproduction | bpchar | 1 | √ | 'N'::bpchar | |
c_orderline | createshipment | bpchar | 1 | √ | 'N'::bpchar | |
m_product | discontinued | bpchar | 1 | √ | 'N'::bpchar | |
m_inoutline | isautoproduce | bpchar | 1 | √ | 'N'::bpchar | |
c_paymentterm | isdefault | bpchar | 1 | √ | 'N'::bpchar | |
m_inout | isdropship | bpchar | 1 | √ | 'N'::bpchar | |
m_warehouse | isintransit | bpchar | 1 | √ | 'N'::bpchar | |
c_bpartner | ismanufacturer | bpchar | 1 | √ | 'N'::bpchar | |
s_resource | ismanufacturingresource | bpchar | 1 | √ | 'N'::bpchar | |
m_product | isphantom | bpchar | 1 | √ | 'N'::bpchar | |
c_bpartner | istaxexempt | bpchar | 1 | √ | 'N'::bpchar | |
a_asset | processing | bpchar | 1 | √ | 'N'::bpchar | |
c_project | projectcategory | bpchar | 1 | √ | 'N'::bpchar | |
c_paymentterm | afterdelivery | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | is1099vendor | bpchar | 1 | 'N'::bpchar | ||
m_inout | isalternatereturnaddress | bpchar | 1 | 'N'::bpchar | ||
c_projectissue | isapproved | bpchar | 1 | 'N'::bpchar | ||
m_inout | isapproved | bpchar | 1 | 'N'::bpchar | ||
m_product | isautoproduce | bpchar | 1 | 'N'::bpchar | ||
m_product | isbom | bpchar | 1 | 'N'::bpchar | ||
c_project | iscommitceiling | bpchar | 1 | 'N'::bpchar | ||
c_projectphase | iscommitceiling | bpchar | 1 | 'N'::bpchar | ||
c_projectphase | iscomplete | bpchar | 1 | 'N'::bpchar | ||
c_order | iscreditapproved | 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 | ||
a_asset | isdisposed | bpchar | 1 | 'N'::bpchar | ||
c_order | isdropship | bpchar | 1 | 'N'::bpchar | ||
m_product | isdropship | bpchar | 1 | 'N'::bpchar | ||
c_paymentterm | isduefixed | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | isemployee | bpchar | 1 | 'N'::bpchar | ||
m_product | isexcludeautodelivery | bpchar | 1 | 'N'::bpchar | ||
a_asset | isfullydepreciated | bpchar | 1 | 'N'::bpchar | ||
c_invoice | isindispute | bpchar | 1 | 'N'::bpchar | ||
m_inout | isindispute | bpchar | 1 | 'N'::bpchar | ||
m_inout | isintransit | bpchar | 1 | 'N'::bpchar | ||
c_order | isinvoiced | bpchar | 1 | 'N'::bpchar | ||
m_inoutline | isinvoiced | bpchar | 1 | 'N'::bpchar | ||
s_timeexpenseline | isinvoiced | bpchar | 1 | 'N'::bpchar | ||
m_product | isinvoiceprintdetails | bpchar | 1 | 'N'::bpchar | ||
m_product | iskanban | bpchar | 1 | 'N'::bpchar | ||
m_product | ismanufactured | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | isonetime | 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 | ispicklistprintdetails | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | ispotaxexempt | bpchar | 1 | 'N'::bpchar | ||
c_invoice | isprinted | bpchar | 1 | 'N'::bpchar | ||
c_order | isprinted | bpchar | 1 | 'N'::bpchar | ||
m_inout | isprinted | bpchar | 1 | 'N'::bpchar | ||
c_order | ispriviledgedrate | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | isprospect | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | issalesrep | bpchar | 1 | 'N'::bpchar | ||
c_order | isselected | bpchar | 1 | 'N'::bpchar | ||
c_invoice | isselfservice | bpchar | 1 | 'N'::bpchar | ||
c_order | isselfservice | bpchar | 1 | 'N'::bpchar | ||
c_activity | issummary | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | issummary | bpchar | 1 | 'N'::bpchar | ||
c_project | issummary | bpchar | 1 | 'N'::bpchar | ||
m_product | issummary | bpchar | 1 | 'N'::bpchar | ||
c_invoice | istaxincluded | bpchar | 1 | 'N'::bpchar | ||
c_order | istaxincluded | bpchar | 1 | 'N'::bpchar | ||
s_timeexpenseline | istimereport | bpchar | 1 | 'N'::bpchar | ||
c_invoice | istransferred | bpchar | 1 | 'N'::bpchar | ||
c_order | istransferred | bpchar | 1 | 'N'::bpchar | ||
c_paymentterm | isvalid | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | isvendor | bpchar | 1 | 'N'::bpchar | ||
m_product | isverified | bpchar | 1 | 'N'::bpchar | ||
m_product | iswebstorefeatured | bpchar | 1 | 'N'::bpchar | ||
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 | ||
a_asset | processed | bpchar | 1 | 'N'::bpchar | ||
c_invoice | processed | bpchar | 1 | 'N'::bpchar | ||
c_invoiceline | processed | bpchar | 1 | 'N'::bpchar | ||
c_order | processed | bpchar | 1 | 'N'::bpchar | ||
c_orderline | processed | bpchar | 1 | 'N'::bpchar | ||
c_project | processed | bpchar | 1 | 'N'::bpchar | ||
c_projectissue | processed | bpchar | 1 | 'N'::bpchar | ||
c_projectline | processed | bpchar | 1 | 'N'::bpchar | ||
m_inout | processed | bpchar | 1 | 'N'::bpchar | ||
m_inoutline | processed | bpchar | 1 | 'N'::bpchar | ||
s_timeexpenseline | processed | bpchar | 1 | 'N'::bpchar | ||
c_projecttype | projectcategory | bpchar | 1 | 'N'::bpchar | ||
c_bpartner | sendemail | bpchar | 1 | 'N'::bpchar | ||
c_invoice | sendemail | bpchar | 1 | 'N'::bpchar | ||
c_order | sendemail | bpchar | 1 | 'N'::bpchar | ||
m_inout | sendemail | bpchar | 1 | 'N'::bpchar | ||
a_asset | a_asset_status | varchar | 2 | 'NW'::character varying | ||
c_bpartner | socreditstatus | bpchar | 1 | √ | 'O'::bpchar | |
c_project | projectlinelevel | bpchar | 1 | 'P'::bpchar | ||
c_projectline | dopricing | bpchar | 1 | √ | 'Y'::bpchar | |
c_bpartner | isdiscountprinted | bpchar | 1 | √ | 'Y'::bpchar | |
c_paymentterm | isnextbusinessday | bpchar | 1 | √ | 'Y'::bpchar | |
a_asset | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_activity | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_bpartner | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_cycle | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_cyclephase | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_cyclestep | 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_orderline | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_paymentterm | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_phase | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_project | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_projectissue | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_projectline | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_projectphase | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_projecttask | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_projecttype | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_task | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_inout | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_inoutline | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_pricelist_version | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_product | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_transaction | isactive | bpchar | 1 | 'Y'::bpchar | ||
m_warehouse | isactive | bpchar | 1 | 'Y'::bpchar | ||
s_resource | isactive | bpchar | 1 | 'Y'::bpchar | ||
s_timeexpenseline | isactive | bpchar | 1 | 'Y'::bpchar | ||
c_invoice | isapproved | bpchar | 1 | 'Y'::bpchar | ||
c_order | isapproved | bpchar | 1 | 'Y'::bpchar | ||
s_resource | isavailable | bpchar | 1 | 'Y'::bpchar | ||
c_project | iscommitment | bpchar | 1 | 'Y'::bpchar | ||
c_bpartner | iscustomer | bpchar | 1 | 'Y'::bpchar | ||
a_asset | isdepreciated | bpchar | 1 | 'Y'::bpchar | ||
c_invoice | isdiscountprinted | bpchar | 1 | 'Y'::bpchar | ||
c_order | isdiscountprinted | bpchar | 1 | 'Y'::bpchar | ||
a_asset | isinposession | bpchar | 1 | 'Y'::bpchar | ||
a_asset | isowned | bpchar | 1 | 'Y'::bpchar | ||
c_invoiceline | isprinted | bpchar | 1 | 'Y'::bpchar | ||
c_projectline | isprinted | bpchar | 1 | 'Y'::bpchar | ||
m_product | ispurchased | bpchar | 1 | 'Y'::bpchar | ||
m_product | 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_inout | issotrx | bpchar | 1 | 'Y'::bpchar | ||
m_product | isstocked | bpchar | 1 | 'Y'::bpchar | ||
s_resource | planninghorizon | numeric | 10 | √ | (0)::numeric | |
m_product | lowlevel | numeric | 10 | (0)::numeric | ||
m_inout | nopackages | numeric | 10 | √ | (1)::numeric | |
s_resource | percentutilization | numeric | 0 | (100)::numeric | ||
c_bpartner | acqusitioncost | numeric | 0 | √ | 0 | |
c_bpartner | actuallifetimevalue | numeric | 0 | √ | 0 | |
s_resource | chargeableqty | numeric | 0 | √ | 0 | |
c_invoice | chargeamt | numeric | 0 | √ | 0 | |
c_order | chargeamt | numeric | 0 | √ | 0 | |
m_inout | chargeamt | numeric | 0 | √ | 0 | |
c_projectline | committedamt | numeric | 0 | √ | 0 | |
c_projectline | committedqty | numeric | 0 | √ | 0 | |
m_inoutline | confirmedqty | numeric | 0 | √ | 0 | |
s_timeexpenseline | convertedamt | numeric | 0 | √ | 0 | |
s_timeexpenseline | expenseamt | numeric | 0 | √ | 0 | |
c_order | freightamt | numeric | 0 | √ | 0 | |
m_inout | freightamt | numeric | 0 | √ | 0 | |
s_timeexpenseline | invoiceprice | numeric | 0 | √ | 0 | |
c_invoiceline | linetotalamt | numeric | 0 | √ | 0 | |
a_asset | m_attributesetinstance_id | numeric | 10 | √ | 0 | |
c_invoiceline | m_attributesetinstance_id | numeric | 10 | √ | 0 | |
c_orderline | m_attributesetinstance_id | numeric | 10 | √ | 0 | |
c_projectissue | m_attributesetinstance_id | numeric | 10 | √ | 0 | |
m_inoutline | m_attributesetinstance_id | numeric | 10 | √ | 0 | |
m_product | m_attributesetinstance_id | numeric | 10 | √ | 0 | |
m_inoutline | pickedqty | numeric | 0 | √ | 0 | |
c_bpartner | potentiallifetimevalue | numeric | 0 | √ | 0 | |
c_projectphase | priceactual | numeric | 0 | √ | 0 | |
c_projectphase | qty | numeric | 0 | √ | 0 | |
c_projecttask | qty | numeric | 0 | √ | 0 | |
s_timeexpenseline | qty | numeric | 0 | √ | 0 | |
m_inoutline | qtyoverreceipt | numeric | 0 | √ | 0 | |
m_inoutline | scrappedqty | numeric | 0 | √ | 0 | |
c_bpartner | so_creditlimit | numeric | 0 | √ | 0 | |
c_bpartner | so_creditused | numeric | 0 | √ | 0 | |
m_inoutline | targetqty | numeric | 0 | √ | 0 | |
c_invoiceline | taxamt | numeric | 0 | √ | 0 | |
m_product | volume | numeric | 0 | √ | 0 | |
m_product | weight | numeric | 0 | √ | 0 | |
c_project | committedamt | numeric | 0 | 0 | ||
c_projectphase | committedamt | numeric | 0 | 0 | ||
c_projecttask | committedamt | numeric | 0 | 0 | ||
c_project | committedqty | numeric | 0 | 0 | ||
c_orderline | freightamt | numeric | 0 | 0 | ||
c_invoice | grandtotal | numeric | 0 | 0 | ||
c_order | grandtotal | numeric | 0 | 0 | ||
c_project | invoicedamt | numeric | 0 | 0 | ||
c_projectline | invoicedamt | numeric | 0 | 0 | ||
c_project | invoicedqty | numeric | 0 | 0 | ||
c_projectline | invoicedqty | numeric | 0 | 0 | ||
c_invoiceline | linenetamt | numeric | 0 | 0 | ||
c_orderline | linenetamt | numeric | 0 | 0 | ||
m_transaction | m_attributesetinstance_id | numeric | 10 | 0 | ||
c_projectissue | movementqty | numeric | 0 | 0 | ||
m_inoutline | movementqty | numeric | 0 | 0 | ||
m_transaction | movementqty | numeric | 0 | 0 | ||
c_project | plannedamt | numeric | 0 | 0 | ||
c_projectline | plannedamt | numeric | 0 | 0 | ||
c_projectphase | plannedamt | numeric | 0 | 0 | ||
c_projecttask | plannedamt | numeric | 0 | 0 | ||
c_project | plannedmarginamt | numeric | 0 | 0 | ||
c_projectline | plannedmarginamt | numeric | 0 | 0 | ||
c_projectline | plannedprice | numeric | 0 | 0 | ||
c_project | plannedqty | numeric | 0 | 0 | ||
c_projectline | plannedqty | numeric | 0 | 0 | ||
c_invoiceline | priceactual | numeric | 0 | 0 | ||
c_orderline | priceactual | numeric | 0 | 0 | ||
c_invoiceline | pricelimit | numeric | 0 | 0 | ||
c_orderline | pricelimit | numeric | 0 | 0 | ||
c_invoiceline | pricelist | numeric | 0 | 0 | ||
c_orderline | pricelist | numeric | 0 | 0 | ||
c_project | projectbalanceamt | numeric | 0 | 0 | ||
c_orderline | qtydelivered | numeric | 0 | 0 | ||
c_invoiceline | qtyinvoiced | numeric | 0 | 0 | ||
c_orderline | qtyinvoiced | numeric | 0 | 0 | ||
c_orderline | qtylostsales | numeric | 0 | 0 | ||
c_orderline | qtyordered | numeric | 0 | 0 | ||
c_orderline | qtyreserved | numeric | 0 | 0 | ||
c_phase | standardqty | numeric | 0 | 0 | ||
c_task | standardqty | numeric | 0 | 0 | ||
c_invoice | totallines | numeric | 0 | 0 | ||
c_order | totallines | numeric | 0 | 0 | ||
m_product | unitsperpack | numeric | 10 | 1 | ||
a_asset | created | timestamp | 29,6 | now() | ||
c_activity | created | timestamp | 29,6 | now() | ||
c_bpartner | created | timestamp | 29,6 | now() | ||
c_cycle | created | timestamp | 29,6 | now() | ||
c_cyclephase | created | timestamp | 29,6 | now() | ||
c_cyclestep | created | timestamp | 29,6 | now() | ||
c_invoice | created | timestamp | 29,6 | now() | ||
c_invoiceline | created | timestamp | 29,6 | now() | ||
c_order | created | timestamp | 29,6 | now() | ||
c_orderline | created | timestamp | 29,6 | now() | ||
c_paymentterm | created | timestamp | 29,6 | now() | ||
c_phase | created | timestamp | 29,6 | now() | ||
c_project | created | timestamp | 29,6 | now() | ||
c_projectissue | created | timestamp | 29,6 | now() | ||
c_projectline | created | timestamp | 29,6 | now() | ||
c_projectphase | created | timestamp | 29,6 | now() | ||
c_projecttask | created | timestamp | 29,6 | now() | ||
c_projecttype | created | timestamp | 29,6 | now() | ||
c_task | created | timestamp | 29,6 | now() | ||
m_inout | created | timestamp | 29,6 | now() | ||
m_inoutline | created | timestamp | 29,6 | now() | ||
m_pricelist_version | created | timestamp | 29,6 | now() | ||
m_product | created | timestamp | 29,6 | now() | ||
m_transaction | created | timestamp | 29,6 | now() | ||
m_warehouse | created | timestamp | 29,6 | now() | ||
s_resource | created | timestamp | 29,6 | now() | ||
s_timeexpenseline | created | timestamp | 29,6 | now() | ||
a_asset | updated | timestamp | 29,6 | now() | ||
c_activity | updated | timestamp | 29,6 | now() | ||
c_bpartner | updated | timestamp | 29,6 | now() | ||
c_cycle | updated | timestamp | 29,6 | now() | ||
c_cyclephase | updated | timestamp | 29,6 | now() | ||
c_cyclestep | updated | timestamp | 29,6 | now() | ||
c_invoice | updated | timestamp | 29,6 | now() | ||
c_invoiceline | updated | timestamp | 29,6 | now() | ||
c_order | updated | timestamp | 29,6 | now() | ||
c_orderline | updated | timestamp | 29,6 | now() | ||
c_paymentterm | updated | timestamp | 29,6 | now() | ||
c_phase | updated | timestamp | 29,6 | now() | ||
c_project | updated | timestamp | 29,6 | now() | ||
c_projectissue | updated | timestamp | 29,6 | now() | ||
c_projectline | updated | timestamp | 29,6 | now() | ||
c_projectphase | updated | timestamp | 29,6 | now() | ||
c_projecttask | updated | timestamp | 29,6 | now() | ||
c_projecttype | updated | timestamp | 29,6 | now() | ||
c_task | updated | timestamp | 29,6 | now() | ||
m_inout | updated | timestamp | 29,6 | now() | ||
m_inoutline | updated | timestamp | 29,6 | now() | ||
m_pricelist_version | updated | timestamp | 29,6 | now() | ||
m_product | updated | timestamp | 29,6 | now() | ||
m_transaction | updated | timestamp | 29,6 | now() | ||
m_warehouse | updated | timestamp | 29,6 | now() | ||
s_resource | updated | timestamp | 29,6 | now() | ||
s_timeexpenseline | updated | timestamp | 29,6 | now() | ||
a_asset | a_asset_createdate | timestamp | 29,6 | √ | null | |
c_invoiceline | a_asset_group_id | numeric | 10 | √ | null | |
c_invoiceline | a_asset_id | numeric | 10 | √ | null | |
a_asset | a_asset_revaldate | timestamp | 29,6 | √ | null | |
a_asset | a_asset_type_id | numeric | 10 | √ | null | |
c_invoiceline | a_capvsexp | varchar | 3 | √ | null | |
a_asset | a_parent_asset_id | numeric | 10 | √ | null | |
a_asset | a_qty_current | numeric | 0 | √ | null | |
a_asset | a_qty_original | numeric | 0 | √ | null | |
c_bpartner | ad_language | varchar | 6 | √ | null | |
c_bpartner | ad_orgbp_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 | |
a_asset | ad_user_id | numeric | 10 | √ | null | |
c_invoice | ad_user_id | numeric | 10 | √ | null | |
c_order | ad_user_id | numeric | 10 | √ | null | |
c_project | ad_user_id | numeric | 10 | √ | null | |
m_inout | ad_user_id | numeric | 10 | √ | null | |
s_resource | ad_user_id | numeric | 10 | √ | null | |
c_order | amountrefunded | numeric | 22,2 | √ | null | |
c_order | amounttendered | numeric | 22,2 | √ | null | |
a_asset | assetactivationdate | timestamp | 29,6 | √ | null | |
a_asset | assetdepreciationdate | timestamp | 29,6 | √ | null | |
a_asset | assetdisposaldate | timestamp | 29,6 | √ | null | |
a_asset | assetservicedate | timestamp | 29,6 | √ | null | |
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_bpartner | bpartner_parent_id | numeric | 10 | √ | null | |
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 | |
s_timeexpenseline | c_activity_id | numeric | 10 | √ | null | |
a_asset | c_bpartner_id | numeric | 10 | √ | null | |
c_orderline | c_bpartner_id | numeric | 10 | √ | null | |
c_project | c_bpartner_id | numeric | 10 | √ | null | |
s_timeexpenseline | c_bpartner_id | numeric | 10 | √ | null | |
a_asset | c_bpartner_location_id | numeric | 10 | √ | null | |
c_orderline | c_bpartner_location_id | numeric | 10 | √ | null | |
c_project | c_bpartner_location_id | numeric | 10 | √ | null | |
a_asset | c_bpartnersr_id | numeric | 10 | √ | null | |
c_project | c_bpartnersr_id | numeric | 10 | √ | null | |
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 | |
c_project | c_campaign_id | numeric | 10 | √ | null | |
m_inout | c_campaign_id | numeric | 10 | √ | null | |
m_inoutline | c_campaign_id | numeric | 10 | √ | null | |
s_timeexpenseline | c_campaign_id | numeric | 10 | √ | null | |
c_invoice | c_cashline_id | numeric | 10 | √ | null | |
c_order | c_cashline_id | numeric | 10 | √ | null | |
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 | |
c_invoice | c_conversiontype_id | numeric | 10 | √ | null | |
c_order | c_conversiontype_id | numeric | 10 | √ | null | |
s_timeexpenseline | c_currency_id | numeric | 10 | √ | null | |
c_bpartner | c_dunning_id | numeric | 10 | √ | null | |
c_invoice | c_dunninglevel_id | numeric | 10 | √ | null | |
c_bpartner | c_greeting_id | numeric | 10 | √ | null | |
m_inout | c_invoice_id | numeric | 10 | √ | null | |
s_timeexpenseline | c_invoiceline_id | numeric | 10 | √ | null | |
c_bpartner | c_invoiceschedule_id | numeric | 10 | √ | null | |
a_asset | c_location_id | numeric | 10 | √ | null | |
c_invoice | c_order_id | numeric | 10 | √ | null | |
c_projectline | c_order_id | numeric | 10 | √ | null | |
c_projectphase | c_order_id | numeric | 10 | √ | null | |
m_inout | c_order_id | numeric | 10 | √ | null | |
c_invoiceline | c_orderline_id | numeric | 10 | √ | null | |
m_inoutline | c_orderline_id | numeric | 10 | √ | null | |
s_timeexpenseline | c_orderline_id | numeric | 10 | √ | null | |
c_projectline | c_orderpo_id | numeric | 10 | √ | null | |
c_order | c_ordersource_id | numeric | 10 | √ | null | |
c_invoice | c_payment_id | numeric | 10 | √ | null | |
c_order | c_payment_id | numeric | 10 | √ | null | |
c_bpartner | c_paymentterm_id | numeric | 10 | √ | null | |
c_project | c_paymentterm_id | numeric | 10 | √ | null | |
c_project | c_phase_id | numeric | 10 | √ | null | |
c_projectphase | c_phase_id | numeric | 10 | √ | null | |
c_order | c_pos_id | numeric | 10 | √ | null | |
a_asset | c_project_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 | |
m_inout | c_project_id | numeric | 10 | √ | null | |
m_inoutline | c_project_id | numeric | 10 | √ | null | |
s_timeexpenseline | c_project_id | numeric | 10 | √ | null | |
c_projectline | c_projectissue_id | numeric | 10 | √ | null | |
m_transaction | c_projectissue_id | numeric | 10 | √ | null | |
c_invoiceline | c_projectphase_id | numeric | 10 | √ | null | |
c_orderline | c_projectphase_id | numeric | 10 | √ | null | |
c_projectline | c_projectphase_id | numeric | 10 | √ | null | |
m_inoutline | c_projectphase_id | numeric | 10 | √ | null | |
s_timeexpenseline | c_projectphase_id | numeric | 10 | √ | null | |
c_invoiceline | c_projecttask_id | numeric | 10 | √ | null | |
c_orderline | c_projecttask_id | numeric | 10 | √ | null | |
c_projectline | c_projecttask_id | numeric | 10 | √ | null | |
m_inoutline | c_projecttask_id | numeric | 10 | √ | null | |
s_timeexpenseline | c_projecttask_id | numeric | 10 | √ | null | |
c_project | c_projecttype_id | numeric | 10 | √ | null | |
m_product | c_revenuerecognition_id | numeric | 10 | √ | null | |
m_product | c_subscriptiontype_id | numeric | 10 | √ | null | |
c_projecttask | c_task_id | numeric | 10 | √ | null | |
c_invoiceline | c_tax_id | numeric | 10 | √ | null | |
c_bpartner | c_taxgroup_id | numeric | 10 | √ | null | |
c_invoiceline | c_uom_id | numeric | 10 | √ | null | |
s_timeexpenseline | c_uom_id | numeric | 10 | √ | null | |
m_product | classification | varchar | 12 | √ | null | |
c_invoice | copyfrom | bpchar | 1 | √ | null | |
c_order | copyfrom | bpchar | 1 | √ | null | |
c_project | copyfrom | bpchar | 1 | √ | null | |
m_inout | createconfirm | bpchar | 1 | √ | null | |
c_invoice | createfrom | bpchar | 1 | √ | null | |
m_inout | createfrom | bpchar | 1 | √ | null | |
m_inout | createpackage | bpchar | 1 | √ | null | |
c_invoice | currencyrate | numeric | 0 | √ | null | |
m_product | customstariffnumber | varchar | 20 | √ | null | |
s_resource | dailycapacity | numeric | 0 | √ | null | |
c_project | datecontract | timestamp | 29,6 | √ | null | |
c_orderline | datedelivered | timestamp | 29,6 | √ | null | |
s_timeexpenseline | dateexpense | timestamp | 29,6 | √ | null | |
c_project | datefinish | timestamp | 29,6 | √ | null | |
c_orderline | dateinvoiced | timestamp | 29,6 | √ | null | |
c_invoice | dateordered | timestamp | 29,6 | √ | null | |
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_bpartner | deliveryrule | bpchar | 1 | √ | null | |
c_bpartner | deliveryviarule | bpchar | 1 | √ | null | |
a_asset | description | varchar | 255 | √ | null | |
c_activity | description | varchar | 255 | √ | null | |
c_bpartner | description | varchar | 255 | √ | null | |
c_cycle | description | varchar | 255 | √ | null | |
c_invoice | description | varchar | 255 | √ | null | |
c_invoiceline | description | varchar | 255 | √ | null | |
c_order | description | varchar | 255 | √ | null | |
c_orderline | description | varchar | 255 | √ | null | |
c_paymentterm | description | varchar | 255 | √ | null | |
c_phase | description | varchar | 255 | √ | null | |
c_project | description | varchar | 255 | √ | null | |
c_projectissue | description | varchar | 255 | √ | null | |
c_projectline | description | varchar | 255 | √ | null | |
c_projectphase | description | varchar | 255 | √ | null | |
c_projecttask | description | varchar | 255 | √ | null | |
c_projecttype | description | varchar | 255 | √ | null | |
c_task | description | varchar | 255 | √ | null | |
m_inout | description | varchar | 255 | √ | null | |
m_inoutline | description | varchar | 255 | √ | null | |
m_pricelist_version | description | varchar | 255 | √ | null | |
m_product | description | varchar | 255 | √ | null | |
m_warehouse | description | varchar | 255 | √ | null | |
s_resource | description | varchar | 255 | √ | null | |
s_timeexpenseline | description | varchar | 255 | √ | null | |
m_product | descriptionurl | varchar | 120 | √ | null | |
m_product | discontinuedat | timestamp | 29,6 | √ | null | |
m_product | discontinuedby | timestamp | 29,6 | √ | null | |
c_orderline | discount | numeric | 0 | √ | null | |
c_bpartner | documentcopies | numeric | 10 | √ | null | |
c_paymentterm | documentnote | varchar | 2000 | √ | 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_bpartner | dunninggrace | timestamp | 29,6 | √ | null | |
c_invoice | dunninggrace | timestamp | 29,6 | √ | null | |
c_bpartner | duns | varchar | 11 | √ | null | |
c_projectphase | enddate | timestamp | 29,6 | √ | null | |
c_bpartner | firstsale | timestamp | 29,6 | √ | null | |
c_paymentterm | fixmonthcutoff | numeric | 10 | √ | null | |
c_paymentterm | fixmonthday | numeric | 10 | √ | null | |
c_paymentterm | fixmonthoffset | numeric | 10 | √ | null | |
c_bpartner | flatdiscount | numeric | 0 | √ | null | |
c_bpartner | freightcostrule | bpchar | 1 | √ | null | |
c_projectphase | generateorder | bpchar | 1 | √ | null | |
c_invoice | generateto | bpchar | 1 | √ | null | |
c_project | generateto | bpchar | 1 | √ | null | |
m_inout | generateto | bpchar | 1 | √ | null | |
m_product | group1 | varchar | 255 | √ | null | |
m_product | group2 | varchar | 255 | √ | null | |
a_asset | guaranteedate | timestamp | 29,6 | √ | null | |
m_product | guaranteedays | numeric | 10 | √ | null | |
m_product | guaranteedaysmin | numeric | 10 | √ | null | |
a_asset | help | varchar | 2000 | √ | null | |
c_activity | help | varchar | 2000 | √ | null | |
c_phase | help | varchar | 2000 | √ | null | |
c_projectphase | help | varchar | 2000 | √ | null | |
c_projecttask | help | varchar | 2000 | √ | null | |
c_projecttype | help | varchar | 2000 | √ | null | |
c_task | help | varchar | 2000 | √ | null | |
m_product | help | varchar | 2000 | √ | null | |
m_product | imageurl | varchar | 120 | √ | null | |
c_bpartner | invoice_printformat_id | numeric | 10 | √ | null | |
c_invoice | invoicecollectiontype | bpchar | 1 | √ | null | |
c_bpartner | invoicerule | bpchar | 1 | √ | null | |
c_invoice | isfixedassetinvoice | bpchar | 1 | √ | null | |
c_invoiceline | isfixedassetinvoice | bpchar | 1 | √ | null | |
m_product | istoformule | bpchar | 1 | √ | null | |
a_asset | lastmaintenancedate | timestamp | 29,6 | √ | null | |
a_asset | lastmaintenancenote | varchar | 60 | √ | null | |
a_asset | lastmaintenanceunit | numeric | 10 | √ | null | |
a_asset | lastmaintenanceuseunit | numeric | 10 | √ | null | |
a_asset | lastmaintenencedate | timestamp | 29,6 | √ | null | |
a_asset | lease_bpartner_id | numeric | 10 | √ | null | |
a_asset | leaseterminationdate | timestamp | 29,6 | √ | null | |
a_asset | lifeuseunits | numeric | 0 | √ | null | |
c_order | link_order_id | numeric | 10 | √ | null | |
c_orderline | link_orderline_id | numeric | 10 | √ | null | |
a_asset | locationcomment | varchar | 255 | √ | null | |
a_asset | lot | varchar | 255 | √ | null | |
m_product | m_attributeset_id | numeric | 10 | √ | null | |
c_bpartner | m_discountschema_id | numeric | 10 | √ | null | |
m_product | m_freightcategory_id | numeric | 10 | √ | null | |
a_asset | m_inoutline_id | numeric | 10 | √ | null | |
c_invoiceline | m_inoutline_id | numeric | 10 | √ | null | |
c_projectissue | m_inoutline_id | numeric | 10 | √ | null | |
m_transaction | m_inoutline_id | numeric | 10 | √ | null | |
m_transaction | m_inventoryline_id | numeric | 10 | √ | null | |
a_asset | m_locator_id | numeric | 10 | √ | null | |
m_inoutline | m_locator_id | numeric | 10 | √ | null | |
m_product | m_locator_id | numeric | 10 | √ | null | |
m_transaction | m_movementline_id | numeric | 10 | √ | null | |
c_bpartner | m_pricelist_id | numeric | 10 | √ | null | |
m_pricelist_version | m_pricelist_version_base_id | numeric | 10 | √ | null | |
c_project | m_pricelist_version_id | numeric | 10 | √ | null | |
c_projectline | m_product_category_id | numeric | 10 | √ | null | |
c_invoiceline | m_product_id | numeric | 10 | √ | null | |
c_orderline | m_product_id | numeric | 10 | √ | null | |
c_phase | m_product_id | numeric | 10 | √ | null | |
c_projectline | m_product_id | numeric | 10 | √ | null | |
c_projectphase | m_product_id | numeric | 10 | √ | null | |
c_projecttask | m_product_id | numeric | 10 | √ | null | |
c_task | m_product_id | numeric | 10 | √ | null | |
m_inoutline | m_product_id | numeric | 10 | √ | null | |
s_timeexpenseline | m_product_id | numeric | 10 | √ | null | |
m_transaction | m_productionline_id | numeric | 10 | √ | null | |
c_orderline | m_promotion_id | numeric | 10 | √ | null | |
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 | |
c_project | m_warehouse_id | numeric | 10 | √ | null | |
m_warehouse | m_warehousesource_id | numeric | 10 | √ | null | |
s_resource | manufacturingresourcetype | bpchar | 2 | √ | null | |
c_bpartner | naics | varchar | 6 | √ | null | |
c_bpartner | name2 | varchar | 60 | √ | null | |
c_paymentterm | netday | bpchar | 1 | √ | null | |
a_asset | nextmaintenanceuseunit | numeric | 10 | √ | null | |
a_asset | nextmaintenencedate | timestamp | 29,6 | √ | null | |
a_asset | nextmaintenenceunit | numeric | 10 | √ | null | |
c_project | note | varchar | 2000 | √ | null | |
s_timeexpenseline | note | varchar | 255 | √ | null | |
c_bpartner | numberemployees | numeric | 10 | √ | null | |
c_order | ordertype | varchar | 510 | √ | null | |
c_order | pay_bpartner_id | numeric | 10 | √ | null | |
c_order | pay_location_id | numeric | 10 | √ | null | |
c_bpartner | paymentrule | bpchar | 1 | √ | null | |
c_bpartner | paymentrulepo | bpchar | 1 | √ | null | |
m_inout | pickdate | timestamp | 29,6 | √ | null | |
c_bpartner | po_discountschema_id | numeric | 10 | √ | null | |
c_bpartner | po_paymentterm_id | numeric | 10 | √ | null | |
c_bpartner | po_pricelist_id | numeric | 10 | √ | null | |
c_bpartner | poreference | varchar | 20 | √ | null | |
c_invoice | poreference | varchar | 20 | √ | null | |
c_order | poreference | varchar | 20 | √ | null | |
c_project | poreference | varchar | 20 | √ | null | |
m_inout | poreference | varchar | 20 | √ | null | |
c_orderline | pp_cost_collector_id | numeric | 10 | √ | null | |
m_transaction | pp_cost_collector_id | numeric | 10 | √ | null | |
c_orderline | pricecost | numeric | 0 | √ | null | |
s_timeexpenseline | priceinvoiced | numeric | 0 | √ | null | |
s_timeexpenseline | pricereimbursed | numeric | 0 | √ | null | |
m_pricelist_version | proccreate | bpchar | 1 | √ | null | |
c_invoice | processedon | numeric | 0 | √ | null | |
c_order | processedon | numeric | 0 | √ | null | |
c_projectissue | processedon | numeric | 0 | √ | null | |
m_inout | processedon | numeric | 0 | √ | null | |
c_invoice | processing | bpchar | 1 | √ | null | |
c_order | processing | bpchar | 1 | √ | null | |
c_paymentterm | processing | bpchar | 1 | √ | null | |
c_project | processing | bpchar | 1 | √ | null | |
c_projectissue | processing | bpchar | 1 | √ | null | |
m_inout | processing | bpchar | 1 | √ | null | |
m_product | processing | bpchar | 1 | √ | null | |
c_projectphase | projinvoicerule | bpchar | 1 | √ | null | |
c_projecttask | projinvoicerule | bpchar | 1 | √ | null | |
c_order | promotioncode | varchar | 30 | √ | null | |
a_asset | qty | numeric | 0 | √ | null | |
s_timeexpenseline | qtyinvoiced | numeric | 0 | √ | null | |
s_timeexpenseline | qtyreimbursed | numeric | 0 | √ | null | |
s_resource | queuingtime | numeric | 0 | √ | null | |
m_product | r_mailtext_id | numeric | 10 | √ | null | |
c_bpartner | rating | bpchar | 1 | √ | 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 | |
c_order | ref_order_id | numeric | 10 | √ | null | |
c_orderline | ref_orderline_id | numeric | 10 | √ | null | |
c_bpartner | referenceno | varchar | 40 | √ | null | |
m_warehouse | replenishmentclass | varchar | 60 | √ | null | |
c_invoice | reversal_id | numeric | 10 | √ | null | |
c_projectissue | reversal_id | numeric | 10 | √ | null | |
m_inout | reversal_id | numeric | 10 | √ | null | |
m_inoutline | reversalline_id | numeric | 10 | √ | null | |
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 | |
c_invoiceline | s_resourceassignment_id | numeric | 10 | √ | null | |
c_orderline | s_resourceassignment_id | numeric | 10 | √ | null | |
s_timeexpenseline | s_resourceassignment_id | numeric | 10 | √ | null | |
c_projectissue | s_timeexpenseline_id | numeric | 10 | √ | null | |
s_timeexpenseline | s_timetype_id | numeric | 10 | √ | null | |
c_bpartner | salesrep_id | numeric | 10 | √ | null | |
c_invoice | salesrep_id | numeric | 10 | √ | null | |
c_order | salesrep_id | numeric | 10 | √ | null | |
c_project | salesrep_id | numeric | 10 | √ | null | |
m_inout | salesrep_id | numeric | 10 | √ | null | |
m_product | salesrep_id | numeric | 10 | √ | null | |
c_bpartner | salesvolume | numeric | 10 | √ | null | |
a_asset | serno | varchar | 255 | √ | null | |
c_bpartner | shareofcustomer | numeric | 10 | √ | null | |
m_product | shelfdepth | numeric | 10 | √ | null | |
m_product | shelfheight | numeric | 0 | √ | null | |
c_bpartner | shelflifeminpct | numeric | 10 | √ | null | |
m_product | shelfwidth | numeric | 10 | √ | null | |
m_inout | shipdate | timestamp | 29,6 | √ | null | |
m_product | sku | varchar | 30 | √ | null | |
c_bpartner | so_description | varchar | 255 | √ | null | |
c_projectphase | startdate | timestamp | 29,6 | √ | null | |
c_bpartner | taxid | varchar | 20 | √ | null | |
c_bpartner | totalopenbalance | numeric | 0 | √ | null | |
m_inout | trackingno | varchar | 60 | √ | null | |
m_product | unitsperpallet | numeric | 0 | √ | null | |
m_product | upc | varchar | 30 | √ | null | |
c_bpartner | url | varchar | 120 | √ | null | |
a_asset | uselifemonths | numeric | 10 | √ | null | |
a_asset | uselifeyears | numeric | 10 | √ | null | |
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 | |
a_asset | useunits | numeric | 0 | √ | null | |
a_asset | versionno | varchar | 20 | √ | null | |
m_product | versionno | varchar | 20 | √ | null | |
c_order | volume | numeric | 0 | √ | null | |
m_inout | volume | numeric | 0 | √ | null | |
s_resource | waitingtime | numeric | 0 | √ | null | |
c_order | weight | numeric | 0 | √ | null | |
m_inout | weight | numeric | 0 | √ | null | |
a_asset | a_asset_group_id | numeric | 10 | |||
a_asset | a_asset_id | numeric | 10 | |||
a_asset | ad_client_id | numeric | 10 | |||
c_activity | ad_client_id | numeric | 10 | |||
c_bpartner | ad_client_id | numeric | 10 | |||
c_cycle | ad_client_id | numeric | 10 | |||
c_cyclephase | ad_client_id | numeric | 10 | |||
c_cyclestep | ad_client_id | numeric | 10 | |||
c_invoice | ad_client_id | numeric | 10 | |||
c_invoiceline | ad_client_id | numeric | 10 | |||
c_order | ad_client_id | numeric | 10 | |||
c_orderline | ad_client_id | numeric | 10 | |||
c_paymentterm | ad_client_id | numeric | 10 | |||
c_phase | ad_client_id | numeric | 10 | |||
c_project | ad_client_id | numeric | 10 | |||
c_projectissue | ad_client_id | numeric | 10 | |||
c_projectline | ad_client_id | numeric | 10 | |||
c_projectphase | ad_client_id | numeric | 10 | |||
c_projecttask | ad_client_id | numeric | 10 | |||
c_projecttype | ad_client_id | numeric | 10 | |||
c_task | ad_client_id | numeric | 10 | |||
m_inout | ad_client_id | numeric | 10 | |||
m_inoutline | ad_client_id | numeric | 10 | |||
m_pricelist_version | ad_client_id | numeric | 10 | |||
m_product | ad_client_id | numeric | 10 | |||
m_transaction | ad_client_id | numeric | 10 | |||
m_warehouse | ad_client_id | numeric | 10 | |||
s_resource | ad_client_id | numeric | 10 | |||
s_timeexpenseline | ad_client_id | numeric | 10 | |||
a_asset | ad_org_id | numeric | 10 | |||
c_activity | ad_org_id | numeric | 10 | |||
c_bpartner | ad_org_id | numeric | 10 | |||
c_cycle | ad_org_id | numeric | 10 | |||
c_cyclephase | ad_org_id | numeric | 10 | |||
c_cyclestep | ad_org_id | numeric | 10 | |||
c_invoice | ad_org_id | numeric | 10 | |||
c_invoiceline | ad_org_id | numeric | 10 | |||
c_order | ad_org_id | numeric | 10 | |||
c_orderline | ad_org_id | numeric | 10 | |||
c_paymentterm | ad_org_id | numeric | 10 | |||
c_phase | ad_org_id | numeric | 10 | |||
c_project | ad_org_id | numeric | 10 | |||
c_projectissue | ad_org_id | numeric | 10 | |||
c_projectline | ad_org_id | numeric | 10 | |||
c_projectphase | ad_org_id | numeric | 10 | |||
c_projecttask | ad_org_id | numeric | 10 | |||
c_projecttype | ad_org_id | numeric | 10 | |||
c_task | ad_org_id | numeric | 10 | |||
m_inout | ad_org_id | numeric | 10 | |||
m_inoutline | ad_org_id | numeric | 10 | |||
m_pricelist_version | ad_org_id | numeric | 10 | |||
m_product | ad_org_id | numeric | 10 | |||
m_transaction | ad_org_id | numeric | 10 | |||
m_warehouse | ad_org_id | numeric | 10 | |||
s_resource | ad_org_id | numeric | 10 | |||
s_timeexpenseline | ad_org_id | numeric | 10 | |||
c_activity | c_activity_id | numeric | 10 | |||
c_bpartner | c_bp_group_id | numeric | 10 | |||
c_bpartner | c_bpartner_id | numeric | 10 | |||
c_invoice | c_bpartner_id | numeric | 10 | |||
c_order | c_bpartner_id | numeric | 10 | |||
m_inout | c_bpartner_id | numeric | 10 | |||
c_invoice | c_bpartner_location_id | numeric | 10 | |||
c_order | c_bpartner_location_id | numeric | 10 | |||
m_inout | c_bpartner_location_id | numeric | 10 | |||
c_cycle | 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 | |||
c_project | c_currency_id | numeric | 10 | |||
c_cycle | c_cycle_id | numeric | 10 | |||
c_cyclestep | c_cycle_id | numeric | 10 | |||
c_cyclephase | c_cyclestep_id | numeric | 10 | |||
c_cyclestep | c_cyclestep_id | numeric | 10 | |||
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_invoice_id | numeric | 10 | |||
c_invoiceline | c_invoice_id | numeric | 10 | |||
c_invoiceline | c_invoiceline_id | numeric | 10 | |||
m_warehouse | c_location_id | numeric | 10 | |||
c_order | c_order_id | numeric | 10 | |||
c_orderline | c_order_id | numeric | 10 | |||
c_orderline | c_orderline_id | numeric | 10 | |||
c_invoice | c_paymentterm_id | numeric | 10 | |||
c_order | c_paymentterm_id | numeric | 10 | |||
c_paymentterm | c_paymentterm_id | numeric | 10 | |||
c_cyclephase | c_phase_id | numeric | 10 | |||
c_phase | c_phase_id | numeric | 10 | |||
c_task | c_phase_id | numeric | 10 | |||
c_project | c_project_id | numeric | 10 | |||
c_projectissue | c_project_id | numeric | 10 | |||
c_projectline | c_project_id | numeric | 10 | |||
c_projectphase | c_project_id | numeric | 10 | |||
c_projectissue | c_projectissue_id | numeric | 10 | |||
c_projectline | c_projectline_id | numeric | 10 | |||
c_projectphase | c_projectphase_id | numeric | 10 | |||
c_projecttask | c_projectphase_id | numeric | 10 | |||
c_projecttask | c_projecttask_id | numeric | 10 | |||
c_phase | c_projecttype_id | numeric | 10 | |||
c_projecttype | c_projecttype_id | numeric | 10 | |||
c_task | c_task_id | numeric | 10 | |||
c_orderline | c_tax_id | numeric | 10 | |||
m_product | c_taxcategory_id | numeric | 10 | |||
c_orderline | c_uom_id | numeric | 10 | |||
m_inoutline | c_uom_id | numeric | 10 | |||
m_product | c_uom_id | numeric | 10 | |||
a_asset | createdby | numeric | 10 | |||
c_activity | createdby | numeric | 10 | |||
c_bpartner | createdby | numeric | 10 | |||
c_cycle | createdby | numeric | 10 | |||
c_cyclephase | createdby | numeric | 10 | |||
c_cyclestep | createdby | numeric | 10 | |||
c_invoice | createdby | numeric | 10 | |||
c_invoiceline | createdby | numeric | 10 | |||
c_order | createdby | numeric | 10 | |||
c_orderline | createdby | numeric | 10 | |||
c_paymentterm | createdby | numeric | 10 | |||
c_phase | createdby | numeric | 10 | |||
c_project | createdby | numeric | 10 | |||
c_projectissue | createdby | numeric | 10 | |||
c_projectline | createdby | numeric | 10 | |||
c_projectphase | createdby | numeric | 10 | |||
c_projecttask | createdby | numeric | 10 | |||
c_projecttype | createdby | numeric | 10 | |||
c_task | createdby | numeric | 10 | |||
m_inout | createdby | numeric | 10 | |||
m_inoutline | createdby | numeric | 10 | |||
m_pricelist_version | createdby | numeric | 10 | |||
m_product | createdby | numeric | 10 | |||
m_transaction | createdby | numeric | 10 | |||
m_warehouse | createdby | numeric | 10 | |||
s_resource | createdby | numeric | 10 | |||
s_timeexpenseline | createdby | numeric | 10 | |||
c_invoice | dateacct | timestamp | 29,6 | |||
c_order | dateacct | timestamp | 29,6 | |||
m_inout | dateacct | timestamp | 29,6 | |||
c_invoice | dateinvoiced | timestamp | 29,6 | |||
c_order | dateordered | timestamp | 29,6 | |||
c_orderline | dateordered | timestamp | 29,6 | |||
c_order | deliveryrule | bpchar | 1 | |||
m_inout | deliveryrule | bpchar | 1 | |||
c_order | deliveryviarule | bpchar | 1 | |||
m_inout | deliveryviarule | bpchar | 1 | |||
c_paymentterm | discount | numeric | 0 | |||
c_paymentterm | discount2 | numeric | 0 | |||
c_paymentterm | discountdays | numeric | 10 | |||
c_paymentterm | discountdays2 | numeric | 10 | |||
c_invoice | docaction | bpchar | 2 | |||
c_order | docaction | bpchar | 2 | |||
m_inout | docaction | bpchar | 2 | |||
c_invoice | docstatus | bpchar | 2 | |||
c_order | docstatus | bpchar | 2 | |||
m_inout | docstatus | bpchar | 2 | |||
c_invoice | documentno | varchar | 30 | |||
c_order | documentno | varchar | 30 | |||
m_inout | documentno | varchar | 30 | |||
c_order | freightcostrule | bpchar | 1 | |||
m_inout | freightcostrule | bpchar | 1 | |||
c_paymentterm | gracedays | numeric | 10 | |||
c_order | invoicerule | bpchar | 1 | |||
c_invoiceline | line | numeric | 10 | |||
c_orderline | line | numeric | 10 | |||
c_projectissue | line | numeric | 10 | |||
c_projectline | line | numeric | 10 | |||
m_inoutline | line | numeric | 10 | |||
s_timeexpenseline | line | numeric | 10 | |||
m_pricelist_version | m_discountschema_id | numeric | 10 | |||
m_inout | m_inout_id | numeric | 10 | |||
m_inoutline | m_inout_id | numeric | 10 | |||
m_inoutline | m_inoutline_id | numeric | 10 | |||
c_projectissue | m_locator_id | numeric | 10 | |||
m_transaction | m_locator_id | numeric | 10 | |||
c_invoice | m_pricelist_id | numeric | 10 | |||
c_order | m_pricelist_id | numeric | 10 | |||
m_pricelist_version | m_pricelist_id | numeric | 10 | |||
m_pricelist_version | m_pricelist_version_id | numeric | 10 | |||
m_product | m_product_category_id | numeric | 10 | |||
a_asset | m_product_id | numeric | 10 | |||
c_projectissue | m_product_id | numeric | 10 | |||
m_product | m_product_id | numeric | 10 | |||
m_transaction | m_product_id | numeric | 10 | |||
m_transaction | m_transaction_id | numeric | 10 | |||
c_order | m_warehouse_id | numeric | 10 | |||
c_orderline | m_warehouse_id | numeric | 10 | |||
m_inout | m_warehouse_id | numeric | 10 | |||
m_warehouse | m_warehouse_id | numeric | 10 | |||
s_resource | m_warehouse_id | numeric | 10 | |||
c_projectissue | movementdate | timestamp | 29,6 | |||
m_inout | movementdate | timestamp | 29,6 | |||
m_transaction | movementdate | timestamp | 29,6 | |||
m_inout | movementtype | bpchar | 2 | |||
m_transaction | movementtype | bpchar | 2 | |||
a_asset | name | varchar | 60 | |||
c_activity | name | varchar | 60 | |||
c_bpartner | name | varchar | 120 | |||
c_cycle | name | varchar | 60 | |||
c_cyclestep | name | varchar | 60 | |||
c_paymentterm | name | varchar | 60 | |||
c_phase | name | varchar | 60 | |||
c_project | name | varchar | 60 | |||
c_projectphase | name | varchar | 60 | |||
c_projecttask | name | varchar | 60 | |||
c_projecttype | name | varchar | 60 | |||
c_task | name | varchar | 60 | |||
m_pricelist_version | name | varchar | 60 | |||
m_product | name | varchar | 255 | |||
m_warehouse | name | varchar | 60 | |||
s_resource | name | varchar | 60 | |||
c_paymentterm | netdays | numeric | 10 | |||
c_invoice | paymentrule | bpchar | 1 | |||
c_order | paymentrule | bpchar | 1 | |||
c_invoiceline | priceentered | numeric | 0 | |||
c_orderline | priceentered | numeric | 0 | |||
c_order | priorityrule | bpchar | 1 | |||
m_inout | priorityrule | bpchar | 1 | |||
c_invoiceline | qtyentered | numeric | 0 | |||
c_orderline | qtyentered | numeric | 0 | |||
m_inoutline | qtyentered | numeric | 0 | |||
c_cyclestep | relativeweight | numeric | 0 | |||
s_resource | s_resource_id | numeric | 10 | |||
s_resource | s_resourcetype_id | numeric | 10 | |||
s_timeexpenseline | s_timeexpense_id | numeric | 10 | |||
s_timeexpenseline | s_timeexpenseline_id | numeric | 10 | |||
m_warehouse | separator | bpchar | 1 | |||
c_cyclestep | seqno | numeric | 10 | |||
c_phase | seqno | numeric | 10 | |||
c_projectphase | seqno | numeric | 10 | |||
c_projecttask | seqno | numeric | 10 | |||
c_task | seqno | numeric | 10 | |||
a_asset | updatedby | numeric | 10 | |||
c_activity | updatedby | numeric | 10 | |||
c_bpartner | updatedby | numeric | 10 | |||
c_cycle | updatedby | numeric | 10 | |||
c_cyclephase | updatedby | numeric | 10 | |||
c_cyclestep | updatedby | numeric | 10 | |||
c_invoice | updatedby | numeric | 10 | |||
c_invoiceline | updatedby | numeric | 10 | |||
c_order | updatedby | numeric | 10 | |||
c_orderline | updatedby | numeric | 10 | |||
c_paymentterm | updatedby | numeric | 10 | |||
c_phase | updatedby | numeric | 10 | |||
c_project | updatedby | numeric | 10 | |||
c_projectissue | updatedby | numeric | 10 | |||
c_projectline | updatedby | numeric | 10 | |||
c_projectphase | updatedby | numeric | 10 | |||
c_projecttask | updatedby | numeric | 10 | |||
c_projecttype | updatedby | numeric | 10 | |||
c_task | updatedby | numeric | 10 | |||
m_inout | updatedby | numeric | 10 | |||
m_inoutline | updatedby | numeric | 10 | |||
m_pricelist_version | updatedby | numeric | 10 | |||
m_product | updatedby | numeric | 10 | |||
m_transaction | updatedby | numeric | 10 | |||
m_warehouse | updatedby | numeric | 10 | |||
s_resource | updatedby | numeric | 10 | |||
s_timeexpenseline | updatedby | numeric | 10 | |||
m_pricelist_version | validfrom | timestamp | 29,6 | |||
a_asset | value | varchar | 40 | |||
c_activity | value | varchar | 40 | |||
c_bpartner | value | varchar | 40 | |||
c_paymentterm | value | varchar | 40 | |||
c_project | value | varchar | 40 | |||
m_product | value | varchar | 40 | |||
m_warehouse | value | varchar | 40 | |||
s_resource | value | varchar | 40 | |||
m_product | copyfrom | bpchar | 1 | √ | NULL::bpchar | |
m_inout | insurance | bpchar | 1 | √ | NULL::bpchar | |
c_order | shippingrateinquiry | bpchar | 1 | √ | NULL::bpchar | |
a_asset | a_asset_uu | varchar | 36 | √ | NULL::character varying | |
c_activity | c_activity_uu | varchar | 36 | √ | NULL::character varying | |
c_bpartner | c_bpartner_uu | varchar | 36 | √ | NULL::character varying | |
c_cycle | c_cycle_uu | varchar | 36 | √ | NULL::character varying | |
c_cyclephase | c_cyclephase_uu | varchar | 36 | √ | NULL::character varying | |
c_cyclestep | c_cyclestep_uu | varchar | 36 | √ | NULL::character varying | |
c_invoice | c_invoice_uu | varchar | 36 | √ | NULL::character varying | |
c_invoiceline | c_invoiceline_uu | varchar | 36 | √ | NULL::character varying | |
c_order | c_order_uu | varchar | 36 | √ | NULL::character varying | |
c_orderline | c_orderline_uu | varchar | 36 | √ | NULL::character varying | |
c_paymentterm | c_paymentterm_uu | varchar | 36 | √ | NULL::character varying | |
c_phase | c_phase_uu | varchar | 36 | √ | NULL::character varying | |
c_project | c_project_uu | varchar | 36 | √ | NULL::character varying | |
c_projectissue | c_projectissue_uu | varchar | 36 | √ | NULL::character varying | |
c_projectline | c_projectline_uu | varchar | 36 | √ | NULL::character varying | |
c_projectphase | c_projectphase_uu | varchar | 36 | √ | NULL::character varying | |
c_projecttask | c_projecttask_uu | varchar | 36 | √ | NULL::character varying | |
c_projecttype | c_projecttype_uu | varchar | 36 | √ | NULL::character varying | |
c_task | c_task_uu | varchar | 36 | √ | NULL::character varying | |
c_bpartner | customerprofileid | varchar | 60 | √ | NULL::character varying | |
m_inout | fob | varchar | 10 | √ | NULL::character varying | |
m_inout | freightcharges | varchar | 10 | √ | NULL::character varying | |
a_asset | inventoryno | varchar | 30 | √ | NULL::character varying | |
m_inout | m_inout_uu | varchar | 36 | √ | NULL::character varying | |
m_inoutline | m_inoutline_uu | varchar | 36 | √ | NULL::character varying | |
m_pricelist_version | m_pricelist_version_uu | varchar | 36 | √ | NULL::character varying | |
m_product | m_product_uu | varchar | 36 | √ | NULL::character varying | |
m_transaction | m_transaction_uu | varchar | 36 | √ | NULL::character varying | |
m_warehouse | m_warehouse_uu | varchar | 36 | √ | NULL::character varying | |
a_asset | manufacturer | varchar | 30 | √ | NULL::character varying | |
s_resource | s_resource_uu | varchar | 36 | √ | NULL::character varying | |
s_timeexpenseline | s_timeexpenseline_uu | varchar | 36 | √ | NULL::character varying | |
m_inout | shipperaccount | varchar | 40 | √ | NULL::character varying | |
a_asset | a_asset_class_id | numeric | 10 | √ | NULL::numeric | |
c_project | ad_orgtrx_id | numeric | 10 | √ | NULL::numeric | |
c_invoiceline | c_1099box_id | numeric | 10 | √ | NULL::numeric | |
a_asset | c_activity_id | numeric | 10 | √ | NULL::numeric | |
c_project | c_activity_id | numeric | 10 | √ | NULL::numeric | |
c_invoice | c_cashplanline_id | numeric | 10 | √ | NULL::numeric | |
c_order | c_cashplanline_id | numeric | 10 | √ | NULL::numeric | |
c_order | c_opportunity_id | numeric | 10 | √ | NULL::numeric | |
c_bpartner | default1099box_id | numeric | 10 | √ | NULL::numeric | |
c_bpartner | logo_id | numeric | 10 | √ | NULL::numeric | |
c_order | m_freightcategory_id | numeric | 10 | √ | NULL::numeric | |
m_product | m_parttype_id | numeric | 10 | √ | NULL::numeric | |
c_projectline | m_production_id | numeric | 10 | √ | NULL::numeric | |
m_warehouse | m_reservelocator_id | numeric | 10 | √ | NULL::numeric | |
a_asset | manufacturedyear | numeric | 10 | √ | NULL::numeric | |
c_order | quotationorder_id | numeric | 10 | √ | NULL::numeric | |
c_invoice | relatedinvoice_id | numeric | 10 | √ | NULL::numeric | |
m_inout | returnbpartner_id | numeric | 10 | √ | NULL::numeric | |
m_inout | returnlocation_id | numeric | 10 | √ | NULL::numeric | |
m_inout | returnuser_id | numeric | 10 | √ | NULL::numeric |