NET_AP_DTL_VW(SQL View) |
Index Back |
|---|---|
Netting AP Details |
| SELECT B.NET_REF_ID , A.VENDOR_ID , A.VOUCHER_ID , A.ACCOUNTING_DT , B.BUSINESS_UNIT , B.PYMNT_GROSS_AMT , B.DISC_AVAIL_AMT , B.DISC_APPL_AMT , B.NET_PYMNT_AMT , B.BAL_PYMNT_AMT , B.DSLCT_BAL_AMT , C.NETTING_DATE , C.NETTING_STL_DATE , C.NETTING_CURRENCY , C.NET_HDR_STATUS , 'P' FROM PS_VOUCHER A , PS_NET_STG_AP B , PS_NET_STG_HDR C , PS_NET_CONTRACT D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND B.NET_REF_ID = C.NET_REF_ID AND D.NET_CONTRACT_ID = C.NET_CONTRACT_ID AND D.EFFDT = ( SELECT MAX(D_ED.EFFDT) FROM PS_NET_CONTRACT D_ED WHERE D.NET_CONTRACT_ID = D_ED.NET_CONTRACT_ID AND D_ED.EFFDT <= %CurrentDateIn) AND D.NET_ADVICE_IND = 'Y' |
| # | 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 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 4 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | PYMNT_GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Payment Amount |
| 7 | DISC_AVAIL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bi-Lateral Netting - Discount Applied Amount |
| 8 | DISC_APPL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bi-Lateral Netting - Discount Applied Amount |
| 9 | NET_PYMNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Netting Payment Amount |
| 10 | BAL_PYMNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Balance Payment Amount |
| 11 | DSLCT_BAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | DeSelected Amount |
| 12 | NETTING_DATE | Date(10) | DATE | Netting Date. Used to Define the date that the netting will take place. |
| 13 | NETTING_STL_DATE | Date(10) | DATE | Netting Settlement Date. This date becomes the due date of the Netting Balance for AP and AR transactions. |
| 14 | NETTING_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Netting Currency |
| 15 | 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 |
| 16 | CUST_VNDR_FLG | Character(1) | VARCHAR2(1) NOT NULL | Customer Supplier Flag |