CA_LMT_TXN_H

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Prompt Table: CA_CNTR_SRCH_VW
4	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
5	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
6	LIMIT_SEQ_TXN	Number(3,0)	SMALLINT NOT NULL	Transaction Limit Sequence
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	LIMIT_AMT_TXN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Limit Amount
9	LMT_PROC_AMT_B	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Funded / Billing Processed Amount
10	LMT_PROC_AMT_R	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revenue Processed Amount
11	LMT_EXCESS_AMT_B	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Funded / Billing Excess Amount
12	LMT_EXCESS_AMT_R	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Revenue Excess Amount
13	LMT_LAST_PROC_DT_B	Date(10)	DATE	Last Funded / Billing Processed Date
14	LMT_LAST_PROC_DT_R	Date(10)	DATE	Last Revenue Processed Date
15	LMT_LAST_TXN_DT_B	Date(10)	DATE	Last Funded / Billing Transaction Date
16	LMT_LAST_TXN_DT_R	Date(10)	DATE	Last Revenue Transaction Date
17	LIMIT_RCHD_DT_BIL	Date(10)	DATE	Date Funded / Billing Limit Reached Date
18	LIMIT_RCHD_DT_REV	Date(10)	DATE	Date Revenue Limit Reached
19	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: CA_DETAIL.CURRENCY_CD
20	CHG_ID	Character(10)	VARCHAR2(10) NOT NULL	Change Package Identifier. This is sequenced from 1 to N for each contract.
21	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