# 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.