# View: Options

RotoID: IC0380
Table: ICOPT
Protocol: Flat, Key auto generate
DLL: ICOPT

## Compositions: 1

RotoID | Tables | Title | DLL
--- | --- | --- | ---
IC0320 | ICITMS | Item Structures | ICITMS

## Keys: 1

Title | Fields
--- | ---
Dummy Key | DUMMY

## Fields: 203

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
DUMMY | 1 | Integer | Dummy Field | E A K R |
CONTACT | 2 | String*60 | Contact Name | E A |
PHONE | 3 | String*30 | Phone Number | E A | Mask: %-30c
FAX | 4 | String*30 | Fax Number | E A | Mask: %-30c
FRACTQTY | 5 | Boolean | Fractional Quantities | E A X |
NEGQTY | 6 | Boolean | Allow Negative Quantities | E A |
TRANSHIST | 7 | Boolean | Keep Transaction History | E A |
JOBCOST | 8 | Boolean | Interface With Job Cost | E A |
REFCHOICE | 9 | Integer | G/L Reference Field | E A | List: 6 entries
1 | = | Document Number
2 | = | Reference Number
3 | = | Source Code/Day End Number/Entry Number
4 | = | Header Description
5 | = | Customer/Vendor Number
6 | = | Customer/Vendor Name
DESCCHOICE | 10 | Integer | G/L Description Field | E A | List: 6 entries
1 | = | Document Number
2 | = | Reference Number
3 | = | Source Code/Day End Number/Entry Number
4 | = | Header Description
5 | = | Customer/Vendor Number
6 | = | Customer/Vendor Name
WEIGHTUNIT | 11 | String*10 | Default Weight Unit of Measure | E A |
COST1NAME | 12 | String*10 | Cost 1 Name | E A |
COST2NAME | 13 | String*10 | Cost 2 Name | E A |
DAYEND | 14 | Integer | Day End Transactions Outstanding | E A |
TRANSNUM | 15 | BCD*10.0 | Next Transaction Number | E A |
NXTALTSET | 16 | Long | Next Alternate Item Set Number | E A |
GLDAYEND | 17 | Long | G/L Trans Created Thru Day End | E A |
ADJENSEQ | 18 | Long | Next Adjustment Entry Seq. | E A |
ASSMENSEQ | 19 | Long | Next Assembly Entry Seq. | E A |
RECENSEQ | 20 | Long | Next Receipt Entry Seq. | E A |
SHIPENSEQ | 21 | Long | Next Shipment Entry Seq. | E A |
TRANFENSEQ | 22 | Long | Next Transfer Entry Seq. | E A |
HISTENSEQ | 23 | Long | Next History Entry Seq. | E A |
DAYENDSEQ | 24 | Long | Next Day End Posting Seq. | E A |
MULTICURR | 25 | Boolean | Multicurrency | E A X |
DEFERGLPST | 26 | Boolean | Deferred G/L Posting | E A |
APPENDGL | 27 | Integer | Append To G/L Batch | E A | List: 3 entries
1 | = | Adding to an Existing Batch
0 | = | Creating a New Batch
2 | = | Creating and Posting a New Batch
CONSOLGL | 28 | Integer | Consolidate G/L Batch | E A | List: 4 entries
1 | = | Do Not Consolidate
9 | = | Consolidate Transaction Details by Account
2 | = | Consolidate by Account and Fiscal Period
3 | = | Consolidate by Account, Fiscal Period, and Source
STATCALNDR | 29 | Integer | Statistics Calendar | E A P | List: 2 entries
1 | = | Calendar Year
2 | = | Fiscal Year
STATPRD | 30 | Integer | Statistics Period | E A P | List: 10 entries
1 | = | Weekly
2 | = | Seven Days
3 | = | Bi-weekly
4 | = | Four Weeks
5 | = | Monthly
6 | = | Bi-monthly
7 | = | Quarterly
8 | = | Semi-annually
9 | = | Annually
10 | = | Fiscal Period
STATEDIT | 31 | Boolean | Edit Statistics | E A |
CRTITEMLOC | 54 | Boolean | Allow Items at All Locations | E A |
ADDCSTTYPE | 55 | Integer | Add'l. Cost on Rcpt. Returns | E A | List: 2 entries
1 | = | Leave
2 | = | Prorate
RATETYPE | 56 | String*2 | Default Rate Type | E A | Mask: %-2N
ITEMBRKID | 57 | String*6 | Default Item Structure | E A | Mask: %-6N
STATACCUM | 58 | Boolean | Accumulate Item Statistics | E A |
PSTTOCLOSD | 59 | Boolean | Post To Closed Fiscal Periods | E A |
PERIODTYPE | 60 | Integer | Period Type | A C | List: 3 entries
1 | = | Seven Days
2 | = | Weekly
3 | = | Monthly
PERIODLENG | 61 | Integer | Period Length | A C |
FRACTDEC | 62 | Integer | Fractional Quantity Decimals | A C |
FACTORDEC | 63 | Integer | Conversion Factor Decimals | A C |
STATPRDS | 64 | Integer | Statistical Periods | A C |
HYHEN | 65 | Boolean | Use Hyhen as Item Separator | E A X |
FWDSLASH | 66 | Boolean | Use Forward Slash as Item Separator | E A X |
BCKSLASH | 67 | Boolean | Use Back Slash as Item Separator | E A X |
ASTERISK | 68 | Boolean | Use Asterisk as Item Separator | E A X |
PERIOD | 69 | Boolean | Use Period as Item Separator | E A X |
LFTPARENS | 70 | Boolean | Use Left Parenthesis as Item Separator | E A X |
RGTPARENS | 71 | Boolean | Use Right Parenthesis as Item Separator | E A X |
POUNDSGN | 72 | Boolean | Use Pound Sign as Item Separator | E A X |
RECNONSTK | 73 | Boolean | Allow Receipt of Non-stock Items | E A X |
DELPROMPT | 74 | Boolean | Prompt to Delete during Posting | E A X |
COSTDURING | 75 | Integer | Cost During | E A | List: 2 entries
1 | = | Day End Processing
2 | = | Posting
ASSNUMBERL | 76 | Integer | Assembly Number Length | E A |
ASSPREFIXD | 77 | String*6 | Assembly Number Prefix | E A | Mask: %-6C
ASSBODYD | 78 | String*22 | Next Assembly Number | E A | Mask: %19D
DASNUMBERL | 79 | Integer | Disassembly Number Length | E A |
DASPREFIXD | 80 | String*6 | Disassembly Number Prefix | E A | Mask: %-6C
DASBODYD | 81 | String*22 | Next Disassembly Number | E A | Mask: %19D
TRFNUMBERL | 82 | Integer | Transfer Number Length | E A |
TRFPREFIXD | 83 | String*6 | Transfer Number Prefix | E A | Mask: %-6C
TRFBODYD | 84 | String*22 | Next Transfer Number | E A | Mask: %19D
ADJNUMBERL | 85 | Integer | Adjustment Number Length | E A |
ADJPREFIXD | 86 | String*6 | Adjustment Number Prefix | E A | Mask: %-6C
ADJBODYD | 87 | String*22 | Next Adjustment Number | E A | Mask: %19D
SHPNUMBERL | 88 | Integer | Shipment Number Length | E A |
SHPPREFIXD | 89 | String*6 | Shipment Number Prefix | E A | Mask: %-6C
SHPBODYD | 90 | String*22 | Next Shipment Number | E A | Mask: %19D
SRTNUMBERL | 91 | Integer | Shipment Return Number Length | E A |
SRTPREFIXD | 92 | String*6 | Shipment Return Number Prefix | E A | Mask: %-6C
SRTBODYD | 93 | String*22 | Next Shipment Return Number | E A | Mask: %19D
RCPNUMBERL | 94 | Integer | Receipt Number Length | E A |
RCPPREFIXD | 95 | String*6 | Receipt Number Prefix | E A | Mask: %-6C
RCPBODYD | 96 | String*22 | Next Receipt Number | E A | Mask: %19D
TRCNUMBERL | 97 | Integer | Transit Receipt Number Length | E A |
TRCPREFIXD | 98 | String*6 | Transit Receipt Number Prefix | E A | Mask: %-6C
TRCBODYD | 99 | String*22 | Next Transit Receipt Number | E A | Mask: %19D
RECDESEQ | 100 | Long | Next Non-costed Receipt Day End Seq. | E A |
SPHYHEN | 106 | Integer | Separator Hyhen | A C | List: 1 entries
1 | = | - Hyphen
SPFWDSLASH | 107 | Integer | Separator Forward Slash | A C | List: 1 entries
1 | = | / Forward Slash
SPBCKSLASH | 108 | Integer | Separator Back Slash | A C | List: 1 entries
1 | = | \ Back Slash
SPASTERISK | 109 | Integer | Separator Asterisk | A C | List: 1 entries
1 | = | * Asterisk
SPPERIOD | 110 | Integer | Separator Period | A C | List: 1 entries
1 | = | . Period
SPLPARENS | 111 | Integer | Separator Left Parenthesis | A C | List: 1 entries
1 | = | ( Left Parenthesis
SPRPARENS | 112 | Integer | Separator Right Parenthesis | A C | List: 1 entries
1 | = | ) Right Parenthesis
SPPOUNDSGN | 113 | Integer | Separator Number Sign | A C | List: 1 entries
1 | = | # Number Sign
HOMECURR | 114 | String*3 | Home Currency | A C |
ASSDEFAULT | 115 | String*22 | Default Assembly Number | A C |
ASSVALUE | 116 | String*22 | Next Assembly Number | A C |
DASDEFAULT | 117 | String*22 | Default Disassembly Number | A C |
DASVALUE | 118 | String*22 | Next Disassembly Number | A C |
TRFDEFAULT | 119 | String*22 | Default Transfer Number | A C |
TRFVALUE | 120 | String*22 | Next Transfer Number | A C |
ADJDEFAULT | 121 | String*22 | Default Adjustment Number | A C |
ADJVALUE | 122 | String*22 | Next Adjustment Number | A C |
SHPDEFAULT | 123 | String*22 | Default Shipment Number | A C |
SHPVALUE | 124 | String*22 | Next Shipment Number | A C |
SRTDEFAULT | 125 | String*22 | Default Shipment Return Number | A C |
SRTVALUE | 126 | String*22 | Next Shipment Return Number | A C |
RCPDEFAULT | 127 | String*22 | Default Receipt Number | A C |
RCPVALUE | 128 | String*22 | Next Receipt Number | A C |
TRCDEFAULT | 129 | String*22 | Default Transit Receipt Number | A C |
TRCVALUE | 130 | String*22 | Next Transit Receipt Number | A C |
GITLOC | 131 | String*6 | Default Goods in Transit Location | E A | Mask: %-6N
GITLOCDESC | 132 | String*60 | Transit Location Description | E A |
DEFUOM | 133 | Boolean | Only Use Defined UOM | E A X |
AGING1 | 134 | BCD*3.0 | Aging Period 1 | E A |
AGING2 | 135 | BCD*3.0 | Aging Period 2 | E A |
AGING3 | 136 | BCD*3.0 | Aging Period 3 | E A |
SLAUDURING | 137 | Integer | Create Subledger/Audit During | E A | List: 2 entries
1 | = | Day End Processing
2 | = | Posting
ICSENSEQ | 138 | Long | Next Internal Usage Entry Seq. | E A |
ICSNUMBERL | 139 | Integer | Internal Usage Number Length | E A |
ICSPREFIXD | 140 | String*6 | Internal Usage Number Prefix | E A | Mask: %-6C
ICSBODYD | 141 | String*22 | Next Internal Usage Number | E A | Mask: %19D
ICSDEFAULT | 142 | String*22 | Default Internal Usage Number | A C |
ICSVALUE | 143 | String*22 | Next Internal Usage Number | A C |
TPOSTACTN | 144 | Integer | Transaction post/dep/cost | A C | List: 3 entries
11 | = | Quantity Only
12 | = | Cost Only
13 | = | Cost and Ledger
SRCTYPERC | 145 | String*2 | I/C Receipts | E A | Mask: %-2N
SRCTYPERR | 146 | String*2 | I/C Receipt Returns | E A | Mask: %-2N
SRCTYPERA | 147 | String*2 | I/C Receipt Adjustments | E A | Mask: %-2N
SRCTYPESH | 148 | String*2 | I/C Shipments | E A | Mask: %-2N
SRCTYPESR | 149 | String*2 | I/C Shipment Returns | E A | Mask: %-2N
SRCTYPETF | 150 | String*2 | I/C Transfers | E A | Mask: %-2N
SRCTYPEAS | 151 | String*2 | I/C Assemblies | E A | Mask: %-2N
SRCTYPEAD | 152 | String*2 | I/C Adjustments | E A | Mask: %-2N
SRCTYPECO | 153 | String*2 | I/C Consolidated Entry | E A | Mask: %-2N
SRCTYPEDA | 154 | String*2 | I/C Disassemblies | E A | Mask: %-2N
SRCTYPEIN | 155 | String*2 | I/C Internal Usage | E A | Mask: %-2N
DATEBUSDFT | 156 | Integer | Default Posting Date | E A | List: 2 entries
1 | = | Document Date
2 | = | Session Date
SERIALMASK | 157 | String*6 | Serial Number Mask | E A | Mask: %-6N
SUSEEXPDAY | 158 | Boolean | Use Serials Days to Expire | E A |
SEXPDAYS | 159 | Integer | Serials Days to Expire | E A |
SDIFQTYOK | 160 | Boolean | Allow Different Serial Qty | E A |
SALCQTYORD | 161 | Boolean | Allow Serial Alloc on Qty Ord. | E A |
SSORTBY | 162 | Integer | Sort Serials by | E A | List: 3 entries
1 | = | Serial Number
2 | = | Stock Date
3 | = | Expiry Date
SFIRST | 163 | Integer | Sort Serials First by | E A | List: 2 entries
1 | = | Earliest
2 | = | Latest
SEXPLEVEL | 164 | Integer | Stop Allocation of Expired Serials | E A | List: 3 entries
0 | = | None
1 | = | Warning
2 | = | Error
SHYPHEN | 165 | Boolean | Serials Hyphen as Separator | E A X |
SFWDSLASH | 166 | Boolean | Serials Fwd Slash as Separator | E A X |
SBCKSLASH | 167 | Boolean | Serials Back Slash as Separator | E A X |
SASTERISK | 168 | Boolean | Serials Asterisk as Separator | E A X |
SPERIOD | 169 | Boolean | Serials Period as Separator | E A X |
SLFPARENS | 170 | Boolean | Serials Left Parenthesis as Sep | E A X |
SRGTPARENS | 171 | Boolean | Serials Right Parenthesis as Sep | E A X |
SPOUNDSIGN | 172 | Boolean | Serials Pound Sign as Separator | E A X |
SLFBRACKT | 173 | Boolean | Serials Left Bracket as Sep | E A X |
SRGTBRACKT | 174 | Boolean | Serials Right Bracket as Sep | E A X |
SLFBRACE | 175 | Boolean | Serials Left Brace as Sep | E A X |
SRGTBRACE | 176 | Boolean | Serials Right Brace as Sep | E A X |
LOTMASK | 177 | String*6 | Lot Number Mask | E A X | Mask: %-6N
LUSEEXPDAY | 178 | Boolean | Use Lots Days to Expire | E A |
LEXPDAYS | 179 | Integer | Lots Days to Expire | E A |
LUSEQRNDAY | 180 | Boolean | Use Lots Days on Quarantine | E A |
LQRNDAYS | 181 | Integer | Lots Days on Quarantine | E A |
LDIFQTYOK | 182 | Boolean | Allow Different Lot Qty | E A |
LALCQTYORD | 183 | Boolean | Allow Lot Alloc on Qty Ord. | E A |
LSORTBY | 184 | Integer | Sort Lots by | E A | List: 3 entries
1 | = | Lot Number
2 | = | Stock Date
3 | = | Expiry Date
LFIRST | 185 | Integer | Sort Lots First by | E A | List: 2 entries
1 | = | Earliest
2 | = | Latest
LEXPLEVEL | 186 | Integer | Stop Allocation of Expired Lots | E A | List: 3 entries
0 | = | None
1 | = | Warning
2 | = | Error
LHYPHEN | 187 | Boolean | Lots Hyphen as Separator | E A X |
LFWDSLASH | 188 | Boolean | Lots Fwd Slash as Separator | E A X |
LBCKSLASH | 189 | Boolean | Lots Back Slash as Separator | E A X |
LASTERISK | 190 | Boolean | Lots Asterisk as Separator | E A X |
LPERIOD | 191 | Boolean | Lots Period as Separator | E A X |
LLFPARENS | 192 | Boolean | Lots Left Parenthesis as Sep | E A X |
LRGTPARENS | 193 | Boolean | Lots Right Parenthesis as Sep | E A X |
LPOUNDSIGN | 194 | Boolean | Lots Pound Sign as Separator | E A X |
LLFBRACKT | 195 | Boolean | Lots Left Bracket as Separator | E A X |
LRGTBRACKT | 196 | Boolean | Lots Right Bracket as Separator | E A X |
LLFBRACE | 197 | Boolean | Lots Left Brace as Separator | E A X |
LRGTBRACE | 198 | Boolean | Lots Right Brace as Separator | E A X |
RECALENSEQ | 199 | BCD*10.0 | Recall/Release Sequence Number | E A |
RECNUMBERL | 200 | Integer | Recall Number Length | E A |
RECPREFIXD | 201 | String*6 | Recall Number Prefix | E A | Mask: %-6C
RECBODYD | 202 | String*22 | Next Recall Number | E A | Mask: %19D
RECDEFAULT | 203 | String*22 | Default Recall Number | A C |
RECVALUE | 204 | String*22 | Next Recall Number | A C |
RELNUMBERL | 205 | Integer | Release Number Length | E A |
RELPREFIXD | 206 | String*6 | Release Number Prefix | E A | Mask: %-6C
RELBODYD | 207 | String*22 | Next Release Number | E A | Mask: %19D
RELDEFAULT | 208 | String*22 | Default Release Number | A C |
RELVALUE | 209 | String*22 | Next Release Number | A C |
COMENSEQ | 210 | BCD*10.0 | Combine/Split Sequence Number | E A |
COMNUMBERL | 211 | Integer | Combine Number Length | E A |
COMPREFIXD | 212 | String*6 | Combine Number Prefix | E A | Mask: %-6C
COMBODYD | 213 | String*22 | Next Combine Number | E A | Mask: %19D
COMDEFAULT | 214 | String*22 | Default Combine Number | A C |
COMVALUE | 215 | String*22 | Next Combine Number | A C |
SPLNUMBERL | 216 | Integer | Split Number Length | E A |
SPLPREFIXD | 217 | String*6 | Split Number Prefix | E A | Mask: %-6C
SPLBODYD | 218 | String*22 | Next Split Number | E A | Mask: %19D
SPLDEFAULT | 219 | String*22 | Default Split Number | A C |
SPLVALUE | 220 | String*22 | Next Split Number | A C |
RCNENSEQ | 221 | BCD*10.0 | Reconciliation Sequence Number | E A |
RCNNUMBERL | 222 | Integer | Reconciliation Number Length | E A |
RCNPREFIXD | 223 | String*6 | Reconciliation Number Prefix | E A | Mask: %-6C
RCNBODYD | 224 | String*22 | Next Reconciliation Number | E A | Mask: %19D
RCNDEFAULT | 225 | String*22 | Default Reconciliation Number | A C |
RCNVALUE | 226 | String*22 | Next Reconciliation Number | A C |
SPLBRACKET | 227 | Integer | Separator Left Bracket | A C | List: 1 entries
1 | = | [ Left Bracket
SPRBRACKET | 228 | Integer | Separator Right Bracket | A C | List: 1 entries
1 | = | ] Right Bracket
SPLBRACE | 229 | Integer | Separator Left Brace | A C | List: 1 entries
1 | = | { Left Brace
SPRBRACE | 230 | Integer | Separator Right Brace | A C | List: 1 entries
1 | = | } Right Brace

This page was generated on 2009-Nov-19

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