POREBRECD – Contract Rebate Detail

System
Purchase Order (PO)
Prefix
RRC
Primary key
CONTRACT-GROUP, CM-CONTRACT, REBATE-TYPE, DUE-DATE, REBATE-SEQ
Fields
20
Updated by
36 programs
Referenced by
0 programs

POREBRECD is the Contract Rebate Detail table in Lawson Purchase Order (prefix RRC). It is indexed by CONTRACT-GROUP, CM-CONTRACT, REBATE-TYPE, DUE-DATE, REBATE-SEQ (RRCSET1); alternate indexes: RRCSET2, RRCSET3 and RRCSET4. It is related 1:1 to POCONTGRP, POCONTRACT and POCONTREB and 1:M to POREBDIST. It is updated by AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 and 28 more. The table has 20 fields, 4 indexes and 4 documented relations.

About POREBRECD

No description in the Lawson data dictionary.

Fields (20)

Column = COBOL field name without the RRC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#RRC-CONTRACT-GROUP PK
CONTRACT_GROUP		Alpha 4This 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 +28 more
#RRC-CM-CONTRACT PK
CM_CONTRACT		Numeric 15—AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RRC-REBATE-TYPE PK
REBATE_TYPE		Alpha 25—AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RRC-DUE-DATE PK
DUE_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 +28 more
#RRC-REBATE-SEQ PK
REBATE_SEQ		Numeric 6A unique sequence number for this rebate payment.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RRC-DOC-DATE
DOC_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 +28 more
#RRC-COMPANY SET3
COMPANY		Numeric 4The company assigned to the rebate payment.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RRC-AR-BATCH-NBR SET3
AR_BATCH_NBR		Numeric 6This identifies the batch to which the entered payments belong.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RRC-AR-INVOICE SET3
AR_INVOICE		Alpha 22This is used to identify the AR invoice.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RRC-API-OBJ-ID SET2
API_OBJ_ID		Numeric 12A unique identifier assigned to an APINVOICE table entry.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RRC-CB-CASH-CODE SET4
CB_CASH_CODE		Alpha 4The 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 +28 more
#RRC-CB-BANK-INST SET4
CB_BANK_INST		Alpha 3The 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 +28 more
#RRC-CB-TRANS-NBR SET4
CB_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 +28 more
#RRC-STATUS
STATUS		Numeric 1This 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 +28 more
#RRC-TRANS-AMOUNT
TRANS_AMOUNT		Signed 18.2Total rebate amount received in the transaction currency.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RRC-TRANS-CURR
TRANS_CURR		Alpha 5Currency code for the transaction.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RRC-CONT-CURR-AMT
CONT_CURR_AMT		Signed 18.2Total rebate amount received in the contract currency.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RRC-CURR-RATE
CURR_RATE		Signed 14.7The 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 +28 more
#RRC-PAYMENT-NBR
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
LAST_DIST_SEQ		Numeric 6——

Indexes (4)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RRCSET1
  1. CONTRACT-GROUP
  2. CM-CONTRACT
  3. REBATE-TYPE
  4. DUE-DATE
  5. REBATE-SEQ
PrimaryAP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)
RRCSET2
  1. API-OBJ-ID
  2. CONTRACT-GROUP
  3. CM-CONTRACT
  4. REBATE-TYPE
  5. DUE-DATE
  6. REBATE-SEQ
SubsetWhere API-OBJ-ID != ZeroesAP30.1, AP30.2
RRCSET3
  1. COMPANY
  2. AR-BATCH-NBR
  3. AR-INVOICE
  4. CONTRACT-GROUP
  5. CM-CONTRACT
  6. REBATE-TYPE
  7. DUE-DATE
  8. REBATE-SEQ
SubsetWhere AR-INVOICE != Spaces—
RRCSET4
  1. CB-CASH-CODE
  2. CB-BANK-INST
  3. CB-TRANS-NBR
  4. CONTRACT-GROUP
  5. CM-CONTRACT
  6. REBATE-TYPE
  7. DUE-DATE
  8. REBATE-SEQ
SubsetWhere CB-TRANS-NBR != Spaces—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
POCONTGRPPOCONTRACTPOCONTREBPOREBDISTPOREBRECD

One to one (3) — lookups and parents

RelationTableRulesConditionField map
PocontgrpPOCONTGRPRequired
RRC-CONTRACT-GROUP→CNG-CONTRACT-GROUP (CNGSET1)
PocontractPOCONTRACTRequired
RRC-CONTRACT-GROUP→CMH-CONTRACT-GROUP
RRC-CM-CONTRACT→CMH-CM-CONTRACT
PocontrebPOCONTREBRequired
RRC-CONTRACT-GROUP→REB-CONTRACT-GROUP
RRC-CM-CONTRACT→REB-CM-CONTRACT
RRC-REBATE-TYPE→REB-REBATE-TYPE

One to many (1) — child tables

RelationTableRulesConditionField map
PorebdistPOREBDIST
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

Programs

Updated by (36)