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.
These tables display the mappings to the Accounts Payable Ledger table, as well as the address selection hierarchy:
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 | . |
These tables describe the Accounts Payable tax explanation codes, ship to, ship from, and order acceptance.
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. |
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. |
This table describes the Customer Ledger tables, vertex fields, value passed, and comments.
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 | . |
This table describes the Accounts Receivable 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 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. |
This table describes the Billing Detail Workfile table, vertex field, values passed, and comments.
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 | . |
This table describes the Contract Billing and Service Billing 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 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. |
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. |
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. |
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. |
This table describes the Sales Order Detail File and Sales Order Header File tables, vertex field, value passed, and comments.
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 | . |
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. |
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 | . |
This table describes the Procurement Use Tax ship to, ship from, and order acceptance.
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. |