EX_SHT_RCLM_VW

(SQL View)
Index Back

SELECT a.BUSINESS_UNIT_GL , b.COUNTRY , a.SHEET_ID , b.LINE_NBR , a.EMPLID , a.SHEET_STATUS , a.CREATION_DT , a.SHEET_NAME , b.EXPENSE_TYPE , b.TRANS_DT , b.MERCHANT_CD , b.MERCHANT , b.TXN_AMOUNT , b.TXN_CURRENCY_CD , b.VAT_RECLAIM_PCT , b.VAT_TREATMENT FROM PS_EX_SHEET_HDR a , PS_EX_SHEET_LINE b , PS_BUS_UNIT_TBL_EX c WHERE c.VAT_RCRD_FRGN_FLG='Y' AND a.BUSINESS_UNIT_GL=c.BUSINESS_UNIT_GL AND a.SHEET_ID=b.SHEET_ID AND b.VAT_TREATMENT IN ('FGE','FSE')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Default Value: EX_AA_EE_ORG_VW.BUSINESS_UNIT_GL

2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
3 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

Default Value: 1

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

Default Value: PND

7 CREATION_DT Date(10) DATE Creation Date

Default Value: %date

8 SHEET_NAME Character(30) VARCHAR2(30) NOT NULL Report Description
9 EXPENSE_TYPE Character(7) VARCHAR2(7) NOT NULL Expense Type

Prompt Table: EX_TYPES_TBL

10 TRANS_DT Date(10) DATE Transaction Date
11 MERCHANT_CD Character(10) VARCHAR2(10) NOT NULL Preferred Merchant

Prompt Table: EX_MERCHANT_VW

12 MERCHANT Character(40) VARCHAR2(40) NOT NULL Merchant
13 TXN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
14 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY

Prompt Table: CURRENCY_CD_TBL

15 VAT_RECLAIM_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Reclaim Percent
16 VAT_TREATMENT Character(4) VARCHAR2(4) NOT NULL VAT Treatment