File Import Definition - Edit Field Properties

Changes to the default field values have affected your field properties settings. Update the field properties settings below.

The changes to both the default field values and the field properties are applied upon clicking "Save changes."

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 contents:	Issues
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) Issue Action Add, A, Delete, D Debit/Credit (optional) Debit, D, Credit, C Payee Alpha (a-z, A-Z), numeric (0-9), special characters (including spaces), 96 characters max