View idempiere11.adempiere.c_payselection_check_v
Check Print View

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10  √  null Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within tenant
ad_language varchar 6  √  null Language for this entity
c_payselection_id numeric 10  √  null Payment Selection
c_payselectioncheck_id numeric 10  √  null Payment Selection Check
org_location_id numeric 10  √  null Organization Location/Address
taxid varchar 20  √  null Tax Identification
c_doctype_id numeric 10  √  null Document type or rules
c_bpartner_id numeric 10  √  null Identifies a Business Partner
bpvalue varchar 40  √  null Business Partner Key Value
bptaxid varchar 20  √  null Tax ID of the Business Partner
naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
duns varchar 11  √  null Dun & Bradstreet Number
bpgreeting varchar 60  √  null Greeting for Business Partner
name varchar 120  √  null Alphanumeric identifier of the entity
name2 varchar 60  √  null Additional Name
c_location_id numeric 0  √  null Location or Address
referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
paydate timestamp 29,6  √  null Date Payment made
payamt numeric 0  √  null Amount being paid
amtinwords numeric 0  √  null Amount in words
qty numeric 0  √  null Quantity
paymentrule bpchar 1  √  null How you pay the invoice
documentno varchar 30  √  null Document sequence number of the document
logo_id numeric 10  √  null Logo
documenttype varchar 60  √  null Document Type
documenttypenote varchar 2000  √  null Optional note of a document type
description varchar 255  √  null Optional short description of the record
bankaccountdescription varchar 255  √  null Bank Account Description
c_bp_bankaccount_id numeric 10  √  null Bank Account of the Business Partner
c_payment_id numeric 10  √  null Payment identifier
c_payselectioncheck_created timestamp 29,6  √  null c_payselectioncheck_created
c_payselectioncheck_createdby numeric 10  √  null c_payselectioncheck_createdby
c_payselectioncheck_discamt numeric 0  √  null c_payselectioncheck_discamt
c_payselectioncheck_isactive bpchar 1  √  null c_payselectioncheck_isactive
isgenerateddraft bpchar 1  √  null Generated Draft
isprinted bpchar 1  √  null Indicates if this document / line is printed
isreceipt bpchar 1  √  null This is a sales transaction (receipt)
processed bpchar 1  √  null The document has been processed
c_payselectioncheck_updated timestamp 29,6  √  null c_payselectioncheck_updated
c_payselectioncheck_updatedby numeric 10  √  null c_payselectioncheck_updatedby
c_payselection_ad_org_id numeric 10  √  null c_payselection_ad_org_id
c_paysel_c_bankaccount_id numeric 10  √  null c_paysel_c_bankaccount_id
c_payselection_created timestamp 29,6  √  null c_payselection_created
c_payselection_createdby numeric 10  √  null c_payselection_createdby
c_payselection_description varchar 255  √  null c_payselection_description
c_payselection_isactive bpchar 1  √  null c_payselection_isactive
c_payselection_isapproved bpchar 1  √  null c_payselection_isapproved
c_payselection_name varchar 120  √  null c_payselection_name
c_payselection_processed bpchar 1  √  null c_payselection_processed
totalamt numeric 0  √  null Total Amount
c_payselection_updated timestamp 29,6  √  null c_payselection_updated
c_payselection_updatedby numeric 10  √  null c_payselection_updatedby
a_city varchar 60  √  null City or the Credit Card or Account Holder
a_country varchar 40  √  null Country
c_payment_ad_org_id numeric 10  √  null c_payment_ad_org_id
a_email varchar 60  √  null Email Address
a_ident_dl varchar 20  √  null Payment Identification - Driver License
a_name varchar 60  √  null Name on Credit Card or Account holder
a_state varchar 40  √  null State of the Credit Card or Account holder
a_street varchar 60  √  null Street address of the Credit Card or Account holder
a_zip varchar 20  √  null Zip Code of the Credit Card or Account Holder
c_activity_id numeric 10  √  null Business Activity
c_payment_c_bpartner_id numeric 10  √  null c_payment_c_bpartner_id
c_campaign_id numeric 10  √  null Marketing Campaign
c_payment_c_charge_id numeric 10  √  null C_Payment_C_Charge_ID
c_conversiontype_id numeric 10  √  null Currency Conversion Rate Type
c_currency_id numeric 10  √  null The Currency for this record
c_payment_chargeamt numeric 0  √  null c_payment_chargeamt
checkno varchar 20  √  null Check Number
c_payment_c_invoice_id numeric 10  √  null C_Payment_C_Invoice_ID
c_payment_c_order_id numeric 10  √  null c_payment_c_order_id
c_paymentbatch_id numeric 10  √  null Payment batch for EFT
c_project_id numeric 10  √  null Financial Project
c_payment_created timestamp 29,6  √  null c_payment_created
c_payment_createdby numeric 10  √  null c_payment_createdby
dateacct timestamp 29,6  √  null Accounting Date
datetrx timestamp 29,6  √  null Transaction Date
c_payment_discountamt numeric 0  √  null c_payment_discountamt
docstatus bpchar 2  √  null The current status of the document
c_payment_documentno varchar 30  √  null c_payment_documentno
c_payment_isactive bpchar 1  √  null c_payment_isactive
isallocated bpchar 1  √  null Indicates if the payment has been allocated
isapproved bpchar 1  √  null Indicates if this document requires approval
isdelayedcapture bpchar 1  √  null Charge after Shipment
isonline bpchar 1  √  null Can be accessed online
isoverunderpayment bpchar 1  √  null Over-Payment (unallocated) or Under-Payment (partial payment)
isprepayment bpchar 1  √  null The Payment/Receipt is a Prepayment
isreconciled bpchar 1  √  null Payment is reconciled with bank statement
c_payment_isselfservice bpchar 1  √  null c_payment_isselfservice
micr varchar 20  √  null Combination of routing no, account and check no
orig_trxid varchar 20  √  null Original Transaction ID
overunderamt numeric 0  √  null Over-Payment (unallocated) or Under-Payment (partial payment) Amount
c_payment_payamt numeric 0  √  null c_payment_payamt
ponum varchar 60  √  null Purchase Order Number
c_payment_posted bpchar 1  √  null c_payment_posted
c_payment_processed bpchar 1  √  null c_payment_processed
c_payment_processedon numeric 0  √  null c_payment_processedon
r_authcode varchar 20  √  null Authorization Code returned
r_authcode_dc varchar 20  √  null Authorization Code Delayed Capture returned
r_avsaddr bpchar 1  √  null This address has been verified
r_avszip bpchar 1  √  null The Zip Code has been verified
r_cvv2match bpchar 1  √  null Credit Card Verification Code Match
ref_payment_id numeric 10  √  null Referenced Payment
c_payment_reversal_id numeric 10  √  null c_payment_reversal_id
r_info varchar 2000  √  null Response info
routingno varchar 20  √  null Bank Routing Number
r_pnref varchar 20  √  null Payment reference
r_pnref_dc varchar 20  √  null Payment Reference Delayed Capture
r_respmsg varchar 60  √  null Response message
r_result varchar 20  √  null Result of transmission
swipe varchar 80  √  null Track 1 and 2 of the Credit Card
taxamt numeric 0  √  null Tax Amount for a document
tendertype bpchar 1  √  null Method of Payment
trxtype bpchar 1  √  null Type of credit card transaction
c_payment_updated timestamp 29,6  √  null c_payment_updated
c_payment_updatedby numeric 10  √  null c_payment_updatedby
user1_id numeric 10  √  null User defined list element #1
user2_id numeric 10  √  null User defined list element #2
voiceauthcode varchar 20  √  null Voice Authorization Code from credit card company
writeoffamt numeric 0  √  null Amount to write-off
c_bp_acqusitioncost numeric 0  √  null c_bp_acqusitioncost
c_bp_actuallifetimevalue numeric 0  √  null c_bp_actuallifetimevalue
c_bp_ad_language varchar 6  √  null c_bp_ad_language
c_bp_ad_orgbp_id numeric 10  √  null c_bp_ad_orgbp_id
c_bp_ad_org_id numeric 10  √  null c_bp_ad_org_id
c_bp_bpartner_parent_id numeric 10  √  null c_bp_bpartner_parent_id
c_bp_c_bp_group_id numeric 10  √  null c_bp_c_bp_group_id
c_bp_c_dunning_id numeric 10  √  null c_bp_c_dunning_id
c_bp_c_greeting_id numeric 10  √  null c_bp_c_greeting_id
c_bp_c_invoiceschedule_id numeric 10  √  null c_bp_c_invoiceschedule_id
c_bp_c_paymentterm_id numeric 10  √  null c_bp_c_paymentterm_id
c_bp_created timestamp 29,6  √  null c_bp_created
c_bp_createdby numeric 10  √  null c_bp_createdby
c_bp_c_taxgroup_id numeric 10  √  null c_bp_c_taxgroup_id
c_bp_deliveryrule bpchar 1  √  null c_bp_deliveryrule
c_bp_deliveryviarule bpchar 1  √  null c_bp_deliveryviarule
c_bp_description varchar 255  √  null c_bp_description
c_bp_dunninggrace timestamp 29,6  √  null c_bp_dunninggrace
c_bp_firstsale timestamp 29,6  √  null c_bp_firstsale
c_bp_flatdiscount numeric 0  √  null c_bp_flatdiscount
c_bp_freightcostrule bpchar 1  √  null c_bp_freightcostrule
c_bp_invoicerule bpchar 1  √  null c_bp_invoicerule
c_bp_isactive bpchar 1  √  null c_bp_isactive
c_bp_iscustomer bpchar 1  √  null c_bp_iscustomer
c_bp_isdiscountprinted bpchar 1  √  null c_bp_isdiscountprinted
c_bp_isemployee bpchar 1  √  null c_bp_isemployee
c_bp_ismanufacturer bpchar 1  √  null c_bp_ismanufacturer
c_bp_isonetime bpchar 1  √  null c_bp_isonetime
c_bp_ispotaxexempt bpchar 1  √  null c_bp_ispotaxexempt
c_bp_isprospect bpchar 1  √  null c_bp_isprospect
c_bp_issalesrep bpchar 1  √  null c_bp_issalesrep
c_bp_issummary bpchar 1  √  null c_bp_issummary
c_bp_istaxexempt bpchar 1  √  null c_bp_istaxexempt
c_bp_isvendor bpchar 1  √  null c_bp_isvendor
c_bp_logo_id numeric 10  √  null c_bp_logo_id
c_bp_m_discountschema_id numeric 10  √  null c_bp_m_discountschema_id
c_bp_m_pricelist_id numeric 10  √  null c_bp_m_pricelist_id
c_bp_numberemployees numeric 10  √  null c_bp_numberemployees
c_bp_paymentrule bpchar 1  √  null c_bp_paymentrule
c_bp_paymentrulepo bpchar 1  √  null c_bp_paymentrulepo
c_bp_po_discountschema_id numeric 10  √  null c_bp_po_discountschema_id
c_bp_po_paymentterm_id numeric 10  √  null c_bp_po_paymentterm_id
c_bp_po_pricelist_id numeric 10  √  null c_bp_po_pricelist_id
c_bp_potentiallifetimevalue numeric 0  √  null c_bp_potentiallifetimevalue
c_bp_rating bpchar 1  √  null c_bp_rating
c_bp_salesrep_id numeric 10  √  null c_bp_salesrep_id
c_bp_salesvolume numeric 10  √  null c_bp_salesvolume
c_bp_sendemail bpchar 1  √  null c_bp_sendemail
c_bp_shareofcustomer numeric 10  √  null c_bp_shareofcustomer
c_bp_shelflifeminpct numeric 10  √  null c_bp_shelflifeminpct
c_bp_so_creditlimit numeric 0  √  null c_bp_so_creditlimit
c_bp_socreditstatus bpchar 1  √  null c_bp_socreditstatus
c_bp_so_creditused numeric 0  √  null c_bp_so_creditused
c_bp_so_description varchar 255  √  null c_bp_so_description
c_bp_totalopenbalance numeric 0  √  null c_bp_totalopenbalance
c_bp_updated timestamp 29,6  √  null c_bp_updated
c_bp_updatedby numeric 10  √  null c_bp_updatedby
c_bp_url varchar 120  √  null c_bp_url
c_greeting_ad_org_id numeric 10  √  null c_greeting_ad_org_id
c_greeting_isactive bpchar 1  √  null c_greeting_isactive
isfirstnameonly bpchar 1  √  null Print only the first name in greetings
c_greeting_name varchar 60  √  null c_greeting_name
ad_orginfo_ad_org_id numeric 10  √  null ad_orginfo_ad_org_id
ad_orgtype_id numeric 10  √  null Organization Type
c_calendar_id numeric 10  √  null Accounting Calendar Name
ad_orginfo_created timestamp 29,6  √  null ad_orginfo_created
ad_orginfo_createdby numeric 10  √  null ad_orginfo_createdby
dropship_warehouse_id numeric 10  √  null The (logical) warehouse to use for recording drop ship receipts and shipments.
ad_orginfo_duns varchar 11  √  null ad_orginfo_duns
ad_orginfo_email varchar 60  √  null ad_orginfo_email
ad_orginfo_fax varchar 40  √  null ad_orginfo_fax
ad_orginfo_isactive bpchar 1  √  null ad_orginfo_isactive
m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
parent_org_id numeric 10  √  null Parent (superior) Organization
ad_orginfo_phone varchar 40  √  null ad_orginfo_phone
ad_orginfo_phone2 varchar 40  √  null ad_orginfo_phone2
receiptfootermsg varchar 1023  √  null This message will be displayed at the bottom of a receipt when doing a sales or purchase
supervisor_id numeric 10  √  null Supervisor for this user/organization - used for escalation and approval
ad_orginfo_updated timestamp 29,6  √  null ad_orginfo_updated
ad_orginfo_updatedby numeric 10  √  null ad_orginfo_updatedby

Analyzed at 2024-01-03 13:44 +0100