	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

200 COLUMNS | 8 INDEXES | 920 | 42 | F42565 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
42: Sales Management
1	920	F42565	IW	200	8	Invoice Print File	Regular Work Files	42: Sales Management	Business Data

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT IWCTID, IWJOBS, IWDOC, IWDCT, IWKCO, IWDOCO, IWDCTO, IWKCOO, IWLNID, IWOSEQ, IWSUBSEQ, IWAN8, IWSHAN, IWMCU, IWCO, IWITM, IWPRNT, IWDSC1, IWDSC2, IWUITM, IWUOM, IWUOM4, IWSOQS, IWSOBK, IWSOCN, IWUPRC, IWAEXP, IWECST, IWPCT1, IWDRQJ, IWCOMM, IWLNTY, IWTXYN, IWCDSC, IWIVI, IWCITM, IWIVD, IWRORN, IWRCTO, IWRKCO, IWINMG, IWTAX1, IWTXA1, IWEXR1, IWTAXA, IWTA1, IWTA2, IWTA3, IWTA4, IWTA5, IWTXR1, IWTXR2, IWTXR3, IWTXR4, IWTXR5, IWTC2, IWTT3, IWTT4, IWTT5, IWFVTY, IWHBUS, IWTRAT, IWATXA, IWSTAM, IWPTC, IWADSC, IWUSER, IWPID, IWJOBN, IWUPMJ, IWTDAY, IWEDOC, IWEDCT, IWEKCO, IWEDLN, IWSFXO, IWPA8, IWDSCT, IWTAXT, IWTAX2, IWTAX3, IWTAX4, IWTAX5, IWATXN, IWLPRC, IWCRCD, IWCRDC, IWCRR, IWLITM, IWCARS, IWDMCS, IWDMCT, IWRSSN, IWDTPU, IWSHPN, IWDETP, IWDCNS, IWDNTP, IWEMCU, IWDNTY, IWSTPU, IWSEQN, IWTEMP, IWREFN, IWREFQ, IWLOAD, IWTRP, IWMMCO, IWVMCU, IWVCF, IWMCUS, IWWGTR, IWAMBR, IWBUM5, IWBUM4, IWBUM3, IWSTOK, IWDTYS, IWLOTN, IWAIEP, IWAILP, IWAITR, IWAIT1, IWAIT2, IWAIT3, IWAIT4, IWAIT5, IWAICM, IWAITX, IWAITA, IWAITU, IWAIAD, IWAIX1, IWAIX2, IWAIX3, IWAIS1, IWAIS2, IWAIS3, IWAIS4, IWAIS5, IWAICC, IWAIRR, IWAITD, IWAITS, IWSPHD, IWATAM, IWATAT, IWAIAM, IWAIAT, IWN1FU, IWN2FU, IWN3FU, IWC1FU, IWC2FU, IWD1FU, IWD2FU, IWS1FU, IWS2FU, IWFVTR, IWBSDVAL, IWSRFLAG, IWSOOR, IWRCD, IWPBAN, IWOORN, IWODOC, IWODCT, IWOCTO, IWFTAN, IWDOC1, IWDCT4, IWITMU, IWUTAM, IWUOM2, IWSQOR, IWCIRV, IWPSJOBNO, IWJOBSQ, IWCARDNO, IWRLIT, IWKITID, IWKITAMTDOM, IWKITAMTFOR, IWKITDIRTY, IWKTLN, IWSTKT, IWRKIT, IWSIDT, IWAST, IWTUPRC, IWTAEXP, IWTAIEP, IWUTA, IWETA, IWTKITAMTD, IWTKITAMTF, IWDTXJ, IWUTP, IWOILNTY, IWAEXPO FROM F42565

TOP 920 | 42 | F42565 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	IWCTID	Computer ID	String	Generic Edit	15	0	Allow NULL?
2	IWJOBS	Job Number	Numeric	Generic Edit	8	0	Allow NULL?
3	IWDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
4	IWDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
5	IWKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
6	IWDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
7	IWDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
8	IWKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
9	IWLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
10	IWOSEQ	Sequence Number	Numeric	Generic Edit	4	0	Allow NULL?
11	IWSUBSEQ	Sub-Sequence Number	Numeric	Generic Edit	4	0	Allow NULL?
12	IWAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
13	IWSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
14	IWMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
15	IWCO	Company	String	Generic Edit	5	0	Allow NULL?
16	IWITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
17	IWPRNT	Print Data (Y/N)	Character	UDC (48 PN)	1	0	Allow NULL?
18	IWDSC1	Description	String	Generic Edit	30	0	Allow NULL?
19	IWDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
20	IWUITM	Item Number - Unknown Format Entered	String	Generic Edit	26	0	Allow NULL?
21	IWUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
22	IWUOM4	Unit of Measure - Pricing	String	UDC (00 UM)	2	0	Allow NULL?
23	IWSOQS	Quantity Shipped	Numeric	Generic Edit	15	0	Allow NULL?
24	IWSOBK	Units - Qty Backordered/Held	Numeric	Generic Edit	15	0	Allow NULL?
25	IWSOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	0	Allow NULL?
26	IWUPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
27	IWAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
28	IWECST	Amount - Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
29	IWPCT1	Percent1	Numeric	Generic Edit	3	0	Allow NULL?
30	IWDRQJ	Date - Requested	Date	Generic Edit	6	0
31	IWCOMM	Committed (H/S)	Character	UDC (H42 CP)	1	0	Allow NULL?
32	IWLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
33	IWTXYN	Text (Y/N)	Character	Generic Edit	1	0	Allow NULL?
34	IWCDSC	Include in Cash Discount Calculation	Character	Generic Edit	1	0	Allow NULL?
35	IWIVI	Inventory Interface Y/N - Distribution	Character	UDC (H40 IV)	1	0	Allow NULL?
36	IWCITM	Item Number - Customer/Supplier	String	Generic Edit	25	0	Allow NULL?
37	IWIVD	Date - Invoice	Date	Generic Edit	6	0
38	IWRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
39	IWRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
40	IWRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
41	IWINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
42	IWTAX1	Sales Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
43	IWTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
44	IWEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
45	IWTAXA	Description - Tax Area	String	Generic Edit	30	0	Allow NULL?
46	IWTA1	Tax Authority	Numeric	Generic Edit	8	0	Allow NULL?
47	IWTA2	Tax Authority 2	Numeric	Generic Edit	8	0	Allow NULL?
48	IWTA3	Tax Authority 3	Numeric	Generic Edit	8	0	Allow NULL?
49	IWTA4	Tax Authority 4	Numeric	Generic Edit	8	0	Allow NULL?
50	IWTA5	Tax Authority 5	Numeric	Generic Edit	8	0	Allow NULL?
51	IWTXR1	Tax Rate 1	Numeric	Generic Edit	7	3	Allow NULL?
52	IWTXR2	Tax Rate 2	Numeric	Generic Edit	7	3	Allow NULL?
53	IWTXR3	Tax Rate 3	Numeric	Generic Edit	7	3	Allow NULL?
54	IWTXR4	Tax Rate 4	Numeric	Generic Edit	7	3	Allow NULL?
55	IWTXR5	Tax Rate 5	Numeric	Generic Edit	7	3	Allow NULL?
56	IWTC2	Tax Calculation Method	Character	Generic Edit	1	0	Allow NULL?
57	IWTT3	Tax Type	Character	UDC (H00 TU)	1	0	Allow NULL?
58	IWTT4	Tax Type	Character	UDC (H00 TU)	1	0	Allow NULL?
59	IWTT5	Tax Type	Character	UDC (H00 TU)	1	0	Allow NULL?
60	IWFVTY	Factor Value - Type	Character	UDC (H00 FV)	1	0	Allow NULL?
61	IWHBUS	Has Been Used	Character	Generic Edit	1	0	Allow NULL?
62	IWTRAT	Total Area Tax Rate	Numeric	Generic Edit	6	3	Allow NULL?
63	IWATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
64	IWSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
65	IWPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
66	IWADSC	Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
67	IWUSER	User ID	String	Generic Edit	10	0	Allow NULL?
68	IWPID	Program ID	String	Generic Edit	10	0	Allow NULL?
69	IWJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
70	IWUPMJ	Date - Updated	Date	Generic Edit	6	0
71	IWTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
72	IWEDOC	EDI - Document Number	Numeric	Generic Edit	9	0	Allow NULL?
73	IWEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
74	IWEKCO	Company - Key (EDI - Document Key Co)	String	Generic Edit	5	0	Allow NULL?
75	IWEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
76	IWSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
77	IWPA8	Address Number - Parent	Numeric	Generic Edit	8	0	Allow NULL?
78	IWDSCT	Discount Amount	Numeric	Generic Edit	15	2	Allow NULL?
79	IWTAXT	Amount - Sales Tax Total 1	Numeric	Generic Edit	15	2	Allow NULL?
80	IWTAX2	Amount - Sales Tax Total 2	Numeric	Generic Edit	15	2	Allow NULL?
81	IWTAX3	Amount - Sales Tax Total 3	Numeric	Generic Edit	15	2	Allow NULL?
82	IWTAX4	Amount - Sales Tax Total 4	Numeric	Generic Edit	15	2	Allow NULL?
83	IWTAX5	Amount - Sales Tax Total 5	Numeric	Generic Edit	15	2	Allow NULL?
84	IWATXN	Amount - Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
85	IWLPRC	Amount - List Price	Numeric	Generic Edit	15	4	Allow NULL?
86	IWCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
87	IWCRDC	Currency Code - To	String	Generic Edit	3	0	Allow NULL?
88	IWCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
89	IWLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
90	IWCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
91	IWDMCS	Agreement Supplement - Distribution	Numeric	Generic Edit	3	0	Allow NULL?
92	IWDMCT	Agreement Number - Distribution	String	Generic Edit	12	0	Allow NULL?
93	IWRSSN	Routing Step Number	Numeric	Generic Edit	3	1	Allow NULL?
94	IWDTPU	Temperature Type	Character	UDC (41B TP)	1	0	Allow NULL?
95	IWSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
96	IWDETP	Density Temperature	Numeric	Generic Edit	7	2	Allow NULL?
97	IWDCNS	Document Number Source	Character	UDC (49 DA)	1	0	Allow NULL?
98	IWDNTP	Density Type - At Standard Temperature	Character	UDC (41B DT)	1	0	Allow NULL?
99	IWEMCU	Business Unit - Header	String	Generic Edit	12	0	Allow NULL?
100	IWDNTY	Density	Numeric	Generic Edit	7	2	Allow NULL?
101	IWSTPU	Temperature Type	Character	UDC (41B TP)	1	0	Allow NULL?
102	IWSEQN	Sequence Number	Numeric	Generic Edit	7	0	Allow NULL?
103	IWTEMP	Temperature	Numeric	Generic Edit	7	2	Allow NULL?
104	IWREFN	Reference Number	String	Generic Edit	30	0	Allow NULL?
105	IWREFQ	Reference Number Qualifier	String	UDC (41 X6)	2	0	Allow NULL?
106	IWLOAD	Date - Scheduled Load	Date	Generic Edit	6	0
107	IWTRP	Trip Number	Numeric	Generic Edit	8	0	Allow NULL?
108	IWMMCO	Company	String	Generic Edit	5	0	Allow NULL?
109	IWVMCU	Depot - Trip	String	Generic Edit	12	0	Allow NULL?
110	IWVCF	Volume Correction Factor	Numeric	Generic Edit	7	5	Allow NULL?
111	IWMCUS	Business Unit - Subsequent	String	Generic Edit	12	0	Allow NULL?
112	IWWGTR	Weight Result	Numeric	Generic Edit	15	0	Allow NULL?
113	IWAMBR	Volume - Ambient	Numeric	Generic Edit	15	0	Allow NULL?
114	IWBUM5	Unit of Measure 5	String	UDC (00 UM)	2	0	Allow NULL?
115	IWBUM4	Unit of Measure 4	String	UDC (00 UM)	2	0	Allow NULL?
116	IWBUM3	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
117	IWSTOK	Volume - Standard	Numeric	Generic Edit	15	0	Allow NULL?
118	IWDTYS	Duty Status	String	UDC (40 DS)	2	0	Allow NULL?
119	IWLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
120	IWAIEP	As If Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
121	IWAILP	As If List Price	Numeric	Generic Edit	15	4	Allow NULL?
122	IWAITR	As If Total Tax Rate	Numeric	Generic Edit	6	3	Allow NULL?
123	IWAIT1	As If Tax Authority	Numeric	Generic Edit	8	0	Allow NULL?
124	IWAIT2	As If Tax Authority 2	Numeric	Generic Edit	8	0	Allow NULL?
125	IWAIT3	As If Tax Authority 3	Numeric	Generic Edit	8	0	Allow NULL?
126	IWAIT4	As If Tax Authority 4	Numeric	Generic Edit	8	0	Allow NULL?
127	IWAIT5	As If Tax Authority 5	Numeric	Generic Edit	8	0	Allow NULL?
128	IWAICM	As If Tax Calculation Method	Character	Generic Edit	1	0	Allow NULL?
129	IWAITX	As If Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
130	IWAITA	As If Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
131	IWAITU	As If Amount Tax Unrounded	Numeric	Generic Edit	15	4	Allow NULL?
132	IWAIAD	As If Amount - Discount	Numeric	Generic Edit	15	2	Allow NULL?
133	IWAIX1	As If Tax Type 1	Character	UDC (H00 TU)	1	0	Allow NULL?
134	IWAIX2	As If Tax Type 2	Character	UDC (H00 TU)	1	0	Allow NULL?
135	IWAIX3	As If Tax Type 3	Character	UDC (H00 TU)	1	0	Allow NULL?
136	IWAIS1	As If Amount - Sales Tax Total 1	Numeric	Generic Edit	15	2	Allow NULL?
137	IWAIS2	As If Amount - Sales Tax Total 2	Numeric	Generic Edit	15	2	Allow NULL?
138	IWAIS3	As If Amount - Sales Tax Total 3	Numeric	Generic Edit	15	2	Allow NULL?
139	IWAIS4	As If Amount - Sales Tax Total 4	Numeric	Generic Edit	15	2	Allow NULL?
140	IWAIS5	As If Amount - Sales Tax Total 5	Numeric	Generic Edit	15	2	Allow NULL?
141	IWAICC	As If Currency Code	String	Generic Edit	3	0	Allow NULL?
142	IWAIRR	As If Currency Conversion Rate-Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
143	IWAITD	As If Transaction Date	Date	Generic Edit	6	0
144	IWAITS	As If Print Tax Summary	Character	Generic Edit	1	0	Allow NULL?
145	IWSPHD	Special Handling Code - User Def Codes	String	Generic Edit	10	0	Allow NULL?
146	IWATAM	Prepayment Tax Amount	Numeric	Generic Edit	15	2	Allow NULL?
147	IWATAT	Prepayment Amount	Numeric	Generic Edit	15	2	Allow NULL?
148	IWAIAM	As If Prepayment Tax Amount	Numeric	Generic Edit	15	2	Allow NULL?
149	IWAIAT	As If Prepayment Amount	Numeric	Generic Edit	15	2	Allow NULL?
150	IWN1FU	Future Use - Math Numeric 1	Numeric	Generic Edit	15	2	Allow NULL?
151	IWN2FU	Future Use - Math Numeric 2	Numeric	Generic Edit	15	8	Allow NULL?
152	IWN3FU	Futrue Use Math Numeric 3	Numeric	Generic Edit	15	8	Allow NULL?
153	IWC1FU	Future Use - Character 1	Character	Generic Edit	1	0	Allow NULL?
154	IWC2FU	Future Use - Character 1	Character	Generic Edit	1	0	Allow NULL?
155	IWD1FU	Future Use - Date 1	Date	Generic Edit	6	0
156	IWD2FU	Future Use - Date 2	Date	Generic Edit	6	0
157	IWS1FU	Future Use String 1	String	Generic Edit	30	0	Allow NULL?
158	IWS2FU	Future Use String 2	String	Generic Edit	30	0	Allow NULL?
159	IWFVTR	Factor Value	Numeric	Generic Edit	15	4	Allow NULL?
160	IWBSDVAL	Based on Value	Numeric	Generic Edit	15	4	Allow NULL?
161	IWSRFLAG	Sliding Rate Flag	Character	Generic Edit	1	0	Allow NULL?
162	IWSOOR	Source of Order	Integer	Generic Edit	11	0	Allow NULL?
163	IWRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
164	IWPBAN	Address Number - Paid By	Numeric	Generic Edit	8	0	Allow NULL?
165	IWOORN	Original Order Number	String	Generic Edit	8	0	Allow NULL?
166	IWODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
167	IWODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
168	IWOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
169	IWFTAN	Address Number - Forwarded To	Numeric	Generic Edit	8	0	Allow NULL?
170	IWDOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
171	IWDCT4	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
172	IWITMU	Item Used in Tax Calculation	Character	Generic Edit	1	0	Allow NULL?
173	IWUTAM	UnroundedTaxAmount	Numeric	Generic Edit	15	4	Allow NULL?
174	IWUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
175	IWSQOR	Units - Secondary Quantity Ordered	Numeric	Generic Edit	15	0	Allow NULL?
176	IWCIRV	Item Revision Level - Customer/Supplier	String	Generic Edit	20	0	Allow NULL?
177	IWPSJOBNO	Production Sequencing Job Number	String	Generic Edit	15	0	Allow NULL?
178	IWJOBSQ	Job Sequence Number	String	Generic Edit	15	0	Allow NULL?
179	IWCARDNO	Card Number	String	UDC (40R CD)	4	0	Allow NULL?
180	IWRLIT	Item Number - Related (Kit)	String	Generic Edit	8	0	Allow NULL?
181	IWKITID	Kit Identifier	Numeric	Generic Edit	15	0	Allow NULL?
182	IWKITAMTDOM	Accumulated Amount Invoiced (Domestic)	Numeric	Generic Edit	15	2	Allow NULL?
183	IWKITAMTFOR	Accumulated Amount Invoiced (Foreign)	Numeric	Generic Edit	15	2	Allow NULL?
184	IWKITDIRTY	Kit Component Dirty Flag	Character	Generic Edit	1	0	Allow NULL?
185	IWKTLN	Kit Master Line Number	Numeric	Generic Edit	6	3	Allow NULL?
186	IWSTKT	Stocking Type	Character	UDC (41 I)	1	0	Allow NULL?
187	IWRKIT	Related Kit Component	Numeric	Generic Edit	8	0	Allow NULL?
188	IWSIDT	Scheduled Invoice Date	Date	Generic Edit	6	0
189	IWAST	Price Adjustment Name	String	UDC (40 TY)	8	0	Allow NULL?
190	IWTUPRC	Taxed Unit Price	Numeric	Generic Edit	15	4	Allow NULL?
191	IWTAEXP	Taxed Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
192	IWTAIEP	Taxed As If Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
193	IWUTA	Unit Tax Amount	Numeric	Generic Edit	15	4	Allow NULL?
194	IWETA	Extended Tax Amount	Numeric	Generic Edit	15	2	Allow NULL?
195	IWTKITAMTD	Kit Taxed Price Invoiced	Numeric	Generic Edit	15	2	Allow NULL?
196	IWTKITAMTF	Foreign Kit Taxed Price Invoiced	Numeric	Generic Edit	15	2	Allow NULL?
197	IWDTXJ	Internal SO Tax Date	Date	Generic Edit	6	0
198	IWUTP	Use Taxed Prices	Character	Generic Edit	1	0	Allow NULL?
199	IWOILNTY	Outbound Inventory Interface	Character	UDC (42I LT)	1	0	Allow NULL?
200	IWAEXPO	Estimated - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?

TOP 920 | 42 | F42565 INDEXES

Number

Description

Invoice Nbr Invoice Type +A (Primary/Unique)

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending
3	DOC	Document (Voucher Invoice etc.)	Ascending
4	DCT	Document Type	Ascending
5	KCO	Document Company	Ascending
6	DOCO	Document (Order No Invoice etc.)	Ascending
7	DCTO	Order Type	Ascending
8	KCOO	Order Company (Order Number)	Ascending
9	LNID	Line Number	Ascending
10	OSEQ	Sequence Number	Ascending
11	SUBSEQ	Sub-Sequence Number	Ascending

Address Nbr Currency Code +A

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending
3	AN8	Address Number	Ascending
4	CRCD	Currency Code - From	Ascending
5	CRDC	Currency Code - To	Ascending
6	CRR	Currency Conversion Rate - Spot Rate	Ascending
7	PTC	Payment Terms Code	Ascending

Item Nbr Unit Price +A

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending
3	LITM	2nd Item Number	Ascending
4	UPRC	Amount - Price per Unit	Ascending
5	UOM	Unit of Measure as Input	Ascending
6	LNTY	Line Type	Ascending
7	UOM4	Unit of Measure - Pricing	Ascending
8	DOC	Document (Voucher Invoice etc.)	Ascending
9	DCT	Document Type	Ascending
10	KCO	Document Company	Ascending

Order Nbr Order Type +A

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
4	DCTO	Order Type	Ascending
5	KCOO	Order Company (Order Number)	Ascending
6	LNID	Line Number	Ascending
7	UPRC	Amount - Price per Unit	Ascending
8	UOM	Unit of Measure as Input	Ascending
9	LNTY	Line Type	Ascending
10	UOM4	Unit of Measure - Pricing	Ascending

Computer ID Job Number

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending

Order Number Kit ID +A

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending
3	DOC	Document (Voucher Invoice etc.)	Ascending
4	DCT	Document Type	Ascending
5	KCO	Document Company	Ascending
6	DOCO	Document (Order No Invoice etc.)	Ascending
7	DCTO	Order Type	Ascending
8	KCOO	Order Company (Order Number)	Ascending
9	KITID	Kit Identifier	Ascending
10	LNID	Line Number	Ascending
11	OSEQ	Sequence Number	Ascending
12	SUBSEQ	Sub-Sequence Number	Ascending

Item Nbr Adj Name +A

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending
3	ITM	Item Number - Short	Ascending
4	UPRC	Amount - Price per Unit	Ascending
5	UOM	Unit of Measure as Input	Ascending
6	UOM4	Unit of Measure - Pricing	Ascending
7	DOC	Document (Voucher Invoice etc.)	Ascending
8	DCT	Document Type	Ascending
9	KCO	Document Company	Ascending
10	AST	Price Adjustment Name	Ascending

Adj Name Line Nbr +A

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
4	DCTO	Order Type	Ascending
5	KCOO	Order Company (Order Number)	Ascending
6	LNID	Line Number	Ascending
7	UPRC	Amount - Price per Unit	Ascending
8	UOM	Unit of Measure as Input	Ascending
9	UOM4	Unit of Measure - Pricing	Ascending
10	AST	Price Adjustment Name	Ascending

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

200 COLUMNS | 8 INDEXES | 920 | 42 | F42565 TABLE

TOP 920 | 42 | F42565 COLUMNS

TOP 920 | 42 | F42565 INDEXES

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

200 COLUMNS | 8 INDEXES | 920 | 42 | F42565 TABLE

TOP920 | 42 | F42565 COLUMNS

TOP920 | 42 | F42565 INDEXES

TOP 920 | 42 | F42565 COLUMNS

TOP 920 | 42 | F42565 INDEXES