File Import Definition Detail
 
Description Edit description

Definition name: Payables
Description: Accounts Payable
File contents: Issues
File type: Delimited
 
Delete file import definition
 
Characteristics Edit characteristics

Field delimiter: Comma (,)
Text qualifier: Double quote (")
Amount format: Decimal included (i.e. 123.00)
Date format: YYMMDD
 
Default Field Values (Optional) Edit default field values

ABA/TRC: 081203790
Account: *4511 - PRESTIGE OPERATING ACCOUNT
Issue Type: Issue
 
Field Properties Edit field properties

Field Name Position Number Valid Field Properties
Check Number 1 Numeric only (0-9), 15 characters max
Amount 2 Numeric only (0-9), greater than 0.00 and less than 100,000,000.00
Issued Date 3 Numeric date in specified format (for example, MMDDYY)
Issue Action 4 Add, A, Delete, D
Debit/Credit (optional) 5 Debit, D, Credit, C
Payee 6 Alpha (a-z, A-Z), numeric (0-9), special characters (including spaces). Up to 96 characters allowed for non-payee positive pay accounts. Up to 80 characters allowed for payee positive pay accounts.