	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

20 COLUMNS | 2 INDEXES | 812 | 13C | F1318 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
13C: Condition-Base Maintenance
1	812	F1318	AR	20	2	Condition-Based Maintenance Alert Action Rules	Files	13C: Condition-Base Maintenance

TOP 812 | 13C | F1318 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	ARAN8	Address Number	Numeric	UDC	8	Allow NULL?
2	ARLANO	Address Number - Lessor/Rentor/Mortgagor	Numeric	Generic Edit	8	Allow NULL?
3	ARMCU	Business Unit	String	Generic Edit	12	Allow NULL?
4	ARLOC	Business Unit - Location	String	Generic Edit	12	Allow NULL?
5	ARPRODF	Product Family	String	UDC (17 PA)	8	Allow NULL?
6	ARPRODM	Product Model	String	UDC (17 PM)	8	Allow NULL?
7	ARNUMB	Asset Item Number	Numeric	Generic Edit	8	Allow NULL?
8	ARITM	Item Number - Short	Numeric	Generic Edit	8	Allow NULL?
9	ARMELC	Measurement Location	String	UDC (13 LC)	10	Allow NULL?
10	ARPDFL	Alert Level	Character	UDC (13 AL)	1	Allow NULL?
11	ARSNDN	Send Notification Message	Character	Generic Edit	1	Allow NULL?
12	ARTYRP	Automated Response Type	Character	UDC (13 AR)	1	Allow NULL?
13	ARSRVT2	Service Type	String	UDC (12 ST)	8	Allow NULL?
14	ARSRVT3	Service Type	String	UDC (12 ST)	8	Allow NULL?
15	ARDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	Allow NULL?
16	ARUSER	User ID	String	Generic Edit	10	Allow NULL?
17	ARPID	Program ID	String	Generic Edit	10	Allow NULL?
18	ARMKEY	Machine Key	String	Generic Edit	15	Allow NULL?
19	ARUPMJ	Date - Updated	Date	Generic Edit	6
20	ARUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?

Number

Description

AN8 LANO MCU LOC+ (Primary/Unique)

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	LANO	Address Number - Lessor/Rentor/Mortgagor	Ascending
3	MCU	Business Unit	Ascending
4	NUMB	Asset Item Number	Ascending
5	LOC	Business Unit - Location	Ascending
6	PRODF	Product Family	Ascending
7	PRODM	Product Model	Ascending
8	ITM	Item Number - Short	Ascending
9	MELC	Measurement Location	Ascending
10	PDFL	Alert Level	Ascending

AN8 LANO MCU+

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	LANO	Address Number - Lessor/Rentor/Mortgagor	Ascending
3	MCU	Business Unit	Ascending
4	LOC	Business Unit - Location	Ascending
5	PRODF	Product Family	Ascending
6	PRODM	Product Model	Ascending
7	NUMB	Asset Item Number	Ascending
8	ITM	Item Number - Short	Ascending