ARCC_PAY_DTL2VW

(SQL View)
Index Back

Misc Pay Distrib- Jrnl Gen


SELECT b.deposit_bu , b.deposit_id , b.payment_seq_num , b.dst_seq_num , b.business_unit , b.foreign_currency , b.business_unit_gl , b.account , b.altacct , B.DEPTID , %subrec(CF16_AN_SBR, b) , %subrec(PC_CF1_N_SBR, b) , b.statistics_code , b.monetary_amount , b.statistic_amount , b.gl_distrib_status , b.process_instance , b.accounting_dt , b.foreign_amount , b.rt_type , b.rate_mult , b.rate_div , b.currency_cd , b.ledger , b.ledger_group , B.CC_AFFECTED , B.BUDGET_DT , B.BUDGET_LINE_STATUS , B.FOREIGN_AMOUNT_CC , B.MONETARY_AMOUNT_CC FROM ps_payment a , PS_PAY_MISC_DST b WHERE a.deposit_bu=b.deposit_bu AND a.deposit_id=b.deposit_id AND a.payment_seq_num=b.payment_seq_num AND a.misc_payment='Y' AND a.misc_dst_bal='C' AND A.CC_AFFECTED = 'Y' AND B.CC_AFFECTED = 'Y' AND B.SYSTEM_DEFINED = 'U'

# 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 DST_SEQ_NUM Number(6,0) INTEGER NOT NULL Distribution Sequence
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: PAYMENT.DEPOSIT_BU

6 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

Default Value: PAYMENT.PAYMENT_CURRENCY

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

Default Value: PAYMENT.DEPOSIT_BU

Prompt Table: BUS_UNIT_TBL_GL

8 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: GL_ACCOUNT_TBL

9 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

11 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

23 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: %EDIT_BU_PC

24 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: %EDIT_PROJECT

25 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDIT_ACTIVITY

26 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

27 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

28 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

29 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

30 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
31 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
32 STATISTIC_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
33 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

34 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
35 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

36 FOREIGN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
37 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

Default Value: PAYMENT.PYMT_RT_TYPE

38 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

Default Value: PAYMENT.PYMT_RATE_MULT

39 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

Default Value: 1

40 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: PAYMENT.CURRENCY_CD

41 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
42 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
43 CC_AFFECTED Character(1) VARCHAR2(1) NOT NULL Indicate whether commitment control (revenue estimate) is affected.
N=No
Y=Yes
44 BUDGET_DT Date(10) DATE Budget Date
45 BUDGET_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL -> SL - 15-AUG-2002 MISC_CRITERIA label has been added <-
B=Bypass
E=Error
N=Not Chk'd
V=Valid
W=Warning
46 FOREIGN_AMOUNT_CC Signed Number(28,3) DECIMAL(26,3) NOT NULL "The deal transaction amount in the denominated
47 MONETARY_AMOUNT_CC Signed Number(28,3) DECIMAL(26,3) NOT NULL Budget Base Amount