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

135 COLUMNS | 10 INDEXES | Print definition?920 | 05 | F069116 TABLE

05: Time Accounting and HRM Base
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F069116YC13510Payroll Transaction ConstantsConstants Files07: 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 YCANN8, YCEXA, YCDC, YCPGRP, YCPAYG, YCPAYN, YCDTAB, YCSPW2, YCPB, YCDESQ, YCMV, YCDISO, YCPDBA, YCPCK, YCDEDM, YCUM, YCRTAM, YCPAYM, YCSHD, YCCMTH, YCPPDL, YCMDL, YCADL, YCPPPL, YCNP, YCAD, YCACO, YCAI, YCHMIN, YCHMAX, YCIIAP, YCDEP1, YCDEP2, YCDEP3, YCDEP4, YCDEP5, YCDEP6, YCTT01, YCTT02, YCTT03, YCTT04, YCTT05, YCTT06, YCTT07, YCTT08, YCTT09, YCTT10, YCTT11, YCTT12, YCTT13, YCTT14, YCTT15, YCNMTH, YCPDED, YCDPRI, YCDGRP, YCDBAL, YCARRR, YCNPER, YCSVCD, YCQDL, YCSVH, YCAAF, YCPTCT, YCCPE, YCEFTB, YCEFTE, YCACEQ, YCSADL, YCSDED, YCAMTS, YCPR01, YCPR02, YCPR03, YCPR04, YCPR05, YCTASF, YCTRPF, YCSALY, YCCOVA, YCTRID, YCTYST, YCBENF, YCPPPM, YCEPRI, YCPTER, YCSTAB, YCCMAX, YCRTAB, YCTARA, YCHMCO, YCPGM1, YCPGM2, YCTDBA, YCCMHU, YCBDT, YCDBAS, YCUDBA, YCAIGR, YCPR06, YCPR07, YCPR08, YCPR09, YCPR10, YCPR11, YCPR12, YCPR13, YCPR14, YCUSER, YCPR15, YCPID, YCPR16, YCUPMJ, YCPR17, YCPR18, YCPR19, YCPR20, YCODBA, YCSACC, YCCALC, YCPPRY, YCGVCH, YCPRTX, YCF415, YCCLCI, YCRYTP, YCAFDT, YCSHDL, YCCHCK, YCLVPT, YCPHISH, YCLPRX, YCDEFR, YCBPPF, YCOFFE FROM F069116

TOP920 | 05 | F069116 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1YCANN8Address Number-Provider/TrusteeNumericGeneric Edit80 Allow NULL? 
2YCEXAName - Alpha ExplanationStringGeneric Edit300 Allow NULL? 
3YCDCDescription - CompressedStringGeneric Edit400 Allow NULL? 
4YCPGRPDeduct/Benefit Override CodeStringGeneric Edit20 Allow NULL? 
5YCPAYGEffect on Gross PayCharacterUDC (07 PA)10 Allow NULL? 
6YCPAYNEffect on Net PayCharacterUDC (07 PA)10 Allow NULL? 
7YCDTABTable CodeStringGeneric Edit50 Allow NULL? 
8YCSPW2W-2 IRS Defined CodeStringUDC (06 S2)20 Allow NULL? 
9YCPBSource of PayCharacterUDC (06 PB)10 Allow NULL? 
10YCDESQSource of CalculationCharacterUDC (06 DB)10 Allow NULL? 
11YCMVEffect on Disposable WageCharacterUDC (05A MV)10 Allow NULL? 
12YCDISODBA TypeCharacterUDC (05 DI)10 Allow NULL? 
13YCPDBADBA CodeNumericGeneric Edit50 Allow NULL? 
14YCPCKMethod of PrintingCharacterUDC (05A PT)10 Allow NULL? 
15YCDEDMMethod of CalculationCharacterUDC (06 DM)10 Allow NULL? 
16YCUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
17YCRTAMAmount or RateNumericGeneric Edit94 Allow NULL? 
18YCPAYMMultiplier - Pay Type MultiplierNumericGeneric Edit52 Allow NULL? 
19YCSHDAmount - Shift DifferentialNumericGeneric Edit93 Allow NULL? 
20YCCMTHShift Diff Calc SequenceCharacterUDC (07 CO)10 Allow NULL? 
21YCPPDLPay Period LimitNumericGeneric Edit152 Allow NULL? 
22YCMDLMonthly LimitNumericGeneric Edit152 Allow NULL? 
23YCADLAnnual LimitNumericGeneric Edit152 Allow NULL? 
24YCPPPLLimit on Pay Period PercentNumericGeneric Edit154 Allow NULL? 
25YCNPNumber of Deduction PeriodsNumericGeneric Edit40 Allow NULL? 
26YCADAmount - DueNumericGeneric Edit152 Allow NULL? 
27YCACOAvailable DBACharacterGeneric Edit10 Allow NULL? 
28YCAIType - SalesCharacterUDC10 Allow NULL? 
29YCHMINHours - MinimumNumericGeneric Edit152 Allow NULL? 
30YCHMAXHours - MaximumNumericGeneric Edit152 Allow NULL? 
31YCIIAPAuto Pay MethodsCharacterUDC (07 II)10 Allow NULL? 
32YCDEP1Deduction Period 1CharacterUDC (05A DD)10 Allow NULL? 
33YCDEP2Deduction Period 2CharacterUDC (05A DD)10 Allow NULL? 
34YCDEP3Deduction Period 3CharacterUDC (05A DD)10 Allow NULL? 
35YCDEP4Deduction Period 4CharacterUDC (05A DD)10 Allow NULL? 
36YCDEP5Deduction Period 5CharacterUDC (05A DD)10 Allow NULL? 
37YCDEP6Deduction Period 6CharacterUDC (05A DD)10 Allow NULL? 
38YCTT01Non-Taxable Authority Types 01StringUDC (06 TX)20 Allow NULL? 
39YCTT02Non-Taxable Authority Types 02StringUDC (06 TX)20 Allow NULL? 
40YCTT03Non-Taxable Authority Types 03StringUDC (06 TX)20 Allow NULL? 
41YCTT04Non-Taxable Authority Types 04StringUDC (06 TX)20 Allow NULL? 
42YCTT05Non-Taxable Authority Types 05StringUDC (06 TX)20 Allow NULL? 
43YCTT06Non-Taxable Authority Types 06StringUDC (06 TX)20 Allow NULL? 
44YCTT07Non-Taxable Authority Types 07StringUDC (06 TX)20 Allow NULL? 
45YCTT08Non-Taxable Authority Types 08StringUDC (06 TX)20 Allow NULL? 
46YCTT09Non-Taxable Authority Types 09StringUDC (06 TX)20 Allow NULL? 
47YCTT10Non-Taxable Authority Types 10StringUDC (06 TX)20 Allow NULL? 
48YCTT11Non-Taxable Authority Types 11StringUDC (06 TX)20 Allow NULL? 
49YCTT12Non-Taxable Authority Types 12StringUDC (06 TX)20 Allow NULL? 
50YCTT13Non-Taxable Authority Types 13StringUDC (06 TX)20 Allow NULL? 
51YCTT14Non-Taxable Authority Types 14StringUDC (06 TX)20 Allow NULL? 
52YCTT15Non-Taxable Authority Types 15StringUDC (06 TX)20 Allow NULL? 
53YCNMTHEffect on GLCharacterUDC10 Allow NULL? 
54YCPDEDDBA For Prior LimitNumericGeneric Edit50 Allow NULL? 
55YCDPRIOrder To Adjust DedNumericGeneric Edit50 Allow NULL? 
56YCDGRPGroup Limit CodeStringUDC (06 GR)20 Allow NULL? 
57YCDBALDeclining Balance (Y N)CharacterGeneric Edit10 Allow NULL? 
58YCARRRArrearage MethodCharacterUDC (05A AR)10 Allow NULL? 
59YCNPERNumber of Deduction PeriodsCharacterGeneric Edit10 Allow NULL? 
60YCSVCDDate - ServiceDateGeneric Edit60
61YCQDLQuarterly LimitNumericGeneric Edit152 Allow NULL? 
62YCSVHBenefit/Accrual TypeCharacterUDC (06 SV)10 Allow NULL? 
63YCAAFVacation FactorCharacterUDC (07 AA)10 Allow NULL? 
64YCPTCTPay Type CategoryCharacterUDC (06 PC)10 Allow NULL? 
65YCCPECOBRA PlanNumericGeneric Edit50 Allow NULL? 
66YCEFTBDate - Beginning EffectiveDateGeneric Edit60
67YCEFTEDate - Ending EffectiveDateGeneric Edit60
68YCACEQAccrual EquivalentNumericGeneric Edit50 Allow NULL? 
69YCSADLAnnual Limit (Level 2)NumericGeneric Edit152 Allow NULL? 
70YCSDEDDeduction Number - SubsequentNumericGeneric Edit50 Allow NULL? 
71YCAMTSAmount or Rate - SecondaryNumericGeneric Edit154 Allow NULL? 
72YCPR01Report Codes - P/R Transaction 01StringUDC (06 T1)30 Allow NULL? 
73YCPR02Report Codes - P/R Transaction 02StringUDC (06 T2)30 Allow NULL? 
74YCPR03Report Codes - P/R Transaction 03StringUDC (06 T3)30 Allow NULL? 
75YCPR04Report Codes - P/R Transaction 04StringUDC (06 T4)30 Allow NULL? 
76YCPR05Report Codes - P/R Transaction 05StringUDC (06 T5)30 Allow NULL? 
77YCTASFLimit MethodCharacterUDC (07 TL)10 Allow NULL? 
78YCTRPFCalc For All Emp (Y N)CharacterUDC (05 YN)10 Allow NULL? 
79YCSALYPay Class (H/S/P)CharacterUDC (05A PK)10 Allow NULL? 
80YCCOVAAmount - CoverageNumericGeneric Edit152 Allow NULL? 
81YCTRIDTrans. Code - IdentifierStringGeneric Edit20 Allow NULL? 
82YCTYSTTrans. Code - Status CodeCharacterUDC (05 YN)10 Allow NULL? 
83YCBENFTrans. Code - Beneficiary FlagCharacterUDC (08 DC)10 Allow NULL? 
84YCPPPMLimit on Pay Period Percent - MinimumNumericGeneric Edit154 Allow NULL? 
85YCEPRIWhen To Adjust DedCharacterUDC (05A EP)10 Allow NULL? 
86YCPTERCanadian EI Allocation FlagCharacterCheck Box10 Allow NULL? 
87YCSTABBenefit/Deduction Table - SecondaryStringGeneric Edit50 Allow NULL? 
88YCCMAXInception to Date LimitNumericGeneric Edit92 Allow NULL? 
89YCRTABRollover TableStringGeneric Edit50 Allow NULL? 
90YCTARATax Area (Work)StringGeneric Edit100 Allow NULL? 
91YCHMCOCompany - HomeStringGeneric Edit50 Allow NULL? 
92YCPGM1Pgm Call 1StringGeneric Edit100 Allow NULL? 
93YCPGM2Pgm Call 2StringGeneric Edit100 Allow NULL? 
94YCTDBACode - Tax Area DeductionCharacterUDC (05 YN)10 Allow NULL? 
95YCCMHUCalendar Month MethodCharacterUDC (52 YN)10 Allow NULL? 
96YCBDTBased FromStringUDC (06 DT)40 Allow NULL? 
97YCDBASCalc Once Per PeriodCharacterUDC (05 YN)10 Allow NULL? 
98YCUDBAInclude in Union Plan (Y N)CharacterUDC (05 YN)10 Allow NULL? 
99YCAIGRInvestment Group CodesCharacterUDC (06 AI)10 Allow NULL? 
100YCPR06Report Codes - P/R Transaction 06StringUDC (06 T6)30 Allow NULL? 
101YCPR07Report Codes - P/R Transaction 07StringUDC (06 T7)30 Allow NULL? 
102YCPR08Report Codes - P/R Transaction 08StringUDC (06 T8)30 Allow NULL? 
103YCPR09Report Codes - P/R Transaction 09StringUDC (06 T9)30 Allow NULL? 
104YCPR10Report Codes - P/R Transaction 10StringUDC (06 T0)30 Allow NULL? 
105YCPR11Report Codes - P/R Transaction 11StringUDC (06 11)30 Allow NULL? 
106YCPR12Report Codes - P/R Transaction 12StringUDC (06 12)30 Allow NULL? 
107YCPR13Report Codes - P/R Transaction 13StringUDC (06 13)30 Allow NULL? 
108YCPR14Report Codes - P/R Transaction 14StringUDC (06 14)30 Allow NULL? 
109YCUSERUser IDStringGeneric Edit100 Allow NULL? 
110YCPR15Report Codes - P/R Transaction 15StringUDC (06 15)30 Allow NULL? 
111YCPIDProgram IDStringGeneric Edit100 Allow NULL? 
112YCPR16Report Codes - P/R Transaction 16StringUDC (06 16)30 Allow NULL? 
113YCUPMJDate - UpdatedDateGeneric Edit60
114YCPR17Report Codes - P/R Transaction 17StringUDC (06 17)30 Allow NULL? 
115YCPR18Report Codes - P/R Transaction 18StringUDC (06 18)30 Allow NULL? 
116YCPR19Report Codes - P/R Transaction 19StringUDC (06 19)30 Allow NULL? 
117YCPR20Report Codes - P/R Transaction 20StringUDC (06 20)30 Allow NULL? 
118YCODBAOptional DBA Processing FlagCharacterUDC (05 YN)10 Allow NULL? 
119YCSACCSpending Account TypeStringUDC (06 FS)30 Allow NULL? 
120YCCALCCalculate If No Gross (Y N)CharacterUDC (05 YN)10 Allow NULL? 
121YCPPRYCalc in Pre-Payroll (Y N)CharacterUDC (05 YN)10 Allow NULL? 
122YCGVCHA/P Voucher (Y N)CharacterUDC (05 YB)10 Allow NULL? 
123YCPRTXPre-Tax DeductionStringUDC (06 4K)30 Allow NULL? 
124YCF415415 Testing CodeStringUDC (06 F4)30 Allow NULL? 
125YCCLCICalculate During Interim ProcessingCharacterUDC (05 YN)10 Allow NULL? 
126YCRYTPType of Rollover YearCharacterGeneric Edit10 Allow NULL? 
127YCAFDTAnniversary Fiscal Beginning DateStringUDC (06 AF)40 Allow NULL? 
128YCSHDLW2 Special Handling DescriptionStringGeneric Edit40 Allow NULL? 
129YCCHCKEffect on CheckCharacterUDC (05A CK)10 Allow NULL? 
130YCLVPTLeave Pay TypeCharacterGeneric Edit10 Allow NULL? 
131YCPHISHRetrieve PDBA History Single FlagCharacterUDC (07 M3)10 Allow NULL? 
132YCLPRXAnniversary Proration RuleCharacterGeneric Edit10 Allow NULL? 
133YCDEFRDate Effective Rate ControlCharacterUDC (07 RN)10 Allow NULL? 
134YCBPPFBase Pay FlagCharacterGeneric Edit10 Allow NULL? 
135YCOFFEAllow For Future EntryCharacterUDC (05T FE)10 Allow NULL? 

TOP920 | 05 | F069116 INDEXES

NumberDescription
1Pay Type Ded. Ben. Accrual (Primary/Unique)
ElementAliasDescriptionSequence
1PDBADBA CodeAscending
2PDBA PDBA Type
ElementAliasDescriptionSequence
1PDBADBA CodeAscending
2DISODBA TypeAscending
3Descr. Compressed PDBA Type
ElementAliasDescriptionSequence
1DCDescription - CompressedAscending
2DISODBA TypeAscending
3PDBADBA CodeAscending
4PDBA Type PDBA
ElementAliasDescriptionSequence
1DISODBA TypeAscending
2PDBADBA CodeAscending
5Sick and Vacation PDBA
ElementAliasDescriptionSequence
1SVHBenefit/Accrual TypeAscending
2PDBADBA CodeAscending
6Calc for All emp. PDBA
ElementAliasDescriptionSequence
1TRPFCalc For All Emp (Y N)Ascending
2PDBADBA CodeAscending
7Deduction Group
ElementAliasDescriptionSequence
1DGRPGroup Limit CodeAscending
8415 Testing
ElementAliasDescriptionSequence
1F415415 Testing CodeAscending
9TransactionTypePay
ElementAliasDescriptionSequence
1DISODBA TypeAscending
10W2 Spec Handling
ElementAliasDescriptionSequence
1SHDLW2 Special Handling DescriptionAscending