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

115 COLUMNS | 2 INDEXES | Print definition?920 | 42B | F42420 TABLE

42B: Sales Order Entry
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F42420AL1152Audit Log TransactionFiles42B: 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 ALKCOO, ALDOCO, ALDCTO, ALLNID, ALCORD, ALUPMJ, ALTDAY, ALUSER, ALRFRV, ALAPSR, ALAPPV, ALAPPJ, ALATIM, ALSFXO, ALMCU, ALLITM, ALUORG, ALUOM, ALUPRC, ALAEXP, ALFUP, ALFEA, ALLOCN, ALLOTN, ALDRQJ, ALDSC1, ALLTTR, ALNXTR, ALUOM4, ALSOQS, ALSOBK, ALSOCN, ALPDDJ, ALPPDJ, ALCNDJ, ALRSDJ, ALUNCS, ALECST, ALFUC, ALFEC, ALPRP5, ALVEND, ALSHAN, ALDSC2, ALTAX1, ALWTUM, ALITWT, ALRYIN, ALINMG, ALMOT, ALDTYS, ALCARS, ALLOB, ALEUSE, ALEMCU, ALUPC1, ALUPC2, ALUPC3, ALASN, ALPRGR, ALPTC, ALPRIO, ALRCD, ALCADC, ALGLPT, ALSBL, ALSBLT, ALSRP1, ALSRP2, ALSRP3, ALSRP4, ALSRP5, ALAFT, ALSHCM, ALSHCN, ALFRAT, ALROUT, ALSTOP, ALZON, ALITVL, ALVLUM, ALACOM, ALEXR1, ALTXA1, ALSQOR, ALUOM2, ALMCLN, ALXDCK, ALXPTY, ALDRQT, ALPDTT, ALOPTT, ALADTM, ALPMDT, ALPSTM, ALRLNU, ALPSIG, ALRLDJ, ALRLTM, ALXKCO, ALXORN, ALXCTO, ALXLLN, ALXSFX, ALPID, ALSPATTN, ALPRAN8, ALPRCIDLN, ALCCIDLN, ALSHCCIDLN, ALOPPID, ALOSTP, ALUKID, ALCATNM, ALOSCORE FROM F42420

TOP920 | 42B | F42420 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1ALKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
2ALDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
3ALDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
4ALLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
5ALCORDChange Order NumberNumericGeneric Edit30 Allow NULL? 
6ALUPMJDate - UpdatedDateGeneric Edit60
7ALTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
8ALUSERUser IDStringGeneric Edit100 Allow NULL? 
9ALRFRVRevision ReasonStringUDC (42 RR)30 Allow NULL? 
10ALAPSRApproval StatusCharacterGeneric Edit10 Allow NULL? 
11ALAPPVApproverStringGeneric Edit100 Allow NULL? 
12ALAPPJDate - Approval (Julian)DateGeneric Edit60
13ALATIMTime - ApprovalNumericGeneric Edit60 Allow NULL? 
14ALSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
15ALMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
16ALLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
17ALUORGUnits - Order/Transaction QuantityNumericGeneric Edit150 Allow NULL? 
18ALUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
19ALUPRCAmount - Price per UnitNumericGeneric Edit154 Allow NULL? 
20ALAEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
21ALFUPAmount - Foreign Price per UnitNumericGeneric Edit154 Allow NULL? 
22ALFEAAmount - Foreign Extended PriceNumericGeneric Edit152 Allow NULL? 
23ALLOCNLocationStringGeneric Edit200 Allow NULL? 
24ALLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
25ALDRQJDate - RequestedDateGeneric Edit60
26ALDSC1DescriptionStringGeneric Edit300 Allow NULL? 
27ALLTTRStatus Code - LastStringUDC (40 AT)30 Allow NULL? 
28ALNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
29ALUOM4Unit of Measure - PricingStringUDC (00 UM)20 Allow NULL? 
30ALSOQSQuantity ShippedNumericGeneric Edit150 Allow NULL? 
31ALSOBKUnits - Qty Backordered/HeldNumericGeneric Edit150 Allow NULL? 
32ALSOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit150 Allow NULL? 
33ALPDDJDate - Scheduled PickDateGeneric Edit60
34ALPPDJDate - Promised ShipmentDateGeneric Edit60
35ALCNDJDate - CancelDateGeneric Edit60
36ALRSDJDate - Promised DeliveryDateGeneric Edit60
37ALUNCSAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
38ALECSTAmount - Extended CostNumericGeneric Edit152 Allow NULL? 
39ALFUCAmount - Foreign Unit CostNumericGeneric Edit154 Allow NULL? 
40ALFECAmount - Foreign Extended CostNumericGeneric Edit152 Allow NULL? 
41ALPRP5Purchasing Category Code 5StringUDC (41 P5)30 Allow NULL? 
42ALVENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
43ALSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
44ALDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
45ALTAX1Sales Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
46ALWTUMWeight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
47ALITWTUnit WeightNumericGeneric Edit154 Allow NULL? 
48ALRYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
49ALINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
50ALMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
51ALDTYSDuty StatusStringUDC (40 DS)20 Allow NULL? 
52ALCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
53ALLOBLine of BusinessStringUDC (40 LB)30 Allow NULL? 
54ALEUSEEnd UseStringUDC (40 EU)30 Allow NULL? 
55ALEMCUBusiness Unit - HeaderStringGeneric Edit120 Allow NULL? 
56ALUPC1Price Code 1StringUDC (40 P1)20 Allow NULL? 
57ALUPC2Price Code 2StringUDC (40 P2)20 Allow NULL? 
58ALUPC3Price Code 3StringUDC (40 P3)20 Allow NULL? 
59ALASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
60ALPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
61ALPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
62ALPRIOPriority - ProcessingCharacterUDC (H40 PR)10 Allow NULL? 
63ALRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
64ALCADCDiscount % - CashNumericGeneric Edit73 Allow NULL? 
65ALGLPTCategory - G/LStringUDC (41 9)40 Allow NULL? 
66ALSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
67ALSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
68ALSRP1Sales Catalog SectionStringUDC (41 S1)30 Allow NULL? 
69ALSRP2Sub SectionStringUDC (41 S2)30 Allow NULL? 
70ALSRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
71ALSRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
72ALSRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
73ALAFTApply Freight - Y/NCharacterGeneric Edit10 Allow NULL? 
74ALSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
75ALSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
76ALFRATRate Code - Frieght/MiscStringUDC (41 RT)100 Allow NULL? 
77ALROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
78ALSTOPStop CodeStringUDC (42 SP)30 Allow NULL? 
79ALZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
80ALITVLUnit VolumeNumericGeneric Edit154 Allow NULL? 
81ALVLUMVolume Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
82ALACOMApply Commission (Y/N)CharacterGeneric Edit10 Allow NULL? 
83ALEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
84ALTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
85ALSQORUnits - Secondary Quantity OrderedNumericGeneric Edit150 Allow NULL? 
86ALUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
87ALMCLNMatrix Control Line NumberNumericGeneric Edit63 Allow NULL? 
88ALXDCKCross-Docking FlagCharacterGeneric Edit10 Allow NULL? 
89ALXPTYCross Docking Priority for Sales OrdersNumericGeneric Edit150 Allow NULL? 
90ALDRQTRequested Delivery TimeNumericGeneric Edit60 Allow NULL? 
91ALPDTTTime - Scheduled PickNumericGeneric Edit60 Allow NULL? 
92ALOPTTTime - Original Promised DeliveryNumericGeneric Edit60 Allow NULL? 
93ALADTMActual Shipment TimeNumericGeneric Edit60 Allow NULL? 
94ALPMDTScheduled Shipment TimeNumericGeneric Edit60 Allow NULL? 
95ALPSTMTime - Future Time 2NumericGeneric Edit60 Allow NULL? 
96ALRLNURelease NumberStringGeneric Edit100 Allow NULL? 
97ALPSIGPull SignalStringGeneric Edit300 Allow NULL? 
98ALRLDJDate - ReleaseDateGeneric Edit60
99ALRLTMTime - ReleaseNumericGeneric Edit60 Allow NULL? 
100ALXKCOCross Dock Order Company (Order Number)StringGeneric Edit50 Allow NULL? 
101ALXORNCross Dock Order NoNumericGeneric Edit80 Allow NULL? 
102ALXCTOCross Dock Order TypeStringUDC (00 DT)20 Allow NULL? 
103ALXLLNCross Dock Line NumberNumericGeneric Edit63 Allow NULL? 
104ALXSFXCross Dock Order SuffixStringGeneric Edit30 Allow NULL? 
105ALPIDProgram IDStringGeneric Edit100 Allow NULL? 
106ALSPATTNShip To AttentionStringGeneric Edit500 Allow NULL? 
107ALPRAN8Partner Address NumberNumericGeneric Edit80 Allow NULL? 
108ALPRCIDLNPartner Contact Line Number IDNumericGeneric Edit50 Allow NULL? 
109ALCCIDLNCustomer Contact Line Number IDNumericGeneric Edit50 Allow NULL? 
110ALSHCCIDLNShip To Cust Contact Line Num IDNumericGeneric Edit50 Allow NULL? 
111ALOPPIDOpportunity NumberNumericGeneric Edit150 Allow NULL? 
112ALOSTPOrganization Structure TypeStringUDC (01 TS)30 Allow NULL? 
113ALUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
114ALCATNMCatalog NameStringGeneric Edit300 Allow NULL? 
115ALOSCORESales Order ScoreNumericGeneric Edit153 Allow NULL? 

TOP920 | 42B | F42420 INDEXES

NumberDescription
1Order Co Order No A+ (Primary/Unique)
ElementAliasDescriptionSequence
1KCOOOrder Company (Order Number)Ascending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4LNIDLine NumberAscending
5CORDChange Order NumberAscending
6UPMJDate - UpdatedAscending
7TDAYTime of DayAscending
8USERUser IDAscending
2Order Co Order B+
ElementAliasDescriptionSequence
1KCOOOrder Company (Order Number)Ascending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4CORDChange Order NumberDescending