AM_EXT_AUD_HDR (SQL Table)	Index Back
Japan Extended Audit Header

AM_EXT_AUD_HDR

(SQL Table)

Japan Extended 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_BU_AM_NONVW

2 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
Prompt Table: SP_BU_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.

4 TRANS_DT Date(10) DATE NOT NULL Transaction Date

5 ACCOUNTING_DT Date(10) DATE NOT NULL The accounting entry construction date for a given transaction (a generic field that crosses multiple

6 LIFE_END_DT Date(10) DATE Useful Life End Date

7 COPY_TO_OTH_BK Character(1) VARCHAR2(1) NOT NULL Copy Impairment to other books
Y/N Table Edit

8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_AM_NONVW
2	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name Prompt Table: SP_BU_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.
4	TRANS_DT	Date(10)	DATE NOT NULL	Transaction Date
5	ACCOUNTING_DT	Date(10)	DATE NOT NULL	The accounting entry construction date for a given transaction (a generic field that crosses multiple
6	LIFE_END_DT	Date(10)	DATE	Useful Life End Date
7	COPY_TO_OTH_BK	Character(1)	VARCHAR2(1) NOT NULL	Copy Impairment to other books Y/N Table Edit
8	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).