1. Home
  2. /
  3. Setup Guides
  4. /
  5. Financials
  6. /
  7. Financials interface environment
  8. /
  9. Fields in the transfer...
  10. /
  11. Fields in SROLBAL

Fields in SROLBAL

Related topics

The following fields exist in SROLBAL:

Field Length Description
BLLIRE 15,0 A/P invoice line ref no (Text in file: A/P invoice line ref no). Mandatory. This is the link to the invoice in SROLBA, field BTLIRE.
BLILIN 5,0 Invoice line number (Text in file: Invoice line number). Mandatory. Must be unique within one invoice, e.g. 10, 20, 30, etc.
BLILTY 3,0 A/P invoice line type (Text in file: A/P invoice line type). Mandatory.

0 = Item line
1-99 = Additional cost line, e.g. freight, etc.
932 = Landed cost line

For MDC automatic A/P invoice matching the following values will be used for the fees on the invoice:

Fee Value
Freight 21
Postage 22
Insurance 23
Administration fee 24
Invoice fee 25
Coin adjustment 29
BLLCTY 5 Landed cost type (Text in file: Landed cost type). Mandatory if line type (BLILTY) is 932. If completed, it is validated against the Landed cost type table.
BLORNO 12,0 Order number (Text in file: Order number). Mandatory/Not allowed. Mandatory if line type (BLILTY) is 0 or 932.
BLLINE 5,0 Order line number (Text in file: Order line number). Mandatory/Not allowed. Mandatory if line type (BLILTY) is 0 or 932.
BLLAMT 17,3 Line net amt trans curr VAT ex (Text in file: Line net amt trans curr VAT ex). Mandatory. This is the total net line amount VAT excluded. Same currency as the invoice.
BLINVQ 15,3 Invoiced quantity (Text in file: Invoice quantity).

Item = Mandatory
Additional cost line = 0
Landed cost = 1

BLHQTY 15,3 Used quantity (Text in file: Used quantity). Optional, will be set equal to invoiced quantity when left blank. Invoiced quantity cannot exceed used quantity.
BLFTX1 70 Free text 1 (Text in file: Free text 1). Optional.
BLFTX2 70 Free text 2 (Text in file: Free text 2). Optional.
BLFTX3 70 Free text 3 (Text in file: Free text 3). Optional.
BLDIM1 20 Account part 1 (Text in file: Account part 1). Mandatory/Not allowed. Mandatory if line type (BLILTY) is set to 1-99 and BLPSAC is blank. Validated against the Account file. Not allowed if line type (BLILTY) is set to 0 or 932. Note: This information is applicable to all the account parts below that are in use.
BLDIM2 20 Account part 2 (Text in file: Account part 2).
BLDIM3 20 Account part 3 (Text in file: Account part 3).
BLDIM4 20 Account part 4 (Text in file: Account part 4).
BLDIM5 20 Account part 5 (Text in file: Account part 5).
BLDIM6 20 Account part 6 (Text in file: Account part 6).
BLDIM7 20 Account part 7 (Text in file: Account part 7).
BLDIM8 20 Account part 8 (Text in file: Account part 8).
BLPSAC 7 Pseudo account (Text in file: Pseudo account). Mandatory/Not allowed. Mandatory if line type (BLILTY) is set to 1-99 and BLDIM1-8 is blank. Validated against the Pseudo account file. Not allowed if line type (BLILTY) is set to 0 or 932.
BLREDT 8,0 Received date (Text in file: Received date). Optional. Not validated. If zero, will be defaulted from the date of the retrieval.
BLCRDT 8,0 Creation date (Text in file: Creation date). Optional Not validated. If zero, will be defaulted from the date of the retrieval.
BLCOTI 6,0 Time (Text in file: Time). Optional. Not validated. If zero, will be defaulted from the date of the retrieval.
BLUSER 10 User id (Text in file: User id). Optional. Not validated. If zero, will be defaulted from the user who submitted the retrieval.
BLVAHC 4 VAT handling code (Text in file: Vat hndl code). Optional. Is used if only VAT on G/L level is active. If blank, the first VAT handling from the VAT catalogue defined for the main account code will be used.
BLTAXT 17,3 VAT amount in transaction curr (Text in file: VAT am trans curr). Optional. Is used if only VAT on G/L level is active. If blank, the amount will be calculated according to the rules for the VAT handling code in BLVAHC.

Related topics