General Information

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.

For more information on purging (checklists, how-to, etc): https://culturatech.atlassian.net/wiki/spaces/ACD/pages/1281851411.

For more information on historical datasets: https://culturatech.atlassian.net/wiki/spaces/ACD/pages/3693248526.

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.
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

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