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=Invoices
2=Orders
3=Both
IINSTRUC  Integer  Include in instructions  List: 4 entries
0=No
1=Invoices
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=Invoices
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 2003-Oct-22

Copyright © 2003 ACCPAC International, Inc. All rights reserved.