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.

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
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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
DITSET1CUST-GROUP, COMPANY, DATE, CUSTOMER, TIME, SEQ-NBRPrimaryAR301
DITSET2CUST-GROUP, COMPANY, OPERATOR, DATE, CUSTOMER, TIME, SEQ-NBR—
DITSET4CUST-GROUP, COMPANY, CUSTOMER, DATE, TIME, SEQ-NBR—
DITSET5CUST-GROUP, COMPANY, NAME, DATE, TIME, SEQ-NBR, CUSTOMER—

Programs

Updated by (9)