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 segmen   
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   
OEAUTOG  Integer  Allow generation of serial numb   
OEAUTOA  Integer  Allow auto-allocation of serial   
OEGREATER  Integer  Allow the transaction quantity   
DUPSERIAL  Integer  Allow the same serial number on   
POTHINGS  Integer  Allocate serial numbers based o   
OETHINGS  Integer  Allocate serial numbers based o   
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 numb  Mask: %-22N
ALWAYSREQ  Integer  Always popup on the quantity sh   
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 l   
NINSTRUC  Integer  Number of serials per instructi   
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  Integer  Use Optional Date 1   
UDATE2  Integer  Use Optional Date 2   
UDATE3  Integer  Use Optional Date 3   
UDATE4  Integer  Use Optional Date 4   
UAMOUNT1  Integer  Use Optional Amount 1   
UAMOUNT2  Integer  Use Optional Amount 2   
UAMOUNT3  Integer  Use Optional Amount 3   
UAMOUNT4  Integer  Use Optional Amount 4   
UTEXT1  Integer  Use Optional Text 1   
UTEXT2  Integer  Use Optional Text 2   
UTEXT3  Integer  Use Optional Text 3   
UTEXT4  Integer  Use Optional Text 4   
UTEXT5  Integer  Use Optional Text 5   
UTEXT6  Integer  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   

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.