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.

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

IndexKeysFlagsConditionUsed in
DUESET1CONTRACT-GROUP, CM-CONTRACT, REBATE-TYPE, DUE-DATEPrimaryAP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
PocontgrpPOCONTGRPRequiredDUE-CONTRACT-GROUP → CNG-CONTRACT-GROUP
PocontractPOCONTRACTRequiredDUE-CONTRACT-GROUP → CMH-CONTRACT-GROUP, DUE-CM-CONTRACT → CMH-CM-CONTRACT
PocontrebPOCONTREBRequiredDUE-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
PorebrecdPOREBRECDDUE-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)