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 WHD2.1
WO81.2 IC170 IC42.3 IC44.1
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.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 IC330 IC500
IC820 IC90.1 MA180 MA41.2 MA41.7 MA43.1
MA43.2 MA43.3 MA43.9 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 PO100
PO101 PO122 PO131 PO20.1 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO23.1 PO25.1
PO25.5 PO25.6 PO25.7 PO27.2 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.2
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 POI3.1 POII.1 POIJ.1 RQ10.1 RQ10.2
RQ10.3 RQ35.1 RQIE.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 WHD3.1 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 The company number represents an AP131 AP20.1
established company and is entered on AP20.2 AP20.3
all function codes. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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 PO100
PO101 PO122
PO131 PO20.1
...
SER-ITEM Alpha 32 AP125 AP126
Element: Item Number This field contains the item AP131 AP20.1
identifier. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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 PO100
PO101 PO122
PO131 PO20.1
...
SER-SERIAL Alpha 16 AP125 AP126
Element: Serial Number This field contains the identification AP131 AP20.1
number for an individual unit. This AP20.2 AP20.3
number is used for tracking purposes. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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 PO100
PO101 PO122
PO131 PO20.1
...
SER-LOCATION Alpha 5 AP125 AP126
Element: Location Code This field contains a valid stocking AP131 AP20.1
location within the company inventory. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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 PO100
PO101 PO122
PO131 PO20.1
...
SER-BIN Alpha 7 AP125 AP126
Element: Bin This field contains the storage area AP131 AP20.1
for this serial numbered item, if the AP20.2 AP20.3
item is bin tracked. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 IC330
IC500 IC820
IC90.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
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
PO100 PO101
...
SER-LAST-REC-DT Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field contains the last received AP131 AP20.1
date for this serial number. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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 PO100
PO101 PO122
PO131 PO20.1
...
SER-LAST-ISSUE-DT Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This field contains the last issue date AP131 AP20.1
for this serial number. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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 PO100
PO101 PO122
PO131 PO20.1
...
SER-STATUS Numeric 1 AP125 AP126
Element: Status This field contains the current status AP131 AP20.1
of this serial number. AP20.2 AP20.3
0 = On Hand AP20.4 AP20.5
1 = Allocated AP20.7 AP23.1
2 = Intransit AP25.1 AP25.2
3 = Hold AP26.1 AP27.1
9 = Issued AP30.4 API1.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 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 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 PO100
PO101 PO122
PO131 PO20.1
...
SER-KIT-SERIAL Alpha 16 WO40.6
Element: Serial Number This is the serial number of the
finished good that was produced using
the serial number tracked component.
SER-KIT-ITEM Alpha 32 WO40.6
Element: Item Number 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 AP20.1
SERIAL AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.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
...
SERSET2 COMPANY KeyChange, Subset IC10.2 IC12.1
LOCATION Where STATUS = Zeroes IC170 IC232
ITEM Or STATUS = 1 IC26.2 IC330
SERIAL Or STATUS = 3 IC42.3 IC44.1
IC500 IC90.1
WH20.5 WH33.3
WH34.3 WH520
WO32.4 WO41.3
SERSET3 COMPANY KeyChange, Subset IC29.2 WH130
LOCATION Where STATUS = Zeroes WH20.5 WH33.3
ITEM WH34.3 WH520
BIN WO32.4 WO41.3
SERIAL
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
|