View: Vendors

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

Compositions: 2

RotoID Tables Title DLL
AP0407 APVENO Vendor Optional Field Values APVENO
AP0222 Vendor Contact Selection APVENMT

Keys: 3

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

Fields: 134

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: (%-3C) %-3C-%-24C
TEXTPHON2 21 String*30 Fax Number E A P  Mask: (%-3C) %-3C-%-24C
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: (%-3C) %-3C-%-24C
CTACFAX 125 String*30 Contact's Fax E A P  Mask: (%-3C) %-3C-%-24C
DELMETHOD 126 Integer Delivery Method E A P  List:4 entries
0 = Mail
2 = Email (vendor)
4 = Email (contact)
5 = Email (multiple contacts)
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 
EWSUPPRESS 138 Boolean Suppress Integration E A 
EWAPVER 139 String*3 A/P Version A 
EWORGID 140 String*6 Database A 
EWMODE 141 Integer Mode E A  List:2 entries
0 = Normal Mode
1 = Unconditional Inserts/Updates
BRN 142 String*30 Business Registration Number E A 

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).