| # |
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 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 4 |
RPT_DEST |
Character(50) |
VARCHAR2(50) NOT NULL |
File Destination
|
| 5 |
PROCESS_BEGIN |
Number(10,0) |
DECIMAL(10) NOT NULL |
Begin Process Instance
|
| 6 |
PROCESS_END |
Number(10,0) |
DECIMAL(10) NOT NULL |
End Process Instance
|
| 7 |
PROCESS_NAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
|
| 8 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
Prompt Table:
%EDITTABLE10
|
| 9 |
JOBID |
Character(10) |
VARCHAR2(10) NOT NULL |
Job ID
|
| 10 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
Default Value: %date
|
| 11 |
BUS_UNIT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit Option
A=All
S=Specific
Default Value: S
|
| 12 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUIN_NONVW
|
| 13 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
Prompt Table:
SP_BU_PM_NONVW
|
| 14 |
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
|
| 15 |
CM_BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Cost Book
Prompt Table:
CM_BU_BOOK_TBL
|
| 16 |
CM_BOOK_OPTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Book Option
A=All
S=Specific
Default Value: A
|
| 17 |
CM_BOOK_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
06/30/99 RML Changed Long Name
A=Active
C=Cancel
I=Inactive
P=Pending
S=Stopped
|
| 18 |
CM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
Prompt Table:
CM_GROUP_DEFN
|
| 19 |
CM_GROUP_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Created on 03/08/99 by RML for CM800-9.0 LIFO/FIFO Enhancements
A=All
N=None
S=Specific
Default Value: A
|
| 20 |
CM_PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
Prompt Table:
CM_PROFILE_DEFN
|
| 21 |
CM_PROFILE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Profile Option
A=All
S=Specific
Default Value: A
|
| 22 |
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
|
| 23 |
CM_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 24 |
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
|
| 25 |
CM_REPRINT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Created 8/12/00 WHS - Report Reprint option
N=No
Y=Yes
Default Value: N
|
| 26 |
CM_SORT_OPT_PROFLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Created on 03/10/99 CM800-9.0 RML
1=Item ID
2=Cost Profile Group / Item ID
Default Value: 1
|
| 27 |
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
|
| 28 |
DET_SUM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Detail or Summary
D=Detail
S=Summary
Default Value: S
|
| 29 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 30 |
FROM_ITEMID |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label ITEM_ID
Prompt Table:
%EDITTABLE
|
| 31 |
TO_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label ITEM_ID
Prompt Table:
%EDITTABLE
|
| 32 |
TRANSACTION_DATE |
Date(10) |
DATE |
Transaction Date
Default Value: %date
|
| 33 |
TRANSACTION_DTTM |
DateTime(26) |
TIMESTAMP |
Transaction Date-Time
|
| 34 |
SYSTEM_DATE |
Date(10) |
DATE |
System Date
Default Value: %date
|
| 35 |
CM_SYSTEM_TM_STAMP |
DateTime(26) |
TIMESTAMP |
System Timestamp
Default Value: %DateTime
|
| 36 |
TRANSACTION_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Type Option
A=All
S=Single
Default Value: A
|
| 37 |
TRANSACTION_GROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
|
| 38 |
INV_ITEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Group
Prompt Table:
INV_ITEM_GROUP
|
| 39 |
INV_PROD_FAM_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Family
Prompt Table:
INV_ITEM_FAM
|
| 40 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table:
STOR_ACCT_VW
|
| 41 |
CM_FROM_TRANS_DT |
Date(10) |
DATE |
From Transaction Date
Default Value: %date
|
| 42 |
CM_FROM_TRANS_DTTM |
DateTime(26) |
TIMESTAMP |
Created on 06/08/99 RML CM800-9.0 Used in SQR reports
|
| 43 |
CM_TO_TRANS_DATE |
Date(10) |
DATE |
To Transaction Date
Default Value: %date
|
| 44 |
CM_TO_TRANS_DTTM |
DateTime(26) |
TIMESTAMP |
Created on 05/18/99 RML for CM800-9.0 LIFO/FIFO Enhancement
|
| 45 |
CM_FROM_SYSTEM_DT |
Date(10) |
DATE |
Created on 05/14/99 RML Used in movement reports for LIFO/FIFO enhancement
Default Value: %date
|
| 46 |
CM_TO_SYSTEM_DATE |
Date(10) |
DATE |
Created on 05/14/99 RML Used in movement reports for LIFO/FIFO enhancement
Default Value: %date
|
| 47 |
CM_FROM_SYS_DTTM |
DateTime(26) |
TIMESTAMP |
System Date Timestamp
|
| 48 |
CM_TO_SYS_DTTM |
DateTime(26) |
TIMESTAMP |
System Date Timestamp
|
| 49 |
CM_RECEIPT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Created on 05/18/99 RML for CM800-9.0 LIFO/FIFO Enhancement - Movement by Receipt Line report; used on panel run_cms2015
A=All
S=Specific
Default Value: A
|
| 50 |
RECEIVER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receiver number
Prompt Table:
CM_TRANS_INV_VW
|
| 51 |
RECV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Receipt Line
Prompt Table:
CM_RECV_LN_VW
|
| 52 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 53 |
CM_COMPARE_RB |
Character(1) |
VARCHAR2(1) NOT NULL |
Created on 05/27/99 RML CM800-9.0 Variable used in RUN_CNTL_CM for On Hand Report (CMS2010)
0=None
1=Floor and Ceiling
2=Last Price Used
Default Value: 0
|
| 54 |
CM_COST_OPT_RB |
Character(1) |
VARCHAR2(1) NOT NULL |
08/12/99 RML Changed descriptions for translate values
1=Last Price Paid
2=Last Receipt Cost
Default Value: 1
|
| 55 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR
Set Control Field: BUSINESS_UNIT
|
| 56 |
VENDOR_ID_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Created 07/99 KDN CN# CM800-2.0 - Landed Cost Reports - CMS3010
Prompt Table:
VENDOR
Set Control Field: BUSINESS_UNIT
|
| 57 |
VENDOR_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Created 07/99 KDN CN# CM800-2.0 - Landed Cost Reports - CMS3010
Prompt Table:
VENDOR
Set Control Field: BUSINESS_UNIT
|
| 58 |
CM_SORT_OPTION_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Created 07/99 KDN CN# CM800-2.0 - Landed Cost Reports - CMS3000
P=PO
R=Receiver
Default Value: R
|
| 59 |
CM_SORT_OPTION_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Created 07/99 KDN CN# CM800-2.0 - Landed Cost Reports - CMS3010
I=Item
P=PO
V=Supplier
Default Value: P
|
| 60 |
VENDOR_NAME_SHORT |
Character(14) |
VARCHAR2(14) NOT NULL |
Short Vendor Name
Prompt Table:
VENDOR_SHRT_VW1
Set Control Field: BUSINESS_UNIT
|
| 61 |
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
|
| 62 |
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
|
| 63 |
CM_UNT_TTL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Created 07/99 KDN CN# CM800-2.0 - Landed Cost Reports - CMS3000
T=Total Amt
U=Unit Amt
Default Value: T
|
| 64 |
CM_CMP_GRP_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Created 07/99 KDN CN# CM800-2.0 - Landed Cost Reports - CMS3000, CMS3010, & CMS3020
C=Component
G=Group
Default Value: C
|
| 65 |
FROM_PO |
Character(10) |
VARCHAR2(10) NOT NULL |
Created 07/99 KDN CN# CM800-2.0 - Landed Cost Reports - CMS3000, CMS3010
Prompt Table:
CM_PO_HDR_VW
|
| 66 |
TO_PO |
Character(10) |
VARCHAR2(10) NOT NULL |
Created 07/99 KDN CN# CM800-2.0 - Landed Cost Reports - CMS3000, CMS3010
Prompt Table:
CM_PO_HDR_VW
|
| 67 |
FROM_RECEIVER |
Character(10) |
VARCHAR2(10) NOT NULL |
Created 07/99 KDN CN# CM800-2.0 - Landed Cost Reports - CMS3000, CMS3010
Prompt Table:
CM_RC_LN_SHP_VW
|
| 68 |
TO_RECEIVER |
Character(10) |
VARCHAR2(10) NOT NULL |
Created 07/99 KDN CN# CM800-2.0 - Landed Cost Reports - CMS3000, CMS3010
Prompt Table:
CM_RC_LN_SHP_VW
|
| 69 |
CM_RANGE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Created 07/99 KDN CN# CM800-2.0 - Landed Cost Reports - CMS3000, CMS3010, & CMS3020
A=All
R=Range
Default Value: A
|
| 70 |
TOLERANCE_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Created for Landed Cost Reports - CMS3000, CMS3010, CMS3020 - KDN 10/20/99
|
| 71 |
AS_OF_DATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
As of Date for CMS2010 report
A=Accounting Period
S=System Date
Default Value: S
|
| 72 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 73 |
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.
|
| 74 |
ONHAND_QTY_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
03/25/03 ST- Created field for run_cms2010
Y/N Table Edit
|