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

158 COLUMNS | 1 INDEXES | Print definition?920 | 45 | F4576Z1 TABLE

45: Advanced Pricing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F4576Z1Z11581Ship and Debit Claims Unedited Transaction TableTransaction Files45: Advanced PricingBusiness 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 Z1EDUS, Z1EDBT, Z1EDTN, Z1EDLN, Z1EDCT, Z1TYTN, Z1EDFT, Z1EDDT, Z1DRIN, Z1EDDL, Z1EDSP, Z1PNID, Z1TNAC, Z1DOCO, Z1DCTO, Z1KCOO, Z1SFXO, Z1LNID, Z1OSEQ, Z1PA04, Z1AST, Z1AGTY, Z1ANS8, Z1MCU, Z1IGID, Z1CGID, Z1AN8, Z1CPGP, Z1ITM, Z1PRGR, Z1CATN, Z1CCF3, Z1CTYE, Z1CLMD, Z1SCNT, Z1ACCS, Z1ACCA, Z1CLAD, Z1CAF, Z1CRCD, Z1BCRC, Z1CLNR, Z1DESC, Z1DOC, Z1DCT, Z1KCO, Z1SFX, Z1SFXE, Z1SDOC, Z1SDCT, Z1SKCO, Z1SFX0, Z1DOCM, Z1DCTM, Z1SCLM, Z1ADDJ, Z1CNFD, Z1CSCD, Z1DSC1, Z1RPER, Z1UOM, Z1SOQS, Z1QYCL, Z1CLRR, Z1BN01, Z1BTY1, Z1SLSP, Z1ABR1, Z1ABR2, Z1ABR3, Z1ABR4, Z1ABT1, Z1ABT2, Z1ABT3, Z1ABT4, Z1UM, Z1SBL, Z1SBLT, Z1ANI, Z1DAMD, Z1DAMF, Z1EMCU, Z1CO, Z1FLIT, Z1ICU, Z1ICUT, Z1DE01, Z1DE02, Z1DE03, Z1DE04, Z1DE05, Z1URCD, Z1URDT, Z1URAT, Z1URAB, Z1URRF, Z1USER, Z1PID, Z1JOBN, Z1UPMJ, Z1TDAY, Z1EDOC, Z1TPUR, Z1CITM, Z1EDST, Z1IVD, Z1ASN, Z1MNQ, Z1LEDG, Z1UPRC, Z1FUP, Z1GLC, Z1FVMD, Z1FVTR, Z1QYAP, Z1ACNT, Z1EFTJ, Z1EXDJ, Z1BDCS, Z1BDCL, Z1FRMN, Z1MQYQ, Z1MAQY, Z1QYOA, Z1AGNB, Z1OKCO, Z1OORN, Z1OCTO, Z1OGNO, Z1RORN, Z1RCTO, Z1RLLN, Z1SHAN, Z1PA8, Z1TRDJ, Z1LITM, Z1AITM, Z1RLIT, Z1KTLN, Z1CPNT, Z1RKIT, Z1KTP, Z1AEXP, Z1UNCS, Z1ECST, Z1ODOC, Z1ODCT, Z1OKC, Z1TAX1, Z1TXA1, Z1EXR1, Z1VEND, Z1UOM1, Z1CRR, Z1FPRC, Z1FEA, Z1FUC, Z1FEC FROM F4576Z1

TOP920 | 45 | F4576Z1 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1Z1EDUSEDI - User IDStringGeneric Edit100 Allow NULL? 
2Z1EDBTEDI - Batch NumberStringGeneric Edit150 Allow NULL? 
3Z1EDTNEDI - Transaction NumberStringGeneric Edit220 Allow NULL? 
4Z1EDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
5Z1EDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
6Z1TYTNType - TransactionStringUDC (00 TT)80 Allow NULL? 
7Z1EDFTEDI - Translation FormatStringGeneric Edit100 Allow NULL? 
8Z1EDDTEDI - Transmission DateDateGeneric Edit60
9Z1DRINDirection IndicatorCharacterUDC (00 DN)10 Allow NULL? 
10Z1EDDLEDI - Detail Lines ProcessedNumericGeneric Edit50 Allow NULL? 
11Z1EDSPEDI - Successfully ProcessedCharacterGeneric Edit10 Allow NULL? 
12Z1PNIDTrading Partner IDStringGeneric Edit150 Allow NULL? 
13Z1TNACTransaction ActionStringUDC (00 TA)20 Allow NULL? 
14Z1DOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
15Z1DCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
16Z1KCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
17Z1SFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
18Z1LNIDLine NumberNumericGeneric Edit63 Allow NULL? 
19Z1OSEQSequence NumberNumericGeneric Edit40 Allow NULL? 
20Z1PA04Target ApplicationCharacterUDC (40 TA)10 Allow NULL? 
21Z1ASTPrice Adjustment NameStringUDC (40 TY)80 Allow NULL? 
22Z1AGTYAgreementTypeStringUDC (45 AT)20 Allow NULL? 
23Z1ANS8Address NumberNumericGeneric Edit80 Allow NULL? 
24Z1MCUBusiness UnitStringGeneric Edit120 Allow NULL? 
25Z1IGIDItem Group Key IDNumericGeneric Edit80 Allow NULL? 
26Z1CGIDCustomer Group Key IDNumericGeneric Edit80 Allow NULL? 
27Z1AN8Address NumberNumericGeneric Edit80 Allow NULL? 
28Z1CPGPCustomer Price GroupStringUDC (40 PC)80 Allow NULL? 
29Z1ITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
30Z1PRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
31Z1CATNCatalogStringUDC (40 CN)80 Allow NULL? 
32Z1CCF3Currency Code - From 3StringGeneric Edit30 Allow NULL? 
33Z1CTYEClaim Type CodeStringUDC (45 CT)20 Allow NULL? 
34Z1CLMDClaim MethodCharacterUDC (45 CM)10 Allow NULL? 
35Z1SCNTStatus Code - NextStringUDC (45 SC)20 Allow NULL? 
36Z1ACCSAccount Number - Cost of Goods ReductionStringGeneric Edit290 Allow NULL? 
37Z1ACCAAccount Number - Claim AccrualStringGeneric Edit290 Allow NULL? 
38Z1CLADClaim Amount - DomesticNumericGeneric Edit152 Allow NULL? 
39Z1CAFClaim Amount - ForeignNumericGeneric Edit152 Allow NULL? 
40Z1CRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
41Z1BCRCCurrency Code - BaseStringGeneric Edit30 Allow NULL? 
42Z1CLNRClaim NumberNumericGeneric Edit80 Allow NULL? 
43Z1DESCDescriptionStringGeneric Edit300 Allow NULL? 
44Z1DOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
45Z1DCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
46Z1KCODocument CompanyStringGeneric Edit50 Allow NULL? 
47Z1SFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
48Z1SFXEPay Item Extension NumberNumericGeneric Edit20 Allow NULL? 
49Z1SDOCSales Document NumberNumericGeneric Edit80 Allow NULL? 
50Z1SDCTSales Document TypeStringUDC (00 DT)20 Allow NULL? 
51Z1SKCODocument Company (Sales Order)StringGeneric Edit50 Allow NULL? 
52Z1SFX0Document Pay ItemStringGeneric Edit30 Allow NULL? 
53Z1DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80 Allow NULL? 
54Z1DCTMDocument Type - MatchingStringUDC (00 DT)20 Allow NULL? 
55Z1SCLMAddress Number - Send Claim ToNumericGeneric Edit80 Allow NULL? 
56Z1ADDJDate - Actual Ship DateDateGeneric Edit60
57Z1CNFDDate - Claim NotificationDateGeneric Edit60
58Z1CSCDDate - Last Claim Status ChangeDateGeneric Edit60
59Z1DSC1DescriptionStringGeneric Edit300 Allow NULL? 
60Z1RPERPerson ResponsibleNumericGeneric Edit80 Allow NULL? 
61Z1UOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
62Z1SOQSQuantity ShippedNumericGeneric Edit150 Allow NULL? 
63Z1QYCLUnits - Claimed QuantityNumericGeneric Edit150 Allow NULL? 
64Z1CLRRClaim Reject Reason CodeStringUDC (45 RR)20 Allow NULL? 
65Z1BN01Batch NumberNumericGeneric Edit80 Allow NULL? 
66Z1BTY1Batch Type1StringUDC (98 IT)20 Allow NULL? 
67Z1SLSPSalespersonNumericGeneric Edit80 Allow NULL? 
68Z1ABR1Managerial Analysis Code 1StringGeneric Edit120 Allow NULL? 
69Z1ABR2Managerial Analysis Code 2StringGeneric Edit120 Allow NULL? 
70Z1ABR3Managerial Analysis Code 3StringGeneric Edit120 Allow NULL? 
71Z1ABR4Managerial Analysis Code 4StringGeneric Edit120 Allow NULL? 
72Z1ABT1Managerial Analysis Type 1CharacterUDC10 Allow NULL? 
73Z1ABT2Managerial Analysis Type 2CharacterUDC10 Allow NULL? 
74Z1ABT3Managerial Analysis Type 3CharacterUDC10 Allow NULL? 
75Z1ABT4Managerial Analysis Type 4CharacterUDC10 Allow NULL? 
76Z1UMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
77Z1SBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
78Z1SBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
79Z1ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
80Z1DAMDAmount - Debit per UnitNumericGeneric Edit154 Allow NULL? 
81Z1DAMFAmount - Debit Foreign per UnitNumericGeneric Edit154 Allow NULL? 
82Z1EMCUBusiness Unit - HeaderStringGeneric Edit120 Allow NULL? 
83Z1COCompanyStringGeneric Edit50 Allow NULL? 
84Z1FLITItem Number - Flex AccountingNumericGeneric Edit80 Allow NULL? 
85Z1ICUBatch NumberNumericGeneric Edit80 Allow NULL? 
86Z1ICUTBatch TypeStringUDC (98 IT)20 Allow NULL? 
87Z1DE01Claims 01StringGeneric Edit30 Allow NULL? 
88Z1DE02Claims 02StringGeneric Edit30 Allow NULL? 
89Z1DE03Claims 03StringGeneric Edit30 Allow NULL? 
90Z1DE04Claims 04StringGeneric Edit30 Allow NULL? 
91Z1DE05Claims 05StringGeneric Edit30 Allow NULL? 
92Z1URCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
93Z1URDTUser Reserved DateDateGeneric Edit60
94Z1URATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
95Z1URABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
96Z1URRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
97Z1USERUser IDStringGeneric Edit100 Allow NULL? 
98Z1PIDProgram IDStringGeneric Edit100 Allow NULL? 
99Z1JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
100Z1UPMJDate - UpdatedDateGeneric Edit60
101Z1TDAYTime of DayNumericGeneric Edit60 Allow NULL? 
102Z1EDOCEDI - Document NumberNumericGeneric Edit90 Allow NULL? 
103Z1TPURTransaction Set PurposeStringUDC (47 PU)20 Allow NULL? 
104Z1CITMItem Number - Customer/SupplierStringGeneric Edit250 Allow NULL? 
105Z1EDSTEDI - Transaction Set NumberStringUDC (40 ST)60 Allow NULL? 
106Z1IVDDate - InvoiceDateGeneric Edit60
107Z1ASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
108Z1MNQQuantity - FromNumericGeneric Edit150 Allow NULL? 
109Z1LEDGCost MethodStringUDC (40 CM)20 Allow NULL? 
110Z1UPRCAmount - Price per UnitNumericGeneric Edit154 Allow NULL? 
111Z1FUPAmount - Foreign Price per UnitNumericGeneric Edit154 Allow NULL? 
112Z1GLCG/L OffsetStringGeneric Edit40 Allow NULL? 
113Z1FVMDFactor Value MethodCharacterUDC (40 BC)10 Allow NULL? 
114Z1FVTRFactor ValueNumericGeneric Edit154 Allow NULL? 
115Z1QYAPUnits - Quantity AppliedNumericGeneric Edit150 Allow NULL? 
116Z1ACNTAdjustment Control CodeCharacterUDC (40 CO)10 Allow NULL? 
117Z1EFTJDate - EffectiveDateGeneric Edit60
118Z1EXDJDate - ExpiredDateGeneric Edit60
119Z1BDCSAmount - Based On CostNumericGeneric Edit154 Allow NULL? 
120Z1BDCLBased On Cost Lock FlagCharacterGeneric Edit10 Allow NULL? 
121Z1FRMNPrice Formula NameStringUDC (40 FM)100 Allow NULL? 
122Z1MQYQUnits - Minimum Quantity to QualifyNumericGeneric Edit150 Allow NULL? 
123Z1MAQYUnits - Maximum Authorized QuantityNumericGeneric Edit150 Allow NULL? 
124Z1QYOAUnits - Quantity Open/AvailableNumericGeneric Edit150 Allow NULL? 
125Z1AGNBAgreement Number - SupplierStringGeneric Edit300 Allow NULL? 
126Z1OKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
127Z1OORNOriginal Order NumberStringGeneric Edit80 Allow NULL? 
128Z1OCTOOriginal Order TypeStringUDC (00 DT)20 Allow NULL? 
129Z1OGNOOriginal Line NumberNumericGeneric Edit73 Allow NULL? 
130Z1RORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
131Z1RCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
132Z1RLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
133Z1SHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
134Z1PA8Address Number - ParentNumericGeneric Edit80 Allow NULL? 
135Z1TRDJDate - Order/TransactionDateGeneric Edit60
136Z1LITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
137Z1AITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
138Z1RLITItem Number - Related (Kit)StringGeneric Edit80 Allow NULL? 
139Z1KTLNKit Master Line NumberNumericGeneric Edit63 Allow NULL? 
140Z1CPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
141Z1RKITRelated Kit ComponentNumericGeneric Edit80 Allow NULL? 
142Z1KTPNumber of Component Per ParentNumericGeneric Edit150 Allow NULL? 
143Z1AEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
144Z1UNCSAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
145Z1ECSTAmount - Extended CostNumericGeneric Edit152 Allow NULL? 
146Z1ODOCDocument - OriginalNumericGeneric Edit80 Allow NULL? 
147Z1ODCTDocument Type - OriginalStringUDC (00 DT)20 Allow NULL? 
148Z1OKCDocument Company - OriginalStringGeneric Edit50 Allow NULL? 
149Z1TAX1Sales Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
150Z1TXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
151Z1EXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
152Z1VENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
153Z1UOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
154Z1CRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
155Z1FPRCAmount - List Price per UnitNumericGeneric Edit154 Allow NULL? 
156Z1FEAAmount - Foreign Extended PriceNumericGeneric Edit152 Allow NULL? 
157Z1FUCAmount - Foreign Unit CostNumericGeneric Edit154 Allow NULL? 
158Z1FECAmount - Foreign Extended CostNumericGeneric Edit152 Allow NULL? 

TOP920 | 45 | F4576Z1 INDEXES

NumberDescription
1EDUS EDBT EDTN EDCT (Primary/Unique)
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4EDLNEDI - Line NumberAscending