Table: Company Options

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

Keys: 1

Title  Flags  Fields

Option ID   PROPTID

Fields: 47

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  List: 2 entries
1=During Posting
2=On Request Using Create G/L Batch Icon
APPENDGLSW  Integer  G/L Trans Append to Batch  List: 3 entries
1=Adding to an Existing Batch
0=Creating a New Batch
2=Creating and Posting a New 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  Cheque or Period End Date  List: 2 entries
1=Use Cheque Date as Journal Entry Date
2=Use Pay Period End Date as Journal Entry Date
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
DEFBANK  String*8  Default Bank  Mask: %-8N
DEFFORM  String*6  Default MC Cheque Stock Code  Mask: %-6N
PRCURR  String*3  Payroll Currency  Mask: %-3C
RATETYPE  String*2  Rate Type  Mask: %-2C
EXDIFFACCT  String*45  Exchange Rounding Difference Acc   
ORGDTRVSE  Boolean  Use Original Dates When Reversin   
PJCCOSTCTR  Boolean  PJC Cost Center Override   

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.