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.