RO_HDR_BILL_VW (SQL View)	Index Back
Capture Bill Customer Bill To Customer view that lists the bill to customer bo id's

RO_HDR_BILL_VW

(SQL View)

Capture Bill Customer

Bill To Customer view that lists the bill to customer bo id's

SELECT HDR.CAPTURE_ID , BIL.BO_ID , BIL.PROFILE_CM_SEQ , BIL.BO_ID_EIP , BIL.PROFILE_CM_SEQ_EIP , BIL.UID20F_ADDR FROM PS_RO_HEADER HDR , PS_RO_BOID BIL WHERE HDR.CAPTURE_ID=BIL.CAPTURE_ID AND HDR.UID20F_BILL=BIL.UID20

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.

2 BO_ID_BILL Number(31,0) DECIMAL(31) NOT NULL Business Object ID

3 PROFILE_CM_SEQ_BIL Number(31,0) DECIMAL(31) NOT NULL Profile Contact Method Sequence Number for Billing

4 BO_ID_EIP_BIL Signed Number(32,0) DECIMAL(31) NOT NULL This is the integration bo id, this BO ID field is used in the OC eip's to send the BO_Id to other systems

5 PRO_CM_SEQ_EIP_BIL Number(31,0) DECIMAL(31) NOT NULL The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.

6 UID20F_BILL Character(20) VARCHAR2(20) NOT NULL Foreign UID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the capture ID in order capture.
2	BO_ID_BILL	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
3	PROFILE_CM_SEQ_BIL	Number(31,0)	DECIMAL(31) NOT NULL	Profile Contact Method Sequence Number for Billing
4	BO_ID_EIP_BIL	Signed Number(32,0)	DECIMAL(31) NOT NULL	This is the integration bo id, this BO ID field is used in the OC eip's to send the BO_Id to other systems
5	PRO_CM_SEQ_EIP_BIL	Number(31,0)	DECIMAL(31) NOT NULL	The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.
6	UID20F_BILL	Character(20)	VARCHAR2(20) NOT NULL	Foreign UID