Table: Transaction History

Table: ICHIST
View: IC0280
Record Length: 213

Flags: A R 

Keys: 6

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

Fields: 30

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
APP String*2 Source Application
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
QUANTITY BCD*10.4 Quantity
UNIT String*10 Unit of Measure Mask: %-10w
SRCCURR String*3 Source Currency Mask: %-3N
EXRATE BCD*8.7 Exchange Rate
SRCEXTCST BCD*10.3 Extended Cost - Source
HOMEEXTCST BCD*10.3 Extended Cost - Functional
DRILSRCTY Integer Drill Down Type
DRILLDWNLK BCD*10.0 Drill Down Link Number
DRILAPP String*2 Drill Down Application Source Mask: %-2A
JOBNO String*24
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).