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

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