OPRIDRUN_CNTL_IDREQUEST_NBRDefault Value: 9999
A=Always Process
N=Don't Run
O=Process Once
Default Value: O
Prompt Table: VAT_ENTITY
%=Both
A=Arrivals
D=Dispatches
Default Value: %date
IST_TXN_LD_RQST(SQL Table) |
Index Back |
|---|---|
Intrastat Txn Load Request |
| # | 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 | REQUEST_NBR |
Number(4,0) | SMALLINT NOT NULL |
Request Number
Default Value: 9999 |
| 4 | PROCESS_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process N=Don't Run O=Process Once Default Value: O |
| 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.
Prompt Table: VAT_ENTITY |
| 6 | IST_FLOW_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Flow Type
%=Both A=Arrivals D=Dispatches |
| 7 | RPT_TXN_THRU_DT | Date(10) | DATE |
Select Transactions Thru
Default Value: %date |