	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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

93 COLUMNS | 2 INDEXES | 812 | 07 | F0729 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
07: Payroll
1	812	F0729	Y9	93	2	Employee DBA Override Instructions	Files	07: Payroll	Business Data

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT Y9AN8, Y9CKCN, Y9DLVL, Y9PDBA, Y9WANO, Y9TSKID, Y9PRTR, Y9EXA, Y9DISO, Y9DEDM, Y9ODDM, Y9DTAB, Y9DESQ, Y9SALY, Y9CMHU, Y9PRTX, Y9PB, Y9PAYM, Y9SVH, Y9DBAL, Y9RTAM, Y9ORTM, Y9PCUN, Y9PAYG, Y9PAYN, Y9PCK, Y9MV, Y9CALC, Y9EPRI, Y9NP, Y9PTCT, Y9PSDT, Y9PTDT, Y9EFTB, Y9EFTE, Y9PPRY, Y9PPDL, Y9MDL, Y9QDL, Y9ADL, Y9SADL, Y9AMTS, Y9PPPL, Y9DGRP, Y9HMIN, Y9HMAX, Y9ANN8, Y9DPRI, Y9PDED, Y9ARRR, Y9ARRA, Y9DEP1, Y9DEP2, Y9DEP3, Y9DEP4, Y9DEP5, Y9DEP6, Y9GVCH, Y9ZOVR, Y9DBAS, Y9HMCO, Y9DC, Y9TARA, Y9TDBA, Y9CMAX, Y9SACC, Y9UDBA, Y9NPER, Y9UN, Y9MCU, Y9JBCD, Y9JBST, Y9TT01, Y9TT02, Y9TT03, Y9TT04, Y9TT05, Y9TT06, Y9TT07, Y9TT08, Y9TT09, Y9TT10, Y9TT11, Y9TT12, Y9TT13, Y9TT14, Y9TT15, Y9UPMJ, Y9UPMT, Y9PID, Y9JOBN, Y9USER, Y9DEFR FROM F0729

TOP 812 | 07 | F0729 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	Y9AN8	Address Number	Numeric	UDC	8	0	Allow NULL?
2	Y9CKCN	Check Control Number	Numeric	Generic Edit	8	0	Allow NULL?
3	Y9DLVL	DBA Calculation Level	Character	Generic Edit	1	0	Allow NULL?
4	Y9PDBA	DBA Code	Numeric	Generic Edit	5	0	Allow NULL?
5	Y9WANO	Wage Attach Control Number	Numeric	Generic Edit	8	0	Allow NULL?
6	Y9TSKID	Task Unique Key ID	Numeric	Generic Edit	15	0	Allow NULL?
7	Y9PRTR	Transaction No. - Payroll	Numeric	Generic Edit	9	0	Allow NULL?
8	Y9EXA	Name - Alpha Explanation	String	Generic Edit	30	0	Allow NULL?
9	Y9DISO	DBA Type	Character	UDC (05 DI)	1	0	Allow NULL?
10	Y9DEDM	Method of Calculation	Character	UDC (06 DM)	1	0	Allow NULL?
11	Y9ODDM	Override Method of Calculation	Character	UDC (06 DM)	1	0	Allow NULL?
12	Y9DTAB	Table Code	String	Generic Edit	5	0	Allow NULL?
13	Y9DESQ	Source of Calculation	Character	UDC (06 DB)	1	0	Allow NULL?
14	Y9SALY	Pay Class (H/S/P)	Character	UDC (05A PK)	1	0	Allow NULL?
15	Y9CMHU	Calendar Month Method	Character	UDC (52 YN)	1	0	Allow NULL?
16	Y9PRTX	Pre-Tax Deduction	String	UDC (06 4K)	3	0	Allow NULL?
17	Y9PB	Source of Pay	Character	UDC (06 PB)	1	0	Allow NULL?
18	Y9PAYM	Multiplier - Pay Type Multiplier	Numeric	Generic Edit	5	2	Allow NULL?
19	Y9SVH	Benefit/Accrual Type	Character	UDC (06 SV)	1	0	Allow NULL?
20	Y9DBAL	Declining Balance (Y N)	Character	Generic Edit	1	0	Allow NULL?
21	Y9RTAM	Amount or Rate	Numeric	Generic Edit	9	4	Allow NULL?
22	Y9ORTM	Override Amount or Rate	Numeric	Generic Edit	9	4	Allow NULL?
23	Y9PCUN	Units - Pieces	Numeric	Generic Edit	9	2	Allow NULL?
24	Y9PAYG	Effect on Gross Pay	Character	UDC (07 PA)	1	0	Allow NULL?
25	Y9PAYN	Effect on Net Pay	Character	UDC (07 PA)	1	0	Allow NULL?
26	Y9PCK	Method of Printing	Character	UDC (05A PT)	1	0	Allow NULL?
27	Y9MV	Effect on Disposable Wage	Character	UDC (05A MV)	1	0	Allow NULL?
28	Y9CALC	Calculate If No Gross (Y N)	Character	UDC (05 YN)	1	0	Allow NULL?
29	Y9EPRI	When To Adjust Ded	Character	UDC (05A EP)	1	0	Allow NULL?
30	Y9NP	Number of Deduction Periods	Numeric	Generic Edit	4	0	Allow NULL?
31	Y9PTCT	Pay Type Category	Character	UDC (06 PC)	1	0	Allow NULL?
32	Y9PSDT	Date - Pay Starts	Date	Generic Edit	6	0
33	Y9PTDT	Date - Pay Stops	Date	Generic Edit	6	0
34	Y9EFTB	Date - Beginning Effective	Date	Generic Edit	6	0
35	Y9EFTE	Date - Ending Effective	Date	Generic Edit	6	0
36	Y9PPRY	Calc in Pre-Payroll (Y N)	Character	UDC (05 YN)	1	0	Allow NULL?
37	Y9PPDL	Pay Period Limit	Numeric	Generic Edit	15	2	Allow NULL?
38	Y9MDL	Monthly Limit	Numeric	Generic Edit	15	2	Allow NULL?
39	Y9QDL	Quarterly Limit	Numeric	Generic Edit	15	2	Allow NULL?
40	Y9ADL	Annual Limit	Numeric	Generic Edit	15	2	Allow NULL?
41	Y9SADL	Annual Limit (Level 2)	Numeric	Generic Edit	15	2	Allow NULL?
42	Y9AMTS	Amount or Rate - Secondary	Numeric	Generic Edit	15	4	Allow NULL?
43	Y9PPPL	Limit on Pay Period Percent	Numeric	Generic Edit	15	4	Allow NULL?
44	Y9DGRP	Group Limit Code	String	UDC (06 GR)	2	0	Allow NULL?
45	Y9HMIN	Hours - Minimum	Numeric	Generic Edit	15	2	Allow NULL?
46	Y9HMAX	Hours - Maximum	Numeric	Generic Edit	15	2	Allow NULL?
47	Y9ANN8	Address Number-Provider/Trustee	Numeric	Generic Edit	8	0	Allow NULL?
48	Y9DPRI	Order To Adjust Ded	Numeric	Generic Edit	5	0	Allow NULL?
49	Y9PDED	DBA For Prior Limit	Numeric	Generic Edit	5	0	Allow NULL?
50	Y9ARRR	Arrearage Method	Character	UDC (05A AR)	1	0	Allow NULL?
51	Y9ARRA	Amount - Arrearage	Numeric	Generic Edit	9	2	Allow NULL?
52	Y9DEP1	Deduction Period 1	Character	UDC (05A DD)	1	0	Allow NULL?
53	Y9DEP2	Deduction Period 2	Character	UDC (05A DD)	1	0	Allow NULL?
54	Y9DEP3	Deduction Period 3	Character	UDC (05A DD)	1	0	Allow NULL?
55	Y9DEP4	Deduction Period 4	Character	UDC (05A DD)	1	0	Allow NULL?
56	Y9DEP5	Deduction Period 5	Character	UDC (05A DD)	1	0	Allow NULL?
57	Y9DEP6	Deduction Period 6	Character	UDC (05A DD)	1	0	Allow NULL?
58	Y9GVCH	A/P Voucher (Y N)	Character	UDC (05 YB)	1	0	Allow NULL?
59	Y9ZOVR	Override Flag	Character	UDC (05 YB)	1	0	Allow NULL?
60	Y9DBAS	Calc Once Per Period	Character	UDC (05 YN)	1	0	Allow NULL?
61	Y9HMCO	Company - Home	String	Generic Edit	5	0	Allow NULL?
62	Y9DC	Description - Compressed	String	Generic Edit	40	0	Allow NULL?
63	Y9TARA	Tax Area (Work)	String	Generic Edit	10	0	Allow NULL?
64	Y9TDBA	Code - Tax Area Deduction	Character	UDC (05 YN)	1	0	Allow NULL?
65	Y9CMAX	Inception to Date Limit	Numeric	Generic Edit	9	2	Allow NULL?
66	Y9SACC	Spending Account Type	String	UDC (06 FS)	3	0	Allow NULL?
67	Y9UDBA	Include in Union Plan (Y N)	Character	UDC (05 YN)	1	0	Allow NULL?
68	Y9NPER	Number of Deduction Periods	Character	Generic Edit	1	0	Allow NULL?
69	Y9UN	Union Code	String	UDC (06 UN)	6	0	Allow NULL?
70	Y9MCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
71	Y9JBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
72	Y9JBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
73	Y9TT01	Non-Taxable Authority Types 01	String	UDC (06 TX)	2	0	Allow NULL?
74	Y9TT02	Non-Taxable Authority Types 02	String	UDC (06 TX)	2	0	Allow NULL?
75	Y9TT03	Non-Taxable Authority Types 03	String	UDC (06 TX)	2	0	Allow NULL?
76	Y9TT04	Non-Taxable Authority Types 04	String	UDC (06 TX)	2	0	Allow NULL?
77	Y9TT05	Non-Taxable Authority Types 05	String	UDC (06 TX)	2	0	Allow NULL?
78	Y9TT06	Non-Taxable Authority Types 06	String	UDC (06 TX)	2	0	Allow NULL?
79	Y9TT07	Non-Taxable Authority Types 07	String	UDC (06 TX)	2	0	Allow NULL?
80	Y9TT08	Non-Taxable Authority Types 08	String	UDC (06 TX)	2	0	Allow NULL?
81	Y9TT09	Non-Taxable Authority Types 09	String	UDC (06 TX)	2	0	Allow NULL?
82	Y9TT10	Non-Taxable Authority Types 10	String	UDC (06 TX)	2	0	Allow NULL?
83	Y9TT11	Non-Taxable Authority Types 11	String	UDC (06 TX)	2	0	Allow NULL?
84	Y9TT12	Non-Taxable Authority Types 12	String	UDC (06 TX)	2	0	Allow NULL?
85	Y9TT13	Non-Taxable Authority Types 13	String	UDC (06 TX)	2	0	Allow NULL?
86	Y9TT14	Non-Taxable Authority Types 14	String	UDC (06 TX)	2	0	Allow NULL?
87	Y9TT15	Non-Taxable Authority Types 15	String	UDC (06 TX)	2	0	Allow NULL?
88	Y9UPMJ	Date - Updated	Date	Generic Edit	6	0
89	Y9UPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
90	Y9PID	Program ID	String	Generic Edit	10	0	Allow NULL?
91	Y9JOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
92	Y9USER	User ID	String	Generic Edit	10	0	Allow NULL?
93	Y9DEFR	Date Effective Rate Control	Character	UDC (07 RN)	1	0	Allow NULL?

TOP 812 | 07 | F0729 INDEXES

Number

Description

EE Number Check Ctrl # +A (Primary/Unique)

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	CKCN	Check Control Number	Ascending
3	DLVL	DBA Calculation Level	Ascending
4	PDBA	DBA Code	Ascending
5	WANO	Wage Attach Control Number	Ascending

Union Code MCU JBCD JBST

Element	Alias	Description	Sequence
1	UN	Union Code	Ascending
2	MCU	Business Unit	Ascending
3	JBCD	Job Type (Craft) Code	Ascending
4	JBST	Job Step	Ascending

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

93 COLUMNS | 2 INDEXES | 812 | 07 | F0729 TABLE

TOP 812 | 07 | F0729 COLUMNS

TOP 812 | 07 | F0729 INDEXES

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

93 COLUMNS | 2 INDEXES | 812 | 07 | F0729 TABLE

TOP812 | 07 | F0729 COLUMNS

TOP812 | 07 | F0729 INDEXES

TOP 812 | 07 | F0729 COLUMNS

TOP 812 | 07 | F0729 INDEXES