IPAC_DETAIL_STG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
2	ALC	Character(8)	VARCHAR2(8) NOT NULL	Agency Location Code
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_ACL_CD	Character(16)	VARCHAR2(16) NOT NULL	IPAC Accounting Classification
6	IPAC_ACRN	Character(12)	VARCHAR2(12) NOT NULL	Account Classification Refrnce
7	IPAC_LN_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Line Amount
8	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty.
9	PHONE_NUM	Character(12)	VARCHAR2(12) NOT NULL	Phone Number
10	IPAC_CONTACT_NAME	Character(60)	VARCHAR2(60) NOT NULL	IPAC Header Contact Name
11	IPAC_PHONE_NUM	Character(17)	VARCHAR2(17) NOT NULL	Phone Number
12	IPAC_CLIN	Character(6)	VARCHAR2(6) NOT NULL	Contract Line Number
13	IPAC_CNTRCT_NUM	Character(17)	VARCHAR2(17) NOT NULL	Contract Number
14	IPAC_RECVR_DEPT	Character(2)	VARCHAR2(2) NOT NULL	Receiver Department
15	IPAC_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Description
16	IPAC_DESCR_X66	Character(66)	VARCHAR2(66) NOT NULL	IPAC Description - Extra 66 ch
17	IPAC_XREF_DOC	Character(8)	VARCHAR2(8) NOT NULL	Cross Reference Document
18	IPAC_FSN	Number(8,0)	INTEGER NOT NULL	Fiscal Station Number
19	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
20	INVOICE_DT	Date(10)	DATE	Invoice Date
21	IPAC_JAS_NUM	Character(30)	VARCHAR2(30) NOT NULL	JAS number
22	IPAC_JOB_NUM	Character(20)	VARCHAR2(20) NOT NULL	IPAC Job Number
23	IPAC_MISC_DESCR	Character(254)	VARCHAR2(254) NOT NULL	IPAC Miscellaneous Description
24	IPAC_MISCDESCR_X66	Character(66)	VARCHAR2(66) NOT NULL	IPAC Miscellaneous - Extra 66
25	IPAC_OBL_DOC_NBR	Character(17)	VARCHAR2(17) NOT NULL	Obligation Document Number
26	IPAC_PAY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	IPAC Pay Flag 1=Partial 2=Final F=Final P=Partial Default Value: P
27	IPAC_PO_ID	Character(22)	VARCHAR2(22) NOT NULL	IPAC Purchase Order
28	IPAC_QUANTITY	Signed Number(18,4)	DECIMAL(16,4) NOT NULL	IPAC Quantity
29	IPAC_RECVR_TAS	Character(27)	VARCHAR2(27) NOT NULL	Receiver Treasury Account Symb Prompt Table: %EDITTABLE17
30	IPAC_REQ_ID	Character(22)	VARCHAR2(22) NOT NULL	IPAC Requisition
31	IPAC_SENDER_TAS	Character(27)	VARCHAR2(27) NOT NULL	Sender Treasury Account Symbol
32	IPAC_TRACE_NUM	Character(15)	VARCHAR2(15) NOT NULL	IPAC Trace ID
33	UNIT_OF_ISSUE	Character(2)	VARCHAR2(2) NOT NULL	Unit of Issue
34	IPAC_UNIT_PRICE	Signed Number(26,5)	DECIMAL(24,5) NOT NULL	IPAC Unit Price
35	IPAC_DODAC	Character(15)	VARCHAR2(15) NOT NULL	DoD Activity Address Code
36	IPAC_ORIG_LN_ITM	Number(6,0)	INTEGER NOT NULL	Original Line Item Number
37	IPAC_FY_OBLIG_ID	Character(1)	VARCHAR2(1) NOT NULL	Fiscal Year Obligation ID C=Current Fiscal Year N=Not Applicable P=Prior Fiscal Year Default Value: N
38	IPAC_RECVR_BETC	Character(8)	VARCHAR2(8) NOT NULL	Receiver Business Event Type Prompt Table: %EDITTABLE16
39	IPAC_RECVR_DUNS	Character(9)	VARCHAR2(9) NOT NULL	Receiver DUNS
40	IPAC_RECVR_DUNS4	Character(4)	VARCHAR2(4) NOT NULL	Receiver DUNS Plus 4
41	IPAC_SENDER_BETC	Character(8)	VARCHAR2(8) NOT NULL	Sender Business Event Type Prompt Table: %EDITTABLE15
42	IPAC_SENDER_DUNS	Character(9)	VARCHAR2(9) NOT NULL	Sender DUNS
43	IPAC_SENDER_DUNS4	Character(4)	VARCHAR2(4) NOT NULL	Sender Duns Plus 4
44	IPAC_S_SGL_CMNT	Character(254)	VARCHAR2(254) NOT NULL	IPAC Sender SGL Comment
45	IPAC_R_SGL_CMNT	Character(254)	VARCHAR2(254) NOT NULL	IPAC Receiver SGL Comment
46	IPAC_VCHR_NUM	Character(10)	VARCHAR2(10) NOT NULL	IPAC Voucher Number
47	IPAC_EMAIL_ADDR	Character(254)	VARCHAR2(254) NOT NULL	IPAC Email Address