	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

23 COLUMNS | 3 INDEXES | 910 | 48S | F48S411 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
48S: Service Billing
1	910	F48S411	BZ	23	3	CSB Pay When Paid Table	Files	48S: Service Billing

TOP 910 | 48S | F48S411 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	BZBCI	Billing Control ID	Numeric	Generic Edit	8	Allow NULL?
2	BZDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6
3	BZSBSQ	Sequence Number	Numeric	Generic Edit	3	Allow NULL?
4	BZPRSQ	Parent Sequence Number	Numeric	Generic Edit	3	Allow NULL?
5	BZSCSQ	Secondary Sequence Number	Numeric	Generic Edit	3	Allow NULL?
6	BZSLNK	Split Link	Numeric	Generic Edit	11	Allow NULL?
7	BZCLNK	Component Link	Numeric	Generic Edit	11	Allow NULL?
8	BZCCOD	Component Code	String	UDC (48 CM)	5	Allow NULL?
9	BZDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	Allow NULL?
10	BZDCT	Document Type	String	UDC (00 DT)	2	Allow NULL?
11	BZKCO	Document Company	String	Generic Edit	5	Allow NULL?
12	BZDOCZ	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	Allow NULL?
13	BZDCTI	Document Type - Invoice Only	String	UDC (00 DI)	2	Allow NULL?
14	BZKCOI	Document Company (Invoice)	String	Generic Edit	5	Allow NULL?
15	BZSFX	Document Pay Item	String	Generic Edit	3	Allow NULL?
16	BZICU	Batch Number	Numeric	Generic Edit	8	Allow NULL?
17	BZBCTY	Batch Type	Character	UDC (48 BT)	1	Allow NULL?
18	BZPWPG	Pay When Paid Group Number	Numeric	Generic Edit	15	Allow NULL?
19	BZUSER	User ID	String	Generic Edit	10	Allow NULL?
20	BZPID	Program ID	String	Generic Edit	10	Allow NULL?
21	BZUPMJ	Date - Updated	Date	Generic Edit	6
22	BZJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
23	BZUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?

Number

Description

Billing ID GL Date + (Primary/Unique)

Element	Alias	Description	Sequence
1	BCI	Billing Control ID	Ascending
2	DGL	Date - For G/L (and Voucher)	Ascending
3	SBSQ	Sequence Number	Ascending
4	PRSQ	Parent Sequence Number	Ascending
5	SCSQ	Secondary Sequence Number	Ascending
6	SLNK	Split Link	Ascending
7	CLNK	Component Link	Ascending
8	CCOD	Component Code	Ascending

Batch Number Batch Type

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	BCTY	Batch Type	Ascending

Invoice Number Doc Type +

Element	Alias	Description	Sequence
1	DOCZ	Document (Order # Invoice etc.)	Ascending
2	DCTI	Document Type - Invoice Only	Ascending
3	KCOI	Document Company (Invoice)	Ascending
4	SFX	Document Pay Item	Ascending