CSH_OFFRCT_L_VW

(SQL View)
 Index Back

Cashier Office Receipt Line


SELECT A.BUSINESS_UNIT ,A.CASHIER_OFFICE ,A.RECEIPT_NBR ,A.RECEIPT_LINE_NBR ,A.TARGET_KEY ,A.ACCOUNT ,A.FUND_CODE ,A.DEPTID ,A.PROGRAM_CODE ,A.PROJECT_ID ,A.AMOUNT_SF ,A.CURRENCY_CD ,A.CSH_OFF_TRAN_TYPE ,A.EXT_GL_CHARTFLD ,A.BUSINESS_UNIT_GL ,A.TAX_ROW ,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 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 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
7 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
8 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
9 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code
10 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant
11 AMOUNT_SF Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
13 CSH_OFF_TRAN_TYPE Character(2) VARCHAR2(2) NOT NULL Cashier's Office Transaction
01=Open Register
02=Student Payment
03=Departmental Receipt
04=Cash Check
05=Cash Withdrawl
06=Close Register
07=Interim Deposit
08=Corporate Payment
14 EXT_GL_CHARTFLD Character(50) VARCHAR2(50) NOT NULL External GL Chart Field
15 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Unit
16 TAX_ROW Character(1) VARCHAR2(1) NOT NULL Tax
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