Goods Stock Records Query (T145)

Query historical stock records with pagination support. This endpoint returns stock-in records including supplier information, stock-in types, production batch details, and financial amounts. Request and response are encrypted.

Endpoint Overview

Property	Value
Interface Code	`T145`
Request Encrypted	✅ Yes
Response Encrypted	✅ Yes
Request Body	`{ "productionBatchNo": "...", "invoiceNo": "...", "referenceNo": "...", "pageNo": 1, "pageSize": 10 }`
Response Format	JSON with pagination

Flow Description

Client submits query with at least one identifier (productionBatchNo, invoiceNo, or referenceNo) and pagination parameters.
Server validates that at least one search identifier is provided.
Server queries stock records matching the criteria across all branches.
Server returns paginated results with supplier details, stock-in information, and amounts.
Client displays records or uses data for audit/compliance reporting.

💡 Tip: At least one of productionBatchNo, invoiceNo, or referenceNo must be provided—cannot all be empty. Use T147 for current-branch-only queries.

PHP
JavaScript / TypeScript
Python

try {
    // Call T145: Goods Stock Records Query
    $filters = [
        'productionBatchNo' => '1200983',      // Optional: batch number
        'invoiceNo' => '320001127399',         // Optional: invoice number
        'referenceNo' => '425502528294126235', // Optional: reference number
        'pageNo' => 1,
        'pageSize' => 10
    ];
    
    $response = $client->queryStockRecords($filters);
    $content = $response['data']['content'] ?? $response;
    $records = $content['records'] ?? [];
    $page = $content['page'] ?? [];
    
    if (!empty($records)) {
        echo "✅ Retrieved " . count($records) . " stock record(s)\n";
        echo "   Page: {$page['pageNo']}/{$page['pageCount']} (Total: {$page['totalSize']})\n";
        
        foreach ($records as $record) {
            echo "   • Supplier: {$record['supplierName']} (TIN: {$record['supplierTin']})\n";
            echo "     Stock-In Type: {$record['stockInType']}\n";
            echo "     Date: {$record['stockInDate']}\n";
            echo "     Invoice: {$record['invoiceNo']}\n";
            echo "     Amount: {$record['totalAmount']}\n";
            echo "     Branch: {$record['branchName']}\n";
            echo "\n";
        }
    } else {
        echo "⚠️  No stock records found for provided criteria\n";
    }
    
} catch (\UraEfrisSdk\Exceptions\APIException $e) {
    echo "❌ Query failed: " . $e->getMessage() . "\n";
    echo "   Return Code: " . $e->getReturnCode() . "\n";
}

try {
    // Call T145: Goods Stock Records Query
    const filters = {
        productionBatchNo: '1200983',      // Optional: batch number
        invoiceNo: '320001127399',         // Optional: invoice number
        referenceNo: '425502528294126235', // Optional: reference number
        pageNo: 1,
        pageSize: 10
    };
    
    const response = await client.queryStockRecords(filters);
    const content = response?.data?.content ?? response;
    const records = content?.records ?? [];
    const page = content?.page ?? {};
    
    if (records.length > 0) {
        console.log(`✅ Retrieved ${records.length} stock record(s)`);
        console.log(`   Page: ${page.pageNo}/${page.pageCount} (Total: ${page.totalSize})`);
        
        for (const record of records) {
            console.log(`   • Supplier: ${record.supplierName} (TIN: ${record.supplierTin})`);
            console.log(`     Stock-In Type: ${record.stockInType}`);
            console.log(`     Date: ${record.stockInDate}`);
            console.log(`     Invoice: ${record.invoiceNo}`);
            console.log(`     Amount: ${record.totalAmount}`);
            console.log(`     Branch: ${record.branchName}`);
            console.log('');
        }
        
        return content;
    } else {
        console.warn('⚠️  No stock records found for provided criteria');
        return { records: [], page };
    }
    
} catch (error: any) {
    console.error(`❌ Query failed: ${error.message}`);
    if (error.returnCode) {
        console.error(`   Return Code: ${error.returnCode}`);
    }
    throw error;
}

try:
    # Call T145: Goods Stock Records Query
    filters = {
        "productionBatchNo": "1200983",      # Optional: batch number
        "invoiceNo": "320001127399",         # Optional: invoice number
        "referenceNo": "425502528294126235", # Optional: reference number
        "pageNo": 1,
        "pageSize": 10
    }
    
    response = client.query_stock_records(filters)
    content = response.get("data", {}).get("content", response)
    records = content.get("records", [])
    page = content.get("page", {})
    
    if records:
        print(f"✅ Retrieved {len(records)} stock record(s)")
        print(f"   Page: {page.get('pageNo')}/{page.get('pageCount')} (Total: {page.get('totalSize')})")
        
        for record in records:
            print(f"   • Supplier: {record['supplierName']} (TIN: {record['supplierTin']})")
            print(f"     Stock-In Type: {record['stockInType']}")
            print(f"     Date: {record['stockInDate']}")
            print(f"     Invoice: {record['invoiceNo']}")
            print(f"     Amount: {record['totalAmount']}")
            print(f"     Branch: {record['branchName']}")
            print()
        
    else:
        print("⚠️  No stock records found for provided criteria")
    
except Exception as e:
    print(f"❌ Query failed: {e}")
    if hasattr(e, "return_code"):
        print(f"   Return Code: {e.return_code}")
    raise

Request Structure

{
  "data": {
    "content": "BASE64_ENCRYPTED_PAYLOAD",
    "signature": "JKQWJK34K32JJEK2JQWJ5678",
    "dataDescription": {
      "codeType": "1",
      "encryptCode": "2",
      "zipCode": "0"
    }
  },
  "globalInfo": {
    "interfaceCode": "T145",
    "appId": "AP04",
    "version": "1.1.20191201",
    "tin": "1000029771",
    "deviceNo": "TCS9e0df01728335239",
    "taxpayerID": "1"
  }
}

Request Fields (Encrypted Payload)

Field	Required	Type	Length	Description
`productionBatchNo`	❌ No	String	≤50	Production batch number for filtering; at least one of `productionBatchNo`, `invoiceNo`, or `referenceNo` must be provided
`invoiceNo`	❌ No	String	≤20	Invoice number for filtering; corresponds to the invoice that triggered the stock-in
`referenceNo`	❌ No	String	≤50	Seller's reference number for filtering
`pageNo`	✅ Yes	Number	≤10	Current page number (starts from 1)
`pageSize`	✅ Yes	Number	≤3	Records per page; cannot exceed 100

💡 Tip: At least one search identifier (productionBatchNo, invoiceNo, or referenceNo) must be provided—all three cannot be empty simultaneously.

Response Structure

{
  "data": {
    "content": {
      "page": {
        "pageNo": "1",
        "pageSize": "10",
        "totalSize": "50",
        "pageCount": "5"
      },
      "records": [
        {
          "supplierTin": "1010039929",
          "supplierName": "Mr. EMUR SAM",
          "adjustType": "101",
          "remarks": "Increase inventory",
          "stockInDate": "2025-02-19",
          "stockInType": "101",
          "productionBatchNo": "1200983",
          "productionDate": "2025-02-19",
          "branchId": "2020090132456",
          "invoiceNo": "320001127399",
          "referenceNo": "425502528294126235",
          "branchName": "PARAMOUR COSMETICS LIMITED",
          "totalAmount": "1000.00"
        }
      ]
    }
  },
  "globalInfo": {
    "interfaceCode": "T145",
    "returnStateInfo": {
      "returnCode": "00",
      "returnMessage": "SUCCESS"
    }
  }
}

Response Fields

Pagination Object

Field	Required	Type	Description
`pageNo`	✅ Yes	Number	Current page number
`pageSize`	✅ Yes	Number	Records per page
`totalSize`	✅ Yes	Number	Total number of matching records
`pageCount`	✅ Yes	Number	Total number of pages

Stock Records Array Items

Field	Required	Type	Length	Description
`supplierTin`	❌ No	String	≤50	Supplier's Taxpayer Identification Number
`supplierName`	❌ No	String	≤100	Supplier name/business name
`adjustType`	❌ No	String (3)	3	101=Expired Goods, 102=Damaged Goods, 103=Personal Uses, 104=Others, 105=Raw Material(s)
`remarks`	❌ No	String	≤1024	Stock record remarks/notes
`stockInDate`	❌ No	Date	-	Stock-in date (yyyy-MM-dd)
`stockInType`	❌ No	String (3)	3	101=Import, 102=Local Purchase, 103=Manufacture/Assembling, 104=Opening Stock
`productionBatchNo`	❌ No	String	≤50	Production batch number (required if `stockInType=103`)
`productionDate`	❌ No	Date	-	Production date (yyyy-MM-dd; required if `stockInType=103`)
`branchId`	❌ No	String	≤18	Branch identifier where stock was received
`branchName`	❌ No	String	≤500	Branch name
`invoiceNo`	❌ No	String	≤20	Associated invoice number
`referenceNo`	❌ No	String	≤50	Seller's reference number
`totalAmount`	❌ No	Number	-	Total stock-in amount

💡 Tip: Use stockInType to filter records by source (import, local purchase, manufacture, opening stock). For manufactured goods (stockInType=103), productionBatchNo and productionDate will be populated.

Return Codes

Code	Message	Description
`00`	SUCCESS	Stock records retrieved successfully
`99`	Unknown error	Generic server error
`400`	Device does not exist	`deviceNo` not registered for this TIN
`402`	Device key expired	Device credentials expired; re-run T102
`403`	Device status is abnormal	Device blocked or suspended
`1521`	pageNo:cannot be empty!	Missing page number in request
`1522`	pageNo:The byte length cannot be less than 0 and cannot be greater than 20!	Page number format error
`1523`	pageNo:Cannot be greater than -1!	Page number must be positive
`1524`	pageSize:cannot be empty!	Missing page size in request
`1525`	pageSize:The byte length cannot be less than 0 and cannot be greater than 3!	Page size format error
`1526`	pageSize:Cannot be greater than 100!	Page size exceeds maximum (100)
`2843`	'productionBatchNo'、'invoiceNo'、'referenceNo' cannot be empty at the same time!	At least one search identifier required
`2844`	productionBatchNo:cannot be empty!	Production batch number format error
`2845`	productionBatchNo:Byte length cannot be greater than 50!	Production batch number too long
`2846`	referenceNo:cannot be empty!	Reference number format error
`2847`	referenceNo:Byte length cannot be greater than 20!	Reference number too long

💡 Tip: Error 2843 is the most common—ensure at least one search identifier (productionBatchNo, invoiceNo, or referenceNo) is provided.

Common Use Cases

Stock Audit Trail
Query historical stock-in records for compliance audits and financial reconciliation.
Supplier Verification
Filter records by supplierTin or supplierName to verify supplier transactions.
Invoice-to-Stock Reconciliation
Match stock records to invoices using invoiceNo for accounting reconciliation.
Batch Traceability
Track manufactured goods by productionBatchNo for quality control and recalls.
Branch Stock Analysis
Analyze stock-in patterns across branches using branchId/branchName filters.
Stock-In Type Reporting
Generate reports by stockInType (import, local purchase, manufacture, opening stock).
Reference Number Lookup
Locate stock records using seller's reference numbers for transaction tracking.

Integration Checklist

✅ Ensure at least one search identifier is provided (productionBatchNo, invoiceNo, or referenceNo)
✅ Validate pageNo ≥ 1 and pageSize ≤ 100 before submitting request
✅ Handle empty records array gracefully (no matching records found)
✅ Implement pagination logic using pageCount and totalSize from response
✅ Cache frequently-queried stock records to reduce API calls
✅ Log query parameters for audit trail compliance
✅ Cross-reference invoiceNo with T106/T108 invoice queries for validation
✅ Use T147 for current-branch-only queries (better performance for single-branch operations)
✅ Validate stockInType values against T115 dictionary for display purposes
✅ Handle date format consistently (yyyy-MM-dd) across all date fields

Endpoint Overview​

Flow Description​

Request Structure​

Request Fields (Encrypted Payload)​

Response Structure​

Response Fields​

Pagination Object​

Stock Records Array Items​

Return Codes​

Common Use Cases​

Integration Checklist​