Attachment 8 - MOVERS Interface Draft.pdf

Attachment 8

MOVERS INTERFACE LAYOUT

Invoices Field Definition - ApInvoicesInterface

Field Name Description DataType Length Usage

Invoice ID the same value to the invoice's lines in the ApInvoiceLineInterface sheet to identify the data as belonging to the same invoice. Number 15 Required

Business Unit Business Unit Name Varchar2 240 Required

Source Identification of the source system providing the invoice data. Varchar2 80 Required

Invoice Number

Supplier Invoice Number which is the unique number (per supplier) that is printed on the supplier invoice the user receives. Varchar2 50 Required

Invoice Amount

Invoice amount that matches the sum of all related invoice lines related to the header. Is a postive value for standard and prepayment invoices but is negative for credit memos.

Enter amount without thousand separator and use "." (dot) as decimal separator Number Required

Invoice Date

The date appears on supplier invoice. This date is used to calculate payment due date based on payment terms. Date Required

Supplier Name

Supplier's name as recorded in MOVERS.

This field is required if Supplier Number (H) is not populated. Varchar2 240 Conditional

Supplier Number

Supplier's number as recorded in MOVERS.

This field is required if Supplier Name (G) is not populated. Varchar2 30 Conditional

Supplier Site Supplier site identifier. Varchar2 240 Required Invoice Currency Currency of invoice. Varchar2 15 Do Not Populate Payment Currency Currency of payment. Varchar2 15 Do Not Populate

Description

Free form text field. Additional information to store on the invoice. This information is not printed anywhere and is visible to suppliers when they login through Supplier Portal Varchar2 240 Optional

Import Set Not a required field. Do not populate Varchar2 80 Do Not Populate Invoice Type Type of invoice being imported Varchar2 25 Required Legal Entity Name of the legal entity on the invoice. Varchar2 50 Do Not Populate Customer Tax Registration Number Customer Tax Registration Number Varchar2 30 Do Not Populate

Customer Registration Code

Customer legal registration code. Used to derive customer registration number for invoice. Varchar2 30 Do Not Populate

First-Party Tax Registration Number First-Party Tax Registration Number Varchar2 60 Do Not Populate Supplier Tax Registration Number Supplier Tax Registration Number Varchar2 60 Do Not Populate

Payment Terms*

Payment Terms used to create due dates, discount dates and discount amount for each invoice Varchar2 50 Required

Terms Date Used with payment terms to calculate scheduled payment of an invoice. Date Do Not Populate

Goods Received Date Date when goods on the invoice were received Date Do Not Populate Invoice Received Date Date when the invoice was received. Date Do Not Populate

Accounting Date Default accounting date for invoice distributions. Date Do Not Populate

Payment Method Payment method. Varchar2 30 Do Not Populate

Invoices Field Definition - ApInvoicesInterface

Field Name Description DataType Length Usage

Pay Group Groups suppliers or invoices for a single pay run. Varchar2 25 Do Not Populate

Pay Alone Pay Alone Varchar2 1 Optional

Discountable Amount Amount of invoice applicable to a discount.

Not validated. Number Do Not Populate

Prepayment Number

Invoice number of an existing, fully paid prepayment for the same supplier site to be applied to the invoice. Varchar2 50 Optional

Prepayment Line Number The invoice line of an existing prepayment to be applied to the invoice. Number Conditional

Prepayment Application Amount Amount of prepayment to apply to the invoice. Number Conditional

Prepayment Accounting Date Accounting date for the prepayment application. Date Do Not Populate

Invoice Includes Prepayment This indicates if prepayment is included in invoice amount. Varchar2 1 Conditional

Conversion Rate Type Exchange rate type for foreign currency invoices. Varchar2 30 Do Not Populate

Conversion Date Date exchange rate is effective. Date Do Not Populate

Conversion Rate Exchange rate used for foreign currency invoices. Number Do Not Populate

Liability Combination Liability GL Account code combination Varchar2 250 Do Not Populate

Document Category Code Sequential numbering (voucher number) document category. Varchar2 30 Do Not Populate

Voucher Number Unique internal identifier assigned to a document. Varchar2 50 Do Not Populate

Requester First Name This information is not used in MOVERS Varchar2 150 Do Not Populate Requester Last Name This information is not used in MOVERS Varchar2 150 Do Not Populate Requester Employee Number This information is not used in MOVERS Varchar2 150 Do Not Populate

Delivery Channel Code

Information displayed for an electronic payment that instruct the bank about carrying out the payment. Example: print a check and hold it for collection by the payee. Varchar2 30 Do Not Populate

Bank Charge Bearer Bearer of bank charge cost. Varchar2 30 Do Not Populate

Remit-to Supplier

The supplier that receives payment on behalf of the supplier on the invoice.

Varchar2 240 Do Not Populate Remit-to Supplier Number Third party supplier number Varchar2 30 Do Not Populate

Remit-to Address Name Remit-to address where the payment should be sent Varchar2 0-240 Do Not Populate

Payment Priority The payment priority of a scheduled payment. Number 2 Do Not Populate

Settlement Priority Priority to settle payment for the transaction. Varchar2 0-30 Do Not Populate

Unique Remittance Identifier Unique remittance identifier provided by the payee. Varchar2 256 Do Not Populate

Unique Remittance Identifier Check Digit Unique Remittance Identifier Check Digit Varchar2 2 Do Not Populate

Payment Reason Code Code to provide the payment system or bank with additional details for the payment. Varchar2 30 Do Not Populate

Payment Reason Comments Reason for the payment. Varchar2 240 Do Not Populate

Invoices Field Definition - ApInvoicesInterface

Field Name Description DataType Length Usage

Remittance Message 1 Remittance message for use in payment processing. Varchar2 150 Do Not Populate

Remittance Message 2 Remittance message for use in payment processing. Varchar2 150 Do Not Populate

Remittance Message 3 Remittance message for use in payment processing. Varchar2 150 Do Not Populate

Withholding Tax Group Used to apply multiple withholding taxes to an invoice line. Varchar2 25 Do Not Populate

Ship-to Location Ship to location for purchase order matching. Varchar2 40 Do Not Populate

Taxation Country Sets the context for tax drivers such as Product Classification Code. Varchar2 30 Do Not Populate

Document Sub Type A document type required by a tax or governmental authority. Varchar2 150 Do Not Populate

Tax Invoice Internal Sequence Number

Company-specific tax invoice number, in sequence, issued by the company for a supplier-issued tax invoice. Varchar2 150 Do Not Populate

Supplier Tax Invoice Number

The invoice number used to report on a supplier issued tax invoice that is distinct from the regular invoice. Varchar2 150 Do Not Populate

Tax Invoice Recording Date

If company-specific tax invoice date and number is captured, the date the company receives or records the supplier-issued tax invoice. Date Do Not Populate

Supplier Tax Invoice Date Tax invoice date on the supplier-issued tax invoice. Date Do Not Populate

Supplier Tax Invoice Conversion Rate

Supplier conversion rate entered in online invoices to calculate the supplier tax amount for foreign currency invoices. Number Do Not Populate

Port Of Entry Code Identifies the location or port through which the invoiced goods entered the country. Varchar2 30 Do Not Populate

Correction Year Number Do Not Populate Correction Period Varchar2 15 Do Not Populate Import Document Number Customer assigned document number. Varchar2 50 Do Not Populate

Import Document Date Customer assigned date during import of invoice. Varchar2 10 Do Not Populate

Tax Control Amount Total tax amount. Number Do Not Populate

Calculate Tax During Import Indicates whether tax should be calculated for the invoice during import. Varchar2 1 Do Not Populate

Add Tax To Invoice Amount Indicates whether the invoice amount should be grossed up by the calculated tax. Varchar2 1 Do Not Populate

Attribute Category Descriptive Flexfield Varchar2 150 Do Not Populate Attribute 1 Descriptive Flexfield Varchar2 150 Do Not Populate Attribute 2 DFF Domicile Address Varchar2 150 Do Not Populate Attribute 3 Descriptive Flexfield Varchar2 150 Do Not Populate Attribute 4 Descriptive Flexfield Varchar2 150 Do Not Populate Attribute 5 Descriptive Flexfield Varchar2 150 Do Not Populate Attribute 6 Descriptive Flexfield Varchar2 150 Do Not Populate

Attribute 7 (Check Category)

Identifies whether the check will be distributed directly to the vendor or returned to the agency for distribution. Varchar2 150 Optional

Attribute 8 Descriptive Flexfield Varchar2 150 Do Not Populate

Invoices Field Definition - ApInvoicesInterface

Field Name Description DataType Length Usage Attribute 9 Descriptive Flexfield Varchar2 150 Do Not Populate Attribute 10 DFF: PGA, ERS, SDA, AOC Type Varchar2 150 Optional

Attribute 11 (Workflow Org Code)

Org code that is used for routing invoices through the Accounts Payable invoice workflow process. Required to route the invoice for approvals. Varchar2 10 Required

Attribute 12 Varchar2 150 Do Not Populate

Attribute 13 (ERS or PGA Number)

The Expenditure Registration System (ERS) was created to provide agencies with a method to process payments that are authorized by statute, such as payments for Medicaid Services, WIC Food Program, and Second Injury Fund. Program Grant Authority (PGA) gives agencies with statutory authority to issue grants the ability to process Grant payments.

These payments are not subject to the procurement requirements of Chapter 34 RSMo. Varchar2 30 Optional

Attribute 14 Descriptive Flexfield Varchar2 150 Do Not Populate Attribute 15 DFF Payment Reference Number Varchar2 30 Optional Attribute Number 1 Descriptive Flexfield Number Do Not Populate Attribute Number 2 Descriptive Flexfield Number Do Not Populate Attribute Number 3 Descriptive Flexfield Number Do Not Populate Attribute Number 4 Descriptive Flexfield Number Do Not Populate Attribute Number 5 Descriptive Flexfield Number Do Not Populate

Attribute Date 1 (Service Period Start Date) Date the services were provided. Date Optional

Attribute Date 2 (Service Period End Date) Date the services were provided. Date Optional Attribute Date 3 Descriptive Flexfield Date Do Not Populate Attribute Date 4 Descriptive Flexfield Date Do Not Populate Attribute Date 5 Descriptive Flexfield Date Do Not Populate Global Attribute Category Descriptive Flexfield Varchar2 150 Do Not Populate Global Attribute 1 Descriptive Flexfield Varchar2 150 Do Not Populate Global Attribute 2 Descriptive Flexfield Varchar2 150 Do Not Populate Global Attribute 3 Descriptive Flexfield Varchar2 150 Do Not Populate Global Attribute 4 Descriptive Flexfield Varchar2 150 Do Not Populate Global Attribute 5 Descriptive Flexfield Varchar2 150 Do Not Populate Global Attribute 6 Descriptive Flexfield Varchar2 150 Do Not Populate Global Attribute 7 Descriptive Flexfield Varchar2 150 Do Not Populate Global Attribute 8 Descriptive Flexfield Varchar2 150 Do Not Populate Global Attribute 9 Descriptive Flexfield Varchar2 150 Do Not Populate Global Attribute 10 Descriptive Flexfield Varchar2 150 Do Not Populate Global Attribute 11 Descriptive Flexfield Varchar2 150 Do Not Populate Global Attribute 12 Descriptive Flexfield Varchar2 150 Do Not Populate Global Attribute 13 Descriptive Flexfield Varchar2 150 Do Not Populate Global Attribute 14 Descriptive Flexfield Varchar2 150 Do Not Populate Global Attribute 15 Descriptive Flexfield Varchar2 150 Do Not Populate Global Attribute 16 Descriptive Flexfield Varchar2 150 Do Not Populate Global Attribute 17 Descriptive Flexfield Varchar2 150 Do Not Populate Global Attribute 18 Descriptive Flexfield Varchar2 150 Do Not Populate Global Attribute 19 Descriptive Flexfield Varchar2 150 Do Not Populate Global Attribute 20 Descriptive Flexfield Varchar2 150 Do Not Populate

Invoices Field Definition - ApInvoicesInterface

Field Name Description DataType Length Usage Global Attribute Number 1 Descriptive Flexfield Number Do Not Populate Global Attribute Number 2 Descriptive Flexfield Number Do Not Populate Global Attribute Number 3 Descriptive Flexfield Number Do Not Populate Global Attribute Number 4 Descriptive Flexfield Number Do Not Populate Global Attribute Number 5 Descriptive Flexfield Number Do Not Populate Global Attribute Date 1 Descriptive Flexfield Date Do Not Populate Global Attribute Date 2 Descriptive Flexfield Date Do Not Populate Global Attribute Date 3 Descriptive Flexfield Date Do Not Populate Global Attribute Date 4 Descriptive Flexfield Date Do Not Populate Global Attribute Date 5 Descriptive Flexfield Date Do Not Populate

URL Attachments URL of the attachment to upload to the invoice Varchar2 4000 Optional

Remit-to Bank Account Number Varchar2 100 Do Not Populate Supplier IBAN Varchar2 50 Do Not Populate Requester Email Address Varchar2 240 Do Not Populate

RFP Attachment 7 Draft