# View: Optional Fields

RotoID: IC0377
Tables: ICOFD
DLL: ICOFD

## Compositions: 1

RotoID | Title | Tables | DLL
--- | --- | --- | ---
IC0378 | Optional Field Locations | ICOFH | ICOFH

## Keys: 1

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

## Fields: 36

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
LOCATION | 1 | Integer | Location | E A K R | List: 11 entries
0 | = | Items
1 | = | Reorder Quantities
2 | = | Receipts
3 | = | Receipt Details
4 | = | Shipments
5 | = | Shipment Details
6 | = | Adjustments
7 | = | Adjustment Details
8 | = | Transfers
9 | = | Transfer Details
10 | = | Assemblies
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
SWPAYCLR | 10 | Integer | Payables Clearing | A P X | List: 1 entries
99 | = | Not Applicable
SWICCTL | 11 | Integer | Inventory Control | A P X | List: 1 entries
99 | = | Not Applicable
SWNSCLR | 12 | Integer | Non-Stock Clearing | A P X | List: 1 entries
99 | = | Not Applicable
SWCOGS | 13 | Integer | Cost of Goods Sold | A P X | List: 1 entries
99 | = | Not Applicable
SWCV | 14 | Integer | Cost Variance | A P X | List: 1 entries
99 | = | Not Applicable
SWADJWO | 15 | Integer | Adjustment Write-Off | A P X | List: 1 entries
99 | = | Not Applicable
SWPMWIP | 16 | Integer | Work in Progress | A P X | List: 1 entries
99 | = | Not Applicable
SWPMCOS | 17 | Integer | Cost of Sales | A P X | List: 1 entries
99 | = | Not Applicable
SWPMOH | 18 | Integer | Overhead | A P X | List: 1 entries
99 | = | Not Applicable
SWICCTLFR | 19 | Integer | Inventory Control(From Location) | A P X | List: 1 entries
99 | = | Not Applicable
SWICCTLTO | 20 | Integer | Inventory Control(To Location) | A P X | List: 1 entries
99 | = | Not Applicable
SWICCTLGIT | 21 | Integer | Inventory Control(GIT Location) | A P X | List: 1 entries
99 | = | Not Applicable
SWTRCLR | 22 | Integer | Transfer Clearing | A P X | List: 1 entries
99 | = | Not Applicable
SWICCTLMA | 23 | Integer | Inventory Control(Master Item) | A P X | List: 1 entries
99 | = | Not Applicable
SWICCTLCO | 24 | Integer | Inventory Control(Component) | A P X | List: 1 entries
99 | = | Not Applicable
SWACC | 25 | Integer | Assembly Cost Credit | A P X | List: 1 entries
99 | = | Not Applicable
SWDE | 26 | Integer | Disassembly Expense | A P X | List: 1 entries
99 | = | Not Applicable
DVINDEX | 40 | Long | Typed Default Value Field Index | E A C |
DVIFTEXT | 41 | String*60 | Default Text Value | E A C P | Mask: %-60c
DVIFMONEY | 42 | BCD*10.3 | Default Money Value | E A C |
DVIFNUM | 43 | BCD*10.0 | Default Number Value | E A C T |
DVIFLONG | 44 | Long | Default Integer Value | E A C |
DVIFBOOL | 45 | Boolean | Default Yes/No Value | E A C | List: 2 entries
0 | = | No
1 | = | Yes
DVIFDATE | 46 | Date | Default Date Value | E A C |
DVIFTIME | 47 | Time | Default Time Value | E A C |
FDESC | 48 | String*60 | Optional Field Description | E A C |
VDESC | 49 | String*60 | Default Value Description | E A C |

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.