VAT_REG_RQST(SQL Table) |
Index Back |
|---|---|
VAT Report 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 | 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 | DET_SUM_SW | Character(1) | VARCHAR2(1) NOT NULL |
Detail or Summary
D=Detail S=Summary Default Value: D |
| 6 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table: CUR_RT_TYPE_TBL |
| 7 | VAT_REGISTER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
VAT Register Type
P=VAT Purchases Register S=VAT Sales Register Default Value: P |
| 8 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: VAT_ENT_BU_GL |
| 9 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 10 | JRNL_CODE | Character(8) | VARCHAR2(8) NOT NULL |
Journal Code
Prompt Table: JRNL_CODE_VW1 |
| 11 | DOC_TYPE | Character(8) | VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
Prompt Table: DOC_TYPE_DIS_VW |
| 12 | DOC_SQ_FR | Date(10) | DATE | From Doc Seq Date |
| 13 | DOC_SQ_TO | Date(10) | DATE | To Doc Seq Date |
| 14 | SHOW_FOREIGN_AMT | Character(1) | VARCHAR2(1) NOT NULL |
Show Foreign Currency Amount
Y/N Table Edit Default Value: N |