ARAUDIT – No description in the Lawson data dictionary

System
Accounts Receivable (AR)
Prefix
DIT
Primary key
CUST-GROUP, COMPANY, DATE, CUSTOMER, TIME, SEQ-NBR
Fields
13
Updated by
9 programs
Referenced by
0 programs

ARAUDIT is a Lawson Accounts Receivable table (prefix DIT); no description in the lawson data dictionary. It is indexed by CUST-GROUP, COMPANY, DATE, CUSTOMER, TIME, SEQ-NBR (DITSET1); alternate indexes: DITSET2, DITSET4 and DITSET5. It is updated by AR09.1, AR09.4, AR10.1, AR12.1, AR12.2, AR17.1, AR301, AR501 and 1 more. The table has 13 fields, 4 indexes and 0 documented relations.

About ARAUDIT

No description in the Lawson data dictionary.

Fields (13)

Column = COBOL field name without the DIT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#DIT-CUST-GROUP PK
CUST_GROUP		Alpha 5Customer group. Used to identify a group of customer associated with one or more companies.AR09.1, AR09.4, AR301, AR501, AR550
#DIT-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.AR10.1, AR12.1, AR12.2, AR17.1, AR501, AR550
#DIT-CUSTOMER PK
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 +1 more
#DIT-DATE PK
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 +1 more
#DIT-TIME PK
TIME		Numeric 8This 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 +1 more
#DIT-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.AR09.1, AR09.4, AR10.1, AR12.1, AR12.2, AR17.1, AR301, AR501 +1 more
#DIT-NAME SET5
NAME		Alpha 30 (Lower Case)Displays the company description.AR09.1, AR09.4, AR10.1, AR550
#DIT-BILL-TO
BILL_TO		Numeric 4This 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 SET2
OPERATOR		Alpha 10This 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 +1 more
#DIT-FIELD-ID
FIELD_ID		Numeric 3This 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 +1 more
#DIT-BEFORE-IMAGE
BEFORE_IMAGE		Alpha 32This field contains the field image before the change.AR09.1, AR09.4, AR10.1, AR12.1, AR12.2, AR17.1, AR550
#DIT-AFTER-IMAGE
AFTER_IMAGE		Alpha 32This field contains the field image before the change.AR09.1, AR09.4, AR10.1, AR12.1, AR12.2, AR17.1, AR550
#DIT-ACTION
ACTION		Alpha 1This 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 +1 more

Indexes (4)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
DITSET1
  1. CUST-GROUP
  2. COMPANY
  3. DATE
  4. CUSTOMER
  5. TIME
  6. SEQ-NBR
PrimaryAR301
DITSET2
  1. CUST-GROUP
  2. COMPANY
  3. OPERATOR
  4. DATE
  5. CUSTOMER
  6. TIME
  7. SEQ-NBR
—
DITSET4
  1. CUST-GROUP
  2. COMPANY
  3. CUSTOMER
  4. DATE
  5. TIME
  6. SEQ-NBR
—
DITSET5
  1. CUST-GROUP
  2. COMPANY
  3. NAME
  4. DATE
  5. TIME
  6. SEQ-NBR
  7. CUSTOMER
—

Programs

Updated by (9)