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

83 columns | Print definition?920 | TNAC | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0006Z1Cost Center Unedited Transaction Table13SZTNACTransaction ActionStringUDC20
2F0401Z1Supplier Master - Batch Upload13VOTNACTransaction ActionStringUDC20
TOP01: Address Book
3F0101Z2Address Book - Interoperability13SZTNACTransaction ActionStringUDC20
4F01112Z1Batch - Related Person13PBTNACTransaction ActionStringUDC20
5F0111Z1Batch Who's Who Information13BWTNACTransaction ActionStringUDC20
6F01151Z1Batch - Electronic Address13EBTNACTransaction ActionStringUDC20
7F0115Z1Phones - Interoperability14PITNACTransaction ActionStringUDC20
8F01161Z1Batch - Alternative Address13LBTNACTransaction ActionStringUDC20
TOP03: Accounts Receivable
9F03012Z1Customer Master LOB-Batch Table13VOTNACTransaction ActionStringUDC20
TOP03B: Enhanced Accounts Receivable
10F03B11Z2F03B11 Interoperability Table13SYTNACTransaction ActionStringUDC20
11F03B13Z2F03B13 Interoperability Table13SYTNACTransaction ActionStringUDC20
12F03B14Z2F03B14 Interoperability Table13SZTNACTransaction ActionStringUDC20
13F03B41Z1Inteoperability - Deductions Management13SZTNACTransaction ActionStringUDC20
TOP04: Accounts Payable
14F0411Z3F0411 Interoperability Table13SZTNACTransaction ActionStringUDC20
15F0413Z1F0413 Interoperability Table13SYTNACTransaction ActionStringUDC20
16F0414Z1F0414 Interoperability Table13SZTNACTransaction ActionStringUDC20
TOP05A: PeopleSoft HR & PR Foundation
17F060116ZUnedited Quick Hire Transaction File13SZTNACTransaction ActionStringUDC20
TOP09: General Accounting
18F0911Z4F0911 Interoperability Table13SZTNACTransaction ActionStringUDC20
TOP10: Financial Reporting
19F1001Z1Unedited MSC Interoperability Header Table13IATNACTransaction ActionStringUDC20
20F1002Z1Unedited MSC Interoperability Table13SZTNACTransaction ActionStringUDC20
TOP11: Multi Currency
21F0015Z1External Currency Exchange Rates13ZETNACTransaction ActionStringUDC20
TOP12: Fixed Assets
22F1201Z1Unedited Asset Master Transactions13FATNACTransaction ActionStringUDC20
23F1217Z1Unedited Equipment Tag Transactions13WRTNACTransaction ActionStringUDC20
24F1217Z2Unedited Equipment Tag Transactions13WRTNACTransaction ActionStringUDC20
TOP13: Plant/Equipment Management
25F12120Z1Unedited Meter Reading Transactions13SZTNACTransaction ActionStringUDC20
TOP13C: Condition-Base Maintenance
26F1310Z1Unedited Condition-Based Alerts13CBTNACTransaction ActionStringUDC20
TOP16: Profit Management (EPS)
27F1602Z1External Cost Analyzer Balances - Interoperability Table13CZTNACTransaction ActionStringUDC20
28F1632Z1External Driver Balances-Interoperability Table13CYTNACTransaction ActionStringUDC20
TOP17: Customer Service Management
29F3111Z2Warranty Claim/Supplier Recovery processing13WPTNACTransaction ActionStringUDC20
30F3112Z2Warranty Claim/Supplier Recovery processing13WLTNACTransaction ActionStringUDC20
31F4801TZ2Warranty Claim/Supplier Recovery processing13WQTNACTransaction ActionStringUDC20
32F4801Z2Warranty Claim/Supplier Recovery processing13WSTNACTransaction ActionStringUDC20
TOP30: Product Data Management
33F0007Z1Work Day Calendar Transaction File13SZTNACTransaction ActionStringUDC20
34F30006Z1Work Center Transaction File13SZTNACTransaction ActionStringUDC20
35F3002Z1Bill of Material Transaction File13SZTNACTransaction ActionStringUDC20
36F3003Z1Routing Transactions File13SZTNACTransaction ActionStringUDC20
TOP31: Shop Floor Control
37F30161Z1Inbound Kanban Card Detail13SZTNACTransaction ActionStringUDC20
38F3111Z1Outbound Work Order Parts List13SZTNACTransaction ActionStringUDC20
39F31122Z1Work Order Time Transactions Unedited Transaction Table13SZTNACTransaction ActionStringUDC20
40F3112Z1Outbound Work Order Routings13SZTNACTransaction ActionStringUDC20
TOP31B: Blend Management
41F31B17Z1Operation EUR Transaction File13SZTNACTransaction ActionStringUDC20
42F31B18Z1VBT Barrel Transaction File13SZTNACTransaction ActionStringUDC20
43F31B19Z1Instructed Attributes Transaction File13SZTNACTransaction ActionStringUDC20
44F31B31Z1Operations Composition Transaction File13SZTNACTransaction ActionStringUDC20
45F31B34Z1Operations Style Transaction File13SZTNACTransaction ActionStringUDC20
46F31B3CZ1Operations Cost Transaction File13SZTNACTransaction ActionStringUDC20
47F31B52Z1Operations Equipment Transaction File13SZTNACTransaction ActionStringUDC20
48F31B53Z1Operations Consumables Transaction File13SZTNACTransaction ActionStringUDC20
49F31B65Z1Operations Transaction File13SZTNACTransaction ActionStringUDC20
50F31B93Z1WIM Work Order Transaction File13SZTNACTransaction ActionStringUDC20
51F31B97Z1Operations Resource Transaction File13SZTNACTransaction ActionStringUDC20
52F31BQAZ1Operations Quality Test Transaction File16SZTNACTransaction ActionStringUDC20
53F31BSPZ1Sample Transactions43STTNACTransaction ActionStringUDC20
TOP36: Forecasting
54F3460Z1Forecast Unedited Transactions13FTTNACTransaction ActionStringUDC20
TOP37: Quality Management
55F3711Z1Test Results Unedited Transaction Table13SZTNACTransaction ActionStringUDC20
TOP40: Inventory/OP Base
56F4106NCBase Price Extraction13SZTNACTransaction ActionStringUDC20
57F4201Z1Sales Order Header Unedited Transaction File13SYTNACTransaction ActionStringUDC20
58F4211Z1Sales Order Detail Unedited Transaction File13SZTNACTransaction ActionStringUDC20
59F49211Z1Sales Order Detail Tag Unedited Transaction File13S1TNACTransaction ActionStringUDC20
TOP41: Inventory Management
60F4101AItem File134IMTNACTransaction ActionStringUDC20
61F4101Z1F4101 Item Master Unedited Transaction Table13SZTNACTransaction ActionStringUDC20
62F4101Z1AF4101 Detail Item Master Unedited Transaction13SZTNACTransaction ActionStringUDC20
63F41021Z1Item Location Unedited Transaction File13SZTNACTransaction ActionStringUDC20
64F4105Z1Unedited Transaction Table - Item Cost13SZTNACTransaction ActionStringUDC20
65F4141Z1F4141 Cycle Count Unedited Transaction Table13SZTNACTransaction ActionStringUDC20
TOP43: Procurement
66F4301Z1Purchase Order Header Unedited Transaction Table13SYTNACTransaction ActionStringUDC20
67F43092Z1Receipt Routing Unedited Transaction Table12SZTNACTransaction ActionStringUDC20
68F4311Z1Purchase Order Detail Unedited Transaction Table13SZTNACTransaction ActionStringUDC20
69F43121Z1Receipts Unedited Transaction Table13SZTNACTransaction ActionStringUDC20
TOP44H: Homebuilder Management
70F44H101ZHB Community Master Unedited Transaction File13SZTNACTransaction ActionStringUDC20
71F44H201ZHB Lot Master Unedited Transaction File13SZTNACTransaction ActionStringUDC20
72F44H501ZHB Sales Master Unedited Transaction File13SZTNACTransaction ActionStringUDC20
73F44H604ZHB Vendor Assignment Unedited Transaction File13SZTNACTransaction ActionStringUDC20
74F44H711ZHB Lot Start Unedited Transaction File13SZTNACTransaction ActionStringUDC20
TOP45: Advanced Pricing
75F4572Z1Live Promotions Interface - Inbound / Outbound6LPTNACTransaction ActionStringUDC20
76F4572ZPPurge Live Promotions Interface6PGTNACTransaction ActionStringUDC20
77F4576Z1Ship and Debit Claims Unedited Transaction Table13Z1TNACTransaction ActionStringUDC20
TOP46: Warehouse Management
78F4611Z1Unedited Suggestion Table13SZTNACTransaction ActionStringUDC20
79F4942Z1Work File for F494213SYTNACTransaction ActionStringUDC20
TOP48: Work Order Processing
80F4801Z1Outbound Work Order Header13SYTNACTransaction ActionStringUDC20
TOP70: Multi-National Products
81F70XMLZ1XML Transaction Interfase13SYTNACTransaction ActionStringUDC20
TOP74: EMEA Localization
82F74XMLZ1XML Transaction Interface13SYTNACTransaction ActionStringUDC20
TOP89: Conversion Programs
83F01111Z1Batch - Contact Information13CBTNACTransaction ActionStringUDC20

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 00 / TA (Transaction Action) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1        00Original Y
2        01Cancellation Y
3        02Add N
4        03Delete N
5        04Change Y
6        05Replace Y
7        06Confirmation Y
8        07Duplicate N
9        08Status N
10        10Not Found N
11        11Response N
12        12Not Processed N
13        13Request N
14        14Advance Notification N
15        15Re-Submission N
16        16Proposed N
17        17Cancel to be Reissued N
18        18Reissue N
19        19Seller Initiated Change N
20        20Final Transmission N
21        21Transaction on Hold N
22        22Information Copy N
23        24Draft N
24        25Incremental N
25        26Replace-Specified Buyer Part N
26        27Verify N
27        28Query N
28        30Renewal N
29        31Allowance/Addition N
30        32Recovery/Deduction N
31        33Request for Payment N
32        34Payment Declined N
33        35Request Authority N
34        36Authority to Deduct (Reply) N
35        37Authority Declined (Reply) N
36        38No Financial Value N
37        41Corrected and Verified N
38        42Temporary Record N
39        43Request Permission to Service N
40        44Rejection N
41        45Followup N
42        46Cancellation with Refund N
43        47Transfer N
44        48Suspended N
45        49Original - No Response Necess. N
46        50Registar N
47        51Historical Inquiry N
48        52Response to Historical Inquiry N
49        53Completion N
50        54Approval N
51        5CChargeable Resubmission N
52        77Simulation Exercise N
53        AAdd Y
54        AIAdd Additional Item(s) Y
55        CChange Y
56        CAChanges to Line Items N
57        CBChange of Date Terms N
58        CCChanges To Terms N
59        CEChg-Item Level Allowance/Chg N
60        CFCancel Prev Transmitted P.O. N
61        CGChg-Total Lev Allowance/Charge N
62        CHChg Orig Confirm Corig Announc N
63        CIChg Confirm Revised Announce N
64        CNComplete Notification N
65        COCorrected N
66        CTChange of Dates N
67        DDelete Y
68        DIDelete Item(s) N
69        IInquiry Y
70        MU(Mult) Un Price Qty Reshed Chg N
71        NCConcurrent Item (No Change) N
72        OAOrig Confirm Revised Announce N
73        OCOrig Confirm of Orig Announce N
74        PCPrice Change N
75        PQUnit Price/Quantity Change N
76        PRUnit Price/Reschedule Change N
77        QDQuantity Decrease N
78        QIQuantity Increase N
79        RReplace Y
80        RAReplace Mode of Shipment N
81        RBReplace All Dates N
82        RCReject Item Change N
83        REReplacement Item N
84        RHRelease Hold N
85        RMReplacement Item-Modifications N
86        RQReschedule/Quantity Change N
87        RSReschedule N
88        RZReplace All Values N
89        SSame as Except Y
90        SUStatus Update N
91        TITransfer Item N
92        UAUpdate - After Image Y
93        UBUpdate - Before Image Y
94        ZZMutual Defined N