| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
Default Value: N
|
| 6 |
PROCESS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
Default Value: N
|
| 7 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 8 |
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:
CURRENCY_CD_TBL
|
| 9 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
Default Value: PRCSRUNCNTL.LANGUAGE_CD
|
| 10 |
RPT_DEST |
Character(50) |
VARCHAR2(50) NOT NULL |
File Destination
|
| 11 |
PROCESS_NAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
|
| 12 |
PRINT_PROCESS_INST |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
Prompt Table:
CM_EOM_HDR_TBL
|
| 13 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
Prompt Table:
CM_EOM_HDR_TBL
|
| 14 |
CM_ZERO_TRN_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Zero Transaction
Y/N Table Edit
Default Value: N
|
| 15 |
CM_PERCNT_TOL |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Tolerance
|
| 16 |
CM_OH_RPT_OPT |
Character(3) |
VARCHAR2(3) NOT NULL |
Onhand Report Options
PDS=Print, Don't Store Snapshot
PPS=Print Stored Snapshot
PSS=Purge Stored Snapshot
SSD=Don't Print, Store Snapshot
SSP=Print, Store Snapshot
|
| 17 |
CM_ACCT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Option
A=All Accounts
S=Select Accounts
Default Value: A
|
| 18 |
CM_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 19 |
CM_RECON_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Reconcilliation Option
A=Report All Items
O=Report Discrepant Items Only
P=Reprint Report
R=Generate Reconcilliations
Default Value: O
|
| 20 |
CM_REPRINT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Created 8/12/00 WHS - Report Reprint option
N=No
Y=Yes
Default Value: N
|
| 21 |
CM_SORT_OPTION_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
08/13/1999 whs CN#CM800-17.0: New XLAT value 8 = sort by Alternate Account/Item ID
1=Item ID
2=Cost Profile Group / Item ID
3=Storage Area / Item ID
4=Item ID / Storage Area
5=Account / Item ID
6=Item Group / Item ID
7=Product Family Code / Item ID
8=Alternate Account/Item ID
Default Value: 1
|
| 22 |
CM_EOM_SRT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort option for report
B=Item
T=Tolerance
Default Value: B
|
| 23 |
CM_EOM_LVL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Option
A=Account Level
I=Item Level
Default Value: I
|
| 24 |
DET_SUM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Detail or Summary
D=Detail
S=Summary
Default Value: S
|
| 25 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 26 |
SYSTEM_DATE |
Date(10) |
DATE |
System Date
Default Value: %date
|
| 27 |
CM_SYSTEM_TM_STAMP |
DateTime(26) |
TIMESTAMP |
System Timestamp
Default Value: %DateTime
|
| 28 |
TRANSACTION_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Type Option
A=All
S=Single
Default Value: A
|
| 29 |
TRANSACTION_GROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
|
| 30 |
CM_CONSIGNOPT_XLAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Created on 06/30/99 RML CM800-4.0 Print option consigned items - include, exclude, or only.
E=Exclude Consigned Inventory
I=Include Consigned Inventory
O=Consigned Inventory Only
Default Value: E
|
| 31 |
CM_INTRANS_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrans Option
E=Exclude Instranit Inventory
I=Include Intransit Inventory
O=Only Intransit Inventory
|
| 32 |
CM_PRODUCTION_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Include production option
E=Exclude Production Inventory
I=Include Production Inventory
O=Only Production Inventory
|
| 33 |
CM_COST_ELEMENT_RB |
Character(1) |
VARCHAR2(1) NOT NULL |
Created on 06/30/99 RML Used in run control panel for Inventory On Hand reports - show Cost Element and Cost Category
C=Cost Category
E=Cost Element
Default Value: C
|
| 34 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 35 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
|
| 36 |
ONHAND_QTY_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
03/25/03 ST- Created field for run_cms2010
Y/N Table Edit
|
| 37 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 38 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 39 |
CM_ITEM_RANGE_OPT |
Character(3) |
VARCHAR2(3) NOT NULL |
04/07/1999 RML CM800-9.0 Created new field instead of using ITEM_OPTION because of wording - Specific vs. Range
A=All Items
G=Item Group
R=Item Range
Default Value: A
|
| 40 |
FROM_ITEMID |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label ITEM_ID
Prompt Table:
%EDITTABLE
|
| 41 |
TO_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label ITEM_ID
Prompt Table:
%EDITTABLE
|
| 42 |
INV_ITEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Group
Prompt Table:
INV_ITEM_GROUP
|
| 43 |
INV_PROD_FAM_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Family
Prompt Table:
INV_ITEM_FAM
|
| 44 |
CM_PURGE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Purge Okay Flag
N=Doesn't Qualify for Purging
Y=Qualifies for Purging
|
| 45 |
TOLERANCE_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Created for Landed Cost Reports - CMS3000, CMS3010, CMS3020 - KDN 10/20/99
|
| 46 |
TOLERANCE_PCT_S |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Created for Cost reconciliation AE
|
| 47 |
CM_THRESHOLD |
Signed Number(20,3) |
DECIMAL(18,3) NOT NULL |
Threshold
|