|
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 |
i_payment_id |
numeric |
10 |
|
|
|
|
|
ad_client_id |
numeric |
10 |
√ |
|
null |
|
|
ad_org_id |
numeric |
10 |
√ |
|
null |
|
|
isactive |
bpchar |
1 |
√ |
|
'Y'::bpchar |
|
|
created |
timestamp |
29,6 |
|
|
statement_timestamp() |
|
|
createdby |
numeric |
10 |
√ |
|
null |
|
|
updated |
timestamp |
29,6 |
|
|
statement_timestamp() |
|
|
updatedby |
numeric |
10 |
√ |
|
null |
|
|
i_isimported |
bpchar |
1 |
|
|
'N'::bpchar |
|
|
i_errormsg |
varchar |
2000 |
√ |
|
null |
|
|
processed |
bpchar |
1 |
√ |
|
'N'::bpchar |
|
|
c_payment_id |
numeric |
10 |
√ |
|
null |
|
|
documentno |
varchar |
30 |
√ |
|
null |
|
|
datetrx |
timestamp |
29,6 |
√ |
|
null |
|
|
isreceipt |
bpchar |
1 |
√ |
|
'Y'::bpchar |
|
|
c_doctype_id |
numeric |
10 |
√ |
|
null |
|
|
doctypename |
varchar |
60 |
√ |
|
null |
|
|
trxtype |
bpchar |
1 |
√ |
|
null |
|
|
c_bankaccount_id |
numeric |
10 |
√ |
|
null |
|
|
bankaccountno |
varchar |
20 |
√ |
|
null |
|
|
c_bpartner_id |
numeric |
10 |
√ |
|
null |
|
|
bpartnervalue |
varchar |
40 |
√ |
|
null |
|
|
c_invoice_id |
numeric |
10 |
√ |
|
null |
|
|
invoicedocumentno |
varchar |
30 |
√ |
|
null |
|
|
tendertype |
bpchar |
1 |
√ |
|
null |
|
|
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_country |
varchar |
40 |
√ |
|
null |
|
|
a_ident_dl |
varchar |
20 |
√ |
|
null |
|
|
a_ident_ssn |
varchar |
20 |
√ |
|
null |
|
|
a_email |
varchar |
60 |
√ |
|
null |
|
|
voiceauthcode |
varchar |
20 |
√ |
|
null |
|
|
swipe |
varchar |
80 |
√ |
|
null |
|
|
orig_trxid |
varchar |
20 |
√ |
|
null |
|
|
ponum |
varchar |
60 |
√ |
|
null |
|
|
c_currency_id |
numeric |
10 |
√ |
|
null |
|
|
payamt |
numeric |
0 |
√ |
|
0 |
|
|
discountamt |
numeric |
0 |
√ |
|
0 |
|
|
writeoffamt |
numeric |
0 |
√ |
|
0 |
|
|
isoverunderpayment |
bpchar |
1 |
√ |
|
'N'::bpchar |
|
|
overunderamt |
numeric |
0 |
√ |
|
0 |
|
|
c_charge_id |
numeric |
10 |
√ |
|
null |
|
|
chargename |
varchar |
60 |
√ |
|
null |
|
|
chargeamt |
numeric |
0 |
√ |
|
0 |
|
|
taxamt |
numeric |
0 |
√ |
|
0 |
|
|
isapproved |
bpchar |
1 |
√ |
|
'N'::bpchar |
|
|
isselfservice |
bpchar |
1 |
√ |
|
'N'::bpchar |
|
|
isdelayedcapture |
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_info |
varchar |
2000 |
√ |
|
null |
|
|
processing |
bpchar |
1 |
√ |
|
null |
|
|
iso_code |
bpchar |
3 |
√ |
|
null |
|
|
dateacct |
timestamp |
29,6 |
√ |
|
null |
|
|
i_payment_uu |
varchar |
36 |
√ |
|
NULL::character varying |
|
|
iban |
varchar |
40 |
√ |
|
NULL::character varying |
|
|
swiftcode |
varchar |
20 |
√ |
|
NULL::character varying |
|
|
Table contained 0 rows at 2024-01-03 13:44 +0100
|
Indexes:
Column(s) |
Type |
Sort |
Constraint Name |
i_payment_id |
Primary key |
Asc |
i_payment_pkey |
i_payment_uu |
Must be unique |
Asc |
i_payment_uu_idx |
SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.