PC_PM_ADJBSE_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , A.RESOURCE_ID , A.BUSINESS_UNIT_GL , A.ACCOUNT , A.ALTACCT , A.DEPTID ,%subrec(CF16_AN_SBR,A) , A.BUS_UNIT_GL_FROM , A.CURRENCY_CD , A.STATISTICS_CODE , 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.OPRID , A.JOURNAL_ID , A.JOURNAL_LINE , A.JRNL_LINE_STATUS , A.JRNL_LN_REF , A.OPEN_ITEM_STATUS , A.KK_TRAN_OVER_FLAG , A.KK_TRAN_OVER_OPRID , A.KK_AMOUNT_TYPE , A.KK_TRAN_OVER_DTTM , A.BUDGET_LINE_STATUS , A.BUDGET_OVER_ALLOW , A.BILLING_DATE , A.BUDGET_DT , A.ACCOUNTING_PERIOD , A.FISCAL_YEAR , A.UNPOST_SEQ , A.LINE_DESCR , A.FOREIGN_CURRENCY , A.RT_TYPE , A.FOREIGN_AMOUNT , A.RATE_MULT , A.RATE_DIV , A.CUR_EFFDT , A.PROJ_TRANS_TYPE , A.PROJ_TRANS_CODE , A.DESCR , 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.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.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.BUSINESS_UNIT_BI , A.INVOICE , 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.LEDGER , A.BUSINESS_UNIT_BD , A.TIME_SHEET_ID , A.SHEET_ID , A.VCHR_DIST_LINE_NUM , A.PRICED_RATE , A.ACTIVITY_ID_DETAIL , A.TXN_LMT_TRANS_ID , A.EVENT_NUM ,%subrec(WM_WO_SBR,A) FROM PS_PROJ_RESOURCE A

# 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 RESOURCE_ID Character(40) VARCHAR2(40) NOT NULL Transaction ID
5 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Default Value: PC_INT_TMPLGLVW.BUSINESS_UNIT_GL

Prompt Table: SP_BUPCIT_NONVW
Set Control Field: BUSINESS_UNIT_GL

6 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: GL_ACCT_CTLB_VW

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

Prompt Table: %EDIT_ALTACCT

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

Prompt Table: DEPTID_BUGL_VW

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

Prompt Table: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

21 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

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

Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD

Prompt Table: CURRENCY_CD_TBL

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

Prompt Table: STAT_BUGL_VW

24 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

Prompt Table: SP_LEDGPC_NONVW
Set Control Field: BUSINESS_UNIT_GL

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

Prompt Table: PROJ_AN_GRP_VW

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

Prompt Table: PROJ_RES_TYPE

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

Prompt Table: %EDITTABLE

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

Prompt Table: %EDITTABLE2

29 RES_USER1 Character(10) VARCHAR2(10) NOT NULL Transaction User 1
30 RES_USER2 Character(10) VARCHAR2(10) NOT NULL Transaction User 2
31 RES_USER3 Character(10) VARCHAR2(10) NOT NULL Transaction User 3
32 RES_USER4 Character(10) VARCHAR2(10) NOT NULL Transaction User 4
33 RES_USER5 Character(10) VARCHAR2(10) NOT NULL Transaction User 5
34 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

35 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.
36 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.
37 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)
38 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.
39 OPEN_ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Open Item Status
C=Closed Item
N=Not an Open Item Account
O=Open Item
40 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes
41 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator
42 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
43 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime
44 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
45 BUDGET_OVER_ALLOW Character(1) VARCHAR2(1) NOT NULL Budget Overrun Allowed
46 BILLING_DATE Date(10) DATE Billing Date
47 BUDGET_DT Date(10) DATE Budget Date
48 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.
49 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
50 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".
51 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.
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 PROJ_TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Project Transaction Type

Prompt Table: PROJ_TRANS_TYPE

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

Prompt Table: PROJ_TRANS_CODE

60 DESCR Character(30) VARCHAR2(30) NOT NULL Description
61 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

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

Prompt Table: PROJ_TEAM_VW

63 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
64 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
65 TIME_RPTG_CD Character(5) VARCHAR2(5) NOT NULL Time Reporting Code
66 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
67 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
68 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit

Prompt Table: SP_BU_AP_NONVW

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

Prompt Table: PROJ_VENDOR_VW

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

Prompt Table: PC_AP_VCHR_VW

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

Prompt Table: JRNLGEN_APPL_ID
Set Control Field: BUSINESS_UNIT_GL

73 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
74 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
75 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

76 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
77 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
78 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
79 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number
80 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

Prompt Table: PC_PO_HDR_VW

81 DUE_DATE Date(10) DATE Delivery Due Date from PO
82 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
83 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
84 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
85 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

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

Prompt Table: PROJ_ASSET_VW

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

Prompt Table: PROFILE_PCAM_VW

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

Prompt Table: COST_TYPE_TBL
Set Control Field: BUSINESS_UNIT_AM

89 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
90 INCENTIVE_ID Character(10) VARCHAR2(10) NOT NULL Investment Incentive ID

Prompt Table: PC_PROJ_GNT_VW

91 MSTONE_SEQ Number(3,0) SMALLINT NOT NULL Milestone Sequence
92 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

Prompt Table: CA_CONTRACT_VW

93 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
94 CONTRACT_PPD_SEQ Number(5,0) INTEGER NOT NULL Prepaid Add Sequence
95 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit

Prompt Table: SP_BU_BI_NONVW

96 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
97 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit

Prompt Table: SP_BUARED_NONVW

98 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

99 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

100 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
101 ITEM_SEQ_NUM Number(3,0) SMALLINT NOT NULL Item Sequence Number
102 DST_SEQ_NUM Number(6,0) INTEGER NOT NULL Distribution Sequence
103 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

Prompt Table: SP_BUIN_NONVW

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

Prompt Table: PROJ_ITEM_VW

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

Prompt Table: SP_BUPCOM_NONVW

109 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
110 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
111 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Documentation ID
112 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
113 RESOURCE_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Quantity
114 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
115 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

116 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

Prompt Table: SP_LEDPC_NONVW
Set Control Field: BUSINESS_UNIT_GL

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

Prompt Table: SP_BUPCBD_NONVW

118 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
119 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
120 VCHR_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line Number
121 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.
122 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.

Prompt Table: PC_ACT_DETAIL

123 TXN_LMT_TRANS_ID Character(10) VARCHAR2(10) NOT NULL Transaction Limit Identifer
124 EVENT_NUM Number(3,0) SMALLINT NOT NULL Event Number
125 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order

Prompt Table: SP_BU_WM_NONVW

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

Prompt Table: %EDIT_WO_ID

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

Prompt Table: %EDIT_WO_TASK

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

Prompt Table: %EDIT_RES_LINE