E-Invoice

E-Invoice's Database

UI Name	Database	Type	Remarks
Doc No	TBL.DOCNO	String	E.g.: IV00001
E-Invoice Validated Date	E.TRANSDATETIME	Date	E.g.: 2025-01-01
E-Invoice Unique Id	TBL.IRBM_UUID	String	E.g.: A1B2C3...
E-Invoice Digital Sign Id	TBL.IRBM_LONGID	String	E.g.: Z9Y8X7...
E-Invoice Validation Link	validation_link	String	E.g.: https://myinvois.hasil.gov.my/......
E-Invoice Status	E.STATUS	String	E.g.: Valid
Last Modified	E.TRANSDATETIME	Timestamp	E.g.: 2025-01-01T00:00:00.000

E-Invoice's Sample Code

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

SQL Script

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

SELECT 
    TBL.DOCNO AS DocNo,//IV,CN,DN
    E.TRANSDATETIME AS EInvoiceValidateDate,
    TBL.IRBM_UUID AS EInvoiceUUID,
    TBL.IRBM_LONGID AS EInvoiceLongID,
    E.STATUS AS EInvoiceStatus,
    E.TRANSDATETIME AS LastModified
FROM 
    {YOUR_DOC_TABLE} TBL
JOIN EIV E 
    ON TBL.DOCKEY = E.DOCKEY //MATCH
WHERE 
    E.DOCTYPE = '{YOUR_DOCTYPE}' //IV,CN,DN
    AND E.STATUS = {STATUS_CODE} // 2
    AND E.TRANSDATETIME >{LAST_MODIFIED_DATE_TIME};

jobs.json

Logic Script