# View: History

RotoID: LT0002
Table: LTHIST
DLL: LTHIST

## Compositions: 0

## Keys: 4

Title | Fields
--- | ---
Lot number/Item number | LOTNUM, ITEMNUM, LOCATION, UNIQUE, ACTNUM
Activity Date/Time/Lot number | ACTDATE, ACTTIME, LOTNUM, ITEMNUM, LOCATION, UNIQUE, ACTNUM
Doc/Docline | DOC, DOCLINE
Doc/Poline | DOC, POLINE

## Fields: 98

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
LOTNUM | 1 | String*20 | Unformatted lot number | E A K R X |
ITEMNUM | 2 | String*24 | Unformatted item number | E A K R X |
LOCATION | 3 | String*6 | Location | E A K R X | Mask: %-6N
UNIQUE | 4 | Long | Lot uniquifier | E A K R X |
ACTNUM | 5 | Long | Activity number | E A K R X |
ACTDATE | 6 | Date | Activity date | A X |
ACTTIME | 7 | Time | Activity time | A X |
LOTNUMF | 8 | String*20 | Lot number | E A X |
ITEMNUMF | 9 | String*24 | Item number | E A X |
ACTSTATUS | 10 | Integer | Activity status | A X | List: 31 entries
10 | = | Not Available
20 | = | Purchase Order
30 | = | Received
40 | = | Order (not shipped)
60 | = | Shipped/Invoiced
70 | = | Credit Note Return
80 | = | Credit Note Damaged Stock
90 | = | Credit Note Price Adjustment
100 | = | Stock Return to Vendor
110 | = | BOM Assembly Master
111 | = | BOM Disassembly Master
120 | = | BOM Assembly Component
121 | = | BOM Disassembly Component
130 | = | Stock Adjustment Increase
140 | = | Stock Adjustment Decrease
150 | = | RMA Pending
160 | = | RMA Received from Customer
170 | = | RMA Sent Offsite
180 | = | RMA Received from Vendor
190 | = | RMA Sent to Customer
195 | = | RMA Returned to Stock
200 | = | Recall Requested
210 | = | Recall Received
220 | = | Transfer In
221 | = | Combine Transfer In
222 | = | Split Transfer In
230 | = | Transfer Out
231 | = | Combine Transfer Out
232 | = | Split Transfer Out
240 | = | Modify Lot
250 | = | Return To Parent
STATUS | 11 | Integer | Master status | E A X | List: 15 entries
0 | = | No change
10 | = | Available
20 | = | Not available
30 | = | On bill of materials
40 | = | On order
50 | = | Sold
60 | = | RMA-pending
70 | = | RMA-received customer
80 | = | RMA-sent offsite
90 | = | RMA-received vendor
100 | = | Recall requested
110 | = | Recall received
120 | = | Received
130 | = | Transfer In
140 | = | Transfer Out
VENDNO | 12 | String*12 | Vendor number | E A X |
VENDNAME | 13 | String*60 | Vendor name | A X |
CUSTNO | 14 | String*12 | Customer number | A X |
CUSTNAME | 15 | String*60 | Customer name | A X |
RMACUST | 16 | String*12 | RMA customer number | A X |
RMACNAME | 17 | String*60 | RMA customer name | A X |
QREC | 18 | BCD*10.4 | Quantity received | A X |
QAVAIL | 19 | BCD*10.4 | Quantity available | E A X |
QRECALL | 20 | BCD*10.4 | Quantity on recall | A X |
QRECALLED | 21 | BCD*10.4 | Quantity recalled | A X |
QRMA | 22 | BCD*10.4 | Quantity on RMA | A X |
QNA | 23 | BCD*10.4 | Quantity not available | A X |
QSOLD | 24 | BCD*10.4 | Quantity sold | A X |
QALLOCATE | 25 | BCD*10.4 | Quantity allocated | A X |
QQUAR | 26 | BCD*10.4 | Quantity quarantined | A X |
QTRANIN | 27 | BCD*10.4 | Quantity transferred in | A X |
QTRANOUT | 28 | BCD*10.4 | Quantity transferred out | A X |
COST | 29 | BCD*10.4 | Total Cost | E A X |
ORIGCOST | 30 | BCD*10.4 | Original Total Cost | A X |
STOCKCOST | 31 | BCD*10.4 | Stock Cost | A X |
ADDCOST | 32 | BCD*10.4 | Additional Cost | A X |
DOC | 33 | String*22 | Document | E A X |
DOCLINE | 34 | Integer | Document line | A X |
POLINE | 35 | BCD*10.0 | PO line number | A X |
REFERENCE | 36 | String*60 | Reference | A X |
NOTE | 37 | String*6 | Note | E A X |
USER | 38 | String*8 | User | A X |
MODULE | 39 | String*6 | Module | E A X |
TRANSDATE | 40 | Date | Transaction Date | A X |
ODATE1 | 41 | Date | Optional date 1 |  |
ODATE2 | 42 | Date | Optional date 2 |  |
ODATE3 | 43 | Date | Optional date 3 |  |
ODATE4 | 44 | Date | Optional date 4 |  |
OAMT1 | 45 | BCD*10.4 | Optional amount 1 |  |
OAMT2 | 46 | BCD*10.4 | Optional amount 2 |  |
OAMT3 | 47 | BCD*10.4 | Optional amount 3 |  |
OAMT4 | 48 | BCD*10.4 | Optional amount 4 |  |
OTEXT1 | 49 | String*2 | Optional text 1 |  |
OTEXT2 | 50 | String*4 | Optional text 2 |  |
OTEXT3 | 51 | String*6 | Optional text 3 |  |
OTEXT4 | 52 | String*15 | Optional text 4 |  |
OTEXT5 | 53 | String*30 | Optional text 5 |  |
OTEXT6 | 54 | String*75 | Optional text 6 |  |
SEGMENT1 | 55 | String*20 | Segment 1 | A X |
SEGMENT2 | 56 | String*20 | Segment 2 | A X |
SEGMENT3 | 57 | String*20 | Segment 3 | A X |
SEGMENT4 | 58 | String*20 | Segment 4 | A X |
SEGMENT5 | 59 | String*20 | Segment 5 | A X |
MASK | 60 | String*30 | Mask | A X |
SOURCECUR | 61 | String*3 | Source currency | A X |
SPRICE | 62 | BCD*10.4 | Source Price | A X |
PRICE | 63 | BCD*10.4 | Functional Price | A X |
RATEOPER | 64 | Integer | Rate operation | A X | List: 2 entries
1 | = | Multiply
2 | = | Divide
RATE | 65 | BCD*8.7 | Rate | A X |
CUSTWAR1 | 66 | Integer | End user warranty period 1 | A X |
CUSTWAR2 | 67 | Integer | End user warranty period 2 | A X |
CUSTWAR3 | 68 | Integer | End user warranty period 3 | A X |
SUPPWAR1 | 69 | Integer | Dealer contract period 1 | A X |
SUPPWAR2 | 70 | Integer | Dealer contract period 2 | A X |
SUPPWAR3 | 71 | Integer | Dealer contract period 3 | A X |
ONWAR | 72 | Boolean | On warranty | A X |
WARDATE | 73 | Date | Warranty start date | A X |
WAREDATE | 74 | Date | Warranty expired date | A X |
ONCTT | 75 | Boolean | On contract | A X |
CTTDATE | 76 | Date | Contract start date | A X |
CTTEDATE | 77 | Date | Contract expired date | A X |
ONQUAR | 78 | Boolean | On Quarantine | A X |
QUARDATE | 79 | Date | Quarantine date | A X |
QUARRDATE | 80 | Date | Quarantine release date | A X |
SPOILDATE | 81 | Date | Expiry date | E A X |
STOCKDATE | 82 | Date | Stock date | E A X |
TRANSLOC | 83 | String*6 | Transfer location | A X |
TRANSLOT | 84 | String*20 | Transfer lot | A X |
TUNIQUE | 85 | Long | TUNIQUE | A X |
SOLDDATE | 86 | Date | Sold Date | A X |
FUNCTION | 150 | Integer | Function | E A X | List: 11 entries
10 | = | Assign RMA
11 | = | Assign Recall
50 | = | Init for new activity
100 | = | Open BOM program
101 | = | Open BOM program modal
102 | = | Open Notes program
103 | = | Open Notes program modal
104 | = | Open Transaction
105 | = | Open Transaction modal
106 | = | Open customer program
107 | = | Open customer program modal
ACTQ | 151 | BCD*10.4 | Activity Quantity | A X |
ACTCOST | 152 | BCD*10.4 | Activity Cost | A X |
QCOMMIT | 153 | BCD*10.4 | Quantity Committed | A X |
LOTTYPE | 154 | String*6 | Lot Type | A |
ACTACOST | 155 | BCD*10.4 | Activity Additional Cost | A X |
ORIGDATE | 156 | Date | Original Transaction Date | A |
TRANTO | 157 | Integer | Destination lot type | A X | List: 2 entries
0 | = | Same lot
1 | = | Different lot
TSTOCK | 158 | Date | Stock Date | E A X |
TEXPIRE | 159 | Date | Expiry Date | E A X |
ROTOID | 160 | String*6 | Drilldown Roto ID | A |
PARAMS | 161 | String*250 | Drilldown Parameters | A |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.