VAT_XREF_AM (SQL Table)	Index Back
AM VAT XREF Table Asset Management VAT Cross-reference table for VAT Transaction Loader

VAT_XREF_AM

(SQL Table)

AM VAT XREF Table

Asset Management VAT Cross-reference table for VAT Transaction Loader

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.

2 COUNTRY_VAT_RPTG Character(3) VARCHAR2(3) NOT NULL VAT Reporting Country

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

4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

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

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

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

8 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.

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

10 VAT_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL VAT Distribution Status
D=Distributed
E=Error Flag
I=Ignored
M=Archival Entry
N=Not Distributed
P=Processed
R=Reversal Entry
U=Undefined

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VAT_ENTITY	Character(20)	VARCHAR2(20) NOT NULL	Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
2	COUNTRY_VAT_RPTG	Character(3)	VARCHAR2(3) NOT NULL	VAT Reporting Country
3	VAT_DCMNT_ID	Number(8,0)	INTEGER NOT NULL	VAT Document ID
4	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
7	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name
8	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.
9	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
10	VAT_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	VAT Distribution Status D=Distributed E=Error Flag I=Ignored M=Archival Entry N=Not Distributed P=Processed R=Reversal Entry U=Undefined