AP_VCHR_ADV_VW(SQL View) |
Index Back |
|---|---|
G-Invoicing Advance-Voucher VwG-Invoicing Advance-Voucher View |
| SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.INVOICE_DT , A.GROSS_AMT , A.ENTRY_STATUS , A.BUDGET_HDR_STATUS , A.POST_STATUS_AP , B.SETID , B.GNV_PERFORM_NBR , B.GNV_ORDER_NUM , B.GNV_PERFORM_TYPE , B.GNV_PRFORM_DTL_NBR , B.GNV_ORDER_LINE_NBR FROM PS_VOUCHER A , PS_AP_GNV_ADV_DTL B WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.VOUCHER_ID=B.VOUCHER_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 4 | INVOICE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 5 | ENTRY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: VCHR_SRCH_DEL.ENTRY_STATUS.SearchInit. Template Voucher status should not be visibile in the drop down.
C=Complete D=Through batch defaults E=Edited by Batch Voucher Module L=Reviewed through Maintenance M=Modified O=Open P=Postable R=Recycle S=Scheduled for Payment T=Template Voucher X=Deleted |
| 6 | BUDGET_HDR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid |
| 7 | POST_STATUS_AP | Character(1) | VARCHAR2(1) NOT NULL |
Post Status
N=Payment Not Applied P=Posted U=Unposted |
| 8 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 9 | GNV_PERFORM_NBR | Character(20) | VARCHAR2(20) NOT NULL | A number for a Performance transaction, assigned by G-Invoicing (GINV) at the time the transaction is recorded in GINV. MANINSRI 16/06/2021 |
| 10 | GNV_ORDER_NUM | Character(20) | VARCHAR2(20) NOT NULL | G-INVOICING MANINSRI 15/06/2021 |
| 11 | GNV_PERFORM_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Identifies the nature of the performance in the reported transaction. G-INVOICING MANINSRI 16/06/2021
014=Deferred Payment 035=Delivered/Performed 050=Received/Accepted 548=Advance |
| 12 | GNV_PRFORM_DTL_NBR | Number(6,0) | INTEGER NOT NULL | Uniquely identifies a specific detail record within the performance transaction. (Agency supplied). G_INVOICING MANINSRI |
| 13 | GNV_ORDER_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Identifier of a specific Line Item within the Order. G_INVOICING MANINSRI 17/06/2021 |