ITA_RPT_RQ_AET

(SQL Table)
Index Back

VAT Report 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 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
7 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
8 PROCESS_INSTANCE2 Number(10,0) DECIMAL(10) NOT NULL Process Instance
9 ITA_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Transmission Type
C=Cancellation
O=Ordinary
S=Substitution
10 ITA_MODE Character(1) VARCHAR2(1) NOT NULL Transmission Mode
A=Aggregated
D=Detailed
11 ITA_RPT_STATUS Character(1) VARCHAR2(1) NOT NULL Report Status
D=Draft
F=Final
R=Regenerate
12 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
13 FS_MAP_ID Character(30) VARCHAR2(30) NOT NULL Map ID
14 VAT_RGSTRN_ID Character(20) VARCHAR2(20) NOT NULL VAT Registration ID
15 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
16 FILEPATH Character(30) VARCHAR2(30) NOT NULL File Information
17 FS_MAP_RET Number(4,0) SMALLINT NOT NULL Result
18 VAT_DCMNT_ID Number(8,0) INTEGER NOT NULL VAT Document ID
19 PROGRESSIVE_ID Character(5) VARCHAR2(5) NOT NULL Progressive ID