# Table: Options

Table: ICOPT
View: IC0380
Record length: 881
Flags: A R

## Keys: 1

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

## Fields: 159

Field | Type | Title | Presentation
--- | --- | --- | ---
DUMMY | Integer | Dummy Field |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
CONTACT | String*60 | Contact Name |
PHONE | String*30 | Phone Number | Mask: %-30c
FAX | String*30 | Fax Number | Mask: %-30c
FRACTQTY | Boolean | Fractional Quantities |
NEGQTY | Boolean | Allow Negative Quantities |
TRANSHIST | Boolean | Keep Transaction History |
JOBCOST | Boolean | Interface With Job Cost |
REFCHOICE | Integer | G/L Reference Field | 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 | Integer | G/L Description Field | 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 | String*10 | Default Weight Unit of Measure |
COST1NAME | String*10 | Cost 1 Name |
COST2NAME | String*10 | Cost 2 Name |
DAYEND | Integer | Day End Transactions Outstanding |
TRANSNUM | BCD*10.0 | Next Transaction Number |
NXTALTSET | Long | Next Alternate Item Set Number |
GLDAYEND | Long | G/L Trans Created Thru Day End |
ADJENSEQ | Long | Next Adjustment Entry Seq. |
ASSMENSEQ | Long | Next Assembly Entry Seq. |
RECENSEQ | Long | Next Receipt Entry Seq. |
SHIPENSEQ | Long | Next Shipment Entry Seq. |
TRANFENSEQ | Long | Next Transfer Entry Seq. |
HISTENSEQ | Long | Next History Entry Seq. |
DAYENDSEQ | Long | Next Day End Posting Seq. |
MULTICURR | Boolean | Multicurrency |
DEFERGLPST | Boolean | Deferred G/L Posting |
APPENDGL | Integer | Append To G/L Batch | List: 3 entries
1 | = | Adding to an Existing Batch
0 | = | Creating a New Batch
2 | = | Creating and Posting a New Batch
CONSOLGL | Integer | Consolidate G/L Batch | 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 | Integer | Statistics Calendar | List: 2 entries
1 | = | Calendar Year
2 | = | Fiscal Year
STATPRD | Integer | Statistics Period | 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 | Boolean | Edit Statistics |
CRTITEMLOC | Boolean | Allow Items at All Locations |
ADDCSTTYPE | Integer | Add'l. Cost on Rcpt. Returns | List: 2 entries
1 | = | Leave
2 | = | Prorate
RATETYPE | String*2 | Default Rate Type | Mask: %-2N
ITEMBRKID | String*6 | Default Item Structure | Mask: %-6N
STATACCUM | Boolean | Accumulate Item Statistics |
PSTTOCLOSD | Boolean | Post To Closed Fiscal Periods |
HYHEN | Boolean | Use Hyhen as Item Separator |
FWDSLASH | Boolean | Use Forward Slash as Item Separator |
BCKSLASH | Boolean | Use Back Slash as Item Separator |
ASTERISK | Boolean | Use Asterisk as Item Separator |
PERIOD | Boolean | Use Period as Item Separator |
LFTPARENS | Boolean | Use Left Parenthesis as Item Separator |
RGTPARENS | Boolean | Use Right Parenthesis as Item Separator |
POUNDSGN | Boolean | Use Pound Sign as Item Separator |
RECNONSTK | Boolean | Allow Receipt of Non-stock Items |
DELPROMPT | Boolean | Prompt to Delete during Posting |
COSTDURING | Integer | Cost During | List: 2 entries
1 | = | Day End Processing
2 | = | Posting
ASSNUMBERL | Integer | Assembly Number Length |
ASSPREFIXD | String*6 | Assembly Number Prefix | Mask: %-6C
ASSBODYD | String*22 | Next Assembly Number | Mask: %19D
DASNUMBERL | Integer | Disassembly Number Length |
DASPREFIXD | String*6 | Disassembly Number Prefix | Mask: %-6C
DASBODYD | String*22 | Next Disassembly Number | Mask: %19D
TRFNUMBERL | Integer | Transfer Number Length |
TRFPREFIXD | String*6 | Transfer Number Prefix | Mask: %-6C
TRFBODYD | String*22 | Next Transfer Number | Mask: %19D
ADJNUMBERL | Integer | Adjustment Number Length |
ADJPREFIXD | String*6 | Adjustment Number Prefix | Mask: %-6C
ADJBODYD | String*22 | Next Adjustment Number | Mask: %19D
SHPNUMBERL | Integer | Shipment Number Length |
SHPPREFIXD | String*6 | Shipment Number Prefix | Mask: %-6C
SHPBODYD | String*22 | Next Shipment Number | Mask: %19D
SRTNUMBERL | Integer | Shipment Return Number Length |
SRTPREFIXD | String*6 | Shipment Return Number Prefix | Mask: %-6C
SRTBODYD | String*22 | Next Shipment Return Number | Mask: %19D
RCPNUMBERL | Integer | Receipt Number Length |
RCPPREFIXD | String*6 | Receipt Number Prefix | Mask: %-6C
RCPBODYD | String*22 | Next Receipt Number | Mask: %19D
TRCNUMBERL | Integer | Transit Receipt Number Length |
TRCPREFIXD | String*6 | Transit Receipt Number Prefix | Mask: %-6C
TRCBODYD | String*22 | Next Transit Receipt Number | Mask: %19D
RECDESEQ | Long | Next Non-costed Receipt Day End Seq. |
GITLOC | String*6 | Default Goods in Transit Location | Mask: %-6N
DEFUOM | Boolean | Only Use Defined UOM |
AGING1 | BCD*3.0 | Aging Period 1 |
AGING2 | BCD*3.0 | Aging Period 2 |
AGING3 | BCD*3.0 | Aging Period 3 |
SLAUDURING | Integer | Create Subledger/Audit During | List: 2 entries
1 | = | Day End Processing
2 | = | Posting
ICSENSEQ | Long | Next Internal Usage Entry Seq. |
ICSNUMBERL | Integer | Internal Usage Number Length |
ICSPREFIXD | String*6 | Internal Usage Number Prefix | Mask: %-6C
ICSBODYD | String*22 | Next Internal Usage Number | Mask: %19D
SRCTYPERC | String*2 | I/C Receipts | Mask: %-2N
SRCTYPERR | String*2 | I/C Receipt Returns | Mask: %-2N
SRCTYPERA | String*2 | I/C Receipt Adjustments | Mask: %-2N
SRCTYPESH | String*2 | I/C Shipments | Mask: %-2N
SRCTYPESR | String*2 | I/C Shipment Returns | Mask: %-2N
SRCTYPETF | String*2 | I/C Transfers | Mask: %-2N
SRCTYPEAS | String*2 | I/C Assemblies | Mask: %-2N
SRCTYPEAD | String*2 | I/C Adjustments | Mask: %-2N
SRCTYPECO | String*2 | I/C Consolidated Entry | Mask: %-2N
SRCTYPEDA | String*2 | I/C Disassemblies | Mask: %-2N
SRCTYPEIN | String*2 | I/C Internal Usage | Mask: %-2N
DATEBUSDFT | Integer | Default Posting Date | List: 2 entries
1 | = | Document Date
2 | = | Session Date
SERIALMASK | String*6 | Serial Number Mask | Mask: %-6N
SUSEEXPDAY | Boolean | Use Serials Days to Expire |
SEXPDAYS | Integer | Serials Days to Expire |
SDIFQTYOK | Boolean | Allow Different Serial Qty |
SALCQTYORD | Boolean | Allow Serial Alloc on Qty Ord. |
SSORTBY | Integer | Sort Serials by | List: 3 entries
1 | = | Serial Number
2 | = | Stock Date
3 | = | Expiry Date
SFIRST | Integer | Sort Serials First by | List: 2 entries
1 | = | Earliest
2 | = | Latest
SEXPLEVEL | Integer | Stop Allocation of Expired Serials | List: 3 entries
0 | = | None
1 | = | Warning
2 | = | Error
SHYPHEN | Boolean | Serials Hyphen as Separator |
SFWDSLASH | Boolean | Serials Fwd Slash as Separator |
SBCKSLASH | Boolean | Serials Back Slash as Separator |
SASTERISK | Boolean | Serials Asterisk as Separator |
SPERIOD | Boolean | Serials Period as Separator |
SLFPARENS | Boolean | Serials Left Parenthesis as Sep |
SRGTPARENS | Boolean | Serials Right Parenthesis as Sep |
SPOUNDSIGN | Boolean | Serials Pound Sign as Separator |
SLFBRACKT | Boolean | Serials Left Bracket as Sep |
SRGTBRACKT | Boolean | Serials Right Bracket as Sep |
SLFBRACE | Boolean | Serials Left Brace as Sep |
SRGTBRACE | Boolean | Serials Right Brace as Sep |
LOTMASK | String*6 | Lot Number Mask | Mask: %-6N
LUSEEXPDAY | Boolean | Use Lots Days to Expire |
LEXPDAYS | Integer | Lots Days to Expire |
LUSEQRNDAY | Boolean | Use Lots Days on Quarantine |
LQRNDAYS | Integer | Lots Days on Quarantine |
LDIFQTYOK | Boolean | Allow Different Lot Qty |
LALCQTYORD | Boolean | Allow Lot Alloc on Qty Ord. |
LSORTBY | Integer | Sort Lots by | List: 3 entries
1 | = | Lot Number
2 | = | Stock Date
3 | = | Expiry Date
LFIRST | Integer | Sort Lots First by | List: 2 entries
1 | = | Earliest
2 | = | Latest
LEXPLEVEL | Integer | Stop Allocation of Expired Lots | List: 3 entries
0 | = | None
1 | = | Warning
2 | = | Error
LHYPHEN | Boolean | Lots Hyphen as Separator |
LFWDSLASH | Boolean | Lots Fwd Slash as Separator |
LBCKSLASH | Boolean | Lots Back Slash as Separator |
LASTERISK | Boolean | Lots Asterisk as Separator |
LPERIOD | Boolean | Lots Period as Separator |
LLFPARENS | Boolean | Lots Left Parenthesis as Sep |
LRGTPARENS | Boolean | Lots Right Parenthesis as Sep |
LPOUNDSIGN | Boolean | Lots Pound Sign as Separator |
LLFBRACKT | Boolean | Lots Left Bracket as Separator |
LRGTBRACKT | Boolean | Lots Right Bracket as Separator |
LLFBRACE | Boolean | Lots Left Brace as Separator |
LRGTBRACE | Boolean | Lots Right Brace as Separator |
RECALENSEQ | BCD*10.0 | Recall/Release Sequence Number |
RECNUMBERL | Integer | Recall Number Length |
RECPREFIXD | String*6 | Recall Number Prefix | Mask: %-6C
RECBODYD | String*22 | Next Recall Number | Mask: %19D
RELNUMBERL | Integer | Release Number Length |
RELPREFIXD | String*6 | Release Number Prefix | Mask: %-6C
RELBODYD | String*22 | Next Release Number | Mask: %19D
COMENSEQ | BCD*10.0 | Combine/Split Sequence Number |
COMNUMBERL | Integer | Combine Number Length |
COMPREFIXD | String*6 | Combine Number Prefix | Mask: %-6C
COMBODYD | String*22 | Next Combine Number | Mask: %19D
SPLNUMBERL | Integer | Split Number Length |
SPLPREFIXD | String*6 | Split Number Prefix | Mask: %-6C
SPLBODYD | String*22 | Next Split Number | Mask: %19D
RCNENSEQ | BCD*10.0 | Reconciliation Sequence Number |
RCNNUMBERL | Integer | Reconciliation Number Length |
RCNPREFIXD | String*6 | Reconciliation Number Prefix | Mask: %-6C
RCNBODYD | String*22 | Next Reconciliation Number | Mask: %19D

This page was generated on 2009-Nov-19

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