| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 2 |
INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Interface Line Number
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: PROJ_ACTIVITY.BUSINESS_UNIT
Prompt Table:
SP_BU_PC_NONVW
|
| 4 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: PROJ_ACTIVITY.PROJECT_ID
Prompt Table:
SP_PROJ_NONVW
|
| 5 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Default Value: PROJ_ACTIVITY.ACTIVITY_ID
Prompt Table:
PROJ_ACT_VW
|
| 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:
SP_BUPCIT_NONVW
|
| 9 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 10 |
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.
|
| 11 |
JOURNAL_DATE |
Date(10) |
DATE |
Specifies the date the journal was created.
Default Value: %date
|
| 12 |
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".
|
| 13 |
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.
|
| 14 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 15 |
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.
|
| 16 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
Prompt Table:
%EDIT_ACCOUNT
|
| 17 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
Prompt Table:
%EDIT_ALTACCT
Set Control Field: BUSINESS_UNIT_GL
|
| 18 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
%EDIT_DEPT
|
| 19 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
%EDIT_OPER_UNIT
|
| 20 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
%EDIT_PRODUCT
|
| 21 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
%EDIT_FUND_CODE
|
| 22 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
%EDIT_CLASS_FLD
|
| 23 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
%EDIT_PROG_CODE
|
| 24 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
%EDIT_BUD_REF
|
| 25 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 26 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 27 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 28 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
%EDIT_CHARTFLD1
|
| 29 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
%EDIT_CHARTFLD2
|
| 30 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
%EDIT_CHARTFLD3
|
| 31 |
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
|
| 32 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
|
| 33 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
Prompt Table:
STAT_BUGL_VW
|
| 34 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table:
SP_LEDGPC_NONVW
Set Control Field: BUSINESS_UNIT_GL
|
| 35 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDITTABLE3
|
| 36 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RES_TYPE
|
| 37 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDITTABLE
|
| 38 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDITTABLE2
|
| 39 |
RES_USER1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 1
|
| 40 |
RES_USER2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 2
|
| 41 |
RES_USER3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 3
|
| 42 |
RES_USER4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 4
|
| 43 |
RES_USER5 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 5
|
| 44 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
Default Value: %date
|
| 45 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %date
|
| 46 |
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.
|
| 47 |
OPEN_ITEM_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Open Item Status
C=Closed Item
N=Not an Open Item Account
O=Open Item
|
| 48 |
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.
|
| 49 |
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)
|
| 50 |
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.
|
| 51 |
FOREIGN_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Foreign Currency Code
Default Value: OPR_DEF_TBL_PC.CURRENCY_CD
Prompt Table:
FRGN_CURR_VW
|
| 52 |
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
|
| 53 |
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.
|
| 54 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 55 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 56 |
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
|
| 57 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 58 |
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
|
| 59 |
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
|
| 60 |
PROJ_TRANS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Project Transaction Type
Prompt Table:
PROJ_TRANS_TYPE
|
| 61 |
PROJ_TRANS_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Transaction Code
Prompt Table:
PROJ_TRANS_CODE
|
| 62 |
RESOURCE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Status
A=Resource Approved
U=Unapproved Resource
Default Value: A
|
| 63 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 64 |
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.
|
| 65 |
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
|
| 66 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PROJ_TEAM_VW
|
| 67 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 68 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 69 |
TIME_RPTG_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Time Reporting Code
Prompt Table:
TL_TM_RPTCD_VW
|
| 70 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 71 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 72 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table:
SP_BU_AP_NONVW
|
| 73 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
PROJ_VENDOR_VW
|
| 74 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
Prompt Table:
PC_AP_VCHR_VW
|
| 75 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
| 76 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
Prompt Table:
JRNLGEN_APPL_ID
Set Control Field: BUSINESS_UNIT_GL
|
| 77 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 78 |
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
|
| 79 |
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
|
| 80 |
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
|
| 81 |
REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID
|
| 82 |
REQ_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Requisition Line Number
|
| 83 |
REQ_SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Requisition Schedule Number
|
| 84 |
REQ_DISTRIB_NBR |
Number(5,0) |
INTEGER NOT NULL |
Requisition Distrib Number
|
| 85 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 86 |
DUE_DATE |
Date(10) |
DATE |
Delivery Due Date from PO
|
| 87 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 88 |
SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Number
|
| 89 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 90 |
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
Default Value: N
|
| 91 |
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
|
| 92 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table:
PROJ_ASSET_VW
|
| 93 |
PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Profile ID
Prompt Table:
PROFILE_PCAM_VW
|
| 94 |
COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type
Prompt Table:
COST_TYPE_TBL
Set Control Field: BUSINESS_UNIT_AM
|
| 95 |
BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Book Name
|
| 96 |
INCENTIVE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Investment Incentive ID
Prompt Table:
PC_PROJ_GNT_VW
|
| 97 |
MSTONE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Milestone Sequence
|
| 98 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
Prompt Table:
PC_CONTRACT_VW
|
| 99 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 100 |
CONTRACT_PPD_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Prepaid Add Sequence
|
| 101 |
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: N
|
| 102 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
Prompt Table:
SP_BU_BI_NONVW
|
| 103 |
BILLING_DATE |
Date(10) |
DATE |
Billing Date
|
| 104 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 105 |
REV_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Revenue Distribution Status
C=Created
D=Distributed
G=Generated
I=Ignore
N=Not Distributed
Default Value: N
|
| 106 |
BUSINESS_UNIT_AR |
Character(5) |
VARCHAR2(5) NOT NULL |
AR Business Unit
Prompt Table:
SP_BUARED_NONVW
|
| 107 |
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
|
| 108 |
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
|
| 109 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
|
| 110 |
ITEM_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Item Sequence Number
|
| 111 |
DST_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Distribution Sequence
|
| 112 |
BUSINESS_UNIT_IN |
Character(5) |
VARCHAR2(5) NOT NULL |
Inventory Unit
Prompt Table:
SP_BUIN_NONVW
|
| 113 |
SCHED_LINE_NO |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Sched Line NO
|
| 114 |
DEMAND_LINE_NO |
Number(4,0) |
SMALLINT NOT NULL |
Demand Line No
|
| 115 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
PROJ_ITEM_VW
|
| 116 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 117 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
Prompt Table:
SP_BUPCOM_NONVW
|
| 118 |
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
|
| 119 |
ORDER_INT_LINE_NO |
Number(5,0) |
INTEGER NOT NULL |
Order Line
|
| 120 |
EX_DOC_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Documentation ID
|
| 121 |
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
|
| 122 |
RESOURCE_QUANTITY |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Quantity
|
| 123 |
RESOURCE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 124 |
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: N
|
| 125 |
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
|
| 126 |
KK_TRAN_OVER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control source transaction override flag
N=No
Y=Yes
|
| 127 |
KK_TRAN_OVER_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Commitment Control source transaction override operator
|
| 128 |
KK_TRAN_OVER_DTTM |
DateTime(26) |
TIMESTAMP |
Commitment Control source transaction override datetime
|
| 129 |
BUDGET_OVER_ALLOW |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Overrun Allowed
|
| 130 |
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
|
| 131 |
BUDGET_DT |
Date(10) |
DATE |
Budget Date
|
| 132 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
Prompt Table:
SP_LEDPC_NONVW
Set Control Field: BUSINESS_UNIT_GL
|
| 133 |
BD_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
BD Distribution Status
D=Distributed
I=Ignore
N=None
Default Value: N
|
| 134 |
BUSINESS_UNIT_BD |
Character(5) |
VARCHAR2(5) NOT NULL |
Budgeting Business Unit
Prompt Table:
SP_BUPCBD_NONVW
|
| 135 |
FA_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
F&A Status
Default Value: N
|
| 136 |
TIME_SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Sheet Unique Identifier (System Generated)
|
| 137 |
SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Report ID
|
| 138 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 139 |
VCHR_DIST_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line Number
|
| 140 |
PM_REVIEWED |
Character(1) |
VARCHAR2(1) NOT NULL |
Reviewed
A=All
N=Not Reviewed
Y=Reviewed
Default Value: Y
|
| 141 |
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.
|
| 142 |
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
|
| 143 |
CST_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Distribution Status
C=Created
D=Distributed
G=Generated
I=Ignore
N=Not Distributed
Default Value: N
|
| 144 |
TXN_LMT_TRANS_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction Limit Identifer
|
| 145 |
EVENT_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Event Number
|
| 146 |
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
|
| 147 |
BUSINESS_UNIT_WO |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit Work Order
Prompt Table:
SP_BU_WM_NONVW
|
| 148 |
WO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Order Identification
Prompt Table:
%EDIT_WO_ID
|
| 149 |
WO_TASK_ID |
Number(5,0) |
INTEGER NOT NULL |
Task Number
Prompt Table:
%EDIT_WO_TASK
|
| 150 |
RSRC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Order Management Resource Types
1=Labor
2=Tools
3=Material
|
| 151 |
RES_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Resource Line No.
Prompt Table:
%EDIT_RES_LINE
|
| 152 |
COMPRESS_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
A unique identifier for a single run instance of the Project Compression Utility (PC_COMPRESS)
|
| 153 |
AMOUNT_IN_EXCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether the amount is in excess.
Y/N Table Edit
|
| 154 |
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
|
| 155 |
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
|
| 156 |
SEQ_TRANS_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Transaction ID
|
| 157 |
DIST_TRANS_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Distribution Transaction ID
|
| 158 |
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)
|
| 159 |
FEEDER_SUM_ID |
Number(16,0) |
DECIMAL(16) NOT NULL |
Feeder Summarization ID relates the summed Project Transactions row to its corresponding detail transactions.
|
| 160 |
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.
|
| 161 |
DEPOSIT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
|
| 162 |
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.
|
| 163 |
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.
|
| 164 |
FMS_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the original entry.
|
| 165 |
FMS_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the original entry.
|
| 166 |
FMS_LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry.
|
| 167 |
FMS_LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry.
|
| 168 |
INTFC_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Trans Load Type
|
| 169 |
PC_INTFC_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Projects Interface Status
DON=Done
ERR=Errors
NEW=New
Default Value: NEW
|
| 170 |
PC_LOAD_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Projects Interface Load Status
DON=Done
ERR=Error
NEW=New
PND=Pending
Default Value: NEW
|
| 171 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 172 |
ORIG_INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Original Interface ID
|
| 173 |
ORIG_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Original Interface Line Number
|
| 174 |
INTEGRATION_TMPL |
Character(15) |
VARCHAR2(15) NOT NULL |
Integration
|
| 175 |
QUANTITY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Interface
|
| 176 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 177 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 178 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 179 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 180 |
COMBO_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Combo Status
I=Invalid
V=Valid
Default Value: V
|
| 181 |
CURRENCY_CD_GL |
Character(3) |
VARCHAR2(3) NOT NULL |
GL Business Unit Base Currency
|
| 182 |
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.
|
| 183 |
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
Default Value: N
|
| 184 |
KK_SOURCE_TRAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Source Transaction Type
|
| 185 |
PC_MSP_AE1 |
Character(1) |
VARCHAR2(1) NOT NULL |
MSP AE Load Flag 1
Y=MSP AE Load Flag 1
|
| 186 |
PC_MSP_AE2 |
Character(1) |
VARCHAR2(1) NOT NULL |
MSP AE Load Flag 2
Y=MSP AE Load Flag 2
|
| 187 |
PC_MSP_AE3 |
Character(1) |
VARCHAR2(1) NOT NULL |
MSP AE Load Flag 3
Y=MSP AE Load Flag 3
|
| 188 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 189 |
PC_BUDGET_ID |
Number(3,0) |
SMALLINT NOT NULL |
Budget Plan ID
|
| 190 |
BUDGET_PERIOD |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Period
|
| 191 |
PC_BUDGET_ITEM |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Budgeting: Budget Item
11/15/2004- FS - Added label COST_BUDGET_ITEM
Prompt Table:
PC_BUD_ITM_VW
|
| 192 |
BUDGET_LN |
Number(6,0) |
INTEGER NOT NULL |
BUDGET_LN
|
| 193 |
PROJ_ROLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Role
Prompt Table:
PROJ_ROLE
|
| 194 |
KK_BUDG_LN_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Budget Journal Line Types
0=Original
1=Adjustment
2=Transfer
3=Roll Forward
4=Closing
Default Value: 0
|
| 195 |
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
Default Value: N
|
| 196 |
GM_FA_SEQ_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Fixed and Administrative
1=Base (Non F&A)
2=Fixed and Administrative
Y/N Table Edit
|
| 197 |
GM_CS_SEQ_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Sharing
1=Sponsor
2=Cost Sharing
Y/N Table Edit
|
| 198 |
FUND_SOURCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Funding Source
Prompt Table:
KK_FUND_SOURCE
|
| 199 |
GM_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Status
C=Available to Contracts
D=Distributed
G=Generated
H=Hold
I=Ignored
M=Modified
N=None
P=To be processed
|
| 200 |
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
Default Value: C
|
| 201 |
BUDGET_CATEGORY |
Character(15) |
VARCHAR2(15) NOT NULL |
BUDGET_CATEGORY
Prompt Table:
GM_BUD_CATEGORY
|
| 202 |
NUM_PERIODS |
Number(2,0) |
SMALLINT NOT NULL |
Number of Time Periods
|
| 203 |
ACT_UID |
Character(15) |
VARCHAR2(15) NOT NULL |
Task ID
|
| 204 |
RES_UID |
Character(15) |
VARCHAR2(15) NOT NULL |
Resource ID
|
| 205 |
PC_HOURS_PER_DAY |
Number(2,0) |
SMALLINT NOT NULL |
Hours per Day
|
| 206 |
PC_FORECAST |
Number(15,0) |
DECIMAL(15) NOT NULL |
Forecast Units to load into Forecasting. Not Remaining Forecast units.
|
| 207 |
PC_FORECAST_REMAIN |
Number(15,0) |
DECIMAL(15) NOT NULL |
Remaining Forecast units to load into Forecasting. Not Forecast Units.
|
| 208 |
STATUS_STRING |
Character(100) |
VARCHAR2(100) NOT NULL |
String Text
|
| 209 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 210 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 211 |
LOAD_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
/* -> JMZ. PSOFT. 11-OCT-2002 */
New Status were added : HLD and INP for Asset Management.
/* <- JMZ. PSOFT. 11-OCT-2002 */
CON=Consolidated
DON=Loaded
ERR=Errored
EXC=Excluded
HLD=On Hold
INP=In Process
NEW=Pending
PGI=PO Grp Incomplete
REP=Replaced
UNI=Unitized
|
| 212 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
|
| 213 |
ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table:
EE_PCB_CODES_VW
Set Control Field: BUSINESS_UNIT_GL
|
| 214 |
KK_DEFAULT_EE |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator - Use Default Entry Event
Y/N Table Edit
Default Value: N
|
| 215 |
KK_GEN_PARENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator - Generate Parent Budgets
Y/N Table Edit
|
| 216 |
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
|
| 217 |
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
|
| 218 |
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
|
| 219 |
EE_PROC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Entry Event Line Status
Default Value: N
|
| 220 |
PROJECT_OBJECTID |
Number(10,0) |
DECIMAL(10) NOT NULL |
A unique ID that is the Project key to a corresponding table in an external system such as Primavera.
|
| 221 |
ACTIVITY_OBJECTID |
Number(10,0) |
DECIMAL(10) NOT NULL |
A unique ID that is the Activity key to a corresponding table in an external system such as Primavera.
|