This document is to guide user how R43900 (Supplier/Item Relationships Rebuild) handles data from F43121 (Purchase Order Receiver File) and F4311 (Purchase Order Detail File).
This document is created based on EnterpriseOne application release 9.1.
Table of Contents:
R43900 is running based on F43121 to insert/update computed values into F43090.
Table F43090 (Supplier/Item Relationships)
Below table is to show how Supplier Analysis routine modifies data from F43090
| Table | S | Alias | DD Item (Description) | Description | P43090 | Computation (R43900) | |
|---|---|---|---|---|---|---|---|
| F43090 | 1 | AN8* | AddressNumber (Address Number) | Primary Key |
8 | Yes | |
| F43090 | 2 | ITM* | IdentifierShortItem (Item Number - Short) | Primay Key | 8 | Yes | |
| F43090 | 3 | LITM | Identifier2ndItem (2nd Item Number) | 25 | Yes | ||
| F43090 | 4 | AITM | Identifier3rdItem (3rd Item Number) | 25 | Yes | ||
| F43090 | 5 | MCU* | CostCenter (Business Unit) | Primary Key | 12 | Yes | This key is not to be mapped for non-stock item |
| F43090 | 6 | CEFJ | DateEffectiveJulian (Date - Effective (Julian)) | 6 | Yes | Update: If the value is not specified, the CEFJ and CXPJ is to be set based on CENTCHG value ** RV CEFJ-Effective Date(wf) |
|
| F43090 | 7 | CXPJ | DateExpirJulian (Date - Expiration (Julian)) | 6 | Yes | Update: ** RV CXPJ-Expiration Date(wf) |
|
| F43090 | 8 | CERS | CertifiedStatus (Status - Certification) | A code that indicates whether the supplier is certified to sell this item. The code that you enter determines how the system manages orders that you enter for the supplier and item. Valid values are: Please see UDC 43/CR Special handling codes are: 1 The system prohibits you from purchasing this item from the supplier. 2 The system displays a warning message if you enter an order for the item from the supplier. Blank You can place orders for the item from the supplier. |
2 | Yes | No update |
| F43090 | 9 | NROU | NormalRouteCode (Route - Normal Route Code) | A user defined code (43/RC) that identifies a receipt route. Each receipt route consists of a series of operations through which the system directs items upon receipt. | 4 | Yes | Update it based on Processing Option ** RV NROU-NormalRouteCode(wf) |
| F43090 | 10 | TROU | TestRouteCode (Route - Alternate Route Code) | A user defined code (43/RC) that identifies an alternate receipt route. Each receipt route consists of a series of operations through which the system directs items upon receipt. An item can have a normal receipt route and an alternate receipt route. The system directs an item through the alternate receipt route intermittently based on the number of days or number of receipts that you specify. |
4 | Yes | No update |
| F43090 | 11 | TFRQ | TestingFrequency (Frequency - Number) | A number that determines how often the system directs an item to the alternate receipt route, based on receipts. For example, if you enter 5 in this field, the system directs every fifth receipt of the item to the alternate receipt route. | 5 | Yes | No update |
| F43090 | 12 | ORDS | NumberOfReceipts (Units - Receipts Since Last Test ) | This field determines the number of purchase order receipts that have occurred for a supplier since the last test has been performed. This field is associated with the Testing Frequency field. | 15 | Mechanical computation for the number of MATC based on primary key mapped | |
| F43090 | 13 | TFRD | TestingFrequencyDays (Days - Frequency) | A number that determines how often the system directs an item to the alternate receipt route, based on days. For example, you enter 3 in this field. If 01/01/98 was the last date for the alternate receipt route, the system directs the next receipt performed on or after 01/04/98 to the alternate receipt route. | 5 | Yes | No update |
| F43090 | 14 | LTDJ | DateLastTest (Date - Last Alternate Route (Julian)) | Indicates the date that the alternate route was last performed. This field is associated with the Testing Frequency Days field. | 6 | No Update | |
| F43090 | 15 | DAYE | DaysAllowedEarly (Days - Allowed Early) | The number of days prior to the promised date for which delivery of the item is acceptable. For example, you enter 2 to indicate that the supplier can deliver the item a maximum of 2 days early to qualify for an on-time delivery. | 5 | Yes | No update. Input value for computation |
| F43090 | 16 | DAYL | DaysAllowedLate (Days - Allowed Late) | The number of days after the promised date for which delivery of the item is acceptable. For example, you enter 2 to indicate that the supplier can deliver the item a maximum of 2 days later than the promised date to qualify for an on-time delivery. | 5 | Yes | No update. Input value for computation |
| F43090 | 17 | LTQP | PercentLeadtimeQuan (Percentage - Leadtime Quantity) | The percentage of an order that you must receive for the system to calculate leadtime. Leadtime is the number of days between the date that you enter an order detail line and the date that you receive the order. For items in a receipt route, the system determines the receipt date based on the date at which the items arrive at the operation flagged for receipt acknowledgement. Default value = 90.00 (%) |
5 | Yes | Input value for computation. If value leaves blank set default value for DD Alias LTQP *** RV LTQP-LeadtimePercent(wf) |
| F43090 | 18 | LTNM | LeadtimeNormalRoute (Leadtime - Normal Routing) | Indicates the leadtime between the first and last routing operations, when no test/inspection operation is performed. | 5 | ||
| F43090 | 19 | LTTS | LeadtimeTestRoute (Leadtime - Test Routing ) | Indicates the leadtime between the first and last routing operations, when a test/inspection operation is performed. | 5 | ||
| F43090 | 20 | ALTD | LeadtimeAverage (Leadtime - Average) | The average number of days from the date of the purchase order to the date that you receive the item. The system calculates leadtime after it meets the leadtime quantity percentage during receipt entry or during receipt routing. You define the leadtime quantity percentage on the Supplier/Item Relationships form (W43090B). |
5 | Yes | Compute & Update ** RV ALTD-Leadtime Average(wf) |
| F43090 | 21 | LLTD | LeadtimeLast (Leadtime - Last) | The last actual number of days from the date of the purchase order to the date that you received the item. For example, if you enter an order on 12/01/98 and receive that order on 12/05/98 and it was the last order that you received for that item from that supplier, the last leadtime is 4 (12/05/98 - 12/01/98). NOTE: The system does not calculate leadtime until the quantity meets the leadtime quantity percentage that you specified on the Supplier/Item Relationships form. |
5 | Compute & Update ** RV LLTD-Leadtime Last(wf) |
|
| F43090 | 22 | ACST | AverageUnitCost (Amount - Average Unit Cost) | Average unit cost paid for the item. When you run Voucher Match in program (P4314) to match the receipt to a voucher, the system calculates this cost by using the weighted average for quantity and cost. | 15 | Yes | Compute & Update ** RV APTD-TotalAmtPaid(wf) |
| F43090 | 23 | LCST | LastUnitCost (Amount - Last Unit Cost ) | Indicates the last unit cost paid that you paid for this item from this supplier. The system displays this value in the item's purchasing unit of measure and updates it each time you match a receipt to a voucher. | 15 | Compute & Update *** RV LCST-Amount Last Unit Cost(wf) |
|
| F43090 | 24 | NOOD | NumberOfOrders (Number of Orders Received) | The number of orders you have received from this supplier for a specific item. For this field, one line on a purchase order is equal to one order. For example: o The system counts a purchase order with two lines that you receive at one time as one purchase order. o The system counts a purchase order with one line that you receive as two partial receipts as one purchase order. |
11 | Compute & Update *** RV NOOD-Number of Orders Received(WF) |
|
| F43090 | 25 | QTYS | QuantityStocked (Units - Stocked ) | 15 | Compute & Update *** RV QTYS-Total Units Stocked(wf) |
||
| F43090 | 26 | QTYR | QuantityReturned (Units - Returned) | 15 | Compute & Update *** RV QTYR-Total Units Returned(wf) |
||
| F43090 | 27 | QTYC | QuantityScrapped (Units - Scrapped) | 15 | Compute & Update *** RV QTYC-Total Units Scrapped(wf) |
||
| F43090 | 28 | QTYW | QuantityReworked (Units - Reworked) | 15 | Compute & Update *** RV QTYW-Total Units Reworked(wf) |
||
| F43090 | 29 | QTYJ | QuantityRejected (Units - Rejected) | 15 | Compute & Update *** RV QTYJ-Total Units Rejected(wf) |
||
| F43090 | 30 | QTYA | QuantityAdjusted (Units - Adjusted) | 15 | Compute & Update *** RV QTYA-Total Units Adjusted(wf) |
||
| F43090 | 31 | UODR | UnitsOrdered2 (Units - Ordered) | 15 | Compute & Update *** RV UODR-TotalUnits Ordered(wf) |
||
| F43090 | 32 | UREC | UnitsLineItemQtyRe (Units - Received) | 15 | Compute & Update *** RV UREC1-TotalUnits(wf) |
||
| F43090 | 33 | UPTD | QuantityPaidToDate (Units - Paid to Date) | 15 | Compute & Update *** RV UPTD-TOTPAID(wf) |
||
| F43090 | 34 | UONT | UnitsOnTime (Units - On-Time) | Indicates the units ordered. The system updates and writes the value in this field at the time of purchase order entry. | 15 | Compute & Update *** RV UONT-Units on time(wf) |
|
| F43090 | 35 | UEAR | UnitsEarly (Units - Early) | This field determines the units received early. The system determines this value by comparing the promised date in the purchase order to the receipt date. If a supplier item relationship record (F43090) exists for a supplier and item, the Days Late field is considered in determining if the receipt is late. The system updates this field only once per purchase order line and once when the quantity received meets or exceeds the leadtime quantity percentage from the supplier item relationship record | 15 | Compute & Update *** RV UEAR-Units Early(wf) |
|
| F43090 | 36 | ULAT | UnitsLate (Units - Late) | Indicates the units received late. The system determines this value by comparing the promised date in the purchase order to the receipt date. If a supplier item relationship record (F43090) exists for a supplier and item, the Days Late field is considered in determining if the receipt is late. The system updates this field only once per purchase order line and once when the quantity received meets or exceeds the leadtime quantity percentage from the supplier item relationship record | 15 | Compute & Update *** RV ULAT-Units Late(wf) |
|
| F43090 | 37 | AODR | AmountOrdered (Amount - Ordered) | 15 | Compute & Update *** RV AODR-TotalAmount Ordered(wf) |
||
| F43090 | 38 | AREC | AmountReceived (Amount - Received) | 15 | Compute & Update *** RV AREC1-TotalAmount(wf) |
||
| F43090 | 39 | APTD | AmountPaidToDate (Amount - Paid to Date) | 15 | Compute & Update *** RV APTD-TotalAmtPaid(wf) |
||
| F43090 | 40 | AONT | AmountOnTime (Amount - On-Time) | 15 | Compute & Update *** RV AONT-Amount on time(wf) |
||
| F43090 | 41 | AEAR | AmountEarly (Amount - Early) | 15 | Compute & Update *** RV AEAR-Amount Early(wf) |
||
| F43090 | 42 | ALAT | AmountLate (Amount - Late) | 15 | Compute & Update *** RV ALAT-Amount Late(wf) |
||
| F43090 | 43 | RONT | ReceiptOnTime (Receipt - On-Time) | 15 | Compute & Update *** RV RONT-Receipts on time(wf) |
||
| F43090 | 44 | REAR | ReceiptEarly (Receipt - Early) | 15 | Compute & Update *** RV REAR-Receipts Early(wf) |
||
| F43090 | 45 | RLAT | ReceiptLate (Receipt - Late) | 15 | Compute & Update *** RV RLAT-Receipts Late(wf) |
||
| F43090 | 46 | URCD | UserReservedCode (User Reserved Code) | 2 | N/A | ||
| F43090 | 47 | URDT | UserReservedDate (User Reserved Date) | 6 | N/A | ||
| F43090 | 48 | URAT | UserReservedAmount (User Reserved Amount) | 15 | N/A | ||
| F43090 | 49 | URAB | UserReservedNumber (User Reserved Number) | 8 | N/A | ||
| F43090 | 50 | URRF | UserReservedReference (User Reserved Reference) | 15 | N/A | ||
| F43090 | 51 | ROTP | RouteTypeCode (Route Type Code) | A code that qualifies the routing for an Item/Supplier combination. Examples would include specific routing types for ASN's (EDI 856 Ship Notice/Manifest transactions) and for Transfers. | 1 | Yes | N/A |
| F43090 | 52 | POC | Payonconsumption (Issue and Receipt) | A code that indicates whether an item is received at the time of inventory issues or if the system uses the Move and Disposition program. Valid values are: 0 The system does not perform any actions. 1 The system receives an item when an inventory issue occurs. 2 The system uses the Movement and Disposition program when an inventory issue occurs |
1 | N/A |
Note:
Table/Column Reference in running R43900
| Table | Alias | DD Item (Description) | Explanation | Others | ||
|---|---|---|---|---|---|---|
| *** F43121 *** | Base Table | |||||
| F43121 | 1 | MATC | MatchType (Type - Match Record Type) | To determine the last cost based on MATC = '2' | 1 | MATC 1 and 2 are to be read |
| 2 | AN8 | AddressNumber (Address Number ) | Primary Key of F43090 | 8 | Supplier number which is primary key for F43090 | |
| 3 | KCOO | CompanyKeyOrderNo (Order Company (Order Number)) | 5 | Key to pull data from F4311 | ||
| 4 | DOCO | DocumentOrderInvoiceE (Document (Order No, Invoice, etc.)) | 8 | |||
| 5 | DCTO | OrderType (Order Type) | 2 | |||
| 6 | SFXO | OrderSuffix (Order Suffix) | 3 | |||
| 7 | LNID | LineNumber (Line Number ) | 6 | |||
| 8 | NLIN | NoOfLinesOnOrder (Number of Lines) | 5 | Receipt Line Number | ||
| 14 | ITM | IdentifierShortItem (Item Number - Short ) | Primary Key of F43090 | 8 | ||
| 15 | LITM | Identifier2ndItem (2nd Item Number ) | 25 | Information only | ||
| 16 | AITM | Identifier3rdItem (3rd Item Number ) | 25 | Information only | ||
| 18 | LOCN | Location (Location) | 20 | These columns can be used for UOM conversion | ||
| 19 | LOTN | Lot (Lot/Serial Number) | 30 | |||
| 21 | LOTP | Lot Potency (Lot Potency) | ||||
| 26 | TRDJ | DateTransactionJulian (Date - Order/Transaction) | 6 | Not in use | ||
| 27 | RCDJ | DateReceived (Date - Received ) | 6 | RV LLTD-DifferenceOfRCDJ&PDDJ) = (F43121.PDDJ) - (F4311.RCDJ | ||
| 29 | PDDJ | ScheduledPickDate (Date - Scheduled Pick) | 6 | Refe to Bug 12504426 : PDDJ INSTEAD OF OPDJ - SAR: 6153948 | ||
| 30 | OPDJ | DateOriginalPromisde (Date - Original Promised Delivery) | 6 | Not in use because lead time is computed based on PDDJ | ||
| 35 | LAND | LandedCostCode (Code - Landed Cost) | Indicates how a PO receiver record relates to landed cost. The following is a list of possible values: blank The record is not related to landed cost. 1 The record has associated landed cost records. 2 The record is a landed cost record that is to be vouchered. 3 The record is a landed cost record that is not to be vouchered. |
1 | R43900 excludes when F43121.LAND IN ('2', '3') | |
| 45 | MCU | CostCenter (Business Unit) | Primary Key for F43090 For non stock item do not map this column |
12 | ||
| 65 | UOM | UnitOfMeasureAsInput (Unit of Measure as Input) | To recognize based on primary UOM | 2 | Target UOM to convert to primary UOM for UORG | |
| 66 | UORG | UnitsTransactionQty (Units - Order/Transaction Quantity ) | 15 | To compute percentage: RV LTQP-PercentReceived(wf) = (sum (F43121.UREC) / (F43121.UORG) * 100 | ||
| 67 | UPTD | QuantityPaidToDate (Units - Paid to Date) | 15 | Compuate UPTD, APTD and LCST when F43121.MATC = 2 | ||
| 69 | UREC | UnitsLineItemQtyRe (Units - Received) | 15 | Calculate Percent Received (RV LTQP-PercentReceived(wf)) A = sum(F43121.urec) / sum(F43121.uorg) * 100 (where ITM, MCU and AN8 are unique) |
||
| 71 | QTYS | QuantityStocked (Units - Stocked ) | 15 | Accumulate QTYS, QTYR, QTYW, QTYC,QTYJ and QTYA in primary UOM For example, QTYS = sum (F43121.QTYS) |
||
| 72 | QTYR | QuantityReturned (Units - Returned) | 15 | |||
| 73 | QTYW | QuantityReworked (Units - Reworked) | 15 | |||
| 74 | QTYC | QuantityScrapped (Units - Scrapped) | 15 | |||
| 75 | QTYJ | QuantityRejected (Units - Rejected) | 15 | |||
| 76 | QTYA | QuantityAdjusted (Units - Adjusted) | 15 | |||
| 82 | AREC | AmountReceived (Amount - Received) | 15 | Accumulate UREC and AREC. UREC = sum (F43121.UREC) in primary UOM and AREC = sum (F43121.AREC) in primary UOM | ||
| 104 | UPMJ | DateUpdated (Date - Updated) | 6 | This value (along with TDAY) can be used to pick up data which has not handled previously. | ||
| 105 | TDAY | TimeOfDay (Time of Day) | 6 | |||
| **** F4311 **** | Referencing Table | |||||
| F4311 | 1 | KCOO | CompanyKeyOrderNo (Order Company (Order Number)) | 5 | Primary Key | |
| 2 | DOCO | DocumentOrderInvoiceE (Document (Order #, Invoice, etc.)) | 8 | Primary Key | ||
| 3 | DCTO | OrderType (Contract Type) | 2 | Primary Key | ||
| 4 | SFXO | OrderSuffix (Order Suffix) | 3 | Primary Key | ||
| 5 | LNID | LineNumber (Line Number) | 6 | Primary Key | ||
| 22 | TRDJ | DateTransactionJulian (Date - Order/Transaction) | 6 | This value is to be used to compute RV LLTD-Last Lead Time(wf) | ||
| 60 | UOM | UnitOfMeasureAsInput (Unit of Measure as Input) | 2 | Transaction UOM. In case this value is different from F4101.UOM1, conversion takes place | ||
| 61 | UORG | UnitsTransactionQty (Units - Order/Transaction Quantity) | 15 | To compute UODR (RV UODR-TotalUnits Ordered(wf)) | ||
| 69 | AEXP | AmountExtendedPrice (Amount - Extended Price) | 15 | AODR (RV AODR-TotalAmount Ordered(wf)) | ||
| **** F4101 **** | Referencing Table | |||||
| F4101 | ITM | Input value to get below column values | Primary Key | |||
| UOM1 | UnitOfMeasurePrimary (Unit of Measure - Primary) | When Transaction UOM is not in Primary then compute quantity and amount based on primary UOM | To realize computation based on primary UOM. | |||
| STKT | StockingType (Stocking Type) | To determine whether the input item is Stock or Non-Stock. In case it is non-stock item access F43090 based on Item and Supplier Combination other wise access it through Item, Branch and Supplier Combination | This value determined whether the line you handle is stock or non-stock item. In case a certain receipt is non-stock item (which presume no record from F4102), which pulls data from F43090 based on ITM and AN8 combination. For stock item it gets data based on MCU, ITM and AN8 combination. And this value determines level break for data from F43121. | |||
| TFLA | TemporaryItemFlashMessag (Standard Unit of Measure Conversion) | To determine UOM Coversion | To determine which file to read between F41003 and F41002. |
Note:
Below table is to show routine to populate a certain column value from F43090. Some values affecting another value so the computation has to be performed in sequence.
| Seq | Computation/Assignment | F43090.Column mapping |
|---|---|---|
| 1 | Exclude receipt records when F43121.LAND is equal to '2 - Receipt' or '3 - Vouchered' (but reads both F43121.matc = '1' and '2' | |
| 2 | Get item master records to get UOM1, STKT and TFLA | F4101 Get Item Master Information |
| 3 | Read F43090 either on ITM, AN8 combination or MCU, ITM (for none stock item) and AN8 combination (for stock item) to get columns DAYE, DAYL and LTQP (and set flag for whether there is a matching record or not) | (through business function GetSupplierItemColumns (B4300400 - F43090 Get Lead Time)) |
| 4 | Set level break either for ITM, AN8 (for non-stock item) or ITM, MCU and AN8 (for stock item) | |
| 5 | Calculate Percent Received (RV LTQP-PercentReceived(wf)) A = sum(F43121.urec) / sum(F43121.uorg) * 100 (where ITM, MCU and AN8 are unique) |
Temporary value to compute following computation |
| 6 | Determine leadtime quantity percent (LTQP). If a F43090 record existed, use that percent otherwise retrieve from the data dictionary (RV LTQP-LeadtimePercent(wf)) B = either [F43090.LTQP] or [90.00% from DD Definition (F9210.DVAL where F3210.DTAI = 'LTQP')] |
F43090.LTQP |
| 7 | Get RV LLTD-Last Lead Time(wf) after getting F4311.TRDJ when A >= B (i.e., Percent Received >= LTQP). RV LLTD-Last Lead Time(wf) = abs (F43121.RCDJ - F4311.TRDJ) |
F43090.LLTD |
| 8 | UODR (RV UODR-TotalUnits Ordered(wf)) = sum (F4311.UORG) in primary UOM | F43090.UODR |
| 9 | AODR (RV AODR-TotalAmount Ordered(wf)) = sum (F4311.AEXP) in primary UOM | F43090.AODR |
| 10 | Determine if the receipt was ontime, early or late.
Note: when there F43090 does not contain any data then remove 2nd conditions (DAYE and DAYL) |
F43090.REAR F43090.RLAT F43090.RONT |
| 11 | Accumulate UREC and AREC. UREC = sum (F43121.UREC) in primary UOM and AREC = sum (F43121.AREC) in primary UOM | F43121.UREC F43121.AREC |
| 12 | Update Lead Time computed in step 7. RV ALTD-Leadtime Average(wf) = RV LLTD-Last Lead Time(wf) |
F43090.ALTD |
| 13 | If the percent received is greater than the leadtime quantity percent, and the order has not been included in the total, do so now. | |
| 14 | Accumulate QTYS, QTYR, QTYW, QTYC,QTYJ and QTYA in primary UOM For example, QTYS = sum (F43121.QTYS) |
F43090.QTYS F43090.QTYR F43090.QTYW F43090.QTYC F43090.QTYJ F43090.QTYA |
| 15 | Compute (UONT, AONT), (UEAR, AEAR) and (ULAT, ALAT). Same as step 10 by comparing PDDJ and RCDJ | F43090.UONT F43090.AONT F43090.UEAR F43090.AEAR F43090.ULAT F43090.ALAT |
| 16 | Compuate UPTD, APTD and LCST when F43121.MATC = 2 UPTD = sum (F43121.UPTD) in primary UOM APTD = sum (F43121.APTD) in primary UOM LCST = APTD/UPTD |
F43090.UPTD F43090.APTD F43090.LCST |
Note:
Ontime receipt
Though this document has focused on the application R43900, the value updated affects Supplier Analysis. For detail refer to,
<Document 659278.1> - E1: 43: Supplier Catalog Price Item Updates (P41061 / F41061 / P43090 / F43090)
<Document 625474.1> - E1: 43: Overview of The Purchase Order Generator (P43011)
<Document 662211.1> - E1: 43: Supplier Analysis (P4310 / P4312 / P4314 / P43230 / R04602 / F0401)