Functional Description
Purpose
The purpose of this business function is to perform Sales Order margin Check Processing. The
business function will perform line or order level checking based on the parameter htat is passed to it. The
function will retrieve the Hold Order Constants F42008 by Hold Code and Branch Plant, compre the
upper and lower limits based on amount or percent code and write a record to Hold Order File F4209 if the
order should be placed on hold. The function returns a code to identify if hte order has been placed
on hold or not.
Setup Notes and Prerequisites
The price and the cost columns must be passed in primary uom.
Special Logic
If Hold Code Constans F42008 is not found, return to calling application without setting any error
condition.
Technical Specification
2.2Related Tables
Table Table Description
F42008Hold Code Constants.
F4209Held Order Details.
2.3Related Business Functions
Source NameFunction Name
B4001100.CWrite Hold Code (F4209).
B4001110.CGet Hold Code Information (F42008).
2.4Processing
Fetch Hold Code Constants by Hold Code HCOD and Branch/Plant MCU. Use business function
B4001110 Get Hold Code Information.
If record not found return to calling application with Order is on Hold EV01 equal to '0'.
If record found get: Limit Type HCLTYP, Responsible Person HCRPER, Lower Limit HCLLC and Upper
Limit HCULC.
Calculate net amount by subtracting cost from price.
Net Amount = UPRC - UNCS
If Limit Type HCLTYP (from F42008) is equal to '%', calculate margin percent by dividing net amount
by price. Multiply the result by 100.
Margin % = Net Amount UPRC * 100
If Net Amount or Margin % is less than Lower Limit HCLLC (from F42008) or greater than Upper Limit
HCULC (from F42008):
Write Held Order Row in F4209 using B4001100 Write Hold Code.
Pass the following data items to B4300080:
MCU - Branch/Plant
HCOD - Hold Code
AN8 - Customer Number
TRDJ - Transaction / Order Date
DRQJ - Requested Date
PDDJ - Promised Date
SFXO - Order Suffix
DCTO - Order Type
DOCO - Order Number
KCOO - Order Key Company
LNID - Order Line Number
CTYP - Hold Code Type
RPER - Responsible Person (from HCRPER - F42008)
ITM - Short Item Number
LITM - Long Item Number
AITM - Third Item Number
^
D4200290 - Margin Check Processing
Special Input Expected
CTYP Hold Code TypeHold Code Type: L=Line; O=Order.
HCODHold CodeHold Code.
AN8Customer NumberCustomer Number.
MCUBranch/PlantBranch / Plant.
DOCOOrder NumberOrder Number.
DCTOOrder TypeOrder Type.
KCOOOrder Key CompanyOrder Key Company.
SFXOOrder SuffixOrder Suffix - Always 000.
LNIDOrder Line NumberOrder Line Number for Hold Code Type 'L'.
TRDJTransaction/Order DateTransaction / Order Date.
DRQJRequested DateRequested Date.
PDDJPromised DatePromised Date.
ITMShort Item NumberShort Item Number for Hold Code Type 'L'.
LITMLong Item NumberLong Item Number for Hold Code Type 'L'.
AITMThird Item Number3rd Item Number for Hold Code Type 'L'.
UNCSCost - Primary UMUnit Cost or Extended Cost in Primary Unit of Measure.
UPRCPrice - Primary UMUnit Price or Extended Cost in Primary Unit of Measure.
Special Output Returned
EV01Order is on Hold 0/1A returned flag that identifies if the order has been put on hold -1 or
0 if it passed the margin check.
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szHoldCodeType | CTYP | char | NONE | NONE |
A code that determines whether the hold code applies to an individual line within an order (L) or the order as a whole (O). For credit holds,
| ||||
szHoldCode | HCOD | char | NONE | NONE |
A user defined code (42/HC) that identifies why an order was placed on hold (for example, credit, budget, or margin standards were
| ||||
mnCustomerNumber | 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
| ||||
szBranchPlant | 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
| ||||
mnOrderNumber | DOCO | MATH_NUMERIC | NONE | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
szOrderType | DCTO | char | NONE | NONE |
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
| ||||
szOrderKeyCompany | KCOO | char | NONE | NONE |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
szOrderSuffix | SFXO | char | NONE | NONE |
In the A/R and A/P systems, a code that corresponds to the pay item. In the Sales Order and Procurement systems, this code identifies
| ||||
mnOrderLineNumber | LNID | MATH_NUMERIC | NONE | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
jdTransactionDate | TRDJ | JDEDATE | NONE | NONE |
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing. | ||||
jdRequestedDate | DRQJ | JDEDATE | NONE | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
jdPromisedDelDate | PDDJ | JDEDATE | NONE | NONE |
The promised shipment date for either a sales order or purchase order. The Supply and Demand Programs use this date to calculate
| ||||
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
| ||||
sz2ndItemNumber | LITM | char | NONE | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
sz3rdItemNumber | AITM | char | NONE | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
mnCostInPrimaryUOM | UNCS | MATH_NUMERIC | NONE | NONE |
The amount per unit, derived by dividing the total cost by the unit quantity. | ||||
mnPriceInPrimaryUOM | UPRC | MATH_NUMERIC | NONE | NONE |
The list or base price to be charged for one unit of this item. In sales order entry, all prices must be set up in the Item Base Price File table
| ||||
cOrderOnHoldFlag | EV01 | char | NONE | NONE |
Special Output Returned
| ||||
cErrorCode | ERRC | char | NONE | NONE |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
| ||||
cSuppressErrorMsg | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
szErrorMsgID | 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
| ||||
cSuppressWriteToTable | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. |
B4001100 Write Hold Code | ||||
B4001110 Get Hold Code Information |
F42008 Order Hold Constants | ||||
F4209 Held Orders |