AMBARCODE – Bar Code

System
Asset Management (AM)
Prefix
BCO
Primary key
BAR-CODE
Fields
4
Updated by
1 program
Referenced by
0 programs

AMBARCODE is the Bar Code table in Lawson Asset Management (prefix BCO). It is indexed by BAR-CODE (BCOSET1); alternate indexes: BCOSET3. It is updated by AM153. The table has 4 fields, 2 indexes and 0 documented relations.

About AMBARCODE

No description in the Lawson data dictionary.

Fields (4)

Column = COBOL field name without the BCO- 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
#BCO-BAR-CODE PK
BAR_CODE
Alpha 30This field contains a unique bar code.AM153
#BCO-ASSET
ASSET
Numeric 10If a bar code is assigned to an asset, this field contains the asset number.AM153
#BCO-SEQ-NUMBER
SEQ_NUMBER
Numeric 6This field contains a system-generated sequence number used to keep each bar code record unique.AM153
#BCO-STATUS
STATUS
Numeric 1This field contains the status of the bar code. A bar code requested for printing but not associated with an asset has a status of Reserved. A bar code associated with an added asset has a status of Assigned.AM153

Indexes (2)

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
BCOSET1
  1. BAR-CODE
Primary
BCOSET3
  1. BAR-CODE
AM153

Programs

Updated by (1)