F38010GetItemBalancingProduct

F38010 Get Item Balancing Product

Minor Business Rule

Object Name: N3800070

Parent DLL: CDIST

Location: Client/Server

Language: NER

Named ER Specification

Source NameN3800070DesignerMarie Midgley
Data Structure D3800070AProgrammerMarie Midgley
Function NameF38010GetItemBalancingProductSystem Code38
Function DescriptionF38010Get Item Balancing Product Function Category
Function Use

Revisions Log
Modifications bySAR NumberDescription
6/12/98Marie Midgley1765283Created

Functional Description

1.1Purpose
The purpose of this Named ER is to determine if a balancing product exists in the F38014 table.

1.2Setup Notes and Prerequisites
Called in Transaction Ledger Application in the event 'Dialog is Initialized'

1.3Special Logic

Technical Specifications

2.1Parameters:
Data Item Data Structure DescriptionI/ORequiredNotes
DMCTAgreement NumberIYes
DMCSAgreement Number SuppIYes
DMTCAgreement TypeONo
ITMShort ItemONo
DSC1Item DescriptionONo
EV01Error FlagONo
EV01Record ExistsONo

2.2Related Tables
Table Table Description
F38010Agreement Master

2.3Related Business Functions
Source NameFunction Name

2.4Processing

VA evt_BalProdExists = "0"
BF cRecordExists = " "
F38010.Fetch Single
  If VA evt_AgreementType is equal to "E"
  F38014.Select
  F38014.Fetch Next
    If BF szAgreementNumber is not equal to

      While SV File_IO_Status is equal to CO SUCCESS And VA evt_BalProdExists is not equal to    "1"
          If VA evt_BalProdFlag is equal to "X"
         BF mnShortItemNumber = VA evt_BalProdItem
         VA evt_BalProdExists = "1"
         Else
         F38014.Fetch Next
        End If
      End While
    BF cRecordExists = "1"
    F4101 Get Item Master Row by Short Item
    End If
  End If

^

Data Structure

D3800070A - Get Item Balancing Product

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szAgreementNumber	DMCT	char	OPT	NONE
A unique number your company assigns to identify a particular agreement. You might want to assign some significance to the agreement number (for example,an agreement type code, location, year, and so forth). An agreement might have multiple supplements to record addendum or changes, for example.
mnAgreementSupplement	DMCS	MATH_NUMERIC	OPT	NONE
The supplement number records any changes or addendum to agreements that occur over time or by item. It can also indicate individual agreements that are tied to a master agreement. The system allows up to 999 different supplements per base agreement number.
cAgreementType	DMTC	char	OPT	NONE
A user defined code that indicates the general type of the agreement.
mnShortItemNumber	ITM	MATH_NUMERIC	OPT	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
szItemDescription	DSC1	char	OPT	NONE
Brief information about an item; a remark or an explanation.
cErrorFlag	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cRecordExists	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.

Related Functions

None

Related Tables

None