| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
JOBINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|
| 5 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 6 |
STARTDATETIME |
DateTime(26) |
TIMESTAMP |
Start Datetime
|
| 7 |
ENDDATETIME |
DateTime(26) |
TIMESTAMP |
End Datetime
|
| 8 |
CURRENT_DATE1 |
Date(10) |
DATE |
12/20/01 EGS (CN#PL900-1): Added
10/07/02 JC (CN#PL880-1): Added FROM_DATE label
|
| 9 |
CURRENT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
08/07/02 EGS (CN#PL880-1): Added.
10/18/02 JC (CN#PL880-1):Added FROM label
1=Date
2=Offset
Default Value: 2
|
| 10 |
CURRENT_OFFSET |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
09/05/01 EGS (CN#PL900-1): Added.
10/07/02 JC (CN#PL880-1): Added FROM_OFFSET label
|
| 11 |
START_OFFSET |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Start Fence
Default Value: -30
|
| 12 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 13 |
END_OFFSET |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
End Fence
Default Value: 365
|
| 14 |
END_DT |
Date(10) |
DATE |
End Date
|
| 15 |
APS_HIST_OFFSET |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
History Start Offset
|
| 16 |
HIST_START_DT |
Date(10) |
DATE |
Historical Start Date
|
| 17 |
CUSTOMER_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer SetID
|
| 18 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 19 |
ITM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Item SetID
Prompt Table:
SP_SETID_NONVW
|
| 20 |
INCL_QUOTES |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit
Default Value: N
|
| 21 |
QUOTE_PERCENT |
Number(3,0) |
SMALLINT NOT NULL |
Quote Percentage
|
| 22 |
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. "
Prompt Table:
APS_BASE_CUR_VW
|
| 23 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table:
APS_RT_TYPE_VW
|
| 24 |
APS_CONSTRAIN_ITM |
Number(5,0) |
INTEGER NOT NULL |
Constrained Item Fence
|
| 25 |
APS_FIXED_PROD_FNC |
Number(5,0) |
INTEGER NOT NULL |
Constrained Item Fence
|
| 26 |
APS_ITM_GRP_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Item Group Option
0001=Item Family
0002=Item Group
|
| 27 |
EARLY_FENCE |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Early Fence
|
| 28 |
LATE_FENCE |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Late Fence
Default Value: 365
|
| 29 |
CAP_FENCE_OFF |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Capacity Fence
Default Value: 365
|
| 30 |
APS_BASE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
APS Integration Flag
Y/N Table Edit
Default Value: Y
|
| 31 |
APS_BEGINV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
APS Integration Flag
Y/N Table Edit
Default Value: Y
|
| 32 |
APS_CALENDAR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
APS Integration Flag
Y/N Table Edit
Default Value: Y
|
| 33 |
APS_CONFIG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
APS Integration Flag
Y/N Table Edit
Default Value: Y
|
| 34 |
APS_CUSTOMER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
APS Integration Flag
Y/N Table Edit
Default Value: Y
|
| 35 |
APS_DISTRIB_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
APS Integration Flag
Y/N Table Edit
Default Value: Y
|
| 36 |
APS_FORECAST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
APS Integration Flag
Y/N Table Edit
Default Value: Y
|
| 37 |
APS_MFG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
APS Integration Flag
Y/N Table Edit
Default Value: Y
|
| 38 |
APS_PURCHASE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
APS Integration Flag
Y/N Table Edit
Default Value: Y
|
| 39 |
APS_SAFETY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
APS Integration Flag
Y/N Table Edit
Default Value: Y
|
| 40 |
APS_SALESORD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
APS Integration Flag
Y/N Table Edit
Default Value: Y
|
| 41 |
APS_SALESORDH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
APS Integration Flag
Y/N Table Edit
Default Value: Y
|
| 42 |
APS_SUPPLIER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
APS Integration Flag
Y/N Table Edit
Default Value: Y
|
| 43 |
APS_TRANSFER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
APS Integration Flag
Y/N Table Edit
Default Value: Y
|
| 44 |
APS_WORKORD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
APS Integration Flag
Y/N Table Edit
Default Value: Y
|
| 45 |
APS_EXPORT_DIR |
Character(254) |
VARCHAR2(254) NOT NULL |
Export Directory
|
| 46 |
APS_RVRS_QRTN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reversing Qurantine
Y/N Table Edit
Default Value: N
|
| 47 |
SPL_FREEZE_PEGGED |
Character(1) |
VARCHAR2(1) NOT NULL |
11/02/2004 NRA: Added
Y/N Table Edit
Default Value: Y
|
| 48 |
MULTI_PROC |
Character(1) |
VARCHAR2(1) NOT NULL |
06/11/02 EGS (CN#PL900-1): Added.
|
| 49 |
MAX_ROW |
Number(9,0) |
DECIMAL(9) NOT NULL |
Max Number of Rows
|
| 50 |
SPL_KEY_SEPARATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Key Field Seperator
Default Value: \
|
| 51 |
APS_EXPORT_DIRFILE |
Character(254) |
VARCHAR2(254) NOT NULL |
Export Directory
|
| 52 |
MESSAGE_PARM |
Character(254) |
VARCHAR2(254) NOT NULL |
Message Parameter Text
|
| 53 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 54 |
EXPORT_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Export Record Count
|
| 55 |
COUNTER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
|
| 56 |
COUNTER1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Counter 1
|
| 57 |
APS_HORIZON_DT |
Date(10) |
DATE |
End Date
|