ITSERIAL – Serial Numbers

System
Inventory Control (IC)
Prefix
SER
Primary key
COMPANY, ITEM, SERIAL
Fields
10
Updated by
244 programs
Referenced by
9 programs

ITSERIAL is the Serial Numbers table in Lawson Inventory Control (prefix SER). It is indexed by COMPANY, ITEM, SERIAL (SERSET1); alternate indexes: SERSET2, SERSET3 and SERSET4. It is related 1:1 to ICCOMPANY, ITEMLOC, ITEMMAST and ICLOCATION. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 236 more and referenced by IC170, IC232, IC29.2, IC42.3, IC44.1, IC574, IC74.1, RQ39.1 and 1 more. The table has 10 fields, 4 indexes and 4 documented relations.

About ITSERIAL

The Serial Numbers file stores the valid serial numbers currently in stock and issued.

Fields (10)

Column = COBOL field name without the SER- 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
#SER-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#SER-ITEM PK
ITEM		Alpha 32This field contains the item identifier.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#SER-SERIAL PK
SERIAL		Alpha 16This field contains the identification number for an individual unit. This number is used for tracking purposes.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#SER-LOCATION SET2 SET3
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#SER-BIN SET3
BIN		Alpha 7This field contains the storage area for this serial numbered item, if the item is bin tracked.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#SER-LAST-REC-DT
LAST_REC_DT		Numeric 8 (yyyymmdd)This field contains the last received date for this serial number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#SER-LAST-ISSUE-DT
LAST_ISSUE_DT		Numeric 8 (yyyymmdd)This field contains the last issue date for this serial number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#SER-STATUS
STATUS		Numeric 1This field contains the current status of this serial number.
  • 0 On Hand
  • 1 Allocated
  • 2 Intransit
  • 3 Hold
  • 9 Issued
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#SER-KIT-SERIAL SET4
KIT_SERIAL		Alpha 16This is the serial number of the finished good that was produced using the serial number tracked component.WHD3.1
#SER-KIT-ITEM SET4
KIT_ITEM		Alpha 32This field contains the item for the serial number tracked finished good that was produced using the serial number tracked component item.WHD3.1

Indexes (4)

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
SERSET1
  1. COMPANY
  2. ITEM
  3. SERIAL
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
SERSET2
  1. COMPANY
  2. LOCATION
  3. ITEM
  4. SERIAL
KeyChange, SubsetWhere STATUS = Zeroes Or STATUS = 1 Or STATUS = 3IC10.2, IC12.1, IC170, IC232, IC26.2, IC330, IC42.3, IC44.1 +6 more
SERSET3
  1. COMPANY
  2. LOCATION
  3. ITEM
  4. BIN
  5. SERIAL
KeyChange, SubsetWhere STATUS = ZeroesIC29.2, WH130, WH20.5, WH33.3, WH34.3, WH520
SERSET4
  1. COMPANY
  2. KIT-ITEM
  3. KIT-SERIAL
  4. ITEM
  5. SERIAL
KeyChange, SubsetWhere KIT-ITEM != Spaces—

Relations

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

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyICCOMPANYRequired
SER-COMPANY→ICC-COMPANY (ICCSET1)
ItemlocITEMLOCRequired
SER-COMPANY→ITL-COMPANY
SER-LOCATION→ITL-LOCATION
SER-ITEM→ITL-ITEM
ItemmastITEMMASTRequired
ICC-ITEM-GROUP→ITE-ITEM-GROUP
SER-ITEM→ITE-ITEM
LocationICLOCATIONRequired
SER-COMPANY→ICL-COMPANY
SER-LOCATION→ICL-LOCATION

Programs

Updated by (244)

Referenced by (9)