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 2009-Nov-19

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