	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

22 COLUMNS | 2 INDEXES | 812 | 81A | F81A01 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
81A: DREAMWriter Conversion Tool
1	812	F81A01	M1	22	2	DW Master Parameters Conversion Table	Files	81A: DREAMWriter Conversion Tool

TOP 812 | 81A | F81A01 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	M1PID	Program ID	String	Generic Edit	10	Allow NULL?
2	M1OPT#	Processing Option Number	Numeric	Generic Edit	3	Allow NULL?
3	M1SQN	Option Prompt Line	Numeric	Generic Edit	3	Allow NULL?
4	M1JD	Version Title	String	Generic Edit	50	Allow NULL?
5	M1FPID	EnterpriseOne Program ID	String	Generic Edit	10	Allow NULL?
6	M1OBNM	Object Name	String	Generic Edit	10	Allow NULL?
7	M1LITN	Item Number - EnterpriseOne	Numeric	Generic Edit	5	Allow NULL?
8	M1BSQN	Sequence Fields	Numeric	Generic Edit	5	Allow NULL?
9	M1BCNT	Processing Option Count	Numeric	Generic Edit	5	Allow NULL?
10	M1LTBN	Tab Name	String	Generic Edit	30	Allow NULL?
11	M1TXT1	Processing Option Text	String	Generic Edit	50	Allow NULL?
12	M1LPOD	Processing Option Default	String	Generic Edit	50	Allow NULL?
13	M1LDSN	Data Structure Template Name	String	Generic Edit	10	Allow NULL?
14	M1DS01	Description	String	Generic Edit	80	Allow NULL?
15	M1OWTP	Data Type - EnterpriseOne	String	UDC (H98 DT)	2	Allow NULL?
16	M1DTAI	Data Item	String	Generic Edit	10	Allow NULL?
17	M1LUS	User Migration	String	Generic Edit	10	Allow NULL?
18	M1FPD	Program ID - Migration Process	String	Generic Edit	10	Allow NULL?
19	M1UPMJ	Date - Updated	Date	Generic Edit	6
20	M1JOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
21	M1UPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
22	M1GSTS	Migration Aid Status Flag	Numeric	Generic Edit	5	Allow NULL?

Number

Description

Main Index (Primary/Unique)

Element	Alias	Description	Sequence
1	PID	Program ID	Ascending
2	OPT#	Processing Option Number	Ascending
3	FPID	EnterpriseOne Program ID	Ascending
4	LITN	Item Number - EnterpriseOne	Ascending
5	BSQN	Sequence Fields	Ascending

$Pid Pag seq

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