| SchemaSpy Analysis of idempiere9.adempiere - ColumnsRfQ | Generated by Quality Systems & Solutions |
| Generated on 2021-12-25 14:55 +0100 |
| |||||
|
| ||||||
idempiere9.adempiere contains 675 columns - click on heading to sort:
| Table | Column | Type | Size | Nulls | Auto | Default | |
|---|---|---|---|---|---|---|---|
| c_rfqresponse | checkcomplete | bpchar | 1 | √ | null | Check Complete | |
| ad_user | connectionprofile | bpchar | 1 | √ | null | How a Java Client connects to the server(s) | |
| c_order | copyfrom | bpchar | 1 | √ | null | Copy From Record | |
| m_product | copyfrom | bpchar | 1 | √ | NULL::bpchar | Copy From Record | |
| c_rfq | copylines | bpchar | 1 | √ | null | Copy Lines | |
| ad_printformat | createcopy | bpchar | 1 | √ | null | Create Copy | |
| c_rfq | createpo | bpchar | 1 | √ | null | Create Purchase Order | |
| c_rfq | createso | bpchar | 1 | √ | null | Create SO | |
| 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_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_printformat | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| 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_bpartner_location | 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_currency | 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_rfq | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_rfq_topic | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_rfq_topicsubscriber | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_rfq_topicsubscriberonly | 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 | ||
| c_rfqlineqty | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_rfqresponse | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_rfqresponseline | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_rfqresponselineqty | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| c_uom | 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_pricelist | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| m_pricelist_version | 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_product_category | isactive | bpchar | 1 | 'Y'::bpchar | The record is active in the system | ||
| r_contactinterest | 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_order | 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 | ||
| c_bpartner_location | isbillto | bpchar | 1 | 'Y'::bpchar | Business Partner Invoice/Bill Address | ||
| m_product | isbom | bpchar | 1 | 'N'::bpchar | Bill of Materials | ||
| ad_printformat | isbreakpageperrecord | bpchar | 1 | 'Y'::bpchar | Page Break after each record | ||
| c_rfqresponse | iscomplete | bpchar | 1 | 'N'::bpchar | It is complete | ||
| 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 | ||
| ad_printformat | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
| c_uom | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
| m_pricelist | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
| m_product_category | isdefault | bpchar | 1 | 'N'::bpchar | Default value | ||
| c_order | isdelivered | bpchar | 1 | 'N'::bpchar | Delivered | ||
| 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_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 | ||
| c_currency | isemumember | bpchar | 1 | 'N'::bpchar | This currency is member if the European Monetary Union | ||
| c_currency | iseuro | bpchar | 1 | 'N'::bpchar | This currency is the Euro | ||
| m_product | isexcludeautodelivery | bpchar | 1 | 'N'::bpchar | Exclude from automatic Delivery | ||
| ad_user | isexpired | bpchar | 1 | 'N'::bpchar | Expired | ||
| ad_printformat | isform | bpchar | 1 | 'N'::bpchar | If Selected, a Form is printed, if not selected a columnar List report | ||
| ad_user | isfullbpaccess | bpchar | 1 | 'Y'::bpchar | The user/contact has full access to Business Partner information and resources | ||
| ad_user | isinpayroll | bpchar | 1 | 'N'::bpchar | Defined if any User Contact will be used for Calculate Payroll | ||
| c_rfq | isinvitedvendorsonly | bpchar | 1 | 'N'::bpchar | Only invited vendors can respond to an RfQ | ||
| 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 | |
| c_bpartner_product | 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_rfqlineqty | isofferqty | bpchar | 1 | 'N'::bpchar | This quantity is used in the Offer to the Customer | ||
| c_bpartner | isonetime | bpchar | 1 | 'N'::bpchar | One time transaction | ||
| m_product | isownbox | bpchar | 1 | 'N'::bpchar | Own Box | ||
| c_bpartner_location | ispayfrom | bpchar | 1 | 'Y'::bpchar | Business Partner pays from that address and we'll send dunning letters there | ||
| 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_bpartner | ispotaxexempt | bpchar | 1 | 'N'::bpchar | Business partner is exempt from tax on purchases | ||
| m_pricelist | ispresentforproduct | bpchar | 1 | √ | 'N'::bpchar | isPresentForProduct | |
| c_bpartner_location | ispreservecustomname | bpchar | 1 | 'N'::bpchar | Preserve custom name | ||
| c_order | isprinted | bpchar | 1 | 'N'::bpchar | Indicates if this document / line is printed | ||
| c_order | ispriviledgedrate | bpchar | 1 | 'N'::bpchar | Priviledged Rate | ||
| c_bpartner | isprospect | bpchar | 1 | 'N'::bpchar | Indicates this is a Prospect | ||
| m_product | ispurchased | bpchar | 1 | 'Y'::bpchar | Organization purchases this product | ||
| c_rfqlineqty | ispurchaseqty | bpchar | 1 | 'N'::bpchar | This quantity is used in the Purchase Order to the Supplier | ||
| c_rfq | isquoteallqty | bpchar | 1 | 'Y'::bpchar | Suppliers are requested to provide responses for all quantities | ||
| c_rfq | isquotetotalamt | bpchar | 1 | 'N'::bpchar | The response can have just the total amount for the RfQ | ||
| c_bpartner_location | isremitto | bpchar | 1 | 'Y'::bpchar | Business Partner payment address | ||
| c_rfqlineqty | isrfqqty | bpchar | 1 | 'Y'::bpchar | The quantity is used when generating RfQ Responses | ||
| c_rfq | isrfqresponseaccepted | bpchar | 1 | 'Y'::bpchar | Are Responses to the Request for Quotation accepted | ||
| 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_order | isselected | bpchar | 1 | 'N'::bpchar | Selected | ||
| c_rfqresponse | isselectedwinner | bpchar | 1 | 'N'::bpchar | The response is the selected winner | ||
| c_rfqresponseline | isselectedwinner | bpchar | 1 | 'N'::bpchar | The response is the selected winner | ||
| c_order | isselfservice | bpchar | 1 | 'N'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
| c_rfq | isselfservice | bpchar | 1 | 'N'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
| c_rfq_topic | isselfservice | bpchar | 1 | 'N'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
| c_rfqresponse | isselfservice | bpchar | 1 | 'N'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
| c_rfqresponseline | 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 | ||
| m_product_category | isselfservice | bpchar | 1 | 'Y'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | ||
| ad_user | isshipto | bpchar | 1 | 'N'::bpchar | Business Partner Shipment Address | ||
| c_bpartner_location | isshipto | bpchar | 1 | 'Y'::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_order | issotrx | bpchar | 1 | 'Y'::bpchar | This is a Sales Transaction | ||
| ad_printformat | isstandardheaderfooter | bpchar | 1 | 'Y'::bpchar | The standard Header and Footer is used | ||
| 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 | ||
| ad_printformat | istablebased | bpchar | 1 | 'Y'::bpchar | Table based List Reporting | ||
| c_bpartner | istaxexempt | bpchar | 1 | √ | 'N'::bpchar | Business partner is exempt from tax on sales | |
| 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 | ||
| m_product_category | mmpolicy | bpchar | 1 | 'F'::bpchar | Material Movement Policy | ||
| 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_order | posted | bpchar | 1 | 'N'::bpchar | Posting status | ||
| c_order | priorityrule | bpchar | 1 | Priority of a document | |||
| m_pricelist_version | proccreate | bpchar | 1 | √ | null | Create | |
| c_order | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
| c_rfq | processed | bpchar | 1 | 'N'::bpchar | The document has been processed | ||
| c_rfqresponse | 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_rfq | processing | bpchar | 1 | √ | null | Process Now | |
| c_rfqresponse | 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_rfq | publishrfq | bpchar | 1 | √ | null | Publish RfQ | |
| c_rfq | quotetype | bpchar | 1 | Request for Quotation Type | |||
| c_rfq | rankrfq | bpchar | 1 | √ | null | Rank RfQ | |
| 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 | ||
| 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 | |||
| c_order | docstatus | bpchar | 2 | The current status of the document | |||
| c_currency | iso_code | bpchar | 3 | Three letter ISO 4217 Code of the Currency | |||
| 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_rfqlineqty | benchmarkprice | numeric | 0 | 0 | Price to compare responses to | ||
| c_rfqlineqty | bestresponseamt | numeric | 0 | √ | 0 | Best Response Amount | |
| c_order | chargeamt | numeric | 0 | √ | 0 | Charge Amount | |
| c_rfqresponselineqty | discount | numeric | 0 | √ | null | Discount in percent | |
| c_currency | emurate | numeric | 0 | √ | 0 | Official rate to the Euro | |
| c_bpartner | flatdiscount | numeric | 0 | √ | null | Flat discount percentage | |
| c_order | freightamt | numeric | 0 | √ | 0 | Freight Amount | |
| c_order | grandtotal | numeric | 0 | 0 | Total amount of document | ||
| c_rfq | margin | numeric | 0 | √ | null | Margin for a product as a percentage | |
| c_rfqlineqty | margin | numeric | 0 | √ | null | Margin for a product as a percentage | |
| c_rfqlineqty | offeramt | numeric | 0 | √ | 0 | Amount of the Offer | |
| m_product_category | plannedmargin | numeric | 0 | Project's planned margin as a percentage | |||
| c_bpartner | potentiallifetimevalue | numeric | 0 | √ | 0 | Total Revenue expected | |
| c_rfqresponse | price | numeric | 0 | 0 | Price | ||
| c_rfqresponselineqty | price | numeric | 0 | 0 | Price | ||
| c_order | processedon | numeric | 0 | √ | null | The date+time (expressed in decimal format) when the document has been processed | |
| c_rfqlineqty | qty | numeric | 0 | 0 | Quantity | ||
| c_bpartner_product | qualityrating | numeric | 0 | √ | null | Method for rating vendors | |
| c_currency | roundofffactor | numeric | 0 | √ | null | Used to Round Off Payment 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 | ||
| 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 | |
| m_product_category | a_asset_group_id | numeric | 10 | √ | null | Group of Assets | |
| ad_printformat | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| ad_user | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| c_bpartner | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| c_bpartner_location | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| c_bpartner_product | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| c_currency | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| c_order | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| c_rfq | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| c_rfq_topic | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| c_rfq_topicsubscriber | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| c_rfq_topicsubscriberonly | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| c_rfqline | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| c_rfqlineqty | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| c_rfqresponse | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| c_rfqresponseline | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| c_rfqresponselineqty | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| c_uom | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| m_attributesetinstance | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| m_pricelist | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| m_pricelist_version | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| m_product | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| m_product_category | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| r_contactinterest | ad_client_id | numeric | 10 | Client/Tenant for this installation. | |||
| ad_user | ad_image_id | numeric | 10 | √ | NULL::numeric | Image or Icon | |
| ad_printformat | ad_org_id | numeric | 10 | Organizational entity within client | |||
| ad_user | ad_org_id | numeric | 10 | Organizational entity within client | |||
| c_bpartner | ad_org_id | numeric | 10 | Organizational entity within client | |||
| c_bpartner_location | ad_org_id | numeric | 10 | Organizational entity within client | |||
| c_bpartner_product | ad_org_id | numeric | 10 | Organizational entity within client | |||
| c_currency | ad_org_id | numeric | 10 | Organizational entity within client | |||
| c_order | ad_org_id | numeric | 10 | Organizational entity within client | |||
| c_rfq | ad_org_id | numeric | 10 | Organizational entity within client | |||
| c_rfq_topic | ad_org_id | numeric | 10 | Organizational entity within client | |||
| c_rfq_topicsubscriber | ad_org_id | numeric | 10 | Organizational entity within client | |||
| c_rfq_topicsubscriberonly | ad_org_id | numeric | 10 | Organizational entity within client | |||
| c_rfqline | ad_org_id | numeric | 10 | Organizational entity within client | |||
| c_rfqlineqty | ad_org_id | numeric | 10 | Organizational entity within client | |||
| c_rfqresponse | ad_org_id | numeric | 10 | Organizational entity within client | |||
| c_rfqresponseline | ad_org_id | numeric | 10 | Organizational entity within client | |||
| c_rfqresponselineqty | ad_org_id | numeric | 10 | Organizational entity within client | |||
| c_uom | ad_org_id | numeric | 10 | Organizational entity within client | |||
| m_attributesetinstance | ad_org_id | numeric | 10 | Organizational entity within client | |||
| m_pricelist | ad_org_id | numeric | 10 | Organizational entity within client | |||
| m_pricelist_version | ad_org_id | numeric | 10 | Organizational entity within client | |||
| m_product | ad_org_id | numeric | 10 | Organizational entity within client | |||
| m_product_category | ad_org_id | numeric | 10 | Organizational entity within client | |||
| r_contactinterest | ad_org_id | numeric | 10 | Organizational entity within client | |||
| 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_order | ad_orgtrx_id | numeric | 10 | √ | null | Performing or initiating organization | |
| ad_printformat | ad_printcolor_id | numeric | 10 | Color used for printing and display | |||
| m_product_category | ad_printcolor_id | numeric | 10 | √ | null | Color used for printing and display | |
| ad_printformat | ad_printfont_id | numeric | 10 | Maintain Print Font | |||
| ad_printformat | ad_printformat_id | numeric | 10 | Data Print Format | |||
| c_rfq_topic | ad_printformat_id | numeric | 10 | √ | null | Data Print Format | |
| ad_printformat | ad_printheaderfooter_id | numeric | 10 | √ | NULL::numeric | Print Header/Footer | |
| ad_printformat | ad_printpaper_id | numeric | 10 | Printer paper definition | |||
| ad_printformat | ad_printtableformat_id | numeric | 10 | √ | null | Table Format in Reports | |
| ad_printformat | ad_reportview_id | numeric | 10 | √ | null | View used to generate this report | |
| ad_printformat | ad_table_id | numeric | 10 | Database Table information | |||
| 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 | |
| c_rfq | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
| c_rfq_topicsubscriber | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
| c_rfqresponse | ad_user_id | numeric | 10 | √ | null | User within the system - Internal or Business Partner Contact | |
| r_contactinterest | ad_user_id | numeric | 10 | User within the system - Internal or Business Partner Contact | |||
| ad_printformat | ad_window_id | numeric | 10 | √ | NULL::numeric | Data entry or display window | |
| 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_order | 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_bpartner_location | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
| c_bpartner_product | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
| c_order | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
| c_rfq | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
| c_rfq_topicsubscriber | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
| c_rfqresponse | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
| ad_user | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
| c_bpartner_location | c_bpartner_location_id | numeric | 10 | 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_rfq | c_bpartner_location_id | numeric | 10 | √ | null | Identifies the (ship to) address for this Business Partner | |
| c_rfq_topicsubscriber | c_bpartner_location_id | numeric | 10 | Identifies the (ship to) address for this Business Partner | |||
| c_rfqresponse | c_bpartner_location_id | numeric | 10 | Identifies the (ship to) address for this Business Partner | |||
| ad_user | c_campaign_id | numeric | 10 | √ | NULL::numeric | Marketing Campaign | |
| c_order | c_campaign_id | numeric | 10 | √ | null | Marketing Campaign | |
| c_order | c_cashline_id | numeric | 10 | √ | null | Cash Journal Line | |
| c_order | c_cashplanline_id | numeric | 10 | √ | NULL::numeric | Cash Plan Line | |
| c_order | c_charge_id | numeric | 10 | √ | null | Additional document charges | |
| c_order | c_conversiontype_id | numeric | 10 | √ | null | Currency Conversion Rate Type | |
| c_currency | c_currency_id | numeric | 10 | The Currency for this record | |||
| c_order | c_currency_id | numeric | 10 | The Currency for this record | |||
| c_rfq | c_currency_id | numeric | 10 | The Currency for this record | |||
| c_rfqresponse | c_currency_id | numeric | 10 | The Currency for this record | |||
| m_pricelist | c_currency_id | numeric | 10 | The Currency for this record | |||
| c_order | c_doctype_id | numeric | 10 | Document type or rules | |||
| 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 | |
| c_bpartner_location | c_location_id | numeric | 10 | √ | null | Location or Address | |
| c_order | c_opportunity_id | numeric | 10 | √ | NULL::numeric | Sales Opportunity | |
| c_order | c_order_id | numeric | 10 | Order | |||
| c_rfq | c_order_id | numeric | 10 | √ | null | Order | |
| c_rfqresponse | c_order_id | numeric | 10 | √ | null | Order | |
| 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_order | c_pos_id | numeric | 10 | √ | null | Point of Sales Terminal | |
| c_order | c_project_id | numeric | 10 | √ | null | Financial Project | |
| m_product | c_revenuerecognition_id | numeric | 10 | √ | null | Method for recording revenue | |
| c_rfq | c_rfq_id | numeric | 10 | Request for Quotation | |||
| c_rfqline | c_rfq_id | numeric | 10 | Request for Quotation | |||
| c_rfqresponse | c_rfq_id | numeric | 10 | Request for Quotation | |||
| c_rfq | c_rfq_topic_id | numeric | 10 | Topic for Request for Quotations | |||
| c_rfq_topic | c_rfq_topic_id | numeric | 10 | Topic for Request for Quotations | |||
| c_rfq_topicsubscriber | c_rfq_topic_id | numeric | 10 | Topic for Request for Quotations | |||
| c_rfq_topicsubscriber | c_rfq_topicsubscriber_id | numeric | 10 | Request for Quotation Topic Subscriber | |||
| c_rfq_topicsubscriberonly | c_rfq_topicsubscriber_id | numeric | 10 | Request for Quotation Topic Subscriber | |||
| c_rfq_topicsubscriberonly | c_rfq_topicsubscriberonly_id | numeric | 10 | Include Subscriber only for certain products or product categories | |||
| c_rfqline | c_rfqline_id | numeric | 10 | Request for Quotation Line | |||
| c_rfqlineqty | c_rfqline_id | numeric | 10 | Request for Quotation Line | |||
| c_rfqresponseline | c_rfqline_id | numeric | 10 | Request for Quotation Line | |||
| c_rfqlineqty | c_rfqlineqty_id | numeric | 10 | Request for Quotation Line Quantity | |||
| c_rfqresponselineqty | c_rfqlineqty_id | numeric | 10 | Request for Quotation Line Quantity | |||
| c_rfqresponse | c_rfqresponse_id | numeric | 10 | Request for Quotation Response from a potential Vendor | |||
| c_rfqresponseline | c_rfqresponse_id | numeric | 10 | Request for Quotation Response from a potential Vendor | |||
| c_rfqresponseline | c_rfqresponseline_id | numeric | 10 | Request for Quotation Response Line | |||
| c_rfqresponselineqty | c_rfqresponseline_id | numeric | 10 | Request for Quotation Response Line | |||
| c_rfqresponselineqty | c_rfqresponselineqty_id | numeric | 10 | Request for Quotation Response Line Quantity | |||
| c_bpartner_location | c_salesregion_id | numeric | 10 | √ | null | Sales coverage region | |
| m_product | c_subscriptiontype_id | numeric | 10 | √ | null | Type of subscription | |
| m_product | c_taxcategory_id | numeric | 10 | Tax Category | |||
| c_bpartner | c_taxgroup_id | numeric | 10 | √ | null | Tax Group | |
| c_rfqlineqty | c_uom_id | numeric | 10 | Unit of Measure | |||
| c_uom | c_uom_id | numeric | 10 | Unit of Measure | |||
| m_product | c_uom_id | numeric | 10 | Unit of Measure | |||
| c_currency | costingprecision | numeric | 10 | Rounding used costing calculations | |||
| c_uom | costingprecision | numeric | 10 | Rounding used costing calculations | |||
| ad_printformat | createdby | numeric | 10 | User who created this records | |||
| ad_user | createdby | numeric | 10 | User who created this records | |||
| c_bpartner | createdby | numeric | 10 | User who created this records | |||
| c_bpartner_location | createdby | numeric | 10 | User who created this records | |||
| c_bpartner_product | createdby | numeric | 10 | User who created this records | |||
| c_currency | createdby | numeric | 10 | User who created this records | |||
| c_order | createdby | numeric | 10 | User who created this records | |||
| c_rfq | createdby | numeric | 10 | User who created this records | |||
| c_rfq_topic | createdby | numeric | 10 | User who created this records | |||
| c_rfq_topicsubscriber | createdby | numeric | 10 | User who created this records | |||
| c_rfq_topicsubscriberonly | createdby | numeric | 10 | User who created this records | |||
| c_rfqline | createdby | numeric | 10 | User who created this records | |||
| c_rfqlineqty | createdby | numeric | 10 | User who created this records | |||
| c_rfqresponse | createdby | numeric | 10 | User who created this records | |||
| c_rfqresponseline | createdby | numeric | 10 | User who created this records | |||
| c_rfqresponselineqty | createdby | numeric | 10 | User who created this records | |||
| c_uom | createdby | numeric | 10 | User who created this records | |||
| m_attributesetinstance | createdby | numeric | 10 | User who created this records | |||
| m_pricelist | createdby | numeric | 10 | User who created this records | |||
| m_pricelist_version | createdby | numeric | 10 | User who created this records | |||
| m_product | createdby | numeric | 10 | User who created this records | |||
| m_product_category | createdby | numeric | 10 | User who created this records | |||
| r_contactinterest | createdby | numeric | 10 | User who created this records | |||
| c_bpartner | default1099box_id | numeric | 10 | √ | NULL::numeric | Default 1099 Box | |
| c_rfq | deliverydays | numeric | 10 | √ | 0 | Number of Days (planned) until Delivery | |
| c_rfqline | deliverydays | numeric | 10 | √ | 0 | Number of Days (planned) until Delivery | |
| c_rfqresponse | deliverydays | numeric | 10 | √ | 0 | Number of Days (planned) until Delivery | |
| c_rfqresponseline | deliverydays | numeric | 10 | √ | 0 | Number of Days (planned) until Delivery | |
| c_bpartner | documentcopies | numeric | 10 | √ | null | 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 | ||
| ad_printformat | footermargin | numeric | 10 | Margin of the Footer in 1/72 of an inch | |||
| 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 | |
| ad_printformat | headermargin | numeric | 10 | Margin of the Header in 1/72 of an inch | |||
| c_bpartner | invoice_printformat_id | numeric | 10 | √ | null | Print Format for printing Invoices | |
| ad_printformat | jasperprocess_id | numeric | 10 | √ | null | The Jasper Process used by the printengine if any process defined | |
| c_rfqline | line | numeric | 10 | 0 | 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_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_attributesetinstance | m_attributeset_id | numeric | 10 | √ | null | Product Attribute Set | |
| m_product | m_attributeset_id | numeric | 10 | √ | null | Product Attribute Set | |
| c_rfqline | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
| m_attributesetinstance | m_attributesetinstance_id | numeric | 10 | Product Attribute Set Instance | |||
| m_product | m_attributesetinstance_id | numeric | 10 | √ | 0 | Product Attribute Set Instance | |
| c_bpartner | m_discountschema_id | numeric | 10 | √ | null | Schema to calculate the trade discount percentage | |
| m_pricelist_version | m_discountschema_id | numeric | 10 | Schema to calculate the trade discount percentage | |||
| 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_attributesetinstance | m_lot_id | numeric | 10 | √ | null | Product Lot Definition | |
| 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_pricelist | m_pricelist_id | numeric | 10 | Unique identifier of a Price List | |||
| m_pricelist_version | m_pricelist_id | numeric | 10 | Unique identifier of a Price List | |||
| m_pricelist_version | m_pricelist_version_base_id | numeric | 10 | √ | null | Source for Price list calculations | |
| m_pricelist_version | m_pricelist_version_id | numeric | 10 | Identifies a unique instance of a Price List | |||
| c_rfq_topicsubscriberonly | m_product_category_id | numeric | 10 | √ | null | Category of a Product | |
| m_product | m_product_category_id | numeric | 10 | Category of a Product | |||
| m_product_category | m_product_category_id | numeric | 10 | Category of a Product | |||
| m_product_category | m_product_category_parent_id | numeric | 10 | √ | null | Parent Product Category | |
| c_bpartner_product | m_product_id | numeric | 10 | Product, Service, Item | |||
| c_rfq_topicsubscriberonly | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
| c_rfqline | m_product_id | numeric | 10 | √ | null | Product, Service, Item | |
| m_product | m_product_id | numeric | 10 | Product, Service, Item | |||
| c_order | 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_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_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 | |
| 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 | |
| r_contactinterest | r_interestarea_id | numeric | 10 | Interest Area or Topic | |||
| m_product | r_mailtext_id | numeric | 10 | √ | null | Text templates for mailings | |
| c_rfqresponse | ranking | numeric | 10 | √ | 0 | Relative Rank Number | |
| c_rfqresponselineqty | ranking | numeric | 10 | √ | 0 | Relative Rank Number | |
| c_order | ref_order_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 | |
| 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 | |
| c_rfq | salesrep_id | numeric | 10 | 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_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 | |
| c_currency | stdprecision | numeric | 10 | Rule for rounding calculated amounts | |||
| c_uom | stdprecision | numeric | 10 | Rule for rounding calculated amounts | |||
| 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_printformat | updatedby | numeric | 10 | User who updated this records | |||
| ad_user | updatedby | numeric | 10 | User who updated this records | |||
| c_bpartner | updatedby | numeric | 10 | User who updated this records | |||
| c_bpartner_location | updatedby | numeric | 10 | User who updated this records | |||
| c_bpartner_product | updatedby | numeric | 10 | User who updated this records | |||
| c_currency | updatedby | numeric | 10 | User who updated this records | |||
| c_order | updatedby | numeric | 10 | User who updated this records | |||
| c_rfq | updatedby | numeric | 10 | User who updated this records | |||
| c_rfq_topic | updatedby | numeric | 10 | User who updated this records | |||
| c_rfq_topicsubscriber | updatedby | numeric | 10 | User who updated this records | |||
| c_rfq_topicsubscriberonly | updatedby | numeric | 10 | User who updated this records | |||
| c_rfqline | updatedby | numeric | 10 | User who updated this records | |||
| c_rfqlineqty | updatedby | numeric | 10 | User who updated this records | |||
| c_rfqresponse | updatedby | numeric | 10 | User who updated this records | |||
| c_rfqresponseline | updatedby | numeric | 10 | User who updated this records | |||
| c_rfqresponselineqty | updatedby | numeric | 10 | User who updated this records | |||
| c_uom | updatedby | numeric | 10 | User who updated this records | |||
| m_attributesetinstance | updatedby | numeric | 10 | User who updated this records | |||
| m_pricelist | updatedby | numeric | 10 | User who updated this records | |||
| m_pricelist_version | updatedby | numeric | 10 | User who updated this records | |||
| m_product | updatedby | numeric | 10 | User who updated this records | |||
| m_product_category | updatedby | numeric | 10 | User who updated this records | |||
| r_contactinterest | updatedby | numeric | 10 | User who updated this records | |||
| c_order | user1_id | numeric | 10 | √ | null | User defined list element #1 | |
| c_order | user2_id | numeric | 10 | √ | null | User defined list element #2 | |
| c_order | amountrefunded | numeric | 22,2 | √ | null | AmountRefunded | |
| c_order | amounttendered | numeric | 22,2 | √ | null | AmountTendered | |
| ad_user | birthday | timestamp | 29,6 | √ | null | Birthday or Anniversary day | |
| ad_printformat | created | timestamp | 29,6 | now() | Date this record was created | ||
| 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_bpartner_location | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_bpartner_product | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_currency | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_order | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_rfq | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_rfq_topic | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_rfq_topicsubscriber | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_rfq_topicsubscriberonly | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_rfqline | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_rfqlineqty | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_rfqresponse | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_rfqresponseline | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_rfqresponselineqty | created | timestamp | 29,6 | now() | Date this record was created | ||
| c_uom | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_attributesetinstance | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_pricelist | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_pricelist_version | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_product | created | timestamp | 29,6 | now() | Date this record was created | ||
| m_product_category | created | timestamp | 29,6 | now() | Date this record was created | ||
| r_contactinterest | 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_rfqresponse | dateinvited | timestamp | 29,6 | √ | null | Date when (last) invitation was sent | |
| ad_user | datelastlogin | timestamp | 29,6 | √ | null | Date Last Login | |
| c_order | 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_rfq | dateresponse | timestamp | 29,6 | Date of the Response | |||
| c_rfqresponse | dateresponse | timestamp | 29,6 | √ | null | Date of the Response | |
| c_rfq | dateworkcomplete | timestamp | 29,6 | √ | null | Date when work is (planned to be) complete | |
| c_rfqline | dateworkcomplete | timestamp | 29,6 | √ | null | Date when work is (planned to be) complete | |
| c_rfqresponse | dateworkcomplete | timestamp | 29,6 | √ | null | Date when work is (planned to be) complete | |
| c_rfqresponseline | dateworkcomplete | timestamp | 29,6 | √ | null | Date when work is (planned to be) complete | |
| c_rfq | dateworkstart | timestamp | 29,6 | √ | null | Date when work is (planned to be) started | |
| c_rfqline | dateworkstart | timestamp | 29,6 | √ | null | Date when work is (planned to be) started | |
| c_rfqresponse | dateworkstart | timestamp | 29,6 | √ | null | Date when work is (planned to be) started | |
| c_rfqresponseline | 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 | |
| ad_user | emailverifydate | timestamp | 29,6 | √ | null | Date Email was verified | |
| c_currency | emuentrydate | timestamp | 29,6 | √ | null | Date when the currency joined / will join the EMU | |
| c_bpartner | firstsale | timestamp | 29,6 | √ | null | Date of First Sale | |
| m_attributesetinstance | guaranteedate | timestamp | 29,6 | √ | null | Date when guarantee expires | |
| ad_user | lastcontact | timestamp | 29,6 | √ | null | Date this individual was last contacted | |
| c_rfq_topicsubscriber | optoutdate | timestamp | 29,6 | √ | null | Date the contact opted out | |
| r_contactinterest | optoutdate | timestamp | 29,6 | √ | null | Date the contact opted out | |
| c_rfq_topicsubscriber | subscribedate | timestamp | 29,6 | √ | null | Date the contact actively subscribed | |
| r_contactinterest | subscribedate | timestamp | 29,6 | √ | null | Date the contact actively subscribed | |
| ad_printformat | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| 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_bpartner_location | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_bpartner_product | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_currency | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_order | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_rfq | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_rfq_topic | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_rfq_topicsubscriber | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_rfq_topicsubscriberonly | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_rfqline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_rfqlineqty | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_rfqresponse | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_rfqresponseline | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_rfqresponselineqty | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| c_uom | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_attributesetinstance | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_pricelist | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_pricelist_version | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_product | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_product_category | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| r_contactinterest | updated | timestamp | 29,6 | now() | Date this record was updated | ||
| m_pricelist_version | validfrom | timestamp | 29,6 | Valid from including this date (first day) | |||
| c_uom | uomtype | varchar | 2 | √ | NULL::character varying | UOM Type | |
| c_uom | x12de355 | varchar | 4 | UOM EDI X12 Code | |||
| 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 | |
| c_currency | cursymbol | varchar | 10 | √ | null | Symbol of the currency (opt used for printing only) | |
| 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_uom | uomsymbol | varchar | 10 | √ | null | Symbol for a Unit of Measure | |
| 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_order | documentno | varchar | 30 | Document sequence number of the document | |||
| c_rfq | documentno | varchar | 30 | '.'::character varying | Document sequence number of the document | ||
| c_bpartner_product | manufacturer | varchar | 30 | √ | null | Manufacturer of the Product | |
| 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) | |
| 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 | |
| ad_printformat | ad_printformat_uu | varchar | 36 | √ | NULL::character varying | AD_PrintFormat_UU | |
| ad_user | ad_user_uu | varchar | 36 | √ | NULL::character varying | AD_User_UU | |
| c_bpartner_location | c_bpartner_location_uu | varchar | 36 | √ | NULL::character varying | C_BPartner_Location_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_currency | c_currency_uu | varchar | 36 | √ | NULL::character varying | C_Currency_UU | |
| c_order | c_order_uu | varchar | 36 | √ | NULL::character varying | C_Order_UU | |
| c_rfq_topic | c_rfq_topic_uu | varchar | 36 | √ | NULL::character varying | C_RfQ_Topic_UU | |
| c_rfq_topicsubscriber | c_rfq_topicsubscriber_uu | varchar | 36 | √ | NULL::character varying | C_RfQ_TopicSubscriber_UU | |
| c_rfq_topicsubscriberonly | c_rfq_topicsubscriberonly_uu | varchar | 36 | √ | NULL::character varying | C_RfQ_TopicSubscriberOnly_UU | |
| c_rfq | c_rfq_uu | varchar | 36 | √ | NULL::character varying | C_RfQ_UU | |
| c_rfqline | c_rfqline_uu | varchar | 36 | √ | NULL::character varying | C_RfQLine_UU | |
| c_rfqlineqty | c_rfqlineqty_uu | varchar | 36 | √ | NULL::character varying | C_RfQLineQty_UU | |
| c_rfqresponse | c_rfqresponse_uu | varchar | 36 | √ | NULL::character varying | C_RfQResponse_UU | |
| c_rfqresponseline | c_rfqresponseline_uu | varchar | 36 | √ | NULL::character varying | C_RfQResponseLine_UU | |
| c_rfqresponselineqty | c_rfqresponselineqty_uu | varchar | 36 | √ | NULL::character varying | C_RfQResponseLineQty_UU | |
| c_uom | c_uom_uu | varchar | 36 | √ | NULL::character varying | C_UOM_UU | |
| m_attributesetinstance | m_attributesetinstance_uu | varchar | 36 | √ | NULL::character varying | M_AttributeSetInstance_UU | |
| m_pricelist | m_pricelist_uu | varchar | 36 | √ | NULL::character varying | M_PriceList_UU | |
| m_pricelist_version | m_pricelist_version_uu | varchar | 36 | √ | NULL::character varying | M_PriceList_Version_UU | |
| m_product_category | m_product_category_uu | varchar | 36 | √ | NULL::character varying | M_Product_Category_UU | |
| m_product | m_product_uu | varchar | 36 | √ | NULL::character varying | M_Product_UU | |
| r_contactinterest | r_contactinterest_uu | varchar | 36 | √ | NULL::character varying | R_ContactInterest_UU | |
| ad_user | emailverify | varchar | 40 | √ | null | Verification information of EMail Address | |
| ad_user | fax | varchar | 40 | √ | null | Facsimile number | |
| c_bpartner_location | fax | varchar | 40 | √ | null | Facsimile number | |
| c_bpartner_location | isdn | varchar | 40 | √ | null | ISDN or modem line | |
| m_attributesetinstance | lot | varchar | 40 | √ | null | Lot number (alphanumeric) | |
| ad_user | phone | varchar | 40 | √ | null | Identifies a telephone number | |
| c_bpartner_location | phone | varchar | 40 | √ | null | Identifies a telephone number | |
| ad_user | phone2 | varchar | 40 | √ | null | Identifies an alternate telephone number. | |
| c_bpartner_location | phone2 | varchar | 40 | √ | null | Identifies an alternate telephone number. | |
| ad_printformat | printername | varchar | 40 | √ | null | Name of the Printer | |
| 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_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_product | value | varchar | 40 | Search key for the record in the format required - must be unique | |||
| m_product_category | 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_location | customeraddressid | varchar | 60 | √ | NULL::character varying | Customer Address ID | |
| 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_printformat | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| ad_user | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_bpartner_location | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_rfq | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_rfq_topic | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_rfqresponse | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| c_uom | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| m_pricelist | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| m_pricelist_version | name | varchar | 60 | Alphanumeric identifier of the entity | |||
| m_product_category | 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 | |
| ad_printformat | classname | varchar | 240 | √ | null | Java Classname | |
| ad_printformat | description | varchar | 255 | √ | null | Optional short description of the record | |
| 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_bpartner_product | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_currency | description | varchar | 255 | Optional short description of the record | |||
| c_order | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_rfq | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_rfq_topic | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_rfq_topicsubscriberonly | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_rfqline | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_rfqresponse | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_rfqresponseline | description | varchar | 255 | √ | null | Optional short description of the record | |
| c_uom | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_attributesetinstance | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_pricelist | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_pricelist_version | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_product | description | varchar | 255 | √ | null | Optional short description of the record | |
| m_product_category | 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 | |
| ad_printformat | args | varchar | 510 | √ | null | Args | |
| c_order | ordertype | varchar | 510 | √ | null | Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition) | |
| 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 | |
| m_product | documentnote | varchar | 2000 | √ | null | Additional information for a Document | |
| c_rfq | help | varchar | 2000 | √ | null | Comment or Hint | |
| c_rfqline | help | varchar | 2000 | √ | null | Comment or Hint | |
| c_rfqresponse | help | varchar | 2000 | √ | null | Comment or Hint | |
| c_rfqresponseline | help | varchar | 2000 | √ | null | Comment or Hint | |
| m_product | help | varchar | 2000 | √ | null | Comment or Hint |