VAT_RPT_INST_CR(SQL Table) |
Index Back |
---|---|
VAT Report List CriteriaVAT Report List Criteria |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | 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 |
4 | COUNTRY_VAT_RPTG | Character(3) | VARCHAR2(3) NOT NULL |
VAT Reporting Country
Prompt Table: VAT_ENT_RGSTRN |
5 | VAT_RPT_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Print Report As
DRFT=Draft Report FNL=Final Report RPRN=Reprint Default Value: DRFT |
6 | FROM_LINE_NUM | Number(5,0) | INTEGER NOT NULL |
From Line
Prompt Table: LC_RPT_VATLN_VW |
7 | TO_LINE_NUM | Number(5,0) | INTEGER NOT NULL |
To Line
Default Value: VAT_RPT_INST_CR.FROM_LINE_NUM Prompt Table: LC_RPT_VATLN_VW |
8 | VALIDATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Validate Flag
Y/N Table Edit Default Value: N |
9 | MAX_TRANS_COUNT | Number(9,0) | DECIMAL(9) NOT NULL | Maximum Transaction Count |
10 | ERROR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Show Errors
Y/N Table Edit Default Value: N |
11 | ORIG_PROC_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Original Process Instance |
12 | VAT_RPT_ID | Character(8) | VARCHAR2(8) NOT NULL | Report ID |
13 | FILTER_OPTIONS | Character(1) | VARCHAR2(1) NOT NULL | Filter Options |
14 | LC_RPT_BURST_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Burst by VAT Report Line
Y/N Table Edit Default Value: N |
15 | LC_RPT_URL1 | Character(254) | VARCHAR2(254) NOT NULL | VAT Transaction Report URL Part 1 |
16 | UK_VAT_DIGITAL | Character(1) | VARCHAR2(1) NOT NULL |
UK Digital VAT Return
Y/N Table Edit Default Value: N |
17 | FS_MAP_ID | Character(30) | VARCHAR2(30) NOT NULL |
Map ID
Prompt Table: UKVATDIG_MAP_VW |