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.