JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

Implementation Guides | 920 VMs | Schema:
920 910 812
System  Table 
Column 
Searchbeta 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

SAPTables.Net - the webs number one SAP Tables Definition reference

920: Top 10 requests

TablePrefixDescription
1F4211SDSales Order Detail File
2F0101ABAddress Book Master
3F4101IMItem Master
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

69 COLUMNS | 7 INDEXES | Print definition?812 | 77 | F77200 TABLE

77: Payroll (Canadian)
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F77200J5697Canadian Employee Year-End Form Header - F77200History Files77Y: Canada Payroll Year EndNo
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

TOP812 | 77 | F77200 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1J5YEIDYear-End IDStringGeneric Edit100 Allow NULL? 
2J5TAXYRTax YearNumericGeneric Edit40 Allow NULL? 
3J5AN8Address NumberNumericUDC80 Allow NULL? 
4J5FORMSIDForm IDNumericGeneric Edit20 Allow NULL? 
5J5FORMDForm DescriptionStringGeneric Edit400 Allow NULL? 
6J5COCompanyStringGeneric Edit50 Allow NULL? 
7J5AMNDTAmend TypeCharacterGeneric Edit10 Allow NULL? 
8J5TARATax Area (Work)StringGeneric Edit100 Allow NULL? 
9J5TAXXTax Identification NumberStringGeneric Edit200 Allow NULL? 
10J5SSNEmployee Tax IDStringGeneric Edit200 Allow NULL? 
11J5ALPHName - AlphaStringGeneric Edit400 Allow NULL? 
12J5HMCUBusiness Unit - HomeStringGeneric Edit120 Allow NULL? 
13J5PFCNOPrimary Form Control NumberNumericGeneric Edit150 Allow NULL? 
14J5SFCNOSecondary Form Control NumberNumericGeneric Edit150 Allow NULL? 
15J5T4PEProvince of EmploymentStringGeneric Edit20 Allow NULL? 
16J5FDWGAmount - Wages Federal TaxableNumericGeneric Edit152 Allow NULL? 
17J5AFDWGAdjusted FIT Taxable WagesNumericGeneric Edit152 Allow NULL? 
18J5FDTXAmount - Federal Income TaxNumericGeneric Edit152 Allow NULL? 
19J5AFDTXAdjusted Federal Income TaxNumericGeneric Edit152 Allow NULL? 
20J5PRTXWProvincial Taxable WagesNumericGeneric Edit152 Allow NULL? 
21J5APRTXWAdjusted Provincial Taxable WagesNumericGeneric Edit152 Allow NULL? 
22J5PRITXProvincial Income TaxNumericGeneric Edit152 Allow NULL? 
23J5APRITXAdjusted Provincial Income TaxNumericGeneric Edit152 Allow NULL? 
24J5EIEREI Insurable EarningsNumericGeneric Edit152 Allow NULL? 
25J5AEIERAdjusted EI Insurable EarningsNumericGeneric Edit152 Allow NULL? 
26J5EIPEI PremiumNumericGeneric Edit152 Allow NULL? 
27J5AEIPAdjusted EI PremiumNumericGeneric Edit152 Allow NULL? 
28J5EIPREI Premium EmployerNumericGeneric Edit152 Allow NULL? 
29J5CPPEPensionable EarningsNumericGeneric Edit152 Allow NULL? 
30J5ACPPEAdjusted Pensionable EarningsNumericGeneric Edit152 Allow NULL? 
31J5CPPCanada Pension Plan- EE ContributionNumericGeneric Edit152 Allow NULL? 
32J5ACPPAdjusted Canada Pension PlanNumericGeneric Edit152 Allow NULL? 
33J5CPERCPP - EmployerNumericGeneric Edit152 Allow NULL? 
34J5QPPQuebec Pension Plan- EE ContributionNumericGeneric Edit152 Allow NULL? 
35J5AQPPAdjusted Quebec Pension PlanNumericGeneric Edit152 Allow NULL? 
36J5GI1Gross Income 1NumericGeneric Edit152 Allow NULL? 
37J5AGI1Adjusted Gross Income 1NumericGeneric Edit152 Allow NULL? 
38J5TXW1Tax Withheld 1NumericGeneric Edit152 Allow NULL? 
39J5ATXW1Adjusted Tax Withheld 1NumericGeneric Edit152 Allow NULL? 
40J5GI2Gross Income 2NumericGeneric Edit152 Allow NULL? 
41J5AGI2Adjusted Gross Income 2NumericGeneric Edit152 Allow NULL? 
42J5TXW2Tax Withheld 2NumericGeneric Edit152 Allow NULL? 
43J5ATXW2Adjusted Tax Withheld 2NumericGeneric Edit152 Allow NULL? 
44J5PPIPPPIP PremiumNumericGeneric Edit152 Allow NULL? 
45J5APPIPAdjusted PPIP PremiumNumericGeneric Edit152 Allow NULL? 
46J5PPIEPPIP Insurable EarningsNumericGeneric Edit152 Allow NULL? 
47J5APPIEAdjusted PPIP Insurable EarningsNumericGeneric Edit152 Allow NULL? 
48J5QPERQPP EmployerNumericGeneric Edit152 Allow NULL? 
49J5T4ECEmployment CodeStringUDC20 Allow NULL? 
50J5ECPPExempt from CPP/QPPCharacterUDC10 Allow NULL? 
51J5EPPExempt PPIP PremiumNumericGeneric Edit152 Allow NULL? 
52J5NRCTRecipient TypeCharacterUDC (77Y RT)10 Allow NULL? 
53J5CCPRCountry CodeStringUDC (00 CN)30 Allow NULL? 
54J5EEIExempt From EICharacterGeneric Edit10 Allow NULL? 
55J5SSINSpouse Social Insurance NumberStringGeneric Edit200 Allow NULL? 
56J5SALPHSpouse Alpha NameStringGeneric Edit400 Allow NULL? 
57J5R2PRType of Retirement AccountStringGeneric Edit100 Allow NULL? 
58J5ICC1Income Code 1StringUDC (77 IC)100 Allow NULL? 
59J5CC1Currency Code 1StringUDC (77 CU)30 Allow NULL? 
60J5EXC1Exemption Code 1StringUDC (77 EX)30 Allow NULL? 
61J5ICC2Income Code 2StringUDC (77 IC)100 Allow NULL? 
62J5CC2Currency Code 2StringUDC (77 CU)30 Allow NULL? 
63J5EXC2Excemption Code 2StringUDC (77 EX)30 Allow NULL? 
64J5ARCSArchive StatusCharacterGeneric Edit10 Allow NULL? 
65J5UPMJDate - UpdatedDateGeneric Edit60
66J5UPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
67J5PIDProgram IDStringGeneric Edit100 Allow NULL? 
68J5JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
69J5USERUser IDStringGeneric Edit100 Allow NULL? 

TOP812 | 77 | F77200 INDEXES

NumberDescription
1YearEndId TaxYear + (Primary/Unique)
ElementAliasDescriptionSequence
1YEIDYear-End IDAscending
2TAXYRTax YearAscending
3AN8Address NumberAscending
4FORMSIDForm IDAscending
5COCompanyAscending
6AMNDTAmend TypeAscending
7TAXXTax Identification NumberAscending
8TARATax Area (Work)Ascending
2FormsId PrimaryFormControlNo
ElementAliasDescriptionSequence
1FORMSIDForm IDAscending
2PFCNOPrimary Form Control NumberDescending
3FormsId SecondaryFormContrlNo
ElementAliasDescriptionSequence
1FORMSIDForm IDAscending
2SFCNOSecondary Form Control NumberDescending
4YearEndId TaxYear FormsId
ElementAliasDescriptionSequence
1YEIDYear-End IDAscending
2TAXYRTax YearAscending
3FORMSIDForm IDAscending
5YearEndId TaxYear
ElementAliasDescriptionSequence
1YEIDYear-End IDAscending
2TAXYRTax YearAscending
6TaxYear FormsId PrimaryFormCnt
ElementAliasDescriptionSequence
1TAXYRTax YearAscending
2FORMSIDForm IDAscending
3PFCNOPrimary Form Control NumberDescending
7TaxYear FormsId SecondFormCnt
ElementAliasDescriptionSequence
1TAXYRTax YearAscending
2FORMSIDForm IDAscending
3SFCNOSecondary Form Control NumberDescending