1.Functional Description
1.1Purpose
This function will read Sales Order History File (F42119) and Sales Order Detail File (F4211), if
required and create Detail Forecast records.
1.2Setup Notes and Prerequisites
1.3Special Logic
2.Technical Specifications
2.4Processing
1.F42119.Select (Depending upon Begin Date, Item Number and Branch)
2.F42119.FetchNext
3.While File_IO_Status = SUCCESS
Inclusion Rules file by chaining to F34004 with keys
F34004.FetchSingle
VersionInclusionRule
DocumentTypeSDDCTO
LineTypeSDLNTY
StatuCodeSDNXTR
If LargeCustomers not equal to blank
Else
F0101.FetchSingle for the sold to (SDAN8) off the record
End
If File_IO_Status = SUCCESS
If ShipTo equals '1'
F0301.FetchSingle (Customer Master table (F0301)) with
SDSHAN
Else
F0301.FetchSingle (Customer Master table (F0301)) with
SDAN8
End
ShortItemNumberShortItemNumber
SecondItemNumberSecondItemNumber
ThirdItemNumberThirdItemNumber
BranchBranch
ForecastTypeForecastType
If AmountQuantity is not equal to '2'
SDPQORQuantity
End
If AmountQuantity is not equal to '1'
SDAEXPAmount
End
If ShipTo equals '1'
Move SDSHANSoldTo
Else
Move SDAN8SoldTo
End
DatePattensDatePatterns
SDDRQJRequestedDate
SummarizeForecastsSummarizeForecasts
RetreiveCatCodesRetrieveCatCodes
SummaryCodeSummaryCode
LinkListPtrLinkListPtr
ProgramIDProgramID
End
ShortItemNumberShortItemNumber
SecondItemNumberSecondItemNumber
ThirdItemNumberThirdItemNumber
BranchBranch
ForecastTypeForecastType
If AmountQuantity is not equal to '2'
SDPQORQuantity
End
If AmountQuantity is not equal to '1'
SDAEXPAmount
End
Move blanks to SoldTo
DatePattensDatePatterns
SDDRQJRequestedDate
SummarizeForecastsSummarizeForecasts
RetreiveCatCodesRetrieveCatCodes
SummaryCodeSummaryCode
LinkListPtrLinkListPtr
ProgramIDProgramID
End
End
F42119.FetchNext
EndWhile
4.If IncludeSalesOrderDetail = '1'
6.F4211.FetchNext
Verify that the combination of the order type, line type and status code exist in
the Inclusion Rules file by chaining to F34004 with keys
VersionInclusionRule
DocumentTypeSDDCTO
LineTypeSDLNTY
StatuCodeSDNXTR
If LargeCustomers not equal to blank
Else
F0101.FetchSingle for the sold to (SDAN8) off the record
End
If File_IO_Status = SUCCESS
If ShipTo equals '1'
F0301.FetchSingle (Customer Master table (F0301)) with
SDSHAN
Else
F0301.FetchSingle (Customer Master table (F0301)) with
SDAN8
End
ShortItemNumberShortItemNumber
SecondItemNumberSecondItemNumber
ThirdItemNumberThirdItemNumber
Branch Branch
ForecastType ForecastType
If AmountQuantity is not equal to '2'
SDPQOR Quantity
End
If AmountQuantity is not equal to '1'
SDAEXP Amount
End
If ShipTo equals '1'
Move SDSHANSoldTo
Else
Move SDAN8SoldTo
End
DatePattens DatePatterns
SDDRQJ RequestedDate
SummarizeForecastsSummarizeForecasts
RetreiveCatCodesRetrieveCatCodes
SummaryCode SummaryCode
LinkListPtr LinkListPtr
ProgramID ProgramID
End
ShortItemNumberShortItemNumber
SecondItemNumberSecondItemNumber
ThirdItemNumberThirdItemNumber
Branch Branch
ForecastType ForecastType
If AmountQuantity is not equal to '2'
SDPQOR Quantity
End
If AmountQuantity is not equal to '1'
SDAEXP Amount
End
Move blanks to SoldTo
DatePattens DatePatterns
SDDRQJ RequestedDate
SummarizeForecastsSummarizeForecasts
RetreiveCatCodesRetrieveCatCodes
SummaryCode SummaryCode
LinkListPtr LinkListPtr
ProgramID ProgramID
End
F4211.FetchNext
EndWhile
End
^
D3401410 - RefreshActualsWithSalesOrder
Data Item Data Structure DescriptionI/ORequiredNotes
ITM ShortItemNumber IR
LITM SecondItemNumber IR
AITM ThirdItemNumber IR
MCU Branch IR
TYPF ForecastType IR
DRQJ BeginDate IR
EV01 LargeCustomers IR
MVER ResourceVersion IR
EV02 SummarizeForecasts IR
EV03 RetrieveCatCodes IR
KVER SummaryCode IR
DRQJ EndDate IR
EV01 MonthlyVsWeekly IR '1' = monthly,
' ' = weekly
GENLNG PointerToDates IR
EV01 ShipTo IR
GENLNG LinkListPtr I/OR
PID ProgramID I
EV01 AmountQuantity IR '1' = quantity,
'2' = amount
' ' = both
EV02 IncludeSalesOrderDetail I '1' = include Sales Order
Detail
' ' = Sales Order History
Only
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
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
| ||||
szSecondItemNumber | LITM | char | OPT | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
szThirdItemNumber | AITM | char | OPT | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
szBranch | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szForecastType | TYPF | char | OPT | NONE |
A user defined code (34/DF) that indicates one of the following:
o The forecasting method used to calculate the numbers displayed about
| ||||
jdBeginDate | DRQJ | JDEDATE | OPT | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
cLargeCustomers | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szResourceVersion | MVER | char | OPT | NONE |
A user defined code (40/RV) that identifies an inclusion rule that you want the system to use for this branch/plant. The Manufacturing and
| ||||
cSummarizeForecast | EV02 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cRetrieveCatCode | EV03 | char | OPT | NONE |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
| ||||
szSummaryCode | KVER | char | OPT | NONE |
A user defined code (40/KY) that indicates the type of summary forecast. | ||||
cMonthlyVsWeekly | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
jdEndDate | DRQJ | JDEDATE | OPT | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
idPointerToDates | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
szProgramID | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
cShipTo | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cAmountQuantity | EV02 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
idLinkListPtr | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
cIncludeCurrentSales | EV03 | char | OPT | NONE |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
| ||||
cBeforeImageProcessing | BIPROC | char | OPT | NONE |
This flag controls image processing in interoperability transactions. | ||||
szTypeTransaction | TYTN | char | OPT | NONE |
The qualifier used to identify a specific type of transaction. |
None |
None |