1.1Purpose
This NER will retrieve the fields in the joined business view (V4801JE) over the Work Order table (F4801) and the Work Order Tag table (F4801T).
1.2Setup Notes and Prerequisites
1.3Special Logic
This NER will use Service Order Number - DOCO to fetch F4801 and F4801T. If Service Order Number is invalid and can not fetch tables
successfully, the error message will be return if SuppressErrorMessage is not equal to 1.
2.1Parameters:
Data Item Data Structure DescriptionI/ORequiredNotes
1.DOCOmnDocumentOrderInvoiceEIY
2.DCTOszOrderTypeON
3.RCTOszRelatedOrderTypeON
4.RORNszRelatedPoSoNumberON
5.RKCOszCompanyKeyRelatedON
6.SFXOszOrderSuffixON
7.LNIDmnLineNumberON
8.PARSszParentWoNumberON
9.TYPScTypeWoON
10.PRTScPriorityWoON
11.DL01szDescription001ON
12.STCMszStatusCommentWoON
13.COszCompanyON
14.MCUszCostCenterON
15.MMCUszCostCenterAltON
16.LOCNszLocationON
17.SRSTszStatusCodeWoON
18.SUBszSubsidiaryON
19.AN8mnAddressNumberON
20.ANOmnAddNoOriginatorON
21.ANSAmnAddressNumberManagerON
22.ANPAmnSupervisorON
23.ANPmnAddNoAssignedToON
24.SAIDmnServiceAddressNumberON
25.ANTmnAddressNumberInspectorON
26.NAN8mnNextAddressNumberON
27.TRDJjdDateTransactionJulianON
28.STRTjdDateStartON
29.DRQJjdDateRequestedJulianON
30.PPLjdDateWoPlanCompletedON
31.STRXjdDateCompletionON
32.DAPjdDateAssignedToON
33.DATjdDateAssignToInspectorON
34.TDTjdDateScheduledTicklerON
35.PBTMmnBeginningHhMmSsON
36.WR01szCategoriesWorkOrder001ON
37.WR02szCategoriesWorkOrder002ON
38.WR03szCategoriesWorkOrder003ON
39.WR04szCategoriesWorkOrder004ON
40.WR05szCategoriesWorkOrder005ON
41.WR06szCategoriesWorkOrder006ON
42.WR07szCategoriesWorkOrder007ON
43.WR08szCategoriesWorkOrder008ON
44.WR09szCategoriesWorkOrder009ON
45.WR10szCategoriesWorkOrder010ON
46.AMTOmnAmountOriginalDollarsON
47.HRSOmnHoursOriginalON
48.AMLCmnAmountEstimatedLaborON
49.AMMCmnAmountEstimatedMaterialON
50.AMOTmnAmountEstimatedOtherON
51.ESDNmnEstimatedDowntimeHoursON
52.AMTAmnAmountActualON
53.HRSAmnHoursActualON
54.LBAMmnAmountActualLaborON
55.MTAMmnAmountActualMaterialON
56.ACDNmnActualDowntimeHoursON
57.ITMmnIdentifierShortItemON
58.TBMszTypeBillON
59.TRTszTypeRoutingON
60.NUMBmnAssetItemNumberON
61.AAIDmnParentNumberON
62.UORGmnUnitsTransactionQtyON
63.SHNOszMessageNoON
64.SPRTcWoFlashMessageON
65.PCmnPercentCompleteON
66.VR01szReference1ON
67.APRTszApprovalTypeON
68.SBLIcSubledgerInactiveCodeON
69.USERszF4801UserIdON
70.PIDszF4801ProgramIdON
71.JOBNszF4801WorkStationIdON
72.UPMJjdF4801DateUpdatedON
73.TDAYmnF4801TimeOfDayON
74.PTWOmnPegToWorkOrderON
75.VR02szReference2VendorON
76.UOMszUnitOfMeasureAsInputON
77.ISSUEszISSUEON
78.PRODMszProductModelON
79.WHO2szContactName2ON
80.AR1szPhoneAreaCode1ON
81.PHN1szPhoneNumberOneON
82.TMCOmnTimeCompletedON
83.SCALLcSecondCallON
84.MTHPRcMethodofPricingON
85.ENTCKszEntitlementCheckON
86.GWAUTszGoodwillAuthorizationON
87.RYINcPaymentInstrumentAON
88.RSTMmnResponseTimeON
89.OTRszCountryON
90.REGIONszGeographicRegionON
91.TXA1szTaxArea1ON
92.EXR1szTaxExplanationCode1ON
93.LNGPszLanguagePreferenceON
94.GLCCVszGLCategoryCoveredON
95.GLCNCszGLCategoryNonCoveredON
96.ISNOmnIssueNumberON
97.DOCmnDocVoucherInvoiceEON
98.DCTszDocumentTypeON
99.KCOszCompanyKeyON
100.COCHszContractChangeNumON
101.LNIDmnF4817LineNumberON
102.CRTUszF4817CreatedByUserON
103.USERszF4817UserIdON
104.PIDszF4817ProgramIdON
105.JOBNszF4817WorkStationIdON
106.TDAYmnF4817TimeOfDayON
107.UPMJjdF4817DateUpdatedON
108.COVGRszCoverageGroupON
109.ASN4szPriceAdjustScheduleFourON
110.ASN2szPriceAdjustScheduleServiceON
111.SESTmnTimeScheduledStartON
112.SEETmnTimeScheduledEndON
113.DSAVNAMEszDaylightSavingsRuleNa ON
114.TIMEZONESszTimeZoesON
115.SUPPScSuppressErrorMessagesIN1 = Suppress Error Messages
116.DTAIszErrorMessageIDONError Message ID
2.2Related Tables
Table Table Description
F4801
F4801T
2.3Related Business Functions
Source NameFunction Name
2.4Processing
Fetch F4801 using DOCO
If File I/O Status is not equal to Successful
If cSuppressErrorMessages is not equal to 1
Set NER Error
SzErrorMessageID = '0002'
Else
Fetch F4801T using DOCO
If File I/O Status is not equal to Successful
If cSuppressErrorMessages is not equal to 1
Set NER Error
SzErrorMessageID = '0002'
End if
End if
End if
D1700980A - S/WM Get Service Order
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cSuppressErrorMessages_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cErrorCode_ERRC | ERRC | char | OPT | NONE |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
| ||||
szErrorMessageID_DTAI | 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
| ||||
mnOrderNumber_DOCO | DOCO | MATH_NUMERIC | REQ | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
szOrderType_DCTO | DCTO | char | OPT | NONE |
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
| ||||
szRelatedOrderType_RCTO | RCTO | char | OPT | NONE |
A user defined code (system 00, type DT) that indicates the document type of the secondary or related order. For example, a purchase
| ||||
szRelatedPoSoNumber_RORN | RORN | char | OPT | NONE |
A number that identifies a secondary purchase order, sales order, or work order that is associated with the original order. This number is for
| ||||
szCompanyKeyRelated_RKCO | RKCO | char | OPT | NONE |
The key company that is associated with the document number of the related order. | ||||
szOrderSuffix_SFXO | SFXO | char | OPT | NONE |
In the A/R and A/P systems, a code that corresponds to the pay item. In the Sales Order and Procurement systems, this code identifies
| ||||
mnLineNumber_LNID | LNID | MATH_NUMERIC | OPT | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
szParentWoNumber_PARS | PARS | char | OPT | NONE |
A number that identifies the parent work order. You can use this number to do the following:
o Enter default values for new work orders,
| ||||
cTypeWo_TYPS | TYPS | char | OPT | NONE |
A user defined code (00/TY) that indicates the classification of a work order or engineering change order.
You can use work order type as a
| ||||
cPriorityWo_PRTS | PRTS | char | OPT | NONE |
A user defined code (00/PR) that indicates the relative priority of a work order or engineering change order in relation to other orders.
A
| ||||
szDescription001_DL01 | DL01 | char | OPT | NONE |
A user defined name or remark. | ||||
szStatusCommentWo_STCM | STCM | char | OPT | NONE |
A brief description to explain the status of the work order. | ||||
szCompany_CO | CO | char | OPT | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
szCostCenter_MCU | 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
| ||||
szCostCenterAlt_MMCU | MMCU | char | OPT | NONE |
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which
| ||||
szLocation_LOCN | LOCN | char | OPT | NONE |
The storage location from which goods will be moved. | ||||
szStatusCodeWo_SRST | SRST | char | OPT | NONE |
A user defined code (00/SS) that describes the status of a work order, rate schedule, or engineering change order. Any status change from
| ||||
szSubsidiary_SUB | SUB | char | OPT | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
mnAddressNumber_AN8 | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
mnAddNoOriginator_ANO | ANO | MATH_NUMERIC | OPT | NONE |
The address book number of the person who originated the change request. The system verifies this number against the Address Book. | ||||
mnAddressNumberManager_ANSA | ANSA | MATH_NUMERIC | OPT | NONE |
The address book number of a manager or planner.
Note: A processing option for some forms allows you to enter a default value for this
| ||||
mnSupervisor_ANPA | ANPA | MATH_NUMERIC | OPT | NONE |
The address book number of the supervisor. | ||||
mnAddNoAssignedTo_ANP | ANP | MATH_NUMERIC | OPT | NONE |
The address book number of the person assigned to do the work. | ||||
mnServiceAddressNumber_SAID | 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
| ||||
mnAddressNumberInspector_ANT | ANT | MATH_NUMERIC | OPT | NONE |
The address book number of the inspector. | ||||
mnNextAddressNumber_NAN8 | NAN8 | MATH_NUMERIC | OPT | NONE |
An eight-position number used to identify each entry in the Address Book,e.g., employees, customers, suppliers, special mailing
| ||||
jdDateTransactionJulian_TRDJ | TRDJ | JDEDATE | OPT | NONE |
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing. | ||||
jdDateStart_STRT | STRT | JDEDATE | OPT | NONE |
The start date for the order. You can enter this date manually, or have the system calculate it using a backscheduling routine. The routine
| ||||
jdDateRequestedJulian_DRQJ | DRQJ | JDEDATE | OPT | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
jdDateWoPlanCompleted_DPL | DPL | JDEDATE | OPT | NONE |
The date that the work order or engineering change order is planned to be completed. | ||||
jdDateCompletion_STRX | STRX | JDEDATE | OPT | NONE |
The date that the work order or engineering change order is completed or canceled. | ||||
jdDateAssignedTo_DAP | DAP | JDEDATE | OPT | NONE |
The date the person responsible for the work order receives the work order. | ||||
jdDateAssignToInspector_DAT | DAT | JDEDATE | OPT | NONE |
The date that the system sends the engineering change order notice to the inspector in the review process. | ||||
jdDateScheduledTickler_TDT | TDT | JDEDATE | OPT | NONE |
The date that you want to receive a reminder message about an asset. | ||||
mnBeginningHhMmSs_PBTM | PBTM | MATH_NUMERIC | OPT | NONE |
A field that is used to enter the beginning time of the operation sequence for the work center operation on the routing. | ||||
szCategoriesWorkOrder001_WR01 | WR01 | char | OPT | NONE |
A user defined code (00/W1) that indicates the current stage or phase of development for a work order. You can assign a work order to only
| ||||
szCategoriesWorkOrder002_WR02 | WR02 | char | OPT | NONE |
A user defined code (00/W2) that indicates the type or category of a work order.
Note: A processing option for some forms lets you enter a
| ||||
szCategoriesWorkOrder003_WR03 | WR03 | char | OPT | NONE |
A user defined code (00/W3) that indicates the type or category of the work order.
Note: A processing option for some forms allows you to
| ||||
szCategoriesWorkOrder004_WR04 | WR04 | char | OPT | NONE |
A user defined code (00/W4) that indicates the type or category of the work order. | ||||
szCategoriesWorkOrder005_WR05 | WR05 | char | OPT | NONE |
A user defined code (00/W5) that indicates the type or category of the work order. | ||||
szCategoriesWorkOrder006_WR06 | WR06 | char | OPT | NONE |
A user defined code (00/W6) that indicates the status of the work order. | ||||
szCategoriesWorkOrder007_WR07 | WR07 | char | OPT | NONE |
A user defined code (00/W7) that indicates the service type for the work order. | ||||
szCategoriesWorkOrder008_WR08 | WR08 | char | OPT | NONE |
A user defined code (00/W8) that indicates the type or category of the work order. | ||||
szCategoriesWorkOrder009_WR09 | WR09 | char | OPT | NONE |
A user defined code (00/W9) that indicates the type or category of the work order. | ||||
szCategoriesWorkOrder010_WR10 | WR10 | char | OPT | NONE |
A user defined code (00/W0) that indicates the type or category of the work order. | ||||
mnAmountOriginalDollars_AMTO | AMTO | MATH_NUMERIC | OPT | NONE |
The estimated monetary amount that is budgeted for this work order. | ||||
mnHoursOriginal_HRSO | HRSO | MATH_NUMERIC | OPT | NONE |
The estimated hours that are budgeted for this work order. | ||||
mnAmountEstimatedLabor_AMLC | AMLC | MATH_NUMERIC | OPT | NONE |
This is the estimated labor cost of a work order. | ||||
mnAmountEstimatedMaterial_AMMC | AMMC | MATH_NUMERIC | OPT | NONE |
This is the estimated material cost of a work order. | ||||
mnAmountEstimatedOther_AMOT | AMOT | MATH_NUMERIC | OPT | NONE |
Amount - Estimated Other. | ||||
mnEstimatedDowntimeHours_ESDN | ESDN | MATH_NUMERIC | OPT | NONE |
This is the estimated duration of a work order. It defines how long the piece of equipment will be down in order to complete the work order,
| ||||
mnAmountActual_AMTA | AMTA | MATH_NUMERIC | OPT | NONE |
The actual dollars accumulated for the work order. | ||||
mnHoursActual_HRSA | HRSA | MATH_NUMERIC | OPT | NONE |
The actual hours accumulated for the work order. | ||||
mnAmountActualLabor_LBAM | LBAM | MATH_NUMERIC | OPT | NONE |
The actual cost of labor that is associated with a task. | ||||
mnAmountActualMaterial_MTAM | MTAM | MATH_NUMERIC | OPT | NONE |
The actual cost of materials that is associated with a task. | ||||
mnActualDowntimeHours_ADCN | ACDN | MATH_NUMERIC | OPT | NONE |
This is the actual duration of a work order. It defines how long the piece of equipment was down in order to complete the work order, which
| ||||
mnIdentifierShortItem_ITM | ITM | MATH_NUMERIC | OPT | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
szTypeBill_TBM | TBM | char | OPT | NONE |
A user defined code (40/TB) that designates the type of bill of material. You can define different types of bills of material for different uses.
| ||||
szTypeRouting_TRT | TRT | char | OPT | NONE |
A user defined code (40/TR) that indicates the type of routing. You can define different types of routing instructions for different uses.
For
| ||||
mnAssetItemNumber_NUMB | NUMB | MATH_NUMERIC | OPT | NONE |
An 8-digit number that uniquely identifies an asset. | ||||
mnParentNumber_AAID | AAID | MATH_NUMERIC | OPT | NONE |
A parent number groups related components together. You can associate each item of property and piece of equipment with a parent item.
| ||||
mnUnitsTransactionQty_UORG | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
szMessageNo_SHNO | SHNO | char | OPT | NONE |
A generic rates and message code (48/SN) that is assigned to a standard note, message, or general narrative explanation. You can use
| ||||
cWoFlashMessage_SPRT | SPRT | char | OPT | NONE |
A user defined code (00/WM) that indicates a change in the status of a work order. The system indicates a changed work order with an
| ||||
mnPercentComplete_PC | PC | MATH_NUMERIC | OPT | NONE |
A measurement that identifies the progress being made on an item such as an account, work order, and so on. It is not always a calculated
| ||||
szReference1_VR01 | VR01 | char | OPT | NONE |
An alphanumeric value used as a cross-reference or secondary reference number. Typically, this is the customer number, supplier
| ||||
szApprovalType_APRT | APRT | char | OPT | NONE |
A user defined code (system 48, type AP) indicating the type of work order approval path that a work order follows. You can use processing
| ||||
cSubledgerInactiveCode_SBLI | SBLI | char | OPT | NONE |
An option that indicates whether a specific subledger is inactive. Examples of inactive subledgers are jobs that are closed, employees
| ||||
szF4801UserId_USER | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
szF4801ProgramId_PID | 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
| ||||
szF4801WorkStationId_JOBN | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
jdF4801DateUpdated_UPMJ | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. | ||||
mnF4801TimeOfDay_TDAY | TDAY | MATH_NUMERIC | OPT | NONE |
The computer clock in hours:minutes:seconds. | ||||
mnPegToWorkOrder_PTWO | PTWO | MATH_NUMERIC | OPT | NONE |
Case number related to the service work order. | ||||
szReference2Vendor_VR02 | 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
| ||||
szUnitOfMeasure_UOM | UOM | char | OPT | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
szISSUE_ISSUE | ISSUE | char | OPT | NONE |
A description of the customer issue. | ||||
szProductModel_PRODM | 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. | ||||
szContactName2_WHO2 | WHO2 | char | OPT | NONE |
The name of the caller, customer, or other contact. | ||||
szPhoneAreaCode1_AR1 | AR1 | char | OPT | NONE |
The first segment of a telephone number. In the United States, the prefix is the three-digit area code. | ||||
szPhoneNumberOne_PHN1 | PHN1 | char | OPT | NONE |
mnTimeCompleted_TMCO | TMCO | MATH_NUMERIC | OPT | NONE |
The time the task was completed. | ||||
cSecondCall_SCALL | SCALL | char | OPT | NONE |
A code that specifies multiple callbacks for a maintenance request. Enter a value from UDC 17/CB. | ||||
cMethodofPricing_MTHPR | 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
| ||||
szEntitlementCheck_ENTCK | 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
| ||||
cPaymentInstrumentA_RYIN | RYIN | char | OPT | NONE |
The user defined code (00/PY) that specifies how payments are made by the customer. For example:
C
Check
D
Draft
T
Electronic funds
| ||||
mnResponseTime_RSTM | RSTM | MATH_NUMERIC | OPT | NONE |
The guaranteed time during which service will be completed, as provided by a service contract, from the time that a provider logs a
| ||||
szCountry_CTR | CTR | char | OPT | NONE |
A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion.
The Address Book system
| ||||
szGeographicRegion_REGION | REGION | char | OPT | NONE |
The geographic region of the customer. | ||||
szTaxArea1_TXA1 | TXA1 | char | OPT | NONE |
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
| ||||
szTaxExplanationCode1_EXR1 | EXR1 | char | OPT | NONE |
A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The
| ||||
szLanguagePreference_LNGP | LNGP | char | OPT | NONE |
A user defined code (01/LP) that specifies the language to use on forms and printed reports. Before you specify a language, a code for that
| ||||
szGLCategoryCovered_GLCCV | 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
| ||||
szGLCategoryNonCovered_GLCNC | 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
| ||||
mnIssueNumber_ISNO | ISNO | MATH_NUMERIC | OPT | NONE |
A number that identifies a customer issue. | ||||
szCoverageGroup_COVGR | COVGR | char | OPT | NONE |
A user defined code that specifies the Coverage Group. The Coverage Group consists of unlimited cost codes and the percentage
| ||||
szPriceAdjSchedFour_ASN4 | 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
| ||||
szPriceAdjSchedService_ASN2 | 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
| ||||
mnTimeScheduledStart_SEST | SEST | MATH_NUMERIC | OPT | NONE |
The time of day that an activity is scheduled to begin. The start time is calculated by the constraints based planning system. | ||||
mnTimeScheduledEnd_SEET | SEET | MATH_NUMERIC | OPT | NONE |
The time of day that an activity is scheduled to end. The end time is calculated by the constraints-based planning system. | ||||
szDaylightSavingsRule_DSAVNAME | DSAVNAME | char | OPT | NONE |
Unique name identifying a daylight savings rule. Use daylight savings rules to adjust time for a geographic and political locale. | ||||
szTimeZones_TIMEZONES | TIMEZONES | char | OPT | NONE |
Choose the time zone for which you want to view the date and time. | ||||
mnCausalPart_CSLPRT | CSLPRT | MATH_NUMERIC | OPT | NONE |
The item number that indicates which part failed and caused the equipment failure. | ||||
szDefectCode_FAILCD | FAILCD | char | OPT | NONE |
A user defined code (17/FC) that indicates the type of defect. | ||||
mnAssessorNumber_AN8AS | AN8AS | MATH_NUMERIC | OPT | NONE |
The address book number that identifies the assessor. | ||||
mnSupplierRecMgr_AN8SRM | AN8SRM | MATH_NUMERIC | OPT | NONE |
The address book number that identifies the supplier recovery manager. | ||||
jdFailureDate_FAILDT | FAILDT | JDEDATE | OPT | NONE |
The date of the equipment failure. | ||||
mnFailureTime_FAILTM | FAILTM | MATH_NUMERIC | OPT | NONE |
The time of the equipment failure. | ||||
jdRepairDate_REPDT | REPDT | JDEDATE | OPT | NONE |
The date that the equipment was repaired. | ||||
mnRepairTime_REPTM | REPTM | MATH_NUMERIC | OPT | NONE |
The time that the equipment was repaired. | ||||
mnPrimaryLastVendorNo_VEND | VEND | MATH_NUMERIC | OPT | NONE |
The address book number of the preferred provider of this item. | ||||
szProductFamily_PRODF | 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. | ||||
cReimbursementMethod_RMTHD | RMTHD | char | OPT | NONE |
An option that specifies how a dealer is reimbursed for a claim or how a claim is paid by a supplier. For example, dealers can request
| ||||
cEligibleSupplierRecovery_SRYN | SRYN | char | OPT | NONE |
A code that specifies whether a work order or a warranty claim is eligible as a source for a supplier recovery claim. | ||||
szCurrencyCodeTo_CRDC | CRDC | char | OPT | NONE |
A code that identifies the domestic (base) currency of the company on a transaction. | ||||
szCurrencyCodeFrom_CRCD | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
cCurrencyMode_CRRM | CRRM | char | OPT | NONE |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
| ||||
mnCurrencyConverRateOv_CRR | CRR | MATH_NUMERIC | OPT | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
szEntitlementCheckSup_ENTCKS | ENTCKS | char | OPT | NONE |
For future use. | ||||
szCompCodeGrpSys_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
| ||||
szCompCodeSysAssembly_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
| ||||
szCompCodeSysAssembly_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
| ||||
mnCurrentBalMeter1_CURBALM1 | CURBALM1 | MATH_NUMERIC | OPT | NONE |
The current balance of meter 1. | ||||
mnCurrentBalMeter2_CURBALM2 | CURBALM2 | MATH_NUMERIC | OPT | NONE |
The current balance of meter 2. | ||||
mnCurrentBalMeter3_CURBALM3 | CURBALM3 | MATH_NUMERIC | OPT | NONE |
The current balance that appears on meter 3. | ||||
szVendorLotNumber_RLOT | RLOT | char | OPT | NONE |
The supplier's lot number for the item. | ||||
szCostCenterCsl_MCUCSL | MCUCSL | char | OPT | NONE |
The business unit that is related to the causal portion of the claim. | ||||
szCreatedByUser_CRTU | CRTU | char | OPT | NONE |
The address book number of the user who created this record. | ||||
mnContractNumber_DOC | DOC | MATH_NUMERIC | OPT | NONE |
A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document
| ||||
szContractType_DCT | DCT | char | OPT | NONE |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
szContractCompanyKey_KCO | KCO | char | OPT | NONE |
A number that, with the document number, document type and G/L date, uniquely identifies an original document, such as invoice, voucher,
| ||||
szContractChangeNum_COCH | COCH | char | OPT | NONE |
The change number of the contract. The change order number of the base contract is always initialized to 000. Each time you enter a
| ||||
mnContractLineNumber_LNID | LNID | MATH_NUMERIC | OPT | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
|
None |
None |