DeleteSupplyDemandInclusionRule

Minor Business Rule

Object Name: B3400120

Parent DLL: CMFG

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
This business function will validate that the Supply and Demand Inclusion rules table (F34004)
contains a row for a given Version , Document type, Line type and Transaction Type. This function will
return a code '1'in the selection field, if the row is found and '1' if the row is not found.

1.2Setup Notes and Prerequisites

• This function keeps the F34004 table open so that multiple fetches can occur. It is important to
call the BSFN in Mode One first, then Mode two can be used as many times as necessary, and finally, call
the function in Mode Three to close the F34004 table and release any allocated memory.

1.3Special Logic.
None.

2.Technical Specifications
1.0   Refresh pointer to F34004 data area if DS Pointer To Structure is not null

2.0   If DS Mode = '1'
            2.01    Open F34004 Table
            2.02    Store F34004 data pointer in DS Pointer To Structure

3.0   If DS Mode = '2' and Table open did not fail
            3.01     Right Justify TRTY into the Key field for F34004 Table

            3.02     Fetch from F34004 table using -
                               DS MVER    Resource Version
                               DS TRTY     Trans Type
                               DS LNTY     Line Type
                               DS DCTO     Order

            3.03     If Fetch passed
                               assign '1' to the DS Selected field
                     else
                               return value  = ER_WARNING

4.0   If DS Mode = '3'

4.1 Close table, free data pointers
^

Data Structure

D3400120 - Delete Supply Demand Inclusion Rule

Data Item Data Structure DescriptionI/ORequiredNotes
  VERS             Version                  IY
  DCT                  Order Type                  IY
  LNTY             Line Type                  IY
  TRTY                  Status Code              IY
  SL01            Selection 001              O      '0' if  successful. '1' if
not
                                             sucessful

^

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szResourceversion	MVER	char	NONE	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 Warehouse Management systems use inclusion rules as follows: o For Manufacturing: Allows multiple versions of resource rules for running MPS, MRP, or DRP. o For Warehouse Management: Allows multiple versions of inclusion rules for running putaway and picking. The system processes only those order lines that match the inclusion rule for a specified branch/plant.
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 reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and should not be changed: P Accounts Payable documents R Accounts Receivable documents T Payroll documents I Inventory documents O Purchase Order Processing documents J General Accounting/Joint Interest Billing documents S Sales Order Processing documents
szLinetype	LNTY	char	NONE	NONE
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as General Ledger, Job Cost, Accounts Payable, Accounts Receivable, and Inventory Management. It also specifies the conditions under which a line prints on reports, and it is included in calculations. Codes include the following: S Stock item J Job cost N Nonstock item F Freight T Text information M Miscellaneous charges and credits W Work order
szTransType	TRTY	char	NONE	NONE
A user defined code (40/AT) that indicates the status of the line.
cSuppressErrorMessage	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szErrorMessageID	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 special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
cSelected	EV02	char	NONE	NONE
An option that specifies the type of processing for an event.

Related Functions

None

Related Tables

None