Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
cActionCode | ACTN | char | OPT | NONE |
^ |
cUpdateMasterFile | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
cProcessEdits | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
cSuppressErrorMessages | 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
runtime error message handling.
1 = suppress runtime error message handling. |
szErrorMessageID | DTA1 | char | OPT | NONE |
A 256 byte field used to hold miscellaneous data. |
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
processing option values and data selection and sequencing options. Interactive versions are associated with applications (usually as a
menu selection). Batch versions are associated with batch jobs or reports. To run a batch process, you must choose a version. |
mnSameAsExcept | 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
location.
|
mnAddressBookNumber | 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
location.
|
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
address book record. If you enter a value other than the address book number (AN8), such as the long address or tax ID, you must precede
it with the special character that is defined in the Address Book constants. When the system locates the record, it returns the address book
number to the field.
For example, if address book number 4100 (Total Solutions) has a long address TOTAL and an * distinguishes it from
other entries (as defined in the Address Book constants), you could type *TOTAL into the field, and the system would return 4100.
|
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
number, and so on. The system verifies the number and prints the separators in their correct format, according to the value of TAXC
(Person/Corporation Code). If no value exists for TAXC, the system uses the Corporate Entity.
Attention Accounts Payable users: The Supplier Master
record supplies the default value for the tax ID for 1099 processing. |
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
V
Suppliers
C
Customers
P
Prospects
M
Mail distribution lists
TAX
Tax authorities |
szAlphaName | 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
dashes, commas, and other special characters, but the system cannot search on them when you use this field to search for a name. |
szSecondaryAlphaName | ALP1 | char | OPT | NONE |
An alternate name field in the Address Book system to accommodate double-byte coding. |
szMailingName | MLNM | char | OPT | NONE |
The company or person to whom billing or correspondence is addressed. |
szSecondaryMailingName | MLN1 | char | OPT | NONE |
An alternate mailing name field in the Address Book system to accomodate double-byte coding. |
szDescriptionCompressed | DC | char | OPT | NONE |
The compressed description contains the alpha name without slashes, dashes, commas, and other special characters. The compressed
description is the field used in the Name Search.
|
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
might be a warehouse location, job, project, work center, branch, or plant.
You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department.
Business unit security might prevent you from viewing information about business units
for which you have no authority.
|
szAddressLine1 | ADD1 | char | OPT | NONE |
The first line of a mailing address for an employee, customer, or supplier in the Address Book system. The U.S. Internal Revenue Service
(IRS) restricts the size of the address that prints on an employee's year-end tax return. To comply with IRS regulations, the system has the
following restrictions:
o On W-2 returns, the system prints only the last three nonblank address lines plus the city, state, and postal code.
o On
1099 returns, the system prints only the last nonblank address line plus the city, state, and postal code.
o On other U.S. federal magnetic
media, the system prints only the last nonblank address line plus the city, state, and postal code.
|
szAddressLine2 | ADD2 | char | OPT | NONE |
The second line of the mailing address for an employee, customer, or supplier in the Address Book system.
Attention Payroll users: The
Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the
address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that
prints on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using
the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state,
and postal code. |
szAddressLine3 | ADD3 | char | OPT | NONE |
The third line of the mailing address for an employee, customer, or supplier in the Address Book system.
Attention Payroll users: The
Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the
address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that prints
on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using
the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state, and
postal code. |
szAddressLine4 | ADD4 | char | OPT | NONE |
The fourth line of the mailing address for an employee, customer, or supplier in the Address Book system.
Attention Payroll users: The
Internal Revenue Service (IRS) restricts the size of the address that prints on employee's year-end forms. To comply with IRS regulations, the
address that prints on W-2 forms includes only the last three nonblank address lines plus the city, state, and postal code. The address that
prints on 1099 forms includes only the last nonblank address line plus the city, state, and postal code. If you process year-end information using
the federal magnetic media format, the address that prints on those forms contains only the last nonblank address line plus the city, state, and
postal code. |
szPostalCode | ADDZ | char | OPT | NONE |
The United States ZIP code or the postal code that specifies where a letter is to be routed. Attach this code to the address for delivery in
other countries. This code is used as the low end value when doing Postal Code Transaction range processing. |
szCity | CTY1 | char | OPT | NONE |
A name that indicates the city associated with the address. |
szCounty | COUN | char | OPT | NONE |
The name of a county, parish, or other political district that is necessary for the address or for tax purposes. |
szState | ADDS | char | OPT | NONE |
A user defined code (00/S) that specifies the state or province. This code is usually a postal service abbreviation. |
szCountry | 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
uses the country code for data selection and address formatting. |
szCarrierRoute | CRTE | char | OPT | NONE |
This field is used to indicate the Carrier Route for the U.S. Postal Service and is reserved for future use. |
szBulkMailingCenter | BKML | char | OPT | NONE |
This field is used to indicate the Bulk Mailing Center for the U.S. Postal System and is reserved for future use. |
szPrefix1 | 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
use any applicable telephone number format for a country. This field is used in conjunction with the Prefix field (AR1), where you enter the first
segment of the telephone number, which is called the area code in the United States.
When you search for an address using a phone
number, you must enter the number exactly as it is set up in the Address Book system, including any special characters.
|
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
number
FAX
Fax telephone number
HOM
Home telephone number
|
szPhoneAreaCode2 | AR1 | char | OPT | NONE |
The first segment of a telephone number. In the United States, the prefix is the three-digit area code.
|
szPhoneNumber2 | 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
use any applicable telephone number format for a country. This field is used in conjunction with the Prefix field (AR1), where you enter the first
segment of the telephone number, which is called the area code in the United States.
When you search for an address using a phone
number, you must enter the number exactly as it is set up in the Address Book system, including any special characters.
|
szPhoneNumberType2 | 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
number
FAX
Fax telephone number
HOM
Home telephone number
|
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
supplier master record appears automatically after you add an address.
N
No, this is not a supplier. This code does not prevent you from entering
a voucher for the address.
M
This is a miscellaneous, one-time supplier. This code does not prevent you from entering multiple vouchers for
the address.
F
This is a supplier with a foreign address. The IRS requires U.S. companies to identify suppliers with foreign addresses for
1099 reporting.
You should assign tax authorities as suppliers. This allows tax payments to be made to tax authorities.
Code N is informational
only unless you set a processing option. In this case, a warning message appears if both the Payables and Receivables fields are N.
|
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.
|
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
employee
Off
The address number does not represent an employee
This code is for information only. It has no predetermined use in the
Address Book system.
|
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
your business. No predefined definitions exist for this option.
|
cARAPNettingY | 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
used
Off
AR/AP netting cannot be used
|
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
who have been terminated, or assets that have been disposed. Turn on this option to indicate that a subledger is inactive. If a subledger
becomes active again, turn off this option. If you want to use subledger information in the tables for reports, but you want to prevent transactions
from posting to the record in the Account Balances table (F0902), turn on this option. Valid values are:
Off
Subledger active
On
Subledger inactive
|
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
with a code of P or N.
Valid values for U.S. entities are:
Blank or C
Corporate entity (the Tax ID prints as 12-3456789)
P
Individual (the Tax ID
prints as 123-45-6789)
N
Noncorporate entity (the Tax ID prints as 12-3456789)
Valid values for non-U.S. entities are:
1
Individual
2
Corporate
entity
3
Both an individual and a corporate entity
4
Noncorporate entity
5
Customs authority
|
szCertificate | TXCT | char | OPT | NONE |
The number that tax authorities issue to tax-exempt individuals and companies to identify their tax-exempt status.
|
szAddlIndTaxID | TX2 | char | OPT | NONE |
An identification number assigned by a tax authority to an individual, in addition to the primary Tax ID number (TX1). |
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
limit
2
Requires purchase order
3
Not on contract maintenance agreement
The credit message displays on inquiry and transaction entry forms in the
Accounts Payable, Sales Order Management, and Procurement systems. The system displays the temporary credit message in the Accounts
Receivable system.
|
szLanguage | 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
language must exist at either the system level or in your user preferences. |
szIndustryClassification | 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:
o Standard Industrial Classification (SIC) or North American Industry Classification
System
(NAICS). A numerical system used in the United States to classify goods
and services. This code is four (SIC) or six (NAICS) digits.
o Harmonized System (HS). The international method of classifying
goods.
More than fifty countries use this code. It can be up to 10 digits.
o Standard Industrial Trade
Classification (SITC). A numerical code
system developed by the United Nations to classify goods used in
international trade.
International organizations use this code. It can
be up to six digits.
|
cEMail | AB3 | char | OPT | NONE |
Future.
|
mn1stAddressNumber | 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
primary address. For example:
o Salesperson
o Law firm
o Accountant
o Securities agent
o Bonding agent
If you leave this field blank
on an entry form, the system supplies the primary address from the Address Number field. |
mn2ndAddressNumber | 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
primary address. For example:
o Ship-to address
o Law firm
o CPA
o Securities agent
o Bonding agent
If you leave this field blank on
an entry screen, the system supplies the primary address from the Address Number field. |
mn3rdAddressNumber | 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
primary address. For example:
Ship-to address Law firm CPA Securities agent Bonding agent
If you leave this field blank on an entry screen,
the system supplies the primary address from the Address Number field. |
mn4thAddressNumber | 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
primary address. For example:
Ship-to address Law firm CPA Securities agent Bonding agent
If you leave this field blank on an entry screen,
the system supplies the primary address from the Address Number field. |
mn5thAddressNumber | 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:
Ship-to address Law firm Accountant Securities agent Bonding agent
If you leave this field blank on an entry screen, the system supplies
the primary address from the Address Number field. |
mnFactorSpecialPayee | 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
Master table (F0101) for validation purposes. If you leave this field blank on an entry form, the system supplies the primary address from the
Address Number field.
|
mnParentNumber | 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
or location. Any value that you enter in this field updates the Address Organizational Structure Master table (F0150) for the blank structure
type. This address number must exist in the Address Book Master table (F0101) for validation purposes. Examples of address book records
that would have a parent number include:
o Subsidiaries with parent companies
o Branches with a home office
o Job sites with a general
contractor
|
cAddressType3YN | 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
Book Master Business Function synchronizes values in the Name and Tax ID fields in both the Address Book and Workforce Management
systems when the value is Y. Valid values are:
Y
The record has a corresponding record in the Workforce Management tables.
N
The record
does not have a corresponding record in the Workforce Management tables.
|
cAddressType4YN | AT4 | char | OPT | NONE |
Reserved by J.D. Edwards.
|
cAddressType5YN | AT5 | char | OPT | NONE |
Reserved by J.D. Edwards.
|
szCategoryCode01 | 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
records for reports, mailings, and so on. Category codes are user defined (system 01, types 01 through 30). Examples of category codes
include:
Category code 01
Location or Branch
Category code 02
Salesperson
Category code 03
Product
Category code 04
Credit officer |
szAccountRepresentative | 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
reports, mailings, and so on. Category codes are user-defined (system 01, types 01 through 30).
Examples:
Category code 01 - Location or
Branch
Category code 02 - Account Representative
Category code 03 - New tenant
Category code 04 - Credit officer |
szCategoryCode03 | 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
reports, mailings, and so on. Category codes are user-defined (system 01, types 01 through 30).
Examples:
Category code 01 - Location or
Branch
Category code 02 - Salesperson
Category code 03 - New tenant
Category code 04 - Credit officer |
szGeographicRegion | 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
reports, mailings, and so on. Category codes are user-defined (system 01, types 01 through 30).
Examples:
Category code 01 - Location or
Branch
Category code 02 - Salesperson
Category code 03 - New tenant
Category code 04 - Credit officer |
szCategoryCode05 | 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
reports, mailings, and so on. Category codes are user-defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szCategoryCode06 | 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
reports, mailings, and so on. Category codes are user-defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
sz1099Reporting | 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
identify the box on the 1099 form in which a voucher or pay item should be reported. Examples include:
01
Rents
13
Nontaxable
distributions
61
Interest income
A7
Nonemployee compensation
|
szCategoryCode08 | 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
reports, mailings, and so on. Category codes are user defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szCategoryCode09 | 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
reports, mailings, and so on. Category codes are user defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szCategoryCode10 | 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
reports, mailings, and so on. Category codes are user defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szSalesRegion | 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
reports, mailings, and so on. Category codes are user defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szCategoryCode12 | 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
reports, mailings, and so on. Category codes are user defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szLineOfBusiness | 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
reports, mailings, and so on. Category codes are user defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szSalesVolume | 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
reports, mailings, and so on. Category codes are user defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szCategoryCode15 | 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
reports, mailings, and so on. Category codes are user defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szCategoryCode16 | 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
reports, mailings, and so on. Category codes are user-defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szCategoryCode17 | 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
reports, mailings, and so on. Category codes are user-defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szCategoryCode18 | 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
reports, mailings, and so on. Category codes are user-defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szCategoryCode19 | 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
reports, mailings, and so on. Category codes are user-defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szCategoryCode20 | 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
reports, mailings, and so on. Category codes are user defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szCategoryCode21 | 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
reports, mailings, and so on. Category codes are user defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szCategoryCode22 | 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
reports, mailings, and so on. Category codes are user defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szCategoryCode23 | 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
reports, mailings, and so on. Category codes are user defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szCategoryCode24 | 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
reports, mailings, and so on. Category codes are user defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szCategoryCode25 | 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
reports, mailings, and so on. Category codes are user defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szCategoryCode26 | 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
reports, mailings, and so on. Category codes are user defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szCategoryCode27 | 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
reports, mailings, and so on. Category codes are user defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szCategoryCode28 | 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
reports, mailings, and so on. Category codes are user defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szCategoryCode29 | 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
reports, mailings, and so on. Category codes are user defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szCategoryCode30 | 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
reports, mailings, and so on. Category codes are user defined (system 01, types 01 through 30).
Examples:
Category code 01 Location
or Branch
Category code 02 Salesperson
Category code 03 New tenant
Category code 04 Credit officer |
szGlBankAccount | GLBA | char | OPT | NONE |
The number of the bank account (general ledger account) to be updated automatically when receipts or disbursements are entered. The
bank account number is assumed to be the same for every document in a batch. Therefore, it is not cleared from entry to entry. However, if
you leave the bank account number blank, the system retrieves a default bank account number from the Automatic Accounting Instructions file
(F0012), item number RB for Accounts Receivable and PB for Accounts Payable. |
mnTimeScheduledIn | PTI | MATH_NUMERIC | OPT | NONE |
The specific time you are scheduled to return. The time must be entered in HH.MM format where
HH hours
MM minutes.
If you do not
enter a time, this field remains blank. |
jdDateScheduledIn | PDI | JDEDATE | OPT | NONE |
The date you are scheduled to return. If this field is left blank, today's date is inserted. The date must be entered in MM/DD/YY format
where:
MM month
DD day
YY year |
cClearedY | MSGA | char | OPT | NONE |
A code to indicate which messages should be displayed.
A Y code will display all messages, including those that have been cleared or
processed, but not those already deleted.
Any value other than Y will display current messages only. |
szRemark | RMK | char | OPT | NONE |
A generic field that you use for a remark, description, name, or address.
|
szUserReservedCode | 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 | 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. |
mnUserReservedAmount | 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. |
mnUserReservedNumber | 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. |
szUserReservedReference | 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.
|
jdDateEffective | EFTB | JDEDATE | OPT | NONE |
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program.
For example, the effective date could represent the following:
o When a change of address becomes effective.
o When a lease becomes
effective.
o When a price becomes effective.
o When the currency exchange rate becomes effective.
o When a tax rate becomes effective.
|
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
interactive program is P4210, and the number of the Print Invoices batch process report is R42565.
The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where:
T
The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program.
SS
The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system.
XXX
The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.
|
szRemark1 | REM1 | char | OPT | NONE |
A 40-character field that you can use to enter text. |
mnAddNumParentOriginal | 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
or location. Any value that you enter in this field updates the Address Organizational Structure Master table (F0150) for the blank structure
type. This address number must exist in the Address Book Master table (F0101) for validation purposes. Examples of address book records
that would have a parent number include:
o Subsidiaries with parent companies
o Branches with a home office
o Job sites with a general
contractor
|
OKToDelete | MATH01 | MATH_NUMERIC | OPT | NONE |
- - - Good Performance Low Value.
|
szVersionconsolidated | VER | char | OPT | NONE |
Identifies a specific set of data selection and sequencing settings for the application. Versions may be named using any combination of
alpha and numeric characters. Versions that begin with 'XJDE' or 'ZJDE' are set up by J.D. Edwards. |
cDirectionIndicator | DRIN | char | OPT | NONE |
A code that indicates whether the transaction is inbound or outbound. |
cEdiSuccessfullyProcess | EDSP | char | OPT | NONE |
An option that indicates whether a record has been successfully processed. Depending on the application, the system updates the EDSP
field in a table with one of the following values:
1
Successfully processed
Blank (or N or 0)
Not processed
|
szCountryForPayroll | CCPR | char | OPT | NONE |
A user defined code list 00/CN that indicates the country in which the employee resides. |
szShortcutClientType | SCCLTP | char | OPT | NONE |
Future use.
|
szTicker | TICKER | char | OPT | NONE |
This field contains the stock ticker symbol for the company.
|
szStockExchange | EXCHG | char | OPT | NONE |
This field indicates the exchange a stock is listed.
|
szDUNSNumber | DUNS | char | OPT | NONE |
The Dun And Bradstreet identifier used to get credit reports on companies.
|
szClassificationCode01 | CLASS01 | char | OPT | NONE |
This is a code used to classify an address book entity.
|
szClassificationCode02 | CLASS02 | char | OPT | NONE |
This is a code used to classify an address book entity.
|
szClassificationCode03 | CLASS03 | char | OPT | NONE |
This is a code used to classify an address book entity.
|
szClassificationCode04 | CLASS04 | char | OPT | NONE |
This is a code used to classify an address book entity.
|
szClassificationCode05 | CLASS05 | char | OPT | NONE |
This is a code used to classify an address book entity.
|
mnNumberOfEmployee | NOE | MATH_NUMERIC | OPT | NONE |
This field indicates the number of people employed by the customer/supplier.
|
mnGrowthRate | GROWTHR | MATH_NUMERIC | OPT | NONE |
This field indicates the growth rate of the customer.
|
szYearStarted | YEARSTAR | char | OPT | NONE |
This field indicates the year the company became a customer.
|
szEmployeeGroupApprovals | AEMPGP | char | OPT | NONE |
Employee Group only used in Approval Processing.
|
cIndicatorFlg | ACTIN | char | OPT | NONE |
Future use.
|
szRevenueRange | REVRNG | char | OPT | NONE |
Company revenue range.
|
mnABSynchStatus | SYNCS | MATH_NUMERIC | OPT | NONE |
A user defined code that indicates the post synchronization validation status of the record.
Valid Values are:
0
Success (Blank)
1
The record
is pending post synchronization Add validation on the server (PVA)
2
The record is pending post synchronization Change validation on the
server (PVC)
3
The record is in error from the post synchronization Add validation on the server (ERRA)
4
The record is in error from the post
synchronization Change validation on the server (ERRC)
5
The associated F0101 record is in error (ERRP)
6
The record is pending post
synchronization Add validation on the server and the associated F0101 record is in error (ERRPA)
7
The record is pending post synchronization
Change validation on the server and the associated F0101 record is in error (ERRPC)
|
mnABServerStatus | CAAD | MATH_NUMERIC | OPT | NONE |
A user defined code that indicates the server synchronization status of the record.
Valid values are:
0
The record has been changed on the
Server or has been processed by post synchronization validation on the Server.
1
The record has been changed on the Disconnected
Client.
2
The record has been changed on the Disconnected Client and has been synchronized to the Server. This value is set only on
Disconnected Client and any records with a value of 2 cannot be changed.
|
mnPhone1SynchStatus | SYNCS | MATH_NUMERIC | OPT | NONE |
A user defined code that indicates the post synchronization validation status of the record.
Valid Values are:
0
Success (Blank)
1
The record
is pending post synchronization Add validation on the server (PVA)
2
The record is pending post synchronization Change validation on the
server (PVC)
3
The record is in error from the post synchronization Add validation on the server (ERRA)
4
The record is in error from the post
synchronization Change validation on the server (ERRC)
5
The associated F0101 record is in error (ERRP)
6
The record is pending post
synchronization Add validation on the server and the associated F0101 record is in error (ERRPA)
7
The record is pending post synchronization
Change validation on the server and the associated F0101 record is in error (ERRPC)
|
mnPhone1ServerStatus | CAAD | MATH_NUMERIC | OPT | NONE |
A user defined code that indicates the server synchronization status of the record.
Valid values are:
0
The record has been changed on the
Server or has been processed by post synchronization validation on the Server.
1
The record has been changed on the Disconnected
Client.
2
The record has been changed on the Disconnected Client and has been synchronized to the Server. This value is set only on
Disconnected Client and any records with a value of 2 cannot be changed.
|
mnPhone2SynchStatus | SYNCS | MATH_NUMERIC | OPT | NONE |
A user defined code that indicates the post synchronization validation status of the record.
Valid Values are:
0
Success (Blank)
1
The record
is pending post synchronization Add validation on the server (PVA)
2
The record is pending post synchronization Change validation on the
server (PVC)
3
The record is in error from the post synchronization Add validation on the server (ERRA)
4
The record is in error from the post
synchronization Change validation on the server (ERRC)
5
The associated F0101 record is in error (ERRP)
6
The record is pending post
synchronization Add validation on the server and the associated F0101 record is in error (ERRPA)
7
The record is pending post synchronization
Change validation on the server and the associated F0101 record is in error (ERRPC)
|
mnPhone2ServerStatus | CAAD | MATH_NUMERIC | OPT | NONE |
A user defined code that indicates the server synchronization status of the record.
Valid values are:
0
The record has been changed on the
Server or has been processed by post synchronization validation on the Server.
1
The record has been changed on the Disconnected
Client.
2
The record has been changed on the Disconnected Client and has been synchronized to the Server. This value is set only on
Disconnected Client and any records with a value of 2 cannot be changed.
|
mnAddressSynchStatus | SYNCS | MATH_NUMERIC | OPT | NONE |
A user defined code that indicates the post synchronization validation status of the record.
Valid Values are:
0
Success (Blank)
1
The record
is pending post synchronization Add validation on the server (PVA)
2
The record is pending post synchronization Change validation on the
server (PVC)
3
The record is in error from the post synchronization Add validation on the server (ERRA)
4
The record is in error from the post
synchronization Change validation on the server (ERRC)
5
The associated F0101 record is in error (ERRP)
6
The record is pending post
synchronization Add validation on the server and the associated F0101 record is in error (ERRPA)
7
The record is pending post synchronization
Change validation on the server and the associated F0101 record is in error (ERRPC)
|
mnAddressServerStatus | CAAD | MATH_NUMERIC | OPT | NONE |
A user defined code that indicates the server synchronization status of the record.
Valid values are:
0
The record has been changed on the
Server or has been processed by post synchronization validation on the Server.
1
The record has been changed on the Disconnected
Client.
2
The record has been changed on the Disconnected Client and has been synchronized to the Server. This value is set only on
Disconnected Client and any records with a value of 2 cannot be changed.
|
mnParentAddSynchStatus | SYNCS | MATH_NUMERIC | OPT | NONE |
A user defined code that indicates the post synchronization validation status of the record.
Valid Values are:
0
Success (Blank)
1
The record
is pending post synchronization Add validation on the server (PVA)
2
The record is pending post synchronization Change validation on the
server (PVC)
3
The record is in error from the post synchronization Add validation on the server (ERRA)
4
The record is in error from the post
synchronization Change validation on the server (ERRC)
5
The associated F0101 record is in error (ERRP)
6
The record is pending post
synchronization Add validation on the server and the associated F0101 record is in error (ERRPA)
7
The record is pending post synchronization
Change validation on the server and the associated F0101 record is in error (ERRPC)
|
mnPreviousF0101ErrorStatus | PERRS | MATH_NUMERIC | OPT | NONE |
A user-defined code that indicates the previous post synchronization validation error status of the record. Values are:
0 or Blank
Success
3
The record is in error from the post synchronization Add validation on the server (ERRA).
4
The record is in error from the post synchronization
Change validation on the server (ERRC).
|
mnWhosWhoSynchStatus | SYNCS | MATH_NUMERIC | OPT | NONE |
A user defined code that indicates the post synchronization validation status of the record.
Valid Values are:
0
Success (Blank)
1
The record
is pending post synchronization Add validation on the server (PVA)
2
The record is pending post synchronization Change validation on the
server (PVC)
3
The record is in error from the post synchronization Add validation on the server (ERRA)
4
The record is in error from the post
synchronization Change validation on the server (ERRC)
5
The associated F0101 record is in error (ERRP)
6
The record is pending post
synchronization Add validation on the server and the associated F0101 record is in error (ERRPA)
7
The record is pending post synchronization
Change validation on the server and the associated F0101 record is in error (ERRPC)
|
mnWhosWhoServerStatus | CAAD | MATH_NUMERIC | OPT | NONE |
A user defined code that indicates the server synchronization status of the record.
Valid values are:
0
The record has been changed on the
Server or has been processed by post synchronization validation on the Server.
1
The record has been changed on the Disconnected
Client.
2
The record has been changed on the Disconnected Client and has been synchronized to the Server. This value is set only on
Disconnected Client and any records with a value of 2 cannot be changed.
|
cCallSalesTeamAlignment | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|