Skip to content

Latest commit

 

History

History
7 lines (4 loc) · 413 Bytes

File metadata and controls

7 lines (4 loc) · 413 Bytes

InvoiceExtractor

A [[RocsMiddleware]] service that extracts invoices from [[ExportMaster]] and stores them in PostgreSQL for X3 upload.

Repo: ~/Git/RocsMiddleware/InvoiceExtractor

Queries [[ExportMaster]] via [[ODBC]] in batches of 100, enriches with customer dimension data from PostgreSQL, and bulk inserts headers and lines in a single transaction. Smart filtering skips already-extracted invoices.