 |
Lawson Insight Technical Documentation |
|
ITSERIAL FILE
Serial Numbers
The Serial Numbers file stores the valid serial numbers currently in stock
and issued.
REFERENCED BY
IC232 IC29.2 IC574 IC74.1 RQ39.1 IC170
IC42.3
UPDATED BY
IC10.2 IC12.1 IC175 IC20.1 IC20.2 IC21.1
IC21.2 IC22.1 IC22.2 IC23.1 IC23.2 IC24.1
IC24.2 IC25.1 IC26.1 IC26.2 IC300 IC500
IC820 IC90.1 ICI2.1 POIJ.1 WH130 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SER-COMPANY Numeric 4 IC175 IC20.1
Company The company number represents an IC20.2 IC21.1
established company and is entered on IC21.2 IC22.1
all function codes. IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC820
IC90.1 ICI2.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
SER-ITEM Alpha 32 IC175 IC20.1
Item Number This field contains the item IC20.2 IC21.1
identifier. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC820
IC90.1 ICI2.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
SER-SERIAL Alpha 16 IC175 IC20.1
Serial Number This field contains the identification IC20.2 IC21.1
number for an individual unit. This IC21.2 IC22.1
number is used for tracking purposes. IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC820
IC90.1 ICI2.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
SER-LOCATION Alpha 5 IC175 IC20.1
Location Code This field contains a valid stocking IC20.2 IC21.1
location within the company inventory. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC820
IC90.1 ICI2.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
SER-BIN Alpha 7 IC10.2 IC12.1
Bin This field contains the storage area IC175 IC20.1
for this serial numbered item, if the IC20.2 IC21.1
item is bin tracked. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC820
IC90.1 ICI2.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
SER-LAST-REC-DT Numeric 8 (yyyymmdd) IC175 IC20.1
Last Received Date This field contains the last received IC20.2 IC21.1
date for this serial number. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC820
IC90.1 ICI2.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
SER-LAST-ISSUE-DT Numeric 8 (yyyymmdd) IC175 IC20.1
Last Issue Date This field contains the last issue date IC20.2 IC21.1
for this serial number. IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC500 IC820
IC90.1 ICI2.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
SER-STATUS Numeric 1 IC175 IC20.1
Status This field contains the current status IC20.2 IC21.1
of this serial number. IC21.2 IC22.1
0 = On Hand IC22.2 IC23.1
1 = Allocated IC23.2 IC24.1
2 = Intransit IC24.2 IC25.1
3 = Hold IC26.1 IC26.2
9 = Issued IC500 IC820
IC90.1 ICI2.1
POIJ.1 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
SER-KIT-SERIAL Alpha 16
Kit Serial This is the serial number of the
finished good that was produced using
the serial number tracked component.
SER-KIT-ITEM Alpha 32
Kit Item This field contains the item for the
serial number tracked finished good that
was produced using the serial number
tracked component item.
ITSERIAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SERSET1 COMPANY IC175 IC20.1
ITEM IC20.2 IC21.1
SERIAL IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC232
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC29.2
IC300 IC500
IC574 IC74.1
IC820 ICI2.1
POIJ.1 RQ39.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
...
SERSET2 COMPANY KeyChange, Subset IC10.2 IC12.1
LOCATION Where STATUS = Zeroes IC170 IC232
ITEM Or STATUS = 1 IC26.2 IC42.3
SERIAL Or STATUS = 3 IC500 IC90.1
WH33.3 WH34.3
SERSET3 COMPANY KeyChange, Subset IC29.2 WH130
LOCATION Where STATUS = Zeroes WH33.3 WH34.3
ITEM
BIN
SERIAL
SERSET4 COMPANY KeyChange, Subset
KIT-ITEM Where KIT-ITEM != Spaces
KIT-SERIAL
ITEM
SERIAL
ITSERIAL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company ICCOMPANY Required
SER-COMPANY -> ICC-COMPANY (ICCSET1)
Itemloc ITEMLOC Required
SER-COMPANY -> ITL-COMPANY
SER-LOCATION -> ITL-LOCATION
SER-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
SER-ITEM -> ITE-ITEM
Location ICLOCATION Required
SER-COMPANY -> ICL-COMPANY
SER-LOCATION -> ICL-LOCATION
|