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
03B: Enhanced Accounts Receivable
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F03B11Z2SY1712F03B11 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 SYEDUS, SYEDBT, SYEDTN, SYEDLN, SYEDCT, SYTYTN, SYEDFT, SYEDDT, SYDRIN, SYEDDL, SYEDSP, SYPNID, SYTNAC, SYDOC, SYDCT, SYKCO, SYSFX, SYAN8, SYDGJ, SYDIVJ, SYICUT, SYICU, SYDICJ, SYFY, SYCTRY, SYPN, SYCO, SYGLC, SYAID, SYPA8, SYAN8J, SYPYR, SYPOST, SYISTR, SYBALJ, SYPST, SYAG, SYAAP, SYADSC, SYADSA, SYATXA, SYATXN, SYSTAM, SYBCRC, SYCRRM, SYCRCD, SYCRR, SYDMCD, SYACR, SYFAP, SYCDS, SYCDSA, SYCTXA, SYCTXN, SYCTAM, SYTXA1, SYEXR1, SYDSVJ, SYGLBA, SYAM, SYAID2, SYAM2, SYMCU, SYOBJ, SYSUB, SYSBLT, SYSBL, SYPTC, SYDDJ, SYDDNJ, SYRDDJ, SYRDSJ, SYLFCJ, SYSMTJ, SYNBRR, SYRDRL, SYRMDS, SYCOLL, SYCORC, SYAFC, SYDNLT, SYRSCO, SYODOC, SYODCT, SYOKCO, SYOSFX, SYVINV, SYPO, SYPDCT, SYPKCO, SYDCTO, SYLNID, SYSDOC, SYSDCT, SYSKCO, SYSFXO, SYVLDT, SYCMC1, SYVR01, SYUNIT, SYMCU2, SYRMK, SYALPH, SYRF, SYDRF, SYCTL, SYFNLP, SYITM, SYU, SYUM, SYALT6, SYRYIN, SYVDGJ, SYVOD, SYRP1, SYRP2, SYRP3, SYAR01, SYAR02, SYAR03, SYAR04, SYAR05, SYAR06, SYAR07, SYAR08, SYAR09, SYAR10, SYISTC, SYPYID, SYRNID, SYPPDI, SYJCL, SYDDEX, SYHCRR, SYHDGJ, SYDCP, SYURCD, SYURDT, SYURAT, SYURAB, SYURRF, SYTORG, SYUSER, SYPID, SYJOBN, SYUPMJ, SYTDAY, SYSHPN, SYDTXS, SYOMOD, SYCLMG, SYCMGR, SYATAD, SYCTAD, SYNRTA, SYFNRT, SYPRGF, SYGFL1, SYGFL2, SYDOCO, SYKCOO, SYSOTF, SYDTPB, SYERDJ, SYPWPG, SYNETTCID, SYNETDOC, SYNETRC5, SYNETST, SYAJCL, SYRMR1 FROM F03B11Z2

TOP910 | 03B | F03B11Z2 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SYEDUSEDI - User IDStringGeneric Edit100 Allow NULL? 
2SYEDBTEDI - Batch NumberStringGeneric Edit150 Allow NULL? 
3SYEDTNEDI - Transaction NumberStringGeneric Edit220 Allow NULL? 
4SYEDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
5SYEDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
6SYTYTNType - TransactionStringUDC (00 TT)80 Allow NULL? 
7SYEDFTEDI - Translation FormatStringGeneric Edit100 Allow NULL? 
8SYEDDTEDI - Transmission DateDateGeneric Edit60
9SYDRINDirection IndicatorCharacterUDC (00 DN)10 Allow NULL? 
10SYEDDLEDI - Detail Lines ProcessedNumericGeneric Edit50 Allow NULL? 
11SYEDSPEDI - Successfully ProcessedCharacterGeneric Edit10 Allow NULL? 
12SYPNIDTrading Partner IDStringGeneric Edit150 Allow NULL? 
13SYTNACTransaction ActionStringUDC (00 TA)20 Allow NULL? 
14SYDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
15SYDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
16SYKCODocument CompanyStringGeneric Edit50 Allow NULL? 
17SYSFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
18SYAN8Address NumberNumericUDC80 Allow NULL? 
19SYDGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
20SYDIVJDate - Invoice - JulianDateGeneric Edit60
21SYICUTBatch TypeStringUDC (98 IT)20 Allow NULL? 
22SYICUBatch NumberNumericGeneric Edit80 Allow NULL? 
23SYDICJDate - Batch (Julian)DateGeneric Edit60
24SYFYFiscal YearNumericGeneric Edit20 Allow NULL? 
25SYCTRYCenturyNumericGeneric Edit20 Allow NULL? 
26SYPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
27SYCOCompanyStringGeneric Edit50 Allow NULL? 
28SYGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
29SYAIDAccount IDStringGeneric Edit80 Allow NULL? 
30SYPA8Address Number - ParentNumericGeneric Edit80 Allow NULL? 
31SYAN8JAddress Number - Alternate PayeeNumericGeneric Edit80 Allow NULL? 
32SYPYRPayor Address NumberNumericGeneric Edit80 Allow NULL? 
33SYPOSTG/L Posted CodeCharacterGeneric Edit10 Allow NULL? 
34SYISTRA/R Post StatusCharacterGeneric Edit10 Allow NULL? 
35SYBALJBalanced - Journal EntriesCharacterUDC (H00 BB)10 Allow NULL? 
36SYPSTPay Status CodeCharacterUDC (00 PS)10 Allow NULL? 
37SYAGAmount - GrossNumericGeneric Edit152 Allow NULL? 
38SYAAPAmount OpenNumericGeneric Edit152 Allow NULL? 
39SYADSCDiscount AvailableNumericGeneric Edit152 Allow NULL? 
40SYADSADiscount TakenNumericGeneric Edit152 Allow NULL? 
41SYATXAAmount - TaxableNumericGeneric Edit152 Allow NULL? 
42SYATXNAmount - Non-TaxableNumericGeneric Edit152 Allow NULL? 
43SYSTAMAmount - TaxNumericGeneric Edit152 Allow NULL? 
44SYBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
45SYCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
46SYCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
47SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
48SYDMCDDomestic Entry w/Mult Currency DistrCharacterGeneric Edit10 Allow NULL? 
49SYACRAmount - CurrencyNumericGeneric Edit152 Allow NULL? 
50SYFAPAmount - Foreign OpenNumericGeneric Edit152 Allow NULL? 
51SYCDSAmount - Foreign Discount AvailableNumericGeneric Edit152 Allow NULL? 
52SYCDSAAmount - Foreign Discount TakenNumericGeneric Edit152 Allow NULL? 
53SYCTXAAmount - Foreign TaxableNumericGeneric Edit152 Allow NULL? 
54SYCTXNAmount - Foreign Non-TaxableNumericGeneric Edit152 Allow NULL? 
55SYCTAMAmount - Foreign TaxNumericGeneric Edit152 Allow NULL? 
56SYTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
57SYEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
58SYDSVJDate - Service/TaxDateGeneric Edit60
59SYGLBAG/L Bank AccountStringGeneric Edit80 Allow NULL? 
60SYAMAccount Mode - G/LCharacterUDC (H09 AM)10 Allow NULL? 
61SYAID2Account IDStringGeneric Edit80 Allow NULL? 
62SYAM2Account Mode - G/LCharacterUDC (H09 AM)10 Allow NULL? 
63SYMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
64SYOBJObject AccountStringGeneric Edit60 Allow NULL? 
65SYSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
66SYSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
67SYSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
68SYPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
69SYDDJDate - Net DueDateGeneric Edit60
70SYDDNJDate - Discount Due - JulianDateGeneric Edit60
71SYRDDJDate of Last Sent ReminderDateGeneric Edit60
72SYRDSJDate - Reminder Stop Until DateDateGeneric Edit60
73SYLFCJDate - Last Fee Calculated (Julian)DateGeneric Edit60
74SYSMTJDate - StatementDateGeneric Edit60
75SYNBRRReminders - Number of Reminders to SendCharacterUDC (H00 NB)10 Allow NULL? 
76SYRDRLLevel of Last Sent ReminderCharacterUDC10 Allow NULL? 
77SYRMDSNumber of Sent Reminders - TotalNumericGeneric Edit30 Allow NULL? 
78SYCOLLCollection Report (Y/N)CharacterUDC (H00 CO)10 Allow NULL? 
79SYCORCCollection Reason CodeStringUDC (03B CL)20 Allow NULL? 
80SYAFCApply Finance Charges - Y/NCharacterUDC (H00 AF)10 Allow NULL? 
81SYDNLTDelinquency Notice (Y/N)CharacterGeneric Edit10 Allow NULL? 
82SYRSCOWrite-Off Reason CodeStringUDC (03B RC)20 Allow NULL? 
83SYODOCDocument - OriginalNumericGeneric Edit80 Allow NULL? 
84SYODCTDocument Type - OriginalStringUDC (00 DT)20 Allow NULL? 
85SYOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
86SYOSFXDocument Pay Item - OriginalStringGeneric Edit30 Allow NULL? 
87SYVINVSupplier Invoice NumberStringGeneric Edit250 Allow NULL? 
88SYPOPurchase OrderStringGeneric Edit80 Allow NULL? 
89SYPDCTDocument Type - Purchase OrderStringUDC (00 DT)20 Allow NULL? 
90SYPKCODocument Company (Purchase Order)StringGeneric Edit50 Allow NULL? 
91SYDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
92SYLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
93SYSDOCSales Document NumberNumericGeneric Edit80 Allow NULL? 
94SYSDCTSales Document TypeStringUDC (00 DT)20 Allow NULL? 
95SYSKCODocument Company (Sales Order)StringGeneric Edit50 Allow NULL? 
96SYSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
97SYVLDTDate - Cleared/ValueDateGeneric Edit60
98SYCMC1Commission Code 1NumericGeneric Edit80 Allow NULL? 
99SYVR01ReferenceStringGeneric Edit250 Allow NULL? 
100SYUNITUnitStringGeneric Edit80 Allow NULL? 
101SYMCU2Business Unit 2StringGeneric Edit120 Allow NULL? 
102SYRMKName - RemarkStringGeneric Edit300 Allow NULL? 
103SYALPHName - AlphaStringGeneric Edit400 Allow NULL? 
104SYRFFrequency - RecurringStringUDC (H00 RF)20 Allow NULL? 
105SYDRFRecurring Frequency # of PaymentsNumericGeneric Edit30 Allow NULL? 
106SYCTLControl/Statement FieldStringGeneric Edit130 Allow NULL? 
107SYFNLPClosed Item - As Of ProcessingCharacterGeneric Edit10 Allow NULL? 
108SYITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
109SYUUnitsNumericGeneric Edit152 Allow NULL? 
110SYUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
111SYALT6G/L Posting Code - Cash Basis AcctCharacterGeneric Edit10 Allow NULL? 
112SYRYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
113SYVDGJVoid Date - For G/L - JulianDateGeneric Edit60
114SYVODVoid FlagCharacterGeneric Edit10 Allow NULL? 
115SYRP1A/R - A/P - Miscellaneous Code 1CharacterGeneric Edit10 Allow NULL? 
116SYRP2A/R - A/P - Miscellaneous Code 2CharacterGeneric Edit10 Allow NULL? 
117SYRP3A/R - A/P - Cash Rcpts/Inv Reg CodeCharacterGeneric Edit10 Allow NULL? 
118SYAR01A/R Reporting Code 1StringUDC (01 01)30 Allow NULL? 
119SYAR02A/R Reporting Code 2StringUDC (01 02)30 Allow NULL? 
120SYAR03A/R Reporting Code 3StringUDC (01 03)30 Allow NULL? 
121SYAR04A/R Reporting Code 4StringUDC (01 04)30 Allow NULL? 
122SYAR05A/R Reporting Code 5StringUDC (01 05)30 Allow NULL? 
123SYAR06A/R Reporting Code 6StringUDC (01 06)30 Allow NULL? 
124SYAR07A/R Reporting Code 7StringUDC (01 07)30 Allow NULL? 
125SYAR08A/R Reporting Code 8StringUDC (01 08)30 Allow NULL? 
126SYAR09A/R Reporting Code 9StringUDC (01 09)30 Allow NULL? 
127SYAR10A/R Reporting Code 10StringUDC (01 10)30 Allow NULL? 
128SYISTCA/R Post to Cash ManagementCharacterGeneric Edit10 Allow NULL? 
129SYPYIDPayment ID (Internal)NumericGeneric Edit150 Allow NULL? 
130SYRNIDBatch Run ID (Internal)NumericGeneric Edit30 Allow NULL? 
131SYPPDIDate - Invoice PrintedDateGeneric Edit60
132SYJCLDate Invoice ClosedDateGeneric Edit60
133SYDDEXDeduction Reason CodeStringUDC (03B CR)20 Allow NULL? 
134SYHCRRHistorical Currency Conversion RateNumericGeneric Edit150 Allow NULL? 
135SYHDGJHistorical Date - JulianDateGeneric Edit60
136SYDCPDiscount % - Payment TermsNumericGeneric Edit50 Allow NULL? 
137SYURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
138SYURDTUser Reserved DateDateGeneric Edit60
139SYURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
140SYURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
141SYURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
142SYTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
143SYUSERUser IDStringGeneric Edit100 Allow NULL? 
144SYPIDProgram IDStringGeneric Edit100 Allow NULL? 
145SYJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
146SYUPMJDate - UpdatedDateGeneric Edit60
147SYTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
148SYSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
149SYDTXSDeferred Tax Status - VATCharacterGeneric Edit10 Allow NULL? 
150SYOMODOriginating SystemCharacterUDC (03B OS)10 Allow NULL? 
151SYCLMGCollection ManagerStringGeneric Edit (01 CM)100 Allow NULL? 
152SYCMGRCredit ManagerStringUDC (01 CR)100 Allow NULL? 
153SYATADAmount - To DistributeNumericGeneric Edit152 Allow NULL? 
154SYCTADAmount - Currency To DistributeNumericGeneric Edit152 Allow NULL? 
155SYNRTANon-Recoverable Tax AmountNumericGeneric Edit152 Allow NULL? 
156SYFNRTForeign Non-Recoverable TaxNumericGeneric Edit152 Allow NULL? 
157SYPRGFPurge FlagCharacterGeneric Edit10 Allow NULL? 
158SYGFL1Generic Flag 1CharacterGeneric Edit10 Allow NULL? 
159SYGFL2Generic Flag 2CharacterGeneric Edit10 Allow NULL? 
160SYDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
161SYKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
162SYSOTFSales Order Tax FlagCharacterGeneric Edit10 Allow NULL? 
163SYDTPBNotification Payment DateDateGeneric Edit60
164SYERDJDate - For Exchange Rate - JulianDateGeneric Edit60
165SYPWPGPay When Paid Group NumberNumericGeneric Edit150 Allow NULL? 
166SYNETTCIDNetting Transaction IDNumericGeneric Edit150 Allow NULL? 
167SYNETDOCNetting Document NumberNumericGeneric Edit150 Allow NULL? 
168SYNETRC5Netting Line IDNumericGeneric Edit60 Allow NULL? 
169SYNETSTNetting Status CodeCharacterUDC (00 NS)10 Allow NULL? 
170SYAJCLActual Date Invoice ClosedDateGeneric Edit60
171SYRMR1Generic AR Receipt Matching Reference1StringGeneric Edit500 Allow NULL? 

TOP910 | 03B | F03B11Z2 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