EX_VAT_HDR_VW (SQL View)	Index Back
Expense Sheet VAT Hdr View

EX_VAT_HDR_VW

(SQL View)

Expense Sheet VAT Hdr View

SELECT SHEET_ID ,'S' ,EMPLID ,SHEET_STATUS ,EX_ORIGIN ,APPROVAL_LEVEL ,CREATION_DT ,APPROVAL_DT ,AUDIT_DT ,AUDIT_OPRID ,SUBMISSION_DATE ,RESUBMISSION_DT ,LASTUPDDTTM ,OPRID_LAST_UPDT ,RCPT_VERIFY_DT ,RCPT_VERIFY_OPRID ,RECEIPTS_RECEIVED ,DST_CNTRL_ID ,REFERENCE_ID ,SHEET_NAME ,SETID ,BUSINESS_UNIT_GL ,EMPL_RCD ,RECEIPT_ID ,POST_STATUS_EX ,ADVANCE_ID ,ADVANCE_AMT ,ACCOUNTING_DT ,PROCESS_INSTANCE ,PROCESS_FLAG ,UNPOST_SEQ ,REVERSAL_DATE ,BUSINESS_PURPOSE ,DOC_TYPE ,DOC_SEQ_NBR ,DOC_SEQ_DATE ,OPRID_ENTERED_BY ,PROJ_MGR_FLAG ,COUNTRY ,VAT_ENTITY FROM PS_EX_SHEET_HDR

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 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

5 EX_ORIGIN Character(1) VARCHAR2(1) NOT NULL Origin of Entry (Expenses)
A=Asset Lifecycle Management
H=Mobile Hand Held Device
M=Mobile Time and Expense
N=NUI
P=Primavera P6
W=Web

6 APPROVAL_LEVEL Character(1) VARCHAR2(1) NOT NULL Approval Level
A=Approver Only
B=Pre- and Post-Pay Audit
E=Approver & Pre-Pay Auditor
I=Approve, Pre- & Post-Pay Audit
N=None
S=Approver & Post-Pay Auditor
T=Auditor Only - Post-Payment
U=Auditor Only - Pre-Payment

7 CREATION_DT Date(10) DATE Creation Date

8 APPROVAL_DT Date(10) DATE Date of Approval

9 AUDIT_DT Date(10) DATE Date of Audit

10 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.

11 SUBMISSION_DATE Date(10) DATE Submission Date

12 RESUBMISSION_DT Date(10) DATE Resubmission Date

13 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

14 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update

15 RCPT_VERIFY_DT Date(10) DATE Date of Verification

16 RCPT_VERIFY_OPRID Character(30) VARCHAR2(30) NOT NULL Verification UserID

17 RECEIPTS_RECEIVED Character(1) VARCHAR2(1) NOT NULL Receipts Received

18 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template

19 REFERENCE_ID Character(10) VARCHAR2(10) NOT NULL Reference ID

20 SHEET_NAME Character(30) VARCHAR2(30) NOT NULL Report Description

21 SETID Character(5) VARCHAR2(5) NOT NULL SetID

22 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

23 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

24 RECEIPT_ID Character(10) VARCHAR2(10) NOT NULL Receipt ID

25 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

26 ADVANCE_ID Character(10) VARCHAR2(10) NOT NULL Advance ID

27 ADVANCE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Advance Amount

28 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

29 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

30 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least

31 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".

32 REVERSAL_DATE Date(10) DATE Specifies the date for an automatic reversal journal entry. The date must be within the calendar of the target (posting) ledger. PeopleSoft General Ledger automatically creates and populates a journal entry with this date.

33 BUSINESS_PURPOSE Character(5) VARCHAR2(5) NOT NULL Business Purpose

34 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.

35 DOC_SEQ_NBR Character(12) VARCHAR2(12) NOT NULL Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.

36 DOC_SEQ_DATE Date(10) DATE Specifies the date that a document sequence number is assigned to a document or the date the document was created.

37 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes

38 PROJ_MGR_FLAG Character(1) VARCHAR2(1) NOT NULL Project Manager Review

39 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

40 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.

#	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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	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
5	EX_ORIGIN	Character(1)	VARCHAR2(1) NOT NULL	Origin of Entry (Expenses) A=Asset Lifecycle Management H=Mobile Hand Held Device M=Mobile Time and Expense N=NUI P=Primavera P6 W=Web
6	APPROVAL_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Approval Level A=Approver Only B=Pre- and Post-Pay Audit E=Approver & Pre-Pay Auditor I=Approve, Pre- & Post-Pay Audit N=None S=Approver & Post-Pay Auditor T=Auditor Only - Post-Payment U=Auditor Only - Pre-Payment
7	CREATION_DT	Date(10)	DATE	Creation Date
8	APPROVAL_DT	Date(10)	DATE	Date of Approval
9	AUDIT_DT	Date(10)	DATE	Date of Audit
10	AUDIT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The OPRID of the user who made the changes audited on an audit record.
11	SUBMISSION_DATE	Date(10)	DATE	Submission Date
12	RESUBMISSION_DT	Date(10)	DATE	Resubmission Date
13	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
14	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update
15	RCPT_VERIFY_DT	Date(10)	DATE	Date of Verification
16	RCPT_VERIFY_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Verification UserID
17	RECEIPTS_RECEIVED	Character(1)	VARCHAR2(1) NOT NULL	Receipts Received
18	DST_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Accounting Template
19	REFERENCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Reference ID
20	SHEET_NAME	Character(30)	VARCHAR2(30) NOT NULL	Report Description
21	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
22	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
23	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
24	RECEIPT_ID	Character(10)	VARCHAR2(10) NOT NULL	Receipt ID
25	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
26	ADVANCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Advance ID
27	ADVANCE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Advance Amount
28	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
29	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
30	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least
31	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".
32	REVERSAL_DATE	Date(10)	DATE	Specifies the date for an automatic reversal journal entry. The date must be within the calendar of the target (posting) ledger. PeopleSoft General Ledger automatically creates and populates a journal entry with this date.
33	BUSINESS_PURPOSE	Character(5)	VARCHAR2(5) NOT NULL	Business Purpose
34	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
35	DOC_SEQ_NBR	Character(12)	VARCHAR2(12) NOT NULL	Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
36	DOC_SEQ_DATE	Date(10)	DATE	Specifies the date that a document sequence number is assigned to a document or the date the document was created.
37	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
38	PROJ_MGR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Project Manager Review
39	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
40	VAT_ENTITY	Character(20)	VARCHAR2(20) NOT NULL	Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.