BUSINESS_UNITPrompt Table: SP_IMP_BU_NONVW
BOOKPrompt Table: SP_IMP_BK_NONVW
DTTM_STAMPPrompt Table: AM_IMPAIR_DTTM
LANGUAGE_CDAM_REV_AUD_H_LG(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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | COMMENTS | Long Character | CLOB | Comment |