| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
FC_TOTAL_HOURS |
Signed Number(11,2) |
DECIMAL(9,2) NOT NULL |
Total Hours
|
| 3 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 4 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 5 |
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
|
| 6 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: Y
|
| 7 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: Y
|
| 8 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Default Value: Y
|
| 9 |
RESOURCE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Transaction ID
|
| 10 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 11 |
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.
|
| 12 |
JOURNAL_DATE |
Date(10) |
DATE |
Specifies the date the journal was created.
|
| 13 |
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".
|
| 14 |
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.
|
| 15 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
|
| 16 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 17 |
FROM_FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
From Fiscal Year
|
| 18 |
FROM_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
From Period
|
| 19 |
THRU_FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Thru Fiscal Year
|
| 20 |
THRU_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Thru Period
|
| 21 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 22 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 23 |
END_DT |
Date(10) |
DATE |
End Date
|
| 24 |
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.
|
| 25 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 26 |
THRU_DATE |
Date(10) |
DATE |
Through Date
|
| 27 |
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
|
| 28 |
DATE_RANGE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Option
A=Accounting Date
E=All
T=Transaction Date
|
| 29 |
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
|
| 30 |
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
|
| 31 |
PO_SEL_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchasing Select Options
A=Requisitions / Purchase Orders
P=Purchase Orders
R=Requisitions
|
| 32 |
RRV_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Requisition Reversal
A=COM Amount
Q=REQ Rate
X=REQ Total
|
| 33 |
CRV_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Order Reversal
A=ACT Amount
Q=COM Rate
|
| 34 |
RUN_DT |
Date(10) |
DATE |
Run Date
|
| 35 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 36 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 37 |
ANALYSIS_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Analysis Group
|
| 38 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 39 |
ANALYSIS_TYPE_MAP |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type Map
|
| 40 |
SIGNED_VALUE |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Amount Multiplier
|
| 41 |
AN_TYPE_AP |
Character(3) |
VARCHAR2(3) NOT NULL |
Payables
|
| 42 |
AN_TYPE_EX |
Character(3) |
VARCHAR2(3) NOT NULL |
Expenses
|
| 43 |
AN_TYPE_IN |
Character(3) |
VARCHAR2(3) NOT NULL |
Inventory
|
| 44 |
AN_TYPE_OM |
Character(3) |
VARCHAR2(3) NOT NULL |
Order Management
|
| 45 |
AN_TYPE_PO_PO |
Character(3) |
VARCHAR2(3) NOT NULL |
Purchase Orders
|
| 46 |
AN_TYPE_PO_REQ |
Character(3) |
VARCHAR2(3) NOT NULL |
Requisitions
|
| 47 |
AN_TYPE_TL |
Character(3) |
VARCHAR2(3) NOT NULL |
Time / Labor Actuals
|
| 48 |
AN_TYPE_TL_EST |
Character(3) |
VARCHAR2(3) NOT NULL |
Time / Labor Estimates
|
| 49 |
AN_TYPE_TL_BI |
Character(3) |
VARCHAR2(3) NOT NULL |
Time / Labor Billing Estimate
|
| 50 |
AN_TYPE_TL_CON |
Character(3) |
VARCHAR2(3) NOT NULL |
Contractor Time / Labor
|
| 51 |
AN_TYPE_AR_ADJ |
Character(3) |
VARCHAR2(3) NOT NULL |
Receivables Adjustment
|
| 52 |
AN_TYPE_TT_EX |
Character(3) |
VARCHAR2(3) NOT NULL |
Mobile Time / Expense
|
| 53 |
AN_TYPE_SP_INC |
Character(3) |
VARCHAR2(3) NOT NULL |
SPro Assignment Incident
|
| 54 |
AN_TYPE_SP_LOG |
Character(3) |
VARCHAR2(3) NOT NULL |
SPro Progress Log
|
| 55 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 56 |
PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Profile ID
|
| 57 |
INCENTIVE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Investment Incentive ID
|
| 58 |
INCENTIVE_ID_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Incentive ID Option
A=All Incentives
V=Specific Incentives
|
| 59 |
CRITERIA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Selection Criteria ID
|
| 60 |
AUTHORIZATION_MAX |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Authorization Amount
|
| 61 |
AUTHORIZATION_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Authorization Percentage
|
| 62 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 63 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 64 |
EXISTING_GNT_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Resource Amount
|
| 65 |
NEW_GNT_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Resource Amount
|
| 66 |
JUST_OVER_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Resource Amount
|
| 67 |
RESOURCE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 68 |
DONE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Done Flag
|
| 69 |
INCLUDE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
include flag
|
| 70 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 71 |
LAST_RESOURCE_ID |
Number(20,0) |
DECIMAL(20) NOT NULL |
Last Transaction ID
|
| 72 |
KEY_DATE_07 |
Date(10) |
DATE |
Key Date 07
|
| 73 |
KEY_NUM_8 |
Number(8,0) |
INTEGER NOT NULL |
Key Number 8
|
| 74 |
KEY_NUM_9 |
Number(8,0) |
INTEGER NOT NULL |
Key Number 9
|
| 75 |
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.
|
| 76 |
SUM_AN_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Summary Analysis Type
|
| 77 |
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.
|
| 78 |
COUNT_1 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 79 |
COUNTER1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Counter 1
|
| 80 |
ASSIGN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Assign
|
| 81 |
PC_AM_RUN_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset Processing Destination
B=Summarize and Run Interface
D=Asset Integration Rule Default
I=Run Interface
L=Sum, Run and Load Transactions
R=Run Interface and Load
S=Summarize
|
| 82 |
ASSET_ID_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset ID Option
A=Selected AM Unit / Asset ID
B=Selected AM Unit
E=All
|
| 83 |
SUMMARIZE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Summarize Type
A=By Asset
P=By Profile
|
| 84 |
SUMMARIZE_AN_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Summarize Analysis Type
|
| 85 |
INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 86 |
INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Interface Line Number
|
| 87 |
LAST_INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Last Interface ID
|
| 88 |
CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Asset Category
|
| 89 |
LAST_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Last Business unit tagged
|
| 90 |
PRIOR_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Prior Asset ID
|
| 91 |
SEQUENCE_NBR_6 |
Number(6,0) |
INTEGER NOT NULL |
Sequence
|
| 92 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
|
| 93 |
COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type
|
| 94 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 95 |
TO_DT |
Date(10) |
DATE |
To Date
|
| 96 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 97 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 98 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
|
| 99 |
PUBLIC_SECTOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Public Sector
|
| 100 |
AE_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exists
|
| 101 |
WORK_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count of Anything
|
| 102 |
TOTAL_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Total Hours
|
| 103 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 104 |
DECIMAL_POS_BSE |
Number(2,0) |
SMALLINT NOT NULL |
Base Cur Decimal Positions
|
| 105 |
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
|
| 106 |
PURGE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Purge History without Archive
|
| 107 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 108 |
FIELDNAME_BASE_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
Base Amount
|
| 109 |
FIELDNAME_BASE_CUR |
Character(18) |
VARCHAR2(18) NOT NULL |
Base Currency
|
| 110 |
FIELDNAME_CUREFFDT |
Character(18) |
VARCHAR2(18) NOT NULL |
Currency Effective Date
|
| 111 |
FIELDNAME_RT_TYPE |
Character(18) |
VARCHAR2(18) NOT NULL |
Rate Type
|
| 112 |
FIELDNAME_TRAN_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
Transaction Amount
|
| 113 |
FIELDNAME_TRAN_CUR |
Character(18) |
VARCHAR2(18) NOT NULL |
Transaction Currency
|
| 114 |
FIELDNAME_FROM_CUR |
Character(18) |
VARCHAR2(18) NOT NULL |
From Currency
|
| 115 |
FIELDNAME_FROM_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
From Amount
|
| 116 |
FIELDNAME_TO_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
To Amount
|
| 117 |
FIELDNAME_TO_CUR |
Character(18) |
VARCHAR2(18) NOT NULL |
To Currency
|
| 118 |
RECNAME_SOURCE |
Character(15) |
VARCHAR2(15) NOT NULL |
Source Recname
|
| 119 |
RECNAME_TARGET |
Character(15) |
VARCHAR2(15) NOT NULL |
Target Recname
|
| 120 |
RECNAME_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name
|
| 121 |
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.
|
| 122 |
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.
|
| 123 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 124 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 125 |
FROM_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
From Currency Code
|
| 126 |
TO_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
To Currency Code
|
| 127 |
BU_CUR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Override
|
| 128 |
PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Processing Flag
|
| 129 |
COMBO_EDIT_TMPL |
Character(10) |
VARCHAR2(10) NOT NULL |
Record Template
|
| 130 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 131 |
DET_SUM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Detail or Summary
D=Detail
S=Summary
|
| 132 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 133 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 134 |
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
|
| 135 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 136 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 137 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 138 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 139 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
|
| 140 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 141 |
TIME_RPTG_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Time Reporting Code
|
| 142 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 143 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 144 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 145 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 146 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 147 |
RATE_OPTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Rate Option
ABI=Activity Bill Rate
ACO=Activity Cost Rate
AML=Mark Up/Down Labor
AMN=Mark Up/Down Non-labor
AMT=Quantity Rate
CRB=Custom Bill Rate
CRC=Custom Cost Rate
EBI=Employee Bill Rate
ECO=Employee Cost Rate
FIX=Fixed Amount
JBI=Job Code Bill Rate
JCO=Job Code Cost Rate
MUP=Markup Rate
NON=Bill at Cost
RBI=Project Role Bill Rate
RCO=Project Role Cost Rate
TBI=MM Tools Usage Bill Rate
TCO=MM Tools Usage Cost Rate
WBI=Work Order Labor Bill Rate
WCO=Work Order Labor Cost Rate
|
| 148 |
RATE_AMT |
Number(30,6) |
DECIMAL(29,6) NOT NULL |
Rate Amount for Rates.
|
| 149 |
PROCESS_INST_STG |
Number(10,0) |
DECIMAL(10) NOT NULL |
Stage Record Process Instance
|
| 150 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 151 |
CUR_EFFDT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Effective Date Option
A=Accounting Date
T=Transaction Date
V=Value
|
| 152 |
OPEN_TRANS_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Open Transaction ID
|
| 153 |
BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Book Name
|
| 154 |
TRANS_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Transaction Code
|
| 155 |
DTTM_STAMP_SEC |
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.
|
| 156 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
|
| 157 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 158 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 159 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 160 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 161 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
|
| 162 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
|
| 163 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
|
| 164 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
|
| 165 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
|
| 166 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
|
| 167 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
|
| 168 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
|
| 169 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
|
| 170 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
|
| 171 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
|
| 172 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
|
| 173 |
SCENARIO |
Character(10) |
VARCHAR2(10) NOT NULL |
A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca
|
| 174 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
|
| 175 |
PROJECT_MANAGER |
Character(11) |
VARCHAR2(11) NOT NULL |
Project Manager
|
| 176 |
PROJECT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
|
| 177 |
CURRENCY_CD_BUGL |
Character(3) |
VARCHAR2(3) NOT NULL |
GL Business Unit Currency
|
| 178 |
BUDGET_PERIOD |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Period
|
| 179 |
JOURNAL_NUM_ASSIGN |
Number(10,0) |
DECIMAL(10) NOT NULL |
Journal Number - Auto Assigned
|
| 180 |
INHERIT_BASE_CUR |
Character(1) |
VARCHAR2(1) NOT NULL |
Inherit Base Currency
|
| 181 |
CUR_RT_TYPE_DFLT |
Character(5) |
VARCHAR2(5) NOT NULL |
Exchange Rate Type Default
|
| 182 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 183 |
FOREIGN_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Foreign Currency Code
|
| 184 |
TOTAL_CNT |
Number(4,0) |
SMALLINT NOT NULL |
Total Objects
|
| 185 |
PC_TLA_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Time and Labor Estimates
|
| 186 |
PC_TLB_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Time and Labor for Billing
|
| 187 |
PC_TLC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Time and Labor Contractor
|
| 188 |
PC_PAY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Time and Labor Actuals
|
| 189 |
TO_DT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
To Date Option
C=Current Date
F=End Date - From Period
P=Process Date
S=Specify Date
T=End Date - To Period
|
| 190 |
FROM_DT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
From Date Option
C=Current Date
F=Begin Date - From Period
N=No From Date
P=Process Date
S=Specify Date
T=Begin Date - To Period
|
| 191 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
|
| 192 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 193 |
ACTIVITY_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Activity Type
A=Activity Type
E=Entry Type
G=Group Type/Origin
O=Activity Type/Origin
R=Entry Type/Reason
|
| 194 |
ASOF_FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
As Of Fiscal Year
|
| 195 |
ASOF_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
As Of Period
|
| 196 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
|
| 197 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 198 |
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
|
| 199 |
PC_INTFC_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Interface Options
A=All Interface ID's
R=Range of Intfc ID's
|
| 200 |
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
|
| 201 |
PC_THRESHOLD_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Interface Line Options
A=All Lines
R=Range of Lines
|
| 202 |
PC_REQ_REV_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Requisition Reversals
|
| 203 |
RECON_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Used for the TL_TO_PC application engine
A=Reconcile by Amount
B=Both Quantity and Amount
N=Do not Reconcile
Q=Reconcile by Quantity
|
| 204 |
RUN_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Program Run Code
1=Load ASSETGEN.ASC File
2=Load BOOKDATA.ASC File
3=Load LABLINFO.ASC File
4=Load PROPTMGR.ASC File
N=None
PRE=Preview Process
PRO=Procedural
RUN=Run Process
SET=Set Process
|
| 205 |
FLEX_GROUP_ID |
Number(8,0) |
INTEGER NOT NULL |
Line Number
|
| 206 |
TO_FLEX_GROUP_ID |
Number(8,0) |
INTEGER NOT NULL |
To Line Number
|
| 207 |
TO_INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
To Interface ID
|
| 208 |
PC_CCA_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Order Adjustments
|
| 209 |
PC_PO_REV_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Order Reversals
|
| 210 |
TRANS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Types of Asset Management Transactions
ACR=Accretion Expense
ADD=Asset Addition
ADJ=Asset Cost Adjustment
BKS=Book Adjustment
BUD=Budgeted Depreciation
DPR=Depreciation
INF=Inflation Adjustment
LEX=Lease Expense
LPB=Budgeted Lease Payments
LPY=Lease Payment
PDP=Prior Period Depreciation
PLP=Prior Lease Payment
RAD=Manual Reserve Adjustment
RCT=Asset Recategorization
REI=Asset Reinstatement
RES=Resume Depreciation
RET=Asset Retirement
RRC=Retro rate change for grp ast
SUS=Suspend Depreciation
TRF=Asset Transfer
|
| 211 |
DTTM_STAMP_MSEC |
Character(25) |
VARCHAR2(25) NOT NULL |
DateTime
|
| 212 |
BUDG_ANALYSIS_GRP |
Character(5) |
VARCHAR2(5) NOT NULL |
Budget Analysis Group
|
| 213 |
COST_ANALYSIS_GRP |
Character(5) |
VARCHAR2(5) NOT NULL |
Cost Analysis Group
|
| 214 |
REV_ANALYSIS_GRP |
Character(5) |
VARCHAR2(5) NOT NULL |
Revenue Analysis Group
|
| 215 |
EMPL_RCD_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Project Employee Job Record #
|
| 216 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 217 |
EDIT_TABLE |
Character(18) |
VARCHAR2(18) NOT NULL |
Edit Table
|
| 218 |
FUNCLIB |
Character(1) |
VARCHAR2(1) NOT NULL |
Function Library
|
| 219 |
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.
|
| 220 |
BUSINESS_UNIT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit Option
A=All Business Units
V=Specific Business Unit
|
| 221 |
JOURNAL_ID_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal ID Option
A=All Journal IDs
S=Some Journal ID Values
|
| 222 |
JOURNAL_ID_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Range From Journal ID
|
| 223 |
JOURNAL_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Range to Journal ID
|
| 224 |
CNTRL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control Option
0=Control
1=Tracking w/ Budget
2=Track w/o Budget
3=Default from Higher Level
4=Control Initial Document
|
| 225 |
BUDGET_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Status
0=Open
1=Closed
2=Hold
3=Default
|
| 226 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 227 |
IN_USE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Table in use switch
|
| 228 |
AE_SW1 |
Character(1) |
VARCHAR2(1) NOT NULL |
AE Switch
|
| 229 |
AE_SW2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Generic field used for decision processing in App. Engine.
|
| 230 |
WHERE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Where Clause
|
| 231 |
KEY1 |
Character(65) |
VARCHAR2(65) NOT NULL |
First Key
|
| 232 |
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. "
|
| 233 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 234 |
BUS_UNIT_GL_FROM |
Character(5) |
VARCHAR2(5) NOT NULL |
From Business Unit GL
|
| 235 |
PROJ_TRANS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Project Transaction Type
|
| 236 |
PROJ_TRANS_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Transaction Code
|
| 237 |
PC_USE_RECORD |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Record
F=PC_BUD_DETAIL
R=PROJ_RESOURCE
|
| 238 |
RES_USER1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 1
|
| 239 |
RES_USER2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 2
|
| 240 |
RES_USER3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 3
|
| 241 |
RES_USER4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction User 4
|
| 242 |
HOLIDAY_HRS |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Holiday Hours
|
| 243 |
HOLIDAY_SCHEDULE |
Character(6) |
VARCHAR2(6) NOT NULL |
Holiday Schedule
|
| 244 |
STD_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Standard Hours
|
| 245 |
HOLIDAY |
Date(10) |
DATE |
Holiday
|
| 246 |
HOLIDAY_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Holiday Type
BRG=Bridge
CAN=Canadian
HALF=1/2 Day
HIGH=High
LOW=Low
STD=Standard
USA=U.S. Public
VERY=Very High
|
| 247 |
PROJ_ROLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Role
|
| 248 |
FORECAST_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Forecast Level
A=Project/Activity
P=Project
|
| 249 |
FORECAST_RATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Standard Rate
E=Resource
J=Job Code
R=Role
|
| 250 |
FORECAST_HORIZON |
Number(3,0) |
SMALLINT NOT NULL |
Forecast Horizon
|
| 251 |
FREQ_ANNUAL_FACTOR |
Number(9,4) |
DECIMAL(8,4) NOT NULL |
Specifies the factor used for annualization/deannualization in a frequency conversion. The Frequency Annualization Factor is expressed in times per year.
|
| 252 |
PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Period
|
| 253 |
TRC |
Character(5) |
VARCHAR2(5) NOT NULL |
Time Reporting Code
|
| 254 |
TOTAL_DETAIL |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Total Detail
|
| 255 |
REMAINING_HRS |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Remaining Hours
|
| 256 |
WORK_DAY_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Number of Hours in a Work Day
|
| 257 |
TIME_QUANTITY |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Time Quantity
|
| 258 |
BUDGET_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
BUDGET_ID
|
| 259 |
JOURNAL_DATE_FROM |
Date(10) |
DATE |
Journal Date From
|
| 260 |
JOURNAL_DATE_TO |
Date(10) |
DATE |
To Journal Date
|
| 261 |
AN_GRP_ACTV_BUD |
Character(5) |
VARCHAR2(5) NOT NULL |
Budget Analysis Group
|
| 262 |
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
|
| 263 |
WHERE_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 264 |
ADJUSTING_ENTRY |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjusting Entry
C=Fiscal Year Close
N=Non-Adjusting Entry
Y=Adjusting Entry
|
| 265 |
FIELDNAME_ADJUST |
Character(28) |
VARCHAR2(28) NOT NULL |
ADJUSTING ENTRY
|
| 266 |
FIELDNAME_ADJUST2 |
Character(17) |
VARCHAR2(17) NOT NULL |
ADJUSTING ENTRY
|
| 267 |
COMPRESS_TEMPLATE |
Character(15) |
VARCHAR2(15) NOT NULL |
A unique identifier for a Project Compression template.
|
| 268 |
COMPRESS_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
A unique identifier for a single run instance of the Project Compression Utility (PC_COMPRESS)
|
| 269 |
FROMPHRASE |
Character(254) |
VARCHAR2(254) NOT NULL |
From Phrase
|
| 270 |
TABLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Name
|
| 271 |
AN_GRP_BIL |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Analysis Group
|
| 272 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 273 |
CUR_RT_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Exchange Rate Source
T=Use Exchange Rate Tables
U=User Specified
|
| 274 |
ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Number to Purge
|