	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	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
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	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
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

197 COLUMNS | 3 INDEXES | 812 | 43 | F43121Z TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
43: Procurement
1	812	F43121Z	PW	197	3	Receiver workfile	Regular Work Files	43A: Purchase Order Receipt/Routing	No

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 PWDOC, PWDOCO, PWDCTO, PWKCOO, PWSFXO, PWLNID, PWNLIN, PWJOBS, PWCTID, PWSELC, PWKCO, PWJELN, PWJEL1, PWJEL2, PWJEL3, PWJEL4, PWJEL5, PWJEL6, PWJEL7, PWJEL8, PWJEL9, PWMCU, PWLOCN, PWLOTN, PWLOTG, PWLOTP, PWLOTS, PWIVI, PWSTKT, PWLEDG, PWCLEV, PWGLC, PWRCDJ, PWDGL, PWRCD, PWSRNR, PWVEND, PWAN8, PWVRMK, PWVANI, PWPRP5, PWASID, PWCNID, PWSBL, PWSBLT, PWULOT, PWAVGC, PWSOQS, PWUOM2, PWUOM3, PWSOCN, PWUOM1, PWCNV1, PWOPST, PWRTG, PWUPIB, PWRCPT, PWPMTE, PWCONV, PWCRR, PWUOM, PWUREC, PWPRRC, PWAREC, PWAOPN, PWECST, PWCRYR, PWFRRC, PWFEC, PWFREC, PWITM, PWRPL, PWNROU, PWCRCD, PWCO, PWPTC, PWDRQJ, PWPDDJ, PWOPDJ, PWLNTY, PWAITM, PWLITM, PWCNV2, PWLIN, PWNXTR, PWWRTH, PWNXT2, PWSOPO, PWDSC1, PWLAND, PWALIN, PWCRDC, PWDSCV, PWDMBV, PWDZBA, PWCZBA, PWRCNV, PWDTAC, PWCTAC, PWTRR1, PWTRR2, PWCRCM, PWDMCT, PWDMCS, PWMODE, PWPSR, PWPSRY, PWSEQ, PWTREX, PWTEMP, PWSTPU, PWDNTY, PWDNTP, PWDETP, PWDTPU, PWAMBR, PWBUM3, PWVCF, PWSTOK, PWBUM4, PWWGTR, PWBUM5, PWSTUM, PWBUM6, PWBPFG, PWABR1, PWABT1, PWABR2, PWABT2, PWABR3, PWABT3, PWABR4, PWABT4, PWPSQ, PWSHPN, PWPEID, PWTCID, PWVR05, PWVR04, PWVR02, PWVR01, PWUPUM, PWUPQT, PWUPCN, PWUKID, PWSTAM, PWSQOR, PWSCUM, PWSCCQ, PWSCCN, PWPLT, PWPAK, PWMERL, PWMACT, PWKTLN, PWFUF6, PWFUF5, PWFUF4, PWFUF3, PWDUAL, PWCTAM, PWXDCK, PWCPNT, PWBCRC, PWUOMV, PWLOTC, PWJEL0, PWJELNNMBR, PWPOE, PWJELA, PWJELB, PWJELC, PWJELD, PWRTGO, PWPTRF, PWPMT2, PWCTSN, PWPROV, PWASN, PWPRFLG1, PWPRFLG2, PWMOADJ, PWPS09, PWQTYPY, PWWVID, PWCNTRTID, PWCNTRTDID, PWREVFLG, PWAPPFLG, PWREVAN8, PWAPPAN8, PWWOPID, PWWVTY, PWAREV, PWSRRC, PWFSRRC, PWEV01 FROM F43121Z

TOP 812 | 43 | F43121Z COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	PWDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	PWDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
3	PWDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
4	PWKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
5	PWSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
6	PWLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
7	PWNLIN	Number of Lines	Numeric	Generic Edit	5	0	Allow NULL?
8	PWJOBS	Job Number	Numeric	Generic Edit	8	0	Allow NULL?
9	PWCTID	Computer ID	String	Generic Edit	15	0	Allow NULL?
10	PWSELC	Selection Exits	Character	Generic Edit	1	0	Allow NULL?
11	PWKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
12	PWJELN	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
13	PWJEL1	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
14	PWJEL2	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
15	PWJEL3	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
16	PWJEL4	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
17	PWJEL5	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
18	PWJEL6	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
19	PWJEL7	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
20	PWJEL8	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
21	PWJEL9	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
22	PWMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
23	PWLOCN	Location	String	Generic Edit	20	0	Allow NULL?
24	PWLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
25	PWLOTG	Lot Grade	String	UDC (40 LG)	3	0	Allow NULL?
26	PWLOTP	Lot Potency	Numeric	Generic Edit	15	3	Allow NULL?
27	PWLOTS	Lot Status Code	Character	UDC (41 L)	1	0	Allow NULL?
28	PWIVI	Inventory Interface Y/N - Distribution	Character	UDC (H40 IV)	1	0	Allow NULL?
29	PWSTKT	Stocking Type	Character	UDC (41 I)	1	0	Allow NULL?
30	PWLEDG	Cost Method	String	UDC (40 CM)	2	0	Allow NULL?
31	PWCLEV	Level - Inventory Cost	Character	UDC (H40 CL)	1	0	Allow NULL?
32	PWGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
33	PWRCDJ	Date - Received	Date	Generic Edit	6	0
34	PWDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
35	PWRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
36	PWSRNR	Serial Number Required	Character	UDC (H41 NR)	1	0	Allow NULL?
37	PWVEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0	Allow NULL?
38	PWAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
39	PWVRMK	Supplier Remark	String	Generic Edit	30	0	Allow NULL?
40	PWVANI	Account Number - Received Not Vouchered	String	Generic Edit	29	0	Allow NULL?
41	PWPRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
42	PWASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
43	PWCNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
44	PWSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
45	PWSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
46	PWULOT	Allow Duplicate Lots	Character	UDC (40 DU)	1	0	Allow NULL?
47	PWAVGC	Update Average Cost On-Line	Character	Generic Edit	1	0	Allow NULL?
48	PWSOQS	Quantity Shipped	Numeric	Generic Edit	15	2	Allow NULL?
49	PWUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
50	PWUOM3	Unit of Measure - Purchasing	String	UDC (00 UM)	2	0	Allow NULL?
51	PWSOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	2	Allow NULL?
52	PWUOM1	Unit of Measure - Primary	String	UDC (00 UM)	2	0	Allow NULL?
53	PWCNV1	Conversion Factor - Secondary to Primary	Numeric	Generic Edit	15	7	Allow NULL?
54	PWOPST	Operation Status Code W.O.	String	UDC (31 OS)	2	0	Allow NULL?
55	PWRTG	Route Sheet (N)	Character	Generic Edit	1	0	Allow NULL?
56	PWUPIB	Update Item Location Quantity	String	Generic Edit	4	0	Allow NULL?
57	PWRCPT	Receipt Acknowledgement (Y/N)	Character	Generic Edit	1	0	Allow NULL?
58	PWPMTE	Payment Eligible (Y/N)	Character	Generic Edit	1	0	Allow NULL?
59	PWCONV	Conversion Factor	Numeric	Generic Edit	15	7	Allow NULL?
60	PWCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
61	PWUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
62	PWUREC	Units - Received	Numeric	Generic Edit	15	2	Allow NULL?
63	PWPRRC	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
64	PWAREC	Amount - Received	Numeric	Generic Edit	15	2	Allow NULL?
65	PWAOPN	Amount - Open	Numeric	Generic Edit	15	2	Allow NULL?
66	PWECST	Amount - Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
67	PWCRYR	Currency Conversion Y/N/Z	Character	UDC (H00 CR)	1	0	Allow NULL?
68	PWFRRC	Amount - Foreign Unit Price	Numeric	Generic Edit	15	4	Allow NULL?
69	PWFEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
70	PWFREC	Amount - Received Foreign	Numeric	Generic Edit	15	2	Allow NULL?
71	PWITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
72	PWRPL	Replacement (Y/N)	Character	UDC (43 RP)	1	0	Allow NULL?
73	PWNROU	Route - Normal Route Code	String	UDC (43 RC)	4	0	Allow NULL?
74	PWCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
75	PWCO	Company	String	Generic Edit	5	0	Allow NULL?
76	PWPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
77	PWDRQJ	Date - Requested	Date	Generic Edit	6	0
78	PWPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
79	PWOPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
80	PWLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
81	PWAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
82	PWLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
83	PWCNV2	Conversion Factor - Purchasing to Primar	Numeric	Generic Edit	15	7	Allow NULL?
84	PWLIN	Line Number - General	Numeric	Generic Edit	7	2	Allow NULL?
85	PWNXTR	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
86	PWWRTH	Flag - Write Ledger Record (Y/N)	Character	Generic Edit	1	0	Allow NULL?
87	PWNXT2	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
88	PWSOPO	Flag - Sales/Purchasing	Character	Generic Edit	1	0	Allow NULL?
89	PWDSC1	Description	String	Generic Edit	30	0	Allow NULL?
90	PWLAND	Code - Landed Cost	Character	Generic Edit	1	0	Allow NULL?
91	PWALIN	Line - Associated	Numeric	Generic Edit	5	0	Allow NULL?
92	PWCRDC	Currency Code - To	String	Generic Edit	3	0	Allow NULL?
93	PWDSCV	Flag - Debit Standard Cost Variance	Character	Generic Edit	1	0	Allow NULL?
94	PWDMBV	Flag - Debit Material Burden Variance	Character	Generic Edit	1	0	Allow NULL?
95	PWDZBA	Flag - Debit Zero Balance Adjustment	Character	Generic Edit	1	0	Allow NULL?
96	PWCZBA	Flag - Credit Zero Balance Adjustment	Character	Generic Edit	1	0	Allow NULL?
97	PWRCNV	Flag - Received Not Vouchered	Character	Generic Edit	1	0	Allow NULL?
98	PWDTAC	Flag - Debit Tax Accrual	Character	Generic Edit	1	0	Allow NULL?
99	PWCTAC	Flag - Credit Tax Accrual	Character	Generic Edit	1	0	Allow NULL?
100	PWTRR1	Triangulation Rate - From Currency	Numeric	Generic Edit	15	0	Allow NULL?
101	PWTRR2	Triangulation Rate - To Currency	Numeric	Generic Edit	15	0	Allow NULL?
102	PWCRCM	Currency Conversion Y/Z	Character	Generic Edit	1	0	Allow NULL?
103	PWDMCT	Agreement Number - Distribution	String	Generic Edit	12	0	Allow NULL?
104	PWDMCS	Agreement Supplement - Distribution	Numeric	Generic Edit	3	0	Allow NULL?
105	PWMODE	Mode - Processing	Character	Generic Edit	1	0	Allow NULL?
106	PWPSR	Source	String	Generic Edit	12	0	Allow NULL?
107	PWPSRY	Source Type	String	UDC (38 DY)	2	0	Allow NULL?
108	PWSEQ	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
109	PWTREX	Explanation - Transaction	String	Generic Edit	30	0	Allow NULL?
110	PWTEMP	Temperature	Numeric	Generic Edit	7	2	Allow NULL?
111	PWSTPU	Temperature Type	Character	UDC (41B TP)	1	0	Allow NULL?
112	PWDNTY	Density	Numeric	Generic Edit	7	2	Allow NULL?
113	PWDNTP	Density Type - At Standard Temperature	Character	UDC (41B DT)	1	0	Allow NULL?
114	PWDETP	Density Temperature	Numeric	Generic Edit	7	2	Allow NULL?
115	PWDTPU	Temperature Type	Character	UDC (41B TP)	1	0	Allow NULL?
116	PWAMBR	Volume - Ambient	Numeric	Generic Edit	15	2	Allow NULL?
117	PWBUM3	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
118	PWVCF	Volume Correction Factor	Numeric	Generic Edit	7	4	Allow NULL?
119	PWSTOK	Volume - Standard	Numeric	Generic Edit	15	2	Allow NULL?
120	PWBUM4	Unit of Measure 4	String	UDC (00 UM)	2	0	Allow NULL?
121	PWWGTR	Weight Result	Numeric	Generic Edit	15	2	Allow NULL?
122	PWBUM5	Unit of Measure 5	String	UDC (00 UM)	2	0	Allow NULL?
123	PWSTUM	Quantity - Primary Stock Accounting Unit	Numeric	Generic Edit	15	2	Allow NULL?
124	PWBUM6	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
125	PWBPFG	Bulk/Packed Flag	Character	UDC (41B BF)	1	0	Allow NULL?
126	PWABR1	Managerial Analysis Code 1	String	Generic Edit	12	0	Allow NULL?
127	PWABT1	Managerial Analysis Type 1	Character	UDC	1	0	Allow NULL?
128	PWABR2	Managerial Analysis Code 2	String	Generic Edit	12	0	Allow NULL?
129	PWABT2	Managerial Analysis Type 2	Character	UDC	1	0	Allow NULL?
130	PWABR3	Managerial Analysis Code 3	String	Generic Edit	12	0	Allow NULL?
131	PWABT3	Managerial Analysis Type 3	Character	UDC	1	0	Allow NULL?
132	PWABR4	Managerial Analysis Code 4	String	Generic Edit	12	0	Allow NULL?
133	PWABT4	Managerial Analysis Type 4	Character	UDC	1	0	Allow NULL?
134	PWPSQ	Primary Sequence Number	Numeric	Generic Edit	6	2	Allow NULL?
135	PWSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
136	PWPEID	Process ID	Numeric	Generic Edit	15	0	Allow NULL?
137	PWTCID	Transaction ID	Numeric	Generic Edit	15	0	Allow NULL?
138	PWVR05	Outside Reference 2	String	Generic Edit	25	0	Allow NULL?
139	PWVR04	Outside Reference 1	String	Generic Edit	25	0	Allow NULL?
140	PWVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
141	PWVR01	Reference	String	Generic Edit	25	0	Allow NULL?
142	PWUPUM	UPC Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
143	PWUPQT	UPC Quantity	Numeric	Generic Edit	15	2	Allow NULL?
144	PWUPCN	UPC Number	String	Generic Edit	13	0	Allow NULL?
145	PWUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
146	PWSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
147	PWSQOR	Units - Secondary Quantity Ordered	Numeric	Generic Edit	15	2	Allow NULL?
148	PWSCUM	SCC Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
149	PWSCCQ	SCC Quantity	Numeric	Generic Edit	15	2	Allow NULL?
150	PWSCCN	SCC Number	String	Generic Edit	14	0	Allow NULL?
151	PWPLT	SSCC Number - Tare Level	String	Generic Edit	18	0	Allow NULL?
152	PWPAK	SSCC Number - Pack Level	String	Generic Edit	18	0	Allow NULL?
153	PWMERL	Item Revision Level	String	Generic Edit	3	0	Allow NULL?
154	PWMACT	Multiple Accounts	Character	UDC (40 MU)	1	0	Allow NULL?
155	PWKTLN	Kit Master Line Number	Numeric	Generic Edit	6	3	Allow NULL?
156	PWFUF6	Future Use	String	Generic Edit	1	0	Allow NULL?
157	PWFUF5	Future Use	String	Generic Edit	1	0	Allow NULL?
158	PWFUF4	Future Use	String	Generic Edit	1	0	Allow NULL?
159	PWFUF3	Future Use	String	Generic Edit	1	0	Allow NULL?
160	PWDUAL	Dual Unit Of Measure Item	Character	Generic Edit	1	0	Allow NULL?
161	PWCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
162	PWXDCK	Cross-Docking Flag	Character	Generic Edit	1	0	Allow NULL?
163	PWCPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
164	PWBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
165	PWUOMV	Unit of Measure as Variable	String	UDC (00 UM)	2	0	Allow NULL?
166	PWLOTC	Lot Status Code Expanded	String	Generic Edit	3	0	Allow NULL?
167	PWJEL0	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
168	PWJELNNMBR	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
169	PWPOE	Port of Entry or Exit	String	UDC (40 PE)	6	0	Allow NULL?
170	PWJELA	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
171	PWJELB	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
172	PWJELC	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
173	PWJELD	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
174	PWRTGO	Flag - Routing Operations	Character	Generic Edit	1	0	Allow NULL?
175	PWPTRF	Flag - Prior To Recept Compl Liab	Character	Generic Edit	1	0	Allow NULL?
176	PWPMT2	F43092 To Step Payment Eligible	Character	Generic Edit	1	0	Allow NULL?
177	PWCTSN	Container Serial Number	String	Generic Edit	40	0	Allow NULL?
178	PWPROV	Price Override Code	Character	Generic Edit	1	0	Allow NULL?
179	PWASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
180	PWPRFLG1	Pricing Control 01	Character	UDC (45 PC)	1	0	Allow NULL?
181	PWPRFLG2	Pricing Control 02	Character	UDC (45 PF)	1	0	Allow NULL?
182	PWMOADJ	Manual Override Adjustment Flag	Character	Check Box	1	0	Allow NULL?
183	PWPS09	Purchase Order Status 09	Character	Generic Edit	1	0	Allow NULL?
184	PWQTYPY	Quantity To Pay	Numeric	Generic Edit	15	0	Allow NULL?
185	PWWVID	Vessel ID	Numeric	Generic Edit	8	0	Allow NULL?
186	PWCNTRTID	Contract ID	Numeric	Generic Edit	8	0	Allow NULL?
187	PWCNTRTDID	Contract Detail ID	Numeric	Generic Edit	15	0	Allow NULL?
188	PWREVFLG	Reviewed Flag	Character	Generic Edit	1	0	Allow NULL?
189	PWAPPFLG	Approved Flag	Character	Generic Edit	1	0	Allow NULL?
190	PWREVAN8	Reviewed By Address Number	Numeric	Generic Edit	8	0	Allow NULL?
191	PWAPPAN8	Approved By Address Number	Numeric	Generic Edit	8	0	Allow NULL?
192	PWWOPID	Operation ID	Integer	Generic Edit	11	0	Allow NULL?
193	PWWVTY	Vessel Class	Character	Generic Edit	1	0	Allow NULL?
194	PWAREV	Adjustment Revision Level	Numeric	Generic Edit	3	0	Allow NULL?
195	PWSRRC	Amount - Secondary Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
196	PWFSRRC	Amount - Foreign Secondary Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
197	PWEV01	J.D. EnterpriseOne Event Point 01	Character	Generic Edit	1	0	Allow NULL?

TOP 812 | 43 | F43121Z INDEXES

Number

Description

Computer ID Job Number +A

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending
3	LNID	Line Number	Ascending
4	NLIN	Number of Lines	Ascending

ComputerID Job Number +B (Primary/Unique)

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	SFXO	Order Suffix	Ascending
7	LNID	Line Number	Ascending
8	NLIN	Number of Lines	Ascending

DOCO DCTO KCOO SFXO LNID

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	SFXO	Order Suffix	Ascending
5	LNID	Line Number	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

197 COLUMNS | 3 INDEXES | 812 | 43 | F43121Z TABLE

TOP 812 | 43 | F43121Z COLUMNS

TOP 812 | 43 | F43121Z 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

197 COLUMNS | 3 INDEXES | 812 | 43 | F43121Z TABLE

TOP812 | 43 | F43121Z COLUMNS

TOP812 | 43 | F43121Z INDEXES

TOP 812 | 43 | F43121Z COLUMNS

TOP 812 | 43 | F43121Z INDEXES