VAST to GP intergration

VAST staging area:

SELECT     TOP (200) IDENTITYFIELD, COMPANY_NUMBER, GL_NUMBER, TRANSACTION_DATE, DOCUMENT_NUMBER, CUSTOMER_NAME, DEBIT, CREDIT, SOURCE, 
                      GL_TYPE, STATUS, WDATE, IDATE, WRITEROUTINE, CUSTOMER_TYPE, COMPOUND_GL_NUMBER, SEND_TO_THIRDPARTY, JOURNAL_NUM, GUID, COMMENT, 
                      WORKORDER, WORKORDER_LINE_ID, Goodyear_Claim_No, REF_Doc_ID, BIG_Invoice_No, REF_Order_Type, PARENT_GUID, Eod_Status, Eod_DateStamp, 
                      DO_NOT_SEND_VENDOR
FROM         GLTRANSACTION

 

VAST Staging area to GP Resend:

UPDATE GLTRANSACTION SET SEND_TO_THIRDPARTY = 1 WHERE  (TRANSACTION_DATE = CONVERT(DATETIME, '2016-05-05 00:00:00', 102))

Cheers!
Sanjay