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
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

109 COLUMNS | 1 INDEXES | Print definition?920 | 51X | F51X30 TABLE

51X: In-Memory Project Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F51X30PB1091Project Advisor Results HeaderFiles51X: In-Memory Project Management
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 PBJOBS, PBUSER, PBUPMJ, PBUPMT, PBPID, PB51XDTOPT, PB51XLODT, PB51XSUM, PBDTAI, PB51XCCCT, PB51XFPN, PB51XTPN, PB51XFFY, PB51XTFY, PBJOBN, PBMKEY, PB51XCOL01, PB51XCOL02, PB51XCOL03, PB51XCOL04, PB51XCOL05, PB51XCOL06, PB51XCOL07, PB51XCOL08, PB51XCOL09, PB51XCOL10, PB51XCOL11, PB51XCOL12, PB51XCOL13, PB51XCOL14, PB51XCOL15, PB51XCOL16, PB51XCOL17, PB51XCOL18, PB51XCOL19, PB51XCOL20, PB51XCOL21, PB51XCOL22, PB51XCOL23, PB51XCOL24, PB51XCOL25, PB51XCOL26, PB51XCOL27, PB51XCOL28, PB51XCOL29, PB51XCOL30, PB51XCOL31, PB51XCOL32, PB51XCOL33, PB51XCOL34, PB51XCOL35, PB51XCOL36, PB51XCOL37, PB51XCOL38, PB51XCOL39, PB51XCOL40, PB51X01IC, PB51X02IC, PB51X03IC, PB51X04IC, PB51X05IC, PB51X06IC, PB51X07IC, PB51X08IC, PB51X09IC, PB51X10IC, PB51X11IC, PB51X12IC, PB51X13IC, PB51X14IC, PB51X15IC, PB51X16IC, PB51X17IC, PB51X18IC, PB51X19IC, PB51X20IC, PB51X21IC, PB51X22IC, PB51X23IC, PB51X24IC, PB51X25IC, PB51X26IC, PB51X27IC, PB51X28IC, PB51X29IC, PB51X30IC, PB51X31IC, PB51X32IC, PB51X33IC, PB51X34IC, PB51X35IC, PB51X36IC, PB51X37IC, PB51X38IC, PB51X39IC, PB51X40IC, PB51XDTAI1, PB51XDTAI2, PBSBL, PBSBLT, PBEFTB, PBEFTE, PB51XDTAI3, PB51XPOD, PB51XEOS, PB51XDL01, PBCRCD, PBAITD, PB51XARN FROM F51X30

TOP920 | 51X | F51X30 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1PBJOBSJob NumberNumericGeneric Edit80 Allow NULL? 
2PBUSERUser IDStringGeneric Edit100 Allow NULL? 
3PBUPMJDate - UpdatedDateGeneric Edit60
4PBUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
5PBPIDProgram IDStringGeneric Edit100 Allow NULL? 
6PB51XDTOPTInception YTD or PeriodCharacterGeneric Edit10 Allow NULL? 
7PB51XLODTLevel of Detail TotalingCharacterGeneric Edit10 Allow NULL? 
8PB51XSUMPAC Summarize OptionStringUDC (51X SM)40 Allow NULL? 
9PBDTAIData ItemStringGeneric Edit100 Allow NULL? 
10PB51XCCCTPAC Cost Code Cost TypeCharacterUDC (51X CC)10 Allow NULL? 
11PB51XFPNFrom Period PACNumericGeneric Edit20 Allow NULL? 
12PB51XTPNThru Period PACNumericGeneric Edit20 Allow NULL? 
13PB51XFFYFrom Fiscal Year PACNumericGeneric Edit20 Allow NULL? 
14PB51XTFYThru Fiscal Year PACNumericGeneric Edit20 Allow NULL? 
15PBJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
16PBMKEYMachine KeyStringGeneric Edit150 Allow NULL? 
17PB51XCOL01Column 01StringGeneric Edit60 Allow NULL? 
18PB51XCOL02Column 02StringGeneric Edit60 Allow NULL? 
19PB51XCOL03Column 03StringGeneric Edit60 Allow NULL? 
20PB51XCOL04Column 04StringGeneric Edit60 Allow NULL? 
21PB51XCOL05Column 05StringGeneric Edit60 Allow NULL? 
22PB51XCOL06Column 06StringGeneric Edit60 Allow NULL? 
23PB51XCOL07Column 07StringGeneric Edit60 Allow NULL? 
24PB51XCOL08Column 08StringGeneric Edit60 Allow NULL? 
25PB51XCOL09Column 09StringGeneric Edit60 Allow NULL? 
26PB51XCOL10Column 10StringGeneric Edit60 Allow NULL? 
27PB51XCOL11Column 11StringGeneric Edit60 Allow NULL? 
28PB51XCOL12Column 12StringGeneric Edit60 Allow NULL? 
29PB51XCOL13Column 13StringGeneric Edit60 Allow NULL? 
30PB51XCOL14Column 14StringGeneric Edit60 Allow NULL? 
31PB51XCOL15Column 15StringGeneric Edit60 Allow NULL? 
32PB51XCOL16Column 16StringGeneric Edit60 Allow NULL? 
33PB51XCOL17Column 17StringGeneric Edit60 Allow NULL? 
34PB51XCOL18Column 18StringGeneric Edit60 Allow NULL? 
35PB51XCOL19Column 19StringGeneric Edit60 Allow NULL? 
36PB51XCOL20Column 20StringGeneric Edit60 Allow NULL? 
37PB51XCOL21Column 21StringGeneric Edit60 Allow NULL? 
38PB51XCOL22Column 22StringGeneric Edit60 Allow NULL? 
39PB51XCOL23Column 23StringGeneric Edit60 Allow NULL? 
40PB51XCOL24Column 24StringGeneric Edit60 Allow NULL? 
41PB51XCOL25Column 25StringGeneric Edit60 Allow NULL? 
42PB51XCOL26Column 26StringGeneric Edit60 Allow NULL? 
43PB51XCOL27Column 27StringGeneric Edit60 Allow NULL? 
44PB51XCOL28Column 28StringGeneric Edit60 Allow NULL? 
45PB51XCOL29Column 29StringGeneric Edit60 Allow NULL? 
46PB51XCOL30Column 30StringGeneric Edit60 Allow NULL? 
47PB51XCOL31Column 31StringGeneric Edit60 Allow NULL? 
48PB51XCOL32Column 32StringGeneric Edit60 Allow NULL? 
49PB51XCOL33Column 33StringGeneric Edit60 Allow NULL? 
50PB51XCOL34Column 34StringGeneric Edit60 Allow NULL? 
51PB51XCOL35Column 35StringGeneric Edit60 Allow NULL? 
52PB51XCOL36Column 36StringGeneric Edit60 Allow NULL? 
53PB51XCOL37Column 37StringGeneric Edit60 Allow NULL? 
54PB51XCOL38Column 38StringGeneric Edit60 Allow NULL? 
55PB51XCOL39Column 39StringGeneric Edit60 Allow NULL? 
56PB51XCOL40Column 40StringGeneric Edit60 Allow NULL? 
57PB51X01ICInclude Column 01 in ChartCharacterCheck Box10 Allow NULL? 
58PB51X02ICInclude Column 02 in ChartCharacterCheck Box10 Allow NULL? 
59PB51X03ICInclude Column 03 in ChartCharacterCheck Box10 Allow NULL? 
60PB51X04ICInclude Column 04 in ChartCharacterCheck Box10 Allow NULL? 
61PB51X05ICInclude Column 05 in ChartCharacterCheck Box10 Allow NULL? 
62PB51X06ICInclude Column 06 in ChartCharacterCheck Box10 Allow NULL? 
63PB51X07ICInclude Column 07 in ChartCharacterCheck Box10 Allow NULL? 
64PB51X08ICInclude Column 08 in ChartCharacterCheck Box10 Allow NULL? 
65PB51X09ICInclude Column 09 in ChartCharacterCheck Box10 Allow NULL? 
66PB51X10ICInclude Column 10 in ChartCharacterCheck Box10 Allow NULL? 
67PB51X11ICInclude Column 11 in ChartCharacterCheck Box10 Allow NULL? 
68PB51X12ICInclude Column 12 in ChartCharacterCheck Box10 Allow NULL? 
69PB51X13ICInclude Column 13 in ChartCharacterCheck Box10 Allow NULL? 
70PB51X14ICInclude Column 14 in ChartCharacterCheck Box10 Allow NULL? 
71PB51X15ICInclude Column 15 in ChartCharacterCheck Box10 Allow NULL? 
72PB51X16ICInclude Column 16 in ChartCharacterCheck Box10 Allow NULL? 
73PB51X17ICInclude Column 17 in ChartCharacterCheck Box10 Allow NULL? 
74PB51X18ICInclude Column 18 in ChartCharacterCheck Box10 Allow NULL? 
75PB51X19ICInclude Column 19 in ChartCharacterCheck Box10 Allow NULL? 
76PB51X20ICInclude Column 20 in ChartCharacterCheck Box10 Allow NULL? 
77PB51X21ICInclude Column 21 in ChartCharacterCheck Box10 Allow NULL? 
78PB51X22ICInclude Column 22 in ChartCharacterCheck Box10 Allow NULL? 
79PB51X23ICInclude Column 23 in ChartCharacterCheck Box10 Allow NULL? 
80PB51X24ICInclude Column 24 in ChartCharacterCheck Box10 Allow NULL? 
81PB51X25ICInclude Column 25 in ChartCharacterCheck Box10 Allow NULL? 
82PB51X26ICInclude Column 26 in ChartCharacterCheck Box10 Allow NULL? 
83PB51X27ICInclude Column 27 in ChartCharacterCheck Box10 Allow NULL? 
84PB51X28ICInclude Column 28 in ChartCharacterCheck Box10 Allow NULL? 
85PB51X29ICInclude Column 29 in ChartCharacterCheck Box10 Allow NULL? 
86PB51X30ICInclude Column 30 in ChartCharacterCheck Box10 Allow NULL? 
87PB51X31ICInclude Column 31 in ChartCharacterCheck Box10 Allow NULL? 
88PB51X32ICInclude Column 32 in ChartCharacterCheck Box10 Allow NULL? 
89PB51X33ICInclude Column 33 in ChartCharacterCheck Box10 Allow NULL? 
90PB51X34ICInclude Column 34 in ChartCharacterCheck Box10 Allow NULL? 
91PB51X35ICInclude Column 35 in ChartCharacterCheck Box10 Allow NULL? 
92PB51X36ICInclude Column 36 in ChartCharacterCheck Box10 Allow NULL? 
93PB51X37ICInclude Column 37 in ChartCharacterCheck Box10 Allow NULL? 
94PB51X38ICInclude Column 38 in ChartCharacterCheck Box10 Allow NULL? 
95PB51X39ICInclude Column 39 in ChartCharacterCheck Box10 Allow NULL? 
96PB51X40ICInclude Column 40 in ChartCharacterCheck Box10 Allow NULL? 
97PB51XDTAI1Currency WarningStringGeneric Edit100 Allow NULL? 
98PB51XDTAI2Date WarningStringGeneric Edit100 Allow NULL? 
99PBSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
100PBSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
101PBEFTBDate - Beginning EffectiveDateGeneric Edit60
102PBEFTEDate - Ending EffectiveDateGeneric Edit60
103PB51XDTAI3Summary Option Data ItemStringGeneric Edit100 Allow NULL? 
104PB51XPODPAC Period or DateCharacterGeneric Edit10 Allow NULL? 
105PB51XEOSPAC Error Or SuccessCharacterGeneric Edit10 Allow NULL? 
106PB51XDL01DescriptionStringGeneric Edit1200 Allow NULL? 
107PBCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
108PBAITDAs If Transaction DateDateGeneric Edit60
109PB51XARNAccount Range NameStringGeneric Edit60 Allow NULL? 

TOP920 | 51X | F51X30 INDEXES

NumberDescription
1Primary Key (Primary/Unique)
ElementAliasDescriptionSequence
1JOBSJob NumberAscending