SchemaSpy Analysis of idempiere9.adempiere - ColumnsProject Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:54 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere9.adempiere contains 1000 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
a_asset a_qty_current numeric 0  √  null Current Qty
a_asset a_qty_original numeric 0  √  null A_QTY_Original
c_bpartner acqusitioncost numeric 0  √  0 The cost of gaining the prospect as a customer
c_bpartner actuallifetimevalue numeric 0  √  0 Actual Life Time Revenue
s_resource chargeableqty numeric 0  √  0 Chargeable Quantity
c_invoice chargeamt numeric 0  √  0 Charge Amount
c_order chargeamt numeric 0  √  0 Charge Amount
m_inout chargeamt numeric 0  √  0 Charge Amount
c_project committedamt numeric 0 0 The (legal) commitment amount
c_projectline committedamt numeric 0  √  0 The (legal) commitment amount
c_projectphase committedamt numeric 0 0 The (legal) commitment amount
c_projecttask committedamt numeric 0 0 The (legal) commitment amount
c_project committedqty numeric 0 0 The (legal) commitment Quantity
c_projectline committedqty numeric 0  √  0 The (legal) commitment Quantity
m_inoutline confirmedqty numeric 0  √  0 Confirmation of a received quantity
s_timeexpenseline convertedamt numeric 0  √  0 Converted Amount
c_invoice currencyrate numeric 0  √  null Currency Conversion Rate
s_resource dailycapacity numeric 0  √  null Daily Capacity
c_orderline discount numeric 0  √  null Discount in percent
c_paymentterm discount numeric 0 Discount in percent
c_paymentterm discount2 numeric 0 Discount in percent
s_timeexpenseline expenseamt numeric 0  √  0 Amount for this expense
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
m_inout freightamt numeric 0  √  0 Freight Amount
c_invoice grandtotal numeric 0 0 Total amount of document
c_order grandtotal numeric 0 0 Total amount of document
c_project invoicedamt numeric 0 0 The amount invoiced
c_projectline invoicedamt numeric 0 0 The amount invoiced
c_project invoicedqty numeric 0 0 The quantity invoiced
c_projectline invoicedqty numeric 0 0 The quantity invoiced
s_timeexpenseline invoiceprice numeric 0  √  0 Unit price to be invoiced or 0 for default price
a_asset lifeuseunits numeric 0  √  null Units of use until the asset is not usable anymore
c_invoiceline linenetamt numeric 0 0 Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_orderline linenetamt numeric 0 0 Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_invoiceline linetotalamt numeric 0  √  0 Total line amount incl. Tax
c_projectissue movementqty numeric 0 0 Quantity of a product moved.
m_inoutline movementqty numeric 0 0 Quantity of a product moved.
m_transaction movementqty numeric 0 0 Quantity of a product moved.
s_resource percentutilization numeric 0 (100)::numeric % Utilization
m_inoutline pickedqty numeric 0  √  0 Picked Quantity
c_project plannedamt numeric 0 0 Planned amount for this project
c_projectline plannedamt numeric 0 0 Planned amount for this project
c_projectphase plannedamt numeric 0 0 Planned amount for this project
c_projecttask plannedamt numeric 0 0 Planned amount for this project
c_project plannedmarginamt numeric 0 0 Project's planned margin amount
c_projectline plannedmarginamt numeric 0 0 Project's planned margin amount
c_projectline plannedprice numeric 0 0 Planned price for this project line
c_project plannedqty numeric 0 0 Planned quantity for this project
c_projectline plannedqty numeric 0 0 Planned quantity for this project
c_bpartner potentiallifetimevalue numeric 0  √  0 Total Revenue expected
c_invoiceline priceactual numeric 0 0 Actual Price
c_orderline priceactual numeric 0 0 Actual Price
c_projectphase priceactual numeric 0  √  0 Actual Price
c_orderline pricecost numeric 0  √  null Price per Unit of Measure including all indirect costs (Freight, etc.)
c_invoiceline priceentered numeric 0 Price Entered - the price based on the selected/base UoM
c_orderline priceentered numeric 0 Price Entered - the price based on the selected/base UoM
s_timeexpenseline priceinvoiced numeric 0  √  null The priced invoiced to the customer (in the currency of the customer's AR price list) - 0 for default price
c_invoiceline pricelimit numeric 0 0 Lowest price for a product
c_orderline pricelimit numeric 0 0 Lowest price for a product
c_invoiceline pricelist numeric 0 0 List Price
c_orderline pricelist numeric 0 0 List Price
s_timeexpenseline pricereimbursed numeric 0  √  null The reimbursed price (in currency of the employee's AP price list)
c_invoice processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
c_order processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
c_projectissue processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
m_inout processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
c_project projectbalanceamt numeric 0 0 Total Project Balance
a_asset qty numeric 0  √  null Quantity
c_projectphase qty numeric 0  √  0 Quantity
c_projecttask qty numeric 0  √  0 Quantity
s_timeexpenseline qty numeric 0  √  0 Quantity
c_orderline qtydelivered numeric 0 0 Delivered Quantity
c_invoiceline qtyentered numeric 0 The Quantity Entered is based on the selected UoM
c_orderline qtyentered numeric 0 The Quantity Entered is based on the selected UoM
m_inoutline qtyentered numeric 0 The Quantity Entered is based on the selected UoM
c_invoiceline qtyinvoiced numeric 0 0 Invoiced Quantity
c_orderline qtyinvoiced numeric 0 0 Invoiced Quantity
s_timeexpenseline qtyinvoiced numeric 0  √  null Invoiced Quantity
c_orderline qtylostsales numeric 0 0 Quantity of potential sales
c_orderline qtyordered numeric 0 0 Ordered Quantity
m_inoutline qtyoverreceipt numeric 0  √  0 Over Receipt Quantity
s_timeexpenseline qtyreimbursed numeric 0  √  null The reimbursed quantity
c_orderline qtyreserved numeric 0 0 Reserved Quantity
s_resource queuingtime numeric 0  √  null Queue time is the time a job waits at a work center before begin handled.
c_cyclestep relativeweight numeric 0 Relative weight of this step (0 = ignored)
c_invoiceline rramt numeric 0  √  null Revenue Recognition Amount
c_orderline rramt numeric 0  √  null Revenue Recognition Amount
m_inoutline scrappedqty numeric 0  √  0 The Quantity scrapped due to QA issues
m_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_phase standardqty numeric 0 0 Standard Quantity
c_task standardqty numeric 0 0 Standard Quantity
m_inoutline targetqty numeric 0  √  0 Target Movement Quantity
c_invoiceline taxamt numeric 0  √  0 Tax Amount for a document
c_invoice totallines numeric 0 0 Total of all document lines
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
a_asset useunits numeric 0  √  null Currently used units of the assets
c_order volume numeric 0  √  null Volume of a product
m_inout volume numeric 0  √  null Volume of a product
m_product volume numeric 0  √  0 Volume of a product
s_resource waitingtime numeric 0  √  null Workflow Simulation Waiting time
c_order weight numeric 0  √  null Weight of a product
m_inout weight numeric 0  √  null Weight of a product
m_product weight numeric 0  √  0 Weight of a product
c_invoiceline a_createasset bpchar 1  √  'N'::bpchar Create Asset
c_invoiceline a_processed bpchar 1  √  'N'::bpchar Processed
c_paymentterm afterdelivery bpchar 1 'N'::bpchar Due after delivery rather than after invoicing
c_invoice copyfrom bpchar 1  √  null Copy From Record
c_order copyfrom bpchar 1  √  null Copy From Record
c_project copyfrom bpchar 1  √  null Copy From Record
m_product copyfrom bpchar 1  √  NULL::bpchar Copy From Record
m_inout createconfirm bpchar 1  √  null Create Confirm
c_invoice createfrom bpchar 1  √  null Process which will generate a new document lines based on an existing document
m_inout createfrom bpchar 1  √  null Process which will generate a new document lines based on an existing document
m_inout createpackage bpchar 1  √  null Create Package
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
m_inout 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_inout deliveryviarule bpchar 1 How the order will be delivered
m_product discontinued bpchar 1  √  'N'::bpchar This product is no longer available
c_projectline dopricing bpchar 1  √  'Y'::bpchar Pricing
c_bpartner freightcostrule bpchar 1  √  null Method for charging Freight
c_order freightcostrule bpchar 1 Method for charging Freight
m_inout freightcostrule bpchar 1 Method for charging Freight
c_projectphase generateorder bpchar 1  √  null Generate Order
c_invoice generateto bpchar 1  √  null Generate To
c_project generateto bpchar 1  √  null Generate To
m_inout generateto bpchar 1  √  null Generate To
m_inout insurance bpchar 1  √  NULL::bpchar Insurance
c_invoice invoicecollectiontype bpchar 1  √  null Invoice Collection Status
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
a_asset isactive bpchar 1 'Y'::bpchar The record is active in the system
c_activity 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_cycle isactive bpchar 1 'Y'::bpchar The record is active in the system
c_cyclephase isactive bpchar 1 'Y'::bpchar The record is active in the system
c_cyclestep isactive bpchar 1 'Y'::bpchar The record is active in the system
c_invoice isactive bpchar 1 'Y'::bpchar The record is active in the system
c_invoiceline isactive bpchar 1 'Y'::bpchar The record is active in the system
c_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_paymentterm isactive bpchar 1 'Y'::bpchar The record is active in the system
c_phase isactive bpchar 1 'Y'::bpchar The record is active in the system
c_project isactive bpchar 1 'Y'::bpchar The record is active in the system
c_projectissue isactive bpchar 1 'Y'::bpchar The record is active in the system
c_projectline isactive bpchar 1 'Y'::bpchar The record is active in the system
c_projectphase isactive bpchar 1 'Y'::bpchar The record is active in the system
c_projecttask isactive bpchar 1 'Y'::bpchar The record is active in the system
c_projecttype isactive bpchar 1 'Y'::bpchar The record is active in the system
c_task isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inout isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inoutline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_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_transaction 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
s_resource isactive bpchar 1 'Y'::bpchar The record is active in the system
s_timeexpenseline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inout isalternatereturnaddress bpchar 1 'N'::bpchar Alternate Return Address
c_invoice isapproved bpchar 1 'Y'::bpchar Indicates if this document requires approval
c_order isapproved bpchar 1 'Y'::bpchar Indicates if this document requires approval
c_projectissue isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
m_inout isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
m_inoutline isautoproduce bpchar 1  √  'N'::bpchar Auto create production to fulfill shipment
m_product isautoproduce bpchar 1 'N'::bpchar Auto create production to fulfill shipment
s_resource isavailable bpchar 1 'Y'::bpchar Resource is available
m_product isbom bpchar 1 'N'::bpchar Bill of Materials
c_project iscommitceiling bpchar 1 'N'::bpchar The commitment amount/quantity is the chargeable ceiling
c_projectphase iscommitceiling bpchar 1 'N'::bpchar The commitment amount/quantity is the chargeable ceiling
c_project iscommitment bpchar 1 'Y'::bpchar Is this document a (legal) commitment?
c_projectphase 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
c_paymentterm isdefault bpchar 1  √  'N'::bpchar Default value
c_order isdelivered bpchar 1 'N'::bpchar Delivered
a_asset isdepreciated bpchar 1 'Y'::bpchar The asset will be depreciated
c_invoiceline isdescription bpchar 1 'N'::bpchar if true, the line is just description and no transaction
c_orderline isdescription bpchar 1 'N'::bpchar if true, the line is just description and no transaction
m_inoutline isdescription bpchar 1 'N'::bpchar if true, the line is just description and no transaction
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_invoice isdiscountprinted bpchar 1 'Y'::bpchar Print Discount on Invoice and Order
c_order isdiscountprinted bpchar 1 'Y'::bpchar Print Discount on Invoice and Order
a_asset isdisposed bpchar 1 'N'::bpchar The asset is disposed
c_order isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
m_inout 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_paymentterm isduefixed bpchar 1 'N'::bpchar Payment is due on a fixed date
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
c_invoice isfixedassetinvoice bpchar 1  √  null IsFixedAssetInvoice
c_invoiceline isfixedassetinvoice bpchar 1  √  null IsFixedAssetInvoice
a_asset isfullydepreciated bpchar 1 'N'::bpchar The asset is fully depreciated
c_invoice isindispute bpchar 1 'N'::bpchar Document is in dispute
m_inout isindispute bpchar 1 'N'::bpchar Document is in dispute
a_asset isinposession bpchar 1 'Y'::bpchar The asset is in the possession of the organization
m_inout 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_inoutline isinvoiced bpchar 1 'N'::bpchar Is this invoiced?
s_timeexpenseline isinvoiced bpchar 1 'N'::bpchar Is this invoiced?
m_product isinvoiceprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the invoice
m_product iskanban bpchar 1 'N'::bpchar This part is Kanban controlled
m_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
s_resource ismanufacturingresource bpchar 1  √  'N'::bpchar Manufacturing Resource
c_paymentterm isnextbusinessday bpchar 1  √  'Y'::bpchar Payment due on the next business day
c_bpartner isonetime bpchar 1 'N'::bpchar One time transaction
c_invoice isoverridecurrencyrate bpchar 1 'N'::bpchar Override Currency Conversion Rate
m_product isownbox bpchar 1 'N'::bpchar Own Box
a_asset isowned bpchar 1 'Y'::bpchar The asset is owned by the organization
c_invoice ispaid bpchar 1 'N'::bpchar The document is paid
c_invoice ispayschedulevalid bpchar 1 'N'::bpchar Is the Payment Schedule is valid
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
c_invoice isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
c_invoiceline isprinted bpchar 1 'Y'::bpchar Indicates if this document / line is printed
c_order isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
c_projectline isprinted bpchar 1 'Y'::bpchar Indicates if this document / line is printed
m_inout 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_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_invoice isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
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
m_product issold bpchar 1 'Y'::bpchar Organization sells this product
c_invoice issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
c_order issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
m_inout issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
m_product isstocked bpchar 1 'Y'::bpchar Organization stocks this product
c_activity issummary bpchar 1 'N'::bpchar This is a summary entity
c_bpartner issummary bpchar 1 'N'::bpchar This is a summary entity
c_project issummary bpchar 1 'N'::bpchar This is a summary entity
m_product issummary bpchar 1 'N'::bpchar This is a summary entity
c_bpartner istaxexempt bpchar 1  √  'N'::bpchar Business partner is exempt from tax on sales
c_invoice istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
c_order istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
s_timeexpenseline istimereport bpchar 1 'N'::bpchar Line is a time report only (no expense)
m_product istoformule bpchar 1  √  null
c_invoice istransferred bpchar 1 'N'::bpchar Transferred to General Ledger (i.e. accounted)
c_order istransferred bpchar 1 'N'::bpchar Transferred to General Ledger (i.e. accounted)
c_paymentterm isvalid bpchar 1 'N'::bpchar Element is valid
c_bpartner isvendor bpchar 1 'N'::bpchar Indicates if this Business Partner is a Vendor
m_product isverified bpchar 1 'N'::bpchar The BOM configuration has been verified
m_product iswebstorefeatured bpchar 1 'N'::bpchar If selected, the product is displayed in the initial or any empty search
c_paymentterm netday bpchar 1  √  null Day when payment is due net
c_bpartner paymentrule bpchar 1  √  null How you pay the invoice
c_invoice paymentrule bpchar 1 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_paymentterm paymenttermusage bpchar 1 'B'::bpchar Payment term usage indicates if this payment term is used for sales, purchases or both.
c_invoice posted bpchar 1 'N'::bpchar Posting status
c_order posted bpchar 1 'N'::bpchar Posting status
c_projectissue posted bpchar 1 'N'::bpchar Posting status
m_inout posted bpchar 1 'N'::bpchar Posting status
c_order priorityrule bpchar 1 Priority of a document
m_inout priorityrule bpchar 1 Priority of a document
m_pricelist_version proccreate bpchar 1  √  null Create
a_asset processed bpchar 1 'N'::bpchar The document has been processed
c_invoice processed bpchar 1 'N'::bpchar The document has been processed
c_invoiceline processed bpchar 1 'N'::bpchar 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
c_project processed bpchar 1 'N'::bpchar The document has been processed
c_projectissue processed bpchar 1 'N'::bpchar The document has been processed
c_projectline processed bpchar 1 'N'::bpchar The document has been processed
m_inout processed bpchar 1 'N'::bpchar The document has been processed
m_inoutline processed bpchar 1 'N'::bpchar The document has been processed
s_timeexpenseline processed bpchar 1 'N'::bpchar The document has been processed
a_asset processing bpchar 1  √  'N'::bpchar Process Now
c_invoice processing bpchar 1  √  null Process Now
c_order processing bpchar 1  √  null Process Now
c_paymentterm processing bpchar 1  √  null Process Now
c_project processing bpchar 1  √  null Process Now
c_projectissue processing bpchar 1  √  null Process Now
m_inout 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_project projectcategory bpchar 1  √  'N'::bpchar Project Category
c_projecttype projectcategory bpchar 1 'N'::bpchar Project Category
c_project projectlinelevel bpchar 1 'P'::bpchar Project Line Level
c_project projinvoicerule bpchar 1 '-'::bpchar Invoice Rule for the project
c_projectphase projinvoicerule bpchar 1  √  null Invoice Rule for the project
c_projecttask projinvoicerule bpchar 1  √  null Invoice Rule for the project
c_bpartner rating bpchar 1  √  null Classification or Importance
c_bpartner sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_invoice sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_order sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
m_inout 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
a_asset a_asset_action varchar 2 'MD'::character varying Asset Action
a_asset a_asset_status varchar 2 'NW'::character varying Asset Status
c_invoice docaction bpchar 2 The targeted status of the document
c_order docaction bpchar 2 The targeted status of the document
c_projectissue docaction bpchar 2 'CO'::bpchar The targeted status of the document
m_inout docaction bpchar 2 The targeted status of the document
c_invoice docstatus bpchar 2 The current status of the document
c_order docstatus bpchar 2 The current status of the document
c_projectissue docstatus varchar 2 'DR'::character varying The current status of the document
m_inout docstatus bpchar 2 The current status of the document
s_resource manufacturingresourcetype bpchar 2  √  null Manufacturing Resource Type
m_inout movementtype bpchar 2 Method of moving the inventory
m_transaction movementtype bpchar 2 Method of moving the inventory
a_asset a_assettype varchar 3 'MFX'::character varying Asset Type
c_invoiceline a_capvsexp varchar 3  √  null Capital/Expense
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
a_asset a_asset_class_id numeric 10  √  NULL::numeric Asset class
a_asset a_asset_group_id numeric 10 Group of Assets
c_invoiceline a_asset_group_id numeric 10  √  null Group of Assets
a_asset a_asset_id numeric 10 Asset used internally or by customers
c_invoiceline a_asset_id numeric 10  √  null Asset used internally or by customers
a_asset a_asset_type_id numeric 10  √  null Asset Type
a_asset a_parent_asset_id numeric 10  √  null Parent Asset
a_asset ad_client_id numeric 10 Client/Tenant for this installation.
c_activity ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner ad_client_id numeric 10 Client/Tenant for this installation.
c_cycle ad_client_id numeric 10 Client/Tenant for this installation.
c_cyclephase ad_client_id numeric 10 Client/Tenant for this installation.
c_cyclestep ad_client_id numeric 10 Client/Tenant for this installation.
c_invoice ad_client_id numeric 10 Client/Tenant for this installation.
c_invoiceline ad_client_id numeric 10 Client/Tenant for this installation.
c_order ad_client_id numeric 10 Client/Tenant for this installation.
c_orderline ad_client_id numeric 10 Client/Tenant for this installation.
c_paymentterm ad_client_id numeric 10 Client/Tenant for this installation.
c_phase ad_client_id numeric 10 Client/Tenant for this installation.
c_project ad_client_id numeric 10 Client/Tenant for this installation.
c_projectissue ad_client_id numeric 10 Client/Tenant for this installation.
c_projectline ad_client_id numeric 10 Client/Tenant for this installation.
c_projectphase ad_client_id numeric 10 Client/Tenant for this installation.
c_projecttask ad_client_id numeric 10 Client/Tenant for this installation.
c_projecttype ad_client_id numeric 10 Client/Tenant for this installation.
c_task ad_client_id numeric 10 Client/Tenant for this installation.
m_inout ad_client_id numeric 10 Client/Tenant for this installation.
m_inoutline 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_transaction ad_client_id numeric 10 Client/Tenant for this installation.
m_warehouse ad_client_id numeric 10 Client/Tenant for this installation.
s_resource ad_client_id numeric 10 Client/Tenant for this installation.
s_timeexpenseline ad_client_id numeric 10 Client/Tenant for this installation.
a_asset ad_org_id numeric 10 Organizational entity within client
c_activity ad_org_id numeric 10 Organizational entity within client
c_bpartner ad_org_id numeric 10 Organizational entity within client
c_cycle ad_org_id numeric 10 Organizational entity within client
c_cyclephase ad_org_id numeric 10 Organizational entity within client
c_cyclestep ad_org_id numeric 10 Organizational entity within client
c_invoice ad_org_id numeric 10 Organizational entity within client
c_invoiceline ad_org_id numeric 10 Organizational entity within client
c_order ad_org_id numeric 10 Organizational entity within client
c_orderline ad_org_id numeric 10 Organizational entity within client
c_paymentterm ad_org_id numeric 10 Organizational entity within client
c_phase ad_org_id numeric 10 Organizational entity within client
c_project ad_org_id numeric 10 Organizational entity within client
c_projectissue ad_org_id numeric 10 Organizational entity within client
c_projectline ad_org_id numeric 10 Organizational entity within client
c_projectphase ad_org_id numeric 10 Organizational entity within client
c_projecttask ad_org_id numeric 10 Organizational entity within client
c_projecttype ad_org_id numeric 10 Organizational entity within client
c_task ad_org_id numeric 10 Organizational entity within client
m_inout ad_org_id numeric 10 Organizational entity within client
m_inoutline 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_transaction ad_org_id numeric 10 Organizational entity within client
m_warehouse ad_org_id numeric 10 Organizational entity within client
s_resource ad_org_id numeric 10 Organizational entity within client
s_timeexpenseline 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
c_invoice ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_invoiceline ad_orgtrx_id numeric 10  √  null 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_project ad_orgtrx_id numeric 10  √  NULL::numeric Performing or initiating organization
m_inout ad_orgtrx_id numeric 10  √  null Performing or initiating organization
m_inoutline ad_orgtrx_id numeric 10  √  null Performing or initiating organization
a_asset ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_invoice ad_user_id numeric 10  √  null 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_project ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
m_inout ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
s_resource ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
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
c_bpartner bpartner_parent_id numeric 10  √  null Business Partner Parent
c_invoiceline c_1099box_id numeric 10  √  NULL::numeric 1099 Box
a_asset c_activity_id numeric 10  √  NULL::numeric Business Activity
c_activity c_activity_id numeric 10 Business Activity
c_invoice c_activity_id numeric 10  √  null Business Activity
c_invoiceline c_activity_id numeric 10  √  null Business Activity
c_order c_activity_id numeric 10  √  null Business Activity
c_orderline c_activity_id numeric 10  √  null Business Activity
c_project c_activity_id numeric 10  √  NULL::numeric Business Activity
m_inout c_activity_id numeric 10  √  null Business Activity
m_inoutline c_activity_id numeric 10  √  null Business Activity
s_timeexpenseline c_activity_id numeric 10  √  null Business Activity
c_bpartner c_bp_group_id numeric 10 Business Partner Group
a_asset c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_bpartner c_bpartner_id numeric 10 Identifies a Business Partner
c_invoice c_bpartner_id numeric 10 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
c_project c_bpartner_id numeric 10  √  null Identifies a Business Partner
m_inout c_bpartner_id numeric 10 Identifies a Business Partner
s_timeexpenseline c_bpartner_id numeric 10  √  null Identifies a Business Partner
a_asset c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
c_invoice 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_orderline c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
c_project c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
m_inout c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
a_asset c_bpartnersr_id numeric 10  √  null Business Partner (Agent or Sales Rep)
c_project c_bpartnersr_id numeric 10  √  null Business Partner (Agent or Sales Rep)
c_invoice c_campaign_id numeric 10  √  null Marketing Campaign
c_invoiceline c_campaign_id numeric 10  √  null Marketing Campaign
c_order c_campaign_id numeric 10  √  null Marketing Campaign
c_orderline c_campaign_id numeric 10  √  null Marketing Campaign
c_project c_campaign_id numeric 10  √  null Marketing Campaign
m_inout c_campaign_id numeric 10  √  null Marketing Campaign
m_inoutline c_campaign_id numeric 10  √  null Marketing Campaign
s_timeexpenseline c_campaign_id numeric 10  √  null Marketing Campaign
c_invoice c_cashline_id numeric 10  √  null Cash Journal Line
c_order c_cashline_id numeric 10  √  null Cash Journal Line
c_invoice c_cashplanline_id numeric 10  √  NULL::numeric Cash Plan Line
c_order c_cashplanline_id numeric 10  √  NULL::numeric Cash Plan Line
c_invoice c_charge_id numeric 10  √  null Additional document charges
c_invoiceline c_charge_id numeric 10  √  null 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_inout c_charge_id numeric 10  √  null Additional document charges
m_inoutline c_charge_id numeric 10  √  null Additional document charges
c_invoice c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
c_order c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
c_cycle c_currency_id numeric 10 The Currency for this record
c_invoice c_currency_id numeric 10 The Currency for this record
c_order c_currency_id numeric 10 The Currency for this record
c_orderline c_currency_id numeric 10 The Currency for this record
c_project c_currency_id numeric 10 The Currency for this record
s_timeexpenseline c_currency_id numeric 10  √  null The Currency for this record
c_cycle c_cycle_id numeric 10 Identifier for this Project Reporting Cycle
c_cyclestep c_cycle_id numeric 10 Identifier for this Project Reporting Cycle
c_cyclephase c_cyclestep_id numeric 10 The step for this Cycle
c_cyclestep c_cyclestep_id numeric 10 The step for this Cycle
c_invoice c_doctype_id numeric 10 Document type or rules
c_order c_doctype_id numeric 10 Document type or rules
m_inout c_doctype_id numeric 10 Document type or rules
c_invoice c_doctypetarget_id numeric 10 Target document type for conversing documents
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
c_invoice c_dunninglevel_id numeric 10  √  null Dunning Level
c_bpartner c_greeting_id numeric 10  √  null Greeting to print on correspondence
c_invoice c_invoice_id numeric 10 Invoice Identifier
c_invoiceline c_invoice_id numeric 10 Invoice Identifier
m_inout c_invoice_id numeric 10  √  null Invoice Identifier
c_invoiceline c_invoiceline_id numeric 10 Invoice Detail Line
s_timeexpenseline c_invoiceline_id numeric 10  √  null Invoice Detail Line
c_bpartner c_invoiceschedule_id numeric 10  √  null Schedule for generating Invoices
a_asset c_location_id numeric 10  √  null Location or Address
m_warehouse c_location_id numeric 10 Location or Address
c_order c_opportunity_id numeric 10  √  NULL::numeric Sales Opportunity
c_invoice c_order_id numeric 10  √  null Order
c_order c_order_id numeric 10 Order
c_orderline c_order_id numeric 10 Order
c_projectline c_order_id numeric 10  √  null Order
c_projectphase c_order_id numeric 10  √  null Order
m_inout c_order_id numeric 10  √  null Order
c_invoiceline c_orderline_id numeric 10  √  null Sales Order Line
c_orderline c_orderline_id numeric 10 Sales Order Line
m_inoutline c_orderline_id numeric 10  √  null Sales Order Line
s_timeexpenseline c_orderline_id numeric 10  √  null Sales Order Line
c_projectline c_orderpo_id numeric 10  √  null Purchase Order
c_order c_ordersource_id numeric 10  √  null Order Source
c_invoice c_payment_id numeric 10  √  null Payment identifier
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_invoice c_paymentterm_id numeric 10 The terms of Payment (timing, discount)
c_order c_paymentterm_id numeric 10 The terms of Payment (timing, discount)
c_paymentterm c_paymentterm_id numeric 10 The terms of Payment (timing, discount)
c_project c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_cyclephase c_phase_id numeric 10 Standard Phase of the Project Type
c_phase c_phase_id numeric 10 Standard Phase of the Project Type
c_project c_phase_id numeric 10  √  null Standard Phase of the Project Type
c_projectphase c_phase_id numeric 10  √  null Standard Phase of the Project Type
c_task c_phase_id numeric 10 Standard Phase of the Project Type
c_order c_pos_id numeric 10  √  null Point of Sales Terminal
a_asset c_project_id numeric 10  √  null Financial Project
c_invoice c_project_id numeric 10  √  null Financial Project
c_invoiceline c_project_id numeric 10  √  null Financial Project
c_order c_project_id numeric 10  √  null Financial Project
c_orderline c_project_id numeric 10  √  null Financial Project
c_project c_project_id numeric 10 Financial Project
c_projectissue c_project_id numeric 10 Financial Project
c_projectline c_project_id numeric 10 Financial Project
c_projectphase c_project_id numeric 10 Financial Project
m_inout c_project_id numeric 10  √  null Financial Project
m_inoutline c_project_id numeric 10  √  null Financial Project
s_timeexpenseline c_project_id numeric 10  √  null Financial Project
c_projectissue c_projectissue_id numeric 10 Project Issues (Material, Labor)
c_projectline c_projectissue_id numeric 10  √  null Project Issues (Material, Labor)
m_transaction c_projectissue_id numeric 10  √  null Project Issues (Material, Labor)
c_projectline c_projectline_id numeric 10 Task or step in a project
c_invoiceline c_projectphase_id numeric 10  √  null Phase of a Project
c_orderline c_projectphase_id numeric 10  √  null Phase of a Project
c_projectline c_projectphase_id numeric 10  √  null Phase of a Project
c_projectphase c_projectphase_id numeric 10 Phase of a Project
c_projecttask c_projectphase_id numeric 10 Phase of a Project
m_inoutline c_projectphase_id numeric 10  √  null Phase of a Project
s_timeexpenseline c_projectphase_id numeric 10  √  null Phase of a Project
c_invoiceline c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
c_orderline c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
c_projectline c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
c_projecttask c_projecttask_id numeric 10 Actual Project Task in a Phase
m_inoutline c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
s_timeexpenseline c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
c_phase c_projecttype_id numeric 10 Type of the project
c_project c_projecttype_id numeric 10  √  null Type of the project
c_projecttype c_projecttype_id numeric 10 Type of the project
m_product c_revenuerecognition_id numeric 10  √  null Method for recording revenue
m_product c_subscriptiontype_id numeric 10  √  null Type of subscription
c_projecttask c_task_id numeric 10  √  null Standard Project Type Task
c_task c_task_id numeric 10 Standard Project Type Task
c_invoiceline c_tax_id numeric 10  √  null Tax identifier
c_orderline c_tax_id numeric 10 Tax identifier
m_product c_taxcategory_id numeric 10 Tax Category
c_bpartner c_taxgroup_id numeric 10  √  null Tax Group
c_invoiceline c_uom_id numeric 10  √  null Unit of Measure
c_orderline c_uom_id numeric 10 Unit of Measure
m_inoutline c_uom_id numeric 10 Unit of Measure
m_product c_uom_id numeric 10 Unit of Measure
s_timeexpenseline c_uom_id numeric 10  √  null Unit of Measure
a_asset createdby numeric 10 User who created this records
c_activity createdby numeric 10 User who created this records
c_bpartner createdby numeric 10 User who created this records
c_cycle createdby numeric 10 User who created this records
c_cyclephase createdby numeric 10 User who created this records
c_cyclestep createdby numeric 10 User who created this records
c_invoice createdby numeric 10 User who created this records
c_invoiceline 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_paymentterm createdby numeric 10 User who created this records
c_phase createdby numeric 10 User who created this records
c_project createdby numeric 10 User who created this records
c_projectissue createdby numeric 10 User who created this records
c_projectline createdby numeric 10 User who created this records
c_projectphase createdby numeric 10 User who created this records
c_projecttask createdby numeric 10 User who created this records
c_projecttype createdby numeric 10 User who created this records
c_task createdby numeric 10 User who created this records
m_inout createdby numeric 10 User who created this records
m_inoutline 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_transaction createdby numeric 10 User who created this records
m_warehouse createdby numeric 10 User who created this records
s_resource createdby numeric 10 User who created this records
s_timeexpenseline createdby numeric 10 User who created this records
c_bpartner default1099box_id numeric 10  √  NULL::numeric Default 1099 Box
c_paymentterm discountdays numeric 10 Number of days from invoice date to be eligible for discount
c_paymentterm discountdays2 numeric 10 Number of days from invoice date to be eligible for discount
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
m_inout 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
m_inout 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
m_inout dropship_user_id numeric 10  √  null Business Partner Contact for drop shipment
c_paymentterm fixmonthcutoff numeric 10  √  null Last day to include for next due date
c_paymentterm fixmonthday numeric 10  √  null Day of the month of the due date
c_paymentterm fixmonthoffset numeric 10  √  null Number of months (0=same, 1=following)
m_inout fob varchar 10  √  NULL::character varying Freight Terms
m_inout freightcharges varchar 10  √  NULL::character varying Freight Charges
c_paymentterm gracedays numeric 10 Days after due date to send first dunning letter
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
a_asset lastmaintenanceunit numeric 10  √  null Last Maintenance Unit
a_asset lastmaintenanceuseunit numeric 10  √  null
a_asset lease_bpartner_id numeric 10  √  null The Business Partner who rents or leases
c_invoiceline line numeric 10 Unique line for this document
c_orderline line numeric 10 Unique line for this document
c_projectissue line numeric 10 Unique line for this document
c_projectline line numeric 10 Unique line for this document
m_inoutline line numeric 10 Unique line for this document
s_timeexpenseline 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
a_asset m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
c_invoiceline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
c_orderline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
c_projectissue m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_inoutline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_product m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_transaction 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_inout m_inout_id numeric 10 Material Shipment Document
m_inoutline m_inout_id numeric 10 Material Shipment Document
a_asset m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
c_invoiceline m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
c_projectissue m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
m_inoutline m_inoutline_id numeric 10 Line on Shipment or Receipt document
m_transaction m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
m_transaction m_inventoryline_id numeric 10  √  null Unique line in an Inventory document
a_asset m_locator_id numeric 10  √  null Warehouse Locator
c_projectissue m_locator_id numeric 10 Warehouse Locator
m_inoutline m_locator_id numeric 10  √  null Warehouse Locator
m_product m_locator_id numeric 10  √  null Warehouse Locator
m_transaction m_locator_id numeric 10 Warehouse Locator
m_transaction m_movementline_id numeric 10  √  null Inventory Move document Line
m_product m_parttype_id numeric 10  √  NULL::numeric Part Type
c_bpartner m_pricelist_id numeric 10  √  null Unique identifier of a Price List
c_invoice m_pricelist_id numeric 10 Unique identifier of a Price List
c_order 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
c_project m_pricelist_version_id numeric 10  √  null Identifies a unique instance of a Price List
m_pricelist_version m_pricelist_version_id numeric 10 Identifies a unique instance of a Price List
c_projectline m_product_category_id numeric 10  √  null Category of a Product
m_product m_product_category_id numeric 10 Category of a Product
a_asset m_product_id numeric 10 Product, Service, Item
c_invoiceline m_product_id numeric 10  √  null Product, Service, Item
c_orderline m_product_id numeric 10  √  null Product, Service, Item
c_phase m_product_id numeric 10  √  null Product, Service, Item
c_projectissue m_product_id numeric 10 Product, Service, Item
c_projectline m_product_id numeric 10  √  null Product, Service, Item
c_projectphase m_product_id numeric 10  √  null Product, Service, Item
c_projecttask m_product_id numeric 10  √  null Product, Service, Item
c_task m_product_id numeric 10  √  null Product, Service, Item
m_inoutline m_product_id numeric 10  √  null Product, Service, Item
m_product m_product_id numeric 10 Product, Service, Item
m_transaction m_product_id numeric 10 Product, Service, Item
s_timeexpenseline m_product_id numeric 10  √  null Product, Service, Item
c_projectline m_production_id numeric 10  √  NULL::numeric Plan for producing a product
m_transaction m_productionline_id numeric 10  √  null Document Line representing a production
c_orderline m_promotion_id numeric 10  √  null Promotion
m_warehouse m_reservelocator_id numeric 10  √  NULL::numeric Reservation Locator (just for reporting purposes)
c_invoice m_rma_id numeric 10  √  null Return Material Authorization
m_inout m_rma_id numeric 10  √  null Return Material Authorization
c_invoiceline m_rmaline_id numeric 10  √  null Return Material Authorization Line
m_inoutline m_rmaline_id numeric 10  √  null Return Material Authorization Line
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
m_inout m_shipper_id numeric 10  √  null Method or manner of product delivery
m_transaction m_transaction_id numeric 10 Inventory Transaction
c_order m_warehouse_id numeric 10 Storage Warehouse and Service Point
c_orderline m_warehouse_id numeric 10 Storage Warehouse and Service Point
c_project m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
m_inout m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_warehouse m_warehouse_id numeric 10 Storage Warehouse and Service Point
s_resource m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_warehouse m_warehousesource_id numeric 10  √  null Optional Warehouse to replenish from
a_asset manufacturedyear numeric 10  √  NULL::numeric Manufactured Year
c_paymentterm netdays numeric 10 Net Days in which payment is due
a_asset nextmaintenanceuseunit numeric 10  √  null
a_asset nextmaintenenceunit numeric 10  √  null Next Maintenence Unit
m_inout nopackages numeric 10  √  (1)::numeric Number of packages shipped
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
s_resource planninghorizon numeric 10  √  (0)::numeric The planning horizon is the amount of time (Days) an organisation will look into the future when preparing a strategic plan.
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_transaction pp_cost_collector_id numeric 10  √  null Manufacturing Cost Collector
c_order quotationorder_id numeric 10  √  NULL::numeric Quotation used for generating this order
m_product r_mailtext_id numeric 10  √  null Text templates for mailings
m_inout ref_inout_id numeric 10  √  null Referenced Shipment
m_inoutline ref_inoutline_id numeric 10  √  null Referenced Shipment Line
c_invoice ref_invoice_id numeric 10  √  null Referenced Invoice
c_invoiceline ref_invoiceline_id numeric 10  √  null Referenced Invoice Line
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
c_invoice relatedinvoice_id numeric 10  √  NULL::numeric Related Invoice
m_inout returnbpartner_id numeric 10  √  NULL::numeric Return Partner
m_inout returnlocation_id numeric 10  √  NULL::numeric Return Location
m_inout returnuser_id numeric 10  √  NULL::numeric Return User/Contact
c_invoice reversal_id numeric 10  √  null ID of document reversal
c_projectissue reversal_id numeric 10  √  null ID of document reversal
m_inout reversal_id numeric 10  √  null ID of document reversal
m_inoutline reversalline_id numeric 10  √  null Use to keep the reversal line ID for reversing costing purpose
m_product s_expensetype_id numeric 10  √  null Expense report type
m_product s_resource_id numeric 10  √  null Resource
s_resource s_resource_id numeric 10 Resource
c_invoiceline s_resourceassignment_id numeric 10  √  null Resource Assignment
c_orderline s_resourceassignment_id numeric 10  √  null Resource Assignment
s_timeexpenseline s_resourceassignment_id numeric 10  √  null Resource Assignment
s_resource s_resourcetype_id numeric 10 Resource Type
s_timeexpenseline s_timeexpense_id numeric 10 Time and Expense Report
c_projectissue s_timeexpenseline_id numeric 10  √  null Time and Expense Report Line
s_timeexpenseline s_timeexpenseline_id numeric 10 Time and Expense Report Line
s_timeexpenseline s_timetype_id numeric 10  √  null Type of time recorded
c_bpartner salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_invoice salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_order salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_project salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_inout 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_cyclestep seqno numeric 10 Method of ordering records; lowest number comes first
c_phase seqno numeric 10 Method of ordering records; lowest number comes first
c_projectphase seqno numeric 10 Method of ordering records; lowest number comes first
c_projecttask seqno numeric 10 Method of ordering records; lowest number comes first
c_task seqno numeric 10 Method of ordering records; lowest number comes first
c_bpartner shareofcustomer numeric 10  √  null Share of Customer's business as a percentage
m_product shelfdepth numeric 10  √  null Shelf depth required
c_bpartner shelflifeminpct numeric 10  √  null Minimum Shelf Life in percent based on Product Instance Guarantee Date
m_product shelfwidth numeric 10  √  null Shelf width required
m_product unitsperpack numeric 10 1 The Units Per Pack indicates the no of units of a product packed together.
a_asset updatedby numeric 10 User who updated this records
c_activity updatedby numeric 10 User who updated this records
c_bpartner updatedby numeric 10 User who updated this records
c_cycle updatedby numeric 10 User who updated this records
c_cyclephase updatedby numeric 10 User who updated this records
c_cyclestep updatedby numeric 10 User who updated this records
c_invoice updatedby numeric 10 User who updated this records
c_invoiceline 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_paymentterm updatedby numeric 10 User who updated this records
c_phase updatedby numeric 10 User who updated this records
c_project updatedby numeric 10 User who updated this records
c_projectissue updatedby numeric 10 User who updated this records
c_projectline updatedby numeric 10 User who updated this records
c_projectphase updatedby numeric 10 User who updated this records
c_projecttask updatedby numeric 10 User who updated this records
c_projecttype updatedby numeric 10 User who updated this records
c_task updatedby numeric 10 User who updated this records
m_inout updatedby numeric 10 User who updated this records
m_inoutline 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_transaction updatedby numeric 10 User who updated this records
m_warehouse updatedby numeric 10 User who updated this records
s_resource updatedby numeric 10 User who updated this records
s_timeexpenseline updatedby numeric 10 User who updated this records
a_asset uselifemonths numeric 10  √  null Months of the usable life of the asset
a_asset uselifeyears numeric 10  √  null Years of the usable life of the asset
c_invoice user1_id numeric 10  √  null User defined list element #1
c_invoiceline user1_id numeric 10  √  null 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
m_inout user1_id numeric 10  √  null User defined list element #1
m_inoutline user1_id numeric 10  √  null User defined list element #1
c_invoice user2_id numeric 10  √  null User defined list element #2
c_invoiceline user2_id numeric 10  √  null 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
m_inout user2_id numeric 10  √  null User defined list element #2
m_inoutline user2_id numeric 10  √  null User defined list element #2
c_bpartner duns varchar 11  √  null Dun & Bradstreet Number
m_product classification varchar 12  √  null Classification for grouping
m_product customstariffnumber varchar 20  √  null Customs Tariff Number, usually the HS-Code
c_bpartner poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_invoice 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_project poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
m_inout poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_bpartner taxid varchar 20  √  null Tax Identification
a_asset versionno varchar 20  √  null Version Number
m_product versionno varchar 20  √  null Version Number
c_order amountrefunded numeric 22,2  √  null AmountRefunded
c_order amounttendered numeric 22,2  √  null AmountTendered
a_asset a_asset_createdate timestamp 29,6  √  null Create Date
a_asset a_asset_revaldate timestamp 29,6  √  null Revaluation Date
a_asset assetactivationdate timestamp 29,6  √  null Activation Date
a_asset assetdepreciationdate timestamp 29,6  √  null Date of last depreciation
a_asset assetdisposaldate timestamp 29,6  √  null Date when the asset is/was disposed
a_asset assetservicedate timestamp 29,6  √  null Date when Asset was put into service
a_asset created timestamp 29,6 now() Date this record was created
c_activity created timestamp 29,6 now() Date this record was created
c_bpartner created timestamp 29,6 now() Date this record was created
c_cycle created timestamp 29,6 now() Date this record was created
c_cyclephase created timestamp 29,6 now() Date this record was created
c_cyclestep created timestamp 29,6 now() Date this record was created
c_invoice created timestamp 29,6 now() Date this record was created
c_invoiceline 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_paymentterm created timestamp 29,6 now() Date this record was created
c_phase created timestamp 29,6 now() Date this record was created
c_project created timestamp 29,6 now() Date this record was created
c_projectissue created timestamp 29,6 now() Date this record was created
c_projectline created timestamp 29,6 now() Date this record was created
c_projectphase created timestamp 29,6 now() Date this record was created
c_projecttask created timestamp 29,6 now() Date this record was created
c_projecttype created timestamp 29,6 now() Date this record was created
c_task created timestamp 29,6 now() Date this record was created
m_inout created timestamp 29,6 now() Date this record was created
m_inoutline 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_transaction created timestamp 29,6 now() Date this record was created
m_warehouse created timestamp 29,6 now() Date this record was created
s_resource created timestamp 29,6 now() Date this record was created
s_timeexpenseline created timestamp 29,6 now() Date this record was created
c_invoice dateacct timestamp 29,6 Accounting Date
c_order dateacct timestamp 29,6 Accounting Date
m_inout dateacct timestamp 29,6 Accounting Date
c_project datecontract timestamp 29,6  √  null The (planned) effective date of this document.
c_orderline datedelivered timestamp 29,6  √  null Date when the product was delivered
s_timeexpenseline dateexpense timestamp 29,6  √  null Date of expense
c_project datefinish timestamp 29,6  √  null Finish or (planned) completion date
c_invoice dateinvoiced timestamp 29,6 Date printed on Invoice
c_orderline dateinvoiced timestamp 29,6  √  null Date printed on Invoice
c_invoice dateordered timestamp 29,6  √  null Date of Order
c_order dateordered timestamp 29,6 Date of Order
c_orderline dateordered timestamp 29,6 Date of Order
m_inout dateordered timestamp 29,6  √  null Date of Order
c_invoice dateprinted timestamp 29,6  √  null Date the document was printed.
c_order dateprinted timestamp 29,6  √  null Date the document was printed.
m_inout 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_inout datereceived timestamp 29,6  √  null Date a product was received
m_product discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product discontinuedby timestamp 29,6  √  null
c_bpartner dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_invoice dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_projectphase enddate timestamp 29,6  √  null Last effective date (inclusive)
c_bpartner firstsale timestamp 29,6  √  null Date of First Sale
a_asset guaranteedate timestamp 29,6  √  null Date when guarantee expires
a_asset lastmaintenancedate timestamp 29,6  √  null Last Maintenance Date
a_asset lastmaintenencedate timestamp 29,6  √  null
a_asset leaseterminationdate timestamp 29,6  √  null Lease Termination Date
c_projectissue movementdate timestamp 29,6 Date a product was moved in or out of inventory
m_inout movementdate timestamp 29,6 Date a product was moved in or out of inventory
m_transaction movementdate timestamp 29,6 Date a product was moved in or out of inventory
a_asset nextmaintenencedate timestamp 29,6  √  null Next Maintenence Date
m_inout pickdate timestamp 29,6  √  null Date/Time when picked for Shipment
c_invoiceline rrstartdate timestamp 29,6  √  null Revenue Recognition Start Date
c_orderline rrstartdate timestamp 29,6  √  null Revenue Recognition Start Date
m_inout shipdate timestamp 29,6  √  null Shipment Date/Time
c_projectphase startdate timestamp 29,6  √  null First effective day (inclusive)
a_asset updated timestamp 29,6 now() Date this record was updated
c_activity updated timestamp 29,6 now() Date this record was updated
c_bpartner updated timestamp 29,6 now() Date this record was updated
c_cycle updated timestamp 29,6 now() Date this record was updated
c_cyclephase updated timestamp 29,6 now() Date this record was updated
c_cyclestep updated timestamp 29,6 now() Date this record was updated
c_invoice updated timestamp 29,6 now() Date this record was updated
c_invoiceline 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_paymentterm updated timestamp 29,6 now() Date this record was updated
c_phase updated timestamp 29,6 now() Date this record was updated
c_project updated timestamp 29,6 now() Date this record was updated
c_projectissue updated timestamp 29,6 now() Date this record was updated
c_projectline updated timestamp 29,6 now() Date this record was updated
c_projectphase updated timestamp 29,6 now() Date this record was updated
c_projecttask updated timestamp 29,6 now() Date this record was updated
c_projecttype updated timestamp 29,6 now() Date this record was updated
c_task updated timestamp 29,6 now() Date this record was updated
m_inout updated timestamp 29,6 now() Date this record was updated
m_inoutline 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_transaction updated timestamp 29,6 now() Date this record was updated
m_warehouse updated timestamp 29,6 now() Date this record was updated
s_resource updated timestamp 29,6 now() Date this record was updated
s_timeexpenseline 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_invoice documentno varchar 30 Document sequence number of the document
c_order documentno varchar 30 Document sequence number of the document
m_inout documentno varchar 30 Document sequence number of the document
a_asset inventoryno varchar 30  √  NULL::character varying Inventory No
a_asset manufacturer varchar 30  √  NULL::character varying 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)
a_asset a_asset_uu varchar 36  √  NULL::character varying A_Asset_UU
c_activity c_activity_uu varchar 36  √  NULL::character varying C_Activity_UU
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying C_BPartner_UU
c_cycle c_cycle_uu varchar 36  √  NULL::character varying C_Cycle_UU
c_cyclephase c_cyclephase_uu varchar 36  √  NULL::character varying C_CyclePhase_UU
c_cyclestep c_cyclestep_uu varchar 36  √  NULL::character varying C_CycleStep_UU
c_invoice c_invoice_uu varchar 36  √  NULL::character varying C_Invoice_UU
c_invoiceline c_invoiceline_uu varchar 36  √  NULL::character varying C_InvoiceLine_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_paymentterm c_paymentterm_uu varchar 36  √  NULL::character varying C_PaymentTerm_UU
c_phase c_phase_uu varchar 36  √  NULL::character varying C_Phase_UU
c_project c_project_uu varchar 36  √  NULL::character varying C_Project_UU
c_projectissue c_projectissue_uu varchar 36  √  NULL::character varying C_ProjectIssue_UU
c_projectline c_projectline_uu varchar 36  √  NULL::character varying C_ProjectLine_UU
c_projectphase c_projectphase_uu varchar 36  √  NULL::character varying C_ProjectPhase_UU
c_projecttask c_projecttask_uu varchar 36  √  NULL::character varying C_ProjectTask_UU
c_projecttype c_projecttype_uu varchar 36  √  NULL::character varying C_ProjectType_UU
c_task c_task_uu varchar 36  √  NULL::character varying C_Task_UU
m_inout m_inout_uu varchar 36  √  NULL::character varying M_InOut_UU
m_inoutline m_inoutline_uu varchar 36  √  NULL::character varying M_InOutLine_UU
m_pricelist_version m_pricelist_version_uu varchar 36  √  NULL::character varying M_PriceList_Version_UU
m_product m_product_uu varchar 36  √  NULL::character varying M_Product_UU
m_transaction m_transaction_uu varchar 36  √  NULL::character varying M_Transaction_UU
m_warehouse m_warehouse_uu varchar 36  √  NULL::character varying M_Warehouse_UU
s_resource s_resource_uu varchar 36  √  NULL::character varying S_Resource_UU
s_timeexpenseline s_timeexpenseline_uu varchar 36  √  NULL::character varying S_TimeExpenseLine_UU
c_bpartner referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
m_inout shipperaccount varchar 40  √  NULL::character varying Shipper Account Number
a_asset value varchar 40 Search key for the record in the format required - must be unique
c_activity value varchar 40 Search key for the record in the format required - must be unique
c_bpartner value varchar 40 Search key for the record in the format required - must be unique
c_paymentterm value varchar 40 Search key for the record in the format required - must be unique
c_project 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_warehouse value varchar 40 Search key for the record in the format required - must be unique
s_resource value varchar 40 Search key for the record in the format required - must be unique
c_bpartner customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
a_asset lastmaintenancenote varchar 60  √  null Last Maintenance Note
a_asset name varchar 60 Alphanumeric identifier of the entity
c_activity name varchar 60 Alphanumeric identifier of the entity
c_cycle name varchar 60 Alphanumeric identifier of the entity
c_cyclestep name varchar 60 Alphanumeric identifier of the entity
c_paymentterm name varchar 60 Alphanumeric identifier of the entity
c_phase name varchar 60 Alphanumeric identifier of the entity
c_project name varchar 60 Alphanumeric identifier of the entity
c_projectphase name varchar 60 Alphanumeric identifier of the entity
c_projecttask name varchar 60 Alphanumeric identifier of the entity
c_projecttype name varchar 60 Alphanumeric identifier of the entity
c_task name varchar 60 Alphanumeric identifier of the entity
m_pricelist_version name varchar 60 Alphanumeric identifier of the entity
m_warehouse name varchar 60 Alphanumeric identifier of the entity
s_resource name varchar 60 Alphanumeric identifier of the entity
c_bpartner name2 varchar 60  √  null Additional Name
m_warehouse replenishmentclass varchar 60  √  null Custom class to calculate Quantity to Order
m_inout trackingno varchar 60  √  null Number to track the shipment
m_product descriptionurl varchar 120  √  null URL for the description
m_product downloadurl varchar 120  √  null
m_product imageurl varchar 120  √  null URL of image
c_bpartner name varchar 120 Alphanumeric identifier of the entity
c_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
a_asset description varchar 255  √  null Optional short description of the record
c_activity description varchar 255  √  null Optional short description of the record
c_bpartner description varchar 255  √  null Optional short description of the record
c_cycle description varchar 255  √  null Optional short description of the record
c_invoice description varchar 255  √  null Optional short description of the record
c_invoiceline 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_paymentterm description varchar 255  √  null Optional short description of the record
c_phase description varchar 255  √  null Optional short description of the record
c_project description varchar 255  √  null Optional short description of the record
c_projectissue description varchar 255  √  null Optional short description of the record
c_projectline description varchar 255  √  null Optional short description of the record
c_projectphase description varchar 255  √  null Optional short description of the record
c_projecttask description varchar 255  √  null Optional short description of the record
c_projecttype description varchar 255  √  null Optional short description of the record
c_task description varchar 255  √  null Optional short description of the record
m_inout description varchar 255  √  null Optional short description of the record
m_inoutline 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_warehouse description varchar 255  √  null Optional short description of the record
s_resource description varchar 255  √  null Optional short description of the record
s_timeexpenseline description varchar 255  √  null Optional short description of the record
m_product group1 varchar 255  √  null Group1
m_product group2 varchar 255  √  null Group2
a_asset locationcomment varchar 255  √  null Additional comments or remarks concerning the location
a_asset lot varchar 255  √  null Lot number (alphanumeric)
m_product name varchar 255 Alphanumeric identifier of the entity
s_timeexpenseline note varchar 255  √  null Optional additional user defined information
a_asset serno varchar 255  √  null Product Serial Number
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)
c_paymentterm documentnote varchar 2000  √  null Additional information for a Document
m_product documentnote varchar 2000  √  null Additional information for a Document
a_asset help varchar 2000  √  null Comment or Hint
c_activity help varchar 2000  √  null Comment or Hint
c_phase help varchar 2000  √  null Comment or Hint
c_projectphase help varchar 2000  √  null Comment or Hint
c_projecttask help varchar 2000  √  null Comment or Hint
c_projecttype help varchar 2000  √  null Comment or Hint
c_task help varchar 2000  √  null Comment or Hint
m_product help varchar 2000  √  null Comment or Hint
c_project note varchar 2000  √  null Optional additional user defined information