BI_RUN_GTCUS_EX

(SQL Table)
 Index Back

GT customer run control data

GT customer run control data

# 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 CUST_OPTION_GTA Character(1) VARCHAR2(1) NOT NULL Used by GTA
C=Customer ID
G=Golden Tax Customer Code

Default Value: G

4 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

5 FROM_CUSTOMER_CD Character(12) VARCHAR2(12) NOT NULL From Golden Tax Customer Code

Prompt Table: BI_GT_CUST_VW

6 TO_CUSTOMER_CD Character(12) VARCHAR2(12) NOT NULL To Golden Tax Customer Code

Prompt Table: BI_GT_CUST_VW

7 FROM_CUSTOMER_ID Character(15) VARCHAR2(15) NOT NULL From Customer ID

Prompt Table: CUSTOMER

8 TO_CUSTOMER_ID Character(15) VARCHAR2(15) NOT NULL To Customer ID

Prompt Table: CUSTOMER

9 LAST_MOD_DT_FROM Date(10) DATE Last modified date
10 LAST_MOD_DT_TO Date(10) DATE Last modified date
11 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes
12 REQUEST_DATE Date(10) DATE Requested