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

idempiere9.adempiere contains 685 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
c_invoiceline a_asset_group_id numeric 10  √  null Group of Assets
c_invoiceline a_asset_id numeric 10  √  null Asset used internally or by customers
c_invoiceline a_capvsexp varchar 3  √  null Capital/Expense
c_invoiceline a_createasset bpchar 1  √  'N'::bpchar Create Asset
c_invoiceline a_processed bpchar 1  √  'N'::bpchar Processed
ad_org ad_org_uu varchar 36  √  NULL::character varying AD_Org_UU
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_inoutline ad_orgtrx_id numeric 10  √  null Performing or initiating organization
ad_org ad_replicationstrategy_id numeric 0  √  null Data Replication Strategy
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
c_order amountrefunded numeric 22,2  √  null AmountRefunded
c_order amounttendered numeric 22,2  √  null AmountTendered
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_elementvalue bpartnertype bpchar 1  √  NULL::bpchar Business Partner Type
c_invoiceline c_1099box_id numeric 10  √  NULL::numeric 1099 Box
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_inoutline c_activity_id numeric 10  √  null Business Activity
c_activity c_activity_uu varchar 36  √  NULL::character varying C_Activity_UU
c_elementvalue c_bankaccount_id numeric 10  √  null Account at the Bank
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_requisitionline c_bpartner_id numeric 10  √  NULL::numeric Identifies a 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
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_inoutline c_campaign_id numeric 10  √  null Marketing Campaign
c_campaign c_campaign_uu varchar 36  √  NULL::character varying C_Campaign_UU
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_campaign c_channel_id numeric 10  √  null Sales Channel
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_inoutline c_charge_id numeric 10  √  null Additional document charges
m_requisitionline 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_elementvalue c_currency_id numeric 10  √  null The Currency for this record
m_product_po c_currency_id numeric 10  √  null The Currency for this record
c_invoice c_dunninglevel_id numeric 10  √  null Dunning Level
c_elementvalue c_elementvalue_uu varchar 36  √  NULL::character varying C_ElementValue_UU
c_invoice c_invoice_uu varchar 36  √  NULL::character varying C_Invoice_UU
m_matchpo c_invoiceline_id numeric 10  √  null Invoice Detail Line
c_invoiceline c_invoiceline_uu varchar 36  √  NULL::character varying C_InvoiceLine_UU
c_order c_opportunity_id numeric 10  √  NULL::numeric Sales Opportunity
c_invoice c_order_id numeric 10  √  null Order
c_projectphase c_order_id numeric 10  √  null Order
c_order c_order_uu varchar 36  √  NULL::character varying C_Order_UU
c_invoiceline c_orderline_id numeric 10  √  null Sales Order Line
m_inoutline c_orderline_id numeric 10  √  null Sales Order Line
m_requisitionline c_orderline_id numeric 10  √  null Sales Order Line
c_orderline c_orderline_uu varchar 36  √  NULL::character varying C_OrderLine_UU
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_project c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
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_order c_pos_id numeric 10  √  null Point of Sales Terminal
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
m_inoutline c_project_id numeric 10  √  null Financial Project
c_project c_project_uu varchar 36  √  NULL::character varying C_Project_UU
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_projectphase c_projectphase_uu varchar 36  √  NULL::character varying C_ProjectPhase_UU
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
c_projecttask c_projecttask_uu varchar 36  √  NULL::character varying C_ProjectTask_UU
c_project c_projecttype_id numeric 10  √  null 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_invoiceline c_tax_id numeric 10  √  null Tax identifier
c_invoiceline c_uom_id numeric 10  √  null Unit of Measure
m_product_po c_uom_id numeric 10  √  null Unit of Measure
m_requisitionline c_uom_id numeric 10  √  NULL::numeric Unit of Measure
c_invoice chargeamt numeric 0  √  0 Charge Amount
c_order chargeamt numeric 0  √  0 Charge Amount
m_product classification varchar 12  √  null Classification for grouping
m_inoutline confirmedqty numeric 0  √  0 Confirmation of a received quantity
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_product_po costperorder numeric 0  √  0 Fixed Cost Per Order
c_invoice createfrom bpchar 1  √  null Process which will generate a new document lines based on an existing document
c_orderline createproduction bpchar 1  √  'N'::bpchar Create Production
c_orderline createshipment bpchar 1  √  'N'::bpchar Create Shipment
c_invoice currencyrate numeric 0  √  null Currency Conversion Rate
m_product customstariffnumber varchar 20  √  null Customs Tariff Number, usually the HS-Code
m_matchinv dateacct timestamp 29,6  √  null Accounting Date
m_matchpo dateacct timestamp 29,6  √  null 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
c_project datefinish timestamp 29,6  √  null Finish or (planned) completion date
c_orderline dateinvoiced timestamp 29,6  √  null Date printed on Invoice
c_invoice 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.
c_order datepromised timestamp 29,6  √  null Date Order was promised
c_orderline datepromised timestamp 29,6  √  null Date Order was promised
m_product_po deliverytime_actual numeric 10  √  null Actual days between order and delivery
m_product_po deliverytime_promised numeric 10  √  null Promised days between order and delivery
ad_org description varchar 255  √  null Optional short description of the record
c_activity description varchar 255  √  null Optional short description of the record
c_campaign description varchar 255  √  null Optional short description of the record
c_elementvalue 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_project 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
m_inoutline description varchar 255  √  null Optional short description of the record
m_matchinv description varchar 255  √  null Optional short description of the record
m_matchpo description varchar 255  √  null Optional short description of the record
m_product description varchar 255  √  null Optional short description of the record
m_requisition description varchar 255  √  null Optional short description of the record
m_requisitionline description varchar 255  √  null Optional short description of the record
m_product descriptionurl varchar 120  √  null URL for the description
m_product discontinued bpchar 1  √  'N'::bpchar This product is no longer available
m_product_po discontinued bpchar 1  √  'N'::bpchar This product is no longer available
m_product discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product_po discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product discontinuedby timestamp 29,6  √  null
m_product_po discontinuedby timestamp 29,6  √  null
c_orderline discount numeric 0  √  null Discount in percent
m_matchinv documentno varchar 30  √  null Document sequence number of the document
m_matchpo documentno varchar 30  √  null Document sequence number of the document
m_product documentnote varchar 2000  √  null Additional information for a Document
m_product downloadurl varchar 120  √  null
c_order dropship_bpartner_id numeric 10  √  null Business Partner to ship to
c_order dropship_location_id numeric 10  √  null Business Partner Location for shipping to
c_order dropship_user_id numeric 10  √  null Business Partner Contact for drop shipment
c_invoice dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_campaign enddate timestamp 29,6  √  null Last effective date (inclusive)
c_projectphase enddate timestamp 29,6  √  null Last effective date (inclusive)
c_order freightamt numeric 0  √  0 Freight Amount
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_product group1 varchar 255  √  null Group1
m_product group2 varchar 255  √  null Group2
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_activity 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
m_product help varchar 2000  √  null Comment or Hint
m_requisition help varchar 2000  √  null Comment or Hint
m_product imageurl varchar 120  √  null URL of image
c_invoice invoicecollectiontype bpchar 1  √  null Invoice Collection Status
m_matchpo isapproved bpchar 1  √  'Y'::bpchar Indicates if this document requires approval
m_inoutline isautoproduce bpchar 1  √  'N'::bpchar Auto create production to fulfill shipment
c_elementvalue isbankaccount bpchar 1  √  'N'::bpchar Indicates if this is the Bank Account
c_elementvalue isdoccontrolled bpchar 1  √  'N'::bpchar Control account - If an account is controlled by a document, you cannot post manually to it
c_invoice isfixedassetinvoice bpchar 1  √  null IsFixedAssetInvoice
c_invoiceline isfixedassetinvoice bpchar 1  √  null IsFixedAssetInvoice
c_elementvalue isforeigncurrency bpchar 1  √  'N'::bpchar Balances in foreign currency accounts are held in the nominated currency
m_product isphantom bpchar 1  √  'N'::bpchar Phantom Component
m_product istoformule bpchar 1  √  null
c_invoiceline linetotalamt numeric 0  √  0 Total line amount incl. Tax
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.
m_product m_attributeset_id numeric 10  √  null Product Attribute Set
c_invoiceline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
c_orderline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_inoutline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_matchinv m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
m_matchpo m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
m_product m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_requisitionline m_attributesetinstance_id numeric 0  √  null Product Attribute Set Instance
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
c_invoiceline m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
m_matchinv m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
m_matchpo m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
m_inoutline m_inoutline_uu varchar 36  √  NULL::character varying M_InOutLine_UU
m_inoutline m_locator_id numeric 10  √  null Warehouse Locator
m_product m_locator_id numeric 10  √  null Warehouse Locator
m_matchinv m_matchinv_uu varchar 36  √  NULL::character varying M_MatchInv_UU
m_matchpo m_matchpo_uu varchar 36  √  NULL::character varying M_MatchPO_UU
m_product m_parttype_id numeric 10  √  NULL::numeric Part Type
c_project m_pricelist_version_id numeric 10  √  null Identifies a unique instance of a Price List
c_invoiceline m_product_id numeric 10  √  null Product, Service, Item
c_orderline 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
m_inoutline m_product_id numeric 10  √  null Product, Service, Item
m_matchinv m_product_id numeric 10  √  null Product, Service, Item
m_matchpo m_product_id numeric 10  √  null Product, Service, Item
m_requisitionline m_product_id numeric 10  √  null Product, Service, Item
m_product_po m_product_po_uu varchar 36  √  NULL::character varying M_Product_PO_UU
m_product m_product_uu varchar 36  √  NULL::character varying M_Product_UU
c_orderline m_promotion_id numeric 10  √  null Promotion
m_requisition m_requisition_uu varchar 36  √  NULL::character varying M_Requisition_UU
m_requisitionline m_requisitionline_uu varchar 36  √  NULL::character varying M_RequisitionLine_UU
c_invoice 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
c_project m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
m_product_po manufacturer varchar 30  √  null Manufacturer of the Product
c_project note varchar 2000  √  null Optional additional user defined information
m_product_po order_min numeric 0  √  0 Minimum order quantity in UOM
m_product_po order_pack numeric 0  √  0 Package order size in UOM (e.g. order set of 5 units)
c_order ordertype varchar 510  √  null Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition)
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
m_inoutline pickedqty numeric 0  √  0 Picked Quantity
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
c_orderline pp_cost_collector_id numeric 10  √  null Manufacturing Cost Collector
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.)
m_product_po priceeffective timestamp 29,6  √  null Effective Date of Price
m_product_po pricelastinv numeric 0  √  0 Price of the last invoice for the product
m_product_po pricelastpo numeric 0  √  0 Price of the last purchase order for the product
m_product_po pricelist numeric 0  √  0 List Price
m_matchpo pricematchdifference numeric 0  √  null Difference between Purchase and Invoice Price per matched line
m_product_po pricepo numeric 0  √  0 Price based on a purchase order
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
m_matchinv processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
m_matchpo processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
m_requisition processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
c_invoice processing bpchar 1  √  null Process Now
c_order processing bpchar 1  √  null Process Now
c_project processing bpchar 1  √  null Process Now
m_product processing bpchar 1  √  null Process Now
m_requisition processing bpchar 1  √  null Process Now
c_project projectcategory bpchar 1  √  'N'::bpchar Project Category
c_projectphase projinvoicerule bpchar 1  √  null Invoice Rule for the project
c_projecttask projinvoicerule bpchar 1  √  null Invoice Rule for the project
c_order promotioncode varchar 30  √  null User entered promotion code at sales time
c_projectphase qty numeric 0  √  0 Quantity
c_projecttask qty numeric 0  √  0 Quantity
m_inoutline qtyoverreceipt numeric 0  √  0 Over Receipt Quantity
m_product_po qualityrating numeric 0  √  null Method for rating vendors
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_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
m_matchinv ref_matchinv_id numeric 10  √  NULL::numeric Referenced Match Invoice
m_matchpo ref_matchpo_id numeric 10  √  NULL::numeric Referenced Match PO
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
c_invoice reversal_id numeric 10  √  null ID of document reversal
m_matchinv reversal_id numeric 10  √  NULL::numeric ID of document reversal
m_matchpo reversal_id numeric 10  √  NULL::numeric ID of document reversal
m_inoutline reversalline_id numeric 10  √  null Use to keep the reversal line ID for reversing costing purpose
m_product_po royaltyamt numeric 0  √  0 (Included) Amount for copyright, etc.
c_invoiceline rramt numeric 0  √  null Revenue Recognition Amount
c_orderline rramt numeric 0  √  null Revenue Recognition Amount
c_invoiceline rrstartdate timestamp 29,6  √  null Revenue Recognition Start Date
c_orderline rrstartdate timestamp 29,6  √  null Revenue Recognition Start Date
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_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_product salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_inoutline scrappedqty numeric 0  √  0 The Quantity scrapped due to QA issues
m_product shelfdepth numeric 10  √  null Shelf depth required
m_product shelfheight numeric 0  √  null Shelf height required
m_product shelfwidth numeric 10  √  null Shelf width required
c_order shippingrateinquiry bpchar 1  √  NULL::bpchar Rate Inquiry
m_product sku varchar 30  √  null Stock Keeping Unit
c_campaign startdate timestamp 29,6  √  null First effective day (inclusive)
c_projectphase startdate timestamp 29,6  √  null First effective day (inclusive)
m_inoutline targetqty numeric 0  √  0 Target Movement Quantity
c_invoiceline taxamt numeric 0  √  0 Tax Amount for a document
m_product unitsperpallet numeric 0  √  null Units Per Pallet
m_product upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
m_product_po upc varchar 20  √  null Bar Code (Universal Product Code or its superset European Article Number)
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_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_inoutline user2_id numeric 10  √  null User defined list element #2
c_elementvalue validfrom timestamp 29,6  √  null Valid from including this date (first day)
c_elementvalue validto timestamp 29,6  √  null Valid to including this date (last day)
m_product_po vendorcategory varchar 30  √  null Product Category of the Business Partner
m_product versionno varchar 20  √  null Version Number
c_order volume numeric 0  √  null Volume of a product
m_product volume numeric 0  √  0 Volume of a product
c_order weight numeric 0  √  null Weight of a product
m_product weight numeric 0  √  0 Weight of a product
c_elementvalue accountsign bpchar 1 Indicates the Natural Sign of the Account as a Debit or Credit
c_elementvalue accounttype bpchar 1 Indicates the type of account
ad_org ad_client_id numeric 10 Client/Tenant for this installation.
c_activity ad_client_id numeric 10 Client/Tenant for this installation.
c_campaign ad_client_id numeric 10 Client/Tenant for this installation.
c_elementvalue 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_project 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.
m_inoutline ad_client_id numeric 10 Client/Tenant for this installation.
m_matchinv ad_client_id numeric 10 Client/Tenant for this installation.
m_matchpo ad_client_id numeric 10 Client/Tenant for this installation.
m_product ad_client_id numeric 10 Client/Tenant for this installation.
m_product_po ad_client_id numeric 10 Client/Tenant for this installation.
m_requisition ad_client_id numeric 10 Client/Tenant for this installation.
m_requisitionline ad_client_id numeric 10 Client/Tenant for this installation.
ad_org ad_org_id numeric 10 Organizational entity within client
c_activity ad_org_id numeric 10 Organizational entity within client
c_campaign ad_org_id numeric 10 Organizational entity within client
c_elementvalue 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_project 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
m_inoutline ad_org_id numeric 10 Organizational entity within client
m_matchinv ad_org_id numeric 10 Organizational entity within client
m_matchpo ad_org_id numeric 10 Organizational entity within client
m_product ad_org_id numeric 10 Organizational entity within client
m_product_po ad_org_id numeric 10 Organizational entity within client
m_requisition ad_org_id numeric 10 Organizational entity within client
m_requisitionline ad_org_id numeric 10 Organizational entity within client
m_requisition ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
c_activity c_activity_id numeric 10 Business Activity
c_invoice c_bpartner_id numeric 10 Identifies a Business Partner
c_order c_bpartner_id numeric 10 Identifies a Business Partner
m_product_po c_bpartner_id numeric 10 Identifies a 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_campaign c_campaign_id numeric 10 Marketing Campaign
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
c_invoice c_doctype_id numeric 10 Document type or rules
c_order c_doctype_id numeric 10 Document type or rules
m_requisition c_doctype_id numeric 10 Document type or rules
c_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_elementvalue c_element_id numeric 10 Accounting Element
c_elementvalue c_elementvalue_id numeric 10 Account Element
c_invoice c_invoice_id numeric 10 Invoice Identifier
c_invoiceline c_invoice_id numeric 10 Invoice Identifier
c_invoiceline c_invoiceline_id numeric 10 Invoice Detail Line
m_matchinv c_invoiceline_id numeric 10 Invoice Detail Line
c_order c_order_id numeric 10 Order
c_orderline c_order_id numeric 10 Order
c_orderline c_orderline_id numeric 10 Sales Order Line
m_matchpo c_orderline_id numeric 10 Sales Order Line
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_project c_project_id numeric 10 Financial Project
c_projectphase c_project_id numeric 10 Financial Project
c_projectphase c_projectphase_id numeric 10 Phase of a Project
c_projecttask c_projectphase_id numeric 10 Phase of a Project
c_projecttask c_projecttask_id numeric 10 Actual Project Task in a Phase
c_orderline c_tax_id numeric 10 Tax identifier
m_product c_taxcategory_id numeric 10 Tax Category
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
c_project 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_campaign costs numeric 0 0 Costs in accounting currency
ad_org created timestamp 29,6 now() Date this record was created
c_activity created timestamp 29,6 now() Date this record was created
c_campaign created timestamp 29,6 now() Date this record was created
c_elementvalue 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_project 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
m_inoutline created timestamp 29,6 now() Date this record was created
m_matchinv created timestamp 29,6 now() Date this record was created
m_matchpo created timestamp 29,6 now() Date this record was created
m_product created timestamp 29,6 now() Date this record was created
m_product_po created timestamp 29,6 now() Date this record was created
m_requisition created timestamp 29,6 now() Date this record was created
m_requisitionline created timestamp 29,6 now() Date this record was created
ad_org createdby numeric 10 User who created this records
c_activity createdby numeric 10 User who created this records
c_campaign createdby numeric 10 User who created this records
c_elementvalue 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_project 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
m_inoutline createdby numeric 10 User who created this records
m_matchinv createdby numeric 10 User who created this records
m_matchpo createdby numeric 10 User who created this records
m_product createdby numeric 10 User who created this records
m_product_po createdby numeric 10 User who created this records
m_requisition createdby numeric 10 User who created this records
m_requisitionline createdby numeric 10 User who created this records
c_invoice dateacct timestamp 29,6 Accounting Date
c_order dateacct timestamp 29,6 Accounting Date
m_requisition datedoc timestamp 29,6 now() Date of the Document
c_invoice dateinvoiced timestamp 29,6 Date printed on Invoice
c_order dateordered timestamp 29,6 Date of Order
c_orderline dateordered timestamp 29,6 Date of Order
m_requisition daterequired timestamp 29,6 Date when required
m_matchinv datetrx timestamp 29,6 Transaction Date
m_matchpo datetrx timestamp 29,6 Transaction Date
c_order deliveryrule bpchar 1 Defines the timing of Delivery
c_order deliveryviarule bpchar 1 How the order will be delivered
c_invoice docaction bpchar 2 The targeted status of the document
c_order docaction bpchar 2 The targeted status of the document
m_requisition 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
m_requisition docstatus bpchar 2 The current status of the document
c_invoice documentno varchar 30 Document sequence number of the document
c_order documentno varchar 30 Document sequence number of the document
m_requisition documentno varchar 30 Document sequence number of the document
c_orderline freightamt numeric 0 0 Freight Amount
c_order freightcostrule bpchar 1 Method for charging Freight
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_project invoicedqty numeric 0 0 The quantity invoiced
c_order invoicerule bpchar 1 Frequency and method of invoicing
ad_org 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_campaign isactive bpchar 1 'Y'::bpchar The record is active in the system
c_elementvalue 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_project 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
m_inoutline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_matchinv isactive bpchar 1 'Y'::bpchar The record is active in the system
m_matchpo isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product_po isactive bpchar 1 'Y'::bpchar The record is active in the system
m_requisition isactive bpchar 1 'Y'::bpchar The record is active in the system
m_requisitionline isactive bpchar 1 'Y'::bpchar The record is active in the system
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
m_requisition isapproved bpchar 1 'Y'::bpchar Indicates if this document requires approval
m_product isautoproduce bpchar 1 'N'::bpchar Auto create production to fulfill shipment
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
m_product_po iscurrentvendor bpchar 1 'Y'::bpchar Use this Vendor for pricing and stock replenishment
c_order isdelivered bpchar 1 'N'::bpchar Delivered
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_elementvalue isdetailbpartner bpchar 1 'N'::bpchar Manage Business Partners
c_elementvalue isdetailproduct bpchar 1 'N'::bpchar Manage Products
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
c_order isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
m_product isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
m_product isexcludeautodelivery bpchar 1 'N'::bpchar Exclude from automatic Delivery
c_invoice isindispute bpchar 1 'N'::bpchar Document is in dispute
c_order isinvoiced bpchar 1 'N'::bpchar Is this invoiced?
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_product ismanufactured bpchar 1 'N'::bpchar This product is manufactured
c_invoice isoverridecurrencyrate bpchar 1 'N'::bpchar Override Currency Conversion Rate
m_product isownbox bpchar 1 'N'::bpchar Own Box
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 ispicklistprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the pick list
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_order ispriviledgedrate bpchar 1 'N'::bpchar Priviledged Rate
m_product ispurchased bpchar 1 'Y'::bpchar Organization purchases this product
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_product isstocked bpchar 1 'Y'::bpchar Organization stocks this product
ad_org issummary bpchar 1 'N'::bpchar This is a summary entity
c_activity issummary bpchar 1 'N'::bpchar This is a summary entity
c_campaign issummary bpchar 1 'N'::bpchar This is a summary entity
c_elementvalue 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_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
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)
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_invoiceline line numeric 10 Unique line for this document
c_orderline line numeric 10 Unique line for this document
m_inoutline line numeric 10 Unique line for this document
m_requisitionline line numeric 10 Unique line for this document
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
m_requisitionline linenetamt numeric 0 0 Line Extended Amount (Quantity * Actual Price) without Freight and Charges
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_inoutline m_inout_id numeric 10 Material Shipment Document
m_inoutline m_inoutline_id numeric 10 Line on Shipment or Receipt document
m_matchinv m_matchinv_id numeric 10 Match Shipment/Receipt to Invoice
m_matchpo m_matchpo_id numeric 10 Match Purchase Order to Shipment/Receipt and Invoice
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_requisition m_pricelist_id numeric 10 Unique identifier of a Price List
m_product m_product_category_id numeric 10 Category of a Product
m_product m_product_id numeric 10 Product, Service, Item
m_product_po m_product_id numeric 10 Product, Service, Item
m_requisition m_requisition_id numeric 10 Material Requisition
m_requisitionline m_requisition_id numeric 10 Material Requisition
m_requisitionline m_requisitionline_id numeric 10 Material Requisition Line
c_order m_warehouse_id numeric 10 Storage Warehouse and Service Point
c_orderline m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_requisition m_warehouse_id numeric 10 Storage Warehouse and Service Point
m_inoutline movementqty numeric 0 0 Quantity of a product moved.
ad_org name varchar 60 Alphanumeric identifier of the entity
c_activity name varchar 60 Alphanumeric identifier of the entity
c_campaign name varchar 60 Alphanumeric identifier of the entity
c_elementvalue name varchar 120 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
m_product name varchar 255 Alphanumeric identifier of the entity
c_invoice paymentrule bpchar 1 How you pay the invoice
c_order paymentrule bpchar 1 How you pay the invoice
c_project 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_project plannedqty numeric 0 0 Planned quantity for this project
c_elementvalue postactual bpchar 1 'Y'::bpchar Actual Values can be posted
c_elementvalue postbudget bpchar 1 'Y'::bpchar Budget values can be posted
c_invoice posted bpchar 1 'N'::bpchar Posting status
c_order posted bpchar 1 'N'::bpchar Posting status
m_matchinv posted bpchar 1 'N'::bpchar Posting status
m_matchpo posted bpchar 1 'N'::bpchar Posting status
m_requisition posted bpchar 1 'N'::bpchar Posting status
c_elementvalue postencumbrance bpchar 1 'Y'::bpchar Post commitments to this account
c_elementvalue poststatistical bpchar 1 'Y'::bpchar Post statistical quantities to this account?
c_invoiceline priceactual numeric 0 0 Actual Price
c_orderline priceactual numeric 0 0 Actual Price
m_requisitionline priceactual numeric 0 0 Actual Price
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_order priorityrule bpchar 1 Priority of a document
m_requisition priorityrule bpchar 1 Priority of a document
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
m_inoutline processed bpchar 1 'N'::bpchar The document has been processed
m_matchinv processed bpchar 1 'N'::bpchar The document has been processed
m_matchpo processed bpchar 1 'N'::bpchar The document has been processed
m_requisition processed bpchar 1 'N'::bpchar The document has been processed
m_matchinv processing bpchar 1 Process Now
m_matchpo processing bpchar 1 Process Now
m_product producttype bpchar 1 'I'::bpchar Type of product
c_project projectbalanceamt numeric 0 0 Total Project Balance
c_project projectlinelevel bpchar 1 'P'::bpchar Project Line Level
c_project projinvoicerule bpchar 1 '-'::bpchar Invoice Rule for the project
m_matchinv qty numeric 0 0 Quantity
m_matchpo qty numeric 0 0 Quantity
m_requisitionline 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
c_orderline qtylostsales numeric 0 0 Quantity of potential sales
c_orderline qtyordered numeric 0 0 Ordered Quantity
c_orderline qtyreserved numeric 0 0 Reserved Quantity
c_invoice sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_order sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
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_invoice totallines numeric 0 0 Total of all document lines
c_order totallines numeric 0 0 Total of all document lines
m_requisition totallines numeric 0 0 Total of all document lines
m_product unitsperpack numeric 10 1 The Units Per Pack indicates the no of units of a product packed together.
ad_org updated timestamp 29,6 now() Date this record was updated
c_activity updated timestamp 29,6 now() Date this record was updated
c_campaign updated timestamp 29,6 now() Date this record was updated
c_elementvalue 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_project 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
m_inoutline updated timestamp 29,6 now() Date this record was updated
m_matchinv updated timestamp 29,6 now() Date this record was updated
m_matchpo updated timestamp 29,6 now() Date this record was updated
m_product updated timestamp 29,6 now() Date this record was updated
m_product_po updated timestamp 29,6 now() Date this record was updated
m_requisition updated timestamp 29,6 now() Date this record was updated
m_requisitionline updated timestamp 29,6 now() Date this record was updated
ad_org updatedby numeric 10 User who updated this records
c_activity updatedby numeric 10 User who updated this records
c_campaign updatedby numeric 10 User who updated this records
c_elementvalue 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_project 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
m_inoutline updatedby numeric 10 User who updated this records
m_matchinv updatedby numeric 10 User who updated this records
m_matchpo updatedby numeric 10 User who updated this records
m_product updatedby numeric 10 User who updated this records
m_product_po updatedby numeric 10 User who updated this records
m_requisition updatedby numeric 10 User who updated this records
m_requisitionline updatedby numeric 10 User who updated this records
ad_org 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_campaign value varchar 40 Search key for the record in the format required - must be unique
c_elementvalue 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_product_po vendorproductno varchar 40 Product Key of the Business Partner