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