EX_BGTCHK_RQ_VW(SQL View) |
Index Back |
|---|---|
Budget Checking List ViewThis child table is used to store the selected Transactions for budget checking. |
| SELECT OPRID , RUN_CNTL_ID , REQUEST_NBR , SHEET_ID , TRAVEL_AUTH_ID , EX_DOC_ID , EX_DOC_TYPE , LINE_NBR , DISTRIB_LINE_NUM , DST_ACCT_TYPE , APPL_JRNL_ID , UNPOST_SEQ , SHEET_ID_RELATED , TRANS_TYPE_CD , EMPLID , SELECT_FLAG , RESET_KK_HDR , DB_ENTERED FROM PS_EX_BGTCHK_REQ3 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | REQUEST_NBR |
Number(4,0) | SMALLINT NOT NULL | Request Number |
| 4 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 5 | 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. |
| 6 | EX_DOC_ID |
Character(10) | VARCHAR2(10) NOT NULL | Documentation ID |
| 7 | 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 |
| 8 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 9 | DISTRIB_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 10 | DST_ACCT_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment |
| 11 | APPL_JRNL_ID |
Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
| 12 | UNPOST_SEQ |
Number(2,0) | SMALLINT NOT NULL | Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1". |
| 13 | SHEET_ID_RELATED | Character(10) | VARCHAR2(10) NOT NULL | Journal Report ID |
| 14 | TRANS_TYPE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Transaction Type
ACE=Encumbrance Relief Accruals ACX=Period End Accruals Expense CVD=Cancel Void Expense Reports EXP=All Expense Reports JER=Journal Expense Reports TAU=All Travel Authorizations |
| 15 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 16 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
N=No Y=Yes |
| 17 | RESET_KK_HDR | Character(1) | VARCHAR2(1) NOT NULL |
Reset Budget Status
N=No Y=Yes |
| 18 | DB_ENTERED | Character(1) | VARCHAR2(1) NOT NULL |
Saved To Database
N=No Y=Yes |