MoversSuite internally stores the source information of the rating utilized when creating billing transactions. This includes transactions created for all revenue billing items, invoices, and quotes. This information assists third-party companies with electronic data interchange (EDI) billing for revenue generated within MoversSuite.
The application stores information on whether the rates are pulled from a Rate Plan or from a Rate Matrix. It also stores the internal identifier for the specific rate referenced from either source.
Two fields store the rating information of an item:
RateSource
This field stores the type of rating being referenced as either Rates or RateMatrixRate. Rates references rating details associated to a Rate Plan Setup record, whereas RateMatrixRate references a Rate Matrix Setup record. The specific record is identified within the RateSourceRecord field.
RateSourceRecord
References the primary table identifier based on the RateSource. If the RateSource is Rates, then this field references the primary key of the Rates table (Rates.RPriKey). If the RateSource is RateMatrixRate, then this field references the primary key of the RateMatrixRate table (RateMatrixRate.RateMatrixRateID).
These two fields are found in each of the following tables:
BillingMajorItem
BillingMinorItem
InvoiceDetail
InvoiceGroup
QuoteDetail
QuoteGroup
RELATED TOPICS:
Military EDI Invoice Integration