Incoming Bank Files Excel Integration
Although the EDI interface is primarily used to import bank files, you can also import a bank file through Excel Integration.
Incoming Bank File Excel Integration (31.1.12) lets you export a file template to Excel, complete the template with bank file data, and import the file back into the system. When the file imports successfully, you can save the file and then run Process Incoming Bank Files to process it.
Incoming Bank Files Excel Integration
The fields in the Excel template file are as follows:
tBankImport.BankImpFileType
Corresponds to the File Type field. This field contains the file type.
tBankImport.BankImpLoadedDate
Corresponds to the Upload Date field and contains the bank file upload date. This field is mandatory.
tBankImport.BankImpLoadedTime
Corresponds to the Time Loaded field and contains the time the bank file was uploaded. This field is mandatory.
tBankImport.BankImpFileName
Corresponds to the Bank File Name field.
tBankImport.BankImpLinesCount
Corresponds to the Numbers of Detail Lines field.
tBankImport.BankImpTotalAmountInTC
Corresponds to the Total Amount In field and displays the total amount in of the bank file.
tBankImport.BankImpTotalAmountOutTC
Corresponds to the Total Amount Out field and displays the total amount out of the bank file.
tBankImport.BankImpCurrencyCode
Corresponds to the Bank Currency Code field.
tBankImportLine.BankImpLineSeq
Corresponds to the Sequence field and contains the bank file line sequence. This field is mandatory.
tBankImportLine.BankImpLineFileFormatCode
Corresponds to the Format Code field and contains the bank file line format code. This field is mandatory.
tBankImportLine.BankImpLineTransType
Corresponds to the Transaction Type field. This field is mandatory.
BankImportLine.BankImpLineAction
Corresponds to the Action field and displays the line action specified by the bank file line. Actions include Create Customer Payment, Pay Customer Payment, Pay Supplier Payment, Bounce Customer Payment, Bounce Supplier Payment, Acknowledge Bank Receipt, Other, and Create Banking Entry. This field is mandatory.
tBankImportLine.BankImpLineBusRelType
Corresponds to the Business Relation Type field. Types include Supplier and Custom This field is mandatory.
tBankImportLine.BankImpLineProcessedStatus
Corresponds to the Process Status field. Process statuses include Not Processed, Processed OK and Processed with Error(s). Assign the initial value Not Processed to the new line. This field is mandatory.
tBankImportLine.BankImpLineOwnBankNumber
Corresponds to the Own Bank Number Bank field. This field is mandatory.
tBankImportLine.BankImpLineValueDate
Corresponds to the Value Date field.
tBankImportLine.BankImpLineStatNumber
Corresponds to the Statement Number field.
tBankImportLine.BankImpLineDescription
Corresponds to the Description field and contains the bank file line description.
tBankImportLine.BankImpLineInOut
Corresponds to the Direction field and indicates the bank file line direction; either incoming or outgoing. This field is mandatory.
tBankImportLine.BankImpLineAmountTC
Corresponds to the Amount TC field and displays the bank file line amount.
tBankImportLine.BankImpLineCurrencyCode
Corresponds to the Currency field and displays the currency of the bank file line.
tBankImportLine.BankImpLineOrigAmountTC
Corresponds to the Original Amount TC field and displays the bank file line original amount.
tBankImportLine.BankImpLineOrigCurrCode
Corresponds to the Original Currency field and displays the bank file line original currency.
tBankImportLine.BankImpLineExchangeRate
Corresponds to the Exchange Rate field and displays the exchange rate of the bank file line.
tBankImportLine.BankImpLineRateScale
Corresponds to the Exchange Scale field and displays the exchange scale of the bank file line.
tBankImportLine.BankImpLineOrigTransDate
Corresponds to the Original Transaction Date and displays the original transaction date of the bank file line.
tBankImportLine.BankImpLineDebtorCode
Corresponds to the Customer Code field and contains the customer code of the bank file line.
tBankImportLine.BankImpLineCreditorCode
Corresponds to the Supplier Code field and displays the supplier code of the bank file line.
tBankImportLine.BankImpLineDebtorName
Corresponds to the Customer Name field and displays the customer name of the bank file line.
tBankImportLine.BankImpLineCreditorName
Corresponds to the Supplier Name field and displays the supplier name of the bank file line.
tBankImportLine.BankImpLineAddressLine
Corresponds to the Address Line field and displays the address of the bank file line.
tBankImportLine.BankImpLineAddressCity
Corresponds to the Address City field and displays the city of the bank file line.
tBankImportLine.BankImpLineAddressZip
Corresponds to the Address Zip field in the program help and displays the bank file line zip code.
tBankImportLine.BankImpLineAddressCountry
Corresponds to the Address Country field and contains the country of the bank file line.
tBankImportLine.BankImpLineBankNumber
Corresponds to the Bank Number field and displays the bank number of the bank file line.
tBankImportLine.BankImpLinePaymentNbr
Corresponds to the Payment Number field and displays the payment number that the bank file line pays.
tBankImportLine.BankImpLinePaymentRef
Corresponds to the Payment Reference field and displays the payments that link to the bank file line.
tBankImportLine.BankImpLineInvRefList
Corresponds to the Invoices field in the program help and displays the invoices that link to the bank file line.
tBankImportLine.BankImpLineInfo
Corresponds to the Info field and contains the bank file line information.
tBankImportLine.BankImpLineCost
Corresponds to the Cost field and displays the cost of the bank file line.
tBankImportLine.BankImpLineBatchNbr
Corresponds to the Batch Number field and displays the batch number that a bank file line belongs to in the processing. This field is to be left blank.
tBankImportLine.BankImpLineReference
Corresponds to the Reference field and displays the reference entered by the user to identify a bank file line.
tBankImportLine.BankImpLineDiscAmtTC
Corresponds to the TC Discount Amount field and displays the discount amount of bank file line.
tBankImportLine.BankImpLineIntAmtTC
Corresponds to the TC Interest Amount field and displays the interest amount of bank file line.
tBankImportLine.BankImpLineResultAction
Corresponds to the Result Action field in the program grid and displays the resulting action after processing. Leave this field blank.
tBankImportLine.BankImpLineProcessDate
Corresponds to the Process Date field and displays the date that bank file line is processed. You cannot edit this field.
tBankImportLine.BankImpLineIsCreateBE
Corresponds to the Create Banking Entry field.
tBankImportLine.BankImpLineIsPayDDoc
Corresponds to the New Payments as Paid field; creates a payment for the banking entry line and changes the status to paid.
tBankImportLine.tlIsProcessed
Corresponds to the Is Processed field and displays whether a bank file line is processed or not. Do not change this field.
tBankImportLine.tlIsDifferentAction
Corresponds to the Is Different Action field and displays whether the result action is different. Do not change this field.
