SYNCBPCMVT: Forcing synchronization indexes for performances

Use this entry point to force the indexes to use in case of performance issues.

Context and operating mode

Transaction

There is no transaction in progress.

Log file

The log file is open.

Call context

The entry point is called before the first object to synchronize.

Available variables and masks

The [M :DIA] (BPCMVT) parameter entry mask is still available.

5 local variables of alphanumeric type are declared in order to indicate the index (HINT) to use for each object concerned by the processing:

  • SQH_HINT for quotes,
  • SOH_HINT for orders,
  • SDH_HINT for deliveries,
  • SIH_HINT for invoices and credit memos,
  • SRH_HINT for returns.

When necessary, indicate the HINT index to use in each case.

When there is not HINT index to indicate, the corresponding variable remains empty (default value). 

For example: Forcing the "SPE_ZSIH1" index on invoices (SIH object).

SIH_HINT = "SPE_ZSIH1"

Open tables

In the table below, the significant content flag indicates that the content matches the context (the current customer is loaded…). It is usually the case for the file containing the header, but not for the file containing the lines…

Table

Significant content

Table Title

SINVOICE

No

Invoice headers

SINVOICEV

No

Invoice header valuations

SDELIVERY

No

Delivery header

SDELIVERYD

No

Delivery line

SORDER

No

Order headers

BPCUSTOMER

No

Customers

BPCUSTMVT

No

Customer transactions

LASTCUSMVT 

No

 Last customer movements

SRETURN

No

 Return

SQUOTE

No

 Quote

SQUOTED

No

 Quote lines