AR_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	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
3	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.
4	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
5	IPAC_HDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	IPAC Header Sequence Number
6	IPAC_DTL_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	IPAC Detail Sequence Number
7	IPAC_SGL_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	IPAC SGL Sequence Number Default Value: 1
8	IPAC_SGL_ACCOUNT	Number(4,0)	SMALLINT NOT NULL	IPAC SGL Account Number
9	IPAC_CR_DR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	IPAC Debit/Credit 1=Credit 2=Debit
10	IPAC_SGL_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	IPAC SGL Amount
11	IPAC_SGL_ACTION	Character(1)	VARCHAR2(1) NOT NULL	SGL Action A=Add SGL Line E=Edit SGL Line Default Value: A
12	IPAC_SGL_SR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Sender/Receiver Flag R=Receiver SGL S=Sender SGL Default Value: S
13	IPAC_SGL_FED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Federal Flag F=Federal N=Non-Federal Default Value: F