	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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
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	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

20 COLUMNS | 4 INDEXES | 920 | 51F | F51F100 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
51F: Advanced Job Forecasting
1	920	F51F100	QF	20	4	Job Forecast Header	Files	51F: Advanced Job Forecasting

TOP 920 | 51F | F51F100 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	QF51FFID	Forecast ID	Numeric	Generic Edit	15	Allow NULL?
2	QFMCU	Business Unit	String	Generic Edit	12	Allow NULL?
3	QF51FNAME	Forecast Name	String	Generic Edit	30	Allow NULL?
4	QF51FSTATS	Forecast Status	String	UDC (51F ST)	2	Allow NULL?
5	QF51FFBD	Forecast Basis Date	Date	Generic Edit	6
6	QF51FFBT	Forecast Basis Time	Numeric	Generic Edit	6	Allow NULL?
7	QFDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6
8	QF51FPF	Projected Final Posted Flag	Character	Generic Edit	1	Allow NULL?
9	QFTORG	Transaction Originator	String	Generic Edit	10	Allow NULL?
10	QFENTJ	Date - Entered	Date	Generic Edit	6
11	QFTENT	Time Entered	Numeric	Generic Edit	6	Allow NULL?
12	QFUSER	User ID	String	Generic Edit	10	Allow NULL?
13	QFUPMJ	Date - Updated	Date	Generic Edit	6
14	QFUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
15	QFJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
16	QFPID	Program ID	String	Generic Edit	10	Allow NULL?
17	QFMKEY	Machine Key	String	Generic Edit	15	Allow NULL?
18	QFPN	Period Number - General Ledger	Numeric	Generic Edit	2	Allow NULL?
19	QFFY	Fiscal Year	Numeric	Generic Edit	2	Allow NULL?
20	QFCTRY	Century	Numeric	Generic Edit	2	Allow NULL?

Number

Description

Forecast Id (Primary/Unique)

Element	Alias	Description	Sequence
1	51FFID	Forecast ID	Ascending

Job Status GL Date Desc

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	51FSTATS	Forecast Status	Ascending
3	DGJ	Date - For G/L (and Voucher) - Julian	Descending

GL Date Desc Job Status Desc

Element	Alias	Description	Sequence
1	DGJ	Date - For G/L (and Voucher) - Julian	Descending
2	MCU	Business Unit	Ascending
3	51FSTATS	Forecast Status	Descending

Job PN FY Desc CTRY Desc

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	PN	Period Number - General Ledger	Ascending
3	FY	Fiscal Year	Descending
4	CTRY	Century	Descending