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
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

58 COLUMNS | 1 INDEXES | Print definition?920 | 75I | F75I4223 TABLE

75I: India
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F75I4223SD581Sales Tax Summary/DetailFiles75I: India
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 SDDOCO, SDDCTO, SDKCOO, SDLNID, SDKCO, SDDOC, SDDCT, SDMCU, SDIVD, SDITM, SDLITM, SDTRQT, SDTRUM, SDSOQS, SDUOM4, SDSTOP, SDZON, SDSRP1, SDSRP2, SDSRP3, SDSRP4, SDSRP5, SDSRP0, SDMATH01, SDAST, SDFVTR, SDAN8, SDSHAN, SDAEXP, SDYEXA, SDAREC, SDUPRC, SDFREC, SDAA, SDAAP, SDAFA1, SDAA1, SDFDADT1, SDFDADT2, SDFDADT3, SDF1A, SDF2A, SDF3A, SDF4A, SDF5A, SDF6A, SDC1FU, SDC2FU, SDF1T, SDF2T, SDF3T, SDPID, SDUSER, SDJOBN, SDUPMJ, SDUPMT, SDOLND, SDEF01 FROM F75I4223

TOP920 | 75I | F75I4223 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SDDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
2SDDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
3SDKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
4SDLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
5SDKCODocument CompanyStringGeneric Edit50 Allow NULL? 
6SDDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
7SDDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
8SDMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
9SDIVDDate - InvoiceDateGeneric Edit60
10SDITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
11SDLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
12SDTRQTQuantity AvailableNumericGeneric Edit150 Allow NULL? 
13SDTRUMUnit of Measure - TransactionStringUDC (00 UM)20 Allow NULL? 
14SDSOQSQuantity ShippedNumericGeneric Edit150 Allow NULL? 
15SDUOM4Unit of Measure - PricingStringUDC (00 UM)20 Allow NULL? 
16SDSTOPStop CodeStringUDC (42 SP)30 Allow NULL? 
17SDZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
18SDSRP1Sales Catalog SectionStringUDC (41 S1)30 Allow NULL? 
19SDSRP2Sub SectionStringUDC (41 S2)30 Allow NULL? 
20SDSRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
21SDSRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
22SDSRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
23SDSRP0Category Code 10StringUDC (41 10)60 Allow NULL? 
24SDMATH01Math Numeric 01NumericGeneric Edit152 Allow NULL? 
25SDASTPrice Adjustment NameStringUDC (40 TY)80 Allow NULL? 
26SDFVTRFactor ValueNumericGeneric Edit154 Allow NULL? 
27SDAN8Address NumberNumericGeneric Edit80 Allow NULL? 
28SDSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
29SDAEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
30SDYEXAExcise AmountNumericGeneric Edit152 Allow NULL? 
31SDARECAmount - ReceivedNumericGeneric Edit152 Allow NULL? 
32SDUPRCAmount - Price per UnitNumericGeneric Edit154 Allow NULL? 
33SDFRECAmount - Received ForeignNumericGeneric Edit152 Allow NULL? 
34SDAAAmountNumericGeneric Edit152 Allow NULL? 
35SDAAPAmount OpenNumericGeneric Edit152 Allow NULL? 
36SDAFA1Amount After ConversionNumericGeneric Edit154 Allow NULL? 
37SDAA1AmountNumericGeneric Edit152 Allow NULL? 
38SDFDADT1Future Use FDA Text Date 1DateGeneric Edit60
39SDFDADT2Future Use FDA Text Date 2DateGeneric Edit60
40SDFDADT3Future Use FDA Text Date 3DateGeneric Edit60
41SDF1AFuture 1 AmountNumericGeneric Edit150 Allow NULL? 
42SDF2AFuture 2 AmountNumericGeneric Edit150 Allow NULL? 
43SDF3AFuture 3 AmountNumericGeneric Edit150 Allow NULL? 
44SDF4AFuture 4 AmountNumericGeneric Edit150 Allow NULL? 
45SDF5AFuture 5 AmountNumericGeneric Edit150 Allow NULL? 
46SDF6AFuture 6 AmountNumericGeneric Edit150 Allow NULL? 
47SDC1FUFuture Use - Character 1CharacterGeneric Edit10 Allow NULL? 
48SDC2FUFuture Use - Character 1CharacterGeneric Edit10 Allow NULL? 
49SDF1TFuture 1 TextStringGeneric Edit300 Allow NULL? 
50SDF2TFuture 2 TextStringGeneric Edit300 Allow NULL? 
51SDF3TFuture 3 TextStringGeneric Edit300 Allow NULL? 
52SDPIDProgram IDStringGeneric Edit100 Allow NULL? 
53SDUSERUser IDStringGeneric Edit100 Allow NULL? 
54SDJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
55SDUPMJDate - UpdatedDateGeneric Edit60
56SDUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
57SDOLNDLine Number - Overall ReportNumericGeneric Edit152 Allow NULL? 
58SDEF01Evaluation Factor1NumericGeneric Edit10 Allow NULL? 

TOP920 | 75I | F75I4223 INDEXES

NumberDescription
1PID USER JOBN UPMJ UPMT OLND (Primary/Unique)
ElementAliasDescriptionSequence
1PIDProgram IDAscending
2USERUser IDAscending
3JOBNWork Station IDAscending
4UPMJDate - UpdatedAscending
5UPMTTime - Last UpdatedAscending
6OLNDLine Number - Overall ReportAscending