OPRIDRUN_CNTL_IDPrompt Table: VAT_ENTITY
Prompt Table: VAT_ENT_RGSTRN
DRFT=Draft Report
FNL=Final Report
RPRN=Reprint
Default Value: DRFT
A=Arrivals
D=Dispatches
IST_RPT_INST_CR(SQL Table) |
Index Back |
|---|---|
Intrastat 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_IST_RPTG | Character(3) | VARCHAR2(3) NOT NULL |
IST Reporting Country
Prompt Table: VAT_ENT_RGSTRN |
| 5 | IST_RPT_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Print Report As
DRFT=Draft Report FNL=Final Report RPRN=Reprint Default Value: DRFT |
| 6 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 7 | IST_FLOW | Character(1) | VARCHAR2(1) NOT NULL |
Intrastat Report Flow
A=Arrivals D=Dispatches |