RUN_AR_1099C

(SQL Table)
Index Back

Run control for 1099C Prep AE

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

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

4 CREDITOR_ID1 Character(40) VARCHAR2(40) NOT NULL Field's label for SEPA Direct Debit Form

Prompt Table: AR_CANC_DEBT_CR

5 TIN Character(20) VARCHAR2(20) NOT NULL Taxpayer Identification Number
6 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
7 FROM_DT Date(10) DATE NOT NULL From Date
8 TO_DT Date(10) DATE NOT NULL To Date
9 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

Prompt Table: CUSTOMER

10 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group

Prompt Table: CUSTGP_CDT_VW