K_PRODLTM - Product Lead Time Transactions

Apr 22, 2024

File Name . . . . K_PRODLTM
   Library . . . .   K3S_5DTA
 Format Descr. . . Product lead time trans
 Format Name . . . RK_PRODLTM
 File Type . . . . PF            Unique Keys-  N

 Field Name FMT Start Lngth Dec Key Field Description
 PL_COMP     A      1     1         Company ID
 PL_LOCN     A      2     5         Location ID
 PL_SUPL     A      7    10         Supplier ID
 PL_SUPLSUB  A     17    10         Sub supplier ID
 PL_SUPLUSR  A     27    10         Supplier user system
 PL_SUPLUSB  A     37    10         Supplier user sub
 PL_PROD     A     47    25         Product ID
 PL_BIRTH    L     72    10         Product LT trans birth
 PL_LASTUPD  L     82    10         Product LT trans last
 PL_ORDDATE  L     92    10         Product order date
 PL_ORDRECV  L    102    10         Product receive date
 PL_QTYRECV  P    112     7   0     Quantity received
 PL_QTYORDR  P    116     7   0     Quantity ordered
 PL_PO#      A    120    10         PO number
 PL_USEFLAG  P    130     1   0     Transaction used flag
 PL_SKIPLT   P    131     1   0     Skip LT forecast flag

 PL_USEFLAG Status Legend
 0 = Not Processed
 1 = Processed Successfully
 2 = Lead Time Turned Off
 3 = Skip LT Forecasting
 4 = Loc/Supl/Product Not On File
 5 = Invalid Transaction
 6 = Daily Hold Out Processing
 7 = PO Line Cancelled


When creating records for cancellations, set PL_USEFLAG = 7, PL_SKIPLT = 1, PL_QTYORDR = ordered qty,
PL_QTYRECV = 0, PL_ORDRECV = PL_ORDDATE.


If entire PO is cancelled, send a K_PRODLTM cancelled record for each item on the PO.
The night process will automatically set the PO status to cancelled in the K_INTORDL record. 

---