Import for BOA WORKS, Wells Fargo and SPS

  • Comma-delimited file
Field Name DataType Length Data Definition
Payee String 254 Payee ID
Merchant String 254 Merchant listed on the transaction
Doc Number String 50 Transaction number
Doc Type Currency Code identifying the type of document. 2=Debit Transaction; 3=Credit Transaction; 4=Reimbursement
Doc Date String 10 Purchase Date
Doc Ref String 50 During reconciliation, accountants can enter any user specific information in this 50 character field.
It is then included in the export
Request Number String 50 The request number in Works associated with the transaction.
This will be blank for base fund purchases
PO Number String 50 The purchase order number associated with the transaction.
This may come from the request or entered during reconciliation w/in Works.
This will be blank if no PO number is entered
Request Name String 50 The name of the request in Works associated with the transaction.
This will be blank for base funds purchases
Requester String 64 Name of the person who created the request associated with this transaction.
This will be either the cardholder, proxy requester or blank if this is a base funds purchase.
Payment Type String 50 Code describing the method of payment for this purchase.
Card Holder String 64 Primary cardholder for the card used on this transaction
Card Number String 10 Card Number
Merchant Ref Number String 24 Reference number as assigned by Visa which shows up on the statement.
Purchase Amount Currency Purchase Amount
Legacy Data Field1 String 1 This field is no longer used by the application
but is a placeholder so the file is compatible with current customer's import process.
Legacy Data Field2 String 1 This field is no longer used by the application
but is a placeholder so the file is compatible with current customer's import process.
Legacy Data Field3 String 1 This field is no longer used by the application
but is a placeholder so the file is compatible with current customer's import process.
Tax Amount Currency Tax Amount
Total Amount Currency The net total amount of the purchase, net debit or credit as shown on the statement
Item Seq Currency Item Sequence
Item Id Currency Item Id
Item Type Currency Item Type
Item Description String 254 Item Description
Legacy Data Field4 String 1 This field is no longer used by the application
but is a placeholder so the file is compatible with current customer's import process.
Legacy Data Field5 String 1 This field is no longer used by the application
but is a placeholder so the file is compatible with current customer's import process.
Legacy Data Field6 String 1 This field is no longer used by the application
but is a placeholder so the file is compatible with current customer's import process.
Legacy Data Field7 String 1 This field is no longer used by the application
but is a placeholder so the file is compatible with current customer's import process.
Legacy Data Field8 String 1 This field is no longer used by the application
but is a placeholder so the file is compatible with current customer's import process.
Item Debit Currency Item Debit
Item Credit Currency Item Credit
Item GL String 254 The general ledger coding for the line item.
Item Personal String 1 This field shows whether a line item was marked as a personal purchase by the cardholder
Y=Yes, N=No, blank for adjustments and AP
Purchase Detail String 1 Purchase Detail-This is a legacy export field and will be blank
Merchant Zip String 9 The ZIP code of the merchant as provided in the Visa transaction information.
Payer Zip String 9 The ZIP code of the merchant as provided in the Visa transaction information.
Payment CRI String 50
Merchant Code String 8 The Merchant Category Code (MCC) for the merchant
Post Date DateTime 10 The posting date of the credit card transaction.