| # |
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 |
BILL_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Plan ID
Prompt Table:
CA_BILL_PLAN
|
| 5 |
EVENT_OCCURRENCE |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.
Default Value: 1
|
| 6 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 7 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: CA_CONTR_HDR.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
|
| 8 |
BILL_EVENT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Billing Event Types -- Date or Milestone
01=Date
02=Milestone
Default Value: 01
|
| 9 |
MILESTONE_ORIGIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Milestone Origin
A=Project
C=Contract
Default Value: C
|
| 10 |
EVENT_DT |
Date(10) |
DATE |
The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting
Default Value: %DATE
|
| 11 |
BP_EVENT_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Event Status
CAN=Cancelled
DON=Completed
HLD=Hold Event
NEW=New Event
PND=Pending
PRG=In Progress
RCL=Recycled
RDY=Ready
REC=Recycled
RIN=Reversal Initiated
RIP=Reversal In Progress
RRP=Recycled
RVS=Reversed
Default Value: PND
|
| 12 |
CA_PERCENTAGE |
Signed Number(13,8) |
DECIMAL(11,8) NOT NULL |
Percentage
|
| 13 |
MS_SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Milestone Number
Prompt Table:
CA_MILESTONE
|
| 14 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
BUS_UNIT_PC_VW
|
| 15 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
CA_PROJ_MS_VW
|
| 16 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
CA_ACT_MS_VW
|
| 17 |
ACTIVITY_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Status
Prompt Table:
PROJ_STATUS_TBL
|
| 18 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 19 |
DAYS_LAG |
Number(3,0) |
SMALLINT NOT NULL |
A number of days lag before an activity/event occurs.
|
| 20 |
TEXT254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Text
|
| 21 |
CA_PER_COMPLETE |
Number(12,8) |
DECIMAL(11,8) NOT NULL |
Percent Complete
|
| 22 |
CA_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Percent Source
1=Manual
2=Auto
|
| 23 |
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.
|
| 24 |
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.
|
| 25 |
CA_NOTE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Note on Invoice Line
H=Invoice Header Note
L=Invoice Line Note
Default Value: H
|
| 26 |
CA_EVT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Event Source
1=Standard
2=Fee
Default Value: 1
|