VAT_ENT_IST_RPT

(SQL Table)
Index Back

Intrastat Reports

Intrastat Reports

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

Prompt Table: VAT_ENTITY

2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

3 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

Prompt Table: PRCSTYPE_VW

4 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

Prompt Table: PRCSDEFN

5 FILE_LAYOUT_ID Character(10) VARCHAR2(10) NOT NULL File Layout ID

Prompt Table: PSFLDDEFN_VW1