Table: History

Table: LTHIST
View: LT0002
Record length: 1073
Flags: A R 

Keys: 4

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

Fields: 90

Field  Type  Title  Presentation 
LOTNUM  String*20  Unformatted lot number   
ITEMNUM  String*24  Unformatted item number   
LOCATION  String*6  Location  Mask: %-6N
UNIQUE  Long  Lot uniquifier   
ACTNUM  Long  Activity number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
ACTDATE  Date  Activity date   
ACTTIME  Time  Activity time   
LOTNUMF  String*20  Lot number   
ITEMNUMF  String*24  Item number   
ACTSTATUS  Integer  Activity status  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  Integer  Master status  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  String*12  Vendor number   
VENDNAME  String*60  Vendor name   
CUSTNO  String*12  Customer number   
CUSTNAME  String*60  Customer name   
RMACUST  String*12  RMA customer number   
RMACNAME  String*60  RMA customer name   
QREC  BCD*10.4  Quantity received   
QAVAIL  BCD*10.4  Quantity available   
QRECALL  BCD*10.4  Quantity on recall   
QRECALLED  BCD*10.4  Quantity recalled   
QRMA  BCD*10.4  Quantity on RMA   
QNA  BCD*10.4  Quantity not available   
QSOLD  BCD*10.4  Quantity sold   
QALLOCATE  BCD*10.4  Quantity allocated   
QQUAR  BCD*10.4  Quantity quarantined   
QTRANIN  BCD*10.4  Quantity transferred in   
QTRANOUT  BCD*10.4  Quantity transferred out   
COST  BCD*10.4  Total Cost   
ORIGCOST  BCD*10.4  Original Total Cost   
STOCKCOST  BCD*10.4  Stock Cost   
ADDCOST  BCD*10.4  Additional Cost   
DOC  String*22  Document   
DOCLINE  Integer  Document line   
POLINE  BCD*10.0  PO line number   
REFERENCE  String*60  Reference   
NOTE  String*6  Note   
USER  String*8  User   
MODULE  String*6  Module   
TRANSDATE  Date  Transaction Date   
ODATE1  Date  Optional date 1   
ODATE2  Date  Optional date 2   
ODATE3  Date  Optional date 3   
ODATE4  Date  Optional date 4   
OAMT1  BCD*10.4  Optional amount 1   
OAMT2  BCD*10.4  Optional amount 2   
OAMT3  BCD*10.4  Optional amount 3   
OAMT4  BCD*10.4  Optional amount 4   
OTEXT1  String*2  Optional text 1   
OTEXT2  String*4  Optional text 2   
OTEXT3  String*6  Optional text 3   
OTEXT4  String*15  Optional text 4   
OTEXT5  String*30  Optional text 5   
OTEXT6  String*75  Optional text 6   
SEGMENT1  String*20  Segment 1   
SEGMENT2  String*20  Segment 2   
SEGMENT3  String*20  Segment 3   
SEGMENT4  String*20  Segment 4   
SEGMENT5  String*20  Segment 5   
MASK  String*30  Mask   
SOURCECUR  String*3  Source currency   
SPRICE  BCD*10.4  Source Price   
PRICE  BCD*10.4  Functional Price   
RATEOPER  Integer  Rate operation  List: 2 entries
1=Multiply
2=Divide
RATE  BCD*8.7  Rate   
CUSTWAR1  Integer  End user warranty period 1   
CUSTWAR2  Integer  End user warranty period 2   
CUSTWAR3  Integer  End user warranty period 3   
SUPPWAR1  Integer  Dealer contract period 1   
SUPPWAR2  Integer  Dealer contract period 2   
SUPPWAR3  Integer  Dealer contract period 3   
ONWAR  Integer  On warranty   
WARDATE  Date  Warranty start date   
WAREDATE  Date  Warranty expired date   
ONCTT  Integer  On contract   
CTTDATE  Date  Contract start date   
CTTEDATE  Date  Contract expired date   
ONQUAR  Integer  On Quarantine   
QUARDATE  Date  Quarantine date   
QUARRDATE  Date  Quarantine release date   
SPOILDATE  Date  Expiry date   
STOCKDATE  Date  Stock date   
TRANSLOC  String*6  Transfer location   
TRANSLOT  String*20  Transfer lot   
TUNIQUE  Long  TUNIQUE   
SOLDDATE  Date  Sold Date   

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.