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

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