View: I/C 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: 219

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: (%-3C) %-3C-%-24C
FAX 4 String*30 Fax Number E A  Mask: (%-3C) %-3C-%-24C
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
DUPSERIALS 231 Boolean Allow Duplicate Serials E A 
SALESPERDS 232 Integer Sales Stats Periods to Use E A 
UPDTMINREQ 233 Boolean Update Location Details Min. Qty. E A  List:2 entries
0 = No
1 = Yes
MINFACTOR 234 BCD*5.2 Minimum Quantity Margin Factor E A 
MAXFACTOR 235 BCD*5.2 Maximum Quantity Margin Factor E A 
SALESHL 236 BCD*5.2 Highlight Sales Variance Above E A 
TRENDHL 237 BCD*5.2 Highlight Trend Variance Above E A 
MINMAXHL 238 BCD*5.2 Highlight Min/Max Variance Above E A 
CMNTDAYS 239 BCD*3.0 Default No. Days for Expiry E A 
FLUPDAYS 240 BCD*3.0 Default No. Days for Follow Up E A 
CMNTTYPE 241 String*8 Default Comment Type E A  Mask: %-8N
SWCMNTTYPE 242 Integer Allow Blank Comment Type E A  List:2 entries
0 = No
1 = Yes
DLASTDEP 243 Date UTC Date Last Day End E A 
TLASTDEP 244 Time UTC Time Last Day End E A 
LODLASTDEP 245 Date Local Date Last Day End E A 
LOTLASTDEP 246 Time Local Time Last Day End E A 

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).