### L_INSTALCARD Table Schema Definition Source: https://github.com/ugurozpinar/logo/blob/master/Tablo Açıklamaları Yeni/L_INSTALCARD/README.md This API documentation provides a structured overview of the L_INSTALCARD table, including its field properties, relational dependencies, and indexing strategies. ```APIDOC L_INSTALCARD Table Definition: Fields: - LOGICALREF: Type: Longint Size: 4 Offset: 0 Description_TR: Basılmış Toplam Hesap Description_EN: Total Count of Printed - INSTALNO: Type: ZString Size: 17 Offset: 4 Description_TR: Taksit Numarası Description_EN: Instalment Number - FICHETYPE: Type: Integer Size: 2 Offset: 21 Description_TR: Fiş Türü (Fatura - Sipariş) Description_EN: Fiche Type (Invoice - Order) - FICHEREF: Type: Longint Size: 4 Offset: 23 Description_TR: Sipariş fişi Ref. - Fatura ref. Description_EN: Order Voucher Reference - Invoices Reference - CLIENTREF: Type: Longint Size: 4 Offset: 27 Description_TR: Cari Hesap Ref. Description_EN: Accounts Receivable / Payable Reference - DATE_: Type: Longint Size: 4 Offset: 31 Description_TR: Tanzim Tarihi Description_EN: Issue Date - DUEDATE: Type: Longint Size: 4 Offset: 35 Description_TR: Vade Description_EN: Due Date - SPECODE: Type: ZString Size: 11 Offset: 39 Description_TR: Özel Kod Description_EN: Aux. Code - CYPHCODE: Type: ZString Size: 11 Offset: 50 Description_TR: Yetki Kodu Description_EN: Auth. Code - SERINO: Type: ZString Size: 25 Offset: 61 Description_TR: Seri numarası Description_EN: Serial Number - GUARANTOR1: Type: ZString Size: 51 Offset: 86 Description_TR: Kefil1 Description_EN: Guarantor1 - GUARANTOR2: Type: ZString Size: 51 Offset: 137 Description_TR: Kefil2 Description_EN: Guarantor2 - STAMP: Type: Double Size: 8 Offset: 188 Description_TR: Pul Description_EN: Stamp - TRCURR: Type: Integer Size: 2 Offset: 196 Description_TR: İD Türü Description_EN: Transaction Currency Type - TRANSFER: Type: Integer Size: 2 Offset: 198 Description_TR: Devirden Description_EN: From Carrying over? - CAPIBLOCK_CREATEDBY: Type: Integer Size: 2 Offset: 200 Description_TR: Oluşturan Description_EN: Created By - CAPIBLOCK_CREADEDDATE: Type: Longint Size: 4 Offset: 202 Description_TR: Oluşturulma Tarihi Description_EN: Created Date - CAPIBLOCK_CREATEDHOUR: Type: Integer Size: 2 Offset: 206 Description_TR: Oluşturulma Saati Description_EN: Created Hour - CAPIBLOCK_CREATEDMIN: Type: Integer Size: 2 Offset: 208 Description_TR: Oluşturulma Dakikası Description_EN: Created Minute - CAPIBLOCK_CREATEDSEC: Type: Integer Size: 2 Offset: 210 Description_TR: Oluşturulma Saniyesi Description_EN: Created Second - CAPIBLOCK_MODIFIEDBY: Type: Integer Size: 2 Offset: 212 Description_TR: Değiştiren Description_EN: Modified By - CAPIBLOCK_MODIFIEDDATE: Type: Longint Size: 4 Offset: 214 Description_TR: Değiştirilme Tarihi Description_EN: Modified Date - CAPIBLOCK_MODIFIEDHOUR: Type: Integer Size: 2 Offset: 218 Description_TR: Değiştirilme Saati Description_EN: Modified Hour - CAPIBLOCK_MODIFIEDMIN: Type: Integer Size: 2 Offset: 220 Description_TR: Değiştirilme Dakikası Description_EN: Modified Minute - CAPIBLOCK_MODIFIEDSEC: Type: Integer Size: 2 Offset: 222 Description_TR: Değiştirilme Saniyesi Description_EN: Modified Second - SITEID: Type: Integer Size: 2 Offset: 224 Description_TR: Veri Merkezi Description_EN: Data Processing Site - RECSTATUS: Type: Integer Size: 2 Offset: 226 Description_TR: Kayıt Durumu Description_EN: Record Status - ORGLOGICREF: Type: Longint Size: 4 Offset: 228 Description_TR: Orijinal Kayıt Log. Ref. Description_EN: Original Record Logical Reference - WFSTATUS: Type: Longint Size: 4 Offset: 232 Description_TR: Kullanımda Değil Description_EN: Not In Use - TEXTINC: Type: Byte Size: 1 Offset: 236 Description_TR: Ayrıntılı Açıklama İçerir Description_EN: Contains Detail Description - PRINTCNT: Type: Integer Size: 2 Offset: 237 Description_TR: Basılmış Toplam Hesap Description_EN: Total Count of Printed Relations: - Source Field: FICHEREF Destination Table: L_ORFICHE Destination Field: LOGICALREF Relation Type: one-to-one Condition: If FicheType = 0 - Source Field: FICHEREF Destination Table: L_INVOICE Destination Field: LOGICALREF Relation Type: one-to-one Condition: If FicheType = 1 - Source Field: CLIENTREF Destination Table: L_CLCARD Destination Field: LOGICALREF Relation Type: one-to-one Indexes: - Name: Index1 Attributes: Unique + Not Null Segments: - Field: LOGICALREF Sense: Ascending - Name: Index2 Attributes: Duplicate + Allow Null Segments: - Field: FICHETYPE Sense: Ascending - Field: FICHEREF Sense: Ascending - Name: Index3 Attributes: Duplicate + Not Null Segments: - Field: DATE_ Sense: Ascending - Name: Index4 Attributes: Duplicate + Not Null Segments: - Field: DUEDATE Sense: Ascending ``` -------------------------------- ### Material Card (ITEMS) Data Fields Reference Source: https://github.com/ugurozpinar/logo/blob/master/Tablo Açıklamaları Yeni/LG_ITEMS/README.md Defines the structure of the Material Card (ITEMS) record, detailing each field's name, data type, size in bytes, offset from the start of the record, and a comprehensive English description of its purpose and possible values. ```APIDOC MaterialCard (ITEMS) Data Structure: LOGICALREF (Longint, Size: 4, Offset: 0): Item Card Logical Reference ACTIVE (Integer, Size: 2, Offset: 4): Item Card Status (0- Active, 1- Passive) CARDTYPE (Integer, Size: 2, Offset: 6): Item Card Type (1- Commercial Good; 2- Mixed case; 3- Deposited Item; 4- Fixed Asset; 10- Raw Material; 11- Semi Finished Good; 12- Finished Good; 13- Consumer Goods; 20- Material Class (General); 21- Material Class (Tabled)) CODE (ZString, Size: 25, Offset: 8): Item Card Code NAME (ZString, Size: 51, Offset: 33): Item Card Definition STGRPCODE (ZString, Size: 17, Offset: 84): Item Group Code PRODUCERCODE (ZString, Size: 25, Offset: 101): Producer Code SPECODE (ZString, Size: 11, Offset: 126): Aux. Code CYPHCODE (ZString, Size: 11, Offset: 137): Auth. Code CLASSTYPE (Integer, Size: 2, Offset: 148): CLASSTYPE PURCHBRWS (Integer, Size: 2, Offset: 150): Usage Point is Purchase SALESBRWS (Integer, Size: 2, Offset: 152): Usage Point is Sales / Distribution MTRLBRWS (Integer, Size: 2, Offset: 154): Usage Point is Material Management VAT (Double, Size: 8, Offset: 156): Vat PAYMENTREF (Longint, Size: 4, Offset: 164): Payment Plan Reference (PAYPLANS) TRACKTYPE (Byte, Size: 1, Offset: 168): Tracking Method (0- No Tracking, 1- Lot Number, 2- Serial Number) LOCTRACKING (Byte, Size: 1, Offset: 169): Location Tracking (1- Yes, 0- No) TOOL (Byte, Size: 1, Offset: 170): Tool (1- Yes, 0- No) AUTOINCSL (Byte, Size: 1, Offset: 171): Automatic Increase Lot / Serial Number (1- Yes, 0- No) DIVLOTSIZE (Byte, Size: 1, Offset: 172): Dividable Lot Size (1- Yes, 0- No) SHELFLIFE (Double, Size: 8, Offset: 173): Shelf Life SHELFDATE (Integer, Size: 2, Offset: 181): Shelf Date (0- Day, 1- Week, 2- Month, 3- Year) DOMINANTREFS1 (Longint, Size: 4, Offset: 183): For General Information Parent Material Class Reference (ITEMS) DOMINANTREFS2 (Longint, Size: 4, Offset: 187): For Warehouse Parameters Parent Material Class Reference (ITEMS) DOMINANTREFS3 (Longint, Size: 4, Offset: 191): For Plant Parameters Parent Material Class Reference (ITEMS) DOMINANTREFS4 (Longint, Size: 4, Offset: 195): For Workstation Parameters Parent Material Class Reference (ITEMS) DOMINANTREFS5 (Longint, Size: 4, Offset: 199): For Units Parent Material Class Reference (ITEMS) DOMINANTREFS6 (Longint, Size: 4, Offset: 203): For Prices Parent Material Class Reference (ITEMS) DOMINANTREFS7 (Longint, Size: 4, Offset: 207): Material Class Reference With Table DOMINANTREFS8 (Longint, Size: 4, Offset: 211): For Customer / Supplier Connections Parent Material Class Reference DOMINANTREFS9 (Longint, Size: 4, Offset: 215): For General Ledger Accounts Codes Parent Material Class Reference DOMINANTREFS10 (Longint, Size: 4, Offset: 219): For Inspection Criteria Sets Parent Material Class Reference DOMINANTREFS11 (Longint, Size: 4, Offset: 223): For Bill of Materials Relations Parent Material Class Reference DOMINANTREFS12 (Longint, Size: 4, Offset: 227): Not In Use IMAGEINC (Byte, Size: 1, Offset: 231): Contains Image (1- Yes, 0- No) TEXTINC (Byte, Size: 1, Offset: 232): Contains Detail Description (1- Yes, 0- No) DEPRTYPE (Integer, Size: 2, Offset: 233): Depreciation Type DEPRRATE (Double, Size: 8, Offset: 235): Depreciation Rate DEPRDUR (Integer, Size: 2, Offset: 243): Depreciation Duration SALVAGEVAL (Double, Size: 8, Offset: 245): Salvage Value REVALFLAG (Byte, Size: 1, Offset: 253): Revaluation REVDEPRFLAG (Byte, Size: 1, Offset: 254): Revaluation Depreciations PARTDEP (Byte, Size: 1, Offset: 255): Partial Depreciation DEPRTYPE2 (Integer, Size: 2, Offset: 256): National Depreciation Type DEPRRATE2 (Double, Size: 8, Offset: 258): National Depreciation Rate DEPRDUR2 (Integer, Size: 2, Offset: 266): National Depreciation Duration ``` -------------------------------- ### Database Relations for Project Entities Source: https://github.com/ugurozpinar/logo/blob/master/Tablo Açıklamaları Yeni/LG_OFFALTER/README.md This table outlines the one-to-one relationships between different project-related entities, such as offers, payment plans, projects, and workflow tasks. It specifies the source and destination tables and fields involved in each relation. ```APIDOC **Level**|**Product ID**|**Resource ID**|**Special Code**|**Source Field**|**Destination Table**|**Destination Field**|**Relation Type**|**Extra Condition** -----|-----|-----|-----|-----|-----|-----|-----|----- 1|0|784||OFFERREF|[L_OFFER](../LG_OFFER "L_OFFER")|LOGICALREF|one-to-one| 1|0|784||PAYDEFREF|[L_PAYPLANS](../LG_PAYPLANS "L_PAYPLANS")|LOGICALREF|one-to-one| 1|0|784||PROJECTREF|[L_PROJECT](../L_PROJECT "L_PROJECT")|LOGICALREF|one-to-one| 1|0|784||WFLOWCRDREF|[L_WFTASK](../LDDS-Res "L_WFTASK")|LOGICALREF|one-to-one| ``` -------------------------------- ### Data Field Schema Reference Source: https://github.com/ugurozpinar/logo/blob/master/Tablo Açıklamaları/LG_ITEMS/README.md This table provides a detailed schema for various data fields, including their identifier, data type, allocated length in bytes, byte offset from the start of a record, and a comprehensive description of their purpose. It is essential for understanding the data structure within the /ugurozpinar/logo project. ```APIDOC | FREIGHTTYPCODE8 | ZString | 13 | 724 | Delivery Type8 | | FREIGHTTYPCODE9 | ZString | 13 | 737 | Delivery Type9 | | FREIGHTTYPCODE10 | ZString | 13 | 750 | Delivery Type10 | | STATECODE | ZString | 13 | 763 | State Code | | STATENAME | ZString | 41 | 776 | State Name | | EXPCATEGORY | ZString | 25 | 817 | Export Category | | LOSTFACTOR | Double | 8 | 842 | Scrap Rate | | TEXTINCENG | Byte | 1 | 850 | Contains Detail Description (Eng) | | EANBARCODE | ZString | 25 | 851 | Product Barcode (EAN) | | DEPRCLASSTYPE | ZString | 31 | 876 | Fixed Asset Type | | WFLOWCRDREF | Longint | 4 | 907 | WFTASK Reference | | SELLPRVAT | Double | 8 | 911 | Retail Sales VAT Rate (%) | | RETURNPRVAT | Double | 8 | 919 | Retail Sales Return VAT Rate (%) | | LOWLEVELCODES1 | Longint | 4 | 927 | Hierarchy Code1 | | LOWLEVELCODES2 | Longint | 4 | 931 | Hierarchy Code2 | ``` -------------------------------- ### Offer Transaction Data Fields Reference Source: https://github.com/ugurozpinar/logo/blob/master/Tablo Açıklamaları Yeni/LG_OFFTRNS/README.md Comprehensive documentation of the fields involved in offer transactions, including their data types, sizes, offsets, and English descriptions. ```APIDOC LOGICALREF: Level: 1 Product ID: 0 Field Type: Longint Field Size: 4 Field Offset: 0 Description: Offer Transaction Logical Reference STOCKREF: Level: 1 Product ID: 0 Field Type: Longint Field Size: 4 Field Offset: 4 Description: Item Card Reference ORDFICHEREF: Level: 1 Product ID: 0 Field Type: Longint Field Size: 4 Field Offset: 8 Description: Offers Logical Reference CLIENTREF: Level: 1 Product ID: 0 Field Type: Longint Field Size: 4 Field Offset: 12 Description: Offer Alternatives Logical Reference LINETYPE: Level: 1 Product ID: 0 Field Type: Byte Field Size: 1 Field Offset: 16 Description: Line Type ;0 Item Line;1 Promotion;2 Discount;3 Surcharge;4 Service;5 Deposit;6 Mixed Case Line;7 Mixed Case Details;8 Fixed Asset Line PREVLINEREF: Level: 1 Product ID: 0 Field Type: Longint Field Size: 4 Field Offset: 17 Description: Parent Material Class Line Reference PREVLINENO: Level: 1 Product ID: 0 Field Type: Integer Field Size: 2 Field Offset: 21 Description: Parent Material Class Line Number DETLINE: Level: 1 Product ID: 0 Field Type: Byte Field Size: 1 Field Offset: 23 Description: Material Class Detail Line LINENO_: Level: 1 Product ID: 0 Field Type: Integer Field Size: 2 Field Offset: 24 Description: Line Number TRCODE: Level: 1 Product ID: 0 Field Type: Integer Field Size: 2 Field Offset: 26 Description: Card Type;1 For Sales;2 For Purchase DATE_: Level: 1 Product ID: 0 Field Type: Longint Field Size: 4 Field Offset: 28 Description: Date TIME_: Level: 1 Product ID: 0 Field Type: Longint Field Size: 4 Field Offset: 32 Description: Time GLOBTRANS: Level: 1 Product ID: 0 Field Type: Byte Field Size: 1 Field Offset: 36 Description: Discount / Surcharge and Promotion Lines ;0 Line;1 General CALCTYPE: Level: 1 Product ID: 0 Field Type: Byte Field Size: 1 Field Offset: 37 Description: Calculation Type CENTERREF: Level: 1 Product ID: 0 Field Type: Longint Field Size: 4 Field Offset: 38 Description: Not In Use ACCOUNTREF: Level: 1 Product ID: 0 Field Type: Longint Field Size: 4 Field Offset: 42 Description: Not In Use VATACCREF: Level: 1 Product ID: 0 Field Type: Longint Field Size: 4 Field Offset: 46 Description: Not In Use VATCENTERREF: Level: 1 Product ID: 0 Field Type: Longint Field Size: 4 Field Offset: 50 Description: Not In Use PRACCREF: Level: 1 Product ID: 0 Field Type: Longint Field Size: 4 Field Offset: 54 Description: Not In Use PRCENTERREF: Level: 1 Product ID: 0 Field Type: Longint Field Size: 4 Field Offset: 58 Description: Not In Use PRVATACCREF: Level: 1 Product ID: 0 Field Type: Longint Field Size: 4 Field Offset: 62 Description: Not In Use PRVATCENREF: Level: 1 Product ID: 0 Field Type: Longint Field Size: 4 Field Offset: 66 Description: Not In Use PROMREF: Level: 1 Product ID: 0 Field Type: Longint Field Size: 4 Field Offset: 70 Description: Promotion Card Reference SPECODE: Level: 1 Product ID: 0 Field Type: ZString Field Size: 17 Field Offset: 74 Description: Aux. Code DELVRYCODE: Level: 1 Product ID: 0 Field Type: ZString Field Size: 5 Field Offset: 91 Description: Delivery Code AMOUNT: Level: 1 Product ID: 0 Field Type: Double Field Size: 8 Field Offset: 96 Description: Quantity PRICE: Level: 1 Product ID: 0 Field Type: Double Field Size: 8 Field Offset: 104 Description: Price TOTAL: Level: 1 Product ID: 0 Field Type: Double Field Size: 8 Field Offset: 112 Description: Total SHIPPEDAMOUNT: Level: 1 Product ID: 0 Field Type: Double Field Size: 8 Field Offset: 120 Description: Delivered Quantity DISCPER: Level: 1 Product ID: 0 Field Type: Double Field Size: 8 Field Offset: 128 Description: Percentage Of Discount DISTCOST: Level: 1 Product ID: 0 Field Type: Double Field Size: 8 Field Offset: 136 Description: Distributed Cost To Line DISTDISC: Level: 1 Product ID: 0 Field Type: Double Field Size: 8 Field Offset: 144 Description: Distributed Discount To Line DISTEXP: Level: 1 Product ID: 0 Field Type: Double Field Size: 8 Field Offset: 152 Description: Distributed Surcharge To Line DISTPROM: Level: 1 Product ID: 0 Field Type: Double Field Size: 8 Field Offset: 160 Description: Distributed Promotion To Line VAT: Level: 1 Product ID: 0 Field Type: Double Field Size: 8 Field Offset: 168 Description: VAT VATAMNT: Level: 1 Product ID: 0 Field Type: Double Field Size: 8 Field Offset: 176 Description: Net VAT Amount VATMATRAH: Level: 1 Product ID: 0 Field Type: Double Field Size: 8 Field Offset: 184 Description: VAT Base Amount LINEEXP: Level: 1 Product ID: 0 Field Type: ZString Field Size: 31 Field Offset: 192 Description: Line Description UOMREF: Level: 1 Product ID: 0 Field Type: Longint Field Size: 4 Field Offset: 223 Description: Unit Reference USREF: Level: 1 Product ID: 0 Field Type: Longint Field Size: 4 Field Offset: 227 Description: Unit Set Reference UINFO1: Level: 1 Product ID: 0 Field Type: Double Field Size: 8 Field Offset: 231 Description: Conversion Factor UINFO2: Level: 1 Product ID: 0 Field Type: Double Field Size: 8 Field Offset: 239 Description: Conversion Factor UINFO3: Level: 1 Product ID: 0 Field Type: Double Field Size: 8 Field Offset: 247 Description: Dimension Factor UINFO4: Level: 1 Product ID: 0 Field Type: Double Field Size: 8 Field Offset: 255 Description: Dimension Factor UINFO5: Level: 1 Product ID: 0 Field Type: Double Field Size: 8 Field Offset: 263 Description: Dimension Factor UINFO6: Level: 1 Product ID: 0 Field Type: Double Field Size: 8 Field Offset: 271 Description: Dimension Factor UINFO7: Level: 1 Product ID: 0 Field Type: Double Field Size: 8 Field Offset: 279 Description: Dimension Factor UINFO8: Level: 1 Product ID: 0 Field Type: Double Field Size: 8 Field Offset: 287 Description: Dimension Factor VATINC: Level: 1 Product ID: 0 Field Type: Byte Field Size: 1 Field Offset: 295 Description: VAT Included / Excluded CLOSED: Level: 1 Product ID: 0 Field Type: Byte Field Size: 1 Field Offset: 296 Description: Offer Is Closed DORESER ``` -------------------------------- ### L_EXIMDISTPEG Database Indexes Source: https://github.com/ugurozpinar/logo/blob/master/Tablo Açıklamaları Yeni/L_EXIMDISTPEG/README.md Lists the database indexes configured for the L_EXIMDISTPEG entity, detailing their attributes (e.g., Unique, Not Null) and the fields they segment. ```APIDOC ## Indexler **Level**|**Product ID**|**Index Name**|**Attributes**|**Segment No**|**Segment Field**|**Sense** -----|-----|-----|-----|-----|-----|----- 0|0|Index1|Unique + Not Null|1|LOGICALREF|Ascending 0|0|Index2|Duplicate + Not Null|1|EXIMDISTFCREF|Ascending 0|0|Index2|Duplicate + Not Null|2|EXIMDISTLNREF|Ascending 0|0|Index3|Duplicate + Not Null|1|EXIMDISTLNREF|Ascending 0|0|Index3|Duplicate + Not Null|2|LINENR|Ascending 0|0|Index4|Duplicate + Not Null|1|EXIMINFOREF|Ascending 0|0|Index4|Duplicate + Not Null|2|ADDEXPENSE|Ascending 0|0|Index5|Duplicate + Not Null|1|STTRANSREF|Ascending ``` -------------------------------- ### Database Indexes for Project Data Source: https://github.com/ugurozpinar/logo/blob/master/Tablo Açıklamaları Yeni/LG_OFFALTER/README.md This section details the various database indexes defined for the project data, including their uniqueness, attributes, and the fields they segment. It specifies whether the index is unique or allows duplicates, and the order of segments. ```APIDOC **Level**|**Product ID**|**Index Name**|**Attributes**|**Segment No**|**Segment Field**|**Sense** -----|-----|-----|-----|-----|-----|----- 1|0|Index1|Unique + Not Null|1|LOGICALREF|Ascending 1|0|Index2|Unique + Not Null|1|OFFERREF|Ascending 1|0|Index2|Unique + Not Null|2|ALTNR|Ascending 1|0|Index3|Unique + Not Null|1|TRCODE|Ascending 1|0|Index3|Unique + Not Null|2|TYP|Ascending 1|0|Index3|Unique + Not Null|3|FICHENO|Ascending 1|0|Index4|Duplicate + Not Null|1|TRCODE|Ascending 1|0|Index4|Duplicate + Not Null|2|TYP|Ascending 1|0|Index4|Duplicate + Not Null|3|DATE_|Ascending 1|0|Index4|Duplicate + Not Null|4|TIME_|Ascending ``` -------------------------------- ### LG_QPRODUCT Table Fields and Descriptions Source: https://github.com/ugurozpinar/logo/blob/master/Tablo Açıklamaları Yeni/LG_QPRODUCT/README.md This section details the fields of the LG_QPRODUCT table, including their data types, sizes, offsets, and both Turkish and English descriptions. It provides a comprehensive overview of the table's structure for data access and manipulation. ```APIDOC LG_QPRODUCT Fields: Level | Product ID | Field Name | Field Type | Field Size | Field Offset | Türkçe Açıklama | Expression ------|------------|------------|------------|------------|--------------|---------------------------|---------------------------------- 2 | 1 | LOGICALREF | Longint | 4 | 0 | Hızlı üretim log. Ref. | Quick Production Logical Reference 2 | 1 | FICHENO | ZString | 17 | 4 | Fiş Numarası | Voucher Number 2 | 1 | DATE_ | Longint | 4 | 21 | Tarih | Date 2 | 1 | FTIME | Longint | 4 | 25 | Saat | Hour 2 | 1 | SPECODE | ZString | 11 | 29 | Özel Kod | Auxiliary Code 2 | 1 | CYPHCODE | ZString | 11 | 40 | Yetki Kodu | Authorization. Code 2 | 1 | ITEMREF | Longint | 4 | 51 | Malzemeler Log. Ref. | ITEMS LOGICALREF 2 | 1 | UOMREF | Longint | 4 | 55 | Birim seti log. Ref. | UNITSETL LOGICALREF 2 | 1 | USETREF | Longint | 4 | 59 | Birim seti log. Ref. | UNITSETF LOGICALREF 2 | 1 | UINFO1 | Double | 8 | 63 | Çevrim Katsayısı | Conversion Factor 2 | 1 | UINFO2 | Double | 8 | 71 | Çevrim Katsayısı | Conversion Factor 2 | 1 | UINFO3 | Double | 8 | 79 | Çevrim Katsayısı | Conversion Factor 2 | 1 | UINFO4 | Double | 8 | 87 | Çevrim Katsayısı | Conversion Factor 2 | 1 | UINFO5 | Double | 8 | 95 | Çevrim Katsayısı | Conversion Factor 2 | 1 | UINFO6 | Double | 8 | 103 | Çevrim Katsayısı | Conversion Factor 2 | 1 | UINFO7 | Double | 8 | 111 | Çevrim Katsayısı | Conversion Factor 2 | 1 | UINFO8 | Double | 8 | 119 | Çevrim Katsayısı | Conversion Factor 2 | 1 | ORDERREF | Longint | 4 | 127 | Sipariş fişi log. Ref. | ORFICHE LOGICALREF 2 | 1 | AMOUNT | Double | 8 | 131 | Tutar | Amount 2 | 1 | SOURCEINDEX| Integer | 2 | 139 | Ambar Numarası | Warehouse Number 2 | 1 | CAPIBLOCK_CREATEDBY| Integer | 2 | 141 | Oluşturan | Created By 2 | 1 | CAPIBLOCK_CREADEDDATE| Longint | 4 | 143 | Oluşturulma Tarihi | Created Date 2 | 1 | CAPIBLOCK_CREATEDHOUR| Integer | 2 | 147 | Oluşturulma Saati | Created Hour 2 | 1 | CAPIBLOCK_CREATEDMIN| Integer | 2 | 149 | Oluşturulma Dakikası | Created Minute 2 | 1 | CAPIBLOCK_CREATEDSEC| Integer | 2 | 151 | Oluşturulma Saniyesi | Created Second 2 | 1 | CAPIBLOCK_MODIFIEDBY| Integer | 2 | 153 | Değiştiren | Modified By 2 | 1 | CAPIBLOCK_MODIFIEDDATE| Longint | 4 | 155 | Değiştirilme Tarihi | Modified Date 2 | 1 | CAPIBLOCK_MODIFIEDHOUR| Integer | 2 | 159 | Değiştirilme Saati | Modified Hour 2 | 1 | CAPIBLOCK_MODIFIEDMIN| Integer | 2 | 161 | Değiştirilme Dakikası | Modified Minute 2 | 1 | CAPIBLOCK_MODIFIEDSEC| Integer | 2 | 163 | Değiştirilme Saniyesi | Modified Second 2 | 1 | SITEID | Integer | 2 | 165 | Veri Merkezi | Data Processing Site 2 | 1 | RECSTATUS | Integer | 2 | 167 | Kayıt Durumu | Record Status 2 | 1 | ORGLOGICREF| Longint | 4 | 169 | Orijinal Kayıt Log. Ref. | Original Record Logical Reference 2 | 1 | WFSTATUS | Longint | 4 | 173 | Kullanımda Değil | Not In Use 2 | 1 | PRODTYPE | Byte | 1 | 177 | Ürün tipi ; 1: Ürün; 2: Parçalama| Product Type ;1: Product;2: Parting 2 | 1 | LOSTFACTOR | Double | 8 | 178 | Fire Faktörü | Scrap Rate 2 | 1 | PROJECTREF | Longint | 4 | 186 | Proje Referansı | PROJECT Reference ``` -------------------------------- ### Field Definitions for Project Data Source: https://github.com/ugurozpinar/logo/blob/master/Tablo Açıklamaları Yeni/LG_OFFALTER/README.md This section defines various fields related to project data, including their data types, sizes, and unique identifiers. It provides both Turkish and English descriptions for each field, detailing its purpose within the system. ```APIDOC 1|0|ONLYONEPAYLINE|Byte|1|591|Tek satırlı ödeme hareketi|One Lined Payment Transaction 1|0|OPSTAT|Integer|2|592|Hareket durumu|Transaction Status 1|0|WITHPAYTRANS|Byte|1|594|Ödemeli / Ödemesiz?|With Payment / Without Payment? 1|0|PROJECTREF|Longint|4|595|Proje Referansı|PROJECT Reference 1|0|WFLOWCRDREF|Longint|4|599|İş Akış Kartı Referansı|WFTASK Reference 1|0|UPDTRCURR|Byte|1|603|| ``` -------------------------------- ### L_EXIMDISTLN Fields and Descriptions Source: https://github.com/ugurozpinar/logo/blob/master/Tablo Açıklamaları Yeni/L_EXIMDISTLN/README.md Defines the fields, their types, sizes, and descriptions for the L_EXIMDISTLN table, representing distribution slip lines. Includes both English and Turkish descriptions for clarity. ```APIDOC Field Name | Field Type | Field Size | Field Offset | English Description | Turkish Description -----------|------------|------------|--------------|---------------------|-------------------- LOGICALREF | Longint | 4 | 0 | Distribution Slip Lines Logical Reference | Dağıtım Fişi Satırları Log. Ref. SRVREF | Longint | 4 | 4 | Service Cards Reference | Hizmet Kartları Ref. DATE_ | Longint | 4 | 8 | Slip Date | Fiş tarihi FTIME | Longint | 4 | 12 | Slip Hour | Fiş saati SOURCEINDEX | Integer | 2 | 16 | Warehouse | Ambar EXIMINFOREF | Longint | 4 | 18 | INVEXIMINFO Reference | INVEXIMINFO Reference EXIMDISTFCREF | Longint | 4 | 22 | EXIMDISTFC Reference | EXIMDISTFC Reference PROCESSNR | Integer | 2 | 26 | Transaction Order | İşlem Sırası SRVTRANSREF | Longint | 4 | 28 | Item Transactions Reference | Malzeme Hareketleri Ref. LINENR | Integer | 2 | 32 | Line Number | Satır Numarası SRVDISTTYPE | Integer | 2 | 34 | Distribution Type ;1: Material Value;2: Material Quantity;3: Weight;4: Volume;5: Rate;6: Amount01 | Distribution Type ;1: Material Value;2: Material Quantity;3: Weight;4: Volume;5: Rate;6: Amount01 DISTTOTAL | Double | 8 | 36 | Total to Distribute | Dağılacak Toplam SRVACCREF | Longint | 4 | 44 | General Ledger Accounts Reference | Genel Muhasebe Hesapları Referansı SRVCENTERREF | Longint | 4 | 48 | Overhead Pools Reference | Masraf Merkezi Referansı SITEID | Integer | 2 | 52 | Data Processing Site | Veri Merkezi RECSTATUS | Integer | 2 | 54 | Record Status | Kayıt Durumu ORGLOGICREF | Longint | 4 | 56 | Original Record Logical Reference | Orijinal Kayıt Log. Ref. WFSTATUS | Longint | 4 | 60 | Not In Use | Kullanımda Değil ``` -------------------------------- ### LG_QPRODUCT Table Relations Source: https://github.com/ugurozpinar/logo/blob/master/Tablo Açıklamaları Yeni/LG_QPRODUCT/README.md This section outlines the relational dependencies of the LG_QPRODUCT table with other tables in the system. It specifies the source and destination fields, relation types, and any extra conditions for linking data. ```APIDOC LG_QPRODUCT Relations: Level | Product ID | Resource ID | Special Code | Source Field | Destination Table | Destination Field | Relation Type | Extra Condition ------|------------|-------------|--------------|--------------|-----------------------------------|-------------------|---------------|----------------- 2 | 1 | 934 | | ITEMREF | [L_ITEMS](../LG_ITEMS "L_ITEMS") | LOGICALREF | one-to-one | 2 | 1 | 934 | | UOMREF | [L_UNITSETL](../LG_UNITSETL "L_UNITSETL")| LOGICALREF | one-to-one | 2 | 1 | 934 | | USETREF | [L_UNITSETL](../LG_UNITSETL "L_UNITSETL")| LOGICALREF | one-to-one | 2 | 1 | 934 | | ORDERREF | [L_ORFICHE](../LG_ORFICHE "L_ORFICHE")| LOGICALREF | one-to-one | 2 | 1 | 934 | | PROJECTREF | [L_PROJECT](../L_PROJECT "L_PROJECT")| LOGICALREF | one-to-one | ```