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 |