AP_IPAC_SGL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUS_AP_NONVW
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
3	IPAC_HDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	IPAC Header Sequence Number
4	IPAC_DTL_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	IPAC Detail Sequence Number
5	IPAC_SGL_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	IPAC SGL Sequence Number Default Value: 1
6	IPAC_SGL_ACCOUNT	Number(4,0)	SMALLINT NOT NULL	IPAC SGL Account Number
7	IPAC_CR_DR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	IPAC Debit/Credit 1=Credit 2=Debit
8	IPAC_SGL_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	IPAC SGL Amount
9	IPAC_SGL_ACTION	Character(1)	VARCHAR2(1) NOT NULL	SGL Action A=Add SGL Line E=Edit SGL Line Default Value: A
10	IPAC_SGL_SR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Sender/Receiver Flag R=Receiver SGL S=Sender SGL Default Value: S
11	IPAC_SGL_FED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Federal Flag F=Federal N=Non-Federal Default Value: F