InvoicesinvoiceLinesinvoiceDistributions
InvoicesinvoiceLinesinvoiceDistributions
Columns
| Name | Type | Description |
| InvoicesInvoiceId [KEY] | Long | InvoicesInvoiceId of InvoicesinvoiceLinesinvoiceDistributions |
| InvoicelinesLineNumber [KEY] | Int | InvoicelinesLineNumber of InvoicesinvoiceLinesinvoiceDistributions |
| InvoiceDistributionId [KEY] | Long | InvoiceDistributionId of InvoicesinvoiceLinesinvoiceDistributions |
| DistributionLineNumber | Long | The line number associated with the invoice distribution. The value must be provided while creating an invoice distribution and cannot be updated once the invoice distribution is created. |
| DistributionLineType | String | The type of invoice line. The value must be provided while creating an invoice distribution. The valid values are Item, Freight and Miscellaneous. A list of accepted values is defined in the lookup type INVOICE DISTRIBUTION TYPE and can be reviewed using the Setup and Maintenance work area, and the Manage Payables Lookups task. |
| IncomeTaxType | String | The payments of type 1099 made to a supplier. A 1099 supplier may receive payments of more than one type. The value can either be provided while creating an invoice distribution or populated by default from the parent invoice line. |
| AccountingStatus | String | AccountingStatus of InvoicesinvoiceLinesinvoiceDistributions |
| MatchedStatus | String | MatchedStatus of InvoicesinvoiceLinesinvoiceDistributions |
| ValidationStatus | String | The option that indicates whether an invoice has passed validation and all invoice holds have been released. The default value is set to Not Validated. |
| AccountingDate | Date | The date when the invoice distribution is to be accounted. The value can either be provided while creating an invoice distribution or populated by default from the parent invoice line. |
| DistributionAmount | Double | The amount on invoice distribution. The value must be provided while creating an invoice distribution. |
| AssetBook | String | The asset book candidate for transfer to Oracle Fusion Assets. |
| DistributionCombination | String | The accounting flexfield for account associated with a distribution. The value can be provided while creating an invoice distribution or populated by default from the parent invoice line. |
| TrackAsAssetFlag | Bool | Indicates if the item should be transferred to Oracle Fusion Assets. The value can either be provided while creating an invoice distribution or populated by default from parent invoice line or populated by default to true if an asset account is provided in the distribution combination. If the value is true, then it indicates that the item should be transferred to Oracle Fusion Assets. |
| BaseAmount | Double | BaseAmount of InvoicesinvoiceLinesinvoiceDistributions |
| CanceledFlag | Bool | Indicates whether an invoice distribution is canceled. The default value is false. If the value if true, then it indicates the invoice distribution is canceled. |
| Description | String | The description of the invoice description. The value can be provided while creating an invoice distribution or populated by default from the parent invoice line. |
| IncomeTaxRegion | String | The reporting region for invoice line for 1099 supplier. The value can be provided while creating an invoice distribution or populated by default from the parent invoice line. |
| ReversedFlag | Bool | Indicates whether a distribution is part of a reversal pair. The default value is false. If the value if true, then it indicates the distribution is part of a reversal pair. |
| InvoicedQuantity | Double | InvoicedQuantity of InvoicesinvoiceLinesinvoiceDistributions |
| UOM | String | UOM of InvoicesinvoiceLinesinvoiceDistributions |
| UnitPrice | Double | UnitPrice of InvoicesinvoiceLinesinvoiceDistributions |
| PurchaseOrderDistributionLineNumber | Double | PurchaseOrderDistributionLineNumber of InvoicesinvoiceLinesinvoiceDistributions |
| PurchaseOrderNumber | String | PurchaseOrderNumber of InvoicesinvoiceLinesinvoiceDistributions |
| PurchaseOrderLineNumber | Double | PurchaseOrderLineNumber of InvoicesinvoiceLinesinvoiceDistributions |
| PurchaseOrderScheduleLineNumber | Double | PurchaseOrderScheduleLineNumber of InvoicesinvoiceLinesinvoiceDistributions |
| ReceiptNumber | String | ReceiptNumber of InvoicesinvoiceLinesinvoiceDistributions |
| ReceiptLineNumber | Long | ReceiptLineNumber of InvoicesinvoiceLinesinvoiceDistributions |
| ConsumptionAdviceNumber | String | ConsumptionAdviceNumber of InvoicesinvoiceLinesinvoiceDistributions |
| ConsumptionAdviceLineNumber | Double | ConsumptionAdviceLineNumber of InvoicesinvoiceLinesinvoiceDistributions |
| AssociatedItemDistributionLineNumber | String | AssociatedItemDistributionLineNumber of InvoicesinvoiceLinesinvoiceDistributions |
| FinalMatchFlag | Bool | FinalMatchFlag of InvoicesinvoiceLinesinvoiceDistributions |
| MultiperiodAccountingStartDate | Date | The multiperiod accounting start date on the invoice distribution. |
| MultiperiodAccountingEndDate | Date | The multiperiod accounting end date on the invoice distribution. |
| MultiperiodAccountingAccrualAccount | String | The accrual account used in multiperiod accounting to accrue deferred expenses. |
| TaxRegimeName | String | TaxRegimeName of InvoicesinvoiceLinesinvoiceDistributions |
| TaxName | String | TaxName of InvoicesinvoiceLinesinvoiceDistributions |
| TaxRecoverable | String | TaxRecoverable of InvoicesinvoiceLinesinvoiceDistributions |
| TaxRate | String | TaxRate of InvoicesinvoiceLinesinvoiceDistributions |
| TaxRateName | String | TaxRateName of InvoicesinvoiceLinesinvoiceDistributions |
| TaxType | String | TaxType of InvoicesinvoiceLinesinvoiceDistributions |
| IntendedUse | String | A tax driver used to determine and calculate the applicable taxes. The value can either be provided while creating an invoice line or populated by default from source document or from the respective entity setup. When passing the attribute value in the payload, ensure that you are passing a value for the intended use code attribute as well. |
| IntendedUseCode | String | The user-entered intended use code that helps to uniquely identify an intended use. |
| CreatedBy | String | CreatedBy of InvoicesinvoiceLinesinvoiceDistributions |
| CreationDate | Datetime | CreationDate of InvoicesinvoiceLinesinvoiceDistributions |
| LastUpdatedBy | String | LastUpdatedBy of InvoicesinvoiceLinesinvoiceDistributions |
| LastUpdateDate | Datetime | LastUpdateDate of InvoicesinvoiceLinesinvoiceDistributions |
| LastUpdateLogin | String | LastUpdateLogin of InvoicesinvoiceLinesinvoiceDistributions |
| PrepaymentNumber | String | PrepaymentNumber of InvoicesinvoiceLinesinvoiceDistributions |
| PrepaymentLineNumber | String | PrepaymentLineNumber of InvoicesinvoiceLinesinvoiceDistributions |
| PrepaymentDistributionLineNumber | String | PrepaymentDistributionLineNumber of InvoicesinvoiceLinesinvoiceDistributions |
| PrepaymentAvailableAmount | Double | The amount of the prepayment that can still be applied to an invoice. |
| ChargeApplicableToDistId | Long | ChargeApplicableToDistId of InvoicesinvoiceLinesinvoiceDistributions |
| AllocationLineNumber | Int | AllocationLineNumber of InvoicesinvoiceLinesinvoiceDistributions |
| AllocationDistributionLineNumber | Long | AllocationDistributionLineNumber of InvoicesinvoiceLinesinvoiceDistributions |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| InvoiceId | Long | InvoiceId |
| Finder | String | finder |