VRBT_GEN_CLM_RC

(SQL Table)
Index Back

Gen Claims Run Control

Supplier Rebate Generate Claims Run Control

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

Default Value: ENG

4 CLAIM_RUN_OPT Character(1) VARCHAR2(1) NOT NULL Claim Run Options
0=All Rebate Agreements
1=Specific Rebate Agreements

Default Value: 1

5 THRU_DATE Date(10) DATE NOT NULL Through Date

Default Value: %DATE

6 VRBT_UNRESTRICT_FL Character(1) VARCHAR2(1) NOT NULL Unrestricted Rebate Manager

Default Value: N