PC_INTFC_LM_TAO (SQL Table)	Index Back
New Amount Limit Check New BIL rows are stored in this table to be converted in the business units base currency. Foreign_Amount is the native amount. Foreig_Currency is the native currency. The native currency is converted to Resource_Amount. Resouce_Amount is then compared with a similar table with converted limits.

PC_INTFC_LM_TAO

(SQL Table)

New Amount Limit Check

New BIL rows are stored in this table to be converted in the business units base currency. Foreign_Amount is the native amount. Foreig_Currency is the native currency. The native currency is converted to Resource_Amount. Resouce_Amount is then compared with a similar table with converted limits.

Parent record: PROJ_ACTIVITY

# 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
Prompt Table: SP_BU_PC_NONVW

3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: PROJ_SCRTY_SRCH

4 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: PROJ_ACT_SRCH

5 RESOURCE_ID Character(40) VARCHAR2(40) NOT NULL Transaction ID

6 CONTRACT_NUM_PC Character(15) VARCHAR2(15) NOT NULL Project Contract

7 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

8 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

9 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount

10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

11 FOREIGN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.

12 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

13 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.

14 CUR_EFFDT Date(10) DATE Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.

15 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

16 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

#	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 Prompt Table: SP_BU_PC_NONVW
3	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: PROJ_SCRTY_SRCH
4	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: PROJ_ACT_SRCH
5	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
6	CONTRACT_NUM_PC	Character(15)	VARCHAR2(15) NOT NULL	Project Contract
7	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
8	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
9	RESOURCE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
11	FOREIGN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
12	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
13	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.
14	CUR_EFFDT	Date(10)	DATE	Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.
15	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
16	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor