POREBDIST

This table contains the accounting information for Contract Management rebates that have been received. These rebates can be received as non-AR cash payments, AP credit memos or CB cash receipt deposits.
UPDATED BY
AP125 AP126 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.1 AP30.2 AP30.4 API1.1
CB10.1 CB10.5 CB150 CB180 CB191 CB43.1
CB46.1 CB543 CB544 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA44.1 MA44.2 MA540

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RDS-CONTRACT-GROUP
Element: Enterprise Grp
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-CM-CONTRACT
Element: Cm Contract
Numeric 15
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-REBATE-TYPE
Element: Rebate Type
Alpha 25
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-DUE-DATE
Element: Date
Numeric 8 (yyyymmdd)
The rebate transaction due date.
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-REBATE-SEQ
Element: Seq Number
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-DIST-SEQ-NBR
Element: 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-COMPANY
Element: 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-AR-BATCH-NBR
Element: 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-AR-INVOICE
Element: 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-API-OBJ-ID
Element: 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-CB-CASH-CODE
Element: 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-CB-BANK-INST
Element: Bank Inst Code
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-CB-TRANS-NBR
Element: 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-DIST-COMPANY
Element: 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-ACCT-UNIT
Element: 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-ACCOUNT
Element: 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-SUB-ACCT
Element: 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-ACTIVITY
Element: 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-ACCT-CATEGORY
Element: 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-TRANS-AMOUNT
Element: Intl Amt
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-TRANS-CURR
Element: Currency Code
Alpha 5
Currency code for the transaction.
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-CONT-CURR-AMT
Element: Intl 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-CURR-RATE
Element: 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 MA540
RDS-CONT-COMPANY
Element: Company
Numeric 4
RDS-CONTRACT-DEPT
Element: Contract Dept
Alpha 15


POREBDIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RDSSET1 CONTRACT-GROUP
CM-CONTRACT
REBATE-TYPE
DUE-DATE
REBATE-SEQ
DIST-SEQ-NBR
...
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
RDSSET2 API-OBJ-ID
DIST-SEQ-NBR
Subset
WhereAPI-OBJ-ID !=Zeroes
...
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
RDSSET3 COMPANY
AR-BATCH-NBR
AR-INVOICE
DIST-SEQ-NBR
Subset
WhereAR-INVOICE !=Spaces
...
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4
RDSSET4 CB-CASH-CODE
CB-BANK-INST
CB-TRANS-NBR
DIST-SEQ-NBR
Subset
WhereCB-TRANS-NBR !=Spaces
...
AP125 AP126
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.1 AP30.2
AP30.4 API1.1
CB10.1 CB10.5
CB150 CB180
CB191 CB43.1
CB46.1 CB543
CB544 MA41.1
MA41.2 MA41.4


POREBDIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Thu Jun 09 02:27:27 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.