SPF_INV_DTL_ADJ

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
3	INVOICE_LINE	Number(5,0)	INTEGER NOT NULL	Invoice Line
4	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
5	ADJUST_DTTM	DateTime(26)	TIMESTAMP NOT NULL	Adjust Date and Time Default Value: %datetime
6	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
7	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.
8	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
9	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
10	RATE_DATE	Date(10)	DATE	Exchange Rate Date
11	SP_TIME_QTY_ADJ	Signed Number(18,4)	DECIMAL(16,4) NOT NULL	Adjusted Time Quantity
12	ADJ_VAT_PCT	Signed Number(9,4)	DECIMAL(7,4) NOT NULL	Specifies the tax percentage that corresponds to the VAT code which has been adjusted.
13	ADJ_SUT_PCT	Number(8,4)	DECIMAL(7,4) NOT NULL	Adjusted Sales/Use Tax Code Percent
14	INV_LINE_ADJRATE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Adjusted Invoice Line Rate
15	INV_LINE_ADJAMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Adjusted Invoice Line Amount
16	ADJ_VAT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	This field stores the adjusted VAT amount. The original amount is stored in the VAT_AMT field for sPro.
17	ADJ_VAT_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Adjusted VAT Amount - Base Currency
18	ADJ_USETAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	This field stores the adjusted Use Tax amount. The original amount is stored in the USETAX_AMT field for sPro.
19	ADJ_USETAX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	This field stores the adjusted Use Tax amount in Base Currency. The original amount is stored in the USETAX_AMT_BSE field for sPro.
20	ADJ_SALETX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	This field stores the adjusted Sales Tax Amount. The original amount is stored in the SALETX_AMT field for sPro.
21	ADJ_SALETX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Adjusted Sales Tax Amount - Base Currency This field stores the adjusted Sales Tax Amount in Base Currency. The original amount is stored in the SALETX_AMT_BSE field for sPro.
22	INV_LINE_ADJEXP	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Line Adjusted Expense Amount
23	ADJ_SP_MSP_FEE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Managed Service Provider/Vendor Managed Services Fee
24	ADJ_SP_MSP_FEE_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Managed Service Provider/Vendor Managed Services Fee
25	INV_LN_ADJRATE_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Invoice Line Adjusted Rate in Base Currency
26	INV_LN_ADJAMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Line Adjusted Amount in base currency
27	INV_LN_ADJEXP_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Line Adjusted Expense Amount in Base Currency
28	INVOICE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
29	INVOICE_AMOUNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount in Base Currency
30	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
31	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
32	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
33	SPF_ADJUST_BY_USER	Character(30)	VARCHAR2(30) NOT NULL	Adjusted By