Page History
Sample File line:
253624539656,1/1/201912152015,2016-04-30,Bank Transaction,12345Header Description,noN,0001-Fort Wayne,4200061500-00000101-000,Test import12345,BLN-1,Fee Expense,100.000000,0,112233456.000000,Steve Smith,1824 Grove Avenue,Woodward,Oklahoma,73801,United States,1
Field | Source | Field ID | ||
a | Bank Account number | Supplied by customer | 1 | Required |
b | Date | 2 | Required | |
c | Type | Supplied by custoemer - Bank transction - bank Withdrawal | 3 | Required |
d | Descripton | Free form from customer | 4 | Can be blank |
e | Recurring flag | y/n from customer | 5 | default to "n" if not supplied |
f | Location | Verify to list of valid locations from system manager | 6 | Required |
g | GL account | Must be valid account - detail record | 7 | Default from user profile if not supplied see Fig1
|
h | Check no | Supplied by customer | added 19.1 | Can be blank |
i | Loan number | Must be a valid loan number or empty | added 19.1 | Can be Blank |
j | Detail Description | Supplied by customer | Can be Blank | |
k | Debit | Debit for Withdrawal | Default 0 or necessary value if not suppplied (if credit would not be supplied) | |
l | Credit | Credit for bank trnsaction | Default 0 or necessary value if not suppplied (if debit would not be supplied) | |
m | Payee | Free form - overwritten if payee id is supplied | Default to Blank if not supplied | |
n | Payee address | Free form - overwritten if payee id is supplied | Default to Blank if not supplied | |
o | city | Free form - overwritten if payee id is supplied | Default to Blank if not supplied | |
p | State | Free form - overwritten if payee id is supplied | Default to Blank if not supplied | |
q | zip | Free form - overwritten if payee id is supplied | Default to Blank if not supplied | |
r | country | Free form - overwritten if payee id is supplied | Default to Blank if not supplied | |
s | Entity ID | Linked to entity name | Default to Blank if not supplied | |
t | Pay to address | Linked to location name | Default to Blank if not supplied |
...
Overview
Content Tools