Walk me through routes determination, split analysis for invoice, Mwst in pricing procedure, and TPO details including vendor ask vs automatic restock control.
Use the supplied Accenture procurement data to produce one reconciliation row for every invoice line. Select the latest route and MwSt pricing record, summarize invoice splits, and classify the applicable TPO restock behavior.
invoice_id, line_no, route_code, split_total, split_status, mwst_rate, mwst_amount, vendor_request_qty, auto_restock_qty, control_mode, and control_result.invoice_id, then line_no.| Column | Type | Description |
|---|---|---|
| route_idPK | INT | Route determination record identifier |
| order_id | INT | Procurement order identifier |
| route_code | VARCHAR(30) | Determined logistics route |
| determination_ts | TIMESTAMP | Time at which the route was determined |
| Column | Type | Description |
|---|---|---|
| invoice_idPK | INT | Invoice identifier |
| order_id | INT | Related procurement order |
| invoice_date | DATE | Invoice date |
| vendor_id | INT | Vendor identifier |
| Column | Type | Description |
|---|---|---|
| invoice_idPK | INT | Invoice identifier |
| line_noPK | INT | Invoice line number |
| sku | VARCHAR(30) | Material or product identifier |
| quantity | INT | Invoiced quantity |
| net_amount | NUMERIC(12,2) | Net invoice amount before tax |
| Column | Type | Description |
|---|---|---|
| split_idPK | INT | Invoice split identifier |
| invoice_id | INT | Invoice identifier |
| line_no | INT | Invoice line number |
| split_quantity | INT | Quantity assigned to this split |
| amount_split | NUMERIC(12,2) | Amount assigned to this split |
| Column | Type | Description |
|---|---|---|
| condition_idPK | INT | Pricing condition identifier |
| invoice_id | INT | Invoice identifier |
| line_no | INT | Invoice line number |
| condition_seq | INT | Pricing procedure sequence |
| condition_type | VARCHAR(20) | Pricing condition type |
| mwst_rate | NUMERIC(5,2) | MwSt percentage rate |
| tax_amount | NUMERIC(12,2) | Calculated tax amount |
| effective_at | TIMESTAMP | Condition effective timestamp |
| Column | Type | Description |
|---|---|---|
| tpo_idPK | INT | TPO control record identifier |
| vendor_id | INT | Vendor identifier |
| sku | VARCHAR(30) | Material or product identifier |
| vendor_request_qty | INT | Quantity requested by the vendor |
| auto_restock_qty | INT | Quantity generated by automatic restock |
| control_mode | VARCHAR(25) | TPO control mode |
| control_ts | TIMESTAMP | Control record timestamp |