## Appendix: Mapping Fields from Vertex Sales Tax Q Series System to JD Edwards EnterpriseOne Software

Field maps display the fields used to pass data from JD Edwards EnterpriseOne software to the Sales Tax Q Series system that will be printed in the Vertex register. A one-to-one relationship exists between the JD Edwards EnterpriseOne fields that hold data and the fields in Sales Tax Q Series that receive the data.

The field maps also display the selection hierarchy for the JD Edwards EnterpriseOne Address Book fields to which JD Edwards EnterpriseOne passes GeoCodes. The hierarchy is dependent upon the tax explanation code and the address being used to determine tax rates.

This chapter discusses the maps for these systems:

- JD Edwards EnterpriseOne Accounts Payable

- JD Edwards EnterpriseOne Accounts Receivable

- JD Edwards EnterpriseOne Contract Billing and JD Edwards EnterpriseOne Service Billing

- JD Edwards EnterpriseOne Sales Order Management

- JD Edwards EnterpriseOne Procurement

### JD Edwards EnterpriseOne Accounts Payable

These tables display the mappings to the Accounts Payable Ledger table, as well as the address selection hierarchy:

Accounts Payable Ledger Table (F0411)

Vertex Field | JD Edwards EnterpriseOne Field or Value Passed | Comments
Invoice Date | RPDGJ (F0411) | The GL date of the voucher equals the date in the Invoice Date field of Vertex.
Line Item Extended Amt | RPATXA (F0411) | .
Quantity | 1.0000 | .
Line Item Number | RPSFX (F0411) | .
Transaction Type | 1 | Vertex records 1 as PURCH.
Transaction Code | 0 | .
Register File Indicator | 1 or NULL | .
Ship-To Address | RPTXA1 (F0411) | A GeoCode is assigned to the business unit on the voucher according to the hierarchy in Address Selection Hierarchy. Only one GeoCode is stored in the F0411 table. The address used is determined by rules developed by Vertex.
Ship-From Address | RPTXA1 (F0411) | A GeoCode is assigned to the supplier master record (F0401) of the address number on the voucher according to the hierarchy in Address Selection Hierarchy. Only one GeoCode is stored in the F0411 table. The address used is determined by rules developed by Vertex.
Order-Acceptance Address | RPTXA1 (F0411) | A GeoCode is assigned to the supplier master record (F0401) of the address number on the voucher according to the hierarchy in Address Selection Hierarchy. Only one GeoCode is stored in the F0411 table. The address used is determined by rules developed by Vertex.
Company Code | RPCO (F0411) | .
Division Code | NULL | .
Customer Code | RPAN8 (F0411) | The customer code in Vertex equals the supplier address book number in the JD Edwards EnterpriseOne Accounts Payable system.
Customer Class | NULL | .
Product Code | NULL | .
Product Set Code | NULL | .
Component Code | NULL | .
Invoice Number | RPDOC (F0411) | The document number (voucher number) equals the value in the Invoice Number field.
Invoice Control Number | NULL | .
User Area | PV + + RPDOC + + RPKCO | .
Store Code | NULL | .

#### Address Selection Hierarchy

These tables describe the Accounts Payable tax explanation codes, ship to, ship from, and order acceptance.

Accounts Payable, Tax Explanation Code U or E

Ship To | Ship From | Order Acceptance
1. Select if a GeoCode is assigned to the business unit on the Voucher. If no GeoCode is assigned to the business unit, then 2. Select if a GeoCode is assigned to the supplier master record (F0401) for the address number of the business unit on the voucher. If no address number is assigned to the business unit, or if no GeoCode is assigned to the supplier master record, then 3. Select if a GeoCode is assigned to the supplier master record for the address number of the company of the business unit on the voucher. 4. If no address number is assigned to the company, or if no GeoCode is assigned to the supplier master record, then set an error. | 1. Select if a GeoCode is assigned to the supplier master record of the address number on the voucher. 2. If no GeoCode is assigned to the supplier master record, then set an error. | Same as Ship From hierarchy.

Accounts Payable, Tax Explanation Codes

Ship To | Ship From | Order Acceptance
1. Select if a GeoCode is assigned to the business unit on the voucher. If no GeoCode is assigned to the business unit, then 2. Select if a GeoCode is assigned to the supplier master record (F0401) for the address number of the business unit on the voucher. If no address number is assigned to the business unit, or if no GeoCode is assigned to the supplier master record, then 3. Select if a GeoCode is assigned to the supplier master record for the address number of the company of the business unit on the voucher. 4. If no address number is assigned to the company, or if no GeoCode is assigned to the supplier master record, then set an error. | 1. Select if a GeoCode is assigned to the supplier master record of the address number on the voucher. 2. If no GeoCode is assigned to the supplier master record, then set an error. | Same as Ship To hierarchy.

### JD Edwards EnterpriseOne Accounts Receivable

This table describes the Customer Ledger tables, vertex fields, value passed, and comments.

Customer Ledger Table (F03B11)

Vertex Field | JD Edwards EnterpriseOne Field or Value Passed | Comments
Invoice Date | RPDSVJ (F03B11) | .
Line Item Extended Amt | RPATXA (F03B11) | .
Quantity | 1.0000 | .
Line Item Number | RPSFX (F03B11) | .
Transaction Type | 0 | Vertex records 0 as SALE.
Transaction Code | 0 | .
Register File Indicator | 1 or NULL | .
Ship-To Address | RPTXA1 (F03B11) | In the F03B11 table, the Ship-To Address is the GeoCode assigned to the customer master record of the address number on the invoice. Only one GeoCode is stored in the F03B11 table. The address used is determined by rules developed by Vertex.
Ship-from Address | RPTXA1 (F03B11) | In the F03B11 table, the Ship-From Address is the GeoCode assigned to the business unit on the invoice according the hierarchy Address Selection Hierarchy. Only one GeoCode is stored in the F03B11 table. The address used is determined by rules developed by Vertex.
Order-Acceptance Address | RPTXA1 (F03B11) | In the F03B11 table, the Order-Acceptance Address is the GeoCode assigned to the business unit on the invoice, according to the hierarchy in Address Selection Hierarchy. Only one GeoCode is stored in the F03B11 table. Vertex chooses which address to use according to rules developed by Vertex.
Company Code | RPCO (F03B11) | .
Division Code | NULL | .
Customer Code | RPAN8 (F03B11) | .
Customer Class | NULL | .
Product Code | NULL | .
Product Set Code | NULL | .
Component Code | NULL | .
Invoice Number | RPDOC (F03B11) | .
Invoice Control Number | NULL | .
User Area | RI + + RPDOC + + RPKCO | .
Store Code | NULL | .

#### Address Selection Hierarchy

This table describes the Accounts Receivable sales tax, ship to, ship from and order acceptance.

Accounts Receivable - Sales Tax

Ship To | Ship From | Order Acceptance
1. Select if a GeoCode is assigned to the customer master record of the address number on the invoice. 2. If no GeoCode is assigned to the customer master record, then set an error. | 1. Select if a GeoCode is assigned to the business unit on the invoice. If no GeoCode is assigned to the business unit, then 2. Select if a GeoCode is assigned to the customer master record for the address number of the business unit on the Invoice. If no address number is assigned to the business unit or if no GeoCode is assigned to the customer master record, then 3. Select if a GeoCode is assigned to the customer master record for the address number of the company of the business unit on the invoice. 4. If no address number is assigned to the company or if no GeoCode is assigned to the customer master record, then set an error. | Same as Ship From hierarchy.

### JD Edwards EnterpriseOne Contract Billing and JD Edwards EnterpriseOne Service Billing and JD Edwards EnterpriseOne Service Management

This table describes the Billing Detail Workfile table, vertex field, values passed, and comments.

Billing Detail Workfile Table (F4812)

Vertex Field | JD Edwards EnterpriseOne Field or Value Passed | Comments
Invoice Date | WDDSVJ (F4812) | .
Line Item Extended Amt | WDITXA (F4812) | .
Quantity | 1.0000 | .
Line Item Number | WDSFX (F4812) | .
Transaction Type | WDVVTY (F4812) | JD Edwards EnterpriseOne Service Billing: If no value is entered in the Tax Derivation Table program (P48127), the value SERVIC is supplied by default. JD Edwards EnterpriseOne Contract Billing: If no value is entered in the Contract Billing Line Details program (P5202), the SERVIC is supplied by default. JD Edwards EnterpriseOne Service Management: The system populates this field based on transactions entered in the JD Edwards EnterpriseOne Service Management system.
Transaction Code | 0 | .
Register File Indicator | 1 | .
Ship-To Address | WDTXA1 (F4812) | A GeoCode is selected according to the appropriate hierarchy in Address Selection Hierarchy. The address used is determined by rules developed by Vertex. JD Edwards EnterpriseOne Service Billing and JD Edwards EnterpriseOne Contract Billing pass all three address numbers.
Ship-From Address | WDTXGCSF (F4812) | A GeoCode is selected according to the appropriate hierarchy in Address Selection Hierarchy. The address used is determined by rules developed by Vertex. JD Edwards EnterpriseOne Service Billing and JD Edwards EnterpriseOne Contract Billing pass all three address numbers.
Order-Acceptance Address | WDGCOA (F4812) | A GeoCode is selected according to the appropriate hierarchy in Address Selection Hierarchy. The address used is determined by rules developed by Vertex. JD Edwards EnterpriseOne Service Billing and JD Edwards EnterpriseOne Contract Billing pass all three address numbers.
Company Code | WDCO (F4812) | .
Division Code | NULL | .
Customer Code | WDAN8O (F4812) | .
Product Code | WDVVTC (F4812) | JD Edwards EnterpriseOne Service Billing: If no value is entered in the Tax Derivation Table program (P48127), blank is supplied by default. JD Edwards EnterpriseOne Contract Billing: If no value is entered in the Contract Billing Line Details program (P5202), blank is supplied by default. JD Edwards EnterpriseOne Service Management: The system populates this field based on transactions entered in the JD Edwards EnterpriseOne Service Management system.
Product Set Code | NULL | .
Component Code | NULL | .
Invoice Number | WDDOCZ (F4812) | .
Invoice Control Number | NULL | .
User Area | NULL | .
Store Code | NULL | .

#### Address Selection Hierarchy

This table describes the Contract Billing and Service Billing Sales Tax, ship to, ship from, and order acceptance.

JD Edwards EnterpriseOne Contract Billing and JD Edwards EnterpriseOne Service Billing - Sales Tax

Ship To | Ship From | Order Acceptance
1. Select if a GeoCode is assigned to the customer master record of the address number on the invoice. 2. If no GeoCode is assigned to the customer master record, then set an error. | 1. Select if a GeoCode is assigned to the business unit on the Invoice. If no GeoCode is assigned to the business unit, then 2. Select if a GeoCode is assigned to the customer master record for the address number of the business unit on the invoice. If no address number is assigned to the business unit or if no GeoCode is assigned to the customer master record, then 3. Select if a GeoCode is assigned to the customer master record for the address number of the company of the business unit on the invoice. 4. If no address number is assigned to the company, or if no GeoCode is assigned to the customer master record, then set an error. | Same as Ship From hierarchy.

JD Edwards EnterpriseOne Service Management System - Contract Sales Tax

This table describes the JD Edwards EnterpriseOne Service Management System Contract Sales Tax, ship to, ship from, and order acceptance.

Ship To | Ship From | Order Acceptance
1. Select if a GeoCode is assigned to the customer master record of the site address number on the Contract Detail line. 2. If no GeoCode is assigned to the customer master record, then set an error. | 1. Select if a GeoCode is assigned to the business unit on the Contract Detail line. If no GeoCode is assigned to the business unit, then 2. Select if a GeoCode is assigned to the supplier master record for the address number of the business unit on the Contract Detail line. If no address number is assigned to the business unit, or if no GeoCode is assigned to the supplier master record, then set an error. | 1. Select if a GeoCode is assigned to the business unit on the contract header. If no GeoCode is assigned to the business unit, then 2. Select if a GeoCode is assigned to the supplier master record for the address number of the business unit on the contract header. If no address number is assigned to the business unit, or if no GeoCode is assigned to the supplier master record, then set an error.

JD Edwards EnterpriseOne Service Management System - Service Order Sales Tax

This table describes the JD Edwards EnterpriseOne Service Management System Service Order Sales Tax, ship to, ship from, and order acceptance.

Ship To | Ship From | Order Acceptance
1. Select if a GeoCode is assigned to the customer master record of the site address number on the service order. 2. If no GeoCode is assigned to the customer master record, then set an error. | 1. Select if a GeoCode is assigned to the responsible business unit on the service order. If no GeoCode is assigned to the responsible business unit, then 2. Select if a GeoCode is assigned to the supplier master record for the address number of the responsible business unit on the service order. If no address number is assigned to the responsible business unit, or if no GeoCode is assigned to the supplier master record, then set an error. | Same as Ship From hierarchy.

JD Edwards EnterpriseOne Service Management System - Service Order Use Tax

This table describes the JD Edwards EnterpriseOne Service Management System Service Order Use Tax, ship to, ship from, and order acceptance.

Ship To | Ship From | Order Acceptance
1. Select if a GeoCode is assigned to the responsible business unit on the service order. If no GeoCode is assigned to the responsible business unit, then 2. Select if a GeoCode is assigned to the supplier master record for the address number of the responsible business unit on the service order. If no address number is assigned to the responsible business unit, or if no GeoCode is assigned to the supplier master record, then set an error. | 1. Select if a GeoCode is assigned to the supplier master record of the site address number on the service order. 2. If no GeoCode is assigned to the supplier master record, then set an error. | Same as Ship To hierarchy.

### JD Edwards EnterpriseOne Sales Order Management

This table describes the Sales Order Detail File and Sales Order Header File tables, vertex field, value passed, and comments.

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

Vertex Field | JD Edwards EnterpriseOne Field or Value Passed | Comments
Invoice Date | SDTRDJ (F4211) | .
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 branch plant 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 branch plant according to the hierarchy in Address Selection Hierarchy.
Company Code | SDKCO (F4211) | .
Division Code | F0101 value | The F0101 category code is associated with the branch/plant 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 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 | SDDOCO (F4211) | .
Invoice Control Number | NULL | .
User Area | SDDCTO + + SDDOCO + SDKCO (F4211) | .
Store Code | NULL | .

#### Address Selection Hierarchy

This table describes the Address Selection Hierarchy ship to, ship from, and order acceptance.

Ship To | Ship From | Order Acceptance
1. Select if a GeoCode is assigned to the customer master record for the address number on the Order Detail Line. 2. If no GeoCode is assigned to the customer master record, then set an error. | 1. Select if a GeoCode is assigned to the branch/plant on the Order Detail Line. If no GeoCode is assigned to the branch/plant, then 2. Select if a GeoCode is assigned to the customer master record for the address number of the branch/plant on the Order Detail Line. If no address number is assigned to the branch/plant, or if no GeoCode is assigned to the customer master record, then 3. Select if a GeoCode is assigned to the customer master record for the address number of the company of the branch/plant on the Order Detail Line. 4. If no address number is assigned to the company, or if no GeoCode is assigned to the customer master record, then set an error. | 1. Select if a GeoCode is assigned to the branch/plant on the order header. If no GeoCode is assigned to the business unit, then 2. Select if a GeoCode is assigned to the customer master record for the address number of the branch/plant on the order header. If no address number is assigned to the branch/plant, or if no GeoCode is assigned to the customer master record, then 3. Select if a GeoCode is assigned to the customer master record for the address number of the company of the branch/plant on the order header. 4. If no address number is assigned to the company, or if no GeoCode is assigned to the customer master record, then set an error.

### JD Edwards EnterpriseOne Procurement

These tables describe the vertex field, value passed, and comments for these JD Edwards EnterpriseOne Procurement and JD Edwards EnterpriseOne Address Book tables:

- F43121

- F4301

- F4311

- F0101

Vertex Field | JD Edwards EnterpriseOne Field or Value Passed | Comments
Invoice Date | PRDGL (F43121) | .
Quantity | PRUREC (F43121) | This value equals the amount of goods received.
Line Item Number | PRSFX (F43121) | .
Transaction Type | 1 | If the Tax Explanation Code equals U, Vertex records 1 as PURCH. If the Tax Explanation Code equals S, Vertex records 0 as SALES.
Transaction Code | 0 | .
Register File Indicator | 1 | .
Ship-to Address | Derived from PHMCU (F4301) | GeoCode is assigned to the branch/plant on the Order Detail Line according to the hierarchy in Address Selection Hierarchy.
Ship-from Address | PRTXA1 (F43121) | In the F43121 table, the GeoCode is assigned to the supplier master record for the address number on the Order Detail Line according to the hierarchy in Address Selection Hierarchy.
Order-acceptance Address | Derived from PDMCU (F4311) | GeoCode is assigned to the branch/plant on the order header according to the hierarchy in Address Selection Hierarchy.
Company Code | PRKCOO (F43121) | .
Division Code | From the F0101 table | This value is associated with the header branch/plant address as defined in the Quantum Constants.
Customer Code | PRAN8 (F43121) | .
Customer Class | From the F0101 table | The customer class is the category code in the F0101 table associated with the supplier address number as defined 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 document type/line type combination. | .
Product Set Code | NULL | .
Component Code | NULL | .
Invoice Number | PRDOC (F43121) | This field is updated with the voucher number assigned to the purchase order during voucher match (P4314).
Invoice Control Number | NULL | .
User Area | PRDCTO + + PRDOC + + PRKCOO | .
Store Code | NULL | .

#### Address Selection Hierarchy

This table describes the Procurement Use Tax ship to, ship from, and order acceptance.

JD Edwards EnterpriseOne Procurement - Use Tax

Ship To | Ship From | Order Acceptance
1. Select if a GeoCode is assigned to the branch/plant on the Order Detail Line. If no GeoCode is assigned to the business unit, then 2. Select if a GeoCode is assigned to the supplier master record for the address number of the branch/plant on the Order Detail Line. If no address number is assigned to the branch/plant, or if no GeoCode is assigned to the supplier master record, then 3. Select if a GeoCode is assigned to the supplier master record for the address number of the company of the branch/plant on the Order Detail Line. 4. If no address number is assigned to the company, or if no GeoCode is assigned to the supplier master record, then set an error. | 1. Select if a GeoCode is assigned to the supplier master record for the address number on the Order Detail Line. 2. If no GeoCode is assigned to the supplier master record, then set an error. | 3. Select if a GeoCode is assigned to the branch/plant on the order header. If no GeoCode is assigned to the business unit, then 4. Select if a GeoCode is assigned to the supplier master record for the address number of the branch/plant on the order header. If no address number is assigned to branch/plant, or if no GeoCode is assigned to the supplier master record, then 5. Select if a GeoCode is assigned to the supplier master record for the address number of the company of the branch/plant on the order header. 6. If no address number is assigned to the company, or if no GeoCode is assigned to the supplier master record, then set an error.