Advance
Represents accounts payable advance transactions, including vendor, payment, currency, and reconciliation details.
Columns
| Name | Type | ReadOnly | Description |
| advanceDate | Date | False |
The date of the advance transaction. |
| advanceNumber | String | True |
The system-assigned number that identifies the advance transaction. |
| advanceSummary_Href | String | True |
The URL of the advance summary associated with this advance. |
| advanceSummary_Id | String | True |
The Id of the advance summary associated with this advance. |
| advanceSummary_Key | String | True |
The system-assigned key of the advance summary associated with this advance. |
| attachment_Href | String | True |
The URL of the attachment associated with this advance. |
| attachment_Id | String | False |
The Id of the attachment associated with this advance. |
| attachment_Key | String | False |
The system-assigned key of the attachment associated with this advance. |
| auditCreatedBy | String | True |
The user who created the advance. |
| auditCreatedDateTime | Datetime | True |
The date and time when the advance was created. |
| auditModifiedBy | String | True |
The user who last modified the advance. |
| auditModifiedDateTime | Datetime | True |
The date and time when the advance was last modified. |
| currencyBaseCurrency | String | False |
The base currency used for this advance. |
| currencyTxnCurrency | String | False |
The transaction currency for this advance. |
| description | String | False |
The description or notes entered for the advance. |
| dueDate | Date | False |
The date by which the advance is due. |
| entity_Href | String | True |
The URL of the entity associated with this advance. |
| entity_Id | String | True |
The Id of the entity associated with this advance. |
| entity_Key | String | True |
The system-assigned key of the entity associated with this advance. |
| entity_Name | String | True |
The name of the entity associated with this advance. |
| financialEntity_Id | String | False |
The Id of the financial entity from which the advance is issued. |
| href | String | True |
The URL of the advance resource. |
| id | String | True |
The unique identifier of the advance. |
| isSystemGenerated | String | False |
Indicates whether the advance was generated automatically by the system. |
| key [KEY] | String | True |
The system-assigned key that uniquely identifies the advance record. |
| paymentInformationPaidDate | Date | True |
The date the advance was fully paid. |
| paymentInformationTotalPaid | Decimal | True |
The total amount paid on this advance. |
| paymentInformationTotalSelected | Decimal | True |
The total amount selected for payment on this advance. |
| paymentInformationTxnTotalPaid | Decimal | True |
The total transaction currency amount paid for this advance. |
| paymentInformationTxnTotalSelected | Decimal | True |
The total transaction currency amount selected for payment on this advance. |
| paymentMethod | String | False |
The payment method used for this advance, such as check or electronic funds transfer. |
| reconciliationGroupCleared | String | False |
The cleared status of the reconciliation group associated with this advance. |
| reconciliationGroupClearingDate | Date | False |
The date on which the reconciliation group for this advance was cleared. |
| recordType | String | True |
The type of record represented by this advance. |
| referenceNumber | String | False |
The external reference number associated with this advance. |
| state | String | False |
The current processing state of the advance, such as draft or posted. |
| totalDue | Decimal | True |
The total amount due on this advance in the base currency. |
| totalEntered | Decimal | True |
The total amount entered on this advance in the base currency. |
| txnTotalDue | Decimal | True |
The total amount due on this advance in the transaction currency. |
| txnTotalEntered | Decimal | True |
The total amount entered on this advance in the transaction currency. |
| vendor_Href | String | True |
The URL of the vendor associated with this advance. |
| vendor_Id | String | False |
The Id of the vendor associated with this advance. |
| vendor_Key | String | False |
The system-assigned key of the vendor associated with this advance. |
| vendor_Name | String | False |
The name of the vendor associated with this advance. |
| vendor_TotalDue | Decimal | True |
The total amount due to the vendor associated with this advance. |
| ListAggregate_Lines | String | False |
The list of line items associated with this advance. |