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
4F4211SDSales Order Detail File
5F4311PDPurchase 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
03B: Enhanced Accounts Receivable
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F03B14Z2SZ1492F03B14 Interoperability TableBatch Input Files03B: Enhanced Accounts ReceivableBusiness 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, SZPYID, SZRC5, SZCKNU, SZDOC, SZDCT, SZKCO, SZSFX, SZAN8, SZDCTM, SZDMTJ, SZDGJ, SZPOST, SZGLC, SZAID, SZCTRY, SZFY, SZPN, SZCO, SZICUT, SZICU, SZDICJ, SZPA8, SZRPID, SZRLIN, SZPAAP, SZADSC, SZADSA, SZAAAJ, SZECBA, SZDDA, SZBCRC, SZCRRM, SZCRCD, SZCRR, SZPFAP, SZCDS, SZCDSA, SZFCHG, SZECBF, SZFDA, SZAGL, SZAIDT, SZTCRC, SZTAAP, SZTADA, SZTAAJ, SZTCBA, SZTDA, SZACRR, SZACR1, SZACR2, SZACRM, SZAGLA, SZAIDA, SZAIDD, SZRSCO, SZAIDW, SZECBR, SZGLCC, SZAIDC, SZDDEX, SZDAID, SZTYIN, SZUTIC, SZUCTF, SZAID2, SZAM2, SZMCU, SZSBL, SZSBLT, SZPKCO, SZPO, SZPDCT, SZNUMB, SZUNIT, SZMCU2, SZRMK, SZFNLP, SZALT6, SZODOC, SZODCT, SZOKCO, SZOSFX, SZGDOC, SZGDCT, SZGKCO, SZGSFX, SZDCTG, SZDOCG, SZKCOG, SZCTL, SZSMTJ, SZVDGJ, SZVRE, SZNFVD, SZHCRR, SZISTC, SZLFCJ, SZPDLT, SZDDJ, SZDDNJ, SZIDGJ, SZDDST, SZVR01, SZRFID, SZRIDC, SZPRGF, SZGFL1, SZRNID, SZURCD, SZURDT, SZURAT, SZURAB, SZURRF, SZTORG, SZUSER, SZPID, SZJOBN, SZUPMJ, SZTDAY, SZSHPN, SZRASI, SZRAMT, SZSFXO, SZDCTO, SZKCOO, SZDOCO, SZGFL2, SZOMOD, SZLRFL, SZDRCO, SZURC1, SZNETTCID, SZNETDOC, SZNETRC5, SZADGJ FROM F03B14Z2

TOP920 | 03B | F03B14Z2 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? 
14SZPYIDPayment ID (Internal)NumericGeneric Edit150 Allow NULL? 
15SZRC5File Line Identifier 5.0NumericGeneric Edit50 Allow NULL? 
16SZCKNUReceipt NumberStringGeneric Edit250 Allow NULL? 
17SZDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
18SZDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
19SZKCODocument CompanyStringGeneric Edit50 Allow NULL? 
20SZSFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
21SZAN8Address NumberNumericGeneric Edit80 Allow NULL? 
22SZDCTMDocument Type - MatchingStringUDC (00 DT)20 Allow NULL? 
23SZDMTJDate - Matching Check or Item - JulianDateGeneric Edit60
24SZDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
25SZPOSTG/L Posted CodeCharacterGeneric Edit10 Allow NULL? 
26SZGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
27SZAIDAccount IDStringGeneric Edit80 Allow NULL? 
28SZCTRYCenturyNumericGeneric Edit20 Allow NULL? 
29SZFYFiscal YearNumericGeneric Edit20 Allow NULL? 
30SZPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
31SZCOCompanyStringGeneric Edit50 Allow NULL? 
32SZICUTBatch TypeStringUDC (98 IT)20 Allow NULL? 
33SZICUBatch NumberNumericGeneric Edit80 Allow NULL? 
34SZDICJDate - Batch (Julian)DateGeneric Edit60
35SZPA8Address Number - ParentNumericGeneric Edit80 Allow NULL? 
36SZRPIDRelated Payment IDNumericGeneric Edit150 Allow NULL? 
37SZRLINRelated Payment Line IDNumericGeneric Edit50 Allow NULL? 
38SZPAAPPayment AmountNumericGeneric Edit152 Allow NULL? 
39SZADSCDiscount AvailableNumericGeneric Edit152 Allow NULL? 
40SZADSADiscount TakenNumericGeneric Edit152 Allow NULL? 
41SZAAAJAmount - Write OffNumericGeneric Edit152 Allow NULL? 
42SZECBAAmount - ChargebackNumericGeneric Edit152 Allow NULL? 
43SZDDAAmount - DeductionNumericGeneric Edit152 Allow NULL? 
44SZBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
45SZCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
46SZCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
47SZCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
48SZPFAPPayment Amount - ForeignNumericGeneric Edit152 Allow NULL? 
49SZCDSAmount - Foreign Discount AvailableNumericGeneric Edit152 Allow NULL? 
50SZCDSAAmount - Foreign Discount TakenNumericGeneric Edit152 Allow NULL? 
51SZFCHGAmount - Foreign Changed AmountNumericGeneric Edit152 Allow NULL? 
52SZECBFAmount - Foreign ChargebackNumericGeneric Edit152 Allow NULL? 
53SZFDAAmount - Foreign DeductionNumericGeneric Edit152 Allow NULL? 
54SZAGLAmount Gain/LossNumericGeneric Edit152 Allow NULL? 
55SZAIDTGain/Loss Account IDStringGeneric Edit80 Allow NULL? 
56SZTCRCTransaction Currency CodeStringGeneric Edit30 Allow NULL? 
57SZTAAPTransaction Payment AmountNumericGeneric Edit152 Allow NULL? 
58SZTADATransaction Discount AmountNumericGeneric Edit152 Allow NULL? 
59SZTAAJTransaction Write Off AmountNumericGeneric Edit152 Allow NULL? 
60SZTCBATransaction Charge Back AmountNumericGeneric Edit152 Allow NULL? 
61SZTDATransaction Deduction AmountNumericGeneric Edit152 Allow NULL? 
62SZACRRAlternate Currency Exchange RateNumericGeneric Edit150 Allow NULL? 
63SZACR1Alternate Currency Rate 1NumericGeneric Edit150 Allow NULL? 
64SZACR2Alternate Currency Rate 2NumericGeneric Edit150 Allow NULL? 
65SZACRMAlt Currency Conversion Y/ZCharacterGeneric Edit10 Allow NULL? 
66SZAGLAAlternate Currency Gain/LossNumericGeneric Edit152 Allow NULL? 
67SZAIDAAlt Curr Gain/Loss Account IDStringGeneric Edit80 Allow NULL? 
68SZAIDDDiscount Account IDStringGeneric Edit80 Allow NULL? 
69SZRSCOWrite-Off Reason CodeStringUDC (03B RC)20 Allow NULL? 
70SZAIDWWrite-Off Account IDStringGeneric Edit80 Allow NULL? 
71SZECBRChargeback Reason CodeStringUDC (03B CB)20 Allow NULL? 
72SZGLCCG/L Offset ChargebacksStringGeneric Edit40 Allow NULL? 
73SZAIDCChargeback Account IDStringGeneric Edit80 Allow NULL? 
74SZDDEXDeduction Reason CodeStringUDC (03B CR)20 Allow NULL? 
75SZDAIDDeduction Account IDStringGeneric Edit80 Allow NULL? 
76SZTYINReceipt Type CodeCharacterUDC (03B TI)10 Allow NULL? 
77SZUTICUser Type Input CodeStringUDC (03B RE)20 Allow NULL? 
78SZUCTFUnapplied Cash TransferCharacterGeneric Edit10 Allow NULL? 
79SZAID2Account IDStringGeneric Edit80 Allow NULL? 
80SZAM2Account Mode - G/LCharacterUDC (H09 AM)10 Allow NULL? 
81SZMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
82SZSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
83SZSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
84SZPKCODocument Company (Purchase Order)StringGeneric Edit50 Allow NULL? 
85SZPOPurchase OrderStringGeneric Edit80 Allow NULL? 
86SZPDCTDocument Type - Purchase OrderStringUDC (00 DT)20 Allow NULL? 
87SZNUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
88SZUNITUnitStringGeneric Edit80 Allow NULL? 
89SZMCU2Business Unit 2StringGeneric Edit120 Allow NULL? 
90SZRMKName - RemarkStringGeneric Edit300 Allow NULL? 
91SZFNLPClosed Item - As Of ProcessingCharacterGeneric Edit10 Allow NULL? 
92SZALT6G/L Posting Code - Cash Basis AcctCharacterGeneric Edit10 Allow NULL? 
93SZODOCDocument - OriginalNumericGeneric Edit80 Allow NULL? 
94SZODCTDocument Type - OriginalStringUDC (00 DT)20 Allow NULL? 
95SZOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
96SZOSFXDocument Pay Item - OriginalStringGeneric Edit30 Allow NULL? 
97SZGDOCDeduction Document NumberNumericGeneric Edit80 Allow NULL? 
98SZGDCTDeduction Document TypeStringUDC (00 DT)20 Allow NULL? 
99SZGKCODeduction Document CompanyStringGeneric Edit50 Allow NULL? 
100SZGSFXDeduction Document Pay ItemStringGeneric Edit30 Allow NULL? 
101SZDCTGDocument Type - JEStringUDC (00 DT)20 Allow NULL? 
102SZDOCGDocument Number - JENumericGeneric Edit80 Allow NULL? 
103SZKCOGDocument Company - JEStringGeneric Edit50 Allow NULL? 
104SZCTLControl/Statement FieldStringGeneric Edit130 Allow NULL? 
105SZSMTJDate - StatementDateGeneric Edit60
106SZVDGJVoid Date - For G/L - JulianDateGeneric Edit60
107SZVREVoid Reason CodeStringUDC (03B VR)30 Allow NULL? 
108SZNFVDReceipt NSF/Void CodeCharacterGeneric Edit10 Allow NULL? 
109SZHCRRHistorical Currency Conversion RateNumericGeneric Edit150 Allow NULL? 
110SZISTCA/R Post to Cash ManagementCharacterGeneric Edit10 Allow NULL? 
111SZLFCJDate - Last Fee Calculated (Julian)DateGeneric Edit60
112SZPDLTPartial PaymentCharacterUDC (03B PL)10 Allow NULL? 
113SZDDJDate - Net DueDateGeneric Edit60
114SZDDNJDate - Discount Due - JulianDateGeneric Edit60
115SZIDGJDate - Invoice Journal Date - JulianDateGeneric Edit60
116SZDDSTDraft StatusCharacterUDC (03B DS)10 Allow NULL? 
117SZVR01ReferenceStringGeneric Edit250 Allow NULL? 
118SZRFIDReference ID (Internal)NumericGeneric Edit150 Allow NULL? 
119SZRIDCReference ID CodeCharacterGeneric Edit10 Allow NULL? 
120SZPRGFPurge FlagCharacterGeneric Edit10 Allow NULL? 
121SZGFL1Generic Flag 1CharacterGeneric Edit10 Allow NULL? 
122SZRNIDBatch Run ID (Internal)NumericGeneric Edit30 Allow NULL? 
123SZURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
124SZURDTUser Reserved DateDateGeneric Edit60
125SZURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
126SZURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
127SZURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
128SZTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
129SZUSERUser IDStringGeneric Edit100 Allow NULL? 
130SZPIDProgram IDStringGeneric Edit100 Allow NULL? 
131SZJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
132SZUPMJDate - UpdatedDateGeneric Edit60
133SZTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
134SZSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
135SZRASIRounding Account Short IDStringGeneric Edit80 Allow NULL? 
136SZRAMTRounding AmountNumericGeneric Edit152 Allow NULL? 
137SZSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
138SZDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
139SZKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
140SZDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
141SZGFL2Generic Flag 2CharacterGeneric Edit10 Allow NULL? 
142SZOMODOriginating SystemCharacterUDC (03B OS)10 Allow NULL? 
143SZLRFLLocalization Reserved FlagCharacterGeneric Edit10 Allow NULL? 
144SZDRCODiscount Reason CodeStringUDC (00 DE)30 Allow NULL? 
145SZURC1User Reserved CodeStringGeneric Edit30 Allow NULL? 
146SZNETTCIDNetting Transaction IDNumericGeneric Edit150 Allow NULL? 
147SZNETDOCNetting Document NumberNumericGeneric Edit150 Allow NULL? 
148SZNETRC5Netting Line IDNumericGeneric Edit60 Allow NULL? 
149SZADGJActual Receipt DateDateGeneric Edit60

TOP920 | 03B | F03B14Z2 INDEXES

NumberDescription
1User ID Batch Number + (Primary/Unique)
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4EDLNEDI - Line NumberAscending
2Payment ID File Line ID
ElementAliasDescriptionSequence
1PYIDPayment ID (Internal)Ascending
2RC5File Line Identifier 5.0Ascending