	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 | 920 | CRRM | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0911	Account Ledger	125	GL	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP03: Accounts Receivable
2	F0311	Accounts Receivable Ledger	31	RP	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
3	F0312	A/R Batch Cash Application	47	RU	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP03B: Enhanced Accounts Receivable
4	F03B11	Customer Ledger	32	RP	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
5	F03B112	Invoice Revisions	35	RW	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
6	F03B112P	Invoice Revisions Purge File	35	RW	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
7	F03B117	Revenue Recognition GL Info	62	RL	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
8	F03B119	Revenue Recognition GL Info Audit	61	RN	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
9	F03B11P	Customer Ledger Purge File	32	RP	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
10	F03B11Z1	Batch Invoices	49	VJ	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
11	F03B11Z2	F03B11 Interoperability Table	45	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
12	F03B13	Receipts Header	25	RY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
13	F03B13P	Receipts Header Purge File	25	RY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
14	F03B13Z1	Electronic Receipts Input	37	RU	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
15	F03B13Z2	F03B13 Interoperability Table	38	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
16	F03B14	Receipts Detail	32	RZ	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
17	F03B14P	Receipts Detail Purge File	32	RZ	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
18	F03B14Z2	F03B14 Interoperability Table	45	SZ	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
19	F03B21	A/R Notification History Detail	17	ZS	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
20	F03B22	A/R Fee Journal History	16	RS	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
21	F03B23	A/R Fee Journal History Detail	14	RT	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
22	F03B40	A/R Deduction Management	29	RB	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
23	F03B465	A/R Netting Workfile	27	RO	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
24	F03B575	Auto Debit Invoice Select and Build	35	RD	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
25	F03B672	Draft Remittance	28	RD	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP04: Accounts Payable
26	F0411	Accounts Payable Ledger	33	RP	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
27	F0411A	WF - 'As Of' Accounts Payable Ledger	33	RP	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
28	F0411P	Purge - Accounts Payable Ledger	33	RP	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
29	F0411Z1	Voucher Transactions - Batch Upload	51	VL	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
30	F0411Z3	F0411 Interoperability Table	55	SZ	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
31	F0413	Accounts Payable - Matching Document	13	RM	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
32	F0413A	WF - 'As Of' Accounts Payable Payment Register	13	RM	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
33	F0413P	Purge - Accounts Payable Matching Documents	13	RM	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
34	F0413Z1	F0413 Interoperability Table	27	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
35	F0414	Accounts Payable Matching Document Detail	15	RN	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
36	F0414A	WF - 'As Of' Accounts Payable Payment Detail	15	RN	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
37	F0414P	Purge - Accounts Payable Matching Document Detail	15	RN	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
38	F0414Z1	F0414 Interoperability Table	28	SZ	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
39	F04572	A/P Payment Processing - Summary	61	KK	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
40	F04573	A/P Payment Processing - Detail	15	KI	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
41	F09UI005	Tax Offsets User Index	43	GL	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP05T: Time Entry
42	F063951	Payroll Journal (Compressed) File	39	GL	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP07: Payroll
43	F05290	WF - Payroll Journal (Detail)	41	JR	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP09: General Accounting
44	F0911P	Purge - Account Ledger	125	GL	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
45	F0911R	WF - Account Ledger Reconciliation	69	GL	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
46	F0911Z1	Journal Entry Transactions - Batch File	122	VN	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
47	F0911Z4	F0911 Interoperability Table	121	SZ	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP15: Real Estate Management
48	F15012	Tenant E.P. Class Master	62	NS	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
49	F15012B	Tenant E.P. Class Master	65	NS	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
50	F15013B	Sales Overage Master File	88	NO	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
51	F15014B	Product Scales Master	52	NP	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
52	F15015B	Min/Max Rents And Recoveries Master	53	NQ	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
53	F15016	Tenant Escalation Master	59	NU	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
54	F15016B	Tenant Escalation Master	58	NU	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
55	F15017	Lease Master Detail	57	NW	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
56	F1501B	Lease Master Header	61	NE	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
57	F1502	Recurring Billings Master	55	NF	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
58	F1502B	Recurring Billings Master	51	NF	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
59	F1502WAB	Rent Increase Amounts	22	NF	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
60	F1502WB	Estimated EP Recurring Billings	54	N4	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
61	F1505B	Management Fee Master	60	ND	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
62	F1505HB	Revenue Fee Generation History	20	OK	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
63	F1511	Tenant/Lease Billings Detail	56	NJ	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
64	F1511B	Lease Billings Master	52	NJ	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
65	F1511H	Tenant/Lease Billings Detail History	56	N#	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
66	F1511HB	Lease Billings History	52	NC	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
67	F1513B	FASB 13 Lease Control	68	O3	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
68	F151991	G/L Transaction A/R Application Work File	19	NB	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
69	F1525B	Fees and Interest	45	NM	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
70	F1531	Expense Participation Class Adjustment	14	OM	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
71	F1538	WF - Expence Participation Register	70	NZ	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
72	F1538B	EP Billing Register	68	NZ	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
73	F1540B	Sales Report Control	47	NR	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
74	F15410	Tenant Weekly Sales	40	N9	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
75	F1541B	Tenant Sales History	50	N8	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
76	F1541BW	Sales History Work File	62	OW	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
77	F1542	Projected Sales	43	OJ	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
78	F1543B	Tenant Sales Analysis Reporting File	79	OA	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
79	F1548B	Escalation Billing Register	72	N1	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
80	F15525W	PM Statements Credit/Cash Build Workfile	59	RT	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
81	F1565	Security Deposit Master	24	JF	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
82	F15703	Legal Clause Amounts	24	NI	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
83	F159071	Market/Potential/Renewal Rent Master	24	NY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP15L: Adv Real Estate Forecasting
84	F15L301	AREF Projected Sales	45	PS	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP17: Customer Service Management
85	F1720	Contract Header	35	CH	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
86	F1721	Contract Detail	112	CD	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
87	F1775	Claim Temporary Table	36	TC	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
88	F4801TZ2	Warranty Claim/Supplier Recovery processing	105	WQ	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP17C: Call Management
89	F1755	Case Master	174	ZA	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
90	F1760	Time Entry	25	ZB	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP31P: Engineer To Order
91	F31P10	Project Quote Header	12	PQ	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP32: Configuration Management
92	F3201	Configurator Master Table	13	CM	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
93	F32019	Configurator Master History Table	13	CH	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP40: Inventory/OP Base
94	F4001Z	Batch Receiver File - Order Headings	94	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
95	F4201Z1	Sales Order Header Unedited Transaction File	83	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
96	F4207	Price by Item	31	PM	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
97	F43800	Summary Voucher Match	21	PR	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP42: Sales Management
98	F4201	Sales Order Header File	70	SH	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
99	F42019	Sales Order Header History File	70	SH	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
100	F42800G	Sales Update G Batch Workfile	28	SG	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
101	F42800G1	Sales Update G Batch Detail Workfile	56	DG	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
102	F42UI01	SO Header Cache File (MBF)	75	ZH	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP43: Procurement
103	F4301	Purchase Order Header	67	PH	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
104	F4301Z	PO Header Work File	71	PA	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
105	F4301Z1	Purchase Order Header Unedited Transaction Table	80	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
106	F43092Z	Receipt Routing Work File	22	PV	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
107	F43UI50H	PO Print Header Work File	56	PA	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP44H: Homebuilder Management
108	F44H601	Bid Header	41	BH	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
109	F44H611	Bid Details	67	BD	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
110	F44H611W	Bid Details Work File	71	BW	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
111	F44H711	Lot Start Workfile	83	SW	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
112	F44H711Z	HB Lot Start Unedited Transaction File	96	SZ	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
113	F44H71W1	Lot Start Generation Workfile	83	GW	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
114	F44H73W1	Lot Start - P.O. / Committment Generation Work File	53	CG	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP47: Electronic Commerce
115	F47011	EDI Purchase Order Header - Inbound	81	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
116	F47016	EDI Purchase Order Header - Outbound	82	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
117	F47021	EDI P.O. Acknowledgment Header - Inbound	82	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
118	F47026	EDI P.O. Acknowledgment Header - Outbound	77	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
119	F47031	EDI Shipping Notice Header - Inbound	77	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
120	F47041	EDI Invoice Header - Inbound	31	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
121	F47042	EDI Invoice Detail - Inbound	68	SZ	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
122	F47044	EDI Invoice Summary - Inbound	34	SW	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
123	F47046	EDI Invoice Header (Sales) - Outbound	77	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
124	F47056	EDI Payment Order Header - Outbound	28	D1	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
125	F47056W	EDI Payment Order Header - Work	28	D1	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
126	F47057	EDI Payment Order Remittance Advice - Outbound	28	D3	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
127	F47057W	EDI Payment Order Remittance Advice - Work	28	D3	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
128	F47071	EDI Receiving Advice Header - Inbound	83	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
129	F47076	EDI Receiving Advice Header - Outbound	83	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
130	F47091	EDI Request for Quote Header - Inbound	81	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
131	F47096	EDI Request for Quote Header - Outbound	82	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
132	F47101	EDI Response to RFQ Header - Inbound	82	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
133	F47106	EDI Response to RFQ Header - Outbound	77	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
134	F47113	EDI Lockbox/Payment Detail - Batch	25	Z3	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
135	F47131	EDI Purchase Order Change Header - Inbound	78	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
136	F47136	EDI Purchase Order Change Header - Outbound	82	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
137	F47141	EDI P.O. Change Acknowledgment Header - Inbound	83	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
138	F47146	EDI P.O. Change Acknowledgment Header - Outbound	78	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
139	F47156	EDI Shipping Schedule Header - Outbound	85	SY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP48: Work Order Processing
140	F4801ST	Purge - Work Order Master Tag File	92	WA	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
141	F4801T	Work Order Master Tag File	92	WA	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
142	F4817	Service Order Extension	54	SR	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP48S: Service Billing
143	F48091	Billing System Constants	21	WZ	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
144	F4812	Billing Detail Workfile	111	WD	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
145	F48128	G/L Offset and Retainage Information	8	WI	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
146	F4812H	Billing Workfile History	111	WD	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
147	F4812HS	Billing Workfile History Purged Save	111	WD	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
148	F4822	Invoice Summary Work File	87	W4	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
149	F4823	Voucher Summary	59	W0	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
150	F48S910	Billing Detail Journal Workfile	42	W2	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
151	F48SUI01	Billing Detail Print Workfile	111	WD	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP52: Contract Billing
152	F5201	Contract Master	47	G4	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
153	F5202	Contract Billing Line Detail	78	G6	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
154	F5216	Milestone/Progress Billing Information	16	A6	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
155	F5280W	Contract Revenue Summary Work File	38	GY	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP52G: Proj & Gov Contract Accounting
156	F4822H	Invoice Summary History	87	IH	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
157	F52G01M	Advanced Contracts Modifications	52	CM	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
158	F52G05	ACRN Detail Table	17	AD	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
159	F52G05H	ACRN History Table	25	AH	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP53: Change Management
160	F5301B	Change Request Master Table	41	DI	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
161	F5301BZ1	Change Request Master Table Workfile	45	DI	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
162	F5311	Change Request Details Table	140	DK	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
163	F5311Z1	Change Request Details Table Workfile	145	DK	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
164	F5314	Planned Change Order Master Table	39	D2	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
165	F5315	Change Order Master Table	38	D3	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP54R: Rental Management
166	F54R099	Rental Contract Header Ledger	73	HL	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
167	F54R10	Rental Contract Header	71	CH	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
168	F54R11	Rental Contract Detail	118	CD	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
169	F54R199	Rental Contract Detail Ledger	114	DL	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP70: Multi-National Products
170	F704001	Payment WH Info TEMP - COMM - 04	50	PT	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
171	F704002	Payment WH Info - COMM - 04	49	PF	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
172	F704002P	Payment WH Info Purge - COMM - 04	49	PF	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP74: EMEA Localization
173	F7430030	Legal Document Header (Print Info) - COMM - 03B	10	PI	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
174	F74411	Withholding Tax Detail - Italy	24	RS	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
175	F74900	Foreign Receivables and Payables - EMEA	39	RP	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP74R: Russia
176	F74R0018	Russian Tax File - 74R	44	TD	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
177	F74R311	Prepayment Detail Tax File - RUS - 03B	21	DE	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP74S: Spain
178	F74S55	Expenses and Exchange Rate for Payments - Spain - 04	15	Q5	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP74U: United Kingdom Localizations
179	F74U0420	SPC - Application Master - UK - 43	50	SE	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
180	F74U0425	SPC - Certificate Master - UK - 43	52	SF	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
181	F74U25BT	Interest Tag Table - 15	10	PK	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP76A: Argentina
182	F76A21	Credit Invoice Header - F76A21 - ARG - 3B - 76A	11	IH	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
183	F76A21P	Credit Invoice Header Purge - ARG - 03B - 76A	11	IH	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
184	F76A24	Credit Invoice Information - Accounts Payable - ARG - - 76A	7	IE	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
185	F76AUI82	Draft - Drafts Work File - ARG - 03B - 03B	37	WF	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
186	F76AUI83	Draft - Application Drafts - Invoices Work File - ARG - 76A	23	WF	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP76C: Colombia
187	F76C031A	A/R Customer ledger As Of - F76C031A - COL - 04	75	RP	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
188	F76C034A	A/R Check Detail file As Of - COL - 03B	33	RZ	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
189	F76CUI02	Tax Detail - Work File - COL - 76C	52	TD	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
190	F76CUI04	Tax Detail for Distribution - Work File - COL - 76C	53	TD	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP76H: Chile
191	F76H3B31	Legal Document Header (Print Info) - CHI - 03B - 76H	33	PI	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
192	F76H3B50	Lot of Printing - Header - CHI - 03B - 76H	9	LP	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
TOP89: Conversion Programs
193	F05290T	Needed for upgrade from Xe to B9	5	JR	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
194	F06116T	Needed for upgrade from Xe to B9	10	YT	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
195	F06116TZ	Needed for upgrade from Xe to B9	11	VL	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
196	F0618T	Needed for upgrade from Xe to B9	10	YT	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0
197	F063951T	Needed for upgrade from Xe to B9	5	GL	CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC	1	0

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

TOPUDC H00 / CY (CRRM Curr Mode-Foreign/Dom) stock values

	Value	Description	Special Handling Code	Hard Coded
1		leave blank	N	N
2	3	Foreign and Domestic	N	N
3	D	Domestic	N	N
4	F	Foreign	N	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

197 columns | 920 | CRRM | STOCK UDC

TOPUDC H00 / CY (CRRM Curr Mode-Foreign/Dom) stock values