# Table: Item Valuation

Table: ICIVAL
View: IC0352
Record length: 323
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Account Set Code |  | ACCTSET, LOCATION, ITEMNO, FISCYEAR, FISCPERIOD, TRANSDATE, DAYENDSEQ, ENTRYSEQ, LINENO

## Fields: 41

Field | Type | Title | Presentation
--- | --- | --- | ---
ACCTSET | String*6 | Account Set Code | Mask: %-6N
LOCATION | String*6 | Location | Mask: %-6N
ITEMNO | String*24 | Item Number | Mask: %-24C
FISCYEAR | String*4 | Fiscal Year | Mask: %4D
FISCPERIOD | Integer | Fiscal Period |
TRANSDATE | Date | Transaction Date |
DAYENDSEQ | Long | Day End Number |
ENTRYSEQ | Long | Transaction Sequence |
LINENO | Integer | Line Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
CATEGORY | String*6 | Category | Mask: %-6N
DOCNUM | String*22 | Document Number |
TRANSTYPE | Integer | Transaction Type | List: 19 entries
1 | = | Receipt
2 | = | Receipt Adjustment
3 | = | Receipt Return
4 | = | Shipment
5 | = | Shipment Return
6 | = | Adjustment Quantity Increase
7 | = | Adjustment Quantity Decrease
8 | = | Adjustment Cost Increase
9 | = | Adjustment Cost Decrease
10 | = | Adjustment Both Increase
11 | = | Adjustment Both Decrease
12 | = | Stock Transfer From
13 | = | Stock Transfer To
14 | = | Master Item Assembly
15 | = | Component Item Assembly
16 | = | Invoice
17 | = | Credit Note
18 | = | Debit Note
19 | = | Shipment Adjustment
UNIT | String*10 | Unit of Measure | Mask: %-10w
QUANTITY | BCD*10.4 | Transaction Quantity |
CONVERSION | BCD*10.6 | Conversion Factor |
TRANSCOST | BCD*10.3 | Transaction Cost |
STKQTY | BCD*10.4 | Quantity in Stocking UOM |
OPTAMT | BCD*10.3 | Optional Amount |
APP | String*2 | Application |
STOCKUNIT | String*10 | Stock Unit | Mask: %-10w
DEFPRICLST | String*6 | Default Price List | Mask: %-6N
TOTALCOST | BCD*10.3 | Total Cost |
RECENTCOST | BCD*10.6 | Recent Cost |
COST1 | BCD*10.6 | Cost 1 Name |
COST2 | BCD*10.6 | Cost 2 Name |
LASTCOST | BCD*10.6 | Last Cost |
STDCOST | BCD*10.6 | Standard Cost |
COSTUNIT | String*10 | Cost Unit | Mask: %-10w
COSTCONV | BCD*10.6 | Cost Conversion |
TOTALQTY | BCD*10.4 | Total Quantity |
PRICELIST | String*6 | Price List Code | Mask: %-6N
PRICEDECS | Integer | Decimals in Price |
BASEPRICE | BCD*10.6 | Base Price |
BASEUNIT | String*10 | Pricing Unit of Measure | Mask: %-10w
BASECONV | BCD*10.6 | Base Conversion Factor |
DETAILNUM | Integer | Detail Number |
COMPNUM | Long | Detail Component Number |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.