| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 4 |
ACCT_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Revenue Recognition Plan
|
| 5 |
EVENT_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Event Number
Default Value: 1
|
| 6 |
AP_EVENT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Accounting Event Type
01=Date
02=Milestone
Default Value: 01
|
| 7 |
CA_PER_COMPLETE |
Number(12,8) |
DECIMAL(11,8) NOT NULL |
Percent Complete
|
| 8 |
PCT_CHANGE |
Signed Number(13,8) |
DECIMAL(11,8) NOT NULL |
Incremental % Complete
|
| 9 |
MILESTONE_ORIGIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Milestone Origin
A=Project
C=Contract
Default Value: C
|
| 10 |
AP_EVENT_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Event Status
CAN=Cancelled
DON=Completed
HLD=Hold Event
NEW=Pending
PRG=In Progress
RDY=Ready
RIN=Reversal Initiated
RIP=Reversal In Progress
RVS=Reversed
Default Value: NEW
|
| 11 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %Date
|
| 12 |
CA_PERCENTAGE |
Signed Number(13,8) |
DECIMAL(11,8) NOT NULL |
Percentage
|
| 13 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 14 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 15 |
TO_DT |
Date(10) |
DATE |
To Date
|
| 16 |
MS_SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Milestone Number
Default Value: 0
Prompt Table:
CA_MS_NST_SN_VW
|
| 17 |
DAYS_LAG |
Number(3,0) |
SMALLINT NOT NULL |
A number of days lag before an activity/event occurs.
|
| 18 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 19 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
SP_CAPRJ3_NONVW
|
| 20 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
CA_ACT_MS_VW
|
| 21 |
ACTIVITY_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Status
Prompt Table:
PROJ_STATUS_TBL
|
| 22 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: CA_CONTR_HDR.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
|
| 23 |
TEXT254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Text
|
| 24 |
CA_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Percent Source
1=Manual
2=Auto
Default Value: 1
|
| 25 |
LASTUPDDTTM |
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.
Default Value: %datetime
|
| 26 |
LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 27 |
CA_EVT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Event Source
1=Standard
2=Fee
Default Value: 1
|
| 28 |
USE_MS_ACCTG_DATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Milestone Accounting Date is to be used for Revenue events of type milestone to provide an option for replacing the accounting date of the event with Milestone completion Date.
This feature of milestone revenue based events are valid for revenue plans having rev rec methods "Milestone" and "As Incurred"
Y/N Table Edit
|