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

idempiere9.adempiere contains 378 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
c_payment a_city varchar 60  √  null City or the Credit Card or Account Holder
c_payment a_country varchar 40  √  null Country
c_payment a_email varchar 60  √  null Email Address
c_payment a_ident_dl varchar 20  √  null Payment Identification - Driver License
c_payment a_ident_ssn varchar 20  √  null Payment Identification - Social Security No
c_payment a_name varchar 60  √  null Name on Credit Card or Account holder
c_payment a_state varchar 40  √  null State of the Credit Card or Account holder
c_payment a_street varchar 60  √  null Street address of the Credit Card or Account holder
c_payment a_zip varchar 20  √  null Zip Code of the Credit Card or Account Holder
c_payment accountno varchar 20  √  null Account Number
c_bpartner acqusitioncost numeric 0  √  0 The cost of gaining the prospect as a customer
c_bpartner actuallifetimevalue numeric 0  √  0 Actual Life Time Revenue
ad_printformat ad_client_id numeric 10 Client/Tenant for this installation.
c_bpartner ad_client_id numeric 10 Client/Tenant for this installation.
c_dunning ad_client_id numeric 10 Client/Tenant for this installation.
c_dunninglevel ad_client_id numeric 10 Client/Tenant for this installation.
c_dunningrun ad_client_id numeric 10 Client/Tenant for this installation.
c_dunningrunentry ad_client_id numeric 10 Client/Tenant for this installation.
c_dunningrunline 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_bpartner ad_language varchar 6  √  null Language for this entity
ad_printformat ad_org_id numeric 10 Organizational entity within client
c_bpartner ad_org_id numeric 10 Organizational entity within client
c_dunning ad_org_id numeric 10 Organizational entity within client
c_dunninglevel ad_org_id numeric 10 Organizational entity within client
c_dunningrun ad_org_id numeric 10 Organizational entity within client
c_dunningrunentry ad_org_id numeric 10 Organizational entity within client
c_dunningrunline 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_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
ad_printformat ad_printcolor_id numeric 10 Color used for printing and display
ad_printformat ad_printfont_id numeric 10 Maintain Print Font
ad_printformat ad_printformat_id numeric 10 Data Print Format
ad_printformat ad_printformat_uu varchar 36  √  NULL::character varying AD_PrintFormat_UU
ad_printformat ad_printheaderfooter_id numeric 10  √  NULL::numeric Print Header/Footer
ad_printformat ad_printpaper_id numeric 10 Printer paper definition
ad_printformat ad_printtableformat_id numeric 10  √  null Table Format in Reports
ad_printformat ad_reportview_id numeric 10  √  null View used to generate this report
ad_printformat ad_table_id numeric 10 Database Table information
c_dunningrunentry 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
ad_printformat ad_window_id numeric 10  √  NULL::numeric Data entry or display window
c_dunningrunentry amt numeric 0 0 Amount
c_dunningrunline amt numeric 0 0 Amount
ad_printformat args varchar 510  √  null Args
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_payment c_bankaccount_id numeric 10  √  null Account at the Bank
c_payment c_bp_bankaccount_id numeric 10  √  null Bank Account of the Business Partner
c_bpartner c_bp_group_id numeric 10 Business Partner Group
c_bpartner c_bpartner_id numeric 10 Identifies a Business Partner
c_dunningrunentry 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
c_dunningrunentry c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
c_invoice c_bpartner_location_id numeric 10 Identifies the (ship to) address for this Business Partner
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying C_BPartner_UU
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_invoice c_charge_id numeric 10  √  null Additional document charges
c_payment 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_dunningrunentry 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_payment c_depositbatch_id numeric 10  √  NULL::numeric Deposit Batch
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_dunning c_dunning_id numeric 10 Dunning Rules for overdue invoices
c_dunninglevel c_dunning_id numeric 10 Dunning Rules for overdue invoices
c_dunningrun c_dunning_id numeric 10 NULL::numeric Dunning Rules for overdue invoices
c_dunning c_dunning_uu varchar 36  √  NULL::character varying C_Dunning_UU
c_dunninglevel c_dunninglevel_id numeric 10 Dunning Level
c_dunningrun c_dunninglevel_id numeric 10  √  null Dunning Level
c_dunningrunentry c_dunninglevel_id numeric 10 NULL::numeric Dunning Level
c_invoice c_dunninglevel_id numeric 10  √  null Dunning Level
c_dunninglevel c_dunninglevel_uu varchar 36  √  NULL::character varying C_DunningLevel_UU
c_dunningrun c_dunningrun_id numeric 10 Dunning Run
c_dunningrunentry c_dunningrun_id numeric 10 Dunning Run
c_dunningrun c_dunningrun_uu varchar 36  √  NULL::character varying C_DunningRun_UU
c_dunningrunentry c_dunningrunentry_id numeric 10 Dunning Run Entry
c_dunningrunline c_dunningrunentry_id numeric 10 Dunning Run Entry
c_dunningrunentry c_dunningrunentry_uu varchar 36  √  NULL::character varying C_DunningRunEntry_UU
c_dunningrunline c_dunningrunline_id numeric 10 Dunning Run Line
c_dunningrunline c_dunningrunline_uu varchar 36  √  NULL::character varying C_DunningRunLine_UU
c_bpartner c_greeting_id numeric 10  √  null Greeting to print on correspondence
c_dunningrunline 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
c_invoice c_invoice_uu varchar 36  √  NULL::character varying C_Invoice_UU
c_dunningrunline c_invoicepayschedule_id numeric 10  √  null Invoice Payment Schedule
c_bpartner c_invoiceschedule_id numeric 10  √  null Schedule for generating Invoices
c_invoice c_order_id numeric 10  √  null Order
c_payment c_order_id numeric 10  √  null Order
c_dunningrunline c_payment_id numeric 10  √  null Payment identifier
c_invoice c_payment_id numeric 10  √  null Payment identifier
c_payment c_payment_id numeric 10 Payment identifier
c_payment c_payment_uu varchar 36  √  NULL::character varying C_Payment_UU
c_payment c_paymentbatch_id numeric 10  √  null Payment batch for EFT
c_payment c_paymentprocessor_id numeric 10  √  NULL::numeric Payment processor for electronic payments
c_bpartner c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_dunninglevel 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_invoice chargeamt numeric 0  √  0 Charge Amount
c_payment chargeamt numeric 0  √  0 Charge Amount
c_dunninglevel chargefee bpchar 1 'Y'::bpchar Indicates if fees will be charged for overdue invoices
c_dunninglevel chargeinterest bpchar 1 'Y'::bpchar Indicates if interest will be charged on overdue invoices
c_payment checkno varchar 20  √  null Check Number
ad_printformat classname varchar 240  √  null Java Classname
c_dunningrunline convertedamt numeric 0 0 Converted Amount
c_payment convertedamt numeric 0  √  null Converted Amount
c_invoice copyfrom bpchar 1  √  null Copy From Record
ad_printformat createcopy bpchar 1  √  null Create Copy
ad_printformat created timestamp 29,6 now() Date this record was created
c_bpartner created timestamp 29,6 now() Date this record was created
c_dunning created timestamp 29,6 now() Date this record was created
c_dunninglevel created timestamp 29,6 now() Date this record was created
c_dunningrun created timestamp 29,6 now() Date this record was created
c_dunningrunentry created timestamp 29,6 now() Date this record was created
c_dunningrunline created timestamp 29,6 now() 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
ad_printformat createdby numeric 10 User who created this records
c_bpartner createdby numeric 10 User who created this records
c_dunning createdby numeric 10 User who created this records
c_dunninglevel createdby numeric 10 User who created this records
c_dunningrun createdby numeric 10 User who created this records
c_dunningrunentry createdby numeric 10 User who created this records
c_dunningrunline 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_invoice createfrom bpchar 1  √  null Process which will generate a new document lines based on an existing document
c_dunning createlevelssequentially bpchar 1 'N'::bpchar Create Dunning Letter by level sequentially
c_payment creditcardexpmm numeric 10  √  null Expiry Month
c_payment creditcardexpyy numeric 10  √  null Expiry Year
c_payment creditcardnumber varchar 20  √  null Credit Card Number
c_payment creditcardtype bpchar 1  √  null Credit Card (Visa, MC, AmEx)
c_payment creditcardvv varchar 4  √  null Credit Card Verification code on credit card
c_invoice currencyrate numeric 0  √  null Currency Conversion Rate
c_payment currencyrate numeric 0  √  null Currency Conversion Rate
c_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_invoice dateacct timestamp 29,6 Accounting Date
c_payment dateacct timestamp 29,6 Accounting Date
c_invoice dateinvoiced timestamp 29,6 Date printed on Invoice
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_dunninglevel daysafterdue numeric 10 Days after due date to dun (if negative days until due)
c_dunninglevel daysbetweendunning numeric 10 Days between sending dunning notices
c_dunningrunline daysdue numeric 10 0 Number of days due (negative: due in number of days)
c_bpartner default1099box_id numeric 10  √  NULL::numeric Default 1099 Box
c_bpartner deliveryrule bpchar 1  √  null Defines the timing of Delivery
c_bpartner deliveryviarule bpchar 1  √  null How the order will be delivered
ad_printformat description varchar 255  √  null Optional short description of the record
c_bpartner description varchar 255  √  null Optional short description of the record
c_dunning description varchar 255  √  null Optional short description of the record
c_dunninglevel description varchar 255  √  null Optional short description of the record
c_dunningrun description varchar 255  √  null 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_payment discountamt numeric 0  √  0 Calculated amount of discount
c_invoice docaction bpchar 2 The targeted status of the document
c_payment docaction bpchar 2 The targeted status of the document
c_invoice docstatus bpchar 2 The current status of the document
c_payment docstatus bpchar 2 The current status of the document
c_bpartner documentcopies numeric 10  √  null Number of copies to be printed
c_invoice documentno varchar 30 Document sequence number of the document
c_payment documentno varchar 30 Document sequence number of the document
c_dunninglevel dunning_printformat_id numeric 10  √  null Print Format for printing Dunning Letters
c_dunningrun dunningdate timestamp 29,6 Date of Dunning
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_dunninglevel feeamt numeric 0  √  0 Fee amount in invoice currency
c_dunningrunline feeamt numeric 0 0 Fee amount in invoice currency
c_bpartner firstsale timestamp 29,6  √  null Date of First Sale
c_bpartner flatdiscount numeric 0  √  null Flat discount percentage
ad_printformat footermargin numeric 10 Margin of the Footer in 1/72 of an inch
c_bpartner freightcostrule bpchar 1  √  null Method for charging Freight
c_invoice generateto bpchar 1  √  null Generate To
c_invoice grandtotal numeric 0 0 Total amount of document
ad_printformat headermargin numeric 10 Margin of the Header in 1/72 of an inch
c_payment iban varchar 40  √  NULL::character varying International Bank Account Number
c_dunningrunline interestamt numeric 0 0 Interest Amount
c_dunninglevel interestpercent numeric 0  √  0 Percentage interest to charge on overdue invoices
c_bpartner invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
c_dunninglevel invoicecollectiontype bpchar 1  √  NULL::bpchar Invoice Collection Status
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
ad_printformat 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_dunning isactive bpchar 1 'Y'::bpchar The record is active in the system
c_dunninglevel isactive bpchar 1 'Y'::bpchar The record is active in the system
c_dunningrun isactive bpchar 1 'Y'::bpchar The record is active in the system
c_dunningrunentry isactive bpchar 1 'Y'::bpchar The record is active in the system
c_dunningrunline 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_payment isallocated bpchar 1 'N'::bpchar Indicates if the payment has been allocated
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
ad_printformat isbreakpageperrecord bpchar 1 'Y'::bpchar Page Break after each record
c_bpartner iscustomer bpchar 1 'Y'::bpchar Indicates if this Business Partner is a Customer
ad_printformat isdefault bpchar 1 'N'::bpchar Default value
c_dunning 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_invoice isfixedassetinvoice bpchar 1  √  null IsFixedAssetInvoice
ad_printformat isform bpchar 1 'N'::bpchar If Selected, a Form is printed, if not selected a columnar List report
c_dunningrunline isindispute bpchar 1 'N'::bpchar Document is in dispute
c_invoice isindispute bpchar 1 'N'::bpchar Document is in dispute
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_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_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_dunninglevel issetcreditstop bpchar 1 'N'::bpchar Set the business partner to credit stop
c_dunninglevel issetpaymentterm bpchar 1 'N'::bpchar Set the payment term of the Business Partner
c_dunninglevel isshowalldue bpchar 1 'N'::bpchar Show/print all due invoices
c_dunninglevel isshownotdue bpchar 1 'N'::bpchar Show/print all invoices which are not due (yet).
c_invoice issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
ad_printformat isstandardheaderfooter bpchar 1 'Y'::bpchar The standard Header and Footer is used
c_dunninglevel isstatement bpchar 1 'N'::bpchar Dunning Level is a definition of a statement
c_bpartner issummary bpchar 1 'N'::bpchar This is a summary entity
ad_printformat istablebased bpchar 1 'Y'::bpchar Table based List Reporting
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
ad_printformat jasperprocess_id numeric 10  √  null The Jasper Process used by the printengine if any process defined
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_payment micr varchar 20  √  null Combination of routing no, account and check no
c_bpartner naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
ad_printformat name varchar 60 Alphanumeric identifier of the entity
c_bpartner name varchar 120 Alphanumeric identifier of the entity
c_dunning name varchar 60 Alphanumeric identifier of the entity
c_dunninglevel name varchar 60 'x'::character varying Alphanumeric identifier of the entity
c_bpartner name2 varchar 60  √  null Additional Name
c_dunninglevel note varchar 2000  √  null Optional additional user defined information
c_dunningrunentry note varchar 2000  √  null Optional additional user defined information
c_bpartner numberemployees numeric 10  √  null Number of employees
c_dunningrunline openamt numeric 0 Open item amount
c_payment oprocessing bpchar 1  √  null This payment can be processed online
c_payment orig_trxid varchar 20  √  null Original Transaction ID
c_payment overunderamt numeric 0  √  0 Over-Payment (unallocated) or Under-Payment (partial payment) Amount
c_payment payamt numeric 0 0 Amount being paid
c_bpartner paymentrule bpchar 1  √  null How you pay the invoice
c_invoice paymentrule bpchar 1 How you pay the invoice
c_bpartner paymentrulepo bpchar 1  √  null Purchase payment option
c_bpartner po_discountschema_id numeric 10  √  null Schema to calculate the purchase trade discount percentage
c_bpartner po_paymentterm_id numeric 10  √  null Payment rules for a purchase order
c_bpartner po_pricelist_id numeric 10  √  null Price List used by this Business Partner
c_payment ponum varchar 60  √  null Purchase Order Number
c_bpartner poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_invoice poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_invoice posted bpchar 1 'N'::bpchar Posting status
c_payment posted bpchar 1 'N'::bpchar Posting status
c_bpartner potentiallifetimevalue numeric 0  √  0 Total Revenue expected
ad_printformat printername varchar 40  √  null Name of the Printer
c_dunninglevel printname varchar 60 The label text to be printed on a document or correspondence.
c_dunningrun processed bpchar 1 'N'::bpchar The document has been processed
c_dunningrunentry processed bpchar 1 'N'::bpchar The document has been processed
c_dunningrunline processed bpchar 1 'N'::bpchar 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
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_dunningrun processing bpchar 1  √  null Process Now
c_invoice processing bpchar 1  √  null Process Now
c_payment processing bpchar 1  √  null Process Now
c_dunningrunentry qty numeric 0 0 Quantity
c_payment r_authcode varchar 20  √  null Authorization Code returned
c_payment r_authcode_dc varchar 20  √  null Authorization Code Delayed Capture returned
c_payment r_avsaddr bpchar 1  √  null This address has been verified
c_payment r_avszip bpchar 1  √  null The Zip Code has been verified
c_payment r_cvv2match bpchar 1  √  null Credit Card Verification Code Match
c_payment r_info varchar 2000  √  null Response info
c_payment r_pnref varchar 20  √  null Payment reference
c_payment r_pnref_dc varchar 20  √  null Payment Reference Delayed Capture
c_payment r_respmsg varchar 60  √  null Response message
c_payment r_result varchar 20  √  null Result of transmission
c_payment r_voidmsg varchar 255  √  NULL::character varying Void Message
c_bpartner rating bpchar 1  √  null Classification or Importance
c_invoice ref_invoice_id numeric 10  √  null Referenced Invoice
c_payment ref_payment_id numeric 10  √  null Referenced Payment
c_bpartner referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
c_invoice relatedinvoice_id numeric 10  √  NULL::numeric Related Invoice
c_invoice reversal_id numeric 10  √  null ID of document reversal
c_payment reversal_id numeric 10  √  null ID of document reversal
c_payment routingno varchar 20  √  null Bank Routing Number
c_bpartner salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_dunningrunentry salesrep_id numeric 10 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_dunning senddunningletter bpchar 1 'Y'::bpchar Indicates if dunning letters will be sent
c_bpartner sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_invoice sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_dunningrun sendit bpchar 1  √  null Send
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_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_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
c_payment taxamt numeric 0  √  0 Tax Amount for a document
c_bpartner taxid varchar 20  √  null Tax Identification
c_payment tendertype bpchar 1 Method of Payment
c_dunningrunline timesdunned numeric 10 0 Number of times dunned previously
c_dunningrunline totalamt numeric 0 0 Total Amount
c_invoice totallines numeric 0 0 Total of all document lines
c_bpartner totalopenbalance numeric 0  √  null Total Open Balance Amount in primary Accounting Currency
c_payment trxtype bpchar 1 Type of credit card transaction
ad_printformat updated timestamp 29,6 now() Date this record was updated
c_bpartner updated timestamp 29,6 now() Date this record was updated
c_dunning updated timestamp 29,6 now() Date this record was updated
c_dunninglevel updated timestamp 29,6 now() Date this record was updated
c_dunningrun updated timestamp 29,6 now() Date this record was updated
c_dunningrunentry updated timestamp 29,6 now() Date this record was updated
c_dunningrunline updated timestamp 29,6 now() 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
ad_printformat updatedby numeric 10 User who updated this records
c_bpartner updatedby numeric 10 User who updated this records
c_dunning updatedby numeric 10 User who updated this records
c_dunninglevel updatedby numeric 10 User who updated this records
c_dunningrun updatedby numeric 10 User who updated this records
c_dunningrunentry updatedby numeric 10 User who updated this records
c_dunningrunline 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_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
c_invoice user1_id numeric 10  √  null User defined list element #1
c_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_bpartner value varchar 40 Search key for the record in the format required - must be unique
c_payment voiceauthcode varchar 20  √  null Voice Authorization Code from credit card company
c_payment writeoffamt numeric 0  √  0 Amount to write-off