MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Technical Library > Financial > Accounts Receivable > Programs > Data Base Audit/Purge - Purpose > Data Base Audit/Purge - Files

Data Base Audit/Purge - Files

AR770P


Number


Description

Record Format

Built
Over

File
Access

ARCUSTL1

Customer File

AR001
AR002

ARCUSTP
ARADDRP

Update

ARCUSTL5

Open Item and Payment Headers Including Changes

AR106
AR107

AROPENP
ARPMNTP

Update

ARCUSTL7

Accounts Receivable Transactions for DB Audit

AR001
AR002
AR003
AR004
AR006
AR005
AR115

ARCUSTP
ARADDRP
AROPENP
ARDISTP
ARAPPLP
ARPMNTP
ARAPPLP

Input

AR640M

Bill-To/Ship-To Customer Relationship Master File

AR042

 

Update

AR640ML1

Bill-To/Ship-To Customer Relationship by Co/Loc

AR042

AR640M

Update

ARDDUCP

Deduction Master File

AR199

 

Update

ARDSCP

Open Item Discount Detail File

AR046

 

Update

ARLOGP

Activity Log

AR012

 

Output

ARLOTP

Invoice Lot Master File

AR023

 

Update

AROPENL1

Open Item

AR003
AR004
AR008
AR116

AROPENP
ARDISTP
ARCMTSP
ARAPPLP

Update

ARPMNTL1

Payment File

AR005
AR006

ARPMNTP
ARAPPLP

Update

DMDRFP

Draft Master File

M1286

 

Update

DMBKRM

Bank Remittance

M1289

 

Update

DMDRFLP1

Draft Master File

M1286

 

Update

IC190BL2

Sales Order Shipment/Returns
Audit Trail

R0527

IC190BP

Input

IC190BL3

Sales Order Shipment/Returns
Audit Trail

R0527

IC190BP

Input

REFERP

Reference File

CF002M
CF002

REFERPM
REFERPS

Input