POREBRECD

Contract Rebate Detail

This table contains the transaction information for rebate payments received on 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
RRC-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.
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
RRC-CM-CONTRACT
Element: Cm Contract		Numeric 15
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
RRC-REBATE-TYPE
Element: Rebate Type		Alpha 25
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
RRC-DUE-DATE
Element: Date		Numeric 8 (yyyymmdd)
The rebate due date for a CM contract.
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
RRC-REBATE-SEQ
Element: Seq Number		Numeric 6
A unique sequence number for this rebate payment.
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
RRC-DOC-DATE
Element: Date		Numeric 8 (yyyymmdd)
The document date for the rebate received.
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
RRC-COMPANY
Element: Company		Numeric 4
The company assigned to the rebate payment.
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
RRC-AR-BATCH-NBR
Element: Batch Nbr		Numeric 6
This identifies the batch to which the entered payments belong.
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
RRC-AR-INVOICE
Element: Invoice		Alpha 22
This is used to identify the AR invoice.
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
RRC-API-OBJ-ID
Element: Obj Id		Numeric 12
A unique identifier assigned to an APINVOICE table entry.
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
RRC-CB-CASH-CODE
Element: Cash Code		Alpha 4
The cash code. Represents the bank account you are depositing cash receipt funds to. Must be a valid record in the Cash Code file.
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
RRC-CB-BANK-INST
Element: Bank Inst Code		Alpha 3
The bank service transaction code. Represents a deposit for the cash code. Must be a valid bank service type transaction code record in the Bank Transaction Code file.
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
RRC-CB-TRANS-NBR
Element: Trans Nbr		Alpha 10 (Right Justified)
A unique number assigned to the deposit.
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
RRC-STATUS
Element: Status		Numeric 1
This field displays the status of the transaction.
0 = Entered
1 = Cancelled/Voided
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
RRC-TRANS-AMOUNT
Element: Intl Amt		Signed 18.2
Total rebate amount received in the transaction currency.
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
RRC-TRANS-CURR
Element: Currency Code		Alpha 5
Currency code for the transaction.
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
RRC-CONT-CURR-AMT
Element: Intl Amt		Signed 18.2
Total rebate amount received in the contract currency.
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
RRC-CURR-RATE
Element: Curr Rate		Signed 14.7
The currency exchange rate applied to the transaction to convert from the transaction currency to the contract currency.
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
RRC-PAYMENT-NBR
Element: Payment Nbr		Alpha 10 (Right Justified)
This is the payment number for the transaction. This can be a check number, wire transfer number, or any other number that identifies the transaction.
RRC-LAST-DIST-SEQ
Element: Seq Number		Numeric 6


POREBRECD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RRCSET1 CONTRACT-GROUP
CM-CONTRACT
REBATE-TYPE
DUE-DATE
REBATE-SEQ
...
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
RRCSET2 API-OBJ-ID
CONTRACT-GROUP
CM-CONTRACT
REBATE-TYPE
DUE-DATE
REBATE-SEQ
Subset
WhereAPI-OBJ-ID !=Zeroes
AP30.1 AP30.2
RRCSET3 COMPANY
AR-BATCH-NBR
AR-INVOICE
CONTRACT-GROUP
CM-CONTRACT
REBATE-TYPE
DUE-DATE
REBATE-SEQ
Subset
WhereAR-INVOICE !=Spaces
RRCSET4 CB-CASH-CODE
CB-BANK-INST
CB-TRANS-NBR
CONTRACT-GROUP
CM-CONTRACT
REBATE-TYPE
DUE-DATE
REBATE-SEQ
Subset
WhereCB-TRANS-NBR !=Spaces


POREBRECD FILE RELATIONS


ONE TO ONE RELATIONS

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


POREBRECD FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Porebdist POREBDIST
RRC-CONTRACT-GROUP->RDS-CONTRACT-GROUP
RRC-CM-CONTRACT->RDS-CM-CONTRACT
RRC-REBATE-TYPE->RDS-REBATE-TYPE
RRC-DOC-DATE->RDS-DUE-DATE
RRC-REBATE-SEQ->RDS-REBATE-SEQ
  RDS-DIST-SEQ-NBR

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

Home
Contact Us



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