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 | Print definition?812 | TNAC | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0006Z1Cost Center Unedited Transaction Table13SZTNACTransaction ActionStringUDC20
2F0401Z1Supplier Master - Batch File13VOTNACTransaction ActionStringUDC20
TOP01: Address Book
3F0101Z2Address Book - Interoperability13SZTNACTransaction ActionStringUDC20
4F01111Z1Batch - Contact Information13CBTNACTransaction ActionStringUDC20
5F01112Z1Batch - Related Person13PBTNACTransaction ActionStringUDC20
6F0111Z1Batch Who's Who Information13BWTNACTransaction ActionStringUDC20
7F01151Z1Batch - Electronic Address13EBTNACTransaction ActionStringUDC20
8F0115Z1Phones - Interoperability14PITNACTransaction ActionStringUDC20
9F01161Z1Batch - Alternative Address13LBTNACTransaction ActionStringUDC20
TOP03: Accounts Receivable
10F03012Z1Customer Master LOB-Batch File13VOTNACTransaction ActionStringUDC20
TOP03B: Enhanced Accounts Receivable
11F03B11Z2F03B11 Interoperability Table13SYTNACTransaction ActionStringUDC20
12F03B13Z2F03B13 Interoperability Table13SYTNACTransaction ActionStringUDC20
13F03B14Z2F03B14 Interoperability Table13SZTNACTransaction ActionStringUDC20
14F03B41Z1Inteoperability - Deductions Management13SZTNACTransaction ActionStringUDC20
TOP04: Accounts Payable
15F0411Z3F0411 Interoperability Table13SZTNACTransaction ActionStringUDC20
16F0413Z1F0413 Interoperability Table13SYTNACTransaction ActionStringUDC20
17F0414Z1F0414 Interoperability Table13SZTNACTransaction ActionStringUDC20
TOP05A: OW HR & PR Foundation
18F060116ZUnedited Quick Hire Transaction File13SZTNACTransaction ActionStringUDC20
TOP09: General Accounting
19F0911Z4F0911 Interoperability Table13SZTNACTransaction ActionStringUDC20
TOP10: Financial Reporting
20F1001Z1Unedited MSC Interoperability Header Table13IATNACTransaction ActionStringUDC20
21F1002Z1Unedited MSC Interoperability Table13SZTNACTransaction ActionStringUDC20
TOP11: Multi Currency
22F0015Z1External Currency Exchange Rates13ZETNACTransaction ActionStringUDC20
TOP12: Fixed Assets
23F1201Z1Unedited Asset Master Transactions13FATNACTransaction ActionStringUDC20
24F1217Z1Unedited Equipment Tag Transactions13WRTNACTransaction ActionStringUDC20
25F1217Z2Unedited Equipment Tag Transactions13WRTNACTransaction ActionStringUDC20
TOP13: Plant/Equipment Management
26F12120Z1Unedited Meter Reading Transactions13SZTNACTransaction ActionStringUDC20
TOP13C: Condition-Base Maintenance
27F1310Z1Unedited Condition-Based Alerts13CBTNACTransaction ActionStringUDC20
TOP16: Profit Management (EPS)
28F1602Z1External Cost Analyzer Balances - Interoperability Table13CZTNACTransaction ActionStringUDC20
29F1632Z1External Driver Balances-Interoperability Table13CYTNACTransaction ActionStringUDC20
TOP17: Customer Service Management
30F3111Z2Warranty Claim/Supplier Recovery processing13WPTNACTransaction ActionStringUDC20
31F3112Z2Warranty Claim/Supplier Recovery processing13WLTNACTransaction ActionStringUDC20
32F4801TZ2Warranty Claim/Supplier Recovery processing13WQTNACTransaction ActionStringUDC20
33F4801Z2Warranty Claim/Supplier Recovery processing13WSTNACTransaction ActionStringUDC20
TOP30: Product Data Management
34F0007Z1Work Day Calendar Transaction File13SZTNACTransaction ActionStringUDC20
35F30006Z1Work Center Transaction File13SZTNACTransaction ActionStringUDC20
36F3002Z1Bill of Material Transaction File13SZTNACTransaction ActionStringUDC20
37F3003Z1Routing Transactions File13SZTNACTransaction ActionStringUDC20
TOP31: Shop Floor Control
38F30161Z1Inbound Kanban Card Detail13SZTNACTransaction ActionStringUDC20
39F3111Z1Outbound Work Order Parts List13SZTNACTransaction ActionStringUDC20
40F31122Z1Work Order Time Transactions Unedited Transaction Table13SZTNACTransaction ActionStringUDC20
41F3112Z1Outbound Work Order Routings13SZTNACTransaction ActionStringUDC20
42F4801Z1Outbound Work Order Header13SYTNACTransaction ActionStringUDC20
TOP31B: Blend Management
43F31B17Z1Operation EUR Transaction File13SZTNACTransaction ActionStringUDC20
44F31B18Z1VBT Barrel Transaction File13SZTNACTransaction ActionStringUDC20
45F31B19Z1Instructed Attributes Transaction File13SZTNACTransaction ActionStringUDC20
46F31B31Z1Operations Composition Transaction File13SZTNACTransaction ActionStringUDC20
47F31B34Z1Operations Style Transaction File13SZTNACTransaction ActionStringUDC20
48F31B3CZ1Operations Cost Transaction File13SZTNACTransaction ActionStringUDC20
49F31B52Z1Operations Equipment Transaction File13SZTNACTransaction ActionStringUDC20
50F31B53Z1Operations Consumables Transaction File13SZTNACTransaction ActionStringUDC20
51F31B65Z1Operations Transaction File13SZTNACTransaction ActionStringUDC20
52F31B93Z1WIM Work Order Transaction File13SZTNACTransaction ActionStringUDC20
53F31B97Z1Operations Resource Transaction File13SZTNACTransaction ActionStringUDC20
54F31BQAZ1Operations Quality Test Transaction File13SZTNACTransaction ActionStringUDC20
TOP36: Forecasting
55F3460Z1Forecast Unedited Transactions13FTTNACTransaction ActionStringUDC20
TOP37: Quality Management
56F3711Z1Test Results Unedited Transaction Table13SZTNACTransaction ActionStringUDC20
TOP40: Inventory/OP Base
57F4106NCBase Price Extraction13SZTNACTransaction ActionStringUDC20
58F4201Z1Sales Order Header Unedited Transaction File13SYTNACTransaction ActionStringUDC20
59F4211Z1Sales Order Detail Unedited Transaction File13SZTNACTransaction ActionStringUDC20
60F49211Z1Sales Order Detail Tag Unedited Transaction File13S1TNACTransaction ActionStringUDC20
TOP41: Inventory Management
61F4101AItem File134IMTNACTransaction ActionStringUDC20
62F4101Z1F4101 Item Master Unedited Transaction Table13SZTNACTransaction ActionStringUDC20
63F4101Z1AF4101 Detail Item Master Unedited Transaction13SZTNACTransaction ActionStringUDC20
64F41021Z1Item Location Unedited Transaction File13SZTNACTransaction ActionStringUDC20
65F4105Z1Unedited Transaction Table - Item Cost13SZTNACTransaction ActionStringUDC20
66F4141Z1F4141 Cycle Count Unedited Transaction Table13SZTNACTransaction ActionStringUDC20
TOP43: Procurement
67F4301Z1Purchase Order Header Unedited Transaction Table13SYTNACTransaction ActionStringUDC20
68F43092Z1Receipt Routing Unedited Transaction Table12SZTNACTransaction ActionStringUDC20
69F4311Z1Purchase Order Detail Unedited Transaction Table13SZTNACTransaction ActionStringUDC20
70F43121Z1Receipts Unedited Transaction Table13SZTNACTransaction ActionStringUDC20
TOP44H: Homebuilder Management
71F44H101ZHB Community Master Unedited Transaction File13SZTNACTransaction ActionStringUDC20
72F44H201ZHB Lot Master Unedited Transaction File13SZTNACTransaction ActionStringUDC20
73F44H501ZHB Sales Master Unedited Transaction File13SZTNACTransaction ActionStringUDC20
74F44H604ZHB Vendor Assignment Unedited Transaction File13SZTNACTransaction ActionStringUDC20
75F44H711ZHB Lot Start Unedited Transaction File13SZTNACTransaction ActionStringUDC20
TOP45: Advanced Pricing
76F4572Z1Live Promotions Interface - Inbound / Outbound6LPTNACTransaction ActionStringUDC20
77F4572ZPPurge Live Promotions Interface6PGTNACTransaction ActionStringUDC20
78F4576Z1Ship and Debit Claims Unedited Transaction Table13Z1TNACTransaction ActionStringUDC20
TOP46: Warehouse Management
79F4611Z1Unedited Suggestion Table13SZTNACTransaction ActionStringUDC20
80F4942Z1Work File for F494213SYTNACTransaction 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        00OriginalY
2        01CancellationY
3        02AddN
4        03DeleteN
5        04ChangeY
6        05ReplaceY
7        06ConfirmationY
8        07DuplicateN
9        08StatusN
10        10Not FoundN
11        11ResponseN
12        12Not ProcessedN
13        13RequestN
14        14Advance NotificationN
15        15Re-SubmissionN
16        16ProposedN
17        17Cancel to be ReissuedN
18        18ReissueN
19        19Seller Initiated ChangeN
20        20Final TransmissionN
21        21Transaction on HoldN
22        22Information CopyN
23        24DraftN
24        25IncrementalN
25        26Replace-Specified Buyer PartN
26        27VerifyN
27        28QueryN
28        30RenewalN
29        31Allowance/AdditionN
30        32Recovery/DeductionN
31        33Request for PaymentN
32        34Payment DeclinedN
33        35Request AuthorityN
34        36Authority to Deduct (Reply)N
35        37Authority Declined (Reply)N
36        38No Financial ValueN
37        41Corrected and VerifiedN
38        42Temporary RecordN
39        43Request Permission to ServiceN
40        44RejectionN
41        45FollowupN
42        46Cancellation with RefundN
43        47TransferN
44        48SuspendedN
45        49Original - No Response Necess.N
46        50RegistarN
47        51Historical InquiryN
48        52Response to Historical InquiryN
49        53CompletionN
50        54ApprovalN
51        5CChargeable ResubmissionN
52        77Simulation ExerciseN
53        A AddY
54        AIAdd Additional Item(s)Y
55        C ChangeY
56        CAChanges to Line ItemsN
57        CBChange of Date TermsN
58        CCChanges To TermsN
59        CEChg-Item Level Allowance/ChgN
60        CFCancel Prev Transmitted P.O.N
61        CGChg-Total Lev Allowance/ChargeN
62        CHChg Orig Confirm Corig AnnouncN
63        CIChg Confirm Revised AnnounceN
64        CNComplete NotificationN
65        COCorrectedN
66        CTChange of DatesN
67        D DeleteY
68        DIDelete Item(s)N
69        I InquiryY
70        MU(Mult) Un Price Qty Reshed ChgN
71        NCConcurrent Item (No Change)N
72        OAOrig Confirm Revised AnnounceN
73        OCOrig Confirm of Orig AnnounceN
74        PCPrice ChangeN
75        PQUnit Price/Quantity ChangeN
76        PRUnit Price/Reschedule ChangeN
77        QDQuantity DecreaseN
78        QIQuantity IncreaseN
79        R ReplaceY
80        RAReplace Mode of ShipmentN
81        RBReplace All DatesN
82        RCReject Item ChangeN
83        REReplacement ItemN
84        RHRelease HoldN
85        RMReplacement Item-ModificationsN
86        RQReschedule/Quantity ChangeN
87        RSRescheduleN
88        RZReplace All ValuesN
89        S Same as ExceptY
90        SUStatus UpdateN
91        TITransfer ItemN
92        UAUpdate - After ImageY
93        UBUpdate - Before ImageY
94        ZZMutual DefinedN