# Table: Optional Fields

Table: AROFD
View: AR0500
Record length: 148
Flags: A R

## Keys: 1

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

## Fields: 32

Field | Type | Title | Presentation
--- | --- | --- | ---
LOCATION | Integer | Location | List: 8 entries
0 | = | Customers, National Accounts, and Customer Groups
1 | = | Ship-To Locations
2 | = | Invoices
3 | = | Invoice Details
4 | = | Receipts
5 | = | Adjustments
6 | = | Revaluation
7 | = | Refunds
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
SWCONTROL | Integer | Receivables Control | List: 1 entries
99 | = | Not Applicable
SWRTG | Integer | Retainage | List: 1 entries
99 | = | Not Applicable
SWDISCOUNT | Integer | Receipt Discount | List: 1 entries
99 | = | Not Applicable
SWTAXLIAB | Integer | Tax Liability | List: 1 entries
99 | = | Not Applicable
SWREXCHG | Integer | Realized Exchange Gain | List: 1 entries
99 | = | Not Applicable
SWREXCHL | Integer | Realized Exchange Loss | List: 1 entries
99 | = | Not Applicable
SWUREXCHG | Integer | Unrealized Exchange Gain | List: 1 entries
99 | = | Not Applicable
SWUREXCHL | Integer | Unrealized Exchange Loss | List: 1 entries
99 | = | Not Applicable
SWROUND | Integer | Rounding | List: 1 entries
99 | = | Not Applicable
SWREVENUE | Integer | Revenue | List: 1 entries
99 | = | Not Applicable
SWPREPAY | Integer | Prepayment | List: 1 entries
99 | = | Not Applicable
SWMISCRCPT | Integer | Miscellaneous Receipt | List: 1 entries
99 | = | Not Applicable
SWBANK | Integer | Bank | List: 1 entries
99 | = | Not Applicable
SWADJ | Integer | Adjustment | List: 1 entries
99 | = | Not Applicable
SWIC | Integer | Inventory Control | List: 1 entries
99 | = | Not Applicable
SWCOGS | Integer | Cost of Goods Sold | List: 1 entries
99 | = | Not Applicable
SWPM | Integer | Billings | 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 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.