AM_IMP_AUD_HDR(SQL Table) |
Index Back |
|---|---|
Impairment Audit Header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_IMP_BU_NONVW |
| 2 | BOOK |
Character(10) | VARCHAR2(10) NOT NULL |
Asset Book Name
Prompt Table: SP_IMP_BK_NONVW |
| 3 | DTTM_STAMP |
DateTime(26) | TIMESTAMP NOT NULL |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Prompt Table: AM_IMPAIR_DTTM |
| 4 | IMPAIR_DT | Date(10) | DATE NOT NULL | Impairment Date |
| 5 | CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Asset Category |
| 6 | CGU_ID | Character(20) | VARCHAR2(20) NOT NULL |
Cash Generating Unit
Prompt Table: AM_CGU_FIELD |
| 7 | IMP_REVERSE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Impairment Reversal
Y/N Table Edit |
| 8 | IMPAIR_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Impairment Frequency
A=Annually M=Monthly Q=Quarterly S=Semiannually |
| 9 | IMPAIR_STRATEGY | Character(1) | VARCHAR2(1) NOT NULL |
Impairment Strategy
A=Impair by Assets C=Impair by CGU |
| 10 | ACCOUNTING_DT | Date(10) | DATE NOT NULL | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 11 | CONVENTION | Character(2) | VARCHAR2(2) NOT NULL | Book Depreciation Convention or Cost Convention |
| 12 | COMMENTS | Long Character | CLOB | Comment |
| 13 | COPY_TO_OTH_BK | Character(1) | VARCHAR2(1) NOT NULL |
Copy Impairment to other books
Y/N Table Edit |
| 14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |