Table: Vendors

Table: APVEN
View: AP0015
Record Length: 1758

Flags: A R 

Keys: 3

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

Fields: 133

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:4 entries
0 = Mail
2 = Email (vendor)
4 = Email (contact)
5 = Email (multiple contacts)
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
LEGALNAME String*60 Legal Name
CHK1099AMT Integer Zero 1099 Amount Warning List:2 entries
0 = None
1 = Warning
IDCUST String*12 Customer Number
BRN String*30 Business Registration Number

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).