# Table: Receipt Vendors

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

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Master Key |  | RCPHSEQ, VDCODE

## Fields: 173

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*60 | Name |
VDADDRESS1 | String*60 | Address 1 |
VDADDRESS2 | String*60 | Address 2 |
VDADDRESS3 | String*60 | Address 3 |
VDADDRESS4 | String*60 | Address 4 |
VDCITY | String*30 | City |
VDSTATE | String*30 | State/Province |
VDZIP | String*20 | Zip/Postal Code |
VDCOUNTRY | String*30 | Country |
VDPHONE | String*30 | Phone Number | Mask: (%-3C) %-3C-%-24C
VDFAX | String*30 | Fax Number | Mask: (%-3C) %-3C-%-24C
VDCONTACT | String*60 | 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*12 | Tax Group | Mask: %-12N
TAXAUTH1 | String*12 | Tax Authority 1 |
TAXAUTH2 | String*12 | Tax Authority 2 |
TAXAUTH3 | String*12 | Tax Authority 3 |
TAXAUTH4 | String*12 | Tax Authority 4 |
TAXAUTH5 | String*12 | 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 |
VDEMAIL | String*50 | E-mail |
VDPHONEC | String*30 | Contact Phone | Mask: (%-3C) %-3C-%-24C
VDFAXC | String*30 | Contact Fax | Mask: (%-3C) %-3C-%-24C
VDEMAILC | String*50 | Contact E-mail |
VALUES | Long | Optional Fields |
JOBCOSTS | Long | Job Related Costs |
COSTSBLPRO | Long | Cost Billing Rates Prorated |
HASRTG | Boolean | Has Retainage | List: 2 entries
0 | = | No
1 | = | Yes
RTGRATE | Integer | Retainage Exchange Rate | List: 2 entries
0 | = | Use Original Document Exchange Rate
1 | = | Use Current Exchange Rate
RTGTERMS | String*6 | Retainage Terms Code | Mask: %-6N
RTGAMOUNT | BCD*10.3 | Retainage Amount |
TRCURRENCY | String*3 | Tax Reporting Currency | Mask: %-3N
RATERC | BCD*8.7 | Tax Reporting Exchange Rate |
SPREADRC | BCD*8.7 | Tax Reporting Rate Spread |
RATETYPERC | String*2 | Tax Reporting Rate Type | Mask: %-2N
RATEMTCHRC | Integer | Tax Reporting Rate Match Type |
RATEDATERC | Date | Tax Reporting Rate Date |
RATEOPERRC | Integer | Tax Reporting Rate Operation | List: 2 entries
1 | = | *
2 | = | /
RATERCOVER | Boolean | Tax Reporting Rate Overridden | List: 2 entries
0 | = | No
1 | = | Yes
RCURNDECML | Integer | Tax Reporting Decimal Places |
TARAMOUNT1 | BCD*10.3 | Tax Reporting Amount 1 |
TARAMOUNT2 | BCD*10.3 | Tax Reporting Amount 2 |
TARAMOUNT3 | BCD*10.3 | Tax Reporting Amount 3 |
TARAMOUNT4 | BCD*10.3 | Tax Reporting Amount 4 |
TARAMOUNT5 | BCD*10.3 | Tax Reporting Amount 5 |
TRINCLUDE1 | BCD*10.3 | Tax Reporting Included Amount 1 |
TRINCLUDE2 | BCD*10.3 | Tax Reporting Included Amount 2 |
TRINCLUDE3 | BCD*10.3 | Tax Reporting Included Amount 3 |
TRINCLUDE4 | BCD*10.3 | Tax Reporting Included Amount 4 |
TRINCLUDE5 | BCD*10.3 | Tax Reporting Included Amount 5 |
TREXCLUDE1 | BCD*10.3 | Tax Reporting Excluded Amount 1 |
TREXCLUDE2 | BCD*10.3 | Tax Reporting Excluded Amount 2 |
TREXCLUDE3 | BCD*10.3 | Tax Reporting Excluded Amount 3 |
TREXCLUDE4 | BCD*10.3 | Tax Reporting Excluded Amount 4 |
TREXCLUDE5 | BCD*10.3 | Tax Reporting Excluded Amount 5 |
TRRECVAMT1 | BCD*10.3 | Tax Reporting Recoverable Amt. 1 |
TRRECVAMT2 | BCD*10.3 | Tax Reporting Recoverable Amt. 2 |
TRRECVAMT3 | BCD*10.3 | Tax Reporting Recoverable Amt. 3 |
TRRECVAMT4 | BCD*10.3 | Tax Reporting Recoverable Amt. 4 |
TRRECVAMT5 | BCD*10.3 | Tax Reporting Recoverable Amt. 5 |
TREXPSAMT1 | BCD*10.3 | Tax Reporting Expense Amount 1 |
TREXPSAMT2 | BCD*10.3 | Tax Reporting Expense Amount 2 |
TREXPSAMT3 | BCD*10.3 | Tax Reporting Expense Amount 3 |
TREXPSAMT4 | BCD*10.3 | Tax Reporting Expense Amount 4 |
TREXPSAMT5 | BCD*10.3 | Tax Reporting Expense Amount 5 |
TRALLOAMT1 | BCD*10.3 | Tax Reporting Allocated Amount 1 |
TRALLOAMT2 | BCD*10.3 | Tax Reporting Allocated Amount 2 |
TRALLOAMT3 | BCD*10.3 | Tax Reporting Allocated Amount 3 |
TRALLOAMT4 | BCD*10.3 | Tax Reporting Allocated Amount 4 |
TRALLOAMT5 | BCD*10.3 | Tax Reporting Allocated Amount 5 |
RAXBASE1 | BCD*10.3 | Retainage Tax Base 1 |
RAXBASE2 | BCD*10.3 | Retainage Tax Base 2 |
RAXBASE3 | BCD*10.3 | Retainage Tax Base 3 |
RAXBASE4 | BCD*10.3 | Retainage Tax Base 4 |
RAXBASE5 | BCD*10.3 | Retainage Tax Base 5 |
RAXAMOUNT1 | BCD*10.3 | Retainage Tax Amount 1 |
RAXAMOUNT2 | BCD*10.3 | Retainage Tax Amount 2 |
RAXAMOUNT3 | BCD*10.3 | Retainage Tax Amount 3 |
RAXAMOUNT4 | BCD*10.3 | Retainage Tax Amount 4 |
RAXAMOUNT5 | BCD*10.3 | Retainage Tax Amount 5 |
RXRECVAMT1 | BCD*10.3 | Retainage Tax Recoverable Amt. 1 |
RXRECVAMT2 | BCD*10.3 | Retainage Tax Recoverable Amt. 2 |
RXRECVAMT3 | BCD*10.3 | Retainage Tax Recoverable Amt. 3 |
RXRECVAMT4 | BCD*10.3 | Retainage Tax Recoverable Amt. 4 |
RXRECVAMT5 | BCD*10.3 | Retainage Tax Recoverable Amt. 5 |
RXEXPSAMT1 | BCD*10.3 | Retainage Tax Expense Amount 1 |
RXEXPSAMT2 | BCD*10.3 | Retainage Tax Expense Amount 2 |
RXEXPSAMT3 | BCD*10.3 | Retainage Tax Expense Amount 3 |
RXEXPSAMT4 | BCD*10.3 | Retainage Tax Expense Amount 4 |
RXEXPSAMT5 | BCD*10.3 | Retainage Tax Expense Amount 5 |
RXALLOAMT1 | BCD*10.3 | Retainage Tax Allocated Amount 1 |
RXALLOAMT2 | BCD*10.3 | Retainage Tax Allocated Amount 2 |
RXALLOAMT3 | BCD*10.3 | Retainage Tax Allocated Amount 3 |
RXALLOAMT4 | BCD*10.3 | Retainage Tax Allocated Amount 4 |
RXALLOAMT5 | BCD*10.3 | Retainage Tax Allocated Amount 5 |
VDACCTSET | String*6 | Vendor Account Set | Mask: %-6N

This page was generated on 2008-May-01

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