AM_LEAPAYREC_VW(SQL View) |
Index Back |
|---|---|
AM/AP Lease Payment Reconcilia |
| SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.PYMNT_DT , A.CURRENCY_CD , A.INTEREST_EXPENSE + A.OBLIGATION_REDUCE , A.LEASE_INTFC_STATUS , A.BUSINESS_UNIT_AP , A.VOUCHER_ID , B.INVOICE_DT , B.PAYMENT_DT , B.PYMNT_AMT , B.CURRENCY_PYMNT , B.POST_STATUS_AP , B.POST_STATUS_PYMNT FROM %Sql(AM_LEAPAYREC_OUTER_JOIN) AND A.LEASE_INTFC_AP_SW = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AM_NONVW |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | PYMNT_DT |
Date(10) | DATE | Payment Date |
| 4 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: CURR_CD_AM_VW.CURRENCY_CD |
| 5 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 6 | LEASE_INTFC_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Payment Status
APP=Pending Approval APR=Approved CAN=Canceled DON=Processed ERR=Error HLD=On Hold INP=In Process NEW=Approved-Auto STA=Sent To AP |
| 7 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table: SP_BU_AP_NONVW |
| 8 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 9 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 10 | PAYMENT_DT | Date(10) | DATE | Payment Date |
| 11 | PYMNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amount |
| 12 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL |
Payment Currency
Prompt Table: CURR_PYMNT_VW |
| 13 | POST_STATUS_AP | Character(1) | VARCHAR2(1) NOT NULL |
Post Status
N=Payment Not Applied P=Posted U=Unposted Default Value: U |
| 14 | POST_STATUS_PYMNT | Character(1) | VARCHAR2(1) NOT NULL |
Post Status
N=Payment Not Applied P=Posted U=Unposted |