ReceivablesInvoicesreceivablesInvoiceInstallments
ReceivablesInvoicesreceivablesInvoiceInstallments
Columns
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId [KEY] | Long | ReceivablesInvoicesCustomerTransactionId of ReceivablesInvoicesreceivablesInvoiceInstallments |
| InstallmentId [KEY] | Long | The unique identifier for installment. |
| InstallmentSequenceNumber | Long | The sequence number of an installment. |
| InstallmentDueDate | Date | The due date of the installment. |
| OriginalAmount | Double | The original due amount of the installment. |
| PaymentDaysLate | Int | Number of days since the due date of the installment. |
| InstallmentBalanceDue | Double | The amount due on the installment. |
| InstallmentStatus | String | The status of the installment. |
| DisputeAmount | Double | The amount in dispute on the installment. |
| DisputeDate | Date | The date a dispute was recorded against the installment. |
| InstallmentClosedDate | Date | The actual date when the payment schedule was closed. |
| InstallmentGLClosedDate | Date | The accounting date when the payment schedule was closed. |
| AccountedBalanceDue | Double | The amount due on the installment in ledger currency. |
| InstallmentAmountAdjusted | Double | The amount that was adjusted on the installment. |
| InstallmentAmountCredited | Double | The amount that was credited on the installment. |
| AmountPaid | Double | The amount that was paid on the installment. |
| PendingAdjustmentAmount | Double | The adjustment amount that is pending approval. |
| InstallmentLineAmountOriginal | Double | The original transaction line amount of the installment. |
| InstallmentLineAmountDue | Double | The transaction line amount due on the installment. |
| InstallmentFreightAmountOriginal | Double | The original freight amount of the installment. |
| InstallmentFreightAmountDue | Double | The freight amount due on the installment. |
| InstallmentTaxAmountOriginal | Double | The original tax amount of the installment. |
| InstallmentTaxAmountDue | Double | The tax amount due on the installment. |
| CreationDate | Datetime | The date and time the record was created. |
| CreatedBy | String | The user who created the record. |
| LastUpdateDate | Datetime | The date on which the record is last updated. |
| LastUpdatedBy | String | The user who last updated the record. |
| ExcludeFromCollections | String | Flag that determines if the installment is dummy or not. |
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 |