EX_AC_A_HDR_VW(SQL View) |
Index Back |
|---|---|
Advance Acctg Inquiry Hdr View |
| select distinct A.EX_DOC_ID, A.EX_DOC_TYPE, A.APPL_JRNL_ID, A.GL_DISTRIB_STATUS from PS_EX_ACCTG_LINE A where A.EX_DOC_TYPE = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ADVANCE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Advance ID |
| 2 | EX_DOC_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Identifies Expenses Document Type
A=Cash Advance C=Time Report J=Time Adjustment M=Accrual - My Wallet R=Accrual - Expense Report S=Expense Report T=Travel Authorization |
| 3 | APPL_JRNL_ID |
Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
| 4 | GL_DISTRIB_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Distribution Status
C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal |