JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.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
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F42119SDSales Order History File
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

69 COLUMNS | 8 INDEXES | Print definition?920 | 07 | F055011W TABLE

07: Payroll
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F055011WAD698Auto Deposit Instructions Work FileFiles07: Payroll
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 ADAN8, ADSSN, ADALPH, ADHMCO, ADTAX, ADSEC, ADSCC, ADPSDT, ADPTDT, ADFPCD, ADPREN, ADDEP1, ADDEP2, ADDEP3, ADDEP4, ADDEP5, ADDEP6, ADUSER, ADPID, ADUPMJ, ADEV01, ADSEQ, ADSEQN2, ADBDM, ADBDM2, ADFOA#, ADFOA#2, ADOFO#, ADIFO#, ADTCOD, ADGPAY, ADEV02, ADSEQN3, ADSEQN4, ADBDM3, ADBDM4, ADFOA#3, ADFOA#4, ADOFO#2, ADIFO#2, ADTCOD2, ADGPAY2, ADEV03, ADSEQN5, ADSEQN6, ADBDM5, ADBDM6, ADFOA#5, ADFOA#6, ADOFO#3, ADIFO#3, ADTCOD3, ADGPAY3, ADEV04, ADSEQN7, ADSEQN8, ADBDM7, ADBDM8, ADFOA#7, ADFOA#8, ADOFO#4, ADIFO#4, ADTCOD4, ADGPAY4, ADDL30, ADFPCD2, ADFPCD3, ADFPCD4, ADFPCD5 FROM F055011W

TOP920 | 07 | F055011W COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1ADAN8Address NumberNumericGeneric Edit80 Allow NULL? 
2ADSSNEmployee Tax IDStringGeneric Edit200 Allow NULL? 
3ADALPHName - AlphaStringGeneric Edit400 Allow NULL? 
4ADHMCOCompany - HomeStringGeneric Edit50 Allow NULL? 
5ADTAXTax IDStringGeneric Edit200 Allow NULL? 
6ADSECStandard Entry ClassStringUDC (07 SE)30 Allow NULL? 
7ADSCCService Class CodeStringUDC (07 SI)30 Allow NULL? 
8ADPSDTDate - Pay StartsDateGeneric Edit60
9ADPTDTDate - Pay StopsDateGeneric Edit60
10ADFPCDFull/Partial CodeCharacterUDC (07 FP)10 Allow NULL? 
11ADPRENPre Notification CodeStringUDC (07 NT)20 Allow NULL? 
12ADDEP1Deduction Period 1CharacterUDC (05A DD)10 Allow NULL? 
13ADDEP2Deduction Period 2CharacterUDC (05A DD)10 Allow NULL? 
14ADDEP3Deduction Period 3CharacterUDC (05A DD)10 Allow NULL? 
15ADDEP4Deduction Period 4CharacterUDC (05A DD)10 Allow NULL? 
16ADDEP5Deduction Period 5CharacterUDC (05A DD)10 Allow NULL? 
17ADDEP6Deduction Period 6CharacterUDC (05A DD)10 Allow NULL? 
18ADUSERUser IDStringGeneric Edit100 Allow NULL? 
19ADPIDProgram IDStringGeneric Edit100 Allow NULL? 
20ADUPMJDate - UpdatedDateGeneric Edit60
21ADEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10 Allow NULL? 
22ADSEQSequence NumberNumericGeneric Edit60 Allow NULL? 
23ADSEQN2Sequence NumberNumericGeneric Edit60 Allow NULL? 
24ADBDMMethod Code - Bank DepositsCharacterUDC (07 MC)10 Allow NULL? 
25ADBDM2Method Code - Bank DepositsCharacterUDC (07 MC)10 Allow NULL? 
26ADFOA#Financial Organization Account NumberStringGeneric Edit170 Allow NULL? 
27ADFOA#2Financial Organization Account NumberStringGeneric Edit170 Allow NULL? 
28ADOFO#Originating Financial Organization No.StringUDC (06 BC)90 Allow NULL? 
29ADIFO#Individuals Financial Organization No.StringUDC (06 BC)90 Allow NULL? 
30ADTCODTransaction CodeStringUDC (06 AD)20 Allow NULL? 
31ADGPAYAmount - Gross PayNumericGeneric Edit152 Allow NULL? 
32ADEV02J.D. EnterpriseOne Event Point 02CharacterGeneric Edit10 Allow NULL? 
33ADSEQN3Sequence NumberNumericGeneric Edit60 Allow NULL? 
34ADSEQN4Sequence NumberNumericGeneric Edit60 Allow NULL? 
35ADBDM3Method Code - Bank DepositsCharacterUDC (07 MC)10 Allow NULL? 
36ADBDM4Method Code - Bank DepositsCharacterUDC (07 MC)10 Allow NULL? 
37ADFOA#3Financial Organization Account NumberStringGeneric Edit170 Allow NULL? 
38ADFOA#4Financial Organization Account NumberStringGeneric Edit170 Allow NULL? 
39ADOFO#2Originating Financial Organization No.StringUDC (06 BC)90 Allow NULL? 
40ADIFO#2Individuals Financial Organization No.StringGeneric Edit90 Allow NULL? 
41ADTCOD2Transaction CodeStringUDC (06 AD)20 Allow NULL? 
42ADGPAY2Amount - Gross PayNumericGeneric Edit152 Allow NULL? 
43ADEV03J.D. EnterpriseOne Point 03CharacterGeneric Edit10 Allow NULL? 
44ADSEQN5Sequence NumberNumericGeneric Edit60 Allow NULL? 
45ADSEQN6Sequence NumberNumericGeneric Edit60 Allow NULL? 
46ADBDM5Method Code - Bank DepositsCharacterUDC (07 MC)10 Allow NULL? 
47ADBDM6Method Code - Bank DepositsCharacterUDC (07 MC)10 Allow NULL? 
48ADFOA#5Financial Organization Account NumberStringGeneric Edit170 Allow NULL? 
49ADFOA#6Financial Organization Account NumberStringGeneric Edit170 Allow NULL? 
50ADOFO#3Originating Financial Organization No.StringUDC (06 BC)90 Allow NULL? 
51ADIFO#3Individuals Financial Organization No.StringUDC (06 BC)90 Allow NULL? 
52ADTCOD3Transaction CodeStringUDC (06 AD)20 Allow NULL? 
53ADGPAY3Amount - Gross PayNumericGeneric Edit152 Allow NULL? 
54ADEV04EnterpriseOne Point 04CharacterGeneric Edit10 Allow NULL? 
55ADSEQN7Sequence NumberNumericGeneric Edit60 Allow NULL? 
56ADSEQN8Sequence NumberNumericGeneric Edit60 Allow NULL? 
57ADBDM7Method Code - Bank DepositsCharacterUDC (07 MC)10 Allow NULL? 
58ADBDM8Method Code - Bank DepositsCharacterUDC (07 MC)10 Allow NULL? 
59ADFOA#7Financial Organization Account NumberStringGeneric Edit170 Allow NULL? 
60ADFOA#8Financial Organization Account NumberStringGeneric Edit170 Allow NULL? 
61ADOFO#4Originating Financial Organization No.StringUDC (06 BC)90 Allow NULL? 
62ADIFO#4Individuals Financial Organization No.StringUDC (06 BC)90 Allow NULL? 
63ADTCOD4Transaction CodeStringUDC (06 AD)20 Allow NULL? 
64ADGPAY4Amount - Gross PayNumericGeneric Edit152 Allow NULL? 
65ADDL30Description 30StringGeneric Edit300 Allow NULL? 
66ADFPCD2Full/Partial CodeCharacterUDC (07 FP)10 Allow NULL? 
67ADFPCD3Full/Partial CodeCharacterUDC (07 FP)10 Allow NULL? 
68ADFPCD4Full/Partial CodeCharacterUDC (07 FP)10 Allow NULL? 
69ADFPCD5Full/Partial CodeCharacterUDC (07 FP)10 Allow NULL? 

TOP920 | 07 | F055011W INDEXES

NumberDescription
1Address No (Primary/Unique)
ElementAliasDescriptionSequence
1ALPHName - AlphaAscending
2AN8Address NumberAscending
2Emp Details
ElementAliasDescriptionSequence
1SSNEmployee Tax IDAscending
2HMCOCompany - HomeAscending
3TAXTax IDAscending
4SECStandard Entry ClassAscending
5SCCService Class CodeAscending
6PSDTDate - Pay StartsAscending
7PTDTDate - Pay StopsAscending
8FPCDFull/Partial CodeAscending
9PRENPre Notification CodeAscending
10DEP1Deduction Period 1Ascending
11DEP2Deduction Period 2Ascending
12DEP3Deduction Period 3Ascending
13DEP4Deduction Period 4Ascending
14DEP5Deduction Period 5Ascending
15DEP6Deduction Period 6Ascending
3Audit Fields
ElementAliasDescriptionSequence
1USERUser IDAscending
2PIDProgram IDAscending
3UPMJDate - UpdatedAscending
4Set 1
ElementAliasDescriptionSequence
1EV01J.D. EnterpriseOne Event Point 01Ascending
2SEQSequence NumberAscending
3SEQN2Sequence NumberAscending
4BDMMethod Code - Bank DepositsAscending
5BDM2Method Code - Bank DepositsAscending
6FOA#Financial Organization Account NumberAscending
7FOA#2Financial Organization Account NumberAscending
8OFO#Originating Financial Organization No.Ascending
9IFO#Individuals Financial Organization No.Ascending
10TCODTransaction CodeAscending
11GPAYAmount - Gross PayAscending
5Set 2
ElementAliasDescriptionSequence
1EV02J.D. EnterpriseOne Event Point 02Ascending
2SEQN3Sequence NumberAscending
3SEQN4Sequence NumberAscending
4BDM3Method Code - Bank DepositsAscending
5BDM4Method Code - Bank DepositsAscending
6FOA#3Financial Organization Account NumberAscending
7FOA#4Financial Organization Account NumberAscending
8OFO#2Originating Financial Organization No.Ascending
9IFO#2Individuals Financial Organization No.Ascending
10TCOD2Transaction CodeAscending
11GPAY2Amount - Gross PayAscending
6Set 3
ElementAliasDescriptionSequence
1EV03J.D. EnterpriseOne Point 03Ascending
2SEQN5Sequence NumberAscending
3SEQN6Sequence NumberAscending
4BDM5Method Code - Bank DepositsAscending
5BDM6Method Code - Bank DepositsAscending
6FOA#5Financial Organization Account NumberAscending
7FOA#6Financial Organization Account NumberAscending
8OFO#3Originating Financial Organization No.Ascending
9IFO#3Individuals Financial Organization No.Ascending
10TCOD3Transaction CodeAscending
11GPAY3Amount - Gross PayAscending
7Set 4
ElementAliasDescriptionSequence
1EV04EnterpriseOne Point 04Ascending
2SEQN7Sequence NumberAscending
3SEQN8Sequence NumberAscending
4BDM7Method Code - Bank DepositsAscending
5BDM8Method Code - Bank DepositsAscending
6FOA#7Financial Organization Account NumberAscending
7FOA#8Financial Organization Account NumberAscending
8OFO#4Originating Financial Organization No.Ascending
9IFO#4Individuals Financial Organization No.Ascending
10TCOD4Transaction CodeAscending
11GPAY4Amount - Gross PayAscending
8Set 5
ElementAliasDescriptionSequence
1DL30Description 30Ascending
2FPCD2Full/Partial CodeAscending
3FPCD3Full/Partial CodeAscending
4FPCD4Full/Partial CodeAscending
5FPCD5Full/Partial CodeAscending