POS_GEN_MAN_VW(SQL View) |
Index Back |
|---|---|
Manual Position Entry |
| SELECT A.SETID , A.POS_CATEGORY , A.VALUE_DT , A.REFERENCE , A.SEQ_NBR , A.BUSINESS_UNIT , A.CURRENCY_CD , A.AMOUNT , A.BNK_ID_NBR , A.BANK_ACCOUNT_NUM , A.TREE_NAME , A.SOURCE_SET , B.BANK_CD , B.BANK_ACCT_KEY FROM PS_POS_GEN_ENT_TBL A , PS_BNK_NON_KEYS_V2 B WHERE A.BNK_ID_NBR = B.BNK_ID_NBR AND A.BANK_ACCOUNT_NUM = B.BANK_aCCOUNT_NUM AND A.SETID = B.SETID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | POS_CATEGORY |
Character(30) | VARCHAR2(30) NOT NULL |
Position Category
Prompt Table: POS_GEN_TRND_VW |
| 3 | VALUE_DT |
Date(10) | DATE NOT NULL | Equivalent to a deal transaction's settlement date. |
| 4 | REFERENCE |
Character(30) | VARCHAR2(30) NOT NULL | Field to show when a variable is a reference variable. |
| 5 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_FS_NONVW |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 8 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 9 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
Prompt Table: BANK_IDALL_VW |
| 10 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
Prompt Table: BANK_ACCTNUM_V3 |
| 11 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table: POS_TREE_TBL |
| 12 | SOURCE_SET | Character(20) | VARCHAR2(20) NOT NULL |
A field name describing a group od position sources.
Prompt Table: POS_SOURCE_SET |
| 13 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 14 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |