ITSERIAL

Serial Numbers

The Serial Numbers file stores the valid serial numbers currently in stock and issued.

REFERENCED BY
IC29.2 IC574 IC74.1 RQ39.1 WHD2.1


UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 API2.1
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 DR100 IC10.2
IC12.1 IC140 IC170 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
IC300 IC330 IC42.3 IC44.1 IC500 IC66.1
IC820 IC83.1 IC90.1 MA180 MA41.1 MA41.2
MA41.4 MA41.7 MA42.2 MA43.2 MA43.7 MA44.1
MA44.2 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PO100
PO101 PO122 PO131 PO136 PO150 PO190
PO20.1 PO20.6 PO20.9 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO23.1
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO27.2
PO28.2 PO29.1 PO30.1 PO30.2 PO30.3 PO30.4
PO300 PO31.1 PO31.2 PO32.2 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
PO54.5 POCP.1 POI3.1 POID.1 POII.1 POIJ.1
RQ10.1 RQ10.2 RQ10.4 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ500 RQIF.1 WH130 WH132 WH190
WH20.2 WH20.3 WH20.4 WH20.5 WH20.6 WH20.7
WH222 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH32.5 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 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SER-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
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 IC66.1
IC820 IC83.1
IC90.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
SER-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
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 IC66.1
IC820 IC83.1
IC90.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
SER-SERIAL
Element: Serial
Alpha 16
This field contains the identification number for an individual unit. This number is used for tracking purposes.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
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 IC66.1
IC820 IC83.1
IC90.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
SER-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
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 IC66.1
IC820 IC83.1
IC90.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
SER-BIN
Element: Bin
Alpha 7
This field contains the storage area for this serial numbered item, if the item is bin tracked.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC10.2
IC12.1 IC140
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
IC330 IC500
IC66.1 IC820
IC83.1 IC90.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
SER-LAST-REC-DT
Element: Last Rec Dt
Numeric 8 (yyyymmdd)
This field contains the last received date for this serial number.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
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 IC66.1
IC820 IC83.1
IC90.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
SER-LAST-ISSUE-DT
Element: Last Issue Dt
Numeric 8 (yyyymmdd)
This field contains the last issue date for this serial number.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
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 IC66.1
IC820 IC83.1
IC90.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
SER-STATUS
Element: Status
Numeric 1
This field contains the current status of this serial number.
0 = On Hand
1 = Allocated
2 = Intransit
3 = Hold
9 = Issued
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
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 IC66.1
IC820 IC83.1
IC90.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
SER-KIT-SERIAL
Element: Serial
Alpha 16
This is the serial number of the finished good that was produced using the serial number tracked component.
WHD3.1
SER-KIT-ITEM
Element: Item
Alpha 32
This field contains the item for the serial number tracked finished good that was produced using the serial number tracked component item.
WHD3.1


ITSERIAL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SERSET1 COMPANY
ITEM
SERIAL
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
SERSET2 COMPANY
LOCATION
ITEM
SERIAL
KeyChange, Subset
WhereSTATUS =Zeroes
OrSTATUS =1
OrSTATUS =3
IC10.2 IC12.1
IC170 IC232
IC26.2 IC330
IC42.3 IC44.1
IC500 IC90.1
WH20.5 WH33.3
WH34.3 WH520
SERSET3 COMPANY
LOCATION
ITEM
BIN
SERIAL
KeyChange, Subset
WhereSTATUS =Zeroes
IC29.2 WH130
WH20.5 WH33.3
WH34.3 WH520
ZW130
SERSET4 COMPANY
KIT-ITEM
KIT-SERIAL
ITEM
SERIAL
KeyChange, Subset
WhereKIT-ITEM !=Spaces


ITSERIAL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:17:25 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.