KK_XCP_AR1_VW2

(SQL View)
 Index Back

AR1 Rev Est Exception Lines

Join of KK_SOURCE_LN with the Source Line table via 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.CUST_ID ,C.ITEM ,C.ITEM_LINE ,C.ITEM_SEQ_NUM ,C.CC_GROUP_SEQ_NUM ,C.CC_SEQ_NUM ,C.BUSINESS_UNIT_GL ,C.ACCOUNT ,C.ALTACCT , C.DEPTID , %subrec(CF14_AN_SBR, C) ,%subrec(cfcc2_an_sbr,C) ,C.BUDGET_DT ,C.BUDGET_LINE_STATUS ,C.STATISTICS_CODE ,C.STATISTIC_AMOUNT ,C.FOREIGN_AMOUNT ,C.FOREIGN_CURRENCY ,C.MONETARY_AMOUNT ,C.CURRENCY_CD FROM PS_AR_CC_TRAN_TBL 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.CUST_ID = D.CUST_ID AND C.ITEM = D.ITEM AND C.ITEM_LINE = D.ITEM_LINE AND C.ITEM_SEQ_NUM = D.ITEM_SEQ_NUM AND C.CC_GROUP_SEQ_NUM = D.CC_GROUP_SEQ_NUM AND C.CC_SEQ_NUM = B.CC_SEQ_NUM

  • Parent record: KK_XCP_AR1_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 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
    6 ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
    7 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
    8 ITEM_SEQ_NUM Number(3,0) SMALLINT NOT NULL Item Sequence Number
    9 CC_GROUP_SEQ_NUM Number(6,0) INTEGER NOT NULL Group Sequency
    10 CC_SEQ_NUM Number(6,0) INTEGER NOT NULL Sequence number
    11 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
    12 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    13 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
    14 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

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

    Prompt Table: OPER_UNIT_TBL

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

    Prompt Table: PRODUCT_TBL

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

    Prompt Table: FUND_TBL

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

    Prompt Table: CLASS_CF_TBL

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

    Prompt Table: PROGRAM_TBL

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

    Prompt Table: BUD_REF_TBL

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

    Prompt Table: AFFILIATE_VW

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

    Prompt Table: %EDIT_INTRA01

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

    Prompt Table: %EDIT_INTRA02

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

    Prompt Table: CHARTFIELD1_TBL

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

    Prompt Table: CHARTFIELD2_TBL

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

    Prompt Table: CHARTFIELD3_TBL

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

    Prompt Table: PC_BU_GL_VW

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

    Prompt Table: PROJECT_ID_VW

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

    Prompt Table: PROJ_ACT_FVW

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

    Prompt Table: PROJ_RESTYPE_FS

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