InvoicesinvoiceInstallments
InvoicesinvoiceInstallments
Columns
| Name | Type | Description |
| InvoicesInvoiceId [KEY] | Long | InvoicesInvoiceId of InvoicesinvoiceInstallments |
| InstallmentNumber [KEY] | Long | The number used to identify an invoice installment. The value must be provided while creating the installment. It cannot be updated once the invoice installment is created. |
| UnpaidAmount | Double | UnpaidAmount of InvoicesinvoiceInstallments |
| FirstDiscountAmount | Double | The discount amount available at first discount date. The value can either be provided while creating an invoice or derived based on the payment terms. The value for the attribute must exist if a value exists for the First Discount Date attribute. You can also update the value for the first discount amount. |
| FirstDiscountDate | Date | The date when the first discount is available. The value can either be provided while creating an invoice or derived based on the payment terms. The value for the attribute must exist if a value exists for the First Discount Amount attribute. You can also update the value for the first discount date. |
| DueDate | Date | The date when the invoice installment is due for payment. The value can either be provided while creating an invoice or derived based on the payment terms. You can also update the value for the due date. |
| GrossAmount | Double | The gross amount due for the invoice installment. The value can either be provided while creating an invoice or derived based on the payment terms. You can also update the value for the gross amount. |
| HoldReason | String | An explanation or justification provided for placing or releasing the hold on the installment. You can also update the value for the hold reason. |
| PaymentPriority | Int | The number (1 to 99) representing the payment priority of an invoice installment. The value can either be provided while creating an invoice or populated by default from the Supplier Site or from the Manage Invoice Options for the invoicing business unit. You can also update the value for the payment priority. |
| SecondDiscountAmount | Double | The discount amount available at second discount date. The value can either be provided while creating an invoice or derived based on the payment terms. The value for the attribute must exist if a value exists for the Second Discount Date attribute. You can also update the value for the second discount amount. |
| SecondDiscountDate | Date | The date when the second discount is available. The value can either be provided while creating an invoice or derived based on the payment terms. The value for the attribute must exist if a value exists for the Second Discount Amount attribute. You can also update the value for the second discount date. |
| ThirdDiscountAmount | Double | The discount amount available at third discount date. The value can either be provided while creating an invoice or derived based on the payment terms. The value for the attribute must exist if a value exists for the Third Discount Date attribute. You can also update the value for the third discount amount. |
| ThirdDiscountDate | Date | The date when the third discount is available. The value can either be provided while creating an invoice or derived based on the payment terms. The value for the attribute must exist if a value exists for the Third Discount Amount attribute. You can also update the value for the third discount date. |
| NetAmountOne | Double | NetAmountOne of InvoicesinvoiceInstallments |
| NetAmountTwo | Double | NetAmountTwo of InvoicesinvoiceInstallments |
| NetAmountThree | Double | NetAmountThree of InvoicesinvoiceInstallments |
| HoldFlag | Bool | Indicates whether a scheduled payment is on hold. The value can either be provided while creating an invoice installment or proactive system holds are applied if there are validation failures. The default value is false. You can also update the value for the hold flag. |
| HeldBy | String | HeldBy of InvoicesinvoiceInstallments |
| HoldType | String | HoldType of InvoicesinvoiceInstallments |
| PaymentMethod | String | Indicates how the first party payer is going to make the payment for the invoice. Examples include check, cash, and credit. The value can either be provided while creating an invoice installment or populated by default based on the Payment Method Default Basis setup in the Manage Disbursement System Options. You can also update the value for the payment method. |
| PaymentMethodCode | String | The user-entered payment method code that helps to uniquely identify a payment method. |
| HoldDate | Datetime | HoldDate of InvoicesinvoiceInstallments |
| BankAccount | String | The supplier bank account number to which the payment will be remitted. The value can either be provided while creating an invoice installment or populated by default from the Supplier Site or Address or Profile level payment attributes. You can also update the value for the bank account. |
| ExternalBankAccountId | Long | The unique identifier for the supplier bank account. The value can either be provided while creating an invoice installment or populated by default from the Supplier Site or Address or Profile level payment attributes. If both Bank Account and External Bank Account ID is provided in the payload then the value for the External Bank Account ID is given preference and the value provided for Bank Account is ignored. You can also update the value for the bank account. |
| CreatedBy | String | CreatedBy of InvoicesinvoiceInstallments |
| CreationDate | Datetime | CreationDate of InvoicesinvoiceInstallments |
| LastUpdateDate | Datetime | LastUpdateDate of InvoicesinvoiceInstallments |
| LastUpdatedBy | String | LastUpdatedBy of InvoicesinvoiceInstallments |
| LastUpdateLogin | String | LastUpdateLogin of InvoicesinvoiceInstallments |
| RemitToAddressName | String | The third-party payment related remit-to address where the payment should be sent. The value can either be provided while creating an invoice installment or populated by default from the Invoicing tab of the Supplier Site. You can also update the value for the remit-to address. |
| RemitToSupplier | String | The third-party payment related remit-to supplier where the payment should be sent. The value can either be provided while creating an invoice installment or populated by default from the Invoicing tab of the Supplier Site. You can also update the value for the remit-to supplier. |
| RemittanceMessageOne | String | Remittance message provided for payment processing. You can provide the information during invoice creation or it will be populated by default from the invoice header. You may update the information at a later stage. |
| RemittanceMessageTwo | String | Remittance message provided for payment processing. You can provide the information during invoice creation or it will be populated by default from the invoice header. You may update the information at a later stage. |
| RemittanceMessageThree | String | Remittance message provided for payment processing. You can provide the information during invoice creation or it will be populated by default from the invoice header. You may update the information at a later stage. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| InvoiceId | Long | InvoiceId |
| Finder | String | finder |