POCONTREB

REFERENCED BY
AP125 AP126 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.1 AP30.2 AP30.4 API1.1
CB10.1 CB10.5 CB150 CB180 CB191 CB43.1
CB46.1 CB543 CB544 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA44.1 MA44.2 MA540

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
REB-CONTRACT-GROUP
Element: Enterprise Grp
Alpha 4
This field contains the identifier for a group of contracts that can be shared by one or more companies.
REB-CM-CONTRACT
Element: Cm Contract
Numeric 15
REB-REBATE-TYPE
Element: Rebate Type
Alpha 25
REB-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
REB-STATUS
Element: Status
Numeric 1

0 = Active
1 = Inactive
REB-LINE-OVERRIDES
Element: Flag
Alpha 1

Y = Yes
N = No
REB-FRST-RB-DUE-DT
Element: Date
Numeric 8 (yyyymmdd)
This is the first rebate due date.
REB-LST-CN-REB-QLF
Element: Seq Number
Numeric 6
This is the last contract rebate qualifier sequence number.
REB-TOTAL-EXP-AMT
Element: Intl Amt
Signed 18.2
This is the total expected rebate amount.
REB-REB-FREQUENCY
Element: Reb Frequency
Numeric 1

1 = Annual
2 = BiAnnual
3 = Quarterly
4 = BiMonthly
5 = Monthly
6 = OneTime
7 = SemiAnnual
REB-REB-PERCENT
Element: Total Percent
Signed 6.3
This field contains the rebate percent and is entered in CM. It is not modified or displayed outside of CM.
REB-CURR-BASE-PUR
Element: Intl Amt
Signed 18.2
REB-CALC-GROWTH-RB
Element: Status
Numeric 1

0 = No
1 = Yes
REB-LST-GROWTH-QLF
Element: Seq Number
Numeric 6
REB-QUAL-CHANGE-FL
Element: All Flag
Alpha 1

N = No qualifier changes
Y = Yes - a qualifier has changed


POCONTREB FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
REBSET1 CONTRACT-GROUP
CM-CONTRACT
REBATE-TYPE
...
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
REBSET2 CONTRACT-GROUP
VENDOR
CM-CONTRACT
REBATE-TYPE


POCONTREB FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apvenmast APVENMAST Required
PCG-VENDOR-GROUP->VEN-VENDOR-GROUP (VENSET1)
REB-VENDOR->VEN-VENDOR
Pocontgrp POCONTGRP Required
REB-CONTRACT-GROUP->CNG-CONTRACT-GROUP
Pocontract POCONTRACT Required
REB-CONTRACT-GROUP->CMH-CONTRACT-GROUP
REB-CM-CONTRACT->CMH-CM-CONTRACT
Procuregrp PROCUREGRP Required
REB-CONTRACT-GROUP->PCG-PROCURE-GROUP


File created: Thu Jun 09 02:26:47 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.