YTD File Selection List
Contents
This section will provide information about the data is contained in each of the data files listed in the purge file selection list.
YTD Invoice Files - ARYINVO / ARYTRAN
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.
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.
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. File - POYMAST/ POYTRAN/ POYAPLOG
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.
▪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.
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.
Invoice Change Log - ARYCHLOG is the log of changes to invoices and the users who made the changes.
Invoice Print Log - ARYPRLOG is the log from the invoice printing utility.
YTD Problem Items File - ARYPRBITM
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.
User Log Activity - ARYUSRLG stores entrée system user account activity history data.
AR Release Journal - ARJRNL
Deleted Scheduler Tasks - ESTASK from the Task Scheduler
YTD Physical Adjustments - ARYPHYS
Physical Adjustment Daily Summary - ARPHYSUM
External Scanning Data - ARYSCAN from entrée.UPC
EWM Scan Log - ELSUPCL from the Electronic Warehouse Manager
•AR Invoice - scanned accounts receivable invoices
•AR Check - scanned accounts receivable checks
•AP Invoice - scanned accounts payable invoices
•AP Check - scanned accounts payable checks
•Purchase Order - scanned purchase orders
•Delivery Receipt - scanned delivery receipts
•Custom
•Loading Sheet - scanned loading sheets
•DSD Invoice
•Customer Credit Application
•AR Statement
•Cash Collection Sheet