Cibc Eft 80 Byte File Layout Bin
EFT ELECTRONIC FUNDS TRANSFER CLIENT MANUAL Assigned Client Values These fields have been specifically assigned to/by you in the preparation of file information and accounting.
EFT Payments Import File LayoutThe EFT Payments Import function enables users to importinformation to create One Time EFT Payments or EFT Payments fromTemplates.All mandatory information must be available to create apayment. If the payment is to becreated using a template, information from the template will be used alongwith information from the import file to create the payment. If a payment is to be created as a one-timeEFT payment, all mandatory information must be available in the importfile.Note: For fixed length files, all fields must beincluded with the exact length and format indicated in the definition column.OneTime EFT Payment ImportField nameDescriptionDefinitionMandatory (Y/N)Type1. Must be ‘EO’. Only upper case allowed.Char (2)YPayment Group1.
Must be a Payment Group that youhave previously set up on the EFT Payments service. Access to the corresponding SD AgreementNumber should be available to the group.2. Agreement number and charge backaccount mapped to payment group are validated.Char (20)YDue Date1. The format of the due date mustbe MM/DD/YYYY.2. Payments can be backdated up to170 calendar days for debits and 30 calendar days for credits.3. Payments can be future dated upto 60 calendar days.4. Defaults to current date whennot available in the file.Char(10)NInstitution1.
Must be numeric.2. Must be a valid institution inthe BENE BANK table.Char (3)YTransit1. Must be numeric.2. Must be a valid institution inthe BENE BANK table.Char (5)YAccount1. Must be numeric.Char (12)YAmount1.
Must be numeric. Comma and dollar sign are allowed.2. Must be 03. Should not exceed the value setup in BANK SERVICE.Decimal (15,2)YPayment Type1. Must be Credit or Debit.2. Validated against user’s accessto payables/receivables.3. Validated againstpayable/receivable account mapped to payment group.Char (6)YPayee/Payor NameChar (30)YAddress 1Char (35)NAddress 2Char (35)NCityChar (20)NProvinceChar (32)NPostalCodeChar (10)NCountry1.
Validated against country table.Char (32)NCross Ref. NumberChar (19)YCPA Code1.
Cibc Eft 80 Byte File Layout Bind
Must be numeric.2. Must exist in the CPA code listavailable in the system.Char (3)YSundry InformationChar (15)NContactChar (35)NPhoneChar (20)NEmailChar (64)NFaxChar (20)NAdditional Info.Char (140)NEFT Payments from Templates ImportField nameDescriptionDefinitionMandatory (Y/N)Type1. Must be ‘ET’. Only upper case allowed.Char (2)YTemplateID1.
Any other characters.2. Must be a template that you havepreviously set up and access to the corresponding agreement number must beavailable to the group.3. Agreement number and charge backaccount mapped to payment group are validated.4.
Validation against user’s accessto payables/receivables based on payment type.Char (30)YDue Date1. The format of due date must beMM/DD/YYYY.2. Payments can be backdated up to170 calendar days for debits and 30 calendar days for credits.3. Payments can be future dated upto 60 calendar days.4. If blank, will default to currentdate.Char (10)NAmount1. Must be numeric.
Comma and dollar sign are allowed.2. Must be 0.3. Should not exceed the valued setup in BANK SERVICE.4. Amount should not be provided inthe file if an amount has already been defined in the payment template.Decimal(15,2)NCPA Code1. Must be numeric.2.
Must exist in the CPA code listavailable in the system.Char (3)YSundry InformationChar (15)NAdditional Info.Char (140)NRelated Topics.