PROCESS_INSTANCEPrompt Table: VAT_ENTITY
Prompt Table: VAT_ENT_RGSTRN
Default Value: 1
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
LC_RPT_VAT_AET(SQL Table) |
Index Back |
|---|---|
VAT Transaction Report AET |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 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 | COUNTRY_VAT_RPTG | Character(3) | VARCHAR2(3) NOT NULL |
VAT Reporting Country
Prompt Table: VAT_ENT_RGSTRN |
| 7 | FROM_LINE_NUM | Number(5,0) | INTEGER NOT NULL | From Line |
| 8 | TO_LINE_NUM | Number(5,0) | INTEGER NOT NULL | To Line |
| 9 | COLUMNNUM | Number(3,0) | SMALLINT NOT NULL |
Column Number
Default Value: 1 |
| 10 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 11 | VALIDATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Validate Flag
Y/N Table Edit Default Value: N |
| 12 | VAT_RPT_ID | Character(8) | VARCHAR2(8) NOT NULL | Report ID |
| 13 | ORIG_PROC_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Original Process Instance |
| 14 | OPERAND_PREFIX | Character(254) | VARCHAR2(254) NOT NULL | Operand Prefix |
| 15 | AMOUNT_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | An internal work field utilized for calculating forecast amounts for a given category in cash wor |
| 16 | CURRENCY_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Currency Field Name |
| 17 | VAT_RPT_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number |
| 18 | ORDERBY_FLD | Character(254) | VARCHAR2(254) NOT NULL | Field Name |
| 19 | ERROR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Error Flag
Y/N Table Edit Default Value: N |
| 20 | FILTER_OPTIONS | Character(1) | VARCHAR2(1) NOT NULL | Filter Options |
| 21 | MAX_TRANS_COUNT | Number(9,0) | DECIMAL(9) NOT NULL | Maximum Transaction Count |
| 22 | ABS_VALUE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Absolute Value |
| 23 | LC_RPT_BURST_FLG | Character(1) | VARCHAR2(1) NOT NULL | Burst by VAT Report Line |
| 24 | NOTHING_TO_RPT | Character(1) | VARCHAR2(1) NOT NULL | VAT Transaction Report - Nothing to Report ((Y/N) |
| 25 | LC_RPT_URL1 | Character(254) | VARCHAR2(254) NOT NULL | VAT Transaction Report URL Part 1 |