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 |