Field

Description (field size)

Transaction Code

Set to “1” (2)

Client Code

Provided from Factoring Branch Setup for the branch set on the invoice. (8)

Customer Code

Identifier from Microsoft Dynamics GP for the customer on the invoice. (20)

Invoice Amount

Dollar amount of the invoice (in cents). (9)

Invoice Date

Date recorded for the invoice (in YYYMMDD format). (8)

Approval #

NOT USED. (6)

Schedule Code

MoversSuite generated batch number, i.e. “1234” for batch B001234. (6)

As of Date

NOT USED. Processed date of the batch (in YYYMMDD format). (8)

Credit Indicator

NOT USED. (1)

Invoice Number

MoversSuite generated Invoice Number. (22)

Store Number

Branch identifier from Branch Setup. (10)

Purchase Order

NOT USED. Purchase Order associated to the invoice. (15)

Terms

Terms specified on the invoice, as define in Invoice Terms Setup. (15)

NOTES:

The following name and address information is pulled from Microsoft Dynamics GP for the customer associated to the invoice.

For the Country Code, the application standardizes the data coming in from Dynamics GP to the three-character size limit. For example, United States or U.S.A. is standardized to USA. If the code from Dynamics GP is exactly three-characters in length, then MoversSuite attempts to match the code or name to a record within the Country Code Setup. What is included in this file is the Van Line Country Code associated to the matching Country Code Setup record.

Name

Name from Microsoft Dynamics GP for the customer on the invoice. (40)

Street Address

Billing address associated to the customer on the invoice. (40)

Street Address2

Second billing address associated to the customer on the invoice. (40)

City

City associated to the customer on the invoice. (40)

State

State associated to the customer on the invoice. (3)

Zip

Postal code associated to the customer on the invoice. (10)

Telephone

Contact phone number for the customer on the invoice. (20)

Country Code

Code identifying the country associated to the customer on the invoice. (3)

Clients Comment

NOT USED. (30)

Client Reference Number

NOT USED. (30)

Non-Merchandize Amount

NOT USED. (9)

VAT Amount

NOT USED. (9)

Bill and Hold

NOT USED. (1)

Client Tradestyle Number

Provided from Factoring Branch Setup for the branch set on the invoice. (2)

Schedule Date

Date of factoring file generated (in YYYYMMDD format). (8)