UKVAT_PRCS_AET

(SQL Table)
Index Back

State Record XMLP Fin Reports

State Record for Financial Application Engine Programs

# 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 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 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

5 COUNTRY_VAT_RPTG Character(3) VARCHAR2(3) NOT NULL VAT Reporting Country

Prompt Table: VAT_ENT_RGSTRN

6 VAT_RPT_ID Character(8) VARCHAR2(8) NOT NULL Report ID
7 ORIG_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Original Process Instance
8 FS_MAP_ID Character(30) VARCHAR2(30) NOT NULL Map ID

Prompt Table: FS_MAP_HDR_VW

9 FILEPATH Character(30) VARCHAR2(30) NOT NULL File Information
10 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name