Financial Item API

The Financial Item API is where products are stored for marketplaces such as Lazada, Shopee, CpCommerce, or any other e-commerce platform. For any item to be created or synced from the marketplace to the Bigledger (BLG) database—or vice versa—it must first be created within the Financial Item section, either through the Financial Item API or the Doc Item Maintenance Applet.

Key Tables Involved

• bl_fi_mst_item_hdr

  • Contains details of the item.

  • The child item of the group item is considered a single product (basic item).

• bl_fi_mst_item_ext

  • Stores extra information that is not stored in the header or line.

• bl_fi_mst_item_line

  • Stores child items after they are created in the header table as a single product.

  • Links the child item to the specific group product.

Chapters

Create Financial Item

This chapter details how to create a new financial item in the system.

Update Financial Item

This chapter provides information on updating an existing financial item.

Get All Financial Items

Learn how to retrieve all financial items from the system.

Get Financial Item by GUID

This section explains how to retrieve a financial item using its unique GUID (Globally Unique Identifier).

Get Financial Item by Criteria

Here, you will find instructions for retrieving financial items based on specific criteria.

Delete Financial Item

This chapter explains the process of deleting a financial item by its GUID.

Get All Financial Item Extensions

Retrieve all extensions linked to financial items in the system.

Create Financial Item Extension

Learn how to create extensions for a financial item.

Update Financial Item Extension

Find out how to update an existing financial item extension.

Get Financial Item Extension by GUID

This chapter covers how to retrieve financial item extensions by their GUID.

Delete Financial Item Extension

Learn the process to delete a financial item extension using its GUID.

Get All Financial Item Lines

Retrieve all lines linked to financial items.

Create Financial Item Line

Instructions for creating a new financial item line.

Update Financial Item Line

This section explains how to update a financial item line.

Get Financial Item Line by GUID

Learn how to retrieve a financial item line by its GUID.

Delete Financial Item Line

Find out how to delete a financial item line using its GUID.

Get Financial Item Line by Criteria

Retrieve financial item lines based on specific criteria.

Add Files to Financial Item

This section covers how to add files to a financial item.

Get File in Financial Item

Learn how to retrieve files that are attached to a financial item.