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.

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
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
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
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
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
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
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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RRCSET1CONTRACT-GROUP, CM-CONTRACT, REBATE-TYPE, DUE-DATE, REBATE-SEQPrimaryAP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)
RRCSET2API-OBJ-ID, CONTRACT-GROUP, CM-CONTRACT, REBATE-TYPE, DUE-DATE, REBATE-SEQSubsetWhere API-OBJ-ID != ZeroesAP30.1, AP30.2
RRCSET3COMPANY, AR-BATCH-NBR, AR-INVOICE, CONTRACT-GROUP, CM-CONTRACT, REBATE-TYPE, DUE-DATE, REBATE-SEQSubsetWhere AR-INVOICE != Spaces—
RRCSET4CB-CASH-CODE, CB-BANK-INST, CB-TRANS-NBR, CONTRACT-GROUP, CM-CONTRACT, REBATE-TYPE, DUE-DATE, REBATE-SEQSubsetWhere CB-TRANS-NBR != Spaces—

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
PocontgrpPOCONTGRPRequiredRRC-CONTRACT-GROUP → CNG-CONTRACT-GROUP (CNGSET1)
PocontractPOCONTRACTRequiredRRC-CONTRACT-GROUP → CMH-CONTRACT-GROUP, RRC-CM-CONTRACT → CMH-CM-CONTRACT
PocontrebPOCONTREBRequiredRRC-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
PorebdistPOREBDISTRRC-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)