| # |
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 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 4 |
CM_BOOK_OPTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Book Option
A=All
S=Specific
|
| 5 |
CM_BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Cost Book
|
| 6 |
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
|
| 7 |
CM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
|
| 8 |
CM_PROFILE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Profile Option
A=All
S=Specific
|
| 9 |
CM_PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
|
| 10 |
CM_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 11 |
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
|
| 12 |
FROM_ITEMID |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label ITEM_ID
|
| 13 |
TO_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label ITEM_ID
|
| 14 |
INV_ITEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Group
|
| 15 |
INV_PROD_FAM_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Family
|
| 16 |
TRANSACTION_DTTM |
DateTime(26) |
TIMESTAMP |
Transaction Date-Time
|
| 17 |
SYSTEM_DATE |
Date(10) |
DATE |
System Date
|
| 18 |
CM_SYSTEM_TM_STAMP |
DateTime(26) |
TIMESTAMP |
System Timestamp
|
| 19 |
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
|
| 20 |
STORAGE_AREA |
Character(5) |
VARCHAR2(5) NOT NULL |
Storage Area
|
| 21 |
DET_SUM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Detail or Summary
D=Detail
S=Summary
|
| 22 |
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
|
| 23 |
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
|
| 24 |
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
|
| 25 |
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
|
| 26 |
AS_OF_DATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
As of Date for CMS2010 report
A=Accounting Period
S=System Date
|
| 27 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 28 |
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.
|