INTFC_PC_ADJ_VW

(SQL View)
 Index Back

Project Resources


SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , A.INTFC_ID , A.INTFC_LINE_NUM , A.RESOURCE_ID , A.RESOURCE_ID_FROM , A.BUSINESS_UNIT_GL , A.JOURNAL_ID , A.JOURNAL_DATE , A.UNPOST_SEQ , A.JOURNAL_LINE , A.FISCAL_YEAR , A.ACCOUNTING_PERIOD , A.ACCOUNT , A.ALTACCT , A.DEPTID ,%subrec(CF16_AN_SBR, A) , A.BUS_UNIT_GL_FROM , A.CURRENCY_CD , A.STATISTICS_CODE , B.SETID , B.ANALYSIS_GROUP , A.LEDGER_GROUP , A.ANALYSIS_TYPE , A.RESOURCE_TYPE , A.RESOURCE_CATEGORY , A.RESOURCE_SUB_CAT , A.RES_USER1 , A.RES_USER2 , A.RES_USER3 , A.RES_USER4 , A.RES_USER5 , A.TRANS_DT , A.ACCOUNTING_DT , A.JRNL_LN_REF , A.OPEN_ITEM_STATUS , A.LINE_DESCR , A.JRNL_LINE_STATUS , A.JOURNAL_LINE_DATE , A.FOREIGN_CURRENCY , A.RT_TYPE , A.FOREIGN_AMOUNT , A.RATE_MULT , A.RATE_DIV , A.CUR_EFFDT , A.PROCESS_INSTANCE , A.PC_DISTRIB_STATUS , A.GL_DISTRIB_STATUS , A.PROJ_TRANS_TYPE , A.PROJ_TRANS_CODE , A.RESOURCE_STATUS , A.DESCR , A.SYSTEM_SOURCE , A.UNIT_OF_MEASURE , A.EMPLID , A.EMPL_RCD , A.SEQ_NBR , A.TIME_RPTG_CD , A.JOBCODE , A.COMPANY , A.BUSINESS_UNIT_AP , A.VENDOR_ID , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.APPL_JRNL_ID , A.PYMNT_CNT , A.DST_ACCT_TYPE , A.PO_DISTRIB_STATUS , A.BUSINESS_UNIT_PO , A.REQ_ID , A.REQ_LINE_NBR , A.REQ_SCHED_NBR , A.REQ_DISTRIB_NBR , A.PO_ID , A.DUE_DATE , A.LINE_NBR , A.SCHED_NBR , A.DISTRIB_LINE_NUM , A.AM_DISTRIB_STATUS , A.BUSINESS_UNIT_AM , A.ASSET_ID , A.PROFILE_ID , A.COST_TYPE , A.BOOK , A.INCENTIVE_ID , A.MSTONE_SEQ , A.CONTRACT_NUM , A.CONTRACT_LINE_NUM , A.CONTRACT_PPD_SEQ , A.BI_DISTRIB_STATUS , A.BUSINESS_UNIT_BI , A.BILLING_DATE , A.INVOICE , A.REV_DISTRIB_STATUS , A.BUSINESS_UNIT_AR , A.CUST_ID , A.ITEM , A.ITEM_LINE , A.ITEM_SEQ_NUM , A.DST_SEQ_NUM , A.BUSINESS_UNIT_IN , A.SCHED_LINE_NO , A.DEMAND_LINE_NO , A.INV_ITEM_ID , A.PAY_END_DT , A.BUSINESS_UNIT_OM , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.EX_DOC_ID , A.EX_DOC_TYPE , A.RESOURCE_QUANTITY , A.RESOURCE_AMOUNT , A.BUDGET_HDR_STATUS , A.KK_AMOUNT_TYPE , A.KK_SOURCE_TRAN , A.KK_DISTRIB_STATUS , A.KK_TRAN_OVER_FLAG , A.KK_TRAN_OVER_OPRID , A.KK_TRAN_OVER_DTTM , A.KK_GEN_PARENT , A.KK_PARENT_ENT_TYPE , A.KK_BUDG_TRANS_TYPE , A.ENTRY_EVENT , A.PC_KK_AE_TYPE , A.CALENDAR_ID , A.BUDGET_OVER_ALLOW , A.BUDGET_LINE_STATUS , A.BUDGET_DT , A.LEDGER , A.BD_DISTRIB_STATUS , A.BUSINESS_UNIT_BD , A.FA_STATUS , A.INTFC_TYPE , A.PC_INTFC_STATUS , A.PC_LOAD_STATUS , A.ORIG_INTFC_ID , A.ORIG_LINE_NUM , A.INTEGRATION_TMPL , A.QUANTITY , A.DESCR254 , A.SETID , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.COMBO_STATUS , A.CURRENCY_CD_GL , A.MONETARY_AMOUNT , A.PC_MSP_AE1 , A.PC_MSP_AE2 , A.PC_MSP_AE3 , A.FIELDNAME , A.TIME_SHEET_ID , A.SHEET_ID , A.DT_TIMESTAMP , A.VCHR_DIST_LINE_NUM , A.PM_REVIEWED , A.PRICED_RATE , A.ACTIVITY_ID_DETAIL , A.CST_DISTRIB_STATUS , A.TXN_LMT_TRANS_ID , A.EVENT_NUM , A.CA_FEE_STATUS , %subrec(WM_WO_SBR, A) , A.COMPRESS_ID , A.AMOUNT_IN_EXCESS , A.RECLAIMED_FROM_OL , A.BD_HDR_STATUS , A.PC_BUD_TYPE , A.FND_DIST_STATUS , A.SEQ_TRANS_ID , A.DIST_TRANS_ID , A.ADJ_LINE_TYPE , A.FEEDER_SUM_ID , A.PRICE_SUM_ID , A.DEPOSIT_BU , A.DEPOSIT_ID , A.PAYMENT_SEQ_NUM , %subrec(FMS_WHO_SBR, A) FROM PS_INTFC_PROJ_RES A , PS_PROJ_AN_GRP_MAP B WHERE B.ANALYSIS_TYPE = A.ANALYSIS_TYPE

  • Parent record: PROJ_ACTIVITY

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

    Default Value: PROJ_ACTIVITY.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

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

    Default Value: PROJ_ACTIVITY.PROJECT_ID

    Prompt Table: SP_PROJ_NONVW

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

    Default Value: PROJ_ACTIVITY.ACTIVITY_ID

    Prompt Table: PROJ_ACT_SRCH

    4 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
    5 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number
    6 RESOURCE_ID Character(40) VARCHAR2(40) NOT NULL Transaction ID
    7 RESOURCE_ID_FROM Character(40) VARCHAR2(40) NOT NULL Original Transaction ID
    8 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Default Value: PC_INT_TMPLGLVW.BUSINESS_UNIT_GL

    Prompt Table: PC_INT_TMPL_GL
    Set Control Field: BUSINESS_UNIT_GL

    9 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.

    Prompt Table: PC_GL_JRNL_VW

    10 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.

    Default Value: %date

    11 UNPOST_SEQ Number(2,0) SMALLINT NOT NULL Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
    12 JOURNAL_LINE Number(9,0) DECIMAL(9) NOT NULL Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
    13 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    14 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
    15 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: GL_ACCT_BUGL_VW

    16 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

    Prompt Table: %EDIT_ALTACCT

    17 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPTID_BUGL_VW

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

    Prompt Table: OPERUNT_BUGL_VW

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

    Prompt Table: PRODUCT_BUGL_VW

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

    Prompt Table: FUND_BUGL_VW

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

    Prompt Table: CLASSCF_BUGL_VW

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

    Prompt Table: PROGRAM_BUGL_VW

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

    Prompt Table: BUD_REF_BUGL_VW

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

    Prompt Table: AFFILIATE_VW

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

    Prompt Table: %EDIT_INTRA01

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

    Prompt Table: %EDIT_INTRA02

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

    Prompt Table: CF1_BUGL_VW

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

    Prompt Table: CF2_BUGL_VW

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

    Prompt Table: CF3_BUGL_VW

    30 BUS_UNIT_GL_FROM Character(5) VARCHAR2(5) NOT NULL From Business Unit GL

    Default Value: PC_INT_TMPLGLVW.BUSINESS_UNIT_GL

    Prompt Table: PC_INT_TMPL_GL

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

    Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    32 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

    Prompt Table: STAT_BUGL_VW

    33 ANALYSIS_SETID Character(5) VARCHAR2(5) NOT NULL SetID
    34 ANALYSIS_GROUP Character(5) VARCHAR2(5) NOT NULL Analysis Group
    35 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

    Prompt Table: %EDITTABLE3

    36 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

    Prompt Table: PROJ_AN_GRP_VW

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

    Prompt Table: PROJ_RES_TYPE

    38 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

    Prompt Table: %EDITTABLE

    39 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

    Prompt Table: %EDITTABLE2

    40 RES_USER1 Character(10) VARCHAR2(10) NOT NULL Transaction User 1
    41 RES_USER2 Character(10) VARCHAR2(10) NOT NULL Transaction User 2
    42 RES_USER3 Character(10) VARCHAR2(10) NOT NULL Transaction User 3
    43 RES_USER4 Character(10) VARCHAR2(10) NOT NULL Transaction User 4
    44 RES_USER5 Character(10) VARCHAR2(10) NOT NULL Transaction User 5
    45 TRANS_DT Date(10) DATE Transaction Date

    Default Value: %date

    46 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

    Default Value: %date

    47 JRNL_LN_REF Character(10) VARCHAR2(10) NOT NULL Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
    48 OPEN_ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Open Item Status
    C=Closed Item
    N=Not an Open Item Account
    O=Open Item
    49 LINE_DESCR Character(30) VARCHAR2(30) NOT NULL Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.
    50 JRNL_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates the stage of processing of a journal entry.
    0=OK - No Errors
    1=Uncorrected Error(s)
    51 JOURNAL_LINE_DATE Date(10) DATE Specifies the date of a journal line. This date must be the same as the journal date on the header (JOURNAL_DATE) in order for the Parent/Child relationship to remain intact.
    52 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

    Default Value: OPR_DEF_TBL_PC.CURRENCY_CD

    Prompt Table: FRGN_CURR_VW

    53 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

    Default Value: OPR_DEF_TBL_PC.RT_TYPE

    Prompt Table: RT_TYPE_TBL

    54 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.
    55 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
    56 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
    57 CUR_EFFDT Date(10) DATE Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.

    Default Value: %DATE

    58 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    59 PC_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PC Distribution Status
    B=Budget Check
    D=Distributed
    G=Generated
    H=Hold
    I=Ignore
    M=Modified
    N=Not Distributed
    S=Staged

    Default Value: N

    60 GL_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Status
    C=Available to Contracts
    D=Distributed
    G=Generated
    H=Hold
    I=Ignored
    J=Creating Journals
    M=Modified
    N=None
    P=To be processed
    X=Waiting for Reversal

    Default Value: I

    61 PROJ_TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Project Transaction Type

    Prompt Table: PROJ_TRANS_TYPE

    62 PROJ_TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Project Transaction Code

    Prompt Table: PROJ_TRANS_CODE

    63 RESOURCE_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status
    A=Resource Approved
    U=Unapproved Resource

    Default Value: A

    64 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    65 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
    66 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

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

    Prompt Table: PROJ_TEAM_VW

    68 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    69 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    70 TIME_RPTG_CD Character(5) VARCHAR2(5) NOT NULL Time Reporting Code
    71 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    72 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    73 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit

    Prompt Table: SP_BU_AP_NONVW

    74 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: PROJ_VENDOR_VW

    75 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

    Prompt Table: PC_AP_VCHR_VW

    76 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
    77 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template

    Prompt Table: JRNLGEN_APPL_ID

    78 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
    79 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
    80 PO_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PO Distribution Status
    0=Non-PO
    1=Active
    2=In-process
    3=Error
    4=Processed
    5=Modified

    Default Value: 0

    81 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

    Default Value: PC_INT_TMPL.BUSINESS_UNIT_PO

    Prompt Table: SP_BU_PM_NONVW

    82 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
    83 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
    84 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
    85 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number
    86 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

    Prompt Table: PC_PO_HDR_VW

    87 DUE_DATE Date(10) DATE Delivery Due Date from PO
    88 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    89 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
    90 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
    91 AM_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL AM Distribution Status
    D=Distributed
    I=Ignore
    M=Modified
    N=Not Distributed
    P=Pending
    V=Reversed
    92 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

    Default Value: PC_INT_TMPL.BUSINESS_UNIT_AM

    Prompt Table: SP_BU_AM_NONVW

    93 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

    Prompt Table: PROJ_ASSET_VW

    94 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

    Prompt Table: PROFILE_PCAM_VW

    95 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type

    Prompt Table: COST_TYPE_TBL

    96 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
    97 INCENTIVE_ID Character(10) VARCHAR2(10) NOT NULL Investment Incentive ID

    Prompt Table: PC_PROJ_GNT_VW

    98 MSTONE_SEQ Number(3,0) SMALLINT NOT NULL Milestone Sequence
    99 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    100 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
    101 CONTRACT_PPD_SEQ Number(5,0) INTEGER NOT NULL Prepaid Add Sequence
    102 BI_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Billing Distribution Status
    D=Distributed
    I=Ignore
    N=Not Distributed
    P=Priced
    U=Unbillable/Non-billable
    W=Billing Worksheet

    Default Value: I

    103 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit

    Prompt Table: SP_BU_BI_NONVW

    104 BILLING_DATE Date(10) DATE Billing Date
    105 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
    106 REV_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Revenue Distribution Status
    C=Created
    D=Distributed
    G=Generated
    I=Ignore
    N=Not Distributed
    107 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit

    Prompt Table: SP_BUARED_NONVW

    108 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: PROJ_CUST_VW

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

    Prompt Table: ITEM_OPEN_PC_VW

    110 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
    111 ITEM_SEQ_NUM Number(3,0) SMALLINT NOT NULL Item Sequence Number
    112 DST_SEQ_NUM Number(6,0) INTEGER NOT NULL Distribution Sequence
    113 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

    Prompt Table: SP_BUIN_NONVW

    114 SCHED_LINE_NO Number(7,2) DECIMAL(6,2) NOT NULL Sched Line NO
    115 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
    116 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: PROJ_ITEM_VW

    117 PAY_END_DT Date(10) DATE Pay Period End Date
    118 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit

    Prompt Table: SP_BUPCOM_NONVW

    119 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
    120 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
    121 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Documentation ID
    122 EX_DOC_TYPE Character(1) VARCHAR2(1) NOT NULL Identifies Expenses Document Type
    A=Cash Advance
    C=Time Report
    J=Time Adjustment
    M=Accrual - My Wallet
    R=Accrual - Expense Report
    S=Expense Report
    T=Travel Authorization
    123 RESOURCE_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Quantity
    124 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
    125 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
    E=Error in Budget Check
    I=Document In Processing
    N=Not Budget Checked
    P=Provisionally Valid
    V=Valid

    Default Value: V

    126 KK_AMOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Commitment Control Amount Type
    0=Budget
    1=Actuals and Recognized
    2=Encumbrance
    3=Pre-Encumbrance
    4=Collected Revenue
    5=Planned
    7=Actuals, Recognize and Collect
    9=Dynamic
    127 KK_SOURCE_TRAN Character(10) VARCHAR2(10) NOT NULL Source Transaction Type
    128 KK_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Commitment Control
    B=Budget Check
    C=Budget Create
    D=Distributed
    E=Posting Error
    K=Post to Commitment control
    N=None
    S=Security Error
    129 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
    N=No
    Y=Yes
    130 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator
    131 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime
    132 KK_GEN_PARENT Character(1) VARCHAR2(1) NOT NULL Yes/No Indicator - Generate Parent Budgets
    133 KK_PARENT_ENT_TYPE Character(1) VARCHAR2(1) NOT NULL Indicator - Parent Budget Entry Type
    0=Original
    1=Adjustment
    2=Transfer Adjustment
    3=Transfer Original
    134 KK_BUDG_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Budget Entry Type
    0=Original
    1=Adjustment
    2=Transfer Adjustment
    3=Transfer Original
    4=Closing
    5=Roll Forward
    135 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event
    136 PC_KK_AE_TYPE Character(1) VARCHAR2(1) NOT NULL Application Engine Flag for Commitment Control. 1 = Budget Creation, 2 = Budget Checking
    1=Budget Creation
    2=Budget Check
    137 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
    138 BUDGET_OVER_ALLOW Character(1) VARCHAR2(1) NOT NULL Budget Overrun Allowed
    139 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
    140 BUDGET_DT Date(10) DATE Budget Date
    141 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
    142 BD_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL BD Distribution Status
    D=Distributed
    I=Ignore
    N=None

    Default Value: N

    143 BUSINESS_UNIT_BD Character(5) VARCHAR2(5) NOT NULL Budgeting Business Unit

    Prompt Table: SP_BU_BD_NONVW

    144 FA_STATUS Character(1) VARCHAR2(1) NOT NULL F&A Status

    Default Value: N

    145 INTFC_TYPE Character(3) VARCHAR2(3) NOT NULL Trans Load Type
    146 PC_INTFC_STATUS Character(3) VARCHAR2(3) NOT NULL Projects Interface Status
    DON=Done
    ERR=Errors
    NEW=New
    147 PC_LOAD_STATUS Character(3) VARCHAR2(3) NOT NULL Projects Interface Load Status
    DON=Done
    ERR=Error
    NEW=New
    PND=Pending
    148 ORIG_INTFC_ID Number(8,0) INTEGER NOT NULL Original Interface ID
    149 ORIG_LINE_NUM Number(8,0) INTEGER NOT NULL Original Interface Line Number
    150 INTEGRATION_TMPL Character(15) VARCHAR2(15) NOT NULL Integration
    151 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface
    152 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    153 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    154 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    155 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    156 COMBO_STATUS Character(1) VARCHAR2(1) NOT NULL Combo Status
    I=Invalid
    V=Valid
    157 CURRENCY_CD_GL Character(3) VARCHAR2(3) NOT NULL GL Business Unit Base Currency
    158 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.
    159 PC_MSP_AE1 Character(1) VARCHAR2(1) NOT NULL MSP AE Load Flag 1
    Y=MSP AE Load Flag 1
    160 PC_MSP_AE2 Character(1) VARCHAR2(1) NOT NULL MSP AE Load Flag 2
    Y=MSP AE Load Flag 2
    161 PC_MSP_AE3 Character(1) VARCHAR2(1) NOT NULL MSP AE Load Flag 3
    Y=MSP AE Load Flag 3
    162 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    163 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
    164 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
    165 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
    166 VCHR_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line Number
    167 PM_REVIEWED Character(1) VARCHAR2(1) NOT NULL Reviewed
    A=All
    N=Not Reviewed
    Y=Reviewed
    168 PRICED_RATE Signed Number(28,3) DECIMAL(26,3) NOT NULL Rate used by Pricing engine to calculate amount on transactions for billing. Rate is quantity related.
    169 ACTIVITY_ID_DETAIL Character(15) VARCHAR2(15) NOT NULL This field identifies the detail Activity ID used for charging time reports in Expenses. This field is only used if the project charging level is set to summarize activity charges to level 1, 2, or 3 of the wbs. ACTIVITY_ID_DETAIL stores the detail activity used in time report charging, whereas the ACTIVITY_ID stores the parent activity at the appropriate charging level.
    170 CST_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Cost Distribution Status
    C=Created
    D=Distributed
    G=Generated
    I=Ignore
    N=Not Distributed
    171 TXN_LMT_TRANS_ID Character(10) VARCHAR2(10) NOT NULL Transaction Limit Identifer
    172 EVENT_NUM Number(3,0) SMALLINT NOT NULL Event Number
    173 CA_FEE_STATUS Character(1) VARCHAR2(1) NOT NULL Cost Plus Fee Status for Governement Contracts
    1=Fee Generated
    2=Bil Actual Fee
    3=Bil Additional Award Fee
    4=Rev Actual Fee
    5=Rev Additional Award Fee
    174 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order

    Prompt Table: SP_BU_WM_NONVW

    175 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification

    Prompt Table: %EDIT_WO_ID

    176 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number

    Prompt Table: %EDIT_WO_TASK

    177 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
    1=Labor
    2=Tools
    3=Material
    178 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.

    Prompt Table: %EDIT_RES_LINE

    179 COMPRESS_ID Number(10,0) DECIMAL(10) NOT NULL A unique identifier for a single run instance of the Project Compression Utility (PC_COMPRESS)
    180 AMOUNT_IN_EXCESS Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether the amount is in excess.

    Y/N Table Edit

    181 RECLAIMED_FROM_OL Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether the amount was reclaimed from over the limit.

    Y/N Table Edit

    182 BD_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Header Status: N - Posting has not been run against the journal E - The journal has failed edits V - The journal has passed edits but cannot be posted due to monetary related issues S - One ore more journal lines have failed the security edits P - The journal has been posted the ledger U - The journal has been unposted I - Incomplete journal pending SaveEdit to validate Security
    B=Not Balanced
    C=Checked Only
    E=Error
    I=Incomplete
    N=None
    P=Posted
    S=Security Error
    U=Unposted
    V=Errors
    183 PC_BUD_TYPE Character(1) VARCHAR2(1) NOT NULL This field defines a Projects Budget as either Cost or Revenue Based.
    C=Cost Budget
    R=Revenue Budget
    184 FND_DIST_STATUS Character(1) VARCHAR2(1) NOT NULL Funds Distribution Status
    1=No Matching Sequence
    2=Insufficient Threshold Amount
    3=Insufficient Distribute Amount
    A=Active
    B=Funds Burden
    C=Complete
    D=Distributed
    G=Generated
    H=Related BAJ Row
    I=Ignore
    N=Not Disitrbuted

    Default Value: N

    185 SEQ_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Sequence Transaction ID
    186 DIST_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Distribution Transaction ID
    187 ADJ_LINE_TYPE Character(3) VARCHAR2(3) NOT NULL Adjustment Line Type
    ACR=Adjustment Credit Line
    ADJ=Adjustment
    ARB=Adjustment Rebill Line
    REG=Regular bill line (not adjust)
    188 FEEDER_SUM_ID Number(16,0) DECIMAL(16) NOT NULL Feeder Summarization ID relates the summed Project Transactions row to its corresponding detail transactions.
    189 PRICE_SUM_ID Number(16,0) DECIMAL(16) NOT NULL Price Summarization ID relates the summed Project Transactions row in PC_PRICE_SUM to its corresponding detail transactions in PROJ_RESOURCE.
    190 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
    191 DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
    192 PAYMENT_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
    193 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    194 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    195 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    196 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.