AR_IPAC_SGL_H

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