PC_UAP_BAJ_VW

(SQL View)
 Index Back

Unapplied Billing Adjustments

A view that returns Unapplied Billing Adjustments (BAJ rows) from PROJ_RESOURCE. Note: Any changes to this view must be replicated in the corresponding CF security view, SEC_PCUAPBJ_DVW.

SELECT DISTINCT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , A.RESOURCE_ID , A.RESOURCE_ID_FROM , 'N' , A.FND_DIST_STATUS , A.RESOURCE_TYPE , A.RESOURCE_CATEGORY , A.RESOURCE_SUB_CAT , A.TRANS_DT , A.ACCOUNTING_DT , A.RESOURCE_AMOUNT , A.CURRENCY_CD , A.ADJ_LINE_TYPE , A.CONTRACT_NUM , A.CONTRACT_LINE_NUM , A.INVOICE , A.ACCOUNT , A.ALTACCT , A.DEPTID , %subrec(CFS16_AN_SBR, A) , A.ACTIVITY_ID_DETAIL , A.DIST_TRANS_ID FROM PS_PROJ_RESOURCE A , PS_PC_FND B WHERE A.ANALYSIS_TYPE = 'BAJ' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.SYSTEM_SOURCE IN ('BBI', 'CBI', 'PBI')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
4 RESOURCE_ID Character(40) VARCHAR2(40) NOT NULL Transaction ID
5 RESOURCE_ID_FROM Character(40) VARCHAR2(40) NOT NULL Original Transaction ID
6 RELATED_SW Character(1) VARCHAR2(1) NOT NULL An indicator that determines whether a transaction is related to another transaction.

Y/N Table Edit

7 FND_DIST_STATUS Character(1) VARCHAR2(1) NOT NULL Funds Distribution Status
1=No Matching Sequence
2=Insufficient Threshold Amount
3=Insufficient Distribute Amount
A=Active
B=Funds Burden
C=Complete
D=Distributed
G=Generated
H=Related BAJ Row
I=Ignore
N=Not Disitrbuted
8 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
9 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
10 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
11 TRANS_DT Date(10) DATE Transaction Date
12 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
13 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
15 BAJ_LINE_TYPE Character(3) VARCHAR2(3) NOT NULL Copied from ADJ_LINE_TYPE with a couple of additional translate values for reporting BAJ rows.
ACR=Adjustment Credit Line
ADJ=Adjustment
ARB=Adjustment Rebill Line
RCR=Reversals
REG=Regular bill line (not adjust)
RRB=Rebill
16 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
17 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
18 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
19 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
20 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
21 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
22 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: %EDIT_OPER_UNIT

23 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: %EDIT_PRODUCT

24 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: %EDIT_FUND_CODE

25 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: %EDIT_CLASS_FLD

26 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: %EDIT_PROG_CODE

27 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: %EDIT_BUD_REF

28 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

29 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

30 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

31 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: %EDIT_CHARTFLD1

32 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: %EDIT_CHARTFLD2

33 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: %EDIT_CHARTFLD3

34 ACTIVITY_ID_FROM Character(15) VARCHAR2(15) NOT NULL Original Activity ID
35 DIST_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Distribution Transaction ID