GM_OPPTY_DTL_TM

(SQL Table)
 Index Back

PM Resource Line Detail

PM Resource Line Detail

  • Related Language Record: GM_OPPTY_TM_LNG

  • Parent Record Of GM_PM_DTL_RSRC GM_PM_DTL_SCMT GM_PM_DTL_SCST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PROPOSAL_ID Character(25) VARCHAR2(25) NOT NULL Proposal ID
    3 VERSION_ID Character(7) VARCHAR2(7) NOT NULL Version ID
    4 SUB_PROP_NBR Character(15) VARCHAR2(15) NOT NULL SUB_PROP_NBR
    5 BUDGET_ID Character(15) VARCHAR2(15) NOT NULL BUDGET_ID
    6 BUDGET_PERIOD_GM Number(3,0) SMALLINT NOT NULL BUDGET_PERIOD_GM

    Default Value: 1

    7 BUDGET_LN Number(6,0) INTEGER NOT NULL BUDGET_LN

    Default Value: 10

    8 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    9 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 BEGIN_DT Date(10) DATE Begin Date

    Default Value: GM_BUD_HDR.BEGIN_DT

    12 END_DT Date(10) DATE End Date

    Default Value: GM_BUD_HDR.END_DT

    13 TEAM_MEMBER_IND Character(1) VARCHAR2(1) NOT NULL Team Member Indicator
    E=Employee
    G=Generic Resource
    N=Not Applicable
    14 GM_TEAM_MEMBER Character(25) VARCHAR2(25) NOT NULL Team Member
    15 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    16 TEAM_MEMBER_CLASS Character(1) VARCHAR2(1) NOT NULL 05/26/2004 - FS Translate Value "O" added.
    A=Asset
    L=Labor
    M=Material
    O=Other
    17 BUDGET_CATEGORY Character(15) VARCHAR2(15) NOT NULL BUDGET_CATEGORY

    Prompt Table: %EDITTABLE9
    Set Control Field: BUSINESS_UNIT_PC

    18 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

    19 SUBCONTRACT_TYPES Character(1) VARCHAR2(1) NOT NULL Subcontract Type
    C=Cost Reimbursable
    F=FP Fee
    N=Not Available
    O=Other
    P=Fixed Price

    Default Value: C

    20 ASSET_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Asset or Item ID

    Prompt Table: %EDITTABLE8

    21 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
    22 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Prompt Table: RS_PROJROLE_VW

    23 QTY_INTEGER Number(11,0) DECIMAL(11) NOT NULL Quantity Rounded to 0 Decimals

    Default Value: 1

    24 NBR_OF_HOURS Number(5,0) INTEGER NOT NULL Number of Hours
    25 QTY_X_HOURS Number(11,0) DECIMAL(11) NOT NULL Quantity * Hours

    Default Value: 1

    26 NBR_OF_DAYS Number(5,0) INTEGER NOT NULL Number of Days
    27 WEEKLY_WEEKS Number(3,0) SMALLINT NOT NULL Weeks
    28 QTY_X_WEEKS Number(11,0) DECIMAL(11) NOT NULL Quantity * Weeks
    29 STD_BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Standard Bill Rate

    Default Value: 0

    30 ADJUSTED_FLAG_BILL Character(1) VARCHAR2(1) NOT NULL Adjusted Flag
    H=Header Level Adjustment
    L=Line Level Adjustment
    N=No Adjustments

    Default Value: N

    31 ADJUST_OPTION_BILL Character(1) VARCHAR2(1) NOT NULL Adjustment Option Bill Rate
    A=Flat Amount
    N=No Adjustment
    P=Percentage
    R=New Rate

    Default Value: N

    32 ADJUSTMENT_BILLAMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Adjustment Bill Amount
    33 ADJUSTMENT_BILLPCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Adjustment Bill Percent
    34 ADJUSTMENT_BILL_RT Number(27,3) DECIMAL(26,3) NOT NULL Adjustment Bill Rate
    35 ACTUAL_BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Actual Bill Rate
    36 STD_COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Standard Cost Rate

    Default Value: 0

    37 ADJUSTED_FLAG_COST Character(1) VARCHAR2(1) NOT NULL Adjusted Flag
    H=Header Level Adjustment
    L=Line Level Adjustment
    N=No Adjustments

    Default Value: N

    38 ADJUST_OPTION_COST Character(1) VARCHAR2(1) NOT NULL Adjustment Option Cost Rate
    A=Flat Amount
    N=No Adjustment
    P=Percentage
    R=New Rate

    Default Value: N

    39 ADJUSTMENT_COSTAMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Adjustment Cost Amount
    40 ADJUSTMENT_COSTPCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Adjustment Cost Percent
    41 ADJUSTMENT_COST_RT Number(27,3) DECIMAL(26,3) NOT NULL Adjustment Cost Rate
    42 ACTUAL_COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Actual Cost Rate
    43 BILL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Bill Amount
    44 COST_AMT Number(27,3) DECIMAL(26,3) NOT NULL Cost Amount
    45 PM_MARGIN_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Margin Percent
    46 RS_RESRC_TEMPLT_ID Character(10) VARCHAR2(10) NOT NULL Resource Template ID

    Prompt Table: RS_RESRC_TMP_VW

    47 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PC_RATE_EMPL

    48 REVIEW Character(1) VARCHAR2(1) NOT NULL Review
    49 RES_RATE_FLG Character(1) VARCHAR2(1) NOT NULL Resource Rate
    E=Employee ID
    J=Job Code
    R=Role Type

    Default Value: R

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

    Default Value: GM_BUD_HDR.CURRENCY_CD

    51 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

    Prompt Table: RS_REGION_VW

    52 POOL_ID Character(10) VARCHAR2(10) NOT NULL Pool ID field.

    Prompt Table: RS_RES_POOL

    53 NOTE Long Character(256) VARCHAR2(256) Note