Bc-Pro docs

Appearance

Return to top
On this page

Articles

In Bcpro all items that you can add to an order or invoice are saved in articles. This can be a product, the cost of a specific work(M.O.I), text(REM.),...

REST API 

GET /article
GET /articles

GraphQL 

query {
  article {
    COD
  }
}

query {
  articles {
    COD
  }
}

Return

/article 

{
  "data": {
      {
        "COD": "001"
      },
  }
}

/articles 

{
  "data": {
    "articles": [
      {
        "COD": "001"
      },
      {
        "COD": "002"
      },
		...
    ]
  }
}

Important fields

COD string(20)
Primary key of the article.

CATEG string(15)
Foreign key of the category.

LIB1_F + LIB2_F string(99) each
Description in french.

LIB1_D + LIB2_D string(99) each
Description in german.

LIB1_E + LIB2_E string(99) each
Description in english.

LIB1_N + LIB2_N string(99) each
Description in dutch.

DESI string(66)
Internal description.

STOCK1 integer
Number of articles in stock.

STOCK_RESERVE1 integer
Number of articles that are reserved.

STOCK1 - STOCK_RESERVE1 to get the real stock

Don't bother with STOCK2-9

PV_BASE PV1 PV2 PV3 decimal(12,4)
Price of an article. Usually PV_BASE is the default one. (depends on the client)

The Article Object 

{
  "IMAGE": "iVBORw0KGgoAAAANSUhEUgAAAMgAAAC0CAYAAADRuGMkAADYB...",
  "COD": "74075",
  "DESI": "HP ProBook 470 G7 (i5 - 8GB - 256 GB SSD)",
  "LIB1_F": "HP ProBook 470 G7 (i5 - 8GB - 256 GB SSD)",
  "LIB2_F": " ",
  "LIB1_D": "HP ProBook 470 G7 (i5 - 8GB - 256 GB SSD)",
  "LIB2_D": " ",
  "LIB1_E": "HP ProBook 470 G7 (i5 - 8GB - 256 GB SSD)",
  "LIB2_E": " ",
  "LIB1_N": "HP ProBook 470 G7 (i5 - 8GB - 256 GB SSD)",
  "LIB2_N": " ",
  "CATEG": "740",
  "STAT_EXPORT": "84713000",
  "FOU": "216",
  "REF_FOU": " ",
  "DEL_LIVR": 10,
  "NBR_EMBAL_UA": 1,
  "MESU": " ",
  "U_E_A": 1,
  "U_E_V": 1,
  "TVA": "21",
  "DEV_PA": "EUR",
  "PA_BRUT": 1200,
  "REMISE1": 0,
  "REMISE2": 0,
  "PV_BASE": 1200,
  "REMISE_PV_BASE": 0,
  "PV1": 1200,
  "PV2": 0,
  "PV3": 0,
  "PV1_DEV2": 0,
  "PV2_DEV2": 0,
  "PV3_DEV2": 0,
  "O_N_ETIQUETTE": "O",
  "GESTION_STOCK": "O",
  "O_N_STAT_DETAIL": "N",
  "SEUIL_POUR_CMDE": 0,
  "ASSORTIMENT": "1",
  "STOCK1": 3,
  "STOCK2": 0,
  "STOCK3": 0,
  "STOCK4": 0,
  "STOCK5": 0,
  "STOCK6": 0,
  "STOCK7": 0,
  "STOCK8": 0,
  "STOCK9": 0,
  "STOCK_RESERVE1": 0,
  "STOCK_RESERVE2": 0,
  "STOCK_RESERVE3": 0,
  "STOCK_RESERVE4": 0,
  "STOCK_RESERVE5": 0,
  "STOCK_RESERVE6": 0,
  "STOCK_RESERVE7": 0,
  "STOCK_RESERVE8": 0,
  "STOCK_RESERVE9": 0,
  "TARIF_DFT_SPEC": "D",
  "PA_PV1": " ",
  "PA_PV2": " ",
  "PA_PV3": " ",
  "PA_PV4": " ",
  "PA_PV5": " ",
  "PA_PV6": " ",
  "PA_PV7": " ",
  "PA_PV8": " ",
  "PA_PV9": " ",
  "VAL1": 0,
  "VAL2": 0,
  "VAL3": 0,
  "VAL4": 0,
  "VAL5": 0,
  "VAL6": 0,
  "VAL7": 0,
  "VAL8": 0,
  "VAL9": 0,
  "POURC1": 0,
  "POURC2": 0,
  "POURC3": 0,
  "POURC4": 0,
  "POURC5": 0,
  "POURC6": 0,
  "POURC7": 0,
  "POURC8": 0,
  "POURC9": 0,
  "REM": null,
  "REMISE_MAX_CV": 0,
  "BARCODE": "1947216672678",
  "COD_ABREGE": " ",
  "MESU_DIM": " ",
  "DIM1": 0,
  "DIM2": 0,
  "DIM3": 0,
  "MESU_POIDS": " ",
  "POIDS": 0,
  "MESU_VOL": " ",
  "VOL": 0,
  "NBR_HEURE": 0,
  "NBR_MIN": 0,
  "CALC_PRIX": " ",
  "POURC_PV2": 0,
  "VAL_PV2": 0,
  "POURC_PV3": 0,
  "VAL_PV3": 0,
  "DAT_MAJ": "2020-02-12T00:00:00.000Z",
  "O_N_STOCK_CLI": "N",
  "LOCALISATION": " ",
  "SEUIL_REAPPRO": 0,
  "O_N_BLOQUE": "N",
  "PR": 0,
  "OPT1": " ",
  "OPT2": " ",
  "OPT3": " ",
  "OPT4": " "
}