AR Autoinvoice Interface

Description

Categories
Enginatics
Repository
GitHub
Lines in the Autoinvoice interface table, one row per interface line, with all errors of the line from the last Autoinvoice run concatenated in Error Messages and Invalid Values.

Interface Line Id is assigned by Autoinvoice, so lines that it has not picked up yet have none and cannot have errors.

With Show Distributions and Sales Credits, each line is repeated per interface distribution and sales credit, and its quantity, amount and Line Count of 1 are shown on the first of these rows only.

The template Autoinvoice Interface Summary totals the lines per operating unit, batch source, context, error messages and request.

SQL 80 lines

Parameters 10

ParameterTypeList of values SQL
Operating UnitLOV
haouv.name=:operating_unit
Show AgeLOV
trunc(sysdate-rila.creation_date) age,
Batch SourceLOV
rila.batch_source_name=:batch_source
Interface Line ContextLOV
rila.interface_line_context=:interface_line_context
Request IdNumber
rila.request_id=:request_id
Sales OrderChar
rila.sales_order=:sales_order
Creation Date FromDate
rila.creation_date>=:creation_date_from
Creation Date ToDate
rila.creation_date<:creation_date_to+1
Errors OnlyLOV
rila.interface_line_id in (select riea.interface_line_id from ra_interface_errors_all riea)
Show Distributions and Sales CreditsLOV
xxen_util.meaning(ric.account_class,'AUTOGL_TYPE',222) account_class,
(select gcck.concatenated_segments from gl_code_combinations_kfv gcck where ric.code_combination_id=gcck.code_combination_id) account,
ric.salesperson,
ric.sales_credit_type,
ric.percent,
ric.child_amount,