InstrumentAssignments
Assigns payment instruments (for example, checks, electronic transfers) to specific payees or transactions, ensuring controlled disbursement.
Columns
| Name | Type | Description |
| PaymentInstrumentAssignmentId [KEY] | Long | Unique identifier for the payment instrument assignment, used to track the assignment of a specific payment instrument to a payer or payee. |
| PaymentPartyId | Long | Unique identifier for the external payer or payee, representing the party involved in the payment instrument assignment. |
| PaymentInstrumentId | Long | Unique identifier for the payment instrument (bank account or credit card) that is part of the payment instrument assignment. |
| PaymentFlow | String | Payment flow associated with the payment instrument assignment, indicating whether the transaction involves funds capture or disbursement. Values are sourced from the IBY_PAYMENT_FLOW lookup. |
| PaymentInstrumentType | String | Type of payment instrument used in the assignment, such as BANKACCOUNT, CREDITCARD, or DEBITCARD. Values are from the IBY_INSTRUMENT_TYPES lookup. |
| PrimaryIndicator | String | Flag indicating whether the payment instrument is the primary payment method for the payer or payee. Primary instruments automatically populate transactions. |
| StartDate | Date | Date when the relationship between the payment instrument and the payer or payee becomes active, marking the beginning of its use. |
| EndDate | Date | Date when the relationship between the payment instrument and the payer or payee becomes inactive, signaling the end of its use. |
| MaskedBankAccountNumber | String | Masked version of the bank account number associated with the payment instrument assignment, providing security by obscuring sensitive data. |
| MaskedCreditCardNumber | String | Masked version of the credit card number associated with the payment instrument assignment, ensuring that sensitive data is not exposed. |
| VendorId | Long | Unique identifier for the vendor associated with the payment instrument assignment, linking it to the specific vendor in the system. |
| PersonId | Long | Unique identifier for the person associated with the payment instrument assignment, typically used when the payee is an employee. |
| Intent | String | Purpose of the payment instrument assignment, defining the payment function. Expected values include PAYABLES_DISB (Supplier), EMPLOYEE_EXP (Person/Employee), CUSTOMER_PAYMENT (Customer), and others. |
| Finder | String | Search term or identifier used to locate and retrieve specific payment instrument assignment records, aiding in efficient data retrieval. |