BI_ACCT_ITM_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	COMMON_ID	Character(11)	VARCHAR2(11) NOT NULL	Common ID to store Personal ID / Ext Org ID value
3	SA_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ID Type O=Organization P=Person
4	ITEM_NBR	Character(15)	VARCHAR2(15) NOT NULL	Item Nbr
5	LINE_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Line Sequence Nbr
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
7	ACCOUNT_NBR	Character(10)	VARCHAR2(10) NOT NULL	Account Nbr
8	ACCOUNT_TERM	Character(4)	VARCHAR2(4) NOT NULL	Account Term
9	ACCOUNT_TYPE_SF	Character(3)	VARCHAR2(3) NOT NULL	Account Type Prompt Table: ACCT_TYP_TBL_SF
10	ACCOUNT_BALANCE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Account Balance
11	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
12	ITEM_TERM	Character(4)	VARCHAR2(4) NOT NULL	Item Term
13	LINE_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Line Amount
14	POSTED_DATE	Date(10)	DATE	Date Posted
15	DUE_DT	Date(10)	DATE	Due Date
16	DUE_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Due Amount
17	DUE_DATE_BY	Character(3)	VARCHAR2(3) NOT NULL	Due Date Enter By GNR=Generated by Billing GRP=Group Post Program QCK=Quick Post Program TUI=Tuition Calc Program
18	AGING_DT	Date(10)	DATE	Aging Date
19	BILLING_DT	Date(10)	DATE	Billing Date
20	ACTUAL_BILLING_DT	Date(10)	DATE	Actual Billing Date
21	ITEM_TYPE_CD	Character(1)	VARCHAR2(1) NOT NULL	Item Type Code A=Application Fee B=Billing Only C=Charge D=Deposit F=Financial Aid G=GL Interface Only H=Withholding I=Interest L=Pre-Paid Tuition P=Payment R=Refund T=Transfers V=Contributor Relations W=Waiver X=Write-off Z=Pay Plan Credit
22	BILL_REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Request ID
23	OVERR_BILL_REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Override Bill Request ID
24	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
25	DT_OF_DEATH	Date(10)	DATE	Date of Death