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

80 COLUMNS | 1 INDEXES | Print definition?920 | 42I | F42I06 TABLE

42I: Outbound Inventory Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F42I06OH801Outbound Inventory Agreement Master Change HistoryFiles42I: Outbound Inventory Management
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 OHDMCT, OHDMCS, OHCNUKID, OHDL01, OHDL02, OHDL03, OHMCU, OHNWRN, OHAGRS, OHCMAN, OHCADM, OHPANM, OHCNTD, OHDMTC, OHDMPC, OHDMSC, OHEFTJ, OHEXDJ, OHAN8, OHAAGM, OHAAGS, OHRAGM, OHRAGS, OHCAGM, OHCAGS, OHPAGM, OHPAGS, OHZD01, OHZD02, OHZD03, OHZD04, OHZD05, OHZD06, OHZD07, OHZD08, OHZD09, OHZD10, OHQEDT, OHCAND, OHCANR, OHUPGL, OHPRAS, OHCMOO, OHCNQY, OHTV01, OHTV02, OHTV03, OHURCD, OHURDT, OHURAT, OHURAB, OHURRF, OHRPQT, OHQED3, OHQED2, OHAGTP, OHPOCUST, OHMLNM, OHACTON, OHSQNBR, OHRFC1, OHRFC2, OHRFC3, OHRFC4, OHFUTCHAR9, OHFUCHAR1, OHFUCHAR2, OHFUNUM7, OHFUNUM8, OHFUNUM9, OHFUTSTR7, OHFUTSTR8, OHFUTSTR9, OHFUDT3, OHUSER, OHPID, OHJOBN, OHUPMJ, OHTDAY, OHACKLDT FROM F42I06

TOP920 | 42I | F42I06 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1OHDMCTAgreement Number - DistributionStringGeneric Edit120 Allow NULL? 
2OHDMCSAgreement Supplement - DistributionNumericGeneric Edit30 Allow NULL? 
3OHCNUKIDConsumption Unique IDNumericGeneric Edit150 Allow NULL? 
4OHDL01DescriptionStringGeneric Edit300 Allow NULL? 
5OHDL02Description 02StringGeneric Edit300 Allow NULL? 
6OHDL03Description 03StringGeneric Edit300 Allow NULL? 
7OHMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
8OHNWRNNew/Renewal FlagCharacterUDC (38 NR)10 Allow NULL? 
9OHAGRSAmendments (Y/N) - AgreementsCharacterGeneric Edit10 Allow NULL? 
10OHCMANAddress Number - Contract ManagerNumericGeneric Edit80 Allow NULL? 
11OHCADMAddress Number - Contract AdministratorNumericGeneric Edit80 Allow NULL? 
12OHPANMPartner Agreement NumberStringGeneric Edit250 Allow NULL? 
13OHCNTDDate - SignedDateGeneric Edit60
14OHDMTCAgreement Type - DistributionCharacterUDC (38 CV)10 Allow NULL? 
15OHDMPCAgreement Purpose - DistributionStringUDC (38 CP)30 Allow NULL? 
16OHDMSCAgreement StatusCharacterUDC (38 CU)10 Allow NULL? 
17OHEFTJDate - EffectiveDateGeneric Edit60
18OHEXDJDate - ExpiredDateGeneric Edit60
19OHAN8Address NumberNumericGeneric Edit80 Allow NULL? 
20OHAAGMAgreement - Associated NumberStringGeneric Edit120 Allow NULL? 
21OHAAGSAgreement - Associated SupplementNumericGeneric Edit30 Allow NULL? 
22OHRAGMCreated From Agreement NumberStringGeneric Edit120 Allow NULL? 
23OHRAGSAgreement - Associated SupplementNumericGeneric Edit30 Allow NULL? 
24OHCAGMCreated From Agreement NumberStringGeneric Edit120 Allow NULL? 
25OHCAGSAgreement - Associated SupplementNumericGeneric Edit30 Allow NULL? 
26OHPAGMParent Agreement NumberStringGeneric Edit120 Allow NULL? 
27OHPAGSAgreement - Associated SupplementNumericGeneric Edit30 Allow NULL? 
28OHZD01Category Code - Agreements 01StringUDC (38 R1)30 Allow NULL? 
29OHZD02Category Code - Agreements 02StringUDC (38 R2)30 Allow NULL? 
30OHZD03Category Code - Agreements 03StringUDC (38 R3)30 Allow NULL? 
31OHZD04Category Code - Agreements 04StringUDC (38 R4)30 Allow NULL? 
32OHZD05Category Code - Agreements 05StringGeneric Edit30 Allow NULL? 
33OHZD06Category Code - Agreements 06StringGeneric Edit30 Allow NULL? 
34OHZD07Category Code - Agreements 07StringGeneric Edit30 Allow NULL? 
35OHZD08Category Code - Agreements 08StringGeneric Edit30 Allow NULL? 
36OHZD09Category Code - Agreements 09StringGeneric Edit30 Allow NULL? 
37OHZD10Category Code - Agreements 10StringGeneric Edit30 Allow NULL? 
38OHQEDTEnforce Quantity EditsCharacterGeneric Edit10 Allow NULL? 
39OHCANDDate - Cancellation of ContractDateGeneric Edit60
40OHCANRCancellation Reason CodeStringUDC (38 CC)30 Allow NULL? 
41OHUPGLUpdate General LedgerCharacterGeneric Edit10 Allow NULL? 
42OHPRASPrice at Ambient/Standard/Weight (A S W)CharacterUDC (38 PR)10 Allow NULL? 
43OHCMOOCommingled Other OwnerCharacterGeneric Edit10 Allow NULL? 
44OHCNQYAgreement Quantity TypeCharacterUDC (38 CN)10 Allow NULL? 
45OHTV01Sales Detail Line OriginCharacterGeneric Edit10 Allow NULL? 
46OHTV02Future Use 02CharacterGeneric Edit10 Allow NULL? 
47OHTV03Future Use 03CharacterGeneric Edit10 Allow NULL? 
48OHURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
49OHURDTUser Reserved DateDateGeneric Edit60
50OHURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
51OHURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
52OHURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
53OHRPQTPercentage - Quantity ToleranceNumericGeneric Edit152 Allow NULL? 
54OHQED3Balance Quantity Edit ControlCharacterGeneric Edit10 Allow NULL? 
55OHQED2Transaction Quantity Edit ControlCharacterGeneric Edit10 Allow NULL? 
56OHAGTPOutbound Inventory Agreement TypeStringUDC (42I AT)30 Allow NULL? 
57OHPOCUSTCustomer POStringGeneric Edit250 Allow NULL? 
58OHMLNMName - MailingStringGeneric Edit400 Allow NULL? 
59OHACTONAction when Agreement ExpiresCharacterUDC (42I AN)10 Allow NULL? 
60OHSQNBRAgreement PriorityNumericGeneric Edit30 Allow NULL? 
61OHRFC1Reference Code 1StringGeneric Edit250 Allow NULL? 
62OHRFC2Reference Code 2StringGeneric Edit250 Allow NULL? 
63OHRFC3Reference Code 3StringGeneric Edit250 Allow NULL? 
64OHRFC4Reference Code 4StringGeneric Edit250 Allow NULL? 
65OHFUTCHAR9Future Use Character 1CharacterGeneric Edit10 Allow NULL? 
66OHFUCHAR1Future Use Character 2CharacterGeneric Edit10 Allow NULL? 
67OHFUCHAR2Future Use Character 3CharacterGeneric Edit10 Allow NULL? 
68OHFUNUM7Future Use Number 1NumericGeneric Edit110 Allow NULL? 
69OHFUNUM8Future Use Number 2NumericGeneric Edit110 Allow NULL? 
70OHFUNUM9Future Use Number 3NumericGeneric Edit110 Allow NULL? 
71OHFUTSTR7Future Use String 1StringGeneric Edit500 Allow NULL? 
72OHFUTSTR8Future Use String 2StringGeneric Edit500 Allow NULL? 
73OHFUTSTR9Future Use String 3StringGeneric Edit500 Allow NULL? 
74OHFUDT3Future Use Date 1DateGeneric Edit60
75OHUSERUser IDStringGeneric Edit100 Allow NULL? 
76OHPIDProgram IDStringGeneric Edit100 Allow NULL? 
77OHJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
78OHUPMJDate - UpdatedDateGeneric Edit60
79OHTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
80OHACKLDTAcknowledgement DateJDE UTimeGeneric Edit110

TOP920 | 42I | F42I06 INDEXES

NumberDescription
1Cont Num Cont Sup UniqueID (Primary/Unique)
ElementAliasDescriptionSequence
1DMCTAgreement Number - DistributionAscending
2DMCSAgreement Supplement - DistributionAscending
3CNUKIDConsumption Unique IDDescending