Electronic File Transfer in AR – Brazil – Technical Information

Companies in Brazil use bank services to collect customers.
The Brazilian Electronic File Transfer for Receivables (CLL F034) provides the
functionality to electronically transfer collection documents to banks using
files in the standard CNAB format. The CLL F034 features allows companies to
meet Brazilian Bank Transfer requirements by providing customers with the most
important bank file formats in Brazil, as each bank has its own format.
Tables:
Setup Tables:
JL_BR_AR_BANK_INSTRUCTIONS
à Bank Instruction table
JL_BR_AR_BANK_OCCURENCES
à Bank Occurrences table
JL_BR_AR_REC_MET_ACCTS_ExT_ALL
à Receipt Method
Accounts table
Transaction Tables:
JL_BR_AR_SELECT_CONTROLS_ALL
à Bank Transfer
Remittance Batches selection criteria table
JL_BR_AR_SELECT_ACCOUNTS_ALL
à Bank Account
Distributions selection criteria table
JL_BR_AR_BORDEROS_ALL
à Header for Remittance
and Occurrence batches
JL_BR_AR_REMIT_BORDEROS_ALL
à Bordero remittance
additional information
JL_BR_AR_COLLECTION_DOCS_ALL
à Collection documents
associated to remittance borderos
JL_BR_AR_OCCURRENCE_DOCS_ALL
à All occurrences
related to the collection documents
JL_BR_AR_RET_INTERFACE_ALL
à Interface table for
Bank returns
JL_BR_AR_RET_INTERFACE_EXT_ALL
à Interface table with
rejected lines

JL_BR_AR_BANK_RETURNS_ALL
à Temporary table to
store bank returned occurrences.
  • June 22, 2016 | 19 views
  • Comments