テーブル定義書 http://www.as-link.com/ ERPlus@iDempiere3.1

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

カラム情報
No	物理名	データ型
1	c_invoice_id	numeric(10)
2	ad_client_id	numeric(10)
3	ad_org_id	numeric(10)
4	isactive	character(1)
5	created	timestamp without time zone
6	createdby	numeric(10)
7	updated	timestamp without time zone
8	updatedby	numeric(10)
9	issotrx	character(1)
10	documentno	character varying(30)
11	docstatus	character(2)
12	docaction	character(2)
13	processing	character(1)
14	processed	character(1)
15	c_doctype_id	numeric(10)
16	c_doctypetarget_id	numeric(10)
17	c_order_id	numeric(10)
18	description	character varying(255)
19	isapproved	character(1)
20	istransferred	character(1)
21	salesrep_id	numeric(10)
22	dateinvoiced	timestamp without time zone
23	dateprinted	timestamp without time zone
24	dateacct	timestamp without time zone
25	c_bpartner_id	numeric(10)
26	c_bpartner_location_id	numeric(10)
27	ad_user_id	numeric(10)
28	poreference	character varying(20)
29	dateordered	timestamp without time zone
30	c_currency_id	numeric(10)
31	c_conversiontype_id	numeric(10)
32	paymentrule	character(1)
33	c_paymentterm_id	numeric(10)
34	c_charge_id	numeric(10)
35	m_pricelist_id	numeric(10)
36	c_campaign_id	numeric(10)
37	c_project_id	numeric(10)
38	c_activity_id	numeric(10)
39	isprinted	character(1)
40	isdiscountprinted	character(1)
41	ispaid	character(1)
42	isindispute	character(1)
43	ispayschedulevalid	character(1)
44	c_invoicepayschedule_id	numeric
45	invoicecollectiontype	character(1)
46	dunninggrace	date
47	chargeamt	numeric
48	totallines	numeric
49	grandtotal	numeric
50	multiplier	numeric
51	multiplierap	numeric
52	docbasetype	character(3)
53	duedate	timestamp with time zone
54	ad_orgtrx_id	numeric(10)
55	c_payment_id	numeric(10)
56	isselfservice	character(1)
57	posted	character(1)
58	processedon	numeric
59	reversal_id	numeric(10)

ソース
ソース
SELECT i.c_invoice_id, i.ad_client_id, i.ad_org_id, i.isactive, i.created, i.createdby, i.updated, i.updatedby, i.issotrx, i.documentno, i.docstatus, i.docaction, i.processing, i.processed, i.c_doctype_id, i.c_doctypetarget_id, i.c_order_id, i.description, i.isapproved, i.istransferred, i.salesrep_id, i.dateinvoiced, i.dateprinted, i.dateacct, i.c_bpartner_id, i.c_bpartner_location_id, i.ad_user_id, i.poreference, i.dateordered, i.c_currency_id, i.c_conversiontype_id, i.paymentrule, i.c_paymentterm_id, i.c_charge_id, i.m_pricelist_id, i.c_campaign_id, i.c_project_id, i.c_activity_id, i.isprinted, i.isdiscountprinted, i.ispaid, i.isindispute, i.ispayschedulevalid, NULL::numeric AS c_invoicepayschedule_id, i.invoicecollectiontype, i.dunninggrace, CASE WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (i.chargeamt * ((-1))::numeric) ELSE i.chargeamt END AS chargeamt, CASE WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (i.totallines * ((-1))::numeric) ELSE i.totallines END AS totallines, CASE WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (i.grandtotal * ((-1))::numeric) ELSE i.grandtotal END AS grandtotal, CASE WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (-1.0) ELSE 1.0 END AS multiplier, CASE WHEN ((charat((d.docbasetype)::character varying, 2))::text = 'P'::text) THEN (-1.0) ELSE 1.0 END AS multiplierap, d.docbasetype, paymenttermduedate(i.c_paymentterm_id, (i.dateinvoiced)::timestamp with time zone) AS duedate, i.ad_orgtrx_id, i.c_payment_id, i.isselfservice, i.posted, i.processedon, i.reversal_id FROM (c_invoice i JOIN c_doctype d ON ((i.c_doctype_id = d.c_doctype_id))) WHERE (i.ispayschedulevalid <> 'Y'::bpchar) UNION SELECT i.c_invoice_id, i.ad_client_id, i.ad_org_id, i.isactive, i.created, i.createdby, i.updated, i.updatedby, i.issotrx, i.documentno, i.docstatus, i.docaction, i.processing, i.processed, i.c_doctype_id, i.c_doctypetarget_id, i.c_order_id, i.description, i.isapproved, i.istransferred, i.salesrep_id, i.dateinvoiced, i.dateprinted, i.dateacct, i.c_bpartner_id, i.c_bpartner_location_id, i.ad_user_id, i.poreference, i.dateordered, i.c_currency_id, i.c_conversiontype_id, i.paymentrule, i.c_paymentterm_id, i.c_charge_id, i.m_pricelist_id, i.c_campaign_id, i.c_project_id, i.c_activity_id, i.isprinted, i.isdiscountprinted, i.ispaid, i.isindispute, i.ispayschedulevalid, ips.c_invoicepayschedule_id, i.invoicecollectiontype, i.dunninggrace, NULL::numeric AS chargeamt, NULL::numeric AS totallines, CASE WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (ips.dueamt * ((-1))::numeric) ELSE ips.dueamt END AS grandtotal, CASE WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (-1) ELSE 1 END AS multiplier, CASE WHEN ((charat((d.docbasetype)::character varying, 2))::text = 'P'::text) THEN (-1) ELSE 1 END AS multiplierap, d.docbasetype, ips.duedate, i.ad_orgtrx_id, i.c_payment_id, i.isselfservice, i.posted, i.processedon, i.reversal_id FROM ((c_invoice i JOIN c_doctype d ON ((i.c_doctype_id = d.c_doctype_id))) JOIN c_invoicepayschedule ips ON ((i.c_invoice_id = ips.c_invoice_id))) WHERE ((i.ispayschedulevalid = 'Y'::bpchar) AND (ips.isvalid = 'Y'::bpchar));

ソース

 SELECT i.c_invoice_id,
    i.ad_client_id,
    i.ad_org_id,
    i.isactive,
    i.created,
    i.createdby,
    i.updated,
    i.updatedby,
    i.issotrx,
    i.documentno,
    i.docstatus,
    i.docaction,
    i.processing,
    i.processed,
    i.c_doctype_id,
    i.c_doctypetarget_id,
    i.c_order_id,
    i.description,
    i.isapproved,
    i.istransferred,
    i.salesrep_id,
    i.dateinvoiced,
    i.dateprinted,
    i.dateacct,
    i.c_bpartner_id,
    i.c_bpartner_location_id,
    i.ad_user_id,
    i.poreference,
    i.dateordered,
    i.c_currency_id,
    i.c_conversiontype_id,
    i.paymentrule,
    i.c_paymentterm_id,
    i.c_charge_id,
    i.m_pricelist_id,
    i.c_campaign_id,
    i.c_project_id,
    i.c_activity_id,
    i.isprinted,
    i.isdiscountprinted,
    i.ispaid,
    i.isindispute,
    i.ispayschedulevalid,
    NULL::numeric AS c_invoicepayschedule_id,
    i.invoicecollectiontype,
    i.dunninggrace,
        CASE
            WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (i.chargeamt * ((-1))::numeric)
            ELSE i.chargeamt
        END AS chargeamt,
        CASE
            WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (i.totallines * ((-1))::numeric)
            ELSE i.totallines
        END AS totallines,
        CASE
            WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (i.grandtotal * ((-1))::numeric)
            ELSE i.grandtotal
        END AS grandtotal,
        CASE
            WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (-1.0)
            ELSE 1.0
        END AS multiplier,
        CASE
            WHEN ((charat((d.docbasetype)::character varying, 2))::text = 'P'::text) THEN (-1.0)
            ELSE 1.0
        END AS multiplierap,
    d.docbasetype,
    paymenttermduedate(i.c_paymentterm_id, (i.dateinvoiced)::timestamp with time zone) AS duedate,
    i.ad_orgtrx_id,
    i.c_payment_id,
    i.isselfservice,
    i.posted,
    i.processedon,
    i.reversal_id
   FROM (c_invoice i
     JOIN c_doctype d ON ((i.c_doctype_id = d.c_doctype_id)))
  WHERE (i.ispayschedulevalid <> 'Y'::bpchar)
UNION
 SELECT i.c_invoice_id,
    i.ad_client_id,
    i.ad_org_id,
    i.isactive,
    i.created,
    i.createdby,
    i.updated,
    i.updatedby,
    i.issotrx,
    i.documentno,
    i.docstatus,
    i.docaction,
    i.processing,
    i.processed,
    i.c_doctype_id,
    i.c_doctypetarget_id,
    i.c_order_id,
    i.description,
    i.isapproved,
    i.istransferred,
    i.salesrep_id,
    i.dateinvoiced,
    i.dateprinted,
    i.dateacct,
    i.c_bpartner_id,
    i.c_bpartner_location_id,
    i.ad_user_id,
    i.poreference,
    i.dateordered,
    i.c_currency_id,
    i.c_conversiontype_id,
    i.paymentrule,
    i.c_paymentterm_id,
    i.c_charge_id,
    i.m_pricelist_id,
    i.c_campaign_id,
    i.c_project_id,
    i.c_activity_id,
    i.isprinted,
    i.isdiscountprinted,
    i.ispaid,
    i.isindispute,
    i.ispayschedulevalid,
    ips.c_invoicepayschedule_id,
    i.invoicecollectiontype,
    i.dunninggrace,
    NULL::numeric AS chargeamt,
    NULL::numeric AS totallines,
        CASE
            WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (ips.dueamt * ((-1))::numeric)
            ELSE ips.dueamt
        END AS grandtotal,
        CASE
            WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (-1)
            ELSE 1
        END AS multiplier,
        CASE
            WHEN ((charat((d.docbasetype)::character varying, 2))::text = 'P'::text) THEN (-1)
            ELSE 1
        END AS multiplierap,
    d.docbasetype,
    ips.duedate,
    i.ad_orgtrx_id,
    i.c_payment_id,
    i.isselfservice,
    i.posted,
    i.processedon,
    i.reversal_id
   FROM ((c_invoice i
     JOIN c_doctype d ON ((i.c_doctype_id = d.c_doctype_id)))
     JOIN c_invoicepayschedule ips ON ((i.c_invoice_id = ips.c_invoice_id)))
  WHERE ((i.ispayschedulevalid = 'Y'::bpchar) AND (ips.isvalid = 'Y'::bpchar));

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

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

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

RDBMS固有の情報
No	プロパティ名	プロパティ値
1	schemaname	adempiere
2	viewname	c_invoice_v
3	viewowner	adempiere
4	definition	SELECT i.c_invoice_id, i.ad_client_id, i.ad_org_id, i.isactive, i.created, i.createdby, i.updated, i.updatedby, i.issotrx, i.documentno, i.docstatus, i.docaction, i.processing, i.processed, i.c_doctype_id, i.c_doctypetarget_id, i.c_order_id, i.description, i.isapproved, i.istransferred, i.salesrep_id, i.dateinvoiced, i.dateprinted, i.dateacct, i.c_bpartner_id, i.c_bpartner_location_id, i.ad_user_id, i.poreference, i.dateordered, i.c_currency_id, i.c_conversiontype_id, i.paymentrule, i.c_paymentterm_id, i.c_charge_id, i.m_pricelist_id, i.c_campaign_id, i.c_project_id, i.c_activity_id, i.isprinted, i.isdiscountprinted, i.ispaid, i.isindispute, i.ispayschedulevalid, NULL::numeric AS c_invoicepayschedule_id, i.invoicecollectiontype, i.dunninggrace, CASE WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (i.chargeamt * ((-1))::numeric) ELSE i.chargeamt END AS chargeamt, CASE WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (i.totallines * ((-1))::numeric) ELSE i.totallines END AS totallines, CASE WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (i.grandtotal * ((-1))::numeric) ELSE i.grandtotal END AS grandtotal, CASE WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (-1.0) ELSE 1.0 END AS multiplier, CASE WHEN ((charat((d.docbasetype)::character varying, 2))::text = 'P'::text) THEN (-1.0) ELSE 1.0 END AS multiplierap, d.docbasetype, paymenttermduedate(i.c_paymentterm_id, (i.dateinvoiced)::timestamp with time zone) AS duedate, i.ad_orgtrx_id, i.c_payment_id, i.isselfservice, i.posted, i.processedon, i.reversal_id FROM (c_invoice i JOIN c_doctype d ON ((i.c_doctype_id = d.c_doctype_id))) WHERE (i.ispayschedulevalid <> 'Y'::bpchar) UNION SELECT i.c_invoice_id, i.ad_client_id, i.ad_org_id, i.isactive, i.created, i.createdby, i.updated, i.updatedby, i.issotrx, i.documentno, i.docstatus, i.docaction, i.processing, i.processed, i.c_doctype_id, i.c_doctypetarget_id, i.c_order_id, i.description, i.isapproved, i.istransferred, i.salesrep_id, i.dateinvoiced, i.dateprinted, i.dateacct, i.c_bpartner_id, i.c_bpartner_location_id, i.ad_user_id, i.poreference, i.dateordered, i.c_currency_id, i.c_conversiontype_id, i.paymentrule, i.c_paymentterm_id, i.c_charge_id, i.m_pricelist_id, i.c_campaign_id, i.c_project_id, i.c_activity_id, i.isprinted, i.isdiscountprinted, i.ispaid, i.isindispute, i.ispayschedulevalid, ips.c_invoicepayschedule_id, i.invoicecollectiontype, i.dunninggrace, NULL::numeric AS chargeamt, NULL::numeric AS totallines, CASE WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (ips.dueamt * ((-1))::numeric) ELSE ips.dueamt END AS grandtotal, CASE WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (-1) ELSE 1 END AS multiplier, CASE WHEN ((charat((d.docbasetype)::character varying, 2))::text = 'P'::text) THEN (-1) ELSE 1 END AS multiplierap, d.docbasetype, ips.duedate, i.ad_orgtrx_id, i.c_payment_id, i.isselfservice, i.posted, i.processedon, i.reversal_id FROM ((c_invoice i JOIN c_doctype d ON ((i.c_doctype_id = d.c_doctype_id))) JOIN c_invoicepayschedule ips ON ((i.c_invoice_id = ips.c_invoice_id))) WHERE ((i.ispayschedulevalid = 'Y'::bpchar) AND (ips.isvalid = 'Y'::bpchar));