A Mapping Fields from Vertex Sales Tax Q Series System to JD Edwards EnterpriseOne Software

This appendix contains the following topics:

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.

A.1 JD Edwards EnterpriseOne Accounts Payable

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

A.1.1 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 .

A.1.2 Address Selection Hierarchy

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

A.1.2.1 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 business unit on the voucher.

4. 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 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.

A.1.2.2 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 business unit on the voucher.

4. 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 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.

A.2 JD Edwards EnterpriseOne Accounts Receivable

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

A.2.1 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 .

A.2.2 Address Selection Hierarchy

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

A.2.2.1 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 business unit on the invoice.

4. If no address number is assigned to the business unit or if no GeoCode is assigned to the customer master record, then set an error.

 Same as Ship From hierarchy.

A.3 JD Edwards EnterpriseOne Contract Billing, Service Billing and Service Management Systems

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

A.3.1 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 .

A.3.2 Address Selection Hierarchy

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

A.3.2.1 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 business unit on the invoice.

4. If no address number is assigned to the business unit, or if no GeoCode is assigned to the customer master record, then set an error.

 Same as Ship From hierarchy.

A.3.2.2 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.

A.3.2.3 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.

A.3.2.4 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.

A.4 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.

A.4.1 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 .

A.4.2 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 business unit on the Order Detail Line. 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 Order Detail Line. 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 business unit on the Order Detail Line.

4. If no address number is assigned to the business unit, or 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 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 business unit on the order header. 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 business unit on the order header.

4. If no address number is assigned to the business unit, or if no GeoCode is assigned to the customer master record, then set an error.

A.5 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 business unit 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 business unit 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 business unit 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 .

A.5.1 Address Selection Hierarchy

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

A.5.1.1 JD Edwards EnterpriseOne Procurement - Use Tax

Ship To Ship From Order Acceptance
1. Select if a GeoCode is assigned to the business unit 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 business unit on the Order Detail Line. 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 business unit 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 business unit 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 business unit on the order header. If no address number is assigned to business unit, 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 business unit on the order header.

6. 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.