ITSERIAL

Serial Numbers

The Serial Numbers file stores the valid serial numbers currently in stock and issued.
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
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POII.1
POIJ.1

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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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.
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.


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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
SERSET2 COMPANY
LOCATION
ITEM
SERIAL
KeyChange, Subset
WhereSTATUS =Zeroes
OrSTATUS =1
OrSTATUS =3
SERSET3 COMPANY
LOCATION
ITEM
BIN
SERIAL
KeyChange, Subset
WhereSTATUS =Zeroes
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: Wed Jun 08 20:49:40 2016

Home
Contact Us



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