PRCR_TXN_HIST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REPORT_ENTITY	Character(5)	VARCHAR2(5) NOT NULL	Reporting Entity ID
2	PRCR_DOC_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Document Type CNT=Contract IUR=Inter Unit Receipt MSR=MSR PMT=Payment PO=Purchase Order RCV=Receipt REQ=Requisition RFQ=Request For Quote RTV=Return To Vendor (Supplier) SSE=Strategic Sourcing Event VOU=Voucher WO=Work Order
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
5	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
6	PERIOD_NAME	Character(30)	VARCHAR2(30) NOT NULL	Period Name
7	PERIOD_ABBRV	Character(3)	VARCHAR2(3) NOT NULL	Abbreviation
8	PRCR_TXN_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	Transactions Count
9	PRCR_TXN_LN_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	Lines Count
10	PRCR_TXN_SH_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	Schedules Count
11	PRCR_TXN_DS_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	Distributions Count
12	PRCR_AVG_TXN_LINES	Number(10,0)	DECIMAL(10) NOT NULL	Average Transaction Lines
13	PRCR_MAX_TXN_LINES	Number(10,0)	DECIMAL(10) NOT NULL	Maximum Transaction Lines
14	PRCR_TXN_BATCH_LD	Number(10,0)	DECIMAL(10) NOT NULL	Transactions Batch Loaded
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
16	MAX_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Maximum Amount
17	MIN_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Minimum Amount
18	PRCR_TXN_CHNG_ORD	Number(10,0)	DECIMAL(10) NOT NULL	Transaction Change Orders
19	PRCR_TXN_OVER_DUE	Number(10,0)	DECIMAL(10) NOT NULL	Transaction Over Due