Field Descriptions

Table Information

 

Credit Card Import Information

What can I do in this screen?

Use this screen to map fields in the Credit Card Transaction File to specific fields in Costpoint. You must complete this screen in order to run the Import Company Credit Card Transactions screen.

When should I use this screen?

You must install InfoSpan software version 2.0 or later before accessing this screen.

Note: The file positions you set up in this screen must match those set up in the InfoSpan software. Failure to do this will result in numerous errors.

Field Descriptions

Credit Card Import Information

Use the fields in this block to enter pertinent information about your company's credit card.

Credit Card Type *

Enter the name (up to five characters) of the credit card for which you will be defining field positions.

Credit Card Desc *

Enter a short credit card description (up to 30 characters) in this field.

Define Field Positions

You can enter a maximum of two characters in each field in this block.

Vendor ID *

Enter the file position of the vendor ID in this required field.

Credit Card Acct *

Enter the file position of the credit card account in this required field.

Pay Vendor ID

Enter the file position of the pay vendor ID in this field, if applicable.

Invoice Date *

Enter the file position of the invoice date in this required field.

Transaction Amt *

Enter the file position of the transaction amount in this required field.

Transaction Desc

Enter the file position of the transaction description in this field, if applicable.

Account *

Enter the file position of the account in this required field.

Organization *

Enter the file position of the organization in this required field.

Project

Enter the file position of the project in this field, if applicable.

Notes

Enter the file position of the notes in this field, if applicable.

Tax Type *

Enter the file position of the tax type in this required field.

Sales/Use Tax Cd

Enter the file position of the sales/use tax code in this field, if applicable.

Sales/Use Tax Amt

Enter the file position of the sales/use tax amount in this field, if applicable.

Enter for Travel Upload

Note: The fields in this group box are optional if you plan to upload corporate credit card transactions using the Enter A/P Vouchers screen.

However, if you plan to upload corporate credit card transactions through the Enter Company-Paid Travel Expenses screen, you must complete these fields.

Trip Number

Enter the file position of the trip number in this field, if applicable.

Expense Type

Enter the file position of the expense type in this required field.

Trip Start Date

Enter the file position of the trip start date in this field, if applicable.

Trip End Date

Enter the file position of the ticket number in this field, if applicable.

Ticket Number

Enter the file position of the ticket number in this field, if applicable.

Destination Desc

Enter the file position of the destination description in this field, if applicable.

* A red asterisk denotes a required field.

Table Information

Changes in this screen update the CR_CARD_UPLOAD_DEF table.

Top of Page