TP_CHARGES

(SQL Table)
 Index Back

Third Party Allowable Charges

  • Parent record: TP_CONTRACT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

    Prompt Table: TP_CONTRACT

    3 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr
    4 SSF_TP_NODE_STATUS Character(1) VARCHAR2(1) NOT NULL Third Party Node Status
    A=Active
    I=Inactive

    Default Value: A

    5 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

    Prompt Table: TREE_NODE_SF_VW

    6 TP_ALLOW_CAP Number(15,2) DECIMAL(14,2) NOT NULL Third Party Allowable CAP
    7 TP_ALLOW_PERCENT Number(9,5) DECIMAL(8,5) NOT NULL Third Party Percentage
    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: TP_CONTRACT.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    9 MAX_DEFER_AMT Number(15,2) DECIMAL(14,2) NOT NULL Maximum Defer Amount
    10 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Default Value: TP_CONTRACT.ITEM_TYPE

    Prompt Table: SP_ITEMCH_NONVW

    11 TP_DISC_PERCENT Number(9,5) DECIMAL(8,5) NOT NULL Discount Percentage given to the organization for third party contract
    12 TP_DISC_ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type for the corporate discount

    Default Value: TP_CONTRACT.TP_DISC_ITEM_TYPE

    Prompt Table: %EDITTABLE

    13 SF_TP_INCLUDE_TAX Character(1) VARCHAR2(1) NOT NULL Include Charge Item Tax

    Y/N Table Edit

    Default Value: N

    14 SF_TP_TAX_ITEM_TYP Character(12) VARCHAR2(12) NOT NULL Pay Tax Item Type

    Prompt Table: SP_ITEMCH_NONVW

    15 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    16 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    17 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    18 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time