Sample File line:
253624539656,1/1/2019,Bank Transaction,12345,no,0001-Fort Wayne,42000-0000-000,Test import,100,0,112233456
Field | Source | Field ID | |
Bank Account number | Supplied by customer | 1 | Required |
Date | 2 | Required | |
Type | Supplied by custoemer - Bank transction - bank Withdrawal | 3 | Required |
Descripton | Free form from customer | 4 | Can be blank |
Recurring flag | y/n from customer | 5 | default to "n" if not supplied |
Location | Verify to list of valid locations from system manager | 6 | Required |
GL account | Must be valid account - detail record | 7 | Default from user profile if not supplied see Fig1
|
Check no | Supplied by customer | added 19.1 | Can be blank |
Loan number | Must be a valid loan number or empty | added 19.1 | Can be Blank |
Detail Description | Supplied by customer | Can be Blank | |
Debit | Debit for Withdrawal | Default 0 or necessary value if not suppplied (if credit would not be supplied) | |
Credit | Credit for bank trnsaction | Default 0 or necessary value if not suppplied (if debit would not be supplied) | |
Payee | Free form - overwritten if payee id is supplied | Default to Blank if not supplied | |
Payee address | Free form - overwritten if payee id is supplied | Default to Blank if not supplied | |
city | Free form - overwritten if payee id is supplied | Default to Blank if not supplied | |
State | Free form - overwritten if payee id is supplied | Default to Blank if not supplied | |
zip | Free form - overwritten if payee id is supplied | Default to Blank if not supplied | |
country | Free form - overwritten if payee id is supplied | Default to Blank if not supplied | |
Entity ID | Linked to entity name | Default to Blank if not supplied | |
Pay to address | Linked to location name | Default to Blank if not supplied |
Overview
Content Tools