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

168 COLUMNS | 1 INDEXES | Print definition?920 | 09 | F0911Z4 TABLE

09: General Accounting
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F0911Z4SZ1681F0911 Interoperability TableBatch Input Files09: General AccountingBusiness 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 SZEDUS, SZEDBT, SZEDTN, SZEDLN, SZEDCT, SZTYTN, SZEDFT, SZEDDT, SZDRIN, SZEDDL, SZEDSP, SZPNID, SZTNAC, SZEDTY, SZEDSQ, SZEDTS, SZEDER, SZEDTC, SZEDTR, SZEDGL, SZEDDH, SZEDAN, SZKCO, SZDCT, SZDOC, SZDGJ, SZJELN, SZEXTL, SZPOST, SZICU, SZICUT, SZDICJ, SZDSYJ, SZTICU, SZCO, SZANI, SZAM, SZAID, SZMCU, SZOBJ, SZSUB, SZSBL, SZSBLT, SZLT, SZPN, SZCTRY, SZFY, SZFQ, SZCRCD, SZCRR, SZHCRR, SZHDGJ, SZAA, SZU, SZUM, SZGLC, SZRE, SZEXA, SZEXR, SZR1, SZR2, SZR3, SZSFX, SZODOC, SZODCT, SZOSFX, SZPKCO, SZOKCO, SZPDCT, SZAN8, SZCN, SZDKJ, SZDKC, SZASID, SZBRE, SZRCND, SZSUMM, SZPRGE, SZTNN, SZALT1, SZALT2, SZALT3, SZALT4, SZALT5, SZALT6, SZALT7, SZALT8, SZALT9, SZALT0, SZALTT, SZALTU, SZALTV, SZALTW, SZALTX, SZALTZ, SZDLNA, SZCFF1, SZCFF2, SZASM, SZBC, SZVINV, SZIVD, SZWR01, SZPO, SZPSFX, SZDCTO, SZLNID, SZWY, SZWN, SZFNLP, SZOPSQ, SZJBCD, SZJBST, SZHMCU, SZDOI, SZALID, SZALTY, SZDSVJ, SZREG#, SZPYID, SZCRRM, SZACR, SZCRDC, SZPYIN, SZURCD, SZURDT, SZURAT, SZURAB, SZURRF, SZTORG, SZUSER, SZPID, SZJOBN, SZUPMJ, SZTDAY, SZABR1, SZABR2, SZABR3, SZABR4, SZABT1, SZABT2, SZABT3, SZABT4, SZITM, SZPM01, SZPM02, SZPM03, SZPM04, SZPM05, SZPM06, SZPM07, SZPM08, SZPM09, SZPM10, SZBCRC, SZTXA1, SZEXR1, SZTXITM, SZACTB, SZDLNID, SZCKNU, SZBUPC, SZAHBU, SZEPGC, SZJPGC, SZRC5, SZSFXE, SZOFM FROM F0911Z4

TOP920 | 09 | F0911Z4 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SZEDUSEDI - User IDStringGeneric Edit100 Allow NULL? 
2SZEDBTEDI - Batch NumberStringGeneric Edit150 Allow NULL? 
3SZEDTNEDI - Transaction NumberStringGeneric Edit220 Allow NULL? 
4SZEDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
5SZEDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
6SZTYTNType - TransactionStringUDC (00 TT)80 Allow NULL? 
7SZEDFTEDI - Translation FormatStringGeneric Edit100 Allow NULL? 
8SZEDDTEDI - Transmission DateDateGeneric Edit60
9SZDRINDirection IndicatorCharacterUDC (00 DN)10 Allow NULL? 
10SZEDDLEDI - Detail Lines ProcessedNumericGeneric Edit50 Allow NULL? 
11SZEDSPEDI - Successfully ProcessedCharacterGeneric Edit10 Allow NULL? 
12SZPNIDTrading Partner IDStringGeneric Edit150 Allow NULL? 
13SZTNACTransaction ActionStringUDC (00 TA)20 Allow NULL? 
14SZEDTYType RecordCharacterUDC (00 RD)10 Allow NULL? 
15SZEDSQRecord SequenceNumericGeneric Edit20 Allow NULL? 
16SZEDTSEDI - Transaction Set NumberStringGeneric Edit60 Allow NULL? 
17SZEDEREDI - Send/Receive IndicatorCharacterUDC (H00 ED)10 Allow NULL? 
18SZEDTCEDI - Transaction ActionCharacterGeneric Edit10 Allow NULL? 
19SZEDTREDI - Transaction TypeCharacterGeneric Edit10 Allow NULL? 
20SZEDGLBatch File Create G/L RecordCharacterGeneric Edit10 Allow NULL? 
21SZEDDHBatch File Discount Handling FlagCharacterGeneric Edit10 Allow NULL? 
22SZEDANUser Address NumberNumericGeneric Edit80 Allow NULL? 
23SZKCODocument CompanyStringGeneric Edit50 Allow NULL? 
24SZDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
25SZDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
26SZDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
27SZJELNJournal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
28SZEXTLLine Extension CodeStringGeneric Edit20 Allow NULL? 
29SZPOSTG/L Posted CodeCharacterGeneric Edit10 Allow NULL? 
30SZICUBatch NumberNumericGeneric Edit80 Allow NULL? 
31SZICUTBatch TypeStringUDC (98 IT)20 Allow NULL? 
32SZDICJDate - Batch (Julian)DateGeneric Edit60
33SZDSYJDate - Batch System DateDateGeneric Edit60
34SZTICUBatch TimeNumericGeneric Edit60 Allow NULL? 
35SZCOCompanyStringGeneric Edit50 Allow NULL? 
36SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
37SZAMAccount Mode - G/LCharacterUDC (H09 AM)10 Allow NULL? 
38SZAIDAccount IDStringGeneric Edit80 Allow NULL? 
39SZMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
40SZOBJObject AccountStringGeneric Edit60 Allow NULL? 
41SZSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
42SZSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
43SZSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
44SZLTLedger TypesStringUDC (09 LT)20 Allow NULL? 
45SZPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
46SZCTRYCenturyNumericGeneric Edit20 Allow NULL? 
47SZFYFiscal YearNumericGeneric Edit20 Allow NULL? 
48SZFQFiscal Quarter (Obsolete)StringUDC (H09 FQ)40 Allow NULL? 
49SZCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
50SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
51SZHCRRHistorical Currency Conversion RateNumericGeneric Edit150 Allow NULL? 
52SZHDGJHistorical Date - JulianDateGeneric Edit60
53SZAAAmountNumericGeneric Edit152 Allow NULL? 
54SZUUnitsNumericGeneric Edit152 Allow NULL? 
55SZUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
56SZGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
57SZREReverse or Void (R/V)CharacterUDC (H09 RE)10 Allow NULL? 
58SZEXAName - Alpha ExplanationStringGeneric Edit300 Allow NULL? 
59SZEXRName - Remark ExplanationStringGeneric Edit300 Allow NULL? 
60SZR1Reference 1 - JE Voucher Invoice etc.StringGeneric Edit80 Allow NULL? 
61SZR2Reference 2StringGeneric Edit80 Allow NULL? 
62SZR3Reference 3 - Account ReconciliationStringGeneric Edit80 Allow NULL? 
63SZSFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
64SZODOCDocument - OriginalNumericGeneric Edit80 Allow NULL? 
65SZODCTDocument Type - OriginalStringUDC (00 DT)20 Allow NULL? 
66SZOSFXDocument Pay Item - OriginalStringGeneric Edit30 Allow NULL? 
67SZPKCODocument Company (Purchase Order)StringGeneric Edit50 Allow NULL? 
68SZOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
69SZPDCTDocument Type - Purchase OrderStringUDC (00 DT)20 Allow NULL? 
70SZAN8Address NumberNumericGeneric Edit80 Allow NULL? 
71SZCNPayment NumberStringGeneric Edit80 Allow NULL? 
72SZDKJDate - Check - JulianDateGeneric Edit60
73SZDKCDate - Check ClearedDateGeneric Edit60
74SZASIDSerial NumberStringGeneric Edit250 Allow NULL? 
75SZBREBatch Rear End Posted CodeCharacterUDC (09 BR)10 Allow NULL? 
76SZRCNDReconciled CodeCharacterUDC (09 RC)10 Allow NULL? 
77SZSUMMSummarized CodeCharacterGeneric Edit10 Allow NULL? 
78SZPRGEPurge CodeCharacterGeneric Edit10 Allow NULL? 
79SZTNNFlag for 1099CharacterGeneric Edit10 Allow NULL? 
80SZALT1G/L Posting Code - Alternate 1CharacterGeneric Edit10 Allow NULL? 
81SZALT2G/L Posting Code - Alternate 2CharacterGeneric Edit10 Allow NULL? 
82SZALT3G/L Posting Code - Alternate 3CharacterGeneric Edit10 Allow NULL? 
83SZALT4G/L Posting Code - Alternate 4CharacterGeneric Edit10 Allow NULL? 
84SZALT5G/L Posting Code - Alternate 5CharacterGeneric Edit10 Allow NULL? 
85SZALT6G/L Posting Code - Cash Basis AcctCharacterGeneric Edit10 Allow NULL? 
86SZALT7Commitment Relief FlagCharacterGeneric Edit10 Allow NULL? 
87SZALT8Billing ControlCharacterGeneric Edit10 Allow NULL? 
88SZALT9Currency UpdateCharacterGeneric Edit10 Allow NULL? 
89SZALT0G/L Posting Code - Alternate 0CharacterGeneric Edit10 Allow NULL? 
90SZALTTG/L Posting Code - Alternate TCharacterGeneric Edit10 Allow NULL? 
91SZALTUG/L Posting Code - Alternate UCharacterGeneric Edit10 Allow NULL? 
92SZALTVStocked Inventory CommitmentCharacterGeneric Edit10 Allow NULL? 
93SZALTWG/L Posting Code - Alternate WCharacterGeneric Edit10 Allow NULL? 
94SZALTXConsumption Tax Cross ReferenceCharacterGeneric Edit10 Allow NULL? 
95SZALTZG/L Posting Code - Account Debit BalanceCharacterGeneric Edit10 Allow NULL? 
96SZDLNADelete Not AllowedCharacterGeneric Edit10 Allow NULL? 
97SZCFF1Client Free Form - Alternate 1CharacterGeneric Edit10 Allow NULL? 
98SZCFF2Client Free Form - Alternate 2CharacterGeneric Edit10 Allow NULL? 
99SZASMLease Cost Ledger Posted CodeCharacterGeneric Edit10 Allow NULL? 
100SZBCBill CodeCharacterUDC (98 BC)10 Allow NULL? 
101SZVINVSupplier Invoice NumberStringGeneric Edit250 Allow NULL? 
102SZIVDDate - InvoiceDateGeneric Edit60
103SZWR01Categories - Work Order 01StringUDC (00 W1)40 Allow NULL? 
104SZPOPurchase OrderStringGeneric Edit80 Allow NULL? 
105SZPSFXPurchase Order SuffixStringGeneric Edit30 Allow NULL? 
106SZDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
107SZLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
108SZWYFiscal Year - WeeklyNumericGeneric Edit20 Allow NULL? 
109SZWNFiscal Period - WeeklyNumericGeneric Edit20 Allow NULL? 
110SZFNLPClosed Item - As Of ProcessingCharacterGeneric Edit10 Allow NULL? 
111SZOPSQSequence Number - OperationsNumericGeneric Edit52 Allow NULL? 
112SZJBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
113SZJBSTJob StepStringUDC (06 GS)40 Allow NULL? 
114SZHMCUBusiness Unit - HomeStringGeneric Edit120 Allow NULL? 
115SZDOIDOI SubNumericGeneric Edit20 Allow NULL? 
116SZALIDOutsider Lease or Well IDStringGeneric Edit250 Allow NULL? 
117SZALTYID TypeStringUDC (00 AL)20 Allow NULL? 
118SZDSVJDate - Service/TaxDateGeneric Edit60
119SZREG#Registration NumberNumericGeneric Edit80 Allow NULL? 
120SZPYIDPayment ID (Internal)NumericGeneric Edit150 Allow NULL? 
121SZCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
122SZACRAmount - CurrencyNumericGeneric Edit152 Allow NULL? 
123SZCRDCCurrency Code - ToStringGeneric Edit30 Allow NULL? 
124SZPYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
125SZURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
126SZURDTUser Reserved DateDateGeneric Edit60
127SZURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
128SZURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
129SZURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
130SZTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
131SZUSERUser IDStringGeneric Edit100 Allow NULL? 
132SZPIDProgram IDStringGeneric Edit100 Allow NULL? 
133SZJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
134SZUPMJDate - UpdatedDateGeneric Edit60
135SZTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
136SZABR1Managerial Analysis Code 1StringGeneric Edit120 Allow NULL? 
137SZABR2Managerial Analysis Code 2StringGeneric Edit120 Allow NULL? 
138SZABR3Managerial Analysis Code 3StringGeneric Edit120 Allow NULL? 
139SZABR4Managerial Analysis Code 4StringGeneric Edit120 Allow NULL? 
140SZABT1Managerial Analysis Type 1CharacterUDC10 Allow NULL? 
141SZABT2Managerial Analysis Type 2CharacterUDC10 Allow NULL? 
142SZABT3Managerial Analysis Type 3CharacterUDC10 Allow NULL? 
143SZABT4Managerial Analysis Type 4CharacterUDC10 Allow NULL? 
144SZITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
145SZPM01Posting Code 1 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
146SZPM02Posting Code 2 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
147SZPM03Posting Code 3 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
148SZPM04Posting Code 4 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
149SZPM05Posting Code 5 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
150SZPM06Posting Code 6 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
151SZPM07Posting Code 7 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
152SZPM08Posting Code 8 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
153SZPM09Posting Code 9 - Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
154SZPM10Posting Code 10- Managerial Accounting .CharacterGeneric Edit10 Allow NULL? 
155SZBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
156SZTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
157SZEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
158SZTXITMTax - Short Item NumberNumericGeneric Edit80 Allow NULL? 
159SZACTBActivity-Based Costing Activity CodeStringGeneric Edit100 Allow NULL? 
160SZDLNIDDistributionLine NumberNumericGeneric Edit63 Allow NULL? 
161SZCKNUReceipt NumberStringGeneric Edit250 Allow NULL? 
162SZBUPCBurdening Posted CodeCharacterGeneric Edit10 Allow NULL? 
163SZAHBUAlternate Home Business UnitStringGeneric Edit120 Allow NULL? 
164SZEPGCEmployee Pool Grouping CodeStringUDC (00 12)30 Allow NULL? 
165SZJPGCJob Pool Grouping CodeStringUDC (00 12)30 Allow NULL? 
166SZRC5File Line Identifier 5.0NumericGeneric Edit50 Allow NULL? 
167SZSFXEPay Item Extension NumberNumericGeneric Edit20 Allow NULL? 
168SZOFMAuto Offset Method (S Y or B)CharacterGeneric Edit10 Allow NULL? 

TOP920 | 09 | F0911Z4 INDEXES

NumberDescription
1User Batch Transaction Line (Primary/Unique)
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4EDLNEDI - Line NumberAscending