JDE table names explained:
F4211 – Sales Order Detail records
F – F is for file, it’s the old school way of saying a table.
42 – is the JDE system code, in this case it means sales.
11 – Generall 11 means detail records, 01 usually means header records – so it’s safe to say the JDE Sales Order Header table is F4201
Here’s a short list of tables I use regularly:
F4211 – Sales order detail records,
F4201 – Sales order header records.
F42119 – Sales order detail archive records (usually after the end of day ube has run and archived the detail records from the F4211).
F4301 – Purchase Order Header records.
F4311 – Purchase Order Detail records.
F43121 – This table is the log of all the receipts against a purchase order.
F0101 – Address book
F4111 – Inventory ledger
F4101 – Item Master
F0911 – General Ledger
Those are the key ones, I’m sure there are more, and if you’ve got any you think should be added, give me a comment and I’ll consider it.