ARCC_PAY_HDR_VW

(SQL View)
 Index Back

Misc Pay Distrib- CC hdr

Misc Pay Commitment Control Source transaction header view

SELECT b.deposit_bu , b.deposit_id , b.payment_seq_num , b.DEPOSIT_BU , b.business_unit_gl , b.gl_distrib_status , b.process_instance , b.accounting_dt , B.CC_AFFECTED , B.BUDGET_HDR_STATUS , B.KK_AMOUNT_TYPE , B.KK_TRAN_OVER_DTTM , B.KK_TRAN_OVER_FLAG , B.KK_TRAN_OVER_OPRID , B.MISC_DST_BAL FROM PS_PAYMENT B WHERE B.misc_payment='Y' AND B.misc_dst_bal IN ('C', 'I') AND B.CC_AFFECTED = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
2 DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
3 PAYMENT_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: PAYMENT.DEPOSIT_BU

5 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Default Value: PAYMENT.DEPOSIT_BU

Prompt Table: BUS_UNIT_TBL_GL

6 GL_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Status
C=Available to Contracts
D=Distributed
G=Generated
H=Hold
I=Ignored
J=Creating Journals
M=Modified
N=None
P=To be processed
X=Waiting for Reversal

Default Value: N

7 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
8 ACCOUNTING_DT Date(10) DATE NOT NULL The accounting entry construction date for a given transaction (a generic field that crosses multiple

Default Value: PAYMENT.ACCOUNTING_DT

9 CC_AFFECTED Character(1) VARCHAR2(1) NOT NULL Indicate whether commitment control (revenue estimate) is affected.
N=No
Y=Yes
10 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
11 KK_AMOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic
12 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime
13 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes
14 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator
15 MISC_DST_BAL Character(1) VARCHAR2(1) NOT NULL Non Customer Dist Balanced
C=Journal Complete
I=Balanced
N=No Distribution
O=Out of Balance