テーブル情報
システム名 http://www.as-link.com/  作成者 秦　松甫 
サブシステム名 ERPlus@iDempiere3.1_daily  作成日 2016/3/7 
スキーマ名 adempiere  更新日  
論理テーブル名   RDBMS  PostgreSQL 9.4.5 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.3 20140911 (Red Hat 4.8.3-9), 64-bit 9.4.5 
物理テーブル名 i_payment     
備考


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 i_payment_id numeric(10) Yes (PK)
2 ad_client_id numeric(10)  
3 ad_org_id numeric(10)  
4 isactive character(1)   'Y'
5 created timestamp without time zone Yes statement_timestamp()
6 createdby numeric(10)  
7 updated timestamp without time zone Yes statement_timestamp()
8 updatedby numeric(10)  
9 i_isimported character(1) Yes 'N'
10 i_errormsg character varying(2000)  
11 processed character(1)   'N'
12 c_payment_id numeric(10)  
13 documentno character varying(30)  
14 datetrx timestamp without time zone  
15 isreceipt character(1)   'Y'
16 c_doctype_id numeric(10)  
17 doctypename character varying(60)  
18 trxtype character(1)  
19 c_bankaccount_id numeric(10)  
20 bankaccountno character varying(20)  
21 c_bpartner_id numeric(10)  
22 bpartnervalue character varying(40)  
23 c_invoice_id numeric(10)  
24 invoicedocumentno character varying(30)  
25 tendertype character(1)  
26 creditcardtype character(1)  
27 creditcardnumber character varying(20)  
28 creditcardvv character varying(4)  
29 creditcardexpmm numeric(10)  
30 creditcardexpyy numeric(10)  
31 micr character varying(20)  
32 routingno character varying(20)  
33 accountno character varying(20)  
34 checkno character varying(20)  
35 a_name character varying(60)  
36 a_street character varying(60)  
37 a_city character varying(60)  
38 a_state character varying(40)  
39 a_zip character varying(20)  
40 a_country character varying(40)  
41 a_ident_dl character varying(20)  
42 a_ident_ssn character varying(20)  
43 a_email character varying(60)  
44 voiceauthcode character varying(20)  
45 swipe character varying(80)  
46 orig_trxid character varying(20)  
47 ponum character varying(60)  
48 c_currency_id numeric(10)  
49 payamt numeric   0
50 discountamt numeric   0
51 writeoffamt numeric   0
52 isoverunderpayment character(1)   'N'
53 overunderamt numeric   0
54 c_charge_id numeric(10)  
55 chargename character varying(60)  
56 chargeamt numeric   0
57 taxamt numeric   0
58 isapproved character(1)   'N'
59 isselfservice character(1)   'N'
60 isdelayedcapture character(1)   'N'
61 r_pnref character varying(20)  
62 r_result character varying(20)  
63 r_respmsg character varying(60)  
64 r_authcode character varying(20)  
65 r_info character varying(2000)  
66 processing character(1)  
67 iso_code character(3)  
68 dateacct timestamp without time zone  
69 i_payment_uu character varying(36)   NULL


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 i_payment_pkey i_payment_id Yes  
2 i_payment_uu_idx i_payment_uu Yes  


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 cbankaccount_ipayment c_bankaccount_id adempiere.c_bankaccount c_bankaccount_id
2 cbpartner_ipayment c_bpartner_id adempiere.c_bpartner c_bpartner_id
3 ccharge_ipayment c_charge_id adempiere.c_charge c_charge_id
4 ccurrency_ipayment c_currency_id adempiere.c_currency c_currency_id
5 cdoctype_ipayment c_doctype_id adempiere.c_doctype c_doctype_id
6 cinvoice_ipayment c_invoice_id adempiere.c_invoice c_invoice_id
7 cpayment_ipayment c_payment_id adempiere.c_payment c_payment_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 tablename i_payment
3 tableowner adempiere
4 tablespace
5 hasindexes True
6 hasrules False
7 hastriggers True