| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OL_WHERE_CLAUSE |
Character(50) |
VARCHAR2(50) NOT NULL |
Open Liability Where Clause.
|
| 3 |
OL_WHERE_CLAUSE1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Open Liability Where Clause 1.
|
| 4 |
OL_WHERE_CLAUSE2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Open Liability Where Clause 2.
|
| 5 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 6 |
WHERE_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 7 |
INSERT_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Insert Clause used for Inheritance.
|
| 8 |
INSERT_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Insert Clause used for Inheritance (where Inh GLBU <> Dist Line GLBU).
|
| 9 |
INSERT_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Insert Clause used for Draft Inheritance (where Inh GLBU = Dist Line GLBU and No Payment Method setup).
|
| 10 |
OL_FROM_TABLE |
Character(25) |
VARCHAR2(25) NOT NULL |
Open Liability From Table used dynamically.
|
| 11 |
OL_FROM_TABLE1 |
Character(25) |
VARCHAR2(25) NOT NULL |
Open Liability From Table used dynamically.
|
| 12 |
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. "
|
| 13 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 14 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 15 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 16 |
TEMP_NBR1 |
Number(7,0) |
INTEGER NOT NULL |
Temporary Number
|
| 17 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 18 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 19 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 20 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 21 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 22 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 23 |
APPLIED_AMT_PPAY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Applied to Prepayment
|