	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 | 7 INDEXES | 812 | 07 | F069066 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
07: Payroll
1	812	F069066	JD	24	7	Pay Cycle Constant	Constants Files	07: Payroll	AS400 Coexistence Tables

TOP 812 | 07 | F069066 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	JDPCCD	Pay Cycle Code	String	UDC (06 PY)	5	0	Allow NULL?
2	JDDTEY	Date - YR	Numeric	Generic Edit	2	0	Allow NULL?
3	JDPPNB	Pay Period Number	String	Generic Edit	3	0	Allow NULL?
4	JDPPED	Date - Pay Period Ending	Date	Generic Edit	6	0
5	JDPPMO	Pay Period Month	String	UDC (06 MN)	2	0	Allow NULL?
6	JDCKDT	Date - Pay Check	Date	Generic Edit	6	0
7	JDWHRW	Standard Hours-Weekly	Numeric	Generic Edit	9	2	Allow NULL?
8	JDBHRW	Standard Hours-Biweekly	Numeric	Generic Edit	9	2	Allow NULL?
9	JDSHRW	Standard Hours-Semi	Numeric	Generic Edit	9	2	Allow NULL?
10	JDMHRW	Standard Hours-Monthly	Numeric	Generic Edit	9	2	Allow NULL?
11	JDAHRW	Standard Hours-Annually	Numeric	Generic Edit	9	2	Allow NULL?
12	JDOHRW	Standard Hours-Other	Numeric	Generic Edit	9	2	Allow NULL?
13	JDPPM1	Pay Period Number - Weekly	Character	UDC (05 PN)	1	0	Allow NULL?
14	JDPPM2	Pay Period Number - Biweekly	Character	UDC (05 PN)	1	0	Allow NULL?
15	JDPPM3	Pay Period Number - Semimonthly	Character	UDC (05 PN)	1	0	Allow NULL?
16	JDPPM4	Pay Period Number - Monthly	Character	UDC (05 PN)	1	0	Allow NULL?
17	JDPPM5	Pay Period Number - Annually	Character	UDC (05 PN)	1	0	Allow NULL?
18	JDPPM6	Pay Period Number - Other	Character	UDC (05 PN)	1	0	Allow NULL?
19	JDUSER	User ID	String	Generic Edit	10	0	Allow NULL?
20	JDPID	Program ID	String	Generic Edit	10	0	Allow NULL?
21	JDUPMJ	Date - Updated	Date	Generic Edit	6	0
22	JDCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
23	JDPPMB	Pay Period Number	Character	UDC (05 YB)	1	0	Allow NULL?
24	JDADDT	Date - Auto Deposit	Date	Generic Edit	6	0

Number

Description

Pay Cycle Code Century + A (Primary/Unique)

Element	Alias	Description	Sequence
1	PCCD	Pay Cycle Code	Ascending
2	CTRY	Century	Ascending
3	DTEY	Date - YR	Ascending
4	PPNB	Pay Period Number	Ascending
5	PPED	Date - Pay Period Ending	Ascending

Pay Cycle Code Century + B

Element	Alias	Description	Sequence
1	PCCD	Pay Cycle Code	Ascending
2	CTRY	Century	Ascending
3	DTEY	Date - YR	Ascending
4	PPED	Date - Pay Period Ending	Ascending

Pay Cycle Code Pay Prd End Dt

Element	Alias	Description	Sequence
1	PCCD	Pay Cycle Code	Ascending
2	PPED	Date - Pay Period Ending	Ascending

Pay Cycle Code Century + C

Element	Alias	Description	Sequence
1	PCCD	Pay Cycle Code	Ascending
2	CTRY	Century	Ascending
3	DTEY	Date - YR	Ascending
4	CKDT	Date - Pay Check	Ascending

Pay Cycle Code Check Date

Element	Alias	Description	Sequence
1	CKDT	Date - Pay Check	Ascending
2	PCCD	Pay Cycle Code	Ascending

Pay Cycle Code Century +D

Element	Alias	Description	Sequence
1	PCCD	Pay Cycle Code	Ascending
2	CTRY	Century	Ascending
3	DTEY	Date - YR	Ascending
4	PPMO	Pay Period Month	Ascending

Pay Cycle Code Pay Pd End Dcd

Element	Alias	Description	Sequence
1	PCCD	Pay Cycle Code	Descending
2	PPED	Date - Pay Period Ending	Descending