	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 | 5 INDEXES | 920 | 48S | F48127 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
48S: Service Billing
1	920	F48127	WO	20	5	Tax Derivation Information	Extra Features Files	48S: Service Billing	Business Data

TOP 920 | 48S | F48127 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	WOGTYP	Generation Type	Character	UDC (48 GT)	1	Allow NULL?
2	WOTYKY	Key Type	Character	UDC (48 TY)	1	Allow NULL?
3	WOTKEY	Table Key	String	Generic Edit	12	Allow NULL?
4	WOEFTB	Date - Beginning Effective	Date	Generic Edit	6
5	WOEFTE	Date - Ending Effective	Date	Generic Edit	6
6	WOOBJ	Object Account	String	Generic Edit	6	Allow NULL?
7	WOOBJT	Object Account Thru	String	Generic Edit	6	Allow NULL?
8	WOSUB	Subsidiary	String	Generic Edit	8	Allow NULL?
9	WOSUBT	Thru Subsidiary	String	Generic Edit	8	Allow NULL?
10	WOTXA1	Tax Rate/Area	String	Generic Edit	10	Allow NULL?
11	WOEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	Allow NULL?
12	WOTOG	Taxable or Gross	Character	UDC (48 TO)	1	Allow NULL?
13	WOUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	Allow NULL?
14	WOUPMJ	Date - Updated	Date	Generic Edit	6
15	WOUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
16	WOPID	Program ID	String	Generic Edit	10	Allow NULL?
17	WOJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
18	WOUSER	User ID	String	Generic Edit	10	Allow NULL?
19	WOVVTY	Vertex Transaction Type	String	UDC (73 TY)	6	Allow NULL?
20	WOVVTC	Vertex Product Category	String	UDC (73 PC)	10	Allow NULL?

Number

Description

Unique Key ID (Primary/Unique)

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	Ascending

Key Type Table Key LA +

Element	Alias	Description	Sequence
1	TYKY	Key Type	Ascending
2	TKEY	Table Key	Ascending
3	EFTB	Date - Beginning Effective	Ascending
4	OBJT	Object Account Thru	Ascending
5	SUBT	Thru Subsidiary	Ascending

Key Type Table Key LB +

Element	Alias	Description	Sequence
1	TYKY	Key Type	Ascending
2	TKEY	Table Key	Ascending
3	EFTB	Date - Beginning Effective	Ascending
4	SUBT	Thru Subsidiary	Ascending
5	OBJT	Object Account Thru	Ascending

Key Type Table Key LC +

Element	Alias	Description	Sequence
1	TYKY	Key Type	Ascending
2	TKEY	Table Key	Ascending
3	EFTB	Date - Beginning Effective	Ascending
4	OBJ	Object Account	Ascending
5	OBJT	Object Account Thru	Ascending
6	SUB	Subsidiary	Ascending
7	SUBT	Thru Subsidiary	Ascending

Key Type Table Key +

Element	Alias	Description	Sequence
1	TYKY	Key Type	Ascending
2	TKEY	Table Key	Ascending
3	EFTB	Date - Beginning Effective	Ascending
4	EFTE	Date - Ending Effective	Ascending