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


カラム情報
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 ad_language character varying(6)  
9 c_dunningrunline_id numeric(10)  
10 c_dunningrunentry_id numeric(10)  
11 amt numeric  
12 convertedamt numeric  
13 daysdue numeric(10)  
14 timesdunned numeric(10)  
15 interestamt numeric  
16 feeamt numeric  
17 totalamt numeric  
18 c_invoice_id numeric(10)  
19 issotrx character(1)  
20 documentno character varying(30)  
21 docstatus character(2)  
22 datetrx timestamp without time zone  
23 c_doctype_id numeric(10)  
24 documenttype character varying(60)  
25 description character varying(255)  
26 c_currency_id numeric(10)  
27 c_campaign_id numeric(10)  
28 c_project_id numeric(10)  
29 c_activity_id numeric(10)  
30 user1_id numeric(10)  
31 user2_id numeric(10)  
32 dateacct timestamp without time zone  
33 c_conversiontype_id numeric(10)  
34 ad_orgtrx_id numeric(10)  
35 poreference character varying(20)  
36 dateordered timestamp without time zone  
37 dateinvoiced timestamp without time zone  
38 isindispute character(1)  
39 paymentterm character varying(60)  
40 c_charge_id numeric(10)  
41 chargeamt numeric  
42 totallines numeric  
43 grandtotal numeric  
44 amtinwords numeric  
45 m_pricelist_id numeric(10)  
46 ispaid character(1)  
47 isallocated character(1)  
48 tendertype character(1)  
49 discountamt numeric  
50 c_invoicepayschedule_id numeric(10)  
51 c_payment_id numeric(10)  
52 c_dunningrunline_isindispute character(1)  
53 openamt numeric  
54 c_dunningrunline_processed character(1)  
55 c_invoice_ad_org_id numeric(10)  
56 ad_user_id numeric(10)  
57 c_invoice_c_bpartner_id numeric(10)  
58 c_bpartner_location_id numeric(10)  
59 c_doctypetarget_id numeric(10)  
60 c_dunninglevel_id numeric(10)  
61 c_invoice_c_order_id numeric(10)  
62 c_invoice_c_payment_id numeric(10)  
63 c_invoice_created timestamp without time zone  
64 c_invoice_createdby numeric(10)  
65 dateprinted timestamp without time zone  
66 docaction character(2)  
67 dunninggrace date  
68 generateto character(1)  
69 invoicecollectiontype character(1)  
70 c_invoice_isactive character(1)  
71 c_invoice_isapproved character(1)  
72 isdiscountprinted character(1)  
73 ispayschedulevalid character(1)  
74 isprinted character(1)  
75 c_invoice_isselfservice character(1)  
76 istaxincluded character(1)  
77 istransferred character(1)  
78 m_rma_id numeric(10)  
79 paymentrule character(1)  
80 c_invoice_posted character(1)  
81 c_invoice_processedon numeric  
82 processing character(1)  
83 ref_invoice_id numeric(10)  
84 c_invoice_reversal_id numeric(10)  
85 salesrep_id numeric(10)  
86 sendemail character(1)  
87 c_invoice_updated timestamp without time zone  
88 c_invoice_updatedby numeric(10)  
89 c_paymentterm_ad_org_id numeric(10)  
90 afterdelivery character(1)  
91 c_paymentterm_id numeric(10)  
92 c_paymentterm_description character varying(255)  
93 discount numeric  
94 discount2 numeric  
95 discountdays numeric(10)  
96 discountdays2 numeric(10)  
97 documentnote character varying(2000)  
98 fixmonthcutoff numeric(10)  
99 fixmonthday numeric(10)  
100 fixmonthoffset numeric(10)  
101 gracedays numeric(10)  
102 c_paymentterm_isactive character(1)  
103 isduefixed character(1)  
104 isnextbusinessday character(1)  
105 isvalid character(1)  
106 netday character(1)  
107 netdays numeric(10)  
108 paymenttermusage character(1)  
109 c_paymentterm_value character varying(40)  
110 a_city character varying(60)  
111 a_country character varying(40)  
112 c_payment_ad_org_id numeric(10)  
113 a_email character varying(60)  
114 a_ident_dl character varying(20)  
115 a_name character varying(60)  
116 a_state character varying(40)  
117 a_street character varying(60)  
118 a_zip character varying(20)  
119 c_payment_c_bpartner_id numeric(10)  
120 c_payment_c_charge_id numeric(10)  
121 c_payment_chargeamt numeric  
122 checkno character varying(20)  
123 c_payment_c_invoice_id numeric(10)  
124 c_payment_c_order_id numeric(10)  
125 c_paymentbatch_id numeric(10)  
126 c_payment_created timestamp without time zone  
127 c_payment_createdby numeric(10)  
128 c_payment_isactive character(1)  
129 isapproved character(1)  
130 isdelayedcapture character(1)  
131 isonline character(1)  
132 isoverunderpayment character(1)  
133 isprepayment character(1)  
134 isreconciled character(1)  
135 c_payment_isselfservice character(1)  
136 micr character varying(20)  
137 orig_trxid character varying(20)  
138 overunderamt numeric  
139 payamt numeric  
140 ponum character varying(60)  
141 c_payment_posted character(1)  
142 c_payment_processed character(1)  
143 c_payment_processedon numeric  
144 r_authcode character varying(20)  
145 r_authcode_dc character varying(20)  
146 r_avsaddr character(1)  
147 r_avszip character(1)  
148 r_cvv2match character(1)  
149 ref_payment_id numeric(10)  
150 c_payment_reversal_id numeric(10)  
151 r_info character varying(2000)  
152 routingno character varying(20)  
153 r_pnref character varying(20)  
154 r_pnref_dc character varying(20)  
155 r_respmsg character varying(60)  
156 r_result character varying(20)  
157 swipe character varying(80)  
158 taxamt numeric  
159 trxtype character(1)  
160 c_payment_updated timestamp without time zone  
161 c_payment_updatedby numeric(10)  
162 voiceauthcode character varying(20)  
163 writeoffamt numeric  


ソース
ソース 
 SELECT drl.ad_client_id,
    drl.ad_org_id,
    drl.isactive,
    drl.created,
    drl.createdby,
    drl.updated,
    drl.updatedby,
    COALESCE(dt.ad_language, dtp.ad_language) AS ad_language,
    drl.c_dunningrunline_id,
    drl.c_dunningrunentry_id,
    drl.amt,
    drl.convertedamt,
    drl.daysdue,
    drl.timesdunned,
    drl.interestamt,
    drl.feeamt,
    drl.totalamt,
    drl.c_invoice_id,
    COALESCE(i.issotrx, p.isreceipt) AS issotrx,
    COALESCE(i.documentno, p.documentno) AS documentno,
    COALESCE(i.docstatus, p.docstatus) AS docstatus,
    COALESCE(i.dateinvoiced, p.datetrx) AS datetrx,
    COALESCE(i.c_doctype_id, p.c_doctype_id) AS c_doctype_id,
    COALESCE(dt.printname, dtp.printname) AS documenttype,
    COALESCE(i.description, p.description) AS description,
    COALESCE(i.c_currency_id, p.c_currency_id) AS c_currency_id,
    COALESCE(i.c_campaign_id, p.c_campaign_id) AS c_campaign_id,
    COALESCE(i.c_project_id, p.c_project_id) AS c_project_id,
    COALESCE(i.c_activity_id, p.c_activity_id) AS c_activity_id,
    COALESCE(i.user1_id, p.user1_id) AS user1_id,
    COALESCE(i.user2_id, p.user2_id) AS user2_id,
    COALESCE(i.dateacct, p.dateacct) AS dateacct,
    COALESCE(i.c_conversiontype_id, p.c_conversiontype_id) AS c_conversiontype_id,
    COALESCE(i.ad_orgtrx_id, p.ad_orgtrx_id) AS ad_orgtrx_id,
    i.poreference,
    i.dateordered,
    i.dateinvoiced,
    i.isindispute,
    ptt.name AS paymentterm,
    i.c_charge_id,
    i.chargeamt,
    i.totallines,
    i.grandtotal,
    i.grandtotal AS amtinwords,
    i.m_pricelist_id,
    i.ispaid,
    p.isallocated,
    p.tendertype,
    p.discountamt,
    drl.c_invoicepayschedule_id,
    drl.c_payment_id,
    drl.isindispute AS c_dunningrunline_isindispute,
    drl.openamt,
    drl.processed AS c_dunningrunline_processed,
    i.ad_org_id AS c_invoice_ad_org_id,
    i.ad_user_id,
    i.c_bpartner_id AS c_invoice_c_bpartner_id,
    i.c_bpartner_location_id,
    i.c_doctypetarget_id,
    i.c_dunninglevel_id,
    i.c_order_id AS c_invoice_c_order_id,
    i.c_payment_id AS c_invoice_c_payment_id,
    i.created AS c_invoice_created,
    i.createdby AS c_invoice_createdby,
    i.dateprinted,
    i.docaction,
    i.dunninggrace,
    i.generateto,
    i.invoicecollectiontype,
    i.isactive AS c_invoice_isactive,
    i.isapproved AS c_invoice_isapproved,
    i.isdiscountprinted,
    i.ispayschedulevalid,
    i.isprinted,
    i.isselfservice AS c_invoice_isselfservice,
    i.istaxincluded,
    i.istransferred,
    i.m_rma_id,
    i.paymentrule,
    i.posted AS c_invoice_posted,
    i.processedon AS c_invoice_processedon,
    i.processing,
    i.ref_invoice_id,
    i.reversal_id AS c_invoice_reversal_id,
    i.salesrep_id,
    i.sendemail,
    i.updated AS c_invoice_updated,
    i.updatedby AS c_invoice_updatedby,
    ptt.ad_org_id AS c_paymentterm_ad_org_id,
    pt.afterdelivery,
    pt.c_paymentterm_id,
    ptt.description AS c_paymentterm_description,
    pt.discount,
    pt.discount2,
    pt.discountdays,
    pt.discountdays2,
    ptt.documentnote,
    pt.fixmonthcutoff,
    pt.fixmonthday,
    pt.fixmonthoffset,
    pt.gracedays,
    ptt.isactive AS c_paymentterm_isactive,
    pt.isduefixed,
    pt.isnextbusinessday,
    pt.isvalid,
    pt.netday,
    pt.netdays,
    pt.paymenttermusage,
    pt.value AS c_paymentterm_value,
    p.a_city,
    p.a_country,
    p.ad_org_id AS c_payment_ad_org_id,
    p.a_email,
    p.a_ident_dl,
    p.a_name,
    p.a_state,
    p.a_street,
    p.a_zip,
    p.c_bpartner_id AS c_payment_c_bpartner_id,
    p.c_charge_id AS c_payment_c_charge_id,
    p.chargeamt AS c_payment_chargeamt,
    p.checkno,
    p.c_invoice_id AS c_payment_c_invoice_id,
    p.c_order_id AS c_payment_c_order_id,
    p.c_paymentbatch_id,
    p.created AS c_payment_created,
    p.createdby AS c_payment_createdby,
    p.isactive AS c_payment_isactive,
    p.isapproved,
    p.isdelayedcapture,
    p.isonline,
    p.isoverunderpayment,
    p.isprepayment,
    p.isreconciled,
    p.isselfservice AS c_payment_isselfservice,
    p.micr,
    p.orig_trxid,
    p.overunderamt,
    p.payamt,
    p.ponum,
    p.posted AS c_payment_posted,
    p.processed AS c_payment_processed,
    p.processedon AS c_payment_processedon,
    p.r_authcode,
    p.r_authcode_dc,
    p.r_avsaddr,
    p.r_avszip,
    p.r_cvv2match,
    p.ref_payment_id,
    p.reversal_id AS c_payment_reversal_id,
    p.r_info,
    p.routingno,
    p.r_pnref,
    p.r_pnref_dc,
    p.r_respmsg,
    p.r_result,
    p.swipe,
    p.taxamt,
    p.trxtype,
    p.updated AS c_payment_updated,
    p.updatedby AS c_payment_updatedby,
    p.voiceauthcode,
    p.writeoffamt
   FROM ((((((c_dunningrunline drl
     LEFT JOIN c_invoice i ON ((drl.c_invoice_id = i.c_invoice_id)))
     LEFT JOIN c_doctype_trl dt ON ((i.c_doctype_id = dt.c_doctype_id)))
     LEFT JOIN c_paymentterm pt ON ((i.c_paymentterm_id = pt.c_paymentterm_id)))
     LEFT JOIN c_paymentterm_trl ptt ON (((i.c_paymentterm_id = ptt.c_paymentterm_id) AND ((ptt.ad_language)::text = (dt.ad_language)::text))))
     LEFT JOIN c_payment p ON ((drl.c_payment_id = p.c_payment_id)))
     LEFT JOIN c_doctype_trl dtp ON ((p.c_doctype_id = dtp.c_doctype_id)))
  WHERE ((COALESCE(dt.ad_language, dtp.ad_language))::text = (COALESCE(dtp.ad_language, dt.ad_language))::text);


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname c_dunning_line_vt
3 viewowner adempiere
4 definition SELECT drl.ad_client_id,
drl.ad_org_id,
drl.isactive,
drl.created,
drl.createdby,
drl.updated,
drl.updatedby,
COALESCE(dt.ad_language, dtp.ad_language) AS ad_language,
drl.c_dunningrunline_id,
drl.c_dunningrunentry_id,
drl.amt,
drl.convertedamt,
drl.daysdue,
drl.timesdunned,
drl.interestamt,
drl.feeamt,
drl.totalamt,
drl.c_invoice_id,
COALESCE(i.issotrx, p.isreceipt) AS issotrx,
COALESCE(i.documentno, p.documentno) AS documentno,
COALESCE(i.docstatus, p.docstatus) AS docstatus,
COALESCE(i.dateinvoiced, p.datetrx) AS datetrx,
COALESCE(i.c_doctype_id, p.c_doctype_id) AS c_doctype_id,
COALESCE(dt.printname, dtp.printname) AS documenttype,
COALESCE(i.description, p.description) AS description,
COALESCE(i.c_currency_id, p.c_currency_id) AS c_currency_id,
COALESCE(i.c_campaign_id, p.c_campaign_id) AS c_campaign_id,
COALESCE(i.c_project_id, p.c_project_id) AS c_project_id,
COALESCE(i.c_activity_id, p.c_activity_id) AS c_activity_id,
COALESCE(i.user1_id, p.user1_id) AS user1_id,
COALESCE(i.user2_id, p.user2_id) AS user2_id,
COALESCE(i.dateacct, p.dateacct) AS dateacct,
COALESCE(i.c_conversiontype_id, p.c_conversiontype_id) AS c_conversiontype_id,
COALESCE(i.ad_orgtrx_id, p.ad_orgtrx_id) AS ad_orgtrx_id,
i.poreference,
i.dateordered,
i.dateinvoiced,
i.isindispute,
ptt.name AS paymentterm,
i.c_charge_id,
i.chargeamt,
i.totallines,
i.grandtotal,
i.grandtotal AS amtinwords,
i.m_pricelist_id,
i.ispaid,
p.isallocated,
p.tendertype,
p.discountamt,
drl.c_invoicepayschedule_id,
drl.c_payment_id,
drl.isindispute AS c_dunningrunline_isindispute,
drl.openamt,
drl.processed AS c_dunningrunline_processed,
i.ad_org_id AS c_invoice_ad_org_id,
i.ad_user_id,
i.c_bpartner_id AS c_invoice_c_bpartner_id,
i.c_bpartner_location_id,
i.c_doctypetarget_id,
i.c_dunninglevel_id,
i.c_order_id AS c_invoice_c_order_id,
i.c_payment_id AS c_invoice_c_payment_id,
i.created AS c_invoice_created,
i.createdby AS c_invoice_createdby,
i.dateprinted,
i.docaction,
i.dunninggrace,
i.generateto,
i.invoicecollectiontype,
i.isactive AS c_invoice_isactive,
i.isapproved AS c_invoice_isapproved,
i.isdiscountprinted,
i.ispayschedulevalid,
i.isprinted,
i.isselfservice AS c_invoice_isselfservice,
i.istaxincluded,
i.istransferred,
i.m_rma_id,
i.paymentrule,
i.posted AS c_invoice_posted,
i.processedon AS c_invoice_processedon,
i.processing,
i.ref_invoice_id,
i.reversal_id AS c_invoice_reversal_id,
i.salesrep_id,
i.sendemail,
i.updated AS c_invoice_updated,
i.updatedby AS c_invoice_updatedby,
ptt.ad_org_id AS c_paymentterm_ad_org_id,
pt.afterdelivery,
pt.c_paymentterm_id,
ptt.description AS c_paymentterm_description,
pt.discount,
pt.discount2,
pt.discountdays,
pt.discountdays2,
ptt.documentnote,
pt.fixmonthcutoff,
pt.fixmonthday,
pt.fixmonthoffset,
pt.gracedays,
ptt.isactive AS c_paymentterm_isactive,
pt.isduefixed,
pt.isnextbusinessday,
pt.isvalid,
pt.netday,
pt.netdays,
pt.paymenttermusage,
pt.value AS c_paymentterm_value,
p.a_city,
p.a_country,
p.ad_org_id AS c_payment_ad_org_id,
p.a_email,
p.a_ident_dl,
p.a_name,
p.a_state,
p.a_street,
p.a_zip,
p.c_bpartner_id AS c_payment_c_bpartner_id,
p.c_charge_id AS c_payment_c_charge_id,
p.chargeamt AS c_payment_chargeamt,
p.checkno,
p.c_invoice_id AS c_payment_c_invoice_id,
p.c_order_id AS c_payment_c_order_id,
p.c_paymentbatch_id,
p.created AS c_payment_created,
p.createdby AS c_payment_createdby,
p.isactive AS c_payment_isactive,
p.isapproved,
p.isdelayedcapture,
p.isonline,
p.isoverunderpayment,
p.isprepayment,
p.isreconciled,
p.isselfservice AS c_payment_isselfservice,
p.micr,
p.orig_trxid,
p.overunderamt,
p.payamt,
p.ponum,
p.posted AS c_payment_posted,
p.processed AS c_payment_processed,
p.processedon AS c_payment_processedon,
p.r_authcode,
p.r_authcode_dc,
p.r_avsaddr,
p.r_avszip,
p.r_cvv2match,
p.ref_payment_id,
p.reversal_id AS c_payment_reversal_id,
p.r_info,
p.routingno,
p.r_pnref,
p.r_pnref_dc,
p.r_respmsg,
p.r_result,
p.swipe,
p.taxamt,
p.trxtype,
p.updated AS c_payment_updated,
p.updatedby AS c_payment_updatedby,
p.voiceauthcode,
p.writeoffamt
FROM ((((((c_dunningrunline drl
LEFT JOIN c_invoice i ON ((drl.c_invoice_id = i.c_invoice_id)))
LEFT JOIN c_doctype_trl dt ON ((i.c_doctype_id = dt.c_doctype_id)))
LEFT JOIN c_paymentterm pt ON ((i.c_paymentterm_id = pt.c_paymentterm_id)))
LEFT JOIN c_paymentterm_trl ptt ON (((i.c_paymentterm_id = ptt.c_paymentterm_id) AND ((ptt.ad_language)::text = (dt.ad_language)::text))))
LEFT JOIN c_payment p ON ((drl.c_payment_id = p.c_payment_id)))
LEFT JOIN c_doctype_trl dtp ON ((p.c_doctype_id = dtp.c_doctype_id)))
WHERE ((COALESCE(dt.ad_language, dtp.ad_language))::text = (COALESCE(dtp.ad_language, dt.ad_language))::text);