POREBDUE – Contract Rebate Header

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

POREBDUE is the Contract Rebate Header table in Lawson Purchase Order (prefix DUE). It is indexed by CONTRACT-GROUP, CM-CONTRACT, REBATE-TYPE, DUE-DATE (DUESET1). It is related 1:1 to POCONTGRP, POCONTRACT and POCONTREB and 1:M to POREBRECD. It is updated by AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 and 28 more. The table has 14 fields, 1 index and 4 documented relations.

About POREBDUE

No description in the Lawson data dictionary.

Fields (14)

Column = COBOL field name without the DUE- 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
#DUE-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.—
#DUE-CM-CONTRACT PK
CM_CONTRACT		Numeric 15——
#DUE-REBATE-TYPE PK
REBATE_TYPE		Alpha 25——
#DUE-DUE-DATE PK
DUE_DATE		Numeric 8 (yyyymmdd)The rebate transaction due date.—
#DUE-EXPECTED-AMT
EXPECTED_AMT		Signed 18.2The expected rebate amount.—
#DUE-RECEIVED-AMT
RECEIVED_AMT		Signed 18.2The received rebate amount.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#DUE-LST-REBATE-SEQ
LST_REBATE_SEQ		Numeric 6The last rebate received sequence number for the PORECRECD table.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#DUE-STATUS
STATUS		Numeric 1This field displays the status of the transaction.
  • 0 Open
  • 1 Closed
  • 2 Paid
  • 3 Not Paid
  • 4 Not Earned
  • 5 Terminated
—
#DUE-REMAINING-AMT
REMAINING_AMT		DerivedThe remaining rebate amount to be paid.—
#DUE-CURR-PURCHASES
CURR_PURCHASES		Signed 18.2Contains the current purchases amount and is entered in CM. It is not entered, updated or displayed outside on CM.—
#DUE-REBATE-AMT
REBATE_AMT		Signed 18.2This 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
GROWTH_PERCENT		Signed 6.3——
#DUE-CURR-BASE-PUR
CURR_BASE_PUR		Signed 18.2This 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
REB_EXP_DATE		Numeric 8 (yyyymmdd)——

Indexes (1)

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
DUESET1
  1. CONTRACT-GROUP
  2. CM-CONTRACT
  3. REBATE-TYPE
  4. DUE-DATE
PrimaryAP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
PocontgrpPOCONTGRPRequired
DUE-CONTRACT-GROUP→CNG-CONTRACT-GROUP
PocontractPOCONTRACTRequired
DUE-CONTRACT-GROUP→CMH-CONTRACT-GROUP
DUE-CM-CONTRACT→CMH-CM-CONTRACT
PocontrebPOCONTREBRequired
DUE-CONTRACT-GROUP→REB-CONTRACT-GROUP
DUE-CM-CONTRACT→REB-CM-CONTRACT
DUE-REBATE-TYPE→REB-REBATE-TYPE

One to many (1) — child tables

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

Programs

Updated by (36)