テーブル情報
システム名 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 論理名 物理名 データ型 Not Null デフォルト 備考
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)));


インデックス情報
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)));