InvoicesinvoiceLines
InvoicesinvoiceLines
Columns
| Name | Type | Description |
| InvoicesInvoiceId | String | InvoicesInvoiceId |
| LineNumber | Long | LineNumber |
| LineAmount | String | LineAmount |
| AccountingDate | Date | AccountingDate |
| UOM | String | UOM |
| TaxRateName | String | TaxRateName |
| LineType | String | LineType |
| AssetBook | String | AssetBook |
| TrackAsAssetFlag | Bool | TrackAsAssetFlag |
| BaseAmount | String | BaseAmount |
| Description | String | Description |
| IncomeTaxRegion | String | IncomeTaxRegion |
| Item | String | Item |
| ItemDescription | String | ItemDescription |
| LineSource | String | LineSource |
| Quantity | String | Quantity |
| DistributionCombination | String | DistributionCombination |
| AssetCategory | String | AssetCategory |
| UnitPrice | String | UnitPrice |
| ProrateAcrossAllItemsFlag | Bool | ProrateAcrossAllItemsFlag |
| LandedCostEnabled | String | LandedCostEnabled |
| DiscardedFlag | Bool | DiscardedFlag |
| CanceledFlag | Bool | CanceledFlag |
| IncomeTaxType | String | IncomeTaxType |
| TaxRateCode | String | TaxRateCode |
| TaxRate | String | TaxRate |
| TaxClassification | String | TaxClassification |
| GenerateDistributions | String | GenerateDistributions |
| BudgetDate | Date | BudgetDate |
| FundsStatus | String | FundsStatus |
| ApprovalStatus | String | ApprovalStatus |
| DistributionSet | String | DistributionSet |
| Withholding | String | Withholding |
| ShipToLocationCode | String | ShipToLocationCode |
| ShipToLocation | String | ShipToLocation |
| ShipToCustomerLocation | String | ShipToCustomerLocation |
| TaxControlAmount | String | TaxControlAmount |
| AssessableValue | String | AssessableValue |
| ProductType | String | ProductType |
| ProductCategory | String | ProductCategory |
| ProductCategoryCodePath | String | ProductCategoryCodePath |
| UserDefinedFiscalClassification | String | UserDefinedFiscalClassification |
| UserDefinedFiscalClassificationCode | String | UserDefinedFiscalClassificationCode |
| IntendedUse | String | IntendedUse |
| IntendedUseCode | String | IntendedUseCode |
| ProductFiscalClassification | String | ProductFiscalClassification |
| ProductFiscalClassificationCode | String | ProductFiscalClassificationCode |
| ProductFiscalClassificationType | String | ProductFiscalClassificationType |
| TransactionBusinessCategory | String | TransactionBusinessCategory |
| TransactionBusinessCategoryCodePath | String | TransactionBusinessCategoryCodePath |
| Requester | String | Requester |
| PurchasingCategory | String | PurchasingCategory |
| MatchType | String | MatchType |
| MatchOption | String | MatchOption |
| MatchBasis | String | MatchBasis |
| PurchaseOrderNumber | String | PurchaseOrderNumber |
| PurchaseOrderLineNumber | String | PurchaseOrderLineNumber |
| PurchaseOrderScheduleLineNumber | String | PurchaseOrderScheduleLineNumber |
| ReceiptNumber | String | ReceiptNumber |
| ReceiptLineNumber | String | ReceiptLineNumber |
| ConsumptionAdviceNumber | String | ConsumptionAdviceNumber |
| ConsumptionAdviceLineNumber | String | ConsumptionAdviceLineNumber |
| FinalMatchFlag | Bool | FinalMatchFlag |
| MultiperiodAccountingStartDate | Date | MultiperiodAccountingStartDate |
| MultiperiodAccountingEndDate | Date | MultiperiodAccountingEndDate |
| MultiperiodAccountingAccrualAccount | String | MultiperiodAccountingAccrualAccount |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdatedBy | String | LastUpdatedBy |
| LastUpdateLogin | String | LastUpdateLogin |
| RequesterId | String | RequesterId |
| PrepaymentNumber | String | PrepaymentNumber |
| PrepaymentLineNumber | Long | PrepaymentLineNumber |
| PrepaymentIncludedonInvoiceFlag | Bool | PrepaymentIncludedonInvoiceFlag |
| ReferenceKeyTwo | String | ReferenceKeyTwo |
| ProductTable | String | ProductTable |