View: Receipt Headers

RotoID: IC0590
Table: ICREEH
Protocol: Header, Key auto generate
DLL:ICREEH

Compositions: 2

RotoID Tables Title DLL
IC0580 ICREED Receipt Details ICREED
IC0595 ICREEHO Receipt Optional Fields ICREEHO

Keys: 4

Title Fields
Sequence Number SEQUENCENO
IC-Unique Document Number DOCUNIQ
Receipt Number RECPNUMBER
Status by Document Number STATUS, RECPNUMBER

Fields: 49

Field Index Type Title Attributes Presentation
SEQUENCENO 1 Long Sequence Number E A K R 
RECPDESC 2 String*60 Description E A 
RECPDATE 3 Date Receipt Date E A 
FISCYEAR 4 String*4 Fiscal Year E A  Mask: %4D
FISCPERIOD 5 Integer Fiscal Period E A P  List:12 entries
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
6 = 6
7 = 7
8 = 8
9 = 9
10 = 10
11 = 11
12 = 12
PONUM 6 String*22 Purchase Order Number E A  Mask: %-22C
REFERENCE 7 String*60 Reference E A 
RECPTYPE 8 Integer Receipt Type E A C  List:4 entries
1 = Receipt
2 = Return
3 = Adjustment
4 = Complete
RATEOP 9 Integer Rate Operation E A C  List:2 entries
1 = Multiply
2 = Divide
VENDNUMBER 10 String*12 Vendor Number E A  Mask: %-12C
RECPCUR 11 String*3 Receipt Currency E A  Mask: %-3N
RECPRATE 12 BCD*8.7 Exchange Rate E A 
RATETYPE 13 String*2 Rate Type E A  Mask: %-2N
RATEDATE 14 Date Rate Date E A 
RATEOVRRD 15 Boolean Rate Override E A  List:2 entries
0 = No
1 = Yes
ADDCOST 16 BCD*10.3 Additional Cost E A X 
ADDCOSTHM 17 BCD*10.3 Orig. Additional Cost-Func. E A C 
ADDCOSTSRC 18 BCD*10.3 Orig. Additional Cost-Source E A C 
ADDCUR 19 String*3 Additional Cost Currency E A  Mask: %-3N
TOTCSTHM 20 BCD*10.3 Total Extended Cost-Functional E A C 
TOTCSTSRC 21 BCD*10.3 Total Extended Cost-Source E A C 
TOTCSTADJ 22 BCD*10.3 Total Extended Cost-Adjusted E A C 
TOTADJHM 23 BCD*10.3 Total Adjusted Cost-Functional E A C 
TOTCSTRET 24 BCD*10.3 Total Return Cost E A C 
NUMCSTDETL 25 Integer Number of Details with Cost E A C 
LABELS 26 Boolean Require Labels E A  List:2 entries
0 = No
1 = Yes
ADDCSTTYPE 27 Integer Additional Cost Allocation Type E A C  List:2 entries
1 = Leave
2 = Prorate
COMPLETE 28 Boolean Complete E A  List:2 entries
0 = No
1 = Yes
ORIGTOTSRC 29 BCD*10.3 Original Total Cost-Source E A C 
ORIGTOTHM 30 BCD*10.3 Original Total Cost-Functional E A C 
ADDCSTHOME 31 BCD*10.3 Additional Cost-Functional A 
TOTALCOST 32 BCD*10.3 Total Cost-Receipt & Additional A C 
TOTCOSTADJ 33 BCD*10.3 Total Adj. Cost-Receipt & Addl. A C 
RECPDECIML 34 Integer Receipt Currency Decimals A C 
VENDNAME 35 String*10 Vendor Short Name A C 
DOCUNIQ 36 BCD*10.0 IC-Unique Document Number E A 
VENDEXISTS 37 Boolean Vendor Exists A C  List:2 entries
0 = No
1 = Yes
DELETED 38 Boolean Record Deleted E A  List:2 entries
0 = No
1 = Yes
TRANSNUM 39 BCD*10.0 Transaction Number A C 
STATUS 40 Integer Record Status E A  List:4 entries
1 = Entered
2 = Posted
3 = Costed
20 = Day End Completed
RECPNUMBER 41 String*22 Receipt Number E A  Mask: %-22C
NEXTDTLNUM 42 Integer Next Detail Line Number E A C 
PRINTED 43 Boolean Record Printed E A  List:2 entries
0 = No
1 = Yes
POSTSEQNUM 44 Long Post Sequence Number A C 
VALUES 45 Long Optional Fields E A C 
PROCESSCMD 46 Integer Process Command E A C  List:2 entries
0 = Nothing to Process
1 = Insert Optional Fields
VDLONGNAME 47 String*60 Vendor Name A C 
ENTEREDBY 48 String*8 Entered By E A  Mask: %-8N
DATEBUS 49 Date Posting Date E A 

This page was generated on 2022-Aug-18

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