KK_XCP_PO4_VW2

(SQL View)
 Index Back

PO RcvAccr Exp Exception Lines

Join of KK_SOURCE_LN with the Source Line table and intermediate of KK_SOURCE_HDR. Retrieves specifics of the non-key source fields..

SELECT DISTINCT B.KK_TRAN_ID ,B.KK_TRAN_DT ,B.KK_TRAN_LN ,C.BUSINESS_UNIT ,C.RECEIVER_ID ,C.RECV_LN_NBR ,C.RECV_SHIP_SEQ_NBR ,C.DISTRIB_LINE_NUM ,C.DST_ACCT_TYPE ,C.APPL_JRNL_ID ,C.ACCOUNTING_PERIOD ,C.FISCAL_YEAR ,C.ORIGINAL_TRANS ,C.DT_TIMESTAMP ,C.BUSINESS_UNIT_GL ,C.ACCOUNT ,C.ALTACCT ,C.DEPTID ,%subrec(CF27_AN_SBR, C) ,%subrec(cfcc2_an_sbr,C) ,C.BUDGET_DT ,C.BUDGET_LINE_STATUS ,C.STATISTICS_CODE ,C.QTY_DS_ACCPT_SUOM ,C.FOREIGN_AMOUNT ,C.FOREIGN_CURRENCY ,C.MONETARY_AMOUNT ,C.CURRENCY_CD FROM PS_RECV_EXP_LN_VW1 C ,PS_KK_SOURCE_LN B ,PS_KK_SOURCE_HDR D WHERE B.KK_TRAN_ID = D.KK_TRAN_ID AND B.KK_TRAN_DT = D.KK_TRAN_DT AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND C.RECEIVER_ID = D.RECEIVER_ID AND C.RECV_LN_NBR = D.RECV_LN_NBR AND C.RECV_SHIP_SEQ_NBR= D.RECV_SHIP_SEQ_NBR AND C.DISTRIB_LINE_NUM = D.DISTRIB_LINE_NUM AND C.APPL_JRNL_ID = D.APPL_JRNL_ID AND C.ACCOUNTING_PERIOD = D.ACCOUNTING_PERIOD AND C.FISCAL_YEAR =D.FISCAL_YEAR AND C.DST_ACCT_TYPE = D.DST_ACCT_TYPE

  • Parent record: KK_XCP_PO1_VW1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 KK_TRAN_ID Character(10) VARCHAR2(10) NOT NULL Commitment Control Foreign Key for Transaction Identification.
    2 KK_TRAN_DT Date(10) DATE Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.
    3 KK_TRAN_LN Number(9,0) DECIMAL(9) NOT NULL Commitment Control Transaction Line number.
    4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    5 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
    6 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
    7 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
    8 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
    9 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
    10 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
    11 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
    12 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    13 ORIGINAL_TRANS Character(1) VARCHAR2(1) NOT NULL Receipt Accrual Original Trans
    14 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
    15 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
    16 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    17 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
    18 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

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

    Prompt Table: OPERUNT_NB_VW

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

    Prompt Table: PRODUCT_NB_VW

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

    Prompt Table: FUND_NB_VW

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

    Prompt Table: CLASS_CF_NB_VW

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

    Prompt Table: PROGRAM_NB_VW

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

    Prompt Table: BUD_REF_NB_VW

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

    Prompt Table: AFFILIATE_VW

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

    Prompt Table: %EDIT_INTRA01

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

    Prompt Table: %EDIT_INTRA02

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

    Prompt Table: CF1_NB_VW

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

    Prompt Table: CF2_NB_VW

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

    Prompt Table: CF3_NB_VW

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

    Prompt Table: PC_BU_GL_VW

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

    Prompt Table: PROJECT_ID_VW

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

    Prompt Table: PROJ_ACT_FVW

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

    Prompt Table: PROJ_RESTYPE_FS

    35 BUDGET_DT Date(10) DATE Budget Date
    36 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
    37 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
    38 KK_QUANTITY Signed Number(20,4) DECIMAL(18,4) NOT NULL Commitment Control Quantity
    39 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.
    40 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
    41 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.
    42 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code