	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

17 columns | 920 | UPC1 | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP40: Inventory/OP Base
1	F4011Z	Batch Receiver File - Order Details	201	SZ	UPC1	Price Code 1	String	UDC	2	0
2	F40311	Preference Profile - Price Code 1	12	P1	UPC1	Price Code 1	String	UDC	2	0
3	F40311R	Preference Resolution Ledger - User Defined Price Code #1	14	P1	UPC1	Price Code 1	String	UDC	2	0
4	F4211Z1	Sales Order Detail Unedited Transaction File	180	SZ	UPC1	Price Code 1	String	UDC	2	0
TOP42: Sales Management
5	F4211	Sales Order Detail File	167	SD	UPC1	Price Code 1	String	UDC	2	0
6	F42119	Sales Order History File	167	SD	UPC1	Price Code 1	String	UDC	2	0
7	F42199	S.O. Detail Ledger File	167	SL	UPC1	Price Code 1	String	UDC	2	0
8	F42UI11	SO Detail Cache File (MBF)	105	ZD	UPC1	Price Code 1	String	UDC	2	0
9	F470371T	Tag for F470371- EDI shipping Notice Detail - Outbound	83	UZ	UPC1	Price Code 1	String	UDC	2	0
TOP42B: Sales Order Entry
10	F42420	Audit Log Transaction	56	AL	UPC1	Price Code 1	String	UDC	2	0
TOP47: Electronic Commerce
11	F47012	EDI Purchase Order Detail - Inbound	202	SZ	UPC1	Price Code 1	String	UDC	2	0
12	F47027	EDI P.O. Acknowledgment Detail - Outbound	202	SZ	UPC1	Price Code 1	String	UDC	2	0
13	F47047	EDI Invoice Detail (Sales) - Outbound	202	SZ	UPC1	Price Code 1	String	UDC	2	0
14	F47092	EDI Request for Quote Detail - Inbound	202	SZ	UPC1	Price Code 1	String	UDC	2	0
15	F47107	EDI Response to RFQ Detail - Outbound	201	SZ	UPC1	Price Code 1	String	UDC	2	0
16	F47132	EDI Purchase Order Change Detail - Inbound	203	SZ	UPC1	Price Code 1	String	UDC	2	0
17	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	204	SZ	UPC1	Price Code 1	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 / P1 (Price Code 1) stock values

	Value	Description	Hard Coded
1		Blank	Y
2	01	Negotiated Discount Level 1	N
3	02	Negotiated Discount Level 2	N
4	03	Negotiated Discount Level 3	N
5	04	Negotiated Discount Level 4	N
6	05	Negotiated Discount Level 5	N
7	06	Negotiated Discount Level 6	N
8	07	Negotiated Discount Level 7	N
9	08	Negotiated Discount Level 8	N
10	09	Negotiated Discount Level 9	N
11	10	Negotiated Discount Level 10	N