Lawson Insight Technical Documentation |
|
ITSERIAL
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 WO81.2
IC170 IC42.3 IC44.1
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.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
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA66.3 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MAI1.1 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE111 OE113 OE114
OE116 OE129 OE13.2 OE13.3 OE13.5 OE13.6
OE14.4 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE510 OE530 OE81.1
OE810 OE830 OE90.1 OE90.2 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 WO120
WO132 WO140 WO20.1 WO30.1 WO32.1 WO32.2
WO32.3 WO32.4 WO32.5 WO40.1 WO40.2 WO40.3
WO40.4 WO40.5 WO40.6 WO41.1 WO41.2 WO41.3
WO41.4 WO42.1 WO42.2 WO42.3 WO42.4 WO42.5
WO45.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SER-COMPANY Numeric 4 AP125 AP126
Element: Company Identifies the AP company if the AP131 AP25.1
resource type = V. Identifies the HR AP25.2 AP26.1
company if the resource type = E. It is AP27.1 AP30.4
blank for type A, P or Q resources. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
SER-ITEM Alpha 32 AP125 AP126
Element: Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
SER-SERIAL Alpha 16 AP125 AP126
Element: 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 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
SER-LOCATION Alpha 5 AP125 AP126
Element: Location Code This field contains a valid stocking AP131 AP25.1
location within the company inventory. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
SER-BIN Alpha 7 AP125 AP126
Element: 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 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
...
SER-LAST-REC-DT Numeric 8 (yyyymmdd) AP125 AP126
Element: Last Received This field contains the last received AP131 AP25.1
date for this serial number. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
SER-LAST-ISSUE-DT Numeric 8 (yyyymmdd) AP125 AP126
Element: Last Issue DatThis field contains the last issue date AP131 AP25.1
for this serial number. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
SER-STATUS Numeric 1 AP125 AP126
Element: Status This field contains the current status AP131 AP25.1
of this serial number. AP25.2 AP26.1
0 = On Hand AP27.1 AP30.4
1 = Allocated BL120 BL122
2 = Intransit BL130 BL20.1
3 = Hold BL20.3 BL21.2
9 = Issued BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.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 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
...
SER-KIT-SERIAL Alpha 16 OE30.1 OE30.2
Element: Serial Number This is the serial number of the OE30.3 OE30.4
finished good that was produced using OE30.5 OE30.6
the serial number tracked component. OE30.7 OE30.9
OE530 OE830
WO40.6
SER-KIT-ITEM Alpha 32 OE30.1 OE30.2
Element: Item Number This field contains the item for the OE30.3 OE30.4
serial number tracked finished good that OE30.5 OE30.6
was produced using the serial number OE30.7 OE30.9
tracked component item. OE530 OE830
WO40.6
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 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC175 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC23.1
IC23.2 IC232
...
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 IC44.1 IC500
IC90.1 WH20.5
WH33.3 WH34.3
WH520 WO32.4
WO41.3
SERSET3 COMPANY KeyChange, Subset IC29.2 OE114
LOCATION Where STATUS = Zeroes WH130 WH20.5
ITEM WH33.3 WH34.3
BIN WH520 WO32.4
SERIAL WO41.3
SERSET4 COMPANY KeyChange, Subset WO40.6
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
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
|