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.
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. |
Use the fields in this block to enter pertinent information about your company's credit card.
Enter the name (up to five characters) of the credit card for which you will be defining field positions.
Enter a short credit card description (up to 30 characters) in this field.
You can enter a maximum of two characters in each field in this block.
Enter the file position of the vendor ID in this required field.
Enter the file position of the credit card account in this required field.
Enter the file position of the pay vendor ID in this field, if applicable.
Enter the file position of the invoice date in this required field.
Enter the file position of the transaction amount in this required field.
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.
Enter the file position of the organization in this required field.
Enter the file position of the project in this field, if applicable.
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.
Enter the file position of the sales/use tax code in this field, if applicable.
Enter the file position of the sales/use tax amount in this field, if applicable.
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. |
Enter the file position of the trip number in this field, if applicable.
Enter the file position of the expense type in this required field.
Enter the file position of the trip start date in this field, if applicable.
Enter the file position of the ticket number in this field, if applicable.
Enter the file position of the ticket number in this field, if applicable.
Enter the file position of the destination description in this field, if applicable.
* A red asterisk denotes a required field.
Changes in this screen update the CR_CARD_UPLOAD_DEF table.