Table: Vendor Statistics

Table: APVSM
View: AP0019
Record length: 267
Flags: A R 

Keys: 1

Title  Flags  Fields

Vendor Statistics Key  VENDORID, CNTYR, CNTPERD

Fields: 37

Field  Type  Title  Presentation 

VENDORID  String*12  Vendor Number  Mask: %-12C
CNTYR  String*4  Year  Mask: %04D
CNTPERD  String*2  Period  Mask: %02D
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
CNTINVC  BCD*3.0  Number of Invoices   
CNTCR  BCD*3.0  Number of Credit Notes   
CNTDR  BCD*3.0  Number of Debit Notes   
CNTPAYM  BCD*3.0  Number of Payments   
CNTDISC  BCD*3.0  Number of Discounts   
CNTLOST  BCD*3.0  Number of Discounts Lost   
CNTADJ  BCD*3.0  Number of Adjustments   
CNTINVCPD  BCD*3.0  Number of Paid Invoices   
CNTDTOPAY  BCD*3.0  Number of Days to Pay   
AMTINVCHC  BCD*10.3  Total Invoices in Func. Currency   
AMTCRHC  BCD*10.3  Total Credits in Func. Currency   
AMTDRHC  BCD*10.3  Total Debits in Func. Currency   
AMTPAYMHC  BCD*10.3  Total Payments in Func. Currency   
AMTDISCHC  BCD*10.3  Total Discounts in Func. Curr.   
AMTLOSTHC  BCD*10.3  Total Discounts Lost - Func. Curr.   
AMTADJHC  BCD*10.3  Total Adjustments in Func. Curr.   
AMTPURHC  BCD*10.3  Reserved   
AMTINVPDHC  BCD*10.3  Total Invoices Pd. in Func. Curr.   
AMTINVCTC  BCD*10.3  Total Invoices in Vend. Curr.   
AMTCRTC  BCD*10.3  Total Credits in Vend. Curr.   
AMTDRTC  BCD*10.3  Total Debits in Vend. Curr.   
AMTPAYMTC  BCD*10.3  Total Payments in Vend. Curr.   
AMTDISCTC  BCD*10.3  Total Discounts in Vend. Curr.   
AMTLOSTTC  BCD*10.3  Total Discounts Lost in Vend. Curr.   
AMTADJTC  BCD*10.3  Total Adjustments in Vend. Curr.   
AMTPURTC  BCD*10.3  Reserved   
AMTINPDTC  BCD*10.3  Total Invoices Pd. in Vend. Curr.   
AMTBLRVLTC  BCD*10.3  Revaluation Bal. in Vend. Curr.   
CNTPUR  BCD*3.0  Reserved   
AVGDAYSPAY  BCD*5.1  Average Days to Pay   

This page was generated on 2009-Nov-19

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