AR115 - EFT Payment Creation Run AR115 (EFT Payment Creation) to create ACH-formatted, BACS-formatted, or non-formatted payments, and apply payments to eligible open items. Payments are created for each customer at the customer group/EFT national account level. AR115 will create one of three types of payment records. 1. A record for funds to be drawn from the customer's account 2. A record for funds to be transmitted to the customer's account if the customer has a credit balance 3. A prenotification record for a new bank transit number The payment header and detail records are created with the payment number consisting of the EFT processing date for the customer. For all EFT payments, pre-application records are created for the open items associated with the payment. For net zero open items and credit balance amounts, a zero check is created. For the net zero open items payment, the payment is a reference for applications. For the net credit balance open items zero payment, a debit memo is created to balance the credit balance, then applications are performed. AR115 creates a report listing open items cleared by the EFT process, total deposit and withdrawal amounts, and the net deposit and withdrawal amounts. Updated Files ACCOMMIT - Used as part of activity commitment update. ACCOMMITX - Used as part of activity commitment update. ARAPPLIED - Application record created for open items. ARCOMP - Updated with last payment batch number used. ARCUSTOMER - Used to validate customer. ARCUSTPER - Used to validate customer transaction period record. ARDISTRIB - Distribution record created for created memo processing. AROIHDR - Open item header record created for created memo processing. AROITEMS - Open item record created for created memo processing, and EFT status updated. AROPIVOT - ARPAYMENT - Payment record created representing funds received and for application to open items. ARPROCLEVL - Used flag updated. ARPYMNTHDR - Payment header record created for batch of payment records. ARSADJUST - Temporary application adjustment record created. ARSAPPLIED - Temporary application record created. ARSUMMARY - Part of process level validation. ARUDISTRIB - Updates user analysis information. ARUPMNTHDR - Updates user analysis information. CBBANKENT - Used as part of cash ledger validation. CBBANKINST - Used as part of payment code validation. CBCASHCODE - Used as part of cash code validation. CBCPYCASH - Used as part of cash ledger validation. CBDISTRIB - Used as part of cash ledger validation. CBTRANS - Creates cash ledger transaction record. CKPOINT - Used for restart purposes. CUSTDESC - Validates customer description record. DTCUSTBANK - Validates Bills of Exchange bank accounts. FTTRANS - EFT transaction record created for open items. JBOOKHDR - Used in journal book processing. NATBALANCE - National account balance updated for with payment amount. TERMS - Used to validate terms code. TXCODEMAST - Validates tax code flag. TXCOMPANY - Validates tax code company. TXTAXCODE - Validates tax codes. TXTAXTABLE - Validates tax table transaction records. TXTAXTRAN - Creates tax transaction records for distribution taxable distribution lines. Referenced Files ACACCTCAT - Used as part of activity validation. ACACTGRP - Used as part of activity validation. ACACTIVITY - Used as part of activity validation. ACCAL - Used as part of activity validation. ACCALX - Used as part of activity validation. APACCRCODE - Used as part of vendor validation. APCOMPANY - Used as part of vendor validation. APCPYVND - Used as part of vendor validation. APHLDINV - Used as part of vendor validation. APVENCLASS - Used as part of vendor validation. APVENGROUP - Used as part of vendor validation. APVENMAST - Used as part of vendor validation. ARCODE - Used to validate general ledger accounts receivable code. ARCUSTGRP - Used to validate customer group. AROPTR - Used to validate operator. ARREASON - Validates reason code record. CBADJUST - Used as part of cash ledger validation. CBBALANCE - Used as part of cash ledger validation. CBSTATEMNT - Used in cash ledger processing. CBSTMTDTL - Used in cash ledger processing. CBUSER - Used as part of cash ledger validation. CBUSRCLASS - Used as part of cash ledger validation. CRANALYST - Validates credit analyst code. CUCONV - Used as part of currency validation. CURELAT - Validates currency relationships. CUSTORDER - Part of workflow validation logic. FTCUSTNOTE - Used to validate customer notification method. GLADDRESS - Validates general ledger company information. GLCHART - Used as part of general ledger account validation. GLCODES - Used to validate system control. GLSYSTEM - Used as part of general ledger account validation. JBKOPCODE - Used in journal book processing. JBKSYSCODE - Used in journal book processing. NATACCT - Used to validate national account customer relationship. OECOMPANY - Part of workflow validation logic. SYSTEMCODE - Validates the system code updating general ledger and updated the object id. TXTAXRATE - Validates tax rate. WFSETUP - INVOKED Programs IFAC ACAC IFCR IFSG IFCU IFAU SLSE SLSU IFCC IFOB IFRS IFSC |