1.Functional Description
1.1Purpose
This NER is to fetch records from F1797 based on the address book and the information type values
passed in.
1.2Setup Notes and Prerequisites
1.3Special Logic
If record is found, set found flag = 1, else set found flag = 0.
Information TypeC = Customer P = Service Provider T = Technician Q = Queue
D1700840 - F1797 Fetch Record
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnAddressNumber_AN8 | AN8 | MATH_NUMERIC | REQ | INPUT |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
cInformationType_ITYPE | ITYPE | char | REQ | INPUT |
C = Customer extension record | ||||
szAdjSchedContracts_ASN1 | ASN1 | char | OPT | NONE |
A user defined code (system 40, type AS) identifying a price and adjustment schedule. A price and adjustment schedule contains one or
| ||||
szAdjSchedServiceOrders_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
| ||||
szAdjSchedCalls_ASN3 | ASN3 | char | OPT | NONE |
A user defined code (40/AS) that identifies a price and adjustment schedule. A price and adjustment schedule contains one or more
| ||||
szAdjSchedClaims_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
| ||||
szAdjustmentSchedule5_ASN5 | ASN5 | char | OPT | NONE |
This user defined code (40/AS) identifies a price and adjustment schedule. A price and adjustment schedule contains one or more
| ||||
mnSupervisor_ANPA | ANPA | MATH_NUMERIC | OPT | NONE |
The address book number of the supervisor. | ||||
mnDefaultDealer_AN8DL | AN8DL | MATH_NUMERIC | OPT | NONE |
The default Dealer for the Customer. | ||||
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
| ||||
szGeographicRegion_REGION | REGION | char | OPT | NONE |
The geographic region of the customer. | ||||
szStdCarrierAlphaCd_SCAC | SCAC | char | OPT | NONE |
A unique four-character code assigned to the carrier. | ||||
szShipmntTrackBus_STBF | STBF | char | OPT | NONE |
The business function which provides access to a carrier's external shipment tracking function. | ||||
cActiveInactive_ASAI | ASAI | char | OPT | NONE |
Active/Inactive | ||||
szPhoneNumber_PH1 | PH1 | char | OPT | NONE |
A number without the prefix or special characters, such as hyphens or periods, that makes up the telephone number for an entity. You can
| ||||
szMailBoxDesignator_MBDS | MBDS | char | OPT | NONE |
A field that determines the mailbox associated with the queue that should be used on delivery of the message. | ||||
szRemark_REM1 | REM1 | char | OPT | NONE |
A 40-character field that you can use to enter text. | ||||
szCostCenterHome_HMCU | HMCU | char | OPT | NONE |
The number of the business unit in which the employee generally resides. | ||||
szObjectAccount_OBJ | OBJ | char | OPT | NONE |
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
| ||||
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. | ||||
szServiceGroup_SVGRP | SVGRP | char | OPT | NONE |
An attribute of a service provider that allows the end user to group the service provider into logical groups, such as regional, type of service
| ||||
szCatCode_JC01 | JC01 | char | OPT | NONE |
User defined code associated with the team a customer issue is assigned to. | ||||
szCatCode_JC02 | JC02 | char | OPT | NONE |
User defined reporting code for assigning customer issues. | ||||
szCatCode_JC03 | JC03 | char | OPT | NONE |
User defined reporting code used when assigning customer issues. | ||||
szCatCode_JC04 | JC04 | char | OPT | NONE |
User defined reporting code used when assigning customer issues. | ||||
szCatCode_JC05 | JC05 | char | OPT | NONE |
User defined category code used when assigning customer issues. | ||||
szCatCode_JC06 | JC06 | char | OPT | NONE |
User defined category code used when assigning customer issues. | ||||
szCatCode_JC07 | JC07 | char | OPT | NONE |
User defined category codes used when assigning customer issues. | ||||
szCatCode_JC08 | JC08 | char | OPT | NONE |
User defined reporting code used when assigning customer issues. | ||||
szCatCode_JC09 | JC09 | char | OPT | NONE |
User defined reporting code used when assigning customer issues. | ||||
szCatCode_JC10 | JC10 | char | OPT | NONE |
User defined reporting code used when assigning customer issues. | ||||
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
| ||||
cServProviderPayMethod_PSYPM | PYSPM | char | OPT | NONE |
A code used to determine how to pay a service provider. Valid values are: blank Do not pay C Check R Credit their account | ||||
cPayServProviderForParts_PYPRT | 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
| ||||
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
| ||||
mnUserReservedNumber_URAB | URAB | MATH_NUMERIC | OPT | NONE |
This is a 8 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
mnUserReservedAmount_URAT | URAT | MATH_NUMERIC | OPT | NONE |
This is a 15 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
szUserReservedCode_URCD | URCD | char | OPT | NONE |
This is a 2 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
jdUserReservedDate_URDT | URDT | JDEDATE | OPT | NONE |
This is a 6 position code that is reserved for the user. JDE does not currently use this field and will not utilize this field in the future. | ||||
szUserReservedReference_URRF | URRF | char | OPT | NONE |
A 15-position reference that is reserved for the user. J.D. Edwards does not currently use this field and does not plan to use it in the future. | ||||
szCreatedByUser_CRTU | CRTU | char | OPT | NONE |
The address book number of the user who created this record. | ||||
szUserId_USER | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
szWorkStationId_JOBN | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
szProgramId_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
| ||||
jdDateUpdated_UPMJ | UPMJ | JDEDATE | OPT | NONE |
The date that specifies the last update to the file record. | ||||
mnTimeLastUpdated_UPMT | UPMT | MATH_NUMERIC | OPT | NONE |
The time that specifies when the program executed the last update to this record. | ||||
cFound | EV01 | char | OPT | NONE |
0 = Record is not found in address extension | ||||
szTimeZoes | TIMEZONES | char | OPT | NONE |
Choose the time zone for which you want to view the date and time. | ||||
szDaylightSavingsRuleName | DSAVNAME | char | OPT | NONE |
Unique name identifying a daylight savings rule. Use daylight savings rules to adjust time for a geographic and political locale. | ||||
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
|
None |
None |