| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
KK_SOURCE_TRAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Source Transaction Type
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
RECNAME_HEADER |
Character(15) |
VARCHAR2(15) NOT NULL |
Header Record
Prompt Table:
RECDEFN_VW
|
| 5 |
RECNAME_LINE |
Character(15) |
VARCHAR2(15) NOT NULL |
Line Record
Prompt Table:
RECDEFN_VW
|
| 6 |
RECNAME_UPD_HEADER |
Character(15) |
VARCHAR2(15) NOT NULL |
Update Header Record
Prompt Table:
RECDEFN_VW
|
| 7 |
RECNAME_UPD_LINE |
Character(15) |
VARCHAR2(15) NOT NULL |
Update Line Record
Prompt Table:
RECDEFN_VW
|
| 8 |
RECNAME_REFREC_KEY |
Character(15) |
VARCHAR2(15) NOT NULL |
Referenced Record Key Record
Prompt Table:
RECDEFN_VW
|
| 9 |
FIELDNAME_ORDER_BY |
Character(18) |
VARCHAR2(18) NOT NULL |
Order By Field Name
Prompt Table:
RECFIELD_HDR_VW
|
| 10 |
FIELDNAME_FRN_CUR |
Character(18) |
VARCHAR2(18) NOT NULL |
Foreign Currency
Prompt Table:
RECFIELD_LN_VW
|
| 11 |
FIELDNAME_FRN_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
Foreign Amount
Prompt Table:
RECFIELD_LN_VW
|
| 12 |
FIELDNAME_BASE_CUR |
Character(18) |
VARCHAR2(18) NOT NULL |
Base Currency
Prompt Table:
RECFIELD_LN_VW
|
| 13 |
FIELDNAME_MON_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
Monetary Amount
Prompt Table:
RECFIELD_LN_VW
|
| 14 |
FIELDNAME_STAT_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
Statistical Amount
Prompt Table:
RECFIELD_LN_VW
|
| 15 |
FIELDNAME_ACCTDATE |
Character(18) |
VARCHAR2(18) NOT NULL |
Accounting Date field name
Prompt Table:
RECFIELD_HDR_VW
|
| 16 |
FIELDNAME_BUDGDATE |
Character(18) |
VARCHAR2(18) NOT NULL |
Budget Date field name
Prompt Table:
RECFIELD_LN_VW
|
| 17 |
FIELDNAME_EFFDT |
Character(18) |
VARCHAR2(18) NOT NULL |
Effective Date Lookup
Prompt Table:
RECFIELD_LN_VW
|
| 18 |
FIELDNAME_BU_GL |
Character(18) |
VARCHAR2(18) NOT NULL |
Business Unit GL Field Name
Prompt Table:
RECFIELD_LN_VW
|
| 19 |
FIELDNAME_CLOSED |
Character(18) |
VARCHAR2(18) NOT NULL |
Closed Status field name
Prompt Table:
RECFIELD_LN_VW
|
| 20 |
FIELDNAME_QUANTITY |
Character(18) |
VARCHAR2(18) NOT NULL |
Quantity
|
| 21 |
CLOSED_VALUE |
Character(1) |
VARCHAR2(1) NOT NULL |
Closed Status field value
|
| 22 |
KK_SOURCE_TRAN_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Referenced Source Transaction
Prompt Table:
KK_SOURCE_TRAN
|
| 23 |
KK_AMOUNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic
Default Value: 1
|
| 24 |
CNTRL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control Option
0=Control
1=Tracking w/ Budget
2=Track w/o Budget
3=Default from Higher Level
4=Control Initial Document
Default Value: 3
|
| 25 |
OVERRIDE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Option
0=Allow Override
1=Do not Allow Override
2=Auto Override
Default Value: 0
|
| 26 |
KK_LOG_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Transaction Log
0=Update Log
1=Don't Update Log
Default Value: 0
|
| 27 |
RECNAME_SRC_TAO |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name
Prompt Table:
RECDFN_BPTAO_VW
|
| 28 |
RECNAME_SIBL |
Character(15) |
VARCHAR2(15) NOT NULL |
KK Source Header Record
Prompt Table:
RECDFN_SHDR_VW
|
| 29 |
KK_SKIP_EDITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Skip Budget Processor Edits
N=Re-edit valid lines
Y=Do not re-edit valid lines
Default Value: N
|
| 30 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 31 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|