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 |