POCONTREB – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
REB
Primary key
CONTRACT-GROUP, CM-CONTRACT, REBATE-TYPE
Fields
15
Updated by
0 programs
Referenced by
0 programs

POCONTREB is a Lawson Purchase Order table (prefix REB); no description in the lawson data dictionary. It is indexed by CONTRACT-GROUP, CM-CONTRACT, REBATE-TYPE (REBSET1); alternate indexes: REBSET2. It is related 1:1 to APVENMAST, POCONTGRP, POCONTRACT and PROCUREGRP. The table has 15 fields, 2 indexes and 4 documented relations.

About POCONTREB

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the REB- 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
#REB-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.—
#REB-CM-CONTRACT PK
CM_CONTRACT		Numeric 15——
#REB-REBATE-TYPE PK
REBATE_TYPE		Alpha 25——
#REB-VENDOR SET2
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.—
#REB-STATUS
STATUS		Numeric 1—
  • 0 Active
  • 1 Inactive
—
#REB-LINE-OVERRIDES
LINE_OVERRIDES		Alpha 1—
  • Y Yes
  • N No
—
#REB-FRST-RB-DUE-DT
FRST_RB_DUE_DT		Numeric 8 (yyyymmdd)This is the first rebate due date.—
#REB-LST-CN-REB-QLF
LST_CN_REB_QLF		Numeric 6This is the last contract rebate qualifier sequence number.—
#REB-TOTAL-EXP-AMT
TOTAL_EXP_AMT		Signed 18.2This is the total expected rebate amount.—
#REB-REB-FREQUENCY
REB_FREQUENCY		Numeric 1—
  • 1 Annual
  • 2 BiAnnual
  • 3 Quarterly
  • 4 BiMonthly
  • 5 Monthly
  • 6 OneTime
  • 7 SemiAnnual
—
#REB-REB-PERCENT
REB_PERCENT		Signed 6.3This field contains the rebate percent and is entered in CM. It is not modified or displayed outside of CM.—
#REB-CURR-BASE-PUR
CURR_BASE_PUR		Signed 18.2——
#REB-CALC-GROWTH-RB
CALC_GROWTH_RB		Numeric 1—
  • 0 No
  • 1 Yes
—
#REB-LST-GROWTH-QLF
LST_GROWTH_QLF		Numeric 6——
#REB-QUAL-CHANGE-FL
QUAL_CHANGE_FL		Alpha 1—
  • N No qualifier changes
  • Y Yes - a qualifier has changed
—

Indexes (2)

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

Relations

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

One to one (4) — lookups and parents

RelationTableRulesConditionField map
ApvenmastAPVENMASTRequired
PCG-VENDOR-GROUP→VEN-VENDOR-GROUP (VENSET1)
REB-VENDOR→VEN-VENDOR
PocontgrpPOCONTGRPRequired
REB-CONTRACT-GROUP→CNG-CONTRACT-GROUP
PocontractPOCONTRACTRequired
REB-CONTRACT-GROUP→CMH-CONTRACT-GROUP
REB-CM-CONTRACT→CMH-CM-CONTRACT
ProcuregrpPROCUREGRPRequired
REB-CONTRACT-GROUP→PCG-PROCURE-GROUP

Programs

No Lawson programs are documented as updating or referencing this table.