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

105 COLUMNS | 8 INDEXES | Print definition?920 | 05 | F06106 TABLE

05: Time Accounting and HRM Base
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F06106YM1058Employee Pay InstructionsSecondary Master Files05: Time Accounting and HRM BaseBusiness 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 YMAN8, YMEXR, YMPDBA, YMDISO, YMPGRP, YMPSDT, YMPTDT, YMSFLG, YMDTAB, YMPB, YMDESQ, YMSHFT, YMAM, YMMCU, YMOBJ, YMSUB, YMSBL, YMTARA, YMWCMP, YMLMTH, YMLF, YMPHRW, YMPCUN, YMUM, YMPHRT, YMPPRT, YMBHRT, YMPBRT, YMBDRT, YMB2RT, YMRBOB, YMRBO2, YMRTAM, YMPAYM, YMSHD, YMCMTH, YMGPA, YMPPDL, YMMDL, YMADL, YMPPPL, YMNP, YMAD, YMAI, YMLD, YMSEC$, YMANN8, YMDEP1, YMDEP2, YMDEP3, YMDEP4, YMDEP5, YMDEP6, YMP001, YMP002, YMP003, YMP004, YMJBCD, YMJBST, YMHMIN, YMHMAX, YMWET, YMEQCG, YMEQHR, YMERC, YMQOBJ, YMEQRT, YMPDED, YMDGRP, YMDPRI, YMARRR, YMQDL, YMDW, YMPRTR, YMSBLT, YMAAF, YMDAAF, YMACEQ, YMALHR, YMUN, YMAMTS, YMSADL, YMWR01, YMCOVA, YMZOVR, YMCMAX, YMUAMT, YMAR1Y, YMARSY, YMRTAB, YMCTAB, YMRCCD, YMPCNO, YMODBA, YMUDBA, YMGVCH, YMPLAN, YMAOPT, YMUSER, YMPID, YMUPMJ, YMPOS, YMHMCU, YMTSKID, YMDEFR FROM F06106

TOP920 | 05 | F06106 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1YMAN8Address NumberNumericGeneric Edit80 Allow NULL? 
2YMEXRName - Remark ExplanationStringGeneric Edit300 Allow NULL? 
3YMPDBADBA CodeNumericGeneric Edit50 Allow NULL? 
4YMDISODBA TypeCharacterUDC (05 DI)10 Allow NULL? 
5YMPGRPDeduct/Benefit Override CodeStringGeneric Edit20 Allow NULL? 
6YMPSDTDate - Pay StartsDateGeneric Edit60
7YMPTDTDate - Pay StopsDateGeneric Edit60
8YMSFLGVoid Flag (Y/N)CharacterGeneric Edit10 Allow NULL? 
9YMDTABTable CodeStringGeneric Edit50 Allow NULL? 
10YMPBSource of PayCharacterUDC (06 PB)10 Allow NULL? 
11YMDESQSource of CalculationCharacterUDC (06 DB)10 Allow NULL? 
12YMSHFTShift CodeCharacterUDC (06 SH)10 Allow NULL? 
13YMAMAccount Mode - G/LCharacterUDC (H09 AM)10 Allow NULL? 
14YMMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
15YMOBJObject AccountStringGeneric Edit60 Allow NULL? 
16YMSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
17YMSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
18YMTARATax Area (Work)StringGeneric Edit100 Allow NULL? 
19YMWCMPWorker's Comp. Insurance CodeStringUDC (00 W)40 Allow NULL? 
20YMLMTHLabor Distribution MethodCharacterUDC (07 LT)10 Allow NULL? 
21YMLFLabor Distribution MultiplierNumericGeneric Edit54 Allow NULL? 
22YMPHRWHours WorkedNumericGeneric Edit92 Allow NULL? 
23YMPCUNUnits - PiecesNumericGeneric Edit92 Allow NULL? 
24YMUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
25YMPHRTRate - HourlyNumericGeneric Edit93 Allow NULL? 
26YMPPRTRate - PieceworkNumericGeneric Edit93 Allow NULL? 
27YMBHRTRate - Base HourlyNumericGeneric Edit93 Allow NULL? 
28YMPBRTRate - Distribution (or Billing)NumericGeneric Edit93 Allow NULL? 
29YMBDRTRate - Recharge BurdenNumericGeneric Edit93 Allow NULL? 
30YMB2RTRate - BurdenNumericGeneric Edit93 Allow NULL? 
31YMRBOBBurden Obj. Account - RechargeStringGeneric Edit60 Allow NULL? 
32YMRBO2Burden Obj. Account - Recharge 2StringGeneric Edit60 Allow NULL? 
33YMRTAMAmount or RateNumericGeneric Edit94 Allow NULL? 
34YMPAYMMultiplier - Pay Type MultiplierNumericGeneric Edit52 Allow NULL? 
35YMSHDAmount - Shift DifferentialNumericGeneric Edit93 Allow NULL? 
36YMCMTHShift Diff Calc SequenceCharacterUDC (07 CO)10 Allow NULL? 
37YMGPAAmount - Gross PayNumericGeneric Edit92 Allow NULL? 
38YMPPDLPay Period LimitNumericGeneric Edit152 Allow NULL? 
39YMMDLMonthly LimitNumericGeneric Edit152 Allow NULL? 
40YMADLAnnual LimitNumericGeneric Edit152 Allow NULL? 
41YMPPPLLimit on Pay Period PercentNumericGeneric Edit154 Allow NULL? 
42YMNPNumber of Deduction PeriodsNumericGeneric Edit40 Allow NULL? 
43YMADAmount - DueNumericGeneric Edit152 Allow NULL? 
44YMAIType - SalesCharacterUDC10 Allow NULL? 
45YMLDPercent or AmountCharacterUDC (07 LD)10 Allow NULL? 
46YMSEC$Security IndicatorCharacterGeneric Edit10 Allow NULL? 
47YMANN8Address Number-Provider/TrusteeNumericGeneric Edit80 Allow NULL? 
48YMDEP1Deduction Period 1CharacterUDC (05A DD)10 Allow NULL? 
49YMDEP2Deduction Period 2CharacterUDC (05A DD)10 Allow NULL? 
50YMDEP3Deduction Period 3CharacterUDC (05A DD)10 Allow NULL? 
51YMDEP4Deduction Period 4CharacterUDC (05A DD)10 Allow NULL? 
52YMDEP5Deduction Period 5CharacterUDC (05A DD)10 Allow NULL? 
53YMDEP6Deduction Period 6CharacterUDC (05A DD)10 Allow NULL? 
54YMP001Category Codes - Payroll1StringUDC (06 01)30 Allow NULL? 
55YMP002Category Codes - Payroll2StringUDC (06 02)30 Allow NULL? 
56YMP003Category Codes - Payroll3StringUDC (06 03)30 Allow NULL? 
57YMP004Category Codes - Payroll4StringUDC (06 04)30 Allow NULL? 
58YMJBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
59YMJBSTJob StepStringUDC (06 GS)40 Allow NULL? 
60YMHMINHours - MinimumNumericGeneric Edit152 Allow NULL? 
61YMHMAXHours - MaximumNumericGeneric Edit152 Allow NULL? 
62YMWETSub Class - Workers CompCharacterUDC (07 WH)10 Allow NULL? 
63YMEQCGEquipment WorkedStringGeneric Edit90 Allow NULL? 
64YMEQHRHours - EquipmentNumericGeneric Edit92 Allow NULL? 
65YMERCEquipment Rate CodeStringUDC (00 RC)20 Allow NULL? 
66YMQOBJEquipment Object AccountStringGeneric Edit60 Allow NULL? 
67YMEQRTBilling Rate - EquipmentNumericGeneric Edit92 Allow NULL? 
68YMPDEDDBA For Prior LimitNumericGeneric Edit50 Allow NULL? 
69YMDGRPGroup Limit CodeStringUDC (06 GR)20 Allow NULL? 
70YMDPRIOrder To Adjust DedNumericGeneric Edit50 Allow NULL? 
71YMARRRArrearage MethodCharacterUDC (05A AR)10 Allow NULL? 
72YMQDLQuarterly LimitNumericGeneric Edit152 Allow NULL? 
73YMDWDay of the WeekCharacterUDC (06 DW)10 Allow NULL? 
74YMPRTRTransaction No. - PayrollNumericGeneric Edit90 Allow NULL? 
75YMSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
76YMAAFVacation FactorCharacterUDC (07 AA)10 Allow NULL? 
77YMDAAFDeduction FactorCharacterUDC10 Allow NULL? 
78YMACEQAccrual EquivalentNumericGeneric Edit50 Allow NULL? 
79YMALHRHours Worked - Annual LeaveNumericGeneric Edit72 Allow NULL? 
80YMUNUnion CodeStringUDC (06 UN)60 Allow NULL? 
81YMAMTSAmount or Rate - SecondaryNumericGeneric Edit154 Allow NULL? 
82YMSADLAnnual Limit (Level 2)NumericGeneric Edit152 Allow NULL? 
83YMWR01Categories - Work Order 01StringUDC (00 W1)40 Allow NULL? 
84YMCOVAAmount - CoverageNumericGeneric Edit152 Allow NULL? 
85YMZOVROverride FlagCharacterUDC (05 YB)10 Allow NULL? 
86YMCMAXInception to Date LimitNumericGeneric Edit92 Allow NULL? 
87YMUAMTAmount - UprateNumericGeneric Edit93 Allow NULL? 
88YMAR1YAccrual Rollover - First YearCharacterUDC (07 AU)10 Allow NULL? 
89YMARSYAccrual Rollover - Subsequent YearsCharacterUDC10 Allow NULL? 
90YMRTABRollover TableStringGeneric Edit50 Allow NULL? 
91YMCTABRollover Table -Subsequent YearStringGeneric Edit50 Allow NULL? 
92YMRCCDRecord TypeCharacterUDC (07 RC)10 Allow NULL? 
93YMPCNOPayroll Control NumberNumericGeneric Edit80 Allow NULL? 
94YMODBAOptional DBA Processing FlagCharacterUDC (05 YN)10 Allow NULL? 
95YMUDBAInclude in Union Plan (Y N)CharacterUDC (05 YN)10 Allow NULL? 
96YMGVCHA/P Voucher (Y N)CharacterUDC (05 YB)10 Allow NULL? 
97YMPLANPlan IDStringGeneric Edit80 Allow NULL? 
98YMAOPTPlan Additional OptionStringGeneric Edit30 Allow NULL? 
99YMUSERUser IDStringGeneric Edit100 Allow NULL? 
100YMPIDProgram IDStringGeneric Edit100 Allow NULL? 
101YMUPMJDate - UpdatedDateGeneric Edit60
102YMPOSPosition IDStringGeneric Edit80 Allow NULL? 
103YMHMCUBusiness Unit - HomeStringGeneric Edit120 Allow NULL? 
104YMTSKIDTask Unique Key IDNumericGeneric Edit150 Allow NULL? 
105YMDEFRDate Effective Rate ControlCharacterUDC (07 RN)10 Allow NULL? 

TOP920 | 05 | F06106 INDEXES

NumberDescription
1Address Number DBA Type +A (Primary/Unique)
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2PDBADBA CodeAscending
3PSDTDate - Pay StartsAscending
4PRTRTransaction No. - PayrollAscending
2Address Number PDBA Type +A
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2PDBADBA CodeAscending
3PRTRTransaction No. - PayrollAscending
3Address Number PDBA Type +B
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2PDBADBA CodeAscending
3DISODBA TypeAscending
5PDBA Type Address Number +A
ElementAliasDescriptionSequence
1PDBADBA CodeAscending
2AN8Address NumberAscending
3PSDTDate - Pay StartsAscending
6Address Number Order Adjst +A
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2DPRIOrder To Adjust DedAscending
3PDBADBA CodeAscending
8Address Number DBA Type +B
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2DISODBA TypeAscending
3HMCUBusiness Unit - HomeAscending
4JBCDJob Type (Craft) CodeAscending
5JBSTJob StepAscending
9Address Number PDBA Type +C
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2PDBADBA CodeAscending
3PTDTDate - Pay StopsAscending
10Address Number DBA Type +C
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2PDBADBA CodeAscending
3PSDTDate - Pay StartsAscending
4PTDTDate - Pay StopsAscending