cbd_locked_new Normal 0 / ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID TRANSNAME Y TRANSNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD EXECUTING_SERVER N EXECUTING_SERVER EXECUTING_USER N EXECUTING_USER CLIENT N CLIENT
ID_BATCH Y ID_BATCH SEQ_NR Y SEQ_NR LOGDATE Y LOGDATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS INPUT_BUFFER_ROWS Y INPUT_BUFFER_ROWS OUTPUT_BUFFER_ROWS Y OUTPUT_BUFFER_ROWS
ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID
ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS LOG_FIELD N LOG_FIELD
ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE METRICS_DATE Y METRICS_DATE METRICS_CODE Y METRICS_CODE METRICS_DESCRIPTION Y METRICS_DESCRIPTION METRICS_SUBJECT Y METRICS_SUBJECT METRICS_TYPE Y METRICS_TYPE METRICS_VALUE Y METRICS_VALUE
0.0 0.0 10000 50 50 N Y 50000 Y N 1000 100 - 2025/08/30 09:01:38.657 - 2025/08/30 09:01:38.657 H4sIAAAAAAAAAAMAAAAAAAAAAAA= N erp indoteknik production (localhost) 10.148.0.3 POSTGRESQL Native erp_indoteknik 5432 pdi Encrypted 2be989bb20084ca95810197629d9ea18e FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N PORT_NUMBER 5432 PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE N USE_POOLING N input payment_term Merge join Y input invoices Merge join Y Constraint Variable Calculator res id Y Calculator res id Update Previous PT & CBD Locked Y Merge join Select values Y Select values Constraint Variable Y Update Previous PT & CBD Locked Update Value Ref PPT Y Calculator res id Calculator Y 1 none Y sum_res_id ADD res_id partner_id String -1 -1 N 560 32 Y Constraint Variable Constant Y 1 none is_cbd_locked Boolean true -1 -1 N res_id String res.partner, -1 -1 N value_reference_new String account.payment.term,26 -1 -1 N name_ppt String property_payment_term_id -1 -1 N 560 176 Y Merge join MergeJoin Y 1 none INNER input invoices input payment_term invoice_payment_term_id payment_term_id 400 176 Y Select values SelectValues Y 1 none invoice_payment_term_id previous_pt partner_id N 400 32 Y Update Previous PT & CBD Locked Update Y 1 none erp indoteknik production (localhost) N 100 N Y public
res_partner
partner_id id = previous_payment_term_id previous_pt is_cbd_locked is_cbd_locked 752 176 Y Update Value Ref PPT Update Y 1 none erp indoteknik production (localhost) N 100 Y N public ir_property
name_ppt name = sum_res_id res_id = value_reference value_reference_new 752 32 Y input invoices TableInput Y 1 none erp indoteknik production (localhost) SELECT am.partner_id, rp.name AS partner_name, am.id AS invoice_id, am.name AS invoice_name, am.invoice_date_due, am.payment_state, am.customer_promise_date, am.invoice_payment_term_id FROM account_move am JOIN res_partner rp ON rp.id = am.partner_id WHERE am.move_type = 'out_invoice' AND am.state = 'posted' AND am.payment_state NOT IN ('paid', 'in_payment', 'reversed') AND am.invoice_date_due IS NOT NULL AND am.date_terima_tukar_faktur IS NOT NULL AND am.amount_residual IS NOT NULL AND am.invoice_date_due < (CURRENT_DATE - INTERVAL '30 day') AND (am.customer_promise_date < CURRENT_DATE OR am.customer_promise_date IS NULL) ORDER BY invoice_payment_term_id; 0 N N N N Integer normal partner_id 9 0 input invoices partner_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal partner_name 2147483647 -1 input invoices partner_name . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal invoice_id 9 0 input invoices invoice_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal invoice_name 2147483647 -1 input invoices invoice_name . , none N Y 0 N N N en_US Asia/Bangkok N Date normal invoice_date_due -1 -1 input invoices invoice_date_due . , none N Y 0 N N N en_US Asia/Bangkok N String normal payment_state 2147483647 -1 input invoices payment_state . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal invoice_payment_term_id 9 0 input invoices invoice_payment_term_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N 240 96 Y input payment_term TableInput Y 1 none erp indoteknik production (localhost) SELECT apt.id AS payment_term_id, apt.name AS payment_term_name, SUM(aptl.days) AS total_days FROM account_payment_term apt JOIN account_payment_term_line aptl ON aptl.payment_id = apt.id GROUP BY apt.id, apt.name HAVING SUM(aptl.days) > 0 order by apt.id; 0 N N N N Integer normal payment_term_id 9 0 input payment_term payment_term_id ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N String normal payment_term_name 2147483647 -1 input payment_term payment_term_name . , none N Y 0 N N N en_US Asia/Bangkok N Integer normal total_days 15 0 input payment_term total_days ####0;-####0 . , none N Y 0 N N N en_US Asia/Bangkok N 240 256 Y N