Edit Line:
Function Name
F3016EditLine
What does it do?
Purpose
This function validates all the data in all the fields in the P3016 Kanban Master Revisions Application. In addition, it also assigns all the default values. If
error free, this function calls the B3003390 Cache Kanban Master Function. This function creates the cache using the job number that was passed from the
F3016 Begin Doc function, and the record is then written into the cache. If the record already exists, it retrieves the existing record and updates it with the
current information
Processing
Initialize variables
Error Indicator
Call F3016 using Kanban ID
If the record exists, set error
If previous Kanban ID is not zero and it is not equal to current Kanban ID,
Call Kanban Master Cache business function.
Set action code equal to "A".
If action code is equal to "A",
Call F3016 using Kanban ID.
If the record exists, set error.
If Action Code is equal to 'D', validate that KANBAN record can be deleted.
If Kanban is in progress (KBST = '2'), set error 0001 on Kanban ID field.
If Action Code is equal to 'C' and Kanban Status = '2', do not allow changes to LINE, AN8, REPT, TLOC, FLOC, MCU, UITM.
Fetch the current existing KANBAN record from the KANBAN master file (F3016). If any of the values are different from those passed to the bsfn, set
error '0001' on KANBAN ID field.
If (no errors exist and (Action Code is equal to 'C' or Action Code is equal to 'A')), validate KANBAN Record.
Validate Branch/Plant (MMCU)
Branch/Plant must exist in the Business Unit Master File (F0006). Call BSFN F0006GetBusinessUnit to perform the validation. If error exists, set error
'0052' on MMCU field and set error indicator.
Branch/Plant must exist in the Manufacturing Constants file (F3009). Fetch F3009 using MMCU (BSFN F3009GetManufacturingConstantsData). If the
reocord does not exist, set error '4431' on MMCU field and set error indicator.
Branch/Plant must exist in the Inventory Constants File (F41001). Fetch F41001 using MMCU (BSFN F41001GetBranchPlantRow). If the record does not
exist, set error '0964' on MMCU and set error indicator.
Validate Item Number (UITM)
If Item number is blank, set error '0003' on the Unknown Item Number field.
Call BSFN VerifyandGetItemMaster passing UITM and MMCU, return LITM and AITM. If the Item Master record does not exist, set error '101U' on
UITM and set error indicator.
If no errors, Validate Item and Branch
Item Branch record must exist in the Item Branch File (F4102). Fetch F4102 using Item (ITM) and Branch/Plant (MMCU) use BSFN
F4102GetItemBranchManufacturingInformation . If the record does not exist, set error '4507' on UITM and set error indicator.
If no errors, Validate Consuming Location (TLOC) and Consuming Branch (MMCU).
If the Consuming Location is not blank and the Consuming branch/plant is blank, set error '0003' on MMCU and set error indicator.
Check that the consuming location is valid by searching for the consuming location in the Item Location File (F41021) using the consuming location and
branch. Retrieve location control field (LCTL) from the Item Location File (F41021). If the consuming location is not found, set error '3690' on TLOC and
set error indicator.
If the Location Control (LCTL) is equal to 'Y', verify that the location exists in F4100. If the location does not exist, set error '3138' on TLOC and set error
indicator.
Validate Supplying Branch/Plant (MCU).
Supplying Branch/Plant must exist in the Business Unit Master File (F0006). If the record does not exist, set error '0052' on MCU and set error indicator.
Supplying Branch/Plant must exist in the Manufacturing Constants file (F3009). Fetch F3009 using MCU. If the reocord does not exist, set error '4431' on
MCU and set error indicator.
If no errors, Validate Supplying Branch (MCU) and Supplying Location (FLOC).
If the Supplying Location is not blank and the Supplying Branch/Plant is blank, set error '0003' on MCU and set error indicator.
Check that the supplying location is valid by searching for the supplying location in the Item Location File (F41021) using the supplying location and
branch. Retrieve the location control field (LCTL) from the Item Location File (F41021). If the supplying location is not found, set error '3690' on FLOC and set
error indicator.
If the Location Control (LCTL) is equal to '1', verify that the location exists in F4100. If the location does not exist set error '3138' on FLOC and set error
indicator.
If this is a new Kanban add then verify that the user is not entering a duplicate Kanban based on ITM, MMCU, LOCN, and TLOC.
Call F3016 using ITM, MMCU, LOCN, TLOC.
If record already exists,
Set NER error '0001' on short item number.
Validate KANBAN ID (KID1)
If action code is equal to 'A' and KANBAN Id is equal to 0 or Null, assign next KANBAN ID using next numbers.
If action code is equal to 'C' and KANBAN Id is equal to 0 or Null, set error '0003' on KID1 and set error indicator.
Perform standard DD edits.
Validate KANBAN Size Quantity (KBQT).
Perform standard DD Edits.
Validate Container Size (CNTS)
Perform standard DD Edits.
Validate KANBAN Size (KBQT) and Container Size (CNTS).
If KANBAN Size and Container Size are equal to 0, set error '0003' on CNTS and set error indicator.
Validate Source Type (REPT).
Retrieve DD Default Value
IF Source Type is equal to blank, set error '057U' on REPT and set error indicator.
Perform standard DD Edits.
Validate Unit of Measure (UOM).
If UOM is equal to blank,
If Source Type (REPT) is equal to '1', default production UOM.
If Source Type (REPT) is equal to '2', default primary UOM (UOM1).
If Source Type (REPT) is equal to '3', default Purchasing UOM
Validate UOM conversion exists. If invalid UOM, set error 'szErrorMessageID' on UOM and set error indicator.
Validate Average Queue Time Hours (AVRT).
If Replenishment leadtime is equal to blank, default to AVRT from F4102.
Perform standard DD Editing.
Validate Phase (KBTM).
Perform standard DD Editing.
Validate Source Type (REPT) and Line/Cell (LINE).
If (source type (REPT) is equal to '2' or '3') and (Line/Cell is not equal to blank), set error '054R' on LINE and set error indicator.
If (source type (REPT) is not equal to '2' or '3') and (Line cell is equal to blank), set error '054R' on LINE and set error indicator.
If Line Cell is not blank, continue validation.
Line/Cell must exist in the Business Unit Master File (F0006). If the record does not exist, set error '0052' on LINE and set error indicator.
Line/Cell must exist in the Manufacturing Constants file (F3009). Fetch F3009 using LINE. If the reocord does not exist, set error '4431' on LINE and set
error indicator.
Line/Cell must exist in the Work Center Master File (F30006). Fetch F30006 using LINE, return production Line (LIC). If the record does not exist, set
error '0964' on LINE and set error indicator.
If F30006 Production Line (LIC) does not equal '1', set error '038N' on LINE and set error indicator.
Validate Replenishment Source Type (REPT) and Supplier (AN8).
If Replenishment Source Type is equal to '1' or '2' and Supplier is not blank, set error '057U' on AN8 and set error indicator.
If Replenishment Source Type is equal to '3' and Supplier is blank, set error '057U' on AN8 and set error indicator.
If supplier is not blank, supplier must exist in the address book file (F0101). If the record does not exist, set error '0002' on AN8 and set error indicator.
Validate Kanban Receipts Flag (KBRC).
Perform standard DD Editing
Validate Kanban Override Flag (KBOV).
Perform standard DD Editing.
Calculate Number of Cards (NCDN).
If Container Size is equal to '0', set Container Size equal to 1.
Number of Cards = Kanban Size (KBQT) / Container Size (CNTS).
Round the Number of Cards to the nearest Whole Number.
If Replenishment Source Type is equal to "4",
Verify Special Handling Code in UDC table using Stocking Type (STKT).
If 1st position of Special Handling Code is not equal to "O",
Set NER error "019T".
If no errors, write transaction to the KANBAN master cache.
^
D3003380B - F3016 Edit Line
Item Description I/O Req Notes
JOBSJob Number IYKEY
LNIDLine Number IO
KID1Kanban Id IOYKEY
MMCUBranch IO
LITM 2nd Item IO
LOCNLocation IO
TLOCTo Location IO
KBQTKanban Qty IO
CNTSContainer Size IO
UMUnit Of Measure IO
AVRTAverage Time IO
KBRCKanban Rec Flg IO
KBOVOverrides Flag IO
MCUBranch / Plant IO
EV01Supp Err Msg I
DTA1Error Msg ID O
REPTRepl Source Typ IO
AN8Supplier IO
KBTMTransfer Method IO
ITMShort Item No I
CDNNumber of Cards I
EV01Action Code IY
AITMThird Item No O
EV01Errors Exist O
LINELine Identifier IO
URCDUser Res Code IO
URDTUser Res Date IO
URATUser Res Amt IO
URABUser Res No IO
URRFUser Res Ref IO
UITMItem No IO
KID1Prev Kanban ID IO
EV01Add Flag 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
| ||||
| 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
| ||||
| 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
| ||||
| 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,
| ||||
| 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
| ||||
| 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
| ||||
| 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
| ||||
| 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
| ||||
| 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. | ||||
| 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
| ||||
| 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
| ||||
| 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.
| ||||
| 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
| ||||
| mnNumberOfCards | CDN | MATH_NUMERIC | OPT | NONE |
A number that uniquely defines a Construction Deposit. | ||||
| cActionCode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| szThirdItemNumber | AITM | char | OPT | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
| cErrorsExist | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| 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. | ||||
| 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. | ||||
| szItemNoUnknownFormat | UITM | char | OPT | NONE |
A number that the system assigns to an item. It can be in short, long, or third item number format. | ||||
| mnPreviousKanbanId | 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. | ||||
| cAddFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| cSuppressEdits | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| 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
| ||||
| cAdhocCardExists_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| None |
| None |