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 = Multiply
2 = Divide
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 = Multiply
2 = Divide
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 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).