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


カラム情報
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 m_inout_id numeric(10)  
9 issotrx character(1)  
10 documentno character varying(30)  
11 docaction character(2)  
12 docstatus character(2)  
13 posted character(1)  
14 processed character(1)  
15 c_doctype_id numeric(10)  
16 description character varying(255)  
17 c_order_id numeric(10)  
18 dateordered timestamp without time zone  
19 movementtype character(2)  
20 movementdate timestamp without time zone  
21 dateacct timestamp without time zone  
22 c_bpartner_id numeric(10)  
23 c_bpartner_location_id numeric(10)  
24 ad_user_id numeric(10)  
25 salesrep_id numeric(10)  
26 m_warehouse_id numeric(10)  
27 poreference character varying(20)  
28 deliveryrule character(1)  
29 freightcostrule character(1)  
30 freightamt numeric  
31 deliveryviarule character(1)  
32 m_shipper_id numeric(10)  
33 priorityrule character(1)  
34 dateprinted timestamp without time zone  
35 nopackages numeric(10)  
36 pickdate timestamp without time zone  
37 shipdate timestamp without time zone  
38 trackingno character varying(60)  
39 ad_orgtrx_id numeric(10)  
40 c_project_id numeric(10)  
41 c_campaign_id numeric(10)  
42 c_activity_id numeric(10)  
43 user1_id numeric(10)  
44 user2_id numeric(10)  
45 datereceived timestamp without time zone  
46 isapproved character(1)  
47 isindispute character(1)  
48 m_inoutline_id numeric(10)  
49 line numeric(10)  
50 linedescription character varying(255)  
51 c_orderline_id numeric(10)  
52 m_locator_id numeric(10)  
53 m_product_id numeric(10)  
54 c_uom_id numeric(10)  
55 m_attributesetinstance_id numeric(10)  
56 productattribute character varying  
57 m_attributeset_id numeric(10)  
58 m_lot_id numeric(10)  
59 guaranteedate timestamp without time zone  
60 lot character varying(40)  
61 serno character varying(40)  
62 movementqty numeric  
63 qtyentered numeric  
64 isdescription character(1)  
65 confirmedqty numeric  
66 pickedqty numeric  
67 scrappedqty numeric  
68 targetqty numeric  
69 locatorvalue character varying(40)  
70 x character varying(60)  
71 y character varying(60)  
72 z character varying(60)  
73 m_inout_c_charge_id numeric(10)  
74 chargeamt numeric  
75 m_inout_c_invoice_id numeric(10)  
76 createconfirm character(1)  
77 m_inout_created timestamp without time zone  
78 m_inout_createdby numeric(10)  
79 createfrom character(1)  
80 createpackage character(1)  
81 dropship_bpartner_id numeric(10)  
82 dropship_location_id numeric(10)  
83 dropship_user_id numeric(10)  
84 generateto character(1)  
85 m_inout_isactive character(1)  
86 isdropship character(1)  
87 isintransit character(1)  
88 isprinted character(1)  
89 m_rma_id numeric(10)  
90 processedon numeric  
91 processing character(1)  
92 ref_inout_id numeric(10)  
93 reversal_id numeric(10)  
94 sendemail character(1)  
95 m_inout_updated timestamp without time zone  
96 m_inout_updatedby numeric(10)  
97 volume numeric  
98 weight numeric  
99 m_inoutline_ad_org_id numeric(10)  
100 m_inoutline_ad_orgtrx_id numeric(10)  
101 m_inoutline_c_activity_id numeric(10)  
102 m_inoutline_c_campaign_id numeric(10)  
103 m_inoutline_c_charge_id numeric(10)  
104 m_inoutline_c_project_id numeric(10)  
105 c_projectphase_id numeric(10)  
106 c_projecttask_id numeric(10)  
107 isinvoiced character(1)  
108 m_rmaline_id numeric(10)  
109 m_inoutline_processed character(1)  
110 ref_inoutline_id numeric(10)  
111 reversalline_id numeric(10)  
112 m_inoutline_user1_id numeric(10)  
113 m_inoutline_user2_id numeric(10)  
114 m_locator_ad_org_id numeric(10)  
115 m_locator_isactive character(1)  
116 isdefault character(1)  
117 m_locator_m_warehouse_id numeric(10)  
118 priorityno numeric(10)  
119 m_asi_ad_org_id numeric(10)  
120 m_asi_created timestamp without time zone  
121 m_asi_createdby numeric(10)  
122 m_asi_description character varying(255)  
123 m_asi_isactive character(1)  
124 m_asi_updated timestamp without time zone  
125 m_asi_updatedby numeric(10)  


ソース
ソース 
 SELECT h.ad_client_id,
    h.ad_org_id,
    l.isactive,
    l.created,
    l.createdby,
    l.updated,
    l.updatedby,
    h.m_inout_id,
    h.issotrx,
    h.documentno,
    h.docaction,
    h.docstatus,
    h.posted,
    h.processed,
    h.c_doctype_id,
    h.description,
    h.c_order_id,
    h.dateordered,
    h.movementtype,
    h.movementdate,
    h.dateacct,
    h.c_bpartner_id,
    h.c_bpartner_location_id,
    h.ad_user_id,
    h.salesrep_id,
    h.m_warehouse_id,
    h.poreference,
    h.deliveryrule,
    h.freightcostrule,
    h.freightamt,
    h.deliveryviarule,
    h.m_shipper_id,
    h.priorityrule,
    h.dateprinted,
    h.nopackages,
    h.pickdate,
    h.shipdate,
    h.trackingno,
    h.ad_orgtrx_id,
    h.c_project_id,
    h.c_campaign_id,
    h.c_activity_id,
    h.user1_id,
    h.user2_id,
    h.datereceived,
    h.isapproved,
    h.isindispute,
    l.m_inoutline_id,
    l.line,
    l.description AS linedescription,
    l.c_orderline_id,
    l.m_locator_id,
    l.m_product_id,
    l.c_uom_id,
    l.m_attributesetinstance_id,
    productattribute(l.m_attributesetinstance_id) AS productattribute,
    pasi.m_attributeset_id,
    pasi.m_lot_id,
    pasi.guaranteedate,
    pasi.lot,
    pasi.serno,
    l.movementqty,
    l.qtyentered,
    l.isdescription,
    l.confirmedqty,
    l.pickedqty,
    l.scrappedqty,
    l.targetqty,
    loc.value AS locatorvalue,
    loc.x,
    loc.y,
    loc.z,
    h.c_charge_id AS m_inout_c_charge_id,
    h.chargeamt,
    h.c_invoice_id AS m_inout_c_invoice_id,
    h.createconfirm,
    h.created AS m_inout_created,
    h.createdby AS m_inout_createdby,
    h.createfrom,
    h.createpackage,
    h.dropship_bpartner_id,
    h.dropship_location_id,
    h.dropship_user_id,
    h.generateto,
    h.isactive AS m_inout_isactive,
    h.isdropship,
    h.isintransit,
    h.isprinted,
    h.m_rma_id,
    h.processedon,
    h.processing,
    h.ref_inout_id,
    h.reversal_id,
    h.sendemail,
    h.updated AS m_inout_updated,
    h.updatedby AS m_inout_updatedby,
    h.volume,
    h.weight,
    l.ad_org_id AS m_inoutline_ad_org_id,
    l.ad_orgtrx_id AS m_inoutline_ad_orgtrx_id,
    l.c_activity_id AS m_inoutline_c_activity_id,
    l.c_campaign_id AS m_inoutline_c_campaign_id,
    l.c_charge_id AS m_inoutline_c_charge_id,
    l.c_project_id AS m_inoutline_c_project_id,
    l.c_projectphase_id,
    l.c_projecttask_id,
    l.isinvoiced,
    l.m_rmaline_id,
    l.processed AS m_inoutline_processed,
    l.ref_inoutline_id,
    l.reversalline_id,
    l.user1_id AS m_inoutline_user1_id,
    l.user2_id AS m_inoutline_user2_id,
    loc.ad_org_id AS m_locator_ad_org_id,
    loc.isactive AS m_locator_isactive,
    loc.isdefault,
    loc.m_warehouse_id AS m_locator_m_warehouse_id,
    loc.priorityno,
    pasi.ad_org_id AS m_asi_ad_org_id,
    pasi.created AS m_asi_created,
    pasi.createdby AS m_asi_createdby,
    pasi.description AS m_asi_description,
    pasi.isactive AS m_asi_isactive,
    pasi.updated AS m_asi_updated,
    pasi.updatedby AS m_asi_updatedby
   FROM (((m_inout h
     JOIN m_inoutline l ON ((h.m_inout_id = l.m_inout_id)))
     LEFT JOIN m_locator loc ON ((l.m_locator_id = loc.m_locator_id)))
     LEFT JOIN m_attributesetinstance pasi ON ((l.m_attributesetinstance_id = pasi.m_attributesetinstance_id)));


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname rv_inoutdetails
3 viewowner adempiere
4 definition SELECT h.ad_client_id,
h.ad_org_id,
l.isactive,
l.created,
l.createdby,
l.updated,
l.updatedby,
h.m_inout_id,
h.issotrx,
h.documentno,
h.docaction,
h.docstatus,
h.posted,
h.processed,
h.c_doctype_id,
h.description,
h.c_order_id,
h.dateordered,
h.movementtype,
h.movementdate,
h.dateacct,
h.c_bpartner_id,
h.c_bpartner_location_id,
h.ad_user_id,
h.salesrep_id,
h.m_warehouse_id,
h.poreference,
h.deliveryrule,
h.freightcostrule,
h.freightamt,
h.deliveryviarule,
h.m_shipper_id,
h.priorityrule,
h.dateprinted,
h.nopackages,
h.pickdate,
h.shipdate,
h.trackingno,
h.ad_orgtrx_id,
h.c_project_id,
h.c_campaign_id,
h.c_activity_id,
h.user1_id,
h.user2_id,
h.datereceived,
h.isapproved,
h.isindispute,
l.m_inoutline_id,
l.line,
l.description AS linedescription,
l.c_orderline_id,
l.m_locator_id,
l.m_product_id,
l.c_uom_id,
l.m_attributesetinstance_id,
productattribute(l.m_attributesetinstance_id) AS productattribute,
pasi.m_attributeset_id,
pasi.m_lot_id,
pasi.guaranteedate,
pasi.lot,
pasi.serno,
l.movementqty,
l.qtyentered,
l.isdescription,
l.confirmedqty,
l.pickedqty,
l.scrappedqty,
l.targetqty,
loc.value AS locatorvalue,
loc.x,
loc.y,
loc.z,
h.c_charge_id AS m_inout_c_charge_id,
h.chargeamt,
h.c_invoice_id AS m_inout_c_invoice_id,
h.createconfirm,
h.created AS m_inout_created,
h.createdby AS m_inout_createdby,
h.createfrom,
h.createpackage,
h.dropship_bpartner_id,
h.dropship_location_id,
h.dropship_user_id,
h.generateto,
h.isactive AS m_inout_isactive,
h.isdropship,
h.isintransit,
h.isprinted,
h.m_rma_id,
h.processedon,
h.processing,
h.ref_inout_id,
h.reversal_id,
h.sendemail,
h.updated AS m_inout_updated,
h.updatedby AS m_inout_updatedby,
h.volume,
h.weight,
l.ad_org_id AS m_inoutline_ad_org_id,
l.ad_orgtrx_id AS m_inoutline_ad_orgtrx_id,
l.c_activity_id AS m_inoutline_c_activity_id,
l.c_campaign_id AS m_inoutline_c_campaign_id,
l.c_charge_id AS m_inoutline_c_charge_id,
l.c_project_id AS m_inoutline_c_project_id,
l.c_projectphase_id,
l.c_projecttask_id,
l.isinvoiced,
l.m_rmaline_id,
l.processed AS m_inoutline_processed,
l.ref_inoutline_id,
l.reversalline_id,
l.user1_id AS m_inoutline_user1_id,
l.user2_id AS m_inoutline_user2_id,
loc.ad_org_id AS m_locator_ad_org_id,
loc.isactive AS m_locator_isactive,
loc.isdefault,
loc.m_warehouse_id AS m_locator_m_warehouse_id,
loc.priorityno,
pasi.ad_org_id AS m_asi_ad_org_id,
pasi.created AS m_asi_created,
pasi.createdby AS m_asi_createdby,
pasi.description AS m_asi_description,
pasi.isactive AS m_asi_isactive,
pasi.updated AS m_asi_updated,
pasi.updatedby AS m_asi_updatedby
FROM (((m_inout h
JOIN m_inoutline l ON ((h.m_inout_id = l.m_inout_id)))
LEFT JOIN m_locator loc ON ((l.m_locator_id = loc.m_locator_id)))
LEFT JOIN m_attributesetinstance pasi ON ((l.m_attributesetinstance_id = pasi.m_attributesetinstance_id)));