NET_STG_HDR_VW(SQL View) |
Index Back |
|---|---|
Search record for Net InquirySearch record for Netting Inquiry |
| SELECT NET_REF_ID , NETTING_DATE , NET_HDR_STATUS , NET_CLOSING_METHOD , NET_APPLY_DSCNT , BUSINESS_UNIT_AR , CUST_SETID , CUST_ID , NET_CONTRACT_ID , NETTING_CURRENCY , TOTAL_PAY_AMT , TOTAL_RCV_AMT , NET_BAL_AMT , PAY_DISC_AMT , PAY_DISC_APPL , RCV_DISC_AMT , RCV_DISC_APPL FROM PS_NET_STG_HDR |
| # | 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_CLOSING_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Closing Method
F=Full P=Partial |
| 5 | NET_APPLY_DSCNT | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether to apply AP/AR discount amounts to the netted transactions.
Y/N Table Edit Default Value: N |
| 6 | BUSINESS_UNIT_AR | Character(5) | VARCHAR2(5) NOT NULL | AR Business Unit |
| 7 | CUST_SETID | Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
| 8 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 9 | NET_CONTRACT_ID | Character(10) | VARCHAR2(10) NOT NULL | Contract ID : To identify unique contract. |
| 10 | NETTING_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Netting Currency |
| 11 | 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 |
| 12 | 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 |
| 13 | NET_BAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Netted Amount |
| 14 | PAY_DISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bi-Lateral Netting - Payable Discount Available Amount |
| 15 | PAY_DISC_APPL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bi-Lateral Netting - Payable Discount Paid Amount |
| 16 | RCV_DISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bi-Lateral Netting - Receivable Discount Available Amount |
| 17 | RCV_DISC_APPL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bi-Lateral Netting - Receivable Discount Paid Amount |