# Table: Optional Field Values

Table: UPOFD
View: UP0121
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 Checks
10 | = | Manual Check Earnings/Deductions
11 | = | Manual Check Taxes
17 | = | Manual Check 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.