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:

Click to jump to parent topicJD 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

.

Click to jump to top of pageClick to jump to parent topicAddress 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.

Click to jump to parent topicJD 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

.

Click to jump to top of pageClick to jump to parent topicAddress 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.

Click to jump to parent topicJD 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

.

Click to jump to top of pageClick to jump to parent topicAddress 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.

Click to jump to parent topicJD 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

.

Click to jump to top of pageClick to jump to parent topicAddress 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.

Click to jump to parent topicJD 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:

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

.

Click to jump to top of pageClick to jump to parent topicAddress 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.