# JD Edwards F4211 and F42119 Tables: Sales Order Detail and History Columns > Source: https://netray.co/tools/jde-f4211-f42119-sales-order-detail-history-columns-reference > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Column-by-column reference for the JDE 9.2 sales order family: F4201 header, F4211 detail, F42119 and F42019 history and the F42199 detail ledger, with keys, data types and storage notes. ## Category oracle ## Erp JD Edwards EnterpriseOne ## Audience - JDE developer - CNC administrator - Report writer - Sales order functional consultant ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### Table **Key:** table **Type:** text #### Column **Key:** column **Type:** text #### Alias **Key:** alias **Type:** text #### Description **Key:** description **Type:** text #### Key part **Key:** key **Type:** text #### Data type **Key:** dtype **Type:** text #### Notes **Key:** notes **Type:** text **Rows:** **Table:** F4211 **Column:** SDKCOO **Alias:** KCOO **Description:** Order Company (Order Number) **Key:** Y **Dtype:** String **Notes:** Part of the primary key (KCOO, DOCO, DCTO, LNID). Always include it in joins, order numbers can repeat across order companies. **Table:** F4211 **Column:** SDDOCO **Alias:** DOCO **Description:** Document (Order No, Invoice etc.) **Key:** Y **Dtype:** Numeric **Notes:** The sales order number. Part of the primary key. **Table:** F4211 **Column:** SDDCTO **Alias:** DCTO **Description:** Order Type **Key:** Y **Dtype:** String **Notes:** UDC 00/DT, e.g. SO. Part of the primary key. **Table:** F4211 **Column:** SDLNID **Alias:** LNID **Description:** Line Number **Key:** Y **Dtype:** Math numeric, 3 implied decimals **Notes:** Stored x1000: line 1.000 is stored as 1000, line 2.500 as 2500. Divide by 1000 for display. **Table:** F4211 **Column:** SDSFXO **Alias:** SFXO **Description:** Order Suffix **Dtype:** String **Notes:** Not part of the primary key in 9.2. **Table:** F4211 **Column:** SDMCU **Alias:** MCU **Description:** Business Unit (detail branch/plant) **Dtype:** String **Notes:** Business unit values are right justified with leading spaces (12 chars). Use LTRIM or pad when filtering. **Table:** F4211 **Column:** SDEMCU **Alias:** EMCU **Description:** Business Unit - Header **Dtype:** String **Notes:** Header business unit copied to each line. **Table:** F4211 **Column:** SDCO **Alias:** CO **Description:** Company **Dtype:** String **Notes:** Company of the selling branch, drives AAI and currency lookups. **Table:** F4211 **Column:** SDAN8 **Alias:** AN8 **Description:** Address Number (sold to) **Dtype:** Numeric **Notes:** Join to F0101.ABAN8 and F03012.AIAN8. **Table:** F4211 **Column:** SDSHAN **Alias:** SHAN **Description:** Address Number - Ship To **Dtype:** Numeric **Notes:** Join to F0101.ABAN8 for the ship-to name. **Table:** F4211 **Column:** SDITM **Alias:** ITM **Description:** Item Number - Short **Dtype:** Numeric **Notes:** Internal short item number. Join to F4101.IMITM and F4102.IBITM on ITM, not on LITM. **Table:** F4211 **Column:** SDLITM **Alias:** LITM **Description:** 2nd Item Number **Dtype:** String **Notes:** The item number users normally see and type. Text, may change if the item is renumbered. **Table:** F4211 **Column:** SDAITM **Alias:** AITM **Description:** 3rd Item Number **Dtype:** String **Notes:** Third item identifier, often a catalogue or drawing number. **Table:** F4211 **Column:** SDLOCN **Alias:** LOCN **Description:** Location **Dtype:** String **Notes:** Storage location the line is committed or shipped from. Blank on lines not yet assigned. **Table:** F4211 **Column:** SDLOTN **Alias:** LOTN **Description:** Lot/Serial Number **Dtype:** String **Notes:** Join with ITM, MCU and LOCN to F41021 for on hand. **Table:** F4211 **Column:** SDLNTY **Alias:** LNTY **Description:** Line Type **Dtype:** String **Notes:** Line type from F40205 (e.g. S stock). Activity rules in F40203 are keyed by DCTO plus LNTY. **Table:** F4211 **Column:** SDNXTR **Alias:** NXTR **Description:** Status Code - Next **Dtype:** String **Notes:** Next step from the order activity rules (UDC 40/AT). 999 means closed. **Table:** F4211 **Column:** SDLTTR **Alias:** LTTR **Description:** Status Code - Last **Dtype:** String **Notes:** Last completed step. Use LTTR plus NXTR to see where a line is stuck. **Table:** F4211 **Column:** SDUOM **Alias:** UOM **Description:** Unit of Measure as Input **Dtype:** String **Notes:** Quantities are in this UOM. Convert with F41002 when summing across UOMs. **Table:** F4211 **Column:** SDUORG **Alias:** UORG **Description:** Units - Order/Transaction Quantity **Dtype:** Math numeric, implied decimals **Notes:** Ordered quantity. Implied decimals follow the data dictionary display decimals for UORG at your site. **Table:** F4211 **Column:** SDSOQS **Alias:** SOQS **Description:** Quantity Shipped **Dtype:** Math numeric, implied decimals **Notes:** Set at ship confirmation. **Table:** F4211 **Column:** SDSOBK **Alias:** SOBK **Description:** Units - Qty Backordered/Held **Dtype:** Math numeric, implied decimals **Notes:** Backordered or held quantity on the line. **Table:** F4211 **Column:** SDSOCN **Alias:** SOCN **Description:** Units - Quantity Canceled/Scrapped **Dtype:** Math numeric, implied decimals **Notes:** Canceled quantity. **Table:** F4211 **Column:** SDUPRC **Alias:** UPRC **Description:** Amount - Price per Unit **Dtype:** Math numeric, 4 decimals in the table definition **Notes:** Domestic unit price. Stored without the decimal point. **Table:** F4211 **Column:** SDAEXP **Alias:** AEXP **Description:** Amount - Extended Price **Dtype:** Math numeric, 2 decimals in the table definition **Notes:** Domestic extended price. Currency amounts follow the currency decimals of the record when multi-currency is on (check P0013 for 0 or 3 decimal currencies). **Table:** F4211 **Column:** SDUNCS **Alias:** UNCS **Description:** Amount - Unit Cost **Dtype:** Math numeric, 4 decimals in the table definition **Notes:** Unit cost from F4105 at entry, updated at ship confirm or sales update. **Table:** F4211 **Column:** SDECST **Alias:** ECST **Description:** Amount - Extended Cost **Dtype:** Math numeric, 2 decimals in the table definition **Notes:** Use with AEXP for line margin. **Table:** F4211 **Column:** SDCRCD **Alias:** CRCD **Description:** Currency Code - From **Dtype:** String **Notes:** Transaction currency. Decides the decimals of the foreign amounts. **Table:** F4211 **Column:** SDFUP **Alias:** FUP **Description:** Amount - Foreign Price per Unit **Dtype:** Math numeric, implied decimals **Notes:** Foreign unit price, populated when the order is entered in a foreign currency. **Table:** F4211 **Column:** SDFEA **Alias:** FEA **Description:** Amount - Foreign Extended Price **Dtype:** Math numeric, implied decimals **Notes:** Foreign extended price. Sum FEA, not AEXP, when reporting in transaction currency. **Table:** F4211 **Column:** SDTRDJ **Alias:** TRDJ **Description:** Date - Order/Transaction **Dtype:** Julian date **Notes:** CYYDDD: 126295 is 22 Oct 2026 (C=1 for 2000s, YY=26, DDD=295). 0 means blank. **Table:** F4211 **Column:** SDDRQJ **Alias:** DRQJ **Description:** Date - Requested **Dtype:** Julian date **Notes:** Customer requested date, CYYDDD. **Table:** F4211 **Column:** SDPDDJ **Alias:** PDDJ **Description:** Date - Scheduled Pick **Dtype:** Julian date **Notes:** Scheduled pick date, CYYDDD. **Table:** F4211 **Column:** SDPPDJ **Alias:** PPDJ **Description:** Date - Promised Shipment **Dtype:** Julian date **Notes:** Promised ship date, CYYDDD. **Table:** F4211 **Column:** SDRSDJ **Alias:** RSDJ **Description:** Date - Promised Delivery **Dtype:** Julian date **Notes:** Promised delivery date, CYYDDD. **Table:** F4211 **Column:** SDADDJ **Alias:** ADDJ **Description:** Date - Actual Ship Date **Dtype:** Julian date **Notes:** Set at ship confirmation. **Table:** F4211 **Column:** SDIVD **Alias:** IVD **Description:** Date - Invoice **Dtype:** Julian date **Notes:** Set when the invoice is printed. **Table:** F4211 **Column:** SDDOC **Alias:** DOC **Description:** Document (Voucher, Invoice etc.) **Dtype:** Numeric **Notes:** Invoice number. With SDDCT and SDKCO it joins to F03B11 (RPDOC, RPDCT, RPKCO). **Table:** F4211 **Column:** SDDCT **Alias:** DCT **Description:** Document Type **Dtype:** String **Notes:** Invoice document type, commonly RI for sales invoices. **Table:** F4211 **Column:** SDKCO **Alias:** KCO **Description:** Document Company **Dtype:** String **Notes:** Company of the invoice document, not the order company. **Table:** F4211 **Column:** SDVR01 **Alias:** VR01 **Description:** Reference **Dtype:** String **Notes:** Often holds the customer PO number. **Table:** F4211 **Column:** SDUSER / SDPID / SDUPMJ / SDTDAY **Alias:** USER, PID, UPMJ, TDAY **Description:** User ID, Program ID, Date - Updated, Time of Day **Dtype:** String, String, Julian date, Numeric (HHMMSS) **Notes:** Audit stamp of the last change. TDAY is stored as HHMMSS without separators. **Table:** F4201 **Column:** SHDOCO / SHDCTO / SHKCOO **Alias:** DOCO, DCTO, KCOO **Description:** Order number, order type, order company **Key:** Y **Dtype:** Numeric, String, String **Notes:** Header key. Join F4211 on SDDOCO=SHDOCO, SDDCTO=SHDCTO, SDKCOO=SHKCOO. **Table:** F4201 **Column:** SHAN8 / SHSHAN **Alias:** AN8, SHAN **Description:** Sold to and ship to address numbers **Dtype:** Numeric **Notes:** Header defaults; lines can override the ship to. **Table:** F4201 **Column:** SHTRDJ **Alias:** TRDJ **Description:** Date - Order/Transaction **Dtype:** Julian date **Notes:** Order date, CYYDDD. **Table:** F4201 **Column:** SHOTOT **Alias:** OTOT **Description:** Amount - Order Gross **Dtype:** Math numeric, implied decimals **Notes:** Header gross amount. Recompute from F4211 lines when lines have been canceled or moved. **Table:** F4201 **Column:** SHHOLD **Alias:** HOLD **Description:** Hold Orders Code **Dtype:** String **Notes:** Non-blank means the order is on hold (credit, margin etc.). **Table:** F42119 **Column:** SD* (same column list) **Alias:** Same as F4211 **Description:** Sales Order History File **Key:** Y (DOCO, DCTO, KCOO, LNID) **Dtype:** Same as F4211 **Notes:** Identical layout and SD prefix to F4211. Lines arrive here when Sales Update (R42800) or Purge Detail to History (R42996) moves closed lines. **Table:** F42019 **Column:** SH* columns **Alias:** Same as F4201 **Description:** Sales Order Header History File **Key:** Y **Dtype:** Same as F4201 **Notes:** Header moves here only when no open detail lines remain in F4211 for that order number and type. **Table:** F42199 **Column:** SL* (same column list) **Alias:** Same aliases as F4211 **Description:** S.O. Detail Ledger File **Key:** Y (DOCO, DCTO, KCOO, LNID, UPMJ, TDAY) **Dtype:** Same as F4211 **Notes:** Same columns as F4211 with SL prefix (SLDOCO, SLNXTR...). One row per ledger write, written at the statuses where Write Ledger (FSWRTH) is Y in F40203. The key adds UPMJ and TDAY so each write is kept. **Notes:** Built from the JD Edwards EnterpriseOne 9.2 table definitions. For full order history, UNION ALL F4211 and F42119 (same column list) and dedupe on KCOO, DOCO, DCTO, LNID, because a line lives in only one of the two tables at a time. Divide LNID by 1000, convert Julian CYYDDD dates, and apply implied decimals before showing amounts. ## Content **Intro:** This reference lists the columns you actually use in the JD Edwards EnterpriseOne 9.2 sales order tables: F4201 header, F4211 detail, F42119 and F42019 history and the F42199 detail ledger. Search by alias, column name or description and export the list to Excel for your report or interface spec. **Sections:** #### Where this lives in JD Edwards **Body:** Sales Order Entry (P4210) writes the header to F4201 and the lines to F4211. Lines stay in F4211 through pick, ship confirm and invoice. Sales Update (R42800) posts sales and, depending on its processing options, copies closed lines from F4211 to F42119 and deletes them from F4211. A separate option does the same for headers into F42019, but only when no open lines remain for that order number and type. Purge Detail to History (R42996) can move status 999 lines on its own. F42199 is written whenever a line passes a status whose activity rule has Write Ledger set to Y. **Bullets:** - F4211 and F42119 share the same column list and the SD prefix - F42199 uses the SL prefix with the same columns - Primary key is DOCO, DCTO, KCOO, LNID in F4211 and F42119 #### Storage conventions that break reports **Body:** Three conventions cause most wrong numbers. First, math numeric columns are stored without the decimal point: SDLNID uses three implied decimals, so line 1.000 is 1000, and amounts follow the decimals in the table definition or the record's currency. Second, dates are Julian CYYDDD, where C is the century offset from 1900, YY the year and DDD the day of year, so 126001 is 1 January 2026 and 0 means no date. Third, SDITM is the internal short item number; SDLITM and SDAITM are the 2nd and 3rd item numbers people see. Join to F4101 and F4102 on ITM. #### Worked example: one order across tables **Body:** Order 104512 SO in order company 00200 has three lines. Line 1.000 (SDLNID 1000) shipped and invoiced and was moved by R42800, so it is now in F42119 with SDNXTR 999. Line 2.000 is backordered at status 904 and is still in F4211. The header stays in F4201 because line 2.000 is open. A query against F4211 alone shows one line and understates the order. Union F4211 and F42119 on the same column list, filter SDKCOO = '00200', SDDOCO = 104512, SDDCTO = 'SO', and you get the full picture. F42199 shows each status change of each line, keyed by update date and time. #### Version differences and gotchas **Body:** Column counts grow with Applications updates, so check your own table definition in OMW or the data dictionary before hard-coding SELECT lists. SDMCU is right justified in a 12 character field, so WHERE SDMCU = 'M30' returns nothing; compare against the padded value or trim. If the R42800 version is set not to move lines to history, closed lines stay in F4211 and F42119 may be empty. Ledger rows in F42199 only exist for statuses with Write Ledger set, so do not use it as a complete audit trail unless you have checked F40203. **Cta:** If you want planners and customer service to ask JD Edwards order questions in plain English, with the query shown and run on your own servers, we can set that up over F4211 and F42119. **Faq:** #### What is the difference between F4211 and F42119 in JDE? **Answer:** F4211 holds open and recently closed sales order lines. F42119 is the history table with exactly the same columns and SD prefix. Sales Update (R42800) or Purge Detail to History (R42996) copies closed lines into F42119 and deletes them from F4211, so a line is in one table or the other, never both. #### What are the key fields of F4211? **Answer:** The primary unique index is SDDOCO (order number), SDDCTO (order type), SDKCOO (order company) and SDLNID (line number). The order suffix SDSFXO is not part of the primary key. Always join on all four columns, because the same order number can exist in different order companies or order types. #### Why does SDLNID show 1000 instead of 1? **Answer:** LNID is a math numeric data item with three display decimals, and JD Edwards stores numbers without the decimal point. Line 1.000 is stored as 1000 and line 1.500 as 1500. Divide by 1000 in SQL or reports, and do the same for other implied decimal fields according to their data dictionary decimals. #### What is F42199 used for? **Answer:** F42199 is the S.O. Detail Ledger File. It has the same columns as F4211 with an SL prefix and stores a copy of a line each time it passes a status where the order activity rule has Write Ledger set to Y. Its key adds update date and time, so you can see how a line changed over time. ## Search terms f4211 and f42119 jde tables, jde f42119 table, jde field names in f42119, table jde f42119, jde schema f4211, jde f4201 table, jde sales order detail table columns, jde f42199 sales order ledger --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json