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

60 COLUMNS | 12 INDEXES | Print definition?812 | 06 | F06146 TABLE

06: Payroll (old) - Obsolete-do not reuse
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F06146YN6012Employee Transaction History SummaryMaster Files06: Payroll (old) - Obsolete-do not reuseAS400 Coexistence Tables
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 YNAN8, YNPDBA, YNDISO, YNCTRY, YNDTEY, YNPBFP, YNHMCO, YNTAXX, YNBWBB, YNBWPY, YNBW01, YNBW02, YNBW03, YNBW04, YNBW05, YNBW06, YNBW07, YNBW08, YNBW09, YNBW10, YNBW11, YNBW12, YNARRA, YNBHBB, YNBHPY, YNBH01, YNBH02, YNBH03, YNBH04, YNBH05, YNBH06, YNBH07, YNBH08, YNBH09, YNBH10, YNBH11, YNBH12, YNBIBB, YNBIPY, YNBI01, YNBI02, YNBI03, YNBI04, YNBI05, YNBI06, YNBI07, YNBI08, YNBI09, YNBI10, YNBI11, YNBI12, YNAD, YNNP, YNUSER, YNPID, YNUPMJ, YNPAYG, YNPAYN, YNDTSP, YNTHTY FROM F06146

TOP812 | 06 | F06146 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1YNAN8Address NumberNumericUDC80 Allow NULL? 
2YNPDBADBA CodeNumericGeneric Edit50 Allow NULL? 
3YNDISODBA TypeCharacterUDC (05 DI)10 Allow NULL? 
4YNCTRYCenturyNumericGeneric Edit20 Allow NULL? 
5YNDTEYDate - YRNumericGeneric Edit20 Allow NULL? 
6YNPBFPFiscal Period - Beginning MonthNumericUDC (07 MN)20 Allow NULL? 
7YNHMCOCompany - HomeStringGeneric Edit50 Allow NULL? 
8YNTAXXTax Identification NumberStringGeneric Edit200 Allow NULL? 
9YNBWBBGross Pay Beginning BalanceNumericGeneric Edit152 Allow NULL? 
10YNBWPYGross Pay Prior YearNumericGeneric Edit152 Allow NULL? 
11YNBW01Pay - Gross 01NumericGeneric Edit152 Allow NULL? 
12YNBW02Pay - Gross 02NumericGeneric Edit152 Allow NULL? 
13YNBW03Pay - Gross 03NumericGeneric Edit152 Allow NULL? 
14YNBW04Pay - Gross 04NumericGeneric Edit152 Allow NULL? 
15YNBW05Pay - Gross 05NumericGeneric Edit152 Allow NULL? 
16YNBW06Pay - Gross 06NumericGeneric Edit152 Allow NULL? 
17YNBW07Pay - Gross 07NumericGeneric Edit152 Allow NULL? 
18YNBW08Pay - Gross 08NumericGeneric Edit152 Allow NULL? 
19YNBW09Pay - Gross 09NumericGeneric Edit152 Allow NULL? 
20YNBW10Pay - Gross 10NumericGeneric Edit152 Allow NULL? 
21YNBW11Pay - Gross 11NumericGeneric Edit152 Allow NULL? 
22YNBW12Pay - Gross 12NumericGeneric Edit152 Allow NULL? 
23YNARRAAmount - ArrearageNumericGeneric Edit92 Allow NULL? 
24YNBHBBHours Beginning BalanceNumericGeneric Edit152 Allow NULL? 
25YNBHPYHours Prior YearNumericGeneric Edit152 Allow NULL? 
26YNBH01Hours MTD 01NumericGeneric Edit152 Allow NULL? 
27YNBH02Hours MTD 02NumericGeneric Edit152 Allow NULL? 
28YNBH03Hours MTD 03NumericGeneric Edit152 Allow NULL? 
29YNBH04Hours MTD 04NumericGeneric Edit152 Allow NULL? 
30YNBH05Hours MTD 05NumericGeneric Edit152 Allow NULL? 
31YNBH06Hours MTD 06NumericGeneric Edit152 Allow NULL? 
32YNBH07Hours MTD 07NumericGeneric Edit152 Allow NULL? 
33YNBH08Hours MTD 08NumericGeneric Edit152 Allow NULL? 
34YNBH09Hours MTD 09NumericGeneric Edit152 Allow NULL? 
35YNBH10Hours MTD 10NumericGeneric Edit152 Allow NULL? 
36YNBH11Hours MTD 11NumericGeneric Edit152 Allow NULL? 
37YNBH12Hours MTD 12NumericGeneric Edit152 Allow NULL? 
38YNBIBBPieces Beginning BalanceNumericGeneric Edit152 Allow NULL? 
39YNBIPYPieces Prior YearNumericGeneric Edit152 Allow NULL? 
40YNBI01Pieces MTD 01NumericGeneric Edit152 Allow NULL? 
41YNBI02Pieces MTD 02NumericGeneric Edit152 Allow NULL? 
42YNBI03Pieces MTD 03NumericGeneric Edit152 Allow NULL? 
43YNBI04Pieces MTD 04NumericGeneric Edit152 Allow NULL? 
44YNBI05Pieces MTD 05NumericGeneric Edit152 Allow NULL? 
45YNBI06Pieces MTD 06NumericGeneric Edit152 Allow NULL? 
46YNBI07Pieces MTD 07NumericGeneric Edit152 Allow NULL? 
47YNBI08Pieces MTD 08NumericGeneric Edit152 Allow NULL? 
48YNBI09Pieces MTD 09NumericGeneric Edit152 Allow NULL? 
49YNBI10Pieces MTD 10NumericGeneric Edit152 Allow NULL? 
50YNBI11Pieces MTD 11NumericGeneric Edit152 Allow NULL? 
51YNBI12Pieces MTD 12NumericGeneric Edit152 Allow NULL? 
52YNADAmount - DueNumericGeneric Edit152 Allow NULL? 
53YNNPNumber of Deduction PeriodsNumericGeneric Edit40 Allow NULL? 
54YNUSERUser IDStringGeneric Edit100 Allow NULL? 
55YNPIDProgram IDStringGeneric Edit100 Allow NULL? 
56YNUPMJDate - UpdatedDateGeneric Edit60
57YNPAYGEffect on Gross PayCharacterUDC (07 PA)10 Allow NULL? 
58YNPAYNEffect on Net PayCharacterUDC (07 PA)10 Allow NULL? 
59YNDTSPDate - Time StampNumericGeneric Edit130 Allow NULL? 
60YNTHTYCode - Tax History TypeCharacterUDC (06 TH)10 Allow NULL? 

TOP812 | 06 | F06146 INDEXES

NumberDescription
1Address Book Nbr Tax Hist +A (Primary/Unique)
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2THTYCode - Tax History TypeAscending
3PDBADBA CodeAscending
4DTEYDate - YRAscending
5TAXXTax Identification NumberAscending
6HMCOCompany - HomeAscending
2Address Book Nbr Date Yr +A
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2DTEYDate - YRAscending
3TAXXTax Identification NumberAscending
4PDBADBA CodeAscending
3Address Book Nbr Date Yr +B
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2DTEYDate - YRAscending
3HMCOCompany - HomeAscending
4TAXXTax Identification NumberAscending
5THTYCode - Tax History TypeAscending
6PDBADBA CodeAscending
4Date Yr Home Company +A
ElementAliasDescriptionSequence
1DTEYDate - YRAscending
2HMCOCompany - HomeAscending
3AN8Address NumberAscending
4THTYCode - Tax History TypeAscending
5PDBADBA CodeAscending
5Date Yr Home Company +B
ElementAliasDescriptionSequence
1DTEYDate - YRAscending
2HMCOCompany - HomeAscending
3PDBADBA CodeAscending
4AN8Address NumberAscending
5THTYCode - Tax History TypeAscending
6Address Book Nbr Date Yr +C
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2DTEYDate - YRAscending
3TAXXTax Identification NumberAscending
4THTYCode - Tax History TypeAscending
5PDBADBA CodeAscending
7Date Yr Address Book Nr +A
ElementAliasDescriptionSequence
1DTEYDate - YRAscending
2AN8Address NumberAscending
3HMCOCompany - HomeAscending
4THTYCode - Tax History TypeAscending
5PDBADBA CodeAscending
8Date Yr Address Book Nr +B
ElementAliasDescriptionSequence
1DTEYDate - YRAscending
2AN8Address NumberAscending
3THTYCode - Tax History TypeAscending
4PDBADBA CodeAscending
5TAXXTax Identification NumberAscending
6HMCOCompany - HomeAscending
9Address Book Nbr PDBA +A
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2PDBADBA CodeAscending
3DTEYDate - YRAscending
4TAXXTax Identification NumberAscending
5HMCOCompany - HomeAscending
10Address Book Nbr PDBA +B
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2PDBADBA CodeAscending
3HMCOCompany - HomeAscending
11Address Book Nbr Home Co
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2HMCOCompany - HomeAscending
12PDBA Date Year
ElementAliasDescriptionSequence
1PDBADBA CodeAscending
2DTEYDate - YRAscending