SPF_PRGLOG_MS

#	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 Prompt Table: SP_BU_SP_NONVW
2	WORK_ORDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Order ID Prompt Table: SPF_WORDERREC
3	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: SPF_WO_ACT_VW Set Control Field: BUSINESS_UNIT
4	PERCENT_POAMOUNT	Number(3,0)	SMALLINT NOT NULL	Percentage of the total PO Amount. If specified, the amount to be paid (MS_AMOUNT) should be calculated.
5	MS_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Progress Log Milestone Amount
6	MS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Milestone/Activity Status: Status of each milestone/activity. Available options are: New, Pending, Invoiced, Completed. C=Completed I=Invoiced N=New P=Pending Default Value: N
7	MS_COMPLETE_DATE	Date(10)	DATE	Date which RFP Milestone/Activity was completed.
8	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
9	INV_LINE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Line Amount
10	INVOICE_DT	Date(10)	DATE	Invoice Date
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code