 |
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
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 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 IC28.1
IC300 IC500 IC820 IC90.1 MA180 MA43.9
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.3 MA67.1 MA67.2 MA70.1 MAI1.1 PO100
PO101 PO122 PO131 PO20.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.2
PO33.1 PO34.1 PO35.1 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 POI3.1 POIE.1
POII.1 POIJ.1 RQ10.1 RQ10.2 RQ35.1 WH130
WH132 WH190 WH20.2 WH20.3 WH20.4 WH20.5
WH20.6 WH20.7 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SER-COMPANY Numeric 4 AP125 AP126
Company The company number represents an AP131 AP25.1
established company and is entered on AP25.2 AP26.1
all function codes. AP27.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 IC28.1
IC500 IC820
IC90.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
...
SER-ITEM Alpha 32 AP125 AP126
Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.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 IC28.1
IC500 IC820
IC90.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
...
SER-SERIAL Alpha 16 AP125 AP126
Serial Number This field contains the identification AP131 AP25.1
number for an individual unit. This AP25.2 AP26.1
number is used for tracking purposes. AP27.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 IC28.1
IC500 IC820
IC90.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
...
SER-LOCATION Alpha 5 AP125 AP126
Location Code This field contains a valid stocking AP131 AP25.1
location within the company inventory. AP25.2 AP26.1
AP27.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 IC28.1
IC500 IC820
IC90.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
...
SER-BIN Alpha 7 AP125 AP126
Bin This field contains the storage area AP131 AP25.1
for this serial numbered item, if the AP25.2 AP26.1
item is bin tracked. AP27.1 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 IC28.1
IC500 IC820
IC90.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
...
SER-LAST-REC-DT Numeric 8 (yyyymmdd) AP125 AP126
Last Received Date This field contains the last received AP131 AP25.1
date for this serial number. AP25.2 AP26.1
AP27.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 IC28.1
IC500 IC820
IC90.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
...
SER-LAST-ISSUE-DT Numeric 8 (yyyymmdd) AP125 AP126
Last Issue Date This field contains the last issue date AP131 AP25.1
for this serial number. AP25.2 AP26.1
AP27.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 IC28.1
IC500 IC820
IC90.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
...
SER-STATUS Numeric 1 AP125 AP126
Status This field contains the current status AP131 AP25.1
of this serial number. AP25.2 AP26.1
0 = On Hand AP27.1 IC175
1 = Allocated IC20.1 IC20.2
2 = Intransit IC21.1 IC21.2
3 = Hold IC22.1 IC22.2
9 = Issued IC23.1 IC23.2
IC24.1 IC24.2
IC25.1 IC26.1
IC26.2 IC28.1
IC500 IC820
IC90.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO29.1
PO30.1 PO30.2
PO30.3 PO300
PO31.1 PO31.2
PO32.2 PO33.1
PO34.1 PO35.1
...
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 AP125 AP126
ITEM AP131 AP25.1
SERIAL AP25.2 AP26.1
AP27.1 IC175
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC23.1 IC23.2
IC232 IC24.1
IC24.2 IC25.1
IC26.1 IC26.2
IC28.1 IC29.2
IC300 IC500
IC574 IC74.1
IC820 MA180
...
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
WH20.5 WH33.3
WH34.3 WH520
SERSET3 COMPANY KeyChange, Subset IC29.2 WH130
LOCATION Where STATUS = Zeroes WH20.5 WH33.3
ITEM WH34.3 WH520
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
|