Table: Optional Field Values

Table: CPOFD
View: CP0121
Record length: 142
Flags: A R 

Keys: 1

Title  Flags  Fields
Optional Field Value  LOCATION, OPTFIELD

Fields: 29

Field  Type  Title  Presentation 
LOCATION  Integer  Location  List: 18 entries
1=Employees
2=Earnings/Deductions
3=Taxes
4=Employee Earnings/Deductions
5=Employee Taxes
6=Timecards
7=Timecard Earnings/Deductions
8=Timecard Taxes
16=Timecard PJC Details
9=Manual Cheques
10=Manual Cheque Earnings/Deductions
11=Manual Cheque Taxes
17=Manual Cheque PJC Details
12=Transactions
13=Transaction Earnings/Deductions
14=Transaction Taxes
18=Transaction PJC Details
15=Payroll Processing
OPTFIELD  String*12  Optional Field  Mask: %-12N
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
DEFVAL  String*60  Default Value  Mask: %-60c
TYPE  Integer  Type  List: 7 entries
1=Text
100=Amount
6=Number
8=Integer
9=Yes/No
3=Date
4=Time
LENGTH  Integer  Length   
DECIMALS  Integer  Decimals   
ALLOWNULL  Boolean  Allow Blank  List: 2 entries
0=No
1=Yes
VALIDATE  Boolean  Validate  List: 2 entries
0=No
1=Yes
INITFLAG  Integer  Auto Insert  List: 2 entries
0=No
1=Yes
SWBANK  Integer  Bank  List: 1 entries
99=Not Applicable
SWSALARY  Integer  Salary and Wages Payable  List: 1 entries
99=Not Applicable
SWSUSPENSE  Integer  Suspense  List: 1 entries
99=Not Applicable
SWEXCHANGE  Integer  Exchange Rounding Difference  List: 1 entries
99=Not Applicable
SWREGEXP  Integer  Regular Expense  List: 1 entries
99=Not Applicable
SWOTEXP  Integer  Overtime Expense  List: 1 entries
99=Not Applicable
SWSHIFTEXP  Integer  Shift Expense  List: 1 entries
99=Not Applicable
SWADVANCE  Integer  Advances Receivable  List: 1 entries
99=Not Applicable
SWEELIAB  Integer  Employee Liability  List: 1 entries
99=Not Applicable
SWERLIAB  Integer  Employer Liability  List: 1 entries
99=Not Applicable
SWEREXP  Integer  Employer Expense  List: 1 entries
99=Not Applicable
SWLABOR  Integer  Labor  List: 1 entries
99=Not Applicable
SWOVERHEAD  Integer  Overhead  List: 1 entries
99=Not Applicable
SWCOSTTRX  Integer  PJC External Cost Transactions  List: 1 entries
99=Not Applicable
SWREQUIRED  Integer  Required  List: 2 entries
0=No
1=Yes
SWSET  Integer  Value Set  List: 2 entries
0=No
1=Yes

This page was generated on 2009-Nov-19

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