RUN_VAT4000

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: OPR_DEF_TBL_AP.OPRID

Prompt Table: OPR_DEF_TBL_AP

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 INDVAT_RPT_TYPE Character(4) VARCHAR2(4) NOT NULL Report Type
IUT=Inter Unit Transfer
REG=Regular
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_GL_NONVW

6 CALENDAR_SETID Character(5) VARCHAR2(5) NOT NULL Calendar SetID

Prompt Table: SP_SETID_NONVW

7 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

Prompt Table: WTHD_CAL_VW3

8 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

Prompt Table: WTHD_CAL_VW1

9 PERIOD Number(3,0) SMALLINT NOT NULL Period

Prompt Table: WTHD_CAL_VW2

10 FROM_DATE Date(10) DATE From Date
11 THRU_DATE Date(10) DATE Through Date