| # |
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
|