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

65 COLUMNS | 4 INDEXES | Print definition?920 | 09 | F09330 TABLE

09: General Accounting
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F09330RT654OVFS Statement Definition Setup TableFiles09: General Accounting
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 RTRPSTN, RTRPSTD, RTLINN, RTRSTN, RTRPRID, RTRIDDS, RTRPCOL01, RTRPCOL02, RTRPCOL03, RTRPCOL04, RTRPCOL05, RTRPCOL06, RTRPCOL07, RTRPCOL08, RTRPCOL09, RTRPCOL10, RTRPCOL11, RTRPCOL12, RTRPCOL13, RTRPCOL14, RTRPCOL15, RTRPCOL16, RTRPCOL17, RTRPCOL18, RTRPCOL19, RTRPCOL20, RTRPCOL21, RTRPCOL22, RTRPCOL23, RTRPCOL24, RTRPCOL25, RTSTMSG, RTFRCC1, RTFRCC2, RTFRCC3, RTFRCC4, RTFRCC5, RTWOBNM, RTRPNU1, RTRPNU2, RTRPNU3, RTRPST1, RTRPST2, RTRPST3, RTRPCT1, RTRPCT2, RTRPCT3, RTRPDT1, RTRPDT2, RTRPDT3, RTCRTBY, RTUSER, RTPID, RTJOBN, RTUPMJ, RTUPMT, RTLVERS, RTLODR, RTGAIGF, RTRWCF, RTRWRSF, RTSSNF, RTSSNT, RTSISF, RTRDCCF FROM F09330

TOP920 | 09 | F09330 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1RTRPSTNStatement Definition NameStringGeneric Edit200 Allow NULL? 
2RTRPSTDStatement Definition DescriptionStringGeneric Edit800 Allow NULL? 
3RTLINNLine NumberNumericGeneric Edit73 Allow NULL? 
4RTRSTNRow Definition NameStringGeneric Edit200 Allow NULL? 
5RTRPRIDSection NumberNumericGeneric Edit73 Allow NULL? 
6RTRIDDSSection DescriptionStringGeneric Edit800 Allow NULL? 
7RTRPCOL01Column Definition Name 1StringGeneric Edit200 Allow NULL? 
8RTRPCOL02Column Definition Name 2StringGeneric Edit200 Allow NULL? 
9RTRPCOL03Column Definition Name 3StringGeneric Edit200 Allow NULL? 
10RTRPCOL04Column Definition Name 4StringGeneric Edit200 Allow NULL? 
11RTRPCOL05Column Definition Name 5StringGeneric Edit200 Allow NULL? 
12RTRPCOL06Column Definition Name 6StringGeneric Edit200 Allow NULL? 
13RTRPCOL07Column Definition Name 7StringGeneric Edit200 Allow NULL? 
14RTRPCOL08Column Definition Name 8StringGeneric Edit200 Allow NULL? 
15RTRPCOL09Column Definition Name 9StringGeneric Edit200 Allow NULL? 
16RTRPCOL10Column Definition Name 10StringGeneric Edit200 Allow NULL? 
17RTRPCOL11Column Definition Name 11StringGeneric Edit200 Allow NULL? 
18RTRPCOL12Column Definition Name 12StringGeneric Edit200 Allow NULL? 
19RTRPCOL13Column Definition Name 13StringGeneric Edit200 Allow NULL? 
20RTRPCOL14Column Definition Name 14StringGeneric Edit200 Allow NULL? 
21RTRPCOL15Column Definition Name 15StringGeneric Edit200 Allow NULL? 
22RTRPCOL16Column Definition Name 16StringGeneric Edit200 Allow NULL? 
23RTRPCOL17Column Definition Name 17StringGeneric Edit200 Allow NULL? 
24RTRPCOL18Column Definition Name 18StringGeneric Edit200 Allow NULL? 
25RTRPCOL19Column Definition Name 19StringGeneric Edit200 Allow NULL? 
26RTRPCOL20Column Definition Name 20StringGeneric Edit200 Allow NULL? 
27RTRPCOL21Column Definition Name 21StringGeneric Edit200 Allow NULL? 
28RTRPCOL22Column Definition Name 22StringGeneric Edit200 Allow NULL? 
29RTRPCOL23Column Definition Name 23StringGeneric Edit200 Allow NULL? 
30RTRPCOL24Column Definition Name 24StringGeneric Edit200 Allow NULL? 
31RTRPCOL25Column Definition Name 25StringGeneric Edit200 Allow NULL? 
32RTSTMSGDefinition StatusStringUDC (09 SM)20 Allow NULL? 
33RTFRCC1Financial Statement Category Code 1StringUDC (09 C1)100 Allow NULL? 
34RTFRCC2Financial Statement Category Code 2StringUDC (09 C2)100 Allow NULL? 
35RTFRCC3Financial Statement Category Code 3StringUDC (09 C3)100 Allow NULL? 
36RTFRCC4Financial Statement Category Code 4StringUDC (09 C4)100 Allow NULL? 
37RTFRCC5Financial Statement Category Code 5StringUDC (09 C5)100 Allow NULL? 
38RTWOBNMObject NameStringGeneric Edit300 Allow NULL? 
39RTRPNU1F09330 Future Use Number 1NumericGeneric Edit150 Allow NULL? 
40RTRPNU2F09330 Future Use Number 2NumericGeneric Edit150 Allow NULL? 
41RTRPNU3F09330 Future Use Number 3NumericGeneric Edit150 Allow NULL? 
42RTRPST1F09330 Future Use String 1StringGeneric Edit800 Allow NULL? 
43RTRPST2F09330 Future Use String 2StringGeneric Edit800 Allow NULL? 
44RTRPST3F09330 Future Use String 3StringGeneric Edit800 Allow NULL? 
45RTRPCT1F09330 Future Use Character 1CharacterGeneric Edit10 Allow NULL? 
46RTRPCT2F09330 Future Use Character 2CharacterGeneric Edit10 Allow NULL? 
47RTRPCT3F09330 Future Use Character 3CharacterGeneric Edit10 Allow NULL? 
48RTRPDT1F09330 Future Use Date 1DateGeneric Edit60
49RTRPDT2F09330 Future Use Date 2DateGeneric Edit60
50RTRPDT3F09330 Future Use Date 3DateGeneric Edit60
51RTCRTBYCreated ByStringGeneric Edit100 Allow NULL? 
52RTUSERUser IDStringGeneric Edit100 Allow NULL? 
53RTPIDProgram IDStringGeneric Edit100 Allow NULL? 
54RTJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
55RTUPMJDate - UpdatedDateGeneric Edit60
56RTUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
57RTLVERSLayout VersionStringGeneric Edit200 Allow NULL? 
58RTLODREnable Level of Detail RollupCharacterGeneric Edit10 Allow NULL? 
59RTGAIGFInclude GLG AAI Item NumberCharacterGeneric Edit10 Allow NULL? 
60RTRWCFConsolidated Row FlagCharacterGeneric Edit10 Allow NULL? 
61RTRWRSFRow Reverse Sign FlagCharacterGeneric Edit10 Allow NULL? 
62RTSSNFSubtotal Section Number FromNumericGeneric Edit73 Allow NULL? 
63RTSSNTSubtotal Section Number ThruNumericGeneric Edit73 Allow NULL? 
64RTSISFInclude Subtotals FlagCharacterGeneric Edit10 Allow NULL? 
65RTRDCCFStatement Definition Component ChangedCharacterGeneric Edit10 Allow NULL? 

TOP920 | 09 | F09330 INDEXES

NumberDescription
1ReportDefName SectionID Line (Primary/Unique)
ElementAliasDescriptionSequence
1RPSTNStatement Definition NameAscending
2RPRIDSection NumberAscending
3LINNLine NumberAscending
2GroupID ReportStName Line
ElementAliasDescriptionSequence
1RPRIDSection NumberAscending
2RPSTNStatement Definition NameAscending
3LINNLine NumberAscending
3ReportStName
ElementAliasDescriptionSequence
1RPSTNStatement Definition NameAscending
4ReportDefName SectionNum
ElementAliasDescriptionSequence
1RPSTNStatement Definition NameAscending
2RPRIDSection NumberAscending