# Table: Transactions

Table: SNHIST
View: SN0004
Record length: 1203
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Serial/ItemNumbers/This History |  | SERIALNUM, ITEMNUM, THISHIST

## Fields: 65

Field | Type | Title | Presentation
--- | --- | --- | ---
SERIALNUM | String*40 | Serial Number Unformatted | Mask: %-40c
ITEMNUM | String*24 | Item Number Unformatted | Mask: %-24C
THISHIST | Long | Transaction Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
TRANSDATE | Date | Transaction Date |
DOCNUM | String*22 | Transaction Document No. | Mask: %-22C
DOCILINE | Integer | Document Line (integer) |
DOCBLINE | BCD*10.0 | Document Line (BCD) |
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 |
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 |
USER | String*8 | User |
MODULE | String*6 | Module |
FUNCTION | Integer | Function | List: 4 entries
0 | = | None
1 | = | Create new transaction
2 | = | Update serial number
3 | = | Drill down

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.