KanbanMasterCache

Cache Process Kanban Master

Master Business Function

Object Name: B3003390

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

Cache Process Kanban Master:

Function Name
KanbanMasterCache

What does it do?

This function is used to create / terminate cache based on the job number, when invoked from the
F3016 Kanban Master Business function (N3003380). In addition, this function also writes / fetches/edits
and deletes records from the cache when called by the N3003380 business function. It performs these
functions based on the value of the parameter cProcessMode.

Processing

Initialize variables
Declare structures
Declare pointers
Check for null pointers

Set error message ID to blanks
Set cache code error to zero

If process mode is not equal to "8"

   If cursor ID is not equal to "0"
   Set cursor equal to data pointer
   Set cursor passed field equal to TRUE
   If cursor ID is equal to "0"
   If process mode is not equal to "6"
   Set cursor opened equal to TRUE
   Set idJCMReturn equal to the value of jdeCacheOpenCursor
   If cursor ID is equal to "0"
   Set cache code error equal to "1"

If cursor is not equal to NULL or process mode is equal to "1" or process mode is equal to "2" or
process mode is equal to "7" or process mode is equal to "8"

Process switch logic

Process mode equal to "1"
Get first element in cursor cache
If return fails
Set cache code error to "6"
Pass control to end of switch statement

Process mode equal to "2"
Add record to cache table
If add to table fails
Set cache code error to "4"
Pass control to end of switch statement

Process mode equal to "5"
Delete record from cache table
Pass control to end of switch statement

Process mode equal to "6"
Get cache for sequential read using matching key
Pass control to end of switch statement

Process mode equal to "7"
Update records
If update operation fails
Set cache code error to "4"
Pass control to end of switch statement

Process mode equal to "8"
End using cache memory
Pass control to end of switch statement

Process mode equal to "9"
Delete records in cache table
Pass control to end of switch statement

If process mode matches none of criteria above
Set cache code error equal to "2"
Pass control to end of switch statement

If cursor is not NULL and process mode is not equal "8" and process mode is not equal to "9" and
return cursor value is not equal to "1"
Perform JDE function CacheCloseCursor

If cache code error is equal to "2" or "3" or "4"
Set error message ID equal to "032E"

If suppress error message is not equal "1"
Perform error message routine

^

Data Structure

D3003390A - Cache Process Kanban Master

Item        Description               I/O       Req              Notes

JOBSJob Number     I  Y
LNIDLine Number     IO
KID1Kanban Id     IO  Y       KEY
MMCUBranch                     IO  Y                  KEY
LITMSecond Item     IO  Y       KEY
LOCNLocation       IO  Y                  KEY
TLOCTo Location     IO  Y       KEY
KBQTKanban Size     IO
CNTSContainer Size     IO
UMUnit of Measure     IO
AVRTAvg Time Hours     IO
KBRCReceipts Flag     IO
KBOVOverrides Flag     IO
MCUBranch / Plant     IO
EV01CprocessMode     I  Y
EV01CacheCodeError     O
EV01SuppressErrMsg     I
DTA1MessageId     O
GENLNGCursor                     O
EV01ReturnCursor     O
REPTSource Type     IO
KBTMTransfer Method     IO
ITMShort Item      IO
AN8Supplier                     IO
EV01Action Code     IY
CDNNumber of Cards     IO
URCDReserved Code     I
URDTReserved Date     I
URATReserved Amt     I
URABReserved No     I
URRFReserved Ref     I
LINELine Identifier     I
AITMThird Item      I

^

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnJobnumberA	JOBS	MATH_NUMERIC	OPT	NONE
The job number (work station ID) which executed the particular job.
mnLineNumber	LNID	MATH_NUMERIC	OPT	NONE
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns this number,but in some cases you can override it.
mnKanbanID1	KID1	MATH_NUMERIC	OPT	NONE
A unique identifier for the first kanban assigned to an item in a specified branch/plant, consuming location, or supplying location.
szCostCenterAlt	MMCU	char	OPT	NONE
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which represent lower-level business units, subordinate to it. For example: o Branch/Plant (MMCU) o Dept A (MCU) o Dept B (MCU) o Job 123 (MCU) Business unit security is based on the higher-level business unit.
szIdentifier2ndItem	LITM	char	OPT	NONE
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to alternative item numbers. The three types of item numbers are: Item Number (short) An 8-digit, computer-assigned item number. 2nd Item Number A 25-digit, user defined, alphanumeric item number. 3rd Item Number Another 25-digit, user defined, alphanumeric item number. In addition to these three basic item numbers, the system provides an extensive cross-reference search capability. You can define numerous cross-references to alternative part numbers. For example, you can define substitute item numbers, replacements, bar codes, customer numbers, or supplier numbers.
szLocation	LOCN	char	OPT	NONE
The storage location from which goods will be moved.
szLocationTo	TLOC	char	OPT	NONE
The storage location to which goods will be moved.
mnKanbansizequantity	KBQT	MATH_NUMERIC	OPT	NONE
The total size of the kanban.
mnContainersizequantity	CNTS	MATH_NUMERIC	OPT	NONE
The capacity of a container in a kanban-controlled environment.
szUnitOfMeasure	UM	char	OPT	NONE
A user defined code (00/UM) that identifies the unit of measurement for an amount or quantity. For example, it can represent a barrel, box, cubic meter, liter, hour, and so on.
mnAverageQueueTimeHours	AVRT	MATH_NUMERIC	OPT	NONE
The time required before a consuming location has a replacement kanban available from its supplying location. This value is used only for kanban card processing in Shop Floor Management.
cKanbanreceiptsflag9	KBRC	char	OPT	NONE
A code that is used to indicate whether the system runs the receipts process at kanban check-in time. Valid values are: 0 The system does not run the receipt process. 1 The system runs the receipt process.
cKanbanoverrideFlag	KBOV	char	OPT	NONE
A code that is used to lock the kanban size and quantity to prevent changes by the kanban calculation program. Valid values are: 0 The system recalculates the size of the kanban. 1 The system does not recalculate the size of the kanban.
szCostCenter	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 might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
cProcessMode	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cCacheCodeError	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cSuppressErrorMessage	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
szErrorMessageId	DTA1	char	OPT	NONE
A 256 byte field used to hold miscellaneous data.
idCursor	GENLNG	ID	OPT	NONE
General purpose ID variable.
cReturnCursor	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cReplenishmentsourcetype	REPT	char	OPT	NONE
A code that indicates the type of supplying location for a kanban. Valid values are: 0 DFM Raw and In Process (RIP) 1 Work center 2 Inventory 3 Supplier 4 Outside Assembly 5 Transfer Order 6 DFM Dual Card
cKanbantransfermethod	KBTM	char	OPT	NONE
A code that indicates the method that the system uses to transfer completed units from the supplying location to the consuming location. Valid values are: 1 One-phase transfer. The completion of the kanban and transfer of inventory are performed simultaneously. 2 Two-phase transfer. The kanban is completed and then the inventory is transferred.
mnSupplier	AN8	MATH_NUMERIC	OPT	NONE
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
mnIdentifierShortItem	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 numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and so forth. The item numbers are as follows: o Item Number (short) - An eight-digit, computer-assigned item number o 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number
cActionCode	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
mnNumberOfCards	CDN	MATH_NUMERIC	OPT	NONE
A number that uniquely defines a Construction Deposit.
szUserReservedCode	URCD	char	OPT	NONE
This is a 2 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future.
jdUserReservedDate	URDT	JDEDATE	OPT	NONE
This is a 6 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future.
mnUserReservedAmount	URAT	MATH_NUMERIC	OPT	NONE
This is a 15 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future.
mnUserReservedNumber	URAB	MATH_NUMERIC	OPT	NONE
This is a 8 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future.
szUserReservedReference	URRF	char	OPT	NONE
A 15-position reference that is reserved for the user. J.D. Edwards does not currently use this field and does not plan to use it in the future.
szLineIdentifier	LINE	char	OPT	NONE
A number that defines a production line or cell. Detailed work center operations can be defined inside the line or cell.
szIdentifier3rdItem	AITM	char	OPT	NONE
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item numbers are as follows: 1. Item Number (short) - An 8-digit, computer-assigned item number. 2. 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number. 3. 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number. In addition to these three basic item numbers, an extensive cross-reference search capability has been provided (see XRT). Numerous cross references to alternate part numbers can be user defined, such as substitute item numbers, replacements, bar codes, customer numbers, or supplier numbers.
mnRelatedKanbanID	KID2	MATH_NUMERIC	OPT	NONE
A unique identifier for the second kanban assigned to an item in a specified branch/plant, consuming location, or supplying location.
szCalculationIdentifier	CALCID	char	OPT	NONE
A value that identifies a unique kanban size calculation method.
mnQtyPerCard	TRQT	MATH_NUMERIC	OPT	NONE
A value that represents the available quantity, which might consist of the on-hand balance minus commitments, reservations, and backorders. You enter this value in the Branch/Plant Constants program (P41001).
cAdhocCardExists	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.

Related Functions

None

Related Tables

F3016 Kanban Master