SETIDGNV_PERFORM_NBRGNV_ORDER_NUMGNV_PERFORM_TYPE014=Deferred Payment
035=Delivered/Performed
050=Received/Accepted
548=Advance
GNV_PRFORM_DTL_NBRGNV_ORDER_LINE_NBRF=F
P=P
CLZ=Closed
REC=Open
STL=Settled
AP_GNV_ADV_DTL(SQL Table) |
Index Back |
|---|---|
Advance Detail Data TableG-Invoicing Advance Detail Data Table |
| # | 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 |
| 18 | ENTRY_EVENT | Character(10) | VARCHAR2(10) NOT NULL | Entry Event |
| 19 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 20 | IN_PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL | In process flag |
| 21 | VCHR_SRC | Character(4) | VARCHAR2(4) NOT NULL | Voucher Source |
| 22 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 23 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 24 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 25 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |