SPF_INVDTL_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number Default Value: SPF_INVOICE_HDR.INVOICE_ID
4	INVOICE_LINE	Number(5,0)	INTEGER NOT NULL	Invoice Line
5	TIME_SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Sheet Unique Identifier (System Generated) Default Value: EX_TIME_HDR.TIME_SHEET_ID
6	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
7	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
8	INV_LINE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Line Amount
9	INV_EXP_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Expense Amount
10	INV_LINE_ADJHOURS	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Line Adjusted Hours
11	INV_LINE_ADJAMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Adjusted Invoice Line Amount
12	INV_LINE_ADJRATE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Adjusted Invoice Line Rate
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	INV_LINE_ADJEXP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Line Adjusted Expense Amount
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
16	WORK_ORDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Order ID
17	TIME_QUANTITY	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Time Quantity
18	WO_RATE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	WorkOrder Rate
19	PERIOD_END_DT	Date(10)	DATE	Represents the date termination point for a given time set utilized in cash worksheet processing.
20	COMMENTS	Long Character	CLOB	Comment