AR575 - Payment1 Interface AR575 (Payment1 Interface) lets you add payments to the Accounts Receivable system from a file created by an external source. The file must be formatted in a non-BAI (Bank Administration Institute) format. AR575 is one of several payment interface programs in the Accounts Receivable system. AR575 differs from AR570 (Lock Box Interface) in that the file does not adhere to a BAI (Bank Administration Institute) format. The program edits the external data to protect the integrity of the Accounts Receivable data. AR575 differs from AR580 (Payment Interface) by presenting fewer options for importing payment batches and thus streamlines processing of payment batches. If any errors exist, no payments will be added, and the program will create a report in payment number order that includes each field that failed an edit, the field data, and a description of the error. If no errors exist, the program creates a report in output sequence order that includes all payments added and totals for the number of records processed and payment amounts added for both assigned and unassigned payments. AR575 adds error-free payments into the data base and does not add payments that have errors. In addition, if there are errors, AR575 produces an error report that lists payments that were not loaded due to errors. Payments with no valid customer number, MICR number, EDI number, or transaction number are loaded as unassigned. The error report includes each field that failed an edit, the field data, and a description of the error. In addition, the report shows total quantities and total payment values for unassigned payments and for total payments processed. AR575 adds non-BAI formatted payment transactions to the ARIPMT file. For file layout information, see the Accounts Receivable Procedures Manual. Use AR97.6 (Interface Payment1) to maintain payment data added by AR575. Updated Files ACCOMMIT - Used as part of Activity commitment update. ACCOMMITX - Used as part of Activity commitment update. ARAPPLIED - Part of cash application object logic. ARCOMP - Last payment batch number. ARCUSTOMER - Last payment and balance fields incremented and updated. ARCUSTPER - Payment period transaction activity updated. ARDISTRIB - Used as part of Non-AR payment distribution creation logic. ARIPMT - Primary input file. Records are deleted after successfully processed. ARMICRCUST - Customer MICR file conditionally created. ARPAYMENT - Primary file created for each payment record. ARPROCLEVL - Used flag updated. ARPYMNTHDR - Payment batch header record for one or more payments. ARREMIT - Remittance records created for each interfaced remittance type record. ARSUMMARY - Payment period activity updated. ARUDISTRIB - Validates user analysis data associated with distributions. ARUPMNTHDR - Validates user analysis data associated with a batch number. CBBANKENT - Validates bank. Sets the used flag to Yes. CBBANKINST - Validates the payment code. Sets the used flag to Yes. CBCASHCODE - Validates the cash code. Sets the used flag to Yes. CBCPYCASH - Validate the cash code for the company. Sets the used flag to Yes. CBDISTRIB - Generates cash ledger distributions for the payments entered. CBTRANS - Generates cash ledger transaction records. CKPOINT - The environment file used for recovery. CUSTDESC - Customer group balance updated. JBOOKHDR - Used in journal book processing. NATBALANCE - National account balance updated. TXCODEMAST - Stores tax codes, descriptions, and tax types that define how the tax code is used. TXCOMPANY - Used as part of tax calculation logic. TXTAXCODE - Used in tax calculation logic. TXTAXTABLE - Used to obtain multiple tax codes. TXTAXTRAN - Creates tax transaction records for 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 as a default cash offset value in of payment creation logic. ARCUSTGRP - Part of company validation. ARLOCKBOX - Validates and defaults lockbox attributes. AROIHDR - Validates open item header if referenced on a remittance type record. AROITEMS - Validates open item if referenced on a remittance type record. ARSADJUST - Part of application object routine. ARSAPPLIED - Part of application object routine. CBADJUST - Used in cash ledger processing. CBBALANCE - Used in cash ledger processing. CBSTATEMNT - Validates reconciliation statement header data for cash codes that require statements to be reconciled. CBSTMTDTL - Used in cash ledger processing. CBUSER - Determines user access to cash ledger. CBUSRCLASS - Determines user access to cash ledger. CUCONV - Obtains a currency exchange rate. CURELAT - Validates currency relationships. CUSTORDER - Part of workflow validation logic. GLADDRESS - Part of company validation. GLCHART - Part of company validation. GLCODES - Part of company validation. GLSYSTEM - Verifies general ledger dates. JBKOPCODE - Used in journal book processing. JBKSYSCODE - Used in journal book processing. NATACCT - Validates national account relationships. OECOMPANY - Part of workflow validation logic. SYSTEMCODE - Validates the system code updating general ledger and updated the object id. TXTAXRATE - Used in tax calculation. WFSETUP - INVOKED Programs IFAC ACAC IFCR IFSG IFCU IFAU SLSE SLSU IFCC IFOB IFRS IFSC |