Table: Company Options

Table: UPOPTS
View: UP0023
Record length: 490
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*40  Contact Person's Name   
PHONENBR  String*20  Contact's Phone Number  Mask: (%-3C) %-3C-%-10C
FAXNBR  String*20  Contact's Fax Number  Mask: (%-3C) %-3C-%-10C
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 Ho   
TCARDTIME  Integer  Timecard Fractional Hours  List: 2 entries
1=Minutes
2=Hundredths of an Hour
DAILYHRS  BCD*4.3  Hours per Pay Frequency in Dail   
WEEKLYHRS  BCD*4.3  Hours per Pay Frequency in Week   
BIWKLYHRS  BCD*4.3  Hours per Pay Frequency in Biwe   
SEMIMONHRS  BCD*4.3  Hours per Pay Frequency in Semi   
MONTHLYHRS  BCD*4.3  Hours per Pay Frequency in Mont   
QRTRLYHRS  BCD*4.3  Hours per Pay Frequency in Quar   
PP10PYHRS  BCD*4.3  Hours per Pay Frequency in 10 P   
PP13PYHRS  BCD*4.3  Hours per Pay Frequency in 13 P   
PP22PYHRS  BCD*4.3  Hours per Pay Frequency in 22 P   
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=Check Date
2=Period End Date
GLREFCOD  Integer  G/L Reference Code  List: 11 entries
1=Employee Name
2=Check Number
3=Check Date
4=Check 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=Check Number
3=Check Date
4=Check 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 Accoun   
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

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