PO_CNTRCT_WS2 (SQL Table)	Index Back
PO contract WS2

PO_CNTRCT_WS2

(SQL Table)

PO contract WS2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

2 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number

3 ORIG_OPEN_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Original Open Item Amount

4 CURR_OPEN_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Current open item amount

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
2	VERSION_NBR	Number(5,0)	INTEGER NOT NULL	Contract Version number
3	ORIG_OPEN_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Original Open Item Amount
4	CURR_OPEN_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Current open item amount
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
6	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.