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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 ad_client_id numeric(10)  
2 ad_org_id numeric(10)  
3 isactive character(1)  
4 created timestamp without time zone  
5 createdby numeric(10)  
6 updated timestamp without time zone  
7 updatedby numeric(10)  
8 c_invoice_id numeric(10)  
9 issotrx character(1)  
10 documentno character varying(30)  
11 docstatus character(2)  
12 c_doctype_id numeric(10)  
13 c_order_id numeric(10)  
14 description character varying(255)  
15 salesrep_id numeric(10)  
16 dateinvoiced timestamp without time zone  
17 dateacct timestamp without time zone  
18 c_paymentterm_id numeric(10)  
19 c_bpartner_id numeric(10)  
20 c_bpartner_location_id numeric(10)  
21 ad_user_id numeric(10)  
22 isselfservice character(1)  
23 c_currency_id numeric(10)  
24 c_conversiontype_id numeric(10)  
25 grandtotal numeric  
26 istaxincluded character(1)  
27 c_campaign_id numeric(10)  
28 c_project_id numeric(10)  
29 c_activity_id numeric(10)  
30 ad_orgtrx_id numeric(10)  
31 user1_id numeric(10)  
32 user2_id numeric(10)  
33 c_locfrom_id numeric(10)  
34 c_locto_id numeric(10)  
35 c_salesregion_id numeric(10)  
36 fact_acct_id numeric(10)  
37 c_acctschema_id numeric(10)  
38 account_id numeric(10)  
39 c_period_id numeric(10)  
40 gl_category_id numeric(10)  
41 gl_budget_id numeric(10)  
42 c_tax_id numeric(10)  
43 m_locator_id numeric(10)  
44 postingtype character(1)  
45 amtsourcedr numeric  
46 amtsourcecr numeric  
47 amtacctdr numeric  
48 amtacctcr numeric  
49 c_uom_id numeric(10)  
50 qty numeric  
51 ad_pinstance_id numeric(10)  
52 apar character(1)  
53 openamt numeric  
54 percent numeric  
55 amtrevaldr numeric  
56 amtrevalcr numeric  
57 datereval timestamp without time zone  
58 c_conversiontypereval_id numeric(10)  
59 amtsourcebalance numeric  
60 amtacctbalance numeric  
61 c_doctypereval_id numeric(10)  
62 amtrevaldrdiff numeric  
63 amtrevalcrdiff numeric  
64 isallcurrencies character(1)  
65 amtacctopendr numeric  
66 amtacctopencr numeric  
67 amtacctopenbalance numeric  
68 t_invoicegl_ad_org_id numeric(10)  
69 t_invoicegl_c_invoice_id numeric(10)  
70 t_invoicegl_created timestamp without time zone  
71 t_invoicegl_createdby numeric(10)  
72 t_invoicegl_grandtotal numeric  
73 t_invoicegl_isactive character(1)  
74 t_invoicegl_updated timestamp without time zone  
75 t_invoicegl_updatedby numeric(10)  
76 c_invoice_c_charge_id numeric(10)  
77 c_doctypetarget_id numeric(10)  
78 c_dunninglevel_id numeric(10)  
79 chargeamt numeric  
80 c_payment_id numeric(10)  
81 dateordered timestamp without time zone  
82 dateprinted timestamp without time zone  
83 docaction character(2)  
84 dunninggrace date  
85 generateto character(1)  
86 invoicecollectiontype character(1)  
87 isapproved character(1)  
88 isdiscountprinted character(1)  
89 isindispute character(1)  
90 ispaid character(1)  
91 ispayschedulevalid character(1)  
92 isprinted character(1)  
93 istransferred character(1)  
94 m_pricelist_id numeric(10)  
95 m_rma_id numeric(10)  
96 paymentrule character(1)  
97 poreference character varying(20)  
98 posted character(1)  
99 processedon numeric  
100 processing character(1)  
101 ref_invoice_id numeric(10)  
102 reversal_id numeric(10)  
103 sendemail character(1)  
104 totallines numeric  
105 a_asset_id numeric(10)  
106 fact_acct_ad_org_id numeric(10)  
107 fact_acct_ad_orgtrx_id numeric(10)  
108 fact_acct_ad_table_id numeric(10)  
109 fact_acct_c_activity_id numeric(10)  
110 fact_acct_c_bpartner_id numeric(10)  
111 fact_acct_c_campaign_id numeric(10)  
112 fact_acct_c_currency_id numeric(10)  
113 c_subacct_id numeric(10)  
114 fact_acct_dateacct timestamp without time zone  
115 datetrx timestamp without time zone  
116 fact_acct_description character varying(255)  
117 fact_acct_isactive character(1)  
118 line_id numeric(10)  
119 fact_acct_m_product_id numeric(10)  
120 record_id numeric(10)  
121 fact_acct_updated timestamp without time zone  
122 fact_acct_updatedby numeric(10)  
123 fact_acct_user1_id numeric(10)  
124 fact_acct_user2_id numeric(10)  
125 userelement1_id numeric(10)  
126 userelement2_id numeric(10)  


ソース
ソース 
 SELECT i.ad_client_id,
    i.ad_org_id,
    i.isactive,
    i.created,
    i.createdby,
    i.updated,
    i.updatedby,
    i.c_invoice_id,
    i.issotrx,
    i.documentno,
    i.docstatus,
    i.c_doctype_id,
    i.c_order_id,
    i.description,
    i.salesrep_id,
    i.dateinvoiced,
    i.dateacct,
    i.c_paymentterm_id,
    i.c_bpartner_id,
    i.c_bpartner_location_id,
    i.ad_user_id,
    i.isselfservice,
    i.c_currency_id,
    i.c_conversiontype_id,
    i.grandtotal,
    i.istaxincluded,
    i.c_campaign_id,
    i.c_project_id,
    i.c_activity_id,
    i.ad_orgtrx_id,
    i.user1_id,
    i.user2_id,
    fa.c_locfrom_id,
    fa.c_locto_id,
    fa.c_salesregion_id,
    fa.fact_acct_id,
    fa.c_acctschema_id,
    fa.account_id,
    fa.c_period_id,
    fa.gl_category_id,
    fa.gl_budget_id,
    fa.c_tax_id,
    fa.m_locator_id,
    fa.postingtype,
    fa.amtsourcedr,
    fa.amtsourcecr,
    fa.amtacctdr,
    fa.amtacctcr,
    fa.c_uom_id,
    fa.qty,
    gl.ad_pinstance_id,
    gl.apar,
    gl.openamt,
    gl.percent,
    gl.amtrevaldr,
    gl.amtrevalcr,
    gl.datereval,
    gl.c_conversiontypereval_id,
    gl.amtsourcebalance,
    gl.amtacctbalance,
    gl.c_doctypereval_id,
    gl.amtrevaldrdiff,
    gl.amtrevalcrdiff,
    gl.isallcurrencies,
    ((fa.amtacctdr * gl.percent) / (100)::numeric) AS amtacctopendr,
    ((fa.amtacctcr * gl.percent) / (100)::numeric) AS amtacctopencr,
    (((fa.amtacctdr - fa.amtacctcr) * gl.percent) / (100)::numeric) AS amtacctopenbalance,
    gl.ad_org_id AS t_invoicegl_ad_org_id,
    gl.c_invoice_id AS t_invoicegl_c_invoice_id,
    gl.created AS t_invoicegl_created,
    gl.createdby AS t_invoicegl_createdby,
    gl.grandtotal AS t_invoicegl_grandtotal,
    gl.isactive AS t_invoicegl_isactive,
    gl.updated AS t_invoicegl_updated,
    gl.updatedby AS t_invoicegl_updatedby,
    i.c_charge_id AS c_invoice_c_charge_id,
    i.c_doctypetarget_id,
    i.c_dunninglevel_id,
    i.chargeamt,
    i.c_payment_id,
    i.dateordered,
    i.dateprinted,
    i.docaction,
    i.dunninggrace,
    i.generateto,
    i.invoicecollectiontype,
    i.isapproved,
    i.isdiscountprinted,
    i.isindispute,
    i.ispaid,
    i.ispayschedulevalid,
    i.isprinted,
    i.istransferred,
    i.m_pricelist_id,
    i.m_rma_id,
    i.paymentrule,
    i.poreference,
    i.posted,
    i.processedon,
    i.processing,
    i.ref_invoice_id,
    i.reversal_id,
    i.sendemail,
    i.totallines,
    fa.a_asset_id,
    fa.ad_org_id AS fact_acct_ad_org_id,
    fa.ad_orgtrx_id AS fact_acct_ad_orgtrx_id,
    fa.ad_table_id AS fact_acct_ad_table_id,
    fa.c_activity_id AS fact_acct_c_activity_id,
    fa.c_bpartner_id AS fact_acct_c_bpartner_id,
    fa.c_campaign_id AS fact_acct_c_campaign_id,
    fa.c_currency_id AS fact_acct_c_currency_id,
    fa.c_subacct_id,
    fa.dateacct AS fact_acct_dateacct,
    fa.datetrx,
    fa.description AS fact_acct_description,
    fa.isactive AS fact_acct_isactive,
    fa.line_id,
    fa.m_product_id AS fact_acct_m_product_id,
    fa.record_id,
    fa.updated AS fact_acct_updated,
    fa.updatedby AS fact_acct_updatedby,
    fa.user1_id AS fact_acct_user1_id,
    fa.user2_id AS fact_acct_user2_id,
    fa.userelement1_id,
    fa.userelement2_id
   FROM ((t_invoicegl gl
     JOIN c_invoice i ON ((gl.c_invoice_id = i.c_invoice_id)))
     JOIN fact_acct fa ON ((gl.fact_acct_id = fa.fact_acct_id)));


インデックス情報
No インデックス名 カラムリスト ユニーク 備考


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname t_invoicegl_v
3 viewowner adempiere
4 definition SELECT i.ad_client_id,
i.ad_org_id,
i.isactive,
i.created,
i.createdby,
i.updated,
i.updatedby,
i.c_invoice_id,
i.issotrx,
i.documentno,
i.docstatus,
i.c_doctype_id,
i.c_order_id,
i.description,
i.salesrep_id,
i.dateinvoiced,
i.dateacct,
i.c_paymentterm_id,
i.c_bpartner_id,
i.c_bpartner_location_id,
i.ad_user_id,
i.isselfservice,
i.c_currency_id,
i.c_conversiontype_id,
i.grandtotal,
i.istaxincluded,
i.c_campaign_id,
i.c_project_id,
i.c_activity_id,
i.ad_orgtrx_id,
i.user1_id,
i.user2_id,
fa.c_locfrom_id,
fa.c_locto_id,
fa.c_salesregion_id,
fa.fact_acct_id,
fa.c_acctschema_id,
fa.account_id,
fa.c_period_id,
fa.gl_category_id,
fa.gl_budget_id,
fa.c_tax_id,
fa.m_locator_id,
fa.postingtype,
fa.amtsourcedr,
fa.amtsourcecr,
fa.amtacctdr,
fa.amtacctcr,
fa.c_uom_id,
fa.qty,
gl.ad_pinstance_id,
gl.apar,
gl.openamt,
gl.percent,
gl.amtrevaldr,
gl.amtrevalcr,
gl.datereval,
gl.c_conversiontypereval_id,
gl.amtsourcebalance,
gl.amtacctbalance,
gl.c_doctypereval_id,
gl.amtrevaldrdiff,
gl.amtrevalcrdiff,
gl.isallcurrencies,
((fa.amtacctdr * gl.percent) / (100)::numeric) AS amtacctopendr,
((fa.amtacctcr * gl.percent) / (100)::numeric) AS amtacctopencr,
(((fa.amtacctdr - fa.amtacctcr) * gl.percent) / (100)::numeric) AS amtacctopenbalance,
gl.ad_org_id AS t_invoicegl_ad_org_id,
gl.c_invoice_id AS t_invoicegl_c_invoice_id,
gl.created AS t_invoicegl_created,
gl.createdby AS t_invoicegl_createdby,
gl.grandtotal AS t_invoicegl_grandtotal,
gl.isactive AS t_invoicegl_isactive,
gl.updated AS t_invoicegl_updated,
gl.updatedby AS t_invoicegl_updatedby,
i.c_charge_id AS c_invoice_c_charge_id,
i.c_doctypetarget_id,
i.c_dunninglevel_id,
i.chargeamt,
i.c_payment_id,
i.dateordered,
i.dateprinted,
i.docaction,
i.dunninggrace,
i.generateto,
i.invoicecollectiontype,
i.isapproved,
i.isdiscountprinted,
i.isindispute,
i.ispaid,
i.ispayschedulevalid,
i.isprinted,
i.istransferred,
i.m_pricelist_id,
i.m_rma_id,
i.paymentrule,
i.poreference,
i.posted,
i.processedon,
i.processing,
i.ref_invoice_id,
i.reversal_id,
i.sendemail,
i.totallines,
fa.a_asset_id,
fa.ad_org_id AS fact_acct_ad_org_id,
fa.ad_orgtrx_id AS fact_acct_ad_orgtrx_id,
fa.ad_table_id AS fact_acct_ad_table_id,
fa.c_activity_id AS fact_acct_c_activity_id,
fa.c_bpartner_id AS fact_acct_c_bpartner_id,
fa.c_campaign_id AS fact_acct_c_campaign_id,
fa.c_currency_id AS fact_acct_c_currency_id,
fa.c_subacct_id,
fa.dateacct AS fact_acct_dateacct,
fa.datetrx,
fa.description AS fact_acct_description,
fa.isactive AS fact_acct_isactive,
fa.line_id,
fa.m_product_id AS fact_acct_m_product_id,
fa.record_id,
fa.updated AS fact_acct_updated,
fa.updatedby AS fact_acct_updatedby,
fa.user1_id AS fact_acct_user1_id,
fa.user2_id AS fact_acct_user2_id,
fa.userelement1_id,
fa.userelement2_id
FROM ((t_invoicegl gl
JOIN c_invoice i ON ((gl.c_invoice_id = i.c_invoice_id)))
JOIN fact_acct fa ON ((gl.fact_acct_id = fa.fact_acct_id)));