EX_AC_RM_HDR_VW(SQL View) |
Index Back |
|---|---|
Sheet 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 IN ('R','M') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EX_DOC_ID |
Character(10) | VARCHAR2(10) NOT NULL | Documentation 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 |