SchemaSpy Analysis of idempiere11.adempiere - ColumnsTemporary Generated by
Quality Systems & Solutions
Generated on 2024-01-03 13:56 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere11.adempiere contains 1181 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
t_rv_reconciliation accounttype bpchar 1  √  null Indicates the type of account
t_rv_reconciliation ad_org_isactive bpchar 1  √  null
ad_find andor bpchar 1 Logical operation: AND or OR
t_invoicegl apar bpchar 1  √  null Include Receivables and/or Payables transactions
t_invoicegl_v apar bpchar 1  √  null Include Receivables and/or Payables transactions
t_rv_reconciliation c_bp_deliveryrule bpchar 1  √  null
t_rv_reconciliation c_bp_deliveryviarule bpchar 1  √  null
t_rv_reconciliation c_bp_freightcostrule bpchar 1  √  null
t_rv_reconciliation c_bp_invoicerule bpchar 1  √  null
t_rv_reconciliation c_bp_isactive bpchar 1  √  null
t_rv_reconciliation c_bp_iscustomer bpchar 1  √  null
t_rv_reconciliation c_bp_isdiscountprinted bpchar 1  √  null
t_rv_reconciliation c_bp_isemployee bpchar 1  √  null
t_rv_reconciliation c_bp_ismanufacturer bpchar 1  √  null
t_rv_reconciliation c_bp_isonetime bpchar 1  √  null
t_rv_reconciliation c_bp_ispotaxexempt bpchar 1  √  null
t_rv_reconciliation c_bp_isprospect bpchar 1  √  null
t_rv_reconciliation c_bp_issalesrep bpchar 1  √  null
t_rv_reconciliation c_bp_issummary bpchar 1  √  null
t_rv_reconciliation c_bp_istaxexempt bpchar 1  √  null
t_rv_reconciliation c_bp_isvendor bpchar 1  √  null
t_rv_reconciliation c_bp_paymentrule bpchar 1  √  null
t_rv_reconciliation c_bp_paymentrulepo bpchar 1  √  null
t_rv_reconciliation c_bp_rating bpchar 1  √  null
t_rv_reconciliation c_bp_sendemail bpchar 1  √  null
t_rv_reconciliation c_bp_socreditstatus bpchar 1  √  null
t_rv_reconciliation c_elementvalue_isactive bpchar 1  √  null
t_rv_reconciliation c_elementvalue_issummary bpchar 1  √  null
t_cashflow cashflowsource bpchar 1  √  NULL::bpchar Cash Flow Source
t_cashflow cashflowtype bpchar 1  √  NULL::bpchar Cash Flow Type
c_invoice copyfrom bpchar 1  √  null Copy From Record
c_project copyfrom bpchar 1  √  null Copy From Record
t_bomline costingmethod bpchar 1  √  NULL::bpchar Indicates how Costs will be calculated
t_bomline_costs costingmethod bpchar 1  √  null Indicates how Costs will be calculated
c_invoice createfrom bpchar 1  √  null Process which will generate a new document lines based on an existing document
c_invoice createlinesfrom bpchar 1  √  NULL::bpchar Process which will generate a new document lines based on an existing document
t_aging dateacct bpchar 1  √  'N'::bpchar Accounting Date
c_bpartner deliveryrule bpchar 1  √  null Defines the timing of Delivery
c_bpartner deliveryviarule bpchar 1  √  null How the order will be delivered
t_rv_reconciliation discontinued bpchar 1  √  null
c_invoiceschedule eveninvoiceweek bpchar 1  √  'Y'::bpchar Send invoices on even weeks
t_invoicegl_v fact_acct_isactive bpchar 1  √  null fact_acct_isactive
c_bpartner freightcostrule bpchar 1  √  null Method for charging Freight
c_invoice generateto bpchar 1  √  null Generate To
c_project generateto bpchar 1  √  null Generate To
t_invoicegl_v generateto bpchar 1  √  null Generate To
c_doctype hascharges bpchar 1 'N'::bpchar Charges can be added to the document
c_doctype hasproforma bpchar 1  √  'N'::bpchar Indicates if Pro Forma Invoices can be generated from this document
t_bomline implosion bpchar 1  √  'N'::bpchar Implosion of a Bill of Materials refers to finding all the BOM''s in which a component is used.
t_bomline_costs implosion bpchar 1  √  null Implosion of a Bill of Materials refers to finding all the BOM''s in which a component is used.
c_invoice invoicecollectiontype bpchar 1  √  null Invoice Collection Status
t_invoicegl_v invoicecollectiontype bpchar 1  √  null Invoice Collection Status
c_invoiceschedule invoicefrequency bpchar 1 How often invoices will be generated
c_bpartner invoicerule bpchar 1  √  null Frequency and method of invoicing
c_invoiceschedule invoiceweekday bpchar 1  √  null Day to generate invoices
c_invoiceschedule invoiceweekdaycutoff bpchar 1  √  null Last day in the week for shipments to be included
c_bpartner is1099vendor bpchar 1 'N'::bpchar 1099 Vendor
ad_find isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_pinstance isactive bpchar 1  √  'Y'::bpchar The record is active in the system
ad_pinstance_para 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_bp_group 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_campaign isactive bpchar 1 'Y'::bpchar The record is active in the system
c_conversiontype isactive bpchar 1 'Y'::bpchar The record is active in the system
c_currency isactive bpchar 1 'Y'::bpchar The record is active in the system
c_doctype 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_invoicepayschedule isactive bpchar 1 'Y'::bpchar The record is active in the system
c_invoiceschedule isactive bpchar 1 'Y'::bpchar The record is active in the system
c_payschedule 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
fact_acct 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
t_1099extract isactive bpchar 1 The record is active in the system
t_aging isactive bpchar 1 'Y'::bpchar The record is active in the system
t_bom_indented isactive bpchar 1  √  NULL::bpchar The record is active in the system
t_bomline isactive bpchar 1  √  null The record is active in the system
t_bomline_costs isactive bpchar 1  √  null The record is active in the system
t_cashflow isactive bpchar 1 'Y'::bpchar The record is active in the system
t_invoicegl isactive bpchar 1 'Y'::bpchar The record is active in the system
t_invoicegl_v isactive bpchar 1  √  null The record is active in the system
t_mrp_crp isactive bpchar 1  √  null The record is active in the system
t_reconciliation isactive bpchar 1 The record is active in the system
t_rv_reconciliation isactive bpchar 1  √  null The record is active in the system
t_transaction isactive bpchar 1 'Y'::bpchar The record is active in the system
t_invoicegl isallcurrencies bpchar 1 'N'::bpchar Report not just foreign currency Invoices
t_invoicegl_v isallcurrencies bpchar 1  √  null Report not just foreign currency Invoices
c_invoiceschedule isamount bpchar 1 'N'::bpchar Send invoices only if the amount exceeds the limit
c_invoice isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
t_invoicegl_v isapproved bpchar 1  √  null Indicates if this document requires approval
t_rv_reconciliation isbankaccount bpchar 1  √  null
c_doctype ischargeorproductmandatory bpchar 1  √  'N'::bpchar Mandatory Charge or Product
c_project 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_bp_group isconfidentialinfo bpchar 1 'N'::bpchar Can enter confidential information
t_bomline iscostfrozen bpchar 1  √  NULL::bpchar Indicated that the Standard Cost is frozen
t_bomline_costs iscostfrozen bpchar 1  √  null Indicated that the Standard Cost is frozen
c_doctype iscreatecounter bpchar 1 'Y'::bpchar Create Counter Document
t_bomline_costs iscritical bpchar 1  √  null Indicate that a Manufacturing Order can not begin without have this component
c_bpartner iscustomer bpchar 1 'Y'::bpchar Indicates if this Business Partner is a Customer
c_bp_group isdefault bpchar 1 'N'::bpchar Default value
c_conversiontype isdefault bpchar 1 'N'::bpchar Default value
c_doctype isdefault bpchar 1 'N'::bpchar Default value
c_invoiceschedule isdefault bpchar 1 'N'::bpchar Default value
c_doctype isdefaultcounterdoc bpchar 1 'N'::bpchar The document type is the default counter document type
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar Print Discount on Invoice and Order
c_invoice isdiscountprinted bpchar 1 'Y'::bpchar Print Discount on Invoice and Order
t_invoicegl_v isdiscountprinted bpchar 1  √  null Print Discount on Invoice and Order
c_doctype isdocnocontrolled bpchar 1 'N'::bpchar The document has a document sequence
t_rv_reconciliation isdropship bpchar 1  √  null
c_bpartner isemployee bpchar 1 'N'::bpchar Indicates if this Business Partner is an employee
c_currency isemumember bpchar 1 'N'::bpchar This currency is member if the European Monetary Union
c_currency iseuro bpchar 1 'N'::bpchar This currency is the Euro
t_rv_reconciliation isexcludeautodelivery bpchar 1  √  null
c_invoice isfixedassetinvoice bpchar 1  √  null Is Fixed Asset Invoice
t_rv_reconciliation isforeigncurrency bpchar 1  √  null
c_doctype isindexed bpchar 1 'Y'::bpchar Index the document for the internal search engine
c_invoice isindispute bpchar 1 'N'::bpchar Document is in dispute
t_invoicegl_v isindispute bpchar 1  √  null Document is in dispute
c_doctype isintransit bpchar 1 'N'::bpchar Movement is in transit
t_rv_reconciliation isinvoiceprintdetails bpchar 1  √  null
t_aging islistinvoices bpchar 1 'N'::bpchar Include List of Invoices
c_bpartner ismanufacturer bpchar 1  √  'N'::bpchar Indicate role of this Business partner as Manufacturer
c_doctype isnopricelistcheck bpchar 1  √  'N'::bpchar Allow Product Without Price List
ad_pinstance_para isnotclause bpchar 1 'N'::bpchar Indicates if a chosen multiple component value must be negate
c_bpartner isonetime bpchar 1 'N'::bpchar One time transaction
c_invoice isoverridecurrencyrate bpchar 1 'N'::bpchar Override Currency Conversion Rate
c_doctype isoverwritedateoncomplete bpchar 1  √  'N'::bpchar Overwrite Date on Complete
c_doctype isoverwriteseqoncomplete bpchar 1  √  'N'::bpchar Overwrite Sequence on Complete
c_invoice ispaid bpchar 1 'N'::bpchar The document is fully paid
t_invoicegl_v ispaid bpchar 1  √  null The document is fully paid
c_invoice ispayschedulevalid bpchar 1 'N'::bpchar Is the Payment Schedule is valid
t_invoicegl_v ispayschedulevalid bpchar 1  √  null Is the Payment Schedule is valid
t_rv_reconciliation ispicklistprintdetails bpchar 1  √  null
c_doctype ispickqaconfirm bpchar 1 'N'::bpchar Require Pick or QA Confirmation before processing
c_bpartner ispotaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on purchases
c_doctype ispreparesplitdocument bpchar 1 'Y'::bpchar Prepare generated split shipment/receipt document
c_invoice isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
t_invoicegl_v isprinted bpchar 1  √  null Indicates if this document / line is printed
ad_pinstance isprocessing bpchar 1 'N'::bpchar Processing
c_bpartner isprospect bpchar 1 'N'::bpchar Indicates this is a Prospect
t_rv_reconciliation ispurchased bpchar 1  √  null
t_bomline_costs isqtypercentage bpchar 1  √  null Indicate that this component is based in % Quantity
ad_pinstance isrunasjob bpchar 1  √  'N'::bpchar Run as Job
c_bpartner issalesrep bpchar 1 'N'::bpchar Indicates if the business partner is a sales representative or company agent
c_invoice isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
t_invoicegl_v isselfservice bpchar 1  √  null This is a Self-Service entry or this entry can be changed via Self-Service
t_rv_reconciliation isselfservice bpchar 1  √  null
c_doctype isshipconfirm bpchar 1 'N'::bpchar Require Ship or Receipt Confirmation before processing
t_rv_reconciliation issold bpchar 1  √  null
c_doctype issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
c_invoice issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
t_aging issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
t_cashflow issotrx bpchar 1 This is a Sales Transaction
t_invoicegl_v issotrx bpchar 1  √  null This is a Sales Transaction
c_doctype issplitwhendifference bpchar 1 'N'::bpchar Split document when there is a difference
t_rv_reconciliation isstocked bpchar 1  √  null
t_bomline_costs issuemethod bpchar 1  √  null There are two methods for issue the components to Manufacturing Order
ad_pinstance issummary bpchar 1  √  NULL::bpchar This is a summary entity
c_activity issummary bpchar 1 'N'::bpchar This is a summary entity
c_bpartner issummary bpchar 1 'N'::bpchar This is a summary entity
c_campaign issummary bpchar 1 'N'::bpchar This is a summary entity
c_project issummary bpchar 1 'N'::bpchar This is a summary entity
c_bpartner istaxexempt bpchar 1  √  'N'::bpchar Business partner is exempt from tax on sales
c_invoice istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
t_invoicegl_v istaxincluded bpchar 1  √  null Tax is included in the price
c_invoice istransferred bpchar 1 'N'::bpchar Transferred to General Ledger (i.e. accounted)
t_invoicegl_v istransferred bpchar 1  √  null Transferred to General Ledger (i.e. accounted)
c_invoicepayschedule isvalid bpchar 1 'N'::bpchar Element is valid
c_payschedule isvalid bpchar 1 'N'::bpchar Element is valid
c_bpartner isvendor bpchar 1 'N'::bpchar Indicates if this Business Partner is a Vendor
t_rv_reconciliation isverified bpchar 1  √  null
t_rv_reconciliation iswebstorefeatured bpchar 1  √  null
t_rv_reconciliation m_product_copyfrom bpchar 1  √  null
t_rv_reconciliation m_product_isactive bpchar 1  √  null
t_rv_reconciliation m_product_issummary bpchar 1  √  null
t_rv_reconciliation m_product_processing bpchar 1  √  null
c_payschedule netday bpchar 1  √  null Day when payment is due net
c_bpartner paymentrule bpchar 1  √  null How you pay the invoice
c_invoice paymentrule bpchar 1 How you pay the invoice
t_invoicegl_v paymentrule bpchar 1  √  null How you pay the invoice
c_bpartner paymentrulepo bpchar 1  √  null Purchase payment option
c_invoice posted bpchar 1 'N'::bpchar Posting status
t_invoicegl_v posted bpchar 1  √  null Posting status
fact_acct postingtype bpchar 1 The type of posted amount for the transaction
t_invoicegl_v postingtype bpchar 1  √  null The type of posted amount for the transaction
t_rv_reconciliation postingtype bpchar 1  √  null The type of posted amount for the transaction
c_bp_group prioritybase bpchar 1  √  null Base of Priority
c_invoice processed bpchar 1 'N'::bpchar The document has been processed
c_invoicepayschedule processed bpchar 1 'N'::bpchar The document has been processed
c_project processed bpchar 1 'N'::bpchar The document has been processed
c_invoice processing bpchar 1  √  null Process Now
c_invoicepayschedule processing bpchar 1  √  null Process Now
c_project processing bpchar 1  √  null Process Now
t_invoicegl_v processing bpchar 1  √  null Process Now
t_rv_reconciliation producttype bpchar 1  √  null
c_project projectcategory bpchar 1  √  'N'::bpchar Project Category
c_project projectlinelevel bpchar 1 'P'::bpchar Project Line Level
c_project projinvoicerule bpchar 1 '-'::bpchar Invoice Rule for the project
c_bpartner rating bpchar 1  √  null Classification or Importance
t_replenish replenishtype bpchar 1 Method for re-ordering a product
c_bpartner sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_invoice sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
t_invoicegl_v sendemail bpchar 1  √  null Enable sending Document EMail
c_bpartner socreditstatus bpchar 1  √  'O'::bpchar Business Partner Credit Status
t_invoicegl_v t_invoicegl_isactive bpchar 1  √  null t_invoicegl_isactive
t_bomline_costs componenttype bpchar 2  √  null Component Type for a Bill of Material or Formula
c_invoice docaction bpchar 2 The targeted status of the document
t_invoicegl_v docaction bpchar 2  √  null The targeted status of the document
c_invoice docstatus bpchar 2 The current status of the document
t_invoicegl_v docstatus bpchar 2  √  null The current status of the document
c_doctype docsubtypeso bpchar 2  √  null Sales Order Sub Type
m_transaction movementtype bpchar 2 Method of moving the inventory
t_transaction movementtype bpchar 2 Method of moving the inventory
ad_find operation bpchar 2 Compare Operation
c_doctype docbasetype bpchar 3 Logical type of document
c_currency iso_code bpchar 3 Three letter ISO 4217 Code of the Currency
t_replenish replenishmentcreate bpchar 3  √  null Create from Replenishment
c_bpartner acqusitioncost numeric 0  √  0 The cost of gaining the prospect as a customer
c_bpartner actuallifetimevalue numeric 0  √  0 Actual Life Time Revenue
c_invoiceschedule amt numeric 0  √  0 Amount
t_rv_reconciliation amtacct numeric 0  √  null Amount Balance in Currency of Accounting Schema
t_invoicegl amtacctbalance numeric 0 0 Accounted Balance Amount
t_invoicegl_v amtacctbalance numeric 0  √  null Accounted Balance Amount
fact_acct amtacctcr numeric 0 0 Accounted Credit Amount
t_bankregister amtacctcr numeric 0  √  null Accounted Credit Amount
t_invoicegl_v amtacctcr numeric 0  √  null Accounted Credit Amount
t_rv_reconciliation amtacctcr numeric 0  √  null Accounted Credit Amount
fact_acct amtacctdr numeric 0 0 Accounted Debit Amount
t_bankregister amtacctdr numeric 0  √  null Accounted Debit Amount
t_invoicegl_v amtacctdr numeric 0  √  null Accounted Debit Amount
t_rv_reconciliation amtacctdr numeric 0  √  null Accounted Debit Amount
t_invoicegl_v amtacctopenbalance numeric 0  √  null Open Balance in document currency & rate
t_invoicegl_v amtacctopencr numeric 0  √  null Open Credit in document currency & rate
t_invoicegl_v amtacctopendr numeric 0  √  null Open Debit in document currency & rate
t_1099extract amtbucket01 numeric 0  √  null Amount Bucket 1
t_1099extract amtbucket02 numeric 0  √  null Amount Bucket 2
t_1099extract amtbucket03 numeric 0  √  null Amount Bucket 3
t_1099extract amtbucket04 numeric 0  √  null Amount Bucket 4
t_1099extract amtbucket05 numeric 0  √  null Amount Bucket 5
t_1099extract amtbucket06 numeric 0  √  null Amount Bucket 6
t_1099extract amtbucket07 numeric 0  √  null Amount Bucket 7
t_1099extract amtbucket08 numeric 0  √  null Amount Bucket 8
t_1099extract amtbucket09 numeric 0  √  null Amount Bucket 9
t_1099extract amtbucket10 numeric 0  √  null Amount Bucket 10
t_1099extract amtbucket11 numeric 0  √  null Amount Bucket 11
t_1099extract amtbucket12 numeric 0  √  null Amount Bucket 12
t_1099extract amtbucket13 numeric 0  √  null Amount Bucket 13
t_1099extract amtbucket14 numeric 0  √  null Amount Bucket 14
t_1099extract amtbucket15 numeric 0  √  null Amount Bucket 15
t_1099extract amtbucket16 numeric 0  √  null Amount Bucket 16
t_invoicegl amtrevalcr numeric 0 0 Revaluated Cr Amount
t_invoicegl_v amtrevalcr numeric 0  √  null Revaluated Cr Amount
t_invoicegl amtrevalcrdiff numeric 0 0 Revaluated Cr Amount Difference
t_invoicegl_v amtrevalcrdiff numeric 0  √  null Revaluated Cr Amount Difference
t_invoicegl amtrevaldr numeric 0 0 Revaluated Dr Amount
t_invoicegl_v amtrevaldr numeric 0  √  null Revaluated Dr Amount
t_invoicegl amtrevaldrdiff numeric 0 0 Revaluated Dr Amount Difference
t_invoicegl_v amtrevaldrdiff numeric 0  √  null Revaluated Dr Amount Difference
t_rv_reconciliation amtsource numeric 0  √  null Amount Balance in Source Currency
t_invoicegl amtsourcebalance numeric 0 0 Source Balance Amount
t_invoicegl_v amtsourcebalance numeric 0  √  null Source Balance Amount
fact_acct amtsourcecr numeric 0 0 Source Credit Amount
t_invoicegl_v amtsourcecr numeric 0  √  null Source Credit Amount
t_rv_reconciliation amtsourcecr numeric 0  √  null Source Credit Amount
fact_acct amtsourcedr numeric 0 0 Source Debit Amount
t_invoicegl_v amtsourcedr numeric 0  √  null Source Debit Amount
t_rv_reconciliation amtsourcedr numeric 0  √  null Source Debit Amount
t_bankregister balance numeric 0  √  null Balance
t_rv_reconciliation c_bp_acqusitioncost numeric 0  √  null
t_rv_reconciliation c_bp_actuallifetimevalue numeric 0  √  null
t_rv_reconciliation c_bp_flatdiscount numeric 0  √  null
t_rv_reconciliation c_bp_potentiallifetimevalue numeric 0  √  null
t_rv_reconciliation c_bp_so_creditlimit numeric 0  √  null
t_rv_reconciliation c_bp_so_creditused numeric 0  √  null
t_rv_reconciliation c_bp_totalopenbalance numeric 0  √  null
c_invoice chargeamt numeric 0  √  0 Charge Amount
t_invoicegl_v chargeamt numeric 0  √  null Charge Amount
c_project committedamt numeric 0 0 The (legal) commitment amount
c_project committedqty numeric 0 0 The (legal) commitment Quantity
t_bom_indented cost numeric 0  √  null Cost information
t_bomline_costs cost numeric 0  √  null Cost information
t_inventoryvalue cost numeric 0  √  0 Cost information
t_inventoryvalue costamt numeric 0  √  0 Value with Cost
t_bom_indented costfuture numeric 0  √  null Cost information
c_campaign costs numeric 0 0 Costs in accounting currency
t_bomline coststandard numeric 0  √  null Standard Costs
t_bomline_costs coststandard numeric 0  √  null Standard Costs
t_inventoryvalue coststandard numeric 0  √  0 Standard Costs
t_inventoryvalue coststandardamt numeric 0  √  0 Value in Standard Costs
c_bp_group creditwatchpercent numeric 0  √  null Credit Watch - Percent of Credit Limit when OK switches to Watch
c_invoice currencyrate numeric 0  √  null Currency Conversion Rate
t_bom_indented currentcostprice numeric 0  √  null The currently used cost price
t_bomline currentcostprice numeric 0  √  null The currently used cost price
t_bomline_costs currentcostprice numeric 0  √  null The currently used cost price
t_bom_indented currentcostpricell numeric 0  √  null Current Price Lower Level Is the sum of the costs of the components of this product manufactured for this level.
t_bomline currentcostpricell numeric 0  √  null Current Price Lower Level Is the sum of the costs of the components of this product manufactured for this level.
t_bomline_costs currentcostpricell numeric 0  √  null Current Price Lower Level Is the sum of the costs of the components of this product manufactured for this level.
c_payschedule discount numeric 0 Discount in percent
c_invoicepayschedule discountamt numeric 0 0 Calculated amount of discount
t_aging due0 numeric 0 0 Due Today
t_aging due0_30 numeric 0 0 Due Today-30
t_aging due0_7 numeric 0 0 Due Today-7
t_aging due1_7 numeric 0 0 Due 1-7
t_aging due31_60 numeric 0 0 Due 31-60
t_aging due31_plus numeric 0 0 Due > 31
t_aging due61_90 numeric 0 0 Due 61-90
t_aging due61_plus numeric 0 0 Due > 61
t_aging due8_30 numeric 0 0 Due 8-30
t_aging due91_plus numeric 0 0 Due > 91
c_invoicepayschedule dueamt numeric 0 0 Amount of the payment due
t_aging dueamt numeric 0 0 Amount of the payment due
c_currency emurate numeric 0  √  0 Official rate to the Euro
ad_find find_id numeric 0 Find
c_bpartner flatdiscount numeric 0  √  null Flat discount percentage
t_bom_indented futurecostprice numeric 0  √  null Future Cost Price
t_bomline futurecostprice numeric 0  √  null Future Cost Price
t_bomline_costs futurecostprice numeric 0  √  null Future Cost Price
t_bom_indented futurecostpricell numeric 0  √  null Future Cost Price Lower Level
t_bomline futurecostpricell numeric 0  √  null Future Cost Price Lower Level
t_bomline_costs futurecostpricell numeric 0  √  null Future Cost Price Lower Level
c_invoice grandtotal numeric 0 0 Total amount of document
t_invoicegl grandtotal numeric 0 0 Total amount of document
t_invoicegl_v grandtotal numeric 0  √  null Total amount of document
c_project invoicedamt numeric 0 0 The amount invoiced
t_aging invoicedamt numeric 0 0 The amount invoiced
c_project invoicedqty numeric 0 0 The quantity invoiced
t_replenish level_max numeric 0 0 Maximum Inventory level for this product
t_replenish level_min numeric 0 0 Minimum Inventory level for this product
t_cashflow linetotalamt numeric 0  √  null Total line amount incl. Tax
m_transaction movementqty numeric 0 0 Quantity of a product moved.
t_transaction movementqty numeric 0 0 Quantity of a product moved.
t_aging openamt numeric 0 0 Open item amount
t_invoicegl openamt numeric 0 0 Open item amount
t_invoicegl_v openamt numeric 0  √  null Open item amount
t_replenish order_min numeric 0 0 Minimum order quantity in UOM
t_replenish order_pack numeric 0 0 Package order size in UOM (e.g. order set of 5 units)
ad_pinstance_log p_number numeric 0  √  null Process Parameter
ad_pinstance_para p_number numeric 0  √  null Process Parameter
ad_pinstance_para p_number_to numeric 0  √  null Process Parameter
t_aging pastdue1_30 numeric 0 0 Past Due 1-30
t_aging pastdue1_7 numeric 0 0 Past Due 1-7
t_aging pastdue31_60 numeric 0 0 Past Due 31-60
t_aging pastdue31_plus numeric 0 0 Past Due > 31
t_aging pastdue61_90 numeric 0 0 Past Due 61-90
t_aging pastdue61_plus numeric 0 0 Past Due > 61
t_aging pastdue8_30 numeric 0 0 Past Due 8-30
t_aging pastdue91_plus numeric 0 0 Past Due > 91
t_aging pastdueamt numeric 0 0 Past Due
t_invoicegl percent numeric 0  √  null Percentage
t_invoicegl_v percent numeric 0  √  null Percentage
c_payschedule percentage numeric 0 Percent of the entire amount
c_project 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_bpartner potentiallifetimevalue numeric 0  √  0 Total Revenue expected
t_inventoryvalue pricelimit numeric 0  √  0 Lowest price for a product
t_inventoryvalue pricelimitamt numeric 0  √  0 Value with limit price
t_inventoryvalue pricelist numeric 0  √  0 List Price
t_inventoryvalue pricelistamt numeric 0  √  0 Valuation with List Price
c_bp_group pricematchtolerance numeric 0  √  null PO-Invoice Match Price Tolerance in percent of the purchase price
t_inventoryvalue pricepo numeric 0  √  0 Price based on a purchase order
t_inventoryvalue pricepoamt numeric 0  √  0 Valuation with PO Price
t_inventoryvalue pricestd numeric 0  √  0 Standard Price
t_inventoryvalue pricestdamt numeric 0  √  0 Valuation with standard price
t_cashflow probability numeric 0  √  null Probability
c_invoice processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
t_invoicegl_v processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
c_project projectbalanceamt numeric 0 0 Total Project Balance
fact_acct qty numeric 0  √  0 Quantity
t_bom_indented qty numeric 0  √  null Quantity
t_invoicegl_v qty numeric 0  √  null Quantity
t_rv_reconciliation qty numeric 0  √  null Quantity
t_bom_indented qtybom numeric 0  √  null Indicate the Quantity use in this BOM
t_bomline qtybom numeric 0  √  null Indicate the Quantity use in this BOM
t_bomline_costs qtybom numeric 0  √  null Indicate the Quantity use in this BOM
t_inventoryvalue qtyonhand numeric 0  √  0 On Hand Quantity
t_replenish qtyonhand numeric 0 0 On Hand Quantity
t_replenish qtyordered numeric 0 0 Ordered Quantity
t_replenish qtyreserved numeric 0 0 Reserved Quantity
t_replenish qtytoorder numeric 0 0 Quantity to Order
t_selection2 query_id numeric 0
t_rv_reconciliation rate numeric 0  √  null Rate or Tax or Exchange
c_currency roundofffactor numeric 0  √  null Used to Round Off Payment Amount
t_bomline_costs scrap numeric 0  √  null Indicate the Scrap % for calculate the Scrap Quantity
t_rv_reconciliation shelfheight numeric 0  √  null
c_bpartner so_creditlimit numeric 0  √  0 Total outstanding invoice amounts allowed
c_bpartner so_creditused numeric 0  √  0 Current open balance
t_invoicegl_v t_invoicegl_grandtotal numeric 0  √  null t_invoicegl_grandtotal
c_invoice totallines numeric 0 0 Total of all document lines
t_invoicegl_v totallines numeric 0  √  null Total of all document lines
c_bpartner totalopenbalance numeric 0  √  null Total Open Balance Amount in primary Accounting Currency
t_rv_reconciliation unitsperpallet numeric 0  √  null
t_rv_reconciliation volume numeric 0  √  null
t_rv_reconciliation weight numeric 0  √  null
fact_acct a_asset_id numeric 10  √  null Asset used internally or by customers
t_invoicegl_v a_asset_id numeric 10  √  null Asset used internally or by customers
t_rv_reconciliation a_asset_id numeric 10  √  null Asset used internally or by customers
fact_acct account_id numeric 10 Account used
t_invoicegl_v account_id numeric 10  √  null Account used
t_rv_reconciliation account_id numeric 10  √  null Account used
ad_find ad_client_id numeric 10 Tenant for this installation.
ad_pinstance ad_client_id numeric 10  √  null Tenant for this installation.
ad_pinstance_para ad_client_id numeric 10  √  null Tenant for this installation.
c_activity ad_client_id numeric 10 Tenant for this installation.
c_bp_group ad_client_id numeric 10 Tenant for this installation.
c_bpartner ad_client_id numeric 10 Tenant for this installation.
c_campaign ad_client_id numeric 10 Tenant for this installation.
c_conversiontype ad_client_id numeric 10 Tenant for this installation.
c_currency ad_client_id numeric 10 Tenant for this installation.
c_doctype ad_client_id numeric 10 Tenant for this installation.
c_invoice ad_client_id numeric 10 Tenant for this installation.
c_invoicepayschedule ad_client_id numeric 10 Tenant for this installation.
c_invoiceschedule ad_client_id numeric 10 Tenant for this installation.
c_payschedule ad_client_id numeric 10 Tenant for this installation.
c_project ad_client_id numeric 10 Tenant for this installation.
fact_acct ad_client_id numeric 10 Tenant for this installation.
m_transaction ad_client_id numeric 10 Tenant for this installation.
t_1099extract ad_client_id numeric 10 Tenant for this installation.
t_aging ad_client_id numeric 10 Tenant for this installation.
t_bankregister ad_client_id numeric 10 Tenant for this installation.
t_bom_indented ad_client_id numeric 10 Tenant for this installation.
t_bomline ad_client_id numeric 10 Tenant for this installation.
t_bomline_costs ad_client_id numeric 10  √  null Tenant for this installation.
t_cashflow ad_client_id numeric 10 Tenant for this installation.
t_inventoryvalue ad_client_id numeric 10  √  null Tenant for this installation.
t_invoicegl ad_client_id numeric 10 Tenant for this installation.
t_invoicegl_v ad_client_id numeric 10  √  null Tenant for this installation.
t_mrp_crp ad_client_id numeric 10 Tenant for this installation.
t_reconciliation ad_client_id numeric 10 Tenant for this installation.
t_replenish ad_client_id numeric 10 Tenant for this installation.
t_rv_reconciliation ad_client_id numeric 10  √  null Tenant for this installation.
t_transaction ad_client_id numeric 10 Tenant for this installation.
ad_find ad_column_id numeric 10 Column in the table
ad_find ad_find_id numeric 10 Find
ad_pinstance ad_language_id numeric 10  √  NULL::numeric Language ID
ad_find ad_org_id numeric 10 Organizational entity within tenant
ad_pinstance ad_org_id numeric 10  √  null Organizational entity within tenant
ad_pinstance_para ad_org_id numeric 10  √  null Organizational entity within tenant
c_activity ad_org_id numeric 10 Organizational entity within tenant
c_bp_group ad_org_id numeric 10 Organizational entity within tenant
c_bpartner ad_org_id numeric 10 Organizational entity within tenant
c_campaign ad_org_id numeric 10 Organizational entity within tenant
c_conversiontype ad_org_id numeric 10 Organizational entity within tenant
c_currency ad_org_id numeric 10 Organizational entity within tenant
c_doctype ad_org_id numeric 10 Organizational entity within tenant
c_invoice ad_org_id numeric 10 Organizational entity within tenant
c_invoicepayschedule ad_org_id numeric 10 Organizational entity within tenant
c_invoiceschedule ad_org_id numeric 10 Organizational entity within tenant
c_payschedule ad_org_id numeric 10 Organizational entity within tenant
c_project ad_org_id numeric 10 Organizational entity within tenant
fact_acct ad_org_id numeric 10 Organizational entity within tenant
m_transaction ad_org_id numeric 10 Organizational entity within tenant
t_1099extract ad_org_id numeric 10  √  NULL::numeric Organizational entity within tenant
t_aging ad_org_id numeric 10 Organizational entity within tenant
t_bankregister ad_org_id numeric 10 Organizational entity within tenant
t_bom_indented ad_org_id numeric 10 Organizational entity within tenant
t_bomline ad_org_id numeric 10 Organizational entity within tenant
t_bomline_costs ad_org_id numeric 10  √  null Organizational entity within tenant
t_cashflow ad_org_id numeric 10 Organizational entity within tenant
t_inventoryvalue ad_org_id numeric 10  √  null Organizational entity within tenant
t_invoicegl ad_org_id numeric 10 Organizational entity within tenant
t_invoicegl_v ad_org_id numeric 10  √  null Organizational entity within tenant
t_mrp_crp ad_org_id numeric 10 Organizational entity within tenant
t_reconciliation ad_org_id numeric 10  √  NULL::numeric Organizational entity within tenant
t_replenish ad_org_id numeric 10 Organizational entity within tenant
t_rv_reconciliation ad_org_id numeric 10  √  null Organizational entity within tenant
t_transaction ad_org_id numeric 10 Organizational entity within tenant
c_bpartner ad_orgbp_id numeric 10  √  null The Business Partner is another Organization for explicit Inter-Org transactions
c_invoice ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_project ad_orgtrx_id numeric 10  √  NULL::numeric Performing or initiating organization
fact_acct ad_orgtrx_id numeric 10  √  null Performing or initiating organization
t_invoicegl_v ad_orgtrx_id numeric 10  √  null Performing or initiating organization
t_rv_reconciliation ad_orgtrx_id numeric 10  √  null Performing or initiating organization
ad_pinstance ad_pinstance_id numeric 10 Instance of the process
ad_pinstance_log ad_pinstance_id numeric 10 Instance of the process
ad_pinstance_para ad_pinstance_id numeric 10 Instance of the process
t_1099extract ad_pinstance_id numeric 10 Instance of the process
t_aging ad_pinstance_id numeric 10 Instance of the process
t_bankregister ad_pinstance_id numeric 10 Instance of the process
t_bom_indented ad_pinstance_id numeric 10  √  NULL::numeric Instance of the process
t_bomline ad_pinstance_id numeric 10  √  null Instance of the process
t_bomline_costs ad_pinstance_id numeric 10  √  null Instance of the process
t_cashflow ad_pinstance_id numeric 10 Instance of the process
t_inventoryvalue ad_pinstance_id numeric 10 Instance of the process
t_invoicegl ad_pinstance_id numeric 10 Instance of the process
t_invoicegl_v ad_pinstance_id numeric 10  √  null Instance of the process
t_mrp_crp ad_pinstance_id numeric 10  √  null Instance of the process
t_reconciliation ad_pinstance_id numeric 10 Instance of the process
t_replenish ad_pinstance_id numeric 10 Instance of the process
t_rv_reconciliation ad_pinstance_id numeric 10  √  null Instance of the process
t_selection ad_pinstance_id numeric 10
t_selection2 ad_pinstance_id numeric 10
t_spool ad_pinstance_id numeric 10 Instance of the process
t_transaction ad_pinstance_id numeric 10 Instance of the process
c_bp_group ad_printcolor_id numeric 10  √  null Color used for printing and display
ad_pinstance ad_printformat_id numeric 10  √  NULL::numeric Data Print Format
c_doctype ad_printformat_id numeric 10  √  null Data Print Format
ad_pinstance ad_process_id numeric 10 Process or Report
ad_pinstance ad_session_id numeric 10  √  NULL::numeric User Session Online or Web
ad_pinstance ad_table_id numeric 10  √  NULL::numeric Database Table information
ad_pinstance_log ad_table_id numeric 10  √  NULL::numeric Database Table information
fact_acct ad_table_id numeric 10 Database Table information
t_rv_reconciliation ad_table_id numeric 10  √  null Database Table information
ad_pinstance ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_invoice ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_project ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
t_invoicegl_v ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_bpartner bpartner_parent_id numeric 10  √  null Business Partner Parent
fact_acct c_acctschema_id numeric 10 Rules for accounting
t_bom_indented c_acctschema_id numeric 10  √  NULL::numeric Rules for accounting
t_bomline c_acctschema_id numeric 10  √  null Rules for accounting
t_bomline_costs c_acctschema_id numeric 10  √  null Rules for accounting
t_cashflow c_acctschema_id numeric 10  √  NULL::numeric Rules for accounting
t_invoicegl_v c_acctschema_id numeric 10  √  null Rules for accounting
t_rv_reconciliation c_acctschema_id numeric 10  √  null Rules for accounting
c_activity c_activity_id numeric 10 Business Activity
c_invoice c_activity_id numeric 10  √  null Business Activity
c_project c_activity_id numeric 10  √  NULL::numeric Business Activity
fact_acct c_activity_id numeric 10  √  null Business Activity
t_aging c_activity_id numeric 10  √  null Business Activity
t_cashflow c_activity_id numeric 10  √  NULL::numeric Business Activity
t_invoicegl_v c_activity_id numeric 10  √  null Business Activity
t_rv_reconciliation c_activity_id numeric 10  √  null Business Activity
t_bankregister c_bank_id numeric 10  √  NULL::numeric Bank
t_rv_reconciliation c_bankaccount_id numeric 10  √  null
t_rv_reconciliation c_bp_ad_org_id numeric 10  √  null
t_rv_reconciliation c_bp_ad_orgbp_id numeric 10  √  null
t_rv_reconciliation c_bp_bpartner_parent_id numeric 10  √  null
t_rv_reconciliation c_bp_c_dunning_id numeric 10  √  null
t_rv_reconciliation c_bp_c_greeting_id numeric 10  √  null
t_rv_reconciliation c_bp_c_invoiceschedule_id numeric 10  √  null
t_rv_reconciliation c_bp_c_paymentterm_id numeric 10  √  null
t_rv_reconciliation c_bp_c_taxgroup_id numeric 10  √  null
t_rv_reconciliation c_bp_createdby numeric 10  √  null
c_bp_group c_bp_group_id numeric 10 Business Partner Group
c_bpartner c_bp_group_id numeric 10 Business Partner Group
t_aging c_bp_group_id numeric 10 Business Partner Group
t_rv_reconciliation c_bp_group_id numeric 10  √  null Business Partner Group
t_rv_reconciliation c_bp_logo_id numeric 10  √  null
t_rv_reconciliation c_bp_m_discountschema_id numeric 10  √  null
t_rv_reconciliation c_bp_m_pricelist_id numeric 10  √  null
t_rv_reconciliation c_bp_numberemployees numeric 10  √  null
t_rv_reconciliation c_bp_po_discountschema_id numeric 10  √  null
t_rv_reconciliation c_bp_po_paymentterm_id numeric 10  √  null
t_rv_reconciliation c_bp_po_pricelist_id numeric 10  √  null
t_rv_reconciliation c_bp_salesrep_id numeric 10  √  null
t_rv_reconciliation c_bp_salesvolume numeric 10  √  null
t_rv_reconciliation c_bp_shareofcustomer numeric 10  √  null
t_rv_reconciliation c_bp_shelflifeminpct numeric 10  √  null
t_rv_reconciliation c_bp_updatedby numeric 10  √  null
c_bpartner c_bpartner_id numeric 10 Identifies a Business Partner
c_invoice c_bpartner_id numeric 10 Identifies a Business Partner
c_project c_bpartner_id numeric 10  √  null Identifies a Business Partner
fact_acct c_bpartner_id numeric 10  √  null Identifies a Business Partner
t_1099extract c_bpartner_id numeric 10 Identifies a Business Partner
t_aging c_bpartner_id numeric 10 Identifies a Business Partner
t_bankregister c_bpartner_id numeric 10  √  NULL::numeric Identifies a Business Partner
t_cashflow c_bpartner_id numeric 10  √  NULL::numeric Identifies a Business Partner
t_invoicegl_v c_bpartner_id numeric 10  √  null Identifies a Business Partner
t_replenish c_bpartner_id numeric 10 Identifies a Business Partner
t_rv_reconciliation c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_invoice c_bpartner_location_id numeric 10 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
t_invoicegl_v 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_campaign c_campaign_id numeric 10 Marketing Campaign
c_invoice c_campaign_id numeric 10  √  null Marketing Campaign
c_project c_campaign_id numeric 10  √  null Marketing Campaign
fact_acct c_campaign_id numeric 10  √  null Marketing Campaign
t_aging c_campaign_id numeric 10  √  null Marketing Campaign
t_cashflow c_campaign_id numeric 10  √  NULL::numeric Marketing Campaign
t_invoicegl_v c_campaign_id numeric 10  √  null Marketing Campaign
t_rv_reconciliation c_campaign_id numeric 10  √  null Marketing Campaign
c_invoice c_cashline_id numeric 10  √  null Cash Journal Line
c_invoice c_cashplanline_id numeric 10  √  NULL::numeric Cash Plan Line
t_cashflow 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
t_cashflow c_charge_id numeric 10  √  NULL::numeric Additional document charges
c_conversiontype c_conversiontype_id numeric 10 Currency Conversion Rate Type
c_invoice c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
t_invoicegl_v c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
t_invoicegl c_conversiontypereval_id numeric 10 Revaluation Currency Conversion Type
t_invoicegl_v c_conversiontypereval_id numeric 10  √  null Revaluation Currency Conversion Type
c_currency c_currency_id numeric 10 The Currency for this record
c_invoice c_currency_id numeric 10 The Currency for this record
c_project c_currency_id numeric 10 The Currency for this record
fact_acct c_currency_id numeric 10 The Currency for this record
t_aging c_currency_id numeric 10 The Currency for this record
t_inventoryvalue c_currency_id numeric 10  √  null The Currency for this record
t_invoicegl_v c_currency_id numeric 10  √  null The Currency for this record
t_rv_reconciliation c_currency_id numeric 10  √  null The Currency for this record
c_doctype c_doctype_id numeric 10 Document type or rules
c_invoice c_doctype_id numeric 10 Document type or rules
t_invoicegl_v c_doctype_id numeric 10  √  null Document type or rules
t_replenish c_doctype_id numeric 10  √  null Document type or rules
c_doctype c_doctypedifference_id numeric 10  √  null Document type for generating in dispute Shipments
c_doctype c_doctypeinvoice_id numeric 10  √  null Document type used for invoices generated from this sales document
c_doctype c_doctypeproforma_id numeric 10  √  null Document type used for pro forma invoices generated from this sales document
t_invoicegl c_doctypereval_id numeric 10  √  null Document Type for Revaluation Journal
t_invoicegl_v c_doctypereval_id numeric 10  √  null Document Type for Revaluation Journal
c_doctype c_doctypeshipment_id numeric 10  √  null Document type used for shipments generated from this sales document
c_invoice c_doctypetarget_id numeric 10 Target document type for conversing documents
t_invoicegl_v c_doctypetarget_id numeric 10  √  null Target document type for conversing documents
c_bp_group c_dunning_id numeric 10  √  null Dunning Rules for overdue invoices
c_bpartner c_dunning_id numeric 10  √  null Dunning Rules for overdue invoices
c_invoice c_dunninglevel_id numeric 10  √  null Dunning Level
t_invoicegl_v c_dunninglevel_id numeric 10  √  null Dunning Level
t_rv_reconciliation c_element_id numeric 10  √  null
t_rv_reconciliation c_elementvalue_ad_org_id numeric 10  √  null
t_rv_reconciliation c_elementvalue_c_currency_id numeric 10  √  null
t_cashflow c_elementvalue_id numeric 10  √  NULL::numeric Account Element
t_rv_reconciliation c_elementvalue_id numeric 10  √  null
c_bpartner c_greeting_id numeric 10  √  null Greeting to print on correspondence
t_invoicegl_v c_invoice_c_charge_id numeric 10  √  null c_invoice_c_charge_id
c_invoice c_invoice_id numeric 10 Invoice Identifier
c_invoicepayschedule c_invoice_id numeric 10 Invoice Identifier
t_aging c_invoice_id numeric 10 Invoice Identifier
t_cashflow c_invoice_id numeric 10  √  NULL::numeric Invoice Identifier
t_invoicegl c_invoice_id numeric 10 Invoice Identifier
t_invoicegl_v c_invoice_id numeric 10  √  null Invoice Identifier
c_invoicepayschedule c_invoicepayschedule_id numeric 10 Invoice Payment Schedule
t_aging c_invoicepayschedule_id numeric 10 Invoice Payment Schedule
c_bpartner c_invoiceschedule_id numeric 10  √  null Schedule for generating Invoices
c_invoiceschedule c_invoiceschedule_id numeric 10 Schedule for generating Invoices
t_1099extract c_location_id numeric 10  √  NULL::numeric Location or Address
fact_acct c_locfrom_id numeric 10  √  null Location that inventory was moved from
t_invoicegl_v c_locfrom_id numeric 10  √  null Location that inventory was moved from
t_rv_reconciliation c_locfrom_id numeric 10  √  null Location that inventory was moved from
fact_acct c_locto_id numeric 10  √  null Location that inventory was moved to
t_invoicegl_v c_locto_id numeric 10  √  null Location that inventory was moved to
t_rv_reconciliation c_locto_id numeric 10  √  null Location that inventory was moved to
c_invoice c_order_id numeric 10  √  null Order
t_cashflow c_order_id numeric 10  √  NULL::numeric Order
t_invoicegl_v c_order_id numeric 10  √  null Order
c_invoice c_payment_id numeric 10  √  null Payment identifier
t_invoicegl_v c_payment_id numeric 10  √  null Payment identifier
c_bpartner c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_invoice c_paymentterm_id numeric 10 The terms of Payment (timing, discount)
c_payschedule c_paymentterm_id numeric 10 The terms of Payment (timing, discount)
c_project c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
t_invoicegl_v c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_invoicepayschedule c_payschedule_id numeric 10  √  null Payment Schedule Template
c_payschedule c_payschedule_id numeric 10 Payment Schedule Template
fact_acct c_period_id numeric 10  √  null Period of the Calendar
t_invoicegl_v c_period_id numeric 10  √  null Period of the Calendar
t_rv_reconciliation c_period_id numeric 10  √  null Period of the Calendar
c_project c_phase_id numeric 10  √  null Standard Phase of the Project Type
c_invoice c_project_id numeric 10  √  null Financial Project
c_project c_project_id numeric 10 Financial Project
fact_acct c_project_id numeric 10  √  null Financial Project
t_aging c_project_id numeric 10  √  null Financial Project
t_cashflow c_project_id numeric 10  √  NULL::numeric Financial Project
t_invoicegl_v c_project_id numeric 10  √  null Financial Project
t_rv_reconciliation c_project_id numeric 10  √  null Financial Project
t_transaction c_project_id numeric 10  √  null Financial Project
m_transaction c_projectissue_id numeric 10  √  null Project Issues (Material, Labor)
t_transaction c_projectissue_id numeric 10  √  null Project Issues (Material, Labor)
fact_acct c_projectphase_id numeric 10  √  null Phase of a Project
t_rv_reconciliation c_projectphase_id numeric 10  √  null
fact_acct c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
t_rv_reconciliation c_projecttask_id numeric 10  √  null
c_project c_projecttype_id numeric 10  √  null Type of the project
t_rv_reconciliation c_revenuerecognition_id numeric 10  √  null
fact_acct c_salesregion_id numeric 10  √  null Sales coverage region
t_invoicegl_v c_salesregion_id numeric 10  √  null Sales coverage region
t_rv_reconciliation c_salesregion_id numeric 10  √  null Sales coverage region
fact_acct c_subacct_id numeric 10  √  null Sub account for Element Value
t_invoicegl_v c_subacct_id numeric 10  √  null Sub account for Element Value
t_rv_reconciliation c_subacct_id numeric 10  √  null
t_rv_reconciliation c_subscriptiontype_id numeric 10  √  null
fact_acct c_tax_id numeric 10  √  null Tax identifier
t_invoicegl_v c_tax_id numeric 10  √  null Tax identifier
t_rv_reconciliation c_tax_id numeric 10  √  null Tax identifier
t_rv_reconciliation c_taxcategory_id numeric 10  √  null
c_bpartner c_taxgroup_id numeric 10  √  null Tax Group
fact_acct c_uom_id numeric 10  √  null Unit of Measure
t_bomline_costs c_uom_id numeric 10  √  null Unit of Measure
t_invoicegl_v c_uom_id numeric 10  √  null Unit of Measure
t_rv_reconciliation c_uom_id numeric 10  √  null Unit of Measure
t_aging convertamountsincurrency_id numeric 10  √  null Convert Amounts in Currency
c_currency costingprecision numeric 10 Rounding used costing calculations
ad_find createdby numeric 10 User who created this records
ad_pinstance createdby numeric 10  √  null User who created this records
ad_pinstance_para createdby numeric 10  √  null User who created this records
c_activity createdby numeric 10 User who created this records
c_bp_group createdby numeric 10 User who created this records
c_bpartner createdby numeric 10 User who created this records
c_campaign createdby numeric 10 User who created this records
c_conversiontype createdby numeric 10 User who created this records
c_currency createdby numeric 10 User who created this records
c_doctype createdby numeric 10 User who created this records
c_invoice createdby numeric 10 User who created this records
c_invoicepayschedule createdby numeric 10 User who created this records
c_invoiceschedule createdby numeric 10 User who created this records
c_payschedule createdby numeric 10 User who created this records
c_project createdby numeric 10 User who created this records
fact_acct createdby numeric 10 User who created this records
m_transaction createdby numeric 10 User who created this records
t_1099extract createdby numeric 10 User who created this records
t_aging createdby numeric 10 User who created this records
t_bom_indented createdby numeric 10 User who created this records
t_bomline createdby numeric 10 User who created this records
t_bomline_costs createdby numeric 10  √  null User who created this records
t_cashflow createdby numeric 10 User who created this records
t_invoicegl createdby numeric 10 User who created this records
t_invoicegl_v createdby numeric 10  √  null User who created this records
t_mrp_crp createdby numeric 10 User who created this records
t_reconciliation createdby numeric 10 User who created this records
t_rv_reconciliation createdby numeric 10  √  null User who created this records
t_transaction createdby numeric 10 User who created this records
t_1099extract cut_year numeric 10  √  NULL::numeric Cut Year
t_aging daysdue numeric 10  √  0 Number of days due (negative: due in number of days)
c_bpartner default1099box_id numeric 10  √  NULL::numeric Default 1099 Box
c_doctype definitesequence_id numeric 10  √  null Definite Sequence
c_payschedule discountdays numeric 10 Number of days from invoice date to be eligible for discount
c_doctype docnosequence_id numeric 10  √  null Document sequence determines the numbering of documents
c_bpartner documentcopies numeric 10  √  null Number of copies to be printed
c_doctype documentcopies numeric 10 Number of copies to be printed
t_invoicegl_v fact_acct_ad_org_id numeric 10  √  null fact_acct_ad_org_id
t_invoicegl_v fact_acct_ad_orgtrx_id numeric 10  √  null fact_acct_ad_orgtrx_id
t_invoicegl_v fact_acct_ad_table_id numeric 10  √  null fact_acct_ad_table_id
t_invoicegl_v fact_acct_c_activity_id numeric 10  √  null fact_acct_c_activity_id
t_invoicegl_v fact_acct_c_bpartner_id numeric 10  √  null fact_acct_c_bpartner_id
t_invoicegl_v fact_acct_c_campaign_id numeric 10  √  null fact_acct_c_campaign_id
t_invoicegl_v fact_acct_c_currency_id numeric 10  √  null fact_acct_c_currency_id
fact_acct fact_acct_id numeric 10 Accounting Fact
t_invoicegl fact_acct_id numeric 10 Accounting Fact
t_invoicegl_v fact_acct_id numeric 10  √  null Accounting Fact
t_reconciliation fact_acct_id numeric 10 Accounting Fact
t_rv_reconciliation fact_acct_id numeric 10  √  null Accounting Fact
t_invoicegl_v fact_acct_m_product_id numeric 10  √  null fact_acct_m_product_id
t_invoicegl_v fact_acct_updatedby numeric 10  √  null fact_acct_updatedby
t_invoicegl_v fact_acct_user1_id numeric 10  √  null fact_acct_user1_id
t_invoicegl_v fact_acct_user2_id numeric 10  √  null fact_acct_user2_id
fact_acct gl_budget_id numeric 10  √  null General Ledger Budget
t_invoicegl_v gl_budget_id numeric 10  √  null General Ledger Budget
t_rv_reconciliation gl_budget_id numeric 10  √  null General Ledger Budget
c_doctype gl_category_id numeric 10 General Ledger Category
fact_acct gl_category_id numeric 10  √  null General Ledger Category
t_invoicegl_v gl_category_id numeric 10  √  null General Ledger Category
t_rv_reconciliation gl_category_id numeric 10  √  null General Ledger Category
c_payschedule gracedays numeric 10 Days after due date to send first dunning letter
t_rv_reconciliation guaranteedays numeric 10  √  null
t_rv_reconciliation guaranteedaysmin numeric 10  √  null
c_bpartner invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
c_invoiceschedule invoiceday numeric 10  √  null Day of Invoice Generation
c_invoiceschedule invoicedaycutoff numeric 10  √  null Last day for including shipments
t_bom_indented levelno numeric 10  √  NULL::numeric Level no
t_bomline levelno numeric 10  √  null Level no
t_bomline_costs levelno numeric 10  √  null Level no
t_bomline_costs line numeric 10  √  null Unique line for this document
fact_acct line_id numeric 10  √  null Transaction line ID (internal)
t_invoicegl_v line_id numeric 10  √  null Transaction line ID (internal)
t_rv_reconciliation line_id numeric 10  √  null Transaction line ID (internal)
ad_pinstance_log log_id numeric 10 Log
c_bpartner logo_id numeric 10  √  NULL::numeric Logo
t_rv_reconciliation lowlevel numeric 10  √  null
m_transaction m_attributesetinstance_id numeric 10 0 Product Attribute Set Instance
t_bomline_costs m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
t_inventoryvalue m_attributesetinstance_id numeric 10 Product Attribute Set Instance
t_transaction m_attributesetinstance_id numeric 10 Product Attribute Set Instance
t_bom_indented m_costelement_id numeric 10  √  NULL::numeric Product Cost Element
t_bomline m_costelement_id numeric 10  √  null Product Cost Element
t_bomline_costs m_costelement_id numeric 10  √  null Product Cost Element
t_inventoryvalue m_costelement_id numeric 10  √  null Product Cost Element
t_bomline m_costtype_id numeric 10  √  NULL::numeric Type of Cost (e.g. Current, Plan, Future)
t_bomline_costs m_costtype_id numeric 10  √  null Type of Cost (e.g. Current, Plan, Future)
c_bp_group m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
c_bpartner m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
t_rv_reconciliation m_freightcategory_id numeric 10  √  null
t_transaction m_inout_id numeric 10  √  null Material Shipment Document
m_transaction m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
t_transaction m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
t_transaction m_inventory_id numeric 10  √  null Parameters for a Physical Inventory
m_transaction m_inventoryline_id numeric 10  √  null Unique line in an Inventory document
t_transaction m_inventoryline_id numeric 10  √  null Unique line in an Inventory document
fact_acct m_locator_id numeric 10  √  null Warehouse Locator
m_transaction m_locator_id numeric 10 Warehouse Locator
t_invoicegl_v m_locator_id numeric 10  √  null Warehouse Locator
t_rv_reconciliation m_locator_id numeric 10  √  null Warehouse Locator
t_transaction m_locator_id numeric 10 Warehouse Locator
t_transaction m_movement_id numeric 10  √  null Movement of Inventory
m_transaction m_movementline_id numeric 10  √  null Inventory Move document Line
t_transaction m_movementline_id numeric 10  √  null Inventory Move document Line
c_bp_group m_pricelist_id numeric 10  √  null Unique identifier of a Price List
c_bpartner m_pricelist_id numeric 10  √  null Unique identifier of a Price List
c_invoice m_pricelist_id numeric 10 Unique identifier of a Price List
t_invoicegl_v m_pricelist_id numeric 10  √  null Unique identifier of a Price List
c_project m_pricelist_version_id numeric 10  √  null Identifies a unique instance of a Price List
t_inventoryvalue m_pricelist_version_id numeric 10  √  null Identifies a unique instance of a Price List
t_rv_reconciliation m_product_ad_org_id numeric 10  √  null
t_rv_reconciliation m_product_c_uom_id numeric 10  √  null
t_rv_reconciliation m_product_category_id numeric 10  √  null Category of a Product
t_rv_reconciliation m_product_createdby numeric 10  √  null
fact_acct m_product_id numeric 10  √  null Product, Service, Item
m_transaction m_product_id numeric 10 Product, Service, Item
t_bom_indented m_product_id numeric 10  √  NULL::numeric Product, Service, Item
t_bomline m_product_id numeric 10  √  null Product, Service, Item
t_bomline_costs m_product_id numeric 10  √  null Product, Service, Item
t_cashflow m_product_id numeric 10  √  NULL::numeric Product, Service, Item
t_inventoryvalue m_product_id numeric 10 Product, Service, Item
t_replenish m_product_id numeric 10 Product, Service, Item
t_rv_reconciliation m_product_id numeric 10  √  null Product, Service, Item
t_transaction m_product_id numeric 10 Product, Service, Item
t_rv_reconciliation m_product_m_asi_id numeric 10  √  null
t_rv_reconciliation m_product_m_attributeset_id numeric 10  √  null
t_rv_reconciliation m_product_m_locator_id numeric 10  √  null
t_rv_reconciliation m_product_salesrep_id numeric 10  √  null
t_rv_reconciliation m_product_updatedby numeric 10  √  null
t_transaction m_production_id numeric 10  √  null Plan for producing a product
m_transaction m_productionline_id numeric 10  √  null Document Line representing a production
t_transaction m_productionline_id numeric 10  √  null Document Line representing a production
c_invoice m_rma_id numeric 10  √  null Return Material Authorization
t_invoicegl_v m_rma_id numeric 10  √  null Return Material Authorization
m_transaction m_transaction_id numeric 10 Inventory Transaction
t_transaction m_transaction_id numeric 10 Inventory Transaction
c_project m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
t_inventoryvalue m_warehouse_id numeric 10 Storage Warehouse and Service Point
t_replenish m_warehouse_id numeric 10 Storage Warehouse and Service Point
t_replenish m_warehousesource_id numeric 10  √  null Optional Warehouse to replenish from
c_payschedule netdays numeric 10 Net Days in which payment is due
c_bpartner numberemployees numeric 10  √  null Number of employees
ad_pinstance_log p_id numeric 10  √  null Process ID
c_bp_group po_discountschema_id numeric 10  √  null Schema to calculate the purchase trade discount percentage
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_bp_group po_pricelist_id numeric 10  √  null Price List used by this Business Partner
c_bpartner po_pricelist_id numeric 10  √  null Price List used by this Business Partner
m_transaction pp_cost_collector_id numeric 10  √  null Manufacturing Cost Collector
t_bomline pp_product_bom_id numeric 10  √  null BOM & Formula
t_bomline_costs pp_product_bom_id numeric 10  √  null BOM & Formula
t_bomline pp_product_bomline_id numeric 10  √  null BOM Line
t_bomline_costs pp_product_bomline_id numeric 10  √  null BOM Line
t_rv_reconciliation r_mailtext_id numeric 10  √  null
ad_pinstance record_id numeric 10 Direct internal record ID
ad_pinstance_log record_id numeric 10  √  NULL::numeric Direct internal record ID
fact_acct record_id numeric 10 Direct internal record ID
t_invoicegl_v record_id numeric 10  √  null Direct internal record ID
t_rv_reconciliation record_id numeric 10  √  null Direct internal record ID
c_invoice ref_invoice_id numeric 10  √  null Referenced Invoice
t_invoicegl_v ref_invoice_id numeric 10  √  null Referenced Invoice
c_invoice relatedinvoice_id numeric 10  √  NULL::numeric Related Invoice
ad_pinstance result numeric 10  √  null Result of the action taken
c_invoice reversal_id numeric 10  √  null ID of document reversal
t_invoicegl_v reversal_id numeric 10  √  null ID of document reversal
t_rv_reconciliation s_expensetype_id numeric 10  √  null
t_rv_reconciliation s_resource_id numeric 10  √  null
c_bpartner salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_invoice salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_project salesrep_id numeric 10  √  null Sales Representative or Company Agent
t_invoicegl_v salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_bpartner salesvolume numeric 10  √  null Total Volume of Sales in Thousands of Currency
t_transaction search_inout_id numeric 10  √  null Material Shipment Document
t_transaction search_invoice_id numeric 10  √  null Search Invoice Identifier
t_transaction search_order_id numeric 10  √  null Order Identifier
t_bom_indented sel_product_id numeric 10  √  NULL::numeric Selected Product
t_bomline sel_product_id numeric 10 Selected Product
ad_pinstance_para seqno numeric 10 Method of ordering records; lowest number comes first
t_bom_indented seqno numeric 10  √  NULL::numeric Method of ordering records; lowest number comes first
t_bomline seqno numeric 10  √  null Method of ordering records; lowest number comes first
t_bomline_costs seqno numeric 10  √  null Method of ordering records; lowest number comes first
t_mrp_crp seqno numeric 10  √  null Method of ordering records; lowest number comes first
t_spool 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
t_rv_reconciliation shelfdepth numeric 10  √  null
c_bpartner shelflifeminpct numeric 10  √  null Minimum Shelf Life in percent based on Product Instance Guarantee Date
t_rv_reconciliation shelfwidth numeric 10  √  null
c_currency stdprecision numeric 10 Rule for rounding calculated amounts
t_bom_indented t_bom_indented_id numeric 10 Indented BOM Report
t_bomline t_bomline_id numeric 10 Temporal BOM Line
t_cashflow t_cashflow_id numeric 10 NULL::numeric T_CashFlow_ID
t_invoicegl_v t_invoicegl_ad_org_id numeric 10  √  null t_invoicegl_ad_org_id
t_invoicegl_v t_invoicegl_c_invoice_id numeric 10  √  null t_invoicegl_c_invoice_id
t_invoicegl_v t_invoicegl_createdby numeric 10  √  null t_invoicegl_createdby
t_invoicegl_v t_invoicegl_updatedby numeric 10  √  null t_invoicegl_updatedby
t_mrp_crp t_mrp_crp_id numeric 10 Temporal MRP & CRP
t_selection t_selection_id numeric 10 0
t_selection2 t_selection_id numeric 10
t_bomline_costs tm_product_id numeric 10  √  null Product
t_rv_reconciliation unitsperpack numeric 10  √  null
ad_find updatedby numeric 10 User who updated this records
ad_pinstance updatedby numeric 10 User who updated this records
ad_pinstance_para updatedby numeric 10  √  null User who updated this records
c_activity updatedby numeric 10 User who updated this records
c_bp_group updatedby numeric 10 User who updated this records
c_bpartner updatedby numeric 10 User who updated this records
c_campaign updatedby numeric 10 User who updated this records
c_conversiontype updatedby numeric 10 User who updated this records
c_currency updatedby numeric 10 User who updated this records
c_doctype updatedby numeric 10 User who updated this records
c_invoice updatedby numeric 10 User who updated this records
c_invoicepayschedule updatedby numeric 10 User who updated this records
c_invoiceschedule updatedby numeric 10 User who updated this records
c_payschedule updatedby numeric 10 User who updated this records
c_project updatedby numeric 10 User who updated this records
fact_acct updatedby numeric 10 User who updated this records
m_transaction updatedby numeric 10 User who updated this records
t_1099extract updatedby numeric 10 User who updated this records
t_aging updatedby numeric 10 User who updated this records
t_bom_indented updatedby numeric 10 User who updated this records
t_bomline updatedby numeric 10 User who updated this records
t_bomline_costs updatedby numeric 10  √  null User who updated this records
t_cashflow updatedby numeric 10 User who updated this records
t_invoicegl updatedby numeric 10 User who updated this records
t_invoicegl_v updatedby numeric 10  √  null User who updated this records
t_mrp_crp updatedby numeric 10 User who updated this records
t_reconciliation updatedby numeric 10 User who updated this records
t_replenish updatedby numeric 10  √  null User who updated this records
t_rv_reconciliation updatedby numeric 10  √  null User who updated this records
t_transaction updatedby numeric 10 User who updated this records
c_invoice user1_id numeric 10  √  null User defined list element #1
fact_acct user1_id numeric 10  √  null User defined list element #1
t_invoicegl_v user1_id numeric 10  √  null User defined list element #1
t_rv_reconciliation user1_id numeric 10  √  null User defined list element #1
c_invoice user2_id numeric 10  √  null User defined list element #2
fact_acct user2_id numeric 10  √  null User defined list element #2
t_invoicegl_v user2_id numeric 10  √  null User defined list element #2
t_rv_reconciliation user2_id numeric 10  √  null User defined list element #2
fact_acct userelement1_id numeric 10  √  null User defined accounting Element
t_invoicegl_v userelement1_id numeric 10  √  null User defined accounting Element
t_rv_reconciliation userelement1_id numeric 10  √  null
fact_acct userelement2_id numeric 10  √  null User defined accounting Element
t_invoicegl_v userelement2_id numeric 10  √  null User defined accounting Element
t_rv_reconciliation userelement2_id numeric 10  √  null
t_rv_reconciliation c_bp_created timestamp 29,6  √  null
t_rv_reconciliation c_bp_dunninggrace timestamp 29,6  √  null
t_rv_reconciliation c_bp_firstsale timestamp 29,6  √  null
t_rv_reconciliation c_bp_updated timestamp 29,6  √  null
ad_find created timestamp 29,6 now() Date this record was created
ad_pinstance created timestamp 29,6 now() Date this record was created
ad_pinstance_para created timestamp 29,6 statement_timestamp() Date this record was created
c_activity created timestamp 29,6 now() Date this record was created
c_bp_group created timestamp 29,6 now() Date this record was created
c_bpartner created timestamp 29,6 now() Date this record was created
c_campaign created timestamp 29,6 now() Date this record was created
c_conversiontype created timestamp 29,6 now() Date this record was created
c_currency created timestamp 29,6 now() Date this record was created
c_doctype created timestamp 29,6 now() Date this record was created
c_invoice created timestamp 29,6 now() Date this record was created
c_invoicepayschedule created timestamp 29,6 now() Date this record was created
c_invoiceschedule created timestamp 29,6 now() Date this record was created
c_payschedule created timestamp 29,6 now() Date this record was created
c_project created timestamp 29,6 now() Date this record was created
fact_acct created timestamp 29,6 now() Date this record was created
m_transaction created timestamp 29,6 now() Date this record was created
t_1099extract created timestamp 29,6 statement_timestamp() Date this record was created
t_aging created timestamp 29,6 now() Date this record was created
t_bom_indented created timestamp 29,6 statement_timestamp() Date this record was created
t_bomline created timestamp 29,6 statement_timestamp() Date this record was created
t_bomline_costs created timestamp 29,6  √  null Date this record was created
t_cashflow created timestamp 29,6 statement_timestamp() Date this record was created
t_invoicegl created timestamp 29,6 now() Date this record was created
t_invoicegl_v created timestamp 29,6  √  null Date this record was created
t_mrp_crp created timestamp 29,6 statement_timestamp() Date this record was created
t_reconciliation created timestamp 29,6 statement_timestamp() Date this record was created
t_rv_reconciliation created timestamp 29,6  √  null Date this record was created
t_transaction created timestamp 29,6 now() Date this record was created
t_1099extract cut_date timestamp 29,6  √  null Cut Date
c_invoice dateacct timestamp 29,6 Accounting Date
fact_acct dateacct timestamp 29,6 Accounting Date
t_bankregister dateacct timestamp 29,6  √  null Accounting Date
t_invoicegl_v dateacct timestamp 29,6  √  null Accounting Date
t_rv_reconciliation dateacct timestamp 29,6  √  null Accounting Date
c_project datecontract timestamp 29,6  √  null The (planned) effective date of this document.
c_project datefinish timestamp 29,6  √  null Finish or (planned) completion date
c_invoice dateinvoiced timestamp 29,6 Date printed on Invoice
t_invoicegl_v dateinvoiced timestamp 29,6  √  null Date printed on Invoice
c_invoice dateordered timestamp 29,6  √  null Date of Order
t_invoicegl_v dateordered timestamp 29,6  √  null Date of Order
c_invoice dateprinted timestamp 29,6  √  null Date the document was printed.
t_invoicegl_v dateprinted timestamp 29,6  √  null Date the document was printed.
t_invoicegl datereval timestamp 29,6 Date of Revaluation
t_invoicegl_v datereval timestamp 29,6  √  null Date of Revaluation
t_cashflow dateto timestamp 29,6  √  null End date of a date range
fact_acct datetrx timestamp 29,6 Transaction Date
t_cashflow datetrx timestamp 29,6 Transaction Date
t_invoicegl_v datetrx timestamp 29,6  √  null Transaction Date
t_rv_reconciliation datetrx timestamp 29,6  √  null Transaction Date
t_inventoryvalue datevalue timestamp 29,6  √  null Date of valuation
t_rv_reconciliation discontinuedat timestamp 29,6  √  null
c_invoicepayschedule discountdate timestamp 29,6 Last Date for payments with discount
c_invoicepayschedule duedate timestamp 29,6 Date when the payment is due
t_aging duedate timestamp 29,6 Date when the payment is due
c_bpartner dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_invoice dunninggrace timestamp 29,6  √  null Dunning Grace Date
t_invoicegl_v dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_currency emuentrydate timestamp 29,6  √  null Date when the currency joined / will join the EMU
c_campaign enddate timestamp 29,6  √  null Last effective date (inclusive)
t_invoicegl_v fact_acct_dateacct timestamp 29,6  √  null fact_acct_dateacct
t_invoicegl_v fact_acct_updated timestamp 29,6  √  null fact_acct_updated
c_bpartner firstsale timestamp 29,6  √  null Date of First Sale
t_rv_reconciliation m_product_created timestamp 29,6  √  null
t_rv_reconciliation m_product_updated timestamp 29,6  √  null
m_transaction movementdate timestamp 29,6 Date a product was moved in or out of inventory
t_transaction movementdate timestamp 29,6 Date a product was moved in or out of inventory
ad_pinstance_log p_date timestamp 29,6  √  now() Process Parameter
ad_pinstance_para p_date timestamp 29,6  √  null Process Parameter
ad_pinstance_para p_date_to timestamp 29,6  √  null Process Parameter
c_campaign startdate timestamp 29,6  √  null First effective day (inclusive)
t_aging statementdate timestamp 29,6 Date of the statement
t_invoicegl_v t_invoicegl_created timestamp 29,6  √  null t_invoicegl_created
t_invoicegl_v t_invoicegl_updated timestamp 29,6  √  null t_invoicegl_updated
ad_find updated timestamp 29,6 now() Date this record was updated
ad_pinstance updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_pinstance_para updated timestamp 29,6 statement_timestamp() Date this record was updated
c_activity updated timestamp 29,6 now() Date this record was updated
c_bp_group updated timestamp 29,6 now() Date this record was updated
c_bpartner updated timestamp 29,6 now() Date this record was updated
c_campaign updated timestamp 29,6 now() Date this record was updated
c_conversiontype updated timestamp 29,6 now() Date this record was updated
c_currency updated timestamp 29,6 now() Date this record was updated
c_doctype updated timestamp 29,6 now() Date this record was updated
c_invoice updated timestamp 29,6 now() Date this record was updated
c_invoicepayschedule updated timestamp 29,6 now() Date this record was updated
c_invoiceschedule updated timestamp 29,6 now() Date this record was updated
c_payschedule updated timestamp 29,6 now() Date this record was updated
c_project updated timestamp 29,6 now() Date this record was updated
fact_acct updated timestamp 29,6 now() Date this record was updated
m_transaction updated timestamp 29,6 now() Date this record was updated
t_1099extract updated timestamp 29,6 statement_timestamp() Date this record was updated
t_aging updated timestamp 29,6 now() Date this record was updated
t_bom_indented updated timestamp 29,6 statement_timestamp() Date this record was updated
t_bomline updated timestamp 29,6 statement_timestamp() Date this record was updated
t_bomline_costs updated timestamp 29,6  √  null Date this record was updated
t_cashflow updated timestamp 29,6 statement_timestamp() Date this record was updated
t_invoicegl updated timestamp 29,6 now() Date this record was updated
t_invoicegl_v updated timestamp 29,6  √  null Date this record was updated
t_mrp_crp updated timestamp 29,6 statement_timestamp() Date this record was updated
t_reconciliation updated timestamp 29,6 statement_timestamp() Date this record was updated
t_replenish updated timestamp 29,6 statement_timestamp() Date this record was updated
t_rv_reconciliation updated timestamp 29,6  √  null Date this record was updated
t_transaction updated timestamp 29,6 now() Date this record was updated
t_bomline_costs validfrom timestamp 29,6  √  null Valid from including this date (first day)
t_bomline_costs validto timestamp 29,6  √  null Valid to including this date (last day)
c_doctype docsubtypeinv varchar 2  √  NULL::character varying Inventory Sub Type
ad_pinstance notificationtype varchar 2  √  NULL::character varying Type of Notifications
ad_pinstance_log pinstancelogtype varchar 3  √  'R'::character varying Process Audit Log Type
ad_pinstance reporttype varchar 5  √  NULL::character varying Report Type
c_bpartner ad_language varchar 6  √  null Language for this entity
t_rv_reconciliation c_bp_ad_language varchar 6  √  null
c_bpartner naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
t_rv_reconciliation naics varchar 6  √  null
c_currency cursymbol varchar 10  √  null Symbol of the currency (opt used for printing only)
c_bpartner duns varchar 11  √  null Dun & Bradstreet Number
t_rv_reconciliation duns varchar 11  √  null
t_rv_reconciliation classification varchar 12  √  null
t_rv_reconciliation c_bp_poreference varchar 20  √  null
c_bpartner poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_invoice poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_project poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
t_invoicegl_v poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_bpartner taxid varchar 20  √  null Tax Identification
t_1099extract taxid varchar 20  √  NULL::character varying Tax Identification
t_rv_reconciliation taxid varchar 20  √  null
t_rv_reconciliation versionno varchar 20  √  null
t_bomline cost varchar 22  √  null Cost information
c_invoice documentno varchar 30 Document sequence number of the document
t_invoicegl_v documentno varchar 30  √  null Document sequence number of the document
t_rv_reconciliation sku varchar 30  √  null
t_rv_reconciliation upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
ad_find ad_find_uu varchar 36  √  NULL::character varying AD_Find_UU
ad_pinstance_log ad_pinstance_log_uu varchar 36  √  null AD_PInstance_Log_UU
ad_pinstance_para ad_pinstance_para_uu varchar 36  √  NULL::character varying AD_PInstance_Para_UU
ad_pinstance ad_pinstance_uu varchar 36  √  NULL::character varying AD_PInstance_UU
c_activity c_activity_uu varchar 36  √  NULL::character varying C_Activity_UU
c_bp_group c_bp_group_uu varchar 36  √  NULL::character varying C_BP_Group_UU
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying C_BPartner_UU
c_campaign c_campaign_uu varchar 36  √  NULL::character varying C_Campaign_UU
c_conversiontype c_conversiontype_uu varchar 36  √  NULL::character varying C_ConversionType_UU
c_currency c_currency_uu varchar 36  √  NULL::character varying C_Currency_UU
c_doctype c_doctype_uu varchar 36  √  NULL::character varying C_DocType_UU
c_invoice c_invoice_uu varchar 36  √  NULL::character varying C_Invoice_UU
c_invoicepayschedule c_invoicepayschedule_uu varchar 36  √  NULL::character varying C_InvoicePaySchedule_UU
c_invoiceschedule c_invoiceschedule_uu varchar 36  √  NULL::character varying C_InvoiceSchedule_UU
c_payschedule c_payschedule_uu varchar 36  √  NULL::character varying C_PaySchedule_UU
c_project c_project_uu varchar 36  √  NULL::character varying C_Project_UU
fact_acct fact_acct_uu varchar 36  √  NULL::character varying Fact_Acct_UU
m_transaction m_transaction_uu varchar 36  √  NULL::character varying M_Transaction_UU
ad_pinstance record_uu varchar 36  √  NULL::character varying Record UUID
t_1099extract t_1099extract_uu varchar 36  √  NULL::character varying T_1099Extract_UU
t_aging t_aging_uu varchar 36  √  NULL::character varying T_Aging_UU
t_bankregister t_bankregister_uu varchar 36  √  NULL::character varying T_BankRegister_UU
t_bom_indented t_bom_indented_uu varchar 36  √  NULL::character varying T_BOM_Indented_UU
t_bomline t_bomline_uu varchar 36  √  NULL::character varying T_BOMLine_UU
t_cashflow t_cashflow_uu varchar 36  √  NULL::character varying T_CashFlow_UU
t_inventoryvalue t_inventoryvalue_uu varchar 36  √  NULL::character varying T_InventoryValue_UU
t_invoicegl t_invoicegl_uu varchar 36  √  NULL::character varying T_InvoiceGL_UU
t_mrp_crp t_mrp_crp_uu varchar 36  √  NULL::character varying T_MRP_CRP_UU
t_reconciliation t_reconciliation_uu varchar 36  √  NULL::character varying T_Reconciliation_UU
t_replenish t_replenish_uu varchar 36  √  NULL::character varying T_Replenish_UU
t_selection t_selection_uu varchar 36 ' '::character varying
t_transaction t_transaction_uu varchar 36  √  NULL::character varying T_Transaction_UU
t_rv_reconciliation accountvalue varchar 40  √  null Key of Account Element
t_rv_reconciliation bpartnervalue varchar 40  √  null Key of the Business Partner
t_rv_reconciliation orgvalue varchar 40  √  null Key of the Organization
c_bpartner referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
t_rv_reconciliation referenceno varchar 40  √  null
ad_find 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_bp_group value varchar 40 Search key for the record in the format required - must be unique
c_bpartner value varchar 40 Search key for the record in the format required - must be unique
c_campaign value varchar 40 Search key for the record in the format required - must be unique
c_conversiontype 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
t_1099extract value varchar 40 Search key for the record in the format required - must be unique
ad_find value2 varchar 40  √  null Value To
t_mrp_crp description varchar 50  √  null Optional short description of the record
t_rv_reconciliation c_bp_name2 varchar 60  √  null
c_bpartner customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
t_reconciliation matchcode varchar 60  √  NULL::character varying String identifying related accounting facts
t_rv_reconciliation matchcode varchar 60  √  null String identifying related accounting facts
ad_pinstance name varchar 60  √  NULL::character varying Alphanumeric identifier of the entity
c_activity name varchar 60 Alphanumeric identifier of the entity
c_bp_group name varchar 60 Alphanumeric identifier of the entity
c_campaign name varchar 60 Alphanumeric identifier of the entity
c_conversiontype name varchar 60 Alphanumeric identifier of the entity
c_doctype name varchar 60 Alphanumeric identifier of the entity
c_invoiceschedule name varchar 60 Alphanumeric identifier of the entity
c_project name varchar 60 Alphanumeric identifier of the entity
t_cashflow name varchar 60  √  NULL::character varying Alphanumeric identifier of the entity
c_bpartner name2 varchar 60  √  null Additional Name
t_rv_reconciliation orgname varchar 60  √  null Name of the Organization
ad_pinstance_para parametername varchar 60  √  null Parameter Name
c_doctype printname varchar 60 The label text to be printed on a document or correspondence.
t_rv_reconciliation bpname varchar 120  √  null BP Name
t_rv_reconciliation c_bp_url varchar 120  √  null
t_rv_reconciliation descriptionurl varchar 120  √  null
t_rv_reconciliation imageurl varchar 120  √  null
c_bpartner name varchar 120 Alphanumeric identifier of the entity
t_1099extract name varchar 120 Alphanumeric identifier of the entity
t_rv_reconciliation name varchar 120  √  null Alphanumeric identifier of the entity
c_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
t_bom_indented levels varchar 250  √  NULL::character varying Levels
t_bomline levels varchar 250  √  null Levels
t_bomline_costs levels varchar 250  √  null Levels
t_bankregister account varchar 255  √  NULL::character varying Account
t_rv_reconciliation ad_org_description varchar 255  √  null
t_bankregister bankname varchar 255  √  NULL::character varying Bank Name
t_bankregister bpartner varchar 255  √  NULL::character varying Business Partner
t_rv_reconciliation c_bp_description varchar 255  √  null
t_rv_reconciliation c_bp_so_description varchar 255  √  null
t_rv_reconciliation c_elementvalue_description varchar 255  √  null
c_activity description varchar 255  √  null Optional short description of the record
c_bp_group description varchar 255  √  null Optional short description of the record
c_bpartner description varchar 255  √  null Optional short description of the record
c_campaign description varchar 255  √  null Optional short description of the record
c_conversiontype description varchar 255  √  null Optional short description of the record
c_currency description varchar 255 Optional short description of the record
c_doctype description varchar 255  √  null Optional short description of the record
c_invoice description varchar 255  √  null Optional short description of the record
c_invoiceschedule description varchar 255  √  null Optional short description of the record
c_project description varchar 255  √  null Optional short description of the record
fact_acct description varchar 255  √  null Optional short description of the record
t_bomline_costs description varchar 255  √  null Optional short description of the record
t_cashflow description varchar 255  √  NULL::character varying Optional short description of the record
t_invoicegl_v description varchar 255  √  null Optional short description of the record
t_rv_reconciliation description varchar 255  √  null Optional short description of the record
t_bankregister documentno varchar 255  √  NULL::character varying Document sequence number of the document
t_invoicegl_v fact_acct_description varchar 255  √  null fact_acct_description
t_rv_reconciliation group1 varchar 255  √  null
t_rv_reconciliation group2 varchar 255  √  null
t_rv_reconciliation m_product_description varchar 255  √  null
t_rv_reconciliation productname varchar 255  √  null Name of the Product
c_bpartner so_description varchar 255  √  null Description to be used on orders
t_rv_reconciliation productvalue varchar 510  √  null Key of the Product
c_doctype documentnote varchar 2000  √  null Additional information for a Document
t_rv_reconciliation documentnote varchar 2000  √  null
ad_pinstance errormsg varchar 2000  √  null Error Msg
c_activity help varchar 2000  √  null Comment or Hint
t_rv_reconciliation help varchar 2000  √  null
t_spool msgtext varchar 2000 Textual Informational, Menu or Error Message
c_project note varchar 2000  √  null Optional additional user defined information
t_selection viewid varchar 2000  √  null
ad_pinstance_para info varchar 4000  √  null Information
ad_pinstance_para info_to varchar 4000  √  null Info To
ad_pinstance_log p_msg varchar 4000  √  null Process Message
ad_pinstance_para p_string varchar 4000  √  null Process Parameter
ad_pinstance_para p_string_to varchar 4000  √  null Process Parameter