Table: Vendors

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

Keys: 3

Title  Flags  Fields

Vendor Number  VENDORID
Vendor Short Name  D M  SHORTNAME
Group Code  D M  IDGRP

Fields: 129

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 Yr.  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.   
PAYMCODE  String*12  Payment Code  Mask: %-12N
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: 7 entries
1=ENG
2=FRA
3=ESN
4=AUS
5=MEX
6=CHN
7=CHT
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 Payments   
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   
NEXTCUID  Long  Next Client Unique ID   

This page was generated on 2008-May-01

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