AP_IPAC_WB_HDR (SQL View)	Index Back
Inbound IPAC HDR Stage Inbound IPAC header staging record. This record will be populated by AP_INIPAC application engine process

AP_IPAC_WB_HDR

(SQL View)

Inbound IPAC HDR Stage

Inbound IPAC header staging record. This record will be populated by AP_INIPAC application engine process

SELECT A.FILENAME ,A.ALC ,A.IPAC_HDR_SEQ_NUM ,A.IPAC_CONTACT_NAME ,A.IPAC_PHONE_NUM ,A.IPAC_STAGE_DATE ,A.IPAC_STAGE_STATUS ,A.IPAC_AMOUNT ,'USD' ,A.CUSTOMER_ALC ,A.IPAC_SENDER_DO ,A.IPAC_TRN_SET ,A.IPAC_ORIG_DOC_REF ,A.IPAC_ORIGINAL_DOS ,A.IPAC_ORIG_ACC_DT ,A.IPAC_DCM_RFR_NR ,A.IPAC_HDR_LN_ITM ,A.IPAC_ORIG_ACCTG_DT ,A.IPAC_TRAN_TYPE ,A.IPAC_ACCTG_DT ,A.IPAC_ACCOMPLISH_DT ,A.IPAC_ORIG_ALC ,A.IPAC_TRANS_ID ,A.IPAC_ORIG_TRN_TYPE ,A.BUSINESS_UNIT_AP ,A.VOUCHER_ID ,A.BUSINESS_UNIT_AR ,A.ITEM ,A.ACCOUNT ,A.COMMENTS_254 ,A.COMMENTS60 ,A.IPAC_EMAIL_ADDR ,A.IPAC_TRAN_STATUS , ( SELECT COUNT(B.IPAC_DTL_SEQ_NUM) FROM PS_IPAC_DETAIL_STG B WHERE A.FILENAME = B.FILENAME AND A.ALC = B.ALC AND A.IPAC_HDR_SEQ_NUM = B.IPAC_HDR_SEQ_NUM) FROM PS_IPAC_HDR_STG A

# 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_CONTACT_NAME Character(60) VARCHAR2(60) NOT NULL IPAC Header Contact Name

5 IPAC_PHONE_NUM Character(17) VARCHAR2(17) NOT NULL Phone Number

6 IPAC_STAGE_DATE Date(10) DATE Inbound IPAC Staged date for Hdr, detail, sgl

7 IPAC_STAGE_STATUS Character(1) VARCHAR2(1) NOT NULL Inbound IPAC staging status xlat
1=Staged
2=Selected
3=Error
Default Value: 1

8 IPAC_AMOUNT Signed Number(18,2) DECIMAL(16,2) NOT NULL IPAC Amount

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

10 CUSTOMER_ALC Character(8) VARCHAR2(8) NOT NULL Customer Agency Location Code

11 IPAC_SENDER_DO Character(5) VARCHAR2(5) NOT NULL Sender Disbursing Office

12 IPAC_TRN_SET Character(3) VARCHAR2(3) NOT NULL Transaction Set ID
810=For a Collection
812=For an Adjustment
820=For a Payment
835=For a Zero Dollar
840=For a Post SGL

13 IPAC_ORIG_DOC_REF Character(8) VARCHAR2(8) NOT NULL Original Document Reference

14 IPAC_ORIGINAL_DOS Character(5) VARCHAR2(5) NOT NULL Original Disbursing Office

15 IPAC_ORIG_ACC_DT Date(10) DATE Original Accomplished Date

16 IPAC_DCM_RFR_NR Character(8) VARCHAR2(8) NOT NULL Document Reference Number

17 IPAC_HDR_LN_ITM Number(6,0) INTEGER NOT NULL Count of Related Detail Lines

18 IPAC_ORIG_ACCTG_DT Date(10) DATE IPAC Accounting Date

19 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

20 IPAC_ACCTG_DT Date(10) DATE IPAC Accounting Date

21 IPAC_ACCOMPLISH_DT Date(10) DATE Accomplish Date

22 IPAC_ORIG_ALC Character(8) VARCHAR2(8) NOT NULL Originating Agency Location Code

23 IPAC_TRANS_ID Character(18) VARCHAR2(18) NOT NULL IPAC Transaction Id - Bulk Fmt

24 IPAC_ORIG_TRN_TYPE Character(1) VARCHAR2(1) NOT NULL IPAC Inbound Transaction Type

25 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
Prompt Table: SP_BU_AP_NONVW

26 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
Prompt Table: AP_IPAC_VCHR_VW

27 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit

28 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.

29 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

30 COMMENTS_254 Character(254) VARCHAR2(254) NOT NULL EDI Comments

31 COMMENTS60 Character(60) VARCHAR2(60) NOT NULL Comments

32 IPAC_EMAIL_ADDR Character(254) VARCHAR2(254) NOT NULL IPAC Email Address

33 IPAC_TRAN_STATUS Character(2) VARCHAR2(2) NOT NULL IPAC Transaction Status
1=AP In Process
10=AP Review
11=AR Review
12=AP Do Not Process
13=AR Do Not Process
2=AR In Process
3=Manager Error
4=AP Error
5=AR Error
6=AP Ready
7=AR Ready
8=AP Processed
9=AR Processed

34 IPAC_NUM_DTL_LINES Number(3,0) SMALLINT NOT NULL Number of Detail Lines

#	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_CONTACT_NAME	Character(60)	VARCHAR2(60) NOT NULL	IPAC Header Contact Name
5	IPAC_PHONE_NUM	Character(17)	VARCHAR2(17) NOT NULL	Phone Number
6	IPAC_STAGE_DATE	Date(10)	DATE	Inbound IPAC Staged date for Hdr, detail, sgl
7	IPAC_STAGE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Inbound IPAC staging status xlat 1=Staged 2=Selected 3=Error Default Value: 1
8	IPAC_AMOUNT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	IPAC Amount
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	CUSTOMER_ALC	Character(8)	VARCHAR2(8) NOT NULL	Customer Agency Location Code
11	IPAC_SENDER_DO	Character(5)	VARCHAR2(5) NOT NULL	Sender Disbursing Office
12	IPAC_TRN_SET	Character(3)	VARCHAR2(3) NOT NULL	Transaction Set ID 810=For a Collection 812=For an Adjustment 820=For a Payment 835=For a Zero Dollar 840=For a Post SGL
13	IPAC_ORIG_DOC_REF	Character(8)	VARCHAR2(8) NOT NULL	Original Document Reference
14	IPAC_ORIGINAL_DOS	Character(5)	VARCHAR2(5) NOT NULL	Original Disbursing Office
15	IPAC_ORIG_ACC_DT	Date(10)	DATE	Original Accomplished Date
16	IPAC_DCM_RFR_NR	Character(8)	VARCHAR2(8) NOT NULL	Document Reference Number
17	IPAC_HDR_LN_ITM	Number(6,0)	INTEGER NOT NULL	Count of Related Detail Lines
18	IPAC_ORIG_ACCTG_DT	Date(10)	DATE	IPAC Accounting Date
19	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
20	IPAC_ACCTG_DT	Date(10)	DATE	IPAC Accounting Date
21	IPAC_ACCOMPLISH_DT	Date(10)	DATE	Accomplish Date
22	IPAC_ORIG_ALC	Character(8)	VARCHAR2(8) NOT NULL	Originating Agency Location Code
23	IPAC_TRANS_ID	Character(18)	VARCHAR2(18) NOT NULL	IPAC Transaction Id - Bulk Fmt
24	IPAC_ORIG_TRN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	IPAC Inbound Transaction Type
25	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit Prompt Table: SP_BU_AP_NONVW
26	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID Prompt Table: AP_IPAC_VCHR_VW
27	BUSINESS_UNIT_AR	Character(5)	VARCHAR2(5) NOT NULL	AR Business Unit
28	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.
29	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
30	COMMENTS_254	Character(254)	VARCHAR2(254) NOT NULL	EDI Comments
31	COMMENTS60	Character(60)	VARCHAR2(60) NOT NULL	Comments
32	IPAC_EMAIL_ADDR	Character(254)	VARCHAR2(254) NOT NULL	IPAC Email Address
33	IPAC_TRAN_STATUS	Character(2)	VARCHAR2(2) NOT NULL	IPAC Transaction Status 1=AP In Process 10=AP Review 11=AR Review 12=AP Do Not Process 13=AR Do Not Process 2=AR In Process 3=Manager Error 4=AP Error 5=AR Error 6=AP Ready 7=AR Ready 8=AP Processed 9=AR Processed
34	IPAC_NUM_DTL_LINES	Number(3,0)	SMALLINT NOT NULL	Number of Detail Lines