# Table: Vendors

Table: APVEN
View: AP0015
Record length: 1644
Flags: A R

## Keys: 3

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

## Fields: 128

Field | Type | Title | Presentation
--- | --- | --- | ---
VENDORID | String*12 | Vendor Number | Mask: %-12C
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
SHORTNAME | String*10 | Short Name |
IDGRP | String*6 | Group Code | Mask: %-6N
SWACTV | Integer | Status | List: 2 entries
0 | = | Inactive
1 | = | Active
DATEINAC | Date | Inactive Date |
DATELASTMN | Date | Date Last Maintained |
SWHOLD | Integer | On Hold | List: 2 entries
0 | = | Not On Hold
1 | = | On Hold
DATESTART | Date | Start Date |
IDPPNT | String*12 | Participant ID |
VENDNAME | String*60 | Vendor Name |
TEXTSTRE1 | String*60 | Address Line 1 |
TEXTSTRE2 | String*60 | Address Line 2 |
TEXTSTRE3 | String*60 | Address Line 3 |
TEXTSTRE4 | String*60 | Address Line 4 |
NAMECITY | String*30 | City |
CODESTTE | String*30 | State/Prov. |
CODEPSTL | String*20 | Zip/Postal Code |
CODECTRY | String*30 | Country |
NAMECTAC | String*60 | Contact Name |
TEXTPHON1 | String*30 | Phone Number | Mask: (%-3C) %-3C-%-24C
TEXTPHON2 | String*30 | Fax Number | Mask: (%-3C) %-3C-%-24C
PRIMRMIT | String*6 | Primary Remit-To Location | Mask: %-6N
IDACCTSET | String*6 | Account Set | Mask: %-6N
CURNCODE | String*3 | Currency Code | Mask: %-3N
RATETYPE | String*2 | Rate Type | Mask: %-2N
BANKID | String*8 | Bank Code | Mask: %-8N
PRTSEPCHKS | Integer | Print Separate Checks | List: 2 entries
0 | = | Do Not Print Separate Checks
1 | = | Print Separate Checks
DISTSETID | String*6 | Distribution Set | Mask: %-6N
DISTCODE | String*6 | Distribution Code | Mask: %-6N
GLACCNT | String*45 | G/L Account | Mask: %-45C
TERMSCODE | String*6 | Terms | Mask: %-6N
DUPINVCCD | Integer | Reserved |
DUPAMTCODE | Integer | Duplicate Amount Code | List: 3 entries
0 | = | None
1 | = | Warning
2 | = | Error
DUPDATECD | Integer | Duplicate Date Code | List: 3 entries
0 | = | None
1 | = | Warning
2 | = | Error
CODETAXGRP | String*12 | Tax Group | Mask: %-12N
TAXCLASS1 | Integer | Tax Class Code 1 |
TAXCLASS2 | Integer | Tax Class Code 2 |
TAXCLASS3 | Integer | Tax Class Code 3 |
TAXCLASS4 | Integer | Tax Class Code 4 |
TAXCLASS5 | Integer | Tax Class Code 5 |
TAXRPTSW | Integer | Tax Reporting Type | List: 3 entries
0 | = | None
1 | = | 1099
2 | = | CPRS
SUBJTOWTHH | Integer | Reserved |
TAXNBR | String*20 | 1099/CPRS Tax Number |
TAXIDTYPE | Integer | Tax Type | 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 | Integer | Reserved |
CLASID | String*6 | 1099/CPRS Code | Mask: %-6N
AMTCRLIMT | BCD*10.3 | Credit Limit |
AMTBALDUET | BCD*10.3 | Balance Due in Vendor Currency |
AMTBALDUEH | BCD*10.3 | Balance Due in Func. Currency |
AMTPPDINVT | BCD*10.3 | Total Prepaid Invoice Vend. Curr |
AMTPPDINVH | BCD*10.3 | Total Prepaid Invoice Func. Curr |
DTLASTRVAL | Date | Date of Last Revaluation |
AMTBALLARV | BCD*10.3 | Last Revaluation Balance |
CNTOPENINV | BCD*4.0 | Number of Open Invoices |
CNTPPDINVC | BCD*4.0 | Number of Prepaid Invoices |
CNTINVPAID | BCD*4.0 | Number of Paid Invoices |
DAYSTOPAY | BCD*4.0 | Number of Days to Pay |
DATEINVCHI | Date | Date of Largest Invoice |
DATEBALHI | Date | Date of Highest Balance |
DATEINVHIL | Date | Date of Largest Invoice Last Yr. |
DATEBALHIL | Date | Date of Highest Balance Last Yr. |
DATELASTAC | Date | Date of Last Activity |
DATELASTIV | Date | Date of Last Invoice |
DATELASTCR | Date | Date of Last Credit Note |
DATELASTDR | Date | Date of Last Debit Note |
DATELASTPA | Date | Date of Last Payment |
DATELASTDI | Date | Date of Last Discount |
DATELSTADJ | Date | Date of Last Adjustment |
IDINVCHI | String*22 | Number of Largest Invoice | Mask: %-22C
IDINVCHILY | String*22 | Number of Largest Invoice Last Y | Mask: %-22C
AMTINVHIT | BCD*10.3 | Largest Invoice - Vend. Curr. |
AMTBALHIT | BCD*10.3 | Highest Balance - Vend. Curr. |
AMTWTHTCUR | BCD*10.3 | Reserved |
AMTINVHILT | BCD*10.3 | Larg. Inv. Last Yr. Vend. Curr. |
AMTBALHILT | BCD*10.3 | High Bal. Last Yr. - Vend. Curr. |
AMTWTHLYTC | BCD*10.3 | Reserved |
AMTLASTIVT | BCD*10.3 | Last Invoice Amt - Vend. Curr. |
AMTLASTCRT | BCD*10.3 | Last Cr. Note Amt. - Vend. Curr. |
AMTLASTDRT | BCD*10.3 | Last Dr. Note Amt. - Vend. Curr. |
AMTLASTPYT | BCD*10.3 | Last Payment - Vend. Curr. |
AMTLASTDIT | BCD*10.3 | Last Discount Amt. - Vend. Curr. |
AMTLASTADT | BCD*10.3 | Last Adj. Amt. - Vend. Curr. |
AMTINVHIH | BCD*10.3 | Largest Invoice - Func. Curr. |
AMTBALHIH | BCD*10.3 | Highest Balance - Func. Curr. |
AMTWTHHCUR | BCD*10.3 | Reserved |
AMTINVHILH | BCD*10.3 | Larg. Inv. Last Yr. Func. Curr. |
AMTBALHILH | BCD*10.3 | High Bal. Last Yr. Func. Curr. |
AMTWTHLYHC | BCD*10.3 | Reserved |
AMTLASTIVH | BCD*10.3 | Last Invoice Amt. - Func. Curr. |
AMTLASTCRH | BCD*10.3 | Last Cr. Note Amt. - Func. Curr. |
AMTLASTDRH | BCD*10.3 | Last Dr. Note Amt. - Func. Curr. |
AMTLASTPYH | BCD*10.3 | Last Payment - Func. Curr. |
AMTLASTDIH | BCD*10.3 | Last Discount Amt. - Func. Curr. |
AMTLASTADH | BCD*10.3 | Last Adj. Amt. - Func. Curr. |
PAYMFORM | String*6 | Reserved |
IDTAXREGI1 | String*20 | Tax Registration Code 1 |
IDTAXREGI2 | String*20 | Tax Registration Code 2 |
IDTAXREGI3 | String*20 | Tax Registration Code 3 |
IDTAXREGI4 | String*20 | Tax Registration Code 4 |
IDTAXREGI5 | String*20 | Tax Registration Code 5 |
SWDISTBY | Integer | Distribution Type | List: 4 entries
0 | = | Distribution Set
1 | = | Distribution Code
2 | = | G/L Account
3 | = | None
CODECHECK | String*3 | Check Language | List: 5 entries
1 | = | ENG
2 | = | FRA
3 | = | ESN
4 | = | AUS
5 | = | MEX
AVGDAYSPAY | BCD*5.1 | Average Days to Pay |
AVGPAYMENT | BCD*10.3 | Reserved |
AMTINVPDHC | BCD*10.3 | Total Invoices Paid - Func. Curr |
AMTINVPDTC | BCD*10.3 | Total Invoices Paid - Vend. Curr |
CNTNBRCHKS | BCD*4.0 | Total Number of Checks |
SWTXINC1 | Integer | Tax Included 1 | List: 2 entries
0 | = | No
1 | = | Yes
SWTXINC2 | Integer | Tax Included 2 | List: 2 entries
0 | = | No
1 | = | Yes
SWTXINC3 | Integer | Tax Included 3 | List: 2 entries
0 | = | No
1 | = | Yes
SWTXINC4 | Integer | Tax Included 4 | List: 2 entries
0 | = | No
1 | = | Yes
SWTXINC5 | Integer | Tax Included 5 | List: 2 entries
0 | = | No
1 | = | Yes
EMAIL1 | String*50 | Contact's E-mail |
EMAIL2 | String*50 | E-mail |
WEBSITE | String*100 | Web Site |
CTACPHONE | String*30 | Contact's Phone | Mask: (%-3C) %-3C-%-24C
CTACFAX | String*30 | Contact's Fax | Mask: (%-3C) %-3C-%-24C
DELMETHOD | Integer | Delivery Method | List: 3 entries
0 | = | Mail
2 | = | E-mail
4 | = | Contact's E-mail
RTGPERCENT | BCD*5.5 | Percent Retained |
RTGDAYS | Integer | Days Retained |
RTGTERMS | String*6 | Retainage Terms Code | Mask: %-6N
RTGAMTTC | BCD*10.3 | Amount Retained - Vend. Curr. |
RTGAMTHC | BCD*10.3 | Amount Retained - Func. Curr. |
VALUES | Long | Optional Fields |

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.