# View: Optional Field Values

RotoID: CP0121
Table: CPOFD
DLL: CPOFD

## Compositions: 1

RotoID | Table | Title | DLL
--- | --- | --- | ---
CP0120 | CPOFH | Optional Field Locations | CPOFH

## Keys: 1

Title | Fields
--- | ---
Optional Field Value | LOCATION, OPTFIELD

## Fields: 35

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
LOCATION | 1 | Integer | Location | E A K P R | List: 15 entries
1 | = | Employees
2 | = | Earnings/Deductions
3 | = | Taxes
4 | = | Employee Earnings/Deductions
5 | = | Employee Taxes
6 | = | Timecards
7 | = | Timecard Earnings/Deductions
8 | = | Timecard Taxes
9 | = | Manual Cheques
10 | = | Manual Cheque Earnings/Deductions
11 | = | Manual Cheque Taxes
12 | = | Transactions
13 | = | Transaction Earnings/Deductions
14 | = | Transaction Taxes
15 | = | Payroll Processing
OPTFIELD | 2 | String*12 | Optional Field | E A K R | Mask: %-12N
DEFVAL | 3 | String*60 | Default Value | E A P | Mask: %-60c
TYPE | 4 | Integer | Type | E A C | List: 7 entries
1 | = | Text
100 | = | Amount
6 | = | Number
8 | = | Integer
9 | = | Yes/No
3 | = | Date
4 | = | Time
LENGTH | 5 | Integer | Length | E A C |
DECIMALS | 6 | Integer | Decimals | E A C |
ALLOWNULL | 7 | Boolean | Allow Blank | E A C | List: 2 entries
0 | = | No
1 | = | Yes
VALIDATE | 8 | Boolean | Validate | E A C | List: 2 entries
0 | = | No
1 | = | Yes
INITFLAG | 9 | Integer | Auto Insert | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWBANK | 10 | Integer | Bank | A P X | List: 1 entries
99 | = | Not Applicable
SWSALARY | 11 | Integer | Salary and Wages Payable | A P X | List: 1 entries
99 | = | Not Applicable
SWSUSPENSE | 12 | Integer | Suspense | A P X | List: 1 entries
99 | = | Not Applicable
SWEXCHANGE | 13 | Integer | Exchange Rounding Difference | A P X | List: 1 entries
99 | = | Not Applicable
SWREGEXP | 14 | Integer | Regular Expense | A P X | List: 1 entries
99 | = | Not Applicable
SWOTEXP | 15 | Integer | Overtime Expense | A P X | List: 1 entries
99 | = | Not Applicable
SWSHIFTEXP | 16 | Integer | Shift Expense | A P X | List: 1 entries
99 | = | Not Applicable
SWADVANCE | 17 | Integer | Advances Receivable | A P X | List: 1 entries
99 | = | Not Applicable
SWEELIAB | 18 | Integer | Employee Liability | A P X | List: 1 entries
99 | = | Not Applicable
SWERLIAB | 19 | Integer | Employer Liability | A P X | List: 1 entries
99 | = | Not Applicable
SWEREXP | 20 | Integer | Employer Expense | A P X | List: 1 entries
99 | = | Not Applicable
SWLABOR | 21 | Integer | Labor | A P X | List: 1 entries
99 | = | Not Applicable
SWOVERHEAD | 22 | Integer | Overhead | A P X | List: 1 entries
99 | = | Not Applicable
SWCOSTTRX | 23 | Integer | PJC External Cost Transactions | A P X | List: 1 entries
99 | = | Not Applicable
SWREQUIRED | 24 | Integer | Required | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWSET | 25 | Integer | Value Set | E A | List: 2 entries
0 | = | No
1 | = | Yes
DVINDEX | 35 | Long | Typed Default Value Field Index | E A C |
DVIFTEXT | 36 | String*60 | Default Text Value | E A C P | Mask: %-60c
DVIFMONEY | 37 | BCD*10.3 | Default Amount Value | E A C |
DVIFNUM | 38 | BCD*10.0 | Default Number Value | E A C T |
DVIFLONG | 39 | Long | Default Integer Value | E A C |
DVIFBOOL | 40 | Boolean | Default Yes/No Value | E A C | List: 2 entries
0 | = | No
1 | = | Yes
DVIFDATE | 41 | Date | Default Date Value | E A C |
DVIFTIME | 42 | Time | Default Time Value | E A C |
FDESC | 43 | String*60 | Optional Field Description | E A C |
VDESC | 44 | String*60 | Default Value Description | E A C |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.