CSH_RCPT_TGT_VW

(SQL View)
 Index Back

Cashier Receipt Target View

SF Cashiering Receipt Target (Line) view.

SELECT A.BUSINESS_UNIT ,A.CASHIER_OFFICE ,A.RECEIPT_NBR ,A.RECEIPT_LINE_NBR ,A.TARGET_KEY ,A.STRM ,A.AMOUNT_SF ,A.CURRENCY_CD ,A.ACCOUNT ,A.CLASS_FLD ,A.DEPTID ,A.EXT_GL_CHARTFLD ,A.FUND_CODE ,A.BUSINESS_UNIT_GL ,A.PROGRAM_CODE ,A.PROJECT_ID ,A.TAX_AUTHORITY_CD ,A.BUDGET_REF ,A.CHARTFIELD1 ,A.CHARTFIELD2 ,A.CHARTFIELD3 ,A.ALTACCT ,A.OPERATING_UNIT ,A.PRODUCT ,A.AFFILIATE_INTRA1 ,A.AFFILIATE_INTRA2 ,A.AFFILIATE FROM PS_CSH_OFF_RCPT_L A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 CASHIER_OFFICE Character(8) VARCHAR2(8) NOT NULL Cashier's Office
3 RECEIPT_NBR Number(12,0) DECIMAL(12) NOT NULL Receipt Number
4 RECEIPT_LINE_NBR Number(3,0) SMALLINT NOT NULL Receipt Line Number
5 TARGET_KEY Character(10) VARCHAR2(10) NOT NULL Target Key
6 STRM Character(4) VARCHAR2(4) NOT NULL Term
7 AMOUNT_SF Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
9 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
10 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field.
11 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
12 EXT_GL_CHARTFLD Character(50) VARCHAR2(50) NOT NULL External GL Chart Field
13 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
14 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Unit
15 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code
16 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant
17 TAX_AUTHORITY_CD Character(3) VARCHAR2(3) NOT NULL Tax Authority
18 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference Chartfield
19 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield number 1
20 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
21 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
22 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
23 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit
24 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
25 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
26 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
27 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Public Sector Financials Chart Field