|
SELECT SETID , CUST_ID , CUST_STATUS , CUST_STATUS_DT , CUSTOMER_TYPE , SINCE_DT , ADD_DT , NAME1 , NAMESHORT , NAME1_AC , ADDRESS_SEQ_NUM , CORPORATE_SETID , CORPORATE_CUST_ID , CNTCT_SEQ_NUM , SUBCUST_USE , CUR_RT_TYPE , CURRENCY_CD , VAT_TXN_TYPE_CD , SHIP_TO_FLG , BILL_TO_FLG , SOLD_TO_FLG , BROKER_FLG , INDIRECT_CUST_FLG , CUST_LEVEL , ADDRESS_SEQ_SOLD , CNTCT_SEQ_SOLD , ADDRESS_SEQ_SHIP , CNTCT_SEQ_SHIP , ADDRESS_SEQ_BRK , ADDRESS_SEQ_IND , HOLD_UPDATE_SW , TAXPAYER_ID , WEB_URL , STOCK_SYMBOL , ROW_LASTMANT_OPRID , %DatePart(ROW_LASTMANT_DTTM) FROM PS_RB_INT_CUSTOMER
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 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
|
| 2 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer ID
|
| 3 |
CUST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Status Indicator. BC.CUST_STATUS
A=Active
I=Inactive
Default Value: A
|
| 4 |
CUST_STATUS_DT |
Date(10) |
DATE |
The date that the status of a customer takes effect.
|
| 5 |
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
|
| 6 |
SINCE_DT |
Date(10) |
DATE NOT NULL |
The customer has been a customer since this date.
Default Value: %date
|
| 7 |
ADD_DT |
Date(10) |
DATE NOT NULL |
The date the customer was added to the system.
Default Value: %date
|
| 8 |
NAME1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Generic 50 character name field for storing names.
|
| 9 |
NAMESHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Name
|
| 10 |
NAME1_AC |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1 Alternate Char Set
|
| 11 |
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.
|
| 12 |
CORPORATE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 13 |
CORPORATE_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Corporate Customer ID
|
| 14 |
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.
|
| 15 |
SUBCUST_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Uses of a Sub Customer
Y/N Table Edit
Default Value: N
|
| 16 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
RT_TYPE_TBL
|
| 17 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
Prompt Table:
CURRENCY_CD_TBL
|
| 18 |
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.
|
| 19 |
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
|
| 20 |
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
|
| 21 |
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
|
| 22 |
BROKER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag indicating that it is a broker.
Y/N Table Edit
Default Value: N
|
| 23 |
INDIRECT_CUST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indirect Customer flag.
Y/N Table Edit
Default Value: N
|
| 24 |
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
|
| 25 |
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.
|
| 26 |
CNTCT_SEQ_SOLD |
Number(5,0) |
INTEGER NOT NULL |
Primary Contact - Sold To
|
| 27 |
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.
|
| 28 |
CNTCT_SEQ_SHIP |
Number(5,0) |
INTEGER NOT NULL |
Primary Contact - Ship To
|
| 29 |
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.
|
| 30 |
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.
|
| 31 |
HOLD_UPDATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Update Switch
Y/N Table Edit
Default Value: N
|
| 32 |
TAXPAYER_ID |
Character(14) |
VARCHAR2(14) NOT NULL |
Taxpayer ID
|
| 33 |
WEB_URL |
Character(130) |
VARCHAR2(130) NOT NULL |
URL of a customer's website.
|
| 34 |
STOCK_SYMBOL |
Character(10) |
VARCHAR2(10) NOT NULL |
This field is used to store the Stock Symbol
|
| 35 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
This field determines the last user or operator that last changed this item.
|
| 36 |
DATE_LAST_MAINT |
Date(10) |
DATE |
This field determines the date of last maintenance.
|