RelieveSOBlanketOrderQty

Relieve SO Blanket Order Qty

Major Business Rule

Object Name: B4200490

Parent DLL: CDIST

Location: Client/Server

Language: C

Functional Description

Purpose
Retrieve the original blanket order and update the quantity shipped to date (QTYT) amount.  Adjust
the availability quantities in the Item Location file (F41021).

Setup Notes and Prerequisites
• This function must be preceded with the function GetUDC - X0005.C.  If the blanket order flag does
not contain '1' upon return, this function.

Special Logic
None.

Technical Specification

2.2Related Tables
Table Table Description
F4211Sales Order Detail

2.3Related Business Functions
Source NameFunction Name
B9800100GetAuditInformation
X0005Get UDC
B4000260GetLineTypeConstants
B4000520GetItemUoMConversionFactor
B4200370CommitSalesOrderToInventory
B4200260WriteSalesLedgerOrHistory
B4200210VerifyandGetSalesDetail

2.4Processing

1. Call VerifyandGetSalesDetail (B4200210.C) to retrieve Sales Order Detail record (F4211) pointer:
ParameterI/OParm Values
Order NumberIOORNKey field(from main parm)
Order TypeIOCTOKey field(from main parm)
Key CompanyIOKCOKey field(from main parm)
Line NumberIOGNOKey field(from main parm)
Call TypeI'2'
Error MessageI(optional)
Suppress Error MessageI(optional)
Return CodeI(optional)
F4211 PointerO

2. Call VerifyActivityRuleStatusCode (B4000260.C) and retrieve the Ledger Record (Y/N) (WRTH)
ParameterI/OParm Values
Order TypeISDDCTO
Line TypeISDLNID
Line Status CodeISDNXTR
Suppress Error MsgIIf a value of '1' is passed and a record is not found, do
not call JdeSetGBRError but set the error code to '1'
Next StatusONot use
Status Allowed 1ONot Use
Status Allowed 2ONot Use
Status Allowed 3ONot Use
Status Allowed 4ONot Use
Status Allowed 5ONot Use
Next NumberO
Ledger Record Y/NOWRTH
Error CodeO'1' if error condition.  '0' if no errors

3. Call GetLineTypConstants (B4000260.C) and retrieve the Inventory Interface flag (IVI)
ParameterI/OParm Values
Line TypeISDLNTY
Line Type DescO
Line Type Desc2O
Line G/L InterfaceO
Inventory InterfaceOIVI
The other parameters are not required as this function is used to only return the line type.

4. Retrieve UOM conversion factors by calling GetItemUoMConversionFactor (B4000520.C)
ParameterI/OParm Values
Branch PlantISDMCU
From Unit of MeasureISDUOM
To Unit of MeasureISDUOM1
Quantity to ConvertI/O-
Inventory Interface Flag I IVI (from item # 3.)
Item Number (Short)ISDITM
Conv Factor Frm/ToOCONV
The other parameters are not required as this function is used to only return the conversion factor.

5. Call CommitSalesOrderToInventory (B4200370.C) to update the inventory commitment
ParameterI/OParm Values
Item NumberISDITM
Branch/PlantISDMCU
LocationISDLOCN
Lot NumberISDLOTN
Shipping QtyISDSOQS
Backorder QtyISDSOBK
TransToPrimConvFactorICONV (from item # 4)
Commitment Flag ISDCOMM
Other quantity 1 or 2ISDOTQY
Future commitI'1' (If SDSONE > 0)
Reverse CommitI'1' (reverse commit)
Program IDIPID (From main parm)

6. Add transaction quantity (UORG) to Quantity Shipped to Date (QTYT)

7. IF Quantity Shipped to Date (QTYT) >= original Ordered Quantity (UORG)
Move NXTR (parm) to next status (NXTR)
   END

8. IF User ID (USER), Workstation ID (JOBN), Date Updated (UPMJ) or Time of Day (TDAY) = blanks,
Use GetAuditInformation (B9800100.C)  to retrieve Audit stamp information
   END

9. IF update Ledger Record flag (WRTH) is set to 'Y',
Write Sales Ledger record F42199) using WriteSalesLedgerOrHistory (B4200260.C)
   END

10.Update Sales Order Detail file (F4211)

Data Structure

D4200490 - Relieve SO Blanket Order Qty

Special Input Expected
OKCOOriginal Order Document Company
OORNOriginal Order Number
OCTOOriginal Document Type
OGNOOriginal Line Number
UORGTransaction Quantity (released)
NXTRDefault for cancel statusDefault is '999
USERUser Name
PIDProgram ID
JOBNWorkstation ID
UPMJDate Updated
TDAYTime Of Day

^

Parameter Name Data Item Data Type Req/Opt I/O/Both

szOriginalOrderDocCo OKCO char NONE NONE

A number that is used in conjunction with the values in the ODOC and ODCT fields to identify a transaction.

szOriginalOrderNo OORN char NONE NONE

The original document number. This can be a voucher, an invoice, unapplied cash, a journal entry number, and so on Matching document
numbers are also used to identify related documents in the Accounts Receivable and Accounts Payable systems. The document number
(DOC) is always the original document number. The matching document number (DOCM) is the check, adjustment, or credit to be applied
against the original document.

szOriginalOrderType OCTO char NONE NONE

This code defines the order type. It is verified in user defined codes (40/OT). Reserved document types have been defined for voucher
entry, invoice entry, receipts entry, and time sheet entry.  Because the offsetting entries for document types are created automatically during the
post program, they will not be self-balancing on original entry. The reserved document types are:    PR Purchase Requisition Orders    PQ
Purchase Quote    PO Purchase Order    PD Purchase Order - Direct Ship    PB Purchase Order - Blanket    SQ Sales Quote    SO Sales Order
SD Sales Order - Direct Ship    SB Sales Order - Blanket

mnOriginalOrderLineNo OGNO MATH_NUMERIC NONE NONE

A number identifying which line on the original order that the current line matches.

mnNewTransactionQty UORG MATH_NUMERIC NONE NONE

^

szDfltStatusForCancel NXTR char NONE NONE

ab ab
Special Input Expected
NXTRab Default for cancel status

Significant Data Values
Default is '999
^

szUserID USER char NONE NONE

The code that identifies a user profile.

szProgramID PID char NONE NONE

The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.

szWorkstationID JOBN char NONE NONE

Special Input Expected
JOBNab Workstation ID

^

jdDateUpdated UPMJ JDEDATE NONE NONE

The date that specifies the last update to the file record.

mnTimeOfDay TDAY MATH_NUMERIC NONE NONE

The computer clock in hours:minutes:seconds.

szStandardUOMConvFlag TFLA char NONE NONE

Allows you to bypass the item-specific unit of measure and use the standard unit of measure. Valid values are:    blank Use the item-specific
unit of measure    1       Bypass the item-specific unit of measure and use the standard unit of measure

mnPreviousTransactionQty UORG MATH_NUMERIC NONE NONE

Special Input Expected
UORGab Transaction Quantity (released)

^

szNewTransactionUom UOM char NONE NONE

A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box).

szPreviousTransactionUom UOM char NONE NONE

A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box).

cMode EV01 char NONE NONE

An option that specifies the type of processing for an event.

szEdiBatchNumber EDBT char OPT NONE

The number that the transmitter assigns to the batch.  During batch processing, the system assigns a new batch number to the PeopleSoft
transactions for each control (user) batch number it finds.

szEdiTransactNumber EDTN char OPT NONE

The number that an Electronic Data Interchange (EDI) transmitter assigns to a transaction. In a non-EDI environment, you can assign any
number that is meaningful to you to identify a transaction within a batch. It can be the same as a J.D. Edwards document number.

mnEdiLineNumber EDLN MATH_NUMERIC OPT NONE

This is the line number you assign when originating an EDI transaction. This number can represent an order line number (applicable for any
order type), an invoice pay item, a journal entry line number, and so on.

szTypeTransaction TYTN char OPT NONE

The qualifier used to identify a specific type of transaction.

szTransactionAction TNAC char OPT NONE

A code that indicates the activity you want to perform on the transaction. In an EDI transaction, this code represents the Transaction Set
Purpose Code or Change Code.

szP4210Version VERS char OPT NONE

A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined
processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a
menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.

cWriteZFileRecords EV02 char OPT NONE

An option that specifies the type of processing for an event.

mnJobnumber JOBS MATH_NUMERIC OPT NONE

The job number (work station ID) which executed the particular job.

Related Functions

B4000260 Line Type - Activity Rules

B4000520 Get Item UoM Conversion Factor

B4200210 Get F4211 Detail Information

B4200260 Write Sales History Or Ledger

B4200370 Commit Sales Order To Inventory

B9800100 Get Audit Information

Related Tables

F4211 Sales Order Detail File

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szOriginalOrderDocCo	OKCO	char	NONE	NONE
A number that is used in conjunction with the values in the ODOC and ODCT fields to identify a transaction.
szOriginalOrderNo	OORN	char	NONE	NONE
The original document number. This can be a voucher, an invoice, unapplied cash, a journal entry number, and so on Matching document numbers are also used to identify related documents in the Accounts Receivable and Accounts Payable systems. The document number (DOC) is always the original document number. The matching document number (DOCM) is the check, adjustment, or credit to be applied against the original document.
szOriginalOrderType	OCTO	char	NONE	NONE
This code defines the order type. It is verified in user defined codes (40/OT). Reserved document types have been defined for voucher entry, invoice entry, receipts entry, and time sheet entry. Because the offsetting entries for document types are created automatically during the post program, they will not be self-balancing on original entry. The reserved document types are: PR Purchase Requisition Orders PQ Purchase Quote PO Purchase Order PD Purchase Order - Direct Ship PB Purchase Order - Blanket SQ Sales Quote SO Sales Order SD Sales Order - Direct Ship SB Sales Order - Blanket
mnOriginalOrderLineNo	OGNO	MATH_NUMERIC	NONE	NONE
A number identifying which line on the original order that the current line matches.
mnNewTransactionQty	UORG	MATH_NUMERIC	NONE	NONE
^
szDfltStatusForCancel	NXTR	char	NONE	NONE
ab ab Special Input Expected NXTRab Default for cancel status Significant Data Values Default is '999 ^
szUserID	USER	char	NONE	NONE
The code that identifies a user profile.
szProgramID	PID	char	NONE	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
szWorkstationID	JOBN	char	NONE	NONE
Special Input Expected JOBNab Workstation ID ^
jdDateUpdated	UPMJ	JDEDATE	NONE	NONE
The date that specifies the last update to the file record.
mnTimeOfDay	TDAY	MATH_NUMERIC	NONE	NONE
The computer clock in hours:minutes:seconds.
szStandardUOMConvFlag	TFLA	char	NONE	NONE
Allows you to bypass the item-specific unit of measure and use the standard unit of measure. Valid values are: blank Use the item-specific unit of measure 1 Bypass the item-specific unit of measure and use the standard unit of measure
mnPreviousTransactionQty	UORG	MATH_NUMERIC	NONE	NONE
Special Input Expected UORGab Transaction Quantity (released) ^
szNewTransactionUom	UOM	char	NONE	NONE
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box).
szPreviousTransactionUom	UOM	char	NONE	NONE
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box).
cMode	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szEdiBatchNumber	EDBT	char	OPT	NONE
The number that the transmitter assigns to the batch. During batch processing, the system assigns a new batch number to the PeopleSoft transactions for each control (user) batch number it finds.
szEdiTransactNumber	EDTN	char	OPT	NONE
The number that an Electronic Data Interchange (EDI) transmitter assigns to a transaction. In a non-EDI environment, you can assign any number that is meaningful to you to identify a transaction within a batch. It can be the same as a J.D. Edwards document number.
mnEdiLineNumber	EDLN	MATH_NUMERIC	OPT	NONE
This is the line number you assign when originating an EDI transaction. This number can represent an order line number (applicable for any order type), an invoice pay item, a journal entry line number, and so on.
szTypeTransaction	TYTN	char	OPT	NONE
The qualifier used to identify a specific type of transaction.
szTransactionAction	TNAC	char	OPT	NONE
A code that indicates the activity you want to perform on the transaction. In an EDI transaction, this code represents the Transaction Set Purpose Code or Change Code.
szP4210Version	VERS	char	OPT	NONE
A user-defined set of specifications that control how applications and reports run. You use versions to group and save a set of user-defined processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version.
cWriteZFileRecords	EV02	char	OPT	NONE
An option that specifies the type of processing for an event.
mnJobnumber	JOBS	MATH_NUMERIC	OPT	NONE
The job number (work station ID) which executed the particular job.

B4000260 Line Type - Activity Rules
B4000520 Get Item UoM Conversion Factor
B4200210 Get F4211 Detail Information
B4200260 Write Sales History Or Ledger
B4200370 Commit Sales Order To Inventory
B9800100 Get Audit Information