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

idempiere9.adempiere contains 971 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_payment a_city varchar 60  √  null City or the Credit Card or Account Holder
c_payment a_country varchar 40  √  null Country
c_invoiceline a_createasset bpchar 1  √  'N'::bpchar Create Asset
c_payment a_email varchar 60  √  null Email Address
c_payment a_ident_dl varchar 20  √  null Payment Identification - Driver License
c_payment a_ident_ssn varchar 20  √  null Payment Identification - Social Security No
c_payment a_name varchar 60  √  null Name on Credit Card or Account holder
c_invoiceline a_processed bpchar 1  √  'N'::bpchar Processed
c_payment a_state varchar 40  √  null State of the Credit Card or Account holder
c_payment a_street varchar 60  √  null Street address of the Credit Card or Account holder
c_payment a_zip varchar 20  √  null Zip Code of the Credit Card or Account Holder
c_payment accountno varchar 20  √  null Account Number
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
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_bpartner ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner_location ad_client_id numeric 10 Client/Tenant for this installation.
c_campaign ad_client_id numeric 10 Client/Tenant for this installation.
c_charge ad_client_id numeric 10 Client/Tenant for this installation.
c_chargetype ad_client_id numeric 10 NULL::numeric Client/Tenant for this installation.
c_chargetype_doctype ad_client_id numeric 10 NULL::numeric Client/Tenant for this installation.
c_invoice ad_client_id numeric 10 Client/Tenant for this installation.
c_invoicebatch ad_client_id numeric 10 Client/Tenant for this installation.
c_invoicebatchline ad_client_id numeric 10 Client/Tenant for this installation.
c_invoiceline ad_client_id numeric 10 Client/Tenant for this installation.
c_invoicepayschedule ad_client_id numeric 10 Client/Tenant for this installation.
c_invoiceschedule ad_client_id numeric 10 Client/Tenant for this installation.
c_invoicetax ad_client_id numeric 10 Client/Tenant for this installation.
c_landedcost ad_client_id numeric 10 Client/Tenant for this installation.
c_landedcostallocation ad_client_id numeric 10 Client/Tenant for this installation.
c_payment ad_client_id numeric 10 Client/Tenant for this installation.
c_paymentterm ad_client_id numeric 10 Client/Tenant for this installation.
c_payschedule ad_client_id numeric 10 Client/Tenant for this installation.
c_project ad_client_id numeric 10 Client/Tenant for this installation.
c_revenuerecog_service ad_client_id numeric 10 Client/Tenant for this installation.
c_revenuerecognition ad_client_id numeric 10 Client/Tenant for this installation.
c_revenuerecognition_plan ad_client_id numeric 10 Client/Tenant for this installation.
c_revenuerecognition_run ad_client_id numeric 10 Client/Tenant for this installation.
c_servicelevel ad_client_id numeric 10 Client/Tenant for this installation.
c_servicelevelline ad_client_id numeric 10 Client/Tenant for this installation.
c_tax ad_client_id numeric 10 Client/Tenant for this installation.
m_inout ad_client_id numeric 10 Client/Tenant for this installation.
m_inoutline ad_client_id numeric 10 Client/Tenant for this installation.
m_pricelist ad_client_id numeric 10 Client/Tenant for this installation.
m_product ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner ad_language varchar 6  √  null Language for this entity
ad_org ad_org_id numeric 10 Organizational entity within client
c_activity ad_org_id numeric 10 Organizational entity within client
c_bpartner ad_org_id numeric 10 Organizational entity within client
c_bpartner_location ad_org_id numeric 10 Organizational entity within client
c_campaign ad_org_id numeric 10 Organizational entity within client
c_charge ad_org_id numeric 10 Organizational entity within client
c_chargetype ad_org_id numeric 10 NULL::numeric Organizational entity within client
c_chargetype_doctype ad_org_id numeric 10 NULL::numeric Organizational entity within client
c_invoice ad_org_id numeric 10 Organizational entity within client
c_invoicebatch ad_org_id numeric 10 Organizational entity within client
c_invoicebatchline ad_org_id numeric 10 Organizational entity within client
c_invoiceline ad_org_id numeric 10 Organizational entity within client
c_invoicepayschedule ad_org_id numeric 10 Organizational entity within client
c_invoiceschedule ad_org_id numeric 10 Organizational entity within client
c_invoicetax ad_org_id numeric 10 Organizational entity within client
c_landedcost ad_org_id numeric 10 Organizational entity within client
c_landedcostallocation ad_org_id numeric 10 Organizational entity within client
c_payment ad_org_id numeric 10 Organizational entity within client
c_paymentterm ad_org_id numeric 10 Organizational entity within client
c_payschedule ad_org_id numeric 10 Organizational entity within client
c_project ad_org_id numeric 10 Organizational entity within client
c_revenuerecog_service ad_org_id numeric 10 Organizational entity within client
c_revenuerecognition ad_org_id numeric 10 Organizational entity within client
c_revenuerecognition_plan ad_org_id numeric 10 Organizational entity within client
c_revenuerecognition_run ad_org_id numeric 10 Organizational entity within client
c_servicelevel ad_org_id numeric 10 Organizational entity within client
c_servicelevelline ad_org_id numeric 10 Organizational entity within client
c_tax ad_org_id numeric 10 Organizational entity within client
m_inout ad_org_id numeric 10 Organizational entity within client
m_inoutline ad_org_id numeric 10 Organizational entity within client
m_pricelist ad_org_id numeric 10 Organizational entity within client
m_product ad_org_id numeric 10 Organizational entity within client
ad_org ad_org_uu varchar 36  √  NULL::character varying AD_Org_UU
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_invoicebatchline ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_invoiceline ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_payment ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_project ad_orgtrx_id numeric 10  √  NULL::numeric Performing or initiating organization
m_inout ad_orgtrx_id numeric 10  √  null Performing or initiating organization
m_inoutline ad_orgtrx_id numeric 10  √  null Performing or initiating organization
ad_org ad_replicationstrategy_id numeric 0  √  null Data Replication Strategy
c_tax ad_rule_id numeric 10  √  null Rule
c_invoice ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_invoicebatchline ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_project ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
m_inout ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_paymentterm afterdelivery bpchar 1 'N'::bpchar Due after delivery rather than after invoicing
c_invoiceschedule amt numeric 0  √  0 Amount
c_landedcostallocation amt numeric 0 0 Amount
c_landedcostallocation base numeric 0 0 Calculation Base
m_pricelist basepricelist_id numeric 10  √  null Pricelist to be used, if product not found on this pricelist
c_bpartner bpartner_parent_id numeric 10  √  null Business Partner Parent
c_invoiceline c_1099box_id numeric 10  √  NULL::numeric 1099 Box
c_revenuerecognition_plan c_acctschema_id numeric 10 Rules for accounting
c_activity c_activity_id numeric 10 Business Activity
c_invoice c_activity_id numeric 10  √  null Business Activity
c_invoicebatchline c_activity_id numeric 10  √  null Business Activity
c_invoiceline c_activity_id numeric 10  √  null Business Activity
c_payment c_activity_id numeric 10  √  null Business Activity
c_project c_activity_id numeric 10  √  NULL::numeric Business Activity
m_inout c_activity_id numeric 10  √  null Business Activity
m_inoutline c_activity_id numeric 10  √  null Business Activity
c_activity c_activity_uu varchar 36  √  NULL::character varying C_Activity_UU
c_payment c_bankaccount_id numeric 10  √  null Account at the Bank
c_payment c_bp_bankaccount_id numeric 10  √  null Bank Account of the Business Partner
c_bpartner c_bp_group_id numeric 10 Business Partner Group
c_bpartner c_bpartner_id numeric 10 Identifies a Business Partner
c_bpartner_location c_bpartner_id numeric 10 Identifies a Business Partner
c_charge c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_invoice c_bpartner_id numeric 10 Identifies a Business Partner
c_invoicebatchline c_bpartner_id numeric 10 Identifies a Business Partner
c_payment c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_project c_bpartner_id numeric 10  √  null Identifies a Business Partner
m_inout c_bpartner_id numeric 10 Identifies a Business Partner
c_bpartner_location c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
c_invoice c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
c_invoicebatchline 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
m_inout c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
c_bpartner_location c_bpartner_location_uu varchar 36  √  NULL::character varying C_BPartner_Location_UU
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying C_BPartner_UU
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_invoiceline c_campaign_id numeric 10  √  null Marketing Campaign
c_payment c_campaign_id numeric 10  √  null Marketing Campaign
c_project c_campaign_id numeric 10  √  null Marketing Campaign
m_inout c_campaign_id numeric 10  √  null Marketing Campaign
m_inoutline c_campaign_id numeric 10  √  null Marketing Campaign
c_campaign c_campaign_uu varchar 36  √  NULL::character varying C_Campaign_UU
c_payment c_cashbook_id numeric 10  √  null Cash Book for recording petty cash transactions
c_invoice c_cashline_id numeric 10  √  null Cash Journal Line
c_invoice c_cashplanline_id numeric 10  √  NULL::numeric Cash Plan Line
c_campaign c_channel_id numeric 10  √  null Sales Channel
c_charge c_charge_id numeric 10 Additional document charges
c_invoice c_charge_id numeric 10  √  null Additional document charges
c_invoicebatchline c_charge_id numeric 10 Additional document charges
c_invoiceline c_charge_id numeric 10  √  null Additional document charges
c_payment c_charge_id numeric 10  √  null Additional document charges
m_inout c_charge_id numeric 10  √  null Additional document charges
m_inoutline c_charge_id numeric 10  √  null Additional document charges
c_charge c_charge_uu varchar 36  √  NULL::character varying C_Charge_UU
c_chargetype_doctype c_chargetype_doctype_uu varchar 36  √  NULL::character varying C_ChargeType_DocType_UU
c_charge c_chargetype_id numeric 10  √  null Charge Type
c_chargetype c_chargetype_id numeric 10 Charge Type
c_chargetype_doctype c_chargetype_id numeric 10 Charge Type
c_chargetype c_chargetype_uu varchar 36  √  NULL::character varying C_ChargeType_UU
c_invoice c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
c_invoicebatch c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
c_payment c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
c_tax c_country_id numeric 10  √  null Country
c_tax c_countrygroupfrom_id numeric 10  √  NULL::numeric Country Group From
c_tax c_countrygroupto_id numeric 10  √  NULL::numeric Country Group To
c_invoice c_currency_id numeric 10 The Currency for this record
c_invoicebatch c_currency_id numeric 10 The Currency for this record
c_payment c_currency_id numeric 10 The Currency for this record
c_project c_currency_id numeric 10 The Currency for this record
c_revenuerecognition_plan c_currency_id numeric 10 The Currency for this record
m_pricelist c_currency_id numeric 10 The Currency for this record
c_payment c_depositbatch_id numeric 10  √  NULL::numeric Deposit Batch
c_chargetype_doctype c_doctype_id numeric 10 Document type or rules
c_invoice c_doctype_id numeric 10 Document type or rules
c_invoicebatchline c_doctype_id numeric 10 Document type or rules
c_payment c_doctype_id numeric 10 Document type or rules
m_inout c_doctype_id numeric 10 Document type or rules
c_invoice c_doctypetarget_id numeric 10 Target document type for conversing documents
c_bpartner c_dunning_id numeric 10  √  null Dunning Rules for overdue invoices
c_invoice c_dunninglevel_id numeric 10  √  null Dunning Level
c_bpartner c_greeting_id numeric 10  √  null Greeting to print on correspondence
c_invoice c_invoice_id numeric 10 Invoice Identifier
c_invoicebatchline c_invoice_id numeric 10  √  null Invoice Identifier
c_invoiceline c_invoice_id numeric 10 Invoice Identifier
c_invoicepayschedule c_invoice_id numeric 10 Invoice Identifier
c_invoicetax c_invoice_id numeric 10 Invoice Identifier
c_payment c_invoice_id numeric 10  √  null Invoice Identifier
m_inout c_invoice_id numeric 10  √  null Invoice Identifier
c_invoice c_invoice_uu varchar 36  √  NULL::character varying C_Invoice_UU
c_invoicebatch c_invoicebatch_id numeric 10 Expense Invoice Batch Header
c_invoicebatchline c_invoicebatch_id numeric 10 Expense Invoice Batch Header
c_invoicebatch c_invoicebatch_uu varchar 36  √  NULL::character varying C_InvoiceBatch_UU
c_invoicebatchline c_invoicebatchline_id numeric 10 Expense Invoice Batch Line
c_invoicebatchline c_invoicebatchline_uu varchar 36  √  NULL::character varying C_InvoiceBatchLine_UU
c_invoicebatchline c_invoiceline_id numeric 10  √  null Invoice Detail Line
c_invoiceline c_invoiceline_id numeric 10 Invoice Detail Line
c_landedcost c_invoiceline_id numeric 10 Invoice Detail Line
c_landedcostallocation c_invoiceline_id numeric 10 Invoice Detail Line
c_revenuerecognition_plan c_invoiceline_id numeric 10 Invoice Detail Line
c_invoiceline c_invoiceline_uu varchar 36  √  NULL::character varying C_InvoiceLine_UU
c_invoicepayschedule c_invoicepayschedule_id numeric 10 Invoice Payment Schedule
c_invoicepayschedule c_invoicepayschedule_uu varchar 36  √  NULL::character varying C_InvoicePaySchedule_UU
c_bpartner c_invoiceschedule_id numeric 10  √  null Schedule for generating Invoices
c_invoiceschedule c_invoiceschedule_id numeric 10 Schedule for generating Invoices
c_invoiceschedule c_invoiceschedule_uu varchar 36  √  NULL::character varying C_InvoiceSchedule_UU
c_invoicetax c_invoicetax_uu varchar 36  √  NULL::character varying C_InvoiceTax_UU
c_landedcost c_landedcost_id numeric 10 Landed cost to be allocated to material receipts
c_landedcost c_landedcost_uu varchar 36  √  NULL::character varying C_LandedCost_UU
c_landedcostallocation c_landedcostallocation_id numeric 10 Allocation for Land Costs
c_landedcostallocation c_landedcostallocation_uu varchar 36  √  NULL::character varying C_LandedCostAllocation_UU
c_bpartner_location c_location_id numeric 10  √  null Location or Address
c_invoice c_order_id numeric 10  √  null Order
c_payment c_order_id numeric 10  √  null Order
m_inout c_order_id numeric 10  √  null Order
c_invoiceline c_orderline_id numeric 10  √  null Sales Order Line
m_inoutline c_orderline_id numeric 10  √  null Sales Order Line
c_invoice c_payment_id numeric 10  √  null Payment identifier
c_payment c_payment_id numeric 10 Payment identifier
c_payment c_payment_uu varchar 36  √  NULL::character varying C_Payment_UU
c_payment c_paymentbatch_id numeric 10  √  null Payment batch for EFT
c_payment c_paymentprocessor_id numeric 10  √  NULL::numeric Payment processor for electronic payments
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_paymentterm 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)
c_paymentterm c_paymentterm_uu varchar 36  √  NULL::character varying C_PaymentTerm_UU
c_invoicepayschedule c_payschedule_id numeric 10  √  null Payment Schedule Template
c_payschedule c_payschedule_id numeric 10 Payment Schedule Template
c_payschedule c_payschedule_uu varchar 36  √  NULL::character varying C_PaySchedule_UU
c_project c_phase_id numeric 10  √  null Standard Phase of the Project Type
c_payment c_postendertype_id numeric 10  √  NULL::numeric POS Tender Type
c_invoice c_project_id numeric 10  √  null Financial Project
c_invoicebatchline c_project_id numeric 10  √  null Financial Project
c_invoiceline c_project_id numeric 10  √  null Financial Project
c_payment c_project_id numeric 10  √  null Financial Project
c_project c_project_id numeric 10 Financial Project
m_inout c_project_id numeric 10  √  null Financial Project
m_inoutline c_project_id numeric 10  √  null Financial Project
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
m_inoutline c_projectphase_id numeric 10  √  null Phase of a Project
c_invoiceline c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
m_inoutline c_projecttask_id numeric 10  √  null Actual Project Task in a Phase
c_project c_projecttype_id numeric 10  √  null Type of the project
c_tax c_region_id numeric 10  √  null Identifies a geographical Region
c_revenuerecog_service c_revenuerecog_service_id numeric 10 Revenue Recognition Service
c_revenuerecognition_run c_revenuerecog_service_id numeric 10  √  NULL::numeric Revenue Recognition Service
c_revenuerecog_service c_revenuerecog_service_uu varchar 36  √  NULL::character varying C_RevenueRecog_Service_UU
c_revenuerecog_service c_revenuerecognition_id numeric 10 Method for recording revenue
c_revenuerecognition c_revenuerecognition_id numeric 10 Method for recording revenue
c_revenuerecognition_plan c_revenuerecognition_id numeric 10 Method for recording revenue
m_product c_revenuerecognition_id numeric 10  √  null Method for recording revenue
c_revenuerecognition_plan c_revenuerecognition_plan_id numeric 10 Plan for recognizing or recording revenue
c_revenuerecognition_run c_revenuerecognition_plan_id numeric 10 Plan for recognizing or recording revenue
c_servicelevel c_revenuerecognition_plan_id numeric 10 Plan for recognizing or recording revenue
c_revenuerecognition_plan c_revenuerecognition_plan_uu varchar 36  √  NULL::character varying C_RevenueRecognition_Plan_UU
c_revenuerecognition_run c_revenuerecognition_run_id numeric 10 Revenue Recognition Run or Process
c_revenuerecognition_run c_revenuerecognition_run_uu varchar 36  √  NULL::character varying C_RevenueRecognition_Run_UU
c_revenuerecognition c_revenuerecognition_uu varchar 36  √  NULL::character varying C_RevenueRecognition_UU
c_bpartner_location c_salesregion_id numeric 10  √  null Sales coverage region
c_servicelevel c_servicelevel_id numeric 10 Product Revenue Recognition Service Level
c_servicelevelline c_servicelevel_id numeric 10 Product Revenue Recognition Service Level
c_servicelevel c_servicelevel_uu varchar 36  √  NULL::character varying C_ServiceLevel_UU
c_servicelevelline c_servicelevelline_id numeric 10 Product Revenue Recognition Service Level Line
c_servicelevelline c_servicelevelline_uu varchar 36  √  NULL::character varying C_ServiceLevelLine_UU
m_product c_subscriptiontype_id numeric 10  √  null Type of subscription
c_invoicebatchline c_tax_id numeric 10 Tax identifier
c_invoiceline c_tax_id numeric 10  √  null Tax identifier
c_invoicetax c_tax_id numeric 10 Tax identifier
c_tax c_tax_id numeric 10 Tax identifier
c_tax c_tax_uu varchar 36  √  NULL::character varying C_Tax_UU
c_charge c_taxcategory_id numeric 10  √  null Tax Category
c_tax c_taxcategory_id numeric 10 Tax Category
m_product c_taxcategory_id numeric 10 Tax Category
c_bpartner c_taxgroup_id numeric 10  √  null Tax Group
c_invoicetax c_taxprovider_id numeric 10  √  NULL::numeric Tax Provider
c_tax c_taxprovider_id numeric 10  √  NULL::numeric Tax Provider
c_invoiceline c_uom_id numeric 10  √  null Unit of Measure
m_inoutline c_uom_id numeric 10 Unit of Measure
m_product c_uom_id numeric 10 Unit of Measure
c_charge chargeamt numeric 0 0 Charge Amount
c_invoice chargeamt numeric 0  √  0 Charge Amount
c_payment chargeamt numeric 0  √  0 Charge Amount
m_inout chargeamt numeric 0  √  0 Charge Amount
c_payment checkno varchar 20  √  null Check Number
m_product classification varchar 12  √  null Classification for grouping
c_project committedamt numeric 0 0 The (legal) commitment amount
c_project committedqty numeric 0 0 The (legal) commitment Quantity
m_inoutline confirmedqty numeric 0  √  0 Confirmation of a received quantity
c_invoicebatch controlamt numeric 0 0 If not zero, the Debit amount of the document must be equal this amount
c_payment convertedamt numeric 0  √  null Converted Amount
c_invoice 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
c_campaign costs numeric 0 0 Costs in accounting currency
m_inout createconfirm bpchar 1  √  null Create Confirm
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_bpartner created timestamp 29,6 now() Date this record was created
c_bpartner_location created timestamp 29,6 now() Date this record was created
c_campaign created timestamp 29,6 now() Date this record was created
c_charge created timestamp 29,6 now() Date this record was created
c_chargetype created timestamp 29,6 statement_timestamp() Date this record was created
c_chargetype_doctype created timestamp 29,6 statement_timestamp() Date this record was created
c_invoice created timestamp 29,6 now() Date this record was created
c_invoicebatch created timestamp 29,6 now() Date this record was created
c_invoicebatchline created timestamp 29,6 now() Date this record was created
c_invoiceline 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_invoicetax created timestamp 29,6 now() Date this record was created
c_landedcost created timestamp 29,6 now() Date this record was created
c_landedcostallocation created timestamp 29,6 now() Date this record was created
c_payment created timestamp 29,6 now() Date this record was created
c_paymentterm 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
c_revenuerecog_service created timestamp 29,6 Date this record was created
c_revenuerecognition created timestamp 29,6 now() Date this record was created
c_revenuerecognition_plan created timestamp 29,6 now() Date this record was created
c_revenuerecognition_run created timestamp 29,6 now() Date this record was created
c_servicelevel created timestamp 29,6 now() Date this record was created
c_servicelevelline created timestamp 29,6 now() Date this record was created
c_tax created timestamp 29,6 now() Date this record was created
m_inout created timestamp 29,6 now() Date this record was created
m_inoutline created timestamp 29,6 now() Date this record was created
m_pricelist created timestamp 29,6 now() Date this record was created
m_product 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_bpartner createdby numeric 10 User who created this records
c_bpartner_location createdby numeric 10 User who created this records
c_campaign createdby numeric 10 User who created this records
c_charge createdby numeric 10 User who created this records
c_chargetype createdby numeric 10 User who created this records
c_chargetype_doctype createdby numeric 10 User who created this records
c_invoice createdby numeric 10 User who created this records
c_invoicebatch createdby numeric 10 User who created this records
c_invoicebatchline createdby numeric 10 User who created this records
c_invoiceline 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_invoicetax createdby numeric 10 User who created this records
c_landedcost createdby numeric 10 User who created this records
c_landedcostallocation createdby numeric 10 User who created this records
c_payment createdby numeric 10 User who created this records
c_paymentterm 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
c_revenuerecog_service createdby numeric 10 User who created this records
c_revenuerecognition createdby numeric 10 User who created this records
c_revenuerecognition_plan createdby numeric 10 User who created this records
c_revenuerecognition_run createdby numeric 10 User who created this records
c_servicelevel createdby numeric 10 User who created this records
c_servicelevelline createdby numeric 10 User who created this records
c_tax createdby numeric 10 User who created this records
m_inout createdby numeric 10 User who created this records
m_inoutline createdby numeric 10 User who created this records
m_pricelist createdby numeric 10 User who created this records
m_product createdby numeric 10 User who created this records
c_invoice createfrom bpchar 1  √  null Process which will generate a new document lines based on an existing document
m_inout createfrom bpchar 1  √  null Process which will generate a new document lines based on an existing document
m_inout createpackage bpchar 1  √  null Create Package
c_payment creditcardexpmm numeric 10  √  null Expiry Month
c_payment creditcardexpyy numeric 10  √  null Expiry Year
c_payment creditcardnumber varchar 20  √  null Credit Card Number
c_payment creditcardtype bpchar 1  √  null Credit Card (Visa, MC, AmEx)
c_payment creditcardvv varchar 4  √  null Credit Card Verification code on credit card
c_invoice currencyrate numeric 0  √  null Currency Conversion Rate
c_payment currencyrate numeric 0  √  null Currency Conversion Rate
c_bpartner_location customeraddressid varchar 60  √  NULL::character varying Customer Address ID
c_payment customeraddressid varchar 60  √  NULL::character varying Customer Address ID
c_payment customerpaymentprofileid varchar 60  √  NULL::character varying Customer Payment Profile ID
c_bpartner customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
c_payment customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
m_product customstariffnumber varchar 20  √  null Customs Tariff Number, usually the HS-Code
c_invoice dateacct timestamp 29,6 Accounting Date
c_invoicebatchline dateacct timestamp 29,6 Accounting Date
c_payment dateacct timestamp 29,6 Accounting Date
m_inout dateacct timestamp 29,6 Accounting Date
c_project datecontract timestamp 29,6  √  null The (planned) effective date of this document.
c_invoicebatch datedoc timestamp 29,6 Date of the Document
c_project datefinish timestamp 29,6  √  null Finish or (planned) completion date
c_invoice dateinvoiced timestamp 29,6 Date printed on Invoice
c_invoicebatchline dateinvoiced timestamp 29,6 Date printed on Invoice
c_invoice dateordered timestamp 29,6  √  null Date of Order
m_inout dateordered timestamp 29,6  √  null Date of Order
c_invoice dateprinted timestamp 29,6  √  null Date the document was printed.
m_inout dateprinted timestamp 29,6  √  null Date the document was printed.
m_inout datereceived timestamp 29,6  √  null Date a product was received
c_revenuerecognition_run daterecognized timestamp 29,6  √  null Recognition Date
c_payment datetrx timestamp 29,6 Transaction Date
c_bpartner default1099box_id numeric 10  √  NULL::numeric Default 1099 Box
c_bpartner deliveryrule bpchar 1  √  null Defines the timing of Delivery
m_inout deliveryrule bpchar 1 Defines the timing of Delivery
c_bpartner deliveryviarule bpchar 1  √  null How the order will be delivered
m_inout deliveryviarule bpchar 1 How the order will be delivered
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_bpartner description varchar 255  √  null Optional short description of the record
c_campaign description varchar 255  √  null Optional short description of the record
c_charge description varchar 255  √  null Optional short description of the record
c_chargetype description varchar 255  √  null Optional short description of the record
c_invoice description varchar 255  √  null Optional short description of the record
c_invoicebatch description varchar 255  √  null Optional short description of the record
c_invoicebatchline description varchar 255  √  null Optional short description of the record
c_invoiceline description varchar 255  √  null Optional short description of the record
c_invoiceschedule description varchar 255  √  null Optional short description of the record
c_landedcost description varchar 255  √  null Optional short description of the record
c_payment description varchar 255  √  null Optional short description of the record
c_paymentterm description varchar 255  √  null Optional short description of the record
c_project description varchar 255  √  null Optional short description of the record
c_revenuerecog_service description varchar 255  √  NULL::character varying Optional short description of the record
c_revenuerecognition description varchar 255  √  null Optional short description of the record
c_servicelevel description varchar 255  √  null Optional short description of the record
c_servicelevelline description varchar 255  √  null Optional short description of the record
c_tax description varchar 255  √  null Optional short description of the record
m_inout description varchar 255  √  null Optional short description of the record
m_inoutline description varchar 255  √  null Optional short description of the record
m_pricelist description varchar 255  √  null Optional short description of the record
m_product 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 discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product discontinuedby timestamp 29,6  √  null
c_paymentterm discount numeric 0 Discount in percent
c_payschedule discount numeric 0 Discount in percent
c_paymentterm discount2 numeric 0 Discount in percent
c_invoicepayschedule discountamt numeric 0 0 Calculated amount of discount
c_payment discountamt numeric 0  √  0 Calculated amount of discount
c_invoicepayschedule discountdate timestamp 29,6 Last Date for payments with discount
c_paymentterm discountdays numeric 10 Number of days from invoice date to be eligible for discount
c_payschedule discountdays numeric 10 Number of days from invoice date to be eligible for discount
c_paymentterm discountdays2 numeric 10 Number of days from invoice date to be eligible for discount
c_invoice docaction bpchar 2 The targeted status of the document
c_payment docaction bpchar 2 The targeted status of the document
m_inout docaction bpchar 2 The targeted status of the document
c_invoice docstatus bpchar 2 The current status of the document
c_payment docstatus bpchar 2 The current status of the document
m_inout docstatus bpchar 2 The current status of the document
c_invoicebatch documentamt numeric 0 0 Document Amount
c_bpartner documentcopies numeric 10  √  null Number of copies to be printed
c_invoice documentno varchar 30 Document sequence number of the document
c_invoicebatch documentno varchar 30 Document sequence number of the document
c_invoicebatchline documentno varchar 30 Document sequence number of the document
c_payment documentno varchar 30 Document sequence number of the document
m_inout documentno varchar 30 Document sequence number of the document
c_paymentterm documentnote varchar 2000  √  null Additional information for a Document
m_product documentnote varchar 2000  √  null Additional information for a Document
m_product downloadurl varchar 120  √  null
m_inout dropship_bpartner_id numeric 10  √  null Business Partner to ship to
m_inout dropship_location_id numeric 10  √  null Business Partner Location for shipping to
m_inout dropship_user_id numeric 10  √  null Business Partner Contact for drop shipment
c_invoicepayschedule dueamt numeric 0 0 Amount of the payment due
c_invoicepayschedule 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
c_bpartner duns varchar 11  √  null Dun & Bradstreet Number
c_campaign enddate timestamp 29,6  √  null Last effective date (inclusive)
m_pricelist enforcepricelimit bpchar 1 'N'::bpchar Do not allow prices below the limit price
c_invoiceschedule eveninvoiceweek bpchar 1  √  'Y'::bpchar Send invoices on even weeks
c_bpartner_location fax varchar 40  √  null Facsimile number
c_bpartner firstsale timestamp 29,6  √  null Date of First Sale
c_revenuerecognition fixedrecogday numeric 10  √  NULL::numeric Day of the period recognition occurs
c_paymentterm fixmonthcutoff numeric 10  √  null Last day to include for next due date
c_paymentterm fixmonthday numeric 10  √  null Day of the month of the due date
c_paymentterm fixmonthoffset numeric 10  √  null Number of months (0=same, 1=following)
c_bpartner flatdiscount numeric 0  √  null Flat discount percentage
m_inout fob varchar 10  √  NULL::character varying Freight Terms
m_inout freightamt numeric 0  √  0 Freight Amount
m_inout freightcharges varchar 10  √  NULL::character varying Freight Charges
c_bpartner freightcostrule bpchar 1  √  null Method for charging Freight
m_inout freightcostrule bpchar 1 Method for charging Freight
c_invoice generateto bpchar 1  √  null Generate To
c_project generateto bpchar 1  √  null Generate To
m_inout generateto bpchar 1  √  null Generate To
c_revenuerecognition_run gl_journal_id numeric 10  √  null General Ledger Journal
c_paymentterm gracedays numeric 10 Days after due date to send first dunning letter
c_payschedule gracedays numeric 10 Days after due date to send first dunning letter
c_invoice grandtotal numeric 0 0 Total amount of document
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_chargetype help varchar 2000  √  null Comment or Hint
m_product help varchar 2000  √  null Comment or Hint
c_payment iban varchar 40  √  NULL::character varying International Bank Account Number
m_product imageurl varchar 120  √  null URL of image
m_inout insurance bpchar 1  √  NULL::bpchar Insurance
c_bpartner invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
c_invoice invoicecollectiontype bpchar 1  √  null Invoice Collection Status
c_project invoicedamt numeric 0 0 The amount invoiced
c_invoiceschedule invoiceday numeric 10  √  null Day of Invoice Generation
c_invoiceschedule invoicedaycutoff numeric 10  √  null Last day for including shipments
c_project invoicedqty numeric 0 0 The quantity invoiced
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_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_bpartner isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bpartner_location isactive bpchar 1 'Y'::bpchar The record is active in the system
c_campaign isactive bpchar 1 'Y'::bpchar The record is active in the system
c_charge isactive bpchar 1 'Y'::bpchar The record is active in the system
c_chargetype isactive bpchar 1 'Y'::bpchar The record is active in the system
c_chargetype_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_invoicebatch isactive bpchar 1 'Y'::bpchar The record is active in the system
c_invoicebatchline 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_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_invoicetax isactive bpchar 1 'Y'::bpchar The record is active in the system
c_payment isactive bpchar 1 'Y'::bpchar The record is active in the system
c_paymentterm isactive bpchar 1 'Y'::bpchar The record is active in the system
c_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
c_revenuerecog_service isactive bpchar 1 'Y'::bpchar The record is active in the system
c_revenuerecognition isactive bpchar 1 'Y'::bpchar The record is active in the system
c_revenuerecognition_plan isactive bpchar 1 'Y'::bpchar The record is active in the system
c_revenuerecognition_run isactive bpchar 1 'Y'::bpchar The record is active in the system
c_servicelevel isactive bpchar 1 'Y'::bpchar The record is active in the system
c_servicelevelline isactive bpchar 1 'Y'::bpchar The record is active in the system
c_tax isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inout isactive bpchar 1 'Y'::bpchar The record is active in the system
m_inoutline isactive bpchar 1 'Y'::bpchar The record is active in the system
m_pricelist 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
c_payment isallocated bpchar 1 'N'::bpchar Indicates if the payment has been allocated
c_chargetype_doctype isallownegative bpchar 1 'Y'::bpchar Allow Negative
c_chargetype_doctype isallowpositive bpchar 1 'Y'::bpchar Allow Positive
m_inout isalternatereturnaddress bpchar 1 'N'::bpchar Alternate Return Address
c_invoiceschedule isamount bpchar 1 'N'::bpchar Send invoices only if the amount exceeds the limit
c_invoice isapproved bpchar 1 'Y'::bpchar Indicates if this document requires approval
c_payment isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
m_inout isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
m_inoutline isautoproduce bpchar 1  √  'N'::bpchar Auto create production to fulfill shipment
m_product isautoproduce bpchar 1 'N'::bpchar Auto create production to fulfill shipment
c_bpartner_location isbillto bpchar 1 'Y'::bpchar Business Partner Invoice/Bill Address
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_project iscommitment bpchar 1 'Y'::bpchar Is this document a (legal) commitment?
c_bpartner iscustomer bpchar 1 'Y'::bpchar Indicates if this Business Partner is a Customer
c_invoiceschedule isdefault bpchar 1 'N'::bpchar Default value
c_paymentterm isdefault bpchar 1  √  'N'::bpchar Default value
c_tax isdefault bpchar 1 'N'::bpchar Default value
m_pricelist isdefault bpchar 1 'N'::bpchar Default value
c_payment isdelayedcapture bpchar 1 'N'::bpchar Charge after Shipment
c_invoiceline isdescription bpchar 1 'N'::bpchar if true, the line is just description and no transaction
m_inoutline isdescription bpchar 1 'N'::bpchar if true, the line is just description and no transaction
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar Print Discount on Invoice and Order
c_invoice isdiscountprinted bpchar 1 'Y'::bpchar Print Discount on Invoice and Order
c_bpartner_location isdn varchar 40  √  null ISDN or modem line
c_tax isdocumentlevel bpchar 1 'Y'::bpchar Tax is calculated on document level (rather than line by line)
m_inout isdropship bpchar 1  √  'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
m_product isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
c_paymentterm isduefixed bpchar 1 'N'::bpchar Payment is due on a fixed date
c_bpartner isemployee bpchar 1 'N'::bpchar Indicates if this Business Partner is an employee
m_product isexcludeautodelivery bpchar 1 'N'::bpchar Exclude from automatic Delivery
c_invoice isfixedassetinvoice bpchar 1  √  null IsFixedAssetInvoice
c_invoiceline isfixedassetinvoice bpchar 1  √  null IsFixedAssetInvoice
c_invoice isindispute bpchar 1 'N'::bpchar Document is in dispute
m_inout isindispute bpchar 1 'N'::bpchar Document is in dispute
m_inout isintransit bpchar 1 'N'::bpchar Movement is in transit
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_pricelist ismandatory bpchar 1  √  'N'::bpchar Data entry is required in this column
m_product ismanufactured bpchar 1 'N'::bpchar This product is manufactured
c_bpartner ismanufacturer bpchar 1  √  'N'::bpchar Indicate role of this Business partner as Manufacturer
c_paymentterm isnextbusinessday bpchar 1  √  'Y'::bpchar Payment due on the next business day
c_bpartner isonetime bpchar 1 'N'::bpchar One time transaction
c_payment isonline bpchar 1 'N'::bpchar Can be accessed online
c_invoice isoverridecurrencyrate bpchar 1 'N'::bpchar Override Currency Conversion Rate
c_payment isoverridecurrencyrate bpchar 1 'N'::bpchar Override Currency Conversion Rate
c_payment isoverunderpayment bpchar 1 'Y'::bpchar Over-Payment (unallocated) or Under-Payment (partial payment)
m_product isownbox bpchar 1 'N'::bpchar Own Box
c_invoice ispaid bpchar 1 'N'::bpchar The document is paid
c_bpartner_location ispayfrom bpchar 1 'Y'::bpchar Business Partner pays from that address and we'll send dunning letters there
c_invoice ispayschedulevalid bpchar 1 'N'::bpchar Is the Payment Schedule is valid
m_product isphantom bpchar 1  √  'N'::bpchar Phantom Component
m_product ispicklistprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the pick list
c_bpartner ispotaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on purchases
c_payment isprepayment bpchar 1 'N'::bpchar The Payment/Receipt is a Prepayment
m_pricelist ispresentforproduct bpchar 1  √  'N'::bpchar isPresentForProduct
c_bpartner_location ispreservecustomname bpchar 1 'N'::bpchar Preserve custom name
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
m_inout isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
c_bpartner isprospect bpchar 1 'N'::bpchar Indicates this is a Prospect
m_product ispurchased bpchar 1 'Y'::bpchar Organization purchases this product
c_payment isreceipt bpchar 1 'Y'::bpchar This is a sales transaction (receipt)
c_payment isreconciled bpchar 1 'N'::bpchar Payment is reconciled with bank statement
c_bpartner_location isremitto bpchar 1 'Y'::bpchar Business Partner payment address
c_bpartner issalesrep bpchar 1 'N'::bpchar Indicates if the business partner is a sales representative or company agent
c_tax issalestax bpchar 1 'N'::bpchar This is a sales tax (i.e. not a value added tax)
c_charge issamecurrency bpchar 1 'N'::bpchar Same Currency
c_charge issametax bpchar 1 'N'::bpchar Use the same tax as the main transaction
c_invoice isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
c_payment 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
c_bpartner_location isshipto bpchar 1 'Y'::bpchar Business Partner Shipment Address
m_product issold bpchar 1 'Y'::bpchar Organization sells this product
m_pricelist issopricelist bpchar 1 'Y'::bpchar This is a Sales Price List
c_invoice issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
c_invoicebatch issotrx bpchar 1 'N'::bpchar This is a Sales Transaction
m_inout issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
m_product isstocked bpchar 1 'Y'::bpchar Organization stocks this product
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_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_tax issummary bpchar 1 'N'::bpchar This is a summary entity
m_product issummary bpchar 1 'N'::bpchar This is a summary entity
c_bpartner istaxexempt bpchar 1  √  'N'::bpchar Business partner is exempt from tax on sales
c_tax istaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on sales
c_charge istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
c_invoice istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
c_invoicebatchline istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
c_invoicetax istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
m_pricelist istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
c_revenuerecognition istimebased bpchar 1 Time based Revenue Recognition rather than Service Level based
m_product istoformule bpchar 1  √  null
c_invoice istransferred bpchar 1 'N'::bpchar Transferred to General Ledger (i.e. accounted)
c_invoicepayschedule isvalid bpchar 1 'N'::bpchar Element is valid
c_paymentterm 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
m_product isverified bpchar 1 'N'::bpchar The BOM configuration has been verified
c_payment isvoided bpchar 1 'N'::bpchar Voided
m_product iswebstorefeatured bpchar 1 'N'::bpchar If selected, the product is displayed in the initial or any empty search
c_landedcost landedcostdistribution bpchar 1 Landed Cost Distribution
c_invoicebatchline line numeric 10 0 Unique line for this document
c_invoiceline line numeric 10 Unique line for this document
c_revenuerecog_service line numeric 10  √  NULL::numeric Unique line for this document
m_inoutline line numeric 10 Unique line for this document
c_invoicebatchline linenetamt numeric 0 0 Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_invoiceline linenetamt numeric 0 0 Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_invoicebatchline linetotalamt numeric 0 0 Total line amount incl. Tax
c_invoiceline linetotalamt numeric 0  √  0 Total line amount incl. Tax
c_bpartner logo_id numeric 10  √  NULL::numeric Logo
m_product lowlevel numeric 10 (0)::numeric The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
m_product m_attributeset_id numeric 10  √  null Product Attribute Set
c_invoiceline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
c_landedcostallocation m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
m_inoutline m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
m_product m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
c_landedcost m_costelement_id numeric 10 Product Cost Element
c_landedcostallocation m_costelement_id numeric 10 Product Cost Element
c_bpartner m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
m_product m_freightcategory_id numeric 10  √  null Category of the Freight
c_landedcost m_inout_id numeric 10  √  null Material Shipment Document
m_inout m_inout_id numeric 10 Material Shipment Document
m_inoutline m_inout_id numeric 10 Material Shipment Document
m_inout m_inout_uu varchar 36  √  NULL::character varying M_InOut_UU
c_invoiceline m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
c_landedcost m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
c_landedcostallocation m_inoutline_id numeric 10  √  NULL::numeric Line on Shipment or Receipt document
m_inoutline m_inoutline_id numeric 10 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_product m_parttype_id numeric 10  √  NULL::numeric Part Type
c_bpartner m_pricelist_id numeric 10  √  null Unique identifier of a Price List
c_invoice m_pricelist_id numeric 10 Unique identifier of a Price List
m_pricelist m_pricelist_id numeric 10 Unique identifier of a Price List
m_pricelist m_pricelist_uu varchar 36  √  NULL::character varying M_PriceList_UU
c_project m_pricelist_version_id numeric 10  √  null Identifies a unique instance of a Price List
m_product m_product_category_id numeric 10 Category of a Product
c_invoiceline m_product_id numeric 10  √  null Product, Service, Item
c_landedcost m_product_id numeric 10  √  null Product, Service, Item
c_landedcostallocation m_product_id numeric 10 Product, Service, Item
c_servicelevel m_product_id numeric 10 Product, Service, Item
m_inoutline m_product_id numeric 10  √  null Product, Service, Item
m_product m_product_id numeric 10 Product, Service, Item
m_product m_product_uu varchar 36  √  NULL::character varying M_Product_UU
c_invoice m_rma_id numeric 10  √  null Return Material Authorization
m_inout m_rma_id numeric 10  √  null Return Material Authorization
c_invoiceline m_rmaline_id numeric 10  √  null Return Material Authorization Line
m_inoutline m_rmaline_id numeric 10  √  null Return Material Authorization Line
m_inout 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_inout m_warehouse_id numeric 10 Storage Warehouse and Service Point
c_payment micr varchar 20  √  null Combination of routing no, account and check no
m_inout movementdate timestamp 29,6 Date a product was moved in or out of inventory
m_inoutline movementqty numeric 0 0 Quantity of a product moved.
m_inout movementtype bpchar 2 Method of moving the inventory
c_bpartner naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
ad_org name varchar 60 Alphanumeric identifier of the entity
c_activity name varchar 60 Alphanumeric identifier of the entity
c_bpartner name varchar 120 Alphanumeric identifier of the entity
c_bpartner_location name varchar 60 Alphanumeric identifier of the entity
c_campaign name varchar 60 Alphanumeric identifier of the entity
c_charge name varchar 60 Alphanumeric identifier of the entity
c_chargetype name varchar 60 Alphanumeric identifier of the entity
c_invoiceschedule name varchar 60 Alphanumeric identifier of the entity
c_paymentterm name varchar 60 Alphanumeric identifier of the entity
c_project name varchar 60 Alphanumeric identifier of the entity
c_revenuerecognition name varchar 60 Alphanumeric identifier of the entity
c_tax name varchar 60 Alphanumeric identifier of the entity
m_pricelist name varchar 60 Alphanumeric identifier of the entity
m_product name varchar 255 Alphanumeric identifier of the entity
c_bpartner name2 varchar 60  √  null Additional Name
c_paymentterm netday bpchar 1  √  null Day when payment is due net
c_payschedule netday bpchar 1  √  null Day when payment is due net
c_paymentterm netdays numeric 10 Net Days in which payment is due
c_payschedule netdays numeric 10 Net Days in which payment is due
c_revenuerecognition nomonths numeric 10  √  null Number of Months
m_inout nopackages numeric 10  √  (1)::numeric Number of packages shipped
c_project note varchar 2000  √  null Optional additional user defined information
c_bpartner numberemployees numeric 10  √  null Number of employees
c_payment oprocessing bpchar 1  √  null This payment can be processed online
c_payment orig_trxid varchar 20  √  null Original Transaction ID
c_payment overunderamt numeric 0  √  0 Over-Payment (unallocated) or Under-Payment (partial payment) Amount
c_revenuerecognition_plan p_revenue_acct numeric 10 Account for Product Revenue (Sales Account)
c_tax parent_tax_id numeric 10  √  null Parent Tax indicates a tax that is made up of multiple taxes
c_payment payamt numeric 0 0 Amount being paid
c_bpartner paymentrule bpchar 1  √  null How you pay the invoice
c_invoice paymentrule bpchar 1 How you pay the invoice
c_bpartner paymentrulepo bpchar 1  √  null Purchase payment option
c_paymentterm paymenttermusage bpchar 1 'B'::bpchar Payment term usage indicates if this payment term is used for sales, purchases or both.
c_revenuerecog_service percent numeric 0  √  null Percentage
c_payschedule percentage numeric 0 Percent of the entire amount
c_bpartner_location phone varchar 40  √  null Identifies a telephone number
c_bpartner_location phone2 varchar 40  √  null Identifies an alternate telephone number.
m_inout pickdate timestamp 29,6  √  null Date/Time when picked for Shipment
m_inoutline pickedqty numeric 0  √  0 Picked Quantity
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 po_discountschema_id numeric 10  √  null Schema to calculate the purchase trade discount percentage
c_bpartner po_paymentterm_id numeric 10  √  null Payment rules for a purchase order
c_bpartner po_pricelist_id numeric 10  √  null Price List used by this Business Partner
c_payment ponum varchar 60  √  null Purchase Order Number
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
m_inout poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_invoice posted bpchar 1 'N'::bpchar Posting status
c_payment posted bpchar 1 'N'::bpchar Posting status
m_inout posted bpchar 1 'N'::bpchar Posting status
c_bpartner potentiallifetimevalue numeric 0  √  0 Total Revenue expected
c_invoiceline priceactual numeric 0 0 Actual Price
c_invoicebatchline priceentered numeric 0 0 Price Entered - the price based on the selected/base UoM
c_invoiceline 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_invoiceline pricelist numeric 0 0 List Price
m_pricelist priceprecision numeric 10 2 Precision (number of decimals) for the Price
m_inout priorityrule bpchar 1 Priority of a document
c_invoice processed bpchar 1 'N'::bpchar The document has been processed
c_invoicebatch processed bpchar 1 'N'::bpchar The document has been processed
c_invoicebatchline processed bpchar 1 'N'::bpchar The document has been processed
c_invoiceline processed bpchar 1 'N'::bpchar The document has been processed
c_invoicepayschedule processed bpchar 1 'N'::bpchar The document has been processed
c_invoicetax processed bpchar 1 'N'::bpchar The document has been processed
c_payment processed bpchar 1 'N'::bpchar The document has been processed
c_project processed bpchar 1 'N'::bpchar The document has been processed
c_servicelevel processed bpchar 1  √  'N'::bpchar The document has been processed
c_servicelevelline processed bpchar 1  √  'N'::bpchar The document has been processed
m_inout processed bpchar 1 'N'::bpchar The document has been processed
m_inoutline processed bpchar 1 'N'::bpchar The document has been processed
c_invoice processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
c_payment processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
m_inout processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
c_invoice processing bpchar 1  √  null Process Now
c_invoicebatch processing bpchar 1  √  null Process Now
c_invoicepayschedule processing bpchar 1  √  null Process Now
c_landedcost processing bpchar 1  √  null Process Now
c_payment processing bpchar 1  √  null Process Now
c_paymentterm processing bpchar 1  √  null Process Now
c_project processing bpchar 1  √  null Process Now
c_servicelevel processing bpchar 1  √  null Process Now
m_inout processing bpchar 1  √  null Process Now
m_product processing bpchar 1  √  null Process Now
m_product producttype bpchar 1 'I'::bpchar Type of product
c_project projectbalanceamt numeric 0 0 Total Project Balance
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_landedcostallocation qty numeric 0 0 Quantity
c_invoicebatchline qtyentered numeric 0 0 The Quantity Entered is based on the selected UoM
c_invoiceline 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
m_inoutline qtyoverreceipt numeric 0  √  0 Over Receipt Quantity
c_payment r_authcode varchar 20  √  null Authorization Code returned
c_payment r_authcode_dc varchar 20  √  null Authorization Code Delayed Capture returned
c_payment r_avsaddr bpchar 1  √  null This address has been verified
c_payment r_avszip bpchar 1  √  null The Zip Code has been verified
c_payment r_cvv2match bpchar 1  √  null Credit Card Verification Code Match
c_payment r_info varchar 2000  √  null Response info
m_product r_mailtext_id numeric 10  √  null Text templates for mailings
c_payment r_pnref varchar 20  √  null Payment reference
c_payment r_pnref_dc varchar 20  √  null Payment Reference Delayed Capture
c_payment r_respmsg varchar 60  √  null Response message
c_payment r_result varchar 20  √  null Result of transmission
c_payment r_voidmsg varchar 255  √  NULL::character varying Void Message
c_tax rate numeric 0 Rate or Tax or Exchange
c_bpartner rating bpchar 1  √  null Classification or Importance
c_revenuerecognition recognitionfrequency bpchar 1  √  null Recognition frequency
c_revenuerecognition_plan recognizedamt numeric 0 0 Recognized Amount
c_revenuerecognition_run recognizedamt numeric 0 0 Recognized Amount
m_inout ref_inout_id numeric 10  √  null Referenced Shipment
m_inoutline ref_inoutline_id numeric 10  √  null Referenced Shipment Line
c_invoice ref_invoice_id numeric 10  √  null Referenced Invoice
c_invoiceline ref_invoiceline_id numeric 10  √  null Referenced Invoice Line
c_payment ref_payment_id numeric 10  √  null Referenced Payment
c_bpartner referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
c_invoice relatedinvoice_id numeric 10  √  NULL::numeric Related Invoice
c_tax requirestaxcertificate bpchar 1 'N'::bpchar This tax rate requires the Business Partner to be tax exempt
m_inout returnbpartner_id numeric 10  √  NULL::numeric Return Partner
m_inout returnlocation_id numeric 10  √  NULL::numeric Return Location
m_inout returnuser_id numeric 10  √  NULL::numeric Return User/Contact
c_invoice reversal_id numeric 10  √  null ID of document reversal
c_payment reversal_id numeric 10  √  null ID of document reversal
m_inout reversal_id numeric 10  √  null ID of document reversal
m_inoutline reversalline_id numeric 10  √  null Use to keep the reversal line ID for reversing costing purpose
c_payment routingno varchar 20  √  null Bank Routing Number
c_invoiceline rramt numeric 0  √  null Revenue Recognition Amount
c_invoiceline 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_bpartner salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_invoice salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_invoicebatch salesrep_id numeric 10 Sales Representative or Company Agent
c_project salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_inout salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_product salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_bpartner salesvolume numeric 10  √  null Total Volume of Sales in Thousands of Currency
m_inoutline scrappedqty numeric 0  √  0 The Quantity scrapped due to QA issues
c_bpartner sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_invoice sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
m_inout sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_servicelevelline servicedate timestamp 29,6 Date service was provided
c_servicelevel servicelevelinvoiced numeric 0 Quantity of product or service invoiced
c_servicelevel servicelevelprovided numeric 0 Quantity of service or product provided
c_servicelevelline servicelevelprovided numeric 0 Quantity of service or product provided
c_bpartner shareofcustomer numeric 10  √  null Share of Customer's business as a percentage
m_product shelfdepth numeric 10  √  null Shelf depth required
m_product shelfheight numeric 0  √  null Shelf height required
c_bpartner shelflifeminpct numeric 10  √  null Minimum Shelf Life in percent based on Product Instance Guarantee Date
m_product shelfwidth numeric 10  √  null Shelf width required
m_inout shipdate timestamp 29,6  √  null Shipment Date/Time
m_inout shipperaccount varchar 40  √  NULL::character varying Shipper Account Number
m_product sku varchar 30  √  null Stock Keeping Unit
c_bpartner so_creditlimit numeric 0  √  0 Total outstanding invoice amounts allowed
c_bpartner so_creditused numeric 0  √  0 Current open balance
c_bpartner so_description varchar 255  √  null Description to be used on orders
c_bpartner socreditstatus bpchar 1  √  'O'::bpchar Business Partner Credit Status
c_tax sopotype bpchar 1 'B'::bpchar Sales Tax applies to sales situations, Purchase Tax to purchase situations
c_campaign startdate timestamp 29,6  √  null First effective day (inclusive)
c_payment swiftcode varchar 20  √  NULL::character varying Swift Code or BIC
c_payment swipe varchar 80  √  null Track 1 and 2 of the Credit Card
m_inoutline targetqty numeric 0  √  0 Target Movement Quantity
c_invoicebatchline taxamt numeric 0 0 Tax Amount for a document
c_invoiceline taxamt numeric 0  √  0 Tax Amount for a document
c_invoicetax taxamt numeric 0 0 Tax Amount for a document
c_payment taxamt numeric 0  √  0 Tax Amount for a document
c_invoicetax taxbaseamt numeric 0 0 Base for calculating the tax amount
c_bpartner taxid varchar 20  √  null Tax Identification
c_tax taxindicator varchar 10  √  null Short form for Tax to be printed on documents
c_payment tendertype bpchar 1 Method of Payment
c_tax to_country_id numeric 10  √  null Receiving Country
c_tax to_region_id numeric 10  √  null Receiving Region
c_revenuerecognition_plan totalamt numeric 0 0 Total Amount
c_invoice totallines numeric 0 0 Total of all document lines
c_bpartner totalopenbalance numeric 0  √  null Total Open Balance Amount in primary Accounting Currency
m_inout trackingno varchar 60  √  null Number to track the shipment
c_payment trxtype bpchar 1 Type of credit card transaction
c_revenuerecognition_plan unearnedrevenue_acct numeric 10 Account for unearned revenue
m_product unitsperpack numeric 10 1 The Units Per Pack indicates the no of units of a product packed together.
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)
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_bpartner updated timestamp 29,6 now() Date this record was updated
c_bpartner_location updated timestamp 29,6 now() Date this record was updated
c_campaign updated timestamp 29,6 now() Date this record was updated
c_charge updated timestamp 29,6 now() Date this record was updated
c_chargetype updated timestamp 29,6 statement_timestamp() Date this record was updated
c_chargetype_doctype updated timestamp 29,6 statement_timestamp() Date this record was updated
c_invoice updated timestamp 29,6 now() Date this record was updated
c_invoicebatch updated timestamp 29,6 now() Date this record was updated
c_invoicebatchline updated timestamp 29,6 now() Date this record was updated
c_invoiceline 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_invoicetax updated timestamp 29,6 now() Date this record was updated
c_landedcost updated timestamp 29,6 now() Date this record was updated
c_landedcostallocation updated timestamp 29,6 now() Date this record was updated
c_payment updated timestamp 29,6 now() Date this record was updated
c_paymentterm 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
c_revenuerecog_service updated timestamp 29,6 Date this record was updated
c_revenuerecognition updated timestamp 29,6 now() Date this record was updated
c_revenuerecognition_plan updated timestamp 29,6 now() Date this record was updated
c_revenuerecognition_run updated timestamp 29,6 now() Date this record was updated
c_servicelevel updated timestamp 29,6 now() Date this record was updated
c_servicelevelline updated timestamp 29,6 now() Date this record was updated
c_tax updated timestamp 29,6 now() Date this record was updated
m_inout updated timestamp 29,6 now() Date this record was updated
m_inoutline updated timestamp 29,6 now() Date this record was updated
m_pricelist updated timestamp 29,6 now() Date this record was updated
m_product 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_bpartner updatedby numeric 10 User who updated this records
c_bpartner_location updatedby numeric 10 User who updated this records
c_campaign updatedby numeric 10 User who updated this records
c_charge updatedby numeric 10 User who updated this records
c_chargetype updatedby numeric 10 User who updated this records
c_chargetype_doctype updatedby numeric 10 User who updated this records
c_invoice updatedby numeric 10 User who updated this records
c_invoicebatch updatedby numeric 10 User who updated this records
c_invoicebatchline updatedby numeric 10 User who updated this records
c_invoiceline 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_invoicetax updatedby numeric 10 User who updated this records
c_landedcost updatedby numeric 10 User who updated this records
c_landedcostallocation updatedby numeric 10 User who updated this records
c_payment updatedby numeric 10 User who updated this records
c_paymentterm 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
c_revenuerecog_service updatedby numeric 10 User who updated this records
c_revenuerecognition updatedby numeric 10 User who updated this records
c_revenuerecognition_plan updatedby numeric 10 User who updated this records
c_revenuerecognition_run updatedby numeric 10 User who updated this records
c_servicelevel updatedby numeric 10 User who updated this records
c_servicelevelline updatedby numeric 10 User who updated this records
c_tax updatedby numeric 10 User who updated this records
m_inout updatedby numeric 10 User who updated this records
m_inoutline updatedby numeric 10 User who updated this records
m_pricelist updatedby numeric 10 User who updated this records
m_product updatedby numeric 10 User who updated this records
c_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
c_invoice user1_id numeric 10  √  null User defined list element #1
c_invoicebatchline user1_id numeric 10  √  null User defined list element #1
c_invoiceline user1_id numeric 10  √  null User defined list element #1
c_payment user1_id numeric 10  √  null User defined list element #1
m_inout user1_id numeric 10  √  null User defined list element #1
m_inoutline user1_id numeric 10  √  null User defined list element #1
c_invoice user2_id numeric 10  √  null User defined list element #2
c_invoicebatchline user2_id numeric 10  √  null User defined list element #2
c_invoiceline user2_id numeric 10  √  null User defined list element #2
c_payment user2_id numeric 10  √  null User defined list element #2
m_inout user2_id numeric 10  √  null User defined list element #2
m_inoutline user2_id numeric 10  √  null User defined list element #2
c_tax validfrom timestamp 29,6 Valid from including this date (first day)
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_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_chargetype value varchar 40 Search key for the record in the format required - must be unique
c_paymentterm value varchar 40 Search key for the record in the format required - must be unique
c_project value varchar 40 Search key for the record in the format required - must be unique
m_product value varchar 40 Search key for the record in the format required - must be unique
m_product versionno varchar 20  √  null Version Number
c_payment voiceauthcode varchar 20  √  null Voice Authorization Code from credit card company
m_inout volume numeric 0  √  null Volume of a product
m_product volume numeric 0  √  0 Volume of a product
m_inout weight numeric 0  √  null Weight of a product
m_product weight numeric 0  √  0 Weight of a product
c_payment writeoffamt numeric 0  √  0 Amount to write-off