FBTRANSAU – Budget Transactions Audit

System
General Ledger (GL)
Prefix
FTA
Primary key
COMPANY, FISCAL-YEAR, BUDGET-NBR, JE-TYPE, CONTROL-GROUP, LINE-NBR, ACTION, DATE, TIME, UNIQUE-I-D
Fields
16
Updated by
40 programs
Referenced by
109 programs

FBTRANSAU is the Budget Transactions Audit table in Lawson General Ledger (prefix FTA). It is indexed by COMPANY, FISCAL-YEAR, BUDGET-NBR, JE-TYPE, CONTROL-GROUP, LINE-NBR, ACTION, DATE, TIME, UNIQUE-I-D (FTASET1); alternate indexes: FTASET2, FTASET3, FTASET4, FTASET5 and FTAUID. It is related 1:1 to FBTRANS. It is updated by CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 and 32 more and referenced by AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 101 more. The table has 16 fields, 6 indexes and 1 documented relation.

About FBTRANSAU

No description in the Lawson data dictionary.

Fields (16)

Column = COBOL field name without the FTA- 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
#FTA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
#FTA-COMPANY PK
COMPANY		Numeric 4—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
#FTA-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
#FTA-BUDGET-NBR PK
BUDGET_NBR		Numeric 3—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
#FTA-JE-TYPE PK
JE_TYPE		Alpha 1—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
#FTA-CONTROL-GROUP PK
CONTROL_GROUP		Numeric 8—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
#FTA-LINE-NBR PK
LINE_NBR		Numeric 6—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
#FTA-ACTION PK
ACTION		Alpha 1—
  • A Add
  • C Change
  • D Delete
CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
#FTA-OPERATOR SET3
OPERATOR		Alpha 10—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
#FTA-DATE PK
DATE		Numeric 8 (yyyymmdd)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
#FTA-TIME PK
TIME		Numeric 6 (hhmmss)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
#FTA-PROGRAM
PROGRAM		Alpha 5—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
#FTA-FIELD-NAME
FIELD_NAME		Alpha 20 (Lower Case)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
#FTA-FIELD-ID
FIELD_ID		Numeric 3—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
#FTA-OLD-VALUE
OLD_VALUE		Alpha 60 (Lower Case)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
#FTA-NEW-VALUE
NEW_VALUE		Alpha 60 (Lower Case)—CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more

Indexes (6)

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
FTASET1
  1. COMPANY
  2. FISCAL-YEAR
  3. BUDGET-NBR
  4. JE-TYPE
  5. CONTROL-GROUP
  6. LINE-NBR
  7. ACTION
  8. DATE
  9. TIME
  10. UNIQUE-I-D
PrimaryAC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
FTASET2
  1. COMPANY
  2. FISCAL-YEAR
  3. JE-TYPE
  4. BUDGET-NBR
  5. CONTROL-GROUP
  6. LINE-NBR
  7. ACTION
  8. DATE
  9. TIME
  10. UNIQUE-I-D
—
FTASET3
  1. OPERATOR
  2. ACTION
  3. DATE
  4. COMPANY
  5. FISCAL-YEAR
  6. BUDGET-NBR
  7. JE-TYPE
  8. CONTROL-GROUP
  9. LINE-NBR
  10. UNIQUE-I-D
—
FTASET4
  1. ACTION
  2. DATE
  3. COMPANY
  4. FISCAL-YEAR
  5. BUDGET-NBR
  6. JE-TYPE
  7. CONTROL-GROUP
  8. LINE-NBR
  9. UNIQUE-I-D
—
FTASET5
  1. DATE
  2. COMPANY
  3. ACTION
  4. FISCAL-YEAR
  5. BUDGET-NBR
  6. JE-TYPE
  7. CONTROL-GROUP
  8. LINE-NBR
  9. UNIQUE-I-D
FB305
FTAUID
  1. UNIQUE-I-D
—

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
FbtransFBTRANSRequired
FTA-COMPANY→FLT-COMPANY (FLTSET2)
FTA-FISCAL-YEAR→FLT-FISCAL-YEAR
FTA-BUDGET-NBR→FLT-BUDGET-NBR
FTA-JE-TYPE→FLT-JE-TYPE
FTA-CONTROL-GROUP→FLT-CONTROL-GROUP
FTA-LINE-NBR→FLT-LINE-NBR

Programs

Updated by (40)

Referenced by (109)