CA_LMT_TXN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Prompt Table: CA_CNTR_SRCH_VW
2	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
3	TXN_LMT_TRANS_ID	Character(10)	VARCHAR2(10) NOT NULL	Transaction Limit Identifer Prompt Table: CA_TXN_LMT_ID Set Control Field: BUSINESS_UNIT_PC
4	LIMIT_SEQ_TXN	Number(3,0)	SMALLINT NOT NULL	Transaction Limit Sequence
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	LIMIT_AMT_TXN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Limit Amount
7	LMT_PROC_AMT_B	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Funded / Billing Processed Amount
8	LMT_PROC_AMT_R	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revenue Processed Amount
9	LMT_EXCESS_AMT_B	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Funded / Billing Excess Amount
10	LMT_EXCESS_AMT_R	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revenue Excess Amount
11	LMT_LAST_PROC_DT_B	Date(10)	DATE	Last Funded / Billing Processed Date
12	LMT_LAST_PROC_DT_R	Date(10)	DATE	Last Revenue Processed Date
13	LMT_LAST_TXN_DT_B	Date(10)	DATE	Last Funded / Billing Transaction Date
14	LMT_LAST_TXN_DT_R	Date(10)	DATE	Last Revenue Transaction Date
15	LIMIT_RCHD_DT_BIL	Date(10)	DATE	Date Funded / Billing Limit Reached Date
16	LIMIT_RCHD_DT_REV	Date(10)	DATE	Date Revenue Limit Reached
17	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: CA_DETAIL.CURRENCY_CD
18	CHG_ID	Character(10)	VARCHAR2(10) NOT NULL	Change Package Identifier. This is sequenced from 1 to N for each contract.
19	CHG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Change Status indicates if this change package is open for further edit: pending, ready for processing by the app. engine component of contract change management (ready) or complete, meaning that no further edit is possible and all changes have been aplied. C=Complete P=Pending R=Ready X=Cancelled