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

40 COLUMNS | 2 INDEXES | Print definition?920 | 17 | F1793 TABLE

17: Customer Service Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F1793LF402S/WM Line Type ConstantsMaster Files17: Customer Service ManagementBusiness 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 LFLNTY, LFYN26, LFYN27, LFYN28, LFYN29, LFYN30, LFDCTO, LFCRTU, LFUSER, LFPID, LFJOBN, LFUPMJ, LFUPMT, LFMCUZ, LFBTF01, LFBTF02, LFBTF03, LFBTF04, LFBTF05, LFBTF06, LFBTF07, LFBTF08, LFBTF09, LFBTF10, LFBHV01, LFBHV02, LFBHV03, LFBHV04, LFBHV05, LFBHV06, LFBHV07, LFBHV08, LFBHV09, LFBHV10, LFUBHV1, LFUBHV2, LFUBHV3, LFUBHV4, LFUBHV5, LFDCT FROM F1793

TOP920 | 17 | F1793 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1LFLNTYLine TypeStringGeneric Edit20 Allow NULL? 
2LFYN26Yes or No Entry 26CharacterGeneric Edit10 Allow NULL? 
3LFYN27Yes or No Entry 27CharacterGeneric Edit10 Allow NULL? 
4LFYN28Yes or No Entry 28CharacterGeneric Edit10 Allow NULL? 
5LFYN29Yes or No Entry 29CharacterGeneric Edit10 Allow NULL? 
6LFYN30Yes or No Entry 30CharacterGeneric Edit10 Allow NULL? 
7LFDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
8LFCRTUCreated by userStringGeneric Edit100 Allow NULL? 
9LFUSERUser IDStringGeneric Edit100 Allow NULL? 
10LFPIDProgram IDStringGeneric Edit100 Allow NULL? 
11LFJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
12LFUPMJDate - UpdatedDateGeneric Edit60
13LFUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
14LFMCUZBusiness Unit - AltStringGeneric Edit120 Allow NULL? 
15LFBTF01Allow Modify Start DateCharacterUDC (17 TF)10 Allow NULL? 
16LFBTF02Allow Modify End DateCharacterUDC (17 TF)10 Allow NULL? 
17LFBTF03Allow Modify DurationCharacterUDC (17 TF)10 Allow NULL? 
18LFBTF04Active Contract RequiredCharacterUDC (17 TF)10 Allow NULL? 
19LFBTF05Free ContractCharacterUDC (17 TF)10 Allow NULL? 
20LFBTF06Allow EntitlementCharacterUDC (17 TF)10 Allow NULL? 
21LFBTF07Yes No Behavior Line Type 07CharacterUDC (17 TF)10 Allow NULL? 
22LFBTF08Yes No Behavior Line Type 08CharacterUDC (17 TF)10 Allow NULL? 
23LFBTF09Yes No Behavior Line Type 09CharacterUDC (17 TF)10 Allow NULL? 
24LFBTF10Yes No Behavior Line Type 10CharacterUDC (17 TF)10 Allow NULL? 
25LFBHV01Start Date DefaultCharacterUDC (17 L1)10 Allow NULL? 
26LFBHV02End Date DefaultCharacterUDC (17 L2)10 Allow NULL? 
27LFBHV03Behavior Type 03CharacterUDC (17 L3)10 Allow NULL? 
28LFBHV04Behavior Type 04CharacterUDC (17 L4)10 Allow NULL? 
29LFBHV05Behavior Type 05CharacterUDC (17 L5)10 Allow NULL? 
30LFBHV06Behavior Type 06CharacterUDC (17 L6)10 Allow NULL? 
31LFBHV07Behavior Type 07CharacterUDC (17 L7)10 Allow NULL? 
32LFBHV08Behavior Type 08CharacterUDC (17 L8)10 Allow NULL? 
33LFBHV09Behavior Type 09CharacterUDC (17 L9)10 Allow NULL? 
34LFBHV10Behavior Type 10CharacterUDC (17 L0)10 Allow NULL? 
35LFUBHV1User Defined Behavior 1StringUDC (17 V1)80 Allow NULL? 
36LFUBHV2User Defined Behavior 2StringUDC (17 V2)80 Allow NULL? 
37LFUBHV3User Defined Behavior 3StringUDC (17 V3)80 Allow NULL? 
38LFUBHV4User Defined Behavior 4StringUDC (17 V4)80 Allow NULL? 
39LFUBHV5User Defined Behavior 5StringUDC (17 V5)80 Allow NULL? 
40LFDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 

TOP920 | 17 | F1793 INDEXES

NumberDescription
1Line Type (Primary/Unique)
ElementAliasDescriptionSequence
1LNTYLine TypeAscending
2Base Warranty
ElementAliasDescriptionSequence
1YN26Yes or No Entry 26Ascending