InvoiceLineItemSplitAccountings
List split accounting details for invoice line items.
View-Specific Information
Select
The connector uses the SAP Ariba API to process WHERE clause conditions that are built with the following column and operators:
- ApprovableId supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [InvoiceLineItemSplitAccountings]
SELECT * FROM [InvoiceLineItemSplitAccountings] WHERE [ApprovableId] = 'Val1'
The connector processes other filters client-side within the connector.
Columns
| Name | Type | References | Description |
| ApprovableId [KEY] | String |
Invoices.ApprovableId | Unique identifier of the approvable. |
| LineItemNumberInCollection [KEY] | Int | The position index of the parent line item. | |
| NumberInCollection [KEY] | Int | The position index of this accounting entry. | |
| PONumber | String | The Purchase Order number associated directly with this accounting split. | |
| ERPSplitValue | String | The corresponding split identifier recognized in the backend ERP system. | |
| Percentage | Decimal | The percentage of the line item allocated to this specific split. | |
| POLineNumber | String | The Purchase Order line number associated directly with this split. | |
| Quantity | Decimal | The physical quantity of the item allocated to this specific split. | |
| SplitTypeUniqueName | String | The method used to calculate the split. | |
| AmountInReportingCurrency | Decimal | The allocated monetary amount in the reporting currency. | |
| AmountApproxAmountInBaseCurrency | Decimal | The approximate allocated monetary amount in the base currency. | |
| Amount | Decimal | The allocated monetary amount in the transactional currency. | |
| AmountConversionDate | Datetime | The date used for currency conversion on the split amount. | |
| AmountCurrencyUniqueName | String | The ISO currency code for the allocated amount. | |
| CostCenterUniqueName | String | The system identifier or code for the Cost Center being charged. | |
| CostCenterDescription | String | The human-readable name of the Cost Center. | |
| CostCenterCompanyCodeUniqueName | String | The company code associated specifically with this Cost Center. | |
| GeneralLedgerDescription | String | The human-readable name of the General Ledger account. | |
| GeneralLedgerUniqueName | String | The system identifier for the General Ledger account. | |
| GeneralLedgerFieldStatusGroup | String | The field status group code for the General Ledger. | |
| GeneralLedgerExternalId | String | The external ERP identifier for this General Ledger account. | |
| GeneralLedgerCompanyCodeUniqueName | String | The company code associated specifically with this General Ledger account. | |
| InternalOrderUniqueName | String | The system identifier for the Internal Order code associated with this split. | |
| InternalOrderDescription | String | The description of the Internal Order associated with this split. | |
| CompanyCodeUniqueName | String | The system identifier for the Company Code assigned to this split. | |
| AssetName | String | The name of the asset. | |
| AssetUniqueName | String | The system identifier for the asset. | |
| AssetSubNumber | String | The sub-number of the asset. | |
| AssetCompanyCodeUniqueName | String | The company code associated with the asset. | |
| WBSElementUniqueName | String | The system identifier for the WBS element. | |
| WBSElementDescription | String | The description of the WBS element. |