Create an Inventory Item

Write-off account. Reference to the ACCOUNT table.

‘Y’ if alternate unit conversions are enabled. ‘N’ if not.

Company Code

Revenue account. Reference to the ACCOUNT table.

Flag to indicate if system will auto assemble non-production composite item upon issue posting

‘Y’ or ‘N’. Set this to ‘N’ unless CIITEM_SERIAL_FLAG = ‘Y’ and CIITEM_COST_METH_CODE = ’F’

Not used. Set this to ‘N’

Reference to a weight/measure code defined in WGTMES_TABLE

Key value 2; Inventory item code or number. If the fixed length flag is set in the control file, this code must be of the length specified in the control file.

Inventory account. Reference to the ACCOUNT table.

One of AVG (average cost), SF (standard FIFO), F (modified FIFO) and STD (standard cost). The validation program does not check but this should be the same value as in the item’s class.

‘P’ if the buyback price is entered explicitly. ‘C’ if it calculated as a percentage of the cost price.

‘P’ if the selling price is entered explicitly, ‘C’ if it calculated as a percentage of the cost price.

Adjustment account. Reference to the ACCOUNT table.

Suspense account. Reference to the ACCOUNT table.

If using the Average Cost method of inventory valuation, specify whether to update the average cost of this inventory item by the total inventory (‘I’), or by the inventory within a specified location (‘L’).

Is the Item available for MS system Y/N

Variance account. Reference to the ACCOUNT table.

‘Y’ if the item is serialized, ‘N’ if not.

Unique Row ID

Key value 3; Reference (with CIITEM_COMP_CODE) to a class defined in the CICLASS table.

With CiitemCompCode a reference to ARTAX table

With CiitemCompCode a reference to ARTAX table

Used in ADF to create default Item Detail right with the insert of Item Master

Allow negative balances

File path to a picture of the item.

Accumulated depreciation account. Reference to the ACCOUNT table.

Item setup for Sales Product Code Y = Yes N = No

Standard on-hand quantity

Maximum on-hand quantity

Date this record was added

Default EM component code for costing Equipment

Customer sales revenue account. Reference to the ACCOUNT table.

Depreciation expense account. Reference to the ACCOUNT table.

Default value for Production flag on the item/type level

Dollar amount that will be added to each unit of this inventory item, when all or a portion of the item is returned.

‘Y’ if this is a composite item, ‘N’ otherwise

Minimum on-hand quantity

Date this record was last modified

Used in ADF to create default Item Header right with the insert of Item Master

With CiitemCompCode a reference to ARTAX table

Minimum order quantity

Inventory Item that mapped to the Sales Product Code

Maximum order quantity

Not used.

With CiitemCompCode a reference to ARTAX table

Affiliate sales revenue account. Reference to the ACCOUNT table.

Userid of the person who added the record

Detailed description of the item

Item name used in most screens and reports

Zone Pricing Code Oraseq (key to Zone Pricing Table)

Selling/issue price or percentage. If percentage remember to make it 100+markup.

If CIITEM_CMP_FLAG=’Y’ this flag indicates whether the item can be issued only partially assembled. ‘Y’ means it can, ‘N’ means it cannot.

With CiitemCompCode a reference to ARTAX table

Cost of goods sold account. Reference to the ACCOUNT table.

Standard order quantity

Buy back price or percentage. If percentage remember to make it 100+markup.

‘Y’ if this item can be returned, ‘N’ otherwise

Userid of the person who last modified the record

Market price

With CiitemCompCode a reference to ARTAX table