ADVLINE_TEO1(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for EX_ADV_LINE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | ADVANCE_ID | Character(10) | VARCHAR2(10) NOT NULL | Advance ID |
| 3 | LINE_NBR | Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1 |
| 4 | EX_LINE_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
The Line Status of an Expenses transaction (i.e. Expense Report, Cash Advance, Travel Authorization, Time Report)
ADJ=Adjusted APR=Approved APY=Approved for Payment CLS=Closed DEN=Denied DNA=Denied by Approver DNC=Denied DNU=Denied by Auditor ESC=Escheated Payment HDA=Hold by Approver HDU=Hold by Auditor HLD=Hold MFS=Marked For Submit OPN=Open PAR=Approvals in Process PD=Paid PND=Pending PRO=In Process RAP=Approved STG=Staged SUB=Submitted XML=Submitted, Pending Validation Default Value: PND |
| 5 | ADVANCE_SOURCE | Character(4) | VARCHAR2(4) NOT NULL |
Advance Source
Prompt Table: EX_ADV_SRC_TBL |
| 6 | 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. |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | GROSSUP | Character(1) | VARCHAR2(1) NOT NULL |
Gross Up Indicator
Y/N Table Edit Default Value: N |
| 10 | SEPCHK | Number(1,0) | SMALLINT NOT NULL | Separate Check Indicator |
| 11 | GROSS_UP_EST_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Up Estimated Amount |
| 12 | APPROVER_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Approver Oprid |
| 13 | APPROVER_ACTN_DT | Date(10) | DATE | The Date on which the approver takes necessary action |
| 14 | APPROVER_ADD_FLAG | Character(1) | VARCHAR2(1) NOT NULL | New Approver Add Flag |
| 15 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |