# View: Vendors

RotoID: AP0015
Table: APVEN
Protocol: Header
DLL: APVEN

## Compositions: 1

RotoID | Tables | Title | DLL
--- | --- | --- | ---
AP0407 | APVENO | Vendor Optional Field Values | APVENO

## Keys: 3

Title | Fields
--- | ---
Vendor Number | VENDORID
Vendor Short Name | SHORTNAME
Group Code | IDGRP

## Fields: 129

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
VENDORID | 1 | String*12 | Vendor Number | E A K R | Mask: %-12C
SHORTNAME | 2 | String*10 | Short Name | E A |
IDGRP | 3 | String*6 | Group Code | E A | Mask: %-6N
SWACTV | 4 | Integer | Status | E A | List: 2 entries
0 | = | Inactive
1 | = | Active
DATEINAC | 5 | Date | Inactive Date | E A C |
DATELASTMN | 6 | Date | Date Last Maintained | E A C |
SWHOLD | 7 | Integer | On Hold | E A | List: 2 entries
0 | = | Not On Hold
1 | = | On Hold
DATESTART | 8 | Date | Start Date | E A |
IDPPNT | 9 | String*12 | Participant ID | A |
VENDNAME | 10 | String*60 | Vendor Name | E A |
TEXTSTRE1 | 11 | String*60 | Address Line 1 | E A |
TEXTSTRE2 | 12 | String*60 | Address Line 2 | E A |
TEXTSTRE3 | 13 | String*60 | Address Line 3 | E A |
TEXTSTRE4 | 14 | String*60 | Address Line 4 | E A |
NAMECITY | 15 | String*30 | City | E A |
CODESTTE | 16 | String*30 | State/Prov. | E A |
CODEPSTL | 17 | String*20 | Zip/Postal Code | E A |
CODECTRY | 18 | String*30 | Country | E A |
NAMECTAC | 19 | String*60 | Contact Name | E A |
TEXTPHON1 | 20 | String*30 | Phone Number | E A P | Mask: %-30c
TEXTPHON2 | 21 | String*30 | Fax Number | E A P | Mask: %-30c
PRIMRMIT | 22 | String*6 | Primary Remit-To Location | E A C | Mask: %-6N
IDACCTSET | 23 | String*6 | Account Set | E A | Mask: %-6N
CURNCODE | 24 | String*3 | Currency Code | E A C | Mask: %-3N
RATETYPE | 25 | String*2 | Rate Type | E A | Mask: %-2N
BANKID | 26 | String*8 | Bank Code | E A | Mask: %-8N
PRTSEPCHKS | 27 | Integer | Print Separate Checks | E A | List: 2 entries
0 | = | Do Not Print Separate Checks
1 | = | Print Separate Checks
DISTSETID | 28 | String*6 | Distribution Set | E A | Mask: %-6N
DISTCODE | 29 | String*6 | Distribution Code | E A | Mask: %-6N
GLACCNT | 30 | String*45 | G/L Account | E A | Mask: %-45C
TERMSCODE | 31 | String*6 | Terms | E A | Mask: %-6N
DUPINVCCD | 32 | Integer | Reserved | E |
DUPAMTCODE | 33 | Integer | Duplicate Amount Code | E A | List: 3 entries
0 | = | None
1 | = | Warning
2 | = | Error
DUPDATECD | 34 | Integer | Duplicate Date Code | E A | List: 3 entries
0 | = | None
1 | = | Warning
2 | = | Error
CODETAXGRP | 35 | String*12 | Tax Group | E A | Mask: %-12N
TAXCLASS1 | 36 | Integer | Tax Class Code 1 | E A |
TAXCLASS2 | 37 | Integer | Tax Class Code 2 | E A |
TAXCLASS3 | 38 | Integer | Tax Class Code 3 | E A |
TAXCLASS4 | 39 | Integer | Tax Class Code 4 | E A |
TAXCLASS5 | 40 | Integer | Tax Class Code 5 | E A |
TAXRPTSW | 41 | Integer | Tax Reporting Type | E A | List: 3 entries
0 | = | None
1 | = | 1099
2 | = | CPRS
SUBJTOWTHH | 42 | Integer | Reserved | E |
TAXNBR | 43 | String*20 | 1099/CPRS Tax Number | E A |
TAXIDTYPE | 44 | Integer | Tax Type | E A | List: 6 entries
0 | = | Unknown
1 | = | Social Security Number
2 | = | Employer ID Number
3 | = | GST Registration Number
4 | = | Business Number
5 | = | Social Insurance Number
TAXNOTE2SW | 45 | Integer | Reserved | E |
CLASID | 46 | String*6 | 1099/CPRS Code | E A | Mask: %-6N
AMTCRLIMT | 47 | BCD*10.3 | Credit Limit | E A |
AMTBALDUET | 48 | BCD*10.3 | Balance Due in Vendor Currency | E A C |
AMTBALDUEH | 49 | BCD*10.3 | Balance Due in Func. Currency | E A C |
AMTPPDINVT | 50 | BCD*10.3 | Total Prepaid Invoice Vend. Curr. | E A C |
AMTPPDINVH | 51 | BCD*10.3 | Total Prepaid Invoice Func. Curr. | E A C |
DTLASTRVAL | 52 | Date | Date of Last Revaluation | E A |
AMTBALLARV | 53 | BCD*10.3 | Last Revaluation Balance | E A |
CNTOPENINV | 54 | BCD*4.0 | Number of Open Invoices | E A C |
CNTPPDINVC | 55 | BCD*4.0 | Number of Prepaid Invoices | E A C |
CNTINVPAID | 56 | BCD*4.0 | Number of Paid Invoices | E A |
DAYSTOPAY | 57 | BCD*4.0 | Number of Days to Pay | E A |
DATEINVCHI | 58 | Date | Date of Largest Invoice | E A |
DATEBALHI | 59 | Date | Date of Highest Balance | E A |
DATEINVHIL | 60 | Date | Date of Largest Invoice Last Yr. | E A |
DATEBALHIL | 61 | Date | Date of Highest Balance Last Yr. | E A |
DATELASTAC | 62 | Date | Date of Last Activity | E A C |
DATELASTIV | 63 | Date | Date of Last Invoice | E A |
DATELASTCR | 64 | Date | Date of Last Credit Note | E A |
DATELASTDR | 65 | Date | Date of Last Debit Note | E A |
DATELASTPA | 66 | Date | Date of Last Payment | E A |
DATELASTDI | 67 | Date | Date of Last Discount | E A |
DATELSTADJ | 68 | Date | Date of Last Adjustment | E A |
IDINVCHI | 69 | String*22 | Number of Largest Invoice | E A C | Mask: %-22C
IDINVCHILY | 70 | String*22 | Number of Largest Invoice Last Yr. | E A C | Mask: %-22C
AMTINVHIT | 71 | BCD*10.3 | Largest Invoice - Vend. Curr. | E A |
AMTBALHIT | 72 | BCD*10.3 | Highest Balance - Vend. Curr. | E A |
AMTWTHTCUR | 73 | BCD*10.3 | Reserved | E |
AMTINVHILT | 74 | BCD*10.3 | Larg. Inv. Last Yr. Vend. Curr. | E A |
AMTBALHILT | 75 | BCD*10.3 | High Bal. Last Yr. - Vend. Curr. | E A |
AMTWTHLYTC | 76 | BCD*10.3 | Reserved | E |
AMTLASTIVT | 77 | BCD*10.3 | Last Invoice Amt - Vend. Curr. | E A |
AMTLASTCRT | 78 | BCD*10.3 | Last Cr. Note Amt. - Vend. Curr. | E A |
AMTLASTDRT | 79 | BCD*10.3 | Last Dr. Note Amt. - Vend. Curr. | E A |
AMTLASTPYT | 80 | BCD*10.3 | Last Payment - Vend. Curr. | E A |
AMTLASTDIT | 81 | BCD*10.3 | Last Discount Amt. - Vend. Curr. | E A |
AMTLASTADT | 82 | BCD*10.3 | Last Adj. Amt. - Vend. Curr. | E A |
AMTINVHIH | 83 | BCD*10.3 | Largest Invoice - Func. Curr. | E A |
AMTBALHIH | 84 | BCD*10.3 | Highest Balance - Func. Curr. | E A |
AMTWTHHCUR | 85 | BCD*10.3 | Reserved | E |
AMTINVHILH | 86 | BCD*10.3 | Larg. Inv. Last Yr. Func. Curr. | E A |
AMTBALHILH | 87 | BCD*10.3 | High Bal. Last Yr. Func. Curr. | E A |
AMTWTHLYHC | 88 | BCD*10.3 | Reserved | E |
AMTLASTIVH | 89 | BCD*10.3 | Last Invoice Amt. - Func. Curr. | E A |
AMTLASTCRH | 90 | BCD*10.3 | Last Cr. Note Amt. - Func. Curr. | E A |
AMTLASTDRH | 91 | BCD*10.3 | Last Dr. Note Amt. - Func. Curr. | E A |
AMTLASTPYH | 92 | BCD*10.3 | Last Payment - Func. Curr. | E A |
AMTLASTDIH | 93 | BCD*10.3 | Last Discount Amt. - Func. Curr. | E A |
AMTLASTADH | 94 | BCD*10.3 | Last Adj. Amt. - Func. Curr. | E A |
PAYMCODE | 103 | String*12 | Payment Code | E A | Mask: %-12N
IDTAXREGI1 | 104 | String*20 | Tax Registration Code 1 | E A |
IDTAXREGI2 | 105 | String*20 | Tax Registration Code 2 | E A |
IDTAXREGI3 | 106 | String*20 | Tax Registration Code 3 | E A |
IDTAXREGI4 | 107 | String*20 | Tax Registration Code 4 | E A |
IDTAXREGI5 | 108 | String*20 | Tax Registration Code 5 | E A |
SWDISTBY | 109 | Integer | Distribution Type | E A | List: 4 entries
0 | = | Distribution Set
1 | = | Distribution Code
2 | = | G/L Account
3 | = | None
CODECHECK | 110 | String*3 | Check Language | E A P | List: 7 entries
1 | = | ENG
2 | = | FRA
3 | = | ESN
4 | = | AUS
5 | = | MEX
6 | = | CHN
7 | = | CHT
AVGDAYSPAY | 111 | BCD*5.1 | Average Days to Pay | E A C |
AVGPAYMENT | 112 | BCD*10.3 | Reserved | E |
AMTINVPDHC | 113 | BCD*10.3 | Total Invoices Paid - Func. Curr. | E A |
AMTINVPDTC | 114 | BCD*10.3 | Total Invoices Paid - Vend. Curr. | E A |
CNTNBRCHKS | 115 | BCD*4.0 | Total Number of Payments | E A |
SWTXINC1 | 116 | Integer | Tax Included 1 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTXINC2 | 117 | Integer | Tax Included 2 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTXINC3 | 118 | Integer | Tax Included 3 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTXINC4 | 119 | Integer | Tax Included 4 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTXINC5 | 120 | Integer | Tax Included 5 | E A | List: 2 entries
0 | = | No
1 | = | Yes
EMAIL1 | 121 | String*50 | Contact's E-mail | E A |
EMAIL2 | 122 | String*50 | E-mail | E A |
WEBSITE | 123 | String*100 | Web Site | E A |
CTACPHONE | 124 | String*30 | Contact's Phone | E A P | Mask: %-30c
CTACFAX | 125 | String*30 | Contact's Fax | E A P | Mask: %-30c
DELMETHOD | 126 | Integer | Delivery Method | E A | List: 3 entries
0 | = | Mail
2 | = | E-mail
4 | = | Contact's E-mail
RTGPERCENT | 127 | BCD*5.5 | Percent Retained | E A |
RTGDAYS | 128 | Integer | Days Retained | E A |
RTGTERMS | 129 | String*6 | Retainage Terms Code | E A | Mask: %-6N
RTGAMTTC | 130 | BCD*10.3 | Amount Retained - Vend. Curr. | E A C |
RTGAMTHC | 131 | BCD*10.3 | Amount Retained - Func. Curr. | E A C |
VALUES | 132 | Long | Optional Fields | E A C |
PROCESSCMD | 133 | Integer | Process Command Code | E A C | List: 1 entries
0 | = | Insert Optional Fields
NEXTCUID | 134 | Long | Next Client Unique ID | E A |
LEGALNAME | 135 | String*60 | Legal Name | E A |
CHK1099AMT | 136 | Integer | Zero 1099 Amount Warning | E A | List: 2 entries
0 | = | None
1 | = | Warning
IDCUST | 137 | String*12 | Customer Number | E |

This page was generated on 2009-Nov-19

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