VAT_TX_AM_TAO (SQL Table)	Index Back
AM VAT DOC TMP Table Asset Management DOC TMP Table for VAT Transaction Loader

VAT_TX_AM_TAO

(SQL Table)

AM VAT DOC TMP Table

Asset Management DOC TMP Table for VAT Transaction Loader

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

4 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

5 DTTM_STAMP DateTime(26) TIMESTAMP 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.

6 VAT_DCMNT_ID Number(8,0) INTEGER NOT NULL VAT Document ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
4	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name
5	DTTM_STAMP	DateTime(26)	TIMESTAMP	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.
6	VAT_DCMNT_ID	Number(8,0)	INTEGER NOT NULL	VAT Document ID