Table: Vendor Groups

Table: APVGR
View: AP0016
Record Length: 252

Flags: A R 

Keys: 1

Title Flags Fields
Vendor Group Code GROUPID

Fields: 38

Field Type Title Presentation
GROUPID String*6 Group Code Mask: %-6N
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
DESCRIPTN String*60 Description
ACTIVESW Integer Status List:2 entries
0 = Inactive
1 = Active
INACTIVEDT Date Inactive Date
LSTMNTDATE Date Date Last Maintained
ACCTSETID String*6 Account Set Mask: %-6N
CURNCODE String*3 Currency Code Mask: %-3N
RATETYPEID String*2 Rate Type Mask: %-2N
BANKID String*8 Bank Code Mask: %-8N
PRTSEPCHKS Integer Print Separate Checks List:2 entries
0 = No
1 = Yes
DISTSETID String*6 Distribution Set Mask: %-6N
DISTCODE String*6 Distribution Code Mask: %-6N
GLACCTID String*45 General Ledger Account No. Mask: %-45C
TERMCODE String*6 Terms Mask: %-6N
DUPLINVC Integer Reserved
DUPLAMT Integer Duplicate Amount Code List:3 entries
0 = None
1 = Warning
2 = Error
DUPLDATE Integer Duplicate Date Code List:3 entries
0 = None
1 = Warning
2 = Error
TAXGRP String*12 Tax Group Mask: %-12N
TAXCLASS1 Integer Tax Class 1
TAXCLASS2 Integer Tax Class 2
TAXCLASS3 Integer Tax Class 3
TAXCLASS4 Integer Tax Class 4
TAXCLASS5 Integer Tax Class 5
TAXRPTSW Integer Tax Reporting Type List:3 entries
0 = None
1 = 1099
2 = CPRS
SUBJWTHHSW Integer Reserved
CLASSID String*6 1099/CPRS Code Mask: %-6N
PAYMCODE String*12 Payment Code Mask: %-12N
SWDISTBY Integer Distribution Type List:4 entries
0 = Distribution Set
1 = Distribution Code
2 = G/L Account
3 = None
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
VALUES Long Optional Fields

This page was generated on 2022-Aug-18

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