RUN_CNTL_SF220

(SQL Table)
Index Back

SF220 Run Control Page

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

Prompt Table: OPRID_VW

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 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

5 ENTITY_CODE Character(9) VARCHAR2(9) NOT NULL Entity Code for SF 220 Reporting

Prompt Table: AR_ENTITY_VW

6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUARED_NONVW

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

Prompt Table: AR_CAL_DETL_VW

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

Prompt Table: AR_CAL_FY_VW

9 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.

Prompt Table: AR_CAL_PERD_VW

10 ACCOUNTING_PD_TO Number(3,0) SMALLINT NOT NULL Range To Accounting Period

Prompt Table: AR_CAL_PERD_VW

11 RECEIVABLE_TYPE Character(3) VARCHAR2(3) NOT NULL Receivable Type code for SF220 Reporting

Prompt Table: AR_RECTYPE1_VW

12 PREP_NAME Character(50) VARCHAR2(50) NOT NULL Preparer Name
13 PREP_PHONE Character(24) VARCHAR2(24) NOT NULL Preparer Telephone
14 PREP_FAX_NBR Character(24) VARCHAR2(24) NOT NULL Preparer Fax Number
15 PREP_EMAIL Character(70) VARCHAR2(70) NOT NULL Preparers Email ID
16 SUP_NAME Character(50) VARCHAR2(50) NOT NULL Supervisor Name
17 SUP_PHONE Character(24) VARCHAR2(24) NOT NULL Supervisor Telephone
18 SUP_FAX_NBR Character(24) VARCHAR2(24) NOT NULL Supervisor Fax Number
19 SUP_EMAIL Character(70) VARCHAR2(70) NOT NULL Supervisor Email ID
20 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
21 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
22 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
23 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
24 CITY Character(30) VARCHAR2(30) NOT NULL City
25 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

Default Value: N

26 COUNTY Character(30) VARCHAR2(30) NOT NULL County
27 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

28 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
29 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Default Value: INSTALLATION.COUNTRY

Prompt Table: COUNTRY_TBL

30 PCA_NBR Number(3,0) SMALLINT NOT NULL PCA Debt Disposition Number
31 PCA_AMT Number(18,2) DECIMAL(17,2) NOT NULL PCA Debit Disposition Amount
32 TXN_NBR Number(3,0) SMALLINT NOT NULL TXN Debt Disposition Number
33 TXN_AMT Number(18,2) DECIMAL(17,2) NOT NULL TXN Debt Distribution Amount
34 TOP_NBR Number(3,0) SMALLINT NOT NULL TOP Debt Disposition Number
35 TOP_AMT Number(18,2) DECIMAL(17,2) NOT NULL TOP Debt Disposition Amount
36 OTH_NBR Number(3,0) SMALLINT NOT NULL OTH Debt Disposition Number
37 OTH_AMT Number(18,2) DECIMAL(17,2) NOT NULL OTH Debt Disposition Amount
38 IRS_1099C_NBR Number(3,0) SMALLINT NOT NULL IRS 1099-C Submitted Number
39 IRS_1099C_AMT Number(18,2) DECIMAL(17,2) NOT NULL IRS 1099-C Submitted Amount
40 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
41 IRS_NRPT_1099C_NBR Number(3,0) SMALLINT NOT NULL IRS Not Reported 1099-C Number
42 IRS_NRPT_1099C_AMT Number(18,2) DECIMAL(17,2) NOT NULL IRS Not Reported 1099-C Amount
43 IRS_NRQD_1099C_AMT Number(18,2) DECIMAL(17,2) NOT NULL IRS Not Report/Required 1099-C
44 IRS_NRQD_1099C_NBR Number(3,0) SMALLINT NOT NULL IRS Not Report/Required 1099-C