# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
2 |
NET_REF_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
A reference identifier associated with a cash transaction subject to netting with a given bank/count
|
3 |
NETTING_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Netting Currency
|
4 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
5 |
NET_BAL_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Netting Balance Amount Base
|
6 |
SUM_AR_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
AR Base Amount
|
7 |
ADJ_AR_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Adjusted AR Base
|
8 |
REAL_GAIN_LOSS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the monetary amount of realized gain or loss calculated by the system during payment application or maintenance worksheet (Receivables).
|
9 |
FIRST_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
First time through process
|
10 |
DEPOSIT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
|
11 |
PAYMENT_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
|
12 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
13 |
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.
|
14 |
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.
|
15 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
|
16 |
AR_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
A number that is assigned to draft items to ensure uniqueness of key
|
17 |
UPD_AR_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Updated AR Amount
|
18 |
UPD_AP_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Updated AP Amount
|
19 |
SUM_AP_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
AP Base Amount
|
20 |
ADJ_AP_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Adjusted AP Base
|
21 |
UPD_AP_GRS_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Updated AP Gross Amount
|
22 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
23 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
24 |
GROSS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Amount
|
25 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
26 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
27 |
ITM_PAY_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
23.3 position signed numeric value. Identifies the item payment amount in the payment's base currency.
|
28 |
DEPOSIT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
|
29 |
PAY_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Amt - Base Curr
|