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 STATUSRECPNUMBER

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 C  Mask: %-8N
DATEBUS 49 Date Posting Date E A