c_payment_id |
numeric |
10 |
|
|
|
|
|
ad_client_id |
numeric |
10 |
|
|
|
|
|
ad_org_id |
numeric |
10 |
|
|
|
|
|
isactive |
bpchar |
1 |
|
|
'Y'::bpchar |
|
|
created |
timestamp |
29,6 |
|
|
now() |
|
|
createdby |
numeric |
10 |
|
|
|
|
|
updated |
timestamp |
29,6 |
|
|
now() |
|
|
updatedby |
numeric |
10 |
|
|
|
|
|
documentno |
varchar |
30 |
|
|
|
|
|
datetrx |
timestamp |
29,6 |
|
|
|
|
|
isreceipt |
bpchar |
1 |
|
|
'Y'::bpchar |
|
|
c_doctype_id |
numeric |
10 |
|
|
|
|
|
trxtype |
bpchar |
1 |
|
|
|
|
|
c_bankaccount_id |
numeric |
10 |
√ |
|
null |
|
|
c_bpartner_id |
numeric |
10 |
√ |
|
null |
|
|
c_invoice_id |
numeric |
10 |
√ |
|
null |
|
|
c_bp_bankaccount_id |
numeric |
10 |
√ |
|
null |
|
|
c_paymentbatch_id |
numeric |
10 |
√ |
|
null |
|
|
tendertype |
bpchar |
1 |
|
|
|
|
|
creditcardtype |
bpchar |
1 |
√ |
|
null |
|
|
creditcardnumber |
varchar |
20 |
√ |
|
null |
|
|
creditcardvv |
varchar |
4 |
√ |
|
null |
|
|
creditcardexpmm |
numeric |
10 |
√ |
|
null |
|
|
creditcardexpyy |
numeric |
10 |
√ |
|
null |
|
|
micr |
varchar |
20 |
√ |
|
null |
|
|
routingno |
varchar |
20 |
√ |
|
null |
|
|
accountno |
varchar |
20 |
√ |
|
null |
|
|
checkno |
varchar |
20 |
√ |
|
null |
|
|
a_name |
varchar |
60 |
√ |
|
null |
|
|
a_street |
varchar |
60 |
√ |
|
null |
|
|
a_city |
varchar |
60 |
√ |
|
null |
|
|
a_state |
varchar |
40 |
√ |
|
null |
|
|
a_zip |
varchar |
20 |
√ |
|
null |
|
|
a_ident_dl |
varchar |
20 |
√ |
|
null |
|
|
a_ident_ssn |
varchar |
20 |
√ |
|
null |
|
|
a_email |
varchar |
60 |
√ |
|
null |
|
|
voiceauthcode |
varchar |
20 |
√ |
|
null |
|
|
orig_trxid |
varchar |
20 |
√ |
|
null |
|
|
ponum |
varchar |
60 |
√ |
|
null |
|
|
c_currency_id |
numeric |
10 |
|
|
|
|
|
payamt |
numeric |
0 |
|
|
0 |
|
|
discountamt |
numeric |
0 |
√ |
|
0 |
|
|
writeoffamt |
numeric |
0 |
√ |
|
0 |
|
|
taxamt |
numeric |
0 |
√ |
|
0 |
|
|
isapproved |
bpchar |
1 |
|
|
'N'::bpchar |
|
|
r_pnref |
varchar |
20 |
√ |
|
null |
|
|
r_result |
varchar |
20 |
√ |
|
null |
|
|
r_respmsg |
varchar |
60 |
√ |
|
null |
|
|
r_authcode |
varchar |
20 |
√ |
|
null |
|
|
r_avsaddr |
bpchar |
1 |
√ |
|
null |
|
|
r_avszip |
bpchar |
1 |
√ |
|
null |
|
|
r_info |
varchar |
2000 |
√ |
|
null |
|
|
processing |
bpchar |
1 |
√ |
|
null |
|
|
oprocessing |
bpchar |
1 |
√ |
|
null |
|
|
docstatus |
bpchar |
2 |
|
|
|
|
|
docaction |
bpchar |
2 |
|
|
|
|
|
isreconciled |
bpchar |
1 |
|
|
'N'::bpchar |
|
|
isallocated |
bpchar |
1 |
|
|
'N'::bpchar |
|
|
isonline |
bpchar |
1 |
|
|
'N'::bpchar |
|
|
processed |
bpchar |
1 |
|
|
'N'::bpchar |
|
|
posted |
bpchar |
1 |
|
|
'N'::bpchar |
|
|
isoverunderpayment |
bpchar |
1 |
|
|
'Y'::bpchar |
|
|
overunderamt |
numeric |
0 |
√ |
|
0 |
|
|
a_country |
varchar |
40 |
√ |
|
null |
|
|
c_project_id |
numeric |
10 |
√ |
|
null |
|
|
isselfservice |
bpchar |
1 |
|
|
'N'::bpchar |
|
|
chargeamt |
numeric |
0 |
√ |
|
0 |
|
|
c_charge_id |
numeric |
10 |
√ |
|
null |
|
|
isdelayedcapture |
bpchar |
1 |
|
|
'N'::bpchar |
|
|
r_authcode_dc |
varchar |
20 |
√ |
|
null |
|
|
r_cvv2match |
bpchar |
1 |
√ |
|
null |
|
|
r_pnref_dc |
varchar |
20 |
√ |
|
null |
|
|
swipe |
varchar |
80 |
√ |
|
null |
|
|
ad_orgtrx_id |
numeric |
10 |
√ |
|
null |
|
|
c_campaign_id |
numeric |
10 |
√ |
|
null |
|
|
c_activity_id |
numeric |
10 |
√ |
|
null |
|
|
user1_id |
numeric |
10 |
√ |
|
null |
|
|
user2_id |
numeric |
10 |
√ |
|
null |
|
|
c_conversiontype_id |
numeric |
10 |
√ |
|
null |
|
|
description |
varchar |
255 |
√ |
|
null |
|
|
dateacct |
timestamp |
29,6 |
|
|
|
|
|
c_order_id |
numeric |
10 |
√ |
|
null |
|
|
isprepayment |
bpchar |
1 |
|
|
'N'::bpchar |
|
|
ref_payment_id |
numeric |
10 |
√ |
|
null |
|
|
reversal_id |
numeric |
10 |
√ |
|
null |
|
|
c_cashbook_id |
numeric |
10 |
√ |
|
null |
|
|
processedon |
numeric |
0 |
√ |
|
null |
|
|
c_payment_uu |
varchar |
36 |
√ |
|
NULL::character varying |
|
|
c_postendertype_id |
numeric |
10 |
√ |
|
NULL::numeric |
|
|
c_paymentprocessor_id |
numeric |
10 |
√ |
|
NULL::numeric |
|
|
customerpaymentprofileid |
varchar |
60 |
√ |
|
NULL::character varying |
|
|
customerprofileid |
varchar |
60 |
√ |
|
NULL::character varying |
|
|
customeraddressid |
varchar |
60 |
√ |
|
NULL::character varying |
|
|
isvoided |
bpchar |
1 |
|
|
'N'::bpchar |
|
|
r_voidmsg |
varchar |
255 |
√ |
|
NULL::character varying |
|
|
c_depositbatch_id |
numeric |
10 |
√ |
|
NULL::numeric |
|
|
iban |
varchar |
40 |
√ |
|
NULL::character varying |
|
|
swiftcode |
varchar |
20 |
√ |
|
NULL::character varying |
|
|
currencyrate |
numeric |
0 |
√ |
|
null |
|
|
convertedamt |
numeric |
0 |
√ |
|
null |
|
|
isoverridecurrencyrate |
bpchar |
1 |
|
|
'N'::bpchar |
|
|
c_banktransfer_id |
numeric |
10 |
√ |
|
NULL::numeric |
|
|