| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 4 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 6 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 7 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 8 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 9 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 10 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 11 |
BUSINESS_UNIT_CA |
Character(5) |
VARCHAR2(5) NOT NULL |
Contracts Business Unit
|
| 12 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
|
| 13 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
|
| 14 |
TABLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Name
|
| 15 |
TABLE_NAME_FROM |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Name From
|
| 16 |
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.
|
| 17 |
UOM_BILL |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Unit of Measure
|
| 18 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 19 |
CONVERSION_RATE |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Conversion Rate
|
| 20 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 21 |
PC_TEMPLATE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Rate Template ID
|
| 22 |
FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag
N=No
Y=Yes
|
| 23 |
RESOURCE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Transaction ID
|
| 24 |
LINE_NO |
Number(3,0) |
SMALLINT NOT NULL |
Line Number
|
| 25 |
DATE_RANGE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Option
A=Accounting Date
E=All
T=Transaction Date
|
| 26 |
DECIMAL_POSITIONS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 27 |
RATE_DATE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Option
A=Acct Dt
T=Trans Dt
|
| 28 |
RATE_DATE_FIELD |
Character(25) |
VARCHAR2(25) NOT NULL |
Rate Date Field
|
| 29 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 30 |
THRU_DATE |
Date(10) |
DATE |
Through Date
|
| 31 |
SOURCE_TABLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Source Table Name
|
| 32 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 33 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 34 |
SEQ_NBR2 |
Number(15,0) |
DECIMAL(15) NOT NULL |
Used as a key to SHIP_INV_TMP in addition to the DEMAND_PHYS_INV.
|
| 35 |
ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Number to Purge
|
| 36 |
LAST_RESOURCE_ID |
Number(20,0) |
DECIMAL(20) NOT NULL |
Last Transaction ID
|
| 37 |
PC_SWITCH_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Reprice Rows?
|
| 38 |
PC_SWITCH_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Price Unpriced Rows?
|
| 39 |
PC_SWITCH_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Recalculate Tiered Pricing
|
| 40 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 41 |
WHERE_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 42 |
WHERE_CLAUSE_AE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause AE
|
| 43 |
PC_DEFER_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Reprice Deferrals
|
| 44 |
PC_OLT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Reprice OLT's?
|
| 45 |
COMMA |
Character(1) |
VARCHAR2(1) NOT NULL |
COMMA
|
| 46 |
DATE_FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
"(Generic field that crosses multiple products; in Treasury
|
| 47 |
PC_TRANS_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction Identifier
|
| 48 |
UOM_TIER |
Character(3) |
VARCHAR2(3) NOT NULL |
Tier Unit of Measure
|
| 49 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 50 |
ITD_TOTAL |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Inception to Date Quantity
|
| 51 |
PC_TOTAL_QUANTITY |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Total Quantity
|
| 52 |
PC_RUNNING_QTY |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Tier Range Running Quantity
|
| 53 |
PC_RANGE_MAX |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Upper Quantity/Amount
|
| 54 |
PC_BREAK_QTY_LOW |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Low Quantity/Amount
|
| 55 |
PC_RANGE_MAX_ORIG |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Upper Quantity/Amount
|
| 56 |
ADJUSTMENT_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Adjustment Percent
|
| 57 |
CHANGE_QUANTITY |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Change Quantity
|
| 58 |
LIMIT_FLAG |
Number(1,0) |
SMALLINT NOT NULL |
Limit Flag
|
| 59 |
ACTUAL_QUANTITY |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Actual Quantity
|
| 60 |
AE_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exists
|
| 61 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 62 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 63 |
REPRICE_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Reprice Only
|
| 64 |
RECALC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Recalculation Flag
SCP - Added a new label -Recalculate
|
| 65 |
WORK_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count of Anything
|
| 66 |
WORK_CNT1 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 1
|
| 67 |
WORK_CNT2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 2
|
| 68 |
WORK_CNT3 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 3
|
| 69 |
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
|
| 70 |
CST_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Distribution Status
C=Created
D=Distributed
G=Generated
I=Ignore
N=Not Distributed
|
| 71 |
WEIGHT |
Number(15,0) |
DECIMAL(15) NOT NULL |
Field used to store Weight Points.
|
| 72 |
SPLIT_LINE |
Character(1) |
VARCHAR2(1) NOT NULL |
Split Line
|
| 73 |
WHERE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Where Clause
|
| 74 |
RATE_PLAN |
Character(15) |
VARCHAR2(15) NOT NULL |
Rate Plan - A Rate Plan will allow rate sets to be stacked on top of each other so that the output from one rate set can be used to create additional output from the next rate set. Rate Plans will replace existing Burden Plans in release 8.9. A Rate Plan could be tied to Project Type, Project, Activity or Contract line.
|
| 75 |
RATE_PLAN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate plan type determines whether a rate plan is created from Projects or Contracts.
C=Contract
R=Standard
|
| 76 |
RATE_DEF_COST |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Definition to track cost rates.
|
| 77 |
RATE_DEF_BIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Definition to track billing rates.
|
| 78 |
RATE_DEF_REV |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Definition to track revenue rates.
|
| 79 |
SEPARATE_BIL_REV |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag used by Governement Contracts to separate Billing and Revenue transactions
|
| 80 |
CA_RQST_SRC |
Character(3) |
VARCHAR2(3) NOT NULL |
Contract Classification
FED=Federal Reimbursable Agreement
GEN=Generic Application
GOV=Government
INT=Internal
OND=CRM Field Services On Demand
STD=Standard
|
| 81 |
VAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Variance Status
A=Active
I=Inactive
P=Pending
|
| 82 |
TEMPLATE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used to identify what document/transaction is associated with a particular template. This is a translate table field whose value is either expense sheet or travel authorization. Cash advances do not use templates.
Projects is using types are R and C.
C=Contract
E=Expense Report
R=Standard
T=Travel Authorization
|
| 83 |
DETAIL_NO |
Number(3,0) |
SMALLINT NOT NULL |
Detail Number
Default Value: 1
|
| 84 |
TGT_AN_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Target Analysis Type
Prompt Table:
%EDITTABLE5
|
| 85 |
TGT_RES_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Target Resource Type
Prompt Table:
PROJ_RES_TYPE
|
| 86 |
TGT_RES_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Target Resource Category
Prompt Table:
%EDITTABLE3
|
| 87 |
TGT_RES_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Target Resource SubCategory
Prompt Table:
%EDITTABLE4
|
| 88 |
TO_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
To Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 89 |
DELTA_RATE_AMT |
Number(30,6) |
DECIMAL(29,6) NOT NULL |
Delta Rate Amount
|
| 90 |
RATE_AMT |
Number(30,6) |
DECIMAL(29,6) NOT NULL |
Rate Amount for Rates.
Default Value: 1
|
| 91 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %DATE
|
| 92 |
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
|
| 93 |
RATE_DEF_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Definition Type
B=Billing
C=Cost
M=Cost / Billing
R=Revenue
|
| 94 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
Default Value: RUN_CNTL_PC.RUN_CNTL_ID
|
| 95 |
REV_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Revenue Distribution Status
C=Created
D=Distributed
G=Generated
I=Ignore
N=Not Distributed
|
| 96 |
RATE_PLAN_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Plan Basis
A=All
O=Original
T=Target
|
| 97 |
RATE_PLAN_COPY |
Character(15) |
VARCHAR2(15) NOT NULL |
Rate Plan - A Rate Plan will allow rate sets to be stacked on top of each other so that the output from one rate set can be used to create additional output from the next rate set. Rate Plans will replace existing Burden Plans in release 8.9. A Rate Plan could be tied to Project Type, Project, Activity or Contract line.
|
| 98 |
SEQ_NUM_COPY |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 99 |
SRC_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.
|
| 100 |
ORG_RATE_AMT |
Number(30,6) |
DECIMAL(29,6) NOT NULL |
Rate Amount for Rates.
|
| 101 |
TGT_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.
|
| 102 |
TGT_RESOURCE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Transaction ID
|
| 103 |
SRC_QUANTITY |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Quantity
|
| 104 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 105 |
PROJ_ROLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Role
|
| 106 |
RESOURCE_ID_FROM |
Character(40) |
VARCHAR2(40) NOT NULL |
Original Transaction ID
|
| 107 |
APPLY_RATES_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Burden Rates
|
| 108 |
PC_RATE_CATEGORY |
Character(15) |
VARCHAR2(15) NOT NULL |
Rate Set Category
|
| 109 |
PC_VAR_PRICE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Variance Pricing
N=No
Y=Yes
|
| 110 |
DELETE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Deletion Flag
|
| 111 |
RELOAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Reload
|
| 112 |
SQLIDBIND |
Character(254) |
VARCHAR2(254) NOT NULL |
SQLID Binds
|
| 113 |
PRICE_WHERE_SQL |
Character(254) |
VARCHAR2(254) NOT NULL |
SQL fragment for use with the PC_PRICING engine.
|
| 114 |
RATE_NAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Unique Identifier for a Custom Rate Name
|
| 115 |
PCUSER_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Application Instance number.
|
| 116 |
WHERE_CLAUSE8 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|