How long will a purge take? Purge times take an average of 4 MB per minute.
Is there an order I should Purge in? Packages can be purged in any order except for ACP-ACR-INV. ACP & ACR must be purged before INV.
ACP
VOUCHERS MUST BE MARKED ACTUAL TO PURGE
The dates that control the purge criteria are not affected by marking vouchers actual so they can be marked actual on today’s date & they will still purge.
FILES PURGED
ACCOUNTS PAYABLE FILES
ACCPAY.ACP
DISBURSE.ACP
ACPGLDTL.ACP
ACPTOTAL.ACP
ACCOUNTS PAYABLE REMARKS FILE
ACPRMRKS.ACP
ACR
Finance charge invoices are processed through one extra date criteria. They must be at least 18-months older than the Accounting Date Groups Default Date. This is done so that Cumulative Finance Charges may still be run on statements.
FILES PURGED
ACCOUNTS RECIEVABLE FILES
ACCREC.ACR
ACRTRAN2.ACR
PAYMENTS.ACR
ACRGLDTL.ACR
ACRTOTAL.ACR
ACRRMRKS.ACR
ACCOUNTS REVIEVABLE REMARKS FILE
ACRRMRKS.ACR
ACCOUNTS RECEIVABLE HISTORICAL BALANCE FILES
HISTORY.ACR
ACCOUNTS RECEIVABLE CONTACT INFORMATION FILE
CONTACT.ACR
ACCOUNTS RECEIVEABLE BUDGET AGREEMENTS FILE
ACRBBMST.ACR
AGY
*AgroGuide does not have a purge function to delete history, but it does have a purge function to wipe out a client.
AgroGuide will not allow a name/address record to be deleted if there is a field history or blend record attached to that name id.
So AgroGuide has built in the ability to “remove” the key but leave the record for regulatory purposes.
AGY > AgroGuide > Displays the window that shows farm name tree > go to ACTIONS > Purge client > merge field attributes to the new name id, then you can delete the old name id in AGRIS name/Address.
BNK
*ONLY RECONCILED TRANSACTIONS WILL PURGE.
*Uses Ledger date on transactions to purge
FILES PURGED
BANK FILES
BANKACCT.BNK
BNKGLDTL.BNK
BNKTOTAL.BNK
CFT
FILES PURGED
COMMUNICATION LOG – AGLOGIC
E01COLOG.CFT
COMMUNICATION LOG – ATLAS
E01COLOG.CFT
COMMUNICATION LOG – PASSPORT POS
E01COLOG.CFT
COMMUNICATION LOG – AGRIS WEB SERVICES
E01COLOG.CFT
COMMUNICATION LOG – DTN MARKET INFORMATION
E01COLOG.CFT
COMMUNICATION LOG – PINNACLE PALM POS
E01COLOG.CFT
INV
FILES PURGED
INVENTORY DELIVERY TICKETS FILE
DTICKETS.INV
INVENTORY SALES/PURCHASE ORDERS FILE
INVORDS2.INV
ORDERS.INV
INVENTORY ACTIVITY FILES
INVTRAN1.INV
INVTRAN3.INV
INVTRAN4.INV
INVTRAN5.INV
INVTRAN6.INV
INVTRAN7.INV
INVENTORY INACTIVE SUBITEMS BALANCE FILES
INVTOTAL.INV
INVENTORY SPECIFICATIONS/REMARKS FILE
SREMARKS.INV
INVENTORY AUDIT FILE
INVAUDIT.INV
OPERATIONAL COSTS
I34ALLOC.INV
GRN
*The grain package is unique in that it will cycle through the same files during each document type purge.
Settlements
a. If this is a voided Settlement and the void date < purge date, then purge.
b. If the settlement date > or = purge date, then do not purge.
c. If this Settlement includes a partial payment on a Delivery Sheet Application that was not fully paid before the purge date, then do not purge.
d. If none of the above is true, purge all records for this Settlement.
Contracts
a. If the Contract status <> “S”, then do not purge.
b. If the due date > or = purge date, then do not purge.
c. If units applied /canceled > contract units, then do not purge.
d. If any pricing or cancelation dates > or = purge date, then do not purge.
e. If any of the delivery Sheet Applications for this contract were not paid before the purge date, then do not purge.
f. If none of the above is true, purge this Contract.
Scale Tickets
a. If void ticket and ship date < purge date, then purge.
b. If transfer ticket and ship date > purge date and hauler voucher numbers exist and no estimates exist, then purge.
c. If estimated weights, grades or freight, then do not purge.
d. If hauler voucher number does not exist, then do not purge.
e. If all applications are not on Delivery Sheets, then do not purge.
f. If the Delivery Sheet is not paid, then do not purge.
g. If the date paid > or = purge date, then do not purge.
h. If the Contract exists, then do not purge.
i. If the Settlement exists, then do no purge.
j. If none of the above is true, then purge this ticket.
Delivery Sheets
a. If this is voided Settlement detail and the Settlement does not exist, then purge.
b. If this is a voided delivery Sheet and the date voided < purge date, then purge.
c. If the Delivery Sheet is not paid, then do not purge.
d. If the date paid > or = purge date, then do not purge.
e. If the Contract exists, then do not purge.
f. If the Settlement exists, then do not purge.
g. If any Scale Ticket Applications exist, then do not purge.
h. If none of the above is true for all the applications, then purge all applications for this Delivery Sheet.
Daily Position Information
a. If the date is less than purge date, then purge.
Warehouse Receipts
a. If the Warehouse Receipt is still active, then do not purge.
b. If the date cancelled > or = purge date, then do not purge.
c. If Delivery Sheets exist for the Receipt, then do not purge.
d. If none of the above is true, then purge this Receipt.
Contract Pricing
a. If the Contract does not exist, then purge.
Contract Remarks and Delivery Schedules
a. If this is a Standard Remarks, then do not purge.
b. If this is not a Standard Remark and the Contract does not exist, then purge.
Scale Ticket Applications
a. If the Ticket does not exist, then purge.
FILES PURGED
GRAIN SETTLEMENTS FILES
SETTLMNT.GRN
CUSTOTAL.GRN
GRNCONT3.GRN
GRNCONT4.GRN
GRNRMRKS.GRN
GRNCONT5.GRN
GRNCONT6.GRN
GRAIN CONTRACTS FILES
CONTRAC1.GRN
CONTRAC2.GRN
GRNCONT3.GRN
GRNCONT4.GRN
GRNCONT5.GRN
GRNCONT6.GRN
GRAIN TICKETS FILES
TICKETS1.GRN
TICKETS2.GRN
GRNTKTS3.GRN
GRNTKTS4.GRN
GRNTKTS5.GRN
GRNCONT3.GRN
GRNCONT4.GRN
GRNRMRKS.GRN
GRNCONT5.GRN
GRNCONT6.GRN
GRAIN DELIVERY SHEETS FILES
DSHEETS1.GRN
DSHEETS2.GRN
GRNCONT3.GRN
GRNRNKS.GRN
GRNCONT4.GRN
GRNCONT5.GRN
GRNCONT6.GRN
GRAIN POSITION FILES
POSITION.GRN
HDGECHGN.GRN
GRNDPRCH.GRN
GRAIN WAREHOUSE RECEIPTS
WHSRECPT.GRN
PEDIMENTO
C61PDMNT.GRN
NAM
*Purging of name/Address only purges Inactive or Temporary Name ID’s.
Due to the small amount of disk space that can be reclaimed, purging name/address is not worth the time investment.
FILES PURGED
NAMEADDR.NAM
RELATION.NAM
COMMENTS.NAM
NAMSPLTS.NAM
NAMLICEN.NAM
SPLGROUP.NAM
N10FARMS.NAM
N11FIELD.NAM
PAY
*Purging Payroll is STRONGLY not recommended.
The amount of disk space recovered is not worth issues that may develop in reporting requirements if needed for audit purposes. But if they are purging Payroll, this option allows you to remove Labor Distribution, Paycheck detail, Employee YTD totals & Employee Information.
All tax reports should be run for purged period.
W-2 Forms should be printed & W-2 Diskette created for purged periods
FILES PURGED
EMPLOYEE.PAY
EMPDEDUC.PAY
EMPTOTAL.PAY
PAYCHECK.PAY
JOBHOURS.PAY
EMPSPLIT.PAY
PAT
FILES PURGED
PRODUCED.PAT
REFUNDED.PAT
PATAUDIT.PAT
SJI
FILES PURGED
SYSTEM JOURNAL ENTRY FILE
SPERIODS.SJI
SYSENTRY.SJI
EXECUTION ID MASTER FILE
SYSEXBUD.SJI
SYSEXMST.SJI
LEDGER DETAIL FILE
§
SYS
FILES PURGED
o SYSTEM DELETED RECORDS FILE
§ TRANSACT.AGR
o SYSTEM ERROR LOG FILE *This will purge all datasets, not just the one you are purging*
§ ERRORLOG.AGR
o SYSTEM ACTIVITY LOG FILE
§ ACTIVITY.AGR
o SYSTEM DOCUMENT TRACKING FILE
§ SYSTRANS.AGR
o SYSTEM LOGIN LOG FILE
§ SYSLOGIN.AGR
o USER OVERRIDE HISTORY FILE
o REPORT STREAM LOG FILE