TD_CHECKBOOK2VW

(SQL View)
 Index Back

Checkbook Definition Header


SELECT SETID , TD_CHECKBOOK_ID , DESCR , TD_CHECK_FORMAT , CURRENCY_CD , UNIT_OF_MEASURE , TD_TREE_ID_CUST , TD_TREE_EFFDT_CUST , TD_TREE_ID_PROD , TD_TREE_EFFDT_PROD , TD_USE_RECENT_EFFT , TD_USE_DEF_TREE , TD_CHECK_AVAIL , TD_DISC_FUND_AVAIL , TD_NOND_FUND_AVAIL , TD_FUND_DIST_DISP , START_DATE , END_DATE , OVERRIDEDFLTVALUE , OVERRIDE , TD_FUND_CODE , PPRC_PROMO_CD , CUST_ID , TD_PROMO_TYPE , PROMO_GROUP , PRODUCT_ID , BUSINESS_UNIT_GL , TD_USE_FILTERS FROM PS_TD_CHECKBOOK

  • Related Language Record: TD_CHECKBK_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 TD_CHECKBOOK_ID Character(10) VARCHAR2(10) NOT NULL Promotions Management Checkbook ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 TD_CHECK_FORMAT Character(1) VARCHAR2(1) NOT NULL Display Format
    C=Custom
    P=Product Tree
    T=Customer Tree

    Default Value: C

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

    Prompt Table: CURRENCY_CD_TBL

    6 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_TBL

    7 TD_TREE_ID_CUST Character(8) VARCHAR2(8) NOT NULL Customer Tree ID

    Prompt Table: TD_TREE_CUST_VW

    8 TD_TREE_EFFDT_CUST Date(10) DATE Customer Effdt

    Prompt Table: TD_TREE_CUS_VW1

    9 TD_TREE_ID_PROD Character(8) VARCHAR2(8) NOT NULL Product Tree ID

    Prompt Table: TD_TREE_PROD_VW

    10 TD_TREE_EFFDT_PROD Date(10) DATE Product Effdt

    Prompt Table: TD_TREE_PRD_VW1

    11 TD_USE_RECENT_EFFT Character(1) VARCHAR2(1) NOT NULL Use Most Recent Effective Date

    Y/N Table Edit

    Default Value: Y

    12 TD_USE_DEF_TREE Character(1) VARCHAR2(1) NOT NULL Use SetID Default Tree

    Y/N Table Edit

    Default Value: Y

    13 TD_CHECK_AVAIL Character(1) VARCHAR2(1) NOT NULL Checkbook Review

    Y/N Table Edit

    Default Value: Y

    14 TD_DISC_FUND_AVAIL Character(1) VARCHAR2(1) NOT NULL Discretionary Fund Budget

    Y/N Table Edit

    Default Value: N

    15 TD_NOND_FUND_AVAIL Character(1) VARCHAR2(1) NOT NULL Non-Discretionary Fund Budget

    Y/N Table Edit

    Default Value: N

    16 TD_FUND_DIST_DISP Character(1) VARCHAR2(1) NOT NULL Display Budget
    A=Amounts
    B=Amounts & Units
    U=Units

    Default Value: B

    17 START_DATE Date(10) DATE Start Date for Gen Standing PO
    18 END_DATE Date(10) DATE End Date
    19 OVERRIDEDFLTVALUE Character(1) VARCHAR2(1) NOT NULL Can Over-Ride Defualt Value
    0=Disable
    1=Enable

    Y/N Table Edit

    Default Value: Y

    20 OVERRIDE Character(1) VARCHAR2(1) NOT NULL Copy Method
    A=Append
    O=Override

    Y/N Table Edit

    Default Value: Y

    21 TD_FUND_CODE Character(10) VARCHAR2(10) NOT NULL Promotions Management Fund Code

    Prompt Table: TD_FUND_MASTER

    22 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code

    Prompt Table: PPRC_PROMO_TBL

    23 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.

    Prompt Table: TD_CUST_OPRVW

    24 TD_PROMO_TYPE Character(1) VARCHAR2(1) NOT NULL Promo Type
    1=Promo Group
    2=Promo Product

    Default Value: 1

    25 PROMO_GROUP Character(10) VARCHAR2(10) NOT NULL Promotional Group

    Prompt Table: TD_PROMO_OPRVW

    26 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: TD_PROD_OPRVW

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

    Prompt Table: SP_BUTDGL_NONVW

    28 TD_USE_FILTERS Character(1) VARCHAR2(1) NOT NULL Use Filter