# Table: Transaction History

Table: ICHIST
View: IC0280
Record length: 213
Flags: A R

## Keys: 5

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

## 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 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.