| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPERATOR_VW
|
| 2 |
INQUIRY |
Character(10) |
VARCHAR2(10) NOT NULL |
Inquiry Name
|
| 3 |
KK_SOURCE_TRAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Source Transaction Type
Prompt Table:
KK_SRC_TRAN_VW2
|
| 4 |
DESCR40 |
Character(40) |
VARCHAR2(40) NOT NULL |
Description
|
| 5 |
KK_TRAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Commitment Control Foreign Key for Transaction Identification.
Prompt Table:
KK_TRAN_ID_VW4
|
| 6 |
KK_TRAN_DT |
Date(10) |
DATE |
Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.
|
| 7 |
KK_PROC_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
Prompt Table:
KK_PROC_INS_VW1
|
| 8 |
KK_PROCESS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Status
E=Errors Exist
I=Document in process
N=Process Unsuccessful
P=Provisionally Valid
V=No Errors or Warnings
W=Only Warnings Exist
X=Unrecorded Errors Exist
|
| 9 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table:
SP_LGRPKK_VW1
|
| 10 |
BUSINESS_UNIT_APPL |
Character(5) |
VARCHAR2(5) NOT NULL |
Application Business Unit
used in KK
Prompt Table:
SP_BU_FS_NONVW
|
| 11 |
FROM_ID_DATE |
Date(10) |
DATE |
An accounting template field designated to support the substitution of desired dates during accounting b
|
| 12 |
TO_ID_DATE |
Date(10) |
DATE |
An accounting template field designated to support the substitution of desired dates during accounting b
|
| 13 |
FROM_ID_CHAR40 |
Character(40) |
VARCHAR2(40) NOT NULL |
40 characters field value
Prompt Table:
%EDITTABLE10
|
| 14 |
TO_ID_CHAR40 |
Character(40) |
VARCHAR2(40) NOT NULL |
40 characters field value
Prompt Table:
%EDITTABLE10
|
| 15 |
FROM_ID_NBR10 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Field Value: 10 digits Number (no decimal)
Prompt Table:
%EDITTABLE10
|
| 16 |
TO_ID_NBR10 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Field Value: 10 digits Number (no decimal)
Prompt Table:
%EDITTABLE10
|
| 17 |
FROM_ID_DTSMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
|
| 18 |
TO_ID_DTSMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
|
| 19 |
FROM_2NDKEY_DATE |
Date(10) |
DATE |
An accounting template field designated to support the substitution of desired dates during accounting b
|
| 20 |
TO_2NDKEY_DATE |
Date(10) |
DATE |
An accounting template field designated to support the substitution of desired dates during accounting b
|
| 21 |
FROM_2NDKEY_CHAR40 |
Character(40) |
VARCHAR2(40) NOT NULL |
40 characters field value
Prompt Table:
%EDITTABLE11
|
| 22 |
TO_2NDKEY_CHAR40 |
Character(40) |
VARCHAR2(40) NOT NULL |
40 characters field value
Prompt Table:
%EDITTABLE11
|
| 23 |
FROM_2NDKEY_NBR10 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Field Value: 10 digits Number (no decimal)
Prompt Table:
%EDITTABLE11
|
| 24 |
TO_2NDKEY_NBR10 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Field Value: 10 digits Number (no decimal)
Prompt Table:
%EDITTABLE11
|
| 25 |
FROM_2NDKEY_DTSMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
|
| 26 |
TO_2NDKEY_DTSMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
|