View: Transaction History

RotoID: IC0280
Table: ICHIST
Protocol: Flat
DLL:ICHIST

Compositions: 4

RotoID Tables Title DLL
IC0310 ICITEM Items ICITEM
IC0370 ICLOC Locations ICLOC
IC0210 ICCATG Categories ICCATG
OE0692 OESHIH Shipments OESHIH

Keys: 6

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

Fields: 28

Field Index Type Title Attributes Presentation
ACCTSET 1 String*6 Account Set Code E A K R  Mask: %-6N
LOCATION 2 String*6 Location E A K R  Mask: %-6N
ITEMNO 3 String*24 Item Number E A K R  Mask: %-24C
FISCYEAR 4 String*4 Fiscal Year E A K R  Mask: %4D
FISCPERIOD 5 Integer Fiscal Period E A K R 
TRANSDATE 6 Date Transaction Date E A K R 
DAYENDSEQ 7 Long Day End Number E A K R 
ENTRYSEQ 8 Long Transaction Sequence E A K R 
LINENO 9 Integer Line Number E A K R 
CATEGORY 10 String*6 Category E A  Mask: %-6N
DOCNUM 11 String*22 Document Number E A 
APP 12 String*2 Source Application E A 
TRANSTYPE 13 Integer Transaction Type E A  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 14 BCD*10.4 Quantity E A 
UNIT 15 String*10 Unit of Measure E A  Mask: %-10w
SRCCURR 16 String*3 Source Currency E A  Mask: %-3N
EXRATE 17 BCD*8.7 Exchange Rate E A 
SRCEXTCST 18 BCD*10.3 Extended Cost - Source E A 
HOMEEXTCST 19 BCD*10.3 Extended Cost - Functional E A 
DRILSRCTY 20 Integer Drill Down Type E A 
DRILLDWNLK 21 BCD*10.0 Drill Down Link Number E A 
DRILAPP 22 String*2 Drill Down Application Source E A  Mask: %-2A
DETAILNUM 23 Integer Detail Number E A 
COMPNUM 24 Long Detail Component Number E A 
DATEBUS 25 Date Posting Date E A 
FMTITEMNO 30 String*24 Formatted Item Number A C 
ITEMDESC 31 String*60 Item Description A C 
INVNUMBER 32 String*22 Invoice Number A C 

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).