NET_AR_DTL_VW(SQL View) |
Index Back |
|---|---|
Netting AR Details |
| SELECT B.NET_REF_ID , %Substring(A.CUST_ID, 1, 10) , A.ITEM , A.ACCOUNTING_DT , B.BUSINESS_UNIT , B.BAL_AMT , B.DISC_AVAIL_AMT , B.DISC_APPL_AMT , B.NET_BAL_AMT , B.BAL_BAL_AMT , B.DSLCT_BAL_AMT , C.NETTING_DATE , C.NETTING_STL_DATE , C.NETTING_CURRENCY , C.NET_HDR_STATUS , 'R' FROM PS_ITEM A , PS_NET_STG_AR B , PS_NET_STG_HDR C , PS_NET_CONTRACT D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.CUST_ID = B.CUST_ID AND A.ITEM = B.ITEM AND A.ITEM_LINE = B.ITEM_LINE 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 | CUSTOMER | Character(10) | VARCHAR2(10) NOT NULL | Customer |
| 3 | ITEM | Character(30) | VARCHAR2(30) NOT NULL | Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number. |
| 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 | BAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Item Balance |
| 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_BAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Netted Amount |
| 10 | BAL_BAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Balance 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 |