AGEUSERONE – No description in the Lawson data dictionary

System
Accounts Receivable (AR)
Prefix
AUO
Primary key
COMPANY, CUSTOMER, TRANS-USER1
Fields
8
Updated by
0 programs
Referenced by
0 programs

AGEUSERONE is a Lawson Accounts Receivable table (prefix AUO); no description in the lawson data dictionary. It is indexed by COMPANY, CUSTOMER, TRANS-USER1 (AUOSET1); alternate indexes: AUOSET2, AUOSET3, AUOSET4 and AUOSET5. The table has 8 fields, 5 indexes and 0 documented relations.

About AGEUSERONE

No description in the Lawson data dictionary.

Fields (8)

Column = COBOL field name without the AUO- 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
#AUO-COMPANY PK
COMPANY		Numeric 4——
#AUO-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)——
#AUO-TRANS-USER1 PK
TRANS_USER1		Alpha 10——
#AUO-STATIC-CUR
STATIC_CUR		Signed 18.2——
#AUO-AGING
AGING		Signed 18.2 Occurs 5 Times ×5——
#AUO-STATUS SET4
STATUS		Numeric 1——
#AUO-DATE SET5
DATE		Numeric 8 (yyyymmdd)——
#AUO-TIME SET5
TIME		Numeric 8——

Indexes (5)

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
AUOSET1
  1. COMPANY
  2. CUSTOMER
  3. TRANS-USER1
Primary—
AUOSET2
  1. CUSTOMER
  2. COMPANY
  3. TRANS-USER1
—
AUOSET3
  1. CUSTOMER
  2. TRANS-USER1
  3. COMPANY
AR09.1, AR09.4, AR10.1, AR11.1, AR12.1, AR12.2, AR13.1, AR13.2 +8 more
AUOSET4
  1. STATUS
  2. CUSTOMER
  3. TRANS-USER1
  4. COMPANY
—
AUOSET5
  1. DATE ↓
  2. TIME
  3. COMPANY
  4. CUSTOMER
  5. TRANS-USER1
—

Programs

No Lawson programs are documented as updating or referencing this table.