GNV_ADV_LINE_VW(SQL View) |
Index Back |
|---|---|
G-Invoicing Adv Line ViewG-Invoicing Adv Line View |
| SELECT DISTINCT A.SETID , B.GNV_PERFORM_NBR , B.GNV_ORDER_NUM , B.GNV_PERFORM_TYPE , B.GNV_PRFORM_DTL_NBR , B.GNV_ORDER_LINE_NBR , B.GNV_PERF_DTL_REF_N , B.GNV_SCHED_NBR , B.GNV_FINAL_FLAG , B.GNV_QUANTITY , B.GNV_UOM , B.GNV_LINE_AMT , B.GNV_STATUS , B.GNV_DOS , B.GNV_DRN , B.GNV_XFER_DT , B.ACCOUNT , B.ENTRY_EVENT , A.BUSINESS_UNIT_PO , A.PO_ID , C.BUSINESS_UNIT_AP , ' ' FROM PS_PO_GNV_PER_HDR A , PS_PO_GNV_PER_DTL B , PS_BUS_UNIT_TBL_PM C WHERE %Join(COMMON_KEYS, PO_GNV_PER_HDR A, PO_GNV_PER_DTL B) AND A.GNV_PERFORM_TYPE='548' AND A.GNV_BUY_SELL_IND='S' AND B.GNV_STATUS IN ('PND', 'STL') AND A.BUSINESS_UNIT_PO =C.BUSINESS_UNIT AND NOT EXISTS ( SELECT 'X' FROM PS_AP_GNV_ADV_HDR E WHERE %Join (COMMON_KEYS, AP_GNV_ADV_HDR E, PO_GNV_PER_HDR A)) UNION ALL SELECT DISTINCT A.SETID , B.GNV_PERFORM_NBR , B.GNV_ORDER_NUM , B.GNV_PERFORM_TYPE , B.GNV_PRFORM_DTL_NBR , B.GNV_ORDER_LINE_NBR , B.GNV_PERF_DTL_REF_N , B.GNV_SCHED_NBR , B.GNV_FINAL_FLAG , B.GNV_QUANTITY , B.GNV_UOM , B.GNV_LINE_AMT , B.GNV_STATUS , B.GNV_DOS , B.GNV_DRN , B.GNV_XFER_DT , B.ACCOUNT , B.ENTRY_EVENT , A.BUSINESS_UNIT_PO , A.PO_ID , B.BUSINESS_UNIT , B.VOUCHER_ID FROM PS_AP_GNV_ADV_HDR A , PS_AP_GNV_ADV_DTL B WHERE %Join(COMMON_KEYS, AP_GNV_ADV_HDR A, AP_GNV_ADV_DTL B) AND A.GNV_PERFORM_TYPE='548' AND A.GNV_BUY_SELL_IND='S' AND B.GNV_STATUS IN ('PND', 'STL') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | 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 |
| 3 | GNV_ORDER_NUM |
Character(20) | VARCHAR2(20) NOT NULL | G-INVOICING MANINSRI 15/06/2021 |
| 4 | 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 |
| 5 | 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 |
| 6 | 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 |
| 7 | GNV_PERF_DTL_REF_N | Number(6,0) | INTEGER NOT NULL | A number that links a new Performance Detail to an existing one. G_INVOICING MANINSRI 17/06/2021 |
| 8 | GNV_SCHED_NBR | Number(5,0) | INTEGER NOT NULL | Schedule Number |
| 9 | GNV_FINAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Specifies from one partner to another that no more performance (of this type) is expected against the Order Schedule. G_INVOICING MANINSRI 17/06/2021
F=F P=P |
| 10 | GNV_QUANTITY | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | The number of units pertaining to the type of performance being reported. G_INVOICING MANINSRI 17/06/2021 |
| 11 | GNV_UOM | Character(3) | VARCHAR2(3) NOT NULL | Units in which a quantity is being expressed. G-INVOICING MANINSRI 17/06/2021 |
| 12 | GNV_LINE_AMT | Signed Number(30,5) | DECIMAL(28,5) NOT NULL | The cost of each unit on an Order Schedule. G_INVOICING MANINSRI 17/06/2021 |
| 13 | GNV_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Status Code The current status of the requested document. G-INVOICING MANINSRI 15/06/2021
CLZ=Closed REC=Open STL=Settled |
| 14 | GNV_DOS | Character(5) | VARCHAR2(5) NOT NULL | An identifier assigned to the agency which is disbursing funds from the Treasury General Account (TGA). G_INVOICING MANINSRI |
| 15 | GNV_DRN | Character(8) | VARCHAR2(8) NOT NULL | Details a unique identifying number created by a system for a document, e.g. payment or collection document. G_INVOICING MANINSRI 17/06/2021 |
| 16 | GNV_XFER_DT | Character(10) | VARCHAR2(10) NOT NULL | The date that funds are transferred into or out of the TGA. (Equivalent to IPAC's Accomplished Date). G_INVOICING MANINSRI 17/06/2021 |
| 17 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL |
Account
Prompt Table: AP_GINV_ACCT_VW |
| 18 | ENTRY_EVENT | Character(10) | VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table:
GINV_EECODES_VW
|
| 19 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 20 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 21 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 22 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |