BUS_PROC_INSTANCECAPTURE_IDPrompt Table: RO_HEADER
C=Complete
L=Canceled
P=In Process
RO_FULFIL_BP_VW(SQL View) |
Index Back |
|---|---|
FulfillmentThis record is used in order bridge.used in order capture |
| SELECT A.BUS_PROC_INSTANCE ,B.CAPTURE_ID ,A.BUS_PROCESS_STATUS ,A.RC_BUS_PROCESS_ID ,A.START_DTTM ,B.TYPE FROM PS_RC_BP_STATUS A , PS_RO_ASSOCIATION B WHERE A.BUS_PROC_INSTANCE = B.BUS_PROC_INSTANCE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUS_PROC_INSTANCE |
Number(18,0) | DECIMAL(18) NOT NULL | Business Project Instance. This is the Business Project instance of a business project. |
| 2 | CAPTURE_ID |
Character(20) | VARCHAR2(20) NOT NULL |
Field use to store the capture ID in order capture.
Prompt Table: RO_HEADER |
| 3 | BUS_PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
This field is to store Business Process status.
C=Complete L=Canceled P=In Process |
| 4 | RC_BUS_PROCESS_ID | Character(15) | VARCHAR2(15) NOT NULL | Business Process ID used in Business Process tracking. |
| 5 | START_DTTM | DateTime(26) | TIMESTAMP | start date time |
| 6 | TYPE | Character(4) | VARCHAR2(4) NOT NULL | Association Types |