| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BO_ID |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID
|
| 2 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 3 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer ID
|
| 4 |
CUST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Status Indicator. BC.CUST_STATUS
A=Active
I=Inactive
Default Value: A
|
| 5 |
CUST_STATUS_DT |
Date(10) |
DATE |
The date that the status of a customer takes effect.
|
| 6 |
CUSTOMER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Type
1=User 1
2=User 2
3=User 3
4=User 4
Default Value: 1
|
| 7 |
SINCE_DT |
Date(10) |
DATE NOT NULL |
The customer has been a customer since this date.
Default Value: %date
|
| 8 |
ADD_DT |
Date(10) |
DATE NOT NULL |
The date the customer was added to the system.
Default Value: %date
|
| 9 |
NAME1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Generic 50 character name field for storing names.
|
| 10 |
NAMESHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Name
|
| 11 |
NAME1_AC |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1 Alternate Char Set
|
| 12 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number from Supply Chain Management.
Field size increased from 3 to 5 in CRM 8.95, as Supply Chain Management has increased the size to 5 in SCM 8.9 release.
|
| 13 |
CORPORATE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 14 |
CORPORATE_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Corporate Customer ID
|
| 15 |
CNTCT_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Contact Sequence Number
Field size increased from 3 to 5 in CRM 8.95, as Supply Chain Management has increased the size to 5 in SCM 8.9 release.
|
| 16 |
SUBCUST_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Uses of a Sub Customer
Y/N Table Edit
Default Value: N
|
| 17 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
RT_TYPE_TBL
|
| 18 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
Prompt Table:
CURRENCY_CD_TBL
|
| 19 |
VAT_TXN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
Prompt Table:
VAT_TXN_CD
|
| 20 |
SHIP_TO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag indicating that the customer or address is a valid Ship To customer or address.
Y/N Table Edit
Default Value: N
|
| 21 |
BILL_TO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A boolean that flags whether or not the customer is a valid Bill To customer.
Y/N Table Edit
Default Value: N
|
| 22 |
SOLD_TO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A boolean that flags whether or not the customer is a valid Sold To customer.
Y/N Table Edit
Default Value: N
|
| 23 |
BROKER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag indicating that it is a broker.
Y/N Table Edit
Default Value: N
|
| 24 |
INDIRECT_CUST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indirect Customer flag.
Y/N Table Edit
Default Value: N
|
| 25 |
CUST_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Level. Example of possible values are New, Prospect, Regular, or Temporary
N=New
P=Prospect - Quotations Only
R=Regular
T=Temporary
Default Value: R
|
| 26 |
ADDRESS_SEQ_SOLD |
Number(5,0) |
INTEGER NOT NULL |
Sequence that the Sold To address should be used.
Field size increased from 3 to 5 in CRM 8.95, as Supply Chain Management has increased the size to 5 in SCM 8.9 release.
|
| 27 |
CNTCT_SEQ_SOLD |
Number(5,0) |
INTEGER NOT NULL |
Primary Contact - Sold To
|
| 28 |
ADDRESS_SEQ_SHIP |
Number(5,0) |
INTEGER NOT NULL |
Primary Address sequence number
Field size increased from 3 to 5 in CRM 8.95, as Supply Chain Management has increased the size to 5 in SCM 8.9 release.
|
| 29 |
CNTCT_SEQ_SHIP |
Number(5,0) |
INTEGER NOT NULL |
Primary Contact - Ship To
|
| 30 |
ADDRESS_SEQ_BRK |
Number(5,0) |
INTEGER NOT NULL |
Sequence number of a Broker address.
Field size increased from 3 to 5 in CRM 8.95, as Supply Chain Management has increased the size to 5 in SCM 8.9 release.
|
| 31 |
ADDRESS_SEQ_IND |
Number(5,0) |
INTEGER NOT NULL |
Sequence number of an Indirect address.
Field size increased from 3 to 5 in CRM 8.95, as Supply Chain Management has increased the size to 5 in SCM 8.9 release.
|
| 32 |
HOLD_UPDATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Update Switch
Y/N Table Edit
Default Value: N
|
| 33 |
ROLEUSER |
Character(30) |
VARCHAR2(30) NOT NULL |
Role User
Prompt Table:
ROLEXLATOPR_VW
|
| 34 |
TAXPAYER_ID |
Character(14) |
VARCHAR2(14) NOT NULL |
Taxpayer ID
|
| 35 |
WEB_URL |
Character(130) |
VARCHAR2(130) NOT NULL |
URL of a customer's website.
|
| 36 |
STOCK_SYMBOL |
Character(10) |
VARCHAR2(10) NOT NULL |
This field is used to store the Stock Symbol
|
| 37 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 38 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 39 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 40 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 41 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 42 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|