Table: Commissions

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

Keys: 1


Title  Flags  Fields
Salesperson/Customer   SALESPER, DAYENDNUM, ENTRYNUM, SALESPNUM

Fields: 24


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*30  Customer Name   
TRANSTYPE  Integer  Transaction Type  List: 2 entries
1=Invoice
2=Credit Note
DOCNUM  String*15  Document Number  Mask: %-15C
DATE  Date  Transaction Date   
TERRITORY  String*2  Territory  Mask: %-2N
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   

This page was generated on 2002-Oct-04

Copyright © 2002 ACCPAC International, Inc. All rights reserved.