| SchemaSpy Analysis of idempiere11.adempiere - ColumnsRequisition / Demand | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:55 +0100 |
| |||||
|
| ||||||
idempiere11.adempiere contains 685 columns - click on heading to sort:
| Table | Column | Type | Size | Nulls | Auto | Default | |
|---|---|---|---|---|---|---|---|
| c_cashplan | cashflowtype | bpchar | 1 | √ | NULL::bpchar | Cash Flow Type | |
| ad_user | connectionprofile | bpchar | 1 | √ | null | How a Java Tenant connects to the server(s) | |
| c_cashplan | copyfrom | bpchar | 1 | √ | NULL::bpchar | Copy From Record | |
| c_order | copyfrom | bpchar | 1 | √ | null | Copy From Record | |
| m_product | copyfrom | bpchar | 1 | √ | NULL::bpchar | Copy From Record | |
| c_orderline | createproduction | bpchar | 1 | √ | 'N'::bpchar | Create Production | |
| c_orderline | createshipment | bpchar | 1 | √ | 'N'::bpchar | Create Shipment | |
| c_bpartner | deliveryrule | bpchar | 1 | √ | null | Defines the timing of Delivery | |
| c_order | deliveryrule | bpchar | 1 | Defines the timing of Delivery | |||
| c_bpartner | deliveryviarule | bpchar | 1 | √ | null | How the order will be delivered | |
| c_order | deliveryviarule | bpchar | 1 | How the order will be delivered | |||
| m_product | discontinued | bpchar | 1 | √ | 'N'::bpchar | This product is no longer available | |
| m_pricelist | enforcepricelimit | bpchar | 1 | 'N'::bpchar | Do not allow prices below the limit price | ||
| c_bpartner | freightcostrule | bpchar | 1 | √ | null | Method for charging Freight | |
| c_order | freightcostrule | bpchar | 1 | Method for charging Freight | |||
| c_cashplan | generateperiodic | bpchar | 1 | √ | NULL::bpchar | Generate Periodic Plan | |
| c_doctype | hascharges | bpchar | 1 | 'N'::bpchar | Charges can be added to the document | ||
| c_doctype | hasproforma | bpchar | 1 | √ | 'N'::bpchar | Indicates if Pro Forma Invoices can be generated from this document | |
| c_bpartner | invoicerule | bpchar | 1 | √ | null | Frequency and method of invoicing | |
| c_order | invoicerule | bpchar | 1 | Frequency and method of invoicing | |||
| c_bpartner | is1099vendor | bpchar | 1 | 'N'::bpchar | 1099 Vendor | ||
| ad_user | 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_calendar | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_cashplan | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_cashplanline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_charge | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_doctype | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_order | 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_period | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_year | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_demand | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_demanddetail | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_demandline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_forecast | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_forecastline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_pricelist | 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_requisition | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_requisitionline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_warehouse | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| ad_user | isaddmailtextautomatically | bpchar | 1 | 'N'::bpchar | The selected mail template will be automatically inserted when creating an email | ||
| c_cashplan | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
| c_order | isapproved | bpchar | 1 | 'N'::bpchar | Indicates if this document requires approval | ||
| m_requisition | isapproved | bpchar | 1 | 'Y'::bpchar | Indicates if this document requires approval | ||
| m_product | isautoproduce | bpchar | 1 | 'N'::bpchar | Auto create production to fulfill shipment | ||
| ad_user | isbillto | bpchar | 1 | 'N'::bpchar | Business Partner Invoice/Bill Address | ||
| m_product | isbom | bpchar | 1 | 'N'::bpchar | Bill of Materials | ||
| c_doctype | ischargeorproductmandatory | bpchar | 1 | √ | 'N'::bpchar | Mandatory Charge or Product | |
| c_doctype | iscreatecounter | bpchar | 1 | 'Y'::bpchar | Create Counter Document | ||
| c_order | iscreditapproved | bpchar | 1 | 'N'::bpchar | Credit has been approved | ||
| c_bpartner | iscustomer | bpchar | 1 | 'Y'::bpchar | Indicates if this Business Partner is a Customer | ||
| c_doctype | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
| m_demand | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
| m_forecast | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
| m_pricelist | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
| c_doctype | isdefaultcounterdoc | bpchar | 1 | 'N'::bpchar | The document type is the default counter document type | ||
| c_order | isdelivered | bpchar | 1 | 'N'::bpchar | Delivered | ||
| c_orderline | isdescription | bpchar | 1 | 'N'::bpchar | if true, the line is just description and no transaction | ||
| m_warehouse | isdisallownegativeinv | bpchar | 1 | 'N'::bpchar | Negative Inventory is not allowed in this warehouse | ||
| c_bpartner | isdiscountprinted | bpchar | 1 | √ | 'Y'::bpchar | Print Discount on Invoice and Order | |
| c_order | isdiscountprinted | bpchar | 1 | 'Y'::bpchar | Print Discount on Invoice and Order | ||
| c_doctype | isdocnocontrolled | bpchar | 1 | 'N'::bpchar | The document has a document sequence | ||
| c_order | isdropship | bpchar | 1 | 'N'::bpchar | Drop Shipments are sent directly to the Drop Shipment Location | ||
| 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_product | isexcludeautodelivery | bpchar | 1 | 'N'::bpchar | Exclude from automatic Delivery | ||
| ad_user | isexpired | bpchar | 1 | 'N'::bpchar | Expired | ||
| ad_user | isfullbpaccess | bpchar | 1 | 'Y'::bpchar | The user/contact has full access to Business Partner information and resources | ||
| c_doctype | isindexed | bpchar | 1 | 'Y'::bpchar | Index the document for the internal search engine | ||
| ad_user | isinpayroll | bpchar | 1 | 'N'::bpchar | Defined if any User Contact will be used for Calculate Payroll | ||
| c_doctype | isintransit | bpchar | 1 | 'N'::bpchar | Movement is in transit | ||
| m_warehouse | isintransit | bpchar | 1 | √ | 'N'::bpchar | Movement is in transit | |
| c_order | 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 | ||
| ad_user | islocked | bpchar | 1 | 'N'::bpchar | Locked | ||
| m_pricelist | ismandatory | bpchar | 1 | √ | 'N'::bpchar | Data entry is required in this column | |
| 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 | |
| ad_user | ismenuautoexpand | bpchar | 1 | √ | null | If ticked, the menu is automatically expanded | |
| ad_user | isnoexpire | bpchar | 1 | 'N'::bpchar | No Expire | ||
| ad_user | isnopasswordreset | bpchar | 1 | 'N'::bpchar | No Password Reset | ||
| c_doctype | isnopricelistcheck | bpchar | 1 | √ | 'N'::bpchar | Allow Product Without Price List | |
| c_bpartner | isonetime | bpchar | 1 | 'N'::bpchar | One time transaction | ||
| c_doctype | isoverwritedateoncomplete | bpchar | 1 | √ | 'N'::bpchar | Overwrite Date on Complete | |
| c_doctype | isoverwriteseqoncomplete | bpchar | 1 | √ | 'N'::bpchar | Overwrite Sequence on Complete | |
| m_product | isownbox | bpchar | 1 | 'N'::bpchar | Own Box | ||
| c_order | ispayschedulevalid | bpchar | 1 | 'N'::bpchar | Is the Payment Schedule is valid | ||
| 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_doctype | ispickqaconfirm | bpchar | 1 | 'N'::bpchar | Require Pick or QA Confirmation before processing | ||
| c_bpartner | ispotaxexempt | bpchar | 1 | 'N'::bpchar | Business partner is exempt from tax on purchases | ||
| c_doctype | ispreparesplitdocument | bpchar | 1 | 'Y'::bpchar | Prepare generated split shipment/receipt document | ||
| m_pricelist | ispresentforproduct | bpchar | 1 | √ | 'N'::bpchar | Is Present For Product | |
| c_order | isprinted | bpchar | 1 | 'N'::bpchar | Indicates if this document / line is printed | ||
| c_order | ispriviledgedrate | bpchar | 1 | 'N'::bpchar | Privileged Rate | ||
| c_bpartner | isprospect | bpchar | 1 | 'N'::bpchar | Indicates this is a Prospect | ||
| m_product | ispurchased | bpchar | 1 | 'Y'::bpchar | Organization purchases this product | ||
| ad_user | issaleslead | bpchar | 1 | 'N'::bpchar | This contact is a sales lead | ||
| c_bpartner | issalesrep | bpchar | 1 | 'N'::bpchar | Indicates if the business partner is a sales representative or company agent | ||
| c_charge | issamecurrency | bpchar | 1 | 'N'::bpchar | Same Currency | ||
| c_charge | issametax | bpchar | 1 | 'N'::bpchar | Use the same tax as the main transaction | ||
| c_order | isselected | bpchar | 1 | 'N'::bpchar | Selected | ||
| c_order | isselfservice | bpchar | 1 | 'N'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
| m_product | isselfservice | bpchar | 1 | 'Y'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
| c_doctype | isshipconfirm | bpchar | 1 | 'N'::bpchar | Require Ship or Receipt Confirmation before processing | ||
| ad_user | isshipto | bpchar | 1 | 'N'::bpchar | Business Partner Shipment Address | ||
| m_product | issold | bpchar | 1 | 'Y'::bpchar | Organization sells this product | ||
| m_pricelist | issopricelist | bpchar | 1 | 'Y'::bpchar | This is a Sales Price List | ||
| c_cashplan | issotrx | bpchar | 1 | This is a Sales Transaction | |||
| c_doctype | issotrx | bpchar | 1 | 'Y'::bpchar | This is a Sales Transaction | ||
| c_order | issotrx | bpchar | 1 | 'Y'::bpchar | This is a Sales Transaction | ||
| c_doctype | issplitwhendifference | bpchar | 1 | 'N'::bpchar | Split document when there is a difference | ||
| 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 | ||
| ad_user | issupportuser | bpchar | 1 | 'N'::bpchar | Support User | ||
| c_bpartner | istaxexempt | bpchar | 1 | √ | 'N'::bpchar | Business partner is exempt from tax on sales | |
| c_charge | istaxincluded | bpchar | 1 | 'N'::bpchar | Tax is included in the price | ||
| c_order | istaxincluded | bpchar | 1 | 'N'::bpchar | Tax is included in the price | ||
| m_pricelist | istaxincluded | bpchar | 1 | 'N'::bpchar | Tax is included in the price | ||
| m_product | istoformule | bpchar | 1 | √ | null | ||
| c_order | istransferred | bpchar | 1 | 'N'::bpchar | Transferred to General Ledger (i.e. accounted) | ||
| c_bpartner | isvendor | bpchar | 1 | 'N'::bpchar | Indicates if this Business Partner is a Vendor | ||
| ad_user | isvendorlead | bpchar | 1 | 'N'::bpchar | This contact is a vendor lead | ||
| m_product | isverified | bpchar | 1 | 'N'::bpchar | The BOM configuration has been verified | ||
| m_product | iswebstorefeatured | bpchar | 1 | 'N'::bpchar | If selected, the product is displayed in the initial or any empty search | ||
| ad_user | notificationtype | bpchar | 1 | 'X'::bpchar | Type of Notifications | ||
| c_bpartner | paymentrule | bpchar | 1 | √ | null | How you pay the invoice | |
| c_order | paymentrule | bpchar | 1 | How you pay the invoice | |||
| c_bpartner | paymentrulepo | bpchar | 1 | √ | null | Purchase payment option | |
| c_period | periodtype | bpchar | 1 | Period Type | |||
| c_order | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
| m_requisition | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
| c_order | priorityrule | bpchar | 1 | Priority of a document | |||
| m_requisition | priorityrule | bpchar | 1 | Priority of a document | |||
| c_cashplan | processed | bpchar | 1 | The document has been processed | |||
| c_cashplanline | processed | bpchar | 1 | The document has been processed | |||
| c_order | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
| c_orderline | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
| m_requisition | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
| ad_user | processing | bpchar | 1 | √ | null | Process Now | |
| c_order | processing | bpchar | 1 | √ | null | Process Now | |
| c_period | processing | bpchar | 1 | √ | null | Process Now | |
| c_year | processing | bpchar | 1 | √ | null | Process Now | |
| m_demand | processing | bpchar | 1 | √ | null | Process Now | |
| m_forecast | processing | bpchar | 1 | √ | null | Process Now | |
| m_product | processing | bpchar | 1 | √ | null | Process Now | |
| m_requisition | 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 | |
| c_bpartner | sendemail | bpchar | 1 | 'N'::bpchar | Enable sending Document EMail | ||
| c_order | sendemail | bpchar | 1 | 'N'::bpchar | Enable sending Document EMail | ||
| m_warehouse | separator | bpchar | 1 | Element Separator | |||
| c_order | shippingrateinquiry | bpchar | 1 | √ | NULL::bpchar | Rate Inquiry | |
| c_bpartner | socreditstatus | bpchar | 1 | √ | 'O'::bpchar | Business Partner Credit Status | |
| c_order | docaction | bpchar | 2 | The targeted status of the document | |||
| m_requisition | docaction | bpchar | 2 | The targeted status of the document | |||
| c_order | docstatus | bpchar | 2 | The current status of the document | |||
| m_requisition | docstatus | bpchar | 2 | The current status of the document | |||
| c_doctype | docsubtypeso | bpchar | 2 | √ | null | Sales Order Sub Type | |
| c_doctype | docbasetype | bpchar | 3 | Logical type of document | |||
| 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 | |
| c_charge | chargeamt | numeric | 0 | 0 | Charge Amount | ||
| c_order | chargeamt | numeric | 0 | √ | 0 | Charge Amount | |
| c_orderline | discount | numeric | 0 | √ | null | Discount in percent | |
| c_bpartner | flatdiscount | numeric | 0 | √ | null | Flat discount percentage | |
| c_order | freightamt | numeric | 0 | √ | 0 | Freight Amount | |
| c_orderline | freightamt | numeric | 0 | 0 | Freight Amount | ||
| c_cashplan | grandtotal | numeric | 0 | Total amount of document | |||
| c_order | grandtotal | numeric | 0 | 0 | Total amount of document | ||
| c_orderline | linenetamt | numeric | 0 | 0 | Line Extended Amount (Quantity * Actual Price) without Freight and Charges | ||
| m_requisitionline | linenetamt | numeric | 0 | 0 | Line Extended Amount (Quantity * Actual Price) without Freight and Charges | ||
| c_cashplanline | linetotalamt | numeric | 0 | √ | null | Total line amount incl. Tax | |
| m_requisitionline | m_attributesetinstance_id | numeric | 0 | √ | null | Product Attribute Set Instance | |
| c_bpartner | potentiallifetimevalue | numeric | 0 | √ | 0 | Total Revenue expected | |
| c_orderline | priceactual | numeric | 0 | 0 | Actual Price | ||
| m_requisitionline | priceactual | numeric | 0 | 0 | Actual Price | ||
| c_orderline | pricecost | numeric | 0 | √ | null | Price per Unit of Measure including all indirect costs (Freight, etc.) | |
| c_orderline | priceentered | numeric | 0 | Price Entered - the price based on the selected/base UoM | |||
| c_orderline | pricelimit | numeric | 0 | 0 | Lowest price for a product | ||
| c_orderline | pricelist | numeric | 0 | 0 | List Price | ||
| c_cashplanline | probability | numeric | 0 | √ | null | Probability | |
| c_order | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
| m_requisition | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
| m_demandline | qty | numeric | 0 | 0 | Quantity | ||
| m_forecastline | qty | numeric | 0 | 0 | Quantity | ||
| m_requisitionline | qty | numeric | 0 | 0 | Quantity | ||
| m_demandline | qtycalculated | numeric | 0 | 0 | Calculated Quantity | ||
| m_forecastline | qtycalculated | numeric | 0 | 0 | Calculated Quantity | ||
| c_orderline | qtydelivered | numeric | 0 | 0 | Delivered Quantity | ||
| c_cashplanline | qtyentered | numeric | 0 | 1 | The Quantity Entered is based on the selected UoM | ||
| c_orderline | qtyentered | numeric | 0 | The Quantity Entered is based on the selected UoM | |||
| c_orderline | qtyinvoiced | numeric | 0 | 0 | Invoiced Quantity | ||
| c_orderline | qtylostsales | numeric | 0 | 0 | Quantity of potential sales | ||
| c_orderline | qtyordered | numeric | 0 | 0 | Ordered Quantity | ||
| c_orderline | qtyreserved | numeric | 0 | 0 | Reserved Quantity | ||
| c_orderline | rramt | numeric | 0 | √ | null | Revenue Recognition Amount | |
| 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 | |
| c_order | totallines | numeric | 0 | 0 | Total of all document lines | ||
| m_requisition | totallines | numeric | 0 | 0 | Total of all document lines | ||
| c_bpartner | totalopenbalance | numeric | 0 | √ | null | Total Open Balance Amount in primary Accounting Currency | |
| m_product | unitsperpallet | numeric | 0 | √ | null | Units Per Pallet | |
| c_order | volume | numeric | 0 | √ | null | Volume of a product | |
| m_product | volume | numeric | 0 | √ | 0 | Volume of a product | |
| c_order | weight | numeric | 0 | √ | null | Weight of a product | |
| m_product | weight | numeric | 0 | √ | 0 | Weight of a product | |
| ad_user | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_bpartner | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_calendar | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_cashplan | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_cashplanline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_charge | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_doctype | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_order | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_orderline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_period | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| c_year | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_demand | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_demanddetail | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_demandline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_forecast | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_forecastline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_pricelist | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_product | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_requisition | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_requisitionline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| m_warehouse | ad_client_id | numeric | 10 | Tenant for this installation. | |||
| ad_user | ad_image_id | numeric | 10 | √ | NULL::numeric | Image or Icon | |
| ad_user | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_bpartner | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_calendar | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_cashplan | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_cashplanline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_charge | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_doctype | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_order | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_orderline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_period | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| c_year | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_demand | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_demanddetail | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_demandline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_forecast | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_forecastline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_pricelist | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_product | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_requisition | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_requisitionline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
| m_warehouse | 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 | |
| ad_user | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
| c_cashplan | ad_orgtrx_id | numeric | 10 | √ | NULL::numeric | Performing or initiating organization | |
| c_cashplanline | ad_orgtrx_id | numeric | 10 | √ | NULL::numeric | Performing or initiating organization | |
| c_order | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
| c_orderline | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
| c_doctype | ad_printformat_id | numeric | 10 | √ | null | Data Print Format | |
| ad_user | ad_user_id | numeric | 10 | User within the system - Internal or Business Partner Contact | |||
| c_order | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
| m_requisition | ad_user_id | numeric | 10 | User within the system - Internal or Business Partner Contact | |||
| m_pricelist | basepricelist_id | numeric | 10 | √ | null | Pricelist to be used, if product not found on this pricelist | |
| c_order | bill_bpartner_id | numeric | 10 | √ | null | Business Partner to be invoiced | |
| c_order | bill_location_id | numeric | 10 | √ | null | Business Partner Location for invoicing | |
| c_order | bill_user_id | numeric | 10 | √ | null | Business Partner Contact for invoicing | |
| ad_user | bp_location_id | numeric | 10 | √ | NULL::numeric | Address of the Business Partner | |
| c_bpartner | bpartner_parent_id | numeric | 10 | √ | null | Business Partner Parent | |
| c_cashplan | c_activity_id | numeric | 10 | √ | null | Business Activity | |
| c_cashplanline | c_activity_id | numeric | 10 | √ | NULL::numeric | Business Activity | |
| c_order | c_activity_id | numeric | 10 | √ | null | Business Activity | |
| c_orderline | c_activity_id | numeric | 10 | √ | null | Business Activity | |
| c_bpartner | c_bp_group_id | numeric | 10 | Business Partner Group | |||
| ad_user | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
| c_bpartner | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
| c_cashplan | c_bpartner_id | numeric | 10 | √ | NULL::numeric | Identifies a Business Partner | |
| c_cashplanline | c_bpartner_id | numeric | 10 | √ | NULL::numeric | Identifies a Business Partner | |
| c_charge | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
| c_order | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
| c_orderline | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
| m_requisitionline | c_bpartner_id | numeric | 10 | √ | NULL::numeric | Identifies a Business Partner | |
| ad_user | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
| c_order | c_bpartner_location_id | numeric | 10 | 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 | |
| c_calendar | c_calendar_id | numeric | 10 | Accounting Calendar Name | |||
| c_year | c_calendar_id | numeric | 10 | Accounting Calendar Name | |||
| m_demand | c_calendar_id | numeric | 10 | Accounting Calendar Name | |||
| m_forecast | c_calendar_id | numeric | 10 | Accounting Calendar Name | |||
| ad_user | c_campaign_id | numeric | 10 | √ | NULL::numeric | Marketing Campaign | |
| c_cashplan | c_campaign_id | numeric | 10 | √ | NULL::numeric | Marketing Campaign | |
| c_cashplanline | c_campaign_id | numeric | 10 | √ | NULL::numeric | Marketing Campaign | |
| c_order | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
| c_orderline | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
| c_order | c_cashline_id | numeric | 10 | √ | null | Cash Journal Line | |
| c_cashplan | c_cashplan_id | numeric | 10 | Cash Plan | |||
| c_cashplanline | c_cashplan_id | numeric | 10 | Cash Plan | |||
| c_cashplanline | c_cashplanline_id | numeric | 10 | Cash Plan Line | |||
| c_order | c_cashplanline_id | numeric | 10 | √ | NULL::numeric | Cash Plan Line | |
| c_cashplanline | c_charge_id | numeric | 10 | √ | NULL::numeric | Additional document charges | |
| c_charge | c_charge_id | numeric | 10 | Additional document charges | |||
| c_order | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
| c_orderline | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
| m_requisitionline | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
| c_charge | c_chargetype_id | numeric | 10 | √ | null | Charge Type | |
| c_order | c_conversiontype_id | numeric | 10 | √ | null | Currency Conversion Rate Type | |
| c_order | c_currency_id | numeric | 10 | The Currency for this record | |||
| c_orderline | c_currency_id | numeric | 10 | The Currency for this record | |||
| m_pricelist | c_currency_id | numeric | 10 | The Currency for this record | |||
| c_doctype | c_doctype_id | numeric | 10 | Document type or rules | |||
| c_order | c_doctype_id | numeric | 10 | Document type or rules | |||
| m_requisition | c_doctype_id | numeric | 10 | Document type or rules | |||
| c_doctype | c_doctypedifference_id | numeric | 10 | √ | null | Document type for generating in dispute Shipments | |
| c_doctype | c_doctypeinvoice_id | numeric | 10 | √ | null | Document type used for invoices generated from this sales document | |
| c_doctype | c_doctypeproforma_id | numeric | 10 | √ | null | Document type used for pro forma invoices generated from this sales document | |
| c_doctype | c_doctypeshipment_id | numeric | 10 | √ | null | Document type used for shipments generated from this sales document | |
| c_order | c_doctypetarget_id | numeric | 10 | Target document type for conversing documents | |||
| c_bpartner | c_dunning_id | numeric | 10 | √ | null | Dunning Rules for overdue invoices | |
| ad_user | c_greeting_id | numeric | 10 | √ | null | Greeting to print on correspondence | |
| c_bpartner | c_greeting_id | numeric | 10 | √ | null | Greeting to print on correspondence | |
| c_bpartner | c_invoiceschedule_id | numeric | 10 | √ | null | Schedule for generating Invoices | |
| ad_user | c_job_id | numeric | 10 | √ | null | Job Position | |
| ad_user | c_location_id | numeric | 10 | √ | NULL::numeric | Location or Address | |
| m_warehouse | c_location_id | numeric | 10 | Location or Address | |||
| c_order | c_opportunity_id | numeric | 10 | √ | NULL::numeric | Sales Opportunity | |
| c_order | c_order_id | numeric | 10 | Order | |||
| c_orderline | c_order_id | numeric | 10 | Order | |||
| c_orderline | c_orderline_id | numeric | 10 | Sales Order Line | |||
| m_demanddetail | c_orderline_id | numeric | 10 | √ | null | Sales Order Line | |
| m_requisitionline | c_orderline_id | numeric | 10 | √ | null | Sales Order Line | |
| c_order | c_ordersource_id | numeric | 10 | √ | null | Order Source | |
| c_order | c_payment_id | numeric | 10 | √ | null | Payment identifier | |
| c_bpartner | c_paymentterm_id | numeric | 10 | √ | null | The terms of Payment (timing, discount) | |
| c_order | c_paymentterm_id | numeric | 10 | The terms of Payment (timing, discount) | |||
| c_period | c_period_id | numeric | 10 | Period of the Calendar | |||
| m_demandline | c_period_id | numeric | 10 | Period of the Calendar | |||
| m_forecastline | c_period_id | numeric | 10 | Period of the Calendar | |||
| c_order | c_pos_id | numeric | 10 | √ | null | Point of Sales Terminal | |
| c_cashplan | c_project_id | numeric | 10 | √ | null | Financial Project | |
| c_cashplanline | c_project_id | numeric | 10 | √ | NULL::numeric | Financial Project | |
| c_order | c_project_id | numeric | 10 | √ | null | Financial Project | |
| c_orderline | c_project_id | numeric | 10 | √ | null | Financial Project | |
| c_cashplanline | c_projectphase_id | numeric | 10 | √ | NULL::numeric | Phase of a Project | |
| c_orderline | c_projectphase_id | numeric | 10 | √ | null | Phase of a Project | |
| c_cashplanline | c_projecttask_id | numeric | 10 | √ | NULL::numeric | Actual Project Task in a Phase | |
| c_orderline | c_projecttask_id | numeric | 10 | √ | null | Actual Project Task in a Phase | |
| m_product | c_revenuerecognition_id | numeric | 10 | √ | null | Method for recording revenue | |
| m_product | c_subscriptiontype_id | numeric | 10 | √ | null | Type of subscription | |
| c_orderline | c_tax_id | numeric | 10 | Tax identifier | |||
| c_charge | c_taxcategory_id | numeric | 10 | √ | null | Tax Category | |
| m_product | c_taxcategory_id | numeric | 10 | Tax Category | |||
| c_bpartner | c_taxgroup_id | numeric | 10 | √ | null | Tax Group | |
| c_orderline | c_uom_id | numeric | 10 | Unit of Measure | |||
| m_product | c_uom_id | numeric | 10 | Unit of Measure | |||
| m_requisitionline | c_uom_id | numeric | 10 | √ | NULL::numeric | Unit of Measure | |
| c_period | c_year_id | numeric | 10 | Calendar Year | |||
| c_year | c_year_id | numeric | 10 | Calendar Year | |||
| m_demand | c_year_id | numeric | 10 | Calendar Year | |||
| m_forecast | c_year_id | numeric | 10 | Calendar Year | |||
| ad_user | createdby | numeric | 10 | User who created this records | |||
| c_bpartner | createdby | numeric | 10 | User who created this records | |||
| c_calendar | createdby | numeric | 10 | User who created this records | |||
| c_cashplan | createdby | numeric | 10 | User who created this records | |||
| c_cashplanline | createdby | numeric | 10 | User who created this records | |||
| c_charge | createdby | numeric | 10 | User who created this records | |||
| c_doctype | createdby | numeric | 10 | User who created this records | |||
| c_order | createdby | numeric | 10 | User who created this records | |||
| c_orderline | createdby | numeric | 10 | User who created this records | |||
| c_period | createdby | numeric | 10 | User who created this records | |||
| c_year | createdby | numeric | 10 | User who created this records | |||
| m_demand | createdby | numeric | 10 | User who created this records | |||
| m_demanddetail | createdby | numeric | 10 | User who created this records | |||
| m_demandline | createdby | numeric | 10 | User who created this records | |||
| m_forecast | createdby | numeric | 10 | User who created this records | |||
| m_forecastline | createdby | numeric | 10 | User who created this records | |||
| m_pricelist | createdby | numeric | 10 | User who created this records | |||
| m_product | createdby | numeric | 10 | User who created this records | |||
| m_requisition | createdby | numeric | 10 | User who created this records | |||
| m_requisitionline | createdby | numeric | 10 | User who created this records | |||
| m_warehouse | createdby | numeric | 10 | User who created this records | |||
| c_bpartner | default1099box_id | numeric | 10 | √ | NULL::numeric | Default 1099 Box | |
| c_doctype | definitesequence_id | numeric | 10 | √ | null | Definite Sequence | |
| c_doctype | docnosequence_id | numeric | 10 | √ | null | Document sequence determines the numbering of documents | |
| c_bpartner | documentcopies | numeric | 10 | √ | null | Number of copies to be printed | |
| c_doctype | documentcopies | numeric | 10 | Number of copies to be printed | |||
| c_order | dropship_bpartner_id | numeric | 10 | √ | null | Business Partner to ship to | |
| c_order | dropship_location_id | numeric | 10 | √ | null | Business Partner Location for shipping to | |
| c_order | dropship_user_id | numeric | 10 | √ | null | Business Partner Contact for drop shipment | |
| ad_user | failedlogincount | numeric | 10 | (0)::numeric | Failed Login Count | ||
| c_doctype | gl_category_id | numeric | 10 | General Ledger Category | |||
| 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 | |
| c_bpartner | invoice_printformat_id | numeric | 10 | √ | null | Print Format for printing Invoices | |
| c_cashplanline | line | numeric | 10 | Unique line for this document | |||
| c_orderline | line | numeric | 10 | Unique line for this document | |||
| m_requisitionline | line | numeric | 10 | Unique line for this document | |||
| c_order | link_order_id | numeric | 10 | √ | null | This field links a sales order to the purchase order that is generated from it. | |
| 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. | |
| 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_product | m_attributeset_id | numeric | 10 | √ | null | Product Attribute Set | |
| c_orderline | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
| m_product | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
| m_demand | m_demand_id | numeric | 10 | Material Demand | |||
| m_demandline | m_demand_id | numeric | 10 | Material Demand | |||
| m_demanddetail | m_demanddetail_id | numeric | 10 | Material Demand Line Source Detail | |||
| m_demanddetail | m_demandline_id | numeric | 10 | Material Demand Line | |||
| m_demandline | m_demandline_id | numeric | 10 | Material Demand Line | |||
| c_bpartner | m_discountschema_id | numeric | 10 | √ | null | Schema to calculate the trade discount percentage | |
| m_forecast | m_forecast_id | numeric | 10 | Material Forecast | |||
| m_forecastline | m_forecast_id | numeric | 10 | Material Forecast | |||
| m_demanddetail | m_forecastline_id | numeric | 10 | √ | null | Forecast Line | |
| m_forecastline | m_forecastline_id | numeric | 10 | Forecast Line | |||
| c_order | m_freightcategory_id | numeric | 10 | √ | NULL::numeric | Category of the Freight | |
| m_product | m_freightcategory_id | numeric | 10 | √ | null | Category of the Freight | |
| m_product | m_locator_id | numeric | 10 | √ | null | Warehouse Locator | |
| 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 | |
| c_order | m_pricelist_id | numeric | 10 | Unique identifier of a Price List | |||
| m_forecast | m_pricelist_id | numeric | 10 | √ | null | Unique identifier of a Price List | |
| m_pricelist | m_pricelist_id | numeric | 10 | Unique identifier of a Price List | |||
| m_requisition | m_pricelist_id | numeric | 10 | Unique identifier of a Price List | |||
| m_product | m_product_category_id | numeric | 10 | Category of a Product | |||
| c_cashplanline | m_product_id | numeric | 10 | √ | NULL::numeric | Product, Service, Item | |
| c_orderline | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
| m_demandline | m_product_id | numeric | 10 | Product, Service, Item | |||
| m_forecastline | m_product_id | numeric | 10 | Product, Service, Item | |||
| m_product | m_product_id | numeric | 10 | Product, Service, Item | |||
| m_requisitionline | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
| c_orderline | m_promotion_id | numeric | 10 | √ | null | Promotion | |
| m_requisition | m_requisition_id | numeric | 10 | Material Requisition | |||
| m_requisitionline | m_requisition_id | numeric | 10 | Material Requisition | |||
| m_demanddetail | m_requisitionline_id | numeric | 10 | √ | null | Material Requisition Line | |
| m_requisitionline | m_requisitionline_id | numeric | 10 | Material Requisition Line | |||
| m_warehouse | m_reservelocator_id | numeric | 10 | √ | NULL::numeric | Reservation Locator (just for reporting purposes) | |
| c_order | m_shipper_id | numeric | 10 | √ | null | Method or manner of product delivery | |
| c_orderline | m_shipper_id | numeric | 10 | √ | null | Method or manner of product delivery | |
| c_order | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
| c_orderline | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
| m_forecastline | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
| m_requisition | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
| m_warehouse | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
| m_warehouse | m_warehousesource_id | numeric | 10 | √ | null | Optional Warehouse to replenish from | |
| c_bpartner | numberemployees | numeric | 10 | √ | null | Number of employees | |
| c_order | pay_bpartner_id | numeric | 10 | √ | null | Business Partner responsible for the payment | |
| c_order | pay_location_id | numeric | 10 | √ | null | Location of the Business Partner responsible for the payment | |
| c_period | periodno | numeric | 10 | Unique Period Number | |||
| 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 | |
| c_orderline | pp_cost_collector_id | numeric | 10 | √ | null | Manufacturing Cost Collector | |
| m_pricelist | priceprecision | numeric | 10 | 2 | Precision (number of decimals) for the Price | ||
| c_order | quotationorder_id | numeric | 10 | √ | NULL::numeric | Quotation used for generating this order | |
| ad_user | r_defaultmailtext_id | numeric | 10 | √ | NULL::numeric | Default mail template | |
| m_product | r_mailtext_id | numeric | 10 | √ | null | Text templates for mailings | |
| c_order | ref_order_id | numeric | 10 | √ | null | Reference to corresponding Sales/Purchase Order | |
| c_orderline | ref_orderline_id | numeric | 10 | √ | null | Reference to corresponding Sales/Purchase Order | |
| m_product | s_expensetype_id | numeric | 10 | √ | null | Expense report type | |
| m_product | s_resource_id | numeric | 10 | √ | null | Resource | |
| c_orderline | s_resourceassignment_id | numeric | 10 | √ | null | Resource Assignment | |
| ad_user | salesrep_id | numeric | 10 | √ | NULL::numeric | Sales Representative or Company Agent | |
| c_bpartner | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
| c_order | salesrep_id | numeric | 10 | √ | null | Sales Representative or Company Agent | |
| m_forecastline | 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 | |
| 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 | shelflifeminpct | numeric | 10 | √ | null | Minimum Shelf Life in percent based on Product Instance Guarantee Date | |
| m_product | shelfwidth | numeric | 10 | √ | null | Shelf width required | |
| ad_user | supervisor_id | numeric | 10 | √ | null | Supervisor for this user/organization - used for escalation and approval | |
| m_product | unitsperpack | numeric | 10 | 1 | The Units Per Pack indicates the no of units of a product packed together. | ||
| ad_user | updatedby | numeric | 10 | User who updated this records | |||
| c_bpartner | updatedby | numeric | 10 | User who updated this records | |||
| c_calendar | updatedby | numeric | 10 | User who updated this records | |||
| c_cashplan | updatedby | numeric | 10 | User who updated this records | |||
| c_cashplanline | updatedby | numeric | 10 | User who updated this records | |||
| c_charge | updatedby | numeric | 10 | User who updated this records | |||
| c_doctype | updatedby | numeric | 10 | User who updated this records | |||
| c_order | updatedby | numeric | 10 | User who updated this records | |||
| c_orderline | updatedby | numeric | 10 | User who updated this records | |||
| c_period | updatedby | numeric | 10 | User who updated this records | |||
| c_year | updatedby | numeric | 10 | User who updated this records | |||
| m_demand | updatedby | numeric | 10 | User who updated this records | |||
| m_demanddetail | updatedby | numeric | 10 | User who updated this records | |||
| m_demandline | updatedby | numeric | 10 | User who updated this records | |||
| m_forecast | updatedby | numeric | 10 | User who updated this records | |||
| m_forecastline | updatedby | numeric | 10 | User who updated this records | |||
| m_pricelist | updatedby | numeric | 10 | User who updated this records | |||
| m_product | updatedby | numeric | 10 | User who updated this records | |||
| m_requisition | updatedby | numeric | 10 | User who updated this records | |||
| m_requisitionline | updatedby | numeric | 10 | User who updated this records | |||
| m_warehouse | updatedby | numeric | 10 | User who updated this records | |||
| c_cashplan | user1_id | numeric | 10 | √ | NULL::numeric | User defined list element #1 | |
| c_cashplanline | user1_id | numeric | 10 | √ | NULL::numeric | User defined list element #1 | |
| c_order | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
| c_orderline | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
| c_cashplan | user2_id | numeric | 10 | √ | NULL::numeric | User defined list element #2 | |
| c_cashplanline | user2_id | numeric | 10 | √ | NULL::numeric | User defined list element #2 | |
| c_order | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
| c_orderline | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
| c_order | amountrefunded | numeric | 22,2 | √ | null | Amount Refunded | |
| c_order | amounttendered | numeric | 22,2 | √ | null | Amount Tendered | |
| ad_user | birthday | timestamp | 29,6 | √ | null | Birthday or Anniversary day | |
| ad_user | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_bpartner | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_calendar | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_cashplan | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
| c_cashplanline | created | timestamp | 29,6 | statement_timestamp() | Date this record was created | ||
| c_charge | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_doctype | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_order | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_orderline | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_period | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_year | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_demand | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_demanddetail | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_demandline | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_forecast | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_forecastline | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_pricelist | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_product | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_requisition | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_requisitionline | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_warehouse | created | timestamp | 29,6 | now() | Date this record was created | ||
| ad_user | dateaccountlocked | timestamp | 29,6 | √ | null | Date Account Locked | |
| c_order | dateacct | timestamp | 29,6 | Accounting Date | |||
| c_orderline | datedelivered | timestamp | 29,6 | √ | null | Date when the product was delivered | |
| c_cashplan | datedoc | timestamp | 29,6 | Date of the Document | |||
| m_requisition | datedoc | timestamp | 29,6 | now() | Date of the Document | ||
| c_orderline | dateinvoiced | timestamp | 29,6 | √ | null | Date printed on Invoice | |
| ad_user | datelastlogin | timestamp | 29,6 | √ | null | Date Last Login | |
| c_order | dateordered | timestamp | 29,6 | Date of Order | |||
| c_orderline | dateordered | timestamp | 29,6 | Date of Order | |||
| ad_user | datepasswordchanged | timestamp | 29,6 | √ | null | Date Password Changed | |
| c_order | dateprinted | timestamp | 29,6 | √ | null | Date the document was printed. | |
| c_order | datepromised | timestamp | 29,6 | √ | null | Date Order was promised | |
| c_orderline | datepromised | timestamp | 29,6 | √ | null | Date Order was promised | |
| m_forecastline | datepromised | timestamp | 29,6 | Date Order was promised | |||
| m_requisition | daterequired | timestamp | 29,6 | Date when required | |||
| c_cashplanline | datetrx | timestamp | 29,6 | Transaction Date | |||
| 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 | |
| ad_user | emailverifydate | timestamp | 29,6 | √ | null | Date Email was verified | |
| c_period | enddate | timestamp | 29,6 | √ | null | Last effective date (inclusive) | |
| c_bpartner | firstsale | timestamp | 29,6 | √ | null | Date of First Sale | |
| ad_user | lastcontact | timestamp | 29,6 | √ | null | Date this individual was last contacted | |
| c_orderline | rrstartdate | timestamp | 29,6 | √ | null | Revenue Recognition Start Date | |
| c_period | startdate | timestamp | 29,6 | First effective day (inclusive) | |||
| ad_user | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_bpartner | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_calendar | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_cashplan | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
| c_cashplanline | updated | timestamp | 29,6 | statement_timestamp() | Date this record was updated | ||
| c_charge | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_doctype | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_order | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_orderline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_period | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_year | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_demand | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_demanddetail | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_demandline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_forecast | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_forecastline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_pricelist | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_product | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_requisition | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_requisitionline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_warehouse | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_doctype | docsubtypeinv | varchar | 2 | √ | NULL::character varying | Inventory Sub 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 | |
| ad_user | authenticationtype | varchar | 10 | √ | NULL::character varying | Authentication Type | |
| c_year | fiscalyear | varchar | 10 | The Fiscal Year | |||
| ad_user | leadsource | varchar | 10 | √ | NULL::character varying | The source of this lead/opportunity | |
| ad_user | leadstatus | varchar | 10 | √ | NULL::character varying | The status of this lead/opportunity in the sales cycle | |
| c_bpartner | duns | varchar | 11 | √ | null | Dun & Bradstreet Number | |
| m_product | classification | varchar | 12 | √ | null | Classification for grouping | |
| ad_user | salt | varchar | 16 | √ | NULL::character varying | Random data added to improve password hash effectiveness | |
| m_product | customstariffnumber | varchar | 20 | √ | null | Customs Tariff Number, usually the HS-Code | |
| c_bpartner | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
| c_order | poreference | varchar | 20 | √ | null | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner | |
| c_bpartner | taxid | varchar | 20 | √ | null | Tax Identification | |
| ad_user | userpin | varchar | 20 | √ | null | User PIN | |
| m_product | versionno | varchar | 20 | √ | null | Version Number | |
| c_cashplan | documentno | varchar | 30 | Document sequence number of the document | |||
| c_order | documentno | varchar | 30 | Document sequence number of the document | |||
| m_requisition | documentno | varchar | 30 | Document sequence number of the document | |||
| c_order | promotioncode | varchar | 30 | √ | null | User entered promotion code at sales time | |
| 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) | |
| ad_user | ad_user_uu | varchar | 36 | √ | NULL::character varying | AD_User_UU | |
| c_bpartner | c_bpartner_uu | varchar | 36 | √ | NULL::character varying | C_BPartner_UU | |
| c_calendar | c_calendar_uu | varchar | 36 | √ | NULL::character varying | C_Calendar_UU | |
| c_cashplan | c_cashplan_uu | varchar | 36 | √ | NULL::character varying | C_CashPlan_UU | |
| c_cashplanline | c_cashplanline_uu | varchar | 36 | √ | NULL::character varying | C_CashPlanLine_UU | |
| c_charge | c_charge_uu | varchar | 36 | √ | NULL::character varying | C_Charge_UU | |
| c_doctype | c_doctype_uu | varchar | 36 | √ | NULL::character varying | C_DocType_UU | |
| c_order | c_order_uu | varchar | 36 | √ | NULL::character varying | C_Order_UU | |
| c_orderline | c_orderline_uu | varchar | 36 | √ | NULL::character varying | C_OrderLine_UU | |
| c_period | c_period_uu | varchar | 36 | √ | NULL::character varying | C_Period_UU | |
| c_year | c_year_uu | varchar | 36 | √ | NULL::character varying | C_Year_UU | |
| m_demand | m_demand_uu | varchar | 36 | √ | NULL::character varying | M_Demand_UU | |
| m_demanddetail | m_demanddetail_uu | varchar | 36 | √ | NULL::character varying | M_DemandDetail_UU | |
| m_demandline | m_demandline_uu | varchar | 36 | √ | NULL::character varying | M_DemandLine_UU | |
| m_forecast | m_forecast_uu | varchar | 36 | √ | NULL::character varying | M_Forecast_UU | |
| m_forecastline | m_forecastline_uu | varchar | 36 | √ | NULL::character varying | M_ForecastLine_UU | |
| m_pricelist | m_pricelist_uu | varchar | 36 | √ | NULL::character varying | M_PriceList_UU | |
| m_product | m_product_uu | varchar | 36 | √ | NULL::character varying | M_Product_UU | |
| m_requisition | m_requisition_uu | varchar | 36 | √ | NULL::character varying | M_Requisition_UU | |
| m_requisitionline | m_requisitionline_uu | varchar | 36 | √ | NULL::character varying | M_RequisitionLine_UU | |
| m_warehouse | m_warehouse_uu | varchar | 36 | √ | NULL::character varying | M_Warehouse_UU | |
| ad_user | emailverify | varchar | 40 | √ | null | Verification information of EMail Address | |
| ad_user | fax | varchar | 40 | √ | null | Facsimile number | |
| ad_user | phone | varchar | 40 | √ | null | Identifies a telephone number | |
| ad_user | phone2 | varchar | 40 | √ | null | Identifies an alternate telephone number. | |
| c_bpartner | referenceno | varchar | 40 | √ | null | Your customer or vendor number at the Business Partner's site | |
| ad_user | title | varchar | 40 | √ | null | Name this entity is referred to as | |
| ad_user | value | varchar | 40 | √ | null | 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_warehouse | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
| ad_user | bpname | varchar | 60 | √ | NULL::character varying | BP Name | |
| c_bpartner | customerprofileid | varchar | 60 | √ | NULL::character varying | Customer Profile ID | |
| ad_user | varchar | 60 | √ | null | Electronic Mail Address | ||
| ad_user | emailuser | varchar | 60 | √ | null | User Name (ID) in the Mail System | |
| ad_user | ldapuser | varchar | 60 | √ | null | User Name used for authorization via LDAP (directory) services | |
| ad_user | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_calendar | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_cashplanline | name | varchar | 60 | √ | NULL::character varying | Alphanumeric identifier of the entity | |
| c_charge | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_doctype | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_period | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| m_demand | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| m_forecast | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| m_pricelist | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| m_warehouse | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_bpartner | name2 | varchar | 60 | √ | null | Additional Name | |
| c_doctype | printname | varchar | 60 | The label text to be printed on a document or correspondence. | |||
| m_warehouse | replenishmentclass | varchar | 60 | √ | null | Custom class to calculate Quantity to Order | |
| 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 | |
| ad_user | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_bpartner | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_calendar | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_cashplan | description | varchar | 255 | √ | NULL::character varying | Optional short description of the record | |
| c_cashplanline | description | varchar | 255 | √ | NULL::character varying | Optional short description of the record | |
| c_charge | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_doctype | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_order | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_orderline | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_year | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_demand | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_forecast | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_pricelist | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_product | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_requisition | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_requisitionline | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_warehouse | description | varchar | 255 | √ | null | Optional short description of the record | |
| ad_user | emailuserpw | varchar | 255 | √ | null | Password of your email user id | |
| m_product | group1 | varchar | 255 | √ | null | Group1 | |
| m_product | group2 | varchar | 255 | √ | null | Group2 | |
| ad_user | lastresult | varchar | 255 | √ | null | Result of last contact | |
| ad_user | leadsourcedescription | varchar | 255 | √ | NULL::character varying | Additional information on the source of this lead/opportunity | |
| ad_user | leadstatusdescription | varchar | 255 | √ | NULL::character varying | Additional information on the status of this lead/opportunity | |
| m_product | name | varchar | 255 | Alphanumeric identifier of the entity | |||
| c_bpartner | so_description | varchar | 255 | √ | null | Description to be used on orders | |
| c_order | ordertype | varchar | 510 | √ | null | Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition) | |
| m_product | value | varchar | 510 | Search key for the record in the format required - must be unique | |||
| ad_user | answer | varchar | 1024 | √ | NULL::character varying | Answer | |
| ad_user | password | varchar | 1024 | √ | null | Password of any length (case sensitive) | |
| ad_user | securityquestion | varchar | 1024 | √ | null | Security Question | |
| ad_user | comments | varchar | 2000 | √ | null | Comments or additional information | |
| c_doctype | documentnote | varchar | 2000 | √ | null | Additional information for a Document | |
| m_product | documentnote | varchar | 2000 | √ | null | Additional information for a Document | |
| m_demand | help | varchar | 2000 | √ | null | Comment or Hint | |
| m_forecast | help | varchar | 2000 | √ | null | Comment or Hint | |
| m_product | help | varchar | 2000 | √ | null | Comment or Hint | |
| m_requisition | help | varchar | 2000 | √ | null | Comment or Hint |