| # |
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 |
KEY_CHAR_40_01 |
Character(40) |
VARCHAR2(40) NOT NULL |
Key Char 40/01
|
| 5 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 6 |
RESOURCE_ID_FROM |
Character(40) |
VARCHAR2(40) NOT NULL |
Original Transaction ID
|
| 7 |
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
|
| 8 |
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
|
| 9 |
JOURNAL_DATE |
Date(10) |
DATE |
Specifies the date the journal was created.
Default Value: %date
|
| 10 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 11 |
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.
|
| 12 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
Prompt Table:
GL_ACCT_BUGL_VW
|
| 13 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
Prompt Table:
%EDIT_ALTACCT
|
| 14 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPTID_BUGL_VW
|
| 15 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPERUNT_BUGL_VW
|
| 16 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_BUGL_VW
|
| 17 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_BUGL_VW
|
| 18 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASSCF_BUGL_VW
|
| 19 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_BUGL_VW
|
| 20 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_BUGL_VW
|
| 21 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 22 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 23 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 24 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_BUGL_VW
|
| 25 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_BUGL_VW
|
| 26 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_BUGL_VW
|
| 27 |
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
|
| 28 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
|
| 29 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
Prompt Table:
STAT_BUGL_VW
|
| 30 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table:
BU_LGRP_DEF_VW
|
| 31 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
PROJ_AN_GRP_VW
|
| 32 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RES_TYPE
|
| 33 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDITTABLE
|
| 34 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDITTABLE2
|
| 35 |
RES_USER1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 1
|
| 36 |
RES_USER2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 2
|
| 37 |
RES_USER3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 3
|
| 38 |
RES_USER4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 4
|
| 39 |
RES_USER5 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 5
|
| 40 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
Default Value: %date
|
| 41 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %date
|
| 42 |
DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 43 |
FOREIGN_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Foreign Currency Code
Default Value: OPR_DEF_TBL_PC.CURRENCY_CD
Prompt Table:
FRGN_CURR_VW
|
| 44 |
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
|
| 45 |
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.
|
| 46 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 47 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 48 |
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
|
| 49 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 50 |
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
|
| 51 |
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
|
| 52 |
PROJ_TRANS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Project Transaction Type
Prompt Table:
PROJ_TRANS_TYPE
|
| 53 |
PROJ_TRANS_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Transaction Code
Prompt Table:
PROJ_TRANS_CODE
|
| 54 |
RESOURCE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Status
A=Resource Approved
U=Unapproved Resource
Default Value: A
|
| 55 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 56 |
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.
|
| 57 |
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
|
| 58 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PROJ_TEAM_VW
|
| 59 |
TIME_RPTG_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Time Reporting Code
|
| 60 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 61 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 62 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table:
SP_BU_AP_NONVW
|
| 63 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
PROJ_VENDOR_VW
|
| 64 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
Prompt Table:
PC_AP_VCHR_VW
|
| 65 |
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
|
| 66 |
REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID
|
| 67 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
Prompt Table:
PC_PO_HDR_VW
|
| 68 |
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
|
| 69 |
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
|
| 70 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table:
PROJ_ASSET_VW
|
| 71 |
PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Profile ID
Prompt Table:
PROFILE_PCAM_VW
|
| 72 |
COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type
|
| 73 |
BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Book Name
|
| 74 |
INCENTIVE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Investment Incentive ID
Prompt Table:
PC_PROJ_GNT_VW
|
| 75 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 76 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
Prompt Table:
SP_BU_BI_NONVW
|
| 77 |
BILLING_DATE |
Date(10) |
DATE |
Billing Date
|
| 78 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 79 |
REV_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Revenue Distribution Status
C=Created
D=Distributed
G=Generated
I=Ignore
N=Not Distributed
|
| 80 |
BUSINESS_UNIT_AR |
Character(5) |
VARCHAR2(5) NOT NULL |
AR Business Unit
Prompt Table:
SP_BUARED_NONVW
|
| 81 |
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
|
| 82 |
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
|
| 83 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
|
| 84 |
ITEM_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Item Sequence Number
|
| 85 |
DST_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Distribution Sequence
|
| 86 |
BUSINESS_UNIT_IN |
Character(5) |
VARCHAR2(5) NOT NULL |
Inventory Unit
Prompt Table:
SP_BUIN_NONVW
|
| 87 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
PROJ_ITEM_VW
|
| 88 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
Prompt Table:
SP_BUPCOM_NONVW
|
| 89 |
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
|
| 90 |
RESOURCE_QUANTITY |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Quantity
|
| 91 |
RESOURCE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 92 |
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
|
| 93 |
BUDGET_DT |
Date(10) |
DATE |
Budget Date
|
| 94 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 95 |
BUSINESS_UNIT_BD |
Character(5) |
VARCHAR2(5) NOT NULL |
Budgeting Business Unit
Prompt Table:
SP_BU_BD_NONVW
|
| 96 |
TIME_SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Sheet Unique Identifier (System Generated)
|
| 97 |
SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Report ID
|
| 98 |
PM_REVIEWED |
Character(1) |
VARCHAR2(1) NOT NULL |
Reviewed
A=All
N=Not Reviewed
Y=Reviewed
|
| 99 |
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.
|
| 100 |
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.
|
| 101 |
CST_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Distribution Status
C=Created
D=Distributed
G=Generated
I=Ignore
N=Not Distributed
|
| 102 |
TXN_LMT_TRANS_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction Limit Identifer
|
| 103 |
EVENT_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Event Number
|
| 104 |
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
|
| 105 |
BUSINESS_UNIT_WO |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit Work Order
Prompt Table:
SP_BU_WM_NONVW
|
| 106 |
WO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Order Identification
Prompt Table:
%EDIT_WO_ID
|
| 107 |
WO_TASK_ID |
Number(5,0) |
INTEGER NOT NULL |
Task Number
Prompt Table:
%EDIT_WO_TASK
|
| 108 |
RSRC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Order Management Resource Types
1=Labor
2=Tools
3=Material
|
| 109 |
RES_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Resource Line No.
Prompt Table:
%EDIT_RES_LINE
|
| 110 |
COMPRESS_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
A unique identifier for a single run instance of the Project Compression Utility (PC_COMPRESS)
|
| 111 |
AMOUNT_IN_EXCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether the amount is in excess.
Y/N Table Edit
|
| 112 |
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
|
| 113 |
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
|
| 114 |
SEQ_TRANS_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Transaction ID
|
| 115 |
DIST_TRANS_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Distribution Transaction ID
|
| 116 |
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)
|
| 117 |
FEEDER_SUM_ID |
Number(16,0) |
DECIMAL(16) NOT NULL |
Feeder Summarization ID relates the summed Project Transactions row to its corresponding detail transactions.
|
| 118 |
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.
|
| 119 |
DEPOSIT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
|
| 120 |
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.
|
| 121 |
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.
|