Debtor

Debtor's Database

UI Name	Database	Type	Remarks
Debtor Account	AccNo	String	E.g.: 400-A001
Company Name	CompanyName	String	E.g.: Gney Software Sdn Bhd
Billing Address 1	Address1	String	E.g.: 1, Jalan Melati Indah,
Billing Address 2	Address2	String	E.g.: Taman Bukit Mewah,
Billing Address 3	Address3	String	E.g.: 43000 Kajang,
Billing Address 4	Address4	String	E.g.: Selangor.
Phone	Phone1	String	E.g.: 012 - 4567890
Credit Term	DisplayTerm	String	Credit Term must match the same in the Inistate system. E.g.: C.O.D.
Email Address	EmailAddress	String	E.g.: [e-mail]
Agent	SalesAgent	String	E.g.: ADMIN

Debtor's Sample Code

Remember to change to the correct field before proceeding to run ANY script.

Inistate To SQL Accounting

jobs.json

In order to sync, you must include LastModified in SELECT

"SQLSync": [
    {
      "name": "SyncCustomer",
      "enabled": true,
      "server": {
        "db": "ACC-0020.FDB",
        "dcf": "C:\\eStream\\SQLAccounting\\Share\\DEFAULT.DCF",
        "username": "ADMIN",
        "password": "ADMIN"
      },
      "to": "sqlaccounting",
      "debug": false,
      "hook": "https://api.inistate.com/api/automationHook/hook/{MODULE-ID}-{LOGIC-NAME}",
      "errorHook": "https://api.inistate.com/api/automationHook/hook/{MODULE-ID}-{LOGIC-NAME}",
      "lastSync": "2025-10-07T09:18:55+08:00",
      "interval": 5,
      "start": null
    },
]

Logic Script

SQL Accounting to Inistate

SQL Script

This is a sample SQL, may not be as same as your database.

SELECT TOP (10)
    AccNo,
    CompanyName,
    Address1,
    Address2,
    Address3,
    Address4,
    Phone1,
    DisplayTerm,
    EmailAddress,
    SalesAgent,
    LastModified
FROM Debtor
WHERE LastModified > "{LAST_MODIFIED_DATE_TIME}";

jobs.json

Logic Script

a