Table: I/C Options

Table: ICOPT
View: IC0380
Record Length: 938

Flags: A R 

Keys: 1

Title Flags Fields
Dummy Key DUMMY

Fields: 173

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

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).