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

196 COLUMNS | 2 INDEXES | Print definition?920 | 04 | F0411Z3 TABLE

04: Accounts Payable
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F0411Z3SZ1962F0411 Interoperability TableBatch Input Files04: Accounts PayableBusiness 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, SZDOC, SZDCT, SZSFX, SZSFXE, SZDCTA, SZAN8, SZPYE, SZSNTO, SZDIVJ, SZDSVJ, SZDDJ, SZDDNJ, SZDGJ, SZFY, SZCTRY, SZPN, SZCO, SZICU, SZICUT, SZDICJ, SZBALJ, SZPST, SZAG, SZAAP, SZADSC, SZADSA, SZATXA, SZATXN, SZSTAM, SZTXA1, SZEXR1, SZCRRM, SZCRCD, SZCRDC, SZCRR, SZACR, SZFAP, SZCDS, SZCDSA, SZCTXA, SZCTXN, SZCTAM, SZGLC, SZGLBA, SZPOST, SZAM, SZAID2, SZMCU, SZOBJ, SZSUB, SZSBLT, SZSBL, SZBAID, SZPTC, SZVOD, SZOKCO, SZODCT, SZODOC, SZOSFX, SZCRC, SZVINV, SZPKCO, SZPO, SZPDCT, SZLNID, SZSFXO, SZOPSQ, SZVR01, SZUNIT, SZMCU2, SZRMK, SZRF, SZDRF, SZCTL, SZFNLP, SZU, SZUM, SZPYIN, SZTXA3, SZEXR3, SZRP1, SZRP2, SZRP3, SZAC07, SZTNN, SZDMCD, SZITM, SZHCRR, SZHDGJ, SZDIM, SZDID, SZDIY, SZDI#, SZDSVM, SZDSVD, SZDSVY, SZDSY#, SZDDM, SZDDD, SZDDY, SZDD#, SZDDNM, SZDDND, SZDDNY, SZDDN#, SZDGM, SZDGD, SZDGY, SZDG#, SZDICM, SZDICD, SZDICY, SZDIC#, SZHDGM, SZHDGD, SZHDGY, SZHDG#, SZDOCM, SZURC1, SZUPMT, SZURCD, SZURDT, SZURAT, SZURAB, SZURRF, SZTORG, SZUSER, SZPID, SZJOBN, SZUPMJ, SZTDAY, SZTNST, SZYC01, SZYC02, SZYC03, SZYC04, SZYC05, SZYC06, SZYC07, SZYC08, SZYC09, SZYC10, SZDTXS, SZBCRC, SZATAD, SZCTAD, SZNRTA, SZFNRT, SZTAXP, SZPRGF, SZGFL5, SZGFL6, SZGAM1, SZGAM2, SZGEN4, SZGEN5, SZWTAD, SZWTAF, SZSMMF, SZPYWP, SZPWPG, SZNETTCID, SZNETDOC, SZNETRC5, SZNETST, SZCNTRTID, SZCNTRTCD, SZWVID, SZBLSCD2, SZHARPER, SZHARSFX, SZDDRL, SZSEQN FROM F0411Z3

TOP920 | 04 | F0411Z3 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? 
24SZDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
25SZDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
26SZSFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
27SZSFXEPay Item Extension NumberNumericGeneric Edit20 Allow NULL? 
28SZDCTADocument Type - AdjustingStringUDC (00 DT)20 Allow NULL? 
29SZAN8Address NumberNumericGeneric Edit80 Allow NULL? 
30SZPYEPayee Address NumberNumericGeneric Edit80 Allow NULL? 
31SZSNTOAddress Number - ApproverNumericGeneric Edit80 Allow NULL? 
32SZDIVJDate - Invoice - JulianDateGeneric Edit60
33SZDSVJDate - Service/TaxDateGeneric Edit60
34SZDDJDate - Net DueDateGeneric Edit60
35SZDDNJDate - Discount Due - JulianDateGeneric Edit60
36SZDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
37SZFYFiscal YearNumericGeneric Edit20 Allow NULL? 
38SZCTRYCenturyNumericGeneric Edit20 Allow NULL? 
39SZPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
40SZCOCompanyStringGeneric Edit50 Allow NULL? 
41SZICUBatch NumberNumericGeneric Edit80 Allow NULL? 
42SZICUTBatch TypeStringUDC (98 IT)20 Allow NULL? 
43SZDICJDate - Batch (Julian)DateGeneric Edit60
44SZBALJBalanced - Journal EntriesCharacterUDC (H00 BB)10 Allow NULL? 
45SZPSTPay Status CodeCharacterUDC (00 PS)10 Allow NULL? 
46SZAGAmount - GrossNumericGeneric Edit152 Allow NULL? 
47SZAAPAmount OpenNumericGeneric Edit152 Allow NULL? 
48SZADSCDiscount AvailableNumericGeneric Edit152 Allow NULL? 
49SZADSADiscount TakenNumericGeneric Edit152 Allow NULL? 
50SZATXAAmount - TaxableNumericGeneric Edit152 Allow NULL? 
51SZATXNAmount - Non-TaxableNumericGeneric Edit152 Allow NULL? 
52SZSTAMAmount - TaxNumericGeneric Edit152 Allow NULL? 
53SZTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
54SZEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
55SZCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
56SZCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
57SZCRDCCurrency Code - ToStringGeneric Edit30 Allow NULL? 
58SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
59SZACRAmount - CurrencyNumericGeneric Edit152 Allow NULL? 
60SZFAPAmount - Foreign OpenNumericGeneric Edit152 Allow NULL? 
61SZCDSAmount - Foreign Discount AvailableNumericGeneric Edit152 Allow NULL? 
62SZCDSAAmount - Foreign Discount TakenNumericGeneric Edit152 Allow NULL? 
63SZCTXAAmount - Foreign TaxableNumericGeneric Edit152 Allow NULL? 
64SZCTXNAmount - Foreign Non-TaxableNumericGeneric Edit152 Allow NULL? 
65SZCTAMAmount - Foreign TaxNumericGeneric Edit152 Allow NULL? 
66SZGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
67SZGLBAG/L Bank AccountStringGeneric Edit80 Allow NULL? 
68SZPOSTG/L Posted CodeCharacterGeneric Edit10 Allow NULL? 
69SZAMAccount Mode - G/LCharacterUDC (H09 AM)10 Allow NULL? 
70SZAID2Account IDStringGeneric Edit80 Allow NULL? 
71SZMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
72SZOBJObject AccountStringGeneric Edit60 Allow NULL? 
73SZSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
74SZSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
75SZSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
76SZBAIDBank Transit Short IDStringGeneric Edit80 Allow NULL? 
77SZPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
78SZVODVoid FlagCharacterGeneric Edit10 Allow NULL? 
79SZOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
80SZODCTDocument Type - OriginalStringUDC (00 DT)20 Allow NULL? 
81SZODOCDocument - OriginalNumericGeneric Edit80 Allow NULL? 
82SZOSFXDocument Pay Item - OriginalStringGeneric Edit30 Allow NULL? 
83SZCRCPayment Handling CodeStringUDC (00 HC)30 Allow NULL? 
84SZVINVSupplier Invoice NumberStringGeneric Edit250 Allow NULL? 
85SZPKCODocument Company (Purchase Order)StringGeneric Edit50 Allow NULL? 
86SZPOPurchase OrderStringGeneric Edit80 Allow NULL? 
87SZPDCTDocument Type - Purchase OrderStringUDC (00 DT)20 Allow NULL? 
88SZLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
89SZSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
90SZOPSQSequence Number - OperationsNumericGeneric Edit52 Allow NULL? 
91SZVR01ReferenceStringGeneric Edit250 Allow NULL? 
92SZUNITUnitStringGeneric Edit80 Allow NULL? 
93SZMCU2Business Unit 2StringGeneric Edit120 Allow NULL? 
94SZRMKName - RemarkStringGeneric Edit300 Allow NULL? 
95SZRFFrequency - RecurringStringUDC (H00 RF)20 Allow NULL? 
96SZDRFRecurring Frequency # of PaymentsNumericGeneric Edit30 Allow NULL? 
97SZCTLControl/Statement FieldStringGeneric Edit130 Allow NULL? 
98SZFNLPClosed Item - As Of ProcessingCharacterGeneric Edit10 Allow NULL? 
99SZUUnitsNumericGeneric Edit152 Allow NULL? 
100SZUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
101SZPYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
102SZTXA3Tax Rate/Area 3 - WithholdingStringGeneric Edit100 Allow NULL? 
103SZEXR3Tax Expl Code 3 - WithholdingStringUDC (00 EX)20 Allow NULL? 
104SZRP1A/R - A/P - Miscellaneous Code 1CharacterGeneric Edit10 Allow NULL? 
105SZRP2A/R - A/P - Miscellaneous Code 2CharacterGeneric Edit10 Allow NULL? 
106SZRP3A/R - A/P - Cash Rcpts/Inv Reg CodeCharacterGeneric Edit10 Allow NULL? 
107SZAC07Category Code - Address Book 07StringUDC (01 07)30 Allow NULL? 
108SZTNNFlag for 1099CharacterGeneric Edit10 Allow NULL? 
109SZDMCDDomestic Entry w/Mult Currency DistrCharacterGeneric Edit10 Allow NULL? 
110SZITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
111SZHCRRHistorical Currency Conversion RateNumericGeneric Edit150 Allow NULL? 
112SZHDGJHistorical Date - JulianDateGeneric Edit60
113SZDIMDate - Invoice - MONumericGeneric Edit20 Allow NULL? 
114SZDIDDate - Invoice - DANumericGeneric Edit20 Allow NULL? 
115SZDIYDate - Invoice - YRNumericGeneric Edit20 Allow NULL? 
116SZDI#Date - Invoice - CTRYNumericGeneric Edit20 Allow NULL? 
117SZDSVMDate - Service/Tax - MONumericGeneric Edit20 Allow NULL? 
118SZDSVDDate - Service/Tax - DANumericGeneric Edit20 Allow NULL? 
119SZDSVYDate - Service/Tax - YRNumericGeneric Edit20 Allow NULL? 
120SZDSY#Date - Batch System Date - CTRYNumericGeneric Edit20 Allow NULL? 
121SZDDMDate - Net Due - MONumericGeneric Edit20 Allow NULL? 
122SZDDDDate - Net Due - DANumericGeneric Edit20 Allow NULL? 
123SZDDYDate - Net Due - YRNumericGeneric Edit20 Allow NULL? 
124SZDD#Date - Net Due - CTRYNumericGeneric Edit20 Allow NULL? 
125SZDDNMDate - Discount Due - MONumericGeneric Edit20 Allow NULL? 
126SZDDNDDate - Discount Due -DANumericGeneric Edit20 Allow NULL? 
127SZDDNYDate - Discount Due - YRNumericGeneric Edit20 Allow NULL? 
128SZDDN#Date - Discount Due - CTRYNumericGeneric Edit20 Allow NULL? 
129SZDGMDate - For G/L (and Voucher) - MONumericGeneric Edit20 Allow NULL? 
130SZDGDDate - For G/L (and Voucher) - DANumericGeneric Edit20 Allow NULL? 
131SZDGYDate - For G/L (and Voucher) - YRNumericGeneric Edit20 Allow NULL? 
132SZDG#Date - For G/L (and Voucher) - CTRYNumericGeneric Edit20 Allow NULL? 
133SZDICMDate - Batch - MONumericGeneric Edit20 Allow NULL? 
134SZDICDDate - Batch - DANumericGeneric Edit20 Allow NULL? 
135SZDICYDate - Batch - YRNumericGeneric Edit20 Allow NULL? 
136SZDIC#Date - Batch - CTRYNumericGeneric Edit20 Allow NULL? 
137SZHDGMHistorical Date - MONumericGeneric Edit20 Allow NULL? 
138SZHDGDHistorical Date - DANumericGeneric Edit20 Allow NULL? 
139SZHDGYHistorical Date - YRNumericGeneric Edit20 Allow NULL? 
140SZHDG#Historical Date - CTRYNumericGeneric Edit20 Allow NULL? 
141SZDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80 Allow NULL? 
142SZURC1User Reserved CodeStringGeneric Edit30 Allow NULL? 
143SZUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
144SZURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
145SZURDTUser Reserved DateDateGeneric Edit60
146SZURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
147SZURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
148SZURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
149SZTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
150SZUSERUser IDStringGeneric Edit100 Allow NULL? 
151SZPIDProgram IDStringGeneric Edit100 Allow NULL? 
152SZJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
153SZUPMJDate - UpdatedDateGeneric Edit60
154SZTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
155SZTNSTTransit Number - BankStringGeneric Edit200 Allow NULL? 
156SZYC01Category Code - A/P Ledger 01StringUDC (01 01)30 Allow NULL? 
157SZYC02Category Code - A/P Ledger 02StringUDC (01 02)30 Allow NULL? 
158SZYC03Category Code - A/P Ledger 03StringUDC (01 03)30 Allow NULL? 
159SZYC04Category Code - A/P Ledger 04StringUDC (01 04)30 Allow NULL? 
160SZYC05Category Code - A/P Ledger 05StringUDC (01 05)30 Allow NULL? 
161SZYC06Category Code - A/P Ledger 06StringUDC (01 06)30 Allow NULL? 
162SZYC07Category Code - A/P Ledger 07StringUDC (01 07)30 Allow NULL? 
163SZYC08Category Code - A/P Ledger 08StringUDC (01 08)30 Allow NULL? 
164SZYC09Category Code - A/P Ledger 09StringUDC (01 09)30 Allow NULL? 
165SZYC10Category Code - A/P Ledger 10StringUDC (01 10)30 Allow NULL? 
166SZDTXSDeferred Tax Status - VATCharacterGeneric Edit10 Allow NULL? 
167SZBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
168SZATADAmount - To DistributeNumericGeneric Edit152 Allow NULL? 
169SZCTADAmount - Currency To DistributeNumericGeneric Edit152 Allow NULL? 
170SZNRTANon-Recoverable Tax AmountNumericGeneric Edit152 Allow NULL? 
171SZFNRTForeign Non-Recoverable TaxNumericGeneric Edit152 Allow NULL? 
172SZTAXPPurchasing Taxable Y/NCharacterGeneric Edit10 Allow NULL? 
173SZPRGFPurge FlagCharacterGeneric Edit10 Allow NULL? 
174SZGFL5Generic Flag 5CharacterGeneric Edit10 Allow NULL? 
175SZGFL6Generic Flag 6CharacterGeneric Edit10 Allow NULL? 
176SZGAM1Generic Amount 1NumericGeneric Edit152 Allow NULL? 
177SZGAM2Generic Amount 2NumericGeneric Edit152 Allow NULL? 
178SZGEN4Generic String 4StringGeneric Edit250 Allow NULL? 
179SZGEN5Generic String 5StringGeneric Edit250 Allow NULL? 
180SZWTADFuture - Withholding Tax Amount DomesticNumericGeneric Edit152 Allow NULL? 
181SZWTAFFuture - Withholding Tax Amount ForeignNumericGeneric Edit152 Allow NULL? 
182SZSMMFSummarized FlagCharacterGeneric Edit10 Allow NULL? 
183SZPYWPPay When PaidCharacterGeneric Edit10 Allow NULL? 
184SZPWPGPay When Paid Group NumberNumericGeneric Edit150 Allow NULL? 
185SZNETTCIDNetting Transaction IDNumericGeneric Edit150 Allow NULL? 
186SZNETDOCNetting Document NumberNumericGeneric Edit150 Allow NULL? 
187SZNETRC5Netting Line IDNumericGeneric Edit60 Allow NULL? 
188SZNETSTNetting Status CodeCharacterUDC (00 NS)10 Allow NULL? 
189SZCNTRTIDContract IDNumericGeneric Edit80 Allow NULL? 
190SZCNTRTCDContract CodeStringGeneric Edit120 Allow NULL? 
191SZWVIDVessel IDNumericGeneric Edit80 Allow NULL? 
192SZBLSCD2Block CodeStringGeneric Edit100 Allow NULL? 
193SZHARPERHarvest PeriodStringGeneric Edit60 Allow NULL? 
194SZHARSFXHarvest SuffixStringGeneric Edit100 Allow NULL? 
195SZDDRLDue Date RuleStringGeneric Edit50 Allow NULL? 
196SZSEQNSequence NumberNumericGeneric Edit70 Allow NULL? 

TOP920 | 04 | F0411Z3 INDEXES

NumberDescription
1User ID Batch Number + (Primary/Unique)
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4EDLNEDI - Line NumberAscending
2Doc Number Doc Type +
ElementAliasDescriptionSequence
1DOCDocument (Voucher Invoice etc.)Ascending
2DCTDocument TypeAscending
3KCODocument CompanyAscending
4SFXDocument Pay ItemAscending