Table: Company Options

Table: CPOPTS
View: CP0023
Record length: 530
Flags: A R 

Keys: 1


Title  Flags  Fields

Option ID   PROPTID

Fields: 66


Field  Type  Title  Presentation 

PROPTID  String*4  Option Record ID  Mask: %-4N
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
CNTRYCODE  String*3  Payroll Country Code   
CONTACT  String*60  Contact Person's Name   
PHONENBR  String*30  Contact's Phone Number  Mask: (%-3C) %-3C-%-24C
FAXNBR  String*30  Contact's Fax Number  Mask: (%-3C) %-3C-%-24C
PRTNONETSW  Boolean  Print Zero Net Cheques   
MINWAGE  BCD*10.3  Minimum Wage   
MAXPTHRS  BCD*4.3  Maximum Annual Part-Time Hours   
YEARSHIST  Integer  Years of History to Keep   
EXCPTPCT  BCD*5.5  Exception for Increase Percent   
EXCPTDLR  BCD*10.3  Exception for Dollar Increase   
HRLYRTEDEC  Integer  Number of Decimal Places for Hou   
TCARDTIME  Integer  Timecard Fractional Hours  List: 2 entries
1=Minutes
2=Hundredths of an Hour
DAILYHRS  BCD*4.3  Hours per Pay Frequency in Daily   
WEEKLYHRS  BCD*4.3  Hours per Pay Frequency in Weekl   
BIWKLYHRS  BCD*4.3  Hours per Pay Frequency in Biwee   
SEMIMONHRS  BCD*4.3  Hours per Pay Frequency in Semim   
MONTHLYHRS  BCD*4.3  Hours per Pay Frequency in Month   
QRTRLYHRS  BCD*4.3  Hours per Pay Frequency in Quart   
PP10PYHRS  BCD*4.3  Hours per Pay Frequency in 10 Pe   
PP13PYHRS  BCD*4.3  Hours per Pay Frequency in 13 Pe   
PP22PYHRS  BCD*4.3  Hours per Pay Frequency in 22 Pe   
DAILYPPPY  Integer  Daily Pay Periods per Year   
WEEKLYPPPY  Integer  Weekly Pay Periods per Year   
BIWKLYPPPY  Integer  Biweekly Pay Periods per Year   
GLONLINESW  Integer  Create G/L Trans or Not   
APPENDGLSW  Boolean  G/L Trans Append to Batch   
GLBTCHTYPE  Integer  G/L Batch Type  List: 3 entries
1=Do Not Consolidate
2=Consolidate by Acct/Fiscal Period
3=Consolidate by Acct/Fiscal Period and Source Code
POSTDATCOD  Integer  Check or Period End Date  List: 2 entries
1=Cheque Date
2=Period End Date
GLREFCOD  Integer  G/L Reference Code  List: 11 entries
1=Employee Name
2=Cheque Number
3=Cheque Date
4=Cheque Number and Date
5=Posting Date
6=Pay Period Dates
11=Posting Sequence - Calculation Sequence
7=Class 1 Value
8=Class 2 Value
9=Class 3 Value
10=Class 4 Value
GLDESCCOD  Integer  G/L Description Code  List: 11 entries
1=Employee Name
2=Cheque Number
3=Cheque Date
4=Cheque Number and Date
5=Posting Date
6=Pay Period Dates
11=Posting Sequence - Calculation Sequence
7=Class 1 Value
8=Class 2 Value
9=Class 3 Value
10=Class 4 Value
SALPAYACCT  String*45  Salary and Wages Payable Account   
SUSPACCT  String*45  Suspense Account   
COSTCTRSW  Boolean  Cost Center Switch   
GLSEG1  String*6  G/L Segment One   
GLSEG2  String*6  G/L Segment Two   
GLSEG3  String*6  G/L Segment Three   
GLSEGREPOP  Integer  Active Segment Replace Option  List: 3 entries
1=None
2=Expense Accounts
3=Expense and Liability Accounts
OPFL02CSW  Boolean  2 Characters Switch   
OPFL02CTTL  String*12  2 Characters Title   
OPFL02CTBL  String*8  2 Characters Lookup Table  Mask: %-8N
OPFL03CSW  Boolean  3 Characters Switch   
OPFL03CTTL  String*12  3 Characters Title   
OPFL03CTBL  String*8  3 Characters Lookup Table  Mask: %-8N
OPFL04CSW  Boolean  4 Characters Switch   
OPFL04CTTL  String*12  4 Characters Title   
OPFL04CTBL  String*8  4 Characters Lookup Table  Mask: %-8N
OPFL12CSW  Boolean  12 Characters Switch   
OPFL12CTTL  String*12  12 Characters Title   
OPFL12CTBL  String*8  12 Characters Lookup Table  Mask: %-8N
OPFL15CSW  Boolean  15 Characters Switch   
OPFL15CTTL  String*12  15 Characters Title   
OPFL15CTBL  String*8  15 Characters Lookup Table  Mask: %-8N
OPFL30CSW  Boolean  30 Characters Switch   
OPFL30CTTL  String*12  30 Characters Title   
OPFL30CTBL  String*8  30 Characters Lookup Table  Mask: %-8N
OPFLAMTSW  Boolean  Amount Switch   
OPFLAMTTTL  String*12  Amount Title   
OPFLAMTTBL  String*8  Amount Lookup Table  Mask: %-8N
OPFLDATSW  Boolean  Date Switch   
OPFLDATTTL  String*12  Date Title   
OPFLDATTBL  String*8  Date Lookup Table  Mask: %-8N

This page was generated on 2003-May-05

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