F4160CountTagStatus

Inventory Tag Count

Minor Business Rule

Object Name: B4100780

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This function reads the Tag table (F4160) and counts the total number of tags for each status for all
branch/plants or one particular branch/plant.

Setup Notes and Prerequisites
The Tag Status (TST) and Branch/Plant (MCU) are required input parameters. If the Branch/Plant field
is blank

Technical Specification

If the Branch parameter is blank, the number of tags are counted for each individual status. If the
Branch parameter is not blank, the function counts only the number of tags for each individual status
for the specified Branch.

^

Data Structure

D4100780D - F4160 Count Tag Status

Data Item Data Structure DescriptionI/ORequired

TSTS        Tag Status             I  Y
MCU        Branch/Plant             I  Y
MATH80  Number of Tags             O

^

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szTagStatus	TSTS	char	NONE	NONE
The code (UDC table 41/TS) for the status of a tag in the tag inventory count process.
szBranchPlant	MCU	char	NONE	NONE
If blank, count all number of items for all statuses.ab ^
mnNumberOfTags	MATH08	MATH_NUMERIC	NONE	NONE
Event point for Math Numeric.

Related Functions

None

Related Tables

F4160 Tag Inventory File

F4160RetrieveLastTagNumber

Inventory Tag Count

Major Business Rule

Object Name: B4100780

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This function returns the tag number of the last printed tag inventory record in the Tag Inventory
table (F4160).

Technical Specification

This function sorts the Tag table (F4160) in descending order and retrieves the last record written
to the F4160. The Tag Number (TGG) is returned.

^

Data Structure

D4100780A - F4160 Retrieve Last Tag Printed

Data Item Data Structure Description I/O Required

TGG Tag Number O Y
^

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnTagNumber	TGG	MATH_NUMERIC	NONE	NONE
This is the last Tag Number in F4160.ab ^

Related Functions

None

Related Tables

F4160 Tag Inventory File

F4160RetrieveTagStatusCode

Inventory Tag Count

Minor Business Rule

Object Name: B4100780

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This function retrieves the Tag Status and Date Updated from the Tag table (F4160).

Setup Notes and Prerequisites
The Tag Number (TGG) is a required input parameter.

Technical Specification

This function retrieves the tag status (TSTS) and date updated (UPMJ) for the Tag Number passed in.
If the record is not found, an error is issued.

^

Data Structure

D4100780C - Retrieve Tag Status Code

Data Item Data Structure DescriptionI/ORequired

TGG        Tag Number             I  Y
TSTS        Tag Status             O
UPMJ         Date Updated             O

^

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnTagNumber	TGG	MATH_NUMERIC	NONE	NONE
If TGG doesn't exist in the F4160, error 2197 is set on this field.ab ^
szTagStatus	TSTS	char	NONE	NONE
The code (UDC table 41/TS) for the status of a tag in the tag inventory count process.
jdDateUpdated	UPMJ	JDEDATE	NONE	NONE
The date that specifies the last update to the file record.

Related Functions

None

Related Tables

F4160 Tag Inventory File

F4160UpdateTagCountRecord

Inventory Tag Count

Minor Business Rule

Object Name: B4100780

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This function verifies if the Item, Branch, Location and Lot combination exists in the Tag table
(F4160).

Setup Notes and Prerequisites
All fields to be updated to the Tag table need to be passed in.

Technical Specification

This function retreives the F4160 for the Item, Branch, Location and Lot passed in.  If the status is
not equal to '60' for closed, processing continues.  If the F4160 is found but the status is not
equal to that passed in, and error is issued.  If the record is found and the status is good, the F4160 is
updated with the parameters passed in.

Data Structure

D4100780E - F4160 Update Tag Count Record

Data Item Data Structure DescriptionI/ORequired

TGG        Tag Number             I  Y
ITM        Short Item Number       I   Y
MCU        Branch/Plant             I  Y
LOCN        Location                   I  Y
LOTN        Lot                         I  Y
CTAN        Count Team ID             I  Y
ENTB        Entered By             I  Y
UPID        Updated By             I  Y
DJST        Date of Tag Status       I  Y
TSTS        Tag Status             I  Y
TST        Time of Tag Status       I  Y
TRQT        Quantity Counted       I  Y
UNCS        Unit Cost                   I  Y
UOM        Primary Unit of Measure I  Y
RMK        Remark                   I  Y
LITM        Second Item Number       I  Y
AITM        Third Item Number       I  Y
ERR        Error Message             O  Y

^

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

mnTagNumber TGG MATH_NUMERIC NONE NONE

A number that the system assigns to the tag using the Print Tag program, based on the next available tag number.

szBranchPlant MCU char NONE NONE

An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units
for which you have no authority.

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

szLocation LOCN char NONE NONE

The storage location from which goods will be moved.

szLotNumber LOTN char NONE NONE

A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics.

mnQuantityCounted TRQT MATH_NUMERIC NONE NONE

A value that represents the available quantity, which might consist of the on-hand balance minus commitments, reservations, and
backorders. You enter this value in the Branch/Plant Constants program (P41001).

szPrimaryUOM UOM1 char NONE NONE

A user defined code (00/UM) that identifies the unit of measure that the system uses to express the quantity of an item, for example, EA
(each) or KG (kilogram).

szEnteredBy ENTB char NONE NONE

The User I.D. of the individual who entered a physical count through Count Entry.  This field is updated automatically by the program.

szUpdatedBy UPID char NONE NONE

This field is updated with the name of the person who last updated the tag.

szTagStatus TSTS char NONE NONE

The code (UDC table 41/TS) for the status of a tag in the tag inventory count process.

jdDateOfStatus DJST JDEDATE NONE NONE

The last date that the status of this tag changed.

mnTimeOfStatus TST MATH_NUMERIC NONE NONE

This field is updated with the time of the last activity on the tag.

szRemark RMK char NONE NONE

A generic field that you use for a remark, description, name, or address.

mnUnitCost UNCS MATH_NUMERIC NONE NONE

The amount per unit, derived by dividing the total cost by the unit quantity.

szSecondItemNumber LITM char NONE NONE

A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
alternative item numbers. The three types of item numbers are: Item Number (short) An 8-digit, computer-assigned item number. 2nd Item Number A
25-digit, user defined, alphanumeric item number. 3rd Item Number Another 25-digit, user defined, alphanumeric item number. In addition to
these three basic item numbers, the system provides an extensive cross-reference search capability. You can define numerous
cross-references to alternative part numbers. For example, you can define substitute item numbers, replacements, bar codes, customer numbers, or
supplier numbers.

szThirdItemNumber AITM char NONE NONE

The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
numbers are as follows: 1.  Item Number (short) - An 8-digit, computer-assigned item number. 2.  2nd Item Number - The 25-digit, free-form, user
defined alphanumeric item number. 3.  3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number. In addition to
these three basic item numbers, an extensive cross-reference search capability has been provided (see XRT). Numerous cross references to
alternate part numbers can be user defined, such as substitute item numbers, replacements, bar codes, customer numbers, or supplier
numbers.

cErrorCode ERR char NONE NONE

The Data Field Error Code field is simply a generic data field to pass an error condition flag.  This field is one of the fields that make up the
external parameter data structure of the Data Dictionary Server.

mnSecondaryQuantityCounted SQOR MATH_NUMERIC OPT NONE

If the secondary unit of measure option in Inventory Constants is selected,this field will display on data entry screens.

szSecondaryUOM UOM2 char OPT NONE

A user defined code (00/UM) that indicates an alternate unit of measure for the item.

Related Functions

None

Related Tables

F4160 Tag Inventory File

F4160UpdateTagStatusCode
F4160UpdateTagStatusCode

Inventory Tag Count

Minor Business Rule

Object Name: B4100780

Parent DLL: COPBASE

Location: Client/Server

Language: C

Functional Description

Purpose
This function updates the tag status.

Setup Notes and Prerequisites
The Tag Number (TGG), Branch/Plant (MCU), Tag Status (TSTS), Updated By (UPID), Date (DJST), Time
(TST) and Date Printed (DPRT) are required input parameters.

If the Program Id is 'P41601', the Tag Team Id - Issued (TMAN) and Tag Team Id - Received (RMAN) are
also required.

Technical Specification
This function does the following:

Write F4160 record with fields as follows:
TGGTag NumberPassed in
MCUBranch/PlantPassed in
UPIDUpdated ByPassed in
TSTSTag StatusPassed in
DJSTDate of Tag StatusPassed in
TSTTime of Tag StatusPassed in
DPRTDate PrintedPassed in
TMANTag Team ID - IssuedPassed in
RMANTag Team ID - ReceivedPassed in

If TSTS = 'PT' then
Update MCU
Update TGG
Update TSTS = 'PT'
Update DPRT
Update UPID
Update DJST
Update TST

If TSTS = IS then
Update DISS
Update TSTS = 'IS'
Update TMAN
Update UPID
Update DJST
Update TST

If TSTS = RE then
Update TSTS = 'RE'
Update RMAN
Update UPID
Update DJST
Update TST

If TSTS = CL then
Update TSTS = 'CL'
Update UPMJ
Update UPID
Update DJST
Update TST

If TSTS = DS then
Update TSTS = 'DS'
Update UPID
Update DJST
Update TST

If TSTS = HD then
Update TSTS = 'HD'
Update UPID
Update DJST
Update TST

If TSTS = RU then
Update TSTS = 'RU'
Update UPID
Update DJST
Update TST

If TSTS = UA then
Update TSTS = 'UA'
Update UPID
Update DJST
Update TST

^

Data Structure

D4100780B - F4160 UpdateTag Status Code

Data Item  Data Structure Description  I/O  Required

TGG       Tag Number                I   Y
MCU       Branch/Plant          I   Y
UPID       Updated By                I   Y
TSTS       Tag Status                I   Y
DJST       Date of Tag Status    I   Y
TST       Time of Tag Status    I   Y
DPRT       Date Printed          I   Y
TMAN       Tag Team ID - Issued    I   N ('Y' if program ID = P41601)
RMAN       Tag Team ID - Received    I    N ('Y' if program ID = P41601)

^

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

mnTagNumber TGG MATH_NUMERIC NONE NONE

A number that the system assigns to the tag using the Print Tag program, based on the next available tag number.

szBranchPlant MCU char NONE NONE

An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units
for which you have no authority.

szUpdatedBy UPID char NONE NONE

This field is updated with the name of the person who last updated the tag.

szTagStatus TSTS char NONE NONE

The code (UDC table 41/TS) for the status of a tag in the tag inventory count process.

jdDateOfTagStatus DJST JDEDATE NONE NONE

The last date that the status of this tag changed.

mnTimeOfTagStatus TST MATH_NUMERIC NONE NONE

This field is updated with the time of the last activity on the tag.

jdDatePrinted DPRT JDEDATE NONE NONE

The date the tag was printed for physical inventory count purposes.

mnIssuedTagTeamID TMAN MATH_NUMERIC NONE NONE

This parameter is required if the program ID = P41601.ab
^

mnReceivedTagTeamID RMAN MATH_NUMERIC NONE NONE

This parameter is required if the program ID = P41601.ab

^

Related Functions

None

Related Tables

F4160 Tag Inventory File