TV_PTNR_URL(SQL Table) |
Index Back |
|---|---|
Travel Partner URLDefine the Travel Partner parameters used to pass within the HTML form for signon to travel site. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TRAVEL_PARTNER |
Character(18) | VARCHAR2(18) NOT NULL | Travel Partner |
| 2 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: 1 |
| 3 | TV_URL_PARM | Character(20) | VARCHAR2(20) NOT NULL | Travel URL parameter |
| 4 | TV_URL_PARMVALUE | Character(60) | VARCHAR2(60) NOT NULL | Travel URL Parameter value |
| 5 | RECORDNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record Name
01=MASTER_ITEM_EC 02=INV_ITEMS_EC 03=BU_ITM_INV_EC 04=BU_ITM_WTVL_EC 05=ITEM_SUPPLIER_EC 06=ITM_SUPP_LOC_EC 07=ITM_VNDR_UOM_EC 08=ITM_VND_UMPR_EC 09=INV_ITM_UOM_EC 10=PUR_ITM_ATTR_EC 13=EN_REVISION_EC 14=ITEM_MFG_GPO_EC 15=ITEM_MFG_EC 16=ITEM_CAT_EC Prompt Table: TV_RECNAME_VW |
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: TV_FIELDNAME_VW |