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


カラム情報
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  
9 m_inout_id numeric(10)  
10 issotrx character(1)  
11 documentno character varying(30)  
12 docstatus character(2)  
13 c_doctype_id numeric(10)  
14 c_bpartner_id numeric(10)  
15 bpvalue character varying(40)  
16 bptaxid character varying(20)  
17 naics character(6)  
18 duns character(11)  
19 org_location_id numeric(10)  
20 taxid character varying(20)  
21 m_warehouse_id numeric(10)  
22 warehouse_location_id numeric(10)  
23 documenttype character varying(60)  
24 documenttypenote character varying(2000)  
25 c_order_id numeric(10)  
26 movementdate timestamp without time zone  
27 movementtype character(2)  
28 bpgreeting character varying(60)  
29 name character varying(120)  
30 name2 character varying(60)  
31 bpcontactgreeting character varying(60)  
32 title character varying(40)  
33 phone character varying(40)  
34 contactname text  
35 c_location_id numeric(10)  
36 postal text  
37 referenceno character varying(40)  
38 description character varying(255)  
39 poreference character varying(20)  
40 dateordered timestamp without time zone  
41 volume numeric  
42 weight numeric  
43 m_shipper_id numeric(10)  
44 deliveryrule character(1)  
45 deliveryviarule character(1)  
46 priorityrule character(1)  
47 logo_id numeric(10)  
48 ad_orgtrx_id numeric(10)  
49 ad_user_id numeric(10)  
50 c_activity_id numeric(10)  
51 c_bpartner_location_id numeric(10)  
52 c_campaign_id numeric(10)  
53 c_charge_id numeric(10)  
54 chargeamt numeric  
55 c_invoice_id numeric(10)  
56 c_project_id numeric(10)  
57 createconfirm character(1)  
58 createfrom character(1)  
59 createpackage character(1)  
60 dateacct timestamp without time zone  
61 dateprinted timestamp without time zone  
62 datereceived timestamp without time zone  
63 docaction character(2)  
64 dropship_bpartner_id numeric(10)  
65 dropship_location_id numeric(10)  
66 dropship_user_id numeric(10)  
67 freightamt numeric  
68 freightcostrule character(1)  
69 generateto character(1)  
70 isapproved character(1)  
71 isdropship character(1)  
72 isindispute character(1)  
73 m_inout_isintransit character(1)  
74 isprinted character(1)  
75 m_rma_id numeric(10)  
76 nopackages numeric(10)  
77 pickdate timestamp without time zone  
78 posted character(1)  
79 processed character(1)  
80 processedon numeric  
81 processing character(1)  
82 ref_inout_id numeric(10)  
83 reversal_id numeric(10)  
84 m_inout_salesrep_id numeric(10)  
85 sendemail character(1)  
86 shipdate timestamp without time zone  
87 trackingno character varying(60)  
88 user1_id numeric(10)  
89 user2_id numeric(10)  
90 c_bp_acqusitioncost numeric  
91 c_bp_actuallifetimevalue numeric  
92 c_bp_ad_language character varying(6)  
93 c_bp_ad_orgbp_id numeric(10)  
94 c_bp_ad_org_id numeric(10)  
95 c_bp_bpartner_parent_id numeric(10)  
96 c_bp_c_bp_group_id numeric(10)  
97 c_bp_c_dunning_id numeric(10)  
98 c_bp_c_greeting_id numeric(10)  
99 c_bp_c_invoiceschedule_id numeric(10)  
100 c_bp_c_paymentterm_id numeric(10)  
101 c_bp_created timestamp without time zone  
102 c_bp_createdby numeric(10)  
103 c_bp_c_taxgroup_id numeric(10)  
104 c_bp_deliveryrule character(1)  
105 c_bp_deliveryviarule character(1)  
106 c_bp_description character varying(255)  
107 c_bp_dunninggrace date  
108 c_bp_firstsale timestamp without time zone  
109 c_bp_flatdiscount numeric  
110 c_bp_freightcostrule character(1)  
111 c_bp_invoicerule character(1)  
112 c_bp_isactive character(1)  
113 c_bp_iscustomer character(1)  
114 c_bp_isdiscountprinted character(1)  
115 c_bp_isemployee character(1)  
116 c_bp_ismanufacturer character(1)  
117 c_bp_isonetime character(1)  
118 c_bp_ispotaxexempt character(1)  
119 c_bp_isprospect character(1)  
120 c_bp_issalesrep character(1)  
121 c_bp_issummary character(1)  
122 c_bp_istaxexempt character(1)  
123 c_bp_isvendor character(1)  
124 c_bp_logo_id numeric(10)  
125 c_bp_m_discountschema_id numeric(10)  
126 c_bp_m_pricelist_id numeric(10)  
127 c_bp_numberemployees numeric(10)  
128 c_bp_paymentrule character(1)  
129 c_bp_paymentrulepo character(1)  
130 c_bp_po_discountschema_id numeric(10)  
131 c_bp_po_paymentterm_id numeric(10)  
132 c_bp_po_pricelist_id numeric(10)  
133 c_bp_poreference character varying(20)  
134 c_bp_potentiallifetimevalue numeric  
135 c_bp_rating character(1)  
136 c_bp_salesrep_id numeric(10)  
137 c_bp_salesvolume numeric(10)  
138 c_bp_sendemail character(1)  
139 c_bp_shareofcustomer numeric(10)  
140 c_bp_shelflifeminpct numeric(10)  
141 c_bp_so_creditlimit numeric  
142 c_bp_socreditstatus character(1)  
143 c_bp_so_creditused numeric  
144 c_bp_so_description character varying(255)  
145 c_bp_totalopenbalance numeric  
146 c_bp_updated timestamp without time zone  
147 c_bp_updatedby numeric(10)  
148 c_bp_url character varying(120)  
149 c_greeting_ad_org_id numeric(10)  
150 c_greeting_isactive character(1)  
151 isfirstnameonly character(1)  
152 c_greeting_name character varying(60)  
153 c_bp_location_ad_org_id numeric(10)  
154 c_bp_location_c_bpartner_id numeric(10)  
155 c_bp_location_created timestamp without time zone  
156 c_bp_location_createdby numeric(10)  
157 c_salesregion_id numeric(10)  
158 c_bp_location_fax character varying(40)  
159 c_bp_location_isactive character(1)  
160 isbillto character(1)  
161 isdn character varying(40)  
162 ispayfrom character(1)  
163 isremitto character(1)  
164 isshipto character(1)  
165 c_bp_location_name character varying(60)  
166 c_bp_location_phone character varying(40)  
167 c_bp_location_phone2 character varying(40)  
168 c_bp_location_updated timestamp without time zone  
169 c_bp_location_updatedby numeric(10)  
170 address1 character varying(60)  
171 address2 character varying(60)  
172 address3 character varying(60)  
173 address4 character varying(60)  
174 c_location_ad_org_id numeric(10)  
175 c_city_id numeric(10)  
176 c_country_id numeric(10)  
177 city character varying(60)  
178 c_location_created timestamp without time zone  
179 c_location_createdby numeric(10)  
180 c_region_id numeric(10)  
181 c_location_isactive character(1)  
182 regionname character varying(40)  
183 c_location_updated timestamp without time zone  
184 c_location_updatedby numeric(10)  
185 ad_user_ad_org_id numeric(10)  
186 ad_user_ad_ad_orgtrx_id numeric(10)  
187 ad_user_ad_birthday timestamp without time zone  
188 ad_user_c_bpartner_id numeric(10)  
189 ad_user_c_bpartner_location_id numeric(10)  
190 ad_user_c_greeting_id numeric(10)  
191 ad_user_comments character varying(2000)  
192 ad_user_created timestamp without time zone  
193 ad_user_createdby numeric(10)  
194 ad_user_description character varying(255)  
195 ad_user_email character varying(60)  
196 ad_user_fax character varying(40)  
197 ad_user_isactive character(1)  
198 ad_user_lastcontact timestamp without time zone  
199 ad_user_lastresult character varying(255)  
200 ad_user_phone2 character varying(40)  
201 ad_user_supervisor_id numeric(10)  
202 ad_user_updated timestamp without time zone  
203 ad_user_updatedby numeric(10)  
204 ad_user_value character varying(40)  
205 c_user_greeting_ad_org_id numeric(10)  
206 c_user_greeting_isactive character(1)  
207 c_user_greeting_isfnameonly character(1)  
208 c_user_greeting_name character varying(60)  
209 ad_orginfo_ad_org_id numeric(10)  
210 ad_orgtype_id numeric(10)  
211 c_calendar_id numeric(10)  
212 ad_orginfo_created timestamp without time zone  
213 ad_orginfo_createdby numeric(10)  
214 dropship_warehouse_id numeric(10)  
215 ad_orginfo_duns character(11)  
216 ad_orginfo_email character varying(60)  
217 ad_orginfo_fax character varying(40)  
218 ad_orginfo_isactive character(1)  
219 ad_orginfo_m_warehouse_id numeric(10)  
220 parent_org_id numeric(10)  
221 ad_orginfo_phone character varying(40)  
222 ad_orginfo_phone2 character varying(40)  
223 receiptfootermsg character varying(1023)  
224 supervisor_id numeric(10)  
225 ad_orginfo_updated timestamp without time zone  
226 ad_orginfo_updatedby numeric(10)  
227 m_warehouse_ad_org_id numeric(10)  
228 m_warehouse_description character varying(255)  
229 m_warehouse__isactive character(1)  
230 isdisallownegativeinv character(1)  
231 m_warehouse_isintransit character(1)  
232 m_warehousesource_id numeric(10)  
233 m_warehouse_name character varying(60)  
234 replenishmentclass character varying(60)  
235 separator character(1)  
236 m_warehouse_value character varying(40)  


ソース
ソース
 SELECT io.ad_client_id,
io.ad_org_id,
io.isactive,
io.created,
io.createdby,
io.updated,
io.updatedby,
'en_US'::character varying AS ad_language,
io.m_inout_id,
io.issotrx,
io.documentno,
io.docstatus,
io.c_doctype_id,
io.c_bpartner_id,
bp.value AS bpvalue,
bp.taxid AS bptaxid,
bp.naics,
bp.duns,
oi.c_location_id AS org_location_id,
oi.taxid,
io.m_warehouse_id,
wh.c_location_id AS warehouse_location_id,
dt.printname AS documenttype,
dt.documentnote AS documenttypenote,
io.c_order_id,
io.movementdate,
io.movementtype,
bpg.greeting AS bpgreeting,
bp.name,
bp.name2,
bpcg.greeting AS bpcontactgreeting,
bpc.title,
bpc.phone,
NULLIF((bpc.name)::text, (bp.name)::text) AS contactname,
bpl.c_location_id,
((l.postal)::text || (l.postal_add)::text) AS postal,
bp.referenceno,
io.description,
io.poreference,
io.dateordered,
io.volume,
io.weight,
io.m_shipper_id,
io.deliveryrule,
io.deliveryviarule,
io.priorityrule,
COALESCE(oi.logo_id, ci.logo_id) AS logo_id,
io.ad_orgtrx_id,
io.ad_user_id,
io.c_activity_id,
io.c_bpartner_location_id,
io.c_campaign_id,
io.c_charge_id,
io.chargeamt,
io.c_invoice_id,
io.c_project_id,
io.createconfirm,
io.createfrom,
io.createpackage,
io.dateacct,
io.dateprinted,
io.datereceived,
io.docaction,
io.dropship_bpartner_id,
io.dropship_location_id,
io.dropship_user_id,
io.freightamt,
io.freightcostrule,
io.generateto,
io.isapproved,
io.isdropship,
io.isindispute,
io.isintransit AS m_inout_isintransit,
io.isprinted,
io.m_rma_id,
io.nopackages,
io.pickdate,
io.posted,
io.processed,
io.processedon,
io.processing,
io.ref_inout_id,
io.reversal_id,
io.salesrep_id AS m_inout_salesrep_id,
io.sendemail,
io.shipdate,
io.trackingno,
io.user1_id,
io.user2_id,
bp.acqusitioncost AS c_bp_acqusitioncost,
bp.actuallifetimevalue AS c_bp_actuallifetimevalue,
bp.ad_language AS c_bp_ad_language,
bp.ad_orgbp_id AS c_bp_ad_orgbp_id,
bp.ad_org_id AS c_bp_ad_org_id,
bp.bpartner_parent_id AS c_bp_bpartner_parent_id,
bp.c_bp_group_id AS c_bp_c_bp_group_id,
bp.c_dunning_id AS c_bp_c_dunning_id,
bp.c_greeting_id AS c_bp_c_greeting_id,
bp.c_invoiceschedule_id AS c_bp_c_invoiceschedule_id,
bp.c_paymentterm_id AS c_bp_c_paymentterm_id,
bp.created AS c_bp_created,
bp.createdby AS c_bp_createdby,
bp.c_taxgroup_id AS c_bp_c_taxgroup_id,
bp.deliveryrule AS c_bp_deliveryrule,
bp.deliveryviarule AS c_bp_deliveryviarule,
bp.description AS c_bp_description,
bp.dunninggrace AS c_bp_dunninggrace,
bp.firstsale AS c_bp_firstsale,
bp.flatdiscount AS c_bp_flatdiscount,
bp.freightcostrule AS c_bp_freightcostrule,
bp.invoicerule AS c_bp_invoicerule,
bp.isactive AS c_bp_isactive,
bp.iscustomer AS c_bp_iscustomer,
bp.isdiscountprinted AS c_bp_isdiscountprinted,
bp.isemployee AS c_bp_isemployee,
bp.ismanufacturer AS c_bp_ismanufacturer,
bp.isonetime AS c_bp_isonetime,
bp.ispotaxexempt AS c_bp_ispotaxexempt,
bp.isprospect AS c_bp_isprospect,
bp.issalesrep AS c_bp_issalesrep,
bp.issummary AS c_bp_issummary,
bp.istaxexempt AS c_bp_istaxexempt,
bp.isvendor AS c_bp_isvendor,
bp.logo_id AS c_bp_logo_id,
bp.m_discountschema_id AS c_bp_m_discountschema_id,
bp.m_pricelist_id AS c_bp_m_pricelist_id,
bp.numberemployees AS c_bp_numberemployees,
bp.paymentrule AS c_bp_paymentrule,
bp.paymentrulepo AS c_bp_paymentrulepo,
bp.po_discountschema_id AS c_bp_po_discountschema_id,
bp.po_paymentterm_id AS c_bp_po_paymentterm_id,
bp.po_pricelist_id AS c_bp_po_pricelist_id,
bp.poreference AS c_bp_poreference,
bp.potentiallifetimevalue AS c_bp_potentiallifetimevalue,
bp.rating AS c_bp_rating,
bp.salesrep_id AS c_bp_salesrep_id,
bp.salesvolume AS c_bp_salesvolume,
bp.sendemail AS c_bp_sendemail,
bp.shareofcustomer AS c_bp_shareofcustomer,
bp.shelflifeminpct AS c_bp_shelflifeminpct,
bp.so_creditlimit AS c_bp_so_creditlimit,
bp.socreditstatus AS c_bp_socreditstatus,
bp.so_creditused AS c_bp_so_creditused,
bp.so_description AS c_bp_so_description,
bp.totalopenbalance AS c_bp_totalopenbalance,
bp.updated AS c_bp_updated,
bp.updatedby AS c_bp_updatedby,
bp.url AS c_bp_url,
bpg.ad_org_id AS c_greeting_ad_org_id,
bpg.isactive AS c_greeting_isactive,
bpg.isfirstnameonly,
bpg.name AS c_greeting_name,
bpl.ad_org_id AS c_bp_location_ad_org_id,
bpl.c_bpartner_id AS c_bp_location_c_bpartner_id,
bpl.created AS c_bp_location_created,
bpl.createdby AS c_bp_location_createdby,
bpl.c_salesregion_id,
bpl.fax AS c_bp_location_fax,
bpl.isactive AS c_bp_location_isactive,
bpl.isbillto,
bpl.isdn,
bpl.ispayfrom,
bpl.isremitto,
bpl.isshipto,
bpl.name AS c_bp_location_name,
bpl.phone AS c_bp_location_phone,
bpl.phone2 AS c_bp_location_phone2,
bpl.updated AS c_bp_location_updated,
bpl.updatedby AS c_bp_location_updatedby,
l.address1,
l.address2,
l.address3,
l.address4,
l.ad_org_id AS c_location_ad_org_id,
l.c_city_id,
l.c_country_id,
l.city,
l.created AS c_location_created,
l.createdby AS c_location_createdby,
l.c_region_id,
l.isactive AS c_location_isactive,
l.regionname,
l.updated AS c_location_updated,
l.updatedby AS c_location_updatedby,
bpc.ad_org_id AS ad_user_ad_org_id,
bpc.ad_orgtrx_id AS ad_user_ad_ad_orgtrx_id,
bpc.birthday AS ad_user_ad_birthday,
bpc.c_bpartner_id AS ad_user_c_bpartner_id,
bpc.c_bpartner_location_id AS ad_user_c_bpartner_location_id,
bpc.c_greeting_id AS ad_user_c_greeting_id,
bpc.comments AS ad_user_comments,
bpc.created AS ad_user_created,
bpc.createdby AS ad_user_createdby,
bpc.description AS ad_user_description,
bpc.email AS ad_user_email,
bpc.fax AS ad_user_fax,
bpc.isactive AS ad_user_isactive,
bpc.lastcontact AS ad_user_lastcontact,
bpc.lastresult AS ad_user_lastresult,
bpc.phone2 AS ad_user_phone2,
bpc.supervisor_id AS ad_user_supervisor_id,
bpc.updated AS ad_user_updated,
bpc.updatedby AS ad_user_updatedby,
bpc.value AS ad_user_value,
bpcg.ad_org_id AS c_user_greeting_ad_org_id,
bpcg.isactive AS c_user_greeting_isactive,
bpcg.isfirstnameonly AS c_user_greeting_isfnameonly,
bpcg.name AS c_user_greeting_name,
oi.ad_org_id AS ad_orginfo_ad_org_id,
oi.ad_orgtype_id,
oi.c_calendar_id,
oi.created AS ad_orginfo_created,
oi.createdby AS ad_orginfo_createdby,
oi.dropship_warehouse_id,
oi.duns AS ad_orginfo_duns,
oi.email AS ad_orginfo_email,
oi.fax AS ad_orginfo_fax,
oi.isactive AS ad_orginfo_isactive,
oi.m_warehouse_id AS ad_orginfo_m_warehouse_id,
oi.parent_org_id,
oi.phone AS ad_orginfo_phone,
oi.phone2 AS ad_orginfo_phone2,
oi.receiptfootermsg,
oi.supervisor_id,
oi.updated AS ad_orginfo_updated,
oi.updatedby AS ad_orginfo_updatedby,
wh.ad_org_id AS m_warehouse_ad_org_id,
wh.description AS m_warehouse_description,
wh.isactive AS m_warehouse__isactive,
wh.isdisallownegativeinv,
wh.isintransit AS m_warehouse_isintransit,
wh.m_warehousesource_id,
wh.name AS m_warehouse_name,
wh.replenishmentclass,
wh.separator,
wh.value AS m_warehouse_value
FROM ((((((((((m_inout io
JOIN c_doctype dt ON ((io.c_doctype_id = dt.c_doctype_id)))
JOIN c_bpartner bp ON ((io.c_bpartner_id = bp.c_bpartner_id)))
LEFT JOIN c_greeting bpg ON ((bp.c_greeting_id = bpg.c_greeting_id)))
JOIN c_bpartner_location bpl ON ((io.c_bpartner_location_id = bpl.c_bpartner_location_id)))
JOIN c_location l ON ((bpl.c_location_id = l.c_location_id)))
LEFT JOIN ad_user bpc ON ((io.ad_user_id = bpc.ad_user_id)))
LEFT JOIN c_greeting bpcg ON ((bpc.c_greeting_id = bpcg.c_greeting_id)))
JOIN ad_orginfo oi ON ((io.ad_org_id = oi.ad_org_id)))
JOIN ad_clientinfo ci ON ((io.ad_client_id = ci.ad_client_id)))
JOIN m_warehouse wh ON ((io.m_warehouse_id = wh.m_warehouse_id)));


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname m_inout_header_v
3 viewowner adempiere
4 definition SELECT io.ad_client_id,
io.ad_org_id,
io.isactive,
io.created,
io.createdby,
io.updated,
io.updatedby,
'en_US'::character varying AS ad_language,
io.m_inout_id,
io.issotrx,
io.documentno,
io.docstatus,
io.c_doctype_id,
io.c_bpartner_id,
bp.value AS bpvalue,
bp.taxid AS bptaxid,
bp.naics,
bp.duns,
oi.c_location_id AS org_location_id,
oi.taxid,
io.m_warehouse_id,
wh.c_location_id AS warehouse_location_id,
dt.printname AS documenttype,
dt.documentnote AS documenttypenote,
io.c_order_id,
io.movementdate,
io.movementtype,
bpg.greeting AS bpgreeting,
bp.name,
bp.name2,
bpcg.greeting AS bpcontactgreeting,
bpc.title,
bpc.phone,
NULLIF((bpc.name)::text, (bp.name)::text) AS contactname,
bpl.c_location_id,
((l.postal)::text || (l.postal_add)::text) AS postal,
bp.referenceno,
io.description,
io.poreference,
io.dateordered,
io.volume,
io.weight,
io.m_shipper_id,
io.deliveryrule,
io.deliveryviarule,
io.priorityrule,
COALESCE(oi.logo_id, ci.logo_id) AS logo_id,
io.ad_orgtrx_id,
io.ad_user_id,
io.c_activity_id,
io.c_bpartner_location_id,
io.c_campaign_id,
io.c_charge_id,
io.chargeamt,
io.c_invoice_id,
io.c_project_id,
io.createconfirm,
io.createfrom,
io.createpackage,
io.dateacct,
io.dateprinted,
io.datereceived,
io.docaction,
io.dropship_bpartner_id,
io.dropship_location_id,
io.dropship_user_id,
io.freightamt,
io.freightcostrule,
io.generateto,
io.isapproved,
io.isdropship,
io.isindispute,
io.isintransit AS m_inout_isintransit,
io.isprinted,
io.m_rma_id,
io.nopackages,
io.pickdate,
io.posted,
io.processed,
io.processedon,
io.processing,
io.ref_inout_id,
io.reversal_id,
io.salesrep_id AS m_inout_salesrep_id,
io.sendemail,
io.shipdate,
io.trackingno,
io.user1_id,
io.user2_id,
bp.acqusitioncost AS c_bp_acqusitioncost,
bp.actuallifetimevalue AS c_bp_actuallifetimevalue,
bp.ad_language AS c_bp_ad_language,
bp.ad_orgbp_id AS c_bp_ad_orgbp_id,
bp.ad_org_id AS c_bp_ad_org_id,
bp.bpartner_parent_id AS c_bp_bpartner_parent_id,
bp.c_bp_group_id AS c_bp_c_bp_group_id,
bp.c_dunning_id AS c_bp_c_dunning_id,
bp.c_greeting_id AS c_bp_c_greeting_id,
bp.c_invoiceschedule_id AS c_bp_c_invoiceschedule_id,
bp.c_paymentterm_id AS c_bp_c_paymentterm_id,
bp.created AS c_bp_created,
bp.createdby AS c_bp_createdby,
bp.c_taxgroup_id AS c_bp_c_taxgroup_id,
bp.deliveryrule AS c_bp_deliveryrule,
bp.deliveryviarule AS c_bp_deliveryviarule,
bp.description AS c_bp_description,
bp.dunninggrace AS c_bp_dunninggrace,
bp.firstsale AS c_bp_firstsale,
bp.flatdiscount AS c_bp_flatdiscount,
bp.freightcostrule AS c_bp_freightcostrule,
bp.invoicerule AS c_bp_invoicerule,
bp.isactive AS c_bp_isactive,
bp.iscustomer AS c_bp_iscustomer,
bp.isdiscountprinted AS c_bp_isdiscountprinted,
bp.isemployee AS c_bp_isemployee,
bp.ismanufacturer AS c_bp_ismanufacturer,
bp.isonetime AS c_bp_isonetime,
bp.ispotaxexempt AS c_bp_ispotaxexempt,
bp.isprospect AS c_bp_isprospect,
bp.issalesrep AS c_bp_issalesrep,
bp.issummary AS c_bp_issummary,
bp.istaxexempt AS c_bp_istaxexempt,
bp.isvendor AS c_bp_isvendor,
bp.logo_id AS c_bp_logo_id,
bp.m_discountschema_id AS c_bp_m_discountschema_id,
bp.m_pricelist_id AS c_bp_m_pricelist_id,
bp.numberemployees AS c_bp_numberemployees,
bp.paymentrule AS c_bp_paymentrule,
bp.paymentrulepo AS c_bp_paymentrulepo,
bp.po_discountschema_id AS c_bp_po_discountschema_id,
bp.po_paymentterm_id AS c_bp_po_paymentterm_id,
bp.po_pricelist_id AS c_bp_po_pricelist_id,
bp.poreference AS c_bp_poreference,
bp.potentiallifetimevalue AS c_bp_potentiallifetimevalue,
bp.rating AS c_bp_rating,
bp.salesrep_id AS c_bp_salesrep_id,
bp.salesvolume AS c_bp_salesvolume,
bp.sendemail AS c_bp_sendemail,
bp.shareofcustomer AS c_bp_shareofcustomer,
bp.shelflifeminpct AS c_bp_shelflifeminpct,
bp.so_creditlimit AS c_bp_so_creditlimit,
bp.socreditstatus AS c_bp_socreditstatus,
bp.so_creditused AS c_bp_so_creditused,
bp.so_description AS c_bp_so_description,
bp.totalopenbalance AS c_bp_totalopenbalance,
bp.updated AS c_bp_updated,
bp.updatedby AS c_bp_updatedby,
bp.url AS c_bp_url,
bpg.ad_org_id AS c_greeting_ad_org_id,
bpg.isactive AS c_greeting_isactive,
bpg.isfirstnameonly,
bpg.name AS c_greeting_name,
bpl.ad_org_id AS c_bp_location_ad_org_id,
bpl.c_bpartner_id AS c_bp_location_c_bpartner_id,
bpl.created AS c_bp_location_created,
bpl.createdby AS c_bp_location_createdby,
bpl.c_salesregion_id,
bpl.fax AS c_bp_location_fax,
bpl.isactive AS c_bp_location_isactive,
bpl.isbillto,
bpl.isdn,
bpl.ispayfrom,
bpl.isremitto,
bpl.isshipto,
bpl.name AS c_bp_location_name,
bpl.phone AS c_bp_location_phone,
bpl.phone2 AS c_bp_location_phone2,
bpl.updated AS c_bp_location_updated,
bpl.updatedby AS c_bp_location_updatedby,
l.address1,
l.address2,
l.address3,
l.address4,
l.ad_org_id AS c_location_ad_org_id,
l.c_city_id,
l.c_country_id,
l.city,
l.created AS c_location_created,
l.createdby AS c_location_createdby,
l.c_region_id,
l.isactive AS c_location_isactive,
l.regionname,
l.updated AS c_location_updated,
l.updatedby AS c_location_updatedby,
bpc.ad_org_id AS ad_user_ad_org_id,
bpc.ad_orgtrx_id AS ad_user_ad_ad_orgtrx_id,
bpc.birthday AS ad_user_ad_birthday,
bpc.c_bpartner_id AS ad_user_c_bpartner_id,
bpc.c_bpartner_location_id AS ad_user_c_bpartner_location_id,
bpc.c_greeting_id AS ad_user_c_greeting_id,
bpc.comments AS ad_user_comments,
bpc.created AS ad_user_created,
bpc.createdby AS ad_user_createdby,
bpc.description AS ad_user_description,
bpc.email AS ad_user_email,
bpc.fax AS ad_user_fax,
bpc.isactive AS ad_user_isactive,
bpc.lastcontact AS ad_user_lastcontact,
bpc.lastresult AS ad_user_lastresult,
bpc.phone2 AS ad_user_phone2,
bpc.supervisor_id AS ad_user_supervisor_id,
bpc.updated AS ad_user_updated,
bpc.updatedby AS ad_user_updatedby,
bpc.value AS ad_user_value,
bpcg.ad_org_id AS c_user_greeting_ad_org_id,
bpcg.isactive AS c_user_greeting_isactive,
bpcg.isfirstnameonly AS c_user_greeting_isfnameonly,
bpcg.name AS c_user_greeting_name,
oi.ad_org_id AS ad_orginfo_ad_org_id,
oi.ad_orgtype_id,
oi.c_calendar_id,
oi.created AS ad_orginfo_created,
oi.createdby AS ad_orginfo_createdby,
oi.dropship_warehouse_id,
oi.duns AS ad_orginfo_duns,
oi.email AS ad_orginfo_email,
oi.fax AS ad_orginfo_fax,
oi.isactive AS ad_orginfo_isactive,
oi.m_warehouse_id AS ad_orginfo_m_warehouse_id,
oi.parent_org_id,
oi.phone AS ad_orginfo_phone,
oi.phone2 AS ad_orginfo_phone2,
oi.receiptfootermsg,
oi.supervisor_id,
oi.updated AS ad_orginfo_updated,
oi.updatedby AS ad_orginfo_updatedby,
wh.ad_org_id AS m_warehouse_ad_org_id,
wh.description AS m_warehouse_description,
wh.isactive AS m_warehouse__isactive,
wh.isdisallownegativeinv,
wh.isintransit AS m_warehouse_isintransit,
wh.m_warehousesource_id,
wh.name AS m_warehouse_name,
wh.replenishmentclass,
wh.separator,
wh.value AS m_warehouse_value
FROM ((((((((((m_inout io
JOIN c_doctype dt ON ((io.c_doctype_id = dt.c_doctype_id)))
JOIN c_bpartner bp ON ((io.c_bpartner_id = bp.c_bpartner_id)))
LEFT JOIN c_greeting bpg ON ((bp.c_greeting_id = bpg.c_greeting_id)))
JOIN c_bpartner_location bpl ON ((io.c_bpartner_location_id = bpl.c_bpartner_location_id)))
JOIN c_location l ON ((bpl.c_location_id = l.c_location_id)))
LEFT JOIN ad_user bpc ON ((io.ad_user_id = bpc.ad_user_id)))
LEFT JOIN c_greeting bpcg ON ((bpc.c_greeting_id = bpcg.c_greeting_id)))
JOIN ad_orginfo oi ON ((io.ad_org_id = oi.ad_org_id)))
JOIN ad_clientinfo ci ON ((io.ad_client_id = ci.ad_client_id)))
JOIN m_warehouse wh ON ((io.m_warehouse_id = wh.m_warehouse_id)));