SPA_PLOG_DTL

#	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	PL_LINE_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Progress Log Line Status ADJ=Adjusted APR=Approved DEN=Denied HLD=Hold OPN=Open PND=Pending SUB=Submitted Default Value: OPN
6	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDITTABLE3
7	WORK_ORDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Order ID Prompt Table: %EDITTABLE
8	APPROVAL_OPRID	Character(30)	VARCHAR2(30) NOT NULL	A system generated value that reflects the operator that approved a given transaction.
9	APPROVAL_DT	Date(10)	DATE	Date of Approval
10	APPR_RATINGS	Character(1)	VARCHAR2(1) NOT NULL	Approver ratings of contractor. E=Excellent F=Fair G=Good N=None P=Poor Default Value: N
11	APPR_RATING_NUM	Number(4,2)	DECIMAL(3,2) NOT NULL	Performance Rating
12	PERCENT_COMPLETE	Number(6,2)	DECIMAL(5,2) NOT NULL	% Complete Default Value: 0
13	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
14	PL_RATE	Number(15,4)	DECIMAL(14,4) NOT NULL	Progress Log Rate
15	PL_RATE_BSE	Number(15,4)	DECIMAL(14,4) NOT NULL	Progress Log Rate Base
16	QUANTITY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Interface
17	SP_BILL_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Billable Amount Default Value: 0
18	COMPLETE_DATE	Date(10)	DATE	To save the task execution complete date
19	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.
20	TE_INVOICE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Time and expense invoiced flag N=No Y=Yes Default Value: N
21	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
22	INVOICE_LINE	Number(5,0)	INTEGER NOT NULL	Invoice Line
23	INV_LINE_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Invoice Line Status 1=Generated 10=Adjusted by Ent Approver 11=Adjusted by Enterprise 2=Approved by Enterprise 3=Submitted to Enterprise 4=Denied by Enterprise 5=Submitted to Supplier 6=Approved by Supplier 7=Denied by Supplier 8=Canceled 9=Adjusted by Supplier
24	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
25	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
26	SP_BILL_AMOUNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Time and Expense amount reported in the base currency
27	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
28	RATE_EFFDT	Date(10)	DATE	Rate Effective Date
29	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
30	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
31	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
32	SP_MSP_PERCENT	Number(6,2)	DECIMAL(5,2) NOT NULL	MSP percent
33	SP_MSP_FEE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Managed Service Provider Fee
34	SP_MSP_FEE_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Managed Service Provider Fee (Base Currency)
35	SPA_ADJUSTED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate Progress Log/Expenses has been adjusted A=Adjusted N=Not Adjusted Default Value: N
36	PC_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PC Distribution Status B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged Default Value: N