テーブル定義書 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_payselection_remittance_vt
備考

カラム情報
No	物理名	データ型
1	ad_client_id	numeric(10)
2	ad_org_id	numeric(10)
3	ad_language	character varying(6)
4	c_payselection_id	numeric(10)
5	c_payselectionline_id	numeric(10)
6	c_payselectioncheck_id	numeric(10)
7	paymentrule	character(1)
8	line	numeric(10)
9	openamt	numeric
10	payamt	numeric
11	discountamt	numeric
12	differenceamt	numeric
13	c_bpartner_id	numeric(10)
14	documentno	character varying(30)
15	dateinvoiced	timestamp without time zone
16	grandtotal	numeric
17	amtinwords	numeric
18	c_invoice_id	numeric(10)
19	c_payselectionline_created	timestamp without time zone
20	c_payselectionline_createdby	numeric(10)
21	c_payselectionline_description	character varying(255)
22	c_payselectionline_isactive	character(1)
23	ismanual	character(1)
24	c_payselectionline_issotrx	character(1)
25	processed	character(1)
26	c_payselectionline_updated	timestamp without time zone
27	c_payselectionline_updatedby	numeric(10)
28	c_invoice_ad_org_id	numeric(10)
29	ad_orgtrx_id	numeric(10)
30	ad_user_id	numeric(10)
31	c_activity_id	numeric(10)
32	c_bpartner_location_id	numeric(10)
33	c_campaign_id	numeric(10)
34	c_charge_id	numeric(10)
35	c_conversiontype_id	numeric(10)
36	c_currency_id	numeric(10)
37	c_doctype_id	numeric(10)
38	c_doctypetarget_id	numeric(10)
39	c_dunninglevel_id	numeric(10)
40	chargeamt	numeric
41	c_payment_id	numeric(10)
42	c_paymentterm_id	numeric(10)
43	c_project_id	numeric(10)
44	c_invoice_created	timestamp without time zone
45	c_invoice_createdby	numeric(10)
46	dateacct	timestamp without time zone
47	dateordered	timestamp without time zone
48	dateprinted	timestamp without time zone
49	c_invoice_description	character varying(255)
50	docaction	character(2)
51	docstatus	character(2)
52	dunninggrace	date
53	generateto	character(1)
54	invoicecollectiontype	character(1)
55	c_invoice_isactive	character(1)
56	isapproved	character(1)
57	isdiscountprinted	character(1)
58	isindispute	character(1)
59	ispayschedulevalid	character(1)
60	isprinted	character(1)
61	c_invoice_isselfservice	character(1)
62	c_invoice_issotrx	character(1)
63	istaxincluded	character(1)
64	istransferred	character(1)
65	m_pricelist_id	numeric(10)
66	m_rma_id	numeric(10)
67	c_invoice_paymentrule	character(1)
68	poreference	character varying(20)
69	posted	character(1)
70	processedon	numeric
71	processing	character(1)
72	ref_invoice_id	numeric(10)
73	reversal_id	numeric(10)
74	sendemail	character(1)
75	totallines	numeric
76	c_invoice_updated	timestamp without time zone
77	c_invoice_updatedby	numeric(10)
78	user1_id	numeric(10)
79	user2_id	numeric(10)

ソース
ソース
SELECT psl.ad_client_id, psl.ad_org_id, l.ad_language, psl.c_payselection_id, psl.c_payselectionline_id, psl.c_payselectioncheck_id, psl.paymentrule, psl.line, psl.openamt, psl.payamt, psl.discountamt, psl.differenceamt, i.c_bpartner_id, i.documentno, i.dateinvoiced, i.grandtotal, i.grandtotal AS amtinwords, psl.c_invoice_id, psl.created AS c_payselectionline_created, psl.createdby AS c_payselectionline_createdby, psl.description AS c_payselectionline_description, psl.isactive AS c_payselectionline_isactive, psl.ismanual, psl.issotrx AS c_payselectionline_issotrx, psl.processed, psl.updated AS c_payselectionline_updated, psl.updatedby AS c_payselectionline_updatedby, i.ad_org_id AS c_invoice_ad_org_id, i.ad_orgtrx_id, i.ad_user_id, i.c_activity_id, i.c_bpartner_location_id, i.c_campaign_id, i.c_charge_id, i.c_conversiontype_id, i.c_currency_id, i.c_doctype_id, i.c_doctypetarget_id, i.c_dunninglevel_id, i.chargeamt, i.c_payment_id, i.c_paymentterm_id, i.c_project_id, i.created AS c_invoice_created, i.createdby AS c_invoice_createdby, i.dateacct, i.dateordered, i.dateprinted, i.description AS c_invoice_description, i.docaction, i.docstatus, i.dunninggrace, i.generateto, i.invoicecollectiontype, i.isactive AS c_invoice_isactive, i.isapproved, i.isdiscountprinted, i.isindispute, i.ispayschedulevalid, i.isprinted, i.isselfservice AS c_invoice_isselfservice, i.issotrx AS c_invoice_issotrx, i.istaxincluded, i.istransferred, i.m_pricelist_id, i.m_rma_id, i.paymentrule AS c_invoice_paymentrule, i.poreference, i.posted, i.processedon, i.processing, i.ref_invoice_id, i.reversal_id, i.sendemail, i.totallines, i.updated AS c_invoice_updated, i.updatedby AS c_invoice_updatedby, i.user1_id, i.user2_id FROM ((c_payselectionline psl JOIN c_invoice i ON ((psl.c_invoice_id = i.c_invoice_id))) JOIN ad_language l ON ((l.issystemlanguage = 'Y'::bpchar)));

ソース

 SELECT psl.ad_client_id,
    psl.ad_org_id,
    l.ad_language,
    psl.c_payselection_id,
    psl.c_payselectionline_id,
    psl.c_payselectioncheck_id,
    psl.paymentrule,
    psl.line,
    psl.openamt,
    psl.payamt,
    psl.discountamt,
    psl.differenceamt,
    i.c_bpartner_id,
    i.documentno,
    i.dateinvoiced,
    i.grandtotal,
    i.grandtotal AS amtinwords,
    psl.c_invoice_id,
    psl.created AS c_payselectionline_created,
    psl.createdby AS c_payselectionline_createdby,
    psl.description AS c_payselectionline_description,
    psl.isactive AS c_payselectionline_isactive,
    psl.ismanual,
    psl.issotrx AS c_payselectionline_issotrx,
    psl.processed,
    psl.updated AS c_payselectionline_updated,
    psl.updatedby AS c_payselectionline_updatedby,
    i.ad_org_id AS c_invoice_ad_org_id,
    i.ad_orgtrx_id,
    i.ad_user_id,
    i.c_activity_id,
    i.c_bpartner_location_id,
    i.c_campaign_id,
    i.c_charge_id,
    i.c_conversiontype_id,
    i.c_currency_id,
    i.c_doctype_id,
    i.c_doctypetarget_id,
    i.c_dunninglevel_id,
    i.chargeamt,
    i.c_payment_id,
    i.c_paymentterm_id,
    i.c_project_id,
    i.created AS c_invoice_created,
    i.createdby AS c_invoice_createdby,
    i.dateacct,
    i.dateordered,
    i.dateprinted,
    i.description AS c_invoice_description,
    i.docaction,
    i.docstatus,
    i.dunninggrace,
    i.generateto,
    i.invoicecollectiontype,
    i.isactive AS c_invoice_isactive,
    i.isapproved,
    i.isdiscountprinted,
    i.isindispute,
    i.ispayschedulevalid,
    i.isprinted,
    i.isselfservice AS c_invoice_isselfservice,
    i.issotrx AS c_invoice_issotrx,
    i.istaxincluded,
    i.istransferred,
    i.m_pricelist_id,
    i.m_rma_id,
    i.paymentrule AS c_invoice_paymentrule,
    i.poreference,
    i.posted,
    i.processedon,
    i.processing,
    i.ref_invoice_id,
    i.reversal_id,
    i.sendemail,
    i.totallines,
    i.updated AS c_invoice_updated,
    i.updatedby AS c_invoice_updatedby,
    i.user1_id,
    i.user2_id
   FROM ((c_payselectionline psl
     JOIN c_invoice i ON ((psl.c_invoice_id = i.c_invoice_id)))
     JOIN ad_language l ON ((l.issystemlanguage = 'Y'::bpchar)));

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

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

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

RDBMS固有の情報
No	プロパティ名	プロパティ値
1	schemaname	adempiere
2	viewname	c_payselection_remittance_vt
3	viewowner	adempiere
4	definition	SELECT psl.ad_client_id, psl.ad_org_id, l.ad_language, psl.c_payselection_id, psl.c_payselectionline_id, psl.c_payselectioncheck_id, psl.paymentrule, psl.line, psl.openamt, psl.payamt, psl.discountamt, psl.differenceamt, i.c_bpartner_id, i.documentno, i.dateinvoiced, i.grandtotal, i.grandtotal AS amtinwords, psl.c_invoice_id, psl.created AS c_payselectionline_created, psl.createdby AS c_payselectionline_createdby, psl.description AS c_payselectionline_description, psl.isactive AS c_payselectionline_isactive, psl.ismanual, psl.issotrx AS c_payselectionline_issotrx, psl.processed, psl.updated AS c_payselectionline_updated, psl.updatedby AS c_payselectionline_updatedby, i.ad_org_id AS c_invoice_ad_org_id, i.ad_orgtrx_id, i.ad_user_id, i.c_activity_id, i.c_bpartner_location_id, i.c_campaign_id, i.c_charge_id, i.c_conversiontype_id, i.c_currency_id, i.c_doctype_id, i.c_doctypetarget_id, i.c_dunninglevel_id, i.chargeamt, i.c_payment_id, i.c_paymentterm_id, i.c_project_id, i.created AS c_invoice_created, i.createdby AS c_invoice_createdby, i.dateacct, i.dateordered, i.dateprinted, i.description AS c_invoice_description, i.docaction, i.docstatus, i.dunninggrace, i.generateto, i.invoicecollectiontype, i.isactive AS c_invoice_isactive, i.isapproved, i.isdiscountprinted, i.isindispute, i.ispayschedulevalid, i.isprinted, i.isselfservice AS c_invoice_isselfservice, i.issotrx AS c_invoice_issotrx, i.istaxincluded, i.istransferred, i.m_pricelist_id, i.m_rma_id, i.paymentrule AS c_invoice_paymentrule, i.poreference, i.posted, i.processedon, i.processing, i.ref_invoice_id, i.reversal_id, i.sendemail, i.totallines, i.updated AS c_invoice_updated, i.updatedby AS c_invoice_updatedby, i.user1_id, i.user2_id FROM ((c_payselectionline psl JOIN c_invoice i ON ((psl.c_invoice_id = i.c_invoice_id))) JOIN ad_language l ON ((l.issystemlanguage = 'Y'::bpchar)));