SchemaSpy Analysis of idempiere11.adempiere - ColumnsPayment | Generated by Quality Systems & Solutions |
Generated on 2024-01-03 13:52 +0100 |
| |||||
|
idempiere11.adempiere contains 989 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_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 | |
i_payment | ad_client_id | numeric | 10 | √ | null | Tenant for this installation. | |
c_bpartner | ad_language | varchar | 6 | √ | null | Language for this entity | |
i_payment | ad_org_id | numeric | 10 | √ | null | Organizational entity within tenant | |
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_allocationline | allocationno | numeric | 10 | √ | null | ||
c_order | amountrefunded | numeric | 22,2 | √ | null | Amount Refunded | |
c_order | amounttendered | numeric | 22,2 | √ | null | Amount Tendered | |
i_payment | bankaccountno | varchar | 20 | √ | null | Bank Account Number | |
c_bp_bankaccount | bankaccounttype | bpchar | 1 | √ | null | Bank Account Type | |
c_bankaccount | bban | varchar | 40 | √ | null | Basic Bank Account Number | |
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_uu | varchar | 36 | √ | NULL::character varying | C_AllocationHdr_UU | |
c_paymentallocate | c_allocationline_id | numeric | 10 | √ | null | Allocation Line | |
c_allocationline | c_allocationline_uu | varchar | 36 | √ | NULL::character varying | C_AllocationLine_UU | |
c_bp_bankaccount | c_bank_id | numeric | 10 | √ | null | Bank | |
c_bank | c_bank_uu | varchar | 36 | √ | NULL::character varying | C_Bank_UU | |
c_cashline | c_bankaccount_id | numeric | 10 | √ | null | 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_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_bankstatementline_uu | varchar | 36 | √ | NULL::character varying | C_BankStatementLine_UU | |
c_allocationline | c_banktransfer_id | numeric | 10 | √ | NULL::numeric | Bank Transfer | |
c_payment | c_banktransfer_id | numeric | 10 | √ | NULL::numeric | Bank Transfer | |
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_allocationline | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
c_bankstatementline | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
c_charge | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
c_payment | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
c_project | c_bpartner_id | numeric | 10 | √ | null | Identifies a Business Partner | |
i_payment | c_bpartner_id | numeric | 10 | √ | null | Identifies a 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_uu | varchar | 36 | √ | NULL::character varying | C_Cash_UU | |
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_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_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_cashline | c_currency_id | numeric | 10 | √ | null | The Currency for this record | |
c_paymentprocessor | c_currency_id | numeric | 10 | √ | null | 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_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_uu | varchar | 36 | √ | NULL::character varying | C_DepositBatchLine_UU | |
c_allocationhdr | c_doctype_id | numeric | 10 | √ | NULL::numeric | 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_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_payment | c_invoice_id | numeric | 10 | √ | null | 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_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_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_invoice | c_payment_id | numeric | 10 | √ | null | Payment identifier | |
c_order | c_payment_id | numeric | 10 | √ | null | 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_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_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_uu | varchar | 36 | √ | NULL::character varying | C_PaymentProcessor_UU | |
c_bpartner | c_paymentterm_id | numeric | 10 | √ | null | 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_uu | varchar | 36 | √ | NULL::character varying | C_PaySchedule_UU | |
c_payselection | c_payselection_uu | varchar | 36 | √ | NULL::character varying | C_PaySelection_UU | |
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_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_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_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_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 | |
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_invoice | createlinesfrom | bpchar | 1 | √ | NULL::bpchar | 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_invoice | currencyrate | numeric | 0 | √ | null | Currency Conversion Rate | |
c_payment | currencyrate | numeric | 0 | √ | null | Currency Conversion Rate | |
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 | |
i_payment | dateacct | timestamp | 29,6 | √ | null | Accounting Date | |
c_project | datecontract | timestamp | 29,6 | √ | null | The (planned) effective date of this document. | |
c_project | datefinish | timestamp | 29,6 | √ | null | Finish or (planned) completion date | |
c_invoice | dateordered | timestamp | 29,6 | √ | null | Date of Order | |
c_invoice | dateprinted | timestamp | 29,6 | √ | null | Date the document was printed. | |
c_order | dateprinted | timestamp | 29,6 | √ | null | Date the document was printed. | |
c_order | datepromised | timestamp | 29,6 | √ | null | Date Order was promised | |
c_allocationline | datetrx | timestamp | 29,6 | √ | null | 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_bpartner | deliveryviarule | bpchar | 1 | √ | null | How the order will be delivered | |
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 | 1000 | √ | 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_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_cashline | discountamt | numeric | 0 | √ | 0 | Calculated amount of discount | |
c_payment | discountamt | numeric | 0 | √ | 0 | Calculated amount of discount | |
i_payment | discountamt | numeric | 0 | √ | 0 | Calculated amount of discount | |
c_doctype | docnosequence_id | numeric | 10 | √ | null | Document sequence determines the numbering of documents | |
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_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_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 | 4000 | √ | 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 | 255 | √ | 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 | 255 | √ | 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_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_invoice | generateto | bpchar | 1 | √ | null | Generate To | |
c_project | generateto | bpchar | 1 | √ | null | Generate To | |
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_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_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 | |
i_payment | invoicedocumentno | varchar | 30 | √ | null | Document Number of the Invoice | |
c_bpartner | invoicerule | bpchar | 1 | √ | null | Frequency and method of invoicing | |
i_payment | isactive | bpchar | 1 | √ | 'Y'::bpchar | The record is active in the system | |
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_paymentterm | isdefault | bpchar | 1 | √ | 'N'::bpchar | Default value | |
i_payment | isdelayedcapture | bpchar | 1 | √ | 'N'::bpchar | Charge after Shipment | |
c_bpartner | isdiscountprinted | bpchar | 1 | √ | 'Y'::bpchar | Print Discount on Invoice and Order | |
c_invoice | isfixedassetinvoice | bpchar | 1 | √ | null | Is Fixed Asset Invoice | |
c_cashline | isgenerated | bpchar | 1 | √ | 'N'::bpchar | This Line is generated | |
c_allocationline | 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_paymentterm | isnextbusinessday | bpchar | 1 | √ | 'Y'::bpchar | Payment due on the next business day | |
c_doctype | isnopricelistcheck | bpchar | 1 | √ | 'N'::bpchar | Allow Product Without Price List | |
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 | |
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 | |
i_payment | isreceipt | bpchar | 1 | √ | 'Y'::bpchar | This is a sales transaction (receipt) | |
i_payment | isselfservice | bpchar | 1 | √ | 'N'::bpchar | This is a Self-Service entry or this entry can be changed via Self-Service | |
c_bpartner | istaxexempt | bpchar | 1 | √ | 'N'::bpchar | Business partner is exempt from tax on sales | |
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_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_project | m_warehouse_id | numeric | 10 | √ | null | Storage Warehouse and Service Point | |
c_bankstatementline | matchstatement | bpchar | 1 | √ | null | Match Statement | |
c_bankstatementline | memo | varchar | 4000 | √ | 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_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_project | note | varchar | 2000 | √ | null | Optional additional user defined information | |
c_bpartner | numberemployees | numeric | 10 | √ | null | Number of employees | |
c_payment | oprocessing | bpchar | 1 | √ | null | This payment can be processed online | |
c_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 | |
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 | |
i_payment | payamt | numeric | 0 | √ | 0 | Amount being paid | |
c_bankaccount | paymentexportclass | varchar | 60 | √ | NULL::character varying | Payment Export Class | |
c_bpartner | paymentrule | bpchar | 1 | √ | null | How you pay the invoice | |
c_bpartner | paymentrulepo | bpchar | 1 | √ | null | Purchase payment option | |
c_paymentprocessor | payprocessorclass | varchar | 60 | √ | null | Payment Processor Java Class | |
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_bpartner | potentiallifetimevalue | numeric | 0 | √ | 0 | Total Revenue expected | |
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_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_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 | projectcategory | bpchar | 1 | √ | 'N'::bpchar | Project Category | |
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_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 | 255 | √ | 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_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_payselection | reversepreparepayment | bpchar | 1 | √ | NULL::bpchar | Reverse Prepare Payment | |
c_currency | roundofffactor | numeric | 0 | √ | null | Used to Round Off Payment Amount | |
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 | 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 | statementdifference | numeric | 0 | √ | 0 | Difference between statement ending balance and actual ending balance | |
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 | |
i_payment | tendertype | bpchar | 1 | √ | null | Method of Payment | |
c_bpartner | totalopenbalance | numeric | 0 | √ | null | Total Open Balance Amount in primary Accounting Currency | |
c_paymentprocessor | trxtype | bpchar | 1 | √ | NULL::bpchar | Type of credit card transaction | |
i_payment | trxtype | bpchar | 1 | √ | null | Type of credit card transaction | |
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_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_cashline | writeoffamt | numeric | 0 | √ | 0 | Amount to write-off | |
c_payment | writeoffamt | numeric | 0 | √ | 0 | Amount to write-off | |
i_payment | writeoffamt | numeric | 0 | √ | 0 | Amount to write-off | |
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_allocationhdr | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_allocationline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_bank | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_bankaccount | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_bankstatementline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_bp_bankaccount | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_bpartner | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_cash | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_cashline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_charge | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_currency | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_depositbatch | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_depositbatchline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_doctype | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_invoice | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_invoicepayschedule | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_order | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_payment | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_paymentallocate | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_paymentbatch | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_paymentprocessor | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_paymentterm | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_payschedule | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_payselection | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_payselectioncheck | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_payselectionline | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_project | ad_client_id | numeric | 10 | Tenant for this installation. | |||
c_allocationhdr | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_allocationline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_bank | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_bankaccount | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_bankstatementline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_bp_bankaccount | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_bpartner | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_cash | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_cashline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_charge | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_currency | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_depositbatch | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_depositbatchline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_doctype | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_invoice | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_invoicepayschedule | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_order | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_payment | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_paymentallocate | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_paymentbatch | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_paymentprocessor | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_paymentterm | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_payschedule | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_payselection | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_payselectioncheck | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_payselectionline | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_project | ad_org_id | numeric | 10 | Organizational entity within tenant | |||
c_paymentterm | afterdelivery | bpchar | 1 | 'N'::bpchar | Due after delivery rather than after invoicing | ||
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_allocationhdr | approvalamt | numeric | 0 | 0 | Document Approval Amount | ||
c_bankaccount | bankaccounttype | bpchar | 1 | Bank Account Type | |||
c_cash | beginningbalance | numeric | 0 | 0 | Balance prior to any transactions | ||
c_allocationhdr | c_allocationhdr_id | numeric | 10 | Payment allocation | |||
c_allocationline | c_allocationhdr_id | numeric | 10 | Payment allocation | |||
c_allocationline | c_allocationline_id | numeric | 10 | Allocation Line | |||
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_depositbatch | c_bankaccount_id | numeric | 10 | Account at the Bank | |||
c_payselection | c_bankaccount_id | numeric | 10 | Account at the Bank | |||
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_bp_bankaccount | c_bp_bankaccount_id | numeric | 10 | Bank Account of the Business Partner | |||
c_bpartner | c_bp_group_id | numeric | 10 | Business Partner Group | |||
c_bp_bankaccount | c_bpartner_id | numeric | 10 | 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_order | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
c_payselectioncheck | c_bpartner_id | numeric | 10 | Identifies a Business Partner | |||
c_invoice | c_bpartner_location_id | numeric | 10 | Identifies the (ship to) address for this Business Partner | |||
c_order | c_bpartner_location_id | numeric | 10 | Identifies the (ship to) address for this Business Partner | |||
c_cash | c_cash_id | numeric | 10 | Cash Journal | |||
c_cashline | c_cash_id | numeric | 10 | Cash Journal | |||
c_cash | c_cashbook_id | numeric | 10 | Cash Book for recording petty cash transactions | |||
c_cashline | c_cashline_id | numeric | 10 | Cash Journal Line | |||
c_charge | c_charge_id | numeric | 10 | Additional document charges | |||
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_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_project | c_currency_id | numeric | 10 | The Currency for this record | |||
c_depositbatch | c_depositbatch_id | numeric | 10 | Deposit Batch | |||
c_depositbatchline | c_depositbatch_id | numeric | 10 | Deposit Batch | |||
c_depositbatchline | c_depositbatchline_id | numeric | 10 | Deposit Batch Line | |||
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 | |||
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_invoice | c_invoice_id | numeric | 10 | Invoice Identifier | |||
c_invoicepayschedule | c_invoice_id | numeric | 10 | Invoice Identifier | |||
c_paymentallocate | c_invoice_id | numeric | 10 | Invoice Identifier | |||
c_payselectionline | c_invoice_id | numeric | 10 | Invoice Identifier | |||
c_invoicepayschedule | c_invoicepayschedule_id | numeric | 10 | Invoice Payment Schedule | |||
c_order | c_order_id | numeric | 10 | Order | |||
c_depositbatchline | c_payment_id | numeric | 10 | Payment identifier | |||
c_payment | c_payment_id | numeric | 10 | Payment identifier | |||
c_paymentallocate | c_payment_id | numeric | 10 | Payment identifier | |||
c_paymentallocate | c_paymentallocate_id | numeric | 10 | Allocate Payment to Invoices | |||
c_paymentbatch | c_paymentbatch_id | numeric | 10 | Payment batch for EFT | |||
c_paymentprocessor | c_paymentprocessor_id | numeric | 10 | Payment processor for electronic payments | |||
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_payschedule | c_payschedule_id | numeric | 10 | Payment Schedule Template | |||
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_payselectioncheck | c_payselectioncheck_id | numeric | 10 | Payment Selection Check | |||
c_payselectionline | c_payselectionline_id | numeric | 10 | Payment Selection Line | |||
c_project | c_project_id | numeric | 10 | Financial Project | |||
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_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_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 | |||
c_bankaccount | creditlimit | numeric | 0 | 0 | Amount of Credit allowed | ||
c_bankaccount | currentbalance | numeric | 0 | 0 | Current Balance | ||
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 | |||
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_order | dateordered | timestamp | 29,6 | Date of Order | |||
c_allocationhdr | datetrx | timestamp | 29,6 | Transaction Date | |||
c_payment | datetrx | timestamp | 29,6 | Transaction Date | |||
c_order | deliveryrule | bpchar | 1 | Defines the timing of Delivery | |||
c_order | deliveryviarule | bpchar | 1 | How the order will be delivered | |||
c_depositbatch | depositamt | numeric | 0 | Deposit Amount | |||
c_currency | description | varchar | 255 | 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_invoicepayschedule | 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 | ||
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_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 | 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_invoicepayschedule | dueamt | numeric | 0 | 0 | Amount of the payment due | ||
c_invoicepayschedule | duedate | timestamp | 29,6 | Date when the payment is due | |||
c_cash | endingbalance | numeric | 0 | 0 | Ending or closing balance | ||
c_order | freightcostrule | bpchar | 1 | Method for charging Freight | |||
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 | ||
i_payment | i_isimported | bpchar | 1 | 'N'::bpchar | Has this import been processed | ||
i_payment | i_payment_id | numeric | 10 | Import Payment | |||
c_bankstatementline | interestamt | numeric | 0 | 0 | Interest Amount | ||
c_project | invoicedamt | numeric | 0 | 0 | The amount invoiced | ||
c_project | invoicedqty | numeric | 0 | 0 | The quantity invoiced | ||
c_order | invoicerule | bpchar | 1 | Frequency and method of invoicing | |||
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 | ||
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 | 'N'::bpchar | Indicates if this document requires approval | ||
c_order | isapproved | bpchar | 1 | 'N'::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 | ||
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_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 | ||
c_order | isdelivered | bpchar | 1 | 'N'::bpchar | Delivered | ||
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_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_bankstatementline | ismanual | bpchar | 1 | 'N'::bpchar | This is a manual process | ||
c_payselectionline | ismanual | bpchar | 1 | 'Y'::bpchar | This is a manual process | ||
c_currency | iso_code | bpchar | 3 | Three letter ISO 4217 Code of the Currency | |||
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 fully 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 | Privileged 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) | ||
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 | ||
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_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_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_order | m_warehouse_id | numeric | 10 | Storage Warehouse and Service Point | |||
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_paymentterm | netdays | numeric | 10 | Net Days in which payment is due | |||
c_payschedule | netdays | numeric | 10 | Net Days in which payment is due | |||
c_payselectionline | openamt | numeric | 0 | 0 | Open item amount | ||
c_paymentallocate | 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_payselectioncheck | payamt | numeric | 0 | 0 | Amount being paid | ||
c_payselectionline | payamt | numeric | 0 | 0 | Amount being paid | ||
c_payselection | paydate | timestamp | 29,6 | Date Payment made | |||
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_paymentterm | paymenttermusage | bpchar | 1 | 'B'::bpchar | Payment term usage indicates if this payment term is used for sales, purchases or both. | ||
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_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_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 | ||
c_depositbatchline | processing | bpchar | 1 | Process Now | |||
c_paymentbatch | processing | bpchar | 1 | Process Now | |||
c_project | projectbalanceamt | numeric | 0 | 0 | Total Project Balance | ||
c_project | projectlinelevel | bpchar | 1 | 'P'::bpchar | Project Line Level | ||
c_project | projinvoicerule | bpchar | 1 | '-'::bpchar | Invoice Rule for the project | ||
c_payselectioncheck | qty | numeric | 0 | 0 | Quantity | ||
c_paymentprocessor | requirevv | bpchar | 1 | 'N'::bpchar | Require 3/4 digit Credit Verification Code | ||
c_bank | routingno | varchar | 20 | Bank Routing Number | |||
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_cash | statementdate | timestamp | 29,6 | Date of the statement | |||
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_payment | tendertype | bpchar | 1 | 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_bankstatementline | trxamt | numeric | 0 | 0 | Amount of a transaction | ||
c_payment | trxtype | bpchar | 1 | 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 | |||
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_allocationline | 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 |