| # |
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 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 7 |
PRINT_PROCESS_INST |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 8 |
CM_ACCT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Option
A=All Accounts
S=Select Accounts
|
| 9 |
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
|
| 10 |
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
|
| 11 |
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.
|
| 12 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 13 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 14 |
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
|
| 15 |
INV_ITEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Group
|
| 16 |
INV_PROD_FAM_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Family
|
| 17 |
FROM_ITEMID |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label ITEM_ID
|
| 18 |
TO_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label ITEM_ID
|
| 19 |
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
|
| 20 |
CM_INTRANS_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrans Option
E=Exclude Instranit Inventory
I=Include Intransit Inventory
O=Only Intransit Inventory
|
| 21 |
CM_ZERO_TRN_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Zero Transaction
Y/N Table Edit
Default Value: N
|
| 22 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 23 |
SHORTNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Field Short Name
|
| 24 |
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. "
|
| 25 |
CM_EOM_LVL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Option
A=Account Level
I=Item Level
|
| 26 |
CM_PURGE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Purge Okay Flag
N=Doesn't Qualify for Purging
Y=Qualifies for Purging
|
| 27 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 28 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 29 |
WHERE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Where Clause
|
| 30 |
FROM_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
From Clause
|
| 31 |
FROM_CLAUSE_DELTA |
Character(254) |
VARCHAR2(254) NOT NULL |
From Clause
|
| 32 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 33 |
WHERE_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 34 |
WHERE_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|