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

78 COLUMNS | 1 INDEXES | Print definition?920 | 75C | F75C902 TABLE

75C: China
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F75C902SB781Subsidiary Balances File - ChinaFiles75C: China
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 SBAID, SBCTRY, SBFY, SBLT, SBSBLT, SBSBL, SBCRCD, SBC75SUB1, SBC75SUB2, SBC75SUB3, SBC75SUB4, SBC75SUB5, SBC75SUB6, SBC75SUB7, SBC75SUB8, SBC75SUB9, SBC75SUB10, SBC75SUB11, SBC75SUB12, SBC75SUB13, SBC75SUB14, SBC75SUB15, SBC75SUB16, SBC75SUB17, SBC75SUB18, SBC75SUB19, SBC75SUB20, SBC75SUB21, SBC75SUB22, SBC75SUB23, SBC75SUB24, SBC75SUB25, SBC75SUB26, SBC75SUB27, SBC75SUB28, SBC75SUB29, SBC75SUB30, SBAPYC, SBAN01, SBAN02, SBAN03, SBAN04, SBAN05, SBAN06, SBAN07, SBAN08, SBAN09, SBAN10, SBAN11, SBAN12, SBAN13, SBAN14, SBAPYN, SBAND01, SBAND02, SBAND03, SBAND04, SBAND05, SBAND06, SBAND07, SBAND08, SBAND09, SBAND10, SBAND11, SBAND12, SBAND13, SBAND14, SBWEA1, SBC75INID, SBFUTMATH1, SBFUTSTR1, SBFUTDATE1, SBFUTUO1, SBUSER, SBPID, SBJOBN, SBUPMJ, SBUPMT FROM F75C902

TOP920 | 75C | F75C902 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SBAIDAccount IDStringGeneric Edit80 Allow NULL? 
2SBCTRYCenturyNumericGeneric Edit20 Allow NULL? 
3SBFYFiscal YearNumericGeneric Edit20 Allow NULL? 
4SBLTLedger TypesStringUDC (09 LT)20 Allow NULL? 
5SBSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
6SBSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
7SBCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
8SBC75SUB1Subsidiary Item ID 1StringGeneric Edit600 Allow NULL? 
9SBC75SUB2Subsidiary Item ID 2StringGeneric Edit600 Allow NULL? 
10SBC75SUB3Subsidiary Item ID 3StringGeneric Edit600 Allow NULL? 
11SBC75SUB4Subsidiary Item ID 4StringGeneric Edit600 Allow NULL? 
12SBC75SUB5Subsidiary Item ID 5StringGeneric Edit600 Allow NULL? 
13SBC75SUB6Subsidiary Item ID 6StringGeneric Edit600 Allow NULL? 
14SBC75SUB7Subsidiary Item ID 7StringGeneric Edit600 Allow NULL? 
15SBC75SUB8Subsidiary Item ID 8StringGeneric Edit600 Allow NULL? 
16SBC75SUB9Subsidiary Item ID 9StringGeneric Edit600 Allow NULL? 
17SBC75SUB10Subsidiary Item ID 10StringGeneric Edit600 Allow NULL? 
18SBC75SUB11Subsidiary Item ID 11StringGeneric Edit600 Allow NULL? 
19SBC75SUB12Subsidiary Item ID 12StringGeneric Edit600 Allow NULL? 
20SBC75SUB13Subsidiary Item ID 13StringGeneric Edit600 Allow NULL? 
21SBC75SUB14Subsidiary Item ID 14StringGeneric Edit600 Allow NULL? 
22SBC75SUB15Subsidiary Item ID 15StringGeneric Edit600 Allow NULL? 
23SBC75SUB16Subsidiary Item ID 16StringGeneric Edit600 Allow NULL? 
24SBC75SUB17Subsidiary Item ID 17StringGeneric Edit600 Allow NULL? 
25SBC75SUB18Subsidiary Item ID 18StringGeneric Edit600 Allow NULL? 
26SBC75SUB19Subsidiary Item ID 19StringGeneric Edit600 Allow NULL? 
27SBC75SUB20Subsidiary Item ID 20StringGeneric Edit600 Allow NULL? 
28SBC75SUB21Subsidiary Item ID 21StringGeneric Edit600 Allow NULL? 
29SBC75SUB22Subsidiary Item ID 22StringGeneric Edit600 Allow NULL? 
30SBC75SUB23Subsidiary Item ID 23StringGeneric Edit600 Allow NULL? 
31SBC75SUB24Subsidiary Item ID 24StringGeneric Edit600 Allow NULL? 
32SBC75SUB25Subsidiary Item ID 25StringGeneric Edit600 Allow NULL? 
33SBC75SUB26Subsidiary Item ID 26StringGeneric Edit600 Allow NULL? 
34SBC75SUB27Subsidiary Item ID 27StringGeneric Edit600 Allow NULL? 
35SBC75SUB28Subsidiary Item ID 28StringGeneric Edit600 Allow NULL? 
36SBC75SUB29Subsidiary Item ID 29StringGeneric Edit600 Allow NULL? 
37SBC75SUB30Subsidiary Item ID 30StringGeneric Edit600 Allow NULL? 
38SBAPYCAmount - Beginning Balance/PYE ForwardNumericGeneric Edit152 Allow NULL? 
39SBAN01Amount - Net Posting 01NumericGeneric Edit152 Allow NULL? 
40SBAN02Amount - Net Posting 02NumericGeneric Edit152 Allow NULL? 
41SBAN03Amount - Net Posting 03NumericGeneric Edit152 Allow NULL? 
42SBAN04Amount - Net Posting 04NumericGeneric Edit152 Allow NULL? 
43SBAN05Amount - Net Posting 05NumericGeneric Edit152 Allow NULL? 
44SBAN06Amount - Net Posting 06NumericGeneric Edit152 Allow NULL? 
45SBAN07Amount - Net Posting 07NumericGeneric Edit152 Allow NULL? 
46SBAN08Amount - Net Posting 08NumericGeneric Edit152 Allow NULL? 
47SBAN09Amount - Net Posting 09NumericGeneric Edit152 Allow NULL? 
48SBAN10Amount - Net Posting 10NumericGeneric Edit152 Allow NULL? 
49SBAN11Amount - Net Posting 11NumericGeneric Edit152 Allow NULL? 
50SBAN12Amount - Net Posting 12NumericGeneric Edit152 Allow NULL? 
51SBAN13Amount - Net Posting 13NumericGeneric Edit152 Allow NULL? 
52SBAN14Amount - Net Posting 14NumericGeneric Edit152 Allow NULL? 
53SBAPYNAmount - Prior Year Net PostingsNumericGeneric Edit152 Allow NULL? 
54SBAND01Amount - Net Debit Posting 01NumericGeneric Edit152 Allow NULL? 
55SBAND02Amount - Net Debit Posting 02NumericGeneric Edit152 Allow NULL? 
56SBAND03Amount - Net Debit Posting 03NumericGeneric Edit152 Allow NULL? 
57SBAND04Amount - Net Debit Posting 04NumericGeneric Edit152 Allow NULL? 
58SBAND05Amount - Net Debit Posting 05NumericGeneric Edit152 Allow NULL? 
59SBAND06Amount - Net Debit Posting 06NumericGeneric Edit152 Allow NULL? 
60SBAND07Amount - Net Debit Posting 07NumericGeneric Edit152 Allow NULL? 
61SBAND08Amount - Net Debit Posting 08NumericGeneric Edit152 Allow NULL? 
62SBAND09Amount - Net Debit Posting 09NumericGeneric Edit152 Allow NULL? 
63SBAND10Amount - Net Debit Posting 10NumericGeneric Edit152 Allow NULL? 
64SBAND11Amount - Net Debit Posting 11NumericGeneric Edit152 Allow NULL? 
65SBAND12Amount - Net Debit Posting 12NumericGeneric Edit152 Allow NULL? 
66SBAND13Amount - Net Debit Posting 13NumericGeneric Edit152 Allow NULL? 
67SBAND14Amount - Net Debit Posting 14NumericGeneric Edit152 Allow NULL? 
68SBWEA1Ending Balance 1NumericGeneric Edit152 Allow NULL? 
69SBC75INIDTables PK Internal IDNumericGeneric Edit150 Allow NULL? 
70SBFUTMATH1Future Use Math 1NumericGeneric Edit154 Allow NULL? 
71SBFUTSTR1Future Use String 1StringGeneric Edit500 Allow NULL? 
72SBFUTDATE1Future Use Translation Date 1DateGeneric Edit60
73SBFUTUO1Future Use Field 1CharacterGeneric Edit10 Allow NULL? 
74SBUSERUser IDStringGeneric Edit100 Allow NULL? 
75SBPIDProgram IDStringGeneric Edit100 Allow NULL? 
76SBJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
77SBUPMJDate - UpdatedDateGeneric Edit60
78SBUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 

TOP920 | 75C | F75C902 INDEXES

NumberDescription
1Internal ID Account ID (Primary/Unique)
ElementAliasDescriptionSequence
1AIDAccount IDAscending
2C75INIDTables PK Internal IDAscending
3CTRYCenturyAscending
4FYFiscal YearAscending
5LTLedger TypesAscending
6SBLTSubledger TypeAscending
7SBLSubledger - G/LAscending
8CRCDCurrency Code - FromAscending