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.

Field / column	Type	Description & values	Updated by
`RDS-CONTRACT-GROUP` PK CONTRACT_GROUP	Alpha 4	This 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 6	This 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 6	A unique sequence number for the rebate distribution. This number will be the same as corresponding distributions in the APDISTRIB, ARDISTRIB and CBRECPTDTL tables	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
`RDS-COMPANY` COMPANY	Numeric 4	The 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` AR_BATCH_NBR	Numeric 6	The 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` AR_INVOICE	Alpha 22	This 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` API_OBJ_ID	Numeric 12	A 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` CB_CASH_CODE	Alpha 4	The 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` CB_BANK_INST	Alpha 3	The 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` 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 4	The 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 15	The 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 6	This 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 4	This 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 15	Activities 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 5	Account 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 thru	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +28 more
`RDS-TRANS-AMOUNT` TRANS_AMOUNT	Signed 18.2	Total 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 5	Currency 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.2	Total 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.7	The 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`RDSSET1`	`CONTRACT-GROUP`, `CM-CONTRACT`, `REBATE-TYPE`, `DUE-DATE`, `REBATE-SEQ`, `DIST-SEQ-NBR`	Primary		AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)
`RDSSET2`	`API-OBJ-ID`, `DIST-SEQ-NBR`	Subset	Where API-OBJ-ID != Zeroes	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)
`RDSSET3`	`COMPANY`, `AR-BATCH-NBR`, `AR-INVOICE`, `DIST-SEQ-NBR`	Subset	Where AR-INVOICE != Spaces	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)
`RDSSET4`	`CB-CASH-CODE`, `CB-BANK-INST`, `CB-TRANS-NBR`, `DIST-SEQ-NBR`	Subset	Where CB-TRANS-NBR != Spaces	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)

Relations

One to one (11) — lookups and parents

Relation	Table	Rules	Condition	Field map
Acacctcat	ACACCTCAT	Required		`RDS-ACCT-CATEGORY` → `AAX-ACCT-CATEGORY`
Acactivity	ACACTIVITY	Required		`RDS-ACTIVITY` → `ACV-ACTIVITY`
Apdistrib	APDISTRIB	Required	When RDS-API-OBJ-ID != Zeroes	`RDS-API-OBJ-ID` → `APD-API-OBJ-ID`, `RDS-DIST-SEQ-NBR` → `APD-DIST-SEQ-NBR`
Ardistrib	ARDISTRIB	Required	When 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`
Cbrecptdtl	CBRECPTDTL	Required		`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`
Glmaster	GLMASTER	Required		`RDS-DIST-COMPANY` → `GLM-COMPANY`, `RDS-ACCT-UNIT` → `GLM-ACCT-UNIT`, `RDS-ACCOUNT` → `GLM-ACCOUNT`, `RDS-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Glsystem	GLSYSTEM	Required		`RDS-DIST-COMPANY` → `GLS-COMPANY`
Pocontgrp	POCONTGRP	Required		`RDS-CONTRACT-GROUP` → `CNG-CONTRACT-GROUP`
Pocontract	POCONTRACT	Required		`RDS-CONTRACT-GROUP` → `CMH-CONTRACT-GROUP`, `RDS-CM-CONTRACT` → `CMH-CM-CONTRACT`
Pocontreb	POCONTREB	Required		`RDS-CONTRACT-GROUP` → `REB-CONTRACT-GROUP`, `RDS-CM-CONTRACT` → `REB-CM-CONTRACT`, `RDS-REBATE-TYPE` → `REB-REBATE-TYPE`
Porebdue	POREBDUE	Required		`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)

AP125 Batch Release
AP126 Mass Invoice Release
AP20.1 Basic Invoice
AP20.2 Taxed Invoice
AP20.3 Detail Invoice
AP20.4 Invoice Line Detail
AP20.5 Multiple Invoice
AP20.7 Distributions
AP21.1 View Distributions
AP23.1 Transit Invoice Entry
AP25.1 Batch Control
AP25.2 Batch Review
AP26.1 Invoice Release
AP27.1 Single Invoice Release
AP30.1 Invoice Maintenance
AP30.2 Distribution Adjustments
AP30.4 Invoice Cancel
API1.1 Add Invoice
CB10.1 Cash Receipt Deposit
CB10.5 Cash Receipt Detail Rebate Option
CB150 Mass Release
CB180 Cash Ledger Void Update
CB191 Bank Statement Close
CB43.1 Receipts Load Maintenance
CB46.1 Returned Payment Entry
CB543 Receipts Load
CB544 Returned Payment Load
MA41.1 Add-On Cost Detail - Purchase Order
MA41.2 Add On Cost Lookup
MA41.4 Miscellaneous Add-On Cost
MA41.7 AOC Approval Entry
MA42.2 Memo Line AOC Detail
MA43.2 Purchase Order Lookup
MA44.1 Invoice Line Detail - Purchase Order
MA44.2 Invoice Line Detail- Service
MA540 Invoice Interface