VAT_RPT_INST_CR

(SQL Table)
Index Back

VAT Report List Criteria

VAT 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_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