TV_MYRES_LINE_H(SQL Table) |
Index Back |
|---|
| # | 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 |
| 7 | RESERVATION_NBR |
Number(3,0) | SMALLINT NOT NULL | reservation sequence number |
| 8 | RESERVATION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
reservation type
A=Air C=Automobile H=Hotel Lodgings R=Rail |
| 9 | CONFIRMATION_ID | Character(18) | VARCHAR2(18) NOT NULL | Confirmation ID |
| 10 | DESCR40 | Character(40) | VARCHAR2(40) NOT NULL | Description |
| 11 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 12 | END_DATE | Date(10) | DATE | End Date |
| 13 | MERCHANT | Character(40) | VARCHAR2(40) NOT NULL | Merchant |
| 14 | TXN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
| 15 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 16 | 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. |
| 17 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 18 | AIRFARE_RCPT_NBR | Character(16) | VARCHAR2(16) NOT NULL | Airfare Receipt Number |
| 19 | 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. |
| 20 | TXN_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Expense Location |
| 21 | NBR_NIGHTS | Number(3,0) | SMALLINT NOT NULL | Number of Nights |
| 22 | EXPENSE_TYPE | Character(7) | VARCHAR2(7) NOT NULL | Expense Type |
| 23 | TRANSPORT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Transportation Type |
| 24 | 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. |
| 25 | SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 26 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 27 | ASSOC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
used for travel reservation association or transactions
Y/N Table Edit Default Value: N |
| 28 | TXN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Status
A=Assigned D=Marked for Delete R=Rejected T=All Transaction Statuses U=Unassigned |
| 29 | 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 |
| 30 | APPRVAL_COMPLT | Character(1) | VARCHAR2(1) NOT NULL | Approval Complete |