LineItems
Overview
An incoming purchase goes through different pricing rules before it ends up on an invoice. A LineItem is a result of this process
Fields
| Name | Type | Description |
|---|---|---|
Key | PK, Integer | Primary Key - A unique identifier for each LineItem |
ProductKey | String | A unique identifier for each product in the datasets. |
AddedValue | String | The value added by the pricing rule. |
AddedCost | String | The cost added by the pricing rule. |
AddedQuantity | String | Purchase quantity. |
From | String | Purchase start date. |
To | String | Purchase end date. |
Type | String | Type of price rule applied to generate the LintItem. 0 = Price; 3 = ; 4 = ; 5 = Adjust Percentage; |
LedgerAccountKey | String | Unique Identifier of each ledger account entry in the datasets. |
LedgerAccountCredit | String | |
LedgerAccountDebit | String | |
Meta1 | String | |
Meta2 | String | |
Meta3 | String | |
NumericMeta1 | String | |
NumericMeta2 | String | |
NumericMeta3 | String | |
DateMeta1 | String | |
DateMeta2 | String | |
Bool1 | String | |
Bool2 | String | |
Bool3 | String | |
Bool4 | String | |
InvoiceKey | String | |
CspOrderKey | String | |
CspInstanceKey | String | |
CspProductKey | String | |
CspSubscriptionKey | String | |
CspResourceGroupKey | String | |
AwsProductKey | String | |
AwsReservationKey | String | |
AwsSavingsPlanKey | String | |
AwsInvoiceKey | String | |
AwsDescriptionKey | String | |
AwsUsageaccountKey | String | |
AWSUnblendedCost | String | |
AddedMeasureQuantity | String | |
StringMeta1Key | String | |
.<br/>.<br/>. | String | |
StringMeta10Key | String | |
FlagsKey | String |