KanbanCacheProcessWorkCache

Kanban Cache Process - Work Cache

Minor Business Rule

Object Name: B3101820

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

Functional Description
Purpose

Cache Kanban Check In Work Cache function performs the cache handling activity related to
maintaining a work cache that is used by the Kanban Check In Business Functions (Begin Doc, Edit Line, End
Doc). This cache stores one record per job number and is used to pass information between the
business functions that comprise Kanban Check In processing. The parameter Cache Action Code contains
the value that determines what cache operation(s) are to be performed during the specific call.

Processing

• CacheKanbanCheckInWorkCache (LPBHVRCOM lpBhvrCom, LPVOID lpVoid, LPDSD3101820A lpDS)

Declare variables:

HUSER hUser = (HUSER) NULL;
HCACHE       idCacheHandle = (HCACHE) NULL;
int iNumberKeys = 0;
short      nSizeOfDataStructure;
DSD3101820AdsCacheData;
DSD3101820AdsCacheKey;void
void*GenericLPDS;

Save the Suppress Error Message flag.
Save the Action Code.
Save the Number of Keys.

Set the keys for the D3101820A cache.
Get the size of the DSD3101820A.
Call jdeCacheInit

Set nSizeOfDataStructure to the size of the DSD3101820A.
Set iNumberKeys to LpDS->mnNumberKeys;

Call IB3101820_ProcessCacheRequest (lpDS->szCacheActionCode,
  (HUSER) hUser,
  (HCACHE) idCacheHandle,
  &lpDS->idCacheCursor,
  (JDECMINDEXSTRUCT *) Index,
  (void *) lpDS,
  (void *) &dsCacheData,
  (void *) &dsCacheKey,
  (short) iSizeOfDataStructure,
  (int) iNumberKeys,
  (char *) szErrorID);

Restore the Suppress Error Message flag to the Saved Suppress Error Message flag .
Restore the Action Code to the Saved Action Code.
Restore the Number of Keys to the Saved Number of Keys.

Data Structure

D3101820A - Kanban Cache Process - Work Cache

Parameters:
Data Item  Description        I/O   Required  Notes
CACTN         Cache Action Code     I  Yes         '1' - Get '2' - Add '3' - Update '4' -
Delete
                                                               '5' - Delete All '6' - Get Next
                                                               '7' - Add/Update '8' - End Cache
                                                               '9' - Close Cursor
NKEYS         Number of Keys           I  Depends   See Setup Notes and Prerequisites
EV01         Suppress Error Message    I  No         '1' suppresses error messages
DTAI         Error Message ID     O
GENLNG   Cache Cursor              I/O  Depends      Required for Cache Action Code '6'
JOBS         Job Number           I/O  Yes         Index field
VERS         cKanbanVersion           I/O               The version of the Kanban
                                                               Processing Options (P3157) retrieved.
EV01         cKanbanProcessingMode     I/O
MATH01   mnHoursPerDay           I/O
SRST         szClosedWOStatus     I/O
EV01         cExecuteWOProcessing     I/O
EV01         cPerformBlindHrsQtys     I/O
EV01         cPerformBlindIssues     I/O
EV01         cPerformBlindCompletions  I/O
EV01         cPerformBlindInvTransfers I/O
EV01         cCreatePurchaseOrder     I/O
EV01         cAutoBlanketOrderRelease  I/O
EV01         cCreateEDI862           I/O
ROTP         cDefaultRouteType     I/O
NROU         szDefaultRouteCode     I/O
VERS         szVersionRateHeaderMaint  I/O
VERS         szVersionPartAvailability I/O
VERS         szVersionWOEntry     I/O
VERS         szVersionWOProcessing     I/O
VERS         szVersionOpenOrdersInquiryI/O
VERS         szVersionPOEntry     I/O
VERS         szVersionPOPrint     I/O
VERS         szVersionPOReceipts     I/O
VERS         szVersionSuperBackflush   I/O
VERS         szVersionHoursQtys     I/O
VERS         szVersionIssues     I/O
VERS         szVersionCompletions     I/O
VERS         szVersionSOEntry     I/O
VERS         szVersionInvTransfers     I/O
KID1         mnKanbanID           I/O
CDN         mnDepositNumber     I/O
REPT         cSourceType           I/O
KBTM         cTransferMethod     I/O
TRQT         mnOriginalTransactionQty  I/O         The container's original
                                                               transaction qty from the Kanban
                                                               Detail table (KDTRQT)
TRQT         mnEnteredTransactionQty   I/O         The container's original
                                                               transaction qty passed in by the
                                                               application which starts out the
                                                               same as KDTRQT, but the user is
                                                               allowed to override.
TRQT         mnKanbanTransactionQty    I/O         The Kanban's cumulative transaction
qty;
                                                               a sum of all conatiner (F30161)
transaction
                                                               quantities.
DCTO         szRateDocumentType     I/O
DOCO         mnKanbanDocumentNo     I/O
DCTO         szKanbanDocumentType
STKT         cStockingType           I/O         From Item Branch (F4102)
TBM         szBillType           I/O
OPC         cOrderPolicyCode     I/O          From Item Branch (F4102)
EV01         cReadyForCheckIn     I/O               Values are: ' ' = not ready
                                                               '1'= check in container only
                                                               '2' = check in Kanban
EV01         cExecuteInvTransfers     I/O         Values are: ' ' = don't execute
                                                               '1' = execute This flag tells the
                                                               application that inventory transfers
                                                               must be called (non-blind)
EV01         cCloseRate           I/O         Values are: ' ' = Don't close
                                                               '1' = Update status to closed
EV01         cKanbanReceipts     I/O         Values are: ' ' = Don't execute
receipts
                                                               '1' = Execute receipts

^

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

szCacheActionCode CACTN char OPT NONE

A code that indicates the activity you want to perform. Valid codes:     o Get - Retrieve the cache element     o Add - Add a cache element     o
Update - Update a cache element     o Delete - Delete a cache element     o Delete All - Delete all cache elements     o Get Next - Retrieve the
next cache element     o Add/Update - Add a cache element if it does not exist; Update a cache element if it does exist     o Terminate -
Terminate Cache

mnNumberKeys NKEYS MATH_NUMERIC OPT NONE

The number of keys in an index that will be used to retrieve, delete, or update a record.

cSuppressErrorMessage EV01 char OPT NONE

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

szErrorMessageID DTAI char OPT 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.

idCacheCursor GENLNG ID OPT NONE

General purpose ID variable.

mnJobNumber JOBS MATH_NUMERIC OPT NONE

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

szKanbanVersion 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.

cKanbanProcessingMode EV01 char OPT NONE

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

mnHoursPerDay MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

szClosedWOStatus SRST char OPT NONE

A user defined code (00/SS) that describes the status of a work order, rate schedule, or engineering change order. Any status change from
90 through 99  triggers the system to automatically update the completion date.

cCreatePurchaseOrder EV01 char OPT NONE

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

cCreateEDI862 EV01 char OPT NONE

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

cPerformBlindInvTransfers EV01 char OPT NONE

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

cExecuteWOProcessing EV01 char OPT NONE

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

cPerformBlindCompletions EV01 char OPT NONE

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

cPerformBlindHrsQtys EV01 char OPT NONE

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

cPerformBlindIssues EV01 char OPT NONE

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

szVersionRateHeaderMaint 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.

szVersionPartAvailability 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.

szVersionWOEntry 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.

szVersionWOProcessing 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.

szVersionOpenOrdersInquiry 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.

szVersionPOEntry 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.

szVersionPOReceipt 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.

szVersionPOPrint 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.

szVersionSuperBackflush 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.

szVersionHoursQtys 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.

szVersionIssues 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.

szVersionCompletions 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.

szVersionInvTransfers 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.

mnKanbanID 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.

mnDepositNumber CDN MATH_NUMERIC OPT NONE

A number that uniquely defines a Construction Deposit.

cSourceType 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

cTransferMethod 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.

mnOriginalTransactionQty 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).

mnEnteredTransactionQty 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).

mnKanbanTransactionQty 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).

szRateDocumentType DCTO char OPT 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

mnKanbanDocumentNo DOCO MATH_NUMERIC OPT NONE

A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
and so on.

szKanbanDocumentType DCTO char OPT 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

cStockingType STKT char OPT NONE

A user defined code (41/I) that indicates how you stock an item, for example, as finished goods or as raw materials. The following stocking
types are hard-coded and you should not change them:    0   Phantom item    B Bulk floor stock    C Configured item    E Emergency/corrective
maintenance    F Feature    K Kit parent item    N Nonstock The first character of Description 2 in the user defined code table indicates if the item
is purchased (P) or manufactured (M).

cOrderPolicyCode OPC char OPT NONE

A code that specifies the rules for inventory reordering in the Requirements Planning and Procurement systems. Valid values are: 0 Reorder
point (Not planned by MPS/MRP/DRP) 1    Lot-for-lot or as required 2    Fixed order quantity 3 Economic order quantity (EOQ) 4 Periods of
supply 5 Rate scheduled item Note: These values are hard-coded.

cReadyForCheckIn EV01 char OPT NONE

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

cExecuteInvTransfers EV01 char OPT NONE

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

cCloseRate EV01 char OPT NONE

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

cKanbanReceipts EV01 char OPT NONE

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

cExecuteSBFProcess EV01 char OPT NONE

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

cExecutePOReceipts EV01 char OPT NONE

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

cExecutePOPrint EV01 char OPT NONE

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

cExecutePOEntry EV01 char OPT NONE

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

mnP311221BatchNumber ICU MATH_NUMERIC OPT NONE

A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either
assign a batch number or let the system assign it using the Next Numbers program.

mnInvTransBatchNumber ICU MATH_NUMERIC OPT NONE

A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either
assign a batch number or let the system assign it using the Next Numbers program.

cInvTransBatchStatus EV01 char OPT NONE

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

cExecuteWOEntry EV01 char OPT NONE

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

mnF4111BatchNumber ICU MATH_NUMERIC OPT NONE

A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either
assign a batch number or let the system assign it using the Next Numbers program.

mnF4312BatchNumber ICU MATH_NUMERIC OPT NONE

A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either
assign a batch number or let the system assign it using the Next Numbers program.

mnF0911BatchNumber ICU MATH_NUMERIC OPT NONE

A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either
assign a batch number or let the system assign it using the Next Numbers program.

cF4312BatchStatus EV01 char OPT NONE

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

mnWOPOLineNumber 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.

szVersionSOEntry 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.

szBillType TBM char OPT NONE

A user defined code (40/TB) that designates the type of bill of material. You can define different types of bills of material for different uses.
For example:    M     Standard manufacturing bill    RWK   Rework bill    SPR   Spare parts bill The system enters bill type M in the work order
header when you create a work order, unless you specify another bill type. The system reads the bill type code on the work order header to
know which bill of material to use to create the work order parts list. MRP uses the bill type code to identify the bill of material to use when it
attaches MRP messages. Batch bills of material must be type M for shop floor management, product costing, and MRP processing.

szWOPOCompanyKey KCOO char OPT NONE

A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
sales order, and so on). If you use the Next Numbers by Company/Fiscal Year facility, the Automatic Next Numbers program (X0010) uses the
order company to retrieve the correct next number for that company. If two or more order documents have the same order number and order
type, the order company lets you locate the desired document. If you use the regular Next Numbers facility, the order company is not used to
assign a next number. In this case, you probably would not use the order company to locate the document.

szOrderSuffix SFXO char OPT 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
multiple transactions for an original order. For purchase orders, the code is always 000. For sales orders with multiple partial receipts against an
order, the first receiver used to record receipt has a suffix of 000, the next has a suffix of 001, the next 002, and so on.

mnF4311Jobnumber JOBS MATH_NUMERIC OPT NONE

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

mnF0911InvTransBatchNum ICU MATH_NUMERIC OPT NONE

A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either
assign a batch number or let the system assign it using the Next Numbers program.

mnF4211Jobnumber JOBS MATH_NUMERIC OPT NONE

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

mnF4211DocumentOrderInvoice DOCO MATH_NUMERIC OPT NONE

A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
and so on.

szF4211OrderType DCTO char OPT 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

szF4211CompanyKeyOrderNo KCOO char OPT NONE

A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
sales order, and so on). If you use the Next Numbers by Company/Fiscal Year facility, the Automatic Next Numbers program (X0010) uses the
order company to retrieve the correct next number for that company. If two or more order documents have the same order number and order
type, the order company lets you locate the desired document. If you use the regular Next Numbers facility, the order company is not used to
assign a next number. In this case, you probably would not use the order company to locate the document.

cExecuteSalesOrderEntry EV01 char OPT NONE

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

cExecuteShipmentConfirmation EV01 char OPT NONE

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

szShipConfirmVersion 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.

mnShipConfirmJobnumber JOBS MATH_NUMERIC OPT NONE

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

cKanbanReady EV01 char OPT NONE

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

cPerformBlindShipConfirm EV01 char OPT NONE

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

mnProcessID PEID MATH_NUMERIC OPT NONE

A code that identifies the Inter-Process Communication ID.

mnTransactionID TCID MATH_NUMERIC OPT NONE

szReceivingLocation LOCN char OPT NONE

The storage location from which goods will be moved.

cAdHocCardExists EV01 char OPT NONE

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

szVersionItemCompletion 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.

Related Functions

None

Related Tables

None