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

idempiere9.adempiere contains 985 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
c_bp_bankaccount a_city varchar 60  √  null City or the Credit Card or Account Holder
c_payment a_city varchar 60  √  null City or the Credit Card or Account Holder
i_payment a_city varchar 60  √  null City or the Credit Card or Account Holder
c_bp_bankaccount a_country varchar 40  √  null Country
c_payment a_country varchar 40  √  null Country
i_payment a_country varchar 40  √  null Country
c_bp_bankaccount a_email varchar 60  √  null Email Address
c_payment a_email varchar 60  √  null Email Address
i_payment a_email varchar 60  √  null Email Address
c_bp_bankaccount a_ident_dl varchar 20  √  null Payment Identification - Driver License
c_payment a_ident_dl varchar 20  √  null Payment Identification - Driver License
i_payment a_ident_dl varchar 20  √  null Payment Identification - Driver License
c_bp_bankaccount a_ident_ssn varchar 20  √  null Payment Identification - Social Security No
c_payment a_ident_ssn varchar 20  √  null Payment Identification - Social Security No
i_payment a_ident_ssn varchar 20  √  null Payment Identification - Social Security No
c_bp_bankaccount a_name varchar 60  √  null Name on Credit Card or Account holder
c_payment a_name varchar 60  √  null Name on Credit Card or Account holder
i_payment a_name varchar 60  √  null Name on Credit Card or Account holder
c_bp_bankaccount a_state varchar 40  √  null State of the Credit Card or Account holder
c_payment a_state varchar 40  √  null State of the Credit Card or Account holder
i_payment a_state varchar 40  √  null State of the Credit Card or Account holder
c_bp_bankaccount a_street varchar 60  √  null Street address of the Credit Card or Account holder
c_payment a_street varchar 60  √  null Street address of the Credit Card or Account holder
i_payment a_street varchar 60  √  null Street address of the Credit Card or Account holder
c_bp_bankaccount a_zip varchar 20  √  null Zip Code of the Credit Card or Account Holder
c_payment a_zip varchar 20  √  null Zip Code of the Credit Card or Account Holder
i_payment a_zip varchar 20  √  null Zip Code of the Credit Card or Account Holder
c_paymentprocessor acceptamex bpchar 1 'Y'::bpchar Accept American Express Card
c_paymentprocessor acceptatm bpchar 1 'Y'::bpchar Accept Bank ATM Card
c_paymentprocessor acceptcheck bpchar 1 'Y'::bpchar Accept ECheck (Electronic Checks)
c_paymentprocessor acceptcorporate bpchar 1 'Y'::bpchar Accept Corporate Purchase Cards
c_paymentprocessor acceptdiners bpchar 1 'Y'::bpchar Accept Diner's Club
c_paymentprocessor acceptdirectdebit bpchar 1 'N'::bpchar Accept Direct Debits (vendor initiated)
c_paymentprocessor acceptdirectdeposit bpchar 1 'N'::bpchar Accept Direct Deposit (payee initiated)
c_paymentprocessor acceptdiscover bpchar 1 'Y'::bpchar Accept Discover Card
c_paymentprocessor acceptmc bpchar 1 'Y'::bpchar Accept Master Card
c_paymentprocessor acceptvisa bpchar 1 'Y'::bpchar Accept Visa Cards
c_bankaccount accountno varchar 20 Account Number
c_bp_bankaccount accountno varchar 20  √  null Account Number
c_payment accountno varchar 20  √  null Account Number
i_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
c_allocationhdr ad_client_id numeric 10 Client/Tenant for this installation.
c_allocationline ad_client_id numeric 10 Client/Tenant for this installation.
c_bank ad_client_id numeric 10 Client/Tenant for this installation.
c_bankaccount ad_client_id numeric 10 Client/Tenant for this installation.
c_bankstatementline ad_client_id numeric 10 Client/Tenant for this installation.
c_bp_bankaccount ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner ad_client_id numeric 10 Client/Tenant for this installation.
c_cash ad_client_id numeric 10 Client/Tenant for this installation.
c_cashline ad_client_id numeric 10 Client/Tenant for this installation.
c_charge ad_client_id numeric 10 Client/Tenant for this installation.
c_currency ad_client_id numeric 10 Client/Tenant for this installation.
c_depositbatch ad_client_id numeric 10 Client/Tenant for this installation.
c_depositbatchline ad_client_id numeric 10 Client/Tenant for this installation.
c_doctype ad_client_id numeric 10 Client/Tenant for this installation.
c_invoice ad_client_id numeric 10 Client/Tenant for this installation.
c_invoicepayschedule ad_client_id numeric 10 Client/Tenant for this installation.
c_order ad_client_id numeric 10 Client/Tenant for this installation.
c_payment ad_client_id numeric 10 Client/Tenant for this installation.
c_paymentallocate ad_client_id numeric 10 Client/Tenant for this installation.
c_paymentbatch ad_client_id numeric 10 Client/Tenant for this installation.
c_paymentprocessor 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_payselection ad_client_id numeric 10 Client/Tenant for this installation.
c_payselectioncheck ad_client_id numeric 10 Client/Tenant for this installation.
c_payselectionline ad_client_id numeric 10 Client/Tenant for this installation.
c_project ad_client_id numeric 10 Client/Tenant for this installation.
i_payment ad_client_id numeric 10  √  null Client/Tenant for this installation.
c_bpartner ad_language varchar 6  √  null Language for this entity
c_allocationhdr ad_org_id numeric 10 Organizational entity within client
c_allocationline ad_org_id numeric 10 Organizational entity within client
c_bank ad_org_id numeric 10 Organizational entity within client
c_bankaccount ad_org_id numeric 10 Organizational entity within client
c_bankstatementline ad_org_id numeric 10 Organizational entity within client
c_bp_bankaccount ad_org_id numeric 10 Organizational entity within client
c_bpartner ad_org_id numeric 10 Organizational entity within client
c_cash ad_org_id numeric 10 Organizational entity within client
c_cashline ad_org_id numeric 10 Organizational entity within client
c_charge ad_org_id numeric 10 Organizational entity within client
c_currency ad_org_id numeric 10 Organizational entity within client
c_depositbatch ad_org_id numeric 10 Organizational entity within client
c_depositbatchline ad_org_id numeric 10 Organizational entity within client
c_doctype ad_org_id numeric 10 Organizational entity within client
c_invoice ad_org_id numeric 10 Organizational entity within client
c_invoicepayschedule ad_org_id numeric 10 Organizational entity within client
c_order ad_org_id numeric 10 Organizational entity within client
c_payment ad_org_id numeric 10 Organizational entity within client
c_paymentallocate ad_org_id numeric 10 Organizational entity within client
c_paymentbatch ad_org_id numeric 10 Organizational entity within client
c_paymentprocessor 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_payselection ad_org_id numeric 10 Organizational entity within client
c_payselectioncheck ad_org_id numeric 10 Organizational entity within client
c_payselectionline ad_org_id numeric 10 Organizational entity within client
c_project ad_org_id numeric 10 Organizational entity within client
i_payment ad_org_id numeric 10  √  null Organizational entity within client
c_bpartner ad_orgbp_id numeric 10  √  null The Business Partner is another Organization for explicit Inter-Org transactions
c_cash ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_invoice ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_order 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
c_doctype ad_printformat_id numeric 10  √  null Data Print Format
c_paymentprocessor ad_sequence_id numeric 10  √  null Document Sequence
c_bp_bankaccount ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_invoice ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_order ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_project ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_paymentterm afterdelivery bpchar 1 'N'::bpchar Due after delivery rather than after invoicing
c_allocationline allocationno numeric 10  √  null
c_allocationline amount numeric 0 0 Amount in a defined currency
c_cashline amount numeric 0 0 Amount in a defined currency
c_paymentallocate amount numeric 0 0 Amount in a defined currency
c_order amountrefunded numeric 22,2  √  null AmountRefunded
c_order amounttendered numeric 22,2  √  null AmountTendered
c_allocationhdr approvalamt numeric 0 0 Document Approval Amount
i_payment bankaccountno varchar 20  √  null Bank Account Number
c_bankaccount bankaccounttype bpchar 1 Bank Account Type
c_bp_bankaccount bankaccounttype bpchar 1  √  null Bank Account Type
c_bankaccount bban varchar 40  √  null Basic Bank Account Number
c_cash beginningbalance numeric 0 0 Balance prior to any transactions
c_order bill_bpartner_id numeric 10  √  null Business Partner to be invoiced
c_order bill_location_id numeric 10  √  null Business Partner Location for invoicing
c_order bill_user_id numeric 10  √  null Business Partner Contact for invoicing
c_bpartner bpartner_parent_id numeric 10  √  null Business Partner Parent
i_payment bpartnervalue varchar 40  √  null Key of the Business Partner
c_bp_bankaccount bpbankacctuse bpchar 1  √  null Business Partner Bank Account usage
c_cash c_activity_id numeric 10  √  null Business Activity
c_invoice c_activity_id numeric 10  √  null Business Activity
c_order 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
c_allocationhdr c_allocationhdr_id numeric 10 Payment allocation
c_allocationline c_allocationhdr_id numeric 10 Payment allocation
c_allocationhdr c_allocationhdr_uu varchar 36  √  NULL::character varying C_AllocationHdr_UU
c_allocationline c_allocationline_id numeric 10 Allocation Line
c_paymentallocate c_allocationline_id numeric 10  √  null Allocation Line
c_allocationline c_allocationline_uu varchar 36  √  NULL::character varying C_AllocationLine_UU
c_bank c_bank_id numeric 10 Bank
c_bankaccount c_bank_id numeric 10 Bank
c_bp_bankaccount c_bank_id numeric 10  √  null Bank
c_bank c_bank_uu varchar 36  √  NULL::character varying C_Bank_UU
c_bankaccount c_bankaccount_id numeric 10 Account at the Bank
c_cashline c_bankaccount_id numeric 10  √  null Account at the Bank
c_depositbatch c_bankaccount_id numeric 10 Account at the Bank
c_payment c_bankaccount_id numeric 10  √  null Account at the Bank
c_paymentprocessor c_bankaccount_id numeric 10  √  null Account at the Bank
c_payselection c_bankaccount_id numeric 10 Account at the Bank
i_payment c_bankaccount_id numeric 10  √  null Account at the Bank
c_bankaccount c_bankaccount_uu varchar 36  √  NULL::character varying C_BankAccount_UU
c_bankstatementline c_bankstatement_id numeric 10 Bank Statement of account
c_bankstatementline c_bankstatementline_id numeric 10 Line on a statement from this Bank
c_bankstatementline c_bankstatementline_uu varchar 36  √  NULL::character varying C_BankStatementLine_UU
c_bp_bankaccount c_bp_bankaccount_id numeric 10 Bank Account of the Business Partner
c_payment c_bp_bankaccount_id numeric 10  √  null Bank Account of the Business Partner
c_payselectioncheck c_bp_bankaccount_id numeric 10  √  null Bank Account of the Business Partner
c_bp_bankaccount c_bp_bankaccount_uu varchar 36  √  NULL::character varying C_BP_BankAccount_UU
c_bpartner c_bp_group_id numeric 10 Business Partner Group
c_allocationline c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_bankstatementline c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_bp_bankaccount c_bpartner_id numeric 10 Identifies a Business Partner
c_bpartner 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_order c_bpartner_id numeric 10 Identifies a Business Partner
c_payment c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_payselectioncheck c_bpartner_id numeric 10 Identifies a Business Partner
c_project c_bpartner_id numeric 10  √  null Identifies a Business Partner
i_payment 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_order 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
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_cash c_campaign_id numeric 10  √  null Marketing Campaign
c_invoice c_campaign_id numeric 10  √  null Marketing Campaign
c_order 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
c_cash c_cash_id numeric 10 Cash Journal
c_cashline c_cash_id numeric 10 Cash Journal
c_cash c_cash_uu varchar 36  √  NULL::character varying C_Cash_UU
c_cash c_cashbook_id numeric 10 Cash Book for recording petty cash transactions
c_payment c_cashbook_id numeric 10  √  null Cash Book for recording petty cash transactions
c_allocationline c_cashline_id numeric 10  √  null Cash Journal Line
c_cashline c_cashline_id numeric 10 Cash Journal Line
c_invoice c_cashline_id numeric 10  √  null Cash Journal Line
c_order c_cashline_id numeric 10  √  null Cash Journal Line
c_cashline c_cashline_uu varchar 36  √  NULL::character varying C_CashLine_UU
c_invoice c_cashplanline_id numeric 10  √  NULL::numeric Cash Plan Line
c_order c_cashplanline_id numeric 10  √  NULL::numeric Cash Plan Line
c_allocationline c_charge_id numeric 10  √  NULL::numeric Additional document charges
c_bankstatementline c_charge_id numeric 10  √  null Additional document charges
c_cashline c_charge_id numeric 10  √  null Additional document charges
c_charge c_charge_id numeric 10 Additional document charges
c_invoice c_charge_id numeric 10  √  null Additional document charges
c_order c_charge_id numeric 10  √  null Additional document charges
c_payment c_charge_id numeric 10  √  null Additional document charges
i_payment c_charge_id numeric 10  √  null Additional document charges
c_charge c_charge_uu varchar 36  √  NULL::character varying C_Charge_UU
c_charge c_chargetype_id numeric 10  √  null Charge Type
c_invoice c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
c_order c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
c_payment c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
c_allocationhdr c_currency_id numeric 10 The Currency for this record
c_bankaccount c_currency_id numeric 10 The Currency for this record
c_bankstatementline c_currency_id numeric 10 The Currency for this record
c_cashline c_currency_id numeric 10  √  null The Currency for this record
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_order c_currency_id numeric 10 The Currency for this record
c_payment c_currency_id numeric 10 The Currency for this record
c_paymentprocessor c_currency_id numeric 10  √  null The Currency for this record
c_project c_currency_id numeric 10 The Currency for this record
i_payment c_currency_id numeric 10  √  null The Currency for this record
c_currency c_currency_uu varchar 36  √  NULL::character varying C_Currency_UU
c_depositbatch c_depositbatch_id numeric 10 Deposit Batch
c_depositbatchline c_depositbatch_id numeric 10 Deposit Batch
c_payment c_depositbatch_id numeric 10  √  NULL::numeric Deposit Batch
c_depositbatch c_depositbatch_uu varchar 36  √  NULL::character varying C_DepositBatch_UU
c_depositbatchline c_depositbatchline_id numeric 10 Deposit Batch Line
c_depositbatchline c_depositbatchline_uu varchar 36  √  NULL::character varying C_DepositBatchLine_UU
c_allocationhdr c_doctype_id numeric 10  √  NULL::numeric Document type or rules
c_depositbatch c_doctype_id numeric 10 Document type or rules
c_doctype c_doctype_id numeric 10 Document type or rules
c_invoice c_doctype_id numeric 10 Document type or rules
c_order c_doctype_id numeric 10 Document type or rules
c_payment c_doctype_id numeric 10 Document type or rules
i_payment c_doctype_id numeric 10  √  null Document type or rules
c_doctype c_doctype_uu varchar 36  √  NULL::character varying C_DocType_UU
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
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
c_order c_doctypetarget_id numeric 10 Target document type for conversing documents
c_bpartner c_dunning_id numeric 10  √  null Dunning Rules for overdue invoices
c_invoice c_dunninglevel_id numeric 10  √  null Dunning Level
c_bpartner c_greeting_id numeric 10  √  null Greeting to print on correspondence
c_allocationline c_invoice_id numeric 10  √  null Invoice Identifier
c_bankstatementline c_invoice_id numeric 10  √  null Invoice Identifier
c_cashline c_invoice_id numeric 10  √  null Invoice Identifier
c_invoice c_invoice_id numeric 10 Invoice Identifier
c_invoicepayschedule c_invoice_id numeric 10 Invoice Identifier
c_payment c_invoice_id numeric 10  √  null Invoice Identifier
c_paymentallocate c_invoice_id numeric 10 Invoice Identifier
c_payselectionline c_invoice_id numeric 10 Invoice Identifier
i_payment c_invoice_id numeric 10  √  null Invoice Identifier
c_invoice c_invoice_uu varchar 36  √  NULL::character varying C_Invoice_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_bank c_location_id numeric 10  √  null Location or Address
c_order c_opportunity_id numeric 10  √  NULL::numeric Sales Opportunity
c_allocationline c_order_id numeric 10  √  null Order
c_invoice c_order_id numeric 10  √  null Order
c_order c_order_id numeric 10 Order
c_payment c_order_id numeric 10  √  null Order
c_order c_order_uu varchar 36  √  NULL::character varying C_Order_UU
c_order c_ordersource_id numeric 10  √  null Order Source
c_allocationline c_payment_id numeric 10  √  null Payment identifier
c_bankstatementline c_payment_id numeric 10  √  null Payment identifier
c_cashline c_payment_id numeric 10  √  null Payment identifier
c_depositbatchline c_payment_id numeric 10 Payment identifier
c_invoice c_payment_id numeric 10  √  null Payment identifier
c_order c_payment_id numeric 10  √  null Payment identifier
c_payment c_payment_id numeric 10 Payment identifier
c_paymentallocate c_payment_id numeric 10 Payment identifier
c_payselectioncheck c_payment_id numeric 10  √  null Payment identifier
i_payment c_payment_id numeric 10  √  null Payment identifier
c_payment c_payment_uu varchar 36  √  NULL::character varying C_Payment_UU
c_paymentallocate c_paymentallocate_id numeric 10 Allocate Payment to Invoices
c_paymentallocate c_paymentallocate_uu varchar 36  √  NULL::character varying C_PaymentAllocate_UU
c_payment c_paymentbatch_id numeric 10  √  null Payment batch for EFT
c_paymentbatch c_paymentbatch_id numeric 10 Payment batch for EFT
c_paymentbatch c_paymentbatch_uu varchar 36  √  NULL::character varying C_PaymentBatch_UU
c_bp_bankaccount c_paymentprocessor_id numeric 10  √  NULL::numeric Payment processor for electronic payments
c_payment c_paymentprocessor_id numeric 10  √  NULL::numeric Payment processor for electronic payments
c_paymentbatch c_paymentprocessor_id numeric 10  √  null Payment processor for electronic payments
c_paymentprocessor c_paymentprocessor_id numeric 10 Payment processor for electronic payments
c_paymentprocessor c_paymentprocessor_uu varchar 36  √  NULL::character varying C_PaymentProcessor_UU
c_bpartner c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_invoice c_paymentterm_id numeric 10 The terms of Payment (timing, discount)
c_order c_paymentterm_id numeric 10 The terms of Payment (timing, discount)
c_paymentterm c_paymentterm_id numeric 10 The terms of Payment (timing, discount)
c_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_payselection c_payselection_id numeric 10 Payment Selection
c_payselectioncheck c_payselection_id numeric 10 Payment Selection
c_payselectionline c_payselection_id numeric 10 Payment Selection
c_payselection c_payselection_uu varchar 36  √  NULL::character varying C_PaySelection_UU
c_payselectioncheck c_payselectioncheck_id numeric 10 Payment Selection Check
c_payselectionline c_payselectioncheck_id numeric 10  √  null Payment Selection Check
c_payselectioncheck c_payselectioncheck_uu varchar 36  √  NULL::character varying C_PaySelectionCheck_UU
c_payselectionline c_payselectionline_id numeric 10 Payment Selection Line
c_payselectionline c_payselectionline_uu varchar 36  √  NULL::character varying C_PaySelectionLine_UU
c_project c_phase_id numeric 10  √  null Standard Phase of the Project Type
c_order c_pos_id numeric 10  √  null Point of Sales Terminal
c_payment c_postendertype_id numeric 10  √  NULL::numeric POS Tender Type
c_cash c_project_id numeric 10  √  null Financial Project
c_invoice c_project_id numeric 10  √  null Financial Project
c_order 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
c_project c_project_uu varchar 36  √  NULL::character varying C_Project_UU
c_project c_projecttype_id numeric 10  √  null Type of the project
c_charge c_taxcategory_id numeric 10  √  null Tax Category
c_bpartner c_taxgroup_id numeric 10  √  null Tax Group
c_cashline cashtype bpchar 1 Source of Cash
c_bankstatementline chargeamt numeric 0 0 Charge Amount
c_charge chargeamt numeric 0 0 Charge Amount
c_invoice chargeamt numeric 0  √  0 Charge Amount
c_order chargeamt numeric 0  √  0 Charge Amount
c_payment chargeamt numeric 0  √  0 Charge Amount
i_payment chargeamt numeric 0  √  0 Charge Amount
i_payment chargename varchar 60  √  null Name of the Charge
c_payment checkno varchar 20  √  null Check Number
i_payment checkno varchar 20  √  null Check Number
c_paymentprocessor commission numeric 0 Commission stated as a percentage
c_project committedamt numeric 0 0 The (legal) commitment amount
c_project committedqty numeric 0 0 The (legal) commitment Quantity
c_payment convertedamt numeric 0  √  null Converted Amount
c_invoice copyfrom bpchar 1  √  null Copy From Record
c_order copyfrom bpchar 1  √  null Copy From Record
c_project copyfrom bpchar 1  √  null Copy From Record
c_currency costingprecision numeric 10 Rounding used costing calculations
c_paymentprocessor costpertrx numeric 0 0 Fixed cost per transaction
c_allocationhdr created timestamp 29,6 now() Date this record was created
c_allocationline created timestamp 29,6 now() Date this record was created
c_bank created timestamp 29,6 now() Date this record was created
c_bankaccount created timestamp 29,6 now() Date this record was created
c_bankstatementline created timestamp 29,6 now() Date this record was created
c_bp_bankaccount created timestamp 29,6 now() Date this record was created
c_bpartner created timestamp 29,6 now() Date this record was created
c_cash created timestamp 29,6 now() Date this record was created
c_cashline created timestamp 29,6 now() Date this record was created
c_charge created timestamp 29,6 now() Date this record was created
c_currency created timestamp 29,6 now() Date this record was created
c_depositbatch created timestamp 29,6 statement_timestamp() Date this record was created
c_depositbatchline created timestamp 29,6 statement_timestamp() 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_order created timestamp 29,6 now() Date this record was created
c_payment created timestamp 29,6 now() Date this record was created
c_paymentallocate created timestamp 29,6 now() Date this record was created
c_paymentbatch created timestamp 29,6 now() Date this record was created
c_paymentprocessor 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_payselection created timestamp 29,6 now() Date this record was created
c_payselectioncheck created timestamp 29,6 now() Date this record was created
c_payselectionline created timestamp 29,6 now() Date this record was created
c_project created timestamp 29,6 now() Date this record was created
i_payment created timestamp 29,6 statement_timestamp() Date this record was created
c_allocationhdr createdby numeric 10 User who created this records
c_allocationline createdby numeric 10 User who created this records
c_bank createdby numeric 10 User who created this records
c_bankaccount createdby numeric 10 User who created this records
c_bankstatementline createdby numeric 10 User who created this records
c_bp_bankaccount createdby numeric 10 User who created this records
c_bpartner createdby numeric 10 User who created this records
c_cash createdby numeric 10 User who created this records
c_cashline createdby numeric 10 User who created this records
c_charge createdby numeric 10 User who created this records
c_currency createdby numeric 10 User who created this records
c_depositbatch createdby numeric 10 User who created this records
c_depositbatchline 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_order createdby numeric 10 User who created this records
c_payment createdby numeric 10 User who created this records
c_paymentallocate createdby numeric 10 User who created this records
c_paymentbatch createdby numeric 10 User who created this records
c_paymentprocessor 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_payselection createdby numeric 10 User who created this records
c_payselectioncheck createdby numeric 10 User who created this records
c_payselectionline createdby numeric 10 User who created this records
c_project createdby numeric 10 User who created this records
i_payment createdby numeric 10  √  null User who created this records
c_depositbatch createfrom bpchar 1  √  NULL::bpchar Process which will generate a new document lines based on an existing document
c_invoice createfrom bpchar 1  √  null Process which will generate a new document lines based on an existing document
c_payselection createfrom bpchar 1  √  null Process which will generate a new document lines based on an existing document
c_bankstatementline createpayment bpchar 1  √  null Create Payment
c_bp_bankaccount creditcardexpmm numeric 10  √  null Expiry Month
c_payment creditcardexpmm numeric 10  √  null Expiry Month
i_payment creditcardexpmm numeric 10  √  null Expiry Month
c_bp_bankaccount creditcardexpyy numeric 10  √  null Expiry Year
c_payment creditcardexpyy numeric 10  √  null Expiry Year
i_payment creditcardexpyy numeric 10  √  null Expiry Year
c_bp_bankaccount creditcardnumber varchar 20  √  null Credit Card Number
c_payment creditcardnumber varchar 20  √  null Credit Card Number
i_payment creditcardnumber varchar 20  √  null Credit Card Number
c_bp_bankaccount creditcardtype bpchar 1  √  null Credit Card (Visa, MC, AmEx)
c_payment creditcardtype bpchar 1  √  null Credit Card (Visa, MC, AmEx)
i_payment creditcardtype bpchar 1  √  null Credit Card (Visa, MC, AmEx)
c_bp_bankaccount creditcardvv varchar 4  √  null Credit Card Verification code on credit card
c_payment creditcardvv varchar 4  √  null Credit Card Verification code on credit card
i_payment creditcardvv varchar 4  √  null Credit Card Verification code on credit card
c_bankaccount creditlimit numeric 0 0 Amount of Credit allowed
c_invoice currencyrate numeric 0  √  null Currency Conversion Rate
c_payment currencyrate numeric 0  √  null Currency Conversion Rate
c_bankaccount currentbalance numeric 0 0 Current Balance
c_currency cursymbol varchar 10  √  null Symbol of the currency (opt used for printing only)
c_payment customeraddressid varchar 60  √  NULL::character varying Customer Address ID
c_bp_bankaccount customerpaymentprofileid varchar 60  √  NULL::character varying Customer Payment Profile 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
c_allocationhdr dateacct timestamp 29,6 Accounting Date
c_bankstatementline dateacct timestamp 29,6 Accounting Date
c_cash dateacct timestamp 29,6 Accounting Date
c_invoice dateacct timestamp 29,6 Accounting Date
c_order dateacct timestamp 29,6 Accounting Date
c_payment dateacct timestamp 29,6 Accounting Date
i_payment dateacct timestamp 29,6  √  null Accounting Date
c_project datecontract timestamp 29,6  √  null The (planned) effective date of this document.
c_depositbatch datedeposit timestamp 29,6 Deposit Date
c_depositbatch 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_invoice dateordered timestamp 29,6  √  null Date of Order
c_order dateordered timestamp 29,6 Date of Order
c_invoice dateprinted timestamp 29,6  √  null Date the document was printed.
c_order dateprinted timestamp 29,6  √  null Date the document was printed.
c_order datepromised timestamp 29,6  √  null Date Order was promised
c_allocationhdr datetrx timestamp 29,6 Transaction Date
c_allocationline datetrx timestamp 29,6  √  null Transaction Date
c_payment datetrx timestamp 29,6 Transaction Date
i_payment datetrx timestamp 29,6  √  null Transaction Date
c_bpartner default1099box_id numeric 10  √  NULL::numeric Default 1099 Box
c_doctype definitesequence_id numeric 10  √  null Definite Sequence
c_bpartner deliveryrule bpchar 1  √  null Defines the timing of Delivery
c_order deliveryrule bpchar 1 Defines the timing of Delivery
c_bpartner deliveryviarule bpchar 1  √  null How the order will be delivered
c_order deliveryviarule bpchar 1 How the order will be delivered
c_depositbatch depositamt numeric 0 Deposit Amount
c_allocationhdr description varchar 255  √  null Optional short description of the record
c_bank description varchar 255  √  null Optional short description of the record
c_bankaccount description varchar 255  √  null Optional short description of the record
c_bankstatementline description varchar 255  √  null Optional short description of the record
c_bpartner description varchar 255  √  null Optional short description of the record
c_cash description varchar 255  √  null Optional short description of the record
c_cashline description varchar 255  √  null Optional short description of the record
c_charge description varchar 255  √  null Optional short description of the record
c_currency description varchar 255 Optional short description of the record
c_depositbatch description varchar 255  √  NULL::character varying 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_order description varchar 255  √  null Optional short description of the record
c_payment description varchar 255  √  null Optional short description of the record
c_paymentprocessor description varchar 255  √  null Optional short description of the record
c_paymentterm description varchar 255  √  null Optional short description of the record
c_payselection description varchar 255  √  null Optional short description of the record
c_payselectionline description varchar 255  √  null Optional short description of the record
c_project description varchar 255  √  null Optional short description of the record
c_payselectionline differenceamt numeric 0 0 Difference Amount
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_allocationline discountamt numeric 0 0 Calculated amount of discount
c_cashline discountamt numeric 0  √  0 Calculated amount of discount
c_invoicepayschedule discountamt numeric 0 0 Calculated amount of discount
c_payment discountamt numeric 0  √  0 Calculated amount of discount
c_paymentallocate discountamt numeric 0 0 Calculated amount of discount
c_payselectioncheck discountamt numeric 0 0 Calculated amount of discount
c_payselectionline discountamt numeric 0 0 Calculated amount of discount
i_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_allocationhdr docaction bpchar 2 The targeted status of the document
c_cash docaction bpchar 2 The targeted status of the document
c_invoice docaction bpchar 2 The targeted status of the document
c_order docaction bpchar 2 The targeted status of the document
c_payment docaction bpchar 2 The targeted status of the document
c_doctype docbasetype bpchar 3 Logical type of document
c_doctype docnosequence_id numeric 10  √  null Document sequence determines the numbering of documents
c_allocationhdr docstatus bpchar 2 The current status of the document
c_cash docstatus bpchar 2 The current status of the document
c_depositbatch docstatus varchar 2 'DR'::character varying The current status of the document
c_invoice docstatus bpchar 2 The current status of the document
c_order docstatus bpchar 2 The current status of the document
c_payment docstatus bpchar 2 The current status of the document
c_doctype docsubtypeinv varchar 2  √  NULL::character varying Inventory Sub Type
c_doctype docsubtypeso bpchar 2  √  null Sales Order Sub Type
i_payment doctypename varchar 60  √  null Name of the Document Type
c_bpartner documentcopies numeric 10  √  null Number of copies to be printed
c_doctype documentcopies numeric 10 Number of copies to be printed
c_allocationhdr documentno varchar 30 Document sequence number of the document
c_depositbatch documentno varchar 30 Document sequence number of the document
c_invoice documentno varchar 30 Document sequence number of the document
c_order documentno varchar 30 Document sequence number of the document
c_payment documentno varchar 30 Document sequence number of the document
c_paymentbatch documentno varchar 30  √  null Document sequence number of the document
c_payselectioncheck documentno varchar 30  √  null Document sequence number of the document
i_payment documentno varchar 30  √  null Document sequence number of the document
c_doctype documentnote varchar 2000  √  null Additional information for a Document
c_paymentterm documentnote varchar 2000  √  null Additional information for a Document
c_order dropship_bpartner_id numeric 10  √  null Business Partner to ship to
c_order dropship_location_id numeric 10  √  null Business Partner Location for shipping to
c_order dropship_user_id numeric 10  √  null Business Partner Contact for drop shipment
c_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_bankstatementline eftamt numeric 0  √  0 Electronic Funds Transfer Amount
c_bankstatementline eftcheckno varchar 20  √  null Electronic Funds Transfer Check No
c_bankstatementline eftcurrency varchar 20  √  null Electronic Funds Transfer Currency
c_bankstatementline eftmemo varchar 2000  √  null Electronic Funds Transfer Memo
c_bankstatementline eftpayee varchar 255  √  null Electronic Funds Transfer Payee information
c_bankstatementline eftpayeeaccount varchar 40  √  null Electronic Funds Transfer Payee Account Information
c_bankstatementline eftreference varchar 60  √  null Electronic Funds Transfer Reference
c_bankstatementline eftstatementlinedate timestamp 29,6  √  null Electronic Funds Transfer Statement Line Date
c_bankstatementline efttrxid varchar 40  √  null Electronic Funds Transfer Transaction ID
c_bankstatementline efttrxtype varchar 20  √  null Electronic Funds Transfer Transaction Type
c_bankstatementline eftvalutadate timestamp 29,6  √  null Electronic Funds Transfer Valuta (effective) Date
c_currency emuentrydate timestamp 29,6  √  null Date when the currency joined / will join the EMU
c_currency emurate numeric 0  √  0 Official rate to the Euro
c_cash endingbalance numeric 0 0 Ending or closing balance
c_bpartner firstsale timestamp 29,6  √  null Date of First Sale
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
c_order freightamt numeric 0  √  0 Freight Amount
c_bpartner freightcostrule bpchar 1  √  null Method for charging Freight
c_order freightcostrule bpchar 1 Method for charging Freight
c_invoice generateto bpchar 1  √  null Generate To
c_project generateto bpchar 1  √  null Generate To
c_doctype gl_category_id numeric 10 General Ledger Category
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
c_order grandtotal numeric 0 0 Total amount of document
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
c_paymentprocessor hostaddress varchar 60  √  null Host Address URL or DNS
c_paymentprocessor hostport numeric 10  √  null Host Communication Port
i_payment i_errormsg varchar 2000  √  null Messages generated from import process
i_payment i_isimported bpchar 1 'N'::bpchar Has this import been processed
i_payment i_payment_id numeric 10 Import Payment
i_payment i_payment_uu varchar 36  √  NULL::character varying I_Payment_UU
c_bankaccount iban varchar 40  √  null International Bank Account Number
c_bp_bankaccount iban varchar 40  √  NULL::character varying International Bank Account Number
c_payment iban varchar 40  √  NULL::character varying International Bank Account Number
i_payment iban varchar 40  √  NULL::character varying International Bank Account Number
c_bankstatementline interestamt numeric 0 0 Interest Amount
c_bpartner invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
c_paymentallocate invoiceamt numeric 0  √  0 Invoice Amt
c_invoice invoicecollectiontype bpchar 1  √  null Invoice Collection Status
c_project invoicedamt numeric 0 0 The amount invoiced
i_payment invoicedocumentno varchar 30  √  null Document Number of the Invoice
c_project invoicedqty numeric 0 0 The quantity invoiced
c_bpartner invoicerule bpchar 1  √  null Frequency and method of invoicing
c_order invoicerule bpchar 1 Frequency and method of invoicing
c_bpartner is1099vendor bpchar 1 'N'::bpchar 1099 Vendor
c_bp_bankaccount isach bpchar 1 'N'::bpchar Automatic Clearing House
c_allocationhdr isactive bpchar 1 'Y'::bpchar The record is active in the system
c_allocationline isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bank isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bankaccount isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bankstatementline isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bp_bankaccount 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_cash isactive bpchar 1 'Y'::bpchar The record is active in the system
c_cashline 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_currency isactive bpchar 1 'Y'::bpchar The record is active in the system
c_depositbatch isactive bpchar 1 'Y'::bpchar The record is active in the system
c_depositbatchline 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_order 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_paymentallocate isactive bpchar 1 'Y'::bpchar The record is active in the system
c_paymentbatch isactive bpchar 1 'Y'::bpchar The record is active in the system
c_paymentprocessor 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_payselection isactive bpchar 1 'Y'::bpchar The record is active in the system
c_payselectioncheck isactive bpchar 1 'Y'::bpchar The record is active in the system
c_payselectionline 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
i_payment 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_allocationhdr isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
c_cash isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
c_invoice isapproved bpchar 1 'Y'::bpchar Indicates if this document requires approval
c_order isapproved bpchar 1 'Y'::bpchar Indicates if this document requires approval
c_payment isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
c_payselection isapproved bpchar 1 'Y'::bpchar Indicates if this document requires approval
i_payment isapproved bpchar 1  √  'N'::bpchar Indicates if this document requires approval
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_doctype iscreatecounter bpchar 1 'Y'::bpchar Create Counter Document
c_order iscreditapproved bpchar 1 'N'::bpchar Credit has been approved
c_bpartner iscustomer bpchar 1 'Y'::bpchar Indicates if this Business Partner is a Customer
c_bankaccount isdefault bpchar 1 'N'::bpchar Default value
c_doctype isdefault bpchar 1 'N'::bpchar Default value
c_paymentterm isdefault bpchar 1  √  'N'::bpchar Default value
c_doctype isdefaultcounterdoc bpchar 1 'N'::bpchar The document type is the default counter document type
c_payment isdelayedcapture bpchar 1 'N'::bpchar Charge after Shipment
i_payment isdelayedcapture bpchar 1  √  'N'::bpchar Charge after Shipment
c_order isdelivered bpchar 1 'N'::bpchar Delivered
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar Print Discount on Invoice and Order
c_invoice isdiscountprinted bpchar 1 'Y'::bpchar Print Discount on Invoice and Order
c_order isdiscountprinted bpchar 1 'Y'::bpchar Print Discount on Invoice and Order
c_doctype isdocnocontrolled bpchar 1 'N'::bpchar The document has a document sequence
c_order 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
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
c_invoice isfixedassetinvoice bpchar 1  √  null IsFixedAssetInvoice
c_cashline isgenerated bpchar 1  √  'N'::bpchar This Line is generated
c_payselectioncheck isgenerateddraft bpchar 1 'N'::bpchar Generated Draft
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
c_doctype isintransit bpchar 1 'N'::bpchar Movement is in transit
c_order isinvoiced bpchar 1 'N'::bpchar Is this invoiced?
c_allocationhdr ismanual bpchar 1 'N'::bpchar This is a manual process
c_allocationline ismanual bpchar 1  √  'N'::bpchar This is a manual process
c_bankstatementline ismanual bpchar 1 'N'::bpchar This is a manual process
c_payselectionline ismanual bpchar 1 'Y'::bpchar This is a manual process
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_doctype isnopricelistcheck bpchar 1  √  'N'::bpchar Allow Product Without Pricelist
c_currency iso_code bpchar 3 Three letter ISO 4217 Code of the Currency
i_payment iso_code bpchar 3  √  null Three letter ISO 4217 Code of the Currency
c_payselection isonepaymentperinvoice bpchar 1  √  'N'::bpchar One Payment Per Invoice
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)
i_payment isoverunderpayment bpchar 1  √  'N'::bpchar Over-Payment (unallocated) or Under-Payment (partial payment)
c_doctype isoverwritedateoncomplete bpchar 1  √  'N'::bpchar Overwrite Date on Complete
c_doctype isoverwriteseqoncomplete bpchar 1  √  'N'::bpchar Overwrite Sequence on Complete
c_bank isownbank bpchar 1 'N'::bpchar Bank for this Organization
c_invoice ispaid bpchar 1 'N'::bpchar The document is paid
c_invoice ispayschedulevalid bpchar 1 'N'::bpchar Is the Payment Schedule is valid
c_order ispayschedulevalid bpchar 1 'N'::bpchar Is the Payment Schedule is valid
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_payment isprepayment bpchar 1 'N'::bpchar The Payment/Receipt is a Prepayment
c_invoice isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
c_order isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
c_payselectioncheck isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
c_order ispriviledgedrate bpchar 1 'N'::bpchar Priviledged Rate
c_bpartner isprospect bpchar 1 'N'::bpchar Indicates this is a Prospect
c_payment isreceipt bpchar 1 'Y'::bpchar This is a sales transaction (receipt)
c_payselectioncheck isreceipt bpchar 1 'N'::bpchar This is a sales transaction (receipt)
i_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_bankstatementline isreversal bpchar 1 'N'::bpchar This is a reversing transaction
c_bpartner issalesrep bpchar 1 'N'::bpchar Indicates if the business partner is a sales representative or company agent
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_order isselected bpchar 1 'N'::bpchar Selected
c_invoice isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
c_order isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
c_payment isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
i_payment isselfservice bpchar 1  √  'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
c_doctype isshipconfirm bpchar 1 'N'::bpchar Require Ship or Receipt Confirmation before processing
c_doctype issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
c_invoice issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
c_order issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
c_payselectionline issotrx bpchar 1 'N'::bpchar This is a Sales Transaction
c_doctype issplitwhendifference bpchar 1 'N'::bpchar Split document when there is a difference
c_bpartner 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_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_order istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
c_invoice istransferred bpchar 1 'N'::bpchar Transferred to General Ledger (i.e. accounted)
c_order istransferred bpchar 1 'N'::bpchar Transferred to General Ledger (i.e. accounted)
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
c_payment isvoided bpchar 1 'N'::bpchar Voided
c_bankstatementline line numeric 10 Unique line for this document
c_cashline line numeric 10 Unique line for this document
c_depositbatchline line numeric 10 Unique line for this document
c_payselectionline line numeric 10 Unique line for this document
c_order link_order_id numeric 10  √  null This field links a sales order to the purchase order that is generated from it.
c_bpartner logo_id numeric 10  √  NULL::numeric Logo
c_bpartner m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
c_order m_freightcategory_id numeric 10  √  NULL::numeric Category of the Freight
c_bpartner m_pricelist_id numeric 10  √  null Unique identifier of a Price List
c_invoice m_pricelist_id numeric 10 Unique identifier of a Price List
c_order m_pricelist_id numeric 10 Unique identifier of a Price List
c_project m_pricelist_version_id numeric 10  √  null Identifies a unique instance of a Price List
c_invoice m_rma_id numeric 10  √  null Return Material Authorization
c_order m_shipper_id numeric 10  √  null Method or manner of product delivery
c_order m_warehouse_id numeric 10 Storage Warehouse and Service Point
c_project m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
c_bankstatementline matchstatement bpchar 1  √  null Match Statement
c_bankstatementline memo varchar 255  √  null Memo Text
c_payment micr varchar 20  √  null Combination of routing no, account and check no
i_payment micr varchar 20  √  null Combination of routing no, account and check no
c_paymentprocessor minimumamt numeric 0  √  0 Minimum Amount in Document Currency
c_bpartner naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_bank name varchar 60 Alphanumeric identifier of the entity
c_bankaccount name varchar 60 NULL::character varying Alphanumeric identifier of the entity
c_bpartner name varchar 120 Alphanumeric identifier of the entity
c_cash name varchar 60 Alphanumeric identifier of the entity
c_charge name varchar 60 Alphanumeric identifier of the entity
c_doctype name varchar 60 Alphanumeric identifier of the entity
c_paymentbatch name varchar 60 Alphanumeric identifier of the entity
c_paymentprocessor name varchar 60 Alphanumeric identifier of the entity
c_paymentterm name varchar 60 Alphanumeric identifier of the entity
c_payselection name varchar 120 Alphanumeric identifier of the entity
c_project name varchar 60 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_project note varchar 2000  √  null Optional additional user defined information
c_bpartner numberemployees numeric 10  √  null Number of employees
c_payselectionline openamt numeric 0 0 Open item amount
c_payment oprocessing bpchar 1  √  null This payment can be processed online
c_order ordertype varchar 510  √  null Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition)
c_payment orig_trxid varchar 20  √  null Original Transaction ID
i_payment orig_trxid varchar 20  √  null Original Transaction ID
c_allocationline overunderamt numeric 0  √  0 Over-Payment (unallocated) or Under-Payment (partial payment) Amount
c_payment overunderamt numeric 0  √  0 Over-Payment (unallocated) or Under-Payment (partial payment) Amount
c_paymentallocate overunderamt numeric 0 0 Over-Payment (unallocated) or Under-Payment (partial payment) Amount
i_payment overunderamt numeric 0  √  0 Over-Payment (unallocated) or Under-Payment (partial payment) Amount
c_order pay_bpartner_id numeric 10  √  null Business Partner responsible for the payment
c_order pay_location_id numeric 10  √  null Location of the Business Partner responsible for the payment
c_depositbatchline payamt numeric 0 Amount being paid
c_payment payamt numeric 0 0 Amount being paid
c_payselectioncheck payamt numeric 0 0 Amount being paid
c_payselectionline payamt numeric 0 0 Amount being paid
i_payment payamt numeric 0  √  0 Amount being paid
c_payselection paydate timestamp 29,6 Date Payment made
c_bankaccount paymentexportclass varchar 60  √  NULL::character varying Payment Export Class
c_bpartner paymentrule bpchar 1  √  null How you pay the invoice
c_invoice paymentrule bpchar 1 How you pay the invoice
c_order paymentrule bpchar 1 How you pay the invoice
c_payselectioncheck paymentrule bpchar 1 How you pay the invoice
c_payselectionline 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_paymentprocessor payprocessorclass varchar 60  √  null Payment Processor Java Class
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 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
i_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_order poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_project poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_allocationhdr posted bpchar 1 'N'::bpchar Posting status
c_cash posted bpchar 1 'N'::bpchar Posting status
c_invoice posted bpchar 1 'N'::bpchar Posting status
c_order posted bpchar 1 'N'::bpchar Posting status
c_payment posted bpchar 1 'N'::bpchar Posting status
c_bpartner potentiallifetimevalue numeric 0  √  0 Total Revenue expected
c_doctype printname varchar 60 The label text to be printed on a document or correspondence.
c_order priorityrule bpchar 1 Priority of a document
c_allocationhdr processed bpchar 1 'N'::bpchar The document has been processed
c_bankstatementline processed bpchar 1 'N'::bpchar The document has been processed
c_cash processed bpchar 1 'N'::bpchar The document has been processed
c_cashline processed bpchar 1 'N'::bpchar The document has been processed
c_depositbatch processed bpchar 1 The document has been processed
c_depositbatchline processed bpchar 1 The document has been processed
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_order processed bpchar 1 'N'::bpchar The document has been processed
c_payment processed bpchar 1 'N'::bpchar The document has been processed
c_paymentbatch processed bpchar 1 'N'::bpchar The document has been processed
c_payselection processed bpchar 1 'N'::bpchar The document has been processed
c_payselectioncheck processed bpchar 1 'N'::bpchar The document has been processed
c_payselectionline processed bpchar 1 'N'::bpchar The document has been processed
c_project processed bpchar 1 'N'::bpchar The document has been processed
i_payment processed bpchar 1  √  'N'::bpchar The document has been processed
c_allocationhdr processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
c_cash processedon numeric 0  √  null The date+time (expressed in decimal format) when 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_order 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
c_allocationhdr processing bpchar 1  √  null Process Now
c_cash processing bpchar 1  √  null Process Now
c_depositbatch processing bpchar 1  √  NULL::bpchar Process Now
c_depositbatchline processing bpchar 1 Process Now
c_invoice processing bpchar 1  √  null Process Now
c_invoicepayschedule processing bpchar 1  √  null Process Now
c_order processing bpchar 1  √  null Process Now
c_payment processing bpchar 1  √  null Process Now
c_paymentbatch processing bpchar 1 Process Now
c_paymentterm processing bpchar 1  √  null Process Now
c_payselection processing bpchar 1  √  null Process Now
c_project processing bpchar 1  √  null Process Now
i_payment processing bpchar 1  √  null Process Now
c_paymentbatch processingdate timestamp 29,6  √  null Processing date
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_order promotioncode varchar 30  √  null User entered promotion code at sales time
c_paymentprocessor proxyaddress varchar 60  √  null Address of your proxy server
c_paymentprocessor proxylogon varchar 60  √  null Logon of your proxy server
c_paymentprocessor proxypassword varchar 60  √  null Password of your proxy server
c_paymentprocessor proxyport numeric 10  √  null Port of your proxy server
c_payselectioncheck qty numeric 0 0 Quantity
c_order quotationorder_id numeric 10  √  NULL::numeric Quotation used for generating this order
c_payment r_authcode varchar 20  √  null Authorization Code returned
i_payment r_authcode varchar 20  √  null Authorization Code returned
c_payment r_authcode_dc varchar 20  √  null Authorization Code Delayed Capture returned
c_bp_bankaccount r_avsaddr bpchar 1  √  null This address has been verified
c_payment r_avsaddr bpchar 1  √  null This address has been verified
c_bp_bankaccount r_avszip bpchar 1  √  null The Zip Code 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
i_payment r_info varchar 2000  √  null Response info
c_payment r_pnref varchar 20  √  null Payment reference
i_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
i_payment r_respmsg varchar 60  √  null Response message
c_payment r_result varchar 20  √  null Result of transmission
i_payment r_result varchar 20  √  null Result of transmission
c_payment r_voidmsg varchar 255  √  NULL::character varying Void Message
c_bpartner rating bpchar 1  √  null Classification or Importance
c_invoice ref_invoice_id numeric 10  √  null Referenced Invoice
c_order ref_order_id numeric 10  √  null Reference to corresponding Sales/Purchase Order
c_payment ref_payment_id numeric 10  √  null Referenced Payment
c_bankstatementline referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
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_paymentprocessor requirevv bpchar 1 'N'::bpchar Require 3/4 digit Credit Verification Code
c_allocationhdr reversal_id numeric 10  √  NULL::numeric ID of document reversal
c_invoice reversal_id numeric 10  √  null ID of document reversal
c_payment reversal_id numeric 10  √  null ID of document reversal
c_currency roundofffactor numeric 0  √  null Used to Round Off Payment Amount
c_bank routingno varchar 20 Bank Routing Number
c_bp_bankaccount routingno varchar 20  √  null Bank Routing Number
c_payment routingno varchar 20  √  null Bank Routing Number
i_payment routingno varchar 20  √  null Bank Routing Number
c_bpartner salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_invoice salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_order salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_project salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_bpartner salesvolume numeric 10  √  null Total Volume of Sales in Thousands of Currency
c_bpartner sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_invoice sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_order sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_bpartner shareofcustomer numeric 10  √  null Share of Customer's business as a percentage
c_bpartner shelflifeminpct numeric 10  √  null Minimum Shelf Life in percent based on Product Instance Guarantee Date
c_order shippingrateinquiry bpchar 1  √  NULL::bpchar Rate Inquiry
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_cash statementdate timestamp 29,6 Date of the statement
c_cash statementdifference numeric 0  √  0 Difference between statement ending balance and actual ending balance
c_bankstatementline statementlinedate timestamp 29,6 Date of the Statement Line
c_currency stdprecision numeric 10 Rule for rounding calculated amounts
c_bankstatementline stmtamt numeric 0 0 Statement Amount
c_bank swiftcode varchar 20  √  null Swift Code or BIC
c_payment swiftcode varchar 20  √  NULL::character varying Swift Code or BIC
i_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
i_payment swipe varchar 80  √  null Track 1 and 2 of the Credit Card
c_payment taxamt numeric 0  √  0 Tax Amount for a document
i_payment taxamt numeric 0  √  0 Tax Amount for a document
c_bpartner taxid varchar 20  √  null Tax Identification
c_payment tendertype bpchar 1 Method of Payment
i_payment tendertype bpchar 1  √  null Method of Payment
c_payselection totalamt numeric 0 0 Total Amount
c_invoice totallines numeric 0 0 Total of all document lines
c_order totallines numeric 0 0 Total of all document lines
c_bpartner totalopenbalance numeric 0  √  null Total Open Balance Amount in primary Accounting Currency
c_bankstatementline trxamt numeric 0 0 Amount of a transaction
c_payment trxtype bpchar 1 Type of credit card transaction
c_paymentprocessor trxtype bpchar 1  √  NULL::bpchar Type of credit card transaction
i_payment trxtype bpchar 1  √  null Type of credit card transaction
c_allocationhdr updated timestamp 29,6 now() Date this record was updated
c_allocationline updated timestamp 29,6 now() Date this record was updated
c_bank updated timestamp 29,6 now() Date this record was updated
c_bankaccount updated timestamp 29,6 now() Date this record was updated
c_bankstatementline updated timestamp 29,6 now() Date this record was updated
c_bp_bankaccount updated timestamp 29,6 now() Date this record was updated
c_bpartner updated timestamp 29,6 now() Date this record was updated
c_cash updated timestamp 29,6 now() Date this record was updated
c_cashline updated timestamp 29,6 now() Date this record was updated
c_charge updated timestamp 29,6 now() Date this record was updated
c_currency updated timestamp 29,6 now() Date this record was updated
c_depositbatch updated timestamp 29,6 statement_timestamp() Date this record was updated
c_depositbatchline updated timestamp 29,6 statement_timestamp() 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_order updated timestamp 29,6 now() Date this record was updated
c_payment updated timestamp 29,6 now() Date this record was updated
c_paymentallocate updated timestamp 29,6 now() Date this record was updated
c_paymentbatch updated timestamp 29,6 now() Date this record was updated
c_paymentprocessor 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_payselection updated timestamp 29,6 now() Date this record was updated
c_payselectioncheck updated timestamp 29,6 now() Date this record was updated
c_payselectionline updated timestamp 29,6 now() Date this record was updated
c_project updated timestamp 29,6 now() Date this record was updated
i_payment updated timestamp 29,6 statement_timestamp() Date this record was updated
c_allocationhdr updatedby numeric 10 User who updated this records
c_allocationline updatedby numeric 10 User who updated this records
c_bank updatedby numeric 10 User who updated this records
c_bankaccount updatedby numeric 10 User who updated this records
c_bankstatementline updatedby numeric 10 User who updated this records
c_bp_bankaccount updatedby numeric 10 User who updated this records
c_bpartner updatedby numeric 10 User who updated this records
c_cash updatedby numeric 10 User who updated this records
c_cashline updatedby numeric 10 User who updated this records
c_charge updatedby numeric 10 User who updated this records
c_currency updatedby numeric 10 User who updated this records
c_depositbatch updatedby numeric 10 User who updated this records
c_depositbatchline 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_order updatedby numeric 10 User who updated this records
c_payment updatedby numeric 10 User who updated this records
c_paymentallocate updatedby numeric 10 User who updated this records
c_paymentbatch updatedby numeric 10 User who updated this records
c_paymentprocessor 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_payselection updatedby numeric 10 User who updated this records
c_payselectioncheck updatedby numeric 10 User who updated this records
c_payselectionline updatedby numeric 10 User who updated this records
c_project updatedby numeric 10 User who updated this records
i_payment updatedby numeric 10  √  null User who updated this records
c_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
c_cash user1_id numeric 10  √  null User defined list element #1
c_invoice user1_id numeric 10  √  null User defined list element #1
c_order user1_id numeric 10  √  null User defined list element #1
c_payment user1_id numeric 10  √  null User defined list element #1
c_cash user2_id numeric 10  √  null User defined list element #2
c_invoice user2_id numeric 10  √  null User defined list element #2
c_order user2_id numeric 10  √  null User defined list element #2
c_payment user2_id numeric 10  √  null User defined list element #2
c_bankaccount value varchar 40 NULL::character varying Search key for the record in the format required - must be unique
c_bpartner value varchar 40 Search key for the record in the format required - must be unique
c_paymentterm value varchar 40 Search key for the record in the format required - must be unique
c_project value varchar 40 Search key for the record in the format required - must be unique
c_bankstatementline valutadate timestamp 29,6 Date when money is available
c_payment voiceauthcode varchar 20  √  null Voice Authorization Code from credit card company
i_payment voiceauthcode varchar 20  √  null Voice Authorization Code from credit card company
c_order volume numeric 0  √  null Volume of a product
c_order weight numeric 0  √  null Weight of a product
c_allocationline writeoffamt numeric 0 0 Amount to write-off
c_cashline writeoffamt numeric 0  √  0 Amount to write-off
c_payment writeoffamt numeric 0  √  0 Amount to write-off
c_paymentallocate writeoffamt numeric 0 0 Amount to write-off
c_payselectioncheck writeoffamt numeric 0 (0)::numeric Amount to write-off
c_payselectionline writeoffamt numeric 0 (0)::numeric Amount to write-off
i_payment writeoffamt numeric 0  √  0 Amount to write-off