IFBCIQUEUE – No description in the Lawson data dictionary

System
General Ledger Setup (IF)
Prefix
BCI
Primary key
DATE, TIME, UNIQUE-I-D
Fields
9
Updated by
18 programs
Referenced by
0 programs

IFBCIQUEUE is a Lawson General Ledger Setup table (prefix BCI); no description in the lawson data dictionary. It is indexed by DATE, TIME, UNIQUE-I-D (BCISET1); alternate indexes: BCISET2 and BCIUID. It is updated by AP10.1, AP10.2, AP510, AP810, IC02.1, IC64.1, IC64.2, IC64.3 and 10 more. The table has 9 fields, 3 indexes and 0 documented relations.

About IFBCIQUEUE

No description in the Lawson data dictionary.

Fields (9)

Column = COBOL field name without the BCI- 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
#BCI-UNIQUE-I-D PK
UNIQUE_I_D
Bad Type 36——
#BCI-PROC-FUNCTION
PROC_FUNCTION
Alpha 1—AP10.1, AP10.2, AP510, AP810, IC02.1, IC64.1, IC64.2, IC64.3 +10 more
#BCI-PROC-NAME
PROC_NAME
Alpha 20—AP10.1, AP10.2, AP510, AP810, IC02.1, IC64.1, IC64.2, IC64.3 +10 more
#BCI-OPERATOR
OPERATOR
Alpha 10This field is used to store the login id of the person who entered the record.AP10.1, AP10.2, AP510, AP810, IC02.1, IC64.1, IC64.2, IC64.3 +10 more
#BCI-DATE PK
DATE
Numeric 8 (yyyymmdd)This field displays the system date when this was created.AP10.1, AP10.2, AP510, AP810, IC02.1, IC64.1, IC64.2, IC64.3 +10 more
#BCI-TIME PK
TIME
Numeric 8This field is updated automatically to indicate the time that the GL entry was created. It is system-maintained.AP10.1, AP10.2, AP510, AP810, IC02.1, IC64.1, IC64.2, IC64.3 +10 more
#BCI-STATUS
STATUS
Numeric 1This field displays the status of the transaction.AP10.1, AP10.2, AP510, AP810, IC02.1, IC64.1, IC64.2, IC64.3 +10 more
#BCI-KEY-VALUE
KEY_VALUE
Alpha 40 Occurs 20 Times ×20—AP10.1, AP10.2, AP510, AP810, IC02.1, IC64.1, IC64.2, IC64.3 +10 more
#BCI-QUEUE-ID SET2
QUEUE_ID
Alpha 4—AP10.1, AP10.2, AP510, AP810, IC02.1, IC64.1, IC64.2, IC64.3 +10 more

Indexes (3)

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
BCISET1
  1. DATE
  2. TIME
  3. UNIQUE-I-D
Primary—
BCISET2
  1. QUEUE-ID
  2. DATE
  3. TIME
  4. UNIQUE-I-D
KeyChange—
BCIUID
  1. UNIQUE-I-D
—

Programs

Updated by (18)