ReceivablesInvoicesreceivablesInvoiceDistributions
ReceivablesInvoicesreceivablesInvoiceDistributions
Columns
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId [KEY] | Long | ReceivablesInvoicesCustomerTransactionId of ReceivablesInvoicesreceivablesInvoiceDistributions |
| DistributionId [KEY] | Long | The unique identifier of the invoice distribution. |
| InvoiceLineNumber | Long | The number of the invoice line associated with the distribution. |
| DetailedTaxLineNumber | Long | The number of the tax line of an invoice line associated with the distribution. |
| AccountClass | String | The account class of the distribution. Valid values are Revenue, Receivable, Freight, and Tax. |
| AccountCombination | String | The account code combination for the distribution. |
| Amount | Double | The amount of the distribution in the invoice currency. |
| AccountedAmount | Double | The amount of the distribution in the ledger currency. |
| Percent | Double | The percentage of the line amount mapped to this distribution. |
| Comments | String | The user-defined comments about the distribution. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date and time the record was created. |
| LastUpdateDate | Datetime | The date and time the record was last updated. |
| LastUpdatedBy | String | The user who last updated the record. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AccountingDate | Date | AccountingDate |
| AllowCompletion | String | AllowCompletion |
| BillToCustomerName | String | BillToCustomerName |
| BillToCustomerNumber | String | BillToCustomerNumber |
| BillToSite | String | BillToSite |
| BillingDate | Date | BillingDate |
| BusinessUnit | String | BusinessUnit |
| CrossReference | String | CrossReference |
| CustomerTransactionId | Long | CustomerTransactionId |
| DocumentNumber | Long | DocumentNumber |
| DueDate | Date | DueDate |
| FirstPartyTaxRegistration | String | FirstPartyTaxRegistration |
| InvoiceCurrencyCode | String | InvoiceCurrencyCode |
| InvoiceStatus | String | InvoiceStatus |
| LegalEntityIdentifier | String | LegalEntityIdentifier |
| PaymentTerms | String | PaymentTerms |
| PurchaseOrder | String | PurchaseOrder |
| ShipToCustomerName | String | ShipToCustomerName |
| ShipToSite | String | ShipToSite |
| ThirdPartyTaxRegistration | String | ThirdPartyTaxRegistration |
| TransactionDate | Date | TransactionDate |
| TransactionNumber | String | TransactionNumber |
| TransactionSource | String | TransactionSource |
| TransactionType | String | TransactionType |
| Finder | String | finder |