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
2F9671SDSoftware Update Detail Table
3F0101ABAddress Book Master
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F03012AICustomer Master by Line of Business
10F41021LIItem Location File

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
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F42119SDSales Order History File
7F0006MCBusiness Unit Master
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

95 COLUMNS | 1 INDEXES | Print definition?812 | 46 | F4600PU TABLE

46: Warehouse Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F4600PUR1951Warehouse Requests - PurgedPurge Files46: Warehouse ManagementNo
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 R1TYFL, R1OCDE, R1RQBT, R1RQSQ, R1KCOO, R1DOCO, R1DCTO, R1LNID, R1NLIN, R1SFXO, R1AN8, R1SHAN, R1MCU, R1ITM, R1LITM, R1AITM, R1OGRP, R1OVRQ, R1MERG, R1RLIT, R1KTLN, R1CPNT, R1RKIT, R1KTP, R1QTRQ, R1UOM, R1LDFS, R1FLOC, R1FLOT, R1STNF, R1LDTS, R1TLOC, R1TLOT, R1STNT, R1FRMP, R1THRP, R1FRGD, R1THGD, R1EXDP, R1LNTY, R1SRP1, R1SRP2, R1SRP3, R1SRP4, R1SRP5, R1PRIO, R1ROUT, R1STOP, R1ZON, R1CARS, R1BACK, R1APTS, R1COMM, R1DSC1, R1DSC2, R1INMG, R1VR01, R1PALC, R1MORD, R1LCOD, R1PACK, R1RPCK, R1PSTB, R1RCDJ, R1TRDJ, R1PDDJ, R1DRQJ, R1ZIP, R1CNFR, R1RESX, R1PTYN, R1TREX, R1DTCR, R1TMCR, R1URCD, R1URDT, R1URAT, R1URAB, R1URRF, R1USER, R1PID, R1JOBN, R1UPMJ, R1TDAY, R1UKID, R1DTE, R1TICU, R1SCHUSER, R1SHPN, R1LDNM, R1CPNB, R1VMCU, R1PSJOBNO, R1JOBSQ, R1DELBATCH FROM F4600PU

TOP812 | 46 | F4600PU COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1R1TYFLCode - WarehouseCharacterGeneric Edit10 Allow NULL? 
2R1OCDECode - OriginStringGeneric Edit20 Allow NULL? 
3R1RQBTBatch Number - RequestsNumericGeneric Edit80 Allow NULL? 
4R1RQSQSequence Number - RequestNumericGeneric Edit73 Allow NULL? 
5R1KCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
6R1DOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
7R1DCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
8R1LNIDLine NumberNumericGeneric Edit63 Allow NULL? 
9R1NLINNumber of LinesNumericGeneric Edit50 Allow NULL? 
10R1SFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
11R1AN8Address NumberNumericUDC80 Allow NULL? 
12R1SHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
13R1MCUBusiness UnitStringGeneric Edit120 Allow NULL? 
14R1ITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
15R1LITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
16R1AITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
17R1OGRPOrder GroupStringUDC (46 DT)40 Allow NULL? 
18R1OVRQOverride Request (Y/N)CharacterGeneric Edit10 Allow NULL? 
19R1MERGTop Off (Y/N)CharacterGeneric Edit10 Allow NULL? 
20R1RLITItem Number - Related (Kit)StringGeneric Edit80 Allow NULL? 
21R1KTLNKit Master Line NumberNumericGeneric Edit63 Allow NULL? 
22R1CPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
23R1RKITRelated Kit ComponentNumericGeneric Edit80 Allow NULL? 
24R1KTPNumber of Component Per ParentNumericGeneric Edit152 Allow NULL? 
25R1QTRQQuantity - Requested in primary U/MNumericGeneric Edit152 Allow NULL? 
26R1UOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
27R1LDFSSequence Number - Location Detail (From)NumericGeneric Edit80 Allow NULL? 
28R1FLOCLocation - FromStringGeneric Edit200 Allow NULL? 
29R1FLOTLot - FromStringGeneric Edit300 Allow NULL? 
30R1STNFStorage Unit Number - FromNumericGeneric Edit80 Allow NULL? 
31R1LDTSSequence Number - Location Detail (To)NumericGeneric Edit80 Allow NULL? 
32R1TLOCLocation - ToStringGeneric Edit200 Allow NULL? 
33R1TLOTLot - ToStringGeneric Edit300 Allow NULL? 
34R1STNTStorage Unit Number - ToNumericGeneric Edit80 Allow NULL? 
35R1FRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
36R1THRPThru PotencyNumericGeneric Edit73 Allow NULL? 
37R1FRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
38R1THGDThru GradeStringUDC (40 LG)30 Allow NULL? 
39R1EXDPDays Before ExpirationNumericGeneric Edit50 Allow NULL? 
40R1LNTYLine TypeStringGeneric Edit20 Allow NULL? 
41R1SRP1Sales Rpt 01 - Product FamilyStringUDC (41 S1)30 Allow NULL? 
42R1SRP2Sales Rpt 02 - Family SectionStringUDC (41 S2)30 Allow NULL? 
43R1SRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
44R1SRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
45R1SRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
46R1PRIOPriority - ProcessingCharacterUDC (H40 PR)10 Allow NULL? 
47R1ROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
48R1STOPStop CodeStringUDC (42 SP)30 Allow NULL? 
49R1ZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
50R1CARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
51R1BACKBackorders Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
52R1APTSPartial Line Shipments Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
53R1COMMCommitted (H/S)CharacterUDC (H42 CP)10 Allow NULL? 
54R1DSC1DescriptionStringGeneric Edit300 Allow NULL? 
55R1DSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
56R1INMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
57R1VR01ReferenceStringGeneric Edit250 Allow NULL? 
58R1PALCPallet ControlCharacterGeneric Edit10 Allow NULL? 
59R1MORDMerge Orders (Y/N)CharacterGeneric Edit10 Allow NULL? 
60R1LCODCode - Location Tax StatusStringUDC (46 LT)20 Allow NULL? 
61R1PACKCode - PackingStringUDC (46 PK)40 Allow NULL? 
62R1RPCKRepack (Y/N)CharacterGeneric Edit10 Allow NULL? 
63R1PSTBStatus - Task / TripStringUDC (46 PS)30 Allow NULL? 
64R1RCDJDate - ReceivedDateGeneric Edit60
65R1TRDJDate - Order/TransactionDateGeneric Edit60
66R1PDDJDate - Scheduled PickDateGeneric Edit60
67R1DRQJDate - RequestedDateGeneric Edit60
68R1ZIPZip Code - Sold to Postal CodeStringGeneric Edit120 Allow NULL? 
69R1CNFRAutomatically Confirm (Y/N)CharacterGeneric Edit10 Allow NULL? 
70R1RESXReservations UsedCharacterGeneric Edit10 Allow NULL? 
71R1PTYNOverride Location (Y/N)CharacterGeneric Edit10 Allow NULL? 
72R1TREXExplanation - TransactionStringGeneric Edit300 Allow NULL? 
73R1DTCRDate - Created (Julian)DateGeneric Edit60
74R1TMCRTime - CreatedNumericGeneric Edit60 Allow NULL? 
75R1URCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
76R1URDTUser Reserved DateDateGeneric Edit60
77R1URATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
78R1URABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
79R1URRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
80R1USERUser IDStringGeneric Edit100 Allow NULL? 
81R1PIDProgram IDStringGeneric Edit100 Allow NULL? 
82R1JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
83R1UPMJDate - UpdatedDateGeneric Edit60
84R1TDAYTime of DayNumericGeneric Edit60 Allow NULL? 
85R1UKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
86R1DTEDateDateGeneric Edit60
87R1TICUBatch TimeNumericGeneric Edit60 Allow NULL? 
88R1SCHUSERUser the job will be launched withStringGeneric Edit100 Allow NULL? 
89R1SHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
90R1LDNMLoad NumberNumericGeneric Edit80 Allow NULL? 
91R1CPNBComponent Line Number BOMNumericGeneric Edit82 Allow NULL? 
92R1VMCUDepot - TripStringGeneric Edit120 Allow NULL? 
93R1PSJOBNOProduction Sequencing Job NumberStringGeneric Edit150 Allow NULL? 
94R1JOBSQJob Sequence NumberStringGeneric Edit150 Allow NULL? 
95R1DELBATCHDelivery Batch NumberStringGeneric Edit60 Allow NULL? 

TOP812 | 46 | F4600PU INDEXES

NumberDescription
1Batch#_Request (Primary/Unique)
ElementAliasDescriptionSequence
1RQBTBatch Number - RequestsAscending
2RQSQSequence Number - RequestAscending