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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
BCI-UNIQUE-I-D PKUNIQUE_I_D | Bad Type 36 | — | — |
BCI-PROC-FUNCTIONPROC_FUNCTION | Alpha 1 | — | AP10.1, AP10.2, AP510, AP810, IC02.1, IC64.1, IC64.2, IC64.3 +10 more |
BCI-PROC-NAMEPROC_NAME | Alpha 20 | — | AP10.1, AP10.2, AP510, AP810, IC02.1, IC64.1, IC64.2, IC64.3 +10 more |
BCI-OPERATOROPERATOR | Alpha 10 | This 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 PKDATE | 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 PKTIME | Numeric 8 | This 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-STATUSSTATUS | Numeric 1 | This 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-VALUEKEY_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-IDQUEUE_ID | Alpha 4 | — | AP10.1, AP10.2, AP510, AP810, IC02.1, IC64.1, IC64.2, IC64.3 +10 more |
Indexes (3)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
BCISET1 | DATE, TIME, UNIQUE-I-D | Primary | — | |
BCISET2 | QUEUE-ID, DATE, TIME, UNIQUE-I-D | KeyChange | — | |
BCIUID | UNIQUE-I-D | — |
Programs
Updated by (18)
- AP10.1 Vendor
- AP10.2 Vendor Location
- AP510 Vendor Conversion
- AP810 Retail Vendor Export
- IC02.1 Location
- IC64.1 Global Location Nbr Assignment GL/IC Company
- IC64.2 Global Location Nbr Assignment IC Location
- IC64.3 Global Location Number Assignment RQ Location
- IC64.4 Global Location Number Assignment Manuf Code
- IC64.5 Global Location Number Assignment Manuf Div
- IC64.6 Global Location Number Assignment Vendor
- IC64.7 Global Location Number Assignment Vendor Location
- IC64.8 Global Location Number Assignment IC Bin
- IC64.9 Global Location Number Assignment Buyer
- IC802 Locations to LRO via BCI
- IC81.1 Cart, Par Location
- IC840 Cart Par Location Conversion
- MAI1.1 Invoke for MAMATCH Object