IPAC_TRANS_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
3	ALC	Character(8)	VARCHAR2(8) NOT NULL	Agency Location Code
4	CUSTOMER_ALC	Character(8)	VARCHAR2(8) NOT NULL	Customer Agency Location Code
5	IPAC_HDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	IPAC Header Sequence Number
6	IPAC_TRAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	IPAC Inbound Transaction Type A=IPAC Adjustment C=IPAC Payment D=AR Credit Journal I=AR Match Item J=AP Adjustment Voucher K=AR Outbound Item Match O=AP Outbound Adjustment P=IPAC Collection T=AR Outbound Adjustment V=AP Match Voucher W=AP Outbound Voucher Match
7	IPAC_DCM_RFR_NR	Character(8)	VARCHAR2(8) NOT NULL	Document Reference Number
8	IPAC_ORIG_TRN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	IPAC Inbound Transaction Type
9	IPAC_ORIG_DOC_REF	Character(8)	VARCHAR2(8) NOT NULL	Original Document Reference
10	IPAC_ORIG_ALC	Character(8)	VARCHAR2(8) NOT NULL	Originating Agency Location Code
11	IPAC_AMOUNT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	IPAC Amount
12	IPAC_HDR_LN_ITM	Number(6,0)	INTEGER NOT NULL	Count of Related Detail Lines