CI_ItemCode

Class CI_ItemCode_bus

Inherits

CI_Account_Val, CI_APDivision_val, CI_BuyerPlannerCode_val, CI_CommodityCode_val, CI_Constant, CI_Image_val, CI_ItemCode_val, CI_PriceCode_val, CI_ProductLine_val, CI_SalesPromoCode_val, CI_TaxClass_val, CI_VendorNo_val, CI_Warehouse_val, CI_WarrantyCode_Val, SY_Maint, SY_MaintSet

Properties

LOCAL cMainTable$="CI_Item"

LOCAL cIsSysDB=isFALSE

LOCAL cPriceCodeRecordType$="0"

LOCAL cBMMiscChgIOL$=CPL("IOLIST ItemCodeDesc$, ManufacturingCostAcctKey$, SetupCharge$, StandardUnitOfMeasure$, StandardUnitCost")

list of fields from misc charge items that are populated into B/M detail tables

LOCAL cAllowAliasItems

LOCAL cAllowEngineering

LOCAL cAllowInactive

PROPERTY HistoryObject * Read Only *

PROPERTY ItemWarehouseBusinessObj * Read Only *

PROPERTY ITItemBus * Read Only *

PROPERTY AllowItemWhseDelete * Read Only *

PROPERTY ItemImageDir$

PROPERTY UIClass$

PROPERTY ExtDescriptionText$

PROPERTY CopyFromExcludeItemVendor

When true, IM_ItemVendor records will be excluded from the copy item function that occurs during the PostWrite() method. This property defaults to false.

PROPERTY CopyFromExcludeAliasItem

When true, IM_AliasItem records will be excluded from the copy item function that occurs during the PostWrite() method. This property defaults to false.

PROPERTY SyncBillDescription

When true, in PostWriteRec() changes made to Item description will be sync'd to BM bill description, if before the change the item description was the same as bill description.

PROPERTY SyncMiscCharge

When true, in PostWriteRec() changes made to misc charge item will be sync'd to bill tables where item is a component item

PROPERTY PostWriteError$ * Read Only *

Stores LastErrorMsg$ set when a post write exception has occurred following a successful write of the main record.

PROPERTY MiscChargeBOMFieldsChanged

When true, one or more of the fields for misc charge items that are stored in the Bill of Materials detail tables has changed

PROPERTY ARIntegrated * Read Only *

PROPERTY APIntegrated * Read Only *

PROPERTY BMIntegrated * Read Only *

PROPERTY POIntegrated * Read Only *

PROPERTY SOIntegrated * Read Only *

PROPERTY ITIntegrated * Read Only *

PROPERTY MPIntegrated * Read Only *

PROPERTY RAIntegrated * Read Only *

PROPERTY WOIntegrated * Read Only *

PROPERTY SO_IMIntegrated * Read Only *

PROPERTY PO_IMIntegrated * Read Only *

PROPERTY AR.Divisions$ * Read Only *

PROPERTY AR.SalesTaxReporting$ * Read Only *

PROPERTY AR.SegmentForSalesPostings$ * Read Only *

PROPERTY AR.CommissionReporting$ * Read Only *

PROPERTY AR.PostCostOfGoodsSold$ * Read Only *

PROPERTY AP.Divisions$ * Read Only *

PROPERTY AP.SalesTaxReporting$ * Read Only *

PROPERTY IM.RequireMultipleWarehouses$ * Read Only *

PROPERTY IM.ReorderByWhse$ * Read Only *

PROPERTY IM.DefaultWarehouseCode$ * Read Only *

PROPERTY IM.CalculateCommByItem$ * Read Only *

PROPERTY IM.EnableWarrantyTracking$ * Read Only *

PROPERTY IM.TrackItemChanges$ * Read Only *

PROPERTY IM.TrackAdditionsInDetail$ * Read Only *

PROPERTY IM.PrintReceiptLabels$ * Read Only *

PROPERTY IM.IntegrateAccountsPayable$ * Read Only *

PROPERTY IM.Category1Desc$ * Read Only *

PROPERTY IM.Category2Desc$ * Read Only *

PROPERTY IM.Category3Desc$ * Read Only *

PROPERTY IM.Category4Desc$ * Read Only *

PROPERTY EnableLotSerialExpirationDates$ * Read Only *

Lot/Serial Expiration Dates enabled

PROPERTY PO.AllowEntryOfLandedCost$ * Read Only *

Methods

FUNCTION CheckForCostTiers(item$)

Check if an item has cost tiers in I/M item cost table

Parameter	Description
item$	[input, string] Item No

Returns

[boolean] True = item has cost tiers, False = item does not have cost tiers

FUNCTION CheckForIMTransaction(item$)

Check if an item is in I/M transaction entry

Parameter	Description
item$	[input, string] Item No

Returns

[boolean] True = item is in transaction entry, False = item is not in transaction entry

FUNCTION CheckForKit()

FUNCTION CheckForKit(kitIn$)

FUNCTION CheckForPhysicalCount(item$)

Check if an item is in I/M physical count entry

Parameter	Description
item$	[input, string] Item No

Returns

[boolean] True = item is in physical count entry, False = item is not in physical count entry

FUNCTION CheckForUseInBMDetail()

FUNCTION CheckForUseInBMDetail(inUse$)

FUNCTION CommodityCodeApplyUpdate(commodityCode$, applyWhere$, itemRec$, itemIOL$, soRec$, soIOL$)

Apply Commodity Code to Items / Sales Order Detail Lines

Parameter	Description
commodityCode$	Commodity code to apply
applyWhere$	Where clause to select the items to be affected
itemRec$	Fields in Item record to be changed
itemIOL$	IOLIST of fields in Item record to be changed
soRec$	Fields in sales order detail record to be changed
soIOL$	IOLIST of fields in sales order detail record to be changed

Returns

[boolean] True = success, False = failure

FUNCTION ConfirmDelete()

FUNCTION ConfirmDelete(fromUtil)

FUNCTION ConfirmDelete(fromUtil, item$)

FUNCTION CopyFrom(key$)

FUNCTION CopyFrom(key$, clearPrimVendor, xItmVendor, xAliasItm)

Copy Item

Parameter	Description
key$	[input, string] The source item code to copy
clearPrimVendor	{optional} [input, boolean] When true, include PrimaryAPDivisionNo$, PrimaryVendorNo in columns to clear
xItmVendor	{optional} [input, boolean] set CopyFromExcludeItemVendor option property, (defaults to false)
xAliasItm	{optional} [input, boolean] set CopyFromExcludeAliasItem option property, (defaults to false)

Returns

[boolean] True = success, False = failure

FUNCTION Delete(key$)

FUNCTION Delete(key$, fromUtil)

FUNCTION ProductLineApplyUpdate(productLine$, applyWhere$, categoryCode$, applyKitProductType, justApplyExplodeKitItems, itemRec$, itemIOL$, soRec$, soIOL$, poRec$, poIOL$)

FUNCTION ProductLineApplyUpdate(productLine$, applyWhere$, categoryCode$, applyKitProductType, justApplyExplodeKitItems, itemRec$, itemIOL$, soRec$, soIOL$, poRec$, poIOL$, applyLSED, lsedRec$, lsedIOL$)

Apply Product Line to Items

Parameter	Description
productLine$	Product LIne to apply
applyWhere$	Where clause to select the items to be affected
categoryCode$	Category code to create, if it does not exist
applyKitProductType	Apply Kit Product Type to item(s)
justApplyExplodeKitItems	Apply Explode Kit Items option
itemRec$	Fields in Item record to be changed
itemIOL$	IOLIST of fields in Item record to be changed
soRec$	Fields in sales order detail record to be changed
soIOL$	IOLIST of fields in sales order detail record to be changed
poRec$	Fields in purchase order detail record to be changed
poIOL$	IOLIST of fields in purchase order detail record to be changed
applyLSED	Apply Lot/Serial Expiration Date settings
lsedRec$	Lot/Serial Expiration Date values from Product Line to apply to items
lsedIOL$	Lot/Serial Expiration Date fields for item to update

Returns

[boolean] True = success, False = failure

FUNCTION RenumberItemCode(oldItemCode$, newItemCode$)

FUNCTION SetCopyKeyValue(col$, val$)

FUNCTION WRITE()

Properties inherited from: SY_Maint

cActionWrite, cActionDelete, cActivityLogFilePrefix$, DocDateWarnDisplayed, DocDateWarnStatus, EditState, RecordChanged, FirstFailure$, DocumentTotal, ReadOnlyReason$, UDTValidation$, ViewOnly, CurrentPrecision, DocDateWarnForceOff, DocDateWarnObject, ScriptObject, ImportTest, SkipNullCheck$, AFSRequiredFields$

Methods inherited from: SY_Maint

ChangedRecordCompare(), ChangedRecordInfo(), Clear(), ClearRecord(), ConfirmDelete(), CopyFrom(), ExportToCSV(), GetColumnInfo(), GetColumnProperties$(), GetDefaults(), GetOrigRecord$(), GetPropertyValue(), GetValidationGroups$(), ResetDocDateWarnState(), SetCopyKeyValue(), SetDocDateWarnDisplayed(), SetDocDateWarnOff(), SetKey(), SetKeyValue(), SetPartialRecord(), SetRecord(), SetToReadOnly(), SetValue(), SetValues(), Write(), ActivityLogCreateFile(), ActivityLogPrepare(), ActivityLogSetMessage$(), ActivityLogWrite(), CallScript(), CheckForAdvancedFieldSettings(), CheckForScripts(), CheckNullRequiredField(), PERFORM ChildValidate(), ClassValidateDate(), ClassValidateTelephoneNo(), ClearSetFiles(), ColInfoInitAll(), ColInfoInitDefaults(), CommitRow(), GetPropertyCommon(), InitColInfo(), InitScriptEngine(), InitWorkTable(), IsColInIOList(), IsValid(), LoadColInfo(), OpenMainTable(), ParseExtField(), RemoveColToSkip(), ResetRow(), RetrieveColInfo(), SetDefaults(), SetFilter(), SetMode(), SetParentHandle(), SetValueNoValidate(), StoreColToSkip(), ValidateAll(), ValidateAllRecord(), ValidateColInfo(), ValidateRule()