BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_TRD_NONVW
TREAS_HEADER_IDTR_INTERNAL_VW(SQL View) |
Index Back |
|---|---|
Select under negotiation dealsIf a deal is under negotiation, then it can become an internal deal. Select those deals. |
| SELECT BUSINESS_UNIT , TREAS_HEADER_ID , DESCR150_MIXED FROM PS_TRX_HEADER_TR WHERE DEAL_STATUS = '01' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_TRD_NONVW |
| 2 | TREAS_HEADER_ID |
Character(12) | VARCHAR2(12) NOT NULL | The unique key identifier for a given deal transaction. |
| 3 | DESCR150_MIXED | Character(150) | VARCHAR2(150) NOT NULL | Description |