Table idempiere9.adempiere.c_pospayment
POS Payment

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
accountno varchar 20  √  NULL::character varying Account Number
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
a_name varchar 60  √  NULL::character varying Name on Credit Card or Account holder
checkno varchar 20  √  NULL::character varying Check Number
checkstatus bpchar 1  √  NULL::bpchar Check Status
c_order_id numeric 10
c_order.c_order_id corder_cpospayment R
Order
c_payment_id numeric 10  √  NULL::numeric
c_payment.c_payment_id cpayment_cpospayment R
Payment identifier
c_pospayment_id numeric 10 POS Payment
c_pospayment_uu varchar 36  √  NULL::character varying C_POSPayment_UU
c_postendertype_id numeric 10
c_postendertype.c_postendertype_id cpostendertype_cpospayment R
POS Tender Type
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
creditcardnumber varchar 20  √  NULL::character varying Credit Card Number
creditcardtype bpchar 1  √  NULL::bpchar Credit Card (Visa, MC, AmEx)
datepromised timestamp 29,6  √  null Date Order was promised
depositgroup varchar 20  √  NULL::character varying Deposit Group
help varchar 2000  √  NULL::character varying Comment or Hint
isactive bpchar 1 'Y'::bpchar The record is active in the system
ispostdated bpchar 1 'N'::bpchar Post Dated
micr varchar 20  √  NULL::character varying Combination of routing no, account and check no
payamt numeric 0 Amount being paid
processed bpchar 1 The document has been processed
routingno varchar 20  √  NULL::character varying Bank Routing Number
tendertype bpchar 1  √  NULL::bpchar Method of Payment
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10 User who updated this records
voiceauthcode varchar 20  √  NULL::character varying Voice Authorization Code from credit card company
iban varchar 40  √  NULL::character varying International Bank Account Number
swiftcode varchar 20  √  NULL::character varying Swift Code or BIC

Table contained 0 rows at 2021-12-25 14:52 +0100

Indexes:
Column(s) Type Sort Constraint Name
c_pospayment_id Primary key Asc c_pospayment_key
c_pospayment_uu Must be unique Asc c_pospayment_uu_idx

Close relationships  within of separation: