WriteF09218HeaderRecord

Write F09218 Header Record

Major Business Rule

Object Name: B0900052

Parent DLL: CFIN

Location: Client/Server

Language: C

Functional Description

Purpose
This function gathers data from the Online Consolidations program (P09218) and either creates a new
Consolidation Header record or updates an existing one.  There is a Mode flag that is used to determine
Add or Update Mode.  If calling this function in Add mode, the Next Number used for the Consolidation
Header record will be passed back in the parameter.  If this function is in Generate mode, it will
set the Generation Date field of the F09218 table to the current System Date.

Setup Notes and Prerequisites
If adding a new consolidation header record, pass an "A" in the Mode Flag along with the following:
Index Name, Index Description, Company, Category Code 1-4, Category Code Values 1-4.

If updating an existing consolidation header record, pass a "U" in the Mode Flag along with the
following: Index Name, Index Description, Company, Category Code 1-4, Category Code Values 1-4.

If generating a consolidation header record, pass a "G" in the Mode Flag along with the Index Name.

Technical Specification
If Mode flag is "A"
   Get Next Number for Consolidation
   Load Next Number into return value for BSFN data structure
   Open F09218 table
   Set Values passed in from P09218 application
   Insert Consolidation Header into F09218 table
   Close table
If Mode flag is "G"
   Open F09218 table
   Fetch Consolidation Header from F09218 table
   Set Generation Date to Current System Date
   Update Consolidation Header in F09218 table
   Close F09218 table
If Mode flag is "U"
   Open F09218 table
   Fetch Consolidation Header from F09218 table
   Set Values passed in from P09218 application
   Update Consolidation Header into F09218 table
   Close table

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szIndexName	IDXN	char	OPT	INPUT
Special Input Expected Pass the Index Name of the Consolidation. ^
szIndexDescription	DL10	char	OPT	INPUT
Special Input Expected Pass the Index Description for the Consolidation. ^
szCompany	CO	char	OPT	INPUT
Special Input Expected Pass the Company of the Consolidation. Pass an "*" for all companies. ^
szCategoryCode1	CDAA	char	OPT	INPUT
Special Input Expected Pass the Catergory Code from the first Category Code field. ^
szCategoryCodeValue1	CDAV	char	OPT	INPUT
Special Input Expected Pass the Catergory Code Value from the first Category Code Value field. ^
szCategoryCode2	CDBB	char	OPT	INPUT
Special Input Expected Pass the Catergory Code from the second Category Code field. ^
szCategoryCodeValue2	CDBV	char	OPT	INPUT
Special Input Expected Pass the Catergory Code Value from the second Category Code Value field. ^
szCategoryCode3	CDCC	char	OPT	INPUT
Special Input Expected Pass the Catergory Code from the third Category Code field. ^
szCategoryCodeValue3	CDCV	char	OPT	INPUT
Special Input Expected Pass the Catergory Code Value from the third Category Code Value field. ^
szCategoryCode4	CDDD	char	OPT	INPUT
Special Input Expected Pass the Catergory Code from the fourth Category Code field. ^
szCategoryCodeValue4	CDDV	char	OPT	INPUT
Special Input Expected Pass the Catergory Code Value from the fourth Category Code Value field. ^
jdGLDate	DGJ	JDEDATE	OPT	INPUT
Please disregard this parameter it is not used. ^
mnNextNumber	N001	MATH_NUMERIC	OPT	BOTH
Special Output Returned When adding a new Consolidation, this value will be passed back, it is the Consolidation's unique Next Number. ^
cModeFlag	EV01	char	OPT	INPUT
Special Input Expected Required parameter to set the processing mode. Valid values are: "A" - Adding a new Consolidation "G" - Generating the detail, setting the Generation Date "U" - Updating an existing Consolidation ^
szOrganizationType	OTPS	char	OPT	INPUT
A user-defined code (00/TS) that identifies the type of organization structure, such as financial or responsibility. Each type of organization structure can have a separate hierarchy.
szParentBusinessUnit	MCU1	char	OPT	INPUT
The primary level in a business unit hierarchy. A parent in one hierarchy can be a child in a different hierarchy.
szMaskedBusinessUnit	MCUM	char	OPT	INPUT
Use this field to select a search pattern within an existing business unit. Replace the wildcard characters with the search characters to create a specific search pattern. The characters you enter must be in the exact positions where they occur in the business unit number. For example, if you type 200 over the last three positions of the wildcard mask (*********200), the system searches for all business units ending in 200. If you enter blanks (spaces) the system searches for a pattern with blanks in those positions. Press F22 to clear the field and refresh the wildcard mask.

WriteF09218HeaderRecord