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

149 COLUMNS | 1 INDEXES | Print definition?910 | 40 | F4001Z TABLE

40: Inventory/OP Base
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F4001ZSY1491Batch Receiver File - Order HeadingsBatch Input Files42B: Sales Order EntryBusiness 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 SYEDTY, SYEDSQ, SYEKCO, SYEDOC, SYEDCT, SYEDLN, SYEDST, SYEDFT, SYEDDT, SYEDER, SYEDDL, SYEDSP, SYPNID, SYOFRQ, SYNXDJ, SYSSDJ, SYSUN, SYMON, SYTUE, SYWED, SYTHR, SYFRI, SYSAT, SYKCOO, SYDOCO, SYDCTO, SYSFXO, SYMCU, SYCO, SYOKCO, SYOORN, SYOCTO, SYRKCO, SYRORN, SYRCTO, SYAN8, SYSHAN, SYPA8, SYDRQJ, SYTRDJ, SYPDDJ, SYOPDJ, SYADDJ, SYCNDJ, SYPEFJ, SYPPDJ, SYPSDJ, SYVR01, SYVR02, SYDEL1, SYDEL2, SYINMG, SYPTC, SYRYIN, SYASN, SYPRGP, SYTRDC, SYPCRT, SYTXA1, SYEXR1, SYTXCT, SYATXT, SYPRIO, SYBACK, SYSBAL, SYHOLD, SYPLST, SYINVC, SYNTR, SYANBY, SYCARS, SYMOT, SYCOT, SYROUT, SYSTOP, SYZON, SYCNID, SYFRTH, SYAFT, SYFUF1, SYFRTC, SYMORD, SYRCD, SYFUF2, SYOTOT, SYTOTC, SYWUMD, SYVUMD, SYAUTN, SYCACT, SYCEXP, SYSBLI, SYCRMD, SYCRRM, SYCRCD, SYCRR, SYLNGP, SYFAP, SYFCST, SYORBY, SYTKBY, SYURCD, SYURDT, SYURAT, SYURAB, SYURRF, SYUSER, SYPID, SYJOBN, SYUPMJ, SYTDAY, SYIR01, SYIR02, SYIR03, SYIR04, SYIR05, SYVR03, SYSOOR, SYPMDT, SYRSDT, SYRQSJ, SYPSTM, SYPDTT, SYOPTT, SYDRQT, SYADTM, SYADLJ, SYPBAN, SYITAN, SYFTAN, SYDVAN, SYDOC1, SYDCT4, SYCORD, SYBSC, SYBCRC, SYAUFT, SYAUFI, SYOPBO, SYOPTC, SYOPLD, SYOPBK, SYOPSB, SYOPPS, SYOPPL, SYOPMS, SYOPSS, SYOPBA, SYOPLL FROM F4001Z

TOP910 | 40 | F4001Z COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SYEDTYType RecordCharacterUDC (00 RD)10 Allow NULL? 
2SYEDSQRecord SequenceNumericGeneric Edit20 Allow NULL? 
3SYEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50 Allow NULL? 
4SYEDOCEDI - Document NumberNumericGeneric Edit90 Allow NULL? 
5SYEDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
6SYEDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
7SYEDSTEDI - Transaction Set NumberStringUDC (40 ST)60 Allow NULL? 
8SYEDFTEDI - Translation FormatStringGeneric Edit100 Allow NULL? 
9SYEDDTEDI - Transmission DateDateGeneric Edit60
10SYEDEREDI - Send/Receive IndicatorCharacterUDC (H00 ED)10 Allow NULL? 
11SYEDDLEDI - Detail Lines ProcessedNumericGeneric Edit50 Allow NULL? 
12SYEDSPEDI - Successfully ProcessedCharacterGeneric Edit10 Allow NULL? 
13SYPNIDTrading Partner IDStringGeneric Edit150 Allow NULL? 
14SYOFRQFrequency - OrderCharacterUDC (40 OF)10 Allow NULL? 
15SYNXDJDate - Next OrderDateGeneric Edit60
16SYSSDJDate - SuspendDateGeneric Edit60
17SYSUNSunday ValidationCharacterGeneric Edit10 Allow NULL? 
18SYMONMonday ValidationCharacterGeneric Edit10 Allow NULL? 
19SYTUETuesday ValidationCharacterGeneric Edit10 Allow NULL? 
20SYWEDWednesday ValidationCharacterGeneric Edit10 Allow NULL? 
21SYTHRThursday ValidationCharacterGeneric Edit10 Allow NULL? 
22SYFRIFriday ValidationCharacterGeneric Edit10 Allow NULL? 
23SYSATSaturday ValidationCharacterGeneric Edit10 Allow NULL? 
24SYKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
25SYDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
26SYDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
27SYSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
28SYMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
29SYCOCompanyStringGeneric Edit50 Allow NULL? 
30SYOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
31SYOORNOriginal Order NumberStringGeneric Edit80 Allow NULL? 
32SYOCTOOriginal Order TypeStringUDC (00 DT)20 Allow NULL? 
33SYRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
34SYRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
35SYRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
36SYAN8Address NumberNumericUDC80 Allow NULL? 
37SYSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
38SYPA8Address Number - ParentNumericGeneric Edit80 Allow NULL? 
39SYDRQJDate - RequestedDateGeneric Edit60
40SYTRDJDate - Order/TransactionDateGeneric Edit60
41SYPDDJDate - Scheduled PickDateGeneric Edit60
42SYOPDJDate - Original Promised DeliveryDateGeneric Edit60
43SYADDJDate - Actual Ship DateDateGeneric Edit60
44SYCNDJDate - CancelDateGeneric Edit60
45SYPEFJDate - Price Effective DateDateGeneric Edit60
46SYPPDJDate - Promised ShipmentDateGeneric Edit60
47SYPSDJDate - Future Date 2DateGeneric Edit60
48SYVR01ReferenceStringGeneric Edit250 Allow NULL? 
49SYVR02Reference 2StringGeneric Edit250 Allow NULL? 
50SYDEL1Delivery Instructions Line 1StringGeneric Edit300 Allow NULL? 
51SYDEL2Delivery Instructions Line 2StringGeneric Edit300 Allow NULL? 
52SYINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
53SYPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
54SYRYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
55SYASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
56SYPRGPPricing GroupStringUDC (40 PC)80 Allow NULL? 
57SYTRDCDiscount - TradeNumericGeneric Edit73 Allow NULL? 
58SYPCRTPercent - RetainageNumericGeneric Edit73 Allow NULL? 
59SYTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
60SYEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
61SYTXCTCertificate Tax ExemptionStringGeneric Edit200 Allow NULL? 
62SYATXTAssociated TextCharacterGeneric Edit10 Allow NULL? 
63SYPRIOPriority - ProcessingCharacterUDC (H40 PR)10 Allow NULL? 
64SYBACKBackorders Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
65SYSBALSubstitutes Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
66SYHOLDHold Orders CodeStringUDC (42 HC)20 Allow NULL? 
67SYPLSTPrice Pick List (Y/N)CharacterGeneric Edit10 Allow NULL? 
68SYINVCInvoice CopiesNumericGeneric Edit20 Allow NULL? 
69SYNTRNature of TransactionStringUDC (00 NT)20 Allow NULL? 
70SYANBYBuyer NumberNumericGeneric Edit80 Allow NULL? 
71SYCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
72SYMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
73SYCOTConditions of TransportStringUDC (00 TC)30 Allow NULL? 
74SYROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
75SYSTOPStop CodeStringUDC (42 SP)30 Allow NULL? 
76SYZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
77SYCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
78SYFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
79SYAFTApply Freight - Y/NCharacterGeneric Edit10 Allow NULL? 
80SYFUF1AIA Document FlagCharacterUDC (H40 FU)10 Allow NULL? 
81SYFRTCFreight Calculated (Y/N)CharacterGeneric Edit10 Allow NULL? 
82SYMORDMerge Orders (Y/N)CharacterGeneric Edit10 Allow NULL? 
83SYRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
84SYFUF2Post QuantitiesCharacterGeneric Edit10 Allow NULL? 
85SYOTOTAmount - Order GrossNumericGeneric Edit152 Allow NULL? 
86SYTOTCAmount - Total CostNumericGeneric Edit152 Allow NULL? 
87SYWUMDUnit of Measure - Weight DisplayStringUDC (00 UM)20 Allow NULL? 
88SYVUMDUnit of Measure - Volume DisplayStringUDC (00 UM)20 Allow NULL? 
89SYAUTNAuthorization Number - Credit ApprovalStringGeneric Edit100 Allow NULL? 
90SYCACTAccount Number - Credit/BankStringGeneric Edit250 Allow NULL? 
91SYCEXPDate - Expired (Julian)DateGeneric Edit60
92SYSBLISubledger Inactive CodeCharacterUDC (00 SI)10 Allow NULL? 
93SYCRMDSend MethodCharacterUDC (00 SM)10 Allow NULL? 
94SYCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
95SYCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
96SYCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
97SYLNGPLanguageStringUDC (01 LP)20 Allow NULL? 
98SYFAPAmount - Foreign OpenNumericGeneric Edit152 Allow NULL? 
99SYFCSTAmount - Foreign Total CostNumericGeneric Edit152 Allow NULL? 
100SYORBYOrdered ByStringGeneric Edit100 Allow NULL? 
101SYTKBYOrder Taken ByStringGeneric Edit100 Allow NULL? 
102SYURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
103SYURDTUser Reserved DateDateGeneric Edit60
104SYURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
105SYURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
106SYURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
107SYUSERUser IDStringGeneric Edit100 Allow NULL? 
108SYPIDProgram IDStringGeneric Edit100 Allow NULL? 
109SYJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
110SYUPMJDate - UpdatedDateGeneric Edit60
111SYTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
112SYIR01Integration Reference 01StringGeneric Edit300 Allow NULL? 
113SYIR02Integration Reference 02StringGeneric Edit300 Allow NULL? 
114SYIR03Integration Reference 03StringGeneric Edit300 Allow NULL? 
115SYIR04Integration Reference 04StringGeneric Edit300 Allow NULL? 
116SYIR05Integration Reference 05StringGeneric Edit300 Allow NULL? 
117SYVR03ReferenceStringGeneric Edit250 Allow NULL? 
118SYSOORSource of OrderIntegerGeneric Edit110 Allow NULL? 
119SYPMDTScheduled Shipment TimeNumericGeneric Edit60 Allow NULL? 
120SYRSDTPromised Delivery TimeNumericGeneric Edit60 Allow NULL? 
121SYRQSJDate - Requested ShipDateGeneric Edit60
122SYPSTMTime - Future Time 2NumericGeneric Edit60 Allow NULL? 
123SYPDTTTime - Scheduled PickNumericGeneric Edit60 Allow NULL? 
124SYOPTTTime - Original Promised DeliveryNumericGeneric Edit60 Allow NULL? 
125SYDRQTRequested Delivery TimeNumericGeneric Edit60 Allow NULL? 
126SYADTMActual Shipment TimeNumericGeneric Edit60 Allow NULL? 
127SYADLJDate - Actual DeliveryDateGeneric Edit60
128SYPBANAddress Number - Paid ByNumericGeneric Edit80 Allow NULL? 
129SYITANAddress Number - Invoiced ToNumericGeneric Edit80 Allow NULL? 
130SYFTANAddress Number - Forwarded ToNumericGeneric Edit80 Allow NULL? 
131SYDVANAddress Number - Deliver ToNumericGeneric Edit80 Allow NULL? 
132SYDOC1Document (Order # Invoice etc.)NumericGeneric Edit80 Allow NULL? 
133SYDCT4Document TypeStringUDC (00 DT)20 Allow NULL? 
134SYCORDChange Order NumberNumericGeneric Edit30 Allow NULL? 
135SYBSCBuying Segment CodeStringUDC (42B BS)100 Allow NULL? 
136SYBCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
137SYAUFTAddress Number to use for TaxCharacterUDC (42B UA)10 Allow NULL? 
138SYAUFIAddress Number to use for TransportationCharacterUDC (42B UA)10 Allow NULL? 
139SYOPBOOP Business ObjectiveStringUDC (34A BO)300 Allow NULL? 
140SYOPTCOP Total CostNumericGeneric Edit154 Allow NULL? 
141SYOPLDOP Latest Line DateDateGeneric Edit60
142SYOPBKOP Number of BackordersNumericGeneric Edit150 Allow NULL? 
143SYOPSBOP Number of SubstitutesNumericGeneric Edit150 Allow NULL? 
144SYOPPSOP Promised StatusStringGeneric Edit300 Allow NULL? 
145SYOPPLOP Partial Order ShipmentCharacterGeneric Edit10 Allow NULL? 
146SYOPMSOP Allow Multi SourceCharacterGeneric Edit10 Allow NULL? 
147SYOPSSOP Allow SubstitutesCharacterGeneric Edit10 Allow NULL? 
148SYOPBAOP Allow BackordersCharacterGeneric Edit10 Allow NULL? 
149SYOPLLOP Partial Ship Line ItemsCharacterGeneric Edit10 Allow NULL? 

TOP910 | 40 | F4001Z INDEXES

NumberDescription
1Document Num Document Type (Primary/Unique)
ElementAliasDescriptionSequence
1EDOCEDI - Document NumberAscending
2EDCTEDI - Document TypeAscending
3EKCOCompany - Key (EDI - Document Key Co)Ascending