テーブル情報
システム名 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 
物理テーブル名 c_payment     
備考


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 c_payment_id numeric(10) Yes (PK)
2 ad_client_id numeric(10) Yes
3 ad_org_id numeric(10) Yes
4 isactive character(1) Yes 'Y'
5 created timestamp without time zone Yes now()
6 createdby numeric(10) Yes
7 updated timestamp without time zone Yes now()
8 updatedby numeric(10) Yes
9 documentno character varying(30) Yes
10 datetrx timestamp without time zone Yes
11 isreceipt character(1) Yes 'Y'
12 c_doctype_id numeric(10) Yes
13 trxtype character(1) Yes
14 c_bankaccount_id numeric(10)  
15 c_bpartner_id numeric(10)  
16 c_invoice_id numeric(10)  
17 c_bp_bankaccount_id numeric(10)  
18 c_paymentbatch_id numeric(10)  
19 tendertype character(1) Yes
20 creditcardtype character(1)  
21 creditcardnumber character varying(20)  
22 creditcardvv character varying(4)  
23 creditcardexpmm numeric(10)  
24 creditcardexpyy numeric(10)  
25 micr character varying(20)  
26 routingno character varying(20)  
27 accountno character varying(20)  
28 checkno character varying(20)  
29 a_name character varying(60)  
30 a_street character varying(60)  
31 a_city character varying(60)  
32 a_state character varying(40)  
33 a_zip character varying(20)  
34 a_ident_dl character varying(20)  
35 a_ident_ssn character varying(20)  
36 a_email character varying(60)  
37 voiceauthcode character varying(20)  
38 orig_trxid character varying(20)  
39 ponum character varying(60)  
40 c_currency_id numeric(10) Yes
41 payamt numeric Yes 0
42 discountamt numeric   0
43 writeoffamt numeric   0
44 taxamt numeric   0
45 isapproved character(1) Yes 'N'
46 r_pnref character varying(20)  
47 r_result character varying(20)  
48 r_respmsg character varying(60)  
49 r_authcode character varying(20)  
50 r_avsaddr character(1)  
51 r_avszip character(1)  
52 r_info character varying(2000)  
53 processing character(1)  
54 oprocessing character(1)  
55 docstatus character(2) Yes
56 docaction character(2) Yes
57 isreconciled character(1) Yes 'N'
58 isallocated character(1) Yes 'N'
59 isonline character(1) Yes 'N'
60 processed character(1) Yes 'N'
61 posted character(1) Yes 'N'
62 isoverunderpayment character(1) Yes 'Y'
63 overunderamt numeric   0
64 a_country character varying(40)  
65 c_project_id numeric(10)  
66 isselfservice character(1) Yes 'N'
67 chargeamt numeric   0
68 c_charge_id numeric(10)  
69 isdelayedcapture character(1) Yes 'N'
70 r_authcode_dc character varying(20)  
71 r_cvv2match character(1)  
72 r_pnref_dc character varying(20)  
73 swipe character varying(80)  
74 ad_orgtrx_id numeric(10)  
75 c_campaign_id numeric(10)  
76 c_activity_id numeric(10)  
77 user1_id numeric(10)  
78 user2_id numeric(10)  
79 c_conversiontype_id numeric(10)  
80 description character varying(255)  
81 dateacct timestamp without time zone Yes
82 c_order_id numeric(10)  
83 isprepayment character(1) Yes 'N'
84 ref_payment_id numeric(10)  
85 reversal_id numeric(10)  
86 c_cashbook_id numeric(10)  
87 processedon numeric  
88 c_payment_uu character varying(36)   NULL
89 c_postendertype_id numeric(10)   NULL
90 c_paymentprocessor_id numeric(10)   NULL
91 customerpaymentprofileid character varying(60)   NULL
92 customerprofileid character varying(60)   NULL
93 customeraddressid character varying(60)   NULL
94 isvoided character(1) Yes 'N'
95 r_voidmsg character varying(255)   NULL
96 c_depositbatch_id numeric(10)   NULL


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 c_payment_bankaccount c_bankaccount_id    
2 c_payment_bpartner c_bpartner_id    
3 c_payment_pkey c_payment_id Yes  
4 c_payment_uu_idx c_payment_uu Yes  
5 idxc_payment_proc_on posted,processed,processedon,ad_client_id    


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 adorg_cpayment ad_org_id adempiere.ad_org ad_org_id
2 adorgtrx_cpayment ad_orgtrx_id adempiere.ad_org ad_org_id
3 c_payment__c_cashbo_c_cashbook c_cashbook_id adempiere.c_cashbook c_cashbook_id
4 cactivity_cpayment c_activity_id adempiere.c_activity c_activity_id
5 cbankaccount_cpayment c_bankaccount_id adempiere.c_bankaccount c_bankaccount_id
6 cbpartner_cpayment c_bpartner_id adempiere.c_bpartner c_bpartner_id
7 cbpbankacct_cpayment c_bp_bankaccount_id adempiere.c_bp_bankaccount c_bp_bankaccount_id
8 ccampaign_cpayment c_campaign_id adempiere.c_campaign c_campaign_id
9 ccharge_cpayment c_charge_id adempiere.c_charge c_charge_id
10 cconversiontype_cpayment c_conversiontype_id adempiere.c_conversiontype c_conversiontype_id
11 ccurrency_cpayment c_currency_id adempiere.c_currency c_currency_id
12 cdepositbatch_cpayment c_depositbatch_id adempiere.c_depositbatch c_depositbatch_id
13 cdoctype_cpayment c_doctype_id adempiere.c_doctype c_doctype_id
14 celementvalueuser1_cpayment user1_id adempiere.c_elementvalue c_elementvalue_id
15 celementvalueuser2_cpayment user2_id adempiere.c_elementvalue c_elementvalue_id
16 cinvoice_cpayment c_invoice_id adempiere.c_invoice c_invoice_id
17 corder_cpayment c_order_id adempiere.c_order c_order_id
18 cpaymentbatch_cpayment c_paymentbatch_id adempiere.c_paymentbatch c_paymentbatch_id
19 cpaymentprocessor_cpayment c_paymentprocessor_id adempiere.c_paymentprocessor c_paymentprocessor_id
20 cpostendertype_cpayment c_postendertype_id adempiere.c_postendertype c_postendertype_id
21 cproject_cpayment c_project_id adempiere.c_project c_project_id
22 refpayment_cpayment ref_payment_id adempiere.c_payment c_payment_id
23 reversal_cpayment reversal_id adempiere.c_payment c_payment_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト
1 cpayment_bbuyerfunds c_payment_id adempiere.b_buyerfunds c_payment_id
2 cpayment_bsellerfunds c_payment_id adempiere.b_sellerfunds c_payment_id
3 cpayment_callocationline c_payment_id adempiere.c_allocationline c_payment_id
4 cpayment_cbankstmtline c_payment_id adempiere.c_bankstatementline c_payment_id
5 cpayment_ccashline c_payment_id adempiere.c_cashline c_payment_id
6 cpayment_cdepositbatchline c_payment_id adempiere.c_depositbatchline c_payment_id
7 cpayment_cdunningrunline c_payment_id adempiere.c_dunningrunline c_payment_id
8 cpayment_cinvoice c_payment_id adempiere.c_invoice c_payment_id
9 cpayment_corder c_payment_id adempiere.c_order c_payment_id
10 cpayment_cpaymentallocate c_payment_id adempiere.c_paymentallocate c_payment_id
11 cpayment_cpaymenttransaction c_payment_id adempiere.c_paymenttransaction c_payment_id
12 cpayment_cpayselectioncheck c_payment_id adempiere.c_payselectioncheck c_payment_id
13 cpayment_cpospayment c_payment_id adempiere.c_pospayment c_payment_id
14 cpayment_crecurring c_payment_id adempiere.c_recurring c_payment_id
15 cpayment_crecurringrun c_payment_id adempiere.c_recurring_run c_payment_id
16 cpayment_ibankstatement c_payment_id adempiere.i_bankstatement c_payment_id
17 cpayment_ipayment c_payment_id adempiere.i_payment c_payment_id
18 cpayment_rrequest c_payment_id adempiere.r_request c_payment_id
19 cpayment_rrequestaction c_payment_id adempiere.r_requestaction c_payment_id
20 refpayment_cpayment c_payment_id adempiere.c_payment ref_payment_id
21 reversal_cpayment c_payment_id adempiere.c_payment reversal_id


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