| # |
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 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 5 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 6 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 7 |
NBR_ORG_CFS |
Character(1) |
VARCHAR2(1) NOT NULL |
Number of Chartfields
1=1
2=2
3=3
4=4
5=5
|
| 8 |
LEVEL1_CF |
Character(30) |
VARCHAR2(30) NOT NULL |
Level 1 Chartfield
|
| 9 |
LEVEL2_CF |
Character(30) |
VARCHAR2(30) NOT NULL |
Level 2 Chartfield
|
| 10 |
LEVEL3_CF |
Character(30) |
VARCHAR2(30) NOT NULL |
Level 3 Chartfield
|
| 11 |
LEVEL4_CF |
Character(30) |
VARCHAR2(30) NOT NULL |
Level 4 Chartfield
|
| 12 |
LEVEL5_CF |
Character(30) |
VARCHAR2(30) NOT NULL |
Level 5 Chartfield
|
| 13 |
ORG_COMPARE |
Character(4) |
VARCHAR2(4) NOT NULL |
Organization Comparison
DFLT=Default
I-BU=inter-Business Unit
I-DE=inter-Department
I-OP=inter-Operating Unit
I-PR=inter-Product
LVL1=Level 1
LVL2=Level 2
LVL3=Level 3
LVL4=Level 4
LVL5=Level 5
|
| 14 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 15 |
PROJECT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
|
| 16 |
PROJECT_MANAGER |
Character(11) |
VARCHAR2(11) NOT NULL |
Project Manager
|
| 17 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 18 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 19 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 20 |
RESOURCE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Transaction ID
|
| 21 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
|
| 22 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 23 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 24 |
CONTRACT_PPD_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Prepaid Add Sequence
|
| 25 |
CONTRACT_DT |
Date(10) |
DATE |
Contract Date
|
| 26 |
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.
|
| 27 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 28 |
THRU_DATE |
Date(10) |
DATE |
Through Date
|
| 29 |
OVERRIDE_ACCTG_DT |
Date(10) |
DATE |
Override Accounting Date
|
| 30 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
|
| 31 |
BUSINESS_UNIT_CA |
Character(5) |
VARCHAR2(5) NOT NULL |
Contracts Business Unit
|
| 32 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 33 |
FIELDNAME_CUREFFDT |
Character(18) |
VARCHAR2(18) NOT NULL |
Currency Effective Date
|
| 34 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 35 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 36 |
QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 37 |
DST_USE |
Character(3) |
VARCHAR2(3) NOT NULL |
Added the following inactive translates for Contracts 8.4:
AP Accounts Payable Liability
AS Fixed Asset
CA Contra Asset
CG Cost of Goods Sold
CL Contra Liability
EX Expense
IN Inventory
WP Work In Progress
|
| 38 |
DEBIT_CREDIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Debit / Credit Indicator
CR=Credit
DR=Debit
|
| 39 |
ACCT_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Revenue Recognition Plan
|
| 40 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 41 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 42 |
RESOURCE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 43 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 44 |
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. "
|
| 45 |
INHERIT_BASE_CUR |
Character(1) |
VARCHAR2(1) NOT NULL |
Inherit Base Currency
|
| 46 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 47 |
LINE_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 48 |
POST_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
POSTING SEQUENCE NUMBER
|
| 49 |
TABLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Name
|
| 50 |
TABLE_NAME_FROM |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Name From
|
| 51 |
TABLE_NAME_TO |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Name To
|
| 52 |
CA_TXN_ID |
Number(12,0) |
DECIMAL(12) NOT NULL |
Transaction ID
|
| 53 |
PROJECT_FLAG |
Character(3) |
VARCHAR2(3) NOT NULL |
Flag for Accounting Rules page. Specifies whether or not the Project ID value flows thru from PROJ_RESOURCE or flows thru with no value.
NON=None
SRC=Source
|
| 54 |
STATE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
State Name
|
| 55 |
CF_NAME1 |
Character(18) |
VARCHAR2(18) NOT NULL |
ChartField Name 1
|
| 56 |
CF_VALUE1 |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value 1
|
| 57 |
WORK_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count of Anything
|
| 58 |
WORK_CNT2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 2
|
| 59 |
WORK_CNT2_CA |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 2
|
| 60 |
WORK_CNT2_PC |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 2
|
| 61 |
WORK_CNT3 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 3
|
| 62 |
LEVEL_CNT |
Number(3,0) |
SMALLINT NOT NULL |
Level Count
|
| 63 |
WEIGHT |
Number(15,0) |
DECIMAL(15) NOT NULL |
Field used to store Weight Points.
|
| 64 |
COUNT_IU |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count Inter/Intra-Unit Rows
|
| 65 |
CUR_EFFDT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Eff. Date Default
A=Accounting Date
C=Current Date
T=Transaction Date
|
| 66 |
CURR_TRANS_DATE |
Character(3) |
VARCHAR2(3) NOT NULL |
Date Type
ACT=Accounting Date
TRN=Transaction Date
|
| 67 |
ORG_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Organization
Y/N Table Edit
Default Value: N
|
| 68 |
PSA_PROCESS_OPTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Purge Process Option
ALL=Process All
CST=Process Costs
REV=Process Revenue
|
| 69 |
IU_SYS_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.
|
| 70 |
IU_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.
|
| 71 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 72 |
WHERE_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 73 |
CONTRACT_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Type
|
| 74 |
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
|
| 75 |
ACCT_DEF_NAME_FS |
Character(10) |
VARCHAR2(10) NOT NULL |
TBP Accounting Definition Entry
|
| 76 |
ACCT_DEF_NAME_PC |
Character(10) |
VARCHAR2(10) NOT NULL |
Acctg Definition Projects
|
| 77 |
COMBO_EDIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Combinations
|
| 78 |
CA_PREFIX |
Character(10) |
VARCHAR2(10) NOT NULL |
Table Prefix
|
| 79 |
RUN_TBP_TXN |
Character(1) |
VARCHAR2(1) NOT NULL |
Run CRM Accounting flag
Default Value: N
|
| 80 |
PC_INSTALLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Projects installed flag
|
| 81 |
GVC_INSTALLED |
Character(1) |
VARCHAR2(1) NOT NULL |
GVC installed flag
|
| 82 |
GL_STREAM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Journal Entries
Default Value: N
|
| 83 |
MS_STREAM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Milestones
|
| 84 |
CA_FEE_TYPE1_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Plus Fee Type None
|
| 85 |
CA_FEE_TYPE2_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Plus Fee Type Fixed
|
| 86 |
CA_FEE_TYPE3_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Plus Fee Type Award
|
| 87 |
CA_FEE_TYPE4_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Plus Fee Type Incentive
|
| 88 |
CA_FEE_TYPE5_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Plus Fee Type Other
|
| 89 |
SEPARATE_BIL_REV |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag used by Governement Contracts to separate Billing and Revenue transactions
|
| 90 |
ANALYSIS_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Analysis Group
|
| 91 |
WHERE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Where Clause
|
| 92 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 93 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 94 |
REVENUE_PROFILE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Revenue Profile
|
| 95 |
PM_REVIEW_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Required for Billing
N=PM Review not used
Y=PM Review enabled
|