D90CA140C - CRM Customer Detail Model Cache
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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:
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
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:
| ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
szPolicyName | PLYN | char | OPT | NONE |
A name that specifies the set of rules that the system uses to determine when an invoice is considered past due and to specify the action
| ||||
cAutoReceipt | ATCS | char | OPT | NONE |
An option that specifies whether a customer or company is eligible to process receipts in the Accounts Receivable system using the
| ||||
szAutoReceiptsExecutionList | ARL | char | OPT | NONE |
The name assigned to a list of algorithms that define the order in which the programs should be run. | ||||
szARClass | ARC | char | OPT | NONE |
A code that determines the A/R trade account that the system will use as the offset when you post invoices. The system concatenates the
| ||||
szCompanyKeyARModel | KCOR | char | OPT | NONE |
A number that, along with A/R Model Document Type (DTAR) and A/R Model Document Number (DCAR), uniquely identifies the model
| ||||
mnDocArDefaultJe | DCAR | MATH_NUMERIC | OPT | NONE |
A code that identifies the document number of the model journal entry to use for a particular customer. | ||||
szDocTyArDefaultJe | DTAR | char | OPT | NONE |
A code that identifies the type of model journal entry to use for a particular customer. | ||||
szCurrencyCodeFrom | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
szTaxArea1 | TXA1 | char | OPT | NONE |
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
| ||||
szTaxExplanationCode1 | EXR1 | char | OPT | NONE |
A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The
| ||||
mnAmountCreditLimit | ACL | MATH_NUMERIC | OPT | NONE |
The total amount that you allow the customer to spend on purchases before the system sends a workflow message. This value is used
| ||||
cArHoldInvoices | HDAR | char | OPT | NONE |
An option that allows you to prevent anyone from entering invoices manually. Valid values are:
On
Hold invoices. The system issues an
| ||||
szPaymentTermsAR | TRAR | char | OPT | NONE |
A code that indicates the default payment terms for a customer. Payment terms determine the due date, discount amount, and discount due
| ||||
cSendStatementToCP | STTO | char | OPT | NONE |
A code that identifies the billing address to print on statements. Valid values are:
C
Customer (AN8)
P
Parent (PA8)
R
Payor (PYR)
1
First
| ||||
cPaymentInstrumentA | RYIN | char | OPT | NONE |
The user defined code (00/PY) that specifies how payments are made by the customer. For example:
C
Check
D
Draft
T
Electronic funds
| ||||
cPrintStatementYN | STMT | char | OPT | NONE |
An option that specifies whether to print statements for the customer or company. Valid settings are:
On
Print statements.
Off
Do not print
| ||||
cSendInvoiceToCP | SITO | char | OPT | NONE |
A code that identifies the billing name and address to print on the invoice. Valid codes are:
C
Customer (AN8)
N
Do not print. The Real
| ||||
szStatementCycle | CYCN | char | OPT | NONE |
A code that allows you to group customers together for statement printing. For example, you can print statements for all customers that have
| ||||
szTempCreditMessage | TSTA | char | OPT | NONE |
A user defined code that identifies a temporary credit status. Generally, you assign the code when an account becomes past due. The
| ||||
jdDateLastCreditReview | DLC | JDEDATE | OPT | NONE |
The date on which the credit manager last examined this customer's payment record and assigned a credit status to the account. | ||||
cDelinquencyLetter | DNLT | char | OPT | NONE |
An option that specifies whether to print delinquency notices for the customer or company based on the notification instructions that are set
| ||||
szLastCreditReview | PLCR | char | OPT | NONE |
The person who completed the last credit review. The system completes this field with the user ID of the person who enters or revises the
| ||||
jdDateRecallforReview | RVDJ | JDEDATE | OPT | NONE |
The review date for the customer's credit information. | ||||
szCreditManager | CMGR | char | OPT | NONE |
The name of the credit manager responsible for approving changes to the credit limit. You must set up the credit manager in the address
| ||||
szCollectionManager | CLMG | char | OPT | NONE |
The name of the collection manager responsible for managing this customer's account. You must set up the collection manager in the
| ||||
cCollectionReport | COLL | char | OPT | NONE |
An option that specifies whether the customer's overdue invoices are eligible to appear on the collection report that you send to an external
| ||||
cApplyFinChargesYN | AFC | char | OPT | NONE |
An option to specify whether to process delinquency fees for the customer.
On
Process delinquency fees
Off
Do not process delinquency
| ||||
cAbcCodeSales | ABC1 | char | OPT | NONE |
A grade that indicates the level of sales activity for a customer or inventory item. This grade documents the 80/20 principle (80 percent of
| ||||
cAbcCodeMargin | ABC2 | char | OPT | NONE |
A code that represents an item's ranking by average investment. You can assign a code or let the system assign it. Valid codes
| ||||
cAbcCodeAverageDays | ABC3 | char | OPT | NONE |
A grade that indicates the average number of days a customer takes to pay a bill. This code documents the 80/20 principle. The possible
| ||||
jdDateFinancialStmtsonHand | FNDJ | JDEDATE | OPT | NONE |
The date that financial statements were received to evaluate a company's credit worthiness. | ||||
szDunBradstreetRating | DB | char | OPT | NONE |
The credit rating assigned by Dun and Bradstreet. | ||||
jdDateDunBradstreet | DNBJ | JDEDATE | OPT | NONE |
The date that Dun & Bradstreet ratings were available. | ||||
szTrwNumber | TRW | char | OPT | NONE |
The credit rating assigned by Experian. | ||||
jdTRWDateJ | TWDJ | JDEDATE | OPT | NONE |
The date that Experian ratings were available. | ||||
szCurrencyCodeAmounts | CRCA | char | OPT | NONE |
The currency in which amounts are stored in the address book. For example, the credit limit, invoiced this year, invoiced prior year, and so
| ||||
szPersonOpeningAcct | POPN | char | OPT | NONE |
The user ID of the person who created the customer record. The system supplies the user ID. | ||||
jdDateAccountOpenedJulian | DAOJ | JDEDATE | OPT | NONE |
The date that the customer record was created. | ||||
mnRelatedAddressNo | AN8R | MATH_NUMERIC | OPT | NONE |
Use this field to relate a ship-to address to a sold-to address or vice versa.
For example, if you enter only a ship-to address in sales order
| ||||
mnAltPayor | ARPY | MATH_NUMERIC | OPT | NONE |
A person or company other than the customer that the system assigns to the Payor field (PYR) on Customer Ledger records (F03B11) that
| ||||
mnMinimumOrderValue | MINO | MATH_NUMERIC | OPT | NONE |
Value below which an order is placed on hold. If you try to enter an order whose total is less than the minimum order value, the system
| ||||
mnMaximumOrderValue | MAXO | MATH_NUMERIC | OPT | NONE |
Value above which an order is placed on hold. If you try to enter an order whose total is more than the maximum order value, the system
| ||||
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
| ||||
szOrderTemplate | ORTP | char | OPT | NONE |
A list of items that you frequently order. The items are often grouped based on the product type, such as fuels, lubricants, and packaged
| ||||
mnDiscountTrade | TRDC | MATH_NUMERIC | OPT | NONE |
Percentage by which the system reduces the price of each item. This is the only discount that will be applied. You can override it if you
| ||||
szPrintMessage1 | INMG | char | OPT | NONE |
A user defined code that you assign to each print message. Examples of text used in messages are engineering specifications, hours of
| ||||
cExemptCreditHold | EXHD | char | OPT | NONE |
Code indicating if the customer is exempt from credit checking in the Sales Order Processing cycle. Valid codes are:
Y Sales order entry
| ||||
szHoldOrdersCode | HOLD | char | OPT | NONE |
A user defined code (42/HC) that identifies why an order is on hold. | ||||
szRouteCode | ROUT | char | OPT | NONE |
The route field is a user defined code (system 42, type RT) that represents the delivery route on which the customer resides. This field is
| ||||
szStopCode | STOP | char | OPT | NONE |
The stop code is a user defined code (system 42, type SP) that represents the stop on a delivery route. This field is one of several factors
| ||||
szZoneNumber | ZON | char | OPT | NONE |
The zone field is a user defined code (system 40, type ZN) that represents the delivery area in which the customer resides. This field is one
| ||||
mnCarrier | CARS | MATH_NUMERIC | OPT | NONE |
The address number for the preferred carrier of the item. The customer or your organization might prefer a certain carrier due to route or
| ||||
szDeliveryInstructLine1 | DEL1 | char | OPT | NONE |
One of two fields that you use to enter delivery instructions. | ||||
szDeliveryInstructLine2 | DEL2 | char | OPT | NONE |
The second of two fields that you use to enter delivery instructions. | ||||
szFreightHandlingCode | FRTH | char | OPT | NONE |
A user defined code (42/FR) designating the method by which supplier shipments are delivered. For example, the supplier could deliver to
| ||||
cApplyFreightYN | AFT | char | OPT | NONE |
An option that specifies whether the system performs freight calculations during processing. Valid values are:
On
The system performs
| ||||
cPartialShipmntsAllowY | APTS | char | OPT | NONE |
An option that indicates whether the customer accepts partial line shipments. Valid values are:
On
The customer accepts partial line
| ||||
cSubstitutesAllowedYN | SBAL | char | OPT | NONE |
Code associated with each customer specifying whether that customer will accept substitute items. Enter N to disallow or Y to allow
| ||||
cBackordersAllowedYN | BACK | char | OPT | NONE |
An option that specifies whether to allow backorders for this item. You can allow backorders by item using the Item Master (P4101) or Item
| ||||
cCustomerPORequiredYN | PORQ | char | OPT | NONE |
This field is used to indicate if the Customer Purchase Order Number field is required to be entered for the customer. This field is editted
| ||||
cPriorityProcessing | PRIO | char | OPT | NONE |
A code that tells the system to handle this customer's orders on a priority basis. Use this value to set up print pick slips so you can choose
| ||||
cAccountsReceivableCps | ARTO | char | OPT | NONE |
A code that controls the way the system conducts credit checking.
Codes are:
P Credit check based on the customer's parent number (P
| ||||
mnInvoiceCopies | INVC | MATH_NUMERIC | OPT | NONE |
The number of invoice copies required by the customer. The system prints the number of invoices specified in this field. The system
| ||||
cInvoiceConsolidation | ICON | char | OPT | NONE |
Code that tells the system whether a customer wants consolidated invoices.
Valid codes are:
Y Customer wants consolidation.
N
| ||||
cPricePickListYN | PLST | char | OPT | NONE |
An option that indicates whether price information appears on the customer's pick list, purchase order, or sales order. Valid values
| ||||
szUnitOfMeasureWhtDisp | WUMD | char | OPT | NONE |
A user defined code (00/UM) that identifies which unit of measure the system should use to display the weight of individual order lines and
| ||||
szUnitOfMeasureVolDisp | VUMD | char | OPT | NONE |
A user defined code (00/UM) that identifies the unit of measure that the system uses to display volume for this branch/plant. The system
| ||||
cDeliveryNote | EDF1 | char | OPT | NONE |
An option that specifies whether the system prints delivery notes for this customer on the invoice. Valid settings are:
On
The system prints
| ||||
cItemRestrictions | EDF2 | char | OPT | NONE |
A code that designates whether restrictions have been placed on the sale of items to this customer.
Valid values are:
Blank No restrictions.
| ||||
cSpecialInstruction02 | SI02 | char | OPT | NONE |
This code indicates that the system should print a Certificate of Analysis for the customer. The valid values are:
Y Allows the printing of the
| ||||
szPriceAdjustmentScheduleN | ASN | 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
| ||||
cPrintAdjustmentsonInvoic | DSPA | char | OPT | NONE |
Use this field to control whether the system should print the price adjustment details on the customer's sales invoice. This field is only
| ||||
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
| ||||
szGroupCustomerPriceGp | CPGP | char | OPT | NONE |
A user defined code (40/PC) that identifies a customer group. You can group customers with similar characteristics, such as comparable
| ||||
mnCustomerNumber | 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
| ||||
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
| ||||
szAcctNoInputMode | ANI | char | OPT | NONE |
A value that identifies an account in the general ledger. Use one of the following formats to enter account numbers:
o Standard account
| ||||
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
| ||||
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). | ||||
szBuyingSegmentCode | BSC | char | OPT | NONE |
A value that groups customers with similar buying habits. | ||||
cBypassAuditLogging | BYAL | char | OPT | NONE |
An option that specifies whether to bypass the audit logging process for sales order changes. | ||||
szOPBusinessObjective | OPBO | char | OPT | NONE |
A value that specifies a default business objective to send outbound to order promising before an order has been promised. A business
| ||||
ShortName | SNAME | char | OPT | NONE |
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
| ||||
mnCustomerAddressNumber | CUAN8 | MATH_NUMERIC | OPT | NONE |
Unique identifier for customer address. | ||||
StatusType | STTYPE | char | OPT | NONE |
mnEnteredBy | ENTDBY | MATH_NUMERIC | OPT | NONE |
Unique identifier to identify user who entered record. | ||||
mnModBy | MODB | MATH_NUMERIC | OPT | NONE |
An identifier that shows the record was modified. | ||||
DateEntered | EDATE | INVALID ITEM DATA TYPE: 55 | OPT | NONE |
Displays the system date on the day the forecast was created. | ||||
DateMod | MDATE | INVALID ITEM DATA TYPE: 55 | OPT | NONE |
The system date when the record was modified. | ||||
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. | ||||
ExtVarchar0 | EXVAR0 | char | OPT | NONE |
Reserved - User Defined - This is a Text String is reserved for the user. PeopleSoft does not currently use this field and will not utilize this
| ||||
ExtVarchar1 | EXVAR1 | char | OPT | NONE |
Reserved - User Defined - This is a Text String is reserved for the user. PeopleSoft does not currently use this field and will not utilize this
| ||||
ExtVarchar2 | EXVAR2 | char | OPT | NONE |
Reserved - User Defined - This is a Text String is reserved for the user. PeopleSoft does not currently use this field and will not utilize this
| ||||
ExtVarchar3 | EXVAR3 | char | OPT | NONE |
Reserved - User Defined - This is a Text String is reserved for the user. PeopleSoft does not currently use this field and will not utilize this
| ||||
ExtVarchar4 | EXVAR4 | char | OPT | NONE |
Reserved - User Defined - This is a Text String is reserved for the user. PeopleSoft does not currently use this field and will not utilize this
| ||||
ExtVarchar5 | EXVAR5 | char | OPT | NONE |
Reserved - User Defined - This is a Text String is reserved for the user. PeopleSoft does not currently use this field and will not utilize this
| ||||
ExtVarchar6 | EXVAR6 | char | OPT | NONE |
Reserved - User Defined - This is a Text String is reserved for the user. PeopleSoft does not currently use this field and will not utilize this
| ||||
ExtVarchar7 | EXVAR7 | char | OPT | NONE |
Reserved - User Defined - This is a Text String is reserved for the user. PeopleSoft does not currently use this field and will not utilize this
| ||||
ExtVarchar8 | EXVAR8 | char | OPT | NONE |
Reserved - User Defined - This is a Text String is reserved for the user. PeopleSoft does not currently use this field and will not utilize this
| ||||
ExtVarchar9 | EXVAR9 | char | OPT | NONE |
Reserved - User Defined - This is a Text String is reserved for the user. PeopleSoft does not currently use this field and will not utilize this
| ||||
ExtVarchar10 | EXVAR10 | char | OPT | NONE |
Reserved - User Defined - This is a Text String is reserved for the user. PeopleSoft does not currently use this field and will not utilize this
| ||||
ExtVarchar11 | EXVAR11 | char | OPT | NONE |
Reserved - User Defined - This is a Text String is reserved for the user. PeopleSoft does not currently use this field and will not utilize this
| ||||
ExtVarchar12 | EXVAR12 | char | OPT | NONE |
Reserved - User Defined - This is a Text String is reserved for the user. PeopleSoft does not currently use this field and will not utilize this
| ||||
ExtVarchar13 | EXVAR13 | char | OPT | NONE |
Reserved - User Defined - This is a Text String is reserved for the user. PeopleSoft does not currently use this field and will not utilize this
| ||||
ExtVarchar14 | EXVAR14 | char | OPT | NONE |
Reserved - User Defined - This is a Text String is reserved for the user. PeopleSoft does not currently use this field and will not utilize this
| ||||
mnExtNumeric0 | EXNM0 | MATH_NUMERIC | OPT | NONE |
Reserved - User Defined - This is a Numeric Value that is reserved for the user. PeopleSoft does not currently use this field and will not
| ||||
mnExtNumeric1 | EXNM1 | MATH_NUMERIC | OPT | NONE |
Reserved - User Defined - This is a Numeric Value that is reserved for the user. PeopleSoft does not currently use this field and will not
| ||||
mnExtNumeric2 | EXNM2 | MATH_NUMERIC | OPT | NONE |
Reserved - User Defined - This is a Numeric Value that is reserved for the user. PeopleSoft does not currently use this field and will not
| ||||
mnExtNumeric3 | EXNM3 | MATH_NUMERIC | OPT | NONE |
Reserved - User Defined - This is a Numeric Value that is reserved for the user. PeopleSoft does not currently use this field and will not
| ||||
mnExtNumeric4 | EXNM4 | MATH_NUMERIC | OPT | NONE |
Reserved - User Defined - This is a Numeric Value that is reserved for the user. PeopleSoft does not currently use this field and will not
| ||||
mnExtNumericp0 | EXNMP0 | MATH_NUMERIC | OPT | NONE |
Reserved - User Defined - This is a Numeric Value that is reserved for the user. PeopleSoft does not currently use this field and will not
| ||||
mnExtNumericp1 | EXNMP1 | MATH_NUMERIC | OPT | NONE |
Reserved - User Defined - This is a Numeric Value that is reserved for the user. PeopleSoft does not currently use this field and will not
| ||||
mnExtNumericp2 | EXNMP2 | MATH_NUMERIC | OPT | NONE |
Reserved - User Defined - This is a Numeric Value that is reserved for the user. PeopleSoft does not currently use this field and will not
| ||||
mnExtNumericp3 | EXNMP3 | MATH_NUMERIC | OPT | NONE |
Reserved - User Defined - This is a Numeric Value that is reserved for the user. PeopleSoft does not currently use this field and will not
| ||||
mnExtNumericp4 | EXNMP4 | MATH_NUMERIC | OPT | NONE |
Reserved - User Defined - This is a Numeric Value that is reserved for the user. PeopleSoft does not currently use this field and will not
| ||||
ExtDate0 | EXDT0 | INVALID ITEM DATA TYPE: 55 | OPT | NONE |
Reserved - User Defined - This is a date that is reserved for the user. PeopleSoft does not currently use this field and will not utilize this
| ||||
ExtDate1 | EXDT1 | INVALID ITEM DATA TYPE: 55 | OPT | NONE |
Reserved - User Defined - This is a date that is reserved for the user. PeopleSoft does not currently use this field and will not utilize this
| ||||
ExtDate2 | EXDT2 | INVALID ITEM DATA TYPE: 55 | OPT | NONE |
Reserved - User Defined - This is a date that is reserved for the user. PeopleSoft does not currently use this field and will not utilize this
| ||||
ExtDate3 | EXDT3 | INVALID ITEM DATA TYPE: 55 | OPT | NONE |
Reserved - User Defined - This is a date that is reserved for the user. PeopleSoft does not currently use this field and will not utilize this
| ||||
ExtDate4 | EXDT4 | INVALID ITEM DATA TYPE: 55 | OPT | NONE |
Reserved - User Defined - This is a date that is reserved for the user. PeopleSoft does not currently use this field and will not utilize this
| ||||
idPtrAddrBookMBFData | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
idPtrCustMBFData | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
cAddrBookMBFActionCode | ACTN | char | OPT | NONE |
A code that specifies the action that is performed. Valid values are: A Add C Change | ||||
cCustMBFActionCode | ACTN | char | OPT | NONE |
A code that specifies the action that is performed. Valid values are: A Add C Change | ||||
szSessionKey | SNKY | char | OPT | NONE |
Session Key is the identifier of a Sales Order Session. | ||||
cAction | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
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.
| ||||
cSpecialInstruction01 | SI01 | char | OPT | NONE |
An option that specifies whether the customer requires that the entire order be shipped at one time, or if the customer will accept multiple
| ||||
szP90CA087Version | 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
| ||||
mnClaimsManager | MAN8 | MATH_NUMERIC | OPT | NONE |
The address book number of the person responsible for managing deductions. | ||||
mnPolicyNumber | PLY | MATH_NUMERIC | OPT | NONE |
A number that the system assigns to each policy record to identify it. | ||||
szAddressBookMBFVersion | 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
| ||||
szCustMasterMBFVersion | 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
| ||||
mnPayorAddressNumber | PYR | MATH_NUMERIC | OPT | NONE |
The address book number of the person or company that sends the payment. | ||||
cAutoCash_2 | ATCS | char | OPT | NONE |
An option that specifies whether a customer or company is eligible to process receipts in the Accounts Receivable system using the
| ||||
nWarningCount | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due. | ||||
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
| ||||
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
| ||||
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
| ||||
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
| ||||
idErrorList | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
mnCreditWorkflowStarted | MATH01 | MATH_NUMERIC | OPT | NONE |
- - - Good Performance Low Value. | ||||
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. | ||||
szCertificate | TXCT | char | OPT | NONE |
The number that tax authorities issue to tax-exempt individuals and companies to identify their tax-exempt status. | ||||
mnF0101SynchronizationStatus | 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
| ||||
mnF0101ServerStatus | 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
| ||||
mnF0101PreviousErrorStatus | 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
| ||||
mnF03012SynchronizationStatus | 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
| ||||
mnF03012ServerStatus | 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
| ||||
mnF0116SynchronizationStatus | 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
| ||||
mnF0116ServerStatus | 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
| ||||
szF0101UserId | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
szF03012UserId | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
szF0116UserId | USER | char | OPT | NONE |
The code that identifies a user profile. | ||||
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
| ||||
szPIMGUID | CFRGUID | char | OPT | NONE |
None |
None |