BUSINESS_UNITTREAS_HEADER_IDSEQUENCE_NBRPrompt Table: BANK_TR_CPTY_VW
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
Default Value: N
Prompt Table: TR_CNTCT_CPTY_V
TRX_COMP_BID(SQL Table) |
Index Back |
|---|---|
Information for comp. BiddingRecord that store information for competitive bidding. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | TREAS_HEADER_ID |
Character(12) | VARCHAR2(12) NOT NULL | The unique key identifier for a given deal transaction. |
| 3 | SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | COUNTERPARTY | Character(5) | VARCHAR2(5) NOT NULL |
Represents a treasury dealing counterpart.
Prompt Table: BANK_TR_CPTY_VW |
| 5 | BID_RATE | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate quoted for bid. |
| 6 | QUOTE_REQUEST_TIME | Time(15) | TIMESTAMP | Time when bid quote is requested. |
| 7 | QUOTE_TIME | Time(15) | TIMESTAMP | Time when bid is quoted. |
| 8 | BEST_BID_RATE | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No flag to indicate the best bid rate among all bids.
Y/N Table Edit |
| 9 | DONE_DEAL | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No flag to indicate whether a bid is chosen.
Y/N Table Edit |
| 10 | BID_EXCLUDED | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether a bid is excluded from reporting.
Y/N Table Edit Default Value: N |
| 11 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 12 | DEALER_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A system generated value that reflects the operator that originally created and saved a given deal tran
Prompt Table: TR_CNTCT_CPTY_V |