NET_ROUND_AET

(SQL Table)
Index Back

Netting Rounding State record

Netting Rounding State record

# 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