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
75A: Australia - Reporting System Only
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F75A0010A01181Australian Employee Termination DetailsSecondary Master Files07: 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 A0AN8, A0DST, A0DT, A0OWTRS, A0TERTYP, A0SKLFLG, A0LSLFLG, A0ETPFLG, A0NTERPAY, A0PERNOT, A0STDGPAY, A0GRSSEV, A0INCAMT, A0COMYSER, A0REDUAMT, A0REDUTRH, A0TAXREDU, A0ULLHRS, A0ULLVAL, A0ALBHRS, A0ALBVAL, A0ALBTAX, A0USKHRS, A0USKVAL, A0URDOHR, A0URDOVL, A0BD1HRS, A0BD1VAL, A0BD1TAX, A0BD2HRS, A0BD2VAL, A0BD2TAX, A0BD3HRS, A0BD3VAL, A0BD3TAX, A0BD4HRS, A0BD4VAL, A0BD4TAX, A0PR83DAY, A0PT83DAY, A0PR83VAL, A0PT83VAL, A0ASSAMT, A0ROLAMT, A0ETPTAX, A0ETPPAY, A0PAYFLG, A0ATOFLG, A0RETDTE, A0INVCOMP, A0INVDAY, A0TAXFNO, A0ATTL, A0SRNM, A0GNNM, A0MDNM, A0ADD1, A0ADD2, A0CTY1, A0ADDS, A0ADDZ, A0CTR, A0DOB, A0PAYTYP, A0ROLNME, A0ROLAD1, A0ROLAD2, A0ROLCTY, A0ROLSTE, A0ROLPOST, A0ROLCTR, A0APD, A0SPANO01, A0SPANO02, A0SPANO03, A0SPAGR01, A0SPATX01, A0UPMJ, A0UPMT, A0PID, A0JOBN, A0ICU, A0CO, A0USER, A0CKDT, A0TRAM, A0PTPA, A0TGOL, A0TPLU, A0DTAM, A0PRAG, A0TRPA, A0PMTP, A0ORAM, A0NRAM, A0TRINVCMP, A0TPR83DAY, A0TPR83VAL, A0TPT83DAY, A0TPT83VAL, A0TRETPTAX, A0TRETPPAY, A0DNPI, A0SPADAUT1, A0SPADAUT2, A0SPADAUT3, A0SPADAUT4, A0SPAFAUT1, A0SPAFAUT2, A0SPAFAUT3, A0SPAFAUT4, A0SPASAUT1, A0SPASAUT2, A0SPASAUT3, A0SPANAUT1, A0SPANAUT2, A0SPANAUT3, A0SPANAUT4 FROM F75A0010

TOP910 | 75A | F75A0010 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1A0AN8Address NumberNumericUDC80 Allow NULL? 
2A0DSTDate StartedDateGeneric Edit60
3A0DTDate - TerminatedDateGeneric Edit60
4A0OWTRSChange ReasonStringUDC (06 T)30 Allow NULL? 
5A0TERTYPTermination TypeStringUDC (75 T1)30 Allow NULL? 
6A0SKLFLGPay out sick Leave FlagCharacterGeneric Edit10 Allow NULL? 
7A0LSLFLGInclude LSL FlagCharacterGeneric Edit10 Allow NULL? 
8A0ETPFLGETP Rollover FlagCharacterGeneric Edit10 Allow NULL? 
9A0NTERPAYNet Termination PayNumericGeneric Edit112 Allow NULL? 
10A0PERNOTPeriod of NoticeNumericGeneric Edit92 Allow NULL? 
11A0STDGPAYStandard Gross/WeekNumericGeneric Edit152 Allow NULL? 
12A0GRSSEVGross SeveranceNumericGeneric Edit112 Allow NULL? 
13A0INCAMTIncentive AmountNumericGeneric Edit112 Allow NULL? 
14A0COMYSERCompleted Years Of ServiceNumericGeneric Edit92 Allow NULL? 
15A0REDUAMTRedundancy AmountNumericGeneric Edit112 Allow NULL? 
16A0REDUTRHRedundancy ThresholdNumericGeneric Edit112 Allow NULL? 
17A0TAXREDUTaxable RedundancyNumericGeneric Edit112 Allow NULL? 
18A0ULLHRSUnused LL HoursNumericGeneric Edit92 Allow NULL? 
19A0ULLVALUnused LL $NumericGeneric Edit112 Allow NULL? 
20A0ALBHRSAnnual Leave Bal HoursNumericGeneric Edit92 Allow NULL? 
21A0ALBVALAnnual Leave Bal ValueNumericGeneric Edit112 Allow NULL? 
22A0ALBTAXAnnual Leave Bal TaxNumericGeneric Edit112 Allow NULL? 
23A0USKHRSUnused Sick Leave HoursNumericGeneric Edit92 Allow NULL? 
24A0USKVALUnused Sick Leave ValueNumericGeneric Edit112 Allow NULL? 
25A0URDOHRUnused RDO Balance HoursNumericGeneric Edit92 Allow NULL? 
26A0URDOVLUnused RDO Balance ValueNumericGeneric Edit112 Allow NULL? 
27A0BD1HRSBand 1 LSL hoursNumericGeneric Edit92 Allow NULL? 
28A0BD1VALBand 1 ValueNumericGeneric Edit112 Allow NULL? 
29A0BD1TAXBand 1 TaxNumericGeneric Edit112 Allow NULL? 
30A0BD2HRSBand 2 LSL hoursNumericGeneric Edit92 Allow NULL? 
31A0BD2VALBand 2 ValueNumericGeneric Edit112 Allow NULL? 
32A0BD2TAXBand 2 TaxNumericGeneric Edit112 Allow NULL? 
33A0BD3HRSBand 3 LSL hoursNumericGeneric Edit92 Allow NULL? 
34A0BD3VALBand 3 ValueNumericGeneric Edit112 Allow NULL? 
35A0BD3TAXBand 3 TaxNumericGeneric Edit112 Allow NULL? 
36A0BD4HRSBand 4 LSL hoursNumericGeneric Edit92 Allow NULL? 
37A0BD4VALBand 4 ValueNumericGeneric Edit112 Allow NULL? 
38A0BD4TAXBand 4 TaxNumericGeneric Edit112 Allow NULL? 
39A0PR83DAYPre 83 DaysNumericGeneric Edit50 Allow NULL? 
40A0PT83DAYPost 83 DaysNumericGeneric Edit50 Allow NULL? 
41A0PR83VALPre 83 ValueNumericGeneric Edit112 Allow NULL? 
42A0PT83VALPost 83 ValueNumericGeneric Edit112 Allow NULL? 
43A0ASSAMTAssessable AmountNumericGeneric Edit112 Allow NULL? 
44A0ROLAMTRollover AmountNumericGeneric Edit112 Allow NULL? 
45A0ETPTAXETP tax deductedNumericGeneric Edit112 Allow NULL? 
46A0ETPPAYNet ETP payNumericGeneric Edit112 Allow NULL? 
47A0PAYFLGPayment MadeCharacterGeneric Edit10 Allow NULL? 
48A0ATOFLGExtracted for ATO FlagrCharacterGeneric Edit10 Allow NULL? 
49A0RETDTERetirement DateDateGeneric Edit60
50A0INVCOMPPost 94 InvalidityNumericGeneric Edit112 Allow NULL? 
51A0INVDAYPost 94 DaysNumericGeneric Edit50 Allow NULL? 
52A0TAXFNOTax File NumberStringGeneric Edit110 Allow NULL? 
53A0ATTLProfessional TitleStringGeneric Edit400 Allow NULL? 
54A0SRNMName - SurnameStringGeneric Edit250 Allow NULL? 
55A0GNNMName - GivenStringGeneric Edit250 Allow NULL? 
56A0MDNMName - MiddleStringGeneric Edit250 Allow NULL? 
57A0ADD1Address Line 1StringGeneric Edit400 Allow NULL? 
58A0ADD2Address Line 2StringGeneric Edit400 Allow NULL? 
59A0CTY1CityStringGeneric Edit250 Allow NULL? 
60A0ADDSStateStringUDC (00 S)30 Allow NULL? 
61A0ADDZPostal CodeStringGeneric Edit120 Allow NULL? 
62A0CTRCountryStringUDC (00 CN)30 Allow NULL? 
63A0DOBDate - BirthDateGeneric Edit60
64A0PAYTYPPayee TypeStringUDC (75 PT)20 Allow NULL? 
65A0ROLNMERollover Fund NameStringGeneric Edit400 Allow NULL? 
66A0ROLAD1Rollover Address Line 1StringGeneric Edit400 Allow NULL? 
67A0ROLAD2Rollover Address Line 2StringGeneric Edit400 Allow NULL? 
68A0ROLCTYRollover CityStringGeneric Edit250 Allow NULL? 
69A0ROLSTERollover StateStringGeneric Edit30 Allow NULL? 
70A0ROLPOSTRollover PostcodeStringGeneric Edit120 Allow NULL? 
71A0ROLCTRRollover CountryStringGeneric Edit30 Allow NULL? 
72A0APDAmount - PaidNumericGeneric Edit152 Allow NULL? 
73A0SPANO01Spare Numeric 01NumericGeneric Edit150 Allow NULL? 
74A0SPANO02Spare Numeric 02NumericGeneric Edit150 Allow NULL? 
75A0SPANO03Spare Numeric 03NumericGeneric Edit150 Allow NULL? 
76A0SPAGR01Spare Gross 01NumericGeneric Edit152 Allow NULL? 
77A0SPATX01Spare Tax 01NumericGeneric Edit152 Allow NULL? 
78A0UPMJDate - UpdatedDateGeneric Edit60
79A0UPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
80A0PIDProgram IDStringGeneric Edit100 Allow NULL? 
81A0JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
82A0ICUBatch NumberNumericGeneric Edit80 Allow NULL? 
83A0COCompanyStringGeneric Edit50 Allow NULL? 
84A0USERUser IDStringGeneric Edit100 Allow NULL? 
85A0CKDTDate - Pay CheckDateGeneric Edit60
86A0TRAMTransition AmountNumericGeneric Edit152 Allow NULL? 
87A0PTPAPrevious Transition AmountNumericGeneric Edit152 Allow NULL? 
88A0TGOLTransition Golden Handshake AmountNumericGeneric Edit152 Allow NULL? 
89A0TPLUTransition Payment in Lieu AmountNumericGeneric Edit152 Allow NULL? 
90A0DTAMDirected Termination Payment AmountNumericGeneric Edit152 Allow NULL? 
91A0PRAGPreservation Age IndicatorCharacterGeneric Edit10 Allow NULL? 
92A0TRPATransition Payment IndicatorCharacterUDC (75 TP)10 Allow NULL? 
93A0PMTPPayment Related IndicatorCharacterUDC (75 PR)10 Allow NULL? 
94A0ORAMTrans Original or Amended IndCharacterUDC (75 OA)10 Allow NULL? 
95A0NRAMNon Trans Original or Amended IndCharacterUDC (75 OA)10 Allow NULL? 
96A0TRINVCMPTrans Post June 94 InvalidityNumericGeneric Edit112 Allow NULL? 
97A0TPR83DAYTransitional Pre July 83 DaysNumericGeneric Edit50 Allow NULL? 
98A0TPR83VALTransitional Pre July 83 AmountNumericGeneric Edit112 Allow NULL? 
99A0TPT83DAYTransitional Post June 83 DaysNumericGeneric Edit50 Allow NULL? 
100A0TPT83VALTransitional Post June 93 AmountNumericGeneric Edit112 Allow NULL? 
101A0TRETPTAXTransitional Tax DeductedNumericGeneric Edit112 Allow NULL? 
102A0TRETPPAYTransitional Net ETPNumericGeneric Edit112 Allow NULL? 
103A0DNPISend to ATO IndicatorCharacterUDC (75 SA)10 Allow NULL? 
104A0SPADAUT1Spare Date 01DateGeneric Edit60
105A0SPADAUT2Spare Date 02DateGeneric Edit60
106A0SPADAUT3Spare Date 03DateGeneric Edit60
107A0SPADAUT4Spare Date 04DateGeneric Edit60
108A0SPAFAUT1Employee Termination Payment (ETP) CodeCharacterGeneric Edit10 Allow NULL? 
109A0SPAFAUT2Spare Flag 02CharacterGeneric Edit10 Allow NULL? 
110A0SPAFAUT3Spare Flag 03CharacterGeneric Edit10 Allow NULL? 
111A0SPAFAUT4Spare Flag 04CharacterGeneric Edit10 Allow NULL? 
112A0SPASAUT1Spare String 01StringGeneric Edit300 Allow NULL? 
113A0SPASAUT2Spare String 02StringGeneric Edit300 Allow NULL? 
114A0SPASAUT3Spare String 03StringGeneric Edit300 Allow NULL? 
115A0SPANAUT1Spare Numeric 01NumericGeneric Edit152 Allow NULL? 
116A0SPANAUT2Spare Numeric 02NumericGeneric Edit152 Allow NULL? 
117A0SPANAUT3Spare Numeric 03NumericGeneric Edit152 Allow NULL? 
118A0SPANAUT4Spare Numeric 04NumericGeneric Edit152 Allow NULL? 

TOP910 | 75A | F75A0010 INDEXES

NumberDescription
1Employee # Date Terminated (Primary/Unique)
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2DTDate - TerminatedAscending