File Import Definition - Edit Field Properties
     
    Edit required information and click "Save changes" to save changes or return to File Import Definition.
     
    Description Edit description

    Definition name: Payables
    Description: Accounts Payable
    File type: Delimited
     
    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

    Enter the numeric order of the fields listed below as they would appear in your import file. For example, if the first field in your file is "ABA/TRC", and the second field is "Account" you would list the fields as position number "1" and position number "2" to import.
     
    Valid field properties are listed below for your reference.
     
    Field Name Position Number Valid Field Properties
    Check Number Numeric only (0-9), 15 characters max
    Amount Numeric only (0-9), greater than 0.00 and less than 100,000,000.00
    Issued Date Numeric date in specified format (for example, MMDDYY)
    Debit/Credit (optional) Debit, D, Credit, C
    Payee Alpha (a-z, A-Z), numeric (0-9), special characters (including spaces), 96 characters max