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 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).