	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	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	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail 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

69 COLUMNS | 7 INDEXES | 920 | 77 | F77200 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
77: Payroll (Canadian)
1	920	F77200	J5	69	7	Canadian Employee Year-End Form Header - F77200	History Files	77Y: Canada Payroll Year End

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 J5YEID, J5TAXYR, J5AN8, J5FORMSID, J5FORMD, J5CO, J5AMNDT, J5TARA, J5TAXX, J5SSN, J5ALPH, J5HMCU, J5PFCNO, J5SFCNO, J5T4PE, J5FDWG, J5AFDWG, J5FDTX, J5AFDTX, J5PRTXW, J5APRTXW, J5PRITX, J5APRITX, J5EIER, J5AEIER, J5EIP, J5AEIP, J5EIPR, J5CPPE, J5ACPPE, J5CPP, J5ACPP, J5CPER, J5QPP, J5AQPP, J5GI1, J5AGI1, J5TXW1, J5ATXW1, J5GI2, J5AGI2, J5TXW2, J5ATXW2, J5PPIP, J5APPIP, J5PPIE, J5APPIE, J5QPER, J5T4EC, J5ECPP, J5EPP, J5NRCT, J5CCPR, J5EEI, J5SSIN, J5SALPH, J5R2PR, J5ICC1, J5CC1, J5EXC1, J5ICC2, J5CC2, J5EXC2, J5ARCS, J5UPMJ, J5UPMT, J5PID, J5JOBN, J5USER FROM F77200

TOP 920 | 77 | F77200 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	J5YEID	Year-End ID	String	Generic Edit	10	0	Allow NULL?
2	J5TAXYR	Tax Year	Numeric	Generic Edit	4	0	Allow NULL?
3	J5AN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
4	J5FORMSID	Form ID	Numeric	Generic Edit	2	0	Allow NULL?
5	J5FORMD	Form Description	String	Generic Edit	40	0	Allow NULL?
6	J5CO	Company	String	Generic Edit	5	0	Allow NULL?
7	J5AMNDT	Amend Type	Character	Generic Edit	1	0	Allow NULL?
8	J5TARA	Tax Area (Work)	String	Generic Edit	10	0	Allow NULL?
9	J5TAXX	Tax Identification Number	String	Generic Edit	20	0	Allow NULL?
10	J5SSN	Employee Tax ID	String	Generic Edit	20	0	Allow NULL?
11	J5ALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
12	J5HMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
13	J5PFCNO	Primary Form Control Number	Numeric	Generic Edit	15	0	Allow NULL?
14	J5SFCNO	Secondary Form Control Number	Numeric	Generic Edit	15	0	Allow NULL?
15	J5T4PE	Province of Employment	String	Generic Edit	2	0	Allow NULL?
16	J5FDWG	Amount - Wages Federal Taxable	Numeric	Generic Edit	15	2	Allow NULL?
17	J5AFDWG	Adjusted FIT Taxable Wages	Numeric	Generic Edit	15	2	Allow NULL?
18	J5FDTX	Amount - Federal Income Tax	Numeric	Generic Edit	15	2	Allow NULL?
19	J5AFDTX	Adjusted Federal Income Tax	Numeric	Generic Edit	15	2	Allow NULL?
20	J5PRTXW	Provincial Taxable Wages	Numeric	Generic Edit	15	2	Allow NULL?
21	J5APRTXW	Adjusted Provincial Taxable Wages	Numeric	Generic Edit	15	2	Allow NULL?
22	J5PRITX	Provincial Income Tax	Numeric	Generic Edit	15	2	Allow NULL?
23	J5APRITX	Adjusted Provincial Income Tax	Numeric	Generic Edit	15	2	Allow NULL?
24	J5EIER	EI Insurable Earnings	Numeric	Generic Edit	15	2	Allow NULL?
25	J5AEIER	Adjusted EI Insurable Earnings	Numeric	Generic Edit	15	2	Allow NULL?
26	J5EIP	EI Premium	Numeric	Generic Edit	15	2	Allow NULL?
27	J5AEIP	Adjusted EI Premium	Numeric	Generic Edit	15	2	Allow NULL?
28	J5EIPR	EI Premium Employer	Numeric	Generic Edit	15	2	Allow NULL?
29	J5CPPE	Pensionable Earnings	Numeric	Generic Edit	15	2	Allow NULL?
30	J5ACPPE	Adjusted Pensionable Earnings	Numeric	Generic Edit	15	2	Allow NULL?
31	J5CPP	Canada Pension Plan- EE Contribution	Numeric	Generic Edit	15	2	Allow NULL?
32	J5ACPP	Adjusted Canada Pension Plan	Numeric	Generic Edit	15	2	Allow NULL?
33	J5CPER	CPP - Employer	Numeric	Generic Edit	15	2	Allow NULL?
34	J5QPP	Quebec Pension Plan- EE Contribution	Numeric	Generic Edit	15	2	Allow NULL?
35	J5AQPP	Adjusted Quebec Pension Plan	Numeric	Generic Edit	15	2	Allow NULL?
36	J5GI1	Gross Income 1	Numeric	Generic Edit	15	2	Allow NULL?
37	J5AGI1	Adjusted Gross Income 1	Numeric	Generic Edit	15	2	Allow NULL?
38	J5TXW1	Tax Withheld 1	Numeric	Generic Edit	15	2	Allow NULL?
39	J5ATXW1	Adjusted Tax Withheld 1	Numeric	Generic Edit	15	2	Allow NULL?
40	J5GI2	Gross Income 2	Numeric	Generic Edit	15	2	Allow NULL?
41	J5AGI2	Adjusted Gross Income 2	Numeric	Generic Edit	15	2	Allow NULL?
42	J5TXW2	Tax Withheld 2	Numeric	Generic Edit	15	2	Allow NULL?
43	J5ATXW2	Adjusted Tax Withheld 2	Numeric	Generic Edit	15	2	Allow NULL?
44	J5PPIP	PPIP Premium	Numeric	Generic Edit	15	2	Allow NULL?
45	J5APPIP	Adjusted PPIP Premium	Numeric	Generic Edit	15	2	Allow NULL?
46	J5PPIE	PPIP Insurable Earnings	Numeric	Generic Edit	15	2	Allow NULL?
47	J5APPIE	Adjusted PPIP Insurable Earnings	Numeric	Generic Edit	15	2	Allow NULL?
48	J5QPER	QPP Employer	Numeric	Generic Edit	15	2	Allow NULL?
49	J5T4EC	Employment Code	String	UDC	2	0	Allow NULL?
50	J5ECPP	Exempt from CPP/QPP	Character	UDC	1	0	Allow NULL?
51	J5EPP	Exempt PPIP Premium	Numeric	Generic Edit	15	2	Allow NULL?
52	J5NRCT	Recipient Type	Character	UDC (77Y RT)	1	0	Allow NULL?
53	J5CCPR	Country Code	String	UDC (00 CN)	3	0	Allow NULL?
54	J5EEI	Exempt From EI	Character	Generic Edit	1	0	Allow NULL?
55	J5SSIN	Spouse Social Insurance Number	String	Generic Edit	20	0	Allow NULL?
56	J5SALPH	Spouse Alpha Name	String	Generic Edit	40	0	Allow NULL?
57	J5R2PR	Type of Retirement Account	String	Generic Edit	10	0	Allow NULL?
58	J5ICC1	Income Code 1	String	UDC (77 IC)	10	0	Allow NULL?
59	J5CC1	Currency Code 1	String	UDC (77 CU)	3	0	Allow NULL?
60	J5EXC1	Exemption Code 1	String	UDC (77 EX)	3	0	Allow NULL?
61	J5ICC2	Income Code 2	String	UDC (77 IC)	10	0	Allow NULL?
62	J5CC2	Currency Code 2	String	UDC (77 CU)	3	0	Allow NULL?
63	J5EXC2	Excemption Code 2	String	UDC (77 EX)	3	0	Allow NULL?
64	J5ARCS	Archive Status	Character	Generic Edit	1	0	Allow NULL?
65	J5UPMJ	Date - Updated	Date	Generic Edit	6	0
66	J5UPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
67	J5PID	Program ID	String	Generic Edit	10	0	Allow NULL?
68	J5JOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
69	J5USER	User ID	String	Generic Edit	10	0	Allow NULL?

TOP 920 | 77 | F77200 INDEXES

Number

Description

YearEndId TaxYear + (Primary/Unique)

Element	Alias	Description	Sequence
1	YEID	Year-End ID	Ascending
2	TAXYR	Tax Year	Ascending
3	AN8	Address Number	Ascending
4	FORMSID	Form ID	Ascending
5	CO	Company	Ascending
6	AMNDT	Amend Type	Ascending
7	TAXX	Tax Identification Number	Ascending
8	TARA	Tax Area (Work)	Ascending

FormsId PrimaryFormControlNo

Element	Alias	Description	Sequence
1	FORMSID	Form ID	Ascending
2	PFCNO	Primary Form Control Number	Descending

FormsId SecondaryFormContrlNo

Element	Alias	Description	Sequence
1	FORMSID	Form ID	Ascending
2	SFCNO	Secondary Form Control Number	Descending

YearEndId TaxYear FormsId

Element	Alias	Description	Sequence
1	YEID	Year-End ID	Ascending
2	TAXYR	Tax Year	Ascending
3	FORMSID	Form ID	Ascending

YearEndId TaxYear

Element	Alias	Description	Sequence
1	YEID	Year-End ID	Ascending
2	TAXYR	Tax Year	Ascending

TaxYear FormsId PrimaryFormCnt

Element	Alias	Description	Sequence
1	TAXYR	Tax Year	Ascending
2	FORMSID	Form ID	Ascending
3	PFCNO	Primary Form Control Number	Descending

TaxYear FormsId SecondFormCnt

Element	Alias	Description	Sequence
1	TAXYR	Tax Year	Ascending
2	FORMSID	Form ID	Ascending
3	SFCNO	Secondary Form Control Number	Descending

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

69 COLUMNS | 7 INDEXES | 920 | 77 | F77200 TABLE

TOP 920 | 77 | F77200 COLUMNS

TOP 920 | 77 | F77200 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

69 COLUMNS | 7 INDEXES | 920 | 77 | F77200 TABLE

TOP920 | 77 | F77200 COLUMNS

TOP920 | 77 | F77200 INDEXES

TOP 920 | 77 | F77200 COLUMNS

TOP 920 | 77 | F77200 INDEXES