Table: Company Options

Table: UPOPTS
View: UP0023
Record length: 422
Flags: A R 

Keys: 1

Title  Flags  Fields

Option ID  PROPTID

Fields: 49

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   
FAXNBR  String*30  Contact's Fax Number   
PRTNONETSW  Boolean  Print Zero Net Checks   
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 Hourly Rates   
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 Weekly   
BIWKLYHRS  BCD*4.3  Hours per Pay Frequency in Biweekly   
SEMIMONHRS  BCD*4.3  Hours per Pay Frequency in Semimonthly   
MONTHLYHRS  BCD*4.3  Hours per Pay Frequency in Monthly   
QRTRLYHRS  BCD*4.3  Hours per Pay Frequency in Quarterly   
PP10PYHRS  BCD*4.3  Hours per Pay Frequency in 10 Periods   
PP13PYHRS  BCD*4.3  Hours per Pay Frequency in 13 Periods   
PP22PYHRS  BCD*4.3  Hours per Pay Frequency in 22 Periods   
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  Check or Period End Date  List: 2 entries
1=Use Check 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 Check Stock Code  Mask: %-6N
PRCURR  String*3  Payroll Currency  Mask: %-3C
RATETYPE  String*2  Rate Type  Mask: %-2C
EXDIFFACCT  String*45  Exchange Rounding Difference Account   
ORGDTRVSE  Boolean  Use Original Dates When Reversing Checks   
PJCCOSTCTR  Boolean  PJC Cost Center Override   
PRINTSIN  Boolean  Print SSN   
EMPLSEC  Boolean  Employee Level Security Flag   

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.