2022-04-25 03:22:37 INFO i.a.w.w.WorkerRun(call):49 - Executing worker wrapper. Airbyte version: 0.36.1-alpha 2022-04-25 03:22:37 INFO i.a.w.t.TemporalAttemptExecution(get):107 - Cloud storage job log path: /workspace/607/0/logs.log 2022-04-25 03:22:43 destination > SLF4J: Class path contains multiple SLF4J bindings. 2022-04-25 03:22:43 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-04-25 03:22:43 destination > SLF4J: Found binding in [jar:file:/airbyte/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2022-04-25 03:22:43 destination > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 2022-04-25 03:22:37 INFO i.a.w.t.TemporalAttemptExecution(get):110 - Executing worker wrapper. Airbyte version: 0.36.1-alpha 2022-04-25 03:22:37 INFO i.a.w.DefaultReplicationWorker(run):104 - start sync worker. job id: 607 attempt id: 0 2022-04-25 03:22:37 INFO i.a.w.DefaultReplicationWorker(run):116 - configured sync modes: {dbo.QCS, LLC$Sales Line=full_refresh - overwrite, dbo.QCS, LLC$G_L Entry=incremental - append_dedup, dbo.QCS, LLC$Item Status Link=full_refresh - overwrite, dbo.QCS, LLC$Item Category=full_refresh - overwrite, dbo.QCS, LLC$Customer=full_refresh - overwrite, dbo.QCS, LLC$Sales Header=full_refresh - overwrite, dbo.QCS, LLC$G_L_ItemLevel_SQL=incremental - append_dedup, dbo.QCS, LLC$Detailed Vendor Ledg_ Entry=full_refresh - overwrite, dbo.QCS, LLC$Salesperson_Purchaser=full_refresh - overwrite, dbo.QCS, LLC$Sales Invoice Line=full_refresh - overwrite, dbo.QCS, LLC$Sales Cr_Memo Line=full_refresh - overwrite, dbo.QCS, LLC$Purchase Header=full_refresh - overwrite, dbo.QCS, LLC$Trans_ Sales Entry=full_refresh - overwrite, dbo.QCS, LLC$Purch_ Inv_ Header=full_refresh - overwrite, dbo.QCS, LLC$Sales Price=full_refresh - overwrite, dbo.QCS, LLC$Item=full_refresh - overwrite, dbo.QCS, LLC$Item Ledger Entry=full_refresh - overwrite, dbo.QCS, LLC$Sales Shipment Line=full_refresh - overwrite, dbo.QCS, LLC$Warehouse Entry=full_refresh - overwrite, dbo.QCS, LLC$Sales Invoice Header=full_refresh - overwrite, dbo.QCS, LLC$Purchase Line=full_refresh - overwrite, dbo.QCS, LLC$Vendor=full_refresh - overwrite, dbo.QCS, LLC$Value Entry=full_refresh - overwrite, dbo.QCS, LLC$Location=full_refresh - overwrite, dbo.QCS, LLC$Sales Cr_Memo Header=full_refresh - overwrite, dbo.QCS, LLC$Purch_ Rcpt_ Header=full_refresh - overwrite, dbo.QCS, LLC$Purch_ Inv_ Line=full_refresh - overwrite, dbo.QCS, LLC$Purchase Price=full_refresh - overwrite, dbo.QCS, LLC$Assembly Line=full_refresh - overwrite, dbo.QCS, LLC$Vendor Ledger Entry=full_refresh - overwrite, dbo.QCS, LLC$Purchase Line Archive=full_refresh - overwrite, dbo.QCS, LLC$Detailed Cust_ Ledg_ Entry=full_refresh - overwrite, dbo.QCS, LLC$Job Ledger Entry=full_refresh - overwrite, dbo.QCS, LLC$Job Planning Line=full_refresh - overwrite, dbo.QCS, LLC$Sales Shipment Header=full_refresh - overwrite, dbo.QCS, LLC$G_L Account=full_refresh - overwrite, dbo.QCS, LLC$Bank Account Ledger Entry=full_refresh - overwrite, dbo.QCS, LLC$Stockkeeping Unit=incremental - append_dedup, dbo.QCS, LLC$Transaction Header=full_refresh - overwrite, dbo.QCS, LLC$Cust_ Ledger Entry=full_refresh - overwrite, dbo.QCS, LLC$Purch_ Cr_ Memo Line=full_refresh - overwrite} 2022-04-25 03:22:37 INFO i.a.w.p.a.DefaultAirbyteDestination(start):69 - Running destination... 2022-04-25 03:22:37 INFO i.a.w.p.KubeProcessFactory(create):113 - Attempting to start pod = destination-snowflake-sync-607-0-ltcqs for airbyte/destination-snowflake:0.4.24 2022-04-25 03:22:37 INFO i.a.w.p.KubeProcessFactory(create):116 - destination-snowflake-sync-607-0-ltcqs stdoutLocalPort = 9016 2022-04-25 03:22:37 INFO i.a.w.p.KubeProcessFactory(create):119 - destination-snowflake-sync-607-0-ltcqs stderrLocalPort = 9017 2022-04-25 03:22:37 INFO i.a.w.p.KubePodProcess(lambda$setupStdOutAndStdErrListeners$9):583 - Creating stdout socket server... 2022-04-25 03:22:37 INFO i.a.w.p.KubePodProcess(lambda$setupStdOutAndStdErrListeners$10):601 - Creating stderr socket server... 2022-04-25 03:22:37 INFO i.a.w.p.KubePodProcess():521 - Creating pod destination-snowflake-sync-607-0-ltcqs... 2022-04-25 03:22:38 INFO i.a.w.p.KubePodProcess(waitForInitPodToRun):305 - Waiting for init container to be ready before copying files... 2022-04-25 03:22:38 INFO i.a.w.p.KubePodProcess(waitForInitPodToRun):318 - Init container present.. 2022-04-25 03:22:39 INFO i.a.w.p.KubePodProcess(waitForInitPodToRun):321 - Init container ready.. 2022-04-25 03:22:39 INFO i.a.w.p.KubePodProcess():546 - Copying files... 2022-04-25 03:22:39 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):254 - Uploading file: destination_config.json 2022-04-25 03:22:39 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):262 - kubectl cp /tmp/d263c985-f975-4a22-88f1-5268450a645a/destination_config.json default/destination-snowflake-sync-607-0-ltcqs:/config/destination_config.json -c init 2022-04-25 03:22:39 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):265 - Waiting for kubectl cp to complete 2022-04-25 03:22:39 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):279 - kubectl cp complete, closing process 2022-04-25 03:22:39 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):254 - Uploading file: destination_catalog.json 2022-04-25 03:22:39 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):262 - kubectl cp /tmp/cb5c7263-e209-463f-8852-5d213e21eaeb/destination_catalog.json default/destination-snowflake-sync-607-0-ltcqs:/config/destination_catalog.json -c init 2022-04-25 03:22:39 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):265 - Waiting for kubectl cp to complete 2022-04-25 03:22:40 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):279 - kubectl cp complete, closing process 2022-04-25 03:22:40 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):254 - Uploading file: FINISHED_UPLOADING 2022-04-25 03:22:40 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):262 - kubectl cp /tmp/7cfaf2ae-44f2-4c42-80c6-422c228a6f90/FINISHED_UPLOADING default/destination-snowflake-sync-607-0-ltcqs:/config/FINISHED_UPLOADING -c init 2022-04-25 03:22:40 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):265 - Waiting for kubectl cp to complete 2022-04-25 03:22:40 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):279 - kubectl cp complete, closing process 2022-04-25 03:22:40 INFO i.a.w.p.KubePodProcess():549 - Waiting until pod is ready... 2022-04-25 03:22:42 INFO i.a.w.p.KubePodProcess(lambda$setupStdOutAndStdErrListeners$9):592 - Setting stdout... 2022-04-25 03:22:42 INFO i.a.w.p.KubePodProcess(lambda$setupStdOutAndStdErrListeners$10):604 - Setting stderr... 2022-04-25 03:22:43 INFO i.a.w.p.KubePodProcess():564 - Reading pod IP... 2022-04-25 03:22:43 INFO i.a.w.p.KubePodProcess():566 - Pod IP: 10.226.4.72 2022-04-25 03:22:43 INFO i.a.w.p.KubePodProcess():569 - Creating stdin socket... 2022-04-25 03:22:43 INFO i.a.w.p.KubeProcessFactory(create):113 - Attempting to start pod = source-mssql-sync-607-0-tezae for airbyte/source-mssql:0.3.19 2022-04-25 03:22:43 INFO i.a.w.p.KubeProcessFactory(create):116 - source-mssql-sync-607-0-tezae stdoutLocalPort = 9034 2022-04-25 03:22:43 INFO i.a.w.p.KubeProcessFactory(create):119 - source-mssql-sync-607-0-tezae stderrLocalPort = 9035 2022-04-25 03:22:43 INFO i.a.w.p.KubePodProcess(lambda$setupStdOutAndStdErrListeners$9):583 - Creating stdout socket server... 2022-04-25 03:22:43 INFO i.a.w.p.KubePodProcess(lambda$setupStdOutAndStdErrListeners$10):601 - Creating stderr socket server... 2022-04-25 03:22:43 INFO i.a.w.p.KubePodProcess():521 - Creating pod source-mssql-sync-607-0-tezae... 2022-04-25 03:22:43 INFO i.a.w.p.KubePodProcess(waitForInitPodToRun):305 - Waiting for init container to be ready before copying files... 2022-04-25 03:22:43 INFO i.a.w.p.KubePodProcess(waitForInitPodToRun):318 - Init container present.. 2022-04-25 03:22:44 INFO i.a.w.p.KubePodProcess(waitForInitPodToRun):321 - Init container ready.. 2022-04-25 03:22:44 INFO i.a.w.p.KubePodProcess():546 - Copying files... 2022-04-25 03:22:44 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):254 - Uploading file: input_state.json 2022-04-25 03:22:44 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):262 - kubectl cp /tmp/6310947a-ebf5-40f3-8e98-a9f878a2961d/input_state.json default/source-mssql-sync-607-0-tezae:/config/input_state.json -c init 2022-04-25 03:22:44 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):265 - Waiting for kubectl cp to complete 2022-04-25 03:22:45 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):279 - kubectl cp complete, closing process 2022-04-25 03:22:45 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):254 - Uploading file: source_config.json 2022-04-25 03:22:45 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):262 - kubectl cp /tmp/8cca9ed9-8a19-4461-982a-4572372b5396/source_config.json default/source-mssql-sync-607-0-tezae:/config/source_config.json -c init 2022-04-25 03:22:45 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):265 - Waiting for kubectl cp to complete 2022-04-25 03:22:45 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):279 - kubectl cp complete, closing process 2022-04-25 03:22:45 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):254 - Uploading file: source_catalog.json 2022-04-25 03:22:45 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):262 - kubectl cp /tmp/327763b8-1f93-4293-90a6-ae665257ddf1/source_catalog.json default/source-mssql-sync-607-0-tezae:/config/source_catalog.json -c init 2022-04-25 03:22:45 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):265 - Waiting for kubectl cp to complete 2022-04-25 03:22:45 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):279 - kubectl cp complete, closing process 2022-04-25 03:22:45 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):254 - Uploading file: FINISHED_UPLOADING 2022-04-25 03:22:45 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):262 - kubectl cp /tmp/65c4242f-ffe1-4f70-9db0-057e0682ff94/FINISHED_UPLOADING default/source-mssql-sync-607-0-tezae:/config/FINISHED_UPLOADING -c init 2022-04-25 03:22:45 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):265 - Waiting for kubectl cp to complete 2022-04-25 03:22:46 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):279 - kubectl cp complete, closing process 2022-04-25 03:22:46 INFO i.a.w.p.KubePodProcess():549 - Waiting until pod is ready... 2022-04-25 03:22:47 INFO i.a.w.p.KubePodProcess(lambda$setupStdOutAndStdErrListeners$9):592 - Setting stdout... 2022-04-25 03:22:47 INFO i.a.w.p.KubePodProcess(lambda$setupStdOutAndStdErrListeners$10):604 - Setting stderr... 2022-04-25 03:22:47 INFO i.a.w.p.KubePodProcess():564 - Reading pod IP... 2022-04-25 03:22:47 INFO i.a.w.p.KubePodProcess():566 - Pod IP: 10.226.5.192 2022-04-25 03:22:47 INFO i.a.w.p.KubePodProcess():573 - Using null stdin output stream... 2022-04-25 03:22:47 INFO i.a.w.DefaultReplicationWorker(lambda$getDestinationOutputRunnable$6):339 - Destination output thread started. 2022-04-25 03:22:47 INFO i.a.w.DefaultReplicationWorker(run):158 - Waiting for source and destination threads to complete. 2022-04-25 03:22:47 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):279 - Replication thread started. 2022-04-25 03:23:11 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 1000 (1 MB) 2022-04-25 03:23:12 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 2000 (2 MB) 2022-04-25 03:23:13 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 3000 (4 MB) ... 2022-04-25 13:22:31 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 98501000 (178 GB) 2022-04-25 13:22:31 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 98502000 (178 GB) 2022-04-25 13:22:31 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 98503000 (178 GB) 2022-04-25 13:22:31 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 98504000 (178 GB) 2022-04-25 13:22:32 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 98505000 (178 GB) 2022-04-25 13:22:32 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):301 - Records read: 98506000 (178 GB) 2022-04-25 13:22:32 INFO i.a.w.p.KubePodProcess(close):713 - (pod: default / source-mssql-sync-607-0-tezae) - Closed all resources for pod 2022-04-25 13:22:32 INFO i.a.w.DefaultReplicationWorker(lambda$getReplicationRunnable$5):305 - Total records read: 98506714 (178 GB) 2022-04-25 13:22:32 WARN i.a.c.i.LineGobbler(voidCall):86 - airbyte-destination gobbler IOException: Socket closed. Typically happens when cancelling a job. 2022-04-25 13:22:32 INFO i.a.w.p.KubePodProcess(close):713 - (pod: default / destination-snowflake-sync-607-0-ltcqs) - Closed all resources for pod 2022-04-25 13:22:32 ERROR i.a.w.DefaultReplicationWorker(run):169 - Sync worker failed. java.util.concurrent.ExecutionException: io.airbyte.workers.DefaultReplicationWorker$SourceException: Source process exited with non-zero exit code 143 at java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:396) ~[?:?] at java.util.concurrent.CompletableFuture.get(CompletableFuture.java:2073) ~[?:?] at io.airbyte.workers.DefaultReplicationWorker.run(DefaultReplicationWorker.java:162) ~[io.airbyte-airbyte-workers-0.36.1-alpha.jar:?] at io.airbyte.workers.DefaultReplicationWorker.run(DefaultReplicationWorker.java:57) ~[io.airbyte-airbyte-workers-0.36.1-alpha.jar:?] at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$2(TemporalAttemptExecution.java:155) ~[io.airbyte-airbyte-workers-0.36.1-alpha.jar:?] at java.lang.Thread.run(Thread.java:833) [?:?] Suppressed: io.airbyte.workers.WorkerException: Source process exit with code 143. This warning is normal if the job was cancelled. at io.airbyte.workers.protocols.airbyte.DefaultAirbyteSource.close(DefaultAirbyteSource.java:136) ~[io.airbyte-airbyte-workers-0.36.1-alpha.jar:?] at io.airbyte.workers.DefaultReplicationWorker.run(DefaultReplicationWorker.java:126) ~[io.airbyte-airbyte-workers-0.36.1-alpha.jar:?] at io.airbyte.workers.DefaultReplicationWorker.run(DefaultReplicationWorker.java:57) ~[io.airbyte-airbyte-workers-0.36.1-alpha.jar:?] at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$2(TemporalAttemptExecution.java:155) ~[io.airbyte-airbyte-workers-0.36.1-alpha.jar:?] at java.lang.Thread.run(Thread.java:833) [?:?] Suppressed: io.airbyte.workers.WorkerException: Destination process exit with code 143. This warning is normal if the job was cancelled. at io.airbyte.workers.protocols.airbyte.DefaultAirbyteDestination.close(DefaultAirbyteDestination.java:119) ~[io.airbyte-airbyte-workers-0.36.1-alpha.jar:?] at io.airbyte.workers.DefaultReplicationWorker.run(DefaultReplicationWorker.java:126) ~[io.airbyte-airbyte-workers-0.36.1-alpha.jar:?] at io.airbyte.workers.DefaultReplicationWorker.run(DefaultReplicationWorker.java:57) ~[io.airbyte-airbyte-workers-0.36.1-alpha.jar:?] at io.airbyte.workers.temporal.TemporalAttemptExecution.lambda$getWorkerThread$2(TemporalAttemptExecution.java:155) ~[io.airbyte-airbyte-workers-0.36.1-alpha.jar:?] at java.lang.Thread.run(Thread.java:833) [?:?] Caused by: io.airbyte.workers.DefaultReplicationWorker$SourceException: Source process exited with non-zero exit code 143 at io.airbyte.workers.DefaultReplicationWorker.lambda$getReplicationRunnable$5(DefaultReplicationWorker.java:312) ~[io.airbyte-airbyte-workers-0.36.1-alpha.jar:?] at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1804) ~[?:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?] ... 1 more 2022-04-25 13:22:32 INFO i.a.w.DefaultReplicationWorker(run):228 - sync summary: io.airbyte.config.ReplicationAttemptSummary@774cec9b[status=failed,recordsSynced=98506711,bytesSynced=192086425487,startTime=1650856957968,endTime=1650892952634,totalStats=io.airbyte.config.SyncStats@15ea9b5d[recordsEmitted=98506711,bytesEmitted=192086425487,stateMessagesEmitted=3,recordsCommitted=0],streamStats=[io.airbyte.config.StreamSyncStats@281df9bd[streamName=QCS, LLC$Warehouse Entry,stats=io.airbyte.config.SyncStats@c67933[recordsEmitted=7973501,bytesEmitted=8789042309,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@10fe7584[streamName=QCS, LLC$Assembly Line,stats=io.airbyte.config.SyncStats@518f24b5[recordsEmitted=10669,bytesEmitted=10484703,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@1618ff28[streamName=QCS, LLC$Sales Shipment Header,stats=io.airbyte.config.SyncStats@25a40339[recordsEmitted=1314843,bytesEmitted=4660687720,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@4695005c[streamName=QCS, LLC$Sales Header,stats=io.airbyte.config.SyncStats@6e972eb7[recordsEmitted=14310,bytesEmitted=93552942,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@3f276df2[streamName=QCS, LLC$Salesperson_Purchaser,stats=io.airbyte.config.SyncStats@3a9f0ce4[recordsEmitted=804,bytesEmitted=575486,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@54e66c0b[streamName=QCS, LLC$Transaction Header,stats=io.airbyte.config.SyncStats@35312b6[recordsEmitted=1843062,bytesEmitted=3487899769,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@79fa7d3[streamName=QCS, LLC$Cust_ Ledger Entry,stats=io.airbyte.config.SyncStats@452563e8[recordsEmitted=4708367,bytesEmitted=11837440837,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@22c4c973[streamName=QCS, LLC$Sales Cr_Memo Header,stats=io.airbyte.config.SyncStats@3999b93f[recordsEmitted=60332,bytesEmitted=284039890,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@434220e0[streamName=QCS, LLC$Item Status Link,stats=io.airbyte.config.SyncStats@2d963143[recordsEmitted=97061,bytesEmitted=62153438,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@299dfad3[streamName=QCS, LLC$Location,stats=io.airbyte.config.SyncStats@5d39ee9e[recordsEmitted=60,bytesEmitted=125404,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@f2e90f9[streamName=QCS, LLC$Vendor Ledger Entry,stats=io.airbyte.config.SyncStats@132eb476[recordsEmitted=1365312,bytesEmitted=2391270731,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@55a38fa2[streamName=QCS, LLC$Item Ledger Entry,stats=io.airbyte.config.SyncStats@47fcd696[recordsEmitted=12835147,bytesEmitted=21784885371,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@3cae2fc8[streamName=QCS, LLC$Purchase Line,stats=io.airbyte.config.SyncStats@5ac5b12f[recordsEmitted=36159,bytesEmitted=209744045,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@1352fb4a[streamName=QCS, LLC$G_L Entry,stats=io.airbyte.config.SyncStats@32bbd7d0[recordsEmitted=397235,bytesEmitted=619502504,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@7fa67e20[streamName=QCS, LLC$Sales Invoice Header,stats=io.airbyte.config.SyncStats@89df432[recordsEmitted=1240982,bytesEmitted=6389742975,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@c91d6c0[streamName=QCS, LLC$Purchase Line Archive,stats=io.airbyte.config.SyncStats@60f895d5[recordsEmitted=2417983,bytesEmitted=11176850259,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@2ce3a094[streamName=QCS, LLC$Bank Account Ledger Entry,stats=io.airbyte.config.SyncStats@4b38ed5e[recordsEmitted=1972353,bytesEmitted=2253409615,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@491d152f[streamName=QCS, LLC$Stockkeeping Unit,stats=io.airbyte.config.SyncStats@6d6f77e4[recordsEmitted=179499,bytesEmitted=276985318,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@5c399ddd[streamName=QCS, LLC$G_L Account,stats=io.airbyte.config.SyncStats@50e7c919[recordsEmitted=831,bytesEmitted=804054,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@71f21a47[streamName=QCS, LLC$Item,stats=io.airbyte.config.SyncStats@673483ca[recordsEmitted=106678,bytesEmitted=892623403,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@77f33d84[streamName=QCS, LLC$Item Category,stats=io.airbyte.config.SyncStats@19328d62[recordsEmitted=79,bytesEmitted=63340,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@78739c21[streamName=QCS, LLC$Purch_ Cr_ Memo Line,stats=io.airbyte.config.SyncStats@3b1a7a36[recordsEmitted=31586,bytesEmitted=89371484,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@556b6fcc[streamName=QCS, LLC$Purch_ Inv_ Header,stats=io.airbyte.config.SyncStats@583fb19e[recordsEmitted=408547,bytesEmitted=1250859671,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@3cc9ac2c[streamName=QCS, LLC$Value Entry,stats=io.airbyte.config.SyncStats@546aba49[recordsEmitted=18565670,bytesEmitted=38857071108,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@5af1ba07[streamName=QCS, LLC$Sales Cr_Memo Line,stats=io.airbyte.config.SyncStats@7f674386[recordsEmitted=207008,bytesEmitted=523533779,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@e3e288a[streamName=QCS, LLC$Detailed Cust_ Ledg_ Entry,stats=io.airbyte.config.SyncStats@f0773f6[recordsEmitted=9575468,bytesEmitted=10778904604,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@58f1d193[streamName=QCS, LLC$Vendor,stats=io.airbyte.config.SyncStats@1dcfc278[recordsEmitted=7657,bytesEmitted=17699104,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@62cad333[streamName=QCS, LLC$Sales Invoice Line,stats=io.airbyte.config.SyncStats@5666945f[recordsEmitted=6389193,bytesEmitted=20771060534,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@4dba49[streamName=QCS, LLC$Purchase Price,stats=io.airbyte.config.SyncStats@6372743a[recordsEmitted=133378,bytesEmitted=44531407,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@5795602c[streamName=QCS, LLC$Sales Shipment Line,stats=io.airbyte.config.SyncStats@35b3d2ed[recordsEmitted=6464384,bytesEmitted=17781682204,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@58c1b9e0[streamName=QCS, LLC$Detailed Vendor Ledg_ Entry,stats=io.airbyte.config.SyncStats@28e2d566[recordsEmitted=2796921,bytesEmitted=2751977305,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@540a4456[streamName=QCS, LLC$Purch_ Inv_ Line,stats=io.airbyte.config.SyncStats@7f85d080[recordsEmitted=2268386,bytesEmitted=7281822318,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@2a5e7829[streamName=QCS, LLC$Purch_ Rcpt_ Header,stats=io.airbyte.config.SyncStats@1429d1e1[recordsEmitted=400524,bytesEmitted=1138680452,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@12070fc6[streamName=QCS, LLC$Sales Line,stats=io.airbyte.config.SyncStats@43d7dcd6[recordsEmitted=98775,bytesEmitted=559380986,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@1a916bb5[streamName=QCS, LLC$Trans_ Sales Entry,stats=io.airbyte.config.SyncStats@406d17df[recordsEmitted=1705066,bytesEmitted=4268580892,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@6a3e592b[streamName=QCS, LLC$Customer,stats=io.airbyte.config.SyncStats@177209d6[recordsEmitted=573196,bytesEmitted=2691682847,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@62f044e[streamName=QCS, LLC$Job Ledger Entry,stats=io.airbyte.config.SyncStats@2ed428bb[recordsEmitted=309245,bytesEmitted=992996632,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@36bbcb4b[streamName=QCS, LLC$Job Planning Line,stats=io.airbyte.config.SyncStats@310048f3[recordsEmitted=333013,bytesEmitted=1094994070,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@4ff327e9[streamName=QCS, LLC$G_L_ItemLevel_SQL,stats=io.airbyte.config.SyncStats@406d4f5c[recordsEmitted=197305,bytesEmitted=283829276,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@28643589[streamName=QCS, LLC$Purchase Header,stats=io.airbyte.config.SyncStats@1b90b7a6[recordsEmitted=7410,bytesEmitted=34985437,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@4d8a1752[streamName=QCS, LLC$Sales Price,stats=io.airbyte.config.SyncStats@67b7b610[recordsEmitted=11458712,bytesEmitted=5650897264,stateMessagesEmitted=,recordsCommitted=]]]] 2022-04-25 13:22:32 INFO i.a.w.DefaultReplicationWorker(run):248 - Source output at least one state message 2022-04-25 13:22:32 WARN i.a.w.DefaultReplicationWorker(run):258 - State capture: No new state, falling back on input state: io.airbyte.config.State@6965aac0[state={"cdc":false,"streams":[{"stream_name":"QCS, LLC$Assembly Line","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Bank Account Ledger Entry","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Cust_ Ledger Entry","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Customer","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Detailed Cust_ Ledg_ Entry","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Detailed Vendor Ledg_ Entry","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$G_L Account","cursor_field":[],"stream_namespace":"dbo"},{"cursor":"2022-03-30T03:03:37.723000Z","stream_name":"QCS, LLC$G_L Entry","cursor_field":["Last Modified DateTime"],"stream_namespace":"dbo"},{"cursor":"2022-03-29T20:32:50.270000Z","stream_name":"QCS, LLC$G_L_ItemLevel_SQL","cursor_field":["UpdatedDate"],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Item","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Item Category","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Item Ledger Entry","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Item Status Link","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Job Ledger Entry","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Job Planning Line","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Location","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Purch_ Cr_ Memo Line","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Purch_ Inv_ Header","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Purch_ Inv_ Line","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Purch_ Rcpt_ Header","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Purchase Header","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Purchase Line","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Purchase Line Archive","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Purchase Price","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Sales Cr_Memo Header","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Sales Cr_Memo Line","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Sales Header","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Sales Invoice Header","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Sales Invoice Line","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Sales Line","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Sales Price","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Sales Shipment Header","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Sales Shipment Line","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Salesperson_Purchaser","cursor_field":[],"stream_namespace":"dbo"},{"cursor":"2022-03-30T02:38:45.420000Z","stream_name":"QCS, LLC$Stockkeeping Unit","cursor_field":["Last DateTime Modified"],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Trans_ Sales Entry","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Transaction Header","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Value Entry","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Vendor","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Vendor Ledger Entry","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Warehouse Entry","cursor_field":[],"stream_namespace":"dbo"}]}] 2022-04-25 13:22:32 INFO i.a.w.t.TemporalAttemptExecution(get):131 - Stopping cancellation check scheduling... 2022-04-25 13:22:32 INFO i.a.w.t.s.ReplicationActivityImpl(lambda$replicate$1):147 - sync summary: io.airbyte.config.StandardSyncOutput@4121dc85[standardSyncSummary=io.airbyte.config.StandardSyncSummary@69c12e66[status=failed,recordsSynced=98506711,bytesSynced=192086425487,startTime=1650856957968,endTime=1650892952634,totalStats=io.airbyte.config.SyncStats@15ea9b5d[recordsEmitted=98506711,bytesEmitted=192086425487,stateMessagesEmitted=3,recordsCommitted=0],streamStats=[io.airbyte.config.StreamSyncStats@281df9bd[streamName=QCS, LLC$Warehouse Entry,stats=io.airbyte.config.SyncStats@c67933[recordsEmitted=7973501,bytesEmitted=8789042309,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@10fe7584[streamName=QCS, LLC$Assembly Line,stats=io.airbyte.config.SyncStats@518f24b5[recordsEmitted=10669,bytesEmitted=10484703,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@1618ff28[streamName=QCS, LLC$Sales Shipment Header,stats=io.airbyte.config.SyncStats@25a40339[recordsEmitted=1314843,bytesEmitted=4660687720,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@4695005c[streamName=QCS, LLC$Sales Header,stats=io.airbyte.config.SyncStats@6e972eb7[recordsEmitted=14310,bytesEmitted=93552942,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@3f276df2[streamName=QCS, LLC$Salesperson_Purchaser,stats=io.airbyte.config.SyncStats@3a9f0ce4[recordsEmitted=804,bytesEmitted=575486,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@54e66c0b[streamName=QCS, LLC$Transaction Header,stats=io.airbyte.config.SyncStats@35312b6[recordsEmitted=1843062,bytesEmitted=3487899769,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@79fa7d3[streamName=QCS, LLC$Cust_ Ledger Entry,stats=io.airbyte.config.SyncStats@452563e8[recordsEmitted=4708367,bytesEmitted=11837440837,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@22c4c973[streamName=QCS, LLC$Sales Cr_Memo Header,stats=io.airbyte.config.SyncStats@3999b93f[recordsEmitted=60332,bytesEmitted=284039890,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@434220e0[streamName=QCS, LLC$Item Status Link,stats=io.airbyte.config.SyncStats@2d963143[recordsEmitted=97061,bytesEmitted=62153438,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@299dfad3[streamName=QCS, LLC$Location,stats=io.airbyte.config.SyncStats@5d39ee9e[recordsEmitted=60,bytesEmitted=125404,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@f2e90f9[streamName=QCS, LLC$Vendor Ledger Entry,stats=io.airbyte.config.SyncStats@132eb476[recordsEmitted=1365312,bytesEmitted=2391270731,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@55a38fa2[streamName=QCS, LLC$Item Ledger Entry,stats=io.airbyte.config.SyncStats@47fcd696[recordsEmitted=12835147,bytesEmitted=21784885371,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@3cae2fc8[streamName=QCS, LLC$Purchase Line,stats=io.airbyte.config.SyncStats@5ac5b12f[recordsEmitted=36159,bytesEmitted=209744045,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@1352fb4a[streamName=QCS, LLC$G_L Entry,stats=io.airbyte.config.SyncStats@32bbd7d0[recordsEmitted=397235,bytesEmitted=619502504,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@7fa67e20[streamName=QCS, LLC$Sales Invoice Header,stats=io.airbyte.config.SyncStats@89df432[recordsEmitted=1240982,bytesEmitted=6389742975,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@c91d6c0[streamName=QCS, LLC$Purchase Line Archive,stats=io.airbyte.config.SyncStats@60f895d5[recordsEmitted=2417983,bytesEmitted=11176850259,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@2ce3a094[streamName=QCS, LLC$Bank Account Ledger Entry,stats=io.airbyte.config.SyncStats@4b38ed5e[recordsEmitted=1972353,bytesEmitted=2253409615,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@491d152f[streamName=QCS, LLC$Stockkeeping Unit,stats=io.airbyte.config.SyncStats@6d6f77e4[recordsEmitted=179499,bytesEmitted=276985318,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@5c399ddd[streamName=QCS, LLC$G_L Account,stats=io.airbyte.config.SyncStats@50e7c919[recordsEmitted=831,bytesEmitted=804054,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@71f21a47[streamName=QCS, LLC$Item,stats=io.airbyte.config.SyncStats@673483ca[recordsEmitted=106678,bytesEmitted=892623403,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@77f33d84[streamName=QCS, LLC$Item Category,stats=io.airbyte.config.SyncStats@19328d62[recordsEmitted=79,bytesEmitted=63340,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@78739c21[streamName=QCS, LLC$Purch_ Cr_ Memo Line,stats=io.airbyte.config.SyncStats@3b1a7a36[recordsEmitted=31586,bytesEmitted=89371484,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@556b6fcc[streamName=QCS, LLC$Purch_ Inv_ Header,stats=io.airbyte.config.SyncStats@583fb19e[recordsEmitted=408547,bytesEmitted=1250859671,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@3cc9ac2c[streamName=QCS, LLC$Value Entry,stats=io.airbyte.config.SyncStats@546aba49[recordsEmitted=18565670,bytesEmitted=38857071108,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@5af1ba07[streamName=QCS, LLC$Sales Cr_Memo Line,stats=io.airbyte.config.SyncStats@7f674386[recordsEmitted=207008,bytesEmitted=523533779,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@e3e288a[streamName=QCS, LLC$Detailed Cust_ Ledg_ Entry,stats=io.airbyte.config.SyncStats@f0773f6[recordsEmitted=9575468,bytesEmitted=10778904604,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@58f1d193[streamName=QCS, LLC$Vendor,stats=io.airbyte.config.SyncStats@1dcfc278[recordsEmitted=7657,bytesEmitted=17699104,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@62cad333[streamName=QCS, LLC$Sales Invoice Line,stats=io.airbyte.config.SyncStats@5666945f[recordsEmitted=6389193,bytesEmitted=20771060534,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@4dba49[streamName=QCS, LLC$Purchase Price,stats=io.airbyte.config.SyncStats@6372743a[recordsEmitted=133378,bytesEmitted=44531407,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@5795602c[streamName=QCS, LLC$Sales Shipment Line,stats=io.airbyte.config.SyncStats@35b3d2ed[recordsEmitted=6464384,bytesEmitted=17781682204,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@58c1b9e0[streamName=QCS, LLC$Detailed Vendor Ledg_ Entry,stats=io.airbyte.config.SyncStats@28e2d566[recordsEmitted=2796921,bytesEmitted=2751977305,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@540a4456[streamName=QCS, LLC$Purch_ Inv_ Line,stats=io.airbyte.config.SyncStats@7f85d080[recordsEmitted=2268386,bytesEmitted=7281822318,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@2a5e7829[streamName=QCS, LLC$Purch_ Rcpt_ Header,stats=io.airbyte.config.SyncStats@1429d1e1[recordsEmitted=400524,bytesEmitted=1138680452,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@12070fc6[streamName=QCS, LLC$Sales Line,stats=io.airbyte.config.SyncStats@43d7dcd6[recordsEmitted=98775,bytesEmitted=559380986,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@1a916bb5[streamName=QCS, LLC$Trans_ Sales Entry,stats=io.airbyte.config.SyncStats@406d17df[recordsEmitted=1705066,bytesEmitted=4268580892,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@6a3e592b[streamName=QCS, LLC$Customer,stats=io.airbyte.config.SyncStats@177209d6[recordsEmitted=573196,bytesEmitted=2691682847,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@62f044e[streamName=QCS, LLC$Job Ledger Entry,stats=io.airbyte.config.SyncStats@2ed428bb[recordsEmitted=309245,bytesEmitted=992996632,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@36bbcb4b[streamName=QCS, LLC$Job Planning Line,stats=io.airbyte.config.SyncStats@310048f3[recordsEmitted=333013,bytesEmitted=1094994070,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@4ff327e9[streamName=QCS, LLC$G_L_ItemLevel_SQL,stats=io.airbyte.config.SyncStats@406d4f5c[recordsEmitted=197305,bytesEmitted=283829276,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@28643589[streamName=QCS, LLC$Purchase Header,stats=io.airbyte.config.SyncStats@1b90b7a6[recordsEmitted=7410,bytesEmitted=34985437,stateMessagesEmitted=,recordsCommitted=]], io.airbyte.config.StreamSyncStats@4d8a1752[streamName=QCS, LLC$Sales Price,stats=io.airbyte.config.SyncStats@67b7b610[recordsEmitted=11458712,bytesEmitted=5650897264,stateMessagesEmitted=,recordsCommitted=]]]],normalizationSummary=,state=io.airbyte.config.State@6965aac0[state={"cdc":false,"streams":[{"stream_name":"QCS, LLC$Assembly Line","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Bank Account Ledger Entry","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Cust_ Ledger Entry","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Customer","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Detailed Cust_ Ledg_ Entry","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Detailed Vendor Ledg_ Entry","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$G_L Account","cursor_field":[],"stream_namespace":"dbo"},{"cursor":"2022-03-30T03:03:37.723000Z","stream_name":"QCS, LLC$G_L Entry","cursor_field":["Last Modified DateTime"],"stream_namespace":"dbo"},{"cursor":"2022-03-29T20:32:50.270000Z","stream_name":"QCS, LLC$G_L_ItemLevel_SQL","cursor_field":["UpdatedDate"],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Item","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Item Category","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Item Ledger Entry","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Item Status Link","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Job Ledger Entry","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Job Planning Line","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Location","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Purch_ Cr_ Memo Line","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Purch_ Inv_ Header","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Purch_ Inv_ Line","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Purch_ Rcpt_ Header","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Purchase Header","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Purchase Line","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Purchase Line Archive","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Purchase Price","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Sales Cr_Memo Header","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Sales Cr_Memo Line","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Sales Header","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Sales Invoice Header","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Sales Invoice Line","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Sales Line","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Sales Price","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Sales Shipment Header","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Sales Shipment Line","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Salesperson_Purchaser","cursor_field":[],"stream_namespace":"dbo"},{"cursor":"2022-03-30T02:38:45.420000Z","stream_name":"QCS, LLC$Stockkeeping Unit","cursor_field":["Last DateTime Modified"],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Trans_ Sales Entry","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Transaction Header","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Value Entry","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Vendor","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Vendor Ledger Entry","cursor_field":[],"stream_namespace":"dbo"},{"stream_name":"QCS, LLC$Warehouse Entry","cursor_field":[],"stream_namespace":"dbo"}]}],outputCatalog=io.airbyte.protocol.models.ConfiguredAirbyteCatalog@76d1cdf7[streams=[io.airbyte.protocol.models.ConfiguredAirbyteStream@44edb3c8[stream=io.airbyte.protocol.models.AirbyteStream@b678a24[name=QCS, LLC$Assembly Line,jsonSchema={"type":"object","properties":{"No_":{"type":"string"},"Type":{"type":"number"},"Reserve":{"type":"number"},"Bin Code":{"type":"string"},"Due Date":{"type":"string"},"Line No_":{"type":"number"},"Position":{"type":"string"},"Quantity":{"type":"number"},"Unit Cost":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Position 2":{"type":"string"},"Position 3":{"type":"string"},"Cost Amount":{"type":"number"},"Description":{"type":"string"},"Qty_ Picked":{"type":"number"},"Document No_":{"type":"string"},"Quantity per":{"type":"number"},"Variant Code":{"type":"string"},"Description 2":{"type":"string"},"Document Type":{"type":"number"},"Location Code":{"type":"string"},"Avail_ Warning":{"type":"number"},"Quantity (Base)":{"type":"number"},"Dimension Set ID":{"type":"number"},"Lead-Time Offset":{"type":"string"},"Consumed Quantity":{"type":"number"},"Qty_ Picked (Base)":{"type":"number"},"Remaining Quantity":{"type":"number"},"Appl_-to Item Entry":{"type":"number"},"Quantity to Consume":{"type":"number"},"Resource Usage Type":{"type":"number"},"Unit of Measure Code":{"type":"string"},"Appl_-from Item Entry":{"type":"number"},"Inventory Posting Group":{"type":"string"},"Consumed Quantity (Base)":{"type":"number"},"Gen_ Prod_ Posting Group":{"type":"string"},"Qty_ per Unit of Measure":{"type":"number"},"Remaining Quantity (Base)":{"type":"number"},"Shortcut Dimension 1 Code":{"type":"string"},"Shortcut Dimension 2 Code":{"type":"string"},"Quantity to Consume (Base)":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Document Type], [Document No_], [Line No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Document Type], [Document No_], [Line No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@6bb52730[stream=io.airbyte.protocol.models.AirbyteStream@13f3e1c4[name=QCS, LLC$Bank Account Ledger Entry,jsonSchema={"type":"object","properties":{"Open":{"type":"number"},"Amount":{"type":"number"},"User ID":{"type":"string"},"Positive":{"type":"number"},"Reversed":{"type":"number"},"Entry No_":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Description":{"type":"string"},"Reason Code":{"type":"string"},"Source Code":{"type":"string"},"Amount (LCY)":{"type":"number"},"Debit Amount":{"type":"number"},"Document No_":{"type":"string"},"Posting Date":{"type":"string"},"Credit Amount":{"type":"number"},"Currency Code":{"type":"string"},"Document Date":{"type":"string"},"Document Type":{"type":"number"},"Statement No_":{"type":"string"},"Closed at Date":{"type":"string"},"Transaction No_":{"type":"number"},"Bal_ Account No_":{"type":"string"},"Bank Account No_":{"type":"string"},"Dimension Set ID":{"type":"number"},"Our Contact Code":{"type":"string"},"Remaining Amount":{"type":"number"},"Statement Status":{"type":"number"},"Bal_ Account Type":{"type":"number"},"Debit Amount (LCY)":{"type":"number"},"EFT Store No_ -CL-":{"type":"string"},"Journal Batch Name":{"type":"string"},"Reversed Entry No_":{"type":"number"},"Statement Line No_":{"type":"number"},"Closed by Entry No_":{"type":"number"},"Credit Amount (LCY)":{"type":"number"},"EFT Terminal No_ -CL-":{"type":"string"},"External Document No_":{"type":"string"},"Reversed by Entry No_":{"type":"number"},"Bank Acc_ Posting Group":{"type":"string"},"Global Dimension 1 Code":{"type":"string"},"Global Dimension 2 Code":{"type":"string"},"EFT Tran_ Archive Status -CL-":{"type":"number"},"EFT Transaction Entry No_ -CL-":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Entry No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Entry No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@3aa97381[stream=io.airbyte.protocol.models.AirbyteStream@da8f85a[name=QCS, LLC$Cust_ Ledger Entry,jsonSchema={"type":"object","properties":{"Open":{"type":"number"},"On Hold":{"type":"string"},"QR Code":{"type":"string","contentEncoding":"base64"},"User ID":{"type":"string"},"Due Date":{"type":"string"},"Positive":{"type":"number"},"Reversed":{"type":"number"},"Batch No_":{"type":"string"},"Entry No_":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Error Code":{"type":"string"},"No_ Series":{"type":"string"},"Prepayment":{"type":"number"},"Description":{"type":"string"},"Reason Code":{"type":"string"},"Sales (LCY)":{"type":"number"},"Source Code":{"type":"string"},"Customer No_":{"type":"string"},"Document No_":{"type":"string"},"Posting Date":{"type":"string"},"Profit (LCY)":{"type":"number"},"Applies-to ID":{"type":"string"},"Currency Code":{"type":"string"},"Document Date":{"type":"string"},"Document Type":{"type":"number"},"Exception No_":{"type":"string"},"Statement No_":{"type":"string"},"Applying Entry":{"type":"number"},"Closed at Date":{"type":"string"},"Date_Time Sent":{"type":"string"},"Your Reference":{"type":"string"},"AR Comment Code":{"type":"string"},"Amount to Apply":{"type":"number"},"IC Partner Code":{"type":"string"},"Original String":{"type":"string","contentEncoding":"base64"},"Transaction No_":{"type":"number"},"Bal_ Account No_":{"type":"string"},"Closed by Amount":{"type":"number"},"Dimension Set ID":{"type":"number"},"Salesperson Code":{"type":"string"},"Bal_ Account Type":{"type":"number"},"Date_Time Stamped":{"type":"string"},"Digital Stamp PAC":{"type":"string","contentEncoding":"base64"},"Digital Stamp SAT":{"type":"string","contentEncoding":"base64"},"Error Description":{"type":"string"},"Tax Exemption No_":{"type":"string"},"Calculate Interest":{"type":"number"},"Date_Time Canceled":{"type":"string"},"EFT Store No_ -CL-":{"type":"string"},"Journal Batch Name":{"type":"string"},"Pmt_ Discount Date":{"type":"string"},"Reversed Entry No_":{"type":"number"},"STE Transaction ID":{"type":"string"},"Applies-to Doc_ No_":{"type":"string"},"Closed by Entry No_":{"type":"number"},"Inv_ Discount (LCY)":{"type":"number"},"Payment Method Code":{"type":"string"},"Sell-to Contact No_":{"type":"string"},"Signed Document XML":{"type":"string","contentEncoding":"base64"},"Applies-to Doc_ Type":{"type":"number"},"Message to Recipient":{"type":"string"},"PAC Web Service Name":{"type":"string"},"Pmt_ Tolerance (LCY)":{"type":"number"},"Sell-to Customer No_":{"type":"string"},"EFT Terminal No_ -CL-":{"type":"string"},"External Document No_":{"type":"string"},"Original Document XML":{"type":"string","contentEncoding":"base64"},"Reversed by Entry No_":{"type":"number"},"Certificate Serial No_":{"type":"string"},"Closed by Amount (LCY)":{"type":"number"},"Customer Posting Group":{"type":"string"},"Max_ Payment Tolerance":{"type":"number"},"Pmt_ Disc_ Given (LCY)":{"type":"number"},"Recipient Bank Account":{"type":"string"},"Closed by Currency Code":{"type":"string"},"Direct Debit Mandate ID":{"type":"string"},"Global Dimension 1 Code":{"type":"string"},"Global Dimension 2 Code":{"type":"string"},"No_ of E-Documents Sent":{"type":"number"},"Adjusted Currency Factor":{"type":"number"},"Applies-to Ext_ Doc_ No_":{"type":"string"},"Electronic Document Sent":{"type":"number"},"Exported to Payment File":{"type":"number"},"Original Currency Factor":{"type":"number"},"Closed by Currency Amount":{"type":"number"},"Date_Time First Req_ Sent":{"type":"string"},"Final Payment Rating Done":{"type":"number"},"Fiscal Invoice Number PAC":{"type":"string"},"Pmt_ Disc_ Tolerance Date":{"type":"string"},"Accepted Payment Tolerance":{"type":"number"},"Debt Coll_ Issued Reminder":{"type":"number"},"Electronic Document Status":{"type":"number"},"Last Issued Reminder Level":{"type":"number"},"Closing Interest Calculated":{"type":"number"},"Original Pmt_ Disc_ Possible":{"type":"number"},"Accepted Pmt_ Disc_ Tolerance":{"type":"number"},"EFT Tran_ Archive Status -CL-":{"type":"number"},"Remaining Pmt_ Disc_ Possible":{"type":"number"},"EFT Transaction Entry No_ -CL-":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Entry No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Entry No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@4fe6c278[stream=io.airbyte.protocol.models.AirbyteStream@4317f781[name=QCS, LLC$Customer,jsonSchema={"type":"object","properties":{"Id":{"type":"string"},"GLN":{"type":"string"},"No_":{"type":"string"},"City":{"type":"string"},"Name":{"type":"string"},"Image":{"type":"string"},"Amount":{"type":"number"},"County":{"type":"string"},"E-Mail":{"type":"string"},"Name 2":{"type":"string"},"Address":{"type":"string"},"Blocked":{"type":"number"},"Contact":{"type":"string"},"Fax No_":{"type":"string"},"Old No_":{"type":"string"},"Picture":{"type":"string","contentEncoding":"base64"},"RFC No_":{"type":"string"},"Reserve":{"type":"number"},"CRM GUID":{"type":"string"},"CURP No_":{"type":"string"},"E-Mail 2":{"type":"string"},"Priority":{"type":"number"},"UPS Zone":{"type":"string"},"Address 2":{"type":"string"},"Contact 2":{"type":"string"},"Home Page":{"type":"string"},"House No_":{"type":"string"},"Phone No_":{"type":"string"},"Post Code":{"type":"string"},"Telex No_":{"type":"string"},"timestamp":{"type":"string","contentEncoding":"base64"},"Cell Phone":{"type":"string"},"Chain Name":{"type":"string"},"Contact ID":{"type":"string"},"No_ Series":{"type":"string"},"Phone Ext_":{"type":"string"},"Start Date":{"type":"string"},"Tax Liable":{"type":"number"},"Currency Id":{"type":"string"},"Customer ID":{"type":"string"},"Grandparent":{"type":"string"},"Phone No_ 2":{"type":"string"},"Reason Code":{"type":"string"},"Retainage _":{"type":"number"},"Search Name":{"type":"string"},"Tax Area ID":{"type":"string"},"CFDI Purpose":{"type":"string"},"Catalog Code":{"type":"string"},"Cell Phone 2":{"type":"string"},"Contact Type":{"type":"number"},"Date Created":{"type":"string"},"Mailing List":{"type":"number"},"Parent_Child":{"type":"string"},"Partner Type":{"type":"number"},"Payment Type":{"type":"number"},"Phone Ext_ 2":{"type":"string"},"Prepayment _":{"type":"number"},"BalanceLCYInt":{"type":"number"},"Business Name":{"type":"number"},"CFDI Relation":{"type":"string"},"Currency Code":{"type":"string"},"In City Limit":{"type":"number"},"Industry Code":{"type":"string"},"Language Code":{"type":"string"},"Location Code":{"type":"string"},"Shipment Logo":{"type":"string","contentEncoding":"base64"},"Shipping Time":{"type":"string"},"Tax Area Code":{"type":"string"},"Default Weight":{"type":"number"},"Email Invoices":{"type":"number"},"Invoice Copies":{"type":"number"},"Search Address":{"type":"string"},"Territory Code":{"type":"string"},"Web Profile ID":{"type":"string"},"Budgeted Amount":{"type":"number"},"Created by User":{"type":"string"},"Do Not Send RMA":{"type":"number"},"IC Partner Code":{"type":"string"},"Last Sales Date":{"type":"string"},"Mail Statements":{"type":"number"},"Our Account No_":{"type":"string"},"Place of Export":{"type":"string"},"Privacy Blocked":{"type":"number"},"Shipping Advice":{"type":"number"},"Tax ID No_ -CL-":{"type":"string"},"Allow Line Disc_":{"type":"number"},"Catalog Drop No_":{"type":"number"},"Contact Graph Id":{"type":"string"},"Email Preference":{"type":"number"},"Mobile Phone No_":{"type":"string"},"Payment Terms Id":{"type":"string"},"Post as Shipment":{"type":"number"},"Print Statements":{"type":"number"},"Salesperson Code":{"type":"string"},"Statistics Group":{"type":"number"},"Check Date Format":{"type":"number"},"Collection Method":{"type":"string"},"Combine Shipments":{"type":"number"},"Daytime Phone No_":{"type":"string"},"Great Grandparent":{"type":"string"},"Mailing List Code":{"type":"string"},"New Customer Flag":{"type":"number"},"Payment Method Id":{"type":"string"},"Service Zone Code":{"type":"string"},"State Inscription":{"type":"string"},"Tax Exemption No_":{"type":"string"},"Telex Answer Back":{"type":"string"},"Transaction Limit":{"type":"number"},"AmtChargedOnPOSInt":{"type":"number"},"AppendOpenInvoices":{"type":"number"},"Application Method":{"type":"number"},"Bank Communication":{"type":"number"},"Base Calendar Code":{"type":"string"},"Credit Limit (LCY)":{"type":"number"},"Email 2 Preference":{"type":"number"},"Invoice Disc_ Code":{"type":"string"},"Last Date Modified":{"type":"string"},"Last Statement No_":{"type":"number"},"Payment Terms Code":{"type":"string"},"Search E-Mail -CL-":{"type":"string"},"Shipment Method Id":{"type":"string"},"Skip on Tax Update":{"type":"number"},"AmtChargedPostedInt":{"type":"number"},"Assist_ Salesperson":{"type":"string"},"Average Days to Pay":{"type":"number"},"Country_Region Code":{"type":"string"},"Gillis Customer No_":{"type":"string"},"Key Account Manager":{"type":"string"},"Last Statement Date":{"type":"string"},"Payment Method Code":{"type":"string"},"Primary Contact No_":{"type":"string"},"Reminder Terms Code":{"type":"string"},"Shipping Agent Code":{"type":"string"},"Bill-to Customer No_":{"type":"string"},"Check Date Separator":{"type":"number"},"Customer Disc_ Group":{"type":"string"},"Customer Price Group":{"type":"string"},"Export Prices to Web":{"type":"number"},"Prices Including VAT":{"type":"number"},"Residential Delivery":{"type":"number"},"Shipment Method Code":{"type":"string"},"VAT Registration No_":{"type":"string"},"Blocked for Reporting":{"type":"string"},"Responsibility Center":{"type":"string"},"Retail Customer Group":{"type":"string"},"Customer Posting Group":{"type":"string"},"Fin_ Charge Terms Code":{"type":"string"},"Last Date Synchronized":{"type":"string"},"Last DateTime Modified":{"type":"string"},"Print Document Invoice":{"type":"number"},"Sync with Connect -CL-":{"type":"number"},"VAT Bus_ Posting Group":{"type":"string"},"Block Payment Tolerance":{"type":"number"},"Document Sending Method":{"type":"number"},"Gen_ Bus_ Posting Group":{"type":"string"},"Global Dimension 1 Code":{"type":"string"},"Global Dimension 2 Code":{"type":"string"},"Identification No_ -CL-":{"type":"string"},"Last Modified Date Time":{"type":"string"},"Tax Classification Code":{"type":"string"},"Tax Identification Type":{"type":"number"},"Document Sending Profile":{"type":"string"},"Validate EU Vat Reg_ No_":{"type":"number"},"Default Transaction Limit":{"type":"number"},"Identification State -CL-":{"type":"string"},"Restriction Functionality":{"type":"number"},"Other Tender in Finalizing":{"type":"number"},"EFT Fraud Prot_ Status -CL-":{"type":"number"},"OneSource Tax Exempt Reason":{"type":"string"},"Preferred Bank Account Code":{"type":"string"},"Shipping Agent Service Code":{"type":"string"},"Cash Flow Payment Terms Code":{"type":"string"},"Electronic Invoice Type -CL-":{"type":"number"},"Do Not Save Chk_ Act_ Nos-CL-":{"type":"number"},"Tax Exemption Expiration Date":{"type":"string"},"Copy Sell-to Addr_ to Qte From":{"type":"number"},"Do Not Save Cred_ Card Nos-CL-":{"type":"number"},"Last Click-to-Pay Stmt_Dt_-CL-":{"type":"string"},"Last Click-to-Pay Stmt_URL-CL-":{"type":"string"},"Preferred Communication Method":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@32d3b119[stream=io.airbyte.protocol.models.AirbyteStream@7873e531[name=QCS, LLC$Detailed Cust_ Ledg_ Entry,jsonSchema={"type":"object","properties":{"Amount":{"type":"number"},"Use Tax":{"type":"number"},"User ID":{"type":"string"},"Entry No_":{"type":"number"},"Unapplied":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Entry Type":{"type":"number"},"Reason Code":{"type":"string"},"Source Code":{"type":"string"},"Amount (LCY)":{"type":"number"},"Customer No_":{"type":"string"},"Debit Amount":{"type":"number"},"Document No_":{"type":"string"},"Posting Date":{"type":"string"},"Credit Amount":{"type":"number"},"Currency Code":{"type":"string"},"Document Type":{"type":"number"},"Application No_":{"type":"number"},"Transaction No_":{"type":"number"},"Debit Amount (LCY)":{"type":"number"},"EFT Store No_ -CL-":{"type":"string"},"Journal Batch Name":{"type":"string"},"Credit Amount (LCY)":{"type":"number"},"Ledger Entry Amount":{"type":"number"},"EFT Terminal No_ -CL-":{"type":"string"},"Initial Document Type":{"type":"number"},"Tax Jurisdiction Code":{"type":"string"},"Cust_ Ledger Entry No_":{"type":"number"},"Initial Entry Due Date":{"type":"string"},"Max_ Payment Tolerance":{"type":"number"},"Unapplied by Entry No_":{"type":"number"},"VAT Bus_ Posting Group":{"type":"string"},"Gen_ Bus_ Posting Group":{"type":"string"},"VAT Prod_ Posting Group":{"type":"string"},"Gen_ Prod_ Posting Group":{"type":"string"},"Initial Entry Global Dim_ 1":{"type":"string"},"Initial Entry Global Dim_ 2":{"type":"string"},"EFT Tran_ Archive Status -CL-":{"type":"number"},"Remaining Pmt_ Disc_ Possible":{"type":"number"},"Applied Cust_ Ledger Entry No_":{"type":"number"},"EFT Transaction Entry No_ -CL-":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Entry No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Entry No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@1ff1d45[stream=io.airbyte.protocol.models.AirbyteStream@7da84904[name=QCS, LLC$Detailed Vendor Ledg_ Entry,jsonSchema={"type":"object","properties":{"Amount":{"type":"number"},"Use Tax":{"type":"number"},"User ID":{"type":"string"},"Entry No_":{"type":"number"},"Unapplied":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Entry Type":{"type":"number"},"Vendor No_":{"type":"string"},"Reason Code":{"type":"string"},"Source Code":{"type":"string"},"Amount (LCY)":{"type":"number"},"Debit Amount":{"type":"number"},"Document No_":{"type":"string"},"Posting Date":{"type":"string"},"Credit Amount":{"type":"number"},"Currency Code":{"type":"string"},"Document Type":{"type":"number"},"Application No_":{"type":"number"},"Transaction No_":{"type":"number"},"Debit Amount (LCY)":{"type":"number"},"Journal Batch Name":{"type":"string"},"Credit Amount (LCY)":{"type":"number"},"Initial Document Type":{"type":"number"},"Tax Jurisdiction Code":{"type":"string"},"Initial Entry Due Date":{"type":"string"},"Max_ Payment Tolerance":{"type":"number"},"Unapplied by Entry No_":{"type":"number"},"VAT Bus_ Posting Group":{"type":"string"},"Gen_ Bus_ Posting Group":{"type":"string"},"VAT Prod_ Posting Group":{"type":"string"},"Vendor Ledger Entry No_":{"type":"number"},"Gen_ Prod_ Posting Group":{"type":"string"},"Initial Entry Global Dim_ 1":{"type":"string"},"Initial Entry Global Dim_ 2":{"type":"string"},"Remaining Pmt_ Disc_ Possible":{"type":"number"},"Applied Vend_ Ledger Entry No_":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Entry No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Entry No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@52dc74d1[stream=io.airbyte.protocol.models.AirbyteStream@356159d6[name=QCS, LLC$G_L Account,jsonSchema={"type":"object","properties":{"No_":{"type":"string"},"Name":{"type":"string"},"No_ 2":{"type":"string"},"Blocked":{"type":"number"},"Old No_":{"type":"string"},"Picture":{"type":"string","contentEncoding":"base64"},"New Page":{"type":"number"},"Totaling":{"type":"string"},"GIFI Code":{"type":"string"},"Unit Cost":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Tax Liable":{"type":"number"},"Unit Price":{"type":"number"},"Indentation":{"type":"number"},"Search Name":{"type":"string"},"Account Type":{"type":"number"},"Debit_Credit":{"type":"number"},"Cost Category":{"type":"number"},"Cost Type No_":{"type":"string"},"Tax Area Code":{"type":"string"},"Direct Posting":{"type":"number"},"Income_Balance":{"type":"number"},"Tax Group Code":{"type":"string"},"SAT Account Code":{"type":"string"},"Gen_ Posting Type":{"type":"number"},"Consol_ Debit Acc_":{"type":"string"},"Is Retainage Acct_":{"type":"number"},"Last Date Modified":{"type":"string"},"No_ of Blank Lines":{"type":"number"},"Consol_ Credit Acc_":{"type":"string"},"Automatic Ext_ Texts":{"type":"number"},"Reconciliation Account":{"type":"number"},"VAT Bus_ Posting Group":{"type":"string"},"Gen_ Bus_ Posting Group":{"type":"string"},"Global Dimension 1 Code":{"type":"string"},"Global Dimension 2 Code":{"type":"string"},"Tax Classification Code":{"type":"string"},"VAT Prod_ Posting Group":{"type":"string"},"Exchange Rate Adjustment":{"type":"number"},"Gen_ Prod_ Posting Group":{"type":"string"},"Consol_ Translation Method":{"type":"number"},"Default IC Partner G_L Acc_ No":{"type":"string"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@4c8d7f0a[stream=io.airbyte.protocol.models.AirbyteStream@73d2eff6[name=QCS, LLC$G_L Entry,jsonSchema={"type":"object","properties":{"Amount":{"type":"number"},"GST_HST":{"type":"number"},"Job No_":{"type":"string"},"Use Tax":{"type":"number"},"User ID":{"type":"string"},"Quantity":{"type":"number"},"Reversed":{"type":"number"},"Batch No_":{"type":"string"},"Entry No_":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"No_ Series":{"type":"string"},"Source No_":{"type":"string"},"Tax Liable":{"type":"number"},"VAT Amount":{"type":"number"},"Description":{"type":"string"},"Reason Code":{"type":"string"},"Source Code":{"type":"string"},"Source Type":{"type":"number"},"BI Timestamp":{"type":"string"},"Debit Amount":{"type":"number"},"Document No_":{"type":"string"},"FA Entry No_":{"type":"number"},"Posting Date":{"type":"string"},"Credit Amount":{"type":"number"},"Document Date":{"type":"string"},"Document Type":{"type":"number"},"FA Entry Type":{"type":"number"},"Tax Area Code":{"type":"string"},"Tax Group Code":{"type":"string"},"G_L Account No_":{"type":"string"},"IC Partner Code":{"type":"string"},"Prod_ Order No_":{"type":"string"},"Transaction No_":{"type":"number"},"Bal_ Account No_":{"type":"string"},"Dimension Set ID":{"type":"number"},"Prior-Year Entry":{"type":"number"},"Bal_ Account Type":{"type":"number"},"Gen_ Posting Type":{"type":"number"},"Business Unit Code":{"type":"string"},"EFT Store No_ -CL-":{"type":"string"},"Journal Batch Name":{"type":"string"},"Reversed Entry No_":{"type":"number"},"STE Transaction ID":{"type":"string"},"Job Ledger Entry No_":{"type":"number"},"System-Created Entry":{"type":"number"},"EFT Terminal No_ -CL-":{"type":"string"},"External Document No_":{"type":"string"},"Reversed by Entry No_":{"type":"number"},"Last Modified DateTime":{"type":"string"},"VAT Bus_ Posting Group":{"type":"string"},"Gen_ Bus_ Posting Group":{"type":"string"},"Global Dimension 1 Code":{"type":"string"},"Global Dimension 2 Code":{"type":"string"},"VAT Prod_ Posting Group":{"type":"string"},"Gen_ Prod_ Posting Group":{"type":"string"},"Add_-Currency Debit Amount":{"type":"number"},"Additional-Currency Amount":{"type":"number"},"Add_-Currency Credit Amount":{"type":"number"},"EFT Tran_ Archive Status -CL-":{"type":"number"},"Close Income Statement Dim_ ID":{"type":"number"},"EFT Transaction Entry No_ -CL-":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Entry No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=incremental,cursorField=[Last Modified DateTime],destinationSyncMode=append_dedup,primaryKey=[[Entry No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@429967a1[stream=io.airbyte.protocol.models.AirbyteStream@7d0929cd[name=QCS, LLC$G_L_ItemLevel_SQL,jsonSchema={"type":"object","properties":{"Seq":{"type":"number"},"Cost":{"type":"number"},"SQL ID":{"type":"string"},"Item No_":{"type":"string"},"Quantity":{"type":"number"},"Order No_":{"type":"string"},"timestamp":{"type":"string","contentEncoding":"base64"},"Job Source":{"type":"string"},"Order Date":{"type":"string"},"Source No_":{"type":"string"},"CreatedDate":{"type":"string"},"CreatedName":{"type":"string"},"Source Code":{"type":"string"},"UpdatedDate":{"type":"string"},"UpdatedName":{"type":"string"},"Bill-to City":{"type":"string"},"Bill-to Name":{"type":"string"},"Catalog Code":{"type":"string"},"Document No_":{"type":"string"},"G/L Zip Code":{"type":"string"},"Original Qty":{"type":"number"},"Posting Date":{"type":"string"},"Posting Year":{"type":"number"},"Sales Amount":{"type":"number"},"Ship-to City":{"type":"string"},"Ship-to Code":{"type":"string"},"Ship-to Name":{"type":"string"},"Variant Code":{"type":"string"},"Web Order ID":{"type":"string"},"Bill-to State":{"type":"string"},"COGS Accounts":{"type":"string"},"Document Type":{"type":"number"},"Item Cat Desc":{"type":"string"},"Posting Month":{"type":"number"},"Ship-to State":{"type":"string"},"Default Vendor":{"type":"string"},"Sales Accounts":{"type":"string"},"Sales Location":{"type":"string"},"Line Discount _":{"type":"number"},"Unit of Measure":{"type":"string"},"Bill To Zip Code":{"type":"string"},"Company Selector":{"type":"string"},"G/L Account Name":{"type":"string"},"G/L Customer No_":{"type":"string"},"Item Description":{"type":"string"},"Salesperson Code":{"type":"string"},"Ship To Zip Code":{"type":"string"},"G/L Customer City":{"type":"string"},"G/L Customer Name":{"type":"string"},"G/L Industry Code":{"type":"string"},"Mailing List Code":{"type":"string"},"G/L Customer State":{"type":"string"},"Applies-to Doc_ No_":{"type":"string"},"Bill To Customer No_":{"type":"string"},"Customer Price Group":{"type":"string"},"Inv_ Discount Amount":{"type":"number"},"Line Discount Amount":{"type":"number"},"Shipment Method Code":{"type":"string"},"Item Classification Code":{"type":"string"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Seq]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=incremental,cursorField=[UpdatedDate],destinationSyncMode=append_dedup,primaryKey=[[Seq]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@5adb7c49[stream=io.airbyte.protocol.models.AirbyteStream@3e9295bb[name=QCS, LLC$Item,jsonSchema={"type":"object","properties":{"Id":{"type":"string"},"GQI":{"type":"number"},"No_":{"type":"string"},"GTIN":{"type":"string"},"Type":{"type":"number"},"Depth":{"type":"number"},"No_ 2":{"type":"string"},"Width":{"type":"number"},"Height":{"type":"number"},"Blocked":{"type":"number"},"Picture":{"type":"string"},"Ref No_":{"type":"string"},"Reserve":{"type":"number"},"Scrap _":{"type":"number"},"BOM Type":{"type":"number"},"Critical":{"type":"number"},"Lot Nos_":{"type":"string"},"Lot Size":{"type":"number"},"New Cost":{"type":"number"},"Profit _":{"type":"number"},"ABC Sales":{"type":"number"},"Duty Code":{"type":"string"},"Fuel Item":{"type":"number"},"Shelf No_":{"type":"string"},"Type Item":{"type":"number"},"Unit Cost":{"type":"number"},"Wastage _":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"ABC Profit":{"type":"number"},"BOM Method":{"type":"number"},"Counted By":{"type":"string"},"Durability":{"type":"string"},"Duty Class":{"type":"string"},"Duty Due _":{"type":"number"},"Net Weight":{"type":"number"},"No_ Series":{"type":"string"},"Scale Item":{"type":"number"},"Tariff No_":{"type":"string"},"Unit Price":{"type":"number"},"Vendor No_":{"type":"string"},"Walco Item":{"type":"number"},"Description":{"type":"string"},"EPA Reg No_":{"type":"string"},"Routing No_":{"type":"string"},"Season Code":{"type":"string"},"Serial Nos_":{"type":"string"},"Tare Weight":{"type":"number"},"Time Bucket":{"type":"string"},"Unit Volume":{"type":"number"},"Ask for Tare":{"type":"number"},"Barcode Mask":{"type":"string"},"Block Reason":{"type":"string"},"Customer No_":{"type":"string"},"Date Created":{"type":"string"},"Freight Type":{"type":"string"},"Gross Weight":{"type":"number"},"Recipe Style":{"type":"string"},"Tax Group Id":{"type":"string"},"Temp Blocked":{"type":"number"},"Attrib 1 Code":{"type":"string"},"Attrib 2 Code":{"type":"string"},"Attrib 3 Code":{"type":"string"},"Attrib 4 Code":{"type":"string"},"Attrib 5 Code":{"type":"string"},"Budget Profit":{"type":"number"},"Date Createdx":{"type":"string"},"Description 2":{"type":"string"},"Division Code":{"type":"string"},"Main Location":{"type":"string"},"Overhead Rate":{"type":"number"},"Profit Goal _":{"type":"number"},"Reorder Point":{"type":"number"},"Standard Cost":{"type":"number"},"Warranty Card":{"type":"number"},"Costing Method":{"type":"number"},"Exclude Excess":{"type":"number"},"Gift Card -CL-":{"type":"number"},"Low-Level Code":{"type":"number"},"Order Multiple":{"type":"number"},"Overflow Level":{"type":"number"},"Tax Group Code":{"type":"string"},"WIC Applicable":{"type":"number"},"Assembly Policy":{"type":"number"},"Budget Quantity":{"type":"number"},"Budgeted Amount":{"type":"number"},"Common Item No_":{"type":"string"},"Created by User":{"type":"string"},"Dampener Period":{"type":"string"},"Def_ Ordered by":{"type":"number"},"Flushing Method":{"type":"number"},"Indirect Cost _":{"type":"number"},"Keying in Price":{"type":"number"},"Recipe Category":{"type":"string"},"Unit List Price":{"type":"number"},"Vendor Item No_":{"type":"string"},"Commission Group":{"type":"number"},"Cost is Adjusted":{"type":"number"},"Date of Increase":{"type":"string"},"Item Disc_ Group":{"type":"string"},"Item Family Code":{"type":"string"},"Labor Curr_ Cost":{"type":"number"},"Last Direct Cost":{"type":"number"},"Lifecycle Length":{"type":"string"},"Misc_ Curr_ Cost":{"type":"number"},"No Stock Posting":{"type":"number"},"Recipe Item Type":{"type":"number"},"Reorder Quantity":{"type":"number"},"Safety Lead Time":{"type":"string"},"Statistics Group":{"type":"number"},"Stockout Warning":{"type":"number"},"Units per Parcel":{"type":"number"},"Zero Price Valid":{"type":"number"},"xWarranty Period":{"type":"string"},"Available as Dish":{"type":"number"},"BOM Receipt Print":{"type":"number"},"Competitor 1 Date":{"type":"string"},"Competitor 1 Name":{"type":"string"},"Competitor 2 Date":{"type":"string"},"Competitor 2 Name":{"type":"string"},"Dampener Quantity":{"type":"number"},"Date Last Counted":{"type":"string"},"External Item No_":{"type":"string"},"Include Inventory":{"type":"number"},"Manufacturer Code":{"type":"string"},"Maximum Inventory":{"type":"number"},"Reordering Policy":{"type":"number"},"Standard BOM Cost":{"type":"number"},"Transfer Multiple":{"type":"number"},"UOM Pop-up on POS":{"type":"number"},"Use Cross-Docking":{"type":"number"},"Buyer_Planner Code":{"type":"string"},"Competitor 1 Price":{"type":"number"},"Competitor 2 Price":{"type":"number"},"Expense Curr_ Cost":{"type":"number"},"Extern_ Size+Crust":{"type":"string"},"Item Category Code":{"type":"string"},"Item Tracking Code":{"type":"string"},"Keying in Quantity":{"type":"number"},"Last Date Modified":{"type":"string"},"Last Time Modified":{"type":"string"},"Machine Curr_ Cost":{"type":"number"},"Outside Curr_ Cost":{"type":"number"},"POS Tax Group Code":{"type":"string"},"Price Includes VAT":{"type":"number"},"Product Group Code":{"type":"string"},"Production BOM No_":{"type":"string"},"Qty not in Decimal":{"type":"number"},"Rounding Precision":{"type":"number"},"Search Description":{"type":"string"},"Service Item Group":{"type":"string"},"Unit of Measure Id":{"type":"string"},"Allow Invoice Disc_":{"type":"number"},"Calculated Std Cost":{"type":"number"},"Default Tare Weight":{"type":"number"},"Item Capacity Value":{"type":"number"},"Material Curr_ Cost":{"type":"number"},"No Discount Allowed":{"type":"number"},"Original Vendor No_":{"type":"string"},"Overhead Curr_ Cost":{"type":"number"},"Recipe Version Code":{"type":"string"},"Rescheduling Period":{"type":"string"},"Standard Setup Cost":{"type":"number"},"Alternative Item No_":{"type":"string"},"Automatic Ext_ Texts":{"type":"number"},"Base Comp_ Unit Code":{"type":"string"},"Base Unit of Measure":{"type":"string"},"Comparison Unit Code":{"type":"string"},"Days Between Recount":{"type":"number"},"Def_ Ordering Method":{"type":"number"},"Duty Unit Conversion":{"type":"number"},"Gillis Ag Vendor No_":{"type":"string"},"Inventory Value Zero":{"type":"number"},"Lifecycle Curve Code":{"type":"string"},"Manufacturing Policy":{"type":"number"},"POS Cost Calculation":{"type":"number"},"Replen_ Data Profile":{"type":"string"},"Replenishment System":{"type":"number"},"Standard Router Cost":{"type":"number"},"SubJob Category Code":{"type":"string"},"Transport Curr_ Cost":{"type":"number"},"Warehouse Class Code":{"type":"string"},"BOM Receiving Explode":{"type":"number"},"Comp_ Price Incl_ VAT":{"type":"number"},"Competitor 1 Item No_":{"type":"string"},"Competitor 1 Page No_":{"type":"string"},"Competitor 2 Item No_":{"type":"string"},"Competitor 2 Page No_":{"type":"string"},"Food Stamp Applicable":{"type":"number"},"Item Error Check Code":{"type":"string"},"Last Date Lot Changed":{"type":"string"},"Last Modified by User":{"type":"string"},"Lead Time Calculation":{"type":"string"},"Lifecycle Ending Date":{"type":"string"},"Order Tracking Policy":{"type":"number"},"Price Unit Conversion":{"type":"number"},"Purch_ Order Delivery":{"type":"number"},"Qty_ Becomes Negative":{"type":"number"},"Replenish as Item No_":{"type":"string"},"Safety Stock Quantity":{"type":"number"},"Sales Unit of Measure":{"type":"string"},"Suggested Qty_ on POS":{"type":"number"},"Confidence Factor Code":{"type":"string"},"Dispense Printer Group":{"type":"string"},"Expiration Calculation":{"type":"string"},"Field Labor Curr_ Cost":{"type":"number"},"Last Date Synchronized":{"type":"string"},"Last DateTime Modified":{"type":"string"},"Max_ Ingr_ + Modifiers":{"type":"number"},"Maximum Order Quantity":{"type":"number"},"Minimum Order Quantity":{"type":"number"},"Next Counting End Date":{"type":"string"},"Production Time (Min_)":{"type":"number"},"Purch_ Unit of Measure":{"type":"string"},"Put-away Template Code":{"type":"string"},"Recipe Main Ingredient":{"type":"string"},"Recipe No_ of Portions":{"type":"number"},"Retail Item in Catalog":{"type":"number"},"Special Equipment Code":{"type":"string"},"Std Cost Calc Lot Size":{"type":"number"},"Sync with Connect -CL-":{"type":"number"},"Use EAN Standard Barc_":{"type":"number"},"Variant Framework Code":{"type":"string"},"Allow Online Adjustment":{"type":"number"},"Discrete Order Quantity":{"type":"number"},"Global Dimension 1 Code":{"type":"string"},"Global Dimension 2 Code":{"type":"string"},"Inventory Posting Group":{"type":"string"},"Item Error Check Status":{"type":"number"},"Lifecycle Starting Date":{"type":"string"},"Lot Accumulation Period":{"type":"string"},"Macola Avg_ Daily Usage":{"type":"number"},"Max_ Modifiers No Price":{"type":"number"},"Rolled-up Capacity Cost":{"type":"number"},"Rolled-up Material Cost":{"type":"number"},"SAT Item Classification":{"type":"string"},"Tax Classification Code":{"type":"string"},"VAT Prod_ Posting Group":{"type":"string"},"Competitor 1 Catalog No_":{"type":"string"},"Competitor 2 Catalog No_":{"type":"string"},"Gen_ Prod_ Posting Group":{"type":"string"},"Item Classification Code":{"type":"string"},"Last Date Std Cost Calcd":{"type":"string"},"Modifying Date of Status":{"type":"string"},"Next Counting Start Date":{"type":"string"},"Original Vendor Item No_":{"type":"string"},"Price Increase Vendor ID":{"type":"string"},"Price_Profit Calculation":{"type":"number"},"Qty_ per Base Comp_ Unit":{"type":"number"},"Replenishment Grade Code":{"type":"string"},"Rolled-up Mfg_ Ovhd Cost":{"type":"number"},"Unit Price Including VAT":{"type":"number"},"Variant Attribute Code 1":{"type":"string"},"Variant Attribute Code 2":{"type":"string"},"Application Wksh_ User ID":{"type":"string"},"Disable Dispense Printing":{"type":"number"},"Last Date Curr_Cost Calcd":{"type":"string"},"Last DateTime Modified-CS":{"type":"string"},"Last Unit Cost Calc_ Date":{"type":"string"},"Unaff_ by Multipl_ Factor":{"type":"number"},"Created From Nonstock Item":{"type":"number"},"Effective Inv_ Sales Order":{"type":"number"},"Error Check Internal Usage":{"type":"number"},"Exclude from Replenishment":{"type":"number"},"Prevent Negative Inventory":{"type":"number"},"Replen_ Transfer Rule Code":{"type":"string"},"Select Lowest Price Vendor":{"type":"number"},"Single-Level Capacity Cost":{"type":"number"},"Single-Level Material Cost":{"type":"number"},"BOM Cost Price Distribution":{"type":"number"},"Direct Job Purchases (Qty_)":{"type":"number"},"Est_ Production Qty per Day":{"type":"number"},"Last Counting Period Update":{"type":"string"},"Manual Estimated Daily Sale":{"type":"number"},"Max_ Ingr_ Removed No Price":{"type":"number"},"Print Variants Shelf Labels":{"type":"number"},"Replenishment Sales Profile":{"type":"string"},"Single-Level Cap_ Ovhd Cost":{"type":"number"},"Single-Level Mfg_ Ovhd Cost":{"type":"number"},"Store Forward Sales Profile":{"type":"string"},"Auto Enter Serial No_ Master":{"type":"number"},"Display Instruct_ in Monitor":{"type":"number"},"Effective Inv_ Purchase Ord_":{"type":"number"},"Effective Inv_ Transfer Inb_":{"type":"number"},"Excluded from Portion Weight":{"type":"number"},"Like for Like Process Method":{"type":"number"},"Like for Like Replen_ Method":{"type":"number"},"Rolled-up Cap_ Overhead Cost":{"type":"number"},"Rolled-up Subcontracted Cost":{"type":"number"},"Single-Level Subcontrd_ Cost":{"type":"number"},"Source of FG Production Cost":{"type":"number"},"VAT Bus_ Posting Gr_ (Price)":{"type":"string"},"Wareh_ Forward Sales Profile":{"type":"string"},"Country_Region Purchased Code":{"type":"string"},"Country_Region of Origin Code":{"type":"string"},"Effective Inv_ Transfer Outb_":{"type":"number"},"Exclude from Menu Requisition":{"type":"number"},"Put-away Unit of Measure Code":{"type":"string"},"Replenish as Item No - Method":{"type":"number"},"Skip Compression When Printed":{"type":"number"},"Skip Compression When Scanned":{"type":"number"},"Store Stock Cover Reqd (Days)":{"type":"number"},"Wareh Stock Cover Reqd (Days)":{"type":"number"},"Default Deferral Template Code":{"type":"string"},"Display Ingredients in Monitor":{"type":"number"},"Explode BOM in Statem_ Posting":{"type":"number"},"Ignore on Cost Pricing Routine":{"type":"number"},"Last Date Standrd Cost Changed":{"type":"string"},"Phys Invt Counting Period Code":{"type":"string"},"Replenishment Calculation Type":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@37bf59a7[stream=io.airbyte.protocol.models.AirbyteStream@3cc49dc[name=QCS, LLC$Item Category,jsonSchema={"type":"object","properties":{"Id":{"type":"string"},"Code":{"type":"string"},"Buyer ID":{"type":"string"},"Negative":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Description":{"type":"string"},"Indentation":{"type":"number"},"Has Children":{"type":"number"},"Division Code":{"type":"string"},"Profit Goal _":{"type":"number"},"Parent Category":{"type":"string"},"Buyer Group Code":{"type":"string"},"Default Profit _":{"type":"number"},"Difference (LCY)":{"type":"number"},"Not Discountable":{"type":"number"},"Item Template Code":{"type":"string"},"Presentation Order":{"type":"number"},"Allocation Rule Code":{"type":"string"},"Item Hierarchy Value":{"type":"string"},"POS Inventory Lookup":{"type":"number"},"Replen_ Data Profile":{"type":"string"},"Def_ Item Distr_ Code":{"type":"string"},"Def_ Item Distr_ Type":{"type":"number"},"Item Error Check Code":{"type":"string"},"Suggested Qty_ on POS":{"type":"number"},"Dispense Printer Group":{"type":"string"},"Item No_ Miscellaneous":{"type":"string"},"Dispense Print Seq_ No_":{"type":"number"},"Last Modified Date Time":{"type":"string"},"Replen_ Transfer Rule Code":{"type":"string"},"Phys Invt Counting Period Code":{"type":"string"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Code]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Code]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@2f454d8[stream=io.airbyte.protocol.models.AirbyteStream@28613670[name=QCS, LLC$Item Ledger Entry,jsonSchema={"type":"object","properties":{"Area":{"type":"string"},"Open":{"type":"number"},"Job No_":{"type":"string"},"Lot No_":{"type":"string"},"Item No_":{"type":"string"},"Nonstock":{"type":"number"},"Positive":{"type":"number"},"Quantity":{"type":"number"},"Batch No_":{"type":"string"},"Entry No_":{"type":"number"},"Job No_ 2":{"type":"string"},"Offer No_":{"type":"string"},"Order No_":{"type":"string"},"timestamp":{"type":"string","contentEncoding":"base64"},"Correction":{"type":"number"},"Entry Type":{"type":"number"},"No_ Series":{"type":"string"},"Order Type":{"type":"number"},"Serial No_":{"type":"string"},"Source No_":{"type":"string"},"Description":{"type":"string"},"Source Type":{"type":"number"},"Document No_":{"type":"string"},"Job Purchase":{"type":"number"},"Job Task No_":{"type":"string"},"Posting Date":{"type":"string"},"Variant Code":{"type":"string"},"Document Date":{"type":"string"},"Document Type":{"type":"number"},"Drop Shipment":{"type":"number"},"Item Tracking":{"type":"number"},"Location Code":{"type":"string"},"Promotion No_":{"type":"string"},"Statement No_":{"type":"string"},"Transfer Type":{"type":"number"},"Warranty Date":{"type":"string"},"Master Job No_":{"type":"string"},"Order Line No_":{"type":"number"},"Budget Line No_":{"type":"number"},"Expiration Date":{"type":"string"},"Purchasing Code":{"type":"string"},"Applies-to Entry":{"type":"number"},"Dimension Set ID":{"type":"number"},"Entry_Exit Point":{"type":"string"},"Transaction Type":{"type":"string"},"Transport Method":{"type":"string"},"Assemble to Order":{"type":"number"},"Document Line No_":{"type":"number"},"Invoiced Quantity":{"type":"number"},"Last Invoice Date":{"type":"string"},"Item Category Code":{"type":"string"},"Product Group Code":{"type":"string"},"Remaining Quantity":{"type":"number"},"Return Reason Code":{"type":"string"},"Completely Invoiced":{"type":"number"},"Country_Region Code":{"type":"string"},"Cross-Reference No_":{"type":"string"},"Unit of Measure Code":{"type":"string"},"External Document No_":{"type":"string"},"Job Inv Cost Allocated":{"type":"number"},"Originally Ordered No_":{"type":"string"},"Applied Entry to Adjust":{"type":"number"},"Global Dimension 1 Code":{"type":"string"},"Global Dimension 2 Code":{"type":"string"},"Qty_ per Unit of Measure":{"type":"number"},"Out-of-Stock Substitution":{"type":"number"},"Shipped Qty_ Not Returned":{"type":"number"},"Transaction Specification":{"type":"string"},"Derived from Blanket Order":{"type":"number"},"Prod_ Order Comp_ Line No_":{"type":"number"},"Originally Ordered Var_ Code":{"type":"string"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Entry No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Entry No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@655e20ba[stream=io.airbyte.protocol.models.AirbyteStream@43d0764[name=QCS, LLC$Item Status Link,jsonSchema={"type":"object","properties":{"Comment":{"type":"string"},"Item No_":{"type":"string"},"timestamp":{"type":"string","contentEncoding":"base64"},"Created by":{"type":"string"},"Status Code":{"type":"string"},"Variant Code":{"type":"string"},"Location Code":{"type":"string"},"Starting Date":{"type":"string"},"Block Discount":{"type":"number"},"Block Purchasing":{"type":"number"},"Store Group Code":{"type":"string"},"Block Sale on POS":{"type":"number"},"Block Sales Return":{"type":"number"},"Block Transferring":{"type":"number"},"Block Promotion Price":{"type":"number"},"Block Purchase Return":{"type":"number"},"Created Date and Time":{"type":"string"},"Block Periodic Discount":{"type":"number"},"Variant Dimension 1 Code":{"type":"string"},"Block Manual Price Change":{"type":"number"},"Block Negative Adjustment":{"type":"number"},"Block Positive Adjustment":{"type":"number"},"Block Sale in Sales Order":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Item No_], [Variant Dimension 1 Code], [Variant Code], [Store Group Code], [Location Code], [Starting Date]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Item No_], [Variant Dimension 1 Code], [Variant Code], [Store Group Code], [Location Code], [Starting Date]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@244fd1af[stream=io.airbyte.protocol.models.AirbyteStream@5bca1e0[name=QCS, LLC$Job Ledger Entry,jsonSchema={"type":"object","properties":{"No_":{"type":"string"},"Area":{"type":"string"},"Open":{"type":"number"},"Type":{"type":"number"},"Scrap":{"type":"number"},"PO No_":{"type":"string"},"Job No_":{"type":"string"},"Lot No_":{"type":"string"},"User ID":{"type":"string"},"Adjusted":{"type":"number"},"Bin Code":{"type":"string"},"Job Type":{"type":"number"},"Positive":{"type":"number"},"Quantity":{"type":"number"},"Step No_":{"type":"number"},"Entry No_":{"type":"number"},"Line Type":{"type":"number"},"Unit Cost":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Chargeable":{"type":"number"},"Entry Type":{"type":"number"},"Job Status":{"type":"number"},"No_ Series":{"type":"string"},"Phase Code":{"type":"string"},"Recognized":{"type":"number"},"Serial No_":{"type":"string"},"Total Cost":{"type":"number"},"Unit Price":{"type":"number"},"Description":{"type":"string"},"Line Amount":{"type":"number"},"PO Line No_":{"type":"number"},"Reason Code":{"type":"string"},"Source Code":{"type":"string"},"Total Price":{"type":"number"},"Burden Entry":{"type":"number"},"Document No_":{"type":"string"},"Job Task No_":{"type":"string"},"Posting Date":{"type":"string"},"Receipt Date":{"type":"string"},"Total Amount":{"type":"number"},"Variant Code":{"type":"string"},"Applies-to ID":{"type":"string"},"Cost Category":{"type":"number"},"Currency Code":{"type":"string"},"Description 2":{"type":"string"},"Document Date":{"type":"string"},"Location Code":{"type":"string"},"Overhead Date":{"type":"string"},"Step Finished":{"type":"number"},"Closed at Date":{"type":"string"},"Master Job No_":{"type":"string"},"Work Type Code":{"type":"string"},"Amt_ Recognized":{"type":"number"},"Currency Factor":{"type":"number"},"Job Project No_":{"type":"string"},"Line Discount _":{"type":"number"},"Quantity (Base)":{"type":"number"},"Recognized Date":{"type":"string"},"Sales Order No_":{"type":"string"},"Unit Cost (LCY)":{"type":"number"},"Closed by Amount":{"type":"number"},"Dimension Set ID":{"type":"number"},"Entry_Exit Point":{"type":"string"},"Ledger Entry No_":{"type":"number"},"Overhead Applied":{"type":"number"},"Receipt Doc_ No_":{"type":"string"},"Receipt Line No_":{"type":"number"},"Remaining Amount":{"type":"number"},"Sub Subjob Costs":{"type":"number"},"Task Description":{"type":"string"},"Total Cost (LCY)":{"type":"number"},"Transaction Type":{"type":"string"},"Transport Method":{"type":"string"},"Unit Price (LCY)":{"type":"number"},"Amt_ to Recognize":{"type":"number"},"DateTime Adjusted":{"type":"string"},"Is Retainage Line":{"type":"number"},"Job Posting Group":{"type":"string"},"Ledger Entry Type":{"type":"number"},"Line Amount (LCY)":{"type":"number"},"Service Order No_":{"type":"string"},"Total Price (LCY)":{"type":"number"},"Amt_ Posted to G_L":{"type":"number"},"Item Category Code":{"type":"string"},"Journal Batch Name":{"type":"string"},"Original Unit Cost":{"type":"number"},"Person Responsible":{"type":"string"},"Purchase Order No_":{"type":"string"},"Resource Group No_":{"type":"string"},"Source Description":{"type":"string"},"Amt_ to Post to G_L":{"type":"number"},"Closed by Entry No_":{"type":"number"},"Country_Region Code":{"type":"string"},"Original Total Cost":{"type":"number"},"Approval History No_":{"type":"number"},"Bill-to Customer No_":{"type":"string"},"Customer Price Group":{"type":"string"},"From Over Production":{"type":"number"},"Line Discount Amount":{"type":"number"},"Unit of Measure Code":{"type":"string"},"External Document No_":{"type":"string"},"Item Ledger Entry No_":{"type":"number"},"Uncalculated WIP Cost":{"type":"number"},"Burden Expense Account":{"type":"string"},"Direct Unit Cost (LCY)":{"type":"number"},"Job Contract Entry No_":{"type":"number"},"Linked Sales Order No_":{"type":"string"},"Drop Ship Special Order":{"type":"number"},"Gen_ Bus_ Posting Group":{"type":"string"},"Global Dimension 1 Code":{"type":"string"},"Global Dimension 2 Code":{"type":"string"},"WIP Cost Balance in G_L":{"type":"number"},"WIP Rev_ Balance in G_L":{"type":"number"},"Gen_ Prod_ Posting Group":{"type":"string"},"Original Unit Cost (LCY)":{"type":"number"},"Qty_ per Unit of Measure":{"type":"number"},"Uncalculated WIP Revenue":{"type":"number"},"Add_-Currency Line Amount":{"type":"number"},"Add_-Currency Total Price":{"type":"number"},"Original Total Cost (ACY)":{"type":"number"},"Original Total Cost (LCY)":{"type":"number"},"Transaction Specification":{"type":"string"},"WIP Cost Calcd Not Posted":{"type":"number"},"WIP Rev_ Calcd Not Posted":{"type":"number"},"Line Discount Amount (LCY)":{"type":"number"},"Posted Service Shipment No_":{"type":"string"},"WIP Cost Calcd to Recognize":{"type":"number"},"WIP Rev_ Calcd to Recognize":{"type":"number"},"Additional-Currency Total Cost":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Entry No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Entry No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@11731a1d[stream=io.airbyte.protocol.models.AirbyteStream@7d193970[name=QCS, LLC$Job Planning Line,jsonSchema={"type":"object","properties":{"No_":{"type":"string"},"Type":{"type":"number"},"VAT _":{"type":"number"},"Ignore":{"type":"number"},"Status":{"type":"number"},"Comment":{"type":"string"},"Job No_":{"type":"string"},"Lot No_":{"type":"string"},"Planned":{"type":"number"},"Reserve":{"type":"number"},"User ID":{"type":"string"},"Bin Code":{"type":"string"},"Due Date":{"type":"string"},"Ext_ Qty":{"type":"number"},"Job Type":{"type":"number"},"Line No_":{"type":"number"},"Quantity":{"type":"number"},"BOM Level":{"type":"number"},"From Task":{"type":"number"},"Line Type":{"type":"number"},"No Update":{"type":"number"},"Type Item":{"type":"number"},"Unit Cost":{"type":"number"},"Wait Line":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Fixed Cost":{"type":"number"},"Phase Code":{"type":"string"},"Serial No_":{"type":"string"},"Setup Line":{"type":"number"},"Total Cost":{"type":"number"},"Unit Price":{"type":"number"},"Usage Link":{"type":"number"},"Cost Factor":{"type":"number"},"Description":{"type":"string"},"Drawing No_":{"type":"string"},"Line Amount":{"type":"number"},"Print on PO":{"type":"number"},"Qty_ Posted":{"type":"number"},"Send to Jnl":{"type":"number"},"Total Price":{"type":"number"},"Document No_":{"type":"string"},"Job Exploded":{"type":"number"},"Job Task No_":{"type":"string"},"Qty Per Unit":{"type":"number"},"Variant Code":{"type":"string"},"Contract Line":{"type":"number"},"Cost Category":{"type":"number"},"Currency Code":{"type":"string"},"Currency Date":{"type":"string"},"Description 2":{"type":"string"},"Document Date":{"type":"string"},"In Production":{"type":"number"},"Location Code":{"type":"string"},"Planning Date":{"type":"string"},"Run Time Line":{"type":"number"},"Schedule Line":{"type":"number"},"Starting Date":{"type":"string"},"Master Job No_":{"type":"string"},"Parent Job No_":{"type":"string"},"Remaining Qty_":{"type":"number"},"VAT Unit Price":{"type":"number"},"Work Type Code":{"type":"string"},"Currency Factor":{"type":"number"},"Is Change Order":{"type":"number"},"Job Project No_":{"type":"string"},"Line Discount _":{"type":"number"},"Outstanding Qty":{"type":"number"},"Parent Item Qty":{"type":"number"},"Qty_ to Invoice":{"type":"number"},"Quantity (Base)":{"type":"number"},"Revision Change":{"type":"number"},"Sent to Job Jrn":{"type":"number"},"Unit Cost (LCY)":{"type":"number"},"VAT Line Amount":{"type":"number"},"Vendor Item No_":{"type":"string"},"Change Order No_":{"type":"string"},"Drawing Item No_":{"type":"string"},"JEB Created Line":{"type":"number"},"Ledger Entry No_":{"type":"number"},"Total Cost (LCY)":{"type":"number"},"Unit Price (LCY)":{"type":"number"},"Last Revision No_":{"type":"string"},"Ledger Entry Type":{"type":"number"},"Line Amount (LCY)":{"type":"number"},"Original Item No_":{"type":"string"},"Posted Total Cost":{"type":"number"},"Reordering Policy":{"type":"number"},"Sales Invoice No_":{"type":"string"},"Service Order No_":{"type":"string"},"Total Price (LCY)":{"type":"number"},"Last Date Modified":{"type":"string"},"Person Responsible":{"type":"string"},"Posted Line Amount":{"type":"number"},"Resource Group No_":{"type":"string"},"Buy-from Vendor No_":{"type":"string"},"Country_Region Code":{"type":"string"},"Exploded Line Entry":{"type":"number"},"Overhead Calculated":{"type":"number"},"Production Complete":{"type":"number"},"Qty_ to Requisition":{"type":"number"},"Attached To Line No_":{"type":"number"},"Base Job Project No_":{"type":"string"},"Bill-to Customer No_":{"type":"string"},"Customer Price Group":{"type":"string"},"Job Ledger Entry No_":{"type":"number"},"Line Discount Amount":{"type":"number"},"Overhead Parent Line":{"type":"number"},"Production Lead Time":{"type":"number"},"Referenced in Import":{"type":"number"},"Remaining Total Cost":{"type":"number"},"System-Created Entry":{"type":"number"},"Transferred to Quote":{"type":"number"},"Unit of Measure Code":{"type":"string"},"Original Variant Code":{"type":"string"},"Planned Delivery Date":{"type":"string"},"Remaining Line Amount":{"type":"number"},"Remaining Qty_ (Base)":{"type":"number"},"Send to Line Comments":{"type":"number"},"Direct Unit Cost (LCY)":{"type":"number"},"Job Contract Entry No_":{"type":"number"},"Outstanding Qty (Base)":{"type":"number"},"Promised Delivery Date":{"type":"string"},"Gen_ Bus_ Posting Group":{"type":"string"},"Global Dimension 1 Code":{"type":"string"},"Global Dimension 2 Code":{"type":"string"},"Posted Total Cost (LCY)":{"type":"number"},"Requested Delivery Date":{"type":"string"},"Do Not Copy to Job Usage":{"type":"number"},"Gen_ Prod_ Posting Group":{"type":"string"},"Posted Line Amount (LCY)":{"type":"number"},"Qty_ per Unit of Measure":{"type":"number"},"VAT Line Discount Amount":{"type":"number"},"Line Discount Amount (LCY)":{"type":"number"},"Remaining Total Cost (LCY)":{"type":"number"},"Qty_ to Transfer to Invoice":{"type":"number"},"Qty_ to Transfer to Journal":{"type":"number"},"Remaining Line Amount (LCY)":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Job No_], [Job Task No_], [Line No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Job No_], [Job Task No_], [Line No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@27015dd5[stream=io.airbyte.protocol.models.AirbyteStream@47d25b74[name=QCS, LLC$Location,jsonSchema={"type":"object","properties":{"City":{"type":"string"},"Code":{"type":"string"},"Name":{"type":"string"},"County":{"type":"string"},"E-Mail":{"type":"string"},"Name 2":{"type":"string"},"Region":{"type":"number"},"Address":{"type":"string"},"Contact":{"type":"string"},"Fax No_":{"type":"string"},"Latitude":{"type":"number"},"Use ADCS":{"type":"number"},"Address 2":{"type":"string"},"Home Page":{"type":"string"},"Longitude":{"type":"number"},"Phone No_":{"type":"string"},"Post Code":{"type":"string"},"Telex No_":{"type":"string"},"timestamp":{"type":"string","contentEncoding":"base64"},"CO Priority":{"type":"number"},"Data Source":{"type":"number"},"Phone No_ 2":{"type":"string"},"Customer No_":{"type":"string"},"Require Pick":{"type":"number"},"Use Transfer":{"type":"number"},"Bin Mandatory":{"type":"number"},"CSR Inventory":{"type":"number"},"Tax Area Code":{"type":"string"},"Default Weight":{"type":"number"},"Allow Breakbulk":{"type":"number"},"Master Location":{"type":"string"},"Require Receive":{"type":"number"},"Retail Location":{"type":"number"},"Default Bin Code":{"type":"string"},"Mark as Inactive":{"type":"number"},"Odyssee Location":{"type":"number"},"Receipt Bin Code":{"type":"string"},"Require Put-away":{"type":"number"},"Require Shipment":{"type":"number"},"Shipment Bin Code":{"type":"string"},"Special Equipment":{"type":"number"},"Tax Exemption No_":{"type":"string"},"Use As In-Transit":{"type":"number"},"Use Cross-Docking":{"type":"number"},"Base Calendar Code":{"type":"string"},"Forecasting Status":{"type":"number"},"Adjustment Bin Code":{"type":"string"},"Bin Capacity Policy":{"type":"number"},"CO Will Ship orders":{"type":"number"},"Country_Region Code":{"type":"string"},"Cross-Dock Bin Code":{"type":"string"},"Data Source Company":{"type":"string"},"Replenishment Group":{"type":"string"},"To-Assembly Bin Code":{"type":"string"},"Default Bin Selection":{"type":"number"},"From-Assembly Bin Code":{"type":"string"},"Pick According to FEFO":{"type":"number"},"Put-away Template Code":{"type":"string"},"To-Production Bin Code":{"type":"string"},"Use Put-away Worksheet":{"type":"number"},"Always Create Pick Line":{"type":"number"},"Freight Department Code":{"type":"string"},"Global Dimension 1 Code":{"type":"string"},"Global Dimension 2 Code":{"type":"string"},"Location is a Warehouse":{"type":"number"},"CO Lead Time Calculation":{"type":"string"},"From-Production Bin Code":{"type":"string"},"Open Shop Floor Bin Code":{"type":"string"},"Provincial Tax Area Code":{"type":"string"},"Cross-Dock Due Date Calc_":{"type":"string"},"Odyssee Stock Location id":{"type":"string"},"Use Planned Cross Docking":{"type":"number"},"CO Orders can be Collected":{"type":"number"},"Directed Put-away and Pick":{"type":"number"},"Replenish as Location Code":{"type":"string"},"Always Create Put-away Line":{"type":"number"},"Inbound Whse_ Handling Time":{"type":"string"},"Include in Web Stock Levels":{"type":"number"},"Asm_-to-Order Shpt_ Bin Code":{"type":"string"},"Outbound Whse_ Handling Time":{"type":"string"},"Active for Autom_ Replenishm_":{"type":"number"},"Default Replenishm_ Grade Code":{"type":"string"},"Do Not Use For Tax Calculation":{"type":"number"},"Web Order Fulfillment Sequence":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@4ef81261[stream=io.airbyte.protocol.models.AirbyteStream@7a9e7077[name=QCS, LLC$Purch_ Cr_ Memo Line,jsonSchema={"type":"object","properties":{"No_":{"type":"string"},"Area":{"type":"string"},"Type":{"type":"number"},"VAT _":{"type":"number"},"Amount":{"type":"number"},"Job No_":{"type":"string"},"Use Tax":{"type":"number"},"Bin Code":{"type":"string"},"Job Type":{"type":"number"},"Line No_":{"type":"number"},"Nonstock":{"type":"number"},"Quantity":{"type":"number"},"Unit Cost":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Net Weight":{"type":"number"},"Phase Code":{"type":"string"},"Tax Liable":{"type":"number"},"Description":{"type":"string"},"Entry Point":{"type":"string"},"Line Amount":{"type":"number"},"Unit Volume":{"type":"number"},"Document No_":{"type":"string"},"Gross Weight":{"type":"number"},"Job Task No_":{"type":"string"},"Posting Date":{"type":"string"},"Variant Code":{"type":"string"},"Cost Category":{"type":"number"},"Description 2":{"type":"string"},"Insurance No_":{"type":"string"},"Job Line Type":{"type":"number"},"Location Code":{"type":"string"},"Posting Group":{"type":"string"},"Salvage Value":{"type":"number"},"Tax Area Code":{"type":"string"},"Job Unit Price":{"type":"number"},"Master Job No_":{"type":"string"},"Tax Group Code":{"type":"string"},"VAT Difference":{"type":"number"},"VAT Identifier":{"type":"string"},"Work Type Code":{"type":"string"},"Budgeted FA No_":{"type":"string"},"FA Posting Date":{"type":"string"},"FA Posting Type":{"type":"number"},"IC Partner Code":{"type":"string"},"IRS 1099 Liable":{"type":"number"},"Indirect Cost _":{"type":"number"},"Job Line Amount":{"type":"number"},"Job Project No_":{"type":"string"},"Job Total Price":{"type":"number"},"Line Discount _":{"type":"number"},"Prepayment Line":{"type":"number"},"Prod_ Order No_":{"type":"string"},"Purchasing Code":{"type":"string"},"Quantity (Base)":{"type":"number"},"Unit Cost (LCY)":{"type":"number"},"Unit of Measure":{"type":"string"},"VAT Base Amount":{"type":"number"},"Vendor Item No_":{"type":"string"},"Dimension Set ID":{"type":"number"},"Direct Unit Cost":{"type":"number"},"Maintenance Code":{"type":"string"},"Task Description":{"type":"string"},"Transaction Type":{"type":"string"},"Transport Method":{"type":"string"},"Unit Price (LCY)":{"type":"number"},"Units per Parcel":{"type":"number"},"Blanket Order No_":{"type":"string"},"Job Currency Code":{"type":"string"},"Pay-to Vendor No_":{"type":"string"},"Item Category Code":{"type":"string"},"Person Responsible":{"type":"string"},"Product Group Code":{"type":"string"},"Return Reason Code":{"type":"string"},"Allow Invoice Disc_":{"type":"number"},"Appl_-to Item Entry":{"type":"number"},"Buy-from Vendor No_":{"type":"string"},"Cross-Reference No_":{"type":"string"},"Job Currency Factor":{"type":"number"},"Job Line Discount _":{"type":"number"},"Return Shipment No_":{"type":"string"},"Variant Description":{"type":"string"},"Amount Including VAT":{"type":"number"},"Attached to Line No_":{"type":"number"},"Bill-to Customer No_":{"type":"string"},"Cross-Reference Type":{"type":"number"},"IC Partner Ref_ Type":{"type":"number"},"IC Partner Reference":{"type":"string"},"Inv_ Discount Amount":{"type":"number"},"Job Unit Price (LCY)":{"type":"number"},"Line Discount Amount":{"type":"number"},"Purchase Voucher No_":{"type":"string"},"System-Created Entry":{"type":"number"},"Unit of Measure Code":{"type":"string"},"Use Duplication List":{"type":"number"},"VAT Calculation Type":{"type":"number"},"Expected Receipt Date":{"type":"string"},"Job Line Amount (LCY)":{"type":"number"},"Job Total Price (LCY)":{"type":"number"},"Responsibility Center":{"type":"string"},"Blanket Order Line No_":{"type":"number"},"Depr_ Acquisition Cost":{"type":"number"},"Depreciation Book Code":{"type":"string"},"VAT Bus_ Posting Group":{"type":"string"},"Gen_ Bus_ Posting Group":{"type":"string"},"VAT Prod_ Posting Group":{"type":"string"},"Cross-Reference Type No_":{"type":"string"},"Gen_ Prod_ Posting Group":{"type":"string"},"Job Line Discount Amount":{"type":"number"},"Provincial Tax Area Code":{"type":"string"},"Qty_ per Unit of Measure":{"type":"number"},"Return Shipment Line No_":{"type":"number"},"Shortcut Dimension 1 Code":{"type":"string"},"Shortcut Dimension 2 Code":{"type":"string"},"Transaction Specification":{"type":"string"},"Exclude from Payment Disc_":{"type":"number"},"Depr_ until FA Posting Date":{"type":"number"},"Job Line Disc_ Amount (LCY)":{"type":"number"},"Unit of Measure (Cross Ref_)":{"type":"string"},"Duplicate in Depreciation Book":{"type":"string"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Document No_], [Line No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Document No_], [Line No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@57dc7504[stream=io.airbyte.protocol.models.AirbyteStream@2808d70[name=QCS, LLC$Purch_ Inv_ Header,jsonSchema={"type":"object","properties":{"Id":{"type":"string"},"No_":{"type":"string"},"Area":{"type":"string"},"On Hold":{"type":"string"},"User ID":{"type":"string"},"Due Date":{"type":"string"},"Order No_":{"type":"string"},"Quote No_":{"type":"string"},"Store No_":{"type":"string"},"timestamp":{"type":"string","contentEncoding":"base64"},"Correction":{"type":"number"},"No_ Series":{"type":"string"},"Order Date":{"type":"string"},"Tax Liable":{"type":"number"},"Entry Point":{"type":"string"},"No_ Printed":{"type":"number"},"Pay-to City":{"type":"string"},"Pay-to Name":{"type":"string"},"Reason Code":{"type":"string"},"Source Code":{"type":"string"},"Campaign No_":{"type":"string"},"Creditor No_":{"type":"string"},"Posting Date":{"type":"string"},"Ship-to City":{"type":"string"},"Ship-to Code":{"type":"string"},"Ship-to Name":{"type":"string"},"Buy-from City":{"type":"string"},"Currency Code":{"type":"string"},"Document Date":{"type":"string"},"IRS 1099 Code":{"type":"string"},"Language Code":{"type":"string"},"Location Code":{"type":"string"},"Pay-to County":{"type":"string"},"Pay-to Name 2":{"type":"string"},"Tax Area Code":{"type":"string"},"Master Job No_":{"type":"string"},"Pay-to Address":{"type":"string"},"Pay-to Contact":{"type":"string"},"Purchaser Code":{"type":"string"},"Ship-to County":{"type":"string"},"Ship-to Name 2":{"type":"string"},"Ship-to Option":{"type":"number"},"Your Reference":{"type":"string"},"Buy-from County":{"type":"string"},"Currency Factor":{"type":"number"},"Ship-to Address":{"type":"string"},"Ship-to Contact":{"type":"string"},"Bal_ Account No_":{"type":"string"},"Buy-from Address":{"type":"string"},"Buy-from Contact":{"type":"string"},"Buy-from Fax No_":{"type":"string"},"Dimension Set ID":{"type":"number"},"Order No_ Series":{"type":"string"},"P_O_ CC Email To":{"type":"string"},"Pay-to Address 2":{"type":"string"},"Pay-to Post Code":{"type":"string"},"Pre-Assigned No_":{"type":"string"},"Ship-to UPS Zone":{"type":"string"},"Transaction Type":{"type":"string"},"Transport Method":{"type":"string"},"Vendor Order No_":{"type":"string"},"Bal_ Account Type":{"type":"number"},"Pay-to Vendor No_":{"type":"string"},"Payment Reference":{"type":"string"},"Ship-to Address 2":{"type":"string"},"Ship-to Phone No_":{"type":"string"},"Ship-to Post Code":{"type":"string"},"Tax Exemption No_":{"type":"string"},"Buy-from Address 2":{"type":"string"},"Buy-from Post Code":{"type":"string"},"Invoice Disc_ Code":{"type":"string"},"Order Address Code":{"type":"string"},"P_O_ Send Email To":{"type":"string"},"Pay-to Contact No_":{"type":"string"},"Payment Discount _":{"type":"number"},"Payment Terms Code":{"type":"string"},"Pmt_ Discount Date":{"type":"string"},"Prepayment Invoice":{"type":"number"},"STE Transaction ID":{"type":"string"},"Vendor Invoice No_":{"type":"string"},"Applies-to Doc_ No_":{"type":"string"},"Buy-from Vendor No_":{"type":"string"},"Payment Method Code":{"type":"string"},"Posting Description":{"type":"string"},"VAT Base Discount _":{"type":"number"},"Applies-to Doc_ Type":{"type":"number"},"Buy-from Contact No_":{"type":"string"},"Buy-from Vendor Name":{"type":"string"},"Miscellaneous Vendor":{"type":"number"},"Prepayment Order No_":{"type":"string"},"Prices Including VAT":{"type":"number"},"Sell-to Customer No_":{"type":"string"},"Shipment Method Code":{"type":"string"},"VAT Registration No_":{"type":"string"},"Vendor Posting Group":{"type":"string"},"Expected Receipt Date":{"type":"string"},"Item Registration No_":{"type":"string"},"Prepayment No_ Series":{"type":"string"},"Responsibility Center":{"type":"string"},"Buy-from Vendor Name 2":{"type":"string"},"VAT Bus_ Posting Group":{"type":"string"},"Gen_ Bus_ Posting Group":{"type":"string"},"Pre-Assigned No_ Series":{"type":"string"},"VAT Country_Region Code":{"type":"string"},"Vendor Ledger Entry No_":{"type":"number"},"Provincial Tax Area Code":{"type":"string"},"Fiscal Invoice Number PAC":{"type":"string"},"Shortcut Dimension 1 Code":{"type":"string"},"Shortcut Dimension 2 Code":{"type":"string"},"Transaction Specification":{"type":"string"},"Pay-to Country_Region Code":{"type":"string"},"Ship-to Country_Region Code":{"type":"string"},"Buy-from Country_Region Code":{"type":"string"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@c65fc5b[stream=io.airbyte.protocol.models.AirbyteStream@5713868[name=QCS, LLC$Purch_ Inv_ Line,jsonSchema={"type":"object","properties":{"No_":{"type":"string"},"Area":{"type":"string"},"Type":{"type":"number"},"VAT _":{"type":"number"},"Amount":{"type":"number"},"Job No_":{"type":"string"},"Use Tax":{"type":"number"},"Bin Code":{"type":"string"},"Job Type":{"type":"number"},"Line No_":{"type":"number"},"Nonstock":{"type":"number"},"Quantity":{"type":"number"},"Unit Cost":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Net Weight":{"type":"number"},"Phase Code":{"type":"string"},"Tax Liable":{"type":"number"},"Description":{"type":"string"},"Entry Point":{"type":"string"},"Line Amount":{"type":"number"},"Receipt No_":{"type":"string"},"Routing No_":{"type":"string"},"Unit Volume":{"type":"number"},"Document No_":{"type":"string"},"Gross Weight":{"type":"number"},"Job Task No_":{"type":"string"},"Original Qty":{"type":"number"},"Posting Date":{"type":"string"},"Variant Code":{"type":"string"},"Cost Category":{"type":"number"},"Deferral Code":{"type":"string"},"Description 2":{"type":"string"},"Insurance No_":{"type":"string"},"Job Line Type":{"type":"number"},"Location Code":{"type":"string"},"Operation No_":{"type":"string"},"Overhead Rate":{"type":"number"},"Posting Group":{"type":"string"},"Salvage Value":{"type":"number"},"Tax Area Code":{"type":"string"},"Job Unit Price":{"type":"number"},"Master Job No_":{"type":"string"},"One Time Price":{"type":"number"},"Ship-to Option":{"type":"number"},"Tax Group Code":{"type":"string"},"VAT Difference":{"type":"number"},"VAT Identifier":{"type":"string"},"Work Type Code":{"type":"string"},"Budget Line No_":{"type":"number"},"Budgeted FA No_":{"type":"string"},"FA Posting Date":{"type":"string"},"FA Posting Type":{"type":"number"},"IC Partner Code":{"type":"string"},"IRS 1099 Liable":{"type":"number"},"Indirect Cost _":{"type":"number"},"Job Line Amount":{"type":"number"},"Job Project No_":{"type":"string"},"Job Total Price":{"type":"number"},"Line Discount _":{"type":"number"},"Prepayment Line":{"type":"number"},"Prod_ Order No_":{"type":"string"},"Purchasing Code":{"type":"string"},"Quantity (Base)":{"type":"number"},"Sales Order No_":{"type":"string"},"Unit Cost (LCY)":{"type":"number"},"Unit of Measure":{"type":"string"},"VAT Base Amount":{"type":"number"},"Vendor Item No_":{"type":"string"},"Work Center No_":{"type":"string"},"Allow Qty Change":{"type":"number"},"Dimension Set ID":{"type":"number"},"Direct Unit Cost":{"type":"number"},"Maintenance Code":{"type":"string"},"Receipt Line No_":{"type":"number"},"Task Description":{"type":"string"},"Transaction Type":{"type":"string"},"Transport Method":{"type":"string"},"Unit Price (LCY)":{"type":"number"},"Units per Parcel":{"type":"number"},"Blanket Order No_":{"type":"string"},"Job Currency Code":{"type":"string"},"Pay-to Vendor No_":{"type":"string"},"Item Category Code":{"type":"string"},"Person Responsible":{"type":"string"},"Product Group Code":{"type":"string"},"Purchase Order No_":{"type":"string"},"Return Reason Code":{"type":"string"},"Allow Invoice Disc_":{"type":"number"},"Appl_-to Item Entry":{"type":"number"},"Buy-from Vendor No_":{"type":"string"},"Cross-Reference No_":{"type":"string"},"Job Currency Factor":{"type":"number"},"Job Line Discount _":{"type":"number"},"Original Qty (Base)":{"type":"number"},"Paym_ Disc_ Allowed":{"type":"number"},"Variant Description":{"type":"string"},"Amount Including VAT":{"type":"number"},"Attached to Line No_":{"type":"number"},"Bill-to Customer No_":{"type":"string"},"Cross-Reference Type":{"type":"number"},"IC Partner Ref_ Type":{"type":"number"},"IC Partner Reference":{"type":"string"},"Inv_ Discount Amount":{"type":"number"},"Job Unit Price (LCY)":{"type":"number"},"Line Discount Amount":{"type":"number"},"Prod_ Order Line No_":{"type":"number"},"System-Created Entry":{"type":"number"},"Unit of Measure Code":{"type":"string"},"Use Duplication List":{"type":"number"},"VAT Calculation Type":{"type":"number"},"Expected Receipt Date":{"type":"string"},"Job Line Amount (LCY)":{"type":"number"},"Job Total Price (LCY)":{"type":"number"},"Responsibility Center":{"type":"string"},"Routing Reference No_":{"type":"number"},"Blanket Order Line No_":{"type":"number"},"Depr_ Acquisition Cost":{"type":"number"},"Depreciation Book Code":{"type":"string"},"VAT Bus_ Posting Group":{"type":"string"},"Gen_ Bus_ Posting Group":{"type":"string"},"VAT Prod_ Posting Group":{"type":"string"},"Cross-Reference Type No_":{"type":"string"},"Gen_ Prod_ Posting Group":{"type":"string"},"Job Line Discount Amount":{"type":"number"},"Provincial Tax Area Code":{"type":"string"},"Qty_ per Unit of Measure":{"type":"number"},"Orig Unit of Measure Code":{"type":"string"},"Shortcut Dimension 1 Code":{"type":"string"},"Shortcut Dimension 2 Code":{"type":"string"},"Transaction Specification":{"type":"string"},"Exclude from Payment Disc_":{"type":"number"},"Depr_ until FA Posting Date":{"type":"number"},"Job Line Disc_ Amount (LCY)":{"type":"number"},"Amt_ for Paym_ Disc_ Allowed":{"type":"number"},"Unit of Measure (Cross Ref_)":{"type":"string"},"Duplicate in Depreciation Book":{"type":"string"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Document No_], [Line No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Document No_], [Line No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@31b10997[stream=io.airbyte.protocol.models.AirbyteStream@375ce9dc[name=QCS, LLC$Purch_ Rcpt_ Header,jsonSchema={"type":"object","properties":{"No_":{"type":"string"},"Area":{"type":"string"},"On Hold":{"type":"string"},"User ID":{"type":"string"},"Due Date":{"type":"string"},"Order No_":{"type":"string"},"Quote No_":{"type":"string"},"Store No_":{"type":"string"},"timestamp":{"type":"string","contentEncoding":"base64"},"Correction":{"type":"number"},"No_ Series":{"type":"string"},"Order Date":{"type":"string"},"Tax Liable":{"type":"number"},"Entry Point":{"type":"string"},"No_ Printed":{"type":"number"},"Pay-to City":{"type":"string"},"Pay-to Name":{"type":"string"},"Reason Code":{"type":"string"},"Source Code":{"type":"string"},"Campaign No_":{"type":"string"},"Posting Date":{"type":"string"},"Ship-to City":{"type":"string"},"Ship-to Code":{"type":"string"},"Ship-to Name":{"type":"string"},"Buy-from City":{"type":"string"},"Currency Code":{"type":"string"},"Document Date":{"type":"string"},"Language Code":{"type":"string"},"Location Code":{"type":"string"},"Pay-to County":{"type":"string"},"Pay-to Name 2":{"type":"string"},"Retail Status":{"type":"number"},"Tax Area Code":{"type":"string"},"Order Receiver":{"type":"string"},"Pay-to Address":{"type":"string"},"Pay-to Contact":{"type":"string"},"Purchaser Code":{"type":"string"},"Receiving Date":{"type":"string"},"Ship-to County":{"type":"string"},"Ship-to Name 2":{"type":"string"},"Your Reference":{"type":"string"},"Buy-from County":{"type":"string"},"Currency Factor":{"type":"number"},"Ship-to Address":{"type":"string"},"Ship-to Contact":{"type":"string"},"Bal_ Account No_":{"type":"string"},"Buy-from Address":{"type":"string"},"Buy-from Contact":{"type":"string"},"Buy-from Fax No_":{"type":"string"},"Dimension Set ID":{"type":"number"},"Order No_ Series":{"type":"string"},"Pay-to Address 2":{"type":"string"},"Pay-to Post Code":{"type":"string"},"Ship-to UPS Zone":{"type":"string"},"Transaction Type":{"type":"string"},"Transport Method":{"type":"string"},"Vendor Order No_":{"type":"string"},"Bal_ Account Type":{"type":"number"},"Pay-to Vendor No_":{"type":"string"},"Ship-to Address 2":{"type":"string"},"Ship-to Phone No_":{"type":"string"},"Ship-to Post Code":{"type":"string"},"Buy-from Address 2":{"type":"string"},"Buy-from Post Code":{"type":"string"},"Invoice Disc_ Code":{"type":"string"},"Order Address Code":{"type":"string"},"Pay-to Contact no_":{"type":"string"},"Payment Discount _":{"type":"number"},"Payment Terms Code":{"type":"string"},"Pmt_ Discount Date":{"type":"string"},"Applies-to Doc_ No_":{"type":"string"},"Buy-from Vendor No_":{"type":"string"},"Payment Method Code":{"type":"string"},"Posting Description":{"type":"string"},"VAT Base Discount _":{"type":"number"},"Vendor Shipment No_":{"type":"string"},"Applies-to Doc_ Type":{"type":"number"},"Buy-from Contact No_":{"type":"string"},"Buy-from Vendor Name":{"type":"string"},"Sell-to Customer No_":{"type":"string"},"Shipment Method Code":{"type":"string"},"VAT Registration No_":{"type":"string"},"Vendor Posting Group":{"type":"string"},"Actual Freight Amount":{"type":"number"},"Expected Receipt Date":{"type":"string"},"Lead Time Calculation":{"type":"string"},"Promised Receipt Date":{"type":"string"},"Receiving_Picking No_":{"type":"string"},"Responsibility Center":{"type":"string"},"Buy-from Vendor Name 2":{"type":"string"},"Requested Receipt Date":{"type":"string"},"VAT Bus_ Posting Group":{"type":"string"},"Gen_ Bus_ Posting Group":{"type":"string"},"VAT Country_Region Code":{"type":"string"},"Shortcut Dimension 1 Code":{"type":"string"},"Shortcut Dimension 2 Code":{"type":"string"},"Transaction Specification":{"type":"string"},"Pay-to Country_Region Code":{"type":"string"},"Inbound Whse_ Handling Time":{"type":"string"},"Ship-to Country_Region Code":{"type":"string"},"Buy-from Country_Region Code":{"type":"string"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@14784c48[stream=io.airbyte.protocol.models.AirbyteStream@18c694d7[name=QCS, LLC$Purchase Header,jsonSchema={"type":"object","properties":{"Id":{"type":"string"},"No_":{"type":"string"},"Area":{"type":"string"},"Ship":{"type":"number"},"Status":{"type":"number"},"Invoice":{"type":"number"},"Job No_":{"type":"string"},"On Hold":{"type":"string"},"Receive":{"type":"number"},"Buyer ID":{"type":"string"},"Due Date":{"type":"string"},"IC Status":{"type":"number"},"Quote No_":{"type":"string"},"Store No_":{"type":"string"},"timestamp":{"type":"string","contentEncoding":"base64"},"Correction":{"type":"number"},"No_ Series":{"type":"string"},"Order Date":{"type":"string"},"Tax Liable":{"type":"number"},"Entry Point":{"type":"string"},"No_ Printed":{"type":"number"},"Order Class":{"type":"string"},"Pay-to City":{"type":"string"},"Pay-to Name":{"type":"string"},"Posting No_":{"type":"string"},"Reason Code":{"type":"string"},"Version No_":{"type":"number"},"Campaign No_":{"type":"string"},"Creditor No_":{"type":"string"},"IC Direction":{"type":"number"},"PO Confirmed":{"type":"number"},"Posting Date":{"type":"string"},"Prepayment _":{"type":"number"},"Ship-to City":{"type":"string"},"Ship-to Code":{"type":"string"},"Ship-to Name":{"type":"string"},"Applies-to ID":{"type":"string"},"Buy-from City":{"type":"string"},"Currency Code":{"type":"string"},"Document Date":{"type":"string"},"Document Type":{"type":"number"},"IRS 1099 Code":{"type":"string"},"Language Code":{"type":"string"},"Location Code":{"type":"string"},"Pay-to County":{"type":"string"},"Pay-to Name 2":{"type":"string"},"Receiving No_":{"type":"string"},"Retail Status":{"type":"number"},"Tax Area Code":{"type":"string"},"Master Job No_":{"type":"string"},"Order Receiver":{"type":"string"},"Pay-to Address":{"type":"string"},"Pay-to Contact":{"type":"string"},"Prepayment No_":{"type":"string"},"Purchaser Code":{"type":"string"},"Receiving Date":{"type":"string"},"Ship-to County":{"type":"string"},"Ship-to Name 2":{"type":"string"},"Ship-to Option":{"type":"number"},"Your Reference":{"type":"string"},"Buy-from County":{"type":"string"},"Currency Factor":{"type":"number"},"Ship-to Address":{"type":"string"},"Ship-to Contact":{"type":"string"},"Assigned User ID":{"type":"string"},"Bal_ Account No_":{"type":"string"},"Buy-from Address":{"type":"string"},"Buy-from Contact":{"type":"string"},"Buy-from Fax No_":{"type":"string"},"Buyer Group Code":{"type":"string"},"Dimension Set ID":{"type":"number"},"General Comments":{"type":"string"},"Job Queue Status":{"type":"number"},"Last Posting No_":{"type":"string"},"Pay-to Address 2":{"type":"string"},"Pay-to Post Code":{"type":"string"},"RTC Filter Field":{"type":"number"},"Send IC Document":{"type":"number"},"Ship-to UPS Zone":{"type":"string"},"Shipment Pending":{"type":"number"},"Transaction Type":{"type":"string"},"Transport Method":{"type":"string"},"Vendor Order No_":{"type":"string"},"Bal_ Account Type":{"type":"number"},"Pay-to Vendor No_":{"type":"string"},"Payment Reference":{"type":"string"},"Ship-to Address 2":{"type":"string"},"Ship-to Phone No_":{"type":"string"},"Ship-to Post Code":{"type":"string"},"Tax Exemption No_":{"type":"string"},"Buy-from Address 2":{"type":"string"},"Buy-from Post Code":{"type":"string"},"Invoice Disc_ Code":{"type":"string"},"Job Queue Entry ID":{"type":"string"},"Last Receiving No_":{"type":"string"},"Order Address Code":{"type":"string"},"Pay-to Contact No_":{"type":"string"},"Payment Discount _":{"type":"number"},"Payment Terms Code":{"type":"string"},"Pmt_ Discount Date":{"type":"string"},"Posting No_ Series":{"type":"string"},"STE Transaction ID":{"type":"string"},"Vendor Invoice No_":{"type":"string"},"Applies-to Doc_ No_":{"type":"string"},"Buy-from Vendor No_":{"type":"string"},"Compress Prepayment":{"type":"number"},"Doc_ No_ Occurrence":{"type":"number"},"Last Prepayment No_":{"type":"string"},"Payment Method Code":{"type":"string"},"Posting Description":{"type":"string"},"Prepayment Due Date":{"type":"string"},"Prepmt_ Include Tax":{"type":"number"},"Return Shipment No_":{"type":"string"},"VAT Base Discount _":{"type":"number"},"Vendor Cr_ Memo No_":{"type":"string"},"Vendor Shipment No_":{"type":"string"},"Applies-to Doc_ Type":{"type":"number"},"Buy-from Contact No_":{"type":"string"},"Buy-from Vendor Name":{"type":"string"},"Miscellaneous Vendor":{"type":"number"},"Prepmt_ Cr_ Memo No_":{"type":"string"},"Prices Including VAT":{"type":"number"},"Receiving No_ Series":{"type":"string"},"Reciving_Picking No_":{"type":"string"},"Sell-to Customer No_":{"type":"string"},"Shipment Method Code":{"type":"string"},"VAT Registration No_":{"type":"string"},"Vendor Posting Group":{"type":"string"},"Actual Freight Amount":{"type":"number"},"Expected Receipt Date":{"type":"string"},"Item Registration No_":{"type":"string"},"Lead Time Calculation":{"type":"string"},"Pay-to Phone No_ -CL-":{"type":"string"},"Prepayment No_ Series":{"type":"string"},"Promised Receipt Date":{"type":"string"},"Responsibility Center":{"type":"string"},"Buy-from Vendor Name 2":{"type":"string"},"Created By Source Code":{"type":"string"},"Invoice Discount Value":{"type":"number"},"Pay-to IC Partner Code":{"type":"string"},"Print Posted Documents":{"type":"number"},"Requested Receipt Date":{"type":"string"},"Ship-to Phone No_ -CL-":{"type":"string"},"VAT Bus_ Posting Group":{"type":"string"},"Buy-from Phone No_ -CL-":{"type":"string"},"Gen_ Bus_ Posting Group":{"type":"string"},"Posting from Whse_ Ref_":{"type":"number"},"VAT Country_Region Code":{"type":"string"},"Buy-from IC Partner Code":{"type":"string"},"Last Return Shipment No_":{"type":"string"},"Provincial Tax Area Code":{"type":"string"},"Vendor Authorization No_":{"type":"string"},"Fiscal Invoice Number PAC":{"type":"string"},"Last Prepmt_ Cr_ Memo No_":{"type":"string"},"Shortcut Dimension 1 Code":{"type":"string"},"Shortcut Dimension 2 Code":{"type":"string"},"Source Sales Document No_":{"type":"string"},"Transaction Specification":{"type":"string"},"Pay-to Country_Region Code":{"type":"string"},"Prepmt_ Payment Discount _":{"type":"number"},"Prepmt_ Payment Terms Code":{"type":"string"},"Prepmt_ Pmt_ Discount Date":{"type":"string"},"Return Shipment No_ Series":{"type":"string"},"Source Sales Document Type":{"type":"number"},"Inbound Whse_ Handling Time":{"type":"string"},"Incoming Document Entry No_":{"type":"number"},"Prepmt_ Cr_ Memo No_ Series":{"type":"string"},"Prepmt_ Posting Description":{"type":"string"},"Ship-to Country_Region Code":{"type":"string"},"Buy-from Country_Region Code":{"type":"string"},"Invoice Discount Calculation":{"type":"number"},"Retail Purchase Dest_ Filter":{"type":"number"},"Retail Purchase Source Filter":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Document Type], [No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Document Type], [No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@2182cbe9[stream=io.airbyte.protocol.models.AirbyteStream@7140d40c[name=QCS, LLC$Purchase Line,jsonSchema={"type":"object","properties":{"No_":{"type":"string"},"Area":{"type":"string"},"Type":{"type":"number"},"VAT _":{"type":"number"},"Amount":{"type":"number"},"GST_HST":{"type":"number"},"Job No_":{"type":"string"},"Planned":{"type":"number"},"Subtype":{"type":"number"},"Use Tax":{"type":"number"},"Bin Code":{"type":"string"},"Division":{"type":"string"},"Finished":{"type":"number"},"Job Type":{"type":"number"},"Line No_":{"type":"number"},"Nonstock":{"type":"number"},"Profit _":{"type":"number"},"Quantity":{"type":"number"},"MPS Order":{"type":"number"},"Unit Cost":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Net Weight":{"type":"number"},"Order Date":{"type":"string"},"Phase Code":{"type":"string"},"Tax Liable":{"type":"number"},"Description":{"type":"string"},"Doc_ Status":{"type":"number"},"Entry Point":{"type":"string"},"Line Amount":{"type":"number"},"Receipt No_":{"type":"string"},"Routing No_":{"type":"string"},"Unit Volume":{"type":"number"},"Document No_":{"type":"string"},"Gross Weight":{"type":"number"},"Job Task No_":{"type":"string"},"Original Qty":{"type":"number"},"Prepayment _":{"type":"number"},"Temp Job No_":{"type":"string"},"Variant Code":{"type":"string"},"Cost Category":{"type":"number"},"Currency Code":{"type":"string"},"Deferral Code":{"type":"string"},"Description 2":{"type":"string"},"Document Type":{"type":"number"},"Drop Shipment":{"type":"number"},"Insurance No_":{"type":"string"},"Job Line Type":{"type":"number"},"Location Code":{"type":"string"},"Operation No_":{"type":"string"},"Overhead Rate":{"type":"number"},"Posting Group":{"type":"string"},"Salvage Value":{"type":"number"},"Special Order":{"type":"number"},"Tax Area Code":{"type":"string"},"Job Unit Price":{"type":"number"},"Master Job No_":{"type":"string"},"One Time Price":{"type":"number"},"Ship-to Option":{"type":"number"},"Tax Group Code":{"type":"string"},"VAT Difference":{"type":"number"},"VAT Identifier":{"type":"string"},"Variant Header":{"type":"number"},"Work Type Code":{"type":"string"},"Budgeted FA No_":{"type":"string"},"FA Posting Date":{"type":"string"},"FA Posting Type":{"type":"number"},"IC Partner Code":{"type":"string"},"IRS 1099 Liable":{"type":"number"},"Indirect Cost _":{"type":"number"},"Job Line Amount":{"type":"number"},"Job Project No_":{"type":"string"},"Job Total Price":{"type":"number"},"Line Discount _":{"type":"number"},"Prepayment Line":{"type":"number"},"Prod_ Order No_":{"type":"string"},"Purchasing Code":{"type":"string"},"Qty_ to Invoice":{"type":"number"},"Qty_ to Receive":{"type":"number"},"Quantity (Base)":{"type":"number"},"Sales Order No_":{"type":"string"},"Unit Cost (LCY)":{"type":"number"},"Unit of Measure":{"type":"string"},"VAT Base Amount":{"type":"number"},"Vendor Item No_":{"type":"string"},"Work Center No_":{"type":"string"},"Allow Qty Change":{"type":"number"},"Dimension Set ID":{"type":"number"},"Direct Unit Cost":{"type":"number"},"Maintenance Code":{"type":"string"},"Prepayment VAT _":{"type":"number"},"Receipt Line No_":{"type":"number"},"Safety Lead Time":{"type":"string"},"Task Description":{"type":"string"},"Transaction Type":{"type":"string"},"Transport Method":{"type":"string"},"Unit Price (LCY)":{"type":"number"},"Units per Parcel":{"type":"number"},"Blanket Order No_":{"type":"string"},"Job Currency Code":{"type":"string"},"Original Quantity":{"type":"number"},"Pay-to Vendor No_":{"type":"string"},"Prepayment Amount":{"type":"number"},"Prepmt_ Amt_ Inv_":{"type":"number"},"Quantity Invoiced":{"type":"number"},"Quantity Received":{"type":"number"},"Temp Job Task No_":{"type":"string"},"Item Category Code":{"type":"string"},"Job Remaining Qty_":{"type":"number"},"Outstanding Amount":{"type":"number"},"Person Responsible":{"type":"string"},"Product Group Code":{"type":"string"},"Return Reason Code":{"type":"string"},"Tax To Be Expensed":{"type":"number"},"Allow Invoice Disc_":{"type":"number"},"Appl_-to Item Entry":{"type":"number"},"Buy-from Vendor No_":{"type":"string"},"Completely Received":{"type":"number"},"Cross-Reference No_":{"type":"string"},"Job Currency Factor":{"type":"number"},"Job Line Discount _":{"type":"number"},"Original Qty (Base)":{"type":"number"},"Paym_ Disc_ Allowed":{"type":"number"},"Prepmt Amt Deducted":{"type":"number"},"Prepmt_ Line Amount":{"type":"number"},"Quantity Difference":{"type":"number"},"Return Qty_ Shipped":{"type":"number"},"Return Qty_ to Ship":{"type":"number"},"Return Shipment No_":{"type":"string"},"Temp Master Job No_":{"type":"string"},"Variant Description":{"type":"string"},"Amount Including VAT":{"type":"number"},"Attached to Line No_":{"type":"number"},"Bill-to Customer No_":{"type":"string"},"Cross-Reference Type":{"type":"number"},"IC Partner Ref_ Type":{"type":"number"},"IC Partner Reference":{"type":"string"},"Inv_ Discount Amount":{"type":"number"},"Job Unit Price (LCY)":{"type":"number"},"Line Discount Amount":{"type":"number"},"Outstanding Quantity":{"type":"number"},"Planned Receipt Date":{"type":"string"},"Planning Flexibility":{"type":"number"},"Posting Date Trigger":{"type":"number"},"Prepmt Amt to Deduct":{"type":"number"},"Prod_ Order Line No_":{"type":"number"},"Qty_ Invoiced (Base)":{"type":"number"},"Qty_ Received (Base)":{"type":"number"},"Return Vendor Action":{"type":"number"},"Sales Order Line No_":{"type":"number"},"System-Created Entry":{"type":"number"},"Temp Budget Line No_":{"type":"number"},"Unit of Measure Code":{"type":"string"},"Use Duplication List":{"type":"number"},"VAT Calculation Type":{"type":"number"},"Cross Doc_ Difference":{"type":"number"},"Expected Receipt Date":{"type":"string"},"Job Line Amount (LCY)":{"type":"number"},"Job Planning Line No_":{"type":"number"},"Job Total Price (LCY)":{"type":"number"},"Lead Time Calculation":{"type":"string"},"Prepayment Tax Liable":{"type":"number"},"Prepmt_ VAT Base Amt_":{"type":"number"},"Promised Receipt Date":{"type":"string"},"Responsibility Center":{"type":"string"},"Routing Reference No_":{"type":"number"},"Amt_ Rcd_ Not Invoiced":{"type":"number"},"Blanket Order Line No_":{"type":"number"},"Depr_ Acquisition Cost":{"type":"number"},"Depreciation Book Code":{"type":"string"},"Job Contract Entry No_":{"type":"number"},"Prepmt_ Amt_ Incl_ VAT":{"type":"number"},"Prepmt_ VAT Calc_ Type":{"type":"number"},"Qty_ Rcd_ Not Invoiced":{"type":"number"},"Qty_ to Invoice (Base)":{"type":"number"},"Qty_ to Receive (Base)":{"type":"number"},"Requested Receipt Date":{"type":"string"},"Return Shpd_ Not Invd_":{"type":"number"},"VAT Bus_ Posting Group":{"type":"string"},"Gen_ Bus_ Posting Group":{"type":"string"},"Outstanding Amt w_o Vat":{"type":"number"},"Outstanding Qty_ (Base)":{"type":"number"},"Special Order Sales No_":{"type":"string"},"VAT Prod_ Posting Group":{"type":"string"},"Cross-Reference Type No_":{"type":"string"},"Gen_ Prod_ Posting Group":{"type":"string"},"Job Line Discount Amount":{"type":"number"},"Original Quantity (base)":{"type":"number"},"Outstanding Amount (LCY)":{"type":"number"},"Prepayment Tax Area Code":{"type":"string"},"Provincial Tax Area Code":{"type":"string"},"Qty_ per Unit of Measure":{"type":"number"},"Return Shipment Line No_":{"type":"number"},"Source Document Line No_":{"type":"number"},"Job Remaining Qty_ (Base)":{"type":"number"},"Orig Unit of Measure Code":{"type":"string"},"Prepayment Tax Group Code":{"type":"string"},"Prepayment VAT Difference":{"type":"number"},"Prepayment VAT Identifier":{"type":"string"},"Prepmt VAT Diff_ Deducted":{"type":"number"},"Prepmt_ Amount Inv_ (LCY)":{"type":"number"},"Recalculate Invoice Disc_":{"type":"number"},"Shortcut Dimension 1 Code":{"type":"string"},"Shortcut Dimension 2 Code":{"type":"string"},"Transaction Specification":{"type":"string"},"Exclude from Payment Disc_":{"type":"number"},"Prepmt VAT Diff_ to Deduct":{"type":"number"},"Reserved For Location Code":{"type":"string"},"Return Qty_ Shipped (Base)":{"type":"number"},"Return Qty_ to Ship (Base)":{"type":"number"},"Depr_ until FA Posting Date":{"type":"number"},"Disposition of Purch_ Quote":{"type":"number"},"Inbound Whse_ Handling Time":{"type":"string"},"Job Line Disc_ Amount (LCY)":{"type":"number"},"Returns Deferral Start Date":{"type":"string"},"Allow Item Charge Assignment":{"type":"number"},"Amt_ Rcd_ Not Invoiced (LCY)":{"type":"number"},"Amt_ for Paym_ Disc_ Allowed":{"type":"number"},"Inv_ Disc_ Amount to Invoice":{"type":"number"},"Return Shpd_ Not Invd_ (LCY)":{"type":"number"},"Special Order Sales Line No_":{"type":"number"},"Unit of Measure (Cross Ref_)":{"type":"string"},"Prepmt_ Amount Inv_ Incl_ VAT":{"type":"number"},"Prepmt_ VAT Amount Inv_ (LCY)":{"type":"number"},"Qty_ Rcd_ Not Invoiced (Base)":{"type":"number"},"Return Qty_ Shipped Not Invd_":{"type":"number"},"A_ Rcd_ Not Inv_ Ex_ VAT (LCY)":{"type":"number"},"Amt_ Rcd_ Not Invoiced w_o Vat":{"type":"number"},"Duplicate in Depreciation Book":{"type":"string"},"Outstanding Amt_ Ex_ VAT (LCY)":{"type":"number"},"Ret_ Qty_ Shpd Not Invd_(Base)":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Document Type], [Document No_], [Line No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Document Type], [Document No_], [Line No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@270cdc60[stream=io.airbyte.protocol.models.AirbyteStream@bc0847a[name=QCS, LLC$Purchase Line Archive,jsonSchema={"type":"object","properties":{"No_":{"type":"string"},"Area":{"type":"string"},"Type":{"type":"number"},"VAT _":{"type":"number"},"Amount":{"type":"number"},"Job No_":{"type":"string"},"Use Tax":{"type":"number"},"Bin Code":{"type":"string"},"Finished":{"type":"number"},"Job Type":{"type":"number"},"Line No_":{"type":"number"},"Nonstock":{"type":"number"},"Profit _":{"type":"number"},"Quantity":{"type":"number"},"MPS Order":{"type":"number"},"Unit Cost":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Net Weight":{"type":"number"},"Order Date":{"type":"string"},"Phase Code":{"type":"string"},"Tax Liable":{"type":"number"},"Description":{"type":"string"},"Entry Point":{"type":"string"},"Line Amount":{"type":"number"},"Receipt No_":{"type":"string"},"Routing No_":{"type":"string"},"Unit Volume":{"type":"number"},"Version No_":{"type":"number"},"Document No_":{"type":"string"},"Gross Weight":{"type":"number"},"Original Qty":{"type":"number"},"Prepayment _":{"type":"number"},"Temp Job No_":{"type":"string"},"Variant Code":{"type":"string"},"Cost Category":{"type":"number"},"Currency Code":{"type":"string"},"Description 2":{"type":"string"},"Document Type":{"type":"number"},"Drop Shipment":{"type":"number"},"Insurance No_":{"type":"string"},"Location Code":{"type":"string"},"Operation No_":{"type":"string"},"Overhead Rate":{"type":"number"},"Posting Group":{"type":"string"},"Salvage Value":{"type":"number"},"Special Order":{"type":"number"},"Tax Area Code":{"type":"string"},"Master Job No_":{"type":"string"},"One Time Price":{"type":"number"},"Ship-to Option":{"type":"number"},"Tax Group Code":{"type":"string"},"VAT Difference":{"type":"number"},"VAT Identifier":{"type":"string"},"Work Type Code":{"type":"string"},"Budget Line No_":{"type":"number"},"Budgeted FA No_":{"type":"string"},"FA Posting Date":{"type":"string"},"FA Posting Type":{"type":"number"},"IC Partner Code":{"type":"string"},"IRS 1099 Liable":{"type":"number"},"Indirect Cost _":{"type":"number"},"Job Project No_":{"type":"string"},"Line Discount _":{"type":"number"},"Prepayment Line":{"type":"number"},"Prod_ Order No_":{"type":"string"},"Purchasing Code":{"type":"string"},"Qty_ to Invoice":{"type":"number"},"Qty_ to Receive":{"type":"number"},"Quantity (Base)":{"type":"number"},"Sales Order No_":{"type":"string"},"Unit Cost (LCY)":{"type":"number"},"Unit of Measure":{"type":"string"},"VAT Base Amount":{"type":"number"},"Vendor Item No_":{"type":"string"},"Work Center No_":{"type":"string"},"Allow Qty Change":{"type":"number"},"Dimension Set ID":{"type":"number"},"Direct Unit Cost":{"type":"number"},"Maintenance Code":{"type":"string"},"Prepayment VAT _":{"type":"number"},"Quantity Disc_ _":{"type":"number"},"Receipt Line No_":{"type":"number"},"Safety Lead Time":{"type":"string"},"Task Description":{"type":"string"},"Transaction Type":{"type":"string"},"Transport Method":{"type":"string"},"Unit Price (LCY)":{"type":"number"},"Units per Parcel":{"type":"number"},"Blanket Order No_":{"type":"string"},"Pay-to Vendor No_":{"type":"string"},"Prepayment Amount":{"type":"number"},"Prepmt_ Amt_ Inv_":{"type":"number"},"Quantity Invoiced":{"type":"number"},"Quantity Received":{"type":"number"},"Temp Job Task No_":{"type":"string"},"Item Category Code":{"type":"string"},"Outstanding Amount":{"type":"number"},"Person Responsible":{"type":"string"},"Product Group Code":{"type":"string"},"Return Reason Code":{"type":"string"},"Allow Invoice Disc_":{"type":"number"},"Appl_-to Item Entry":{"type":"number"},"Buy-from Vendor No_":{"type":"string"},"Completely Received":{"type":"number"},"Cross-Reference No_":{"type":"string"},"Doc_ No_ Occurrence":{"type":"number"},"Original Qty (Base)":{"type":"number"},"Prepmt Amt Deducted":{"type":"number"},"Prepmt_ Line Amount":{"type":"number"},"Return Qty_ Shipped":{"type":"number"},"Return Qty_ to Ship":{"type":"number"},"Return Shipment No_":{"type":"string"},"Temp Master Job No_":{"type":"string"},"Amount Including VAT":{"type":"number"},"Attached to Line No_":{"type":"number"},"Bill-to Customer No_":{"type":"string"},"Cross-Reference Type":{"type":"number"},"IC Partner Ref_ Type":{"type":"number"},"IC Partner Reference":{"type":"string"},"Inv_ Discount Amount":{"type":"number"},"Line Discount Amount":{"type":"number"},"Outstanding Quantity":{"type":"number"},"Planned Receipt Date":{"type":"string"},"Planning Flexibility":{"type":"number"},"Posting Date Trigger":{"type":"number"},"Prepmt Amt to Deduct":{"type":"number"},"Prod_ Order Line No_":{"type":"number"},"Qty_ Invoiced (Base)":{"type":"number"},"Qty_ Received (Base)":{"type":"number"},"Sales Order Line No_":{"type":"number"},"System-Created Entry":{"type":"number"},"Temp Budget Line No_":{"type":"number"},"Unit of Measure Code":{"type":"string"},"Use Duplication List":{"type":"number"},"VAT Calculation Type":{"type":"number"},"Expected Receipt Date":{"type":"string"},"Lead Time Calculation":{"type":"string"},"Prepayment Tax Liable":{"type":"number"},"Prepmt_ VAT Base Amt_":{"type":"number"},"Promised Receipt Date":{"type":"string"},"Responsibility Center":{"type":"string"},"Routing Reference No_":{"type":"number"},"Amt_ Rcd_ Not Invoiced":{"type":"number"},"Blanket Order Line No_":{"type":"number"},"Depr_ Acquisition Cost":{"type":"number"},"Depreciation Book Code":{"type":"string"},"Prepmt_ Amt_ Incl_ VAT":{"type":"number"},"Prepmt_ VAT Calc_ Type":{"type":"number"},"Qty_ Rcd_ Not Invoiced":{"type":"number"},"Qty_ to Invoice (Base)":{"type":"number"},"Qty_ to Receive (Base)":{"type":"number"},"Requested Receipt Date":{"type":"string"},"Return Shpd_ Not Invd_":{"type":"number"},"VAT Bus_ Posting Group":{"type":"string"},"Gen_ Bus_ Posting Group":{"type":"string"},"Outstanding Qty_ (Base)":{"type":"number"},"Special Order Sales No_":{"type":"string"},"VAT Prod_ Posting Group":{"type":"string"},"Cross-Reference Type No_":{"type":"string"},"Gen_ Prod_ Posting Group":{"type":"string"},"Outstanding Amount (LCY)":{"type":"number"},"Prepayment Tax Area Code":{"type":"string"},"Provincial Tax Area Code":{"type":"string"},"Purch_ Quote Disposition":{"type":"number"},"Qty_ per Unit of Measure":{"type":"number"},"Return Shipment Line No_":{"type":"number"},"Orig Unit of Measure Code":{"type":"string"},"Prepayment Tax Group Code":{"type":"string"},"Prepayment VAT Identifier":{"type":"string"},"Shortcut Dimension 1 Code":{"type":"string"},"Shortcut Dimension 2 Code":{"type":"string"},"Transaction Specification":{"type":"string"},"Return Qty_ Shipped (Base)":{"type":"number"},"Return Qty_ to Ship (Base)":{"type":"number"},"Depr_ until FA Posting Date":{"type":"number"},"Inbound Whse_ Handling Time":{"type":"string"},"Allow Item Charge Assignment":{"type":"number"},"Amt_ Rcd_ Not Invoiced (LCY)":{"type":"number"},"Inv_ Disc_ Amount to Invoice":{"type":"number"},"Return Shpd_ Not Invd_ (LCY)":{"type":"number"},"Special Order Sales Line No_":{"type":"number"},"Unit of Measure (Cross Ref_)":{"type":"string"},"Prepmt_ Amount Inv_ Incl_ VAT":{"type":"number"},"Qty_ Rcd_ Not Invoiced (Base)":{"type":"number"},"Return Qty_ Shipped Not Invd_":{"type":"number"},"Duplicate in Depreciation Book":{"type":"string"},"Ret_ Qty_ Shpd Not Invd_(Base)":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Document Type], [Document No_], [Doc_ No_ Occurrence], [Version No_], [Line No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Document Type], [Document No_], [Doc_ No_ Occurrence], [Version No_], [Line No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@3c2adb68[stream=io.airbyte.protocol.models.AirbyteStream@4b3d8855[name=QCS, LLC$Purchase Price,jsonSchema={"type":"object","properties":{"Item No_":{"type":"string"},"timestamp":{"type":"string","contentEncoding":"base64"},"Discount _":{"type":"number"},"Vendor No_":{"type":"string"},"Ending Date":{"type":"string"},"Variant Code":{"type":"string"},"Currency Code":{"type":"string"},"Starting Date":{"type":"string"},"Wholesale Price":{"type":"number"},"Direct Unit Cost":{"type":"number"},"Minimum Quantity":{"type":"number"},"Unit of Measure Code":{"type":"string"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Item No_], [Vendor No_], [Starting Date], [Currency Code], [Variant Code], [Unit of Measure Code], [Minimum Quantity]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Item No_], [Vendor No_], [Starting Date], [Currency Code], [Variant Code], [Unit of Measure Code], [Minimum Quantity]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@a13a28e[stream=io.airbyte.protocol.models.AirbyteStream@5ff14e2[name=QCS, LLC$Sales Cr_Memo Header,jsonSchema={"type":"object","properties":{"Id":{"type":"string"},"No_":{"type":"string"},"Area":{"type":"string"},"POS ID":{"type":"string"},"Job No_":{"type":"string"},"On Hold":{"type":"string"},"QR Code":{"type":"string","contentEncoding":"base64"},"User ID":{"type":"string"},"Due Date":{"type":"string"},"Exchange":{"type":"number"},"Project?":{"type":"number"},"Batch No_":{"type":"string"},"Hash -CL-":{"type":"string"},"Store No_":{"type":"string"},"timestamp":{"type":"string","contentEncoding":"base64"},"Cashier ID":{"type":"string"},"Correction":{"type":"number"},"Error Code":{"type":"string"},"Exit Point":{"type":"string"},"No_ Series":{"type":"string"},"Tax Liable":{"type":"number"},"No_ Printed":{"type":"number"},"Reason Code":{"type":"string"},"Source Code":{"type":"string"},"BI Timestamp":{"type":"string"},"Bill-to City":{"type":"string"},"Bill-to Name":{"type":"string"},"Campaign No_":{"type":"string"},"Catalog Code":{"type":"string"},"Payment Type":{"type":"number"},"Posting Date":{"type":"string"},"Posting Time":{"type":"string"},"Sell-to City":{"type":"string"},"Ship-to City":{"type":"string"},"Ship-to Code":{"type":"string"},"Ship-to Name":{"type":"string"},"Web Order ID":{"type":"string"},"Currency Code":{"type":"string"},"Document Date":{"type":"string"},"Language Code":{"type":"string"},"Location Code":{"type":"string"},"POS Type -CL-":{"type":"number"},"Shipment Date":{"type":"string"},"Tax Area Code":{"type":"string"},"Bill-to County":{"type":"string"},"Bill-to Name 2":{"type":"string"},"Card Type -CL-":{"type":"number"},"Date_Time Sent":{"type":"string"},"Master Job No_":{"type":"string"},"Sell-to County":{"type":"string"},"Ship-From Name":{"type":"string"},"Ship-to County":{"type":"string"},"Ship-to Name 2":{"type":"string"},"Web Profile ID":{"type":"string"},"Your Reference":{"type":"string"},"Bill-to Address":{"type":"string"},"Bill-to Contact":{"type":"string"},"Check Type -CL-":{"type":"number"},"Currency Factor":{"type":"number"},"Member Card No_":{"type":"string"},"Opportunity No_":{"type":"string"},"Order Time -CL-":{"type":"string"},"Sell-to Address":{"type":"string"},"Sell-to Contact":{"type":"string"},"Ship-to Address":{"type":"string"},"Ship-to Contact":{"type":"string"},"Allow Line Disc_":{"type":"number"},"Bal_ Account No_":{"type":"string"},"Catalog Drop No_":{"type":"number"},"Company Card No_":{"type":"string"},"Dimension Set ID":{"type":"number"},"EU 3-Party Trade":{"type":"number"},"Pre-Assigned No_":{"type":"string"},"Return Order No_":{"type":"string"},"Salesperson Code":{"type":"string"},"Ship-to UPS Zone":{"type":"string"},"Transaction Type":{"type":"string"},"Transport Method":{"type":"string"},"Account Type -CL-":{"type":"number"},"Bal_ Account Type":{"type":"number"},"Bill-to Address 2":{"type":"string"},"Bill-to Post Code":{"type":"string"},"Date_Time Stamped":{"type":"string"},"Digital Stamp PAC":{"type":"string","contentEncoding":"base64"},"Error Description":{"type":"string"},"Mailing List Code":{"type":"string"},"Orig_ Invoice No_":{"type":"string"},"Sell-to Address 2":{"type":"string"},"Sell-to Post Code":{"type":"string"},"Ship-to Address 2":{"type":"string"},"Ship-to Post Code":{"type":"string"},"Tax Exemption No_":{"type":"string"},"Date_Time Canceled":{"type":"string"},"EFT Store No_ -CL-":{"type":"string"},"Invoice Disc_ Code":{"type":"string"},"Payment Discount _":{"type":"number"},"Payment Terms Code":{"type":"string"},"Pmt_ Discount Date":{"type":"string"},"STE Transaction ID":{"type":"string"},"Account Number -CL-":{"type":"string"},"Applies-to Doc_ No_":{"type":"string"},"Bill-to Contact No_":{"type":"string"},"Bill-to ID No_ -CL-":{"type":"string"},"Payment Method Code":{"type":"string"},"Posting Description":{"type":"string"},"Routing Number -CL-":{"type":"string"},"Sell-to Contact No_":{"type":"string"},"Signed Document XML":{"type":"string","contentEncoding":"base64"},"Source Document No_":{"type":"string"},"VAT Base Discount _":{"type":"number"},"Applies-to Doc_ Type":{"type":"number"},"Bill-to Customer No_":{"type":"string"},"Customer Disc_ Group":{"type":"string"},"Customer Price Group":{"type":"string"},"EFT Tender Type -CL-":{"type":"number"},"Encryption Salt -CL-":{"type":"string"},"Expiration Year -CL-":{"type":"string"},"OneSource Tax Exempt":{"type":"number"},"PAC Web Service Name":{"type":"string"},"Prepayment Order No_":{"type":"string"},"Prices Including VAT":{"type":"number"},"Residential Delivery":{"type":"number"},"Sell-to Customer No_":{"type":"string"},"Sell-to Phone No_TBD":{"type":"string"},"Ship-to Phone No_TBD":{"type":"string"},"Shipment Method Code":{"type":"string"},"Source Document Type":{"type":"number"},"VAT Registration No_":{"type":"string"},"EFT Terminal No_ -CL-":{"type":"string"},"Expiration Month -CL-":{"type":"string"},"External Document No_":{"type":"string"},"Issuer ID Number -CL-":{"type":"string"},"Responsibility Center":{"type":"string"},"Sell-to Customer Name":{"type":"string"},"Bill-to ID County -CL-":{"type":"string"},"Bill-to Phone No_ -CL-":{"type":"string"},"Cust_ Ledger Entry No_":{"type":"number"},"Customer Posting Group":{"type":"string"},"Payment Transaction ID":{"type":"number"},"Prepayment Credit Memo":{"type":"number"},"Sell-to E-Mail Address":{"type":"string"},"Sell-to Phone No_ -CL-":{"type":"string"},"Ship-to Phone No_ -CL-":{"type":"string"},"VAT Bus_ Posting Group":{"type":"string"},"Gen_ Bus_ Posting Group":{"type":"string"},"Get Return Receipt Used":{"type":"number"},"Pre-Assigned No_ Series":{"type":"string"},"Return Order No_ Series":{"type":"string"},"Sell-to Customer Name 2":{"type":"string"},"VAT Country_Region Code":{"type":"string"},"Document Exchange Status":{"type":"number"},"Cash Register Session No_":{"type":"number"},"Date_Time First Req_ Sent":{"type":"string"},"Fiscal Invoice Number PAC":{"type":"string"},"Is Anonymous Web Customer":{"type":"number"},"Shortcut Dimension 1 Code":{"type":"string"},"Shortcut Dimension 2 Code":{"type":"string"},"Transaction Specification":{"type":"string"},"AvaTax Customer Usage Type":{"type":"string"},"EFT Customer Link No_ -CL-":{"type":"string"},"Electronic Document Status":{"type":"number"},"Masked Payment Account No_":{"type":"string"},"Bill-to Country_Region Code":{"type":"string"},"Bill-to Federal ID No_ -CL-":{"type":"string"},"EFT Customer Link Type -CL-":{"type":"number"},"Prepmt_ Cr_ Memo No_ Series":{"type":"string"},"Sell-to Country_Region Code":{"type":"string"},"Ship-to Country_Region Code":{"type":"string"},"Document Exchange Identifier":{"type":"string"},"EFT Cust_ Link Line No_ -CL-":{"type":"number"},"Is Anonymous Retail Customer":{"type":"number"},"Protected Account Number -CL-":{"type":"string"},"Account Number Prot_ Type -CL-":{"type":"number"},"Doc_ Exch_ Original Identifier":{"type":"string"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@6f647eae[stream=io.airbyte.protocol.models.AirbyteStream@483c2c37[name=QCS, LLC$Sales Cr_Memo Line,jsonSchema={"type":"object","properties":{"No_":{"type":"string"},"Area":{"type":"string"},"Type":{"type":"number"},"VAT _":{"type":"number"},"Amount":{"type":"number"},"Job No_":{"type":"string"},"Bin Code":{"type":"string"},"Division":{"type":"string"},"Line No_":{"type":"number"},"Made Job":{"type":"number"},"Nonstock":{"type":"number"},"Quantity":{"type":"number"},"Offer No_":{"type":"string"},"Unit Cost":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Exit Point":{"type":"string"},"Is Freight":{"type":"number"},"Net Weight":{"type":"number"},"Tax Liable":{"type":"number"},"Unit Price":{"type":"number"},"Vendor No_":{"type":"string"},"Description":{"type":"string"},"Line Amount":{"type":"number"},"Retainage _":{"type":"number"},"Unit Volume":{"type":"number"},"Document No_":{"type":"string"},"Gross Weight":{"type":"number"},"Job Task No_":{"type":"string"},"Posting Date":{"type":"string"},"Variant Code":{"type":"string"},"Description 2":{"type":"string"},"Location Code":{"type":"string"},"Posting Group":{"type":"string"},"Shipment Date":{"type":"string"},"Tax Area Code":{"type":"string"},"Master Job No_":{"type":"string"},"Tax Group Code":{"type":"string"},"VAT Difference":{"type":"number"},"VAT Identifier":{"type":"string"},"Work Type Code":{"type":"string"},"FA Posting Date":{"type":"string"},"IC Partner Code":{"type":"string"},"Line Discount _":{"type":"number"},"Prepayment Line":{"type":"number"},"Purchasing Code":{"type":"string"},"Quantity (Base)":{"type":"number"},"Unit Cost (LCY)":{"type":"number"},"Unit of Measure":{"type":"string"},"VAT Base Amount":{"type":"number"},"Vendor Item No_":{"type":"string"},"Allow Line Disc_":{"type":"number"},"Dimension Set ID":{"type":"number"},"Print on Invoice":{"type":"number"},"Retainage Amount":{"type":"number"},"Salesperson Code":{"type":"string"},"Transaction Type":{"type":"string"},"Transport Method":{"type":"string"},"Units per Parcel":{"type":"number"},"Blanket Order No_":{"type":"string"},"Is Retainage Line":{"type":"number"},"Sales Account No_":{"type":"string"},"Sales Invoice No_":{"type":"string"},"Item Category Code":{"type":"string"},"Person Responsible":{"type":"string"},"Product Group Code":{"type":"string"},"Return Reason Code":{"type":"string"},"Return Receipt No_":{"type":"string"},"Allow Invoice Disc_":{"type":"number"},"Appl_-to Item Entry":{"type":"number"},"Cross-Reference No_":{"type":"string"},"Variant Description":{"type":"string"},"Amount Including VAT":{"type":"number"},"Attached to Line No_":{"type":"number"},"Bill-to Customer No_":{"type":"string"},"Cross-Reference Type":{"type":"number"},"Customer Disc_ Group":{"type":"string"},"Customer Price Group":{"type":"string"},"IC Partner Ref_ Type":{"type":"number"},"IC Partner Reference":{"type":"string"},"Inv_ Discount Amount":{"type":"number"},"Line Discount Amount":{"type":"number"},"OneSource Tax Exempt":{"type":"number"},"Package Tracking No_":{"type":"string"},"Retainage Applied-to":{"type":"number"},"Sell-to Customer No_":{"type":"string"},"System-Created Entry":{"type":"number"},"Unit of Measure Code":{"type":"string"},"Use Duplication List":{"type":"number"},"VAT Calculation Type":{"type":"number"},"Appl_-from Item Entry":{"type":"number"},"Responsibility Center":{"type":"string"},"Blanket Order Line No_":{"type":"number"},"Depreciation Book Code":{"type":"string"},"Job Contract Entry No_":{"type":"number"},"VAT Bus_ Posting Group":{"type":"string"},"Gen_ Bus_ Posting Group":{"type":"string"},"Return Receipt Line No_":{"type":"number"},"VAT Prod_ Posting Group":{"type":"string"},"Cross-Reference Type No_":{"type":"string"},"Gen_ Prod_ Posting Group":{"type":"string"},"Qty_ per Unit of Measure":{"type":"number"},"Shortcut Dimension 1 Code":{"type":"string"},"Shortcut Dimension 2 Code":{"type":"string"},"Transaction Specification":{"type":"string"},"Depr_ until FA Posting Date":{"type":"number"},"Unit of Measure (Cross Ref_)":{"type":"string"},"Duplicate in Depreciation Book":{"type":"string"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Document No_], [Line No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Document No_], [Line No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@5facf06c[stream=io.airbyte.protocol.models.AirbyteStream@2209b77f[name=QCS, LLC$Sales Header,jsonSchema={"type":"object","properties":{"No_":{"type":"string"},"Area":{"type":"string"},"Ship":{"type":"number"},"POS ID":{"type":"string"},"Status":{"type":"number"},"Invoice":{"type":"number"},"Job No_":{"type":"string"},"On Hold":{"type":"string"},"Receive":{"type":"number"},"Reserve":{"type":"number"},"Due Date":{"type":"string"},"Project?":{"type":"number"},"Batch No_":{"type":"string"},"Hash -CL-":{"type":"string"},"Quote No_":{"type":"string"},"Store No_":{"type":"string"},"timestamp":{"type":"string","contentEncoding":"base64"},"Cashier ID":{"type":"string"},"Correction":{"type":"number"},"Exit Point":{"type":"string"},"No_ Series":{"type":"string"},"Order Date":{"type":"string"},"Sales Type":{"type":"string"},"Tax Liable":{"type":"number"},"JEB Job No_":{"type":"string"},"No_ Printed":{"type":"number"},"Order Class":{"type":"string"},"Posting No_":{"type":"string"},"Reason Code":{"type":"string"},"Bill-to City":{"type":"string"},"Bill-to Name":{"type":"string"},"Catalog Code":{"type":"string"},"Order Picker":{"type":"string"},"Payment Type":{"type":"number"},"Picking Date":{"type":"string"},"Posting Date":{"type":"string"},"Posting Time":{"type":"string"},"Prepayment _":{"type":"number"},"Sell-to City":{"type":"string"},"Ship-to City":{"type":"string"},"Ship-to Code":{"type":"string"},"Ship-to Name":{"type":"string"},"Shipping No_":{"type":"string"},"Web Order ID":{"type":"string"},"Applies-to ID":{"type":"string"},"Currency Code":{"type":"string"},"Document Date":{"type":"string"},"Document Type":{"type":"number"},"EFT GUID -CL-":{"type":"string"},"Free Shipping":{"type":"number"},"Language Code":{"type":"string"},"Location Code":{"type":"string"},"POS Type -CL-":{"type":"number"},"Retail Status":{"type":"number"},"Shipment Date":{"type":"string"},"Shipping Time":{"type":"string"},"Statement No_":{"type":"string"},"Tax Area Code":{"type":"string"},"Bill-to County":{"type":"string"},"Bill-to Name 2":{"type":"string"},"Card Type -CL-":{"type":"number"},"JEB As Of Date":{"type":"string"},"Master Job No_":{"type":"string"},"Prepayment No_":{"type":"string"},"Quote Accepted":{"type":"number"},"Sell-to County":{"type":"string"},"Ship-From Name":{"type":"string"},"Ship-from City":{"type":"string"},"Ship-from Code":{"type":"string"},"Ship-to County":{"type":"string"},"Ship-to Name 2":{"type":"string"},"Web Profile ID":{"type":"string"},"Web Tax Amount":{"type":"number"},"Your Reference":{"type":"string"},"Bill-to Address":{"type":"string"},"Bill-to Contact":{"type":"string"},"Check Type -CL-":{"type":"number"},"Currency Factor":{"type":"number"},"Member Card No_":{"type":"string"},"Not Show Dialog":{"type":"number"},"Order Time -CL-":{"type":"string"},"Sell-to Address":{"type":"string"},"Sell-to Contact":{"type":"string"},"Ship-to Address":{"type":"string"},"Ship-to Contact":{"type":"string"},"Shipping Advice":{"type":"number"},"Allow Line Disc_":{"type":"number"},"Assigned User ID":{"type":"string"},"Bal_ Account No_":{"type":"string"},"Catalog Drop No_":{"type":"number"},"Dimension Set ID":{"type":"number"},"Job Queue Status":{"type":"number"},"Last Posting No_":{"type":"string"},"No_ Pick Printed":{"type":"number"},"RetainagePercent":{"type":"number"},"Salesperson Code":{"type":"string"},"Ship-from County":{"type":"string"},"Ship-to UPS Zone":{"type":"string"},"Shipment Pending":{"type":"number"},"Transaction Type":{"type":"string"},"Transport Method":{"type":"string"},"Work Description":{"type":"string","contentEncoding":"base64"},"Account Type -CL-":{"type":"number"},"Bal_ Account Type":{"type":"number"},"Bill-to Address 2":{"type":"string"},"Bill-to Post Code":{"type":"string"},"Combine Shipments":{"type":"number"},"EFT Order ID -CL-":{"type":"string"},"Get Shipment Used":{"type":"number"},"Last Shipping No_":{"type":"string"},"Mailing List Code":{"type":"string"},"Orig_ Invoice No_":{"type":"string"},"Replacement Order":{"type":"number"},"Sell-to Address 2":{"type":"string"},"Sell-to Post Code":{"type":"string"},"Ship-from Address":{"type":"string"},"Ship-to Address 2":{"type":"string"},"Ship-to Post Code":{"type":"string"},"EFT Store No_ -CL-":{"type":"string"},"Invoice Disc_ Code":{"type":"string"},"Job Queue Entry ID":{"type":"string"},"Payment Discount _":{"type":"number"},"Payment Terms Code":{"type":"string"},"Pmt_ Discount Date":{"type":"string"},"Posting No_ Series":{"type":"string"},"QC Order Date_Time":{"type":"string"},"Ready for Shipping":{"type":"number"},"Return Receipt No_":{"type":"string"},"Web Payment Amount":{"type":"number"},"Account Number -CL-":{"type":"string"},"Applies-to Doc_ No_":{"type":"string"},"Bill-to Contact No_":{"type":"string"},"Bill-to ID No_ -CL-":{"type":"string"},"Compress Prepayment":{"type":"number"},"Doc_ No_ Occurrence":{"type":"number"},"Last Prepayment No_":{"type":"string"},"Payment Method Code":{"type":"string"},"Posting Description":{"type":"string"},"Prepayment Due Date":{"type":"string"},"Prepmt_ Include Tax":{"type":"number"},"Quote Accepted Date":{"type":"string"},"Routing Number -CL-":{"type":"string"},"Sell-to Contact No_":{"type":"string"},"Ship-From Post Code":{"type":"string"},"Ship-from Address 2":{"type":"string"},"Shipping Agent Code":{"type":"string"},"Shipping No_ Series":{"type":"string"},"VAT Base Discount _":{"type":"number"},"Applies-to Doc_ Type":{"type":"number"},"Bill-to Customer No_":{"type":"string"},"Customer Disc_ Group":{"type":"string"},"Customer Price Group":{"type":"string"},"EFT Tender Type -CL-":{"type":"number"},"Encryption Salt -CL-":{"type":"string"},"Expiration Year -CL-":{"type":"string"},"JEB Master Job Order":{"type":"number"},"OneSource Tax Exempt":{"type":"number"},"Package Tracking No_":{"type":"string"},"Prepmt_ Cr_ Memo No_":{"type":"string"},"Prices Including VAT":{"type":"number"},"Residential Delivery":{"type":"number"},"Sell-to Customer No_":{"type":"string"},"Shipment Method Code":{"type":"string"},"VAT Registration No_":{"type":"string"},"Actual Freight Amount":{"type":"number"},"Click-to-Pay URL -CL-":{"type":"string"},"EFT Terminal No_ -CL-":{"type":"string"},"Expiration Month -CL-":{"type":"string"},"External Document No_":{"type":"string"},"Issuer ID Number -CL-":{"type":"string"},"Prepayment No_ Series":{"type":"string"},"Quote Expiration Date":{"type":"string"},"Quoted Freight Amount":{"type":"number"},"Quoted Freight Billed":{"type":"number"},"Receiving_Picking No_":{"type":"string"},"Sell-to Customer Name":{"type":"string"},"Shipping Instructions":{"type":"string"},"Web Merchandise Total":{"type":"number"},"Web User Customer No_":{"type":"string"},"xRetail Location Code":{"type":"string"},"Bill-to ID County -CL-":{"type":"string"},"Bill-to Phone No_ -CL-":{"type":"string"},"Customer Posting Group":{"type":"string"},"Date Received from Web":{"type":"string"},"Invoice Discount Value":{"type":"number"},"Payment Service Set ID":{"type":"number"},"Print Posted Documents":{"type":"number"},"Promised Delivery Date":{"type":"string"},"Quote Sent to Customer":{"type":"string"},"Quote Valid Until Date":{"type":"string"},"Sell-to E-Mail Address":{"type":"string"},"Sell-to Phone No_ -CL-":{"type":"string"},"Ship-to Phone No_ -CL-":{"type":"string"},"VAT Bus_ Posting Group":{"type":"string"},"Direct Debit Mandate ID":{"type":"string"},"Gen_ Bus_ Posting Group":{"type":"string"},"Last Return Receipt No_":{"type":"string"},"Posting from Whse_ Ref_":{"type":"number"},"Requested Delivery Date":{"type":"string"},"Sell-to Customer Name 2":{"type":"string"},"VAT Country_Region Code":{"type":"string"},"Is Anonymous Web Customer":{"type":"number"},"Last Prepmt_ Cr_ Memo No_":{"type":"string"},"Return Receipt No_ Series":{"type":"string"},"Shortcut Dimension 1 Code":{"type":"string"},"Shortcut Dimension 2 Code":{"type":"string"},"Transaction Specification":{"type":"string"},"EFT Customer Link No_ -CL-":{"type":"string"},"Prepmt_ Payment Discount _":{"type":"number"},"Prepmt_ Payment Terms Code":{"type":"string"},"Prepmt_ Pmt_ Discount Date":{"type":"string"},"Bill-to Country_Region Code":{"type":"string"},"Bill-to Federal ID No_ -CL-":{"type":"string"},"EFT Customer Link Type -CL-":{"type":"number"},"Incoming Document Entry No_":{"type":"number"},"OneSource Tax Exempt Reason":{"type":"string"},"Prepmt_ Cr_ Memo No_ Series":{"type":"string"},"Prepmt_ Posting Description":{"type":"string"},"Sell-to Country_Region Code":{"type":"string"},"Ship-to Country_Region Code":{"type":"string"},"Shipping Agent Service Code":{"type":"string"},"Web User Has Ordered Before":{"type":"number"},"EFT Cust_ Link Line No_ -CL-":{"type":"number"},"Electronic Invoice Type -CL-":{"type":"number"},"Invoice Discount Calculation":{"type":"number"},"Is Anonymous Retail Customer":{"type":"number"},"Outbound Whse_ Handling Time":{"type":"string"},"Protected Account Number -CL-":{"type":"string"},"Ship-from Country_Region Code":{"type":"string"},"Account Number Prot_ Type -CL-":{"type":"number"},"Bill-to Customer Template Code":{"type":"string"},"Sell-to Customer Template Code":{"type":"string"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Document Type], [No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Document Type], [No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@6ed42c9e[stream=io.airbyte.protocol.models.AirbyteStream@4720e8e7[name=QCS, LLC$Sales Invoice Header,jsonSchema={"type":"object","properties":{"Id":{"type":"string"},"No_":{"type":"string"},"Area":{"type":"string"},"POS ID":{"type":"string"},"Job No_":{"type":"string"},"On Hold":{"type":"string"},"QR Code":{"type":"string","contentEncoding":"base64"},"User ID":{"type":"string"},"Disputed":{"type":"number"},"Due Date":{"type":"string"},"Exchange":{"type":"number"},"Project?":{"type":"number"},"Batch No_":{"type":"string"},"Hash -CL-":{"type":"string"},"Order No_":{"type":"string"},"Quote No_":{"type":"string"},"Store No_":{"type":"string"},"timestamp":{"type":"string","contentEncoding":"base64"},"Cashier ID":{"type":"string"},"Correction":{"type":"number"},"Error Code":{"type":"string"},"Exit Point":{"type":"string"},"No_ Series":{"type":"string"},"Order Date":{"type":"string"},"Tax Liable":{"type":"number"},"No_ Printed":{"type":"number"},"Reason Code":{"type":"string"},"Retainage _":{"type":"number"},"Source Code":{"type":"string"},"BI Timestamp":{"type":"string"},"Bill-to City":{"type":"string"},"Bill-to Name":{"type":"string"},"Campaign No_":{"type":"string"},"Catalog Code":{"type":"string"},"Payment Type":{"type":"number"},"Posting Date":{"type":"string"},"Posting Time":{"type":"string"},"Sell-to City":{"type":"string"},"Ship-to City":{"type":"string"},"Ship-to Code":{"type":"string"},"Ship-to Name":{"type":"string"},"Web Order ID":{"type":"string"},"Currency Code":{"type":"string"},"Document Date":{"type":"string"},"EFT GUID -CL-":{"type":"string"},"Language Code":{"type":"string"},"Location Code":{"type":"string"},"POS Type -CL-":{"type":"number"},"Shipment Date":{"type":"string"},"Tax Area Code":{"type":"string"},"Bill-to County":{"type":"string"},"Bill-to Name 2":{"type":"string"},"Card Type -CL-":{"type":"number"},"Coupled to CRM":{"type":"number"},"Date_Time Sent":{"type":"string"},"Master Job No_":{"type":"string"},"Sell-to County":{"type":"string"},"Ship-From Name":{"type":"string"},"Ship-to County":{"type":"string"},"Ship-to Name 2":{"type":"string"},"Web Profile ID":{"type":"string"},"Web Tax Amount":{"type":"number"},"Your Reference":{"type":"string"},"Bill-to Address":{"type":"string"},"Bill-to Contact":{"type":"string"},"Check Type -CL-":{"type":"number"},"Currency Factor":{"type":"number"},"Member Card No_":{"type":"string"},"Order Time -CL-":{"type":"string"},"Sell-to Address":{"type":"string"},"Sell-to Contact":{"type":"string"},"Ship-to Address":{"type":"string"},"Ship-to Contact":{"type":"string"},"Allow Line Disc_":{"type":"number"},"Bal_ Account No_":{"type":"string"},"Catalog Drop No_":{"type":"number"},"Dimension Set ID":{"type":"number"},"Dispute Resolved":{"type":"number"},"EU 3-Party Trade":{"type":"number"},"Order No_ Series":{"type":"string"},"Pre-Assigned No_":{"type":"string"},"Salesperson Code":{"type":"string"},"Ship-to UPS Zone":{"type":"string"},"Transaction Type":{"type":"string"},"Transport Method":{"type":"string"},"Work Description":{"type":"string","contentEncoding":"base64"},"Account Type -CL-":{"type":"number"},"Bal_ Account Type":{"type":"number"},"Bill-to Address 2":{"type":"string"},"Bill-to Post Code":{"type":"string"},"Date_Time Stamped":{"type":"string"},"Digital Stamp PAC":{"type":"string","contentEncoding":"base64"},"EFT Order ID -CL-":{"type":"string"},"Error Description":{"type":"string"},"Get Shipment Used":{"type":"number"},"Mailing List Code":{"type":"string"},"Sell-to Address 2":{"type":"string"},"Sell-to Post Code":{"type":"string"},"Ship-to Address 2":{"type":"string"},"Ship-to Post Code":{"type":"string"},"Tax Exemption No_":{"type":"string"},"Date_Time Canceled":{"type":"string"},"EFT Store No_ -CL-":{"type":"string"},"Invoice Disc_ Code":{"type":"string"},"Payment Discount _":{"type":"number"},"Payment Terms Code":{"type":"string"},"Pmt_ Discount Date":{"type":"string"},"Prepayment Invoice":{"type":"number"},"STE Transaction ID":{"type":"string"},"Web Payment Amount":{"type":"number"},"Account Number -CL-":{"type":"string"},"Applies-to Doc_ No_":{"type":"string"},"Bill-to Contact No_":{"type":"string"},"Bill-to ID No_ -CL-":{"type":"string"},"Payment Method Code":{"type":"string"},"Posting Description":{"type":"string"},"Routing Number -CL-":{"type":"string"},"Sell-to Contact No_":{"type":"string"},"Shipping Agent Code":{"type":"string"},"Source Document No_":{"type":"string"},"VAT Base Discount _":{"type":"number"},"Applies-to Doc_ Type":{"type":"number"},"Bill-to Customer No_":{"type":"string"},"Customer Disc_ Group":{"type":"string"},"Customer Price Group":{"type":"string"},"EFT Tender Type -CL-":{"type":"number"},"Encryption Salt -CL-":{"type":"string"},"Expiration Year -CL-":{"type":"string"},"OneSource Tax Exempt":{"type":"number"},"PAC Web Service Name":{"type":"string"},"Package Tracking No_":{"type":"string"},"Prepayment Order No_":{"type":"string"},"Prices Including VAT":{"type":"number"},"Residential Delivery":{"type":"number"},"Sell-to Customer No_":{"type":"string"},"Shipment Method Code":{"type":"string"},"Source Document Type":{"type":"number"},"VAT Registration No_":{"type":"string"},"Billed Freight Amount":{"type":"number"},"Click-to-Pay URL -CL-":{"type":"string"},"EFT Terminal No_ -CL-":{"type":"string"},"Expiration Month -CL-":{"type":"string"},"External Document No_":{"type":"string"},"Issuer ID Number -CL-":{"type":"string"},"Prepayment No_ Series":{"type":"string"},"Responsibility Center":{"type":"string"},"Sell-to Customer Name":{"type":"string"},"Web Merchandise Total":{"type":"number"},"Bill-to ID County -CL-":{"type":"string"},"Bill-to Phone No_ -CL-":{"type":"string"},"Cust_ Ledger Entry No_":{"type":"number"},"Customer Posting Group":{"type":"string"},"Invoice Discount Value":{"type":"number"},"Payment Service Set ID":{"type":"number"},"Sell-To Tax Class Code":{"type":"string"},"Sell-to E-Mail Address":{"type":"string"},"Sell-to Phone No_ -CL-":{"type":"string"},"Ship-to Phone No_ -CL-":{"type":"string"},"VAT Bus_ Posting Group":{"type":"string"},"Web User Industry Code":{"type":"string"},"Direct Debit Mandate ID":{"type":"string"},"Gen_ Bus_ Posting Group":{"type":"string"},"Pre-Assigned No_ Series":{"type":"string"},"Sell-to Customer Name 2":{"type":"string"},"VAT Country_Region Code":{"type":"string"},"Document Exchange Status":{"type":"number"},"Date_Time First Req_ Sent":{"type":"string"},"Fiscal Invoice Number PAC":{"type":"string"},"Is Anonymous Web Customer":{"type":"number"},"Shortcut Dimension 1 Code":{"type":"string"},"Shortcut Dimension 2 Code":{"type":"string"},"Transaction Specification":{"type":"string"},"AvaTax Customer Usage Type":{"type":"string"},"EFT Customer Link No_ -CL-":{"type":"string"},"Electronic Document Status":{"type":"number"},"Bill-to Country_Region Code":{"type":"string"},"Bill-to Federal ID No_ -CL-":{"type":"string"},"EFT Customer Link Type -CL-":{"type":"number"},"Sell-to Country_Region Code":{"type":"string"},"Ship-to Country_Region Code":{"type":"string"},"Shipping Agent Service Code":{"type":"string"},"Document Exchange Identifier":{"type":"string"},"EFT Cust_ Link Line No_ -CL-":{"type":"number"},"Electronic Invoice Type -CL-":{"type":"number"},"Invoice Discount Calculation":{"type":"number"},"Is Anonymous Retail Customer":{"type":"number"},"Protected Account Number -CL-":{"type":"string"},"Account Number Prot_ Type -CL-":{"type":"number"},"Doc_ Exch_ Original Identifier":{"type":"string"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@7fb74fff[stream=io.airbyte.protocol.models.AirbyteStream@106abd39[name=QCS, LLC$Sales Invoice Line,jsonSchema={"type":"object","properties":{"No_":{"type":"string"},"Area":{"type":"string"},"Type":{"type":"number"},"VAT _":{"type":"number"},"Amount":{"type":"number"},"Job No_":{"type":"string"},"Bin Code":{"type":"string"},"Division":{"type":"string"},"Line No_":{"type":"number"},"Made Job":{"type":"number"},"Nonstock":{"type":"number"},"Quantity":{"type":"number"},"Offer No_":{"type":"string"},"Unit Cost":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Exit Point":{"type":"string"},"Is Freight":{"type":"number"},"Net Weight":{"type":"number"},"Tax Liable":{"type":"number"},"Unit Price":{"type":"number"},"Vendor No_":{"type":"string"},"Description":{"type":"string"},"Line Amount":{"type":"number"},"Retainage _":{"type":"number"},"Unit Volume":{"type":"number"},"BI Timestamp":{"type":"string"},"Document No_":{"type":"string"},"Gross Weight":{"type":"number"},"Job Task No_":{"type":"string"},"Original Qty":{"type":"number"},"Posting Date":{"type":"string"},"Price Change":{"type":"number"},"Ship-to Code":{"type":"string"},"Shipment No_":{"type":"string"},"Tax Category":{"type":"string"},"Variant Code":{"type":"string"},"Deferral Code":{"type":"string"},"Description 2":{"type":"string"},"Drop Shipment":{"type":"number"},"Location Code":{"type":"string"},"Member Points":{"type":"number"},"Posting Group":{"type":"string"},"Shipment Date":{"type":"string"},"Special Order":{"type":"number"},"Tax Area Code":{"type":"string"},"Vendor No_ JM":{"type":"string"},"Master Job No_":{"type":"string"},"Tax Group Code":{"type":"string"},"VAT Difference":{"type":"number"},"VAT Identifier":{"type":"string"},"Variant Header":{"type":"number"},"Vendor No_ QCS":{"type":"string"},"Work Type Code":{"type":"string"},"Direct Purchase":{"type":"number"},"FA Posting Date":{"type":"string"},"IC Partner Code":{"type":"string"},"Line Discount _":{"type":"number"},"Prepayment Line":{"type":"number"},"Purchasing Code":{"type":"string"},"Quantity (Base)":{"type":"number"},"Sales Order No_":{"type":"string"},"Unit Cost (LCY)":{"type":"number"},"Unit of Measure":{"type":"string"},"VAT Amount -CL-":{"type":"number"},"VAT Base Amount":{"type":"number"},"VAT Clause Code":{"type":"string"},"Vendor Item No_":{"type":"string"},"Allow Line Disc_":{"type":"number"},"Allow Qty Change":{"type":"number"},"Dimension Set ID":{"type":"number"},"Print on Invoice":{"type":"number"},"Retainage Amount":{"type":"number"},"Salesperson Code":{"type":"string"},"Transaction Type":{"type":"string"},"Transport Method":{"type":"string"},"Units per Parcel":{"type":"number"},"Blanket Order No_":{"type":"string"},"Is Retainage Line":{"type":"number"},"Price description":{"type":"string"},"Sales Account No_":{"type":"string"},"Shipment Line No_":{"type":"number"},"EFT Entry No_ -CL-":{"type":"number"},"EFT Store No_ -CL-":{"type":"string"},"Item Category Code":{"type":"string"},"Member Points Type":{"type":"number"},"Person Responsible":{"type":"string"},"Product Group Code":{"type":"string"},"Purchase Order No_":{"type":"string"},"Return Reason Code":{"type":"string"},"Allow Invoice Disc_":{"type":"number"},"Appl_-to Item Entry":{"type":"number"},"Cross-Reference No_":{"type":"string"},"Original Qty (Base)":{"type":"number"},"Price Change Reason":{"type":"string"},"Variant Description":{"type":"string"},"Amount Including VAT":{"type":"number"},"Attached to Line No_":{"type":"number"},"Bill-to Customer No_":{"type":"string"},"Cross-Reference Type":{"type":"number"},"Customer Disc_ Group":{"type":"string"},"Customer Price Group":{"type":"string"},"IC Partner Ref_ Type":{"type":"number"},"IC Partner Reference":{"type":"string"},"Inv_ Discount Amount":{"type":"number"},"Line Discount Amount":{"type":"number"},"OneSource Tax Exempt":{"type":"number"},"Original Sales Price":{"type":"number"},"Package Tracking No_":{"type":"string"},"Retainage Applied-to":{"type":"number"},"Sell-to Customer No_":{"type":"string"},"System-Created Entry":{"type":"number"},"Unit of Measure Code":{"type":"string"},"Use Duplication List":{"type":"number"},"VAT Calculation Type":{"type":"number"},"Appl_-from Item Entry":{"type":"number"},"EFT Terminal No_ -CL-":{"type":"string"},"Responsibility Center":{"type":"string"},"Blanket Order Line No_":{"type":"number"},"Depreciation Book Code":{"type":"string"},"Job Contract Entry No_":{"type":"number"},"VAT Bus_ Posting Group":{"type":"string"},"Gen_ Bus_ Posting Group":{"type":"string"},"VAT Prod_ Posting Group":{"type":"string"},"Cross-Reference Type No_":{"type":"string"},"Gen_ Prod_ Posting Group":{"type":"string"},"Qty_ per Unit of Measure":{"type":"number"},"Transfer Price Order No_":{"type":"string"},"Line Discount Calculation":{"type":"number"},"Orig Unit of Measure Code":{"type":"string"},"Shortcut Dimension 1 Code":{"type":"string"},"Shortcut Dimension 2 Code":{"type":"string"},"Transaction Specification":{"type":"string"},"Depr_ until FA Posting Date":{"type":"number"},"OneSource Tax Exempt Reason":{"type":"string"},"Unit of Measure (Cross Ref_)":{"type":"string"},"Duplicate in Depreciation Book":{"type":"string"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Document No_], [Line No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Document No_], [Line No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@5f15d376[stream=io.airbyte.protocol.models.AirbyteStream@1fb27fa3[name=QCS, LLC$Sales Line,jsonSchema={"type":"object","properties":{"No_":{"type":"string"},"Area":{"type":"string"},"Type":{"type":"number"},"VAT _":{"type":"number"},"Amount":{"type":"number"},"Job No_":{"type":"string"},"Planned":{"type":"number"},"Reserve":{"type":"number"},"Subtype":{"type":"number"},"Bin Code":{"type":"string"},"Division":{"type":"string"},"Line No_":{"type":"number"},"Made Job":{"type":"number"},"Nonstock":{"type":"number"},"Profit _":{"type":"number"},"Quantity":{"type":"number"},"Offer No_":{"type":"string"},"Store No_":{"type":"string"},"Unit Cost":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Exit Point":{"type":"string"},"Is Freight":{"type":"number"},"Net Weight":{"type":"number"},"Tax Liable":{"type":"number"},"Unit Price":{"type":"number"},"Vendor No_":{"type":"string"},"Description":{"type":"string"},"Line Amount":{"type":"number"},"Retainage _":{"type":"number"},"Unit Volume":{"type":"number"},"BOM Item No_":{"type":"string"},"Document No_":{"type":"string"},"Gross Weight":{"type":"number"},"Job Task No_":{"type":"string"},"Original Qty":{"type":"number"},"Prepayment _":{"type":"number"},"Price Change":{"type":"number"},"Qty_ to Ship":{"type":"number"},"Ship-to Code":{"type":"string"},"Shipment No_":{"type":"string"},"Tax Category":{"type":"string"},"Variant Code":{"type":"string"},"Currency Code":{"type":"string"},"Deferral Code":{"type":"string"},"Description 2":{"type":"string"},"Document Type":{"type":"number"},"Drop Shipment":{"type":"number"},"Location Code":{"type":"string"},"Posting Group":{"type":"string"},"Promotion No_":{"type":"string"},"Shipment Date":{"type":"string"},"Shipping Time":{"type":"string"},"Special Order":{"type":"number"},"Tax Area Code":{"type":"string"},"Vendor No_ JM":{"type":"string"},"Master Job No_":{"type":"string"},"Ship-to Option":{"type":"number"},"Tax Group Code":{"type":"string"},"VAT Difference":{"type":"number"},"VAT Identifier":{"type":"string"},"Variant Header":{"type":"number"},"Vendor No_ QCS":{"type":"string"},"Work Type Code":{"type":"string"},"Direct Purchase":{"type":"number"},"FA Posting Date":{"type":"string"},"IC Partner Code":{"type":"string"},"Line Discount _":{"type":"number"},"Prepayment Line":{"type":"number"},"Purchasing Code":{"type":"string"},"Qty_ to Invoice":{"type":"number"},"Quantity (Base)":{"type":"number"},"Quantity Picked":{"type":"number"},"Unit Cost (LCY)":{"type":"number"},"Unit of Measure":{"type":"string"},"VAT Base Amount":{"type":"number"},"VAT Clause Code":{"type":"string"},"Vendor Item No_":{"type":"string"},"Allow Line Disc_":{"type":"number"},"Allow Qty Change":{"type":"number"},"Dimension Set ID":{"type":"number"},"JEB Created Line":{"type":"number"},"Job Posting Only":{"type":"number"},"Prepayment VAT _":{"type":"number"},"Print on Invoice":{"type":"number"},"Quantity Shipped":{"type":"number"},"Retainage Amount":{"type":"number"},"Transaction Type":{"type":"string"},"Transport Method":{"type":"string"},"Unit Price (LCY)":{"type":"number"},"Units per Parcel":{"type":"number"},"Blanket Order No_":{"type":"string"},"Is Quoted Freight":{"type":"number"},"Is Retainage Line":{"type":"number"},"Job Applies-to ID":{"type":"string"},"Line Amount (LCY)":{"type":"number"},"Prepayment Amount":{"type":"number"},"Prepmt_ Amt_ Inv_":{"type":"number"},"Price description":{"type":"string"},"Quantity Invoiced":{"type":"number"},"Shipment Line No_":{"type":"number"},"Appl_-to Job Entry":{"type":"number"},"Completely Shipped":{"type":"number"},"EFT Entry No_ -CL-":{"type":"number"},"EFT Store No_ -CL-":{"type":"string"},"Item Category Code":{"type":"string"},"Outstanding Amount":{"type":"number"},"Person Responsible":{"type":"string"},"Product Group Code":{"type":"string"},"Purchase Order No_":{"type":"string"},"Return Disposition":{"type":"number"},"Return Reason Code":{"type":"string"},"Return Receipt No_":{"type":"string"},"Allow Invoice Disc_":{"type":"number"},"Appl_-to Item Entry":{"type":"number"},"Cross-Reference No_":{"type":"string"},"Current Store Group":{"type":"string"},"Original Qty (Base)":{"type":"number"},"Prepmt Amt Deducted":{"type":"number"},"Prepmt_ Line Amount":{"type":"number"},"Price Change Reason":{"type":"string"},"Qty_ Shipped (Base)":{"type":"number"},"Qty_ to Ship (Base)":{"type":"number"},"Shipping Agent Code":{"type":"string"},"Variant Description":{"type":"string"},"Amount Including VAT":{"type":"number"},"Attached to Line No_":{"type":"number"},"Bill-to Customer No_":{"type":"string"},"Cross-Reference Type":{"type":"number"},"Customer Disc_ Group":{"type":"string"},"Customer Price Group":{"type":"string"},"IC Partner Ref_ Type":{"type":"number"},"IC Partner Reference":{"type":"string"},"Inv_ Discount Amount":{"type":"number"},"Line Discount Amount":{"type":"number"},"OneSource Tax Exempt":{"type":"number"},"Original Sales Price":{"type":"number"},"Outstanding Quantity":{"type":"number"},"Package Tracking No_":{"type":"string"},"Prepmt Amt to Deduct":{"type":"number"},"Qty_ Invoiced (Base)":{"type":"number"},"Return Qty_ Received":{"type":"number"},"Sell-to Customer No_":{"type":"string"},"Shipped Not Invoiced":{"type":"number"},"System-Created Entry":{"type":"number"},"Unit of Measure Code":{"type":"string"},"Use Duplication List":{"type":"number"},"VAT Calculation Type":{"type":"number"},"Appl_-from Item Entry":{"type":"number"},"Apply and Close (Job)":{"type":"number"},"Create Replacement SO":{"type":"number"},"EFT Terminal No_ -CL-":{"type":"string"},"Line Disc_ Amt_ (LCY)":{"type":"number"},"Planned Delivery Date":{"type":"string"},"Planned Shipment Date":{"type":"string"},"Prepayment Tax Liable":{"type":"number"},"Prepmt_ VAT Base Amt_":{"type":"number"},"Purch_ Order Line No_":{"type":"number"},"Responsibility Center":{"type":"string"},"Return Rcd_ Not Invd_":{"type":"number"},"Blanket Order Line No_":{"type":"number"},"Depreciation Book Code":{"type":"string"},"Job Contract Entry No_":{"type":"number"},"Originally Ordered No_":{"type":"string"},"Prepmt_ Amt_ Incl_ VAT":{"type":"number"},"Prepmt_ VAT Calc_ Type":{"type":"number"},"Promised Delivery Date":{"type":"string"},"Qty_ to Invoice (Base)":{"type":"number"},"Return Qty_ to Receive":{"type":"number"},"VAT Bus_ Posting Group":{"type":"string"},"Gen_ Bus_ Posting Group":{"type":"string"},"Outstanding Amt w_o Vat":{"type":"number"},"Outstanding Qty_ (Base)":{"type":"number"},"Requested Delivery Date":{"type":"string"},"Return Receipt Line No_":{"type":"number"},"VAT Prod_ Posting Group":{"type":"string"},"Cross-Reference Type No_":{"type":"string"},"Gen_ Prod_ Posting Group":{"type":"string"},"Outstanding Amount (LCY)":{"type":"number"},"Prepayment Tax Area Code":{"type":"string"},"Qty_ per Unit of Measure":{"type":"number"},"Source Document Line No_":{"type":"number"},"Current Cust_ Price Group":{"type":"string"},"Line Discount Calculation":{"type":"number"},"Orig Unit of Measure Code":{"type":"string"},"Out-of-Stock Substitution":{"type":"number"},"Prepayment Tax Group Code":{"type":"string"},"Prepayment VAT Difference":{"type":"number"},"Prepayment VAT Identifier":{"type":"string"},"Prepmt VAT Diff_ Deducted":{"type":"number"},"Prepmt_ Amount Inv_ (LCY)":{"type":"number"},"Qty_ Shipped Not Invoiced":{"type":"number"},"Qty_ to Assemble to Order":{"type":"number"},"Recalculate Invoice Disc_":{"type":"number"},"Shortcut Dimension 1 Code":{"type":"string"},"Shortcut Dimension 2 Code":{"type":"string"},"Transaction Specification":{"type":"string"},"Prepmt VAT Diff_ to Deduct":{"type":"number"},"Return Qty_ Rcd_ Not Invd_":{"type":"number"},"Shipped Not Invoiced (LCY)":{"type":"number"},"Special Order Purchase No_":{"type":"string"},"Alloc_ Plan Purc_ Order No_":{"type":"string"},"Depr_ until FA Posting Date":{"type":"number"},"OneSource Tax Exempt Reason":{"type":"string"},"Return Qty_ Received (Base)":{"type":"number"},"Return Rcd_ Not Invd_ (LCY)":{"type":"number"},"Returns Deferral Start Date":{"type":"string"},"Shipping Agent Service Code":{"type":"string"},"Allow Item Charge Assignment":{"type":"number"},"Inv_ Disc_ Amount to Invoice":{"type":"number"},"Originally Ordered Var_ Code":{"type":"string"},"Outbound Whse_ Handling Time":{"type":"string"},"Qty_ to Asm_ to Order (Base)":{"type":"number"},"Shipped Not Invoiced w_o Vat":{"type":"number"},"Unit of Measure (Cross Ref_)":{"type":"string"},"Prepmt_ Amount Inv_ Incl_ VAT":{"type":"number"},"Prepmt_ VAT Amount Inv_ (LCY)":{"type":"number"},"Qty_ Shipped Not Invd_ (Base)":{"type":"number"},"Return Qty_ to Receive (Base)":{"type":"number"},"Shipped Not Inv_ (LCY) No VAT":{"type":"number"},"Special Order Purch_ Line No_":{"type":"number"},"Duplicate in Depreciation Book":{"type":"string"},"Ret_ Qty_ Rcd_ Not Invd_(Base)":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Document Type], [Document No_], [Line No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Document Type], [Document No_], [Line No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@5abf031d[stream=io.airbyte.protocol.models.AirbyteStream@1f79ee06[name=QCS, LLC$Sales Price,jsonSchema={"type":"object","properties":{"Item No_":{"type":"string"},"Markup _":{"type":"number"},"Profit _":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Sales Code":{"type":"string"},"Sales Type":{"type":"number"},"Unit Price":{"type":"number"},"Ending Date":{"type":"string"},"Profit (LCY)":{"type":"number"},"Variant Code":{"type":"string"},"Currency Code":{"type":"string"},"Starting Date":{"type":"string"},"Allow Line Disc_":{"type":"number"},"Minimum Quantity":{"type":"number"},"Price Includes VAT":{"type":"number"},"Allow Invoice Disc_":{"type":"number"},"Unit of Measure Code":{"type":"string"},"Unit Price Including VAT":{"type":"number"},"VAT Bus_ Posting Gr_ (Price)":{"type":"string"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Item No_], [Sales Type], [Sales Code], [Starting Date], [Currency Code], [Variant Code], [Unit of Measure Code], [Minimum Quantity]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Item No_], [Sales Type], [Sales Code], [Starting Date], [Currency Code], [Variant Code], [Unit of Measure Code], [Minimum Quantity]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@6e8610fc[stream=io.airbyte.protocol.models.AirbyteStream@624525e8[name=QCS, LLC$Sales Shipment Header,jsonSchema={"type":"object","properties":{"No_":{"type":"string"},"Area":{"type":"string"},"On Hold":{"type":"string"},"User ID":{"type":"string"},"Due Date":{"type":"string"},"Order No_":{"type":"string"},"Quote No_":{"type":"string"},"Store No_":{"type":"string"},"timestamp":{"type":"string","contentEncoding":"base64"},"Correction":{"type":"number"},"Exit Point":{"type":"string"},"No_ Series":{"type":"string"},"Order Date":{"type":"string"},"Tax Liable":{"type":"number"},"No_ Printed":{"type":"number"},"Reason Code":{"type":"string"},"Source Code":{"type":"string"},"Bill-to City":{"type":"string"},"Bill-to Name":{"type":"string"},"Campaign No_":{"type":"string"},"Date Shipped":{"type":"string"},"Order Picker":{"type":"string"},"Picking Date":{"type":"string"},"Posting Date":{"type":"string"},"Sell-to City":{"type":"string"},"Ship-to City":{"type":"string"},"Ship-to Code":{"type":"string"},"Ship-to Name":{"type":"string"},"Web Order ID":{"type":"string"},"Currency Code":{"type":"string"},"Document Date":{"type":"string"},"Language Code":{"type":"string"},"Location Code":{"type":"string"},"Retail Status":{"type":"number"},"Shipment Date":{"type":"string"},"Shipping Time":{"type":"string"},"Statement No_":{"type":"string"},"Tax Area Code":{"type":"string"},"Bill-to County":{"type":"string"},"Bill-to Name 2":{"type":"string"},"Sell-to County":{"type":"string"},"Ship-to County":{"type":"string"},"Ship-to Name 2":{"type":"string"},"Web Profile ID":{"type":"string"},"Your Reference":{"type":"string"},"Bill-to Address":{"type":"string"},"Bill-to Contact":{"type":"string"},"Currency Factor":{"type":"number"},"Member Card No_":{"type":"string"},"Opportunity No_":{"type":"string"},"Sell-to Address":{"type":"string"},"Sell-to Contact":{"type":"string"},"Ship-to Address":{"type":"string"},"Ship-to Contact":{"type":"string"},"Allow Line Disc_":{"type":"number"},"Bal_ Account No_":{"type":"string"},"Dimension Set ID":{"type":"number"},"EU 3-Party Trade":{"type":"number"},"Order No_ Series":{"type":"string"},"Salesperson Code":{"type":"string"},"Ship-to UPS Zone":{"type":"string"},"Transaction Type":{"type":"string"},"Transport Method":{"type":"string"},"Bal_ Account Type":{"type":"number"},"Bill-to Address 2":{"type":"string"},"Bill-to Post Code":{"type":"string"},"EFT Order ID -CL-":{"type":"string"},"Sell-to Address 2":{"type":"string"},"Sell-to Post Code":{"type":"string"},"Ship-to Address 2":{"type":"string"},"Ship-to Post Code":{"type":"string"},"EFT Store No_ -CL-":{"type":"string"},"Invoice Disc_ Code":{"type":"string"},"Payment Discount _":{"type":"number"},"Payment Terms Code":{"type":"string"},"Pmt_ Discount Date":{"type":"string"},"Applies-to Doc_ No_":{"type":"string"},"Bill-to Contact No_":{"type":"string"},"Bill-to ID No_ -CL-":{"type":"string"},"Payment Method Code":{"type":"string"},"Posting Description":{"type":"string"},"Sell-to Contact No_":{"type":"string"},"Shipping Agent Code":{"type":"string"},"VAT Base Discount _":{"type":"number"},"Applies-to Doc_ Type":{"type":"number"},"Bill-to Customer No_":{"type":"string"},"Customer Disc_ Group":{"type":"string"},"Customer Price Group":{"type":"string"},"Package Tracking No_":{"type":"string"},"Prices Including VAT":{"type":"number"},"Reciving_Picking No_":{"type":"string"},"Residential Delivery":{"type":"number"},"Sell-to Customer No_":{"type":"string"},"Sell-to Phone No_TBD":{"type":"string"},"Ship-to Phone No_TBD":{"type":"string"},"Shipment Method Code":{"type":"string"},"VAT Registration No_":{"type":"string"},"Actual Freight Amount":{"type":"number"},"Billed Freight Amount":{"type":"number"},"External Document No_":{"type":"string"},"Responsibility Center":{"type":"string"},"Sell-to Customer Name":{"type":"string"},"Shipping Instructions":{"type":"string"},"Bill-to ID County -CL-":{"type":"string"},"Bill-to Phone No_ -CL-":{"type":"string"},"Customer Posting Group":{"type":"string"},"Promised Delivery Date":{"type":"string"},"Sell-to Phone No_ -CL-":{"type":"string"},"Ship-to Phone No_ -CL-":{"type":"string"},"VAT Bus_ Posting Group":{"type":"string"},"Date Web Status Updated":{"type":"string"},"Gen_ Bus_ Posting Group":{"type":"string"},"Requested Delivery Date":{"type":"string"},"Sell-to Customer Name 2":{"type":"string"},"VAT Country_Region Code":{"type":"string"},"Shortcut Dimension 1 Code":{"type":"string"},"Shortcut Dimension 2 Code":{"type":"string"},"Transaction Specification":{"type":"string"},"Bill-to Country_Region Code":{"type":"string"},"Bill-to Federal ID No_ -CL-":{"type":"string"},"Sell-to Country_Region Code":{"type":"string"},"Ship-to Country_Region Code":{"type":"string"},"Shipping Agent Service Code":{"type":"string"},"Outbound Whse_ Handling Time":{"type":"string"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@40c06556[stream=io.airbyte.protocol.models.AirbyteStream@1099ba96[name=QCS, LLC$Sales Shipment Line,jsonSchema={"type":"object","properties":{"No_":{"type":"string"},"Area":{"type":"string"},"Type":{"type":"number"},"VAT _":{"type":"number"},"Job No_":{"type":"string"},"Bin Code":{"type":"string"},"Line No_":{"type":"number"},"Nonstock":{"type":"number"},"Quantity":{"type":"number"},"Order No_":{"type":"string"},"Unit Cost":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Correction":{"type":"number"},"Exit Point":{"type":"string"},"Is Freight":{"type":"number"},"Net Weight":{"type":"number"},"Tax Liable":{"type":"number"},"Unit Price":{"type":"number"},"Vendor No_":{"type":"string"},"Description":{"type":"string"},"Unit Volume":{"type":"number"},"Document No_":{"type":"string"},"Gross Weight":{"type":"number"},"Job Task No_":{"type":"string"},"Original Qty":{"type":"number"},"Posting Date":{"type":"string"},"Ship-to Code":{"type":"string"},"Variant Code":{"type":"string"},"Description 2":{"type":"string"},"Drop Shipment":{"type":"number"},"Location Code":{"type":"string"},"Posting Group":{"type":"string"},"Shipment Date":{"type":"string"},"Shipping Time":{"type":"string"},"Tax Area Code":{"type":"string"},"Order Line No_":{"type":"number"},"Tax Group Code":{"type":"string"},"Variant Header":{"type":"number"},"Vendor No_ QCS":{"type":"string"},"Work Type Code":{"type":"string"},"FA Posting Date":{"type":"string"},"Line Discount _":{"type":"number"},"Purchasing Code":{"type":"string"},"Quantity (Base)":{"type":"number"},"Unit Cost (LCY)":{"type":"number"},"Unit of Measure":{"type":"string"},"VAT Base Amount":{"type":"number"},"Vendor Item No_":{"type":"string"},"Allow Line Disc_":{"type":"number"},"Allow Qty Change":{"type":"number"},"Dimension Set ID":{"type":"number"},"Transaction Type":{"type":"string"},"Transport Method":{"type":"string"},"Units per Parcel":{"type":"number"},"Blanket Order No_":{"type":"string"},"Quantity Invoiced":{"type":"number"},"Item Category Code":{"type":"string"},"Product Group Code":{"type":"string"},"Purchase Order No_":{"type":"string"},"Return Reason Code":{"type":"string"},"Allow Invoice Disc_":{"type":"number"},"Appl_-to Item Entry":{"type":"number"},"Cross-Reference No_":{"type":"string"},"Original Qty (Base)":{"type":"number"},"Variant Description":{"type":"string"},"Attached to Line No_":{"type":"number"},"Bill-to Customer No_":{"type":"string"},"Cross-Reference Type":{"type":"number"},"Customer Disc_ Group":{"type":"string"},"Customer Price Group":{"type":"string"},"IC Partner Ref_ Type":{"type":"number"},"IC Partner Reference":{"type":"string"},"Item Shpt_ Entry No_":{"type":"number"},"Package Tracking No_":{"type":"string"},"Qty_ Invoiced (Base)":{"type":"number"},"Sell-to Customer No_":{"type":"string"},"Unit of Measure Code":{"type":"string"},"Use Duplication List":{"type":"number"},"VAT Calculation Type":{"type":"number"},"Appl_-from Item Entry":{"type":"number"},"Planned Delivery Date":{"type":"string"},"Planned Shipment Date":{"type":"string"},"Purch_ Order Line No_":{"type":"number"},"Responsibility Center":{"type":"string"},"Blanket Order Line No_":{"type":"number"},"Depreciation Book Code":{"type":"string"},"Job Contract Entry No_":{"type":"number"},"Promised Delivery Date":{"type":"string"},"VAT Bus_ Posting Group":{"type":"string"},"Gen_ Bus_ Posting Group":{"type":"string"},"Item Charge Base Amount":{"type":"number"},"Requested Delivery Date":{"type":"string"},"VAT Prod_ Posting Group":{"type":"string"},"Cross-Reference Type No_":{"type":"string"},"Gen_ Prod_ Posting Group":{"type":"string"},"Qty_ per Unit of Measure":{"type":"number"},"Orig Unit of Measure Code":{"type":"string"},"Qty_ Shipped Not Invoiced":{"type":"number"},"Shortcut Dimension 1 Code":{"type":"string"},"Shortcut Dimension 2 Code":{"type":"string"},"Transaction Specification":{"type":"string"},"Authorized for Credit Card":{"type":"number"},"Depr_ until FA Posting Date":{"type":"number"},"Outbound Whse_ Handling Time":{"type":"string"},"Unit of Measure (Cross Ref_)":{"type":"string"},"Duplicate in Depreciation Book":{"type":"string"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Document No_], [Line No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Document No_], [Line No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@4e464989[stream=io.airbyte.protocol.models.AirbyteStream@5675fcc[name=QCS, LLC$Salesperson_Purchaser,jsonSchema={"type":"object","properties":{"Code":{"type":"string"},"Name":{"type":"string"},"Image":{"type":"string"},"Store":{"type":"string"},"Active":{"type":"number"},"E-Mail":{"type":"string"},"E-Mail 2":{"type":"string"},"Job Title":{"type":"string"},"Phone No_":{"type":"string"},"timestamp":{"type":"string","contentEncoding":"base64"},"Account No_":{"type":"string"},"Account Type":{"type":"number"},"Commission _":{"type":"number"},"Float Amount":{"type":"number"},"Search E-Mail":{"type":"string"},"Privacy Blocked":{"type":"number"},"Password Hash -CL-":{"type":"string"},"Password Salt -CL-":{"type":"string"},"Global Dimension 1 Code":{"type":"string"},"Global Dimension 2 Code":{"type":"string"},"POS Permission Set -CL-":{"type":"string"},"Retail Commission Blocked":{"type":"number"},"Login Expiration Date -CL-":{"type":"string"},"Responsible Coll_ Rep_ Code":{"type":"string"},"Password Change Required -CL-":{"type":"number"},"Password Last Reset Date -CL-":{"type":"string"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Code]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Code]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@46ce70e3[stream=io.airbyte.protocol.models.AirbyteStream@1b5e2fa6[name=QCS, LLC$Stockkeeping Unit,jsonSchema={"type":"object","properties":{"Item No_":{"type":"string"},"Lot Size":{"type":"number"},"Shelf No_":{"type":"string"},"Unit Cost":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Vendor No_":{"type":"string"},"Time Bucket":{"type":"string"},"Discontinued":{"type":"number"},"Gross Weight":{"type":"number"},"Skip Confirm":{"type":"number"},"Variant Code":{"type":"string"},"01DLR Pricing":{"type":"number"},"03AGP Pricing":{"type":"number"},"Location Code":{"type":"string"},"Reorder Point":{"type":"number"},"Standard Cost":{"type":"number"},"Order Multiple":{"type":"number"},"Overflow Level":{"type":"number"},"Assembly Policy":{"type":"number"},"Dampener Period":{"type":"string"},"Flushing Method":{"type":"number"},"Vendor Item No_":{"type":"string"},"Created From SKU":{"type":"string"},"Drop Ship Advice":{"type":"number"},"Last Direct Cost":{"type":"number"},"Reorder Quantity":{"type":"number"},"Safety Lead Time":{"type":"string"},"Dampener Quantity":{"type":"number"},"Include Inventory":{"type":"number"},"Maximum Inventory":{"type":"number"},"Reordering Policy":{"type":"number"},"Use Cross-Docking":{"type":"number"},"Display on Website":{"type":"number"},"Last Date Modified":{"type":"string"},"Transfer-from Code":{"type":"string"},"Rescheduling Period":{"type":"string"},"Transfer-Level Code":{"type":"number"},"All Customer Pricing":{"type":"number"},"Manufacturing Policy":{"type":"number"},"Replenishment System":{"type":"number"},"Lead Time Calculation":{"type":"string"},"Safety Stock Quantity":{"type":"number"},"Always In Stock on Web":{"type":"number"},"Components at Location":{"type":"string"},"Last Date Synchronized":{"type":"string"},"Last DateTime Modified":{"type":"string"},"Maximum Order Quantity":{"type":"number"},"Minimum Order Quantity":{"type":"number"},"Next Counting End Date":{"type":"string"},"Put-away Template Code":{"type":"string"},"Special Equipment Code":{"type":"string"},"Discrete Order Quantity":{"type":"number"},"Lot Accumulation Period":{"type":"string"},"Macola Avg_ Daily Usage":{"type":"number"},"Next Counting Start Date":{"type":"string"},"Last Counting Period Update":{"type":"string"},"Put-away Unit of Measure Code":{"type":"string"},"Phys Invt Counting Period Code":{"type":"string"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Location Code], [Item No_], [Variant Code]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=incremental,cursorField=[Last DateTime Modified],destinationSyncMode=append_dedup,primaryKey=[[Location Code], [Item No_], [Variant Code]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@67a82745[stream=io.airbyte.protocol.models.AirbyteStream@588e9d43[name=QCS, LLC$Trans_ Sales Entry,jsonSchema={"type":"object","properties":{"Date":{"type":"string"},"Time":{"type":"string"},"Price":{"type":"number"},"Shelf":{"type":"string"},"Counter":{"type":"number"},"Lot No_":{"type":"string"},"Section":{"type":"string"},"Item No_":{"type":"string"},"Line No_":{"type":"number"},"Quantity":{"type":"number"},"Staff ID":{"type":"string"},"VAT Code":{"type":"string"},"Deal Line":{"type":"number"},"Net Price":{"type":"number"},"Shift No_":{"type":"string"},"Store No_":{"type":"string"},"UOM Price":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Net Amount":{"type":"number"},"Replicated":{"type":"number"},"Sales Type":{"type":"string"},"Scale Item":{"type":"number"},"Serial No_":{"type":"string"},"Shift Date":{"type":"string"},"VAT Amount":{"type":"number"},"Barcode No_":{"type":"string"},"Cost Amount":{"type":"number"},"Receipt No_":{"type":"string"},"Refund Qty_":{"type":"number"},"Sales Staff":{"type":"string"},"Trans_ Date":{"type":"string"},"Trans_ Time":{"type":"string"},"Weight Item":{"type":"number"},"Customer No_":{"type":"string"},"Price Change":{"type":"number"},"Total Disc__":{"type":"number"},"Type of Sale":{"type":"number"},"UOM Quantity":{"type":"number"},"Variant Code":{"type":"string"},"Deal Line No_":{"type":"number"},"Line Discount":{"type":"number"},"Member Points":{"type":"number"},"Promotion No_":{"type":"string"},"Orig Trans No_":{"type":"number"},"Orig Trans Pos":{"type":"string"},"Return No Sale":{"type":"number"},"Statement Code":{"type":"string"},"Tax Group Code":{"type":"string"},"Total Discount":{"type":"number"},"xStatement No_":{"type":"string"},"Coupon Discount":{"type":"number"},"Discount Amount":{"type":"number"},"Expiration Date":{"type":"string"},"Parent Item No_":{"type":"string"},"Parent Line No_":{"type":"number"},"Transaction No_":{"type":"number"},"Unit of Measure":{"type":"string"},"Item Disc_ Group":{"type":"string"},"No Stock Posting":{"type":"number"},"Orig Trans Store":{"type":"string"},"POS Terminal No_":{"type":"string"},"Price Group Code":{"type":"string"},"Price in Barcode":{"type":"number"},"Refunded POS No_":{"type":"string"},"Transaction Code":{"type":"number"},"Customer Discount":{"type":"number"},"Infocode Discount":{"type":"number"},"Periodic Discount":{"type":"number"},"Refunded Line No_":{"type":"number"},"Item Category Code":{"type":"string"},"Item Posting Group":{"type":"string"},"Member Points Type":{"type":"number"},"Orig_ from Subcode":{"type":"string"},"Product Group Code":{"type":"string"},"Refunded Store No_":{"type":"string"},"Sales Tax Rounding":{"type":"number"},"Standard Net Price":{"type":"number"},"Total Rounded Amt_":{"type":"number"},"Item Corrected Line":{"type":"number"},"Item Number Scanned":{"type":"number"},"Keyboard Item Entry":{"type":"number"},"Line was Discounted":{"type":"number"},"Orig Trans Line No_":{"type":"number"},"Orig_ from Infocode":{"type":"string"},"Periodic Disc_ Type":{"type":"number"},"Refunded Trans_ No_":{"type":"number"},"Replication Counter":{"type":"number"},"xTransaction Status":{"type":"number"},"Deal Header Line No_":{"type":"number"},"Deal Line Added Amt_":{"type":"number"},"Linked No_ not Orig_":{"type":"number"},"Offer Blocked Points":{"type":"number"},"Periodic Disc_ Group":{"type":"string"},"VAT Calculation Type":{"type":"number"},"Excluded BOM Line No_":{"type":"number"},"Cust_ Invoice Discount":{"type":"number"},"Deal Modifier Line No_":{"type":"number"},"Infocode Selected Qty_":{"type":"number"},"VAT Bus_ Posting Group":{"type":"string"},"Infocode Entry Line No_":{"type":"number"},"Tot_ Disc Info Line No_":{"type":"number"},"Weight Manually Entered":{"type":"number"},"Coupon Amt_ For Printing":{"type":"number"},"Deal Modifier Added Amt_":{"type":"number"},"Serial_Lot No_ Not Valid":{"type":"number"},"Discount Amt_ For Printing":{"type":"number"},"Orig_ of a Linked Item List":{"type":"number"},"Disc_ Amount From Std_ Price":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Store No_], [POS Terminal No_], [Transaction No_], [Line No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Store No_], [POS Terminal No_], [Transaction No_], [Line No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@6d72b7d9[stream=io.airbyte.protocol.models.AirbyteStream@7bb96ce[name=QCS, LLC$Transaction Header,jsonSchema={"type":"object","properties":{"Date":{"type":"string"},"Time":{"type":"string"},"Comment":{"type":"string"},"Counter":{"type":"number"},"Payment":{"type":"number"},"Rounded":{"type":"number"},"Staff ID":{"type":"string"},"Order No_":{"type":"string"},"Safe Code":{"type":"string"},"Shift No_":{"type":"string"},"Store No_":{"type":"string"},"Table No_":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"Manager ID":{"type":"string"},"Net Amount":{"type":"number"},"No Receipt":{"type":"number"},"Replicated":{"type":"number"},"Sales Type":{"type":"string"},"Shift Date":{"type":"string"},"Tax Liable":{"type":"number"},"To Account":{"type":"number"},"Cost Amount":{"type":"number"},"Open Drawer":{"type":"number"},"Receipt No_":{"type":"string"},"Source Type":{"type":"number"},"Wrong Shift":{"type":"number"},"Y-Report ID":{"type":"string"},"Z-Report ID":{"type":"string"},"BI Timestamp":{"type":"string"},"Customer No_":{"type":"string"},"Entry Status":{"type":"number"},"Gross Amount":{"type":"number"},"Items Posted":{"type":"number"},"No_ of Items":{"type":"number"},"Split Number":{"type":"number"},"No_ of Covers":{"type":"number"},"Original Date":{"type":"string"},"Tax Area Code":{"type":"string"},"Customer Order":{"type":"number"},"Safe Entry No_":{"type":"number"},"Statement Code":{"type":"string"},"Total Discount":{"type":"number"},"Discount Amount":{"type":"number"},"Member Card No_":{"type":"string"},"No_ of Invoices":{"type":"number"},"Trans_ Currency":{"type":"string"},"Transaction No_":{"type":"number"},"WIC Transaction":{"type":"number"},"POS Terminal No_":{"type":"string"},"Post as Shipment":{"type":"number"},"Transaction Code":{"type":"number"},"Transaction Type":{"type":"number"},"Amount to Account":{"type":"number"},"Apply to Doc_ No_":{"type":"string"},"Customer Discount":{"type":"number"},"No_ of Item Lines":{"type":"number"},"Tax Exemption No_":{"type":"string"},"Income_Exp_ Amount":{"type":"number"},"Playback Entry No_":{"type":"number"},"Refund Receipt No_":{"type":"string"},"Replication Counter":{"type":"number"},"Sale Is Return Sale":{"type":"number"},"Sell-to Contact No_":{"type":"string"},"Customer Disc_ Group":{"type":"string"},"Infocode Disc_ Group":{"type":"string"},"No Receipt Back Date":{"type":"string"},"No_ of Payment Lines":{"type":"number"},"Gift Registration No_":{"type":"string"},"Playback Recording ID":{"type":"string"},"VAT Bus_Posting Group":{"type":"string"},"Net Income_Exp_ Amount":{"type":"number"},"Starting Point Balance":{"type":"number"},"Trans_ Sale_Pmt_ Diff_":{"type":"number"},"Created on POS Terminal":{"type":"string"},"Time when Total Pressed":{"type":"string"},"Time when Trans_ Closed":{"type":"string"},"Contains Forecourt Items":{"type":"number"},"Statement No_ - NOT USED":{"type":"string"},"Retrieved from Receipt No_":{"type":"string"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Store No_], [POS Terminal No_], [Transaction No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Store No_], [POS Terminal No_], [Transaction No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@218f0b73[stream=io.airbyte.protocol.models.AirbyteStream@dc7fe84[name=QCS, LLC$Value Entry,jsonSchema={"type":"object","properties":{"No_":{"type":"string"},"Type":{"type":"number"},"Job No_":{"type":"string"},"User ID":{"type":"string"},"Division":{"type":"string"},"Item No_":{"type":"string"},"Batch No_":{"type":"string"},"Entry No_":{"type":"number"},"Offer No_":{"type":"string"},"Order No_":{"type":"string"},"timestamp":{"type":"string","contentEncoding":"base64"},"Adjustment":{"type":"number"},"Entry Type":{"type":"number"},"Order Type":{"type":"number"},"Source No_":{"type":"string"},"Vendor No_":{"type":"string"},"Description":{"type":"string"},"Reason Code":{"type":"string"},"Source Code":{"type":"string"},"Source Type":{"type":"number"},"BI Timestamp":{"type":"string"},"Catalog Code":{"type":"string"},"Document No_":{"type":"string"},"Job Task No_":{"type":"string"},"Posting Date":{"type":"string"},"Resource No_":{"type":"string"},"Variant Code":{"type":"string"},"Cost per Unit":{"type":"number"},"Document Date":{"type":"string"},"Document Type":{"type":"number"},"Drop Shipment":{"type":"number"},"Expected Cost":{"type":"number"},"Inventoriable":{"type":"number"},"Item Category":{"type":"string"},"Location Code":{"type":"string"},"Product Group":{"type":"string"},"Promotion No_":{"type":"string"},"Variance Type":{"type":"number"},"Master Job No_":{"type":"string"},"Order Line No_":{"type":"number"},"Valuation Date":{"type":"string"},"Discount Amount":{"type":"number"},"Item Charge No_":{"type":"string"},"Valued Quantity":{"type":"number"},"Applies-to Entry":{"type":"number"},"Catalog Drop No_":{"type":"number"},"Dimension Set ID":{"type":"number"},"Document Line No_":{"type":"number"},"Invoiced Quantity":{"type":"number"},"Mailing List Code":{"type":"string"},"Cost Posted to G_L":{"type":"number"},"Inv_ Adjust_ Group":{"type":"string"},"Journal Batch Name":{"type":"string"},"Return Reason Code":{"type":"string"},"Cost per Unit (ACY)":{"type":"number"},"Partial Revaluation":{"type":"number"},"Cost Amount (Actual)":{"type":"number"},"Job Ledger Entry No_":{"type":"number"},"Source Posting Group":{"type":"string"},"External Document No_":{"type":"string"},"Item Ledger Entry No_":{"type":"number"},"Sales Amount (Actual)":{"type":"number"},"Average Cost Exception":{"type":"number"},"Cost Amount (Expected)":{"type":"number"},"Item Ledger Entry Type":{"type":"number"},"Salespers__Purch_ Code":{"type":"string"},"Valued By Average Cost":{"type":"number"},"Gen_ Bus_ Posting Group":{"type":"string"},"Global Dimension 1 Code":{"type":"string"},"Global Dimension 2 Code":{"type":"string"},"Inventory Posting Group":{"type":"string"},"Sales Amount (Expected)":{"type":"number"},"Cost Posted to G_L (ACY)":{"type":"number"},"Gen_ Prod_ Posting Group":{"type":"string"},"Purchase Amount (Actual)":{"type":"number"},"Capacity Ledger Entry No_":{"type":"number"},"Cost Amount (Non-Invtbl_)":{"type":"number"},"Cost Amount (Actual) (ACY)":{"type":"number"},"Item Ledger Entry Quantity":{"type":"number"},"Purchase Amount (Expected)":{"type":"number"},"Expected Cost Posted to G_L":{"type":"number"},"Cost Amount (Expected) (ACY)":{"type":"number"},"Exp_ Cost Posted to G_L (ACY)":{"type":"number"},"Cost Amount (Non-Invtbl_)(ACY)":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Entry No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Entry No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@75735c9a[stream=io.airbyte.protocol.models.AirbyteStream@2ea5a91c[name=QCS, LLC$Vendor,jsonSchema={"type":"object","properties":{"Id":{"type":"string"},"GLN":{"type":"string"},"No_":{"type":"string"},"City":{"type":"string"},"Name":{"type":"string"},"Image":{"type":"string"},"County":{"type":"string"},"E-Mail":{"type":"string"},"Name 2":{"type":"string"},"Address":{"type":"string"},"Blocked":{"type":"number"},"Contact":{"type":"string"},"Fax No_":{"type":"string"},"Old No_":{"type":"string"},"Picture":{"type":"string","contentEncoding":"base64"},"RFC No_":{"type":"string"},"Buyer ID":{"type":"string"},"CURP No_":{"type":"string"},"E-Mail 2":{"type":"string"},"Priority":{"type":"number"},"UPS Zone":{"type":"string"},"Address 2":{"type":"string"},"Home Page":{"type":"string"},"Phone No_":{"type":"string"},"Post Code":{"type":"string"},"Telex No_":{"type":"string"},"timestamp":{"type":"string","contentEncoding":"base64"},"No_ Series":{"type":"string"},"Payee Name":{"type":"string"},"Tax Liable":{"type":"number"},"Currency Id":{"type":"string"},"Phone No_ 2":{"type":"string"},"Search Name":{"type":"string"},"Creditor No_":{"type":"string"},"Partner Type":{"type":"number"},"Prepayment _":{"type":"number"},"Currency Code":{"type":"string"},"IRS 1099 Code":{"type":"string"},"Language Code":{"type":"string"},"Location Code":{"type":"string"},"Tax Area Code":{"type":"string"},"Federal ID No_":{"type":"string"},"Purchaser Code":{"type":"string"},"Territory Code":{"type":"string"},"Budgeted Amount":{"type":"number"},"Default COA No_":{"type":"string"},"IC Partner Code":{"type":"string"},"Our Account No_":{"type":"string"},"Privacy Blocked":{"type":"number"},"Tax ID No_ -CL-":{"type":"string"},"Buyer Group Code":{"type":"string"},"Payment Terms Id":{"type":"string"},"RTC Filter Field":{"type":"number"},"Statistics Group":{"type":"number"},"Check Date Format":{"type":"number"},"Pay-to Vendor No_":{"type":"string"},"Payment Method Id":{"type":"string"},"State Inscription":{"type":"string"},"Telex Answer Back":{"type":"string"},"Application Method":{"type":"number"},"Bank Communication":{"type":"number"},"Base Calendar Code":{"type":"string"},"Invoice Disc_ Code":{"type":"string"},"Last Date Modified":{"type":"string"},"Payment Terms Code":{"type":"string"},"Print Prices on PO":{"type":"number"},"Country_Region Code":{"type":"string"},"Payment Method Code":{"type":"string"},"Primary Contact No_":{"type":"string"},"Shipping Agent Code":{"type":"string"},"Check Date Separator":{"type":"number"},"Miscellaneous Vendor":{"type":"number"},"Prices Including VAT":{"type":"number"},"Shipment Method Code":{"type":"string"},"VAT Registration No_":{"type":"string"},"Vendor Posting Group":{"type":"string"},"Lead Time Calculation":{"type":"string"},"Responsibility Center":{"type":"string"},"Fin_ Charge Terms Code":{"type":"string"},"VAT Bus_ Posting Group":{"type":"string"},"Block Payment Tolerance":{"type":"number"},"Document Sending Method":{"type":"number"},"Gen_ Bus_ Posting Group":{"type":"string"},"Global Dimension 1 Code":{"type":"string"},"Global Dimension 2 Code":{"type":"string"},"Last Modified Date Time":{"type":"string"},"Tax Identification Type":{"type":"number"},"Document Sending Profile":{"type":"string"},"FATCA filing requirement":{"type":"number"},"Validate EU Vat Reg_ No_":{"type":"number"},"Preferred Bank Account Code":{"type":"string"},"Cash Flow Payment Terms Code":{"type":"string"},"Preferred Communication Method":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@77a8eb28[stream=io.airbyte.protocol.models.AirbyteStream@45291887[name=QCS, LLC$Vendor Ledger Entry,jsonSchema={"type":"object","properties":{"Open":{"type":"number"},"On Hold":{"type":"string"},"User ID":{"type":"string"},"Due Date":{"type":"string"},"Positive":{"type":"number"},"Reversed":{"type":"number"},"Entry No_":{"type":"number"},"timestamp":{"type":"string","contentEncoding":"base64"},"No_ Series":{"type":"string"},"Prepayment":{"type":"number"},"Vendor No_":{"type":"string"},"Description":{"type":"string"},"Reason Code":{"type":"string"},"Source Code":{"type":"string"},"Document No_":{"type":"string"},"Posting Date":{"type":"string"},"Applies-to ID":{"type":"string"},"Currency Code":{"type":"string"},"Document Date":{"type":"string"},"Document Type":{"type":"number"},"IRS 1099 Code":{"type":"string"},"Applying Entry":{"type":"number"},"Closed at Date":{"type":"string"},"Purchase (LCY)":{"type":"number"},"Purchaser Code":{"type":"string"},"Your Reference":{"type":"string"},"Amount to Apply":{"type":"number"},"IC Partner Code":{"type":"string"},"IRS 1099 Amount":{"type":"number"},"Transaction No_":{"type":"number"},"Bal_ Account No_":{"type":"string"},"Closed by Amount":{"type":"number"},"Dimension Set ID":{"type":"number"},"Bal_ Account Type":{"type":"number"},"Journal Batch Name":{"type":"string"},"Pmt_ Discount Date":{"type":"string"},"Reversed Entry No_":{"type":"number"},"Applies-to Doc_ No_":{"type":"string"},"Buy-from Vendor No_":{"type":"string"},"Closed by Entry No_":{"type":"number"},"Inv_ Discount (LCY)":{"type":"number"},"Payment Method Code":{"type":"string"},"Applies-to Doc_ Type":{"type":"number"},"Message to Recipient":{"type":"string"},"Miscellaneous Vendor":{"type":"number"},"Pmt_ Disc_ Rcd_(LCY)":{"type":"number"},"Pmt_ Tolerance (LCY)":{"type":"number"},"Vendor Posting Group":{"type":"string"},"External Document No_":{"type":"string"},"Reversed by Entry No_":{"type":"number"},"Closed by Amount (LCY)":{"type":"number"},"Max_ Payment Tolerance":{"type":"number"},"Recipient Bank Account":{"type":"string"},"Closed by Currency Code":{"type":"string"},"Global Dimension 1 Code":{"type":"string"},"Global Dimension 2 Code":{"type":"string"},"Adjusted Currency Factor":{"type":"number"},"Original Currency Factor":{"type":"number"},"Closed by Currency Amount":{"type":"number"},"Pmt_ Disc_ Tolerance Date":{"type":"string"},"Accepted Payment Tolerance":{"type":"number"},"Original Pmt_ Disc_ Possible":{"type":"number"},"Accepted Pmt_ Disc_ Tolerance":{"type":"number"},"Remaining Pmt_ Disc_ Possible":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Entry No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Entry No_]],additionalProperties={}], io.airbyte.protocol.models.ConfiguredAirbyteStream@2ad10b34[stream=io.airbyte.protocol.models.AirbyteStream@293faa3b[name=QCS, LLC$Warehouse Entry,jsonSchema={"type":"object","properties":{"Cubage":{"type":"number"},"Weight":{"type":"number"},"Job No_":{"type":"string"},"Lot No_":{"type":"string"},"User ID":{"type":"string"},"Bin Code":{"type":"string"},"Item No_":{"type":"string"},"Line No_":{"type":"number"},"Quantity":{"type":"number"},"Dedicated":{"type":"number"},"Entry No_":{"type":"number"},"Unit Cost":{"type":"number"},"Zone Code":{"type":"string"},"timestamp":{"type":"string","contentEncoding":"base64"},"Entry Type":{"type":"number"},"No_ Series":{"type":"string"},"Serial No_":{"type":"string"},"Source No_":{"type":"string"},"Total Cost":{"type":"number"},"Description":{"type":"string"},"Qty_ (Base)":{"type":"number"},"Reason Code":{"type":"string"},"Source Code":{"type":"string"},"Source Type":{"type":"number"},"Job Task No_":{"type":"string"},"Variant Code":{"type":"string"},"Bin Type Code":{"type":"string"},"Cost Category":{"type":"number"},"Location Code":{"type":"string"},"Reference No_":{"type":"string"},"Warranty Date":{"type":"string"},"Master Job No_":{"type":"string"},"Source Subtype":{"type":"number"},"Expiration Date":{"type":"string"},"Source Document":{"type":"number"},"Source Line No_":{"type":"number"},"Job Contract No_":{"type":"number"},"Registering Date":{"type":"string"},"Journal Batch Name":{"type":"string"},"Reference Document":{"type":"number"},"Source Subline No_":{"type":"number"},"Whse_ Document No_":{"type":"string"},"Whse_ Document Type":{"type":"number"},"Unit of Measure Code":{"type":"string"},"Journal Template Name":{"type":"string"},"Whse_ Document Line No_":{"type":"number"},"Qty_ per Unit of Measure":{"type":"number"},"Phys Invt Counting Period Code":{"type":"string"},"Phys Invt Counting Period Type":{"type":"number"}}},supportedSyncModes=[full_refresh, incremental],sourceDefinedCursor=,defaultCursorField=[],sourceDefinedPrimaryKey=[[Entry No_]],namespace=MSSQL_QCS,additionalProperties={}],syncMode=full_refresh,cursorField=[],destinationSyncMode=overwrite,primaryKey=[[Entry No_]],additionalProperties={}]],additionalProperties={}],failures=[io.airbyte.config.FailureReason@197ef59f[failureOrigin=source,failureType=,internalMessage=io.airbyte.workers.DefaultReplicationWorker$SourceException: Source process exited with non-zero exit code 143,externalMessage=Something went wrong within the source connector,metadata=io.airbyte.config.Metadata@149e2b17[additionalProperties={attemptNumber=0, jobId=607}],stacktrace=java.util.concurrent.CompletionException: io.airbyte.workers.DefaultReplicationWorker$SourceException: Source process exited with non-zero exit code 143 at java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:315) at java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:320) at java.base/java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1807) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:833) Caused by: io.airbyte.workers.DefaultReplicationWorker$SourceException: Source process exited with non-zero exit code 143 at io.airbyte.workers.DefaultReplicationWorker.lambda$getReplicationRunnable$5(DefaultReplicationWorker.java:312) at java.base/java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1804) ... 3 more ,retryable=,timestamp=1650892952624], io.airbyte.config.FailureReason@36b41a1b[failureOrigin=replication,failureType=,internalMessage=java.lang.RuntimeException: java.io.UncheckedIOException: java.net.SocketException: Socket closed,externalMessage=Something went wrong during replication,metadata=io.airbyte.config.Metadata@620e0084[additionalProperties={attemptNumber=0, jobId=607}],stacktrace=java.util.concurrent.CompletionException: java.lang.RuntimeException: java.io.UncheckedIOException: java.net.SocketException: Socket closed at java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:315) at java.base/java.util.concurrent.CompletableFuture.completeThrowable(CompletableFuture.java:320) at java.base/java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1807) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:833) Caused by: java.lang.RuntimeException: java.io.UncheckedIOException: java.net.SocketException: Socket closed at io.airbyte.workers.DefaultReplicationWorker.lambda$getDestinationOutputRunnable$6(DefaultReplicationWorker.java:367) at java.base/java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1804) ... 3 more Caused by: java.io.UncheckedIOException: java.net.SocketException: Socket closed at java.base/java.io.BufferedReader$1.hasNext(BufferedReader.java:574) at java.base/java.util.Spliterators$IteratorSpliterator.tryAdvance(Spliterators.java:1855) at java.base/java.util.stream.StreamSpliterators$WrappingSpliterator.lambda$initPartialTraversalState$0(StreamSpliterators.java:292) at java.base/java.util.stream.StreamSpliterators$AbstractWrappingSpliterator.fillBuffer(StreamSpliterators.java:206) at java.base/java.util.stream.StreamSpliterators$AbstractWrappingSpliterator.doAdvance(StreamSpliterators.java:161) at java.base/java.util.stream.StreamSpliterators$WrappingSpliterator.tryAdvance(StreamSpliterators.java:298) at java.base/java.util.Spliterators$1Adapter.hasNext(Spliterators.java:681) at io.airbyte.workers.protocols.airbyte.DefaultAirbyteDestination.isFinished(DefaultAirbyteDestination.java:141) at io.airbyte.workers.DefaultReplicationWorker.lambda$getDestinationOutputRunnable$6(DefaultReplicationWorker.java:341) ... 4 more Caused by: java.net.SocketException: Socket closed at java.base/sun.nio.ch.NioSocketImpl.endRead(NioSocketImpl.java:248) at java.base/sun.nio.ch.NioSocketImpl.implRead(NioSocketImpl.java:327) at java.base/sun.nio.ch.NioSocketImpl.read(NioSocketImpl.java:350) at java.base/sun.nio.ch.NioSocketImpl$1.read(NioSocketImpl.java:803) at java.base/java.net.Socket$SocketInputStream.read(Socket.java:966) at java.base/sun.nio.cs.StreamDecoder.readBytes(StreamDecoder.java:270) at java.base/sun.nio.cs.StreamDecoder.implRead(StreamDecoder.java:313) at java.base/sun.nio.cs.StreamDecoder.read(StreamDecoder.java:188) at java.base/java.io.InputStreamReader.read(InputStreamReader.java:177) at java.base/java.io.BufferedReader.fill(BufferedReader.java:162) at java.base/java.io.BufferedReader.readLine(BufferedReader.java:329) at java.base/java.io.BufferedReader.readLine(BufferedReader.java:396) at java.base/java.io.BufferedReader$1.hasNext(BufferedReader.java:571) ... 12 more ,retryable=,timestamp=1650892952631]]] 2022-04-25 13:22:32 INFO i.a.w.t.TemporalUtils(withBackgroundHeartbeat):235 - Stopping temporal heartbeating... 2022-04-25 13:21:44 source > 2022-04-25 13:21:44 INFO i.a.i.s.r.AbstractDbSource(lambda$createReadIterator$7):250 - Reading stream QCS, LLC$Warehouse Entry. Records read: 7780000 2022-04-25 13:21:46 source > 2022-04-25 13:21:46 INFO i.a.i.s.r.AbstractDbSource(lambda$createReadIterator$7):250 - Reading stream QCS, LLC$Warehouse Entry. Records read: 7790000 2022-04-25 13:21:48 source > 2022-04-25 13:21:48 INFO i.a.i.s.r.AbstractDbSource(lambda$createReadIterator$7):250 - Reading stream QCS, LLC$Warehouse Entry. Records read: 7800000 2022-04-25 13:21:50 source > 2022-04-25 13:21:50 INFO i.a.i.s.r.AbstractDbSource(lambda$createReadIterator$7):250 - Reading stream QCS, LLC$Warehouse Entry. Records read: 7810000 2022-04-25 13:21:53 source > 2022-04-25 13:21:52 INFO i.a.i.s.r.AbstractDbSource(lambda$createReadIterator$7):250 - Reading stream QCS, LLC$Warehouse Entry. Records read: 7820000 2022-04-25 13:21:55 source > 2022-04-25 13:21:54 INFO i.a.i.s.r.AbstractDbSource(lambda$createReadIterator$7):250 - Reading stream QCS, LLC$Warehouse Entry. Records read: 7830000 2022-04-25 13:21:57 source > 2022-04-25 13:21:57 INFO i.a.i.s.r.AbstractDbSource(lambda$createReadIterator$7):250 - Reading stream QCS, LLC$Warehouse Entry. Records read: 7840000 2022-04-25 13:21:59 source > 2022-04-25 13:21:59 INFO i.a.i.s.r.AbstractDbSource(lambda$createReadIterator$7):250 - Reading stream QCS, LLC$Warehouse Entry. Records read: 7850000 2022-04-25 13:22:01 source > 2022-04-25 13:22:01 INFO i.a.i.s.r.AbstractDbSource(lambda$createReadIterator$7):250 - Reading stream QCS, LLC$Warehouse Entry. Records read: 7860000 2022-04-25 13:22:04 source > 2022-04-25 13:22:03 INFO i.a.i.s.r.AbstractDbSource(lambda$createReadIterator$7):250 - Reading stream QCS, LLC$Warehouse Entry. Records read: 7870000 2022-04-25 13:22:06 source > 2022-04-25 13:22:05 INFO i.a.i.s.r.AbstractDbSource(lambda$createReadIterator$7):250 - Reading stream QCS, LLC$Warehouse Entry. Records read: 7880000 2022-04-25 13:22:08 source > 2022-04-25 13:22:08 INFO i.a.i.s.r.AbstractDbSource(lambda$createReadIterator$7):250 - Reading stream QCS, LLC$Warehouse Entry. Records read: 7890000 2022-04-25 13:22:10 source > 2022-04-25 13:22:10 INFO i.a.i.s.r.AbstractDbSource(lambda$createReadIterator$7):250 - Reading stream QCS, LLC$Warehouse Entry. Records read: 7900000 2022-04-25 13:22:12 destination > 2022-04-25 13:22:12 INFO i.a.i.d.r.SerializedBufferingStrategy(flushWriter):82 - Flushing buffer of stream QCS, LLC$Warehouse Entry (200 MB) 2022-04-25 13:22:12 destination > 2022-04-25 13:22:12 INFO i.a.i.d.s.StagingConsumerFactory(lambda$flushBufferFunction$3):155 - Flushing buffer for stream QCS, LLC$Warehouse Entry (200 MB) to staging 2022-04-25 13:22:12 destination > 2022-04-25 13:22:12 INFO i.a.i.d.r.BaseSerializedBuffer(flush):123 - Finished writing data to 0ec3f26c-e759-4e41-a7c6-66dbfeaae86817587241038190162385.csv.gz (200 MB) 2022-04-25 13:22:12 source > 2022-04-25 13:22:12 INFO i.a.i.s.r.AbstractDbSource(lambda$createReadIterator$7):250 - Reading stream QCS, LLC$Warehouse Entry. Records read: 7910000 2022-04-25 13:22:18 destination > 2022-04-25 13:22:18 INFO i.a.d.j.DefaultJdbcDatabase(lambda$unsafeQuery$1):106 - closing connection 2022-04-25 13:22:18 destination > 2022-04-25 13:22:18 INFO i.a.i.d.r.FileBuffer(deleteFile):78 - Deleting tempFile data 0ec3f26c-e759-4e41-a7c6-66dbfeaae86817587241038190162385.csv.gz 2022-04-25 13:22:18 destination > 2022-04-25 13:22:18 INFO i.a.i.d.r.SerializedBufferingStrategy(lambda$addRecord$0):55 - Starting a new buffer for stream QCS, LLC$Warehouse Entry (current state: 392 MB in 4 buffers) 2022-04-25 13:22:21 source > 2022-04-25 13:22:20 INFO i.a.i.s.r.AbstractDbSource(lambda$createReadIterator$7):250 - Reading stream QCS, LLC$Warehouse Entry. Records read: 7920000 2022-04-25 13:22:23 source > 2022-04-25 13:22:22 INFO i.a.i.s.r.AbstractDbSource(lambda$createReadIterator$7):250 - Reading stream QCS, LLC$Warehouse Entry. Records read: 7930000 2022-04-25 13:22:25 source > 2022-04-25 13:22:24 INFO i.a.i.s.r.AbstractDbSource(lambda$createReadIterator$7):250 - Reading stream QCS, LLC$Warehouse Entry. Records read: 7940000 2022-04-25 13:22:27 source > 2022-04-25 13:22:27 INFO i.a.i.s.r.AbstractDbSource(lambda$createReadIterator$7):250 - Reading stream QCS, LLC$Warehouse Entry. Records read: 7950000 2022-04-25 13:22:29 source > 2022-04-25 13:22:29 INFO i.a.i.s.r.AbstractDbSource(lambda$createReadIterator$7):250 - Reading stream QCS, LLC$Warehouse Entry. Records read: 7960000 2022-04-25 13:22:31 source > 2022-04-25 13:22:31 INFO i.a.i.s.r.AbstractDbSource(lambda$createReadIterator$7):250 - Reading stream QCS, LLC$Warehouse Entry. Records read: 7970000 2022-04-25 13:22:32 source > 2022-04-25 13:22:32 INFO i.a.i.s.r.AbstractDbSource(lambda$read$2):124 - Closing database connection pool. 2022-04-25 13:22:32 source > 2022-04-25 13:22:32 INFO i.a.i.s.r.AbstractDbSource(lambda$read$2):126 - Closed database connection pool. 2022-04-25 13:22:32 source > 2022-04-25 13:22:32 INFO i.a.i.b.IntegrationRunner(runInternal):169 - Completed integration: io.airbyte.integrations.base.ssh.SshWrappedSource 2022-04-25 13:22:32 source > 2022-04-25 13:22:32 INFO i.a.i.s.m.MssqlSource(main):450 - completed source: class io.airbyte.integrations.source.mssql.MssqlSource 2022-04-25 13:22:32 INFO i.a.w.DefaultNormalizationWorker(run):47 - Running normalization. 2022-04-25 13:22:32 INFO i.a.w.n.DefaultNormalizationRunner(runProcess):122 - Running with normalization version: airbyte/normalization-snowflake:0.1.75 2022-04-25 13:22:32 INFO i.a.w.p.KubeProcessFactory(create):113 - Attempting to start pod = normalization-snowflake-sync-607-0-xuars for airbyte/normalization-snowflake:0.1.75 2022-04-25 13:22:32 INFO i.a.w.p.KubeProcessFactory(create):116 - normalization-snowflake-sync-607-0-xuars stdoutLocalPort = 9016 2022-04-25 13:22:32 INFO i.a.w.p.KubeProcessFactory(create):119 - normalization-snowflake-sync-607-0-xuars stderrLocalPort = 9017 2022-04-25 13:22:32 INFO i.a.w.p.KubePodProcess(lambda$setupStdOutAndStdErrListeners$9):583 - Creating stdout socket server... 2022-04-25 13:22:32 INFO i.a.w.p.KubePodProcess():521 - Creating pod normalization-snowflake-sync-607-0-xuars... 2022-04-25 13:22:32 INFO i.a.w.p.KubePodProcess(lambda$setupStdOutAndStdErrListeners$10):601 - Creating stderr socket server... 2022-04-25 13:22:33 INFO i.a.w.p.KubePodProcess(waitForInitPodToRun):305 - Waiting for init container to be ready before copying files... 2022-04-25 13:22:33 INFO i.a.w.p.KubePodProcess(waitForInitPodToRun):318 - Init container present.. 2022-04-25 13:22:34 INFO i.a.w.p.KubePodProcess(waitForInitPodToRun):321 - Init container ready.. 2022-04-25 13:22:34 INFO i.a.w.p.KubePodProcess():546 - Copying files... 2022-04-25 13:22:34 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):254 - Uploading file: destination_config.json 2022-04-25 13:22:34 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):262 - kubectl cp /tmp/6a8a384b-9fd1-4ed8-828d-012fd138587d/destination_config.json default/normalization-snowflake-sync-607-0-xuars:/config/destination_config.json -c init 2022-04-25 13:22:34 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):265 - Waiting for kubectl cp to complete 2022-04-25 13:22:34 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):279 - kubectl cp complete, closing process 2022-04-25 13:22:34 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):254 - Uploading file: destination_catalog.json 2022-04-25 13:22:34 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):262 - kubectl cp /tmp/340d4e7b-37a0-47b8-8c7d-48f9e636fc39/destination_catalog.json default/normalization-snowflake-sync-607-0-xuars:/config/destination_catalog.json -c init 2022-04-25 13:22:34 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):265 - Waiting for kubectl cp to complete 2022-04-25 13:22:34 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):279 - kubectl cp complete, closing process 2022-04-25 13:22:34 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):254 - Uploading file: FINISHED_UPLOADING 2022-04-25 13:22:34 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):262 - kubectl cp /tmp/6008618b-916f-4e57-9258-68d9c28535e1/FINISHED_UPLOADING default/normalization-snowflake-sync-607-0-xuars:/config/FINISHED_UPLOADING -c init 2022-04-25 13:22:34 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):265 - Waiting for kubectl cp to complete 2022-04-25 13:22:35 INFO i.a.w.p.KubePodProcess(copyFilesToKubeConfigVolume):279 - kubectl cp complete, closing process 2022-04-25 13:22:35 INFO i.a.w.p.KubePodProcess():549 - Waiting until pod is ready... 2022-04-25 13:22:36 INFO i.a.w.p.KubePodProcess(lambda$setupStdOutAndStdErrListeners$9):592 - Setting stdout... 2022-04-25 13:22:36 INFO i.a.w.p.KubePodProcess(lambda$setupStdOutAndStdErrListeners$10):604 - Setting stderr... 2022-04-25 13:22:37 INFO i.a.w.p.KubePodProcess():564 - Reading pod IP... 2022-04-25 13:22:37 INFO i.a.w.p.KubePodProcess():566 - Pod IP: 10.226.5.139 2022-04-25 13:22:37 INFO i.a.w.p.KubePodProcess():573 - Using null stdin output stream... 2022-04-25 13:22:38 normalization > Processing destination_catalog.json... 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_ASSEMBLY_LINE_AB1.sql from QCS, LLC$Assembly Line 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_ASSEMBLY_LINE_AB2.sql from QCS, LLC$Assembly Line 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_ASSEMBLY_LINE_AB3.sql from QCS, LLC$Assembly Line 2022-04-25 13:22:38 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_ASSEMBLY_LINE.sql from QCS, LLC$Assembly Line 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_BANK_ACCOUNT_LEDGER_ENTRY_AB1.sql from QCS, LLC$Bank Account Ledger Entry 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_BANK_ACCOUNT_LEDGER_ENTRY_AB2.sql from QCS, LLC$Bank Account Ledger Entry 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_BANK_ACCOUNT_LEDGER_ENTRY_AB3.sql from QCS, LLC$Bank Account Ledger Entry 2022-04-25 13:22:38 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_BANK_ACCOUNT_LEDGER_ENTRY.sql from QCS, LLC$Bank Account Ledger Entry 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_CUST__LEDGER_ENTRY_AB1.sql from QCS, LLC$Cust_ Ledger Entry 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_CUST__LEDGER_ENTRY_AB2.sql from QCS, LLC$Cust_ Ledger Entry 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_CUST__LEDGER_ENTRY_AB3.sql from QCS, LLC$Cust_ Ledger Entry 2022-04-25 13:22:38 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_CUST__LEDGER_ENTRY.sql from QCS, LLC$Cust_ Ledger Entry 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_CUSTOMER_AB1.sql from QCS, LLC$Customer 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_CUSTOMER_AB2.sql from QCS, LLC$Customer 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_CUSTOMER_AB3.sql from QCS, LLC$Customer 2022-04-25 13:22:38 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_CUSTOMER.sql from QCS, LLC$Customer 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_DETAILED_CUST__LEDG__ENTRY_AB1.sql from QCS, LLC$Detailed Cust_ Ledg_ Entry 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_DETAILED_CUST__LEDG__ENTRY_AB2.sql from QCS, LLC$Detailed Cust_ Ledg_ Entry 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_DETAILED_CUST__LEDG__ENTRY_AB3.sql from QCS, LLC$Detailed Cust_ Ledg_ Entry 2022-04-25 13:22:38 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_DETAILED_CUST__LEDG__ENTRY.sql from QCS, LLC$Detailed Cust_ Ledg_ Entry 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_DETAILED_VENDOR_LEDG__ENTRY_AB1.sql from QCS, LLC$Detailed Vendor Ledg_ Entry 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_DETAILED_VENDOR_LEDG__ENTRY_AB2.sql from QCS, LLC$Detailed Vendor Ledg_ Entry 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_DETAILED_VENDOR_LEDG__ENTRY_AB3.sql from QCS, LLC$Detailed Vendor Ledg_ Entry 2022-04-25 13:22:38 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_DETAILED_VENDOR_LEDG__ENTRY.sql from QCS, LLC$Detailed Vendor Ledg_ Entry 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_G_L_ACCOUNT_AB1.sql from QCS, LLC$G_L Account 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_G_L_ACCOUNT_AB2.sql from QCS, LLC$G_L Account 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_G_L_ACCOUNT_AB3.sql from QCS, LLC$G_L Account 2022-04-25 13:22:38 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_G_L_ACCOUNT.sql from QCS, LLC$G_L Account 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_G_L_ENTRY_AB1.sql from QCS, LLC$G_L Entry 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_G_L_ENTRY_AB2.sql from QCS, LLC$G_L Entry 2022-04-25 13:22:38 normalization > Generating airbyte_views/MSSQL_QCS/QCS__LLC_G_L_ENTRY_STG.sql from QCS, LLC$G_L Entry 2022-04-25 13:22:38 normalization > Generating airbyte_incremental/scd/MSSQL_QCS/QCS__LLC_G_L_ENTRY_SCD.sql from QCS, LLC$G_L Entry 2022-04-25 13:22:38 normalization > Generating airbyte_incremental/MSSQL_QCS/QCS__LLC_G_L_ENTRY.sql from QCS, LLC$G_L Entry 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_G_L_ITEMLEVEL_SQL_AB1.sql from QCS, LLC$G_L_ItemLevel_SQL 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_G_L_ITEMLEVEL_SQL_AB2.sql from QCS, LLC$G_L_ItemLevel_SQL 2022-04-25 13:22:38 normalization > Generating airbyte_views/MSSQL_QCS/QCS__LLC_G_L_ITEMLEVEL_SQL_STG.sql from QCS, LLC$G_L_ItemLevel_SQL 2022-04-25 13:22:38 normalization > Generating airbyte_incremental/scd/MSSQL_QCS/QCS__LLC_G_L_ITEMLEVEL_SQL_SCD.sql from QCS, LLC$G_L_ItemLevel_SQL 2022-04-25 13:22:38 normalization > Generating airbyte_incremental/MSSQL_QCS/QCS__LLC_G_L_ITEMLEVEL_SQL.sql from QCS, LLC$G_L_ItemLevel_SQL 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_ITEM_AB1.sql from QCS, LLC$Item 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_ITEM_AB2.sql from QCS, LLC$Item 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_ITEM_AB3.sql from QCS, LLC$Item 2022-04-25 13:22:38 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_ITEM.sql from QCS, LLC$Item 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_ITEM_CATEGORY_AB1.sql from QCS, LLC$Item Category 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_ITEM_CATEGORY_AB2.sql from QCS, LLC$Item Category 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_ITEM_CATEGORY_AB3.sql from QCS, LLC$Item Category 2022-04-25 13:22:38 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_ITEM_CATEGORY.sql from QCS, LLC$Item Category 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_ITEM_LEDGER_ENTRY_AB1.sql from QCS, LLC$Item Ledger Entry 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_ITEM_LEDGER_ENTRY_AB2.sql from QCS, LLC$Item Ledger Entry 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_ITEM_LEDGER_ENTRY_AB3.sql from QCS, LLC$Item Ledger Entry 2022-04-25 13:22:38 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_ITEM_LEDGER_ENTRY.sql from QCS, LLC$Item Ledger Entry 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_ITEM_STATUS_LINK_AB1.sql from QCS, LLC$Item Status Link 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_ITEM_STATUS_LINK_AB2.sql from QCS, LLC$Item Status Link 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_ITEM_STATUS_LINK_AB3.sql from QCS, LLC$Item Status Link 2022-04-25 13:22:38 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_ITEM_STATUS_LINK.sql from QCS, LLC$Item Status Link 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_JOB_LEDGER_ENTRY_AB1.sql from QCS, LLC$Job Ledger Entry 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_JOB_LEDGER_ENTRY_AB2.sql from QCS, LLC$Job Ledger Entry 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_JOB_LEDGER_ENTRY_AB3.sql from QCS, LLC$Job Ledger Entry 2022-04-25 13:22:38 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_JOB_LEDGER_ENTRY.sql from QCS, LLC$Job Ledger Entry 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_JOB_PLANNING_LINE_AB1.sql from QCS, LLC$Job Planning Line 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_JOB_PLANNING_LINE_AB2.sql from QCS, LLC$Job Planning Line 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_JOB_PLANNING_LINE_AB3.sql from QCS, LLC$Job Planning Line 2022-04-25 13:22:38 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_JOB_PLANNING_LINE.sql from QCS, LLC$Job Planning Line 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_LOCATION_AB1.sql from QCS, LLC$Location 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_LOCATION_AB2.sql from QCS, LLC$Location 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_LOCATION_AB3.sql from QCS, LLC$Location 2022-04-25 13:22:38 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_LOCATION.sql from QCS, LLC$Location 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCH__CR__MEMO_LINE_AB1.sql from QCS, LLC$Purch_ Cr_ Memo Line 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCH__CR__MEMO_LINE_AB2.sql from QCS, LLC$Purch_ Cr_ Memo Line 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCH__CR__MEMO_LINE_AB3.sql from QCS, LLC$Purch_ Cr_ Memo Line 2022-04-25 13:22:38 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_PURCH__CR__MEMO_LINE.sql from QCS, LLC$Purch_ Cr_ Memo Line 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCH__INV__HEADER_AB1.sql from QCS, LLC$Purch_ Inv_ Header 2022-04-25 13:22:38 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCH__INV__HEADER_AB2.sql from QCS, LLC$Purch_ Inv_ Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCH__INV__HEADER_AB3.sql from QCS, LLC$Purch_ Inv_ Header 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_PURCH__INV__HEADER.sql from QCS, LLC$Purch_ Inv_ Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCH__INV__LINE_AB1.sql from QCS, LLC$Purch_ Inv_ Line 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCH__INV__LINE_AB2.sql from QCS, LLC$Purch_ Inv_ Line 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCH__INV__LINE_AB3.sql from QCS, LLC$Purch_ Inv_ Line 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_PURCH__INV__LINE.sql from QCS, LLC$Purch_ Inv_ Line 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCH__RCPT__HEADER_AB1.sql from QCS, LLC$Purch_ Rcpt_ Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCH__RCPT__HEADER_AB2.sql from QCS, LLC$Purch_ Rcpt_ Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCH__RCPT__HEADER_AB3.sql from QCS, LLC$Purch_ Rcpt_ Header 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_PURCH__RCPT__HEADER.sql from QCS, LLC$Purch_ Rcpt_ Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCHASE_HEADER_AB1.sql from QCS, LLC$Purchase Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCHASE_HEADER_AB2.sql from QCS, LLC$Purchase Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCHASE_HEADER_AB3.sql from QCS, LLC$Purchase Header 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_PURCHASE_HEADER.sql from QCS, LLC$Purchase Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCHASE_LINE_AB1.sql from QCS, LLC$Purchase Line 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCHASE_LINE_AB2.sql from QCS, LLC$Purchase Line 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCHASE_LINE_AB3.sql from QCS, LLC$Purchase Line 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_PURCHASE_LINE.sql from QCS, LLC$Purchase Line 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCHASE_LINE_ARCHIVE_AB1.sql from QCS, LLC$Purchase Line Archive 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCHASE_LINE_ARCHIVE_AB2.sql from QCS, LLC$Purchase Line Archive 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCHASE_LINE_ARCHIVE_AB3.sql from QCS, LLC$Purchase Line Archive 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_PURCHASE_LINE_ARCHIVE.sql from QCS, LLC$Purchase Line Archive 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCHASE_PRICE_AB1.sql from QCS, LLC$Purchase Price 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCHASE_PRICE_AB2.sql from QCS, LLC$Purchase Price 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_PURCHASE_PRICE_AB3.sql from QCS, LLC$Purchase Price 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_PURCHASE_PRICE.sql from QCS, LLC$Purchase Price 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_CR_MEMO_HEADER_AB1.sql from QCS, LLC$Sales Cr_Memo Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_CR_MEMO_HEADER_AB2.sql from QCS, LLC$Sales Cr_Memo Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_CR_MEMO_HEADER_AB3.sql from QCS, LLC$Sales Cr_Memo Header 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_SALES_CR_MEMO_HEADER.sql from QCS, LLC$Sales Cr_Memo Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_CR_MEMO_LINE_AB1.sql from QCS, LLC$Sales Cr_Memo Line 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_CR_MEMO_LINE_AB2.sql from QCS, LLC$Sales Cr_Memo Line 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_CR_MEMO_LINE_AB3.sql from QCS, LLC$Sales Cr_Memo Line 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_SALES_CR_MEMO_LINE.sql from QCS, LLC$Sales Cr_Memo Line 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_HEADER_AB1.sql from QCS, LLC$Sales Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_HEADER_AB2.sql from QCS, LLC$Sales Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_HEADER_AB3.sql from QCS, LLC$Sales Header 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_SALES_HEADER.sql from QCS, LLC$Sales Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_INVOICE_HEADER_AB1.sql from QCS, LLC$Sales Invoice Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_INVOICE_HEADER_AB2.sql from QCS, LLC$Sales Invoice Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_INVOICE_HEADER_AB3.sql from QCS, LLC$Sales Invoice Header 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_SALES_INVOICE_HEADER.sql from QCS, LLC$Sales Invoice Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_INVOICE_LINE_AB1.sql from QCS, LLC$Sales Invoice Line 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_INVOICE_LINE_AB2.sql from QCS, LLC$Sales Invoice Line 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_INVOICE_LINE_AB3.sql from QCS, LLC$Sales Invoice Line 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_SALES_INVOICE_LINE.sql from QCS, LLC$Sales Invoice Line 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_LINE_AB1.sql from QCS, LLC$Sales Line 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_LINE_AB2.sql from QCS, LLC$Sales Line 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_LINE_AB3.sql from QCS, LLC$Sales Line 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_SALES_LINE.sql from QCS, LLC$Sales Line 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_PRICE_AB1.sql from QCS, LLC$Sales Price 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_PRICE_AB2.sql from QCS, LLC$Sales Price 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_PRICE_AB3.sql from QCS, LLC$Sales Price 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_SALES_PRICE.sql from QCS, LLC$Sales Price 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_SHIPMENT_HEADER_AB1.sql from QCS, LLC$Sales Shipment Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_SHIPMENT_HEADER_AB2.sql from QCS, LLC$Sales Shipment Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_SHIPMENT_HEADER_AB3.sql from QCS, LLC$Sales Shipment Header 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_SALES_SHIPMENT_HEADER.sql from QCS, LLC$Sales Shipment Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_SHIPMENT_LINE_AB1.sql from QCS, LLC$Sales Shipment Line 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_SHIPMENT_LINE_AB2.sql from QCS, LLC$Sales Shipment Line 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALES_SHIPMENT_LINE_AB3.sql from QCS, LLC$Sales Shipment Line 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_SALES_SHIPMENT_LINE.sql from QCS, LLC$Sales Shipment Line 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALESPERSON_PURCHASER_AB1.sql from QCS, LLC$Salesperson_Purchaser 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALESPERSON_PURCHASER_AB2.sql from QCS, LLC$Salesperson_Purchaser 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_SALESPERSON_PURCHASER_AB3.sql from QCS, LLC$Salesperson_Purchaser 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_SALESPERSON_PURCHASER.sql from QCS, LLC$Salesperson_Purchaser 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_STOCKKEEPING_UNIT_AB1.sql from QCS, LLC$Stockkeeping Unit 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_STOCKKEEPING_UNIT_AB2.sql from QCS, LLC$Stockkeeping Unit 2022-04-25 13:22:39 normalization > Generating airbyte_views/MSSQL_QCS/QCS__LLC_STOCKKEEPING_UNIT_STG.sql from QCS, LLC$Stockkeeping Unit 2022-04-25 13:22:39 normalization > Generating airbyte_incremental/scd/MSSQL_QCS/QCS__LLC_STOCKKEEPING_UNIT_SCD.sql from QCS, LLC$Stockkeeping Unit 2022-04-25 13:22:39 normalization > Generating airbyte_incremental/MSSQL_QCS/QCS__LLC_STOCKKEEPING_UNIT.sql from QCS, LLC$Stockkeeping Unit 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_TRANS__SALES_ENTRY_AB1.sql from QCS, LLC$Trans_ Sales Entry 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_TRANS__SALES_ENTRY_AB2.sql from QCS, LLC$Trans_ Sales Entry 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_TRANS__SALES_ENTRY_AB3.sql from QCS, LLC$Trans_ Sales Entry 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_TRANS__SALES_ENTRY.sql from QCS, LLC$Trans_ Sales Entry 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_TRANSACTION_HEADER_AB1.sql from QCS, LLC$Transaction Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_TRANSACTION_HEADER_AB2.sql from QCS, LLC$Transaction Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_TRANSACTION_HEADER_AB3.sql from QCS, LLC$Transaction Header 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_TRANSACTION_HEADER.sql from QCS, LLC$Transaction Header 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_VALUE_ENTRY_AB1.sql from QCS, LLC$Value Entry 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_VALUE_ENTRY_AB2.sql from QCS, LLC$Value Entry 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_VALUE_ENTRY_AB3.sql from QCS, LLC$Value Entry 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_VALUE_ENTRY.sql from QCS, LLC$Value Entry 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_VENDOR_AB1.sql from QCS, LLC$Vendor 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_VENDOR_AB2.sql from QCS, LLC$Vendor 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_VENDOR_AB3.sql from QCS, LLC$Vendor 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_VENDOR.sql from QCS, LLC$Vendor 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_VENDOR_LEDGER_ENTRY_AB1.sql from QCS, LLC$Vendor Ledger Entry 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_VENDOR_LEDGER_ENTRY_AB2.sql from QCS, LLC$Vendor Ledger Entry 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_VENDOR_LEDGER_ENTRY_AB3.sql from QCS, LLC$Vendor Ledger Entry 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_VENDOR_LEDGER_ENTRY.sql from QCS, LLC$Vendor Ledger Entry 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_WAREHOUSE_ENTRY_AB1.sql from QCS, LLC$Warehouse Entry 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_WAREHOUSE_ENTRY_AB2.sql from QCS, LLC$Warehouse Entry 2022-04-25 13:22:39 normalization > Generating airbyte_ctes/MSSQL_QCS/QCS__LLC_WAREHOUSE_ENTRY_AB3.sql from QCS, LLC$Warehouse Entry 2022-04-25 13:22:39 normalization > Generating airbyte_tables/MSSQL_QCS/QCS__LLC_WAREHOUSE_ENTRY.sql from QCS, LLC$Warehouse Entry 2022-04-25 13:22:39 normalization > detected no config file for ssh, assuming ssh is off. 2022-04-25 13:22:44 normalization > [--event-buffer-size EVENT_BUFFER_SIZE] 2022-04-25 13:22:44 normalization > --event-buffer-size EVENT_BUFFER_SIZE 2022-04-25 13:22:44 normalization > 2022-04-25 13:22:44 normalization > DBT >=1.0.0 detected; using 10K event buffer size 2022-04-25 13:22:44 normalization > 2022-04-25 13:22:50 normalization > 13:22:50 Running with dbt=1.0.0 2022-04-25 13:22:50 normalization > 13:22:50 Partial parse save file not found. Starting full parse. 2022-04-25 13:23:18 normalization > 13:23:18 Found 167 models, 0 tests, 0 snapshots, 0 analyses, 528 macros, 0 operations, 0 seed files, 41 sources, 0 exposures, 0 metrics 2022-04-25 13:23:18 normalization > 13:23:18 2022-04-25 13:23:22 normalization > 13:23:22 Concurrency: 5 threads (target='prod') 2022-04-25 13:23:22 normalization > 13:23:22 2022-04-25 13:23:52 normalization > 13:23:52 1 of 47 START view model _AIRBYTE_MSSQL_QCS.QCS__LLC_G_L_ENTRY_STG................................................ [RUN] 2022-04-25 13:23:53 normalization > 13:23:53 2 of 47 START view model _AIRBYTE_MSSQL_QCS.QCS__LLC_G_L_ITEMLEVEL_SQL_STG........................................ [RUN] 2022-04-25 13:23:59 normalization > 13:23:59 2 of 47 OK created view model _AIRBYTE_MSSQL_QCS.QCS__LLC_G_L_ITEMLEVEL_SQL_STG................................... [SUCCESS 1 in 6.05s] 2022-04-25 13:23:59 normalization > 13:23:59 1 of 47 OK created view model _AIRBYTE_MSSQL_QCS.QCS__LLC_G_L_ENTRY_STG........................................... [SUCCESS 1 in 6.77s] 2022-04-25 13:24:56 normalization > 13:24:56 3 of 47 START view model _AIRBYTE_MSSQL_QCS.QCS__LLC_STOCKKEEPING_UNIT_STG........................................ [RUN] 2022-04-25 13:25:02 normalization > 13:25:02 3 of 47 OK created view model _AIRBYTE_MSSQL_QCS.QCS__LLC_STOCKKEEPING_UNIT_STG................................... [SUCCESS 1 in 6.42s] 2022-04-25 13:25:58 normalization > 13:25:58 4 of 47 START table model MSSQL_QCS.QCS__LLC_DETAILED_CUST__LEDG__ENTRY........................................... [RUN] 2022-04-25 13:25:59 normalization > 13:25:59 5 of 47 START table model MSSQL_QCS.QCS__LLC_DETAILED_VENDOR_LEDG__ENTRY.......................................... [RUN] 2022-04-25 13:26:03 normalization > 13:26:03 4 of 47 OK created table model MSSQL_QCS.QCS__LLC_DETAILED_CUST__LEDG__ENTRY...................................... [SUCCESS 1 in 4.85s] 2022-04-25 13:26:03 normalization > 13:26:03 6 of 47 START table model MSSQL_QCS.QCS__LLC_ASSEMBLY_LINE........................................................ [RUN] 2022-04-25 13:26:04 normalization > 13:26:04 5 of 47 OK created table model MSSQL_QCS.QCS__LLC_DETAILED_VENDOR_LEDG__ENTRY..................................... [SUCCESS 1 in 4.45s] 2022-04-25 13:26:09 normalization > 13:26:09 6 of 47 OK created table model MSSQL_QCS.QCS__LLC_ASSEMBLY_LINE................................................... [SUCCESS 1 in 5.56s] 2022-04-25 13:26:09 normalization > 13:26:09 7 of 47 START table model MSSQL_QCS.QCS__LLC_BANK_ACCOUNT_LEDGER_ENTRY............................................ [RUN] 2022-04-25 13:26:10 normalization > 13:26:10 8 of 47 START table model MSSQL_QCS.QCS__LLC_G_L_ACCOUNT.......................................................... [RUN] 2022-04-25 13:26:14 normalization > 13:26:14 7 of 47 OK created table model MSSQL_QCS.QCS__LLC_BANK_ACCOUNT_LEDGER_ENTRY....................................... [SUCCESS 1 in 5.63s] 2022-04-25 13:26:14 normalization > 13:26:14 9 of 47 START table model MSSQL_QCS.QCS__LLC_ITEM_CATEGORY........................................................ [RUN] 2022-04-25 13:26:15 normalization > 13:26:15 8 of 47 OK created table model MSSQL_QCS.QCS__LLC_G_L_ACCOUNT..................................................... [SUCCESS 1 in 4.69s] 2022-04-25 13:26:15 normalization > 13:26:15 10 of 47 START table model MSSQL_QCS.QCS__LLC_ITEM_STATUS_LINK.................................................... [RUN] 2022-04-25 13:26:19 normalization > 13:26:19 9 of 47 OK created table model MSSQL_QCS.QCS__LLC_ITEM_CATEGORY................................................... [SUCCESS 1 in 4.26s] 2022-04-25 13:26:19 normalization > 13:26:19 11 of 47 START table model MSSQL_QCS.QCS__LLC_ITEM_LEDGER_ENTRY................................................... [RUN] 2022-04-25 13:26:20 normalization > 13:26:20 10 of 47 OK created table model MSSQL_QCS.QCS__LLC_ITEM_STATUS_LINK............................................... [SUCCESS 1 in 4.72s] 2022-04-25 13:26:20 normalization > 13:26:20 12 of 47 START table model MSSQL_QCS.QCS__LLC_PURCHASE_PRICE...................................................... [RUN] 2022-04-25 13:26:23 normalization > 13:26:23 11 of 47 OK created table model MSSQL_QCS.QCS__LLC_ITEM_LEDGER_ENTRY.............................................. [SUCCESS 1 in 4.52s] 2022-04-25 13:26:23 normalization > 13:26:23 13 of 47 START table model MSSQL_QCS.QCS__LLC_LOCATION............................................................ [RUN] 2022-04-25 13:26:23 normalization > 13:26:23 12 of 47 OK created table model MSSQL_QCS.QCS__LLC_PURCHASE_PRICE................................................. [SUCCESS 1 in 3.72s] 2022-04-25 13:26:23 normalization > 13:26:23 14 of 47 START incremental model MSSQL_QCS.QCS__LLC_G_L_ITEMLEVEL_SQL_SCD......................................... [RUN] 2022-04-25 13:26:28 normalization > 13:26:28 13 of 47 OK created table model MSSQL_QCS.QCS__LLC_LOCATION....................................................... [SUCCESS 1 in 4.72s] 2022-04-25 13:26:28 normalization > 13:26:28 15 of 47 START incremental model MSSQL_QCS.QCS__LLC_G_L_ENTRY_SCD................................................. [RUN] 2022-04-25 13:26:29 normalization > 13:26:29 16 of 47 START table model MSSQL_QCS.QCS__LLC_CUST__LEDGER_ENTRY.................................................. [RUN] 2022-04-25 13:26:32 normalization > 13:26:32 17 of 47 START table model MSSQL_QCS.QCS__LLC_PURCH__CR__MEMO_LINE................................................ [RUN] 2022-04-25 13:26:34 normalization > 13:26:34 16 of 47 OK created table model MSSQL_QCS.QCS__LLC_CUST__LEDGER_ENTRY............................................. [SUCCESS 1 in 5.05s] 2022-04-25 13:26:34 normalization > 13:26:34 18 of 47 START table model MSSQL_QCS.QCS__LLC_JOB_LEDGER_ENTRY.................................................... [RUN] 2022-04-25 13:26:35 normalization > 13:26:35 17 of 47 OK created table model MSSQL_QCS.QCS__LLC_PURCH__CR__MEMO_LINE........................................... [SUCCESS 1 in 3.57s] 2022-04-25 13:26:35 normalization > 13:26:35 19 of 47 START table model MSSQL_QCS.QCS__LLC_JOB_PLANNING_LINE................................................... [RUN] 2022-04-25 13:26:38 normalization > 13:26:38 18 of 47 OK created table model MSSQL_QCS.QCS__LLC_JOB_LEDGER_ENTRY............................................... [SUCCESS 1 in 3.92s] 2022-04-25 13:26:38 normalization > 13:26:38 20 of 47 START table model MSSQL_QCS.QCS__LLC_SALESPERSON_PURCHASER............................................... [RUN] 2022-04-25 13:26:38 normalization > 13:26:38 19 of 47 OK created table model MSSQL_QCS.QCS__LLC_JOB_PLANNING_LINE.............................................. [SUCCESS 1 in 3.02s] 2022-04-25 13:26:38 normalization > 13:26:38 21 of 47 START table model MSSQL_QCS.QCS__LLC_PURCH__INV__HEADER.................................................. [RUN] 2022-04-25 13:26:41 normalization > 13:26:41 20 of 47 OK created table model MSSQL_QCS.QCS__LLC_SALESPERSON_PURCHASER.......................................... [SUCCESS 1 in 2.95s] 2022-04-25 13:26:41 normalization > 13:26:41 22 of 47 START table model MSSQL_QCS.QCS__LLC_PURCH__INV__LINE.................................................... [RUN] 2022-04-25 13:26:42 normalization > 13:26:42 21 of 47 OK created table model MSSQL_QCS.QCS__LLC_PURCH__INV__HEADER............................................. [SUCCESS 1 in 3.92s] 2022-04-25 13:26:42 normalization > 13:26:42 23 of 47 START table model MSSQL_QCS.QCS__LLC_PURCHASE_HEADER..................................................... [RUN] 2022-04-25 13:26:45 normalization > 13:26:45 22 of 47 OK created table model MSSQL_QCS.QCS__LLC_PURCH__INV__LINE............................................... [SUCCESS 1 in 3.48s] 2022-04-25 13:26:45 normalization > 13:26:45 24 of 47 START table model MSSQL_QCS.QCS__LLC_CUSTOMER............................................................ [RUN] 2022-04-25 13:26:46 normalization > 13:26:46 23 of 47 OK created table model MSSQL_QCS.QCS__LLC_PURCHASE_HEADER................................................ [SUCCESS 1 in 3.82s] 2022-04-25 13:26:46 normalization > 13:26:46 25 of 47 START table model MSSQL_QCS.QCS__LLC_PURCH__RCPT__HEADER................................................. [RUN] 2022-04-25 13:26:48 normalization > 13:26:48 24 of 47 OK created table model MSSQL_QCS.QCS__LLC_CUSTOMER....................................................... [SUCCESS 1 in 3.66s] 2022-04-25 13:26:48 normalization > 13:26:48 26 of 47 START table model MSSQL_QCS.QCS__LLC_SALES_PRICE......................................................... [RUN] 2022-04-25 13:26:50 normalization > 13:26:50 25 of 47 OK created table model MSSQL_QCS.QCS__LLC_PURCH__RCPT__HEADER............................................ [SUCCESS 1 in 3.73s] 2022-04-25 13:26:50 normalization > 13:26:50 27 of 47 START table model MSSQL_QCS.QCS__LLC_SALES_CR_MEMO_LINE.................................................. [RUN] 2022-04-25 13:26:51 normalization > 13:26:51 26 of 47 OK created table model MSSQL_QCS.QCS__LLC_SALES_PRICE.................................................... [SUCCESS 1 in 2.96s] 2022-04-25 13:26:51 normalization > 13:26:51 28 of 47 START table model MSSQL_QCS.QCS__LLC_PURCHASE_LINE_ARCHIVE............................................... [RUN] 2022-04-25 13:26:53 normalization > 13:26:53 27 of 47 OK created table model MSSQL_QCS.QCS__LLC_SALES_CR_MEMO_LINE............................................. [SUCCESS 1 in 3.19s] 2022-04-25 13:26:53 normalization > 13:26:53 29 of 47 START incremental model MSSQL_QCS.QCS__LLC_STOCKKEEPING_UNIT_SCD......................................... [RUN] 2022-04-25 13:26:54 normalization > 13:26:54 30 of 47 START table model MSSQL_QCS.QCS__LLC_SALES_INVOICE_LINE.................................................. [RUN] 2022-04-25 13:26:55 normalization > 13:26:55 28 of 47 OK created table model MSSQL_QCS.QCS__LLC_PURCHASE_LINE_ARCHIVE.......................................... [SUCCESS 1 in 3.84s] 2022-04-25 13:26:55 normalization > 13:26:55 31 of 47 START table model MSSQL_QCS.QCS__LLC_TRANSACTION_HEADER.................................................. [RUN] 2022-04-25 13:26:56 normalization > 13:26:56 30 of 47 OK created table model MSSQL_QCS.QCS__LLC_SALES_INVOICE_LINE............................................. [SUCCESS 1 in 2.69s] 2022-04-25 13:26:56 normalization > 13:26:56 32 of 47 START table model MSSQL_QCS.QCS__LLC_SALES_CR_MEMO_HEADER................................................ [RUN] 2022-04-25 13:26:57 normalization > 13:26:57 31 of 47 OK created table model MSSQL_QCS.QCS__LLC_TRANSACTION_HEADER............................................. [SUCCESS 1 in 1.99s] 2022-04-25 13:26:57 normalization > 13:26:57 33 of 47 START table model MSSQL_QCS.QCS__LLC_SALES_SHIPMENT_HEADER............................................... [RUN] 2022-04-25 13:26:59 normalization > 13:26:59 32 of 47 OK created table model MSSQL_QCS.QCS__LLC_SALES_CR_MEMO_HEADER........................................... [SUCCESS 1 in 2.58s] 2022-04-25 13:26:59 normalization > 13:26:59 34 of 47 START table model MSSQL_QCS.QCS__LLC_VALUE_ENTRY......................................................... [RUN] 2022-04-25 13:27:00 normalization > 13:27:00 33 of 47 OK created table model MSSQL_QCS.QCS__LLC_SALES_SHIPMENT_HEADER.......................................... [SUCCESS 1 in 2.43s] 2022-04-25 13:27:00 normalization > 13:27:00 35 of 47 START table model MSSQL_QCS.QCS__LLC_PURCHASE_LINE....................................................... [RUN] 2022-04-25 13:27:01 normalization > 13:27:01 34 of 47 OK created table model MSSQL_QCS.QCS__LLC_VALUE_ENTRY.................................................... [SUCCESS 1 in 1.93s] 2022-04-25 13:27:01 normalization > 13:27:01 36 of 47 START table model MSSQL_QCS.QCS__LLC_SALES_INVOICE_HEADER................................................ [RUN] 2022-04-25 13:27:02 normalization > 13:27:02 35 of 47 OK created table model MSSQL_QCS.QCS__LLC_PURCHASE_LINE.................................................. [SUCCESS 1 in 2.77s] 2022-04-25 13:27:02 normalization > 13:27:02 37 of 47 START table model MSSQL_QCS.QCS__LLC_SALES_SHIPMENT_LINE................................................. [RUN] 2022-04-25 13:27:04 normalization > 13:27:04 36 of 47 OK created table model MSSQL_QCS.QCS__LLC_SALES_INVOICE_HEADER........................................... [SUCCESS 1 in 2.80s] 2022-04-25 13:27:04 normalization > 13:27:04 38 of 47 START table model MSSQL_QCS.QCS__LLC_WAREHOUSE_ENTRY..................................................... [RUN] 2022-04-25 13:27:05 normalization > 13:27:05 37 of 47 OK created table model MSSQL_QCS.QCS__LLC_SALES_SHIPMENT_LINE............................................ [SUCCESS 1 in 2.13s] 2022-04-25 13:27:05 normalization > 13:27:05 39 of 47 START table model MSSQL_QCS.QCS__LLC_VENDOR_LEDGER_ENTRY................................................. [RUN] 2022-04-25 13:27:06 normalization > 13:27:06 38 of 47 OK created table model MSSQL_QCS.QCS__LLC_WAREHOUSE_ENTRY................................................ [SUCCESS 1 in 2.02s] 2022-04-25 13:27:06 normalization > 13:27:06 40 of 47 START table model MSSQL_QCS.QCS__LLC_TRANS__SALES_ENTRY.................................................. [RUN] 2022-04-25 13:27:07 normalization > 13:27:07 39 of 47 OK created table model MSSQL_QCS.QCS__LLC_VENDOR_LEDGER_ENTRY............................................ [SUCCESS 1 in 2.12s] 2022-04-25 13:27:07 normalization > 13:27:07 41 of 47 START table model MSSQL_QCS.QCS__LLC_VENDOR.............................................................. [RUN] 2022-04-25 13:27:09 normalization > 13:27:09 40 of 47 OK created table model MSSQL_QCS.QCS__LLC_TRANS__SALES_ENTRY............................................. [SUCCESS 1 in 3.10s] 2022-04-25 13:27:09 normalization > 13:27:09 42 of 47 START table model MSSQL_QCS.QCS__LLC_SALES_LINE.......................................................... [RUN] 2022-04-25 13:27:09 normalization > 13:27:09 41 of 47 OK created table model MSSQL_QCS.QCS__LLC_VENDOR......................................................... [SUCCESS 1 in 1.95s] 2022-04-25 13:27:09 normalization > 13:27:09 43 of 47 START table model MSSQL_QCS.QCS__LLC_SALES_HEADER........................................................ [RUN] 2022-04-25 13:27:13 normalization > 13:27:13 42 of 47 OK created table model MSSQL_QCS.QCS__LLC_SALES_LINE..................................................... [SUCCESS 1 in 3.92s] 2022-04-25 13:27:13 normalization > 13:27:13 44 of 47 START table model MSSQL_QCS.QCS__LLC_ITEM................................................................ [RUN] 2022-04-25 13:27:13 normalization > 13:27:13 43 of 47 OK created table model MSSQL_QCS.QCS__LLC_SALES_HEADER................................................... [SUCCESS 1 in 3.92s] 2022-04-25 13:27:17 normalization > 13:27:17 44 of 47 OK created table model MSSQL_QCS.QCS__LLC_ITEM........................................................... [SUCCESS 1 in 4.08s] 2022-04-25 13:27:35 normalization > 13:27:35 14 of 47 OK created incremental model MSSQL_QCS.QCS__LLC_G_L_ITEMLEVEL_SQL_SCD.................................... [SUCCESS 1 in 71.74s] 2022-04-25 13:27:35 normalization > 13:27:35 45 of 47 START incremental model MSSQL_QCS.QCS__LLC_G_L_ITEMLEVEL_SQL............................................. [RUN] 2022-04-25 13:28:15 normalization > 13:28:15 29 of 47 OK created incremental model MSSQL_QCS.QCS__LLC_STOCKKEEPING_UNIT_SCD.................................... [SUCCESS 1 in 82.06s] 2022-04-25 13:28:15 normalization > 13:28:15 46 of 47 START incremental model MSSQL_QCS.QCS__LLC_STOCKKEEPING_UNIT............................................. [RUN] 2022-04-25 13:28:34 normalization > 13:28:34 15 of 47 OK created incremental model MSSQL_QCS.QCS__LLC_G_L_ENTRY_SCD............................................ [SUCCESS 1 in 126.00s] 2022-04-25 13:28:34 normalization > 13:28:34 47 of 47 START incremental model MSSQL_QCS.QCS__LLC_G_L_ENTRY..................................................... [RUN] 2022-04-25 13:29:22 INFO i.a.w.p.KubePodProcess(close):713 - (pod: default / normalization-snowflake-sync-607-0-xuars) - Closed all resources for pod 2022-04-25 13:29:22 INFO i.a.w.DefaultNormalizationWorker(run):71 - Normalization executed in 6 minutes 49 seconds. 2022-04-25 13:29:22 INFO i.a.w.DefaultNormalizationWorker(run):77 - Normalization summary: io.airbyte.config.NormalizationSummary@67f4b427[startTime=1650892952855,endTime=1650893362749] 2022-04-25 13:29:22 INFO i.a.w.t.TemporalAttemptExecution(get):131 - Stopping cancellation check scheduling... 2022-04-25 13:29:22 INFO i.a.w.t.TemporalUtils(withBackgroundHeartbeat):235 - Stopping temporal heartbeating... 2022-04-25 13:28:43 normalization > 13:28:43 46 of 47 OK created incremental model MSSQL_QCS.QCS__LLC_STOCKKEEPING_UNIT........................................ [SUCCESS 1 in 27.79s] 2022-04-25 13:29:08 normalization > 13:29:08 45 of 47 OK created incremental model MSSQL_QCS.QCS__LLC_G_L_ITEMLEVEL_SQL........................................ [SUCCESS 1 in 92.98s] 2022-04-25 13:29:21 normalization > 13:29:21 47 of 47 OK created incremental model MSSQL_QCS.QCS__LLC_G_L_ENTRY................................................ [SUCCESS 1 in 47.22s] 2022-04-25 13:29:21 normalization > 13:29:21 2022-04-25 13:29:21 normalization > 13:29:21 Finished running 3 view models, 38 table models, 6 incremental models in 363.72s. 2022-04-25 13:29:21 normalization > 13:29:21 2022-04-25 13:29:21 normalization > 13:29:21 Completed successfully 2022-04-25 13:29:21 normalization > 13:29:21 2022-04-25 13:29:21 normalization > 13:29:21 Done. PASS=47 WARN=0 ERROR=0 SKIP=0 TOTAL=47