RD_PARTNER_CI_V

(SQL View)
 Index Back

Partner Main Record

RD_PARTNER is a sibling of RD_COMPANY being added in 8.9 to accommodate PRM.

SELECT BO_ID , PARTNER_STATUS , SINCE_DT , CUSTOMER_IND , BO_ID_CONTACT , TREE_NAME , TERRITORY_ID , TAX_EXEMPT_FLG , REJECT_REASON , TOTAL_LOCATIONS , CUST_BY_REVENUE , CUST_BY_EMPLOYEES , CUST_BY_SIZE , CUST_BY_MARKET_CAP , ROW_ADDED_DTTM , ROW_ADDED_OPRID , ROW_LASTMANT_DTTM , ROW_LASTMANT_OPRID , SYNCID , SYNCDTTM FROM PS_RD_PARTNER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

Default Value: 999999999999999

2 PARTNER_STATUS Character(1) VARCHAR2(1) NOT NULL Parnter Status
1=Active
2=Approved
3=Rejected
4=Pending Approval
5=Inactive
3 SINCE_DT Date(10) DATE The customer has been a customer since this date.
4 CUSTOMER_IND Character(1) VARCHAR2(1) NOT NULL Customer Indicator for Business Contacts.
N=No
Y=Yes
5 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

Prompt Table: RD_PTNR_CONT_VW

6 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
7 TERRITORY_ID Character(20) VARCHAR2(20) NOT NULL Territory ID
8 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

Y/N Table Edit

9 REJECT_REASON Character(2) VARCHAR2(2) NOT NULL Reject Reason
01=Not Qualified
02=Incomplete Application
03=Duplicate Application
04=Other
10 TOTAL_LOCATIONS Number(5,0) INTEGER NOT NULL Total Locations
11 CUST_BY_REVENUE Character(1) VARCHAR2(1) NOT NULL Target Customer By Revenuw
1=Under 1 Million
2=Between 1 and 10 Million
3=Between 10 and 20 Million
4=Greater Than 20 Million
12 CUST_BY_EMPLOYEES Character(1) VARCHAR2(1) NOT NULL Target Customer By Employees
1=Less Than 1,000
2=Between 1000 and 5000
3=Between 5000 and 10000
4=More than 10000
13 CUST_BY_SIZE Character(1) VARCHAR2(1) NOT NULL Target Customer By Size
1=Small
2=Medium
3=Large
14 CUST_BY_MARKET_CAP Character(1) VARCHAR2(1) NOT NULL Target Customer By Market Capitalization
1=Under 5000000
2=Between 5000000 and 10000000
3=Between 10 and 50 Million
4=More than 50 Million
15 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
16 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
17 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
18 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
19 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.
20 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time