Sales Order Detail File (F4211) and Sales Order Header File (F4201) tables

Vertex Field

JD Edwards EnterpriseOne Field or Value Passed

Comments

Invoice Date

SDIVD (F4211)

.When you run the Sales Update program (R42800), the process writes the invoice number to this field.

Line Item Extended Amt

SDAEXP (F4211)

.

Quantity

SDSOQS

For the JD Edwards EnterpriseOne Sales Order Management system, Vertex uses the actual quantity.

Line Item Number

000

.

Transaction Type

0

Vertex records 0 as SALE.

Transaction Code

0

.

Register File Indicator

1 or NULL

.

Ship-To Address

SDTXA1 (F4211)

In the F4211 table, GeoCode is associated with the Ship-To address book number of the customer.

Ship-From Address

Derived from SHMCU (F4201)

The GeoCode is associated with the address book number of the detail business unit according to the hierarchy in Address Selection Hierarchy.

Order-Acceptance Address

Derived from SOMCU (F4211)

The GeoCode is associated with the address book number of the detail business unit according to the hierarchy in Address Selection Hierarchy.

Company Code

SDKCO (F4211)

.

Division Code

F0101 value

The F0101 category code is associated with the business unit in the Quantum Constants.

Customer Code

SDSHAN (F4211)

.

Customer Class

F0101 value

The F0101 category code is associated with the SHAN field (Ship-To Address Number) specified in the Quantum constants.

Product Code

For stock items, the category code associated with product category 1D in the item/branch plant that is specified in the Quantum constants.

For non-stock items, the product code is taken from the F7307 table, based on the order type/line type combination.

.

Product Set Code

NULL

.

Component Code

NULL

.

Invoice Number

SDDOC (F4211)

.

Invoice Control Number

NULL

.

User Area

SDDCTO + SDDOCO (F4211)

.

Store Code

NULL

.