BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
PLOG_IDDefault Value: NEXT
LINE_NBRDefault Value: 1
DISTRIB_LINE_NUMPrompt Table: SPF_WO_DIST_VW
Default Value: 0
SPA_PLOG_M_DIST(SQL Table) |
Index Back |
|---|---|
Progress Log Milestone distribProgress Log record to store milestone based distrib details |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 2 | PLOG_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Time Sheet Unique Identifier (System Generated)
Default Value: NEXT |
| 3 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1 |
| 4 | DISTRIB_LINE_NUM |
Number(5,0) | INTEGER NOT NULL |
Distribution Line
Prompt Table: SPF_WO_DIST_VW |
| 5 | SP_BILL_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL |
Billable Amount
Default Value: 0 |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 7 | PERCENT_COMPLETE | Number(6,2) | DECIMAL(5,2) NOT NULL | % Complete |