# View: Update Statistics

RotoID: AR0060
Protocol: Superview
DLL: ARSTAT

## Compositions: 0

## Keys: 0

## Fields: 46

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
ITEMNBR | 1 | String*16 | Item Number | E A | Mask: %-16C
IDCUST | 2 | String*12 | Customer Number | E A | Mask: %-12C
DATEBDATE | 3 | Date | Transaction Date | E A |
SWCODETYPE | 4 | Integer | Transaction Type | E A | List: 15 entries
1 | = | Invoice
2 | = | Debit note
3 | = | Credit note
4 | = | Interest
5 | = | Returned check
7 | = | Current payment
9 | = | Adjustment
12 | = | Prepayment
13 | = | Earned discount
16 | = | Exchange Gain/Loss
17 | = | Rounding
35 | = | Refund
40 | = | Memo resolution
80 | = | Batch writeoff
81 | = | Batch adjustment
AMTHCUR | 5 | BCD*10.3 | Functional Amount | E A |
AMTTCUR | 6 | BCD*10.3 | Source Amount | E A |
AMTTAXHCUR | 7 | BCD*10.3 | Functional Tax Amount | E A |
AMTTAXTCUR | 8 | BCD*10.3 | Source Tax Amount | E A |
AMTCOGSHC | 9 | BCD*10.3 | Func. COGS Amount | E A |
CNTPAYDAYS | 10 | BCD*4.0 | Number of Days Between Payments | E A |
SWRVSL | 11 | Integer | Reversal | E A | List: 3 entries
0 | = | No reversal
1 | = | Reversal
2 | = | Do not update
SLSP1 | 12 | String*8 | Salesperson 1 | E A | Mask: %-8N
SLSPSPLT1 | 13 | BCD*5.5 | Sales-Split Percentage 1 | E A |
SLSP2 | 14 | String*8 | Salesperson 2 | E A | Mask: %-8N
SLSPSPLT2 | 15 | BCD*5.5 | Sales-Split Percentage 2 | E A |
SLSP3 | 16 | String*8 | Salesperson 3 | E A | Mask: %-8N
SLSPSPLT3 | 17 | BCD*5.5 | Sales-Split Percentage 3 | E A |
SLSP4 | 18 | String*8 | Salesperson 4 | E A | Mask: %-8N
SLSPSPLT4 | 19 | BCD*5.5 | Sales-Split Percentage 4 | E A |
SLSP5 | 20 | String*8 | Salesperson 5 | E A | Mask: %-8N
SLSPSPLT5 | 21 | BCD*5.5 | Sales-Split Percentage 5 | E A |
SWINVFULPD | 22 | Integer | Invoice Fully Paid | E A | List: 3 entries
0 | = | Not fully paid
1 | = | Fully paid
2 | = | Unpaid
QTYITEMS | 23 | BCD*10.5 | Quantity Sold | E A |
SWCSMSTATS | 24 | Integer | Update Customer Statistics | E A | List: 2 entries
0 | = | Do not process
1 | = | Process
SWGSMSTATS | 25 | Integer | Update Group Statistics | E A | List: 2 entries
0 | = | Do not process
1 | = | Process
SWITSSTATS | 26 | Integer | Update Item Statistics | E A | List: 2 entries
0 | = | Do not process
1 | = | Process
SWNSMSTATS | 27 | Integer | Update National Acct. Statistics | E A | List: 2 entries
0 | = | Do not process
1 | = | Process
SWSPSSTATS | 28 | Integer | Update Salesperson Statistics | E A | List: 2 entries
0 | = | Do not process
1 | = | Process
DATELSTSAL | 29 | Date | Last Date Sold | E A |
IDUNITMEAS | 30 | String*10 | Unit of Measure | E A | Mask: %-10C
AMTINVCHC | 31 | BCD*10.3 | Fully Paid Invoice Amount in Fun | E A |
AMTINVCTC | 32 | BCD*10.3 | Fully Paid Invoice Amount in Cus | E A |
BTCHTYPE | 33 | String*2 | Posting Batch Type | E A |
FISCYR | 34 | String*4 | Fiscal Year | E A | Mask: %04D
FISCPER | 35 | String*2 | Fiscal Period | E A | Mask: %02D
IDNATACCT | 36 | String*12 | National Account Number | E A | Mask: %-12C
IDGRP | 37 | String*6 | Group Code | E A | Mask: %-6N
CURRPERDCU | 38 | String*2 | Cust. Current Period Based on Session Date | E A | Mask: %02D
MAXPERDCU | 39 | Integer | Cust. Maximum Period for Setting | E A |
CURRPERDIT | 40 | String*2 | Item Current Period Based on Session Date | E A | Mask: %02D
MAXPERDIT | 41 | Integer | Item Maximum Period for Setting | E A |
CURRPERDSA | 42 | String*2 | Sales Current Period Based on Session Date | E A | Mask: %02D
MAXPERDSA | 43 | Integer | Sales Maximum Period for Setting | E A |
CURRYEARCU | 44 | String*4 | Cust. Current Year Based on Session Date | E A | Mask: %04D
CURRYEARIT | 45 | String*4 | Item Current Year Based on Session Date | E A | Mask: %04D
CURRYEARSA | 46 | String*4 | Sales Current Year Based on Session Date | E A | Mask: %04D

This page was generated on 2009-Nov-19

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