| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 3 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: Y
|
| 5 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: Y
|
| 6 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Default Value: Y
|
| 7 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPRUNT_BUGL2_VW
|
| 8 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODCT_BUGL2_VW
|
| 9 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_BUGL2_VW
|
| 10 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASS_BUGL2_VW
|
| 11 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRM_BUGL2_VW
|
| 12 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUDREF_BUGL2_VW
|
| 13 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 14 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 15 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 16 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_BUGL2_VW
|
| 17 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_BUGL2_VW
|
| 18 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_BUGL2_VW
|
| 19 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 20 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 21 |
BUPRJACT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
BU/Proj/Act Option
A=Business Unit/Project/Activity
B=Business Unit
E=All
P=Business Unit/Project
|
| 22 |
DATE_RANGE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Option
A=Accounting Date
E=All
T=Transaction Date
|
| 23 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 24 |
THRU_DATE |
Date(10) |
DATE |
Through Date
|
| 25 |
DATE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
From and To Date Type
A=Accounting Date
J=Journal Date
P=Posted Date
T=Transaction Date
Default Value: A
|
| 26 |
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
Default Value: DST
|
| 27 |
DST_TYPE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
DST Acct Type Option
A=All Lines
D=DST Lines
F=FRG Lines
S=STX Lines
V=Specific Lines
|
| 28 |
PC_INTFC_RUN_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Interface Run Option
B=Edit and Load
E=Edit Only
L=Load Only
U=Update Only
|
| 29 |
PC_THRESHOLD_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Interface Line Options
A=All Lines
R=Range of Lines
Default Value: A
|
| 30 |
PC_INTFC_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Interface Options
A=All Interface ID's
R=Range of Intfc ID's
|
| 31 |
INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 32 |
TO_INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
To Interface ID
|
| 33 |
INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Interface Line Number
|
| 34 |
PO_SEL_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchasing Select Options
A=Requisitions / Purchase Orders
P=Purchase Orders
R=Requisitions
|
| 35 |
RUN_DT |
Date(10) |
DATE |
Run Date
|
| 36 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 37 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 38 |
ANALYSIS_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Analysis Group
|
| 39 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 40 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 41 |
PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Profile ID
|
| 42 |
INCENTIVE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Investment Incentive ID
|
| 43 |
AUTHORIZATION_MAX |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Authorization Amount
|
| 44 |
AUTHORIZATION_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Authorization Percentage
|
| 45 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 46 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 47 |
EXISTING_GNT_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Resource Amount
|
| 48 |
NEW_GNT_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Resource Amount
|
| 49 |
JUST_OVER_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Resource Amount
|
| 50 |
REMAINING_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Remaining Amount
|
| 51 |
RESOURCE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 52 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 53 |
DONE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Done Flag
|
| 54 |
INCLUDE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
include flag
|
| 55 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 56 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
|
| 57 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 58 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 59 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 60 |
REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID
|
| 61 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 62 |
BUSINESS_UNIT_IN |
Character(5) |
VARCHAR2(5) NOT NULL |
Inventory Unit
|
| 63 |
TRANSACTION_GROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
|
| 64 |
EX_DOC_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Documentation ID
|
| 65 |
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
|
| 66 |
KEY_DATE_07 |
Date(10) |
DATE |
Key Date 07
|
| 67 |
KEY_NUM_8 |
Number(8,0) |
INTEGER NOT NULL |
Key Number 8
|
| 68 |
KEY_NUM_9 |
Number(8,0) |
INTEGER NOT NULL |
Key Number 9
|
| 69 |
SETID_CUST_BILL |
Character(5) |
VARCHAR2(5) NOT NULL |
Bill-to Cust setid
|
| 70 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
|
| 71 |
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.
|
| 72 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 73 |
TO_DT |
Date(10) |
DATE |
To Date
|
| 74 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 75 |
TIME_SPAN |
Character(10) |
VARCHAR2(10) NOT NULL |
TimeSpan
|
| 76 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 77 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
|
| 78 |
PUBLIC_SECTOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Public Sector
|
| 79 |
AE_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exists
|
| 80 |
WORK_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count of Anything
|
| 81 |
AE_WHERE_1 |
Character(50) |
VARCHAR2(50) NOT NULL |
AE_WHERE_1
|
| 82 |
AE_WHERE_2 |
Character(50) |
VARCHAR2(50) NOT NULL |
AE_WHERE_2
|
| 83 |
AE_WHERE_3 |
Character(50) |
VARCHAR2(50) NOT NULL |
AE_WHERE_3
|
| 84 |
AE_WHERE_4 |
Character(50) |
VARCHAR2(50) NOT NULL |
AE_WHERE_4
|
| 85 |
AE_WHERE_5 |
Character(50) |
VARCHAR2(50) NOT NULL |
AE_WHERE_5
|
| 86 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 87 |
AE_INT_2 |
Number(2,0) |
SMALLINT NOT NULL |
Number Work Field
|
| 88 |
AE_ROUND_INC |
Signed Number(8,5) |
DECIMAL(6,5) NOT NULL |
Rounding Increment
|
| 89 |
AE_CNV_IN_FLD_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
AE input convert field
|
| 90 |
AE_CNV_OUT_FLD_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
AE output converion field
|
| 91 |
AE_CNV_JUSTIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
AE Convert Justify Indicator
|
| 92 |
AE_STRIP_ZERO |
Character(1) |
VARCHAR2(1) NOT NULL |
AE Strip Zeros
|
| 93 |
AE_CHUNK_BY |
Character(20) |
VARCHAR2(20) NOT NULL |
Chunking Method
|
| 94 |
AE_CHUNK_BY_VALUE |
Character(15) |
VARCHAR2(15) NOT NULL |
Current value of chunk-by fld
|
| 95 |
AE_ALIAS_1 |
Character(15) |
VARCHAR2(15) NOT NULL |
AE Alias 1
|
| 96 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 97 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 98 |
EDITTABLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Edit Table
|
| 99 |
USEEDIT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Field Use and Edit Flags- USEEDIT reference
|
| 100 |
SETCNTRLFLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Structure Node User Key Field Name
|
| 101 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 102 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 103 |
COMBO_EDIT_TMPL |
Character(10) |
VARCHAR2(10) NOT NULL |
Record Template
|
| 104 |
DECIMAL_POS_BSE |
Number(2,0) |
SMALLINT NOT NULL |
Base Cur Decimal Positions
|
| 105 |
PC_PO_ADJ_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Closed PO Adjustments
|
| 106 |
PC_CCA_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Order Adjustments
|
| 107 |
PC_RRV_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
REQ Reversals
|
| 108 |
PC_CRV_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Reversals
|
| 109 |
PC_PO_REV_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Order Reversals
|
| 110 |
PC_REQ_REV_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Requisition Reversals
|
| 111 |
AN_TYPE_PO_CCA |
Character(3) |
VARCHAR2(3) NOT NULL |
Purchasing Closure
|
| 112 |
AN_TYPE_PO_CRV |
Character(3) |
VARCHAR2(3) NOT NULL |
Purchasing Reversals
|
| 113 |
AN_TYPE_PO_RRV |
Character(3) |
VARCHAR2(3) NOT NULL |
Requisition Reversals
|
| 114 |
RRV_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Requisition Reversal
A=COM Amount
Q=REQ Rate
X=REQ Total
|
| 115 |
CRV_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Order Reversal
A=ACT Amount
Q=COM Rate
|
| 116 |
AN_TYPE_AP |
Character(3) |
VARCHAR2(3) NOT NULL |
Payables
|
| 117 |
AN_TYPE_EX |
Character(3) |
VARCHAR2(3) NOT NULL |
Expenses
|
| 118 |
AN_TYPE_IN |
Character(3) |
VARCHAR2(3) NOT NULL |
Inventory
|
| 119 |
AN_TYPE_OM |
Character(3) |
VARCHAR2(3) NOT NULL |
Order Management
|
| 120 |
AN_TYPE_PO_PO |
Character(3) |
VARCHAR2(3) NOT NULL |
Purchase Orders
|
| 121 |
AN_TYPE_PO_REQ |
Character(3) |
VARCHAR2(3) NOT NULL |
Requisitions
|
| 122 |
AN_TYPE_TL |
Character(3) |
VARCHAR2(3) NOT NULL |
Time / Labor Actuals
|
| 123 |
AN_TYPE_TL_EST |
Character(3) |
VARCHAR2(3) NOT NULL |
Time / Labor Estimates
|
| 124 |
AN_TYPE_TL_BI |
Character(3) |
VARCHAR2(3) NOT NULL |
Time / Labor Billing Estimate
|
| 125 |
FIELDNAME_BASE_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
Base Amount
|
| 126 |
FIELDNAME_BASE_CUR |
Character(18) |
VARCHAR2(18) NOT NULL |
Base Currency
|
| 127 |
FIELDNAME_CUREFFDT |
Character(18) |
VARCHAR2(18) NOT NULL |
Currency Effective Date
|
| 128 |
FIELDNAME_RT_TYPE |
Character(18) |
VARCHAR2(18) NOT NULL |
Rate Type
|
| 129 |
FIELDNAME_TRAN_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
Transaction Amount
|
| 130 |
FIELDNAME_TRAN_CUR |
Character(18) |
VARCHAR2(18) NOT NULL |
Transaction Currency
|
| 131 |
TO_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
To Currency Code
|
| 132 |
BU_CUR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Override
|
| 133 |
FROM_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
From Currency Code
|
| 134 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 135 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 136 |
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.
|
| 137 |
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.
|
| 138 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 139 |
PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Processing Flag
|
| 140 |
PROJ_ACT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Third party project/activity load option.
A=Activities
B=Both Projects and Activities
P=Projects
Q=Projects and Resources
R=Resources
S=Activities and Resources
T=Projects and Trees
U=Projs, Activities & Resources
|
| 141 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
|
| 142 |
COMMITMENT_CNTL_PC |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on PC
|
| 143 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
| 144 |
CUR_RT_TYPE_DFLT |
Character(5) |
VARCHAR2(5) NOT NULL |
Exchange Rate Type Default
|
| 145 |
CURRENCY_CD_GL |
Character(3) |
VARCHAR2(3) NOT NULL |
GL Business Unit Base Currency
|
| 146 |
RT_TYPE_BUGL |
Character(5) |
VARCHAR2(5) NOT NULL |
Rate Type for GL Business Unit
|
| 147 |
INHERIT_BASE_CUR |
Character(1) |
VARCHAR2(1) NOT NULL |
Inherit Base Currency
|
| 148 |
RTNCD |
Character(30) |
VARCHAR2(30) NOT NULL |
return code
|
| 149 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 150 |
PARMCOUNT |
Number(3,0) |
SMALLINT NOT NULL |
Parameter Count
|
| 151 |
MESSAGE_PARM |
Character(254) |
VARCHAR2(254) NOT NULL |
Message Parameter Text
|
| 152 |
PROJ_FUND |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Project Funded Amount
|
| 153 |
RESOURCE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Transaction ID
|
| 154 |
IN_USE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Table in use switch
|
| 155 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 156 |
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.
|
| 157 |
RECNAME_SOURCE |
Character(15) |
VARCHAR2(15) NOT NULL |
Source Recname
|
| 158 |
FIELDNAME_FROM_CUR |
Character(18) |
VARCHAR2(18) NOT NULL |
From Currency
|
| 159 |
FIELDNAME_FROM_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
From Amount
|
| 160 |
FIELDNAME_TO_CUR |
Character(18) |
VARCHAR2(18) NOT NULL |
To Currency
|
| 161 |
FIELDNAME_TO_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
To Amount
|
| 162 |
RECNAME_TARGET |
Character(15) |
VARCHAR2(15) NOT NULL |
Target Recname
|
| 163 |
RECNAME_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name
|
| 164 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 165 |
PROJECT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Status
B=Budgeted
C=Closed
H=Hold
O=Open
P=Proposed
|
| 166 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
|
| 167 |
TREE_EFFDT |
Date(10) |
DATE |
Effective date of the Tree
|
| 168 |
TREE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Tree Description
|
| 169 |
PARENT_NODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Parent Tree Node
|
| 170 |
PC_TREE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used to identify type of tree (project or wbs).
PRJ=Project
WBS=Work Breakdown Structure
|
| 171 |
PC_SCH_PTR_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Options for Project Tree Integration with Third Party scheduling software
APP=Append Node to Existing Tree
NEW=Create New Tree
UPD=Update Existing Tree
|
| 172 |
LAST_PROJECT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Last Project ID
|
| 173 |
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.
|
| 174 |
FOREIGN_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Foreign Currency Code
|
| 175 |
RESOURCE_QUANTITY |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Quantity
|
| 176 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 177 |
LAST_RESOURCE_ID |
Number(20,0) |
DECIMAL(20) NOT NULL |
Last Transaction ID
|
| 178 |
RESOURCE_ID_FROM |
Character(40) |
VARCHAR2(40) NOT NULL |
Original Transaction ID
|
| 179 |
PC_COMBO_BYPASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Combo Edit Bypass Flag
N=Do Not Bypass Combo Edit
Y=Bypass Combo Edit
|
| 180 |
EFFDT_NEW |
Date(10) |
DATE |
New Effective Date
|
| 181 |
KK_SOURCE_TRAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Source Transaction Type
|
| 182 |
LAST_ACTIVITY_ID |
Number(8,0) |
INTEGER NOT NULL |
Last Actvity ID
|
| 183 |
WHERE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Where Clause
|
| 184 |
WHERE_CLAUSE_LONG3 |
Long Character(4000) |
CLOB |
Where Clause
|
| 185 |
PC_CHC_TEMPLATE |
Character(30) |
VARCHAR2(30) NOT NULL |
Change Control Template
|
| 186 |
PC_CHC_COUNT |
Number(15,0) |
DECIMAL(15) NOT NULL |
Count of Changes
|
| 187 |
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
|
| 188 |
NEWVALUE |
Character(65) |
VARCHAR2(65) NOT NULL |
New Value
|
| 189 |
ACCTG_DIST_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting Distribution
|
| 190 |
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.
|
| 191 |
PROJ_FLD_LENGTH |
Number(3,0) |
SMALLINT NOT NULL |
Project ID Field Length
|
| 192 |
PROJECT_ID_TARGET |
Character(15) |
VARCHAR2(15) NOT NULL |
Project ID
|
| 193 |
ACTV_FLD_LENGTH |
Number(3,0) |
SMALLINT NOT NULL |
Activity ID Field Length
|
| 194 |
ACTIVITY_ID_TARGET |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 195 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 196 |
LAST_CBUD_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the last cost budget analysis type used in Projects Budgeting when versioning is turned on.
|
| 197 |
CONSTRAINT_DT |
Date(10) |
DATE |
Constraint Date
|
| 198 |
CONSTRAINT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Constraint Type
ALAP=As Late As Possible
ASAP=As Soon As Possible
ENET=End No Earlier Than
ENLT=End No Later Than
MEO=Must End On
MSO=Must Start On
SNET=Start No Earlier Than
SNLT=Start No Later Than
|
| 199 |
DEADLINE_DT |
Date(10) |
DATE |
Deadline Date
|
| 200 |
WBS_ID |
Character(100) |
VARCHAR2(100) NOT NULL |
WBS ID
|
| 201 |
LEVEL1 |
Number(5,0) |
INTEGER NOT NULL |
Level 1
|
| 202 |
LEVEL2 |
Number(5,0) |
INTEGER NOT NULL |
Level 2
|
| 203 |
LEVEL3 |
Number(5,0) |
INTEGER NOT NULL |
Level 3
|
| 204 |
LEVEL4 |
Number(5,0) |
INTEGER NOT NULL |
Level 4
|
| 205 |
LEVEL5 |
Number(5,0) |
INTEGER NOT NULL |
Level 5
|
| 206 |
LEVEL6 |
Number(5,0) |
INTEGER NOT NULL |
Level 6
|
| 207 |
LEVEL7 |
Number(5,0) |
INTEGER NOT NULL |
Level 7
|
| 208 |
LEVEL8 |
Number(5,0) |
INTEGER NOT NULL |
Level 8
|
| 209 |
LEVEL9 |
Number(5,0) |
INTEGER NOT NULL |
Level 9
|
| 210 |
LEVEL10 |
Number(5,0) |
INTEGER NOT NULL |
Level 10
|
| 211 |
LEVEL11 |
Number(5,0) |
INTEGER NOT NULL |
Level 11
|
| 212 |
LEVEL12 |
Number(5,0) |
INTEGER NOT NULL |
Level 12
|
| 213 |
LEVEL13 |
Number(5,0) |
INTEGER NOT NULL |
Level 13
|
| 214 |
LEVEL14 |
Number(5,0) |
INTEGER NOT NULL |
Level 14
|
| 215 |
LEVEL15 |
Number(5,0) |
INTEGER NOT NULL |
Level 15
|
| 216 |
LEVEL16 |
Number(5,0) |
INTEGER NOT NULL |
Level 16
|
| 217 |
LEVEL17 |
Number(5,0) |
INTEGER NOT NULL |
Level 17
|
| 218 |
LEVEL18 |
Number(5,0) |
INTEGER NOT NULL |
Level 18
|
| 219 |
LEVEL19 |
Number(5,0) |
INTEGER NOT NULL |
Level 19
|
| 220 |
LEVEL20 |
Number(5,0) |
INTEGER NOT NULL |
Level 20
|
| 221 |
LEVEL21 |
Number(5,0) |
INTEGER NOT NULL |
Level 21
|
| 222 |
LEVEL22 |
Number(5,0) |
INTEGER NOT NULL |
Level 22
|
| 223 |
LEVEL23 |
Number(5,0) |
INTEGER NOT NULL |
Level 23
|
| 224 |
LEVEL24 |
Number(5,0) |
INTEGER NOT NULL |
Level 24
|
| 225 |
LEVEL25 |
Number(5,0) |
INTEGER NOT NULL |
Level 25
|
| 226 |
LEVEL26 |
Number(5,0) |
INTEGER NOT NULL |
Level 26
|
| 227 |
LEVEL_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Level
|
| 228 |
ROW_NUMBER_5 |
Number(5,0) |
INTEGER NOT NULL |
Row Number
|
| 229 |
CHARGING_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Charging Level - identifies which level of the WBS activities are available for charging.
'D' indicates the detail level, which means all detail activities are available for charging.
'1' indicates level 1 of the WBS is available for charging.
'2' indicates level 2 of the WBS is available for charging.
'3' indicates level 3 of the WBS is available for charging.
1=Costing Level 1
2=Costing Level 2
3=Costing Level 3
D=Detail
|
| 230 |
COSTING_ACT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Costing Switch - determines whether an activity is available for charging. 'Y' = charging is allowed; 'N' = charging is not allowed.
|
| 231 |
LAST_ROW_NUMBER |
Number(5,0) |
INTEGER NOT NULL |
Tracks the last row number used.
|
| 232 |
SUMMARY_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate whether an activity is summary or detail.
N=Detail Activity
Y=Summary Activity
|
| 233 |
CHANGE_REQ_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Change Request ID
|
| 234 |
RANGE_FROM |
Character(30) |
VARCHAR2(30) NOT NULL |
Lower boundary for detail value that contains a range of values
|
| 235 |
RANGE_TO |
Character(30) |
VARCHAR2(30) NOT NULL |
Upper boundary for detail value that contains a range of values
|
| 236 |
SUBTYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Ruleset
|
| 237 |
FILTER_CHARTFIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Ruleset ChartField
|
| 238 |
TREE_LEVEL |
Character(10) |
VARCHAR2(10) NOT NULL |
Tree Level Number
|
| 239 |
CHARTFIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
ChartField
|
| 240 |
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
|
| 241 |
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
|
| 242 |
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
|
| 243 |
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
|
| 244 |
PC_INTFC_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Projects Interface Status
DON=Done
ERR=Errors
NEW=New
|
| 245 |
PC_BUDGET_ID |
Number(3,0) |
SMALLINT NOT NULL |
Budget Plan ID
|
| 246 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 247 |
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.
|
| 248 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 249 |
STATUS_DEF_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Active Processing Status
|
| 250 |
STATUS_DEF_IACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Inactive Processing Status
|
| 251 |
STATUS_DEF_PEND |
Character(1) |
VARCHAR2(1) NOT NULL |
Pending Processing Status
|
| 252 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
|
| 253 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 254 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 255 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
|
| 256 |
EE_PROCESS_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Entry Event Common Run Control Options
A=All Business Units
B=Business Unit
D=Document
N=All Banks
O=Bank Account
P=Payment
R=All Reconciled Payments
T=BU/Project/Plan/Activity/Trans
U=BU/Project/Plan/Activity
V=BU/Project/Plan
W=BU/Project
|
| 257 |
PERCENT_COMPLETE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Complete
|
| 258 |
RETAIN_HISTORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator to determine how often history is retained.
D=Daily
M=Monthly
Q=Quarterly
W=Weekly
|
| 259 |
WORK_CNT1 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 1
|
| 260 |
KK_GEN_PARENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator - Generate Parent Budgets
|
| 261 |
KK_DEFAULT_EE |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator - Use Default Entry Event
|
| 262 |
RUN_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Interface Processing Options
DA=Depreciate All
DC=Delete Conversion Data
DD=Delete Data
DF=Delete Fin
DT=Delete Transactions
FFC=Flexible Formula Calculator
GS=Generate Scan Scope
GT=Generate Trans
LC=Load Conversion Data
LD=Load Data
LF=Load Fin Table from Conversion
LT=Load Transactions
MC=Mass Change
N=None
PM=Purge Mass Changes
PP=Purge Mass Change Preview
RM=Run Match
UA=UnDepreciate All
XD=Extract Data
|
| 263 |
ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entry Event
|
| 264 |
SRC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Source Flag
E=External
I=Internal
|
| 265 |
ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Number to Purge
|
| 266 |
RETAIN_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Project Instances to Retain
|
| 267 |
RUNCNTLID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 268 |
PROCESSINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 269 |
RUNCNTLID_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Control Buil Flag
|
| 270 |
PROC_INSTANCE_SYNC |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance Sync
|
| 271 |
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
|
| 272 |
TEAM_MEMBER_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Team Member Indicator
E=Employee
G=Generic Resource
N=Not Applicable
|
| 273 |
TEAM_MEMBER |
Character(30) |
VARCHAR2(30) NOT NULL |
Team Member
|
| 274 |
DATETIME_STAMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
|
| 275 |
PROJECT_ID_2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Project
|
| 276 |
BUSINESS_UNIT_SEL |
Character(5) |
VARCHAR2(5) NOT NULL |
The general ledger business unit entered as a run time parameter when executing the automat
|
| 277 |
FIELDNAME_EFFDT |
Character(18) |
VARCHAR2(18) NOT NULL |
Effective Date Lookup
|
| 278 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 279 |
BLANK |
Character(1) |
VARCHAR2(1) NOT NULL |
Blank
|
| 280 |
COMBO_EDIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Combinations
|