Logo SQL Reports and Tools

This repository provides specialized SQL reports for Logo Tiger Enterprise and related products. Key available reports include:

• Lot and Warehouse Based Stock Report: Specialized report for Tiger Enterprise.
• Checks Report (Çekler Raporu): Accounting report for managing checks.
• Aging Report from Accounting Vouchers (Muhasebe Fiş Hareketlerinden Yaşlandırma Raporu): Debt aging analysis.
• Detailed Invoice Line Report (Faturalar Satır Detaylı): Detailed breakdown of invoice lines including VAT information.

To retrieve full details for a sales representative or a client associated with a relation, join LG_SLSCLREL using the following foreign key relationships:

• Sales Representative: Join LG_SLSCLREL.LOGICALREF to L_SLSMAN.LOGICALREF (one-to-one).
• Client/Account: Join LG_SLSCLREL.LOGICALREF to L_CLCARD.LOGICALREF (one-to-one).

-- Example Join Concept
SELECT 
    rel.LOGICALREF, 
    sman.NAME as SalesmanName, 
    cl.DEFINITION as ClientName
FROM LG_SLSCLREL rel
INNER JOIN L_SLSMAN sman ON rel.LOGICALREF = sman.LOGICALREF
INNER JOIN L_CLCARD cl ON rel.LOGICALREF = cl.LOGICALREF;

The LG_ITMFACTP table has a one-to-one relationship with the LG_ITEMS table. You can link item-specific plant information to the main item card using the ITEMREF field, which maps to LOGICALREF in LG_ITEMS.

| Level|Product ID|Resource ID|Special Code|Source Field|Destination Table|Destination Field|Relation Type|Extra Condition|
|-----|-----|-----|-----|-----|-----|-----|-----|-----|
|1|3|889||ITEMREF|[L_ITEMS](../LG_ITEMS "L_ITEMS")|LOGICALREF|one-to-one|

The LG_ROUTE table has a one-to-one relationship with the L_SLSMAN table via the SALESMANREF field. You can use this relationship to link a sales route to its corresponding sales representative.

Relation Details:

• Source Field: SALESMANREF (in LG_ROUTE)
• Destination Table: L_SLSMAN
• Destination Field: LOGICALREF
• Type: one-to-one

The LG_WSCHVAL table has a one-to-one relationship with the L_WSCHCODE table. You can join these tables using the CHARCODEREF field from LG_WSCHVAL to the LOGICALREF field in L_WSCHCODE to link characteristic values to their respective characteristic codes.

| Level| Product ID| Resource ID| Special Code| Source Field| Destination Table| Destination Field| Relation Type| Extra Condition |
|------|------------|-------------|-------------|-------------|-------------------|-----------------|--------------|----------------|
| 1| 0| 899| | CHARCODEREF| L_WSCHCODE | LOGICALREF| one-to-one| |

The LG_INVDEF table maintains one-to-one relationships with the following tables to link item and location details:

• LG_ITEMS: Linked via ITEMREF to LOGICALREF. Use this to retrieve item card details.
• LG_LOCATION: Linked via LOCATIONREF to LOGICALREF. Use this to retrieve default location details.

The LG_PRCARDS table uses a flattened structure to store up to 15 promotion lines directly within the main record. Each line (from PROMLINES1 to PROMLINES15) contains its own set of attributes for the associated item, formula, price, and unit.

Key fields for each line include:

• PROMLINESX_STOCKREF: Reference to the Item Card.
• PROMLINESX_FORMULA: The formula applied to the line.
• PROMLINESX_PRICE: The price for that specific line.
• PROMLINESX_RNDVAL: The rounding base.
• PROMLINESX_UOMREF: Unit reference.
• PROMLINESX_SITEID: Data processing site.
• PROMLINESX_RECSTATUS: Record status.
• PROMLINESX_ORGLOGICREF: Original record reference.
• PROMLINESX_WFSTATUS: Workflow status (e.g., 'Not In Use').