View: Receipt Vendors

RotoID: PO0468
Table:
DLL: POIRCPV

Compositions: 2


RotoID  Table  Title  DLL 
PO0462    Receipts  POIRCPH
PO0718  PORCPV  Receipt Vendors  PORCPV

Keys: 1


Title  Fields
Master Key   RCPHSEQ, VDCODE

Fields: 165


Field  Index  Type  Title  Attributes  Presentation
RCPHSEQ  1  BCD*10.0  Receipt Sequence Key  E A K R   
VDCODE  2  String*12  Vendor   
COSTS  3  Long  Costs   
COSTSPRORA  4  Long  Number of Costs Prorated   
COSTSCMPL  5  Long  Costs Complete   
INDBTABLE  6  Boolean  Stored in Database Table   
TAXAUTOCAL  7  Boolean  Auto. tax calculation on save   
ISINVOICED  8  Boolean  Invoiced   
INVNUMBER  9  String*22  Invoice Number   
VDEXISTS  10  Boolean  Vendor Exists   
VDNAME  11  String*30  Name   
VDADDRESS1  12  String*30  Address 1   
VDADDRESS2  13  String*30  Address 2   
VDADDRESS3  14  String*30  Address 3   
VDADDRESS4  15  String*30  Address 4   
VDCITY  16  String*20  City   
VDSTATE  17  String*20  State/Province   
VDZIP  18  String*15  Zip/Postal Code   
VDCOUNTRY  19  String*20  Country   
VDPHONE  20  String*20  Phone Number   
VDFAX  21  String*20  Fax Number   
VDCONTACT  22  String*30  Contact   
TERMSCODE  23  String*6  Terms Code   
CURRENCY  24  String*3  Currency   
RATE  25  BCD*8.7  Exchange Rate   
SPREAD  26  BCD*8.7  Rate Spread   
RATETYPE  27  String*2  Rate Type   
RATEMATCH  28  Integer  Rate Match Type   
RATEDATE  29  Date  Rate Date   
RATEOPER  30  Integer  Rate Operation   
RATEOVER  31  Boolean  Rate Overridden   
SCURNDECML  32  Integer  Decimal Places   
DOCTOTAL  33  BCD*10.3  Total   
AMOUNT  34  BCD*10.3  Amount   
TAXGROUP  35  String*6  Tax Group   
TAXAUTH1  36  String*6  Tax Authority 1   
TAXAUTH2  37  String*6  Tax Authority 2   
TAXAUTH3  38  String*6  Tax Authority 3   
TAXAUTH4  39  String*6  Tax Authority 4   
TAXAUTH5  40  String*6  Tax Authority 5   
TAXCLASS1  41  Integer  Tax Class 1   
TAXCLASS2  42  Integer  Tax Class 2   
TAXCLASS3  43  Integer  Tax Class 3   
TAXCLASS4  44  Integer  Tax Class 4   
TAXCLASS5  45  Integer  Tax Class 5   
TAXBASE1  46  BCD*10.3  Tax Base 1   
TAXBASE2  47  BCD*10.3  Tax Base 2   
TAXBASE3  48  BCD*10.3  Tax Base 3   
TAXBASE4  49  BCD*10.3  Tax Base 4   
TAXBASE5  50  BCD*10.3  Tax Base 5   
TXINCLUDE1  51  BCD*10.3  Included Tax Amount 1   
TXINCLUDE2  52  BCD*10.3  Included Tax Amount 2   
TXINCLUDE3  53  BCD*10.3  Included Tax Amount 3   
TXINCLUDE4  54  BCD*10.3  Included Tax Amount 4   
TXINCLUDE5  55  BCD*10.3  Included Tax Amount 5   
TXEXCLUDE1  56  BCD*10.3  Excluded Tax Amount 1   
TXEXCLUDE2  57  BCD*10.3  Excluded Tax Amount 2   
TXEXCLUDE3  58  BCD*10.3  Excluded Tax Amount 3   
TXEXCLUDE4  59  BCD*10.3  Excluded Tax Amount 4   
TXEXCLUDE5  60  BCD*10.3  Excluded Tax Amount 5   
TAXAMOUNT1  61  BCD*10.3  Tax Amount 1   
TAXAMOUNT2  62  BCD*10.3  Tax Amount 2   
TAXAMOUNT3  63  BCD*10.3  Tax Amount 3   
TAXAMOUNT4  64  BCD*10.3  Tax Amount 4   
TAXAMOUNT5  65  BCD*10.3  Tax Amount 5   
TXALLOAMT1  66  BCD*10.3  Tax Allocated Amount 1   
TXALLOAMT2  67  BCD*10.3  Tax Allocated Amount 2   
TXALLOAMT3  68  BCD*10.3  Tax Allocated Amount 3   
TXALLOAMT4  69  BCD*10.3  Tax Allocated Amount 4   
TXALLOAMT5  70  BCD*10.3  Tax Allocated Amount 5   
TXRECVAMT1  71  BCD*10.3  Tax Recoverable Amount 1   
TXRECVAMT2  72  BCD*10.3  Tax Recoverable Amount 2   
TXRECVAMT3  73  BCD*10.3  Tax Recoverable Amount 3   
TXRECVAMT4  74  BCD*10.3  Tax Recoverable Amount 4   
TXRECVAMT5  75  BCD*10.3  Tax Recoverable Amount 5   
TXEXPSAMT1  76  BCD*10.3  Tax Expense Amount 1   
TXEXPSAMT2  77  BCD*10.3  Tax Expense Amount 2   
TXEXPSAMT3  78  BCD*10.3  Tax Expense Amount 3   
TXEXPSAMT4  79  BCD*10.3  Tax Expense Amount 4   
TXEXPSAMT5  80  BCD*10.3  Tax Expense Amount 5   
TXBASEALLO  81  BCD*10.3  Net of Tax   
TXINCLUDED  82  BCD*10.3  Tax Included   
TXEXCLUDED  83  BCD*10.3  Tax Excluded   
TAXAMOUNT  84  BCD*10.3  Total Tax   
TXRECVAMT  85  BCD*10.3  Total Tax Recoverable   
TXEXPSAMT  86  BCD*10.3  Total Tax Expensed   
TXALLOAMT  87  BCD*10.3  Total Tax Allocated   
SCAMOUNT  88  BCD*10.3  Conversion Source Amount   
FCAMOUNT  89  BCD*10.3  Conversion Functional Amount   
MTOPRORATE  90  BCD*10.3  Manual To Prorate   
TAXLINES  91  Long  Lines Tax Calculation Sees   
ISCOMPLETE  92  Boolean  Completed   
DTCOMPLETE  93  Date  Date Completed   
CURRENCYD  141  String*30  Currency Description   
TERMSCODED  142  String*30  Terms Code Description   
RATETYPED  143  String*30  Rate Type Description   
TAXGROUPD  144  String*30  Tax Group Description   
TAXCLASS1D  145  String*30  Tax Class 1 Description   
TAXCLASS2D  146  String*30  Tax Class 2 Description   
TAXCLASS3D  147  String*30  Tax Class 3 Description   
TAXCLASS4D  148  String*30  Tax Class 4 Description   
TAXCLASS5D  149  String*30  Tax Class 5 Description   
TAXAUTH1D  150  String*30  Tax Authority 1 Description   
TAXAUTH2D  151  String*30  Tax Authority 2 Description   
TAXAUTH3D  152  String*30  Tax Authority 3 Description   
TAXAUTH4D  153  String*30  Tax Authority 4 Description   
TAXAUTH5D  154  String*30  Tax Authority 5 Description   
TCBASEALLO  155  BCD*10.3  Allocated Base Amount Sum   
TCINCLUDE1  156  BCD*10.3  Tax Included 1 Sum   
TCINCLUDE2  157  BCD*10.3  Tax Included 2 Sum   
TCINCLUDE3  158  BCD*10.3  Tax Included 3 Sum   
TCINCLUDE4  159  BCD*10.3  Tax Included 4 Sum   
TCINCLUDE5  160  BCD*10.3  Tax Included 5 Sum   
TCALLOAMT1  161  BCD*10.3  Tax Allocated Amount 1 Sum   
TCALLOAMT2  162  BCD*10.3  Tax Allocated Amount 2 Sum   
TCALLOAMT3  163  BCD*10.3  Tax Allocated Amount 3 Sum   
TCALLOAMT4  164  BCD*10.3  Tax Allocated Amount 4 Sum   
TCALLOAMT5  165  BCD*10.3  Tax Allocated Amount 5 Sum   
TCRECVAMT1  166  BCD*10.3  Tax Recoverable Amount 1 Sum   
TCRECVAMT2  167  BCD*10.3  Tax Recoverable Amount 2 Sum   
TCRECVAMT3  168  BCD*10.3  Tax Recoverable Amount 3 Sum   
TCRECVAMT4  169  BCD*10.3  Tax Recoverable Amount 4 Sum   
TCRECVAMT5  170  BCD*10.3  Tax Recoverable Amount 5 Sum   
TCEXPSAMT1  171  BCD*10.3  Tax Expense Amount 1 Sum   
TCEXPSAMT2  172  BCD*10.3  Tax Expense Amount 2 Sum   
TCEXPSAMT3  173  BCD*10.3  Tax Expense Amount 3 Sum   
TCEXPSAMT4  174  BCD*10.3  Tax Expense Amount 4 Sum   
TCEXPSAMT5  175  BCD*10.3  Tax Expense Amount 5 Sum   
TCALLOAMT  176  BCD*10.3  Total Tax Allocated   
TCINCLUDED  177  BCD*10.3  Tax Included   
TCEXCLUDED  178  BCD*10.3  Tax Excluded   
UBALTAXAMT  179  BCD*10.3  Total Unbalanced Tax   
UBALTXALLO  180  BCD*10.3  Total Unbalanced Allocated Tax   
TPBASEALLO  181  BCD*10.3  Primary Net of Tax   
TPINCLUDE1  182  BCD*10.3  Primary Included Tax Amount 1   
TPINCLUDE2  183  BCD*10.3  Primary Included Tax Amount 2   
TPINCLUDE3  184  BCD*10.3  Primary Included Tax Amount 3   
TPINCLUDE4  185  BCD*10.3  Primary Included Tax Amount 4   
TPINCLUDE5  186  BCD*10.3  Primary Included Tax Amount 5   
TPALLOAMT1  187  BCD*10.3  Primary Tax Allocated Amount 1   
TPALLOAMT2  188  BCD*10.3  Primary Tax Allocated Amount 2   
TPALLOAMT3  189  BCD*10.3  Primary Tax Allocated Amount 3   
TPALLOAMT4  190  BCD*10.3  Primary Tax Allocated Amount 4   
TPALLOAMT5  191  BCD*10.3  Primary Tax Allocated Amount 5   
TPRECVAMT1  192  BCD*10.3  Primary Tax Recoverable Amount 1   
TPRECVAMT2  193  BCD*10.3  Primary Tax Recoverable Amount 2   
TPRECVAMT3  194  BCD*10.3  Primary Tax Recoverable Amount 3   
TPRECVAMT4  195  BCD*10.3  Primary Tax Recoverable Amount 4   
TPRECVAMT5  196  BCD*10.3  Primary Tax Recoverable Amount 5   
TPEXPSAMT1  197  BCD*10.3  Primary Tax Expense Amount 1   
TPEXPSAMT2  198  BCD*10.3  Primary Tax Expense Amount 2   
TPEXPSAMT3  199  BCD*10.3  Primary Tax Expense Amount 3   
TPEXPSAMT4  200  BCD*10.3  Primary Tax Expense Amount 4   
TPEXPSAMT5  201  BCD*10.3  Primary Tax Expense Amount 5   
PAMOUNT  202  BCD*10.3  Amount   
SUBTOTAL  203  BCD*10.3  Subtotal   
VEND  204  Long  Vendors   
VENDCMPL  205  Long  Vendors Completed   
VENDINVC  206  Long  Vendors Invoiced   
PENDINGCAL  207  Boolean  Tax calculation is pending   
LOCKED  208  Boolean  Document Locked   
RATEEXISTS  209  Boolean  Exchange Rate Exists   
ISPRIMARY  210  Boolean  Is This Vendor Primary?   
HASDETAILS  211  Boolean  Has Details   
PTAXLINES  212  Long  Lines Tax Calculation Sees   

This page was generated on 2003-Apr-12

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