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

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

105 COLUMNS | 2 INDEXES | Print definition?920 | 42 | F470371T TABLE

42: Sales Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F470371TUZ1052Tag for F470371- EDI shipping Notice Detail - OutboundFiles42: Sales ManagementBusiness 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 UZAAID, UZACOM, UZAID, UZANBY, UZANI, UZANTY, UZASN, UZBACK, UZCLVL, UZCMCG, UZCMGL, UZCMGP, UZCORD, UZDCTO, UZDMCS, UZDMCT, UZDOCO, UZEDBT, UZEDCT, UZEDDL, UZEDDT, UZEDER, UZEDFT, UZEDLN, UZEDOC, UZEDSP, UZEDSQ, UZEDST, UZEDTY, UZEKCO, UZEXR1, UZFAPP, UZFUN2, UZKCOO, UZLNID, UZLT, UZMCLN, UZMERL, UZNUMB, UZOBJ, UZODLN, UZOMCU, UZORP, UZORPR, UZOSEQ, UZPEND, UZPOE, UZPRGR, UZPROV, UZPRP3, UZPRP4, UZPRP5, UZPSDJ, UZRESL, UZRPRC, UZSBL, UZSBLT, UZSO02, UZSO03, UZSO04, UZSO05, UZSO06, UZSO07, UZSO08, UZSO09, UZSO10, UZSO11, UZSO12, UZSO13, UZSO14, UZSO15, UZSO16, UZSO17, UZSO18, UZSO19, UZSO20, UZSUB, UZSWMS, UZTAX1, UZTPC, UZTXA1, UZUNCD, UZUPC1, UZUPC2, UZUPC3, UZVEND, UZXCTO, UZXDCK, UZXKCO, UZXLLN, UZXORN, UZXPTY, UZXSFX, UZEMCU, UZIR01, UZIR02, UZIR03, UZIR04, UZIR05, UZSBAL, UZUSER, UZPID, UZJOBN, UZUPMJ, UZTDAY FROM F470371T

TOP920 | 42 | F470371T COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1UZAAIDParent NumberNumericGeneric Edit80 Allow NULL? 
2UZACOMApply Commission (Y/N)CharacterGeneric Edit10 Allow NULL? 
3UZAIDAccount IDStringGeneric Edit80 Allow NULL? 
4UZANBYBuyer NumberNumericGeneric Edit80 Allow NULL? 
5UZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
6UZANTYType - Address NumberCharacterUDC (40 AN)10 Allow NULL? 
7UZASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
8UZBACKBackorders Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
9UZCLVLPricing Category LevelStringGeneric Edit30 Allow NULL? 
10UZCMCGCommission CategoryStringGeneric Edit80 Allow NULL? 
11UZCMGLCommitment MethodCharacterUDC (H40 CM)10 Allow NULL? 
12UZCMGPCosting Method - InventoryStringGeneric Edit20 Allow NULL? 
13UZCORDChange Order NumberNumericGeneric Edit30 Allow NULL? 
14UZDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
15UZDMCSAgreement Supplement - DistributionNumericGeneric Edit30 Allow NULL? 
16UZDMCTAgreement Number - DistributionStringGeneric Edit120 Allow NULL? 
17UZDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
18UZEDBTEDI - Batch NumberStringGeneric Edit150 Allow NULL? 
19UZEDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
20UZEDDLEDI - Detail Lines ProcessedNumericGeneric Edit50 Allow NULL? 
21UZEDDTEDI - Transmission DateDateGeneric Edit60
22UZEDEREDI - Send/Receive IndicatorCharacterUDC (H00 ED)10 Allow NULL? 
23UZEDFTEDI - Translation FormatStringGeneric Edit100 Allow NULL? 
24UZEDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
25UZEDOCEDI - Document NumberNumericGeneric Edit90 Allow NULL? 
26UZEDSPEDI - Successfully ProcessedCharacterGeneric Edit10 Allow NULL? 
27UZEDSQRecord SequenceNumericGeneric Edit20 Allow NULL? 
28UZEDSTEDI - Transaction Set NumberStringUDC (40 ST)60 Allow NULL? 
29UZEDTYType RecordCharacterUDC (00 RD)10 Allow NULL? 
30UZEKCOCompany - Key (EDI - Document Key Co)StringGeneric Edit50 Allow NULL? 
31UZEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
32UZFAPPDiscount Application TypeCharacterGeneric Edit10 Allow NULL? 
33UZFUN2Trade Discount (Old)NumericGeneric Edit154 Allow NULL? 
34UZKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
35UZLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
36UZLTLedger TypesStringUDC (09 LT)20 Allow NULL? 
37UZMCLNMatrix Control Line NumberNumericGeneric Edit63 Allow NULL? 
38UZMERLItem Revision LevelStringGeneric Edit30 Allow NULL? 
39UZNUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
40UZOBJObject AccountStringGeneric Edit60 Allow NULL? 
41UZODLNDocument Line Number - OriginalNumericGeneric Edit73 Allow NULL? 
42UZOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
43UZORPOrder Repriced IndicatorCharacterGeneric Edit10 Allow NULL? 
44UZORPROrder Reprice CategoryStringUDC (40 PI)80 Allow NULL? 
45UZOSEQSequence NumberNumericGeneric Edit40 Allow NULL? 
46UZPENDPending Approval FlagCharacterGeneric Edit10 Allow NULL? 
47UZPOEPort of Entry or ExitStringUDC (40 PE)60 Allow NULL? 
48UZPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
49UZPROVPrice Override CodeCharacterGeneric Edit10 Allow NULL? 
50UZPRP3Supplier Rebate CodeStringUDC (41 P3)30 Allow NULL? 
51UZPRP4Master Planning FamilyStringUDC (41 P4)30 Allow NULL? 
52UZPRP5Purchasing Category Code 5StringUDC (41 P5)30 Allow NULL? 
53UZPSDJDate - Future Date 2DateGeneric Edit60
54UZRESLPrinted CodeCharacterGeneric Edit10 Allow NULL? 
55UZRPRCReprice (Basket Price) CategoryStringUDC (40 PI)80 Allow NULL? 
56UZSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
57UZSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
58UZSO02On Hand UpdatedCharacterGeneric Edit10 Allow NULL? 
59UZSO03Configurator Print FlagCharacterGeneric Edit10 Allow NULL? 
60UZSO04Sales Order Status 04CharacterGeneric Edit10 Allow NULL? 
61UZSO05Substitute Item IndicatorCharacterGeneric Edit10 Allow NULL? 
62UZSO06Preference Commitment IndicatorCharacterGeneric Edit10 Allow NULL? 
63UZSO07Ship date (PDDJ) overriddenCharacterGeneric Edit10 Allow NULL? 
64UZSO08Price Adjustment Line IndicatorCharacterGeneric Edit10 Allow NULL? 
65UZSO09Price Adj. History IndicatorCharacterGeneric Edit10 Allow NULL? 
66UZSO10Preference Production AllocationCharacterGeneric Edit10 Allow NULL? 
67UZSO11Transfer/Direct Ship/Intercompany FlagCharacterGeneric Edit10 Allow NULL? 
68UZSO12Deferred entries flagCharacterGeneric Edit10 Allow NULL? 
69UZSO13Euro Conversion Status FlagCharacterGeneric Edit10 Allow NULL? 
70UZSO14Sales Order Status 14CharacterGeneric Edit10 Allow NULL? 
71UZSO15Sales Order Status 15CharacterGeneric Edit10 Allow NULL? 
72UZSO16Manufacturing Variance Accounting FlagCharacterGeneric Edit10 Allow NULL? 
73UZSO17Sales Order Status 17CharacterGeneric Edit10 Allow NULL? 
74UZSO18Sales Order Status 18CharacterGeneric Edit10 Allow NULL? 
75UZSO19Sales Order Status 19CharacterGeneric Edit10 Allow NULL? 
76UZSO20Sales Order Status 20CharacterGeneric Edit10 Allow NULL? 
77UZSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
78UZSWMSStatus - In WarehouseCharacterGeneric Edit10 Allow NULL? 
79UZTAX1Sales Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
80UZTPCTemporary Price (Y/N)CharacterGeneric Edit10 Allow NULL? 
81UZTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
82UZUNCDWork Order Freeze CodeCharacterUDC (H00 UN)10 Allow NULL? 
83UZUPC1Price Code 1StringUDC (40 P1)20 Allow NULL? 
84UZUPC2Price Code 2StringUDC (40 P2)20 Allow NULL? 
85UZUPC3Price Code 3StringUDC (40 P3)20 Allow NULL? 
86UZVENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
87UZXCTOCross Dock Order TypeStringUDC (00 DT)20 Allow NULL? 
88UZXDCKCross-Docking FlagCharacterGeneric Edit10 Allow NULL? 
89UZXKCOCross Dock Order Company (Order Number)StringGeneric Edit50 Allow NULL? 
90UZXLLNCross Dock Line NumberNumericGeneric Edit63 Allow NULL? 
91UZXORNCross Dock Order NoNumericGeneric Edit80 Allow NULL? 
92UZXPTYCross Docking Priority for Sales OrdersNumericGeneric Edit150 Allow NULL? 
93UZXSFXCross Dock Order SuffixStringGeneric Edit30 Allow NULL? 
94UZEMCUBusiness Unit - HeaderStringGeneric Edit120 Allow NULL? 
95UZIR01Integration Reference 01StringGeneric Edit300 Allow NULL? 
96UZIR02Integration Reference 02StringGeneric Edit300 Allow NULL? 
97UZIR03Integration Reference 03StringGeneric Edit300 Allow NULL? 
98UZIR04Integration Reference 04StringGeneric Edit300 Allow NULL? 
99UZIR05Integration Reference 05StringGeneric Edit300 Allow NULL? 
100UZSBALSubstitutes Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
101UZUSERUser IDStringGeneric Edit100 Allow NULL? 
102UZPIDProgram IDStringGeneric Edit100 Allow NULL? 
103UZJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
104UZUPMJDate - UpdatedDateGeneric Edit60
105UZTDAYTime of DayNumericGeneric Edit60 Allow NULL? 

TOP920 | 42 | F470371T INDEXES

NumberDescription
1Primary EDOC EDCT EKCO EDLN (Primary/Unique)
ElementAliasDescriptionSequence
1EDOCEDI - Document NumberAscending
2EKCOCompany - Key (EDI - Document Key Co)Ascending
3EDLNEDI - Line NumberAscending
4EDCTEDI - Document TypeAscending
2Document Number Doc Type +
ElementAliasDescriptionSequence
1EDOCEDI - Document NumberAscending
2EDCTEDI - Document TypeAscending
3EKCOCompany - Key (EDI - Document Key Co)Ascending