BI_360_REQ

(SQL Table)
Index Back

CRM to Billing 360 requests

Record containing the CRM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
4 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
5 START_DT Date(10) DATE Start Date
6 END_DT Date(10) DATE End Date
7 ORDERBY_FLD Character(254) VARCHAR2(254) NOT NULL Field Name
8 MAX_ROWS_FETCH Number(5,0) INTEGER NOT NULL Max Rows Fetch
9 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL Customer BO ID
10 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Customer Role Type ID
11 BO_ID_CNTCT Number(31,0) DECIMAL(31) NOT NULL Contact BO_ID
12 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Contact Role Type ID