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