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

idempiere9.adempiere contains 562 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
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 bankaccounttype bpchar 1 Bank Account Type
c_bankstatement copyfrom bpchar 1  √  'N'::bpchar Copy From Record
c_invoice copyfrom bpchar 1  √  null Copy From Record
c_bankstatement createfrom bpchar 1  √  'N'::bpchar Process which will generate a new document lines based on an existing document
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_bankstatement createfrombatch bpchar 1  √  NULL::bpchar Create From Batch
c_bankstatementline createpayment bpchar 1  √  null Create Payment
i_bankstatement createpayment bpchar 1  √  null Create Payment
c_payment creditcardtype bpchar 1  √  null Credit Card (Visa, MC, AmEx)
c_bpartner deliveryrule bpchar 1  √  null Defines the timing of Delivery
c_bpartner deliveryviarule bpchar 1  √  null How the order will be delivered
c_bpartner freightcostrule bpchar 1  √  null Method for charging Freight
c_invoice generateto bpchar 1  √  null Generate To
i_bankstatement i_isimported bpchar 1 'N'::bpchar Has this import been processed
c_invoice invoicecollectiontype bpchar 1  √  null Invoice Collection Status
c_bpartner invoicerule bpchar 1  √  null Frequency and method of invoicing
c_bpartner is1099vendor bpchar 1 'N'::bpchar 1099 Vendor
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_bankaccountdoc isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bankstatement 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_bankstatementloader isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bankstatementmatcher 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_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_invoice 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_paymentprocessor isactive bpchar 1 'Y'::bpchar The record is active in the system
i_bankstatement 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_bankstatement 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_payment isapproved bpchar 1 'N'::bpchar Indicates if this document requires approval
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_payment isdelayedcapture bpchar 1 'N'::bpchar Charge after Shipment
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 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_invoice isindispute bpchar 1 'N'::bpchar Document is in dispute
c_bankstatement ismanual bpchar 1 'Y'::bpchar This is a manual process
c_bankstatementline ismanual bpchar 1 'N'::bpchar This is a manual process
c_bpartner ismanufacturer bpchar 1  √  'N'::bpchar Indicate role of this Business partner as Manufacturer
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)
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_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
c_invoice isprinted bpchar 1 'N'::bpchar Indicates if this document / line is printed
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_payment isreconciled bpchar 1 'N'::bpchar Payment is reconciled with bank statement
c_bankstatementline isreversal bpchar 1 'N'::bpchar This is a reversing transaction
i_bankstatement 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_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
c_invoice issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
c_bpartner issummary bpchar 1 'N'::bpchar This is a summary entity
c_bpartner istaxexempt bpchar 1  √  'N'::bpchar Business partner is exempt from tax on sales
c_invoice istaxincluded bpchar 1 'N'::bpchar Tax is included in the price
c_invoice istransferred bpchar 1 'N'::bpchar Transferred to General Ledger (i.e. accounted)
c_bpartner isvendor bpchar 1 'N'::bpchar Indicates if this Business Partner is a Vendor
c_payment isvoided bpchar 1 'N'::bpchar Voided
c_bankstatement matchstatement bpchar 1  √  null Match Statement
c_bankstatementline matchstatement bpchar 1  √  null Match Statement
i_bankstatement matchstatement bpchar 1  √  null Match Statement
c_payment oprocessing bpchar 1  √  null This payment can be processed online
c_bankaccountdoc paymentrule bpchar 1 How you pay the invoice
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_bankstatement posted bpchar 1 'N'::bpchar Posting status
c_invoice posted bpchar 1 'N'::bpchar Posting status
c_payment posted bpchar 1 'N'::bpchar Posting status
c_bankstatement processed bpchar 1 'N'::bpchar The document has been processed
c_bankstatementline 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_payment processed bpchar 1 'N'::bpchar The document has been processed
i_bankstatement processed bpchar 1  √  'N'::bpchar The document has been processed
c_bankstatement 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_payment processing bpchar 1  √  null Process Now
i_bankstatement processing bpchar 1  √  null Process Now
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_bpartner rating bpchar 1  √  null Classification or Importance
c_paymentprocessor requirevv bpchar 1 'N'::bpchar Require 3/4 digit Credit Verification Code
c_bpartner sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_invoice sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_bpartner socreditstatus bpchar 1  √  'O'::bpchar Business Partner Credit Status
c_payment tendertype bpchar 1 Method of Payment
c_payment trxtype bpchar 1 Type of credit card transaction
c_paymentprocessor trxtype bpchar 1  √  NULL::bpchar Type of credit card transaction
c_bankstatement docaction bpchar 2 The targeted status of the document
c_invoice docaction bpchar 2 The targeted status of the document
c_payment docaction bpchar 2 The targeted status of the document
c_bankstatement docstatus bpchar 2 The current 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
c_currency iso_code bpchar 3 Three letter ISO 4217 Code of the Currency
i_bankstatement iso_code bpchar 3  √  null Three letter ISO 4217 Code of the Currency
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_bankstatement beginningbalance numeric 0  √  0 Balance prior to any transactions
c_bankstatementline chargeamt numeric 0 0 Charge Amount
c_invoice chargeamt numeric 0  √  0 Charge Amount
c_payment chargeamt numeric 0  √  0 Charge Amount
i_bankstatement chargeamt numeric 0  √  0 Charge Amount
c_paymentprocessor commission numeric 0 Commission stated as a percentage
c_payment convertedamt numeric 0  √  null Converted Amount
c_paymentprocessor costpertrx numeric 0 0 Fixed cost per transaction
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_depositbatch depositamt numeric 0 Deposit Amount
c_payment discountamt numeric 0  √  0 Calculated amount of discount
c_bankstatementline eftamt numeric 0  √  0 Electronic Funds Transfer Amount
i_bankstatement eftamt numeric 0  √  0 Electronic Funds Transfer Amount
c_currency emurate numeric 0  √  0 Official rate to the Euro
c_bankstatement endingbalance numeric 0 0 Ending or closing balance
c_bpartner flatdiscount numeric 0  √  null Flat discount percentage
c_invoice grandtotal numeric 0 0 Total amount of document
c_bankstatementline interestamt numeric 0 0 Interest Amount
i_bankstatement interestamt numeric 0  √  0 Interest Amount
c_paymentprocessor minimumamt numeric 0  √  0 Minimum Amount in Document Currency
c_payment overunderamt numeric 0  √  0 Over-Payment (unallocated) or Under-Payment (partial payment) Amount
c_depositbatchline payamt numeric 0 Amount being paid
c_payment payamt numeric 0 0 Amount being paid
c_bpartner potentiallifetimevalue numeric 0  √  0 Total Revenue expected
c_bankstatement 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_payment processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
c_currency roundofffactor numeric 0  √  null Used to Round Off Payment Amount
c_bpartner so_creditlimit numeric 0  √  0 Total outstanding invoice amounts allowed
c_bpartner so_creditused numeric 0  √  0 Current open balance
c_bankstatement statementdifference numeric 0  √  0 Difference between statement ending balance and actual ending balance
c_bankstatementline stmtamt numeric 0 0 Statement Amount
i_bankstatement stmtamt numeric 0  √  0 Statement Amount
c_payment taxamt numeric 0  √  0 Tax Amount for a document
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
c_bankstatementline trxamt numeric 0 0 Amount of a transaction
i_bankstatement trxamt numeric 0  √  0 Amount of a transaction
c_payment writeoffamt numeric 0  √  0 Amount to write-off
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_bankaccountdoc ad_client_id numeric 10 Client/Tenant for this installation.
c_bankstatement ad_client_id numeric 10 Client/Tenant for this installation.
c_bankstatementline ad_client_id numeric 10 Client/Tenant for this installation.
c_bankstatementloader ad_client_id numeric 10 Client/Tenant for this installation.
c_bankstatementmatcher ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner 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_invoice ad_client_id numeric 10 Client/Tenant for this installation.
c_payment ad_client_id numeric 10 Client/Tenant for this installation.
c_paymentprocessor ad_client_id numeric 10 Client/Tenant for this installation.
i_bankstatement ad_client_id numeric 10  √  null Client/Tenant for this installation.
c_bank ad_org_id numeric 10 Organizational entity within client
c_bankaccount ad_org_id numeric 10 Organizational entity within client
c_bankaccountdoc ad_org_id numeric 10 Organizational entity within client
c_bankstatement ad_org_id numeric 10 Organizational entity within client
c_bankstatementline ad_org_id numeric 10 Organizational entity within client
c_bankstatementloader ad_org_id numeric 10 Organizational entity within client
c_bankstatementmatcher ad_org_id numeric 10 Organizational entity within client
c_bpartner 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_invoice ad_org_id numeric 10 Organizational entity within client
c_payment ad_org_id numeric 10 Organizational entity within client
c_paymentprocessor ad_org_id numeric 10 Organizational entity within client
i_bankstatement 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_invoice ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_payment ad_orgtrx_id numeric 10  √  null Performing or initiating organization
c_paymentprocessor ad_sequence_id numeric 10  √  null Document Sequence
c_invoice ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
c_bpartner bpartner_parent_id numeric 10  √  null Business Partner Parent
c_invoice c_activity_id numeric 10  √  null Business Activity
c_payment c_activity_id numeric 10  √  null Business Activity
c_bank c_bank_id numeric 10 Bank
c_bankaccount c_bank_id numeric 10 Bank
c_bankaccount c_bankaccount_id numeric 10 Account at the Bank
c_bankaccountdoc c_bankaccount_id numeric 10 Account at the Bank
c_bankstatement c_bankaccount_id numeric 10 Account at the Bank
c_bankstatementloader c_bankaccount_id numeric 10 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
i_bankstatement c_bankaccount_id numeric 10  √  null Account at the Bank
c_bankaccountdoc c_bankaccountdoc_id numeric 10 Checks, Transfers, etc.
c_bankstatement c_bankstatement_id numeric 10 Bank Statement of account
c_bankstatementline c_bankstatement_id numeric 10 Bank Statement of account
i_bankstatement c_bankstatement_id numeric 10  √  null Bank Statement of account
c_bankstatementline c_bankstatementline_id numeric 10 Line on a statement from this Bank
i_bankstatement c_bankstatementline_id numeric 10  √  null Line on a statement from this Bank
c_bankstatementloader c_bankstatementloader_id numeric 10 Definition of Bank Statement Loader (SWIFT, OFX)
c_bankstatementmatcher c_bankstatementmatcher_id numeric 10 Algorithm to match Bank Statement Info to Business Partners, Invoices and Payments
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_bankstatementline c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_bpartner c_bpartner_id numeric 10 Identifies a Business Partner
c_invoice c_bpartner_id numeric 10 Identifies a Business Partner
c_payment c_bpartner_id numeric 10  √  null Identifies a Business Partner
i_bankstatement 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_invoice c_campaign_id numeric 10  √  null Marketing Campaign
c_payment c_campaign_id numeric 10  √  null Marketing Campaign
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_bankstatementline c_charge_id numeric 10  √  null Additional document charges
c_invoice c_charge_id numeric 10  √  null Additional document charges
c_payment c_charge_id numeric 10  √  null Additional document charges
i_bankstatement c_charge_id numeric 10  √  null Additional document charges
c_invoice c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
c_payment c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
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_currency c_currency_id numeric 10 The Currency for this record
c_invoice 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
i_bankstatement c_currency_id numeric 10  √  null The Currency for this record
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_depositbatchline c_depositbatchline_id numeric 10 Deposit Batch Line
c_depositbatch c_doctype_id numeric 10 Document type or rules
c_invoice c_doctype_id numeric 10 Document type or rules
c_payment 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_bankstatementline c_invoice_id numeric 10  √  null Invoice Identifier
c_invoice c_invoice_id numeric 10 Invoice Identifier
c_payment c_invoice_id numeric 10  √  null Invoice Identifier
i_bankstatement c_invoice_id numeric 10  √  null Invoice Identifier
c_bpartner c_invoiceschedule_id numeric 10  √  null Schedule for generating Invoices
c_bank 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
c_bankstatementline 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_payment c_payment_id numeric 10 Payment identifier
i_bankstatement c_payment_id numeric 10  √  null Payment identifier
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_paymentprocessor c_paymentprocessor_id numeric 10 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_payment c_postendertype_id numeric 10  √  NULL::numeric POS Tender Type
c_invoice c_project_id numeric 10  √  null Financial Project
c_payment c_project_id numeric 10  √  null Financial Project
c_bpartner c_taxgroup_id numeric 10  √  null Tax Group
c_bankaccountdoc check_printformat_id numeric 10  √  null Print Format for printing Checks
c_currency costingprecision numeric 10 Rounding used costing calculations
c_bank createdby numeric 10 User who created this records
c_bankaccount createdby numeric 10 User who created this records
c_bankaccountdoc createdby numeric 10 User who created this records
c_bankstatement createdby numeric 10 User who created this records
c_bankstatementline createdby numeric 10 User who created this records
c_bankstatementloader createdby numeric 10 User who created this records
c_bankstatementmatcher createdby numeric 10 User who created this records
c_bpartner 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_invoice createdby numeric 10 User who created this records
c_payment createdby numeric 10 User who created this records
c_paymentprocessor createdby numeric 10 User who created this records
i_bankstatement createdby numeric 10  √  null User who created this records
c_payment creditcardexpmm numeric 10  √  null Expiry Month
c_payment creditcardexpyy numeric 10  √  null Expiry Year
c_bankaccountdoc currentnext numeric 10 The next number to be used
c_bpartner default1099box_id numeric 10  √  NULL::numeric Default 1099 Box
c_bpartner documentcopies numeric 10  √  null Number of copies to be printed
c_bankstatementloader hostport numeric 10  √  null Host Communication Port
c_paymentprocessor hostport numeric 10  √  null Host Communication Port
i_bankstatement i_bankstatement_id numeric 10 Import of the Bank Statement
c_bpartner invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
c_bankstatementline line numeric 10 Unique line for this document
c_depositbatchline line numeric 10 Unique line for this document
i_bankstatement line numeric 10  √  null Unique line for this document
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_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_invoice m_rma_id numeric 10  √  null Return Material Authorization
c_bpartner numberemployees numeric 10  √  null Number of employees
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_bankstatementloader proxyport numeric 10  √  null Port of your proxy server
c_paymentprocessor proxyport numeric 10  √  null Port of your proxy server
c_invoice ref_invoice_id numeric 10  √  null Referenced Invoice
c_payment ref_payment_id numeric 10  √  null Referenced Payment
c_invoice relatedinvoice_id numeric 10  √  NULL::numeric Related Invoice
c_invoice reversal_id numeric 10  √  null ID of document reversal
c_payment reversal_id numeric 10  √  null ID of document reversal
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_bpartner salesvolume numeric 10  √  null Total Volume of Sales in Thousands of Currency
c_bankstatementmatcher seqno numeric 10 Method of ordering records; lowest number comes first
c_bpartner shareofcustomer numeric 10  √  null Share of Customer's business as a percentage
c_bpartner shelflifeminpct numeric 10  √  null Minimum Shelf Life in percent based on Product Instance Guarantee Date
c_currency stdprecision numeric 10 Rule for rounding calculated amounts
c_bank updatedby numeric 10 User who updated this records
c_bankaccount updatedby numeric 10 User who updated this records
c_bankaccountdoc updatedby numeric 10 User who updated this records
c_bankstatement updatedby numeric 10 User who updated this records
c_bankstatementline updatedby numeric 10 User who updated this records
c_bankstatementloader updatedby numeric 10 User who updated this records
c_bankstatementmatcher updatedby numeric 10 User who updated this records
c_bpartner 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_invoice updatedby numeric 10 User who updated this records
c_payment updatedby numeric 10 User who updated this records
c_paymentprocessor updatedby numeric 10 User who updated this records
i_bankstatement updatedby numeric 10  √  null User who updated this records
c_invoice user1_id numeric 10  √  null User defined list element #1
c_payment user1_id numeric 10  √  null User defined list element #1
c_invoice user2_id numeric 10  √  null User defined list element #2
c_payment user2_id numeric 10  √  null User defined list element #2
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_bankaccountdoc created timestamp 29,6 now() Date this record was created
c_bankstatement created timestamp 29,6 now() Date this record was created
c_bankstatementline created timestamp 29,6 now() Date this record was created
c_bankstatementloader created timestamp 29,6 now() Date this record was created
c_bankstatementmatcher created timestamp 29,6 now() Date this record was created
c_bpartner 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_invoice created timestamp 29,6 now() Date this record was created
c_payment created timestamp 29,6 now() Date this record was created
c_paymentprocessor created timestamp 29,6 now() Date this record was created
i_bankstatement created timestamp 29,6 statement_timestamp() Date this record was created
c_bankstatement dateacct timestamp 29,6 Accounting Date
c_bankstatementline dateacct timestamp 29,6 Accounting Date
c_invoice dateacct timestamp 29,6 Accounting Date
c_payment dateacct timestamp 29,6 Accounting Date
i_bankstatement dateacct timestamp 29,6  √  null Accounting Date
c_depositbatch datedeposit timestamp 29,6 Deposit Date
c_depositbatch datedoc timestamp 29,6 Date of the Document
c_invoice dateinvoiced timestamp 29,6 Date printed on Invoice
c_bankstatementloader datelastrun timestamp 29,6  √  null Date the process was last run.
c_invoice dateordered timestamp 29,6  √  null Date of Order
c_invoice dateprinted timestamp 29,6  √  null Date the document was printed.
c_payment datetrx timestamp 29,6 Transaction Date
c_bpartner dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_invoice dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_bankstatement eftstatementdate timestamp 29,6  √  null Electronic Funds Transfer Statement Date
i_bankstatement eftstatementdate timestamp 29,6  √  null Electronic Funds Transfer Statement Date
c_bankstatementline eftstatementlinedate timestamp 29,6  √  null Electronic Funds Transfer Statement Line Date
i_bankstatement eftstatementlinedate timestamp 29,6  √  null Electronic Funds Transfer Statement Line Date
c_bankstatementline eftvalutadate timestamp 29,6  √  null Electronic Funds Transfer Valuta (effective) Date
i_bankstatement 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_bpartner firstsale timestamp 29,6  √  null Date of First Sale
c_bankstatement statementdate timestamp 29,6 Date of the statement
i_bankstatement statementdate timestamp 29,6  √  null Date of the statement
c_bankstatementline statementlinedate timestamp 29,6 Date of the Statement Line
i_bankstatement statementlinedate timestamp 29,6  √  null Date of the Statement Line
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_bankaccountdoc updated timestamp 29,6 now() Date this record was updated
c_bankstatement updated timestamp 29,6 now() Date this record was updated
c_bankstatementline updated timestamp 29,6 now() Date this record was updated
c_bankstatementloader updated timestamp 29,6 now() Date this record was updated
c_bankstatementmatcher updated timestamp 29,6 now() Date this record was updated
c_bpartner 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_invoice updated timestamp 29,6 now() Date this record was updated
c_payment updated timestamp 29,6 now() Date this record was updated
c_paymentprocessor updated timestamp 29,6 now() Date this record was updated
i_bankstatement updated timestamp 29,6 statement_timestamp() Date this record was updated
c_bankstatementline valutadate timestamp 29,6 Date when money is available
i_bankstatement valutadate timestamp 29,6  √  null Date when money is available
c_depositbatch docstatus varchar 2 'DR'::character varying The current status of the document
c_payment creditcardvv varchar 4  √  null Credit Card Verification code on credit card
c_bpartner ad_language varchar 6  √  null Language for this entity
c_bpartner naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_currency cursymbol varchar 10  √  null Symbol of the currency (opt used for printing only)
c_bpartner duns varchar 11  √  null Dun & Bradstreet Number
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_zip varchar 20  √  null Zip Code of the Credit Card or Account Holder
c_bankaccount accountno varchar 20 Account Number
c_bankstatementloader accountno varchar 20  √  null Account Number
c_payment accountno varchar 20  √  null Account Number
i_bankstatement bankaccountno varchar 20  √  null Bank Account Number
c_bankstatementloader branchid varchar 20  √  null Bank Branch ID
c_payment checkno varchar 20  √  null Check Number
c_payment creditcardnumber varchar 20  √  null Credit Card Number
c_bankstatementloader dateformat varchar 20  √  null Date format used in the input format
c_bankstatementline eftcheckno varchar 20  √  null Electronic Funds Transfer Check No
i_bankstatement eftcheckno varchar 20  √  null Electronic Funds Transfer Check No
c_bankstatementline eftcurrency varchar 20  √  null Electronic Funds Transfer Currency
i_bankstatement eftcurrency varchar 20  √  null Electronic Funds Transfer Currency
c_bankstatementline efttrxtype varchar 20  √  null Electronic Funds Transfer Transaction Type
i_bankstatement efttrxtype varchar 20  √  null Electronic Funds Transfer Transaction Type
c_bankstatementloader financialinstitutionid varchar 20  √  null The ID of the Financial Institution / Bank
c_payment micr varchar 20  √  null Combination of routing no, account and check no
c_payment orig_trxid varchar 20  √  null Original Transaction ID
c_bankstatementloader pin varchar 20  √  null Personal Identification 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_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_pnref varchar 20  √  null Payment reference
c_payment r_pnref_dc varchar 20  √  null Payment Reference Delayed Capture
c_payment r_result varchar 20  √  null Result of transmission
c_bank routingno varchar 20 Bank Routing Number
c_payment routingno varchar 20  √  null Bank Routing Number
i_bankstatement routingno varchar 20  √  null Bank Routing Number
c_bank swiftcode varchar 20  √  null Swift Code or BIC
c_payment swiftcode varchar 20  √  NULL::character varying Swift Code or BIC
c_bpartner taxid varchar 20  √  null Tax Identification
i_bankstatement trxtype varchar 20  √  null Type of credit card transaction
c_payment voiceauthcode varchar 20  √  null Voice Authorization Code from credit card company
c_depositbatch documentno varchar 30 Document sequence number of the document
c_invoice documentno varchar 30 Document sequence number of the document
c_payment documentno varchar 30 Document sequence number of the document
i_bankstatement invoicedocumentno varchar 30  √  null Document Number of the Invoice
i_bankstatement paymentdocumentno varchar 30  √  null Document number of the Payment
c_bank c_bank_uu varchar 36  √  NULL::character varying C_Bank_UU
c_bankaccount c_bankaccount_uu varchar 36  √  NULL::character varying C_BankAccount_UU
c_bankaccountdoc c_bankaccountdoc_uu varchar 36  √  NULL::character varying C_BankAccountDoc_UU
c_bankstatement c_bankstatement_uu varchar 36  √  NULL::character varying C_BankStatement_UU
c_bankstatementline c_bankstatementline_uu varchar 36  √  NULL::character varying C_BankStatementLine_UU
c_bankstatementloader c_bankstatementloader_uu varchar 36  √  NULL::character varying C_BankStatementLoader_UU
c_bankstatementmatcher c_bankstatementmatcher_uu varchar 36  √  NULL::character varying C_BankStatementMatcher_UU
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying C_BPartner_UU
c_currency c_currency_uu varchar 36  √  NULL::character varying C_Currency_UU
c_depositbatch c_depositbatch_uu varchar 36  √  NULL::character varying C_DepositBatch_UU
c_depositbatchline c_depositbatchline_uu varchar 36  √  NULL::character varying C_DepositBatchLine_UU
c_invoice c_invoice_uu varchar 36  √  NULL::character varying C_Invoice_UU
c_payment c_payment_uu varchar 36  √  NULL::character varying C_Payment_UU
c_paymentprocessor c_paymentprocessor_uu varchar 36  √  NULL::character varying C_PaymentProcessor_UU
i_bankstatement i_bankstatement_uu varchar 36  √  NULL::character varying I_BankStatement_UU
c_payment a_country varchar 40  √  null Country
c_payment a_state varchar 40  √  null State of the Credit Card or Account holder
c_bankaccount bban varchar 40  √  null Basic Bank Account Number
i_bankstatement bpartnervalue varchar 40  √  null Key of the Business Partner
c_bankstatementline eftpayeeaccount varchar 40  √  null Electronic Funds Transfer Payee Account Information
i_bankstatement eftpayeeaccount varchar 40  √  null Electronic Funds Transfer Payee Account Information
c_bankstatementline efttrxid varchar 40  √  null Electronic Funds Transfer Transaction ID
i_bankstatement efttrxid varchar 40  √  null Electronic Funds Transfer Transaction ID
c_bankaccount iban varchar 40  √  null International Bank Account Number
c_payment iban varchar 40  √  NULL::character varying International Bank Account Number
i_bankstatement iban varchar 40  √  NULL::character varying International Bank Account Number
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
i_bankstatement referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
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_payment a_city varchar 60  √  null City or the Credit Card or Account Holder
c_payment a_email varchar 60  √  null Email Address
c_payment a_name varchar 60  √  null Name on Credit Card or Account holder
c_payment a_street varchar 60  √  null Street address of the Credit Card or Account holder
i_bankstatement chargename varchar 60  √  null Name of the Charge
c_bankstatementmatcher classname varchar 60 Java Classname
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
c_bankstatementline eftreference varchar 60  √  null Electronic Funds Transfer Reference
i_bankstatement eftreference varchar 60  √  null Electronic Funds Transfer Reference
c_bankstatement eftstatementreference varchar 60  √  null Electronic Funds Transfer Statement Reference
i_bankstatement eftstatementreference varchar 60  √  null Electronic Funds Transfer Statement Reference
c_bankstatementloader hostaddress varchar 60  √  null Host Address URL or DNS
c_paymentprocessor hostaddress varchar 60  √  null Host Address URL or DNS
c_bank name varchar 60 Alphanumeric identifier of the entity
c_bankaccount name varchar 60 NULL::character varying Alphanumeric identifier of the entity
c_bankaccountdoc name varchar 60 Alphanumeric identifier of the entity
c_bankstatement name varchar 60 Alphanumeric identifier of the entity
c_bankstatementloader name varchar 60 Alphanumeric identifier of the entity
c_bankstatementmatcher name varchar 60 Alphanumeric identifier of the entity
c_paymentprocessor name varchar 60 Alphanumeric identifier of the entity
i_bankstatement name varchar 60  √  null Alphanumeric identifier of the entity
c_bpartner name2 varchar 60  √  null Additional Name
c_bankstatementloader password varchar 60  √  null Password of any length (case sensitive)
c_bankaccount paymentexportclass varchar 60  √  NULL::character varying Payment Export Class
c_paymentprocessor payprocessorclass varchar 60  √  null Payment Processor Java Class
c_payment ponum varchar 60  √  null Purchase Order Number
c_bankstatementloader proxyaddress varchar 60  √  null Address of your proxy server
c_paymentprocessor proxyaddress varchar 60  √  null Address of your proxy server
c_bankstatementloader proxylogon varchar 60  √  null Logon of your proxy server
c_paymentprocessor proxylogon varchar 60  √  null Logon of your proxy server
c_bankstatementloader proxypassword varchar 60  √  null Password of your proxy server
c_paymentprocessor proxypassword varchar 60  √  null Password of your proxy server
c_payment r_respmsg varchar 60  √  null Response message
c_bankstatementloader stmtloaderclass varchar 60  √  null Class name of the bank statement loader
c_bankstatementloader userid varchar 60  √  null User ID or account number
c_payment swipe varchar 80  √  null Track 1 and 2 of the Credit Card
c_bankstatementloader filename varchar 120  √  null Name of the local file or URL
c_bpartner name varchar 120 Alphanumeric identifier of the entity
c_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
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_bankaccountdoc description varchar 255  √  null Optional short description of the record
c_bankstatement description varchar 255  √  null Optional short description of the record
c_bankstatementline description varchar 255  √  null Optional short description of the record
c_bankstatementloader description varchar 255  √  null Optional short description of the record
c_bankstatementmatcher description varchar 255  √  null Optional short description of the record
c_bpartner 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_invoice 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
i_bankstatement description varchar 255  √  null Optional short description of the record
c_bankstatementline eftpayee varchar 255  √  null Electronic Funds Transfer Payee information
i_bankstatement eftpayee varchar 255  √  null Electronic Funds Transfer Payee information
i_bankstatement linedescription varchar 255  √  null Description of the Line
c_bankstatementline memo varchar 255  √  null Memo Text
i_bankstatement memo varchar 255  √  null Memo Text
c_payment r_voidmsg varchar 255  √  NULL::character varying Void Message
c_bpartner so_description varchar 255  √  null Description to be used on orders
c_bankstatementline eftmemo varchar 2000  √  null Electronic Funds Transfer Memo
i_bankstatement eftmemo varchar 2000  √  null Electronic Funds Transfer Memo
i_bankstatement i_errormsg varchar 2000  √  null Messages generated from import process
c_payment r_info varchar 2000  √  null Response info