Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
cBillingAddressType | BADT | char | OPT | NONE |
Code that tells the system to use this address as a Sold To address, a Ship To address, or both. Valid codes are:
X Indicates a bill to and
a ship to address
S Indicates a ship to address only
B Indicates a bill to address only |
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 |
mnTerritoryId | TERRID | MATH_NUMERIC | OPT | NONE |
This field indicates the geographic territory associated with the customer. This field, along with Industry Grouping, is used to assign a sales
team to the customer.
|
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
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
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
|
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
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
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 |
StatusUpdatedDate | STSUDT | INVALID ITEM DATA TYPE: 55 | OPT | NONE |
Status Updated Date is the date and time when a record has been updated in a table.
|
szSessionKey | SNKY | char | OPT | NONE |
Session Key is the identifier of a Sales Order Session.
|
szCompany | 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
Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany
transactions.
Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000
for transaction entries.
|
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.
|
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. |
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.
|
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. |
nCustomerDataChangedYN | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due.
|
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. |
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. |
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.
|
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.
|
jdDateAccountOpenedJulian | DAOJ | JDEDATE | OPT | NONE |
The date that the customer record was created. |
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
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
|
szAlternateAddressKey | 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.
|
szTier | TIER1 | char | OPT | NONE |
This field defines the Tier associated with the Customer. This is a subjective ranking of customer 'value'.
|
mnParentNumberOriginal | 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
|
szTicker | TICKER | char | OPT | NONE |
This field contains the stock ticker symbol for the company.
|
mnCustomerIndustryGroup | CIG | MATH_NUMERIC | OPT | NONE |
The industry grouping field is based upon the customer's SIC Code, and is used to classify their business at a higher level than the SIC
Code. This field, along with Territory, is used to assign a sales team to the customer.
|
cOverrideSalesTeamAssigment | STOF | char | OPT | NONE |
This flag controls if CRM system automatically assigns a sales team to this customer. Valid values are:
On
Override the automatic sales
team assignment process.
Off
CRM system automatically assigns a sales team to the customer.
|
cCustomerStatus | CUSTS | char | OPT | NONE |
This field indicates the customer status for CRM purposes. Valid values are:
Off or null
Active
On or 1
Inactive
|
cSpecialInstruction03 | SI03 | char | OPT | NONE |
This flag controls if CRM system automatically assigns a sales territory ID to this customer. Valid values are:
On
Override the automatic
sales territory ID assigment.
Off
CRM system automatically assigns a sales territory ID to the customer.
|
idErrorList | GENLNG | ID | OPT | OUTPUT |
General purpose ID variable. |
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.
|
szRevenueRange | REVRNG | char | OPT | NONE |
Company revenue range.
|
mnNumberOfEmployee | NOE | MATH_NUMERIC | OPT | NONE |
This field indicates the number of people employed by the customer/supplier.
|
szStockExchange | EXCHG | char | OPT | NONE |
This field indicates the exchange a stock is listed.
|
cPimSubscription | FLNW | char | OPT | NONE |
This flag is used to indicate the first time that a User subscribed to a contact. This new subscription will trigger the synchronization process
to send the contact information to Domino and Exchange, regardless of changes in the contact in PeopleSoft EnterpriseOne. Valid values
are:
0
Not New Subscription.
1
New Subscription.
|
nUserSynchable | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due.
|
szPIMGUID | CFRGUID | char | OPT | NONE |
|