	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

21 COLUMNS | 3 INDEXES | 812 | 81 | F81A122 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
81: DREAM Writer
1	812	F81A122	M4	21	3	Dream Writer Processing Option Interim File F59012 - F81A122	Files	81: DREAM Writer

TOP 812 | 81 | F81A122 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	M4LDFR	Library Name - Data - From	String	Generic Edit	10	Allow NULL?
2	M4PID	Program ID	String	Generic Edit	10	Allow NULL?
3	M4VERS	Version History	String	Generic Edit	10	Allow NULL?
4	M4OPT#	Processing Option Number	Numeric	Generic Edit	3	Allow NULL?
5	M4SVL	Selection value	String	Generic Edit	25	Allow NULL?
6	M4FPID	EnterpriseOne Program ID	String	Generic Edit	10	Allow NULL?
7	M4BVER	EnterpriseOne Version	String	Generic Edit	10	Allow NULL?
8	M4OBNM	Object Name	String	Generic Edit	10	Allow NULL?
9	M4LITN	Item Number - EnterpriseOne	Numeric	Generic Edit	5	Allow NULL?
10	M4BSQN	Sequence Fields	Numeric	Generic Edit	5	Allow NULL?
11	M4BCNT	Processing Option Count	Numeric	Generic Edit	5	Allow NULL?
12	M4LNGP	Language	String	UDC (01 LP)	2	Allow NULL?
13	M4OWTP	Data Type - EnterpriseOne	String	UDC (H98 DT)	2	Allow NULL?
14	M4DTAI	Data Item	String	Generic Edit	10	Allow NULL?
15	M4VL01	Selection Values 01	String	Generic Edit	25	Allow NULL?
16	M4BNUM	Migration Aid Number	Numeric	Generic Edit	15	Allow NULL?
17	M4LUS	User Migration	String	Generic Edit	10	Allow NULL?
18	M4FPD	Program ID - Migration Process	String	Generic Edit	10	Allow NULL?
19	M4UPMJ	Date - Updated	Date	Generic Edit	6
20	M4JOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
21	M4UPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?

Number

Description

Library Program Version PO# (Primary/Unique)

Element	Alias	Description	Sequence
1	LDFR	Library Name - Data - From	Ascending
2	PID	Program ID	Ascending
3	VERS	Version History	Ascending
4	OPT#	Processing Option Number	Ascending
5	FPID	EnterpriseOne Program ID	Ascending
6	BVER	EnterpriseOne Version	Ascending
7	BCNT	Processing Option Count	Ascending

Key20WProgram Version PO#

Element	Alias	Description	Sequence
1	FPID	EnterpriseOne Program ID	Ascending
2	BVER	EnterpriseOne Version	Ascending
3	BCNT	Processing Option Count	Ascending

Key30WProgram Version Item Seq

Element	Alias	Description	Sequence
1	FPID	EnterpriseOne Program ID	Ascending
2	BVER	EnterpriseOne Version	Ascending
3	LITN	Item Number - EnterpriseOne	Ascending
4	BSQN	Sequence Fields	Ascending