CBTRANSAUD – No description in the Lawson data dictionary

System
Cash Ledger (CB)
Prefix
CAU
Primary key
BANK-INST-CODE, TRANS-IDENT, UNIQUE-I-D
Fields
19
Updated by
32 programs
Referenced by
3 programs

CBTRANSAUD is a Lawson Cash Ledger table (prefix CAU); no description in the lawson data dictionary. It is indexed by BANK-INST-CODE, TRANS-IDENT, UNIQUE-I-D (CAUSET1); alternate indexes: CAUSET2, CAUSET3, CAUSET4, CAUSET5, CAUSET6 and CAUUID. It is related 1:1 to CBTRANS. It is updated by AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 and 24 more and referenced by CB00.2, CB95.1 and CB95.2. The table has 19 fields, 7 indexes and 1 documented relation.

About CBTRANSAUD

No description in the Lawson data dictionary.

Fields (19)

Column = COBOL field name without the CAU- 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
#CAU-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
#CAU-CASH-CODE SET2 SET3 SET4 SET5 SET6
CASH_CODE		Alpha 4—AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
#CAU-BANK-INST-CODE PK
BANK_INST_CODE		Alpha 3—AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
#CAU-BANK-INST-TYPE
BANK_INST_TYPE		Alpha 1—AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
#CAU-TRANS-NBR SET3 SET4
TRANS_NBR		Alpha 10 (Right Justified)—AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
#CAU-SUFFIX
SUFFIX		Numeric 3—AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
#CAU-TRANS-IDENT PK
TRANS_IDENT		Numeric 10—AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
#CAU-COMPANY SET5 SET6
COMPANY		Numeric 4—AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
#CAU-VENDOR SET4 SET6
VENDOR		Alpha 9 (Right Justified)—AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
#CAU-CUSTOMER SET5 SET6
CUSTOMER		Alpha 9 (Right Justified)—AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
#CAU-EMPLOYEE SET6
EMPLOYEE		Numeric 9—AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
#CAU-APPROVER
APPROVER		Alpha 30—AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
#CAU-OPERATOR SET2 SET3 SET4 SET5
OPERATOR		Alpha 10—AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
#CAU-PERIOD-DATE
PERIOD_DATE		Numeric 8 (yyyymmdd)—AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
#CAU-MAINT-DATE SET2 SET3 SET4 SET5 SET6
MAINT_DATE		Numeric 8 (yyyymmdd)—AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
#CAU-MAINT-TIME
MAINT_TIME		Numeric 6 (hhmmss)—AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
#CAU-TRANS-DATE
TRANS_DATE		Numeric 8 (yyyymmdd)——
#CAU-TRANS-TIME
TRANS_TIME		Numeric 6 (hhmmss)——
#CAU-REC-STATUS SET2 SET3 SET5 SET6
REC_STATUS		Numeric 1—AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more

Indexes (7)

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
CAUSET1
  1. BANK-INST-CODE
  2. TRANS-IDENT
  3. UNIQUE-I-D
Primary, KeyChange—
CAUSET2
  1. OPERATOR
  2. MAINT-DATE
  3. CASH-CODE
  4. BANK-INST-CODE
  5. TRANS-IDENT
  6. REC-STATUS
  7. UNIQUE-I-D
KeyChangeCB295, CB95.2
CAUSET3
  1. CASH-CODE
  2. MAINT-DATE
  3. OPERATOR
  4. BANK-INST-CODE
  5. TRANS-NBR
  6. TRANS-IDENT
  7. REC-STATUS
  8. UNIQUE-I-D
KeyChangeCB00.2, CB295, CB305, CB95.1
CAUSET4
  1. VENDOR
  2. MAINT-DATE
  3. OPERATOR
  4. BANK-INST-CODE
  5. CASH-CODE
  6. TRANS-NBR
  7. TRANS-IDENT
  8. UNIQUE-I-D
—
CAUSET5
  1. CUSTOMER
  2. MAINT-DATE
  3. OPERATOR
  4. CASH-CODE
  5. COMPANY
  6. BANK-INST-CODE
  7. TRANS-IDENT
  8. REC-STATUS
  9. UNIQUE-I-D
KeyChange—
CAUSET6
  1. COMPANY
  2. VENDOR
  3. CUSTOMER
  4. EMPLOYEE
  5. MAINT-DATE
  6. REC-STATUS
  7. BANK-INST-CODE
  8. TRANS-IDENT
  9. CASH-CODE
  10. UNIQUE-I-D
KeyChange—
CAUUID
  1. UNIQUE-I-D
CB305

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
CBTRANSCBTRANSAUD

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CbtransCBTRANSRequired
CAU-BANK-INST-CODE→CBT-BANK-INST-CODE
CAU-TRANS-IDENT→CBT-TRANS-IDENT

Programs

Updated by (32)

Referenced by (3)