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
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

81 COLUMNS | 3 INDEXES | Print definition?920 | 06 | F06210 TABLE

06: Payroll (old) - Obsolete-do not reuse
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F06210YD813Payroll Cycle ParametersWork Files06: Payroll (old) - Obsolete-do not reuseBusiness 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 YDPRID, YDVERS, YDPCCD, YDDTEY, YDCO, YDPPED, YDPCTC, YDJCTY, YDEFTB, YDEFTE, YDCKDT, YDAGDT, YDGLBA, YDCYGR, YDWHRW, YDBHRW, YDSHRW, YDMHRW, YDAHRW, YDOHRW, YDPPM1, YDPPM2, YDPPM3, YDPPM4, YDPPM5, YDPPM6, YDACCF, YDVER1, YDVER2, YDVER3, YDVER4, YDVER5, YDVER6, YDVER7, YDVER8, YDVER9, YDSEQC, YDNMAX, YDPPST, YDCKST, YDJEST, YDROST, YDFUST, YDYST1, YDYST2, YDYST3, YDICU, YDDNMN, YDPYDT, YDPCCT, YDPPMB, YDRNUM, YDPYMH, YDMANB, YDCCPR, YDDL02, YDADOF, YDMNAF, YDADRF, YDARST, YDPEF1, YDPEF2, YDPEF3, YDPEF4, YDPEF5, YDPCGT, YDCKPF, YDASF, YDCCUF, YDWCUF, YDADEF, YDADDT, YDADPC, YDADPO, YDGPOR, YDELCT, YDACUS, YDODBA, YDVICU, YDDTSP, YDUSER FROM F06210

TOP920 | 06 | F06210 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1YDPRIDPayroll IDNumericGeneric Edit50 Allow NULL? 
2YDVERSVersion HistoryStringGeneric Edit100 Allow NULL? 
3YDPCCDPay Cycle CodeStringUDC (06 PY)50 Allow NULL? 
4YDDTEYDate - YRNumericGeneric Edit20 Allow NULL? 
5YDCOCompanyStringGeneric Edit50 Allow NULL? 
6YDPPEDDate - Pay Period EndingDateGeneric Edit60
7YDPCTCPay Categories/DBA Print GroupCharacterUDC (06 ST)10 Allow NULL? 
8YDJCTYPayroll Expense TypeCharacterUDC (07 PJ)10 Allow NULL? 
9YDEFTBDate - Beginning EffectiveDateGeneric Edit60
10YDEFTEDate - Ending EffectiveDateGeneric Edit60
11YDCKDTDate - Pay CheckDateGeneric Edit60
12YDAGDTDate - Payroll JournalsDateGeneric Edit60
13YDGLBAG/L Bank AccountStringGeneric Edit80 Allow NULL? 
14YDCYGRPay Cycle Group CodeStringUDC (06 PG)20 Allow NULL? 
15YDWHRWStandard Hours-WeeklyNumericGeneric Edit92 Allow NULL? 
16YDBHRWStandard Hours-BiweeklyNumericGeneric Edit92 Allow NULL? 
17YDSHRWStandard Hours-SemiNumericGeneric Edit92 Allow NULL? 
18YDMHRWStandard Hours-MonthlyNumericGeneric Edit92 Allow NULL? 
19YDAHRWStandard Hours-AnnuallyNumericGeneric Edit92 Allow NULL? 
20YDOHRWStandard Hours-OtherNumericGeneric Edit92 Allow NULL? 
21YDPPM1Pay Period Number - WeeklyCharacterUDC (05 PN)10 Allow NULL? 
22YDPPM2Pay Period Number - BiweeklyCharacterUDC (05 PN)10 Allow NULL? 
23YDPPM3Pay Period Number - SemimonthlyCharacterUDC (05 PN)10 Allow NULL? 
24YDPPM4Pay Period Number - MonthlyCharacterUDC (05 PN)10 Allow NULL? 
25YDPPM5Pay Period Number - AnnuallyCharacterUDC (05 PN)10 Allow NULL? 
26YDPPM6Pay Period Number - OtherCharacterUDC (05 PN)10 Allow NULL? 
27YDACCFRate - Accrual FactorNumericGeneric Edit94 Allow NULL? 
28YDVER1Version 1StringGeneric Edit100 Allow NULL? 
29YDVER2Version 2StringGeneric Edit100 Allow NULL? 
30YDVER3Version 3StringGeneric Edit100 Allow NULL? 
31YDVER4Version 4StringGeneric Edit100 Allow NULL? 
32YDVER5Version 5StringGeneric Edit100 Allow NULL? 
33YDVER6Fiscal & Anniv. RolloverStringGeneric Edit100 Allow NULL? 
34YDVER7Version 7StringGeneric Edit100 Allow NULL? 
35YDVER8Version 8StringGeneric Edit100 Allow NULL? 
36YDVER9Payroll Voucher Batch 2StringGeneric Edit100 Allow NULL? 
37YDSEQCSequence CodeCharacterUDC (07 SR)10 Allow NULL? 
38YDNMAXAmount - Maximum Net PayNumericGeneric Edit152 Allow NULL? 
39YDPPSTStatus - Pre payroll ProcessingCharacterUDC (07 PP)10 Allow NULL? 
40YDCKSTStatus - Print Payroll ChecksCharacterUDC (07 CK)10 Allow NULL? 
41YDJESTStatus - Payroll Journal EntriesCharacterUDC (07 JE)10 Allow NULL? 
42YDROSTStatus - Reports OnlyCharacterUDC10 Allow NULL? 
43YDFUSTStatus - Final UpdateCharacterUDC (07 FV)10 Allow NULL? 
44YDYST1Status- Payroll 01CharacterUDC (07 YS)10 Allow NULL? 
45YDYST2Status- Payroll 02CharacterUDC10 Allow NULL? 
46YDYST3Status- Payroll 03CharacterUDC10 Allow NULL? 
47YDICUBatch NumberNumericGeneric Edit80 Allow NULL? 
48YDDNMNDenomination MinimumNumericGeneric Edit72 Allow NULL? 
49YDPYDTDate - Pay Cycle ProcessedDateGeneric Edit60
50YDPCCTPay Cycle CountNumericGeneric Edit20 Allow NULL? 
51YDPPMBPay Period NumberCharacterUDC (05 YB)10 Allow NULL? 
52YDRNUMNumber of Reports to RunNumericGeneric Edit30 Allow NULL? 
53YDPYMHMethod - Employee PaymentCharacterUDC10 Allow NULL? 
54YDMANBMandatory Benefit FlagCharacterUDC (05 YN)10 Allow NULL? 
55YDCCPRCountry CodeStringUDC (00 CN)30 Allow NULL? 
56YDDL02Description 02StringGeneric Edit300 Allow NULL? 
57YDADOFAuto Deposit Override FlagCharacterUDC (05 YN)10 Allow NULL? 
58YDMNAFMinimum Check Adjustment FlagCharacterUDC10 Allow NULL? 
59YDADRFAuto Deposit Reconcilation FlagCharacterUDC (05 YN)10 Allow NULL? 
60YDARSTWage Attachment Invoice DateCharacterUDC (07 WI)10 Allow NULL? 
61YDPEF1Execution Flag 1CharacterGeneric Edit10 Allow NULL? 
62YDPEF2Execution Flag 2CharacterGeneric Edit10 Allow NULL? 
63YDPEF3Execution Flag 3CharacterGeneric Edit10 Allow NULL? 
64YDPEF4Execution Flag 4CharacterGeneric Edit10 Allow NULL? 
65YDPEF5Execution Flag 5CharacterGeneric Edit10 Allow NULL? 
66YDPCGTPay Cycle Group TypeCharacterUDC (07 PH)10 Allow NULL? 
67YDCKPFCheck Stock Processing FlagCharacterUDC (05 YN)10 Allow NULL? 
68YDASFAccelerated Submission FlagCharacterUDC (05 YN)10 Allow NULL? 
69YDCCUFStep Progression AutomationCharacterUDC (07 JP)10 Allow NULL? 
70YDWCUFWorkers Comp. Update FlagCharacterUDC (05 YN)10 Allow NULL? 
71YDADEFStatus - Auto Deposit ProcessingCharacterUDC10 Allow NULL? 
72YDADDTDate - Auto DepositDateGeneric Edit60
73YDADPCType Process - Auto DepositCharacterGeneric Edit10 Allow NULL? 
74YDADPOPre-Note Option CodeCharacterUDC (05 YN)10 Allow NULL? 
75YDGPORCode - Group Plan OverrideCharacterUDC (05 YN)10 Allow NULL? 
76YDELCTCode - Employee Lockout ControlCharacterUDC (05 YN)10 Allow NULL? 
77YDACUSActive UsersNumericGeneric Edit30 Allow NULL? 
78YDODBAOptional DBA Processing FlagCharacterUDC (05 YN)10 Allow NULL? 
79YDVICUPayroll Voucher Batch NumberNumericGeneric Edit80 Allow NULL? 
80YDDTSPDate - Time StampNumericGeneric Edit130 Allow NULL? 
81YDUSERUser IDStringGeneric Edit100 Allow NULL? 

TOP920 | 06 | F06210 INDEXES

NumberDescription
1Payroll ID (Primary/Unique)
ElementAliasDescriptionSequence
1PRIDPayroll IDAscending
2Batch Number
ElementAliasDescriptionSequence
1ICUBatch NumberAscending
3Versions
ElementAliasDescriptionSequence
1VERSVersion HistoryAscending