Table: Receipt Headers

Table: ICREEH
View: IC0590
Record length: 395
Flags: A R 

Keys: 4

Title  Flags  Fields

Sequence Number  SEQUENCENO
IC-Unique Document Number  D M  DOCUNIQ
Receipt Number  RECPNUMBER
Status by Document Number  M  STATUS, RECPNUMBER

Fields: 44

Field  Type  Title  Presentation 

SEQUENCENO  Long  Sequence Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
RECPDESC  String*60  Description   
RECPDATE  Date  Receipt Date   
FISCYEAR  String*4  Fiscal Year  Mask: %4D
FISCPERIOD  Integer  Fiscal Period  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  String*22  Purchase Order Number  Mask: %-22C
REFERENCE  String*60  Reference   
RECPTYPE  Integer  Receipt Type  List: 4 entries
1=Receipt
2=Return
3=Adjustment
4=Complete
RATEOP  Integer  Rate Operation  List: 2 entries
1=Multiply
2=Divide
VENDNUMBER  String*12  Vendor Number  Mask: %-12C
RECPCUR  String*3  Receipt Currency  Mask: %-3N
RECPRATE  BCD*8.7  Exchange Rate   
RATETYPE  String*2  Rate Type  Mask: %-2N
RATEDATE  Date  Rate Date   
RATEOVRRD  Boolean  Rate Override  List: 2 entries
0=No
1=Yes
ADDCOST  BCD*10.3  Additional Cost   
ADDCOSTHM  BCD*10.3  Orig. Additional Cost-Func.   
ADDCOSTSRC  BCD*10.3  Orig. Additional Cost-Source   
ADDCUR  String*3  Additional Cost Currency  Mask: %-3N
TOTCSTHM  BCD*10.3  Total Extended Cost-Functional   
TOTCSTSRC  BCD*10.3  Total Extended Cost-Source   
TOTCSTADJ  BCD*10.3  Total Extended Cost-Adjusted   
TOTADJHM  BCD*10.3  Total Adjusted Cost-Functional   
TOTCSTRET  BCD*10.3  Total Return Cost   
NUMCSTDETL  Integer  Number of Details with Cost   
LABELS  Boolean  Require Labels  List: 2 entries
0=No
1=Yes
ADDCSTTYPE  Integer  Additional Cost Allocation Type  List: 2 entries
1=Leave
2=Prorate
COMPLETE  Boolean  Complete  List: 2 entries
0=No
1=Yes
ORIGTOTSRC  BCD*10.3  Original Total Cost-Source   
ORIGTOTHM  BCD*10.3  Original Total Cost-Functional   
DOCUNIQ  BCD*10.0  IC-Unique Document Number   
DELETED  Boolean  Record Deleted  List: 2 entries
0=No
1=Yes
TRANSNUM  BCD*10.0  Transaction Number   
STATUS  Integer  Record Status  List: 4 entries
1=Entered
2=Posted
3=Costed
20=Day End Completed
RECPNUMBER  String*22  Receipt Number  Mask: %-22C
NEXTDTLNUM  Integer  Next Detail Line Number   
PRINTED  Boolean  Record Printed  List: 2 entries
0=No
1=Yes
VALUES  Long  Optional Fields   
ENTEREDBY  String*8  Entered By  Mask: %-8N
DATEBUS  Date  Posting Date   

This page was generated on 2009-Nov-19

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