F30026GetDetail

F30026 Get Detail Information

Major Business Rule

Object Name: B3001500

Parent DLL: CMFG

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
The purpose of this business function is to retrieve the detail information from the Item Cost
Component Table (F30026) using either the pointer or a key with full or partial index.

1.2Setup Notes and Prerequisites
List of Indexes:
1 = ITM, MMCU, LOCN, LOTN, LEDG, COST
2 = LEDG, ITM, MMCU, LOCN, LOTN, COST
Keys = Number of keys in the index that should be used to retrieve the row.

1.3Special Logic
None

2.Technical Specifications

2.4Processing
If the DS Pointer is not null, fetch the F30026 row using the input pointer.
If the DS Pointer is null, fetch the F30026 row based upon DS Index and DS Keys.
If the fetch failed or an error occurred, and DS Suppress Error Messages <> '1', assign DS Error
Message ID = '0002'; else, return the requested paraxmeters

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
idF30026GenLng	GENLNG	ID	NONE	NONE
General purpose ID variable.
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
sz2ndItemNumberL	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.
sz3rdItemNumberA	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.
szBranchNumber	MMCU	char	NONE	NONE
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which represent lower-level business units, subordinate to it. For example: o Branch/Plant (MMCU) o Dept A (MCU) o Dept B (MCU) o Job 123 (MCU) Business unit security is based on the higher-level business unit.
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.
szCostMethod	LEDG	char	NONE	NONE
A user defined code (40/CM) that specifies the basis for calculating item costs. Cost methods 01 through 19 are reserved for J.D. Edwards use.
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.
szLotGrade	LOTG	char	NONE	NONE
A code that indicates the grade of a lot. The grade is used to indicate the quality of the lot. Examples include the following: A1 Premium grade A2 Secondary grade The grade for a lot is stored in the Lot Master table (F4108).
mnFrozenCostAmount	STDC	MATH_NUMERIC	NONE	NONE
The cost of the item as calculated by the Simulate Cost Rollup program (P30820) and updated by the Frozen Cost Update program (P30835). You can also manually maintain this cost.
mnSimulatedMfgCost	XSMC	MATH_NUMERIC	NONE	NONE
Used to calculate cost during the simulation process.
mnFrozenCostRollupAmount	CSL	MATH_NUMERIC	NONE	NONE
The accumulated standard cost rolled up from lower levels.
mnSimulatedCostRollup	XSCR	MATH_NUMERIC	NONE	NONE
For the designated cost method, used to calculate the cost of all the lower levels during the simulation process.
szFrozenFactorCode	SCTC	char	NONE	NONE
A code used to retrieve factor information from the Generic Rate File (F00191). System Code 30 Record Type CF
szSimulatedFactorCode	XSFC	char	NONE	NONE
A user defined code (system 30, type CF) used to retrieve factor information from the Generic Rate table (F00191). This value is used in conjunction with the Rate Code and Rate Amount fields to calculate extra costs (electricity,taxes, tooling changes, and so on).
mnFrozenFactor	STFC	MATH_NUMERIC	NONE	NONE
A generic factor number used to calculate data.
mnSimulatedFactor	XSF	MATH_NUMERIC	NONE	NONE
A generic factor used to calculate data for standard cost component extras.
szFrozenRateCode	RATS	char	NONE	NONE
A code used to retrieve rate information from the Generic Rate File (F00191). System Code 30 Record Type CR
szSimulatedRateCode	XSRC	char	NONE	NONE
A user defined code (system 30, type CR) used to retrieve rate information from the Generic Rate table (F00191). This value is used in conjunction with the Factor Code and Factor Amount fields to calculate extra costs (electricity, taxes, tooling changes, and so on).
mnFrozenRate	RTSD	MATH_NUMERIC	NONE	NONE
A code used to define rate information in the Generic Rate File (F00191).
mnSimulatedRate	XSR	MATH_NUMERIC	NONE	NONE
A generic rate used to calculate extra costs, such as electricity and taxes.
cProcessingFlag	PFLG	char	NONE	NONE
A processing code to indicate the item is currently acitve in the simulation process. Blank Inactive 1 Active
cIndex	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
cKeys	EV02	char	NONE	NONE
An option that specifies the type of processing for an event.
cSuppressError	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.
szErrorMessage	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.

F30026GetDetail