EX_SHEET_HL_VW

(SQL View)
 Index Back

Sheet View


SELECT A.SHEET_ID, A.EMPLID, B.LINE_NBR, A.UNPOST_SEQ, A.BUSINESS_UNIT_GL, A.SHEET_STATUS, A.CREATION_DT, A.APPROVAL_DT, A.ACCOUNTING_DT, A.DST_CNTRL_ID, B.EXPEND_MTHD, B.REIMBURSEMENT_CD, A.POST_STATUS_EX, B.MONETARY_AMOUNT, B.CURRENCY_CD, B.TXN_AMOUNT, B.TXN_CURRENCY_CD, B.RATE_MULT, B.RATE_DIV, B.RT_TYPE, A.ADVANCE_ID, A.PROCESS_INSTANCE ,A.PROJ_MGR_FLAG FROM PS_EX_SHEET_HDR A, PS_EX_SHEET_LINE B WHERE B.SHEET_ID = A.SHEET_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 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".
5 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
6 SHEET_STATUS Character(3) VARCHAR2(3) NOT NULL Report Status
APY=Approved for Payment
APZ=Approved For Zero Payment
CLS=Closed
DEN=Denied
DNA=Denied by Approver
DNU=Denied by Auditor
ESC=Escheated Payment
HDA=On Hold, with Approver
HDU=On Hold, with Auditor
HLD=On Hold
MFS=Marked for Submit
OPN=Open
PAR=Approvals in Process
PD=Paid
PND=Pending
PRO=In Process
RAP=Approved
SFA=Submission in Process
STG=Staged
SUB=Submitted for Approval
XML=Submitted, Pending Validation
7 CREATION_DT Date(10) DATE Creation Date
8 APPROVAL_DT Date(10) DATE Date of Approval
9 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
10 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template
11 EXPEND_MTHD Character(3) VARCHAR2(3) NOT NULL Payment Type
12 REIMBURSEMENT_CD Character(1) VARCHAR2(1) NOT NULL Deny
N=Nonreimburseable
P=Prepaid
R=Reimburseable
13 POST_STATUS_EX Character(1) VARCHAR2(1) NOT NULL Expenses Post Status
C=Closed
M=Marked for Unpost
N=Not Applied
O=Unpost In Process
P=Posted
S=Close In Process
U=Unposted
14 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.
15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
16 TXN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
17 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
18 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
19 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
20 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
21 ADVANCE_ID Character(10) VARCHAR2(10) NOT NULL Advance ID
22 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
23 PROJ_MGR_FLAG Character(1) VARCHAR2(1) NOT NULL Project Manager Review