Table: Main

Table: LTMAIN
View: LT0001
Record length: 1417
Flags: A R 

Keys: 12

Title  Flags  Fields
Lot number/Item number   LOTNUM, ITEMNUM, LOCATION, UNIQUE
Item number/Lot number   ITEMNUM, LOTNUM, LOCATION, UNIQUE
Customer number/Lot number   M  CUSTNO, ITEMNUM, LOCATION, LOTNUM, UNIQUE
Vendor number/Lot number   M  VENDNO, ITEMNUM, LOCATION, LOTNUM, UNIQUE
Status/Lot number   D M  STATUS, LOTNUM, UNIQUE
Stock date/Lot number   D M  STOCKDATE, LOTNUM, UNIQUE
Expiry date/Lot number   D M  SPOILDATE, LOTNUM, UNIQUE
Optional date1/Lot number   D M  ODATE1, LOTNUM, UNIQUE
Activity date/Time/Lot number   D M  LASTDATE, LASTTIME, LOTNUM, UNIQUE
Last document/Last line   M  LASTDOC, LASTLINE, LOTNUM, ITEMNUM, LOCATION, UNIQUE
Unique/Status/Item/Lot   D M  UNIQUE, STATUS, ITEMNUM, LOCATION, LOTNUM
Customer/Status   ITEMNUM, LOCATION, UNIQUE, LOTNUM

Fields: 116

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   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
LASTUNI  Long  Last uniquifier assigned   
LACTNUM  Long  Last activity number   
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   
QCOMMIT  BCD*10.4  Quantity committed   
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   
LASTDOC  String*22  Last document   
LASTLINE  Integer  Last document line   
REFERENCE  String*60  Reference   
LASTDATE  Date  Last activity date   
LASTTIME  Time  Last activity time   
PONUM  String*22  PO number   
PORECNUM  String*22  PO receipt number   
PORETNUM  String*22  PO Return number   
TRANSNUM  String*22  Transfer number   
ADJNUM  String*22  Adjustment number   
ICRECNUM  String*22  IC receipt number   
ICRECRET  String*22  IC receipt return   
ICSHPRET  String*22  IC ship return   
SHIPNUM  String*22  Shipment number   
ASMNUM  String*22  Assembly number   
ORDERNUM  String*22  Order number   
INVNUM  String*22  Invoice number   
CNNUM  String*22  Credit note number   
RMANUM  String*22  RMA number   
LPONUM  BCD*10.0  PO line number   
LPORECNUM  BCD*10.0  PO receipt line number   
LPORETNUM  BCD*10.0  PO Return line number   
LTRANSNUM  Integer  Transfer line number   
LADJNUM  Integer  Adjustment line number   
LICRECNUM  Integer  IC receipt line number   
LICRECRET  Integer  IC receipt line return   
LICSHPRET  Integer  IC ship line return   
LSHIPNUM  Integer  Shipment line number   
LASMNUM  Integer  Assembly line number   
LORDERNUM  Integer  Order line number   
LINVNUM  Integer  Invoice line number   
LCNNUM  Integer  Credit note line number   
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   
NOTE  String*6  Note   
TRANSDATE  Date  Transaction Date   
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  Boolean  On warranty   
WARDATE  Date  Warranty start date   
WAREDATE  Date  Warranty expired date   
ONCTT  Boolean  On contract   
CTTDATE  Date  Contract start date   
CTTEDATE  Date  Contract expired date   
ONQUAR  Boolean  On Quarantine   
QUARDATE  Date  Quarantine date   
QUARRDATE  Date  Quarantine release date   
SPOILDATE  Date  Expiry date   
STOCKDATE  Date  Stock date   
NEEDDE  Boolean  Need Day End   
SOLDDATE  Date  Sold Date   
SHINUM  String*22  Shipment Number   
LSHINUM  Integer  Shipment Line Number   

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.