KK_TRAN_VW

(SQL View)
 Index Back

SELECT DISTINCT A.KK_TRAN_ID , A.KK_TRAN_DT ,A.KK_TRAN_LN ,A.LEDGER_GROUP ,A.BUSINESS_UNIT ,A.ACCOUNT , A.DEPTID ,%subrec(CF12_AN_SBR, A) ,%subrec(CFCC1_AN_SBR,A) , A.STATISTICS_CODE ,B.KK_PROCESS_STATUS ,A.EXCPTN_TYPE FROM PS_KK_EXCPTN_TBL A , PS_KK_SOURCE_HDR B WHERE A.KK_TRAN_ID = B.KK_TRAN_ID AND A.KK_TRAN_DT = B.KK_TRAN_DT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TRAN_ID Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
2 TRAN_DT Date(10) DATE Represents the transaction date in bank reconciliation processing.
3 KK_TRAN_LN Number(9,0) DECIMAL(9) NOT NULL Commitment Control Transaction Line number.
4 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
7 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
8 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
9 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
10 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
11 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
12 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
13 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
14 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
15 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
16 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
17 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
18 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
19 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
20 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
21 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
22 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
23 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
24 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period
25 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
26 KK_PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
E=Errors Exist
I=Document in process
N=Process Unsuccessful
P=Provisionally Valid
V=No Errors or Warnings
W=Only Warnings Exist
X=Unrecorded Errors Exist
27 EXCPTN_TYPE Character(3) VARCHAR2(3) NOT NULL Exception Type