DEPR_RPT_DTTM

(SQL Table)
Index Back

Depr Rpt Dttm Insights

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
3 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
4 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
5 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.
6 CF_SEQNO Number(6,0) INTEGER NOT NULL Chartfield Sequence Number
7 SES_LAST_DTTM DateTime(26) TIMESTAMP PTSF Last Modified DateTimestamp

Default Value: %DATETIME