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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 c_invoice_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 issotrx character(1) Yes 'Y'
10 documentno character varying(30) Yes
11 docstatus character(2) Yes
12 docaction character(2) Yes
13 processing character(1)  
14 processed character(1) Yes 'N'
15 posted character(1) Yes 'N'
16 c_doctype_id numeric(10) Yes
17 c_doctypetarget_id numeric(10) Yes
18 c_order_id numeric(10)  
19 description character varying(255)  
20 isapproved character(1) Yes 'Y'
21 istransferred character(1) Yes 'N'
22 isprinted character(1) Yes 'N'
23 salesrep_id numeric(10)  
24 dateinvoiced timestamp without time zone Yes
25 dateprinted timestamp without time zone  
26 dateacct timestamp without time zone Yes
27 c_bpartner_id numeric(10) Yes
28 c_bpartner_location_id numeric(10) Yes
29 poreference character varying(20)  
30 isdiscountprinted character(1) Yes 'Y'
31 dateordered timestamp without time zone  
32 c_currency_id numeric(10) Yes
33 paymentrule character(1) Yes
34 c_paymentterm_id numeric(10) Yes
35 c_charge_id numeric(10)  
36 chargeamt numeric   0
37 totallines numeric Yes 0
38 grandtotal numeric Yes 0
39 m_pricelist_id numeric(10) Yes
40 istaxincluded character(1) Yes 'N'
41 c_campaign_id numeric(10)  
42 c_project_id numeric(10)  
43 c_activity_id numeric(10)  
44 ispaid character(1) Yes 'N'
45 c_payment_id numeric(10)  
46 c_cashline_id numeric(10)  
47 createfrom character(1)  
48 generateto character(1)  
49 sendemail character(1) Yes 'N'
50 ad_user_id numeric(10)  
51 copyfrom character(1)  
52 isselfservice character(1) Yes 'N'
53 ad_orgtrx_id numeric(10)  
54 user1_id numeric(10)  
55 user2_id numeric(10)  
56 c_conversiontype_id numeric(10)  
57 ispayschedulevalid character(1) Yes 'N'
58 ref_invoice_id numeric(10)  
59 isindispute character(1) Yes 'N'
60 invoicecollectiontype character(1)  
61 m_rma_id numeric(10)  
62 dunninggrace date  
63 c_dunninglevel_id numeric(10)  
64 reversal_id numeric(10)  
65 processedon numeric  
66 c_cashplanline_id numeric(10)   NULL
67 c_invoice_uu character varying(36)   NULL
68 isfixedassetinvoice character(1)  


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 c_invoice_documentno documentno,c_doctype_id,c_bpartner_id Yes  
2 c_invoice_documentno_target c_bpartner_id,documentno,c_doctypetarget_id Yes  
3 c_invoice_key c_invoice_id Yes  
4 c_invoice_order c_order_id    
5 c_invoice_paid ispaid,ad_client_id    
6 c_invoice_pkey c_invoice_id Yes  
7 c_invoice_uu_idx c_invoice_uu Yes  
8 idxc_invoice_proc_on posted,processed,processedon,ad_client_id    


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 adorg_cinvoice ad_org_id adempiere.ad_org ad_org_id
2 adorgtrx_cinvoice ad_orgtrx_id adempiere.ad_org ad_org_id
3 aduser_cinvoice ad_user_id adempiere.ad_user ad_user_id
4 aduser_sr_cinvoice salesrep_id adempiere.ad_user ad_user_id
5 c_bplocation_cinvoice c_bpartner_location_id adempiere.c_bpartner_location c_bpartner_location_id
6 cactivity_cinvoice c_activity_id adempiere.c_activity c_activity_id
7 cbpartner_cinvoice c_bpartner_id adempiere.c_bpartner c_bpartner_id
8 ccampaign_cinvoice c_campaign_id adempiere.c_campaign c_campaign_id
9 ccashline_cinvoice c_cashline_id adempiere.c_cashline c_cashline_id
10 ccashplanline_cinvoice c_cashplanline_id adempiere.c_cashplanline c_cashplanline_id
11 ccharge_cinvoice c_charge_id adempiere.c_charge c_charge_id
12 cconversiontype_cinvoice c_conversiontype_id adempiere.c_conversiontype c_conversiontype_id
13 ccurrency_cinvoice c_currency_id adempiere.c_currency c_currency_id
14 cdoctype_cinvoice c_doctype_id adempiere.c_doctype c_doctype_id
15 cdoctypetarget_cinvoice c_doctypetarget_id adempiere.c_doctype c_doctype_id
16 cdunninglevel_cinvoice c_dunninglevel_id adempiere.c_dunninglevel c_dunninglevel_id
17 celementvalueuser1_cinvoice user1_id adempiere.c_elementvalue c_elementvalue_id
18 celementvalueuser2_cinvoice user2_id adempiere.c_elementvalue c_elementvalue_id
19 cinvoice_ref ref_invoice_id adempiere.c_invoice c_invoice_id
20 corder_cinvoice c_order_id adempiere.c_order c_order_id
21 cpayment_cinvoice c_payment_id adempiere.c_payment c_payment_id
22 cpaymentterm_cinvoice c_paymentterm_id adempiere.c_paymentterm c_paymentterm_id
23 cproject_cinvoice c_project_id adempiere.c_project c_project_id
24 mpricelist_cinvoice m_pricelist_id adempiere.m_pricelist m_pricelist_id
25 mrma_cinvoice m_rma_id adempiere.m_rma m_rma_id
26 reversal_cinvoice reversal_id adempiere.c_invoice c_invoice_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト
1 cinvoice_aassetaddition c_invoice_id adempiere.a_asset_addition c_invoice_id
2 cinvoice_aassetdisposed c_invoice_id adempiere.a_asset_disposed c_invoice_id
3 cinvoice_callocationline c_invoice_id adempiere.c_allocationline c_invoice_id
4 cinvoice_cbankstatementline c_invoice_id adempiere.c_bankstatementline c_invoice_id
5 cinvoice_ccashline c_invoice_id adempiere.c_cashline c_invoice_id
6 cinvoice_cdunningrunline c_invoice_id adempiere.c_dunningrunline c_invoice_id
7 cinvoice_cinvoicebatchline c_invoice_id adempiere.c_invoicebatchline c_invoice_id
8 cinvoice_cinvoiceline c_invoice_id adempiere.c_invoiceline c_invoice_id
9 cinvoice_cinvoicepaysched c_invoice_id adempiere.c_invoicepayschedule c_invoice_id
10 cinvoice_cinvoicetax c_invoice_id adempiere.c_invoicetax c_invoice_id
11 cinvoice_cpayment c_invoice_id adempiere.c_payment c_invoice_id
12 cinvoice_cpaymentallocate c_invoice_id adempiere.c_paymentallocate c_invoice_id
13 cinvoice_cpaymenttransaction c_invoice_id adempiere.c_paymenttransaction c_invoice_id
14 cinvoice_cpayselectline c_invoice_id adempiere.c_payselectionline c_invoice_id
15 cinvoice_crecurring c_invoice_id adempiere.c_recurring c_invoice_id
16 cinvoice_crecurringrun c_invoice_id adempiere.c_recurring_run c_invoice_id
17 cinvoice_ctaxdeclline c_invoice_id adempiere.c_taxdeclarationline c_invoice_id
18 cinvoice_ddorder c_invoice_id adempiere.dd_order c_invoice_id
19 cinvoice_ibankstatement c_invoice_id adempiere.i_bankstatement c_invoice_id
20 cinvoice_iinvoice c_invoice_id adempiere.i_invoice c_invoice_id
21 cinvoice_ipayment c_invoice_id adempiere.i_payment c_invoice_id
22 cinvoice_minout c_invoice_id adempiere.m_inout c_invoice_id
23 cinvoice_minoutconfirm c_invoice_id adempiere.m_inoutconfirm c_invoice_id
24 cinvoice_mshippingtransaction c_invoice_id adempiere.m_shippingtransaction c_invoice_id
25 cinvoice_ref c_invoice_id adempiere.c_invoice ref_invoice_id
26 cinvoice_rrequestaction c_invoice_id adempiere.r_requestaction c_invoice_id
27 cinvoice_tinvoicegl c_invoice_id adempiere.t_invoicegl c_invoice_id
28 cinvoicerequest_rrequest c_invoice_id adempiere.r_request c_invoicerequest_id
29 reversal_cinvoice c_invoice_id adempiere.c_invoice reversal_id
30 rinvoice_rrequest c_invoice_id adempiere.r_request c_invoice_id


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