Price refund
This table is used to log reductions in purchase prices, for suppliers with a price refund agreement.
You can keep the rows as long as you desire. In addition to forming the basis for refunds, you can also use the table to illustrate the price history.
You enable the price refund agreement for a supplier by checking Price refund agreement in the Supplier options field in the Associate table. Reductions in purchase price after discount in percent and -amount are then automatically logged in the Price refund table when:
-
The Price- and discount matrix table is saved or edited, or
-
Values are imported using Overwrite stated fields in the Import dialog
You can also edit the table manually.
These rows are displayed in the Refund request report in the Associate table.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | PrRep | The table name in the database. |
| API identifier | priceRefund | The API identifier used in GraphQL. |
| Table no. | 179 | The table number in the data model. |
The following fields exist in this table:
Amount (dom.)
The price reduction after discount in the default currency.
This field is calculated from the values in the New disc. amount (dom.), New price (dom.), New disc. %, Prev. disc. amount (dom.), Previous price (dom.), Previous discount %, Unrealised stock inc. and Realised stock fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | DAm | The database field name. |
| API identifier | amountDomestic | The API identifier used in GraphQL. |
| Number | 6793 |
Amount
The price reduction after discount in current currency.
This field is calculated from the values in the New disc. amount, New price, New disc. %, Prev. disc. amount, Previous price, Previous discount %, Unrealised stock inc. and Realised stock fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Am | The database field name. |
| API identifier | amountInCurrency | The API identifier used in GraphQL. |
| Number | 6443 |
Currency no.
The currency valid for this price refund.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Currency no. | Integer |
| SQL name | Cur | The database field name. |
| API identifier | currencyNo | The API identifier used in GraphQL. |
| Number | 6788 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency |
|
Exchange rate
The exchange rate used for this price refund.
The value is retrieved from the Currency table. This field is used to calculate values in the default currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| SQL name | ExRt | The database field name. |
| API identifier | exchangeRate | The API identifier used in GraphQL. |
| Number | 6789 |
Gr. 1
A group to which the price refund belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price refund grouping 1 | Integer |
| SQL name | Gr | The database field name. |
| API identifier | group1 | The API identifier used in GraphQL. |
| Number | 6806 |
Gr. 2
A group to which the price refund belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price refund grouping 2 | Integer |
| SQL name | Gr2 | The database field name. |
| API identifier | group2 | The API identifier used in GraphQL. |
| Number | 6807 |
Inf. 1
Additional price refund information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf | The database field name. |
| API identifier | information1 | The API identifier used in GraphQL. |
| Number | 6808 |
Inf. 2
Additional price refund information.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf2 | The database field name. |
| API identifier | information2 | The API identifier used in GraphQL. |
| Number | 6809 |
Line no.
Each line in the table is given a consecutive number in the order in which they are entered.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Sup. no., Line no. |
| SQL name | LnNo | The database field name. |
| API identifier | lineNo | The API identifier used in GraphQL. |
| Number | 6437 |
New disc. %
The new percentage discount for the product.
When this field changes, the Amount and Amount (dom.) fields are recalculated.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | NewDcP | The database field name. |
| API identifier | newDiscountPercent | The API identifier used in GraphQL. |
| Number | 6801 |
New disc. amount
The new discount amount for the product in the current currency.
When this field changes, the Amount field is recalculated.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | NewDcAm | The database field name. |
| API identifier | newDiscountAmountInCurrency | The API identifier used in GraphQL. |
| Number | 6802 |
New disc. amount (dom.)
The new discount amount for the product in the default currency.
When this field changes, the Amount (dom.) field is recalculated.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | NewDcDAm | The database field name. |
| API identifier | newDiscountAmountDomestic | The API identifier used in GraphQL. |
| Number | 6803 |
New price
The new price of the product in the current currency.
When this field changes, the Amount field is recalculated.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Price | Decimal |
| SQL name | NewPrice | The database field name. |
| API identifier | newPriceInCurrency | The API identifier used in GraphQL. |
| Number | 6440 |
New price (dom.)
The new price of the product in the default currency.
When this field changes, the Amount (dom.) field is recalculated.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| SQL name | NewDPr | The database field name. |
| API identifier | newPriceDomestic | The API identifier used in GraphQL. |
| Number | 6791 |
New price after discount
The new price of the product after discount in the current currency.
This field is calculated from the New price, New disc. % and New disc. amount fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | newPriceAfterDiscountInCurrency | The API identifier used in GraphQL. |
| Number | 6796 |
New price after discount (dom.)
The new price of the product after discount in the default currency.
This field is calculated from the New price (dom.), New disc. % and New disc. amount (dom.) fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | newPriceAfterDiscountDomestic | The API identifier used in GraphQL. |
| Number | 6797 |
Prev. disc. amount
The previous value of the discount amount in the current currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | PreDcAm | The database field name. |
| API identifier | previousDiscountAmountInCurrency | The API identifier used in GraphQL. |
| Number | 6799 |
Prev. disc. amount (dom.)
The previous value of the discount amount in the default currency.
When this field changes, the Amount (dom.) field is recalculated.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | PreDcDAm | The database field name. |
| API identifier | previousDiscountAmountDomestic | The API identifier used in GraphQL. |
| Number | 6800 |
Prev. price after disc.
The previous price after discount in the current currency.
This field is calculated from the Previous price, Previous discount % and the Prev. disc. amount fields
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | previousPriceAfterDiscountInCurrency | The API identifier used in GraphQL. |
| Number | 6794 |
Prev. price after disc. (dom.)
The previous price after discount in the default currency.
This field is calculated from the Previous price (dom.), Previous discount % and the Prev. disc. amount (dom.) fields
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | previousPriceAfterDiscountDomestic | The API identifier used in GraphQL. |
| Number | 6795 |
Previous discount %
The previous percentage discount.
When this field changes, the Amount and Amount (dom.) fields are recalculated.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | PreDcP | The database field name. |
| API identifier | previousDiscountPercent | The API identifier used in GraphQL. |
| Number | 6798 |
Previous price
The previous value of the price in the current currency.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Price | Decimal |
| SQL name | PrePrice | The database field name. |
| API identifier | previousPriceInCurrency | The API identifier used in GraphQL. |
| Number | 6439 |
Previous price (dom.)
The previous value of the price in the default currency.
When this field changes, the Amount (dom.) field is recalculated.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| SQL name | PreDPr | The database field name. |
| API identifier | previousPriceDomestic | The API identifier used in GraphQL. |
| Number | 6790 |
Price protection proc.
Settings defining the behaviour of the price refund record.
The values are suggested from the Price protection proc. field in the Company information table.
Sales orders
- Update sales price
- Update cost price
Purchase orders
- Update purchase prices
- Update cost price
____
- Update shipments and produce transactions
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price protection proc. | Integer |
| SQL name | PrRepP | The database field name. |
| API identifier | priceProtectionProcessing | The API identifier used in GraphQL. |
| Number | 6805 |
Price reduction
The difference between value in the Prev. price after disc. field and the value in the New price after discount field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | priceReductionInCurrency | The API identifier used in GraphQL. |
| Number | 6441 |
Price reduction (dom.)
The difference between value in the Prev. price after disc. (dom.) field and the value in the New price after discount (dom.) field.
The field is updated when the values in the Prev. price after disc. (dom.) and New price after discount (dom.) fields changes.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | priceReductionDomestic | The API identifier used in GraphQL. |
| Number | 6792 |
Product no.
The product that this price refund record is valid for.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Product no. | Text (40) |
| SQL name | ProdNo | The database field name. |
| API identifier | productNo | The API identifier used in GraphQL. |
| Number | 6438 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product | Product |
| ||
| Search product | SearchProduct |
| ||
| Stock balance | StockBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Realised stock
The realised stock, which is the total of the records in the Shipment table for the supplier.
When this field changes, the Amount and Amount (dom.) fields are recalculated.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Bal | The database field name. |
| API identifier | realisedStock | The API identifier used in GraphQL. |
| Number | 6442 |
Refund no.
When you approve printed refund requests, a unique document number is inserted in this field.
The document number is fetched from the Next voucher no. field in the Voucher series table. The record to use from the Voucher series table is specified in the Refund series field in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | RepNo | The database field name. |
| API identifier | refundNo | The API identifier used in GraphQL. |
| Number | 6455 |
Refund status
The status of the price refund record.
- 1 - Requested
- This value is set on approval of printed refund requests
- 2 - Confirmed
- This value is set when running the Price refund confirmed processing.
- 3 - Refused
- This value is set when running the Price refund refused processing.
- 4 - Credit received
- This value is set when running the Credit received processing.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Refund status | Integer |
| SQL name | RepSt | The database field name. |
| API identifier | refundStatus | The API identifier used in GraphQL. |
| Number | 6444 |
Sort seq. no.
The order of the lines.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Sort seq. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Srt | The database field name. |
| API identifier | sortSequenceNo | The API identifier used in GraphQL. |
| Number | 6445 |
Sup. no.
The supplier that is connected to this price refund record.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Sup. no. | Integer |
| Primary key | Yes | Sup. no., Line no. |
| SQL name | SupNo | The database field name. |
| API identifier | supplierNo | The API identifier used in GraphQL. |
| Number | 6436 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Supplier |
|
Unrealised stock inc.
The unrealised stock increase, which is the total of the records in the Shipment table, for the specified supplier.
When this field changes, the Amount and Amount (dom.) fields are recalculated.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | StcInc | The database field name. |
| API identifier | unrealisedStockIncrease | The API identifier used in GraphQL. |
| Number | 6506 |
Warehouse no.
The warehouse where the specified product is located.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Warehouse no. | Integer |
| SQL name | Stc | The database field name. |
| API identifier | warehouseNo | The API identifier used in GraphQL. |
| Number | 6804 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Warehouse | Warehouse |
| ||
| Stock balance | StockBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Control columns
Control columns include information about who has changed the record last and when, and which process that is currently editing the record.
Changed by provenance
The provenance for the record change.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPvn | The database field name. |
| API identifier | changedByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed by user
The name of the user that changed the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChUsr | The database field name. |
| API identifier | changedByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed date
The date when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChDt | The database field name. |
| API identifier | changedDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time
The time when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTm | The database field name. |
| API identifier | changedTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time stamp
The date and time when the record was changed.
The field is updated with the UTC time.
This value can be used by external systems to replicate changed data. The column is indexed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTs | The database field name. |
| API identifier | changedTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by provenance
The provenance for the record creation.
A look-up in this field gives you the following list of possible values:
0 - None
1 - UI
10 - External API
20 - GAiA
21 - AI Connect
100 - Internal service
101 - Task automation
102 - AutoInvoice download
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CrePvn | The database field name. |
| API identifier | createdByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by user
The name of the user that created the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreUsr | The database field name. |
| API identifier | createdByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created date
The date when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreDt | The database field name. |
| API identifier | createdDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time
The time when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTm | The database field name. |
| API identifier | createdTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time stamp
The date and time when the record was created.
The field is updated with the UTC time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTs | The database field name. |
| API identifier | createdTimestamp | The API identifier used in GraphQL. |
| Number | A unique column number. |
Edit status
The current status of the record.
A look-up in this field gives you the following list of possible values:
0 - Unchanged: The record is read, but not changed.
1 - Inserted: The record is new.
2 - Changed: The record is changed.
3 - Deleted: The record is deleted.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Edit status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LckSt | The database field name. |
| API identifier | editStatus | The API identifier used in GraphQL. |
| Number | A unique column number. |
Process no
The Process no. from the Active company process table which is currently using or has control of this record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Process no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPrc | The database field name. |
| API identifier | lockedByProcessNo | The API identifier used in GraphQL. |
| Number | A unique column number. |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Active company process | CompanyProcess | Process no. | Process no. |