1.Functional Description
1.1Purpose
This function will read the Kanban Master table (F3016) by the specified keys and verify if any
record exists in the table. If any record is found, data will be returned from the table.
1.2Setup Notes and Prerequisites
List of indexes:
2 = DOCO, DCTO
Keys : number of keys in the index that should be used to retrieve row.
None
2.Technical Specifications
2.4Processing
Open the F3016 table.
If open table is successful
Perform a select based on the input index.
Fetch the matching record.
If any record is found
ERRC = 1
Else
ERRC = 0
End if
Else
ERRC = 2
End if
Close F3016
D3003470 - F3016 Get Kanban Master
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
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. | ||||
cKanbanStatus | KBST | char | OPT | NONE |
Indicates the current status of a kanban. Valid values are:
1 or In
The kanban is ready for use at the consuming location.
2 or Out
The
| ||||
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
| ||||
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
| ||||
szIdentifier3rdItem | AITM | char | OPT | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
mnOrderNumber | 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,
| ||||
szOrderType | 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
| ||||
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
| ||||
szLocation | LOCN | char | OPT | NONE |
The storage location from which goods will be moved. | ||||
szBusinessUnit | 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
| ||||
szLocationTo | TLOC | char | OPT | NONE |
The storage location to which goods will be moved. | ||||
szBranch | 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
| ||||
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
| ||||
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
| ||||
mnKanbansizeQuantity | KBQT | MATH_NUMERIC | OPT | NONE |
The total size of the kanban. | ||||
szUnitOfMeasureAsInput | UOM | char | OPT | 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). | ||||
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,
| ||||
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.
| ||||
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
| ||||
mnAddressNumber | 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
| ||||
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. | ||||
cKanbanReceiptsFlag | 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
| ||||
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. | ||||
mnTransactionQuantity | TRQT | MATH_NUMERIC | OPT | NONE |
A value that represents the available quantity, which might consist of the on-hand balance minus commitments, reservations, and
| ||||
nIndex | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due. | ||||
nKeys | INT02 | integer | OPT | NONE |
Number of Days in the Past to Query for Quote Requests Received. | ||||
cSuppressErrorMessage | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cErrorCode | ERRC | char | OPT | NONE |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
| ||||
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
|
None |
None |