get_credit_exposure — Credit Exposure

Each customer's credit limit against current balance plus open sales-order value, flagging who is over limit.

This is a Named SQL Query (SAP /SQLQueries) — dynamic aggregate SQL returning per-query rows, not a fixed Service Layer entity.

Credit-exposure report — each customer’s credit limit against current balance plus open sales-order value. Returns one row per customer with credit_limit, current_balance, open_order_value (total of their open orders), total_exposure (balance + open orders), and over_limit (true when exposure exceeds the limit), ordered by exposure, highest first. Only open orders count toward exposure.

Try these prompts

“show me the credit exposure”
“who is over their credit limit?”
“which customers are near their limit?”
“credit exposure for C001”

נסו גם בעברית

“הצג את החשיפה האשראית של הלקוחות”
“מי חרג ממסגרת האשראי?”
“אילו לקוחות קרובים למסגרת שלהם?”

Arguments

Arg	Required	Meaning
`card_code`	optional	One customer, e.g. `C001`. Omit for all customers.

Example result

One customer over limit. C002 Beta Industries — $18,000 exposure vs a $15,000 limit ($12,000 balance + $6,000 open orders). C001 Acme Corp — $9,500 exposure, within its $20,000 limit.

Result columns

Column	Type	Meaning
`card_code`	text	The customer’s SAP code.
`card_name`	text	The customer’s name.
`credit_limit`	number	The limit set on the customer’s account.
`current_balance`	number	What the customer owes today.
`open_order_value`	number	Total value of the customer’s open sales orders.
`total_exposure`	number	`current_balance` plus `open_order_value`.
`over_limit`	text	`true` when `total_exposure` passes `credit_limit`. The row holds a boolean; the closed type set has none, so it is declared `text` — a flag to read, not a magnitude to plot.

Charts

bar: x=card_name, y=total_exposure,credit_limit, title=“Exposure vs credit limit”
bar: x=card_name, y=current_balance,open_order_value, title=“Balance and open orders”

get_ar_aging — plain outstanding-receivables aging, without the limit.
get_order_backlog — open sales-order demand against stock.