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

28 columns | Print definition?812 | TPUR | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP40R: Demand Scheduling
1F40R11Demand Detail50DDTPURTransaction Set PurposeStringUDC20
2F40R41Demand History55DITPURTransaction Set PurposeStringUDC20
3F47171EDI Demand Header17EHTPURTransaction Set PurposeStringUDC20
TOP43: Procurement
4F43121Z1Receipts Unedited Transaction Table14SZTPURTransaction Set PurposeStringUDC20
TOP43S: Supplier Self Service
5F43001Procurement Self-Service Transaction Log15SATPURTransaction Set PurposeStringUDC20
TOP45: Advanced Pricing
6F4576Z1Ship and Debit Claims Unedited Transaction Table103Z1TPURTransaction Set PurposeStringUDC20
TOP47: Electronic Commerce
7F47011EDI Purchase Order Header - Inbound18SYTPURTransaction Set PurposeStringUDC20
8F47016EDI Purchase Order Header - Outbound15SYTPURTransaction Set PurposeStringUDC20
9F47021EDI P.O. Acknowledgment Header - Inbound15SYTPURTransaction Set PurposeStringUDC20
10F47026EDI P.O. Acknowledgment Header - Outbound15SYTPURTransaction Set PurposeStringUDC20
11F47031EDI Shipping Notice Header - Inbound16SYTPURTransaction Set PurposeStringUDC20
12F47036EDI Shipping Notice Header - Outbound15SYTPURTransaction Set PurposeStringUDC20
13F47046EDI Invoice Header (Sales) - Outbound15SYTPURTransaction Set PurposeStringUDC20
14F47061EDI Planning Schedule Header - Inbound15MJTPURTransaction Set PurposeStringUDC20
15F47066EDI Planning Schedule Header - Outbound15MJTPURTransaction Set PurposeStringUDC20
16F47071EDI Receiving Advice Header - Inbound15SYTPURTransaction Set PurposeStringUDC20
17F47076EDI Receiving Advice Header - Outbound15SYTPURTransaction Set PurposeStringUDC20
18F47081EDI Price Sales Catalog Header - Inbound15FVTPURTransaction Set PurposeStringUDC20
19F47091EDI Request for Quote Header - Inbound16SYTPURTransaction Set PurposeStringUDC20
20F47096EDI Request for Quote Header - Outbound15SYTPURTransaction Set PurposeStringUDC20
21F47101EDI Response to RFQ Header - Inbound15SYTPURTransaction Set PurposeStringUDC20
22F47106EDI Response to RFQ Header - Outbound15SYTPURTransaction Set PurposeStringUDC20
23F47131EDI Purchase Order Change Header - Inbound15SYTPURTransaction Set PurposeStringUDC20
24F47136EDI Purchase Order Change Header - Outbound15SYTPURTransaction Set PurposeStringUDC20
25F47141EDI P.O. Change Acknowledgment Header - Inbound15SYTPURTransaction Set PurposeStringUDC20
26F47146EDI P.O. Change Acknowledgment Header - Outbound15SYTPURTransaction Set PurposeStringUDC20
27F47156EDI Shipping Schedule Header - Outbound15SYTPURTransaction Set PurposeStringUDC20
28F47191EDI Acknowledgement Header15AHTPURTransaction Set PurposeStringUDC20

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

TOPUDC 47 / PU (Transaction Set Purpose Code) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1        00OriginalN
2        01CancellationN
3        02AddN
4        03DeleteN
5        04ChangeN
6        05ReplaceN
7        06ConfirmationN
8        07DuplicateN
9        08StatusN
10        10Not FoundN
11        11ResponseN
12        12Not ProcessedN
13        13RequestN
14        14Advance Notification
15        15Re-Submission
16        16Proposed
17        17Cancel, to be Reissued
18        18Reissue
19        19Seller Initiated Change
20        20Final Transmission
21        21Transaction on Hold
22        22Information Copy
23        25Incremental
24        26Replace - Specified Buyer Part
25        27Verify
26        28Query
27        30Renewal
28        31Allowance/Addition
29        32Recovery/Deduction
30        33Request for Payment
31        34Payment Declined
32        35Request Authority
33        36Authority to Deduct (Reply)
34        37Authority Declined (Reply)
35        38No Financial Value
36        41Corrected and Verified
37        42Temporary Record
38        43Request Permission to Service
39        44Rejection
40        45Followup
41        46Cancellation with Refund
42        47Transfer
43        48Suspended
44        49Original - No Response Necess.
45        50Registar
46        ZZMutual DefinedN