Functional Description
Purpose
To perform all inquiries, additions, updates and deletions to the Routing Extension Table (F31172).
Setup Notes and Prerequisites
Definitions
1)"Soft" errors are errors that do not cause the function to stop processing further and exit.
2) "Fatal" errors are errors that cause the function to stop processing further and exit.
3)Any error (Soft or Fatal) will prevent database commits to occur.
Special Logic
The business function will currently recognize "CSMS" process module calls.
Technical Specification
1.// Initialize work and output fields.
2.Error Message ID (DTAI) = " "
3.If Update Master File (EV01) <> '1' And <> '0' Then
4. Update Master File (EV01) = '0'
5.End IF
6.//
7.If Action Code (ACTN) = 'I' Then
8. Fetch Record from F31172 using DOCO, OPSQ, OPSC, and MCU. Return data to I/O Parameters.
9. If Failed Then Set Error 017F, Error Message ID (DTAI) = "017F"
10.End If
11.
12.If Update Master File (EV01) = '1' And Error Message ID (DTAI) = " " And Action Code <> 'I'
Then
13. If Action Code (ACTN) = 'A' Then
14. Call B9800100 to retrieve USER, JOBN, UPMJ, TDAY
15. Add Record to F31172 using all I/O Parameters.
16. If Failed Then Set Error 026P, Error Message ID (DTAI) = "026P"
17. Else If Action Code (ACTN) = 'C' Then
18. Call B9800100 to retrieve USER, JOBN, UPMJ, TDAY
19. Update Record to F31172 using all I/O Parameters and DOCO, OPSQ, OPSC and MCU as Keys.
20. If Failed Then Set Error 026N, Error Message ID (DTAI) = "026N"
21. Else If Action Code (ACTN) = 'D' Then
22. Delete Record from F31172 using DOCO, OPSQ, OPSC and MCU as Keys.
23. If Failed Then Set Error 026O, Error Message ID (DTAI) = "026O"
24. End If
25.End If
D1700410 - F31172 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. | ||||
mnOrderNumber | DOCO | MATH_NUMERIC | OPT | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
mnOperationSequenceNumber | OPSQ | MATH_NUMERIC | OPT | NONE |
A number used to indicate an order of succession.
In routing instructions, a number that sequences the fabrication or assembly steps in the
| ||||
szTypeOperationCode | OPSC | char | OPT | NONE |
A user defined code (30/OT) that indicates the type of operation. Valid values include: A Alternate routing TT Travel time IT Idle time T Text | ||||
szBusinessUnit | 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
| ||||
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
| ||||
mnActBillableRate | ACRTB | MATH_NUMERIC | OPT | NONE |
The actual billable rate associated with a transaction. | ||||
mnActPayableRate | ACRTP | MATH_NUMERIC | OPT | NONE |
The actual payable rate associated with a transaction. | ||||
mnEstimatedAmount | EBILL | MATH_NUMERIC | OPT | NONE |
mnActualDollars | AMTA | MATH_NUMERIC | OPT | NONE |
The actual dollars accumulated for the work order. | ||||
mnAmountOriginalDollars | AMTO | MATH_NUMERIC | OPT | NONE |
The estimated monetary amount that is budgeted for this work order. | ||||
mnEstimatedBillableRate | ESRTB | MATH_NUMERIC | OPT | NONE |
The estimated billable rate associated with a service. | ||||
mnEstimatedPayableRate | ESRTP | MATH_NUMERIC | OPT | NONE |
The estimated payable rate associated with a transaction. | ||||
mnEstimatedPaymentAmount | EPAAP | MATH_NUMERIC | OPT | NONE |
This is the estimated payment amount used in service billing. | ||||
mnTotalBilled | TOTB | MATH_NUMERIC | OPT | NONE |
The total amount billed through this application number. | ||||
mnClaimAmount | CLAMT | MATH_NUMERIC | OPT | NONE |
The amount requested for providing a service. | ||||
jdBillDate | DTBIL | JDEDATE | OPT | NONE |
In service billing, the date a customer was billed for a service. | ||||
jdPaidDate | DTPAY | JDEDATE | OPT | NONE |
The date a service provider was paid for a service. | ||||
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
| ||||
mnLaborRatePerHour1 | LBR1 | MATH_NUMERIC | OPT | NONE |
Under a Service Contract, the labor rate per hour charged while providing the service for each day of the week and for holidays. For
| ||||
jdActualStartDate | D2J | JDEDATE | OPT | NONE |
Enter the actual start date for a project or job in this field. Use this information for reporting purposes. | ||||
mnStartTime | STTI | MATH_NUMERIC | OPT | NONE |
This is the start time for an operation or an order. | ||||
mnEstimatedEndingTime | EPETM | MATH_NUMERIC | OPT | NONE |
The estimated ending time associated with a work order. | ||||
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
| ||||
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
| ||||
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. | ||||
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. | ||||
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
| ||||
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
| ||||
szGLCategoryNonCovered | 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
| ||||
szGLCategoryCovered | 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
| ||||
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.
| ||||
mnForeignEstBillUnit | FESUNB | MATH_NUMERIC | OPT | NONE |
The estimated unit rate that is billable in the currency of the customer. | ||||
mnForeignEstBillAmount | FEBILL | MATH_NUMERIC | OPT | NONE |
The estimated billable amount in the currency of the customer. | ||||
mnForeignActBillUnit | FACUNB | MATH_NUMERIC | OPT | NONE |
The actual unit rate that is billable in the currency of the customer. | ||||
mnForeignActBillAmount | FTOTB | MATH_NUMERIC | OPT | NONE |
The actual amount that is billable in the currency of the customer. | ||||
mnForeignActPayAmount | FPAAP | MATH_NUMERIC | OPT | NONE |
The actual payable amount that is recorded in the foreign 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. | ||||
mnForeignEstPayAmount | FEPAAP | MATH_NUMERIC | OPT | NONE |
The estimated payable amount in the currency of the service provider. | ||||
mnForeignActPayUnit | FACUNP | MATH_NUMERIC | OPT | NONE |
The actual unit rate that is payable in the currency of the service provider. | ||||
szCostCenterCausal | 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 |
szFailureCode | FAILCD | char | OPT | NONE |
A user defined code (17/FC) that indicates the type of defect. | ||||
jdDateSubmitted | DTSUB | JDEDATE | OPT | NONE |
The date that a supplier recovery claim was submitted to the interoperability tables for Warranty Claim/Supplier Recovery
| ||||
mnTimeSubmitted | TMSUB | MATH_NUMERIC | OPT | NONE |
The time that a supplier recovery claim was submitted to the interoperability tables. | ||||
mnCausalPart | CSLPRT | MATH_NUMERIC | OPT | NONE |
The item number that indicates which part failed and caused the equipment failure. | ||||
cInvoiceRequired | INVREQ | char | OPT | NONE |
A code that determines whether an invoice is required. Valid values are: 0 An invoice is not required. 1 An invoice is required. | ||||
cInvoiceReceived | INVREC | char | OPT | NONE |
A code that indicates whether an invoice is received. Valid values are: 0 An invoice is not received. 1 An invoice is received. | ||||
szRTSSystem_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
| ||||
szRTSAssembly_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
| ||||
szRTSPart_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
| ||||
cLaborSource_LSRCE | LSRCE | char | OPT | NONE |
A user defined code (17/LS) that specifies whether the system tracks labor amounts and information or whether it tracks third-party invoice
|
None |
None |