| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
CF_VALUE |
Character(18) |
VARCHAR2(18) NOT NULL |
ChartField Value
|
| 3 |
CF_VALUE1 |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value 1
|
| 4 |
CF_VALUE2 |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value 2
|
| 5 |
CF_VALUE3 |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value 3
|
| 6 |
CF_VALUE4 |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value 4
|
| 7 |
CF_VALUE5 |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value 5
|
| 8 |
CF_VALUE6 |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value 6
|
| 9 |
CF_VALUE7 |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value 7
|
| 10 |
CF_VALUE8 |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value 8
|
| 11 |
CF_VALUE9 |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value 9
|
| 12 |
CF_VALUE10 |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value 10
|
| 13 |
CF_VALUE11 |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value 11
|
| 14 |
CF_VALUE12 |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value 12
|
| 15 |
CF_VALUE13 |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value 13
|
| 16 |
CF_VALUE14 |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value 14
|
| 17 |
CF_VALUE15 |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value 15
|
| 18 |
CF_VALUE16 |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value 16
|
| 19 |
CF_VALUE17 |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value 17
|
| 20 |
CF_VALUE18 |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value 18
|
| 21 |
CF_VALUE19 |
Character(30) |
VARCHAR2(30) NOT NULL |
ChartField Value 19
|
| 22 |
POSTED_BASE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the net balance of debit and credit amounts that have been posted to a particular ChartField combination, in the base currency of the business unit. Unless the Separate Debit/Credit option is set up, the ledger stores net amounts only.
|
| 23 |
POSTED_TOTAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the net balance of debit and credit amounts that have been posted to a particular ChartField combination.
|
| 24 |
POSTED_TOTAL_CR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Posted Total Credits
|
| 25 |
POSTED_TOTAL_DR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Posted Total Debits
|
| 26 |
POSTED_TRAN_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Posted Transaction Amount
|
| 27 |
POSTED_TRAN_DR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Debit Amount
|
| 28 |
POSTED_TRAN_CR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Credit Amount
|
| 29 |
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. "
|