	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	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

18 columns | 920 | PRFR | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP40: Inventory/OP Base
1	F40070	Preference Master File	1	PF	PRFR	Preference Type	String	UDC	2	0
2	F40071	Customer Preference Groups	2	CU	PRFR	Preference Type	String	UDC	2	0
3	F40072	Item Preference Groups	2	GI	PRFR	Preference Type	String	UDC	2	0
4	F40073	Preference Hierarchy File	1	HY	PRFR	Preference Type	String	UDC	2	0
5	F40300R	Preference Resolution History - Master	2	PM	PRFR	Preference Type	String	UDC	2	0
TOP45: Advanced Pricing
6	F4071	Price Adjustment Type	5	AT	PRFR	Preference Type	String	UDC	2	0
7	F4071P	Price Adjustment Type Purge	6	AT	PRFR	Preference Type	String	UDC	2	0
8	F4511W	Pricing Structure View	10	AP	PRFR	Preference Type	String	UDC	2	0
9	F4574	Key Reference Table	69	KR	PRFR	Preference Type	String	UDC	2	0
TOP75I: India
10	F75I357	Consignment Header	12	CH	PRFR	Preference Type	String	UDC	2	0
11	F75I3571	Consignment - Work Orders	13	CW	PRFR	Preference Type	String	UDC	2	0
12	F75I3572	Consignment - Stock Transfers	16	CS	PRFR	Preference Type	String	UDC	2	0
13	F75I3573	Consignment - Order Items	17	CO	PRFR	Preference Type	String	UDC	2	0
14	F75I3574	Consignment - Issues/Receipts Transactions	27	CT	PRFR	Preference Type	String	UDC	2	0
15	F75I3575	Consignment - Work Order Part List Items - Balances	10	CP	PRFR	Preference Type	String	UDC	2	0
16	F75I3576	Stock Transfer - Work Orders	15	SW	PRFR	Preference Type	String	UDC	2	0
17	F75I380	Excise - RG-1 - Transaction File - IND	34	RG	PRFR	Preference Type	String	UDC	2	0
18	F75I3901	Work With Consignment - IND -43	29	CO	PRFR	Preference 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 40 / PR (Preference Profiles) stock values

	Value	Description	Special Handling Code	Hard Coded
1		01 - 51 Reserved for Oracle		Y
2	01	Payment Terms	1	Y
3	02	Pricing Unit of Measure	1	Y
4	03	Revenue Business Unit	1	Y
5	04	End Use	1	Y
6	05	Print Messages	1	Y
7	06	Inventory Commitment	1	Y
8	07	Product Allocations	1	Y
9	08	Grade and Potency	1	Y
10	09	Delivery Date	1	Y
11	10	Line of Business	1	Y
12	11	User Defined Price Code 1	1	Y
13	12	User Defined Price Code 2	1	Y
14	13	User Defined Price Code 3	1	Y
15	14	Price Adjustment Schedule		Y
16	15	Invoice Cycle		Y
17	16	Order Preparation Days		Y
18	17	Container Preferences		N
19	18	Quality Management	1	Y
20	21	Receiving Locations		N
21	22	Shipping Locations		N
22	29	Document Distribution		Y
23	30	Document Set		Y
24	31	Options and Equipment		Y
25	32	Customer Freight		Y
26	33	Carrier		Y
27	34	Mode of Transport		Y
28	38	Payment Terms (Branch)		N
29	39	Product Allocation (Branch)		N
30	41	Next Order Status		Y
31	44	Sales Commission		N
32	45	Customer Currency		N
33	47	Pricing UOM (Branch)		N
34	49	Revenue Business Unit (Branch)		N
35	51	Base Price		Y
36	52	SoldTo ShipTo
37	54	SoldTo ShipTo Item
38	55	SoldTo Item
39	56	SoldTo
40	88	MD's Test
41	AA	All Addresses		N
42	AB	Advance Price Bikes		N
43	AC	Sold To Customer Address		N
44	AF	Customer Group All Items
45	AG	Sold To Cust. Grp/ All Address		N
46	BI	Brazilian Interest
47	BR	Brazilian Repasse
48	CG	Customer Group		N
49	CS	S&WM Hierarchy		N
50	EB	Enhanced Baskets		N
51	GR	Grower Pricing Hierarchy		N
52	IA	All Items		N
53	IG	Item Group		N
54	IN	All Customers/Item Number
55	MT	Sold to Cust Group/Item Group
56	PH	Pricing Hierarchy		N
57	SD	Ship and Debit		N
58	U1	Upsell Hierarchy		N