# Table: Inventory Serial Numbers

Table: ICXSER
View: IC0830
Record length: 240
Flags: A R

## Keys: 7

Title | Flags | Fields
--- | --- | ---
Serial/Item |  | SERIALNUM, ITEMNUM
Item/Serial |  | ITEMNUM, SERIALNUM
Item/Location/Status/Reserved fo | D M | ITEMNUM, LOCATION, STATUS, RESVFORORD
Item/Location/Status/Serial | M | ITEMNUM, LOCATION, STATUS, SERIALNUM
Item/Location/Status/Stock Date/ | M | ITEMNUM, LOCATION, STATUS, STOCKDATE, SERIALNUM
Item/Location/Status/Expiry Date | M | ITEMNUM, LOCATION, STATUS, EXPIRYDATE, SERIALNUM
Stock Date/Status/Asset Stock/As | M | STOCKDATE, STATUS, ASSETSTOCK, ITEMNUM, LOCATION, SERIALNUM

## Fields: 36

Field | Type | Title | Presentation
--- | --- | --- | ---
SERIALNUM | String*40 | Unformatted Serial Number |
ITEMNUM | String*24 | Unformatted Item Number | Mask: %-24C
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
LOCATION | String*6 | Location | Mask: %-6N
STATUS | Integer | Status | List: 2 entries
0 | = | Not Available
1 | = | Available
STOCKDATE | Date | Stock Date |
EXPIRYDATE | Date | Expiry Date |
SERIALNUMF | String*40 | Serial Number |
RESVFORORD | Boolean | Reserve For Order | List: 2 entries
0 | = | No
1 | = | Yes
ASSETSTOCK | Integer | Stocked for Costing |
ASSETCOST | BCD*10.3 | Cost for Costing |
CONTCODE | String*6 | Contract Code | Mask: %-6N
VALUES | Long | Optional Fields |
INUSE1 | Boolean | Contract Period 1 In Use | List: 2 entries
0 | = | No
1 | = | Yes
DATE1 | Date | Contract Period 1 Expiry Date |
EFFDATE1 | Date | Contract Period 1 Effective Date |
LIFECONT1 | Boolean | Contract Period 1 Lifetime | List: 2 entries
0 | = | No
1 | = | Yes
INUSE2 | Boolean | Contract Period 2 In Use | List: 2 entries
0 | = | No
1 | = | Yes
DATE2 | Date | Contract Period 2 Expiry Date |
EFFDATE2 | Date | Contract Period 2 Effective Date |
LIFECONT2 | Boolean | Contract Period 2 Lifetime | List: 2 entries
0 | = | No
1 | = | Yes
INUSE3 | Boolean | Contract Period 3 In Use | List: 2 entries
0 | = | No
1 | = | Yes
DATE3 | Date | Contract Period 3 Expiry Date |
EFFDATE3 | Date | Contract Period 3 Effective Date |
LIFECONT3 | Boolean | Contract Period 3 Lifetime | List: 2 entries
0 | = | No
1 | = | Yes
INUSE4 | Boolean | Contract Period 4 In Use | List: 2 entries
0 | = | No
1 | = | Yes
DATE4 | Date | Contract Period 4 Expiry Date |
EFFDATE4 | Date | Contract Period 4 Effective Date |
LIFECONT4 | Boolean | Contract Period 4 Lifetime | List: 2 entries
0 | = | No
1 | = | Yes
INUSE5 | Boolean | Contract Period 5 In Use | List: 2 entries
0 | = | No
1 | = | Yes
DATE5 | Date | Contract Period 5 Expiry Date |
EFFDATE5 | Date | Contract Period 5 Effective Date |
LIFECONT5 | Boolean | Contract Period 5 Lifetime | List: 2 entries
0 | = | No
1 | = | Yes

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.