PROJ_FUND_DISTR(SQL Table) |
Index Back |
---|---|
Project ActivitiesProject Activities |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: PROJECT.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW |
|
2 | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: PROJECT.PROJECT_ID Prompt Table: SP_PROJ_NONVW |
|
3 | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Default Value: PROJ_ACTIVITY.ACTIVITY_ID Prompt Table: PROJ_ACT_VW |
|
4 | Number(3,0) | SMALLINT NOT NULL |
Project Activity Sequence Num
Default Value: 1 |
|
5 | PROJ_ACTV_FUND | Signed Number(19,2) | DECIMAL(17,2) NOT NULL | Project Activity Fund |