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.