CM_EOM_HDR_TBL

(SQL Table)
Index Back

End of Month Summary

This table is the summary detail displayed on the report for End Of Month Reconcilation. All information is summed to the Item level.

# 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 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
7 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.
8 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Prompt Table: SP_BU_GL_NONVW

9 CM_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

10 RUNDATE Date(10) DATE Process Scheduler Run Date

Default Value: %DATE

11 TOLERANCE_PCT Number(6,2) DECIMAL(5,2) NOT NULL Created for Landed Cost Reports - CMS3000, CMS3010, CMS3020 - KDN 10/20/99
12 CM_THRESHOLD Signed Number(20,3) DECIMAL(18,3) NOT NULL Threshold
13 CM_ACCT_OPTION Character(1) VARCHAR2(1) NOT NULL Account Option
A=All Accounts
S=Select Accounts
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 FROM_ITEMID Character(18) VARCHAR2(18) NOT NULL 04/10/00 SCC (Internet Architecture): Add label ITEM_ID

Prompt Table: %EDITTABLE

16 TO_ITEM_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 SCC (Internet Architecture): Add label ITEM_ID
17 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
18 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family
19 CM_EOM_SRT_OPT Character(1) VARCHAR2(1) NOT NULL Sort option for report
B=Item
T=Tolerance
20 CM_EOM_LVL_OPT Character(1) VARCHAR2(1) NOT NULL Account Option
A=Account Level
I=Item Level
21 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
22 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code