BUSINESS_UNITPrompt Table: SP_IMP_BU_NONVW
BOOKPrompt Table: SP_IMP_BK_NONVW
DTTM_STAMPPrompt Table: AM_IMPAIR_DTTM
A=Annually
M=Monthly
Q=Quarterly
S=Semiannually
Y/N Table Edit
C=Cost Based
D=Depr. Write-Off
I=Investment Property
AM_REV_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 | IMPAIR_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Impairment Frequency
A=Annually M=Monthly Q=Quarterly S=Semiannually |
| 7 | ACCOUNTING_DT | Date(10) | DATE NOT NULL | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 8 | CONVENTION | Character(2) | VARCHAR2(2) NOT NULL | Book Depreciation Convention or Cost Convention |
| 9 | COPY_TO_OTH_BK | Character(1) | VARCHAR2(1) NOT NULL |
Copy Impairment to other books
Y/N Table Edit |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 11 | REVALUE_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Revaluation Method
C=Cost Based D=Depr. Write-Off I=Investment Property |
| 12 | INCL_CUR_PD_DEPR | Character(1) | VARCHAR2(1) NOT NULL | Include current Period Depr. |
| 13 | COMMENTS | Long Character | CLOB | Comment |