RBF_ALCP_CIS_VW

(SQL View)
 Index Back

Search record for the 8.4CI

Search record for the RBF_ALTCAPACITY_CI component for the 8.4 CI

SELECT A.ALT_CAP_ID , B.BO_ID , B.BO_NAME , B.BO_NAME_AC , A.TIN_TYPE , A.TIN , A.SETID , A.CHAM_OF_COMM_NBR , A.LEGAL_FORM , C.CUST_STATUS , C.SEGMENT FROM PS_RBF_ALT_CAP A , PS_BO_NAME B , PS_BC C WHERE A.BO_ID = B.BO_ID AND A.BO_ID= C.BO_ID AND B.BO_ID= C.BO_ID AND A.SETID <> ' ' AND B.PRIMARY_IND = 'Y'

  • Parent record: BO

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ALT_CAP_ID Character(15) VARCHAR2(15) NOT NULL Alternate Capacity ID

    Default Value: NEXT

    2 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

    Default Value: 999999999999999999

    3 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    4 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
    5 TIN_TYPE Character(1) VARCHAR2(1) NOT NULL Tin Type
    F=Federal Employer ID
    S=Social Security Number
    6 TIN Character(20) VARCHAR2(20) NOT NULL TIN
    7 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    8 CHAM_OF_COMM_NBR Character(18) VARCHAR2(18) NOT NULL Chamber of Commerce
    9 LEGAL_FORM Character(30) VARCHAR2(30) NOT NULL legal form
    10 CUST_STATUS Character(1) VARCHAR2(1) NOT NULL Customer Status Indicator. BC.CUST_STATUS
    A=Active
    I=Inactive
    11 SEGMENT Character(4) VARCHAR2(4) NOT NULL Segment code for customer data