Scribd
Upload
14 views1 page

Customer Invoice Payment Query

The document contains a SQL query that selects various fields from the AROBL table related to customer invoices. It filters results based on specific conditions regarding payment status and invoice dates for a particular customer ID. The query aims to retrieve relevant financial data for analysis or reporting purposes.

Uploaded by

H
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
14 views1 page

Customer Invoice Payment Query

The document contains a SQL query that selects various fields from the AROBL table related to customer invoices. It filters results based on specific conditions regarding payment status and invoice dates for a particular customer ID. The query aims to retrieve relevant financial data for analysis or reporting purposes.

Uploaded by

H
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

SELECT [Link] ,[Link] ,[Link] ,L.

DATEDUE
,[Link] /*ACCPAC TYPE 5 FT_INT*/,[Link] /*ACCPAC TYPE 6
FT_INT*/,[Link] ,[Link] ,[Link]
,[Link] ,[Link] ,[Link] /*ACCPAC TYPE 12
FT_INT*/ ,[Link],[Link],[Link] ,[Link]
,[Link] ,[Link] ,[Link] ,[Link] ,[Link] /*ACCPAC TYPE 21
FT_LONG */,[Link] /*ACCPAC TYPE 22 FT_LONG */,[Link]
,[Link] ,[Link] ,[Link] /*ACCPAC TYPE 26 FT_INT
*/,[Link] ,[Link] /*ACCPAC TYPE 28 FT_INT */ FROM AROBL L

WHERE [Link] = ''CUS000000001'' AND ((([Link] = 0 OR ([Link]=1 AND


[Link] > 20250428)) AND [Link] <= 20250428)
OR ([Link] > 20250428))

You might also like