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

54 COLUMNS | 1 INDEXES | Print definition?920 | 43E | F43E20WF TABLE

43E: Requisition Self Service
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F43E20WFSW541eReq - Shopping Cart Work FileFiles43E: Requisition Self Service
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 SWUSER, SWCOOKIE, SWLNID, SWAN8V, SWCMDCDE, SWCMDSUP, SWITM, SWPRODNM, SWITEMDES, SWSUPITMID, SWITMAUXID, SWSCITTY, SWUNSPSC, SWQTY, SWUOM, SWFRRC, SWFEA, SWCCD0, SWATXA, SWSTAM, SWTAXA, SWEXR1, SWTXR1, SWSCAMT, SWSCDESC, SWMGFID, SWMOFLAG, SWLNG, SWNRCC, SWCNDJ, SWJOBN, SWPID, SWUPMT, SWUPMJ, SWEV01, SWEV02, SWEV03, SWEV04, SWEV05, SWMATH01, SWMATH02, SWMATH03, SWMATH04, SWMATH05, SWFUTANON3, SWFUTANON4, SWFUTANON5, SWFUTANON6, SWFUTANON7, SWCRSREF01, SWCRSREF02, SWCRSREF03, SWCRSREF04, SWCRSREF05 FROM F43E20WF

TOP920 | 43E | F43E20WF COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SWUSERUser IDStringGeneric Edit100 Allow NULL? 
2SWCOOKIEBuyer CookieStringGeneric Edit2000 Allow NULL? 
3SWLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
4SWAN8VAddress Number - SupplierNumericGeneric Edit80 Allow NULL? 
5SWCMDCDECommodity CodeStringGeneric Edit150 Allow NULL? 
6SWCMDSUPCommodity Code SupplierStringGeneric Edit300 Allow NULL? 
7SWITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
8SWPRODNMItem Short NameStringGeneric Edit500 Allow NULL? 
9SWITEMDESItem DescriptionStringGeneric Edit300 Allow NULL? 
10SWSUPITMIDSupplier Item IDStringGeneric Edit300 Allow NULL? 
11SWITMAUXIDSupplier Part Auxiliary IDStringGeneric Edit500 Allow NULL? 
12SWSCITTYItem Type - Shopping CartCharacterGeneric Edit10 Allow NULL? 
13SWUNSPSCUNSPSC Commodity CodeStringGeneric Edit80 Allow NULL? 
14SWQTYQuantityNumericGeneric Edit72 Allow NULL? 
15SWUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
16SWFRRCAmount - Foreign Unit PriceNumericGeneric Edit154 Allow NULL? 
17SWFEAAmount - Foreign Extended PriceNumericGeneric Edit152 Allow NULL? 
18SWCCD0Currency CodeStringGeneric Edit30 Allow NULL? 
19SWATXAAmount - TaxableNumericGeneric Edit152 Allow NULL? 
20SWSTAMAmount - TaxNumericGeneric Edit152 Allow NULL? 
21SWTAXADescription - Tax AreaStringGeneric Edit300 Allow NULL? 
22SWEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
23SWTXR1Tax Rate 1NumericGeneric Edit73 Allow NULL? 
24SWSCAMTShipping Charge AmountNumericGeneric Edit152 Allow NULL? 
25SWSCDESCShipping Charge DescriptionStringGeneric Edit300 Allow NULL? 
26SWMGFIDManufacturer IDStringGeneric Edit300 Allow NULL? 
28SWMOFLAGMedia Object FlagCharacterGeneric Edit10 Allow NULL? 
29SWLNGLanguage CodeStringUDC30 Allow NULL? 
30SWNRCCCountry Code - 3 digitStringUDC (77 CN)30 Allow NULL? 
31SWCNDJDate - CancelDateGeneric Edit60
32SWJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
33SWPIDProgram IDStringGeneric Edit100 Allow NULL? 
34SWUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
35SWUPMJDate - UpdatedDateGeneric Edit60
36SWEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10 Allow NULL? 
37SWEV02J.D. EnterpriseOne Event Point 02CharacterGeneric Edit10 Allow NULL? 
38SWEV03J.D. EnterpriseOne Point 03CharacterGeneric Edit10 Allow NULL? 
39SWEV04EnterpriseOne Point 04CharacterGeneric Edit10 Allow NULL? 
40SWEV05EnterpriseOne Point 05CharacterGeneric Edit10 Allow NULL? 
41SWMATH01Math Numeric 01NumericGeneric Edit152 Allow NULL? 
42SWMATH02Math Numeric 02NumericGeneric Edit152 Allow NULL? 
43SWMATH03Math Numeric 03NumericGeneric Edit152 Allow NULL? 
44SWMATH04Math Numeric 04NumericGeneric Edit152 Allow NULL? 
45SWMATH05Math Numeric 05NumericGeneric Edit152 Allow NULL? 
46SWFUTANON3Future Use Field 3StringGeneric Edit200 Allow NULL? 
47SWFUTANON4Future Use Field 4StringGeneric Edit200 Allow NULL? 
48SWFUTANON5Future Use Field 5StringGeneric Edit200 Allow NULL? 
49SWFUTANON6Future Use Field 6StringGeneric Edit200 Allow NULL? 
50SWFUTANON7Future Use Field 7StringGeneric Edit200 Allow NULL? 
51SWCRSREF01Cross Reference Field 01StringGeneric Edit3000 Allow NULL? 
52SWCRSREF02Cross Reference Field 02StringGeneric Edit3000 Allow NULL? 
53SWCRSREF03Cross Reference Field 03StringGeneric Edit3000 Allow NULL? 
54SWCRSREF04Cross Reference Field 04StringGeneric Edit3000 Allow NULL? 
55SWCRSREF05Cross Reference Field 05StringGeneric Edit3000 Allow NULL? 

TOP920 | 43E | F43E20WF INDEXES

NumberDescription
1UserID Cookie A (Primary/Unique)
ElementAliasDescriptionSequence
1USERUser IDAscending
2COOKIEBuyer CookieAscending
3LNIDLine NumberAscending