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 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
| 2 | 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 |