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.

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

IndexKeysFlagsConditionUsed in
REBSET1CONTRACT-GROUP, CM-CONTRACT, REBATE-TYPEPrimaryAP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)
REBSET2CONTRACT-GROUP, VENDOR, CM-CONTRACT, REBATE-TYPE—

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
ApvenmastAPVENMASTRequiredPCG-VENDOR-GROUP → VEN-VENDOR-GROUP (VENSET1), REB-VENDOR → VEN-VENDOR
PocontgrpPOCONTGRPRequiredREB-CONTRACT-GROUP → CNG-CONTRACT-GROUP
PocontractPOCONTRACTRequiredREB-CONTRACT-GROUP → CMH-CONTRACT-GROUP, REB-CM-CONTRACT → CMH-CM-CONTRACT
ProcuregrpPROCUREGRPRequiredREB-CONTRACT-GROUP → PCG-PROCURE-GROUP

Programs

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