diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2024-06-07 11:34:21 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2024-06-07 11:34:21 +0700 |
| commit | c54a584c08f11ae73f05973defd1899ba9740557 (patch) | |
| tree | 20f24ad31357c84bb4af42c17658ce75eaa76705 /import_match_payment_invoice.ktr | |
| parent | 35d738ff58f301ec80eb2e91c0704dfe35e3fcc7 (diff) | |
import match payment invoice
Diffstat (limited to 'import_match_payment_invoice.ktr')
| -rw-r--r-- | import_match_payment_invoice.ktr | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/import_match_payment_invoice.ktr b/import_match_payment_invoice.ktr index 11e4155..7074623 100644 --- a/import_match_payment_invoice.ktr +++ b/import_match_payment_invoice.ktr @@ -556,7 +556,9 @@ <schema_name/> </partitioning> <connection>erp indoteknik production (localhost)</connection> - <sql>select * from v_match_payment_invoice</sql> + <sql>select * from v_match_payment_invoice v +join account_payment ap on ap.id = v.payment_id +where ap.write_date >= (now() - '15 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> |