ARAUDIT

This file contains audit type records for customer changes. Changes are conditionaly tracked based on rules established at the Customer Group, Company, Customer Description, and Customer levels.
UPDATED BY
AR09.1 AR09.4 AR10.1 AR12.1 AR12.2 AR17.1
AR301 AR501 AR550

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DIT-CUST-GROUP
Element: Cust Group		Alpha 5
Customer group. Used to identify a group of customer associated with one or more companies.
AR09.1 AR09.4
AR301 AR501
AR550
DIT-COMPANY
Element: Company		Numeric 4
The number representing an AR company.
AR10.1 AR12.1
AR12.2 AR17.1
AR501 AR550
DIT-CUSTOMER
Element: Customer		Alpha 9 (Right Justified)
This field contains the number that represents a customer.
AR09.1 AR09.4
AR10.1 AR12.1
AR12.2 AR17.1
AR301 AR501
AR550
DIT-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
AR09.1 AR09.4
AR10.1 AR12.1
AR12.2 AR17.1
AR301 AR501
AR550
DIT-TIME
Element: Time		Numeric 8
This field is updated automatically to indicate the time that the GL entry was created. It is system-maintained.
AR09.1 AR09.4
AR10.1 AR12.1
AR12.2 AR17.1
AR301 AR501
AR550
DIT-SEQ-NBR
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
AR09.1 AR09.4
AR10.1 AR12.1
AR12.2 AR17.1
AR301 AR501
AR550
DIT-NAME
Element: Name		Alpha 30 (Lower Case)
Displays the company description.
AR09.1 AR09.4
AR10.1 AR550
DIT-BILL-TO
Element: Bill To		Numeric 4
This field contains the mailing address for the invoice. Bill to addresses are maintained in the Accounts Receviable Bill To form AR09.4.
AR09.4 AR301
AR501
DIT-OPERATOR
Element: Operator		Alpha 10
This field is used to store the login id of the person who entered the record.
AR09.1 AR09.4
AR10.1 AR12.1
AR12.2 AR17.1
AR301 AR501
AR550
DIT-FIELD-ID
Element: Field Id		Numeric 3
This field contains a number representing a customer data field that has changed.
AR09.1 AR09.4
AR10.1 AR12.1
AR12.2 AR17.1
AR301 AR501
AR550
DIT-BEFORE-IMAGE
Element: Before Image		Alpha 32
This field contains the field image before the change.
AR09.1 AR09.4
AR10.1 AR12.1
AR12.2 AR17.1
AR550
DIT-AFTER-IMAGE
Element: Before Image		Alpha 32
This field contains the field image before the change.
AR09.1 AR09.4
AR10.1 AR12.1
AR12.2 AR17.1
AR550
DIT-ACTION
Element: Action		Alpha 1
This field contains the action performed on the associated field or the record. Valid values are: A = Add C = Change D = Delete
AR09.1 AR09.4
AR10.1 AR12.1
AR12.2 AR17.1
AR301 AR501
AR550


ARAUDIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DITSET1 CUST-GROUP
COMPANY
DATE
CUSTOMER
TIME
SEQ-NBR
AR301
DITSET2 CUST-GROUP
COMPANY
OPERATOR
DATE
CUSTOMER
TIME
SEQ-NBR
DITSET4 CUST-GROUP
COMPANY
CUSTOMER
DATE
TIME
SEQ-NBR
DITSET5 CUST-GROUP
COMPANY
NAME
DATE
TIME
SEQ-NBR
CUSTOMER

File created: Wed Jun 08 20:47:53 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.