Sample File line:

12152015,2016-04-30,Bank Transaction,Header Description,N,0001-Fort Wayne,61500-0101-000,12345,BLN-1,Fee Expense,100.000000,0.000000,Steve Smith,1824  Grove Avenue,Woodward,Oklahoma,73801,United States,1

 

 

 

 FieldSourceField ID 
aBank Account numberSupplied by customer1Required
bDate 2Required
cTypeSupplied by custoemer - Bank transction - bank Withdrawal3Required
dDescriptonFree form from customer4Can be blank 
eRecurring flagy/n from customer5default to "n" if not supplied
fLocationVerify to list of valid locations from system manager6Required
gGL accountMust be valid account - detail record7

Default from user profile if not supplied see Fig1

 

hCheck noSupplied by customeradded 19.1Can be blank
iLoan numberMust be a valid loan number or emptyadded 19.1Can be Blank
jDetail DescriptionSupplied by customer Can be Blank
kDebitDebit for Withdrawal Default 0 or necessary value if not suppplied (if credit would not be supplied)
lCreditCredit for bank trnsaction Default 0 or necessary value if not suppplied (if debit would not be supplied)
mPayeeFree form - overwritten if payee id is supplied Default to Blank if not supplied
nPayee addressFree form - overwritten if payee id is supplied Default to Blank if not supplied
ocityFree form - overwritten if payee id is supplied Default to Blank if not supplied
pState Free form - overwritten if payee id is supplied Default to Blank if not supplied
qzipFree form - overwritten if payee id is supplied Default to Blank if not supplied
rcountryFree form - overwritten if payee id is supplied Default to Blank if not supplied
sEntity IDLinked to entity name Default to Blank if not supplied
tPay to addressLinked to location name Default to Blank if not supplied

 

 

 

 

 

  • No labels