# Table: Serialized Inventory Settings

Table: SNOPT
View: SN0003
Record length: 1470
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Settings |  | DUMMY

## Fields: 92

Field | Type | Title | Presentation
--- | --- | --- | ---
DUMMY | Integer | Dummy |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
MASKYN | Integer | Use Mask |
MASK | String*50 | Serial Number Mask |
INCSEG | Integer | Increasing serial number segment |
QUICKOE | Integer | Quick Post in OE |
QUICKPO | Integer | Quick Post in PO |
CNACT | Integer | Credit note return results in | List: 2 entries
50 | = | Return the serial number to stock
170 | = | Receive the damaged serial number from the customer on RMA
CNACT2 | Integer | Credit note damaged results in | List: 2 entries
60 | = | Return the damaged serial number to stock
170 | = | Receive the damaged serial number from the customer on RMA
POAUTOG | Integer | Allow auto-generation of serial |
POGREATER | Integer | Allow the transaction quantity i |
OEAUTOG | Integer | Allow generation of serial numbe |
OEAUTOA | Integer | Allow auto-allocation of serial |
OEGREATER | Integer | Allow the transaction quantity i |
DUPSERIAL | Integer | Allow the same serial number on |
POTHINGS | Integer | Allocate serial numbers based on |
OETHINGS | Integer | Allocate serial numbers based on |
ONORD | Boolean | Allow allocation serial numbers |
CWARRPER1 | Long | Customer Warranty Period 1 |
CWARRPER2 | Long | Customer Warranty Period 2 |
CWARRPER3 | Long | Customer Warranty Period 3 |
DWARRPER1 | Long | Supplier Warranty Period 1 |
DWARRPER2 | Long | Supplier Warranty Period 2 |
DWARRPER3 | Long | Supplier Warranty Period 3 |
RMAAUTO | Integer | Automatic RMA Numbering |
RMASTART | String*22 | Automatically generate RMA numbe | Mask: %-22N
ALWAYSREQ | Integer | Always popup on the quantity shi |
ICOMMENT | Integer | Include in comments | List: 4 entries
0 | = | No
1 | = | Shipments
2 | = | Orders
3 | = | Both
IINSTRUC | Integer | Include in instructions | List: 4 entries
0 | = | No
1 | = | Shipments
2 | = | Orders
3 | = | Both
NCOMMENT | Integer | Number of serials per comment li |
NINSTRUC | Integer | Number of serials per instructio |
PREC | String*3 | Prefix for comment line |
POSTC | String*3 | Suffix for comment line |
PREI | String*3 | Prefix for instruction line |
POSTI | String*3 | Suffix for instruction line |
USEOESN | Integer | Use the OE serial number field | List: 4 entries
0 | = | No
1 | = | Shipments
2 | = | Orders
3 | = | Both
VERSION | Integer | Tables version |
SHOWBY | Integer | Show By | List: 4 entries
0 | = | Serial Number
1 | = | Stock Date
2 | = | Expiry Date
3 | = | Optional Date 1
SORTBY | Integer | Sort By | List: 2 entries
0 | = | FIFO
1 | = | LIFO
ODATE1 | String*50 | Optional Date 1 |
ODATE2 | String*50 | Optional Date 2 |
ODATE3 | String*50 | Optional Date 3 |
ODATE4 | String*50 | Optional Date 4 |
OAMOUNT1 | String*50 | Optional Amount 1 |
OAMOUNT2 | String*50 | Optional Amount 2 |
OAMOUNT3 | String*50 | Optional Amount 3 |
OAMOUNT4 | String*50 | Optional Amount 4 |
OTEXT1 | String*50 | Optional Text 1 |
OTEXT2 | String*50 | Optional Text 2 |
OTEXT3 | String*50 | Optional Text 3 |
OTEXT4 | String*50 | Optional Text 4 |
OTEXT5 | String*50 | Optional Text 5 |
OTEXT6 | String*50 | Optional Text 6 |
UDATE1 | Boolean | Use Optional Date 1 |
UDATE2 | Boolean | Use Optional Date 2 |
UDATE3 | Boolean | Use Optional Date 3 |
UDATE4 | Boolean | Use Optional Date 4 |
UAMOUNT1 | Boolean | Use Optional Amount 1 |
UAMOUNT2 | Boolean | Use Optional Amount 2 |
UAMOUNT3 | Boolean | Use Optional Amount 3 |
UAMOUNT4 | Boolean | Use Optional Amount 4 |
UTEXT1 | Boolean | Use Optional Text 1 |
UTEXT2 | Boolean | Use Optional Text 2 |
UTEXT3 | Boolean | Use Optional Text 3 |
UTEXT4 | Boolean | Use Optional Text 4 |
UTEXT5 | Boolean | Use Optional Text 5 |
UTEXT6 | Boolean | Use Optional Text 6 |
HEADUNIQ | Integer |  |
PREFIX | Integer | Mask Prefix | List: 13 entries
0 | = | None
1 | = | - Hyphen
2 | = | / Forward slash
3 | = | \ Back slash
4 | = | * Asterisk
5 | = | . Period
6 | = | ( Left parenthesis
7 | = | ) Right parenthesis
8 | = | # Number sign
9 | = | [ Left bracket
10 | = | ] Right bracket
11 | = | { Left brace
12 | = | } Right brace
MASKEG | String*40 | Mask Example |
MASKLEN | Integer | Mask Length |
SEGTYPE1 | Integer | Segment 1 Type | List: 8 entries
0 | = | None
1 | = | Uppercase alphabetic
2 | = | Mixed case alphabetic
3 | = | Uppercase alphanumeric
4 | = | Mixed case alphanumeric
5 | = | Numeric
6 | = | Uppercase printable
7 | = | Mixed case printable
SEGLEN1 | Integer | Segment 1 Length |
SEGSUF1 | Integer | Segment 1 Suffix | List: 13 entries
0 | = | None
1 | = | - Hyphen
2 | = | / Forward slash
3 | = | \ Back slash
4 | = | * Asterisk
5 | = | . Period
6 | = | ( Left parenthesis
7 | = | ) Right parenthesis
8 | = | # Number sign
9 | = | [ Left bracket
10 | = | ] Right bracket
11 | = | { Left brace
12 | = | } Right brace
SEGTYPE2 | Integer | Segment 2 Type | List: 8 entries
0 | = | None
1 | = | Uppercase alphabetic
2 | = | Mixed case alphabetic
3 | = | Uppercase alphanumeric
4 | = | Mixed case alphanumeric
5 | = | Numeric
6 | = | Uppercase printable
7 | = | Mixed case printable
SEGLEN2 | Integer | Segment 2 Length |
SEGSUF2 | Integer | Segment 2 Suffix | List: 13 entries
0 | = | None
1 | = | - Hyphen
2 | = | / Forward slash
3 | = | \ Back slash
4 | = | * Asterisk
5 | = | . Period
6 | = | ( Left parenthesis
7 | = | ) Right parenthesis
8 | = | # Number sign
9 | = | [ Left bracket
10 | = | ] Right bracket
11 | = | { Left brace
12 | = | } Right brace
SEGTYPE3 | Integer | Segment 3 Type | List: 8 entries
0 | = | None
1 | = | Uppercase alphabetic
2 | = | Mixed case alphabetic
3 | = | Uppercase alphanumeric
4 | = | Mixed case alphanumeric
5 | = | Numeric
6 | = | Uppercase printable
7 | = | Mixed case printable
SEGLEN3 | Integer | Segment 3 Length |
SEGSUF3 | Integer | Segment 3 Suffix | List: 13 entries
0 | = | None
1 | = | - Hyphen
2 | = | / Forward slash
3 | = | \ Back slash
4 | = | * Asterisk
5 | = | . Period
6 | = | ( Left parenthesis
7 | = | ) Right parenthesis
8 | = | # Number sign
9 | = | [ Left bracket
10 | = | ] Right bracket
11 | = | { Left brace
12 | = | } Right brace
SEGTYPE4 | Integer | Segment 4 Type | List: 8 entries
0 | = | None
1 | = | Uppercase alphabetic
2 | = | Mixed case alphabetic
3 | = | Uppercase alphanumeric
4 | = | Mixed case alphanumeric
5 | = | Numeric
6 | = | Uppercase printable
7 | = | Mixed case printable
SEGLEN4 | Integer | Segment 4 Length |
SEGSUF4 | Integer | Segment 4 Suffix | List: 13 entries
0 | = | None
1 | = | - Hyphen
2 | = | / Forward slash
3 | = | \ Back slash
4 | = | * Asterisk
5 | = | . Period
6 | = | ( Left parenthesis
7 | = | ) Right parenthesis
8 | = | # Number sign
9 | = | [ Left bracket
10 | = | ] Right bracket
11 | = | { Left brace
12 | = | } Right brace
SEGTYPE5 | Integer | Segment 5 Type | List: 8 entries
0 | = | None
1 | = | Uppercase alphabetic
2 | = | Mixed case alphabetic
3 | = | Uppercase alphanumeric
4 | = | Mixed case alphanumeric
5 | = | Numeric
6 | = | Uppercase printable
7 | = | Mixed case printable
SEGLEN5 | Integer | Segment 5 Length |
SEGSUF5 | Integer | Segment 5 Suffix | List: 13 entries
0 | = | None
1 | = | - Hyphen
2 | = | / Forward slash
3 | = | \ Back slash
4 | = | * Asterisk
5 | = | . Period
6 | = | ( Left parenthesis
7 | = | ) Right parenthesis
8 | = | # Number sign
9 | = | [ Left bracket
10 | = | ] Right bracket
11 | = | { Left brace
12 | = | } Right brace
CFORM | String*240 | Comments Format |
IFORM | String*240 | Instructions Format |
SHOWCOST | Integer | Display the serial cost during o |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.