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.