ITA_RPT_EXT_AET

(SQL Table)
Index Back

VAT Transaction Update Request

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
5 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.
6 ITA_DECL_TYPE Character(4) VARCHAR2(4) NOT NULL Declaration Type
BLTD=Restricted Country Listing
CSLD=Customer & Supplier Listing
PYIL=Payable Invoice Listing
REIL=Receivable Invoice Listing
RSMD=Republic of SanMarino Listing
7 CALENDAR_SETID Character(5) VARCHAR2(5) NOT NULL Calendar SetID
8 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
9 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
10 PERIOD Number(3,0) SMALLINT NOT NULL Period
11 DATE_FROM Date(10) DATE NOT NULL Date From
12 DATE_TO Date(10) DATE NOT NULL Date To
13 ITA_RPT_STATUS Character(1) VARCHAR2(1) NOT NULL Report Status
D=Draft
F=Final
R=Regenerate
14 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

Prompt Table: CUR_RT_TYPE_TBL

15 RUNDATE Date(10) DATE Process Scheduler Run Date