ContractLineItemSplitAccountings
Retrieves split accounting details for contract 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:
- ContractUniqueName supports the '=,IN' comparison operators.
For example, the following queries are processed server-side:
SELECT * FROM [ContractLineItemSplitAccountings]
SELECT * FROM [ContractLineItemSplitAccountings] WHERE [ContractUniqueName] = 'C10'
The connector processes other filters client-side within the connector.
Columns
| Name | Type | References | Description |
| ContractUniqueName [KEY] | String |
Contracts.UniqueName | The unique identifier of the contract. |
| LineItemNumberInCollection [KEY] | Int |
ContractLineItems.NumberInCollection | Line item number in collection. |
| NumberInCollection [KEY] | Int | Number in collection for this split accounting entry. | |
| AccountName | String | Name of the account. | |
| AccountUniqueName | String | Unique identifier of the account. | |
| AccountingCombinationID | String | Accounting combination identifier. | |
| Percentage | Decimal | Percentage split for this accounting entry. | |
| Quantity | Decimal | Quantity for this split accounting entry. | |
| Amount | Decimal | Amount for this split accounting entry. | |
| AmountCurrencyName | String | Currency name for the amount. | |
| AmountCurrencyUniqueName | String | Currency unique identifier for the amount. | |
| ActivityNumberName | String | Name of the activity number. | |
| ActivityNumberNetwork | String | Network associated with the activity number. | |
| ActivityNumberUniqueName | String | Unique identifier of the activity number. | |
| AssetCompanyCode | String | Company code of the asset. | |
| AssetName | String | Name of the asset. | |
| AssetUniqueName | String | Unique identifier of the asset. | |
| AssetClassName | String | Name of the asset class. | |
| AssetClassUniqueName | String | Unique identifier of the asset class. | |
| AssetDescription | String | Description of the asset. | |
| AssetLocationCity | String | City of the asset location. | |
| AssetLocationCountryName | String | Country name of the asset location. | |
| AssetLocationCountryUniqueName | String | Country unique identifier of the asset location. | |
| AssetLocationFax | String | Fax number of the asset location. | |
| AssetLocationLine1 | String | Address line 1 of the asset location. | |
| AssetLocationLine2 | String | Address line 2 of the asset location. | |
| AssetLocationLine3 | String | Address line 3 of the asset location. | |
| AssetLocationName | String | Name of the asset location. | |
| AssetLocationPhone | String | Phone number of the asset location. | |
| AssetLocationPostalCode | String | Postal code of the asset location. | |
| AssetLocationState | String | State of the asset location. | |
| AssetLocationUniqueName | String | Unique identifier of the asset location. | |
| BusinessUnitName | String | Name of the business unit. | |
| BusinessUnitUniqueName | String | Unique identifier of the business unit. | |
| BusinessUnitAM | String | The PeopleSoft asset management business unit. | |
| CompanyName | String | Name of the company. | |
| CompanyUniqueName | String | Unique identifier of the company. | |
| CompanyCodeUniqueName | String | Unique identifier of the company code. | |
| CostCenterCompanyCode | String | Company code of the cost center. | |
| CostCenterName | String | Name of the cost center. | |
| CostCenterUniqueName | String | Unique identifier of the cost center. | |
| DepartmentName | String | Name of the department. | |
| DepartmentUniqueName | String | Unique identifier of the department. | |
| GLBusinessUnitName | String | Name of the GL business unit. | |
| GLBusinessUnitUniqueName | String | Unique identifier of the GL business unit. | |
| GeneralLedgerCompanyCode | String | Company code of the general ledger. | |
| GeneralLedgerName | String | Name of the general ledger. | |
| GeneralLedgerUniqueName | String | Unique identifier of the general ledger. | |
| InternalOrderName | String | Name of the internal order. | |
| InternalOrderUniqueName | String | Unique identifier of the internal order. | |
| LocationCity | String | City of the location. | |
| LocationCountryName | String | Country name of the location. | |
| LocationCountryUniqueName | String | Country unique identifier of the location. | |
| LocationFax | String | Fax number of the location. | |
| LocationLine1 | String | Address line 1 of the location. | |
| LocationLine2 | String | Address line 2 of the location. | |
| LocationLine3 | String | Address line 3 of the location. | |
| LocationName | String | Name of the location. | |
| LocationPhone | String | Phone number of the location. | |
| LocationPostalCode | String | Postal code of the location. | |
| LocationState | String | State of the location. | |
| LocationUniqueName | String | Unique identifier of the location. | |
| NetworkCompanyCode | String | Company code of the network. | |
| NetworkName | String | Name of the network. | |
| NetworkUniqueName | String | Unique identifier of the network. | |
| PSProfileId | String | PS Profile identifier. | |
| SAPLimitSplitValue | String | SAP limit split value. | |
| SAPSerialNumber | String | SAP serial number. | |
| ProcurementUnitName | String | Name of the procurement unit. | |
| ProcurementUnitUniqueName | String | Unique identifier of the procurement unit. | |
| ProductName | String | Name of the product. | |
| ProductUniqueName | String | Unique identifier of the product. | |
| ProjectName | String | Name of the project. | |
| ProjectUniqueName | String | Unique identifier of the project. | |
| RegionName | String | Name of the region. | |
| RegionUniqueName | String | Unique identifier of the region. | |
| StatisticsCodeName | String | Name of the statistics code. | |
| StatisticsCodeUniqueName | String | Unique identifier of the statistics code. | |
| SubAccountName | String | Name of the sub account. | |
| SubAccountUniqueName | String | Unique identifier of the sub account. | |
| TypeName | String | Name of the split accounting type. | |
| TypeUniqueName | String | Unique identifier of the split accounting type. | |
| WBSElementName | String | Name of the WBS element. | |
| WBSElementUniqueName | String | Unique identifier of the WBS element. |