Table: Receipt Audit Headers

Table: PORCPAH
View: PO0686
Record length: 306
Flags: A R 

Keys: 4


Title  Flags  Fields

Master Key   DAYENDSEQ, RCPAHSEQ
Vendor   VENDOR, DAYENDSEQ, RCPAHSEQ
Transaction Date   TRANSDATE, DAYENDSEQ, RCPAHSEQ
Document Number   RCPNUMBER, DAYENDSEQ, RCPAHSEQ

Fields: 43


Field  Type  Title  Presentation 

DAYENDSEQ  BCD*10.0  Day End Number   
RCPAHSEQ  BCD*10.0  Processing Sequence   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
ISPRINTED  Boolean  Printed  List: 2 entries
0=No
1=Yes
RCPHSEQ  BCD*10.0  Receipt Sequence Key   
POSTDATE  Date  Last Posting Date   
DAYENDDATE  Date  Day End Processing Date   
TRANSDATE  Date  Transaction Date   
REFERENCE  String*22  Reference   
FISCYEAR  String*4  Fiscal Year  Mask: %4D
FISCPERIOD  Integer  Fiscal Period   
DESCRIPTIO  String*30  Description   
TRANSTYPE  Integer  Transaction Type  List: 3 entries
1=Receipt
2=Receipt Adjustment
99=Sequence Placeholder (?)
VENDOR  String*12  Vendor  Mask: %-12C
VENDORNAME  String*30  Name   
TAXGROUP  String*6  Tax Group  Mask: %-6N
TAXAUTH1  String*6  Tax Authority 1  Mask: %-6N
TAXAUTH2  String*6  Tax Authority 2  Mask: %-6N
TAXAUTH3  String*6  Tax Authority 3  Mask: %-6N
TAXAUTH4  String*6  Tax Authority 4  Mask: %-6N
TAXAUTH5  String*6  Tax Authority 5  Mask: %-6N
TAXCLASS1  Integer  Tax Class 1   
TAXCLASS2  Integer  Tax Class 2   
TAXCLASS3  Integer  Tax Class 3   
TAXCLASS4  Integer  Tax Class 4   
TAXCLASS5  Integer  Tax Class 5   
PONUMBER  String*22  Purchase Order Number  Mask: %-22C
RCPNUMBER  String*15  Receipt Number  Mask: %-15C
RCPCURR  String*3  Currency  Mask: %-3N
EXRATE  BCD*8.7  Exchange Rate   
RATEDATE  Date  Rate Date   
RATETYPE  String*2  Rate Type  Mask: %-2N
RATEOPER  Integer  Rate Operation  List: 2 entries
1=*
2=/
RATEOVER  Boolean  Rate Overridden  List: 2 entries
0=No
1=Yes
SCURNDECML  Integer  Decimal Places   
FCDOCTOTAL  BCD*10.3  Total Cost (Functional)   
SCDOCTOTAL  BCD*10.3  Source Document Total   
COMPLETE  Boolean  Completed  List: 2 entries
0=No
1=Yes
PRINTED  Boolean  Printed  List: 2 entries
0=No
1=Yes
MULTIPOR  Boolean  Multiple Purchase Orders  List: 2 entries
0=No
1=Yes

This page was generated on 2002-Oct-04

Copyright © 2002 ACCPAC International, Inc. All rights reserved.