テーブル情報
システム名 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 
物理テーブル名 m_inout_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 m_inout_id numeric(10)  
10 m_inoutline_id numeric(10)  
11 line numeric  
12 m_product_id numeric(10)  
13 movementqty numeric  
14 qtyentered numeric  
15 uomsymbol character varying  
16 qtyordered numeric  
17 qtydelivered numeric  
18 qtybackordered numeric  
19 name text  
20 description character varying  
21 documentnote character varying(2000)  
22 upc character varying(30)  
23 sku character varying(30)  
24 productvalue character varying(40)  
25 m_locator_id numeric(10)  
26 m_warehouse_id numeric(10)  
27 x character varying(60)  
28 y character varying(60)  
29 z character varying(60)  
30 m_attributesetinstance_id numeric(10)  
31 m_attributeset_id numeric(10)  
32 serno character varying(40)  
33 lot character varying(40)  
34 m_lot_id numeric(10)  
35 guaranteedate timestamp without time zone  
36 productdescription character varying(255)  
37 imageurl character varying(120)  
38 c_campaign_id numeric(10)  
39 c_project_id numeric(10)  
40 c_activity_id numeric(10)  
41 c_projectphase_id numeric(10)  
42 c_projecttask_id numeric(10)  
43 ad_orgtrx_id numeric(10)  
44 c_charge_id numeric(10)  
45 confirmedqty numeric  
46 c_orderline_id numeric(10)  
47 m_inoutline_c_uom_id numeric(10)  
48 m_inoutline_isdescription character(1)  
49 isinvoiced character(1)  
50 m_rmaline_id numeric(10)  
51 pickedqty numeric  
52 m_inoutline_processed character(1)  
53 ref_inoutline_id numeric(10)  
54 reversalline_id numeric(10)  
55 scrappedqty numeric  
56 targetqty numeric  
57 m_inoutline_user1_id numeric(10)  
58 m_inoutline_user2_id numeric(10)  
59 m_product_ad_org_id numeric(10)  
60 classification character varying(12)  
61 m_product_copyfrom character(1)  
62 m_product_created timestamp without time zone  
63 m_product_createdby numeric(10)  
64 c_revenuerecognition_id numeric(10)  
65 c_subscriptiontype_id numeric(10)  
66 m_product_c_taxcategory_id numeric(10)  
67 m_product_c_uom_id numeric(10)  
68 descriptionurl character varying(120)  
69 discontinued character(1)  
70 discontinuedat timestamp without time zone  
71 group1 character varying(255)  
72 group2 character varying(255)  
73 guaranteedays numeric(10)  
74 guaranteedaysmin numeric(10)  
75 help character varying(2000)  
76 m_product_isactive character(1)  
77 isbom character(1)  
78 isdropship character(1)  
79 isexcludeautodelivery character(1)  
80 isinvoiceprintdetails character(1)  
81 ispicklistprintdetails character(1)  
82 ispurchased character(1)  
83 m_product_isselfservice character(1)  
84 issold character(1)  
85 isstocked character(1)  
86 m_product_issummary character(1)  
87 isverified character(1)  
88 iswebstorefeatured character(1)  
89 lowlevel numeric(10)  
90 m_product_m_attributeset_id numeric(10)  
91 m_product_m_asi_id numeric(10)  
92 m_freightcategory_id numeric(10)  
93 m_product_m_locator_id numeric(10)  
94 m_product_m_prod_category_id numeric(10)  
95 m_product_processing character(1)  
96 producttype character(1)  
97 r_mailtext_id numeric(10)  
98 m_product_salesrep_id numeric(10)  
99 s_expensetype_id numeric(10)  
100 shelfdepth numeric(10)  
101 shelfheight numeric  
102 shelfwidth numeric(10)  
103 m_product_s_resource_id numeric(10)  
104 unitsperpack numeric(10)  
105 unitsperpallet numeric  
106 m_product_updated timestamp without time zone  
107 m_product_updatedby numeric(10)  
108 versionno character varying(20)  
109 volume numeric  
110 weight numeric  
111 c_uom_ad_org_id numeric(10)  
112 costingprecision numeric(10)  
113 c_uom_description character varying(255)  
114 c_uom_isactive character(1)  
115 c_uom_isdefault character(1)  
116 c_uom_name character varying(60)  
117 stdprecision numeric(10)  
118 uomtype character varying(2)  
119 x12de355 character varying(4)  
120 m_asi_ad_org_id numeric(10)  
121 m_asi_created timestamp without time zone  
122 m_asi_createdby numeric(10)  
123 m_asi_description character varying(255)  
124 m_asi_isactive character(1)  
125 m_asi_updated timestamp without time zone  
126 m_asi_updatedby numeric(10)  
127 m_locator_ad_org_id numeric(10)  
128 m_locator_isactive character(1)  
129 isdefault character(1)  
130 priorityno numeric(10)  
131 m_locator_value character varying(40)  
132 c_orderline_ad_org_id numeric  
133 c_orderline_ad_orgtrx_id numeric  
134 c_orderline_c_activity_id numeric  
135 c_orderline_c_bpartner_id numeric  
136 c_orderline_c_bp_location_id numeric  
137 c_orderline_c_charge_id numeric  
138 c_orderline_c_currency_id numeric  
139 c_order_id numeric  
140 c_orderline_c_project_id numeric  
141 c_orderline_c_projectphase_id numeric  
142 c_orderline_c_projecttask_id numeric  
143 c_orderline_created timestamp without time zone  
144 c_orderline_createdby numeric  
145 c_orderline_c_tax_id numeric  
146 c_orderline_c_uom_id numeric  
147 datedelivered timestamp without time zone  
148 dateinvoiced timestamp without time zone  
149 dateordered timestamp without time zone  
150 c_orderline_datepromised timestamp without time zone  
151 c_orderline_description character varying  
152 discount numeric  
153 c_orderline_freightamt numeric  
154 c_orderline_isactive character  
155 c_orderline_isdescription character  
156 c_orderline_line numeric  
157 linenetamt numeric  
158 link_orderline_id numeric  
159 c_orderline_m_asi_id numeric  
160 c_orderline_m_product_id numeric  
161 m_promotion_id numeric  
162 c_orderline_m_shipper_id numeric  
163 c_orderline_warehouse_id numeric  
164 priceactual numeric  
165 pricecost numeric  
166 priceentered numeric  
167 pricelimit numeric  
168 pricelist numeric  
169 c_orderline_processed character  
170 c_orderline_qtyentered numeric  
171 qtyinvoiced numeric  
172 qtylostsales numeric  
173 qtyreserved numeric  
174 ref_orderline_id numeric  
175 rramt numeric  
176 rrstartdate timestamp without time zone  
177 s_resourceassignment_id numeric  
178 c_orderline_updated timestamp without time zone  
179 c_orderline_updatedby numeric  
180 c_orderline_user1_id numeric  
181 c_orderline_user2_id numeric  
182 c_charge_c_org_id numeric  
183 c_charge_c_bpartner_id numeric  
184 c_chargetype_id numeric  
185 c_charge_chargeamt numeric  
186 c_charge_c_taxcategory_id numeric  
187 c_charge_description character varying  
188 c_charge_isactive character  
189 issamecurrency character  
190 issametax character  
191 c_charge_istaxincluded character  


ソース
ソース 
 SELECT iol.ad_client_id,
    iol.ad_org_id,
    iol.isactive,
    iol.created,
    iol.createdby,
    iol.updated,
    iol.updatedby,
    uomt.ad_language,
    iol.m_inout_id,
    iol.m_inoutline_id,
    iol.line,
    pt.m_product_id,
        CASE
            WHEN ((iol.movementqty <> (0)::numeric) OR (iol.m_product_id IS NOT NULL)) THEN iol.movementqty
            ELSE NULL::numeric
        END AS movementqty,
        CASE
            WHEN ((iol.qtyentered <> (0)::numeric) OR (iol.m_product_id IS NOT NULL)) THEN iol.qtyentered
            ELSE NULL::numeric
        END AS qtyentered,
        CASE
            WHEN ((iol.movementqty <> (0)::numeric) OR (iol.m_product_id IS NOT NULL)) THEN uomt.uomsymbol
            ELSE NULL::character varying
        END AS uomsymbol,
    ol.qtyordered,
    ol.qtydelivered,
        CASE
            WHEN ((iol.movementqty <> (0)::numeric) OR (iol.m_product_id IS NOT NULL)) THEN (ol.qtyordered - ol.qtydelivered)
            ELSE NULL::numeric
        END AS qtybackordered,
    COALESCE(((pt.name)::text || (productattribute(iol.m_attributesetinstance_id))::text), (ct.name)::text, (iol.description)::text) AS name,
        CASE
            WHEN (COALESCE(ct.name, pt.name) IS NOT NULL) THEN iol.description
            ELSE NULL::character varying
        END AS description,
    pt.documentnote,
    p.upc,
    p.sku,
    p.value AS productvalue,
    iol.m_locator_id,
    l.m_warehouse_id,
    l.x,
    l.y,
    l.z,
    iol.m_attributesetinstance_id,
    asi.m_attributeset_id,
    asi.serno,
    asi.lot,
    asi.m_lot_id,
    asi.guaranteedate,
    pt.description AS productdescription,
    p.imageurl,
    iol.c_campaign_id,
    iol.c_project_id,
    iol.c_activity_id,
    iol.c_projectphase_id,
    iol.c_projecttask_id,
    iol.ad_orgtrx_id,
    iol.c_charge_id,
    iol.confirmedqty,
    iol.c_orderline_id,
    iol.c_uom_id AS m_inoutline_c_uom_id,
    iol.isdescription AS m_inoutline_isdescription,
    iol.isinvoiced,
    iol.m_rmaline_id,
    iol.pickedqty,
    iol.processed AS m_inoutline_processed,
    iol.ref_inoutline_id,
    iol.reversalline_id,
    iol.scrappedqty,
    iol.targetqty,
    iol.user1_id AS m_inoutline_user1_id,
    iol.user2_id AS m_inoutline_user2_id,
    pt.ad_org_id AS m_product_ad_org_id,
    p.classification,
    p.copyfrom AS m_product_copyfrom,
    pt.created AS m_product_created,
    pt.createdby AS m_product_createdby,
    p.c_revenuerecognition_id,
    p.c_subscriptiontype_id,
    p.c_taxcategory_id AS m_product_c_taxcategory_id,
    p.c_uom_id AS m_product_c_uom_id,
    p.descriptionurl,
    p.discontinued,
    p.discontinuedat,
    p.group1,
    p.group2,
    p.guaranteedays,
    p.guaranteedaysmin,
    p.help,
    pt.isactive AS m_product_isactive,
    p.isbom,
    p.isdropship,
    p.isexcludeautodelivery,
    p.isinvoiceprintdetails,
    p.ispicklistprintdetails,
    p.ispurchased,
    p.isselfservice AS m_product_isselfservice,
    p.issold,
    p.isstocked,
    p.issummary AS m_product_issummary,
    p.isverified,
    p.iswebstorefeatured,
    p.lowlevel,
    p.m_attributeset_id AS m_product_m_attributeset_id,
    p.m_attributesetinstance_id AS m_product_m_asi_id,
    p.m_freightcategory_id,
    p.m_locator_id AS m_product_m_locator_id,
    p.m_product_category_id AS m_product_m_prod_category_id,
    p.processing AS m_product_processing,
    p.producttype,
    p.r_mailtext_id,
    p.salesrep_id AS m_product_salesrep_id,
    p.s_expensetype_id,
    p.shelfdepth,
    p.shelfheight,
    p.shelfwidth,
    p.s_resource_id AS m_product_s_resource_id,
    p.unitsperpack,
    p.unitsperpallet,
    p.updated AS m_product_updated,
    p.updatedby AS m_product_updatedby,
    p.versionno,
    p.volume,
    p.weight,
    uomt.ad_org_id AS c_uom_ad_org_id,
    uom.costingprecision,
    uomt.description AS c_uom_description,
    uomt.isactive AS c_uom_isactive,
    uom.isdefault AS c_uom_isdefault,
    uomt.name AS c_uom_name,
    uom.stdprecision,
    uom.uomtype,
    uom.x12de355,
    asi.ad_org_id AS m_asi_ad_org_id,
    asi.created AS m_asi_created,
    asi.createdby AS m_asi_createdby,
    asi.description AS m_asi_description,
    asi.isactive AS m_asi_isactive,
    asi.updated AS m_asi_updated,
    asi.updatedby AS m_asi_updatedby,
    l.ad_org_id AS m_locator_ad_org_id,
    l.isactive AS m_locator_isactive,
    l.isdefault,
    l.priorityno,
    l.value AS m_locator_value,
    ol.ad_org_id AS c_orderline_ad_org_id,
    ol.ad_orgtrx_id AS c_orderline_ad_orgtrx_id,
    ol.c_activity_id AS c_orderline_c_activity_id,
    ol.c_bpartner_id AS c_orderline_c_bpartner_id,
    ol.c_bpartner_location_id AS c_orderline_c_bp_location_id,
    ol.c_charge_id AS c_orderline_c_charge_id,
    ol.c_currency_id AS c_orderline_c_currency_id,
    ol.c_order_id,
    ol.c_project_id AS c_orderline_c_project_id,
    ol.c_projectphase_id AS c_orderline_c_projectphase_id,
    ol.c_projecttask_id AS c_orderline_c_projecttask_id,
    ol.created AS c_orderline_created,
    ol.createdby AS c_orderline_createdby,
    ol.c_tax_id AS c_orderline_c_tax_id,
    ol.c_uom_id AS c_orderline_c_uom_id,
    ol.datedelivered,
    ol.dateinvoiced,
    ol.dateordered,
    ol.datepromised AS c_orderline_datepromised,
    ol.description AS c_orderline_description,
    ol.discount,
    ol.freightamt AS c_orderline_freightamt,
    ol.isactive AS c_orderline_isactive,
    ol.isdescription AS c_orderline_isdescription,
    ol.line AS c_orderline_line,
    ol.linenetamt,
    ol.link_orderline_id,
    ol.m_attributesetinstance_id AS c_orderline_m_asi_id,
    ol.m_product_id AS c_orderline_m_product_id,
    ol.m_promotion_id,
    ol.m_shipper_id AS c_orderline_m_shipper_id,
    ol.m_warehouse_id AS c_orderline_warehouse_id,
    ol.priceactual,
    ol.pricecost,
    ol.priceentered,
    ol.pricelimit,
    ol.pricelist,
    ol.processed AS c_orderline_processed,
    ol.qtyentered AS c_orderline_qtyentered,
    ol.qtyinvoiced,
    ol.qtylostsales,
    ol.qtyreserved,
    ol.ref_orderline_id,
    ol.rramt,
    ol.rrstartdate,
    ol.s_resourceassignment_id,
    ol.updated AS c_orderline_updated,
    ol.updatedby AS c_orderline_updatedby,
    ol.user1_id AS c_orderline_user1_id,
    ol.user2_id AS c_orderline_user2_id,
    ct.ad_org_id AS c_charge_c_org_id,
    c.c_bpartner_id AS c_charge_c_bpartner_id,
    c.c_chargetype_id,
    c.chargeamt AS c_charge_chargeamt,
    c.c_taxcategory_id AS c_charge_c_taxcategory_id,
    ct.description AS c_charge_description,
    ct.isactive AS c_charge_isactive,
    c.issamecurrency,
    c.issametax,
    c.istaxincluded AS c_charge_istaxincluded
   FROM (((((((((m_inoutline iol
     JOIN c_uom uom ON ((iol.c_uom_id = uom.c_uom_id)))
     JOIN c_uom_trl uomt ON ((iol.c_uom_id = uomt.c_uom_id)))
     LEFT JOIN m_product p ON ((iol.m_product_id = p.m_product_id)))
     LEFT JOIN m_product_trl pt ON (((iol.m_product_id = pt.m_product_id) AND ((uomt.ad_language)::text = (pt.ad_language)::text))))
     LEFT JOIN m_attributesetinstance asi ON ((iol.m_attributesetinstance_id = asi.m_attributesetinstance_id)))
     LEFT JOIN m_locator l ON ((iol.m_locator_id = l.m_locator_id)))
     LEFT JOIN c_orderline ol ON ((iol.c_orderline_id = ol.c_orderline_id)))
     LEFT JOIN c_charge c ON ((iol.c_charge_id = c.c_charge_id)))
     LEFT JOIN c_charge_trl ct ON ((iol.c_charge_id = ct.c_charge_id)))
UNION
 SELECT iol.ad_client_id,
    iol.ad_org_id,
    iol.isactive,
    iol.created,
    iol.createdby,
    iol.updated,
    iol.updatedby,
    uomt.ad_language,
    iol.m_inout_id,
    iol.m_inoutline_id,
    (iol.line + (bl.line / (100)::numeric)) AS line,
    pt.m_product_id,
        CASE
            WHEN (bl.isqtypercentage = 'N'::bpchar) THEN (iol.movementqty * bl.qtybom)
            ELSE (iol.movementqty * (bl.qtybatch / (100)::numeric))
        END AS movementqty,
        CASE
            WHEN (bl.isqtypercentage = 'N'::bpchar) THEN (iol.qtyentered * bl.qtybom)
            ELSE (iol.qtyentered * (bl.qtybatch / (100)::numeric))
        END AS qtyentered,
    uomt.uomsymbol,
    NULL::numeric AS qtyordered,
    NULL::numeric AS qtydelivered,
    NULL::numeric AS qtybackordered,
    pt.name,
    b.description,
    pt.documentnote,
    p.upc,
    p.sku,
    p.value AS productvalue,
    iol.m_locator_id,
    l.m_warehouse_id,
    l.x,
    l.y,
    l.z,
    iol.m_attributesetinstance_id,
    asi.m_attributeset_id,
    asi.serno,
    asi.lot,
    asi.m_lot_id,
    asi.guaranteedate,
    pt.description AS productdescription,
    p.imageurl,
    iol.c_campaign_id,
    iol.c_project_id,
    iol.c_activity_id,
    iol.c_projectphase_id,
    iol.c_projecttask_id,
    iol.ad_orgtrx_id,
    iol.c_charge_id,
    iol.confirmedqty,
    iol.c_orderline_id,
    iol.c_uom_id AS m_inoutline_c_uom_id,
    iol.isdescription AS m_inoutline_isdescription,
    iol.isinvoiced,
    iol.m_rmaline_id,
    iol.pickedqty,
    iol.processed AS m_inoutline_processed,
    iol.ref_inoutline_id,
    iol.reversalline_id,
    iol.scrappedqty,
    iol.targetqty,
    iol.user1_id AS m_inoutline_user1_id,
    iol.user2_id AS m_inoutline_user2_id,
    pt.ad_org_id AS m_product_ad_org_id,
    p.classification,
    p.copyfrom AS m_product_copyfrom,
    pt.created AS m_product_created,
    pt.createdby AS m_product_createdby,
    p.c_revenuerecognition_id,
    p.c_subscriptiontype_id,
    p.c_taxcategory_id AS m_product_c_taxcategory_id,
    p.c_uom_id AS m_product_c_uom_id,
    p.descriptionurl,
    p.discontinued,
    p.discontinuedat,
    p.group1,
    p.group2,
    p.guaranteedays,
    p.guaranteedaysmin,
    p.help,
    pt.isactive AS m_product_isactive,
    p.isbom,
    p.isdropship,
    p.isexcludeautodelivery,
    p.isinvoiceprintdetails,
    p.ispicklistprintdetails,
    p.ispurchased,
    p.isselfservice AS m_product_isselfservice,
    p.issold,
    p.isstocked,
    p.issummary AS m_product_issummary,
    p.isverified,
    p.iswebstorefeatured,
    p.lowlevel,
    p.m_attributeset_id AS m_product_m_attributeset_id,
    p.m_attributesetinstance_id AS m_product_m_asi_id,
    p.m_freightcategory_id,
    p.m_locator_id AS m_product_m_locator_id,
    p.m_product_category_id AS m_product_m_prod_category_id,
    p.processing AS m_product_processing,
    p.producttype,
    p.r_mailtext_id,
    p.salesrep_id AS m_product_salesrep_id,
    p.s_expensetype_id,
    p.shelfdepth,
    p.shelfheight,
    p.shelfwidth,
    p.s_resource_id AS m_product_s_resource_id,
    p.unitsperpack,
    p.unitsperpallet,
    pt.updated AS m_product_updated,
    pt.updatedby AS m_product_updatedby,
    p.versionno,
    p.volume,
    p.weight,
    uomt.ad_org_id AS c_uom_ad_org_id,
    uom.costingprecision,
    uomt.description AS c_uom_description,
    uomt.isactive AS c_uom_isactive,
    uom.isdefault AS c_uom_isdefault,
    uomt.name AS c_uom_name,
    uom.stdprecision,
    uom.uomtype,
    uom.x12de355,
    asi.ad_org_id AS m_asi_ad_org_id,
    asi.created AS m_asi_created,
    asi.createdby AS m_asi_createdby,
    asi.description AS m_asi_description,
    asi.isactive AS m_asi_isactive,
    asi.updated AS m_asi_updated,
    asi.updatedby AS m_asi_updatedby,
    l.ad_org_id AS m_locator_ad_org_id,
    l.isactive AS m_locator_isactive,
    l.isdefault,
    l.priorityno,
    l.value AS m_locator_value,
    NULL::numeric AS c_orderline_ad_org_id,
    NULL::numeric AS c_orderline_ad_orgtrx_id,
    NULL::numeric AS c_orderline_c_activity_id,
    NULL::numeric AS c_orderline_c_bpartner_id,
    NULL::numeric AS c_orderline_c_bp_location_id,
    NULL::numeric AS c_orderline_c_charge_id,
    NULL::numeric AS c_orderline_c_currency_id,
    NULL::numeric AS c_order_id,
    NULL::numeric AS c_orderline_c_project_id,
    NULL::numeric AS c_orderline_c_projectphase_id,
    NULL::numeric AS c_orderline_c_projecttask_id,
    NULL::timestamp without time zone AS c_orderline_created,
    NULL::numeric AS c_orderline_createdby,
    NULL::numeric AS c_orderline_c_tax_id,
    NULL::numeric AS c_orderline_c_uom_id,
    NULL::timestamp without time zone AS datedelivered,
    NULL::timestamp without time zone AS dateinvoiced,
    NULL::timestamp without time zone AS dateordered,
    NULL::timestamp without time zone AS c_orderline_datepromised,
    NULL::character varying AS c_orderline_description,
    NULL::numeric AS discount,
    NULL::numeric AS c_orderline_freightamt,
    NULL::bpchar AS c_orderline_isactive,
    NULL::bpchar AS c_orderline_isdescription,
    NULL::numeric AS c_orderline_line,
    NULL::numeric AS linenetamt,
    NULL::numeric AS link_orderline_id,
    NULL::numeric AS c_orderline_m_asi_id,
    NULL::numeric AS c_orderline_m_product_id,
    NULL::numeric AS m_promotion_id,
    NULL::numeric AS c_orderline_m_shipper_id,
    NULL::numeric AS c_orderline_warehouse_id,
    NULL::numeric AS priceactual,
    NULL::numeric AS pricecost,
    NULL::numeric AS priceentered,
    NULL::numeric AS pricelimit,
    NULL::numeric AS pricelist,
    NULL::bpchar AS c_orderline_processed,
    NULL::numeric AS c_orderline_qtyentered,
    NULL::numeric AS qtyinvoiced,
    NULL::numeric AS qtylostsales,
    NULL::numeric AS qtyreserved,
    NULL::numeric AS ref_orderline_id,
    NULL::numeric AS rramt,
    NULL::timestamp without time zone AS rrstartdate,
    NULL::numeric AS s_resourceassignment_id,
    NULL::timestamp without time zone AS c_orderline_updated,
    NULL::numeric AS c_orderline_updatedby,
    NULL::numeric AS c_orderline_user1_id,
    NULL::numeric AS c_orderline_user2_id,
    NULL::numeric AS c_charge_c_org_id,
    NULL::numeric AS c_charge_c_bpartner_id,
    NULL::numeric AS c_chargetype_id,
    NULL::numeric AS c_charge_chargeamt,
    NULL::numeric AS c_charge_c_taxcategory_id,
    NULL::character varying AS c_charge_description,
    NULL::bpchar AS c_charge_isactive,
    NULL::bpchar AS issamecurrency,
    NULL::bpchar AS issametax,
    NULL::bpchar AS c_charge_istaxincluded
   FROM (((((((((pp_product_bom b
     JOIN m_inoutline iol ON ((b.m_product_id = iol.m_product_id)))
     JOIN m_product bp ON (((((bp.m_product_id = iol.m_product_id) AND (bp.isbom = 'Y'::bpchar)) AND (bp.isverified = 'Y'::bpchar)) AND (bp.ispicklistprintdetails = 'Y'::bpchar))))
     JOIN pp_product_bomline bl ON ((bl.pp_product_bom_id = b.pp_product_bom_id)))
     JOIN m_product p ON ((bl.m_product_id = p.m_product_id)))
     JOIN c_uom uom ON ((iol.c_uom_id = uom.c_uom_id)))
     JOIN c_uom_trl uomt ON ((p.c_uom_id = uomt.c_uom_id)))
     JOIN m_product_trl pt ON (((bl.m_product_id = pt.m_product_id) AND ((uomt.ad_language)::text = (pt.ad_language)::text))))
     LEFT JOIN m_attributesetinstance asi ON ((iol.m_attributesetinstance_id = asi.m_attributesetinstance_id)))
     LEFT JOIN m_locator l ON ((iol.m_locator_id = l.m_locator_id)));


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname m_inout_line_vt
3 viewowner adempiere
4 definition SELECT iol.ad_client_id,
iol.ad_org_id,
iol.isactive,
iol.created,
iol.createdby,
iol.updated,
iol.updatedby,
uomt.ad_language,
iol.m_inout_id,
iol.m_inoutline_id,
iol.line,
pt.m_product_id,
CASE
WHEN ((iol.movementqty <> (0)::numeric) OR (iol.m_product_id IS NOT NULL)) THEN iol.movementqty
ELSE NULL::numeric
END AS movementqty,
CASE
WHEN ((iol.qtyentered <> (0)::numeric) OR (iol.m_product_id IS NOT NULL)) THEN iol.qtyentered
ELSE NULL::numeric
END AS qtyentered,
CASE
WHEN ((iol.movementqty <> (0)::numeric) OR (iol.m_product_id IS NOT NULL)) THEN uomt.uomsymbol
ELSE NULL::character varying
END AS uomsymbol,
ol.qtyordered,
ol.qtydelivered,
CASE
WHEN ((iol.movementqty <> (0)::numeric) OR (iol.m_product_id IS NOT NULL)) THEN (ol.qtyordered - ol.qtydelivered)
ELSE NULL::numeric
END AS qtybackordered,
COALESCE(((pt.name)::text || (productattribute(iol.m_attributesetinstance_id))::text), (ct.name)::text, (iol.description)::text) AS name,
CASE
WHEN (COALESCE(ct.name, pt.name) IS NOT NULL) THEN iol.description
ELSE NULL::character varying
END AS description,
pt.documentnote,
p.upc,
p.sku,
p.value AS productvalue,
iol.m_locator_id,
l.m_warehouse_id,
l.x,
l.y,
l.z,
iol.m_attributesetinstance_id,
asi.m_attributeset_id,
asi.serno,
asi.lot,
asi.m_lot_id,
asi.guaranteedate,
pt.description AS productdescription,
p.imageurl,
iol.c_campaign_id,
iol.c_project_id,
iol.c_activity_id,
iol.c_projectphase_id,
iol.c_projecttask_id,
iol.ad_orgtrx_id,
iol.c_charge_id,
iol.confirmedqty,
iol.c_orderline_id,
iol.c_uom_id AS m_inoutline_c_uom_id,
iol.isdescription AS m_inoutline_isdescription,
iol.isinvoiced,
iol.m_rmaline_id,
iol.pickedqty,
iol.processed AS m_inoutline_processed,
iol.ref_inoutline_id,
iol.reversalline_id,
iol.scrappedqty,
iol.targetqty,
iol.user1_id AS m_inoutline_user1_id,
iol.user2_id AS m_inoutline_user2_id,
pt.ad_org_id AS m_product_ad_org_id,
p.classification,
p.copyfrom AS m_product_copyfrom,
pt.created AS m_product_created,
pt.createdby AS m_product_createdby,
p.c_revenuerecognition_id,
p.c_subscriptiontype_id,
p.c_taxcategory_id AS m_product_c_taxcategory_id,
p.c_uom_id AS m_product_c_uom_id,
p.descriptionurl,
p.discontinued,
p.discontinuedat,
p.group1,
p.group2,
p.guaranteedays,
p.guaranteedaysmin,
p.help,
pt.isactive AS m_product_isactive,
p.isbom,
p.isdropship,
p.isexcludeautodelivery,
p.isinvoiceprintdetails,
p.ispicklistprintdetails,
p.ispurchased,
p.isselfservice AS m_product_isselfservice,
p.issold,
p.isstocked,
p.issummary AS m_product_issummary,
p.isverified,
p.iswebstorefeatured,
p.lowlevel,
p.m_attributeset_id AS m_product_m_attributeset_id,
p.m_attributesetinstance_id AS m_product_m_asi_id,
p.m_freightcategory_id,
p.m_locator_id AS m_product_m_locator_id,
p.m_product_category_id AS m_product_m_prod_category_id,
p.processing AS m_product_processing,
p.producttype,
p.r_mailtext_id,
p.salesrep_id AS m_product_salesrep_id,
p.s_expensetype_id,
p.shelfdepth,
p.shelfheight,
p.shelfwidth,
p.s_resource_id AS m_product_s_resource_id,
p.unitsperpack,
p.unitsperpallet,
p.updated AS m_product_updated,
p.updatedby AS m_product_updatedby,
p.versionno,
p.volume,
p.weight,
uomt.ad_org_id AS c_uom_ad_org_id,
uom.costingprecision,
uomt.description AS c_uom_description,
uomt.isactive AS c_uom_isactive,
uom.isdefault AS c_uom_isdefault,
uomt.name AS c_uom_name,
uom.stdprecision,
uom.uomtype,
uom.x12de355,
asi.ad_org_id AS m_asi_ad_org_id,
asi.created AS m_asi_created,
asi.createdby AS m_asi_createdby,
asi.description AS m_asi_description,
asi.isactive AS m_asi_isactive,
asi.updated AS m_asi_updated,
asi.updatedby AS m_asi_updatedby,
l.ad_org_id AS m_locator_ad_org_id,
l.isactive AS m_locator_isactive,
l.isdefault,
l.priorityno,
l.value AS m_locator_value,
ol.ad_org_id AS c_orderline_ad_org_id,
ol.ad_orgtrx_id AS c_orderline_ad_orgtrx_id,
ol.c_activity_id AS c_orderline_c_activity_id,
ol.c_bpartner_id AS c_orderline_c_bpartner_id,
ol.c_bpartner_location_id AS c_orderline_c_bp_location_id,
ol.c_charge_id AS c_orderline_c_charge_id,
ol.c_currency_id AS c_orderline_c_currency_id,
ol.c_order_id,
ol.c_project_id AS c_orderline_c_project_id,
ol.c_projectphase_id AS c_orderline_c_projectphase_id,
ol.c_projecttask_id AS c_orderline_c_projecttask_id,
ol.created AS c_orderline_created,
ol.createdby AS c_orderline_createdby,
ol.c_tax_id AS c_orderline_c_tax_id,
ol.c_uom_id AS c_orderline_c_uom_id,
ol.datedelivered,
ol.dateinvoiced,
ol.dateordered,
ol.datepromised AS c_orderline_datepromised,
ol.description AS c_orderline_description,
ol.discount,
ol.freightamt AS c_orderline_freightamt,
ol.isactive AS c_orderline_isactive,
ol.isdescription AS c_orderline_isdescription,
ol.line AS c_orderline_line,
ol.linenetamt,
ol.link_orderline_id,
ol.m_attributesetinstance_id AS c_orderline_m_asi_id,
ol.m_product_id AS c_orderline_m_product_id,
ol.m_promotion_id,
ol.m_shipper_id AS c_orderline_m_shipper_id,
ol.m_warehouse_id AS c_orderline_warehouse_id,
ol.priceactual,
ol.pricecost,
ol.priceentered,
ol.pricelimit,
ol.pricelist,
ol.processed AS c_orderline_processed,
ol.qtyentered AS c_orderline_qtyentered,
ol.qtyinvoiced,
ol.qtylostsales,
ol.qtyreserved,
ol.ref_orderline_id,
ol.rramt,
ol.rrstartdate,
ol.s_resourceassignment_id,
ol.updated AS c_orderline_updated,
ol.updatedby AS c_orderline_updatedby,
ol.user1_id AS c_orderline_user1_id,
ol.user2_id AS c_orderline_user2_id,
ct.ad_org_id AS c_charge_c_org_id,
c.c_bpartner_id AS c_charge_c_bpartner_id,
c.c_chargetype_id,
c.chargeamt AS c_charge_chargeamt,
c.c_taxcategory_id AS c_charge_c_taxcategory_id,
ct.description AS c_charge_description,
ct.isactive AS c_charge_isactive,
c.issamecurrency,
c.issametax,
c.istaxincluded AS c_charge_istaxincluded
FROM (((((((((m_inoutline iol
JOIN c_uom uom ON ((iol.c_uom_id = uom.c_uom_id)))
JOIN c_uom_trl uomt ON ((iol.c_uom_id = uomt.c_uom_id)))
LEFT JOIN m_product p ON ((iol.m_product_id = p.m_product_id)))
LEFT JOIN m_product_trl pt ON (((iol.m_product_id = pt.m_product_id) AND ((uomt.ad_language)::text = (pt.ad_language)::text))))
LEFT JOIN m_attributesetinstance asi ON ((iol.m_attributesetinstance_id = asi.m_attributesetinstance_id)))
LEFT JOIN m_locator l ON ((iol.m_locator_id = l.m_locator_id)))
LEFT JOIN c_orderline ol ON ((iol.c_orderline_id = ol.c_orderline_id)))
LEFT JOIN c_charge c ON ((iol.c_charge_id = c.c_charge_id)))
LEFT JOIN c_charge_trl ct ON ((iol.c_charge_id = ct.c_charge_id)))
UNION
SELECT iol.ad_client_id,
iol.ad_org_id,
iol.isactive,
iol.created,
iol.createdby,
iol.updated,
iol.updatedby,
uomt.ad_language,
iol.m_inout_id,
iol.m_inoutline_id,
(iol.line + (bl.line / (100)::numeric)) AS line,
pt.m_product_id,
CASE
WHEN (bl.isqtypercentage = 'N'::bpchar) THEN (iol.movementqty * bl.qtybom)
ELSE (iol.movementqty * (bl.qtybatch / (100)::numeric))
END AS movementqty,
CASE
WHEN (bl.isqtypercentage = 'N'::bpchar) THEN (iol.qtyentered * bl.qtybom)
ELSE (iol.qtyentered * (bl.qtybatch / (100)::numeric))
END AS qtyentered,
uomt.uomsymbol,
NULL::numeric AS qtyordered,
NULL::numeric AS qtydelivered,
NULL::numeric AS qtybackordered,
pt.name,
b.description,
pt.documentnote,
p.upc,
p.sku,
p.value AS productvalue,
iol.m_locator_id,
l.m_warehouse_id,
l.x,
l.y,
l.z,
iol.m_attributesetinstance_id,
asi.m_attributeset_id,
asi.serno,
asi.lot,
asi.m_lot_id,
asi.guaranteedate,
pt.description AS productdescription,
p.imageurl,
iol.c_campaign_id,
iol.c_project_id,
iol.c_activity_id,
iol.c_projectphase_id,
iol.c_projecttask_id,
iol.ad_orgtrx_id,
iol.c_charge_id,
iol.confirmedqty,
iol.c_orderline_id,
iol.c_uom_id AS m_inoutline_c_uom_id,
iol.isdescription AS m_inoutline_isdescription,
iol.isinvoiced,
iol.m_rmaline_id,
iol.pickedqty,
iol.processed AS m_inoutline_processed,
iol.ref_inoutline_id,
iol.reversalline_id,
iol.scrappedqty,
iol.targetqty,
iol.user1_id AS m_inoutline_user1_id,
iol.user2_id AS m_inoutline_user2_id,
pt.ad_org_id AS m_product_ad_org_id,
p.classification,
p.copyfrom AS m_product_copyfrom,
pt.created AS m_product_created,
pt.createdby AS m_product_createdby,
p.c_revenuerecognition_id,
p.c_subscriptiontype_id,
p.c_taxcategory_id AS m_product_c_taxcategory_id,
p.c_uom_id AS m_product_c_uom_id,
p.descriptionurl,
p.discontinued,
p.discontinuedat,
p.group1,
p.group2,
p.guaranteedays,
p.guaranteedaysmin,
p.help,
pt.isactive AS m_product_isactive,
p.isbom,
p.isdropship,
p.isexcludeautodelivery,
p.isinvoiceprintdetails,
p.ispicklistprintdetails,
p.ispurchased,
p.isselfservice AS m_product_isselfservice,
p.issold,
p.isstocked,
p.issummary AS m_product_issummary,
p.isverified,
p.iswebstorefeatured,
p.lowlevel,
p.m_attributeset_id AS m_product_m_attributeset_id,
p.m_attributesetinstance_id AS m_product_m_asi_id,
p.m_freightcategory_id,
p.m_locator_id AS m_product_m_locator_id,
p.m_product_category_id AS m_product_m_prod_category_id,
p.processing AS m_product_processing,
p.producttype,
p.r_mailtext_id,
p.salesrep_id AS m_product_salesrep_id,
p.s_expensetype_id,
p.shelfdepth,
p.shelfheight,
p.shelfwidth,
p.s_resource_id AS m_product_s_resource_id,
p.unitsperpack,
p.unitsperpallet,
pt.updated AS m_product_updated,
pt.updatedby AS m_product_updatedby,
p.versionno,
p.volume,
p.weight,
uomt.ad_org_id AS c_uom_ad_org_id,
uom.costingprecision,
uomt.description AS c_uom_description,
uomt.isactive AS c_uom_isactive,
uom.isdefault AS c_uom_isdefault,
uomt.name AS c_uom_name,
uom.stdprecision,
uom.uomtype,
uom.x12de355,
asi.ad_org_id AS m_asi_ad_org_id,
asi.created AS m_asi_created,
asi.createdby AS m_asi_createdby,
asi.description AS m_asi_description,
asi.isactive AS m_asi_isactive,
asi.updated AS m_asi_updated,
asi.updatedby AS m_asi_updatedby,
l.ad_org_id AS m_locator_ad_org_id,
l.isactive AS m_locator_isactive,
l.isdefault,
l.priorityno,
l.value AS m_locator_value,
NULL::numeric AS c_orderline_ad_org_id,
NULL::numeric AS c_orderline_ad_orgtrx_id,
NULL::numeric AS c_orderline_c_activity_id,
NULL::numeric AS c_orderline_c_bpartner_id,
NULL::numeric AS c_orderline_c_bp_location_id,
NULL::numeric AS c_orderline_c_charge_id,
NULL::numeric AS c_orderline_c_currency_id,
NULL::numeric AS c_order_id,
NULL::numeric AS c_orderline_c_project_id,
NULL::numeric AS c_orderline_c_projectphase_id,
NULL::numeric AS c_orderline_c_projecttask_id,
NULL::timestamp without time zone AS c_orderline_created,
NULL::numeric AS c_orderline_createdby,
NULL::numeric AS c_orderline_c_tax_id,
NULL::numeric AS c_orderline_c_uom_id,
NULL::timestamp without time zone AS datedelivered,
NULL::timestamp without time zone AS dateinvoiced,
NULL::timestamp without time zone AS dateordered,
NULL::timestamp without time zone AS c_orderline_datepromised,
NULL::character varying AS c_orderline_description,
NULL::numeric AS discount,
NULL::numeric AS c_orderline_freightamt,
NULL::bpchar AS c_orderline_isactive,
NULL::bpchar AS c_orderline_isdescription,
NULL::numeric AS c_orderline_line,
NULL::numeric AS linenetamt,
NULL::numeric AS link_orderline_id,
NULL::numeric AS c_orderline_m_asi_id,
NULL::numeric AS c_orderline_m_product_id,
NULL::numeric AS m_promotion_id,
NULL::numeric AS c_orderline_m_shipper_id,
NULL::numeric AS c_orderline_warehouse_id,
NULL::numeric AS priceactual,
NULL::numeric AS pricecost,
NULL::numeric AS priceentered,
NULL::numeric AS pricelimit,
NULL::numeric AS pricelist,
NULL::bpchar AS c_orderline_processed,
NULL::numeric AS c_orderline_qtyentered,
NULL::numeric AS qtyinvoiced,
NULL::numeric AS qtylostsales,
NULL::numeric AS qtyreserved,
NULL::numeric AS ref_orderline_id,
NULL::numeric AS rramt,
NULL::timestamp without time zone AS rrstartdate,
NULL::numeric AS s_resourceassignment_id,
NULL::timestamp without time zone AS c_orderline_updated,
NULL::numeric AS c_orderline_updatedby,
NULL::numeric AS c_orderline_user1_id,
NULL::numeric AS c_orderline_user2_id,
NULL::numeric AS c_charge_c_org_id,
NULL::numeric AS c_charge_c_bpartner_id,
NULL::numeric AS c_chargetype_id,
NULL::numeric AS c_charge_chargeamt,
NULL::numeric AS c_charge_c_taxcategory_id,
NULL::character varying AS c_charge_description,
NULL::bpchar AS c_charge_isactive,
NULL::bpchar AS issamecurrency,
NULL::bpchar AS issametax,
NULL::bpchar AS c_charge_istaxincluded
FROM (((((((((pp_product_bom b
JOIN m_inoutline iol ON ((b.m_product_id = iol.m_product_id)))
JOIN m_product bp ON (((((bp.m_product_id = iol.m_product_id) AND (bp.isbom = 'Y'::bpchar)) AND (bp.isverified = 'Y'::bpchar)) AND (bp.ispicklistprintdetails = 'Y'::bpchar))))
JOIN pp_product_bomline bl ON ((bl.pp_product_bom_id = b.pp_product_bom_id)))
JOIN m_product p ON ((bl.m_product_id = p.m_product_id)))
JOIN c_uom uom ON ((iol.c_uom_id = uom.c_uom_id)))
JOIN c_uom_trl uomt ON ((p.c_uom_id = uomt.c_uom_id)))
JOIN m_product_trl pt ON (((bl.m_product_id = pt.m_product_id) AND ((uomt.ad_language)::text = (pt.ad_language)::text))))
LEFT JOIN m_attributesetinstance asi ON ((iol.m_attributesetinstance_id = asi.m_attributesetinstance_id)))
LEFT JOIN m_locator l ON ((iol.m_locator_id = l.m_locator_id)));