	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

24 COLUMNS | 4 INDEXES | 812 | 05 | F0626 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
05: Time Accounting and HRM Base
1	812	F0626	JG	24	4	Wage Attachment Control File	Transaction Files	05: Time Accounting and HRM Base	AS400 Coexistence Tables

TOP 812 | 05 | F0626 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	JGAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
2	JGPDBA	DBA Code	Numeric	Generic Edit	5	0	Allow NULL?
3	JGWANO	Wage Attach Control Number	Numeric	Generic Edit	8	0	Allow NULL?
4	JGANN8	Address Number-Provider/Trustee	Numeric	Generic Edit	8	0	Allow NULL?
5	JGOAN8	Address Number - Obligee	Numeric	Generic Edit	8	0	Allow NULL?
6	JGWAFN	File Number	String	Generic Edit	30	0	Allow NULL?
7	JGWACN	Case Number	String	Generic Edit	30	0	Allow NULL?
8	JGWACD	Date - Case Date	Date	Generic Edit	6	0
9	JGSSN	Employee Tax ID	String	Generic Edit	20	0	Allow NULL?
10	JGDL01	Description	String	Generic Edit	30	0	Allow NULL?
11	JGAD	Amount - Due	Numeric	Generic Edit	15	2	Allow NULL?
12	JGTARA	Tax Area (Work)	String	Generic Edit	10	0	Allow NULL?
13	JGHMCO	Company - Home	String	Generic Edit	5	0	Allow NULL?
14	JGPTCP	Payment Terms Code - Payroll	String	Generic Edit	2	0	Allow NULL?
15	JGWADC	Date - Completion Date	Date	Generic Edit	6	0
16	JGWATY	Code - Wage Attachment Type	Character	UDC (07 WE)	1	0	Allow NULL?
17	JGBAD	Amount - Due(Wage Attachment)	Numeric	Generic Edit	15	2	Allow NULL?
18	JGWADR	Date - Date Receipt Wage Attachment	Date	Generic Edit	6	0
19	JGARRA	Amount - Arrearage	Numeric	Generic Edit	9	2	Allow NULL?
20	JGWAPN	Wage Attach Priority Number	Numeric	Generic Edit	5	0	Allow NULL?
21	JGWAMA	Amount - Wage Attach Minimum Arrearage	Numeric	Generic Edit	9	2	Allow NULL?
22	JGWADM	Wage Attachment Method	Character	UDC	1	0	Allow NULL?
23	JGWAWA	Amount - Wage Attach Periods in Arrears	Numeric	Generic Edit	9	0	Allow NULL?
24	JGWAAA	Amount - Wage Attach Arrearage	Numeric	Generic Edit	9	2	Allow NULL?

Number

Description

Wage Control Number (Primary/Unique)

Element	Alias	Description	Sequence
1	WANO	Wage Attach Control Number	Ascending

Address Num Add Num Payee A+

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	ANN8	Address Number-Provider/Trustee	Ascending
3	OAN8	Address Number - Obligee	Ascending
4	WANO	Wage Attach Control Number	Ascending

Add Num Payee Owner Add A+

Element	Alias	Description	Sequence
1	ANN8	Address Number-Provider/Trustee	Ascending
2	OAN8	Address Number - Obligee	Ascending
3	AN8	Address Number	Ascending
4	WANO	Wage Attach Control Number	Ascending

Owner Add Num Address Num A+

Element	Alias	Description	Sequence
1	OAN8	Address Number - Obligee	Ascending
2	AN8	Address Number	Ascending
3	ANN8	Address Number-Provider/Trustee	Ascending
4	WANO	Wage Attach Control Number	Ascending