VRBT_NOTIFY_AET

(SQL Table)
Index Back

Notification Processing State

Supplier Rebate Claims Notification processing state record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
5 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
6 CLAIM_RECON_OPT Character(1) VARCHAR2(1) NOT NULL Incoming Payment Reconciliation Run Option
1=Specific Rebate Agreement
2=Specific Claim ID
3=All Rebate IDs
4=Specific Claimback Contract
5=All Claimback Contracts
7 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

8 VRBT_ID Character(25) VARCHAR2(25) NOT NULL Vendor Rebate ID

Prompt Table: VRBT_HDR

9 THRU_DATE Date(10) DATE Through Date
10 WORKBENCH_ID Character(10) VARCHAR2(10) NOT NULL WorkBench ID
11 CLAIM_ID Character(15) VARCHAR2(15) NOT NULL Claim ID

Prompt Table: VRBT_CLAIM_HDR

12 CLAIM_TYPE Character(1) VARCHAR2(1) NOT NULL Claim Type
C=Claimbacks
R=Vendor Rebate
13 CB_CONTRACT_SETID Character(5) VARCHAR2(5) NOT NULL Claimback Contract Setid
14 CB_CONTRACT_ID Character(25) VARCHAR2(25) NOT NULL Claimback Contract ID
15 NOTIFY_REBATE_MGR Character(1) VARCHAR2(1) NOT NULL Notify Rebate Manager

Y/N Table Edit

16 NOTIFY_STLMENT_MGR Character(1) VARCHAR2(1) NOT NULL Notify Settlement Manager

Y/N Table Edit

Default Value: N

17 COUNT_1 Number(3,0) SMALLINT NOT NULL Count Work Field
18 EOEN_PRCS_NAME Character(30) VARCHAR2(30) NOT NULL EOEN Process Name
19 EOEN_CATEGORY Character(30) VARCHAR2(30) NOT NULL EOEN Category
20 REBATE_MGR Character(30) VARCHAR2(30) NOT NULL Rebate Manager
21 SETTLEMENT_MGR Character(30) VARCHAR2(30) NOT NULL Settlement Manager
22 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
23 VENDOR_NAME Character(30) VARCHAR2(30) NOT NULL Supplier Name
24 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
25 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
26 CLAIM_DT Date(10) DATE Claim Date
27 CLAIM_DUE_DT Date(10) DATE Claim Due Date
28 TOTAL_CLAIM_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Claim Amount
29 DESCR Character(30) VARCHAR2(30) NOT NULL Description
30 VRBT_UNRESTRICT_FL Character(1) VARCHAR2(1) NOT NULL Unrestricted Rebate Manager
31 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine