# Table: Items

Table: SNITEM
View: SN0002
Record length: 1141
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Item Number Unformatted |  | ITEMNUM

## Fields: 44

Field | Type | Title | Presentation
--- | --- | --- | ---
ITEMNUM | String*24 | Item Number Unformatted |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
ITEMNUMF | String*24 | Item Number |
DESC | String*75 | Description |
COMMENT1 | String*75 | Comment 1 |
COMMENT2 | String*75 | Comment 2 |
COMMENT3 | String*75 | Comment 3 |
COMMENT4 | String*75 | Comment 4 |
ODATE1 | Integer | Optional Date 1 |
ODATE2 | Integer | Optional Date 2 |
ODATE3 | Integer | Optional Date 3 |
ODATE4 | Integer | Optional Date 4 |
OAMT1 | BCD*10.6 | Optional Amount 1 |
OAMT2 | BCD*10.6 | Optional Amount 2 |
OAMT3 | BCD*10.6 | Optional Amount 3 |
OAMT4 | BCD*10.6 | Optional Amount 4 |
OTEXT1 | String*2 | Optional Text 1 |
OTEXT2 | String*4 | Optional Text 2 |
OTEXT3 | String*6 | Optional Text 3 |
OTEXT4 | String*15 | Optional Text 4 |
OTEXT5 | String*30 | Optional Text 5 |
OTEXT6 | String*75 | Optional Text 6 |
CUSTWAR1 | Integer | Days in Warranty Period 1 |
CUSTWAR2 | Integer | Days in Warranty Period 2 |
CUSTWAR3 | Integer | Days in Warranty Period 3 |
SUPPWAR1 | Integer | Days in Contract Period 1 |
SUPPWAR2 | Integer | Days in Contract Period 2 |
SUPPWAR3 | Integer | Days in Contract Period 3 |
CWDESC1 | String*75 | Warranty Period 1 |
CWDESC2 | String*75 | Warranty Period 2 |
CWDESC3 | String*75 | Warranty Period 3 |
SWDESC1 | String*75 | Contract Period 1 |
SWDESC2 | String*75 | Contract Period 2 |
SWDESC3 | String*75 | Contract Period 3 |
ONWAR | Boolean | On Warranty when Sold |
ONCTT | Boolean | On Contract when Received |
ONREG | Boolean | On Warranty when Reg Received |
AUTOREC | Boolean | Auto Receive Serial Nums in PO? |
STARTSER | String*40 | Starting Serial Number |
AUTOSHIP | Boolean | Auto Ship Serial Nums in OE? |
EXPIRYDATE | Integer | Number of days to expire or 999 |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.