UpdateUserIndexWithVariances

Update User Index With Variances

Minor Business Rule

Object Name: B3100780

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
This function updates the UserIndex File F31UI002 with value passed : Planned, Actual, Completed or
Scrap. In Mode 0, It updates one record at a time for one Work Order, Item and Cost type. In Mode 1, it
deletes all records with the Job Number passed.

1.2Setup Notes and Prerequisites
1.3Special Logic

2.Technical Specifications
2.4Processing

If mode = 1,

Delete all Records in F31UI002 for the Job Number.

If Mode = 0,

Initialize F31UI002 Fields
Read F31UI002 with Work Order, Item, Part and Cost Type
F31UI002 Unit of Measure = Unit of Measure Passed

•
If First Transaction Type = "P"

F31UI002 Planned Amount = F31UI002 Planned Amount  + Calculated Amount
F31UI002 Planned Units = F31UI002 Planned Units + Calculated Units

•
If First Transaction Type = "A"

F31UI002 Actual Amount = F31UI002 Actual Amount + Calculated Amount
F31UI002 Actual Units = F31UI002 Actual Units + Calculated Units

•
If First Transaction Type = "C"

F31UI002 Completed Amount = F31UI002 Completed Amount  + Calculated Amount
F31UI002 Completed Units = F31UI002 Completed Units + Calculated Units

•
If First Transaction Type = "S"

F31UI002 Scrap Amount = F31UI002 Scrap Amount + Calculated Amount
F31UI002 Scrap Units = F31UI002 Scrap Units +  Calculated Units

•
If First Transaction Type = "M"

F31UI002 Manufactured Cost = Calculated Amount

•
If First Transaction Type = "Q"

F31UI002 Qty shipped = Calculated Units

•
If First Transaction Type = "0"

F31UI002 Standard Amounts = Calculated Amount
F31UI002 Standard Units = Calculated Units
F31UI002 Planned Amount = 0
F31UI002 Planned Units = 0
F31UI002 Actual Amount = 0
F31UI002 Actual Units = 0
F31UI002 Completed Amount = 0
F31UI002 Completed Units = 0
F31UI002 Scrap Amount = 0
F31UI002 Scrap Units = 0
F31UI002 Manufactured Cost = 0
F31UI002 Qty shipped = 0

If Second and Third Transaction Types are not blank, proceed the same.

If record exists, update F31UI002
Else, Create F31UI002 (key = Work Order, Item, Part and Cost Type)

Data Structure

D3100780 - Update User Index With Variances

Parameter Name Data Item Data Type Req/Opt I/O/Both

cMode EV01 char NONE NONE

An option that specifies the type of processing for an event.

cFirstTransactionType EV01 char NONE NONE

An option that specifies the type of processing for an event.

mnOrderNumber DOCO MATH_NUMERIC NONE NONE

A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
and so on.

mnShortItemNumber ITM MATH_NUMERIC NONE NONE

An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and
so forth. The item numbers are as follows:   o Item Number (short) - An eight-digit, computer-assigned item number     o 2nd Item Number - The
25-digit, free-form, user defined alphanumeric item number     o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item
number

cParentChildRelationship PART char NONE NONE

An option that specifies whether the system displays parent records or child records. If you turn on this option, the system displays parent
records for the address book number entered. Also a field that indicates whether a record is a parent or child. For the field, valid values
are: P Parent   C Child

szCostType COST char NONE NONE

A code that designates each element of cost for an item. Examples of the cost object types are:   o  A1  Purchased raw material   o  B1
Direct labor routing rollup   o  B2  Setup labor routing rollup   o  C1  Variable burden routing rollup   o  C2  Fixed burden routing rollup   o  Dx  Outside
operation routing rollup   o  Xx  Extra add-ons, such as electricity and water The optional add-on computations usually operate with the type
Xx extra add-ons. This cost structure allows you to use an unlimited number of cost components to calculate alternative cost rollups. The
system then associates these cost components with one of six user defined summary cost buckets.

mnFirstCalculatedAmount MN15D4 MATH_NUMERIC NONE NONE

mnFirstCalculatedUnits OPUN MATH_NUMERIC NONE NONE

The standard units to produce a given amount of product.

szUnitOfMeasure UOM char NONE NONE

A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box).

mnJobNumber JOBS MATH_NUMERIC NONE NONE

The job number (work station ID) which executed the particular job.

szComputerID CTID char NONE NONE

cSuppressErrorMessages EV01 char NONE NONE

An option that specifies the type of processing for an event.

szErrorMessageID DTAI char NONE NONE

A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

szUserID USER char NONE NONE

The code that identifies a user profile.

cSecondTransactionType EV02 char NONE NONE

An option that specifies the type of processing for an event.

mnSecondCalculatedAmount MN15D4 MATH_NUMERIC NONE NONE

mnSecondCalculatedUnits OPUN MATH_NUMERIC NONE NONE

The standard units to produce a given amount of product.

cThirdTransactionType EV02 char NONE NONE

An option that specifies the type of processing for an event.

mnThirdCalculatedAmount MN15D4 MATH_NUMERIC NONE NONE

mnThirdCalculatedUnits OPUN MATH_NUMERIC NONE NONE

The standard units to produce a given amount of product.

Related Functions

None

Related Tables

F31UI002 User Index - Variances

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cMode	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
cFirstTransactionType	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
mnOrderNumber	DOCO	MATH_NUMERIC	NONE	NONE
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry, and so on.
mnShortItemNumber	ITM	MATH_NUMERIC	NONE	NONE
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and so forth. The item numbers are as follows: o Item Number (short) - An eight-digit, computer-assigned item number o 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number
cParentChildRelationship	PART	char	NONE	NONE
An option that specifies whether the system displays parent records or child records. If you turn on this option, the system displays parent records for the address book number entered. Also a field that indicates whether a record is a parent or child. For the field, valid values are: P Parent C Child
szCostType	COST	char	NONE	NONE
A code that designates each element of cost for an item. Examples of the cost object types are: o A1 Purchased raw material o B1 Direct labor routing rollup o B2 Setup labor routing rollup o C1 Variable burden routing rollup o C2 Fixed burden routing rollup o Dx Outside operation routing rollup o Xx Extra add-ons, such as electricity and water The optional add-on computations usually operate with the type Xx extra add-ons. This cost structure allows you to use an unlimited number of cost components to calculate alternative cost rollups. The system then associates these cost components with one of six user defined summary cost buckets.
mnFirstCalculatedAmount	MN15D4	MATH_NUMERIC	NONE	NONE

mnFirstCalculatedUnits	OPUN	MATH_NUMERIC	NONE	NONE
The standard units to produce a given amount of product.
szUnitOfMeasure	UOM	char	NONE	NONE
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box).
mnJobNumber	JOBS	MATH_NUMERIC	NONE	NONE
The job number (work station ID) which executed the particular job.
szComputerID	CTID	char	NONE	NONE

cSuppressErrorMessages	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szErrorMessageID	DTAI	char	NONE	NONE
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
szUserID	USER	char	NONE	NONE
The code that identifies a user profile.
cSecondTransactionType	EV02	char	NONE	NONE
An option that specifies the type of processing for an event.
mnSecondCalculatedAmount	MN15D4	MATH_NUMERIC	NONE	NONE

mnSecondCalculatedUnits	OPUN	MATH_NUMERIC	NONE	NONE
The standard units to produce a given amount of product.
cThirdTransactionType	EV02	char	NONE	NONE
An option that specifies the type of processing for an event.
mnThirdCalculatedAmount	MN15D4	MATH_NUMERIC	NONE	NONE

mnThirdCalculatedUnits	OPUN	MATH_NUMERIC	NONE	NONE
The standard units to produce a given amount of product.