1.Functional Description
1.1Purpose
This function will return the levels of the summary forecast hierarchy that match the input pieces of
the key, for the given forecast types.
1.2Setup Notes and Prerequisites
• The calling application must close the F3400 and F3460 tables using business function
C4102A1-FreeHuserAndHrequest when processing is complete.
1.3Special Logic
2.Technical Specifications
1.Create an array to hold the 54 Periods passed in and an array of 54 char flags PeriodCount
2.If GetMoreRecords is equal to blank
/*Load array @S with the key values*/
Create an 14 big array (@S) of 8 big fields
Move Company to @S,2
Move LevelOne- LevelTen into @S,3 - @S,12
Move Customer into @S,13
Move a ShortItem to @S,14
*/ Load the flags that indicate if a level is in the hierarchy into the array
@L*/
Create a 14 big array (@L) of one character fields and initialize them all to
zero
If Global Level is equal to '1'
Move a 1 to @L,1
End
If Company Level is equal to '1'
Move a 1 to @L,2
End
Move 03 to Y
Move Category1Level - Category10Level to a 10 big array (@C)
Do 10 times
If @C,Y is equal to '1'
Move a '1' to @L,Y
End
Add 1 to Y
Enddo
If Customer Level is not blank
Move a 1 to @L,13
End
If ItemLevel is equal to '1'
Move a '1' to @L,14
End
If there are any blank key values in @S between the lowest non-blank level and
the top level,
move a '*' to that key value in @S
*/Build the select statement based on what the above @L array says is in the hierarchy */
Select over the F3400 where
The Requested date is between the BeginDate and EndDate
The Forecast Type is equal to one of the Twelve Forecast Types passed in
*./ Select on Item field */
If @L,14 is not equal to zero
If @S,14 is not equal to zero
Select on Item = @S,14
Else
If AllItems is equal to '1'
Select on Item not equal to zero
Else
Select on Item equal to zero
End
End
Else
Select on Item equal to zero
End
*./ Select on Customer field */
If @L,13 is not equal to zero
If @S,13 is not equal to zero
Select on Customer = @S,13
Else
If AllCustomers is equal to '1'
Select on Customer not equal to zero
Else
Select on Customer equal to zero
End
End
Else
Select on Customer equal to zero
End
*/ Select on Category Code fields */
Move 12 to X
Move 10 to Y
Do 10 times
If @L,X is not equal to zero
If @S,X is not equal to blanks
If @S,X is equal to '*'
Select on Category Code Y not equal to blanks
Else
Select on Category Code Y equal to @S,X
End
Else
Select Category Code Y equal to blanks
End
Else
Select Category Code Y equal to blanks
End
Subtract 1 from X
Subract 1 from Y
End Do
*/ Load Global/ Company level */
If @L,2 is not equal to zero
If @S,2 is not equal to blanks
If @S,2 is equal to '*'
Select on Company not equal to blanks
Else
Select on Company equal to @S,2
End
Else
Select Company equal to '00000'
End
Else
Select Company equal to '00000'
End
3.If GetMoreRecords is not equal to blanks and/or after the above select is done
4.Move '1' to NoMoreRecords
If F3460LastRecord is not NULL
Call RetrieveDetailRecords (see below)
Else
If F34006TableHandle is not NULL
Call RetrieveWorkFileRecords (see below)
End
If NoMoreRecords is equal to '1'
Call RetrieveSummaryRecords (see below)
End
End
5.RetrieveSummaryRecords
If F3400LastRecord is not NULL
Re-fetch the record at the pointer F3400LastRecord and continue fetching records from that point
Else
Begin fetching records from the F3400 selected records
End
*/ Read all of the selected records doing the following for each */
If a record was selected
If FirstPass is ' '
Move '1' to FirstPass
Save the keys in a set of F3400SaveKeys (not including date)
End
If the Key fields are equal to the F3400Save Key fields OR NoMoreRecords is equal to '1'
If Branch is not blank
If SaveChildKey is not equal to SGSFKE
Call RetreiveWorkFileRecords (see below)
End
Else
Call Load Period Buckets (see below)
End
Else
Call Load Data to Output (See Below)
Return to application
End
Else
*/ If there are no more records to select */
If Branch is blank
Call Load Data to Output (see below)
End
Set F3400LastRecord equal to NULL
Return to application
End
6.RetreiveWorkFileRecords
If F34006TableHandle is equal to NULL
Select the records from the F34006 with the Child Key Off the F3400 record just read, the Branch (
if branch is not equal to '*' else select just with the child key)and the Forecast Type equal to
the Type off the F3400
End
Fetch a record from the F34006 selected records and do the following:
If a record was fetched
Move SJSFKY to SaveChildKey
Call RetrieveDetailRecords (see Below)
Else
Release F34006TableHandle
End
7.RetreiveDetailRecords
If F3460LastRecord is equal to NULL
Select on the F3460 with the Item, Branch and Type off the F34006. If Customer is in the
hierarchy
select on the AN8 from the F3400 record
The Requested date is between the BeginDate and EndDate
Fetch the F3460 record
Else
Re-fetch the record at the pointer in F3460LastRecord
End
*/ Read all of the selected records doing the following for each */
If a record is selected
If F3460FirstPass is equal ' '
Move '1' to F3460FirstPass
Move the key fields to the F3460SaveKeys (not including date)
End
If the key fields are equal to the F3460SaveKeys
Call Load Period Buckets (see below)
Else
Call Load Data to Output (see below)
Return to application
End
Else
*/ If there are no more records to select */
Call Load Data to Output (see below)
Set F3460LastRecord equal to NULL
Return to application
End
8.Load Period Buckets
Move ' ' to NoMoreRecords
Look up the Requested Date off the record in the PntrToDates array. Find the first position that is
greater than or equal to the date.
If AmountQuantity is equal to '1'
Add the quantity off the record to the same position of the array of Period fields
Else
Add the amount off the record to the same position of the array of Period fields
End
Add 1 to the count in the PeriodCount array at the same position as the date
Load Data to Output
Move the array of period fields back out to the 54 periods
If any element in the PeriodCount array is greater than 1
Move '1' to MultipleDates
End
Move the saved ForecastType off the record to OutputType
*/ Load the Key Path Value */
If @L,1 is not equal to 0
Move GlobalText to KeyPathValue
Move the KeySegmentor to the next posistion of the KeyPathValue
End
If @L,2 is not equal to 0
Move the saved SGCO to KeyPathValue left justified
Move the KeySegmentor to the next position of the KeyPathValue
End
Move 01 to Y
Move 01 to X
Move the Saved LevelOne - the SavedLevelTen to a 10 big array (@C)
Do 10 times
If X is equal CustomerLevel
If SaveAddressNumber is equal to -99999999
Move BlankValueText to the next position of KeyPathValue
Else
Move the Saved AddressNumber to the next position of
KeyPathValue
End
End
If @L,Y+2 is not equal to 0
If @C,Y is equal to *BLANK
Move BlankValueText to the next position of KeyPathValue
Else
Move @C,Y to the next position of KeyPathValue
End
Add 1 to Y
Move the KeySegmentor to the next position of the KeyPathValue
End
Add 1 to X
EndDo
If @L,14 is not equal to 0
Move the saved Short Item to the next posistion of KeyPathValue
Move the KeySegmentor to the next position of the KeyPathValue
End
If Branch is not blank
Move SaveBranch to the next position of the KeyPathValue
Move '1' to DetailRecord
Move ' ' to PlusMinus
Else
Move '+' to PlusMinus
If this is the bottom level of the hierarchy
Check if this record has any children in the F3460 table
If there are no children
Move ' ' to PlusMinus
End
End
End
*/ Load pointer to return to application */
Move the pointer to the selected F3400 records to F3400TableHandle
If F34006 was read move the pointer to the selected F34006 records to F34006TableHandle
If F3460 was read move the pointer to the selected F3460 records to F3460TableHandle
If the key changing caused return to the application move the pointer of the record just read
(with th
D3400650 - F3400 Get Forecast By Type
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| szSummaryCode | KVER | char | NONE | NONE |
A user defined code (40/KY) that indicates the type of summary forecast. | ||||
| szCompany | CO | char | NONE | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
| szLevelOne | KV01 | char | NONE | NONE |
The first key postion of the forecasting hierarchy. The value in this field relates to the first level chosen in the forecasting constants. | ||||
| szLevelTwo | KV02 | char | NONE | NONE |
The second key postion of the forecasting hierarchy. The value in this field relates to the second level chosen in the forecasting constants. | ||||
| szLevelThree | KV03 | char | NONE | NONE |
The third key postion of the forecasting hierarchy. The value in this field relates to the third level chosen in the forecasting constants. | ||||
| szLevelFour | KV04 | char | NONE | NONE |
The forth key postion of the forecasting hierarchy. The value in this field relates to the fourth level chosen in the forecasting constants. | ||||
| szLevelFive | KV05 | char | NONE | NONE |
The fifth key postion of the forecasting hierarchy. The value in this field relates to the fifth level chosen in the forecasting constants. | ||||
| szLevelSix | KV06 | char | NONE | NONE |
The sixth key postion of the forecasting hierarchy. The value in this field relates to the sixth level chosen in the forecasting constants. | ||||
| szLevelSeven | KV07 | char | NONE | NONE |
The seventh key postion of the forecasting hierarchy. The value in this field relates to the seventh level chosen in the forecasting constants. | ||||
| szLevelEight | KV08 | char | NONE | NONE |
The eighth key postion of the forecasting hierarchy. The value in this field relates to the eighth level chosen in the forecasting constants. | ||||
| szLevelNine | KV09 | char | NONE | NONE |
The ninth key postion of the forecasting hierarchy. The value in this field relates to the ninth level chosen in the forecasting constants. | ||||
| szLevelTen | KV10 | char | NONE | NONE |
The tenth key postion of the forecasting hierarchy. The value in this field relates to the tenth level chosen in the forecasting constants. | ||||
| 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
| ||||
| mnAddressNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
| szBranch | 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
| ||||
| cGlobalLevel | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cCompanyLevel | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cCategory1Level | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cCategory2Level | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cCategory3Level | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cCategory4Level | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cCategory5Level | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cCategory6Level | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cCategory7Level | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cCategory8Level | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cCategory9Level | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cCategory10Level | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cItemLevel | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cCustomerLevel | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| mnLevelOfCustomer | MATH01 | MATH_NUMERIC | NONE | NONE |
- - - Good Performance Low Value. | ||||
| szTypeOne | TYPF | char | NONE | NONE |
A user defined code (34/DF) that indicates one of the following:
o The forecasting method used to calculate the numbers displayed about
| ||||
| szTypeTwo | TYPF2 | char | NONE | NONE |
| szTypeThree | TYPF3 | char | NONE | NONE |
| szTypeFour | TYPF4 | char | NONE | NONE |
| szTypeFive | TYPF5 | char | NONE | NONE |
| szTypeSix | TYPF6 | char | NONE | NONE |
| szTypeSeven | TYPF7 | char | NONE | NONE |
| szTypeEight | TYPF8 | char | NONE | NONE |
| szTypeNine | TYPF9 | char | NONE | NONE |
| szTypeTen | TYPF10 | char | NONE | NONE |
| szTypeEleven | TYPF11 | char | NONE | NONE |
| szTypeTwelve | TYPF12 | char | NONE | NONE |
| jdBeginDate | DRQJ | JDEDATE | NONE | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
| jdEndDate | DRQJ | JDEDATE | NONE | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
| idPtrToDates | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
| cGetMoreRecords | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cAmountQuantity | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cKeySegmentor | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cAllItems | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cAllCustomers | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cDetailRecord | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cNoMoreRecords | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| szPeriod1 | TQ01 | char | NONE | NONE |
Time Series Column 01. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod2 | TQ02 | char | NONE | NONE |
Time Series Column 02. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod3 | TQ03 | char | NONE | NONE |
Time Series Column 03. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod4 | TQ04 | char | NONE | NONE |
Time Series Column 04. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod5 | TQ05 | char | NONE | NONE |
Time Series Column 05. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod6 | TQ06 | char | NONE | NONE |
Time Series Column 06. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod7 | TQ07 | char | NONE | NONE |
Time Series Column 07. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod8 | TQ08 | char | NONE | NONE |
Time Series Column 08. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod9 | TQ09 | char | NONE | NONE |
Time Series Column 09. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod10 | TQ10 | char | NONE | NONE |
Time Series Column 10. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod11 | TQ11 | char | NONE | NONE |
Time Series Column 11. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod12 | TQ12 | char | NONE | NONE |
Time Series Column 12. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod13 | TQ13 | char | NONE | NONE |
Time Series Column 13. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod14 | TQ14 | char | NONE | NONE |
Time Series Column 14. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod15 | TQ15 | char | NONE | NONE |
Time Series Column 15. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod16 | TQ16 | char | NONE | NONE |
Time Series Column 16. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod17 | TQ17 | char | NONE | NONE |
Time Series Column 17. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod18 | TQ18 | char | NONE | NONE |
Time Series Column 18. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod19 | TQ19 | char | NONE | NONE |
Time Series Column 19. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod20 | TQ20 | char | NONE | NONE |
Time Series Column 20. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod21 | TQ21 | char | NONE | NONE |
Time Series Column 21. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod22 | TQ22 | char | NONE | NONE |
Time Series Column 22. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod23 | TQ23 | char | NONE | NONE |
Time Series Column 23. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod24 | TQ24 | char | NONE | NONE |
Time Series Column 24. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod25 | TQ25 | char | NONE | NONE |
Time Series Column 25. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod26 | TQ26 | char | NONE | NONE |
Time Series Column 26. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod27 | TQ27 | char | NONE | NONE |
Time Series Column 27. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod28 | TQ28 | char | NONE | NONE |
Time Series Column 28. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod29 | TQ29 | char | NONE | NONE |
Time Series Column 29. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod30 | TQ30 | char | NONE | NONE |
Time Series Column 30. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod31 | TQ31 | char | NONE | NONE |
Time Series Column 31. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod32 | TQ32 | char | NONE | NONE |
Time Series Column 32. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod33 | TQ33 | char | NONE | NONE |
Time Series Column 33. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod34 | TQ34 | char | NONE | NONE |
Time Series Column 34. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod35 | TQ35 | char | NONE | NONE |
Time Series Column 35. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod36 | TQ36 | char | NONE | NONE |
Time Series Column 36. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod37 | TQ37 | char | NONE | NONE |
Time Series Column 37. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod38 | TQ38 | char | NONE | NONE |
Time Series Column 38. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod39 | TQ39 | char | NONE | NONE |
Time Series Column 39. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod40 | TQ40 | char | NONE | NONE |
Time Series Column 40. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod41 | TQ41 | char | NONE | NONE |
Time Series Column 41. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod42 | TQ42 | char | NONE | NONE |
Time Series Column 42. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod43 | TQ43 | char | NONE | NONE |
Time Series Column 43. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod44 | TQ44 | char | NONE | NONE |
Time Series Column 44. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod45 | TQ45 | char | NONE | NONE |
Time Series Column 45. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod46 | TQ46 | char | NONE | NONE |
Time Series Column 46. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod47 | TQ47 | char | NONE | NONE |
Time Series Column 47. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod48 | TQ48 | char | NONE | NONE |
Time Series Column 48. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod49 | TQ49 | char | NONE | NONE |
Time Series Column 49. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod50 | TQ50 | char | NONE | NONE |
Time Series Column 50. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod51 | TQ51 | char | NONE | NONE |
Time Series Column 51. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod52 | TQ52 | char | NONE | NONE |
Time Series Column 52. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod53 | TQ53 | char | NONE | NONE |
Time Series Column 53. This column will hold Time Series Dates or Quantities. | ||||
| szPeriod54 | TQ54 | char | NONE | NONE |
Time Series Column 54. This column will hold Time Series Dates or Quantities. | ||||
| szKeyPathValue | DS01 | char | NONE | NONE |
A free-form, 80-character text field. | ||||
| szOutputType | TYPF | char | NONE | NONE |
A user defined code (34/DF) that indicates one of the following:
o The forecasting method used to calculate the numbers displayed about
| ||||
| idF3400TableHandle | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
| idF3460TableHandle | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
| idF34006TableHandle | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
| idF3400LastRecord | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
| idF3460LastRecord | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
| szSaveCompany | CO | char | NONE | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
| szSaveLevelOne | KV01 | char | NONE | NONE |
The first key postion of the forecasting hierarchy. The value in this field relates to the first level chosen in the forecasting constants. | ||||
| szSaveLevelTwo | KV02 | char | NONE | NONE |
The second key postion of the forecasting hierarchy. The value in this field relates to the second level chosen in the forecasting constants. | ||||
| szSaveLevelThree | KV03 | char | NONE | NONE |
The third key postion of the forecasting hierarchy. The value in this field relates to the third level chosen in the forecasting constants. | ||||
| szSaveLevelFour | KV04 | char | NONE | NONE |
The forth key postion of the forecasting hierarchy. The value in this field relates to the fourth level chosen in the forecasting constants. | ||||
| szSaveLevelFive | KV05 | char | NONE | NONE |
The fifth key postion of the forecasting hierarchy. The value in this field relates to the fifth level chosen in the forecasting constants. | ||||
| szSaveLevelSix | KV06 | char | NONE | NONE |
The sixth key postion of the forecasting hierarchy. The value in this field relates to the sixth level chosen in the forecasting constants. | ||||
| szSaveLevelSeven | KV07 | char | NONE | NONE |
The seventh key postion of the forecasting hierarchy. The value in this field relates to the seventh level chosen in the forecasting constants. | ||||
| szSaveLevelEight | KV08 | char | NONE | NONE |
The eighth key postion of the forecasting hierarchy. The value in this field relates to the eighth level chosen in the forecasting constants. | ||||
| szSaveLevelNine | KV09 | char | NONE | NONE |
The ninth key postion of the forecasting hierarchy. The value in this field relates to the ninth level chosen in the forecasting constants. | ||||
| szSaveLevelTen | KV10 | char | NONE | NONE |
The tenth key postion of the forecasting hierarchy. The value in this field relates to the tenth level chosen in the forecasting constants. | ||||
| mnSaveShortItem | 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
| ||||
| mnSaveAddressNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
| cPlusMinus | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cMultipleDates | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| cMonthlyVsWeekly | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
| szSaveBranch | 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
| ||||
| szSaveForecastType | TYPF | char | NONE | NONE |
A user defined code (34/DF) that indicates one of the following:
o The forecasting method used to calculate the numbers displayed about
| ||||
| szGlobalText | DSC1 | char | NONE | NONE |
Brief information about an item; a remark or an explanation. | ||||
| szBlankValueText | KV01 | char | NONE | NONE |
The first key postion of the forecasting hierarchy. The value in this field relates to the first level chosen in the forecasting constants. | ||||
| mnSaveChildKey | SFKE | MATH_NUMERIC | NONE | NONE |
Summary Forecast Key | ||||
| mnSaveDetailAddress | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
| szPeriodtotal | TQ55 | char | NONE | NONE |
Time Series Column 55. This column will hold Time Series Dates or Quantities. | ||||
| X4101 Validate and Retrieve Item Master |
| F3400 Forecast Summary File | ||||
| F34006 Forecast Summary Work File | ||||
| F3460 Forecast File |