POREBDUE

Contract Rebate Header

This table contains the rebate summary information for a contract.
UPDATED 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
DUE-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.
DUE-CM-CONTRACT
Element: Cm Contract		Numeric 15
DUE-REBATE-TYPE
Element: Rebate Type		Alpha 25
DUE-DUE-DATE
Element: Date		Numeric 8 (yyyymmdd)
The rebate transaction due date.
DUE-EXPECTED-AMT
Element: Intl Amt		Signed 18.2
The expected rebate amount.
DUE-RECEIVED-AMT
Element: Intl Amt		Signed 18.2
The received rebate amount.
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
DUE-LST-REBATE-SEQ
Element: Seq Number		Numeric 6
The last rebate received sequence number for the PORECRECD table.
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
DUE-STATUS
Element: Status		Numeric 1
This field displays the status of the transaction.
0 = Open
1 = Closed
2 = Paid
3 = Not Paid
4 = Not Earned
5 = Terminated
DUE-REMAINING-AMT
Element: Remaining Amt		Derived
The remaining rebate amount to be paid.
DUE-CURR-PURCHASES
Element: Intl Amt		Signed 18.2
Contains the current purchases amount and is entered in CM. It is not entered, updated or displayed outside on CM.
DUE-REBATE-AMT
Element: Intl Amt		Signed 18.2
This field can be entered in CM or it will be calculated as follows: Curr-Purchases - Curr-Base-Pur = Rebate-Amt. This field is not entered, updated or displayed outside of CM.
DUE-GROWTH-PERCENT
Element: Total Percent		Signed 6.3
DUE-CURR-BASE-PUR
Element: Intl Amt		Signed 18.2
This is the base or starting amount from which to calculate the growth in purchases. It is not entered, updated or displayed outside of CM. The calculation is Curr-Purchases - Curr-Base-Pur = Rebate-Amt
DUE-REB-EXP-DATE
Element: Date		Numeric 8 (yyyymmdd)


POREBDUE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DUESET1 CONTRACT-GROUP
CM-CONTRACT
REBATE-TYPE
DUE-DATE
...
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


POREBDUE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Pocontgrp POCONTGRP Required
DUE-CONTRACT-GROUP->CNG-CONTRACT-GROUP
Pocontract POCONTRACT Required
DUE-CONTRACT-GROUP->CMH-CONTRACT-GROUP
DUE-CM-CONTRACT->CMH-CM-CONTRACT
Pocontreb POCONTREB Required
DUE-CONTRACT-GROUP->REB-CONTRACT-GROUP
DUE-CM-CONTRACT->REB-CM-CONTRACT
DUE-REBATE-TYPE->REB-REBATE-TYPE


POREBDUE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Porebrecd POREBRECD
DUE-CONTRACT-GROUP->RRC-CONTRACT-GROUP
DUE-CM-CONTRACT->RRC-CM-CONTRACT
DUE-REBATE-TYPE->RRC-REBATE-TYPE
DUE-DUE-DATE->RRC-DUE-DATE
  RRC-REBATE-SEQ

File created: Thu Jun 09 02:27:28 2016

Home
Contact Us



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