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

93 COLUMNS | 2 INDEXES | Print definition?920 | 07 | F0729 TABLE

07: Payroll
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F0729Y9932Employee DBA Override InstructionsFiles07: PayrollBusiness 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 Y9AN8, Y9CKCN, Y9DLVL, Y9PDBA, Y9WANO, Y9TSKID, Y9PRTR, Y9EXA, Y9DISO, Y9DEDM, Y9ODDM, Y9DTAB, Y9DESQ, Y9SALY, Y9CMHU, Y9PRTX, Y9PB, Y9PAYM, Y9SVH, Y9DBAL, Y9RTAM, Y9ORTM, Y9PCUN, Y9PAYG, Y9PAYN, Y9PCK, Y9MV, Y9CALC, Y9EPRI, Y9NP, Y9PTCT, Y9PSDT, Y9PTDT, Y9EFTB, Y9EFTE, Y9PPRY, Y9PPDL, Y9MDL, Y9QDL, Y9ADL, Y9SADL, Y9AMTS, Y9PPPL, Y9DGRP, Y9HMIN, Y9HMAX, Y9ANN8, Y9DPRI, Y9PDED, Y9ARRR, Y9ARRA, Y9DEP1, Y9DEP2, Y9DEP3, Y9DEP4, Y9DEP5, Y9DEP6, Y9GVCH, Y9ZOVR, Y9DBAS, Y9HMCO, Y9DC, Y9TARA, Y9TDBA, Y9CMAX, Y9SACC, Y9UDBA, Y9NPER, Y9UN, Y9MCU, Y9JBCD, Y9JBST, Y9TT01, Y9TT02, Y9TT03, Y9TT04, Y9TT05, Y9TT06, Y9TT07, Y9TT08, Y9TT09, Y9TT10, Y9TT11, Y9TT12, Y9TT13, Y9TT14, Y9TT15, Y9UPMJ, Y9UPMT, Y9PID, Y9JOBN, Y9USER, Y9DEFR FROM F0729

TOP920 | 07 | F0729 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1Y9AN8Address NumberNumericGeneric Edit80 Allow NULL? 
2Y9CKCNCheck Control NumberNumericGeneric Edit80 Allow NULL? 
3Y9DLVLDBA Calculation LevelCharacterGeneric Edit10 Allow NULL? 
4Y9PDBADBA CodeNumericGeneric Edit50 Allow NULL? 
5Y9WANOWage Attach Control NumberNumericGeneric Edit80 Allow NULL? 
6Y9TSKIDTask Unique Key IDNumericGeneric Edit150 Allow NULL? 
7Y9PRTRTransaction No. - PayrollNumericGeneric Edit90 Allow NULL? 
8Y9EXAName - Alpha ExplanationStringGeneric Edit300 Allow NULL? 
9Y9DISODBA TypeCharacterUDC (05 DI)10 Allow NULL? 
10Y9DEDMMethod of CalculationCharacterUDC (06 DM)10 Allow NULL? 
11Y9ODDMOverride Method of CalculationCharacterUDC (06 DM)10 Allow NULL? 
12Y9DTABTable CodeStringGeneric Edit50 Allow NULL? 
13Y9DESQSource of CalculationCharacterUDC (06 DB)10 Allow NULL? 
14Y9SALYPay Class (H/S/P)CharacterUDC (05A PK)10 Allow NULL? 
15Y9CMHUCalendar Month MethodCharacterUDC (52 YN)10 Allow NULL? 
16Y9PRTXPre-Tax DeductionStringUDC (06 4K)30 Allow NULL? 
17Y9PBSource of PayCharacterUDC (06 PB)10 Allow NULL? 
18Y9PAYMMultiplier - Pay Type MultiplierNumericGeneric Edit52 Allow NULL? 
19Y9SVHBenefit/Accrual TypeCharacterUDC (06 SV)10 Allow NULL? 
20Y9DBALDeclining Balance (Y N)CharacterGeneric Edit10 Allow NULL? 
21Y9RTAMAmount or RateNumericGeneric Edit94 Allow NULL? 
22Y9ORTMOverride Amount or RateNumericGeneric Edit94 Allow NULL? 
23Y9PCUNUnits - PiecesNumericGeneric Edit92 Allow NULL? 
24Y9PAYGEffect on Gross PayCharacterUDC (07 PA)10 Allow NULL? 
25Y9PAYNEffect on Net PayCharacterUDC (07 PA)10 Allow NULL? 
26Y9PCKMethod of PrintingCharacterUDC (05A PT)10 Allow NULL? 
27Y9MVEffect on Disposable WageCharacterUDC (05A MV)10 Allow NULL? 
28Y9CALCCalculate If No Gross (Y N)CharacterUDC (05 YN)10 Allow NULL? 
29Y9EPRIWhen To Adjust DedCharacterUDC (05A EP)10 Allow NULL? 
30Y9NPNumber of Deduction PeriodsNumericGeneric Edit40 Allow NULL? 
31Y9PTCTPay Type CategoryCharacterUDC (06 PC)10 Allow NULL? 
32Y9PSDTDate - Pay StartsDateGeneric Edit60
33Y9PTDTDate - Pay StopsDateGeneric Edit60
34Y9EFTBDate - Beginning EffectiveDateGeneric Edit60
35Y9EFTEDate - Ending EffectiveDateGeneric Edit60
36Y9PPRYCalc in Pre-Payroll (Y N)CharacterUDC (05 YN)10 Allow NULL? 
37Y9PPDLPay Period LimitNumericGeneric Edit152 Allow NULL? 
38Y9MDLMonthly LimitNumericGeneric Edit152 Allow NULL? 
39Y9QDLQuarterly LimitNumericGeneric Edit152 Allow NULL? 
40Y9ADLAnnual LimitNumericGeneric Edit152 Allow NULL? 
41Y9SADLAnnual Limit (Level 2)NumericGeneric Edit152 Allow NULL? 
42Y9AMTSAmount or Rate - SecondaryNumericGeneric Edit154 Allow NULL? 
43Y9PPPLLimit on Pay Period PercentNumericGeneric Edit154 Allow NULL? 
44Y9DGRPGroup Limit CodeStringUDC (06 GR)20 Allow NULL? 
45Y9HMINHours - MinimumNumericGeneric Edit152 Allow NULL? 
46Y9HMAXHours - MaximumNumericGeneric Edit152 Allow NULL? 
47Y9ANN8Address Number-Provider/TrusteeNumericGeneric Edit80 Allow NULL? 
48Y9DPRIOrder To Adjust DedNumericGeneric Edit50 Allow NULL? 
49Y9PDEDDBA For Prior LimitNumericGeneric Edit50 Allow NULL? 
50Y9ARRRArrearage MethodCharacterUDC (05A AR)10 Allow NULL? 
51Y9ARRAAmount - ArrearageNumericGeneric Edit92 Allow NULL? 
52Y9DEP1Deduction Period 1CharacterUDC (05A DD)10 Allow NULL? 
53Y9DEP2Deduction Period 2CharacterUDC (05A DD)10 Allow NULL? 
54Y9DEP3Deduction Period 3CharacterUDC (05A DD)10 Allow NULL? 
55Y9DEP4Deduction Period 4CharacterUDC (05A DD)10 Allow NULL? 
56Y9DEP5Deduction Period 5CharacterUDC (05A DD)10 Allow NULL? 
57Y9DEP6Deduction Period 6CharacterUDC (05A DD)10 Allow NULL? 
58Y9GVCHA/P Voucher (Y N)CharacterUDC (05 YB)10 Allow NULL? 
59Y9ZOVROverride FlagCharacterUDC (05 YB)10 Allow NULL? 
60Y9DBASCalc Once Per PeriodCharacterUDC (05 YN)10 Allow NULL? 
61Y9HMCOCompany - HomeStringGeneric Edit50 Allow NULL? 
62Y9DCDescription - CompressedStringGeneric Edit400 Allow NULL? 
63Y9TARATax Area (Work)StringGeneric Edit100 Allow NULL? 
64Y9TDBACode - Tax Area DeductionCharacterUDC (05 YN)10 Allow NULL? 
65Y9CMAXInception to Date LimitNumericGeneric Edit92 Allow NULL? 
66Y9SACCSpending Account TypeStringUDC (06 FS)30 Allow NULL? 
67Y9UDBAInclude in Union Plan (Y N)CharacterUDC (05 YN)10 Allow NULL? 
68Y9NPERNumber of Deduction PeriodsCharacterGeneric Edit10 Allow NULL? 
69Y9UNUnion CodeStringUDC (06 UN)60 Allow NULL? 
70Y9MCUBusiness UnitStringGeneric Edit120 Allow NULL? 
71Y9JBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
72Y9JBSTJob StepStringUDC (06 GS)40 Allow NULL? 
73Y9TT01Non-Taxable Authority Types 01StringUDC (06 TX)20 Allow NULL? 
74Y9TT02Non-Taxable Authority Types 02StringUDC (06 TX)20 Allow NULL? 
75Y9TT03Non-Taxable Authority Types 03StringUDC (06 TX)20 Allow NULL? 
76Y9TT04Non-Taxable Authority Types 04StringUDC (06 TX)20 Allow NULL? 
77Y9TT05Non-Taxable Authority Types 05StringUDC (06 TX)20 Allow NULL? 
78Y9TT06Non-Taxable Authority Types 06StringUDC (06 TX)20 Allow NULL? 
79Y9TT07Non-Taxable Authority Types 07StringUDC (06 TX)20 Allow NULL? 
80Y9TT08Non-Taxable Authority Types 08StringUDC (06 TX)20 Allow NULL? 
81Y9TT09Non-Taxable Authority Types 09StringUDC (06 TX)20 Allow NULL? 
82Y9TT10Non-Taxable Authority Types 10StringUDC (06 TX)20 Allow NULL? 
83Y9TT11Non-Taxable Authority Types 11StringUDC (06 TX)20 Allow NULL? 
84Y9TT12Non-Taxable Authority Types 12StringUDC (06 TX)20 Allow NULL? 
85Y9TT13Non-Taxable Authority Types 13StringUDC (06 TX)20 Allow NULL? 
86Y9TT14Non-Taxable Authority Types 14StringUDC (06 TX)20 Allow NULL? 
87Y9TT15Non-Taxable Authority Types 15StringUDC (06 TX)20 Allow NULL? 
88Y9UPMJDate - UpdatedDateGeneric Edit60
89Y9UPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
90Y9PIDProgram IDStringGeneric Edit100 Allow NULL? 
91Y9JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
92Y9USERUser IDStringGeneric Edit100 Allow NULL? 
93Y9DEFRDate Effective Rate ControlCharacterUDC (07 RN)10 Allow NULL? 

TOP920 | 07 | F0729 INDEXES

NumberDescription
1EE Number Check Ctrl # +A (Primary/Unique)
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2CKCNCheck Control NumberAscending
3DLVLDBA Calculation LevelAscending
4PDBADBA CodeAscending
5WANOWage Attach Control NumberAscending
3Union Code MCU JBCD JBST
ElementAliasDescriptionSequence
1UNUnion CodeAscending
2MCUBusiness UnitAscending
3JBCDJob Type (Craft) CodeAscending
4JBSTJob StepAscending