NET_REF_IDA=Approved
C=Closed
O=Open
X=Cancelled
NET_STG_APPR_VW(SQL View) |
Index Back |
|---|---|
Netting Stage Approve ViewNetting Stage Approve View |
| SELECT NET_REF_ID , NET_HDR_STATUS , NET_CONTRACT_ID , NETTING_DATE , RUN_DTTM , TOTAL_PAY_AMT , TOTAL_RCV_AMT , BAL_BAL_AMT ,NETTING_CURRENCY FROM PS_NET_STG_HDR WHERE NET_HDR_STATUS = 'O' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NET_REF_ID |
Character(12) | VARCHAR2(12) NOT NULL | A reference identifier associated with a cash transaction subject to netting with a given bank/count |
| 2 | NET_HDR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Indicates the status of a given Netting Run:
Open
Approve
Cancel
Close
A=Approved C=Closed O=Open X=Cancelled |
| 3 | NET_CONTRACT_ID | Character(10) | VARCHAR2(10) NOT NULL | Contract ID : To identify unique contract. |
| 4 | NETTING_DATE | Date(10) | DATE | Netting Date. Used to Define the date that the netting will take place. |
| 5 | RUN_DTTM | DateTime(26) | TIMESTAMP | Run Date and Time |
| 6 | TOTAL_PAY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | An internal work field in the settlements module that contains a summary of all outbound transact |
| 7 | TOTAL_RCV_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | An internal work field in the settlements module that contains a summary of all inbound transacti |
| 8 | BAL_BAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Balance Amount |
| 9 | NETTING_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Netting Currency |