Functional Description
Purpose
To perform all inquiries, additions, updates and deletions to the Parts List Extension Table (F31171).
Setup Notes and Prerequisites
Special Logic
Modes:
Add = 'A'
Change = 'C'
Delete = 'D'
Inquire = 'I'
Any other values will not allow the commit to the database.
Update Master File:
No updates, edit only (Default) = 0
Update the database = 1
Technical Specification
2.4 Processing
// Initialize work and output fields.
Error Message ID (DTAI) = " "
If Update Master File (EV01) <> '1' And <> '0' Then
Update Master File (EV01) = '0'
End IF
//
If Action Code (ACTN) = 'I' Then
Fetch Record from F31171 using UKID. Return data to I/O Parameters.
If Failed Then Set Error 017F, Error Message ID (DTAI) = "017F"
End If
If Update Master File (EV01) = '1' And Error Message ID (DTAI) = " " And Action Code <> 'I' Then
If Action Code (ACTN) = 'A' Then
Call B9800100 to retrieve USER, JOBN, UPMJ, TDAY
Add Record to F31171 using all I/O Parameters.
If Failed Then Set Error 026P, Error Message ID (DTAI) = "026P"
Else If Action Code (ACTN) = 'C' Then
Call B9800100 to retrieve USER, JOBN, UPMJ, TDAY
Update Record to F31172 using all I/O Parameters and UKID as Key.
If Failed Then Set Error 026N, Error Message ID (DTAI) = "026N"
Else If Action Code (ACTN) = 'D' Then
Delete Record from F31172 using UKID as Key.
If Failed Then Set Error 026O, Error Message ID (DTAI) = "026O"
End If
End If
D1700400 - F31171 Process Master Data
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| cActionCode | ACTN | char | OPT | NONE |
A code that specifies the action that is performed. Valid values are: A Add C Change | ||||
| cUpdateMasterFile | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
| cSuppressErrorMessage | SUPPS | char | OPT | NONE |
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.
0 = allow
| ||||
| cProcessEdits | 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
| ||||
| szProgramVersionForProcOpts | 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
| ||||
| szProgramIdForProcOpts | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
| szProcessModule | VC04A | char | OPT | NONE |
This is a generic field used as a work field in Everest. | ||||
| mnUniqueKeyID | UKID | MATH_NUMERIC | OPT | NONE |
This field is a unique number used to identify a record in a file. | ||||
| mnEstimatedUnitCost | ESUNC | MATH_NUMERIC | OPT | NONE |
Estimated unit cost associated with a transaction. | ||||
| mnEstimatedUnitBillable | ESUNB | MATH_NUMERIC | OPT | NONE |
The estimated unit cost for billing. | ||||
| mnEstimatedUnitPayable | ESUNP | MATH_NUMERIC | OPT | NONE |
The estimated unit cost of the payable. | ||||
| mnEstimatedPaymentAmount | EPAAP | MATH_NUMERIC | OPT | NONE |
This is the estimated payment amount used in service billing. | ||||
| mnAmountOriginalDollars | AMTO | MATH_NUMERIC | OPT | NONE |
The estimated monetary amount that is budgeted for this work order. | ||||
| mnEstimatedAmount | EBILL | MATH_NUMERIC | OPT | NONE |
| mnActualUnitCost | ACUNC | MATH_NUMERIC | OPT | NONE |
The actual unit cost associated with a transaction. | ||||
| mnActualUnitBillable | ACUNB | MATH_NUMERIC | OPT | NONE |
The actual unit billable amount. | ||||
| mnActualUnitPayable | ACUNP | MATH_NUMERIC | OPT | NONE |
The actual unit payable amount. | ||||
| mnActualDollars | AMTA | MATH_NUMERIC | OPT | NONE |
The actual dollars accumulated for the work order. | ||||
| mnTotalBilled | TOTB | MATH_NUMERIC | OPT | NONE |
The total amount billed through this application number. | ||||
| mnPaymentAmount | PAAP | MATH_NUMERIC | OPT | NONE |
In the Accounts Payable system, the amount of the payment.
In the Accounts Receivable system, the amount of the receipt. This amount
| ||||
| mnClaimAmount | CLAMT | MATH_NUMERIC | OPT | NONE |
The amount requested for providing a service. | ||||
| mnPrimaryLastSupplier | VEND | MATH_NUMERIC | OPT | NONE |
The address book number of the preferred provider of this item. | ||||
| cPayableYN | PAYAB | char | OPT | NONE |
This field specifies whether a general ledger account should be paid. Valid values are:
Y The account should be paid.
N The account
| ||||
| cBillableYN | BILL | char | OPT | NONE |
Specifies whether a general ledger account should be billed. Valid codes are:
Y Yes, the account should be billed.
N No, it should not be
| ||||
| jdPaidDate | DTPAY | JDEDATE | OPT | NONE |
The date a service provider was paid for a service. | ||||
| jdBillDate | DTBIL | JDEDATE | OPT | NONE |
In service billing, the date a customer was billed for a service. | ||||
| szCostType | COST | char | OPT | NONE |
A code that designates each element of cost for an item. Examples of the cost object types are:
o A1 Purchased raw material
o B1
| ||||
| szNonCoveredGLCategory | GLCNC | char | OPT | NONE |
A user defined code (41/9) that identifies the G/L Offset to use when the system is searching for the account to which it will post the
| ||||
| szCoveredGLCategory | GLCCV | char | OPT | NONE |
A user defined code (41/9) that identifies the G/L Offset to use when the system is searching for the account to which it will post the covered
| ||||
| szEntitlementCheck | ENTCK | char | OPT | NONE |
A user defined code (17/ER) to indicate the results of an entitlement check.
Valid values are:
0 Not entitled
1 Transaction entitled
2
| ||||
| szReference02 | VR02 | char | OPT | NONE |
A field available to record reference numbers, such as the supplier's bid document number, quote document, sales order, work order, or
| ||||
| szUserId | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
| szProgramId | PID | char | OPT | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
| szWorkStationId | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
| jdDateUpdated | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. | ||||
| mnTimeOfDay | TDAY | MATH_NUMERIC | OPT | NONE |
The computer clock in hours:minutes:seconds. | ||||
| szPriceAdjustScheduleService | ASN2 | char | OPT | NONE |
This user defined code (40/AS) identifies a price and adjustment schedule. A price and adjustment schedule contains one or more
| ||||
| szPriceAdjustScheduleFour | ASN4 | char | OPT | NONE |
A user defined code (40/AS) identifying a price and adjustment schedule. A price and adjustment schedule contains one or more
| ||||
| mnPercentCovered | PCOVR | MATH_NUMERIC | OPT | NONE |
The percentage covered under warranty or contract. This is used to calculate the amount to bill or the amount to cost for the line item being
| ||||
| cMethodofPricing | MTHPR | char | OPT | NONE |
A code used to determine if this type of service should be priced based on a flat rate or based on actual time and materials.
Valid values
| ||||
| mnServiceAddressNumber | SAID | MATH_NUMERIC | OPT | NONE |
A unique numeric identifier for a physical location at which utility service is delivered. A service address often corresponds to a parcel of
| ||||
| szProductModel | PRODM | char | OPT | NONE |
A code that classifies an inventory item into a model for customer service. Some examples include: Laser Printer, Inkjet or Fax. | ||||
| szProductFamily | PRODF | char | OPT | NONE |
A code that classifies an inventory item into a group for customer service. Some examples include: Laser Printer, Inkjet, or Fax. | ||||
| szCoverageGroup | COVGR | char | OPT | NONE |
A user defined code that specifies the Coverage Group. The Coverage Group consists of unlimited cost codes and the percentage
| ||||
| cPayPricingMethod | PMTHP | char | OPT | NONE |
A code used to determine if this type of service should be priced based on a flat rate or based on actual time and materials.
Valid values
| ||||
| cPayServProviderForParts | PYPRT | char | OPT | NONE |
A code to indicate if the service provider should be paid for parts used during a repair.
Valid values are:
Y or 1 - Pay the service provider
| ||||
| szBaseCurrency | CRDC | char | OPT | NONE |
A code that identifies the domestic (base) currency of the company on a transaction. | ||||
| szBillableCurrency | BCRCD | char | OPT | NONE |
The currency for the billable amounts of a service order. | ||||
| mnBillableExchangeRate | BCRR | MATH_NUMERIC | OPT | NONE |
The rate that the system uses to convert foreign currency amounts to domestic currency amounts. The system uses this rate specifically for
| ||||
| cBillableCurrencyMode | BCRRM | char | OPT | NONE |
A code that specifies whether the system uses the foreign currency (currency of the customer) or the domestic currency for billable
| ||||
| szPayableCurrency | PCRCD | char | OPT | NONE |
A code that indicates the currency of the payable amounts on a work order or claim. | ||||
| mnPayableExchangeRate | PCRR | MATH_NUMERIC | OPT | NONE |
The rate that the system uses to convert foreign currency amounts to domestic currency amounts. The system uses this rate specifically for
| ||||
| cPayableCurrencyMode | PCRRM | char | OPT | NONE |
A code that specifies whether payable amounts are in the foreign currency (currency of the service provider) or in the domestic currency.
| ||||
| mnForeignActualBillAmount | FTOTB | MATH_NUMERIC | OPT | NONE |
The actual amount that is billable in the currency of the customer. | ||||
| mnForeignActBillableUnit | FACUNB | MATH_NUMERIC | OPT | NONE |
The actual unit rate that is billable in the currency of the customer. | ||||
| mnForeignEstBillableAmount | FEBILL | MATH_NUMERIC | OPT | NONE |
The estimated billable amount in the currency of the customer. | ||||
| mnForeignEstBillableUnit | FESUNB | MATH_NUMERIC | OPT | NONE |
The estimated unit rate that is billable in the currency of the customer. | ||||
| mnForeignActualPayAmount | FPAAP | MATH_NUMERIC | OPT | NONE |
The actual payable amount that is recorded in the foreign currency of the service provider. | ||||
| mnForeignActualPayUnit | FACUNP | MATH_NUMERIC | OPT | NONE |
The actual unit rate that is payable in the currency of the service provider. | ||||
| mnForeignEstPayAmount | FEPAAP | MATH_NUMERIC | OPT | NONE |
The estimated payable amount in the currency of the service provider. | ||||
| mnForeignEstPayUnit | FESUNP | MATH_NUMERIC | OPT | NONE |
The estimated unit rate that is payable in the currency of the service provider. | ||||
| szCausalCostCenter | MCUCSL | char | OPT | NONE |
The business unit that is related to the causal portion of the claim. | ||||
| szVendorLotNumber | RLOT | char | OPT | NONE |
The supplier's lot number for the item. | ||||
| mnSRVendorNo | SRVEND | MATH_NUMERIC | OPT | NONE |
The address book number of the vendor to be used for supplier recovery. | ||||
| mnUniqueKeyPricing | UKIDP | MATH_NUMERIC | OPT | NONE |
| cTaxableYN | TAX1 | char | OPT | NONE |
A code that indicates whether the item is subject to sales tax when you sell it. The system calculates tax on the item only if the customer is
| ||||
| mnCausalPart | CSLPRT | MATH_NUMERIC | OPT | NONE |
The item number that indicates which part failed and caused the equipment failure. | ||||
| mnTimeSubmitted | TMSUB | MATH_NUMERIC | OPT | NONE |
The time that a supplier recovery claim was submitted to the interoperability tables. | ||||
| jdDateSubmitted | DTSUB | JDEDATE | OPT | NONE |
The date that a supplier recovery claim was submitted to the interoperability tables for Warranty Claim/Supplier Recovery
| ||||
| cReturnPolicy | RETPOL | char | OPT | NONE |
A user defined code (17/RT) that specifies whether to return the part with the claim. | ||||
| szFailureCode | FAILCD | char | OPT | NONE |
A user defined code (17/FC) that indicates the type of defect. | ||||
| szCompCdGrpSys_VMRS31 | VMRS31 | char | OPT | NONE |
A user defined code (17/C6) that indicates a specific system, such as the air conditioning system, that is associated with a piece of
| ||||
| szCompCdSysAsbly_VMRS32 | VMRS32 | char | OPT | NONE |
A user defined code (17/C7) that indicates the location of a specific assembly, such as the air conditioning compressor, within a piece of
| ||||
| szCompCdSysAsblyPart_VMRS33 | VMRS33 | char | OPT | NONE |
A user defined code (17/C8) that indicates the location of a specific part, such as the fuse to the air conditioning compressor clutch, within a
| ||||
| None |
| None |