| SchemaSpy Analysis of idempiere11.adempiere - ColumnsProduct Attribute | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:53 +0100 |
| |||||
|
| ||||||
idempiere11.adempiere contains 816 columns - click on heading to sort:
| Table | Column | Type | Size | Nulls | Auto | Default | |
|---|---|---|---|---|---|---|---|
| c_invoiceline | a_createasset | bpchar | 1 | √ | 'N'::bpchar | Create Asset | |
| c_invoiceline | a_processed | bpchar | 1 | √ | 'N'::bpchar | Processed | |
| ad_table | accesslevel | bpchar | 1 | Access Level required | |||
| m_transactionallocation | allocationstrategytype | bpchar | 1 | Allocation Strategy | |||
| m_attribute | attributevaluetype | bpchar | 1 | 'S'::bpchar | Type of Attribute Value | ||
| ad_table | copycomponentsfromview | bpchar | 1 | √ | NULL::bpchar | Copy Components From View | |
| m_product | copyfrom | bpchar | 1 | √ | NULL::bpchar | Copy From Record | |
| ad_table | createpartition | bpchar | 1 | √ | NULL::bpchar | Process which create or update table partitions based on the table and column records | |
| c_orderline | createproduction | bpchar | 1 | √ | 'N'::bpchar | Create Production | |
| c_orderline | createshipment | bpchar | 1 | √ | 'N'::bpchar | Create Shipment | |
| ad_table | createwindowfromtable | bpchar | 1 | √ | NULL::bpchar | Create Window From Table | |
| ad_table | databaseviewdrop | bpchar | 1 | √ | NULL::bpchar | Drop view | |
| c_bpartner | deliveryrule | bpchar | 1 | √ | null | Defines the timing of Delivery | |
| c_bpartner | deliveryviarule | bpchar | 1 | √ | null | How the order will be delivered | |
| m_product | discontinued | bpchar | 1 | √ | 'N'::bpchar | This product is no longer available | |
| c_bpartner | freightcostrule | bpchar | 1 | √ | null | Method for charging Freight | |
| ad_table | importtable | bpchar | 1 | √ | null | Import Table Columns from Database | |
| m_inventoryline | inventorytype | bpchar | 1 | 'D'::bpchar | Type of inventory difference | ||
| c_bpartner | invoicerule | bpchar | 1 | √ | null | Frequency and method of invoicing | |
| c_bpartner | is1099vendor | bpchar | 1 | 'N'::bpchar | 1099 Vendor | ||
| a_asset | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| ad_table | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_bpartner | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_bpartner_product | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_invoiceline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_orderline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_projectissue | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_rfqline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_attribute | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_attributeinstance | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_attributesearch | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_attributeset | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_attributesetexclude | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_attributesetinstance | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_attributeuse | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_attributevalue | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_inoutline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_inventoryline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_lot | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_lotctl | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_lotctlexclude | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_movementline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_product | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_productionline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_sernoctl | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_sernoctlexclude | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_storage | isactive | bpchar | 1 | √ | null | The record is active in the system | |
| m_storageonhand | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_storagereservation | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_transaction | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_transactionallocation | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_transactionallocation | isallocated | bpchar | 1 | 'N'::bpchar | Indicates if the payment has been allocated | ||
| c_projectissue | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
| m_attributeset | isautogeneratelot | bpchar | 1 | √ | 'N'::bpchar | Is Auto Generate Lot | |
| m_inoutline | isautoproduce | bpchar | 1 | √ | 'N'::bpchar | Auto create production to fulfill shipment | |
| m_product | isautoproduce | bpchar | 1 | 'N'::bpchar | Auto create production to fulfill shipment | ||
| m_product | isbom | bpchar | 1 | 'N'::bpchar | Bill of Materials | ||
| ad_table | iscentrallymaintained | bpchar | 1 | √ | 'Y'::bpchar | Information maintained in System Element table | |
| ad_table | ischangelog | bpchar | 1 | 'N'::bpchar | Maintain a log of changes | ||
| c_bpartner | iscustomer | bpchar | 1 | 'Y'::bpchar | Indicates if this Business Partner is a Customer | ||
| ad_table | isdeleteable | bpchar | 1 | 'Y'::bpchar | Indicates if records can be deleted from the database | ||
| a_asset | isdepreciated | bpchar | 1 | 'Y'::bpchar | The asset will be depreciated | ||
| c_invoiceline | isdescription | bpchar | 1 | 'N'::bpchar | if true, the line is just description and no transaction | ||
| c_orderline | isdescription | bpchar | 1 | 'N'::bpchar | if true, the line is just description and no transaction | ||
| m_inoutline | isdescription | bpchar | 1 | 'N'::bpchar | if true, the line is just description and no transaction | ||
| c_bpartner | isdiscountprinted | bpchar | 1 | √ | 'Y'::bpchar | Print Discount on Invoice and Order | |
| a_asset | isdisposed | bpchar | 1 | 'N'::bpchar | The asset is disposed | ||
| m_product | isdropship | bpchar | 1 | 'N'::bpchar | Drop Shipments are sent directly to the Drop Shipment Location | ||
| c_bpartner | isemployee | bpchar | 1 | 'N'::bpchar | Indicates if this Business Partner is an employee | ||
| m_productionline | isendproduct | bpchar | 1 | √ | NULL::bpchar | End Product of production | |
| m_product | isexcludeautodelivery | bpchar | 1 | 'N'::bpchar | Exclude from automatic Delivery | ||
| c_invoiceline | isfixedassetinvoice | bpchar | 1 | √ | null | Is Fixed Asset Invoice | |
| a_asset | isfullydepreciated | bpchar | 1 | 'N'::bpchar | The asset is fully depreciated | ||
| m_attributeset | isguaranteedate | bpchar | 1 | 'N'::bpchar | Product has Guarantee or Expiry Date | ||
| m_attributeset | isguaranteedatemandatory | bpchar | 1 | 'N'::bpchar | The entry of a Guarantee Date is mandatory when creating a Product Instance | ||
| ad_table | ishighvolume | bpchar | 1 | 'N'::bpchar | Use Search instead of Pick list | ||
| a_asset | isinposession | bpchar | 1 | 'Y'::bpchar | The asset is in the possession of the organization | ||
| m_attribute | isinstanceattribute | bpchar | 1 | 'N'::bpchar | The product attribute is specific to the instance (like Serial No, Lot or Guarantee Date) | ||
| m_attributeset | isinstanceattribute | bpchar | 1 | 'N'::bpchar | The product attribute is specific to the instance (like Serial No, Lot or Guarantee Date) | ||
| m_inoutline | isinvoiced | bpchar | 1 | 'N'::bpchar | Is this invoiced? | ||
| m_product | isinvoiceprintdetails | bpchar | 1 | 'N'::bpchar | Print detail BOM elements on the invoice | ||
| m_product | iskanban | bpchar | 1 | 'N'::bpchar | This part is Kanban controlled | ||
| m_attributeset | islot | bpchar | 1 | 'Y'::bpchar | The product instances have a Lot Number | ||
| m_attributeset | islotmandatory | bpchar | 1 | 'N'::bpchar | The entry of Lot info is mandatory when creating a Product Instance | ||
| m_attribute | ismandatory | bpchar | 1 | 'N'::bpchar | Data entry is required in this column | ||
| m_transactionallocation | ismanual | bpchar | 1 | 'N'::bpchar | This is a manual process | ||
| m_product | ismanufactured | bpchar | 1 | 'N'::bpchar | This product is manufactured | ||
| c_bpartner | ismanufacturer | bpchar | 1 | √ | 'N'::bpchar | Indicate role of this Business partner as Manufacturer | |
| c_bpartner_product | ismanufacturer | bpchar | 1 | 'N'::bpchar | Indicate role of this Business partner as Manufacturer | ||
| c_bpartner | isonetime | bpchar | 1 | 'N'::bpchar | One time transaction | ||
| m_product | isownbox | bpchar | 1 | 'N'::bpchar | Own Box | ||
| a_asset | isowned | bpchar | 1 | 'Y'::bpchar | The asset is owned by the organization | ||
| ad_table | ispartition | bpchar | 1 | 'N'::bpchar | This is a partitioned table | ||
| m_product | isphantom | bpchar | 1 | √ | 'N'::bpchar | Phantom Component | |
| m_product | ispicklistprintdetails | bpchar | 1 | 'N'::bpchar | Print detail BOM elements on the pick list | ||
| c_bpartner | ispotaxexempt | bpchar | 1 | 'N'::bpchar | Business partner is exempt from tax on purchases | ||
| c_invoiceline | isprinted | bpchar | 1 | 'Y'::bpchar | Indicates if this document / line is printed | ||
| c_bpartner | isprospect | bpchar | 1 | 'N'::bpchar | Indicates this is a Prospect | ||
| m_product | ispurchased | bpchar | 1 | 'Y'::bpchar | Organization purchases this product | ||
| c_bpartner | issalesrep | bpchar | 1 | 'N'::bpchar | Indicates if the business partner is a sales representative or company agent | ||
| ad_table | issecurityenabled | bpchar | 1 | 'N'::bpchar | If security is enabled, user access to data can be restricted via Roles | ||
| m_product | isselfservice | bpchar | 1 | 'Y'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
| m_attributeset | isserno | bpchar | 1 | 'Y'::bpchar | The product instances have Serial Numbers | ||
| m_attributeset | issernomandatory | bpchar | 1 | 'N'::bpchar | The entry of a Serial No is mandatory when creating a Product Instance | ||
| ad_table | isshowindrilloptions | bpchar | 1 | √ | 'Y'::bpchar | This parameter enables the table to be displayed in Drill Assistant - Table tab | |
| m_product | issold | bpchar | 1 | 'Y'::bpchar | Organization sells this product | ||
| m_attributesetexclude | issotrx | bpchar | 1 | 'Y'::bpchar | This is a Sales Transaction | ||
| m_lotctlexclude | issotrx | bpchar | 1 | 'N'::bpchar | This is a Sales Transaction | ||
| m_sernoctlexclude | issotrx | bpchar | 1 | 'N'::bpchar | This is a Sales Transaction | ||
| m_storagereservation | issotrx | bpchar | 1 | 'Y'::bpchar | This is a Sales Transaction | ||
| m_product | isstocked | bpchar | 1 | 'Y'::bpchar | Organization stocks this product | ||
| c_bpartner | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
| m_product | issummary | bpchar | 1 | 'N'::bpchar | This is a summary entity | ||
| c_bpartner | istaxexempt | bpchar | 1 | √ | 'N'::bpchar | Business partner is exempt from tax on sales | |
| m_product | istoformule | bpchar | 1 | √ | null | ||
| c_bpartner | isvendor | bpchar | 1 | 'N'::bpchar | Indicates if this Business Partner is a Vendor | ||
| m_product | isverified | bpchar | 1 | 'N'::bpchar | The BOM configuration has been verified | ||
| ad_table | isview | bpchar | 1 | 'N'::bpchar | This is a view | ||
| m_product | iswebstorefeatured | bpchar | 1 | 'N'::bpchar | If selected, the product is displayed in the initial or any empty search | ||
| m_attributeset | lotchareoverwrite | bpchar | 1 | √ | null | Lot/Batch End Indicator overwrite - default » | |
| m_attributeset | lotcharsoverwrite | bpchar | 1 | √ | null | Lot/Batch Start Indicator overwrite - default « | |
| m_attributeset | mandatorytype | bpchar | 1 | 'N'::bpchar | The specification of a Product Attribute Instance is mandatory | ||
| c_bpartner | paymentrule | bpchar | 1 | √ | null | How you pay the invoice | |
| c_bpartner | paymentrulepo | bpchar | 1 | √ | null | Purchase payment option | |
| c_projectissue | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
| a_asset | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
| c_invoiceline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
| c_orderline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
| c_projectissue | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
| m_inoutline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
| m_inventoryline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
| m_movementline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
| m_productionline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
| a_asset | processing | bpchar | 1 | √ | 'N'::bpchar | Process Now | |
| ad_table | processing | bpchar | 1 | √ | NULL::bpchar | Process Now | |
| c_projectissue | processing | bpchar | 1 | √ | null | Process Now | |
| m_product | processing | bpchar | 1 | √ | null | Process Now | |
| m_product | producttype | bpchar | 1 | 'I'::bpchar | Type of product | ||
| c_bpartner | rating | bpchar | 1 | √ | null | Classification or Importance | |
| ad_table | replicationtype | bpchar | 1 | 'L'::bpchar | Type of Data Replication | ||
| c_bpartner | sendemail | bpchar | 1 | 'N'::bpchar | Enable sending Document EMail | ||
| m_attributeset | sernochareoverwrite | bpchar | 1 | √ | null | Serial Number End Indicator overwrite - default empty | |
| m_attributeset | sernocharsoverwrite | bpchar | 1 | √ | null | Serial Number Start Indicator overwrite - default # | |
| c_bpartner | socreditstatus | bpchar | 1 | √ | 'O'::bpchar | Business Partner Credit Status | |
| m_attributeset | useguaranteedateformpolicy | bpchar | 1 | √ | 'N'::bpchar | Use Guarantee Date for Material Policy | |
| c_projectissue | docaction | bpchar | 2 | 'CO'::bpchar | The targeted status of the document | ||
| m_transaction | movementtype | bpchar | 2 | Method of moving the inventory | |||
| a_asset | a_qty_current | numeric | 0 | √ | null | Current Qty | |
| a_asset | a_qty_original | numeric | 0 | √ | null | A_QTY_Original | |
| c_bpartner | acqusitioncost | numeric | 0 | √ | 0 | The cost of gaining the prospect as a customer | |
| c_bpartner | actuallifetimevalue | numeric | 0 | √ | 0 | Actual Life Time Revenue | |
| m_inoutline | confirmedqty | numeric | 0 | √ | 0 | Confirmation of a received quantity | |
| m_movementline | confirmedqty | numeric | 0 | √ | 0 | Confirmation of a received quantity | |
| m_inventoryline | currentcostprice | numeric | 0 | √ | (0)::numeric | The currently used cost price | |
| c_orderline | discount | numeric | 0 | √ | null | Discount in percent | |
| c_bpartner | flatdiscount | numeric | 0 | √ | null | Flat discount percentage | |
| c_orderline | freightamt | numeric | 0 | 0 | Freight Amount | ||
| a_asset | lifeuseunits | numeric | 0 | √ | null | Units of use until the asset is not usable anymore | |
| c_invoiceline | linenetamt | numeric | 0 | 0 | Line Extended Amount (Quantity * Actual Price) without Freight and Charges | ||
| c_orderline | linenetamt | numeric | 0 | 0 | Line Extended Amount (Quantity * Actual Price) without Freight and Charges | ||
| c_invoiceline | linetotalamt | numeric | 0 | √ | 0 | Total line amount incl. Tax | |
| c_projectissue | movementqty | numeric | 0 | 0 | Quantity of a product moved. | ||
| m_inoutline | movementqty | numeric | 0 | 0 | Quantity of a product moved. | ||
| m_movementline | movementqty | numeric | 0 | 0 | Quantity of a product moved. | ||
| m_productionline | movementqty | numeric | 0 | 0 | Quantity of a product moved. | ||
| m_transaction | movementqty | numeric | 0 | 0 | Quantity of a product moved. | ||
| m_inventoryline | newcostprice | numeric | 0 | √ | (0)::numeric | New current cost price after processing of M_CostDetail | |
| m_inoutline | pickedqty | numeric | 0 | √ | 0 | Picked Quantity | |
| m_productionline | plannedqty | numeric | 0 | √ | null | Planned quantity for this project | |
| c_bpartner | potentiallifetimevalue | numeric | 0 | √ | 0 | Total Revenue expected | |
| c_invoiceline | priceactual | numeric | 0 | 0 | Actual Price | ||
| c_orderline | priceactual | numeric | 0 | 0 | Actual Price | ||
| c_orderline | pricecost | numeric | 0 | √ | null | Price per Unit of Measure including all indirect costs (Freight, etc.) | |
| c_invoiceline | priceentered | numeric | 0 | Price Entered - the price based on the selected/base UoM | |||
| c_orderline | priceentered | numeric | 0 | Price Entered - the price based on the selected/base UoM | |||
| c_invoiceline | pricelimit | numeric | 0 | 0 | Lowest price for a product | ||
| c_orderline | pricelimit | numeric | 0 | 0 | Lowest price for a product | ||
| c_invoiceline | pricelist | numeric | 0 | 0 | List Price | ||
| c_orderline | pricelist | numeric | 0 | 0 | List Price | ||
| c_projectissue | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
| a_asset | qty | numeric | 0 | √ | null | Quantity | |
| m_storagereservation | qty | numeric | 0 | Quantity | |||
| m_transactionallocation | qty | numeric | 0 | 0 | Quantity | ||
| m_inventoryline | qtybook | numeric | 0 | 0 | Book Quantity | ||
| m_inventoryline | qtycount | numeric | 0 | 0 | Counted Quantity | ||
| m_inventoryline | qtycsv | numeric | 0 | 0 | Qty Csv | ||
| c_orderline | qtydelivered | numeric | 0 | 0 | Delivered Quantity | ||
| c_invoiceline | qtyentered | numeric | 0 | The Quantity Entered is based on the selected UoM | |||
| c_orderline | qtyentered | numeric | 0 | The Quantity Entered is based on the selected UoM | |||
| m_inoutline | qtyentered | numeric | 0 | The Quantity Entered is based on the selected UoM | |||
| m_inventoryline | qtyinternaluse | numeric | 0 | √ | null | Internal Use Quantity removed from Inventory | |
| c_invoiceline | qtyinvoiced | numeric | 0 | 0 | Invoiced Quantity | ||
| c_orderline | qtyinvoiced | numeric | 0 | 0 | Invoiced Quantity | ||
| c_orderline | qtylostsales | numeric | 0 | 0 | Quantity of potential sales | ||
| m_storage | qtyonhand | numeric | 0 | √ | null | On Hand Quantity | |
| m_storageonhand | qtyonhand | numeric | 0 | On Hand Quantity | |||
| c_orderline | qtyordered | numeric | 0 | 0 | Ordered Quantity | ||
| m_storage | qtyordered | numeric | 0 | √ | null | Ordered Quantity | |
| m_inoutline | qtyoverreceipt | numeric | 0 | √ | 0 | Over Receipt Quantity | |
| c_orderline | qtyreserved | numeric | 0 | 0 | Reserved Quantity | ||
| m_storage | qtyreserved | numeric | 0 | √ | null | Reserved Quantity | |
| m_productionline | qtyused | numeric | 0 | √ | null | Quantity Used | |
| c_bpartner_product | qualityrating | numeric | 0 | √ | null | Method for rating vendors | |
| c_invoiceline | rramt | numeric | 0 | √ | null | Revenue Recognition Amount | |
| c_orderline | rramt | numeric | 0 | √ | null | Revenue Recognition Amount | |
| m_inoutline | scrappedqty | numeric | 0 | √ | 0 | The Quantity scrapped due to QA issues | |
| m_movementline | scrappedqty | numeric | 0 | √ | 0 | The Quantity scrapped due to QA issues | |
| m_product | shelfheight | numeric | 0 | √ | null | Shelf height required | |
| c_bpartner | so_creditlimit | numeric | 0 | √ | 0 | Total outstanding invoice amounts allowed | |
| c_bpartner | so_creditused | numeric | 0 | √ | 0 | Current open balance | |
| m_inoutline | targetqty | numeric | 0 | √ | 0 | Target Movement Quantity | |
| m_movementline | targetqty | numeric | 0 | √ | 0 | Target Movement Quantity | |
| c_invoiceline | taxamt | numeric | 0 | √ | 0 | Tax Amount for a document | |
| c_bpartner | totalopenbalance | numeric | 0 | √ | null | Total Open Balance Amount in primary Accounting Currency | |
| m_product | unitsperpallet | numeric | 0 | √ | null | Units Per Pallet | |
| a_asset | uselifeyears | numeric | 0 | √ | null | Years of the usable life of the asset | |
| a_asset | useunits | numeric | 0 | √ | null | Currently used units of the assets | |
| m_attributeinstance | valuenumber | numeric | 0 | √ | null | Numeric Value | |
| m_product | volume | numeric | 0 | √ | 0 | Volume of a product | |
| m_product | weight | numeric | 0 | √ | 0 | Weight of a product | |
| a_asset | a_asset_class_id | numeric | 10 | √ | NULL::numeric | Asset class | |
| a_asset | a_asset_group_id | numeric | 10 | Group of Assets | |||
| c_invoiceline | a_asset_group_id | numeric | 10 | √ | null | Group of Assets | |
| a_asset | a_asset_id | numeric | 10 | Asset used internally or by customers | |||
| c_invoiceline | a_asset_id | numeric | 10 | √ | null | Asset used internally or by customers | |
| a_asset | a_asset_type_id | numeric | 10 | √ | null | Asset Type | |
| a_asset | a_parent_asset_id | numeric | 10 | √ | null | Parent Asset | |
| a_asset | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| ad_table | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_bpartner | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_bpartner_product | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_invoiceline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_orderline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_projectissue | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_rfqline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_attribute | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_attributeinstance | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_attributesearch | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_attributeset | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_attributesetexclude | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_attributesetinstance | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_attributeuse | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_attributevalue | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_inoutline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_inventoryline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_lot | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_lotctl | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_lotctlexclude | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_movementline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_product | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_productionline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_sernoctl | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_sernoctlexclude | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_storage | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
| m_storageonhand | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_storagereservation | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_transaction | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_transactionallocation | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| a_asset | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| ad_table | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_bpartner | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_bpartner_product | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_invoiceline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_orderline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_projectissue | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_rfqline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_attribute | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_attributeinstance | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_attributesearch | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_attributeset | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_attributesetexclude | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_attributesetinstance | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_attributeuse | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_attributevalue | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_inoutline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_inventoryline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_lot | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_lotctl | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_lotctlexclude | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_movementline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_product | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_productionline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_sernoctl | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_sernoctlexclude | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_storage | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
| m_storageonhand | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_storagereservation | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_transaction | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_transactionallocation | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_bpartner | ad_orgbp_id | numeric | 10 | √ | null | The Business Partner is another Organization for explicit Inter-Org transactions | |
| c_invoiceline | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
| c_orderline | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
| m_inoutline | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
| m_attribute | ad_reference_id | numeric | 10 | √ | NULL::numeric | System Reference and Validation | |
| m_attribute | ad_reference_value_id | numeric | 10 | √ | NULL::numeric | Required to specify, if data type is Table or List | |
| ad_table | ad_table_id | numeric | 10 | Database Table information | |||
| m_attributesetexclude | ad_table_id | numeric | 10 | Database Table information | |||
| m_lotctlexclude | ad_table_id | numeric | 10 | Database Table information | |||
| m_sernoctlexclude | ad_table_id | numeric | 10 | Database Table information | |||
| a_asset | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
| ad_table | ad_val_rule_id | numeric | 10 | √ | null | Dynamic Validation Rule | |
| m_attribute | ad_val_rule_id | numeric | 10 | √ | NULL::numeric | Dynamic Validation Rule | |
| ad_table | ad_window_id | numeric | 10 | √ | null | Data entry or display window | |
| c_bpartner | bpartner_parent_id | numeric | 10 | √ | null | Business Partner Parent | |
| c_invoiceline | c_1099box_id | numeric | 10 | √ | NULL::numeric | 1099 Box | |
| a_asset | c_activity_id | numeric | 10 | √ | NULL::numeric | Business Activity | |
| c_invoiceline | c_activity_id | numeric | 10 | √ | null | Business Activity | |
| c_orderline | c_activity_id | numeric | 10 | √ | null | Business Activity | |
| m_inoutline | c_activity_id | numeric | 10 | √ | null | Business Activity | |
| c_bpartner | c_bp_group_id | numeric | 10 | Business Partner Group | |||
| a_asset | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
| c_bpartner | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
| c_bpartner_product | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
| c_orderline | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
| a_asset | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
| c_orderline | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
| a_asset | c_bpartnersr_id | numeric | 10 | √ | null | Business Partner (Agent or Sales Rep) | |
| c_invoiceline | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
| c_orderline | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
| m_inoutline | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
| c_invoiceline | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
| c_orderline | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
| m_inoutline | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
| m_inventoryline | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
| c_orderline | c_currency_id | numeric | 10 | The Currency for this record | |||
| c_bpartner | c_dunning_id | numeric | 10 | √ | null | Dunning Rules for overdue invoices | |
| c_bpartner | c_greeting_id | numeric | 10 | √ | null | Greeting to print on correspondence | |
| c_invoiceline | c_invoice_id | numeric | 10 | Invoice Identifier | |||
| c_invoiceline | c_invoiceline_id | numeric | 10 | Invoice Detail Line | |||
| c_bpartner | c_invoiceschedule_id | numeric | 10 | √ | null | Schedule for generating Invoices | |
| a_asset | c_location_id | numeric | 10 | √ | null | Location or Address | |
| c_orderline | c_order_id | numeric | 10 | Order | |||
| c_invoiceline | c_orderline_id | numeric | 10 | √ | null | Sales Order Line | |
| c_orderline | c_orderline_id | numeric | 10 | Sales Order Line | |||
| m_inoutline | c_orderline_id | numeric | 10 | √ | null | Sales Order Line | |
| c_bpartner | c_paymentterm_id | numeric | 10 | √ | null | The terms of Payment (timing, discount) | |
| a_asset | c_project_id | numeric | 10 | √ | null | Financial Project | |
| c_invoiceline | c_project_id | numeric | 10 | √ | null | Financial Project | |
| c_orderline | c_project_id | numeric | 10 | √ | null | Financial Project | |
| c_projectissue | c_project_id | numeric | 10 | Financial Project | |||
| m_inoutline | c_project_id | numeric | 10 | √ | null | Financial Project | |
| c_projectissue | c_projectissue_id | numeric | 10 | Project Issues (Material, Labor) | |||
| m_transaction | c_projectissue_id | numeric | 10 | √ | null | Project Issues (Material, Labor) | |
| c_invoiceline | c_projectphase_id | numeric | 10 | √ | null | Phase of a Project | |
| c_orderline | c_projectphase_id | numeric | 10 | √ | null | Phase of a Project | |
| m_inoutline | c_projectphase_id | numeric | 10 | √ | null | Phase of a Project | |
| c_invoiceline | c_projecttask_id | numeric | 10 | √ | null | Actual Project Task in a Phase | |
| c_orderline | c_projecttask_id | numeric | 10 | √ | null | Actual Project Task in a Phase | |
| m_inoutline | c_projecttask_id | numeric | 10 | √ | null | Actual Project Task in a Phase | |
| m_product | c_revenuerecognition_id | numeric | 10 | √ | null | Method for recording revenue | |
| c_rfqline | c_rfq_id | numeric | 10 | Request for Quotation | |||
| c_rfqline | c_rfqline_id | numeric | 10 | Request for Quotation Line | |||
| m_product | c_subscriptiontype_id | numeric | 10 | √ | null | Type of subscription | |
| c_invoiceline | c_tax_id | numeric | 10 | √ | null | Tax identifier | |
| c_orderline | c_tax_id | numeric | 10 | Tax identifier | |||
| m_product | c_taxcategory_id | numeric | 10 | Tax Category | |||
| c_bpartner | c_taxgroup_id | numeric | 10 | √ | null | Tax Group | |
| c_invoiceline | c_uom_id | numeric | 10 | √ | null | Unit of Measure | |
| c_orderline | c_uom_id | numeric | 10 | Unit of Measure | |||
| m_inoutline | c_uom_id | numeric | 10 | Unit of Measure | |||
| m_product | c_uom_id | numeric | 10 | Unit of Measure | |||
| a_asset | createdby | numeric | 10 | User who created this records | |||
| ad_table | createdby | numeric | 10 | User who created this records | |||
| c_bpartner | createdby | numeric | 10 | User who created this records | |||
| c_bpartner_product | createdby | numeric | 10 | User who created this records | |||
| c_invoiceline | createdby | numeric | 10 | User who created this records | |||
| c_orderline | createdby | numeric | 10 | User who created this records | |||
| c_projectissue | createdby | numeric | 10 | User who created this records | |||
| c_rfqline | createdby | numeric | 10 | User who created this records | |||
| m_attribute | createdby | numeric | 10 | User who created this records | |||
| m_attributeinstance | createdby | numeric | 10 | User who created this records | |||
| m_attributesearch | createdby | numeric | 10 | User who created this records | |||
| m_attributeset | createdby | numeric | 10 | User who created this records | |||
| m_attributesetexclude | createdby | numeric | 10 | User who created this records | |||
| m_attributesetinstance | createdby | numeric | 10 | User who created this records | |||
| m_attributeuse | createdby | numeric | 10 | User who created this records | |||
| m_attributevalue | createdby | numeric | 10 | User who created this records | |||
| m_inoutline | createdby | numeric | 10 | User who created this records | |||
| m_inventoryline | createdby | numeric | 10 | User who created this records | |||
| m_lot | createdby | numeric | 10 | User who created this records | |||
| m_lotctl | createdby | numeric | 10 | User who created this records | |||
| m_lotctlexclude | createdby | numeric | 10 | User who created this records | |||
| m_movementline | createdby | numeric | 10 | User who created this records | |||
| m_product | createdby | numeric | 10 | User who created this records | |||
| m_productionline | createdby | numeric | 10 | User who created this records | |||
| m_sernoctl | createdby | numeric | 10 | User who created this records | |||
| m_sernoctlexclude | createdby | numeric | 10 | User who created this records | |||
| m_storage | createdby | numeric | 10 | √ | null | User who created this records | |
| m_storageonhand | createdby | numeric | 10 | User who created this records | |||
| m_storagereservation | createdby | numeric | 10 | User who created this records | |||
| m_transaction | createdby | numeric | 10 | User who created this records | |||
| m_transactionallocation | createdby | numeric | 10 | User who created this records | |||
| m_lotctl | currentnext | numeric | 10 | The next number to be used | |||
| m_sernoctl | currentnext | numeric | 10 | The next number to be used | |||
| m_movementline | dd_orderline_id | numeric | 10 | √ | null | Distribution Order Line | |
| c_bpartner | default1099box_id | numeric | 10 | √ | NULL::numeric | Default 1099 Box | |
| c_rfqline | deliverydays | numeric | 10 | √ | 0 | Number of Days (planned) until Delivery | |
| c_bpartner | documentcopies | numeric | 10 | √ | null | Number of copies to be printed | |
| m_attributeset | guaranteedays | numeric | 10 | √ | null | Number of days the product is guaranteed or available | |
| m_product | guaranteedays | numeric | 10 | √ | null | Number of days the product is guaranteed or available | |
| m_product | guaranteedaysmin | numeric | 10 | √ | null | Minimum number of guarantee days | |
| m_lotctl | incrementno | numeric | 10 | The number to increment the last document number by | |||
| m_sernoctl | incrementno | numeric | 10 | The number to increment the last document number by | |||
| c_bpartner | invoice_printformat_id | numeric | 10 | √ | null | Print Format for printing Invoices | |
| a_asset | lastmaintenanceunit | numeric | 10 | √ | null | Last Maintenance Unit | |
| a_asset | lastmaintenanceuseunit | numeric | 10 | √ | null | ||
| a_asset | lease_bpartner_id | numeric | 10 | √ | null | The Business Partner who rents or leases | |
| c_invoiceline | line | numeric | 10 | Unique line for this document | |||
| c_orderline | line | numeric | 10 | Unique line for this document | |||
| c_projectissue | line | numeric | 10 | Unique line for this document | |||
| c_rfqline | line | numeric | 10 | 0 | Unique line for this document | ||
| m_inoutline | line | numeric | 10 | Unique line for this document | |||
| m_inventoryline | line | numeric | 10 | √ | null | Unique line for this document | |
| m_movementline | line | numeric | 10 | √ | null | Unique line for this document | |
| m_productionline | line | numeric | 10 | Unique line for this document | |||
| c_orderline | link_orderline_id | numeric | 10 | √ | null | This field links a sales order line to the purchase order line that is generated from it. | |
| ad_table | loadseq | numeric | 10 | √ | null | Sequence | |
| c_bpartner | logo_id | numeric | 10 | √ | NULL::numeric | Logo | |
| m_product | lowlevel | numeric | 10 | (0)::numeric | The Low Level is used to calculate the material plan and determines if a net requirement should be exploited | ||
| m_attribute | m_attribute_id | numeric | 10 | Product Attribute | |||
| m_attributeinstance | m_attribute_id | numeric | 10 | Product Attribute | |||
| m_attributeuse | m_attribute_id | numeric | 10 | Product Attribute | |||
| m_attributevalue | m_attribute_id | numeric | 10 | Product Attribute | |||
| m_attribute | m_attributesearch_id | numeric | 10 | √ | null | Common Search Attribute | |
| m_attributesearch | m_attributesearch_id | numeric | 10 | Common Search Attribute | |||
| m_attributeset | m_attributeset_id | numeric | 10 | Product Attribute Set | |||
| m_attributesetexclude | m_attributeset_id | numeric | 10 | Product Attribute Set | |||
| m_attributesetinstance | m_attributeset_id | numeric | 10 | √ | null | Product Attribute Set | |
| m_attributeuse | m_attributeset_id | numeric | 10 | Product Attribute Set | |||
| m_product | m_attributeset_id | numeric | 10 | √ | null | Product Attribute Set | |
| m_attributesetexclude | m_attributesetexclude_id | numeric | 10 | Exclude the ability to enter Attribute Sets | |||
| a_asset | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
| c_invoiceline | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
| c_orderline | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
| c_projectissue | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
| c_rfqline | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
| m_attributeinstance | m_attributesetinstance_id | numeric | 10 | 0 | Product Attribute Set Instance | ||
| m_attributesetinstance | m_attributesetinstance_id | numeric | 10 | Product Attribute Set Instance | |||
| m_inoutline | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
| m_inventoryline | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
| m_movementline | m_attributesetinstance_id | numeric | 10 | √ | null | Product Attribute Set Instance | |
| m_product | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
| m_productionline | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
| m_storage | m_attributesetinstance_id | numeric | 10 | √ | null | Product Attribute Set Instance | |
| m_storageonhand | m_attributesetinstance_id | numeric | 10 | Product Attribute Set Instance | |||
| m_storagereservation | m_attributesetinstance_id | numeric | 10 | Product Attribute Set Instance | |||
| m_transaction | m_attributesetinstance_id | numeric | 10 | 0 | Product Attribute Set Instance | ||
| m_transactionallocation | m_attributesetinstance_id | numeric | 10 | 0 | Product Attribute Set Instance | ||
| m_movementline | m_attributesetinstanceto_id | numeric | 10 | √ | null | Target Product Attribute Set Instance | |
| m_attributeinstance | m_attributevalue_id | numeric | 10 | √ | null | Product Attribute Value | |
| m_attributevalue | m_attributevalue_id | numeric | 10 | Product Attribute Value | |||
| c_bpartner | m_discountschema_id | numeric | 10 | √ | null | Schema to calculate the trade discount percentage | |
| m_product | m_freightcategory_id | numeric | 10 | √ | null | Category of the Freight | |
| m_inoutline | m_inout_id | numeric | 10 | Material Shipment Document | |||
| a_asset | m_inoutline_id | numeric | 10 | √ | null | Line on Shipment or Receipt document | |
| c_invoiceline | m_inoutline_id | numeric | 10 | √ | null | Line on Shipment or Receipt document | |
| c_projectissue | m_inoutline_id | numeric | 10 | √ | null | Line on Shipment or Receipt document | |
| m_inoutline | m_inoutline_id | numeric | 10 | Line on Shipment or Receipt document | |||
| m_transaction | m_inoutline_id | numeric | 10 | √ | null | Line on Shipment or Receipt document | |
| m_transactionallocation | m_inoutline_id | numeric | 10 | √ | null | Line on Shipment or Receipt document | |
| m_inventoryline | m_inventory_id | numeric | 10 | Parameters for a Physical Inventory | |||
| m_inventoryline | m_inventoryline_id | numeric | 10 | Unique line in an Inventory document | |||
| m_transaction | m_inventoryline_id | numeric | 10 | √ | null | Unique line in an Inventory document | |
| m_transactionallocation | m_inventoryline_id | numeric | 10 | √ | null | Unique line in an Inventory document | |
| a_asset | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
| c_projectissue | m_locator_id | numeric | 10 | Warehouse Locator | |||
| m_inoutline | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
| m_inventoryline | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
| m_movementline | m_locator_id | numeric | 10 | Warehouse Locator | |||
| m_product | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
| m_productionline | m_locator_id | numeric | 10 | Warehouse Locator | |||
| m_storage | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
| m_storageonhand | m_locator_id | numeric | 10 | Warehouse Locator | |||
| m_transaction | m_locator_id | numeric | 10 | Warehouse Locator | |||
| m_movementline | m_locatorto_id | numeric | 10 | Location inventory is moved to | |||
| m_attributesetinstance | m_lot_id | numeric | 10 | √ | null | Product Lot Definition | |
| m_lot | m_lot_id | numeric | 10 | Product Lot Definition | |||
| m_attributeset | m_lotctl_id | numeric | 10 | √ | null | Product Lot Control | |
| m_lot | m_lotctl_id | numeric | 10 | √ | null | Product Lot Control | |
| m_lotctl | m_lotctl_id | numeric | 10 | Product Lot Control | |||
| m_lotctlexclude | m_lotctl_id | numeric | 10 | Product Lot Control | |||
| m_lotctlexclude | m_lotctlexclude_id | numeric | 10 | Exclude the ability to create Lots in Attribute Sets | |||
| m_movementline | m_movement_id | numeric | 10 | Movement of Inventory | |||
| m_movementline | m_movementline_id | numeric | 10 | Inventory Move document Line | |||
| m_transaction | m_movementline_id | numeric | 10 | √ | null | Inventory Move document Line | |
| m_product | m_parttype_id | numeric | 10 | √ | NULL::numeric | Part Type | |
| c_bpartner | m_pricelist_id | numeric | 10 | √ | null | Unique identifier of a Price List | |
| m_product | m_product_category_id | numeric | 10 | Category of a Product | |||
| a_asset | m_product_id | numeric | 10 | Product, Service, Item | |||
| c_bpartner_product | m_product_id | numeric | 10 | Product, Service, Item | |||
| c_invoiceline | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
| c_orderline | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
| c_projectissue | m_product_id | numeric | 10 | Product, Service, Item | |||
| c_rfqline | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
| m_inoutline | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
| m_inventoryline | m_product_id | numeric | 10 | Product, Service, Item | |||
| m_lot | m_product_id | numeric | 10 | Product, Service, Item | |||
| m_movementline | m_product_id | numeric | 10 | Product, Service, Item | |||
| m_product | m_product_id | numeric | 10 | Product, Service, Item | |||
| m_productionline | m_product_id | numeric | 10 | Product, Service, Item | |||
| m_storage | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
| m_storageonhand | m_product_id | numeric | 10 | Product, Service, Item | |||
| m_storagereservation | m_product_id | numeric | 10 | Product, Service, Item | |||
| m_transaction | m_product_id | numeric | 10 | Product, Service, Item | |||
| m_transactionallocation | m_product_id | numeric | 10 | Product, Service, Item | |||
| m_productionline | m_production_id | numeric | 10 | √ | null | Plan for producing a product | |
| m_productionline | m_productionline_id | numeric | 10 | Document Line representing a production | |||
| m_transaction | m_productionline_id | numeric | 10 | √ | null | Document Line representing a production | |
| m_transactionallocation | m_productionline_id | numeric | 10 | √ | null | Document Line representing a production | |
| m_productionline | m_productionplan_id | numeric | 10 | √ | null | Plan for how a product is produced | |
| c_orderline | m_promotion_id | numeric | 10 | √ | null | Promotion | |
| c_invoiceline | m_rmaline_id | numeric | 10 | √ | null | Return Material Authorization Line | |
| m_inoutline | m_rmaline_id | numeric | 10 | √ | null | Return Material Authorization Line | |
| m_attributeset | m_sernoctl_id | numeric | 10 | √ | null | Product Serial Number Control | |
| m_sernoctl | m_sernoctl_id | numeric | 10 | Product Serial Number Control | |||
| m_sernoctlexclude | m_sernoctl_id | numeric | 10 | Product Serial Number Control | |||
| m_sernoctlexclude | m_sernoctlexclude_id | numeric | 10 | Exclude the ability to create Serial Numbers in Attribute Sets | |||
| c_orderline | m_shipper_id | numeric | 10 | √ | null | Method or manner of product delivery | |
| m_transaction | m_transaction_id | numeric | 10 | Inventory Transaction | |||
| m_transactionallocation | m_transaction_id | numeric | 10 | Inventory Transaction | |||
| c_orderline | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
| m_storagereservation | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
| a_asset | manufacturedyear | numeric | 10 | √ | NULL::numeric | Manufactured Year | |
| a_asset | nextmaintenanceuseunit | numeric | 10 | √ | null | ||
| a_asset | nextmaintenenceunit | numeric | 10 | √ | null | Next Maintenence Unit | |
| c_bpartner | numberemployees | numeric | 10 | √ | null | Number of employees | |
| m_transactionallocation | out_m_inoutline_id | numeric | 10 | √ | null | Outgoing Shipment/Receipt | |
| m_transactionallocation | out_m_inventoryline_id | numeric | 10 | √ | null | Outgoing Inventory Line | |
| m_transactionallocation | out_m_productionline_id | numeric | 10 | √ | null | Outgoing Production Line | |
| m_transactionallocation | out_m_transaction_id | numeric | 10 | √ | null | Outgoing Transaction | |
| c_bpartner | po_discountschema_id | numeric | 10 | √ | null | Schema to calculate the purchase trade discount percentage | |
| c_bpartner | po_paymentterm_id | numeric | 10 | √ | null | Payment rules for a purchase order | |
| c_bpartner | po_pricelist_id | numeric | 10 | √ | null | Price List used by this Business Partner | |
| ad_table | po_window_id | numeric | 10 | √ | null | Purchase Order Window | |
| c_orderline | pp_cost_collector_id | numeric | 10 | √ | null | Manufacturing Cost Collector | |
| m_transaction | pp_cost_collector_id | numeric | 10 | √ | null | Manufacturing Cost Collector | |
| m_product | r_mailtext_id | numeric | 10 | √ | null | Text templates for mailings | |
| m_inoutline | ref_inoutline_id | numeric | 10 | √ | null | Referenced Shipment Line | |
| c_invoiceline | ref_invoiceline_id | numeric | 10 | √ | null | Referenced Invoice Line | |
| c_orderline | ref_orderline_id | numeric | 10 | √ | null | Reference to corresponding Sales/Purchase Order | |
| c_projectissue | reversal_id | numeric | 10 | √ | null | ID of document reversal | |
| m_inoutline | reversalline_id | numeric | 10 | √ | null | Use to keep the reversal line ID for reversing costing purpose | |
| m_inventoryline | reversalline_id | numeric | 10 | √ | null | Use to keep the reversal line ID for reversing costing purpose | |
| m_movementline | reversalline_id | numeric | 10 | √ | null | Use to keep the reversal line ID for reversing costing purpose | |
| m_product | s_expensetype_id | numeric | 10 | √ | null | Expense report type | |
| m_product | s_resource_id | numeric | 10 | √ | null | Resource | |
| c_invoiceline | s_resourceassignment_id | numeric | 10 | √ | null | Resource Assignment | |
| c_orderline | s_resourceassignment_id | numeric | 10 | √ | null | Resource Assignment | |
| c_projectissue | s_timeexpenseline_id | numeric | 10 | √ | null | Time and Expense Report Line | |
| c_bpartner | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
| m_product | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
| c_bpartner | salesvolume | numeric | 10 | √ | null | Total Volume of Sales in Thousands of Currency | |
| m_attributeuse | seqno | numeric | 10 | Method of ordering records; lowest number comes first | |||
| c_bpartner | shareofcustomer | numeric | 10 | √ | null | Share of Customer's business as a percentage | |
| m_product | shelfdepth | numeric | 10 | √ | null | Shelf depth required | |
| c_bpartner_product | shelflifemindays | numeric | 10 | Minimum Shelf Life in days based on Product Instance Guarantee Date | |||
| c_bpartner | shelflifeminpct | numeric | 10 | √ | null | Minimum Shelf Life in percent based on Product Instance Guarantee Date | |
| c_bpartner_product | shelflifeminpct | numeric | 10 | Minimum Shelf Life in percent based on Product Instance Guarantee Date | |||
| m_product | shelfwidth | numeric | 10 | √ | null | Shelf width required | |
| m_lotctl | startno | numeric | 10 | Starting number/position | |||
| m_sernoctl | startno | numeric | 10 | Starting number/position | |||
| m_product | unitsperpack | numeric | 10 | 1 | The Units Per Pack indicates the no of units of a product packed together. | ||
| a_asset | updatedby | numeric | 10 | User who updated this records | |||
| ad_table | updatedby | numeric | 10 | User who updated this records | |||
| c_bpartner | updatedby | numeric | 10 | User who updated this records | |||
| c_bpartner_product | updatedby | numeric | 10 | User who updated this records | |||
| c_invoiceline | updatedby | numeric | 10 | User who updated this records | |||
| c_orderline | updatedby | numeric | 10 | User who updated this records | |||
| c_projectissue | updatedby | numeric | 10 | User who updated this records | |||
| c_rfqline | updatedby | numeric | 10 | User who updated this records | |||
| m_attribute | updatedby | numeric | 10 | User who updated this records | |||
| m_attributeinstance | updatedby | numeric | 10 | User who updated this records | |||
| m_attributesearch | updatedby | numeric | 10 | User who updated this records | |||
| m_attributeset | updatedby | numeric | 10 | User who updated this records | |||
| m_attributesetexclude | updatedby | numeric | 10 | User who updated this records | |||
| m_attributesetinstance | updatedby | numeric | 10 | User who updated this records | |||
| m_attributeuse | updatedby | numeric | 10 | User who updated this records | |||
| m_attributevalue | updatedby | numeric | 10 | User who updated this records | |||
| m_inoutline | updatedby | numeric | 10 | User who updated this records | |||
| m_inventoryline | updatedby | numeric | 10 | User who updated this records | |||
| m_lot | updatedby | numeric | 10 | User who updated this records | |||
| m_lotctl | updatedby | numeric | 10 | User who updated this records | |||
| m_lotctlexclude | updatedby | numeric | 10 | User who updated this records | |||
| m_movementline | updatedby | numeric | 10 | User who updated this records | |||
| m_product | updatedby | numeric | 10 | User who updated this records | |||
| m_productionline | updatedby | numeric | 10 | User who updated this records | |||
| m_sernoctl | updatedby | numeric | 10 | User who updated this records | |||
| m_sernoctlexclude | updatedby | numeric | 10 | User who updated this records | |||
| m_storage | updatedby | numeric | 10 | √ | null | User who updated this records | |
| m_storageonhand | updatedby | numeric | 10 | User who updated this records | |||
| m_storagereservation | updatedby | numeric | 10 | User who updated this records | |||
| m_transaction | updatedby | numeric | 10 | User who updated this records | |||
| m_transactionallocation | updatedby | numeric | 10 | User who updated this records | |||
| a_asset | uselifemonths | numeric | 10 | √ | null | Months of the usable life of the asset | |
| c_invoiceline | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
| c_orderline | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
| m_inoutline | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
| c_invoiceline | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
| c_orderline | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
| m_inoutline | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
| a_asset | a_asset_createdate | timestamp | 29,6 | √ | null | Create Date | |
| a_asset | a_asset_revaldate | timestamp | 29,6 | √ | null | Revaluation Date | |
| a_asset | assetactivationdate | timestamp | 29,6 | √ | null | Activation Date | |
| a_asset | assetdepreciationdate | timestamp | 29,6 | √ | null | Date of last depreciation | |
| a_asset | assetdisposaldate | timestamp | 29,6 | √ | null | Date when the asset is/was disposed | |
| a_asset | assetservicedate | timestamp | 29,6 | √ | null | Date when Asset was put into service | |
| a_asset | created | timestamp | 29,6 | now() | Date this record was created | ||
| ad_table | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_bpartner | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_bpartner_product | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_invoiceline | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_orderline | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_projectissue | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_rfqline | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_attribute | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_attributeinstance | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_attributesearch | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_attributeset | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_attributesetexclude | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_attributesetinstance | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_attributeuse | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_attributevalue | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_inoutline | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_inventoryline | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_lot | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_lotctl | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_lotctlexclude | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_movementline | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_product | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_productionline | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_sernoctl | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_sernoctlexclude | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_storage | created | timestamp | 29,6 | √ | null | Date this record was created | |
| m_storageonhand | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
| m_storagereservation | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
| m_transaction | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_transactionallocation | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_orderline | datedelivered | timestamp | 29,6 | √ | null | Date when the product was delivered | |
| m_lot | datefrom | timestamp | 29,6 | √ | null | Starting date for a range | |
| c_orderline | dateinvoiced | timestamp | 29,6 | √ | null | Date printed on Invoice | |
| m_storage | datelastinventory | timestamp | 29,6 | √ | null | Date of Last Inventory Count | |
| m_storageonhand | datelastinventory | timestamp | 29,6 | √ | null | Date of Last Inventory Count | |
| m_storagereservation | datelastinventory | timestamp | 29,6 | √ | null | Date of Last Inventory Count | |
| m_storage | datematerialpolicy | timestamp | 29,6 | √ | null | Time used for LIFO and FIFO Material Policy | |
| m_storageonhand | datematerialpolicy | timestamp | 29,6 | Time used for LIFO and FIFO Material Policy | |||
| c_orderline | dateordered | timestamp | 29,6 | Date of Order | |||
| c_orderline | datepromised | timestamp | 29,6 | √ | null | Date Order was promised | |
| m_lot | dateto | timestamp | 29,6 | √ | null | End date of a date range | |
| c_rfqline | dateworkcomplete | timestamp | 29,6 | √ | null | Date when work is (planned to be) complete | |
| c_rfqline | dateworkstart | timestamp | 29,6 | √ | null | Date when work is (planned to be) started | |
| m_product | discontinuedat | timestamp | 29,6 | √ | null | Discontinued At indicates Date when product was discontinued | |
| m_product | discontinuedby | timestamp | 29,6 | √ | null | ||
| c_bpartner | dunninggrace | timestamp | 29,6 | √ | null | Dunning Grace Date | |
| c_bpartner | firstsale | timestamp | 29,6 | √ | null | Date of First Sale | |
| a_asset | guaranteedate | timestamp | 29,6 | √ | null | Date when guarantee expires | |
| m_attributesetinstance | guaranteedate | timestamp | 29,6 | √ | null | Date when guarantee expires | |
| a_asset | lastmaintenancedate | timestamp | 29,6 | √ | null | Last Maintenance Date | |
| a_asset | lastmaintenencedate | timestamp | 29,6 | √ | null | ||
| a_asset | leaseterminationdate | timestamp | 29,6 | √ | null | Lease Termination Date | |
| c_projectissue | movementdate | timestamp | 29,6 | Date a product was moved in or out of inventory | |||
| m_transaction | movementdate | timestamp | 29,6 | Date a product was moved in or out of inventory | |||
| a_asset | nextmaintenencedate | timestamp | 29,6 | √ | null | Next Maintenance Date | |
| c_invoiceline | rrstartdate | timestamp | 29,6 | √ | null | Revenue Recognition Start Date | |
| c_orderline | rrstartdate | timestamp | 29,6 | √ | null | Revenue Recognition Start Date | |
| a_asset | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| ad_table | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_bpartner | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_bpartner_product | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_invoiceline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_orderline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_projectissue | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_rfqline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_attribute | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_attributeinstance | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_attributesearch | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_attributeset | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_attributesetexclude | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_attributesetinstance | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_attributeuse | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_attributevalue | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_inoutline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_inventoryline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_lot | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_lotctl | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_lotctlexclude | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_movementline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_product | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_productionline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_sernoctl | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_sernoctlexclude | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_storage | updated | timestamp | 29,6 | √ | null | Date this record was updated | |
| m_storageonhand | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
| m_storagereservation | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
| m_transaction | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_transactionallocation | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_attributeinstance | valuedate | timestamp | 29,6 | √ | null | Value Date | |
| ad_table | copycolumnsfromtable | varchar | 1 | √ | null | Copy Columns From Table | |
| a_asset | a_asset_action | varchar | 2 | 'MD'::character varying | Asset Action | ||
| a_asset | a_asset_status | varchar | 2 | 'NW'::character varying | Asset Status | ||
| c_projectissue | docstatus | varchar | 2 | 'DR'::character varying | The current status of the document | ||
| a_asset | a_assettype | varchar | 3 | 'MFX'::character varying | Asset Type | ||
| c_invoiceline | a_capvsexp | varchar | 3 | √ | null | Capital/Expense | |
| m_attributeset | m_attributeset_type | varchar | 3 | √ | 'MMS'::character varying | Attribute Set Type | |
| c_bpartner | ad_language | varchar | 6 | √ | null | Language for this entity | |
| c_bpartner | naics | varchar | 6 | √ | null | Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html | |
| m_lotctl | prefix | varchar | 10 | √ | null | Prefix before the sequence number | |
| m_sernoctl | prefix | varchar | 10 | √ | null | Prefix before the sequence number | |
| m_lotctl | suffix | varchar | 10 | √ | null | Suffix after the number | |
| m_sernoctl | suffix | varchar | 10 | √ | null | Suffix after the number | |
| c_bpartner | duns | varchar | 11 | √ | null | Dun & Bradstreet Number | |
| m_product | classification | varchar | 12 | √ | null | Classification for grouping | |
| m_product | customstariffnumber | varchar | 20 | √ | null | Customs Tariff Number, usually the HS-Code | |
| m_attribute | dateformat | varchar | 20 | √ | NULL::character varying | Date format used in the input format | |
| c_bpartner | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
| c_bpartner | taxid | varchar | 20 | √ | null | Tax Identification | |
| a_asset | versionno | varchar | 20 | √ | null | Version Number | |
| m_product | versionno | varchar | 20 | √ | null | Version Number | |
| a_asset | inventoryno | varchar | 30 | √ | NULL::character varying | Inventory No | |
| a_asset | manufacturer | varchar | 30 | √ | NULL::character varying | Manufacturer of the Product | |
| c_bpartner_product | manufacturer | varchar | 30 | √ | null | Manufacturer of the Product | |
| m_product | sku | varchar | 30 | √ | null | Stock Keeping Unit | |
| m_product | upc | varchar | 30 | √ | null | Bar Code (Universal Product Code or its superset European Article Number) | |
| c_bpartner_product | vendorcategory | varchar | 30 | √ | null | Product Category of the Business Partner | |
| c_bpartner_product | vendorproductno | varchar | 30 | √ | null | Product Key of the Business Partner | |
| a_asset | a_asset_uu | varchar | 36 | √ | NULL::character varying | A_Asset_UU | |
| ad_table | ad_table_uu | varchar | 36 | √ | NULL::character varying | AD_Table_UU | |
| c_bpartner_product | c_bpartner_product_uu | varchar | 36 | √ | NULL::character varying | C_BPartner_Product_UU | |
| c_bpartner | c_bpartner_uu | varchar | 36 | √ | NULL::character varying | C_BPartner_UU | |
| c_invoiceline | c_invoiceline_uu | varchar | 36 | √ | NULL::character varying | C_InvoiceLine_UU | |
| c_orderline | c_orderline_uu | varchar | 36 | √ | NULL::character varying | C_OrderLine_UU | |
| c_projectissue | c_projectissue_uu | varchar | 36 | √ | NULL::character varying | C_ProjectIssue_UU | |
| c_rfqline | c_rfqline_uu | varchar | 36 | √ | NULL::character varying | C_RfQLine_UU | |
| m_attribute | m_attribute_uu | varchar | 36 | √ | NULL::character varying | M_Attribute_UU | |
| m_attributeinstance | m_attributeinstance_uu | varchar | 36 | √ | NULL::character varying | M_AttributeInstance_UU | |
| m_attributesearch | m_attributesearch_uu | varchar | 36 | √ | NULL::character varying | M_AttributeSearch_UU | |
| m_attributeset | m_attributeset_uu | varchar | 36 | √ | NULL::character varying | M_AttributeSet_UU | |
| m_attributesetexclude | m_attributesetexclude_uu | varchar | 36 | √ | NULL::character varying | M_AttributeSetExclude_UU | |
| m_attributesetinstance | m_attributesetinstance_uu | varchar | 36 | √ | NULL::character varying | M_AttributeSetInstance_UU | |
| m_attributeuse | m_attributeuse_uu | varchar | 36 | √ | NULL::character varying | M_AttributeUse_UU | |
| m_attributevalue | m_attributevalue_uu | varchar | 36 | √ | NULL::character varying | M_AttributeValue_UU | |
| m_inoutline | m_inoutline_uu | varchar | 36 | √ | NULL::character varying | M_InOutLine_UU | |
| m_inventoryline | m_inventoryline_uu | varchar | 36 | √ | NULL::character varying | M_InventoryLine_UU | |
| m_lot | m_lot_uu | varchar | 36 | √ | NULL::character varying | M_Lot_UU | |
| m_lotctl | m_lotctl_uu | varchar | 36 | √ | NULL::character varying | M_LotCtl_UU | |
| m_lotctlexclude | m_lotctlexclude_uu | varchar | 36 | √ | NULL::character varying | M_LotCtlExclude_UU | |
| m_movementline | m_movementline_uu | varchar | 36 | √ | NULL::character varying | M_MovementLine_UU | |
| m_product | m_product_uu | varchar | 36 | √ | NULL::character varying | M_Product_UU | |
| m_productionline | m_productionline_uu | varchar | 36 | √ | NULL::character varying | M_ProductionLine_UU | |
| m_sernoctl | m_sernoctl_uu | varchar | 36 | √ | NULL::character varying | M_SerNoCtl_UU | |
| m_sernoctlexclude | m_sernoctlexclude_uu | varchar | 36 | √ | NULL::character varying | M_SerNoCtlExclude_UU | |
| m_storage | m_storage_uu | varchar | 36 | √ | null | M_Storage_UU | |
| m_storageonhand | m_storageonhand_uu | varchar | 36 | √ | NULL::character varying | M_StorageOnHand_UU | |
| m_storagereservation | m_storagereservation_uu | varchar | 36 | √ | NULL::character varying | M_StorageReservation_UU | |
| m_transaction | m_transaction_uu | varchar | 36 | √ | NULL::character varying | M_Transaction_UU | |
| m_transactionallocation | m_transactionallocation_uu | varchar | 36 | √ | NULL::character varying | M_TransactionAllocation_UU | |
| ad_table | entitytype | varchar | 40 | 'D'::character varying | Dictionary Entity Type; Determines ownership and synchronization | ||
| m_attributesetinstance | lot | varchar | 40 | √ | null | Lot number (alphanumeric) | |
| c_bpartner | referenceno | varchar | 40 | √ | null | Your customer or vendor number at the Business Partner's site | |
| m_attributesetinstance | serno | varchar | 40 | √ | null | Product Serial Number | |
| ad_table | tablename | varchar | 40 | Name of the table in the database | |||
| a_asset | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
| c_bpartner | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
| m_attributeinstance | value | varchar | 40 | √ | null | Search key for the record in the format required - must be unique | |
| m_attributevalue | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
| c_bpartner | customerprofileid | varchar | 60 | √ | NULL::character varying | Customer Profile ID | |
| a_asset | lastmaintenancenote | varchar | 60 | √ | null | Last Maintenance Note | |
| a_asset | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| ad_table | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| m_attribute | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| m_attributesearch | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| m_attributeset | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| m_attributevalue | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| m_lot | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| m_lotctl | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| m_sernoctl | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_bpartner | name2 | varchar | 60 | √ | null | Additional Name | |
| m_product | descriptionurl | varchar | 120 | √ | null | URL for the description | |
| m_product | downloadurl | varchar | 120 | √ | null | ||
| m_product | imageurl | varchar | 120 | √ | null | URL of image | |
| c_bpartner | name | varchar | 120 | Alphanumeric identifier of the entity | |||
| c_bpartner | url | varchar | 120 | √ | null | Full URL address - e.g. http://www.idempiere.org | |
| a_asset | description | varchar | 255 | √ | null | Optional short description of the record | |
| ad_table | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_bpartner | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_bpartner_product | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_invoiceline | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_orderline | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_projectissue | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_rfqline | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_attribute | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_attributesearch | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_attributeset | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_attributesetinstance | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_attributevalue | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_inoutline | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_inventoryline | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_lot | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_lotctl | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_movementline | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_product | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_productionline | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_sernoctl | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_product | group1 | varchar | 255 | √ | null | Group1 | |
| m_product | group2 | varchar | 255 | √ | null | Group2 | |
| a_asset | locationcomment | varchar | 255 | √ | null | Additional comments or remarks concerning the location | |
| a_asset | lot | varchar | 255 | √ | null | Lot number (alphanumeric) | |
| m_product | name | varchar | 255 | Alphanumeric identifier of the entity | |||
| a_asset | serno | varchar | 255 | √ | null | Product Serial Number | |
| c_bpartner | so_description | varchar | 255 | √ | null | Description to be used on orders | |
| m_product | value | varchar | 510 | Search key for the record in the format required - must be unique | |||
| m_product | documentnote | varchar | 2000 | √ | null | Additional information for a Document | |
| a_asset | help | varchar | 2000 | √ | null | Comment or Hint | |
| ad_table | help | varchar | 2000 | √ | null | Comment or Hint | |
| c_rfqline | help | varchar | 2000 | √ | null | Comment or Hint | |
| m_lot | help | varchar | 2000 | √ | null | Comment or Hint | |
| m_product | help | varchar | 2000 | √ | null | Comment or Hint |