This section will provide insight to what data is contained in each of the data files listed in the file selection list.

 

 

YTD Invoice Header File  -  ARYINVO

This file contains one record for every invoice/credit memo created. If an average of 5,000 invoices were created per month the file will accumulate approximately 60,000 entries over the course of one year.

Added support for this option to also purge the Invoice Comments files.

 

YTD Cash Receipts File  -  ARYCASH

This file contains every application of a cash receipt to accounts receivable. If a check was applied to 20 invoices, there would be 20 corresponding entries in the cash receipts file.

 

YTD Credit Card Transactions - CCYTRAN

 

 

YTD Inventory Receipts/Returns   -  ARYITRN

Contains one record for each time an item is received into, or relieved from, inventory. Records are generated each time a physical adjustment is made or an item is received, shipped on an invoice, or returned to inventory.

 

YTD Invoice Detail File  -  ARYTRAN

This file contains one record for each line item on every invoice. If an average of 5,000 invoices were created per month, with an average of 20 items on each invoice, the file will accumulate approximately 1,200,000 entries over the course of one year. This file will be very large!

 

YTD P.O. Header File  -  POYMAST

This file contains one record for each purchase order that was created. If an average of 500 purchase orders were processed per month, this file will accumulate approximately 6,000 entries over the course of one year.

 

YTD P.O. Detail File   -  POYTRAN

This file contains one record for each line item on every purchase order. If an average of 500 purchase orders were processed per month, with an average of 20 line items on each PO, this file will accumulate approximately 120,000 entries over the course of one year.

 

YTD Invoice Change Log File - ARYCHLOG

 

YTD Invoice Print Log File - ARYPRLOG

 

Invoice Addresses - ARADDRE

This file contains one record for each invoice that uses an alternate ship to address. Entries will be made for every invoice generated for customers that are configured as a one-ship customer.

 

Business Status File  -  ARBUST

Accumulates Year-to-date sales and cash receipts data by salesperson. This file has become obsolete. Purging the data will have no effect on the entrée system.

 

Deleted User Accounts - SYSAUTH

Purging this file will permanently remove all user accounts that have been flagged as deleted.

 

Deleted Group Accounts - SYSAUTH

Purging this file will permanently remove all group accounts that have been flagged as deleted.

 

AR Release Journal - ARJRNL