	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

113 columns | 920 | RCTO | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F00092	Supplemental Data	13	T3	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP12: Fixed Assets
2	F1217	Equipment Master Extension	17	WR	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
3	F1217P	Equipment Master Extension Purge Table	17	WR	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
4	F1217Z1	Unedited Equipment Tag Transactions	30	WR	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
5	F1217Z2	Unedited Equipment Tag Transactions	30	WR	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP17: Customer Service Management
6	F3111Z2	Warranty Claim/Supplier Recovery processing	29	WP	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
7	F3112Z2	Warranty Claim/Supplier Recovery processing	78	WL	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
8	F4801Z2	Warranty Claim/Supplier Recovery processing	23	WS	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP17C: Call Management
9	F1755	Case Master	77	ZA	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP31: Shop Floor Control
10	F3111	Work Order Parts List	16	WM	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
11	F3111S	Purge - Shop Floor Parts List	16	WM	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
12	F3111Z1	Outbound Work Order Parts List	29	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
13	F3112	Work Order Routing	66	WL	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
14	F3112S	Purge Shop Floor Control Routing Instructions	66	WL	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
15	F3112Z1	Outbound Work Order Routings	78	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
16	F3118	Shortage Maintenance Master File	12	WN	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
17	F31UI006	Line Scheduling Workbench - Work File	38	LS	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP31P: Engineer To Order
18	F31P10	Project Quote Header	22	PQ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
19	F31P11	Project Quote Detail	31	QP	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP34: Requirements Planning
20	F3412	MPS/MRP/DRP Lower Level Requirements File	12	MW	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP34X: In-Memory Planning Advisor
21	F34X200W	Planning Details Supply/Demand Work Table	47	SD	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP37: Quality Management
22	F3711	Test Results	5	TR	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
23	F3711Z1	Test Results Unedited Transaction Table	18	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
24	F37900	Certificate of Analysis (COA) Extract	5	TR	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP40: Inventory/OP Base
25	F4001Z	Batch Receiver File - Order Headings	35	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
26	F40051	Return Material Authorization	2	RD	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
27	F40052	Return Material Authorization Defaults	1	RV	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
28	F4011Z	Batch Receiver File - Order Details	27	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
29	F4201Z1	Sales Order Header Unedited Transaction File	25	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
30	F4211Z1	Sales Order Detail Unedited Transaction File	27	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP41: Inventory Management
31	F4118	Container Deposit File	10	CN	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
32	F41181	Container Transaction File	21	CM	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP41F: Apparel Management
33	FCW65	Work Order Header for Style Items	5	OF	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
34	FCW67	Style Work Order Parts List	22	WM	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
35	FCW68	Style Work Order Routings	70	WL	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP42: Sales Management
36	F4201	Sales Order Header File	12	SH	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
37	F42019	Sales Order Header History File	12	SH	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
38	F4211	Sales Order Detail File	14	SD	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
39	F42119	Sales Order History File	14	SD	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
40	F42199	S.O. Detail Ledger File	14	SL	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
41	F42565	Invoice Print File	39	IW	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
42	F42UI01	SO Header Cache File (MBF)	17	ZH	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
43	F42UI11	SO Detail Cache File (MBF)	18	ZD	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
44	F42UI520	Pick Slips Header File	36	S8	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
45	F42UI521	Pick Slips Detail File	14	S9	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP42I: Outbound Inventory Management
46	F42I09	Outbound Hold and Return Transactions	26	OI	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP43: Procurement
47	F4301	Purchase Order Header	11	PH	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
48	F4301Z	PO Header Work File	15	PA	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
49	F4301Z1	Purchase Order Header Unedited Transaction Table	24	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
50	F43080	Approvals Fields Constants	24	PD	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
51	F4311	Purchase Order Detail File	14	PD	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
52	F4311Z	Purchase Order Generator File	18	PW	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
53	F4311Z1	Purchase Order Detail Unedited Transaction Table	27	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
54	F43199	P.O. Detail Ledger File - Flexible Version	14	OL	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
55	F43UI50D	PO Print Detail Work File	46	PW	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
56	F43UI50H	PO Print Header Work File	41	PA	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP43E: Requisition Self Service
57	F43E121	eRequisition Receiver file	10	ER	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP43Q: Strategic Sourcing
58	F43Q50	Analyze Event Header	14	AV	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP45: Advanced Pricing
59	F4079	Rebate Transaction Detail	21	SV	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
60	F4576Z1	Ship and Debit Claims Unedited Transaction Table	131	Z1	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP47: Electronic Commerce
61	F47011	EDI Purchase Order Header - Inbound	30	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
62	F47012	EDI Purchase Order Detail - Inbound	28	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
63	F47016	EDI Purchase Order Header - Outbound	26	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
64	F47017	EDI Purchase Order Detail - Outbound	28	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
65	F47021	EDI P.O. Acknowledgment Header - Inbound	26	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
66	F47022	EDI P.O. Acknowledgment Detail - Inbound	28	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
67	F47026	EDI P.O. Acknowledgment Header - Outbound	27	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
68	F47027	EDI P.O. Acknowledgment Detail - Outbound	28	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
69	F47031	EDI Shipping Notice Header - Inbound	27	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
70	F47032	EDI Shipping Notice Detail - Inbound	31	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
71	F47037	EDI Shipping Notice Detail - Outbound	31	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
72	F470371	EDI Shipping Notice Detail - Outbound	31	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
73	F47046	EDI Invoice Header (Sales) - Outbound	27	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
74	F47047	EDI Invoice Detail (Sales) - Outbound	28	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
75	F47071	EDI Receiving Advice Header - Inbound	27	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
76	F47072	EDI Receiving Advice Detail - Inbound	29	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
77	F47076	EDI Receiving Advice Header - Outbound	27	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
78	F47077	EDI Receiving Advice Detail - Outbound	29	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
79	F47091	EDI Request for Quote Header - Inbound	30	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
80	F47092	EDI Request for Quote Detail - Inbound	28	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
81	F47096	EDI Request for Quote Header - Outbound	26	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
82	F47097	EDI Request for Quote Detail - Outbound	28	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
83	F47101	EDI Response to RFQ Header - Inbound	26	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
84	F47102	EDI Response to RFQ Detail - Inbound	28	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
85	F47106	EDI Response to RFQ Header - Outbound	27	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
86	F47107	EDI Response to RFQ Detail - Outbound	28	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
87	F47131	EDI Purchase Order Change Header - Inbound	27	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
88	F47132	EDI Purchase Order Change Detail - Inbound	29	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
89	F47136	EDI Purchase Order Change Header - Outbound	26	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
90	F47137	EDI Purchase Order Change Detail - Outbound	29	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
91	F47141	EDI P.O. Change Acknowledgment Header - Inbound	27	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
92	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	30	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
93	F47146	EDI P.O. Change Acknowledgment Header - Outbound	28	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
94	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	30	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
95	F47156	EDI Shipping Schedule Header - Outbound	27	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
96	F47157	EDI Shipping Schedule Detail - Outbound	28	SZ	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP48: Work Order Processing
97	F4801	Work Order Master File	4	WA	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
98	F4801S	Purge - Work Order Master file	4	WA	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
99	F4801Z1	Outbound Work Order Header	23	SY	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
100	F48092	WO Supplemental DB User Defined	11	W8	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
101	F48UI001	X4801 Master Business Function Workfile	7	WA	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP49: Transportation Management
102	F49T10	Sales Order Release Staging Table	33	OR	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP54R: Rental Management
103	F54R099	Rental Contract Header Ledger	10	HL	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
104	F54R10	Rental Contract Header	8	CH	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP75I: India
105	F75I3572	Consignment - Stock Transfers	13	CS	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
106	F75I3576	Stock Transfer - Work Orders	7	SW	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOP89: Conversion Programs
107	F43199A	Temp F43199 for ERP 9.0 Upgrade	14	OL	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
TOPF31: Lean Transactions
108	FF31111	Lean Transaction Parts List	19	PL	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
109	FF31111S	Purge - Lean Transaction Parts List	19	PR	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
110	FF31112	Routing Transaction Table	63	EH	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
111	FF31112S	Purge - Routing Transaction Table	63	ET	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
112	FF31113	Lean Transaction Labor Detail	36	LD	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0
113	FF31113S	Purge - Lean Transaction Labor Detail	36	LR	RCTO	Related PO/SO/WO Order Type	String	UDC	2	0

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 00 / DT (Document Type - All Documents) stock values

	Value	Description	Special Handling Code	Hard Coded
1	##	Prior Year Transactions		Y
2	$A	Eventual Withholdings		N
3	$B	Gross Income Withholdings		N
4	$G	Profit Withholdings		N
5	$I	V.A.T Withholdings		N
6	$L	Cleaning Services Withholding		N
7	$P	Security Withholdings		Y
8	$Q	General SUSS		Y
9	$S	Contract Withholdings		N
10	%	Percentage Journal Entry		Y
11	@O	Payment order		N
12	A	Inv. Cnv. - Adjustments		N
13	AC	Lease Accrual / Deferral		N
14	AD	Asset Disposal		Y
15	AE	Automatic Entries		Y
16	AF	Adjusting Entries		Y
17	AJ	Service Billing Adjustments		Y
18	AR	Asset Revaluation		Y
19	AS	Asset Split		Y
20	AT	Asset Transfer		Y
21	AU	Units - Committed		Y
22	BA	Billing Adjustments		Y
23	BB	Bulk - Simple Blend		N
24	BC	Base Agreement Contract		N
25	BD	Bulk- Decant		N
26	BE	Billing Entries		N
27	BF	Balance Forward/Summarize		Y
28	BG	Regrade/GSM		N
29	BI	Bulk/Packed Invoice		N
30	BJ	Bulk - Adjustment		N
31	BL	Bulk-Filling		N
32	BM	Bill of Lading		N
33	BO	Bulk-Consumed in Operations		N
34	BP	Bulk-Repacking		N
35	BR	Bulk-Rebrand or Regrade		N
36	BT	Bulk-Tank to Tank Transfer		N
37	BX	Budget Change Order		N
38	C%	TDS Withholding		N
39	C1	Contract Level		Y
40	C2	Invoice Level		Y
41	C3	Funding Level		Y
42	C4	Credit Order - Transportation		N
43	CC	USER		N
44	CD	Container Deposits		N
45	CF	Journal Entry From Conversion		N
46	CG	Lot Grade Change		Y
47	CL	Call		N
48	CM	Service Contracts - CSMS	N	N
49	CO	Credit Order		N
50	CP	Lot Potency Change		Y
51	CS	RFx		N
52	CT	Transportation Confirmation		N
53	CW	HomeBuilder Closing Worksheet		N
54	CX	Change Request		Y
55	CZ	Cash Basis		Y
56	DA	Debit Note		N
57	DD	Sale Order		N
58	DL	Delivery Ticket		N
59	DN	Credit Note		N
60	DP	Depreciation Journal		Y
61	DR	Job Cost Draw Splits		Y
62	E	Energy		N
63	EA	Lease Cost Adjusting Entries		N
64	EC	Revenue Checks		N
65	EG	Engineering Change Request	R	N
66	EN	Engineering Change Order		N
67	EP	Revenue J/E`s 8/8`s		N
68	EQ	Revenue J/E`s Subledger		N
69	ER	Revenue J/E`s Net Company		N
70	ES	Revenue Suspense Entries		N
71	ET	Engineer to Order	N	N
72	EU	Service Billing Revenue		Y
73	EV	Revenue Manual/Void Checks		N
74	EX	Currency Conversion Offsets		Y
75	FA	Invoice		N
76	FC	Forecast		N
77	FE	Revenue Fees		N
78	FJ	Revenue Fees - Jrnl Entry Only		N
79	FO	Firm Work Order W/Parts List		N
80	FP	Field Progress Reporting		N
81	FR	Firm Rate Order W/Parts List		Y
82	FS	FRW Created Doc. Types		N
83	FT	Freight		N
84	G2	Inbound Completions		N
85	GF	General Ledger Transferred		N
86	GG	Environmental Document		Y
87	GL	Bulk Product Gain/Loss		N
88	HP	Purchase Order		N
89	HS	Hours Service		N
90	HT	Purchase Transfer Order		N
91	I	Inv Cnv - Issues		N
92	I1	Interbranch Sales
93	I2	Sorties de Stock- Obsolescence		N
94	I3	Sorties de Stock - Vol		N
95	I4	Sorties de Stock - Dommages		N
96	IA	Inventory Adjustments		N
97	IB	Item Cost Changes		N
98	IC	Completed W.O.`s To Inventory		N
99	ID	Inventory Issue To Blend Mgmt		Y
100	IH	Labor Charged To W.O.`s		N
101	II	Inventory Issue		N
102	IJ	Inventory Adjustments
103	IL	Inventory Issue
104	IM	Material Charged To W.O.`s		N
105	IO	Component Scrap to W.O.`s		N
106	IP	Physical Inventory		Y
107	IQ	Inventory Quantity Only		Y
108	IR	Inventory Receipt		N
109	IS	Scrapped W.O.`s To Inventory		N
110	IT	Inventory Transfers		N
111	IV	Variance Calculated for W.O.`s		N
112	IX	Recalculate Average Cost		Y
113	IZ	Lot Hold/Release		Y
114	JA	Budget or Cost Allocation		Y
115	JB	Joint Interest Billing		N
116	JC	Job Cost % Complete		N
117	JD	JIB Detail Owner Entries		N
118	JE	Journal Entry		Y
119	JF	Journals Brought Forward		N
120	JK	A/P Redistribute Payments		Y
121	JM	AR VAT Redistribution		Y
122	JP	Subscription Sales		N
123	JQ	Sub. Sales Net Ledger		N
124	JR	Subscription Sales Commissions		N
125	JT	Accrued Property Taxes		N
126	JV	A/P Redistribute Prepayments		Y
127	JX	Foreign Currency Revaluation		Y
128	JZ	Cash Basis Journal Entry		Y
129	K1	Kanban Type 1		Y
130	K2	Kanban Type 2		Y
131	K3	Kanban Type 3		Y
132	K4	Kanban Type 4		Y
133	LB	Labels		N
134	LC	Completed Lean Trans to Inv	L3	N
135	LH	Work Order Labor Hours		N
136	LL	Labor charged to Lean Trans	L2	N
137	LM	Material charged to Lean Trans	L1	N
138	LO	Component Scrap to Lean Trans	L	N
139	LP	Scrapped Lean Trans to Inv	L4	N
140	LS	Property Management Lease		N
141	LV	Variance calculated for Lean T	L	N
142	MP	Another Purchase Order		N
143	MS	Material Issue Service		N
144	MU	Mileage (Meter) Update		N
145	N	Other Values	N	N
146	NA	Stand Alone Nota Fiscal		N
147	ND	Ship-To Nota Fiscal Return		N
148	NF	Purchasing Nota Fiscal		N
149	NI	Non Stock Nota Fiscal		N
150	NL	Preliminary Order		N
151	NN	Nota Fiscal Reverse/Void		N
152	NO	Netting Transactions		Y
153	NP	Partial NSF		Y
154	NR	Ship-From Nota Fiscal Return		N
155	NS	Nota Fiscal Sales		N
156	O	Ordering Document Types		N
157	O1	Order Document Type Fixed Asse		N
158	O4	Purchase Order -Transportation		N
159	OA	Do Not Use		Y
160	OB	Blanket Order		N
161	OC	Construction Work Order		N
162	OD	Direct Ship Order		N
163	OE	Do Not Use--Exchange Rate Var.		Y
164	OI	Interoperability Direct P.O.		N
165	OK	Purchase Intercompany Order		N
166	OM	Purchase Order RMA		N
167	OO	Outside Operations
168	OP	Purchase Order		N
169	OQ	Purchase Quote or Bid		N
170	OR	Purchase Requisition		N
171	OS	Subcontract		N
172	OT	Transfer Order		N
173	OU	Requisition Self Service		Y
174	OV	Do Not Use--Receiving Document		Y
175	OX	Change Order		N
176	OY	EDI Purchase Order Quote
177	OZ	EDI Purchase Order
178	P	Payables		N
179	P1	A/P Drafts		Y
180	P7	Alternate Currency Payment		Y
181	P9	Voucher		Y
182	PA	Credit Note Reimbursements		Y
183	PB	BACS Electronic Funds Transfer		Y
184	PC	Percent Complete FASTR Entry		N
185	PD	Debit Memo		Y
186	PE	Change to Voucher Amount		Y
187	PF	Recurring Billing		N
188	PG	Gain/Loss on Exchange Rate		Y
189	PI	Physical Inventory		Y
190	PJ	Sales Overage		N
191	PK	Automated Check		Y
192	PL	Voucher Logging		Y
193	PM	Manual Voucher		Y
194	PN	Manual Check		Y
195	PO	Void Check		Y
196	PP	Periodic Invoice		Y
197	PQ	Manual Billing		N
198	PR	Recurring Voucher		Y
199	PT	Electronic Funds Transfer		Y
200	PV	Voucher		Y
201	PW	Withholding		Y
202	PY	Payment Order - EDI Only		Y
203	PZ	A/P Cash Basis		Y
204	Q7	Suspended VAT - Recognized		N
205	Q8	Suspended and Recognized VAT		N
206	Q9	Suspended VAT		N
207	QA	Non-Comformance Report		N
208	QO	Quote Order		N
209	QR	Quote Request		N
210	R	Receivables		N
211	R%	TDS Withholding		N
212	R1	A/R Drafts		Y
213	R2	Contract Billing		Y
214	R3	Draft Invoice		Y
215	R4	Final Invoice		Y
216	R5	Deduction		Y
217	R6	RMA - Sales Order		Y
218	R7	Alternate Currency Receipt		Y
219	R8	Return Material Authorization		N
220	R9	RMA Credit Order		N
221	RA	Adjustment		Y
222	RB	Chargeback		Y
223	RC	Receipts - A/R		Y
224	RD	Recurring Billing		N
225	RE	Change to Invoice Amount		Y
226	RF	Finance Charge		Y
227	RG	Gain/Loss on Exchange Rate		Y
228	RH	Expense Participation		N
229	RI	Invoice		Y
230	RJ	Sales Overage		N
231	RK	Receipt - Summarized		Y
232	RL	Escalation		N
233	RM	Credit Memo		Y
234	RN	Manual Billing		Y
235	RO	Reversing or Void Entry		Y
236	RP	Direct Payments		Y
237	RQ	Chargeback Amount Created		Y
238	RR	Recurring Invoice		Y
239	RS	Spread Adjustments		Y
240	RT	A/R Fee & Interest		Y
241	RU	Unapplied Cash		Y
242	RV	Non-sufficient Funds		Y
243	RW	Receipt Journal Entry		Y
244	RX	Sales Contracts		N
245	RY	EDI Receipt		Y
246	RZ	A/R Cash Basis		Y
247	S	Sales Order Document Types		N
248	S1	Counter Sales		N
249	S2	Phone Sales		N
250	S3	Sales Order - ECS		N
251	S4	Sales Order - Transportation	10	N
252	SB	Blanket Sales Order		N
253	SC	Actual Rate Schedule		Y
254	SD	Direct Ship		N
255	SE	Extended Warr. Service	N	N
256	SH	Supplier Recovery		N
257	SI	Interbranch Sales		N
258	SK	Sales Intercompany Order		N
259	SN	Nonwarranty Service	N	N
260	SO	Sales Order	SO	N
261	SP	Price List		N
262	SQ	Sales Quote		N
263	SR	Sales Order - Rush		N
264	SS	Do Not Use--Summary Records		Y
265	ST	Transfer Sale		N
266	SV	Base Warranty Service	N	N
267	SW	Sales with Trans. & Warehouse		N
268	SY	EDI Sales Order Quote		N
269	SZ	EDI Sales Order		N
270	T	Time and Pay		N
271	T1	Payroll Disbursement Entries		N
272	T2	Payroll Labor Distribution		N
273	T3	Actual Burden Journal Entries		N
274	T4	Labor Billing Distribution		N
275	T5	Equipment Distribution		N
276	T6	Payroll Accruals / Deferrals		N
277	T7	Payroll Vouchers		N
278	TE	Time Sheet Entry		N
279	TJ	Payroll Journal		N
280	TM	Enterprise Treasury Management		Y
281	TO	Takeoff		N
282	U1	U1 through U9 client reserved		N
283	UA	UA through UZ client reserved		N
284	UP	Used Produt		N
285	V1	Versand Service		N
286	VC	Sales Order Reverse		N
287	VD	Delivery ocument for Service		N
288	VL	Nota Fiscal Batch Return		N
289	VN	Vendor Notice
290	VO	Sales Order		N
291	VR	Sales Order Return		N
292	VS	Purchase Order Return		N
293	VT	Sales Transfer Order		N
294	W1	Work Order Other		N
295	WA	Work order for A		N
296	WC	Warranty Claim		N
297	WD	Write Downs
298	WH	Equipment Work Order		N
299	WM	Maintenance Work Order		N
300	WO	Real (firm) Work Orders		N
301	WP	Planning Work Orders		N
302	WT	Wire Transfer		N
303	X1	User-defined Doc Type X1
304	X2	User-defined Doc Type X2
305	X3	User-defined Doc Type X3
306	X4	User-defined Doc Type X4
307	XR	Rental Contracts		Y
308	Y1	User-defined Doc Type Y1
309	Y2	User-defined Doc Type Y2
310	Y3	User-defined Doc Type Y3
311	Y4	User-defined Doc Type Y4
312	Y5	User-defined Doc Type Y5
313	Z	Inv Cnv - Month End Summary		N
314	ZC	Document ZC		N
315	ZD	Document ZD		N
316	ZZ	Unrecognized Version E Trans.		N

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

113 columns | 920 | RCTO | STOCK UDC

TOPUDC 00 / DT (Document Type - All Documents) stock values