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 PO32.2 PO39.1
RQ39.1 WO81.2 IC170 IC42.3
UPDATED BY
BL92.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC10.2 IC116 IC12.1 IC141 IC142 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 IC83.1 IC90.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 OE113 OE114 OE129 OE14.4 OE15.1
OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE810 OE830 OE90.1 OE920
OE950 PO30.1 PO31.1 PO33.1 PO34.1 PO35.1
PO530 RQ10.1 RQ10.3 RQ11.1 RQ12.1 RQ13.1
RQ20.1 RQ35.1 RQ500 RQ961 WH130 WH132
WH190 WH20.1 WH20.2 WH20.3 WH20.4 WH20.5
WH20.6 WH20.7 WH222 WH30.1 WH30.2 WH30.3
WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3
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
WOEX.1 WOSP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SER-COMPANY Numeric 4 BL92.1 CX100
Company The company number represents an CX20.1 CX20.2
established company and is entered on CX20.4 CX20.5
all function codes. CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
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
IC500 IC820
IC83.1 IC90.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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
...
SER-ITEM Alpha 32 BL92.1 CX100
Item Number This field contains the item CX20.1 CX20.2
identifier. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
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
IC500 IC820
IC83.1 IC90.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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
...
SER-SERIAL Alpha 16 BL92.1 CX100
Serial Number This field contains the identification CX20.1 CX20.2
number for an individual unit. This CX20.4 CX20.5
number is used for tracking purposes. CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
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
IC500 IC820
IC83.1 IC90.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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
...
SER-LOCATION Alpha 5 BL92.1 CX100
Location Code This field contains a valid stock CX20.1 CX20.2
location within the company inventory. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
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
IC500 IC820
IC83.1 IC90.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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
...
SER-BIN Alpha 7 BL92.1 CX100
Bin This field contains the storage area CX20.1 CX20.2
for this serial numbered item, if the CX20.4 CX20.5
item is bin tracked. CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC116
IC12.1 IC141
IC142 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 IC500
IC820 IC83.1
IC90.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
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
...
SER-LAST-REC-DT Numeric 8 (yyyymmdd) BL92.1 CX100
Last Received Date This field contains the last received CX20.1 CX20.2
date for this serial number. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
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
IC500 IC820
IC83.1 IC90.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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
...
SER-LAST-ISSUE-DT Numeric 8 (yyyymmdd) BL92.1 CX100
Last Issue Date This field contains the last issue date CX20.1 CX20.2
for this serial number. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
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
IC500 IC820
IC83.1 IC90.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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
...
SER-STATUS Numeric 1 BL92.1 CX100
Status This field contains the current status CX20.1 CX20.2
of this serial number. CX20.4 CX20.5
0 = On Hand CX220 CX30.1
1 = Allocated CX300 CX506
2 = Intransit CXCP.1 DR100
3 = Hold IC141 IC142
9 = Issued 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
IC500 IC820
IC83.1 IC90.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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
...
SER-KIT-SERIAL Alpha 16 OE30.1 OE30.2
Kit Serial 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
OE830 OE950
WO40.6
SER-KIT-ITEM Alpha 32 OE30.1 OE30.2
Kit Item 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. OE830 OE950
WO40.6
ITSERIAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SERSET1 COMPANY BL92.1 CX100
ITEM CX20.1 CX20.2
SERIAL CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC141 IC142
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 IC29.2
...
SERSET2 COMPANY KeyChange, Subset IC10.2 IC116
LOCATION Where STATUS = Zeroes IC12.1 IC170
ITEM Or STATUS = 1 IC232 IC26.2
SERIAL Or STATUS = 3 IC42.3 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
|