| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 4 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 6 |
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.
|
| 7 |
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
|
| 8 |
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
|