Table: Receipt Vendors

Table: PORCPV
View: PO0718
Record length: 950
Flags: A R 

Keys: 1


Title  Flags  Fields
Master Key   RCPHSEQ, VDCODE

Fields: 97


Field  Type  Title  Presentation 
RCPHSEQ  BCD*10.0  Receipt Sequence Key   
VDCODE  String*12  Vendor  Mask: %-12C
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
COSTS  Long  Costs   
COSTSPRORA  Long  Number of Costs Prorated   
COSTSCMPL  Long  Costs Complete   
INDBTABLE  Boolean  Stored in Database Table  List: 2 entries
0=No
1=Yes
TAXAUTOCAL  Boolean  Auto. tax calculation on save  List: 2 entries
0=No
1=Yes
ISINVOICED  Boolean  Invoiced  List: 2 entries
0=No
1=Yes
INVNUMBER  String*22  Invoice Number  Mask: %-22C
VDEXISTS  Boolean  Vendor Exists  List: 2 entries
0=No
1=Yes
VDNAME  String*30  Name   
VDADDRESS1  String*30  Address 1   
VDADDRESS2  String*30  Address 2   
VDADDRESS3  String*30  Address 3   
VDADDRESS4  String*30  Address 4   
VDCITY  String*20  City   
VDSTATE  String*20  State/Province   
VDZIP  String*15  Zip/Postal Code   
VDCOUNTRY  String*20  Country   
VDPHONE  String*20  Phone Number  Mask: (%-3C) %-3C-%-10C
VDFAX  String*20  Fax Number  Mask: (%-3C) %-3C-%-10C
VDCONTACT  String*30  Contact   
TERMSCODE  String*6  Terms Code  Mask: %-6N
CURRENCY  String*3  Currency  Mask: %-3N
RATE  BCD*8.7  Exchange Rate   
SPREAD  BCD*8.7  Rate Spread   
RATETYPE  String*2  Rate Type  Mask: %-2N
RATEMATCH  Integer  Rate Match Type   
RATEDATE  Date  Rate Date   
RATEOPER  Integer  Rate Operation  List: 2 entries
1=*
2=/
RATEOVER  Boolean  Rate Overridden  List: 2 entries
0=No
1=Yes
SCURNDECML  Integer  Decimal Places   
DOCTOTAL  BCD*10.3  Total   
AMOUNT  BCD*10.3  Amount   
TAXGROUP  String*6  Tax Group  Mask: %-6N
TAXAUTH1  String*6  Tax Authority 1   
TAXAUTH2  String*6  Tax Authority 2   
TAXAUTH3  String*6  Tax Authority 3   
TAXAUTH4  String*6  Tax Authority 4   
TAXAUTH5  String*6  Tax Authority 5   
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   
TAXBASE1  BCD*10.3  Tax Base 1   
TAXBASE2  BCD*10.3  Tax Base 2   
TAXBASE3  BCD*10.3  Tax Base 3   
TAXBASE4  BCD*10.3  Tax Base 4   
TAXBASE5  BCD*10.3  Tax Base 5   
TXINCLUDE1  BCD*10.3  Included Tax Amount 1   
TXINCLUDE2  BCD*10.3  Included Tax Amount 2   
TXINCLUDE3  BCD*10.3  Included Tax Amount 3   
TXINCLUDE4  BCD*10.3  Included Tax Amount 4   
TXINCLUDE5  BCD*10.3  Included Tax Amount 5   
TXEXCLUDE1  BCD*10.3  Excluded Tax Amount 1   
TXEXCLUDE2  BCD*10.3  Excluded Tax Amount 2   
TXEXCLUDE3  BCD*10.3  Excluded Tax Amount 3   
TXEXCLUDE4  BCD*10.3  Excluded Tax Amount 4   
TXEXCLUDE5  BCD*10.3  Excluded Tax Amount 5   
TAXAMOUNT1  BCD*10.3  Tax Amount 1   
TAXAMOUNT2  BCD*10.3  Tax Amount 2   
TAXAMOUNT3  BCD*10.3  Tax Amount 3   
TAXAMOUNT4  BCD*10.3  Tax Amount 4   
TAXAMOUNT5  BCD*10.3  Tax Amount 5   
TXALLOAMT1  BCD*10.3  Tax Allocated Amount 1   
TXALLOAMT2  BCD*10.3  Tax Allocated Amount 2   
TXALLOAMT3  BCD*10.3  Tax Allocated Amount 3   
TXALLOAMT4  BCD*10.3  Tax Allocated Amount 4   
TXALLOAMT5  BCD*10.3  Tax Allocated Amount 5   
TXRECVAMT1  BCD*10.3  Tax Recoverable Amount 1   
TXRECVAMT2  BCD*10.3  Tax Recoverable Amount 2   
TXRECVAMT3  BCD*10.3  Tax Recoverable Amount 3   
TXRECVAMT4  BCD*10.3  Tax Recoverable Amount 4   
TXRECVAMT5  BCD*10.3  Tax Recoverable Amount 5   
TXEXPSAMT1  BCD*10.3  Tax Expense Amount 1   
TXEXPSAMT2  BCD*10.3  Tax Expense Amount 2   
TXEXPSAMT3  BCD*10.3  Tax Expense Amount 3   
TXEXPSAMT4  BCD*10.3  Tax Expense Amount 4   
TXEXPSAMT5  BCD*10.3  Tax Expense Amount 5   
TXBASEALLO  BCD*10.3  Net of Tax   
TXINCLUDED  BCD*10.3  Tax Included   
TXEXCLUDED  BCD*10.3  Tax Excluded   
TAXAMOUNT  BCD*10.3  Total Tax   
TXRECVAMT  BCD*10.3  Total Tax Recoverable   
TXEXPSAMT  BCD*10.3  Total Tax Expensed   
TXALLOAMT  BCD*10.3  Total Tax Allocated   
SCAMOUNT  BCD*10.3  Conversion Source Amount   
FCAMOUNT  BCD*10.3  Conversion Functional Amount   
MTOPRORATE  BCD*10.3  Manual To Prorate   
TAXLINES  Long  Lines Tax Calculation Sees   
ISCOMPLETE  Boolean  Completed  List: 2 entries
0=No
1=Yes
DTCOMPLETE  Date  Date Completed   

This page was generated on 2002-Oct-04

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