SII_VAT_RGS_AET

(SQL Table)
 Index Back

VAT Txn Loader State Table

Application engine state table used by the 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 RECNAME_UPD_SRC Character(15) VARCHAR2(15) NOT NULL VAT Transaction Update Source
3 SII_HDR_SQL Character(100) VARCHAR2(100) NOT NULL Header SQL
4 SII_LN_SQL Character(100) VARCHAR2(100) NOT NULL Header SQL
5 SII_PAY_SQL Character(100) VARCHAR2(100) NOT NULL Header SQL
6 RECNAME_BU Character(15) VARCHAR2(15) NOT NULL Business Unit Recname
7 SII_REC_MNT Character(15) VARCHAR2(15) NOT NULL Management Record
8 SII_FILTER_SQL Character(100) VARCHAR2(100) NOT NULL Filter SQL
9 SII_REC_HDR_SRC Character(15) VARCHAR2(15) NOT NULL Record Name
10 SII_REC_HDR_TRG Character(15) VARCHAR2(15) NOT NULL Record Name
11 SII_REC_LN_SRC Character(15) VARCHAR2(15) NOT NULL Record Name
12 SII_REC_LN_TRG Character(15) VARCHAR2(15) NOT NULL Record Name
13 FS_RET_DESRC Character(254) VARCHAR2(254) NOT NULL Result Description
14 FS_MAP_RET Number(4,0) SMALLINT NOT NULL Result
15 FILE_SEQ Number(9,0) DECIMAL(9) NOT NULL File Sequence Number
16 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name
17 SII_ACTION_TYPE Character(2) VARCHAR2(2) NOT NULL Action Type
A0=Addition
A1=Modification
18 LOC_RGSTRN_ID Character(20) VARCHAR2(20) NOT NULL Local VAT Registration ID
19 SII_FILE_TYPE Character(2) VARCHAR2(2) NOT NULL Register File Type
20 FS_MAP_ID Character(30) VARCHAR2(30) NOT NULL Map ID
21 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
22 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
23 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number
24 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.
25 ALL_PRODUCTS Character(1) VARCHAR2(1) NOT NULL All Products
26 ALL_BU Character(1) VARCHAR2(1) NOT NULL All Business Units
N=Specific Business Unit
Y=All Business Units
27 DATE_FROM Date(10) DATE Date From
28 DATE_TO Date(10) DATE Date To
29 RPT_YEAR Character(4) VARCHAR2(4) NOT NULL Reporting Year
30 RPT_PERIOD Character(2) VARCHAR2(2) NOT NULL Reporting Period
31 OUTDEST Character(127) VARCHAR2(127) NOT NULL Process Scheduler Output Destination
32 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
33 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
34 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
35 VAT_SOURCE_DEFN Character(10) VARCHAR2(10) NOT NULL Update VAT Source Definition
36 SII_REC_HDR_TMP Character(15) VARCHAR2(15) NOT NULL Record Name
37 SII_REC_LN_TMP Character(15) VARCHAR2(15) NOT NULL Record Name
38 SII_REC_PAY_TMP Character(15) VARCHAR2(15) NOT NULL Record Name
39 SII_INVOICE_ID Character(60) VARCHAR2(60) NOT NULL SII_INVOICE_ID
40 SII_INVID_TMP Character(60) VARCHAR2(60) NOT NULL SII_INVOICE_ID
41 COUNTER Number(10,0) DECIMAL(10) NOT NULL Counter