NET_REF_IDA=Approved
C=Closed
O=Open
X=Cancelled
NET_STG_HDR_VW1(SQL View) |
Index Back |
|---|---|
Search Record for Manual Adj |
| SELECT NET_REF_ID , NETTING_DATE , NET_HDR_STATUS , NET_CONTRACT_ID , NETTING_CURRENCY , TOTAL_PAY_AMT , TOTAL_RCV_AMT FROM PS_NET_STG_HDR WHERE NET_HDR_STATUS IN ('O', 'A') |
| # | 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 | NETTING_DATE | Date(10) | DATE | Netting Date. Used to Define the date that the netting will take place. |
| 3 | 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 |
| 4 | NET_CONTRACT_ID | Character(10) | VARCHAR2(10) NOT NULL | Contract ID : To identify unique contract. |
| 5 | NETTING_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Netting Currency |
| 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 |