| # |
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
Default Value: 1
|
| 8 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 9 |
IPAC_RECORD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
IPAC Record Type
1=Adjustments
2=Collections
3=Payments
4=Zero Dollar
5=None
6=Post SGL
|
| 10 |
IPAC_SUBCATEGORY |
Character(2) |
VARCHAR2(2) NOT NULL |
IPAC Transaction Subcategory Code
A1=Buy/Sell
A2=Expenditure Non-Exch
A3=Custodial Exchange
A4=Custodial Non-Exch
A5=Capital
A6=Benefits
A7=Investments
A8=Borrowings
A9=Other
|
| 11 |
IPAC_PRCS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
IPAC Process Status
1=Not Processed
2=Processed
3=Do Not Process
Default Value: 1
|
| 12 |
ALC |
Character(8) |
VARCHAR2(8) NOT NULL |
Agency Location Code
Prompt Table:
AGENCY_LOC_CD
Set Control Field: BUSINESS_UNIT
|
| 13 |
IPAC_AMOUNT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
IPAC Amount
|
| 14 |
CUSTOMER_ALC |
Character(8) |
VARCHAR2(8) NOT NULL |
Customer Agency Location Code
Prompt Table:
AGENCY_LOC_CD
Set Control Field: BUSINESS_UNIT
|
| 15 |
IPAC_SENDER_DO |
Character(5) |
VARCHAR2(5) NOT NULL |
Sender Disbursing Office
|
| 16 |
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
|
| 17 |
IPAC_ORIG_DOC_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Original Document Reference
|
| 18 |
IPAC_ORIGINAL_DOS |
Character(5) |
VARCHAR2(5) NOT NULL |
Original Disbursing Office
|
| 19 |
IPAC_ORIG_ACC_DT |
Date(10) |
DATE |
Original Accomplished Date
|
| 20 |
IPAC_DCM_RFR_NR |
Character(8) |
VARCHAR2(8) NOT NULL |
Document Reference Number
|
| 21 |
IPAC_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
IPAC Source Transaction
1=Accounts Receivable
2=Accounts Payable
|
| 22 |
TREASURY_PMT_NBR |
Number(11,0) |
DECIMAL(11) NOT NULL |
Payment Confirm Number
|