Table: Employee

Table: PMSTAFF
View: PM0002
Record length: 601
Flags: A R 

Keys: 1


Title  Flags  Fields
Employee Number   STAFFCODE

Fields: 25


Field  Type  Title  Presentation 
STAFFCODE  String*16  Employee Number  Mask: %-16N
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
NAME  String*60  Name   
COMMENT  String*250  Comments   
INACTIVE  Integer  Status  List: 2 entries
0=Active
1=Inactive
DATELASTMN  Date  Last Maintained   
DATEINACTV  Date  Date Inactive   
GROUP  String*10  Group   
UNITCOST  BCD*10.6  Unit Cost   
PAYRATE  Integer  Pay Rate  List: 4 entries
1=Hour
2=Week
3=Month
4=Annum
STDHOURS  BCD*10.2  Default Hours   
TYPE  Integer  Type  List: 3 entries
1=Salary
2=Timecard
3=Contractor
PAYROLL  String*40  Payroll Code   
BILLRATE  BCD*10.6  Billing Rate   
CCY  String*3  Currency  Mask: %-3N
USERID  String*8  User ID  Mask: %-8C
EMAIL1  String*50  E-mail   
EMAIL2  String*50  E-mail   
PAYTYPE  Integer  Payroll Type  List: 2 entries
3=None
2=Canadian Payroll
EARNCODE  String*16  Earnings Code  Mask: %-16N
ARITEM  String*16  A/R Item No.  Mask: %-16C
UOM  String*10  Unit of Measure  Mask: %-10C

This page was generated on 2003-May-05

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