Table: Item Valuation

Table: ICIVAL
View: IC0352
Record Length: 328

Flags: A R 

Keys: 5

Title Flags Fields
Account Set Code ACCTSET, LOCATION, ITEMNO, FISCYEAR, FISCPERIOD, TRANSDATE, DAYENDSEQ, ENTRYSEQ, LINENO
Location/Item Number D M  LOCATION, ITEMNO
Dayend Sequence D M  DAYENDSEQ, ENTRYSEQ, LINENO
Item Number/Location D M  ITEMNO, LOCATION, FISCYEAR, FISCPERIOD
Account Set Code/Trans. Type D M  ACCTSET, LOCATION, ITEMNO, FISCYEAR, FISCPERIOD, TRANSTYPE, TRANSDATE, DOCNUM

Fields: 42

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:20 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
20 = Internal Usage
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
DATEBUS Date Posting Date

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).