POREBDIST – No description in the Lawson data dictionary

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

POREBDIST is a Lawson Purchase Order table (prefix RDS); no description in the lawson data dictionary. It is indexed by CONTRACT-GROUP, CM-CONTRACT, REBATE-TYPE, DUE-DATE, REBATE-SEQ, DIST-SEQ-NBR (RDSSET1); alternate indexes: RDSSET2, RDSSET3 and RDSSET4. It is related 1:1 to ACACCTCAT, ACACTIVITY, APDISTRIB, ARDISTRIB, CBRECPTDTL, GLMASTER, GLSYSTEM, POCONTGRP and 3 more. It is updated by AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 and 28 more. The table has 25 fields, 4 indexes and 11 documented relations.

About POREBDIST

No description in the Lawson data dictionary.

Fields (25)

Column = COBOL field name without the RDS- 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
#RDS-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
#RDS-CM-CONTRACT PK
CM_CONTRACT		Numeric 15—AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RDS-REBATE-TYPE PK
REBATE_TYPE		Alpha 25—AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RDS-DUE-DATE PK
DUE_DATE		Numeric 8 (yyyymmdd)The rebate transaction due date.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RDS-REBATE-SEQ PK
REBATE_SEQ		Numeric 6This is the sequence number on the corresponding POREBRECD table entry.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RDS-DIST-SEQ-NBR PK
DIST_SEQ_NBR		Numeric 6A unique sequence number for the rebate distribution. This number will be the same as corresponding distributions in the APDISTRIB, ARDISTRIB and CBRECPTDTL tablesAP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RDS-COMPANY SET3
COMPANY		Numeric 4The company assigned to the distribution. This may be different from the company assigned to the transaction if an intercompany relationship is system.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RDS-AR-BATCH-NBR SET3
AR_BATCH_NBR		Numeric 6The batch number associated with the AR transaction distribution.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RDS-AR-INVOICE SET3
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
#RDS-API-OBJ-ID SET2
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
#RDS-CB-CASH-CODE SET4
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
#RDS-CB-BANK-INST SET4
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
#RDS-CB-TRANS-NBR SET4
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
#RDS-DIST-COMPANY
DIST_COMPANY		Numeric 4The distribution company assigned to the rebate distribution. Must be a valid record in the General Ledger Company file and a valid relationship record must exist in the Intercompany Relationship file.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RDS-ACCT-UNIT
ACCT_UNIT		Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RDS-ACCOUNT
ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RDS-SUB-ACCT
SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RDS-ACTIVITY
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RDS-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruAP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RDS-TRANS-AMOUNT
TRANS_AMOUNT		Signed 18.2Total rebate distribution amount received in the transaction currency. The currency rate will be stored on the corresponding POREBRECD table entry for conversion to the contract currency.AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
#RDS-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
#RDS-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
#RDS-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
#RDS-CONT-COMPANY
CONT_COMPANY		Numeric 4——
#RDS-CONTRACT-DEPT
CONTRACT_DEPT		Alpha 15——

Indexes (4)

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
RDSSET1
  1. CONTRACT-GROUP
  2. CM-CONTRACT
  3. REBATE-TYPE
  4. DUE-DATE
  5. REBATE-SEQ
  6. DIST-SEQ-NBR
PrimaryAP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)
RDSSET2
  1. API-OBJ-ID
  2. DIST-SEQ-NBR
SubsetWhere API-OBJ-ID != ZeroesAP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)
RDSSET3
  1. COMPANY
  2. AR-BATCH-NBR
  3. AR-INVOICE
  4. DIST-SEQ-NBR
SubsetWhere AR-INVOICE != SpacesAP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)
RDSSET4
  1. CB-CASH-CODE
  2. CB-BANK-INST
  3. CB-TRANS-NBR
  4. DIST-SEQ-NBR
SubsetWhere CB-TRANS-NBR != SpacesAP125, 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)
ACACCTCATACACTIVITYAPDISTRIBARDISTRIBCBRECPTDTLGLMASTERGLSYSTEMPOCONTGRPPOCONTRACTPOCONTREBPOREBDUEPOREBDIST

One to one (11) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATRequired
RDS-ACCT-CATEGORY→AAX-ACCT-CATEGORY
AcactivityACACTIVITYRequired
RDS-ACTIVITY→ACV-ACTIVITY
ApdistribAPDISTRIBRequiredWhen RDS-API-OBJ-ID != Zeroes
RDS-API-OBJ-ID→APD-API-OBJ-ID
RDS-DIST-SEQ-NBR→APD-DIST-SEQ-NBR
ArdistribARDISTRIBRequiredWhen RDS-AR-INVOICE != Spaces
RDS-COMPANY→AMD-COMPANY
RDS-AR-BATCH-NBR→AMD-BATCH-NBR
"N"→AMD-TRANS-TYPE
RDS-AR-INVOICE→AMD-INVOICE
Spaces→AMD-CUSTOMER
RDS-DIST-SEQ-NBR→AMD-DIST-SEQ
CbrecptdtlCBRECPTDTLRequired
RDS-CB-CASH-CODE→CBA-CASH-CODE
RDS-CB-BANK-INST→CBA-BANK-INST-CODE
RDS-CB-TRANS-NBR→CBA-TRANS-NBR
RDS-DIST-SEQ-NBR→CBA-SEQ-NBR
GlmasterGLMASTERRequired
RDS-DIST-COMPANY→GLM-COMPANY
RDS-ACCT-UNIT→GLM-ACCT-UNIT
RDS-ACCOUNT→GLM-ACCOUNT
RDS-SUB-ACCT→GLM-SUB-ACCOUNT
GlsystemGLSYSTEMRequired
RDS-DIST-COMPANY→GLS-COMPANY
PocontgrpPOCONTGRPRequired
RDS-CONTRACT-GROUP→CNG-CONTRACT-GROUP
PocontractPOCONTRACTRequired
RDS-CONTRACT-GROUP→CMH-CONTRACT-GROUP
RDS-CM-CONTRACT→CMH-CM-CONTRACT
PocontrebPOCONTREBRequired
RDS-CONTRACT-GROUP→REB-CONTRACT-GROUP
RDS-CM-CONTRACT→REB-CM-CONTRACT
RDS-REBATE-TYPE→REB-REBATE-TYPE
PorebduePOREBDUERequired
RDS-CONTRACT-GROUP→DUE-CONTRACT-GROUP
RDS-CM-CONTRACT→DUE-CM-CONTRACT
RDS-REBATE-TYPE→DUE-REBATE-TYPE
RDS-DUE-DATE→DUE-DUE-DATE

Programs

Updated by (36)