TV_MYRES_HDR_H(SQL Table) |
Index Back |
|---|---|
tv myresv hdr |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | TRAVEL_PARTNER |
Character(18) | VARCHAR2(18) NOT NULL |
Travel Partner
Prompt Table: TV_TRAVEL_PTNR |
| 5 | ITINERARY_ID |
Character(18) | VARCHAR2(18) NOT NULL | Itinerary ID for Travel Reservations |
| 6 | CONFIRM_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Confirm Status
C=Confirmed U=Unconfirmed Default Value: C |
| 7 | BOOKING_DT | Date(10) | DATE | Booking Date |
| 8 | DESCR40 | Character(40) | VARCHAR2(40) NOT NULL | Description |
| 9 | TXN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
| 10 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 11 | AMT_BEFORE_TAX | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Travel Reservation Amount before taxes |
| 12 | ABT_CURR_CD | Character(3) | VARCHAR2(3) NOT NULL | travel reservation Amount before tax currency code |
| 13 | AMT_AFTER_TAX | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | travel reservation amount after taxes |
| 14 | AAT_CURR_CD | Character(3) | VARCHAR2(3) NOT NULL | travel reservation Amount after tax currency code |
| 15 | ADDL_FEES_INCL | Character(1) | VARCHAR2(1) NOT NULL |
Additional Fees Included
Y/N Table Edit Default Value: N |
| 16 | CRDMEM_ACCT_NBR | Character(44) | VARCHAR2(44) NOT NULL | Cardmember Number |
| 17 | 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. |
| 18 | ASSOC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
used for travel reservation association or transactions
Y/N Table Edit Default Value: N |
| 19 | TXN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Status
A=Assigned D=Marked for Delete R=Rejected T=All Transaction Statuses U=Unassigned |
| 20 | 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 |
| 21 | APPRVAL_COMPLT | Character(1) | VARCHAR2(1) NOT NULL |
Approval Complete
Y/N Table Edit |