Table: Serial Numbers

Table: SNUMBER
View: SN0001
Record length: 1529
Flags: A R 

Keys: 11

Title  Flags  Fields

Serial/ItemNumbers   SERIALNUM, ITEMNUM
Item/Serial   D M  ITEMNUM, SERIALNUM
Custno/Item/Serial   D M  CUSTNO, ITEMNUM, SERIALNUM
Vendno/Item/Serial   D M  VENDNO, ITEMNUM, SERIALNUM
Location/Item/Serial   D M  LOCATION, ITEMNUM, SERIALNUM
Item/Loc/Status/Stockdate/Ser.   D M  ITEMNUM, LOCATION, STATUS, STOCKDATE, SERIALNUM
Item/Loc/Status/Expiry/Ser.   D M  ITEMNUM, LOCATION, STATUS, EXPIRYDATE, SERIALNUM
Item/Loc/Status/Opt.Date/Ser.   D M  ITEMNUM, LOCATION, STATUS, ODATE1, SERIALNUM
Status/Item/Serial   D M  STATUS, ITEMNUM, SERIALNUM
RMA   D M  RMANUM
Item/Location/Status/Serial   D M  ITEMNUM, LOCATION, STATUS, SERIALNUM

Fields: 77

Field  Type  Title  Presentation 

SERIALNUM  String*40  Serial Number Unformatted  Mask: %-40c
ITEMNUM  String*24  Item Number Unformatted  Mask: %-24C
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
TRANSDATE  Date  Sold Date/Date Committed   
DOCNUM  String*22  Last Document  Mask: %-22C
CUSTNO  String*12  Customer Number  Mask: %-12C
CUSTNAME  String*60  Customer Name   
VENDNO  String*12  Vendor Number  Mask: %-12C
VENDNAME  String*60  Vendor Name   
RMACUST  String*12  SI Customer Number   
RMACNAME  String*60  SI Customer Name   
DESC  String*75  Description   
NOTE  String*6  Note   
SOURCECUR  String*3  Source Currency - Selling Price   
RATEOPER  Integer  Rate Operation - Selling Price  List: 2 entries
1=Multiply
2=Divide
RATE  BCD*8.7  Rate - Selling Price   
CATEGORY  String*6  Category  Mask: %-6N
LOCATION  String*6  Location  Mask: %-6N
SERIALNUMF  String*40  Serial Number  Mask: %-40c
ITEMNUMF  String*24  Item Number  Mask: %-24C
STOCKDATE  Date  Stock Date   
EXPIRYDATE  Date  Expiry Date   
ACTDATE  Date  Last Activity Date   
ACTTIME  Time  Last Activity Time   
ADTCOST  BCD*10.4  Additional Cost in Functional   
UNITCOST  BCD*10.4  Unit Cost in Functional   
TRANSCOST  BCD*10.4  Transfer Cost in Functional   
COST  BCD*10.4  Total Cost   
PRICE  BCD*10.2  Source Price   
SPRICE  BCD*10.2  Price in Functional   
LASTHIST  Long  Last Transaction Number   
STATUS  Integer  Master Status  List: 11 entries
0=No change
10=Not available
20=BOM
30=On purchase order
40=Available
50=On order
60=Sold
70=RMA - pending
80=RMA - received customer
90=RMA - sent offsite
100=RMA - received vendor
TRANSTYPE  Integer  Transaction Type  List: 28 entries
0=Not Available
20=Receive the serial number into stock
30=Commit the serial number to a customer
40=Invoice the serial number
50=Return the serial number to stock
60=Return the damaged serial number to stock
70=Price adjustment to a serial number
80=Return the serial number to the supplier
90=Transfer the serial number between locations
100=Create a master serial number during an assembly
101=Disassemble a master serial number
110=Place the component serial number on an assembly
111=Retrieve the component serial number from a disassembly
120=Add the serial number through adjustments
130=Remove the serial number through adjustments
140=Add the serial number through inventory worksheet
150=Remove the serial number through inventory worksheet
160=Issue an RMA number to a customer
170=Receive the damaged serial number from the customer on RMA
180=Send the serial number back to the supplier on RMA
190=Receive the fixed serial number back from the supplier on RMA
200=Send the fixed serial number back to the customer on RMA
210=Send the fixed serial number back to stock
220=Replace a damaged serial number with one from available stock
230=Update the Warranty information on a serial number
240=Update the Contract Information on a serial number
250=Update the Registration information on a serial number
251=Change the serial cost through adjustments
REFERENCE  String*60  Reference   
ONWAR  Boolean  On Warranty   
WARSDATE1  Date  Warranty Start Date 1   
WAREDATE1  Date  Warranty End Date 1   
WARDESC1  String*75  Warranty Description 1   
WARSDATE2  Date  Warranty Start Date 2   
WAREDATE2  Date  Warranty End Date 2   
WARDESC2  String*75  Warranty Description 2   
WARSDATE3  Date  Warranty Start Date 3   
WAREDATE3  Date  Warranty End Date 3   
WARDESC3  String*75  Warranty Description 3   
ONCTT  Boolean  On Contract   
CTTSDATE1  Date  Contract Start Date 1   
CTTEDATE1  Date  Contract End Date 1   
CTTDESC1  String*75  Contract Description 1   
CTTSDATE2  Date  Contract Start Date 2   
CTTEDATE2  Date  Contract End Date 2   
CTTDESC2  String*75  Contract Description 2   
CTTSDATE3  Date  Contract Start Date 3   
CTTEDATE3  Date  Contract End Date 3   
CTTDESC3  String*75  Contract Description 3   
REGISTERED  Boolean  Registration Received   
REGDATE  Date  Registration Date   
ODATE1  Date  Optional Date 1   
PONUM  String*22  PO Number  Mask: %-22C
PORECNUM  String*22  PO Receipt Number  Mask: %-22C
PORETNUM  String*22  PO Return Number  Mask: %-22C
TRANSNUM  String*22  Transfer Number  Mask: %-22C
ADJNUM  String*22  Adjustment Number  Mask: %-22C
ICRECNUM  String*22  IC Receipt Number  Mask: %-22C
ICRECRET  String*22  IC Receipt Return  Mask: %-22C
ICSHPRET  String*22  IC Shipment Return  Mask: %-22C
SHIPNUM  String*22  Shipment Number  Mask: %-22C
ASMNUM  String*22  Assembly Number  Mask: %-22C
ORDERNUM  String*22  Order Number  Mask: %-22C
INVNUM  String*22  Invoice Number  Mask: %-22C
CNNUM  String*22  Credit Note Number  Mask: %-22C
RMANUM  String*22  RMA Number  Mask: %-22C
RECONNUM  String*22  Reconciliation Number  Mask: %-22C
FUNCTION  Integer  Function  List: 10 entries
0=None
2=Delete serial and history
3=Renumber
6=Clear history
7=Make comment in desc
8=Make instruction in desc
10=Assign RMA number if auto RMA is enabled
11=Assign RMA number
20=Recalculate Warranty
21=Recalculate Contract
SHINUM  String*22  SHINUM  Mask: %-22C

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.