Fields in SROKBCB

Related topics

The Cash book header interface file, SROKBCB is used to load the additional cash book related information to be associated to a SROKBPP payment. The document type indicated in the file should be a Cash book payment, which means the Liquid entry panel field value must be set to 8 for the document in the Document types table.

Field Length Description
CBERNS 1 External reference number series (Text in file: External reference number series) Mandatory The External reference number series together with the External liquid entry reference number uniquely identifies the Cash book header and links the connected payment(s) loaded into the SROKBPP file. One common External reference number series is foreseen to retrieve Liquid entry reference numbers and External reference numbers.
CBELER 15,00 External liquid entry reference number (Text in file: External liquid entry reference number) Mandatory. External liquid entry reference number togehter with the External reference number series uniquely identifies the Cash book header and links the connected payment(s) loaded into the SROKBPP file.
CBDOTY 3 Document type (Text in file: Document type) Mandatory, if not defined by the template applied for import. Document type valid for A/R Cash book transactions. It means the document must be defined with Liquid entry type 8 (Cash book) in the Document types table. It must be the same document type as the one loaded into the SROKBPP file for the payment(s) connected to this Cash book header record.
CBBKCO 3 Bank, company (Text in file: Bank, company ) Mandatory, if not defined by the template applied for import. Bank code is used to generate the pseudo account for Cash book automatic accounting. Cash book bank account defined in the Document types table for the applied Cash book document type is completed with the Bank code entered here
CBBCTR 17,03 Amount, bank currency (Text in file: Amount, bank currency) Mandatory. Bank amount is the amount that will be booked on the Cash book bank account. Currency for the Bank amount is the currency defined in the Account file for the Cash book bank account. If the currency for the account is not defined then it is the system currency.
CBSCTR 17,03 Amount, system currency (Text in file: Amount, system currency) Optional. If not entered will be calculated from Bank amount based on the provided Exchange rate information.
CBTREF 30 Transaction reference (Text in file: Transaction reference) Mandatory. Transaction reference that will be used for Cash book reconciliation.
CBRSCD 4 Cash Book Reason Code (Text in file: Cash Book Reason Code) Mandatory, if not defined by the template applied for import. Cash book reason code defined in the Cash book reason codes table.
CBVADT 8,00 Value date (Text in file: Value date) Mandatory, if not defined by the template applied for the import. Value date for the Cash book transaction.

The Exchange rate time (CBTIML) field value, if not entered, will be defaulted based on the Value date and the provided exchange rate period type (CBTYPC)

CBTTXT 30 Transaction text (Text in file: External reference number series) Optional Transaction text, if not provided, will be defaulted with the Document type text.
CBTIML 8,00 Exchange rate time (Text in file: Exchange rate time) Optional This field is used to give the exchange rate system time interval from which the transaction exchange should be retrieved. The format required for this value is dependent on the Exchange rate period type code (PATYPC) value:

  • a. For 1: CCYYMMDD (day)
  • b. For 2: CCYYWW (week)
  • c. For 3: CCYYMM (month)
  • d. For 4: CCYY (year)
  • e. For 5: *zero (fixed)

If zero the interval will be calculated from the Value date (CBVADT) for the given Exchange rate period type (CBTYPC).

CBTYPC 1,00 Exchange rate period (Text in file: Exchange rate period) Mandatory, if not defined by the template applied for import. This value determines the format of the current record Exchange rate period value (CBTIML). The following values are allowed:

  • 1: day
  • 2: week
  • 3: month
  • 4: year
  • 5: fixed rate used
CBCLVL 1 Exchange rate level code (Text in file: Exchange rate level code) Mandatory, if not defined by the template applied for import.

The following codes are valid:

  • H = High
  • M = Medium
  • L = Low
CBSTAT 1 Cash book interface status (Text in file: Cash book interface status) Not allowed.
CBERRC 2 Cash book error code (Text in file: Cash book error code) Not allowed.
CBERRD 2 Cash book detail error code (Text in file: Cash book detail error code) Not allowed.

Related topics