GM_PT_AWD_TRN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
3	TRANS_ID	Character(50)	VARCHAR2(50) NOT NULL	Transaction ID
4	BUDGET_PERIOD_GM	Number(3,0)	SMALLINT NOT NULL	BUDGET_PERIOD_GM
5	BUDGET_CATEGORY	Character(15)	VARCHAR2(15) NOT NULL	BUDGET_CATEGORY
6	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
7	TRANSACTION_DT	Date(10)	DATE	Transaction date (often used as trade date)
8	AMOUNT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Amount Type CSD=Cost Share Direct CSF=Cost Share F&A INV=Invoice PAY=Payment SPD=Sponsor Direct SPF=Sponsor F&A TCS=Third Party Cost Share
9	INVOICED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amt Invoiced
10	RECEIVED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Received Assets
11	UNPAID_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Unpaid Amount
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
14	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
15	PAYMENT_ID	Character(15)	VARCHAR2(15) NOT NULL	Identifies a customer payment. This is usually a check number but may be some other identifying number.
16	PAYMENT_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
17	ITEM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Item Status C=Closed O=Open
18	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance