SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
GNV_SYSTEM_IDPrompt Table: PO_GNV_SYSID_VW
PO_GNV_DEFN(SQL Table) |
Index Back |
|---|---|
G-Invoicing DefinitionG-Invoicing Definition, is needed to function as a G-Invoicing integration control center. G-INVOICING MANINSRI 12/06/2021 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | GNV_SYSTEM_ID |
Character(100) | VARCHAR2(100) NOT NULL |
Identifies the system that the interfacing Partner ID represents for the request. The System ID is used to limit data access and permissions in G-Invoicing. G-INVOICING MANINSRI12/06/2021
Prompt Table: PO_GNV_SYSID_VW |
| 3 | DESCRIPTION1 | Character(35) | VARCHAR2(35) NOT NULL | Description |
| 4 | GTC_LASTUPDDT | Date(10) | DATE | Last Update Date Since |
| 5 | GTC_LASTUPDTM | Time(15) | TIMESTAMP | Last Updated Time Since |
| 6 | GTC_DTTIME_UPDATED | DateTime(26) | TIMESTAMP | DateTime Updated |
| 7 | ORD_LASTUPDDT | Date(10) | DATE | Last Update Date Since |
| 8 | ORD_LASTUPDTM | Time(15) | TIMESTAMP | Last Updated Time Since |
| 9 | ORD_DTTIME_UPDATED | DateTime(26) | TIMESTAMP | DateTime Updated |
| 10 | PULL_PFM_LASTUPDDT | Date(10) | DATE | Last Update Date Since |
| 11 | PULL_PFM_LASTUPDTM | Time(15) | TIMESTAMP | Last Updated Time Since |
| 12 | PFM_DTTIME_UPDATED | DateTime(26) | TIMESTAMP | DateTime Updated |
| 13 | PUSH_PFM_LASTUPDDT | Date(10) | DATE | Last Update Date Since |
| 14 | PUSH_PFM_LASTUPDTM | Time(15) | TIMESTAMP | Last Updated Time Since |
| 15 | PUSH_DTTIME_UPDATE | DateTime(26) | TIMESTAMP | DateTime Updated |
| 16 | PULL_EZ_LASTUPDDT | Date(10) | DATE | Last Update Date Since |
| 17 | PULL_EZ_LASTUPDTM | Time(15) | TIMESTAMP | Last Updated Time Since |
| 18 | EZPULL_DTTM_UPDTD | DateTime(26) | TIMESTAMP | DateTime Updated |
| 19 | PUSH_EZ_LASTUPDDT | Date(10) | DATE | Last Update Date Since |
| 20 | PUSH_EZ_LASTUPDTM | Time(15) | TIMESTAMP | Last Updated Time Since |
| 21 | EZPUSH_DTTM_UPDTD | DateTime(26) | TIMESTAMP | DateTime Updated |