D90CA045 - Fetch Employee Record
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnAddressNumber | 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
| ||||
mnLineNumberID | IDLN | MATH_NUMERIC | OPT | NONE |
This field is used to identify the line ID number for a Who's Who record. | ||||
mnContactPersonalID | CNLN | MATH_NUMERIC | OPT | NONE |
A field that associates a who's who or contact record with a name in the Related Person table (F0112). The Related Person ID field allows a
| ||||
szRelationType | RELY | char | OPT | NONE |
A user defined code (01/RT) that indicates the relationship between the contact and a name in the Related Person table (F01112). Valid
| ||||
szRelationName | RALP | char | OPT | NONE |
The name of the person in the Related Person table (F01112) that is tied to the Who's Who record. | ||||
szOrganizationTypeStructur | OSTP | char | OPT | NONE |
A user defined code (01/TS) that identifies a type of organizational structure that has its own hierarchy in the Address Book system (for
| ||||
mnAddressNumberParent | PA8 | MATH_NUMERIC | OPT | NONE |
The address book number of the parent company. The system uses this number to associate a particular address with a parent company
| ||||
mnSequenceNumber72Display | DSS7 | MATH_NUMERIC | OPT | NONE |
A number that reorders a group of records on the form. | ||||
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
| ||||
szVersion | 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
| ||||
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
| ||||
idF90CA020PTR | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
idF90CA040PTR | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
idF0150PTR | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
idF0115PTR | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
idF01112PTR | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
idF0101PTR | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
idContactPTR | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
szPrefix | SLNM | char | OPT | NONE |
The name that you would use to address an individual in written correspondence. Examples include Ms. Green, Dr. Strasheim, Herr
| ||||
szFirstName | GNNM | char | OPT | NONE |
The first name of an individual. This field is informational only. | ||||
szLastName | SRNM | char | OPT | NONE |
The last name of an individual. This field is informational only. | ||||
szMiddleName | MDNM | char | OPT | NONE |
The middle name or initial of an individual. This field is informational only. The name does not appear on any reports. | ||||
szTitle | ATTL | char | OPT | NONE |
The professional title of a Who's Who person. | ||||
szNameNick | NICK | char | OPT | NONE |
The nickname of an individual. Nickname is linked to a who's who line of an address book number. | ||||
cGenderMaleFemale | GEND | char | OPT | NONE |
A code that indicates an individual's gender. Valid values are: Blank 1 Male 2 Female 3 Unknown | ||||
szNameAlpha | ALPH | char | OPT | NONE |
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter
| ||||
szPreferredContactMethod | PCM | char | OPT | NONE |
A user defined code (system 01, type CQ) that defines the desired contact method for the contact. Examples
| ||||
mnAgentNumber | AGTNO | MATH_NUMERIC | OPT | NONE |
cIgnoreSvcEscalationFlag | ISEF | char | OPT | NONE |
When this option is on, the employee is excluded from the Service Request escalation process. This option might be used temporarily if an
| ||||
szConcatLastFirst | DS80 | char | OPT | NONE |
A free-form text field for comments or memoranda. | ||||
mnPersonAddressNumber | PSAN8 | MATH_NUMERIC | OPT | NONE |
mnEmployeeAddressNumber | EMAN8 | MATH_NUMERIC | OPT | NONE |
The address book number (F0101) of the lead owner. | ||||
cDeptContact | DPTCNT | char | OPT | NONE |
cExecutive | EXTV | char | OPT | NONE |
szStatusCode | STSCOD | char | OPT | NONE |
szEmployeeNumber | ENUM | char | OPT | NONE |
szDepartmentCode | DPTCD | char | OPT | NONE |
This is the department in which the employee or a contact works. | ||||
utHireDate | HDATE | INVALID ITEM DATA TYPE: 55 | OPT | NONE |
utInactiveDate | INACTD | INVALID ITEM DATA TYPE: 55 | OPT | NONE |
idF0116PTR | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
idF0150BPTR | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
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
| ||||
cPTRMode | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cErrorCode | 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
| ||||
szSearchTypeDefault | AT1 | char | OPT | NONE |
A user defined code (01/ST) that specifies the kind of address book record to search for. Examples include:
E
Employees
X
Ex-employees
| ||||
szPOVersionP90CA043 | 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
| ||||
szAsstPhoneNumber | 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
| ||||
szAsstPhoneAreaCode | AR1 | char | OPT | NONE |
The first segment of a telephone number. In the United States, the prefix is the three-digit area code. | ||||
mnAsstPhoneLine | RCK7 | MATH_NUMERIC | OPT | NONE |
This field is used to create a unique key within a file. If you are using a program which will allow you to resequence the records, we
| ||||
szAsstPhoneNumberType | PHTP | char | OPT | NONE |
A user defined code (01/PH) that indicates either the location or use of a telephone number. Valid values include:
Blank
Business telephone
| ||||
szLongAddressNumber | ALKY | char | OPT | NONE |
A user-defined name or number that identifies an address book record. You can use this number to locate and enter information about the
| ||||
szNameMailing | MLNM | char | OPT | NONE |
The company or person to whom billing or correspondence is addressed. | ||||
szLanguagePreference | 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
| ||||
szSearchType | AT1 | char | OPT | NONE |
A user defined code (01/ST) that specifies the kind of address book record to search for. Examples include:
E
Employees
X
Ex-employees
| ||||
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
| ||||
szStandardIndustryCode | SIC | char | OPT | NONE |
A code that classifies goods and services. This code can be in the format of
any one of the following systems of classification:
| ||||
cPayablesYNM | ATP | char | OPT | NONE |
A code that identifies the address as a supplier. Valid values are:
Y
Yes, this is a supplier. A processing option specifies whether the
| ||||
cEmployeeYN | ATE | char | OPT | NONE |
An option that indicates whether this address number represents an employee.
Valid values are:
On
The address number represents an
| ||||
cHRMRecExist | AT3 | char | OPT | NONE |
A value that indicates whether the record has a corresponding record in the tables of the Workforce Management system. The Address
| ||||
cARAPNetting | AT2 | char | OPT | NONE |
An option that indicates whether you can use an address in the A/R and A/P netting process.
Valid values are:
On
AR/AP netting can be
| ||||
cReceivablesYN | ATR | char | OPT | NONE |
An option that identifies the address number as that of a customer. Valid settings are: On This is a customer. Off This is not a customer. | ||||
cUserCode | ATPR | char | OPT | NONE |
An option that you define in the data dictionary to reference an address. You can use this option to identify information that is pertinent to
| ||||
cSubledgerInactiveCode | SBLI | char | OPT | NONE |
An option that indicates whether a specific subledger is inactive. Examples of inactive subledgers are jobs that are closed, employees
| ||||
szCreditMessage | CM | char | OPT | NONE |
A value in the user defined code table 00/CM that indicates the credit status of a customer or supplier. Examples are:
1
Over credit
| ||||
cPersonCorporationCode | TAXC | char | OPT | NONE |
A code that designates the type of taxpayer. For 1099 reporting for U.S. suppliers and foreign suppliers, the system chooses only records
| ||||
szCertificateTaxExempt | TXCT | char | OPT | NONE |
The number that tax authorities issue to tax-exempt individuals and companies to identify their tax-exempt status. | ||||
szTaxId | TAX | char | OPT | NONE |
The identification code required by various tax authorities. This can be a social security number, federal or state corporate tax ID, sales tax
| ||||
szTaxId2 | TX2 | char | OPT | NONE |
An identification number assigned by a tax authority to an individual, in addition to the primary Tax ID number (TX1). | ||||
mnAddressNumber1st | AN81 | MATH_NUMERIC | OPT | NONE |
An alternate address number in the Address Book system. You can use this field for any secondary business address that relates to the
| ||||
mnAddressNumber2nd | AN82 | MATH_NUMERIC | OPT | NONE |
An alternate address number in the Address Book system. You can use this field for any secondary business address that relates to the
| ||||
mnAddressNumber3rd | AN83 | MATH_NUMERIC | OPT | NONE |
An alternate address number in the Address Book system. You can use this field for any secondary business address that relates to the
| ||||
mnAddressNumber4th | AN84 | MATH_NUMERIC | OPT | NONE |
An alternate address number in the Address Book system. You can use this field for any secondary business address that relates to the
| ||||
mnAddressNumber5th | AN85 | MATH_NUMERIC | OPT | NONE |
A number in the address book that identifies a special payment address for accounts payable.
This number must exist in the Address Book
| ||||
mnAddressNumber6th | AN86 | MATH_NUMERIC | OPT | NONE |
An alternate address number. You can use this field for any secondary business address that relates to the primary address. For example:
| ||||
cEmailPreference | AB3 | char | OPT | NONE |
Future. | ||||
szShortcutClientType | SCCLTP | char | OPT | NONE |
Future use. | ||||
szReportCodeAddBook001 | AC01 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to group address book
| ||||
szReportCodeAddBook002 | AC02 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook003 | AC03 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook004 | AC04 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook005 | AC05 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook006 | AC06 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook007 | AC07 | char | OPT | NONE |
One of 30 reporting codes that you can assign to an address in the Address Book system. Category Code 07 is used in the 1099 process to
| ||||
szReportCodeAddBook008 | AC08 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook009 | AC09 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook010 | AC10 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook011 | AC11 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook012 | AC12 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook013 | AC13 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook014 | AC14 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook015 | AC15 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook016 | AC16 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook017 | AC17 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook018 | AC18 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook019 | AC19 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szReportCodeAddBook020 | AC20 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szCategoryCodeAddressBook2 | AC21 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szCategoryCodeAddressBk22 | AC22 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szCategoryCodeAddressBk23 | AC23 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szCategoryCodeAddressBk24 | AC24 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szCategoryCodeAddressBk25 | AC25 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szCategoryCodeAddressBk26 | AC26 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szCategoryCodeAddressBk27 | AC27 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szCategoryCodeAddressBk28 | AC28 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szCategoryCodeAddressBk29 | AC29 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szCategoryCodeAddressBk30 | AC30 | char | OPT | NONE |
One of thirty reporting codes that you can assign to an address in the Address Book system. Use these codes to identify addresses for
| ||||
szPhoneAreaCode1 | AR1 | char | OPT | NONE |
The first segment of a telephone number. In the United States, the prefix is the three-digit area code. | ||||
szPhoneNumber1 | 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
| ||||
szPhoneNumberType1 | PHTP | char | OPT | NONE |
A user defined code (01/PH) that indicates either the location or use of a telephone number. Valid values include:
Blank
Business telephone
| ||||
szSecondaryAlphaName | ALP1 | char | OPT | NONE |
An alternate name field in the Address Book system to accommodate double-byte coding. | ||||
szSecondaryMailingName | MLN1 | char | OPT | NONE |
An alternate mailing name field in the Address Book system to accomodate double-byte coding. |
None |
None |