TV_MYRESV_LINE(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | TRAVEL_PARTNER |
Character(18) | VARCHAR2(18) NOT NULL |
Travel Partner
Prompt Table: TV_TRAVEL_PTNR |
| 3 | ITINERARY_ID |
Character(18) | VARCHAR2(18) NOT NULL | Itinerary ID for Travel Reservations |
| 4 | CONFIRM_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Confirm Status
C=Confirmed U=Unconfirmed Default Value: C |
| 5 | RESERVATION_NBR |
Number(3,0) | SMALLINT NOT NULL | reservation sequence number |
| 6 | RESERVATION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
reservation type
A=Air C=Automobile H=Hotel Lodgings R=Rail |
| 7 | CONFIRMATION_ID | Character(18) | VARCHAR2(18) NOT NULL | Confirmation ID |
| 8 | DESCR40 | Character(40) | VARCHAR2(40) NOT NULL | Description |
| 9 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 10 | END_DATE | Date(10) | DATE | End Date |
| 11 | MERCHANT | Character(40) | VARCHAR2(40) NOT NULL | Merchant |
| 12 | TXN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
| 13 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 14 | MONETARY_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account. |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 16 | AIRFARE_RCPT_NBR | Character(16) | VARCHAR2(16) NOT NULL | Airfare Receipt Number |
| 17 | TRAVEL_FROM | Character(5) | VARCHAR2(5) NOT NULL | Used to indicate the starting point of travel for a travel authorization for airline expenditures. Defined on the EX_TAUTH_LINE record and used on various travel auth line panels. Used in conjunction with the TRAVEL_TO field to track the cost of flights to and from various locals. |
| 18 | TXN_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Expense Location |
| 19 | NBR_NIGHTS | Number(3,0) | SMALLINT NOT NULL | Number of Nights |
| 20 | EXPENSE_TYPE | Character(7) | VARCHAR2(7) NOT NULL |
Expense Type
Prompt Table: EX_TYPES_TBL |
| 21 | TRANSPORT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Transportation Type |
| 22 | TRAVEL_AUTH_ID | Character(10) | VARCHAR2(10) NOT NULL | Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels. |
| 23 | SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 24 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 25 | ASSOC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
used for travel reservation association or transactions
Y/N Table Edit Default Value: N |
| 26 | TXN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Status
A=Assigned D=Marked for Delete R=Rejected T=All Transaction Statuses U=Unassigned |
| 27 | APPROVAL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval Status
A=Approved D=Denied E=Sent Back for Revision H=On Hold I=Initial M=Resubmitted P=In Process R=Rerouted S=Submitted |
| 28 | APPRVAL_COMPLT | Character(1) | VARCHAR2(1) NOT NULL | Approval Complete |