Create an Inventory Item

Write-off account. Reference to the ACCOUNT table.

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

💻 UI Fieldname: Alternate WM Allowed

Company Code

Revenue account. Reference to the ACCOUNT table.

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.

💻 UI Fieldname: *Item Code

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.

💻 UI Fieldname: *Buy Back

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

💻 UI Fieldname: *Issue At

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

💻 UI Fieldname: Average Cost Update Level

Is the Item available for MS system Y/N

💻 UI Fieldname: Available For MS System

Variance account. Reference to the ACCOUNT table.

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

💻 UI Fieldname: Serialized

Unique Row ID

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

💻 UI Fieldname: *Class Code

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

💻 UI Fieldname: Negative Balances

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

💻 UI Fieldname: Sales Code

Standard on-hand quantity

💻 UI Fieldname: Standard On Hand

Maximum on-hand quantity

💻 UI Fieldname: Maximum On Hand

Default EM component code for costing Equipment

💻 UI Fieldname: Equipment Category

Customer sales revenue account. Reference to the ACCOUNT table.

Default value for Production flag on the item/type level

💻 UI Fieldname: Production

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

💻 UI Fieldname: Re-Stock Charge

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

💻 UI Fieldname: Composite

Minimum on-hand quantity

💻 UI Fieldname: Minimum On Hand

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

💻 UI Fieldname: Minimum Order

Inventory Item that mapped to the Sales Product Code

💻 UI Fieldname: Item

Maximum order quantity

💻 UI Fieldname: Maximum Order

With CiitemCompCode a reference to ARTAX table

Affiliate sales revenue account. Reference to the ACCOUNT table.

Detailed description of the item

Item name used in most screens and reports

💻 UI Fieldname: Item Name

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.

💻 UI Fieldname: Partial

With CiitemCompCode a reference to ARTAX table

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

Standard order quantity

💻 UI Fieldname: Standard Order

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

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

💻 UI Fieldname: Returnable

Market price

💻 UI Fieldname: Market Price

With CiitemCompCode a reference to ARTAX table