# Table: Commissions

Table: OECOMM
View: OE0200
Record length: 255
Flags: A R

## Keys: 3

Title | Flags | Fields
--- | --- | ---
Salesperson/Customer |  | SALESPER, DAYENDNUM, ENTRYNUM, SALESPNUM
Date/Salesperson/Fiscalyear/Cust | M | DATE, SALESPER, FISCYR, FISCPER, DAYENDNUM, ENTRYNUM, SALESPNUM
FiscalYear/Salesperson/Date/Cust | M | FISCYR, FISCPER, SALESPER, DATE, DAYENDNUM, ENTRYNUM, SALESPNUM

## Fields: 26

Field | Type | Title | Presentation
--- | --- | --- | ---
SALESPER | String*8 | Salesperson Number | Mask: %-8N
DAYENDNUM | Long | Day End Number |
ENTRYNUM | Long | Entry Number |
SALESPNUM | Integer | Salesperson Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
CUSTOMER | String*12 | Customer Number | Mask: %-12C
CUSTNAME | String*60 | Customer Name |
TRANSTYPE | Integer | Transaction Type | List: 4 entries
1 | = | Invoice
2 | = | Credit Note
3 | = | Shipment
4 | = | Debit Note
DOCNUM | String*22 | Document Number | Mask: %-22C
DATE | Date | Transaction Date |
TERRITORY | String*6 | Territory | Mask: %-6N
CATSALES | BCD*10.3 | Category Sales |
CATCOST | BCD*10.3 | Cost of Category Sales |
CATCOMM | BCD*10.3 | Commission on Category Sales |
NONCATSALE | BCD*10.3 | Noncategory Sales |
NONCATCOST | BCD*10.3 | Cost of Noncategory Sales |
NONCATCOM1 | BCD*10.3 | Commission on Noncat. Sales 1 |
NONCATCOM2 | BCD*10.3 | Commission on Noncat. Sales 2 |
NONCATCOM3 | BCD*10.3 | Commission on Noncat. Sales 3 |
NONCATCOM4 | BCD*10.3 | Commission on Noncat. Sales 4 |
NONCATCOM5 | BCD*10.3 | Commission on Noncat. Sales 5 |
FISCYR | String*4 | Fiscal Year | Mask: %-4d
FISCPER | Integer | Fiecal Period |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.