Ansicht
Dokumentation

RFKKBE_OPI2 - Belgium: Open Items of Foreign Customers (from 2002)

Description

Belgium: Open Items for Foreign Customers

This program creates the BLIW report from the open items of all foreign customers. These reports have to be sent to the IBLC/BLIW Institute monthly.

Only the report for report type '90' is supported. You can select these items via the business area or the industry.

Output

1. Total per currency/country (group)
   
   For each company code, the report creates a cover and a table in accordance with the official format.
   Each program run is for companies in Luxemburg or Belgium. (You can select this using corresponding parameters).
   The first column always contains BEF/LUF documents. The last column 'OTH' contains the values in local currency (BEF or LUF) of all currencies that are not listed separately.
   In the detail reports these values are repeated in BEF and LUF and the original currency is also displayed.
   The ISO country codes are also printed; for the groups (01.. 12), the values are as follows (orignal country displayed on detailed report):
   01:
   AM, AZ, BY, KZ, KG, MD, RU, TJ, TM, UA, UZ
   02:
   AL, BA, BG, HR, CZ, EE, HU, LT, MK, PL, RO, SK, SI, LV
   03:
   AD, CY, GI, LI, MT, MC, SM, VA
   04:
   EC, VE
   05:
   DZ, GA, LY, NG
   06:
   IR, IQ, KW, GA, SA, AE
   07:
   AI, AW, BS, BM, BO, BR, VG, KY, CL, CO, CR, CU, SV, GT, HN, AN, NI, PA, PE, TC, AG, AR, BB, BZ, DM, DO, FK, GD, GY, HT, JM, PY, KN, LC, VC, SR, TT, UY, VI
   08:
   BJ, BF, CM, CV, CF, TD, EG, GM, GH, CI, LR,
   ML, MR, MA, NG, SN, SL, SD, TG, TN, ZR, AO, IO, BI, KM, CG, DJ, GQ, ET, KE, MG, MW, MV, MZ, RW, ST, SC, SO, SH, TZ, UG, ZW, ZM
   09:
   AF, BH, BD, BT, BN, KH, CN, GE, IN, IL, JO, LA,
   LB, MV, MN, MM, NP, KP, OM, PK, LK, SY, VN, YE
   10:
   UM, AU, FJ, KI, NR, UM, NZ, PG, PN, PL, SB, TO, TU, VU, WS
   11:
   HK, TW, KR
   12:
   MY, PH, TH
   
2. Detailed List with all Selected Items
   
   The report issues a total amount per currency.
   The detailed list shows the values of the selected documents in the document currency. The table contains the values in the corresponding currency in units of 1000. Amounts that are smaller than 1000 units are therefore only displayed in the detailed list, in the table they have the value 0.

Terms of Delivery:

On the cover sheet of the report, enter the estimated percentage value of the terms of delivery in the corresponding parameters.
The total value is compared with 100%.

Settings Required

1. ISO codes used:
Country codes (country table)
Currency codes (currency definition table)
2. Company code, address, and tax number must be available (global
parameters of the company code)