PaymentsExternalPayees
PaymentsExternalPayees
Columns
| Name | Type | Description |
| PayeeId [KEY] | Long | Application-generated identifier of the external payee. |
| PaymentFunctionCode | String | Code that indicates the function or purpose of the payment. Values from the IBY_PAYMENT_FUNCTIONS lookup include SUPPLIER_PAYMENT, CUSTOMER_REFUNDS, and Others. |
| OrganizationIdentifier | String | Identifier of the business unit associated with an external payee. |
| OrganizationName | String | Name of the business unit associated with an external payee. |
| OrganizationType | String | OrganizationType of PaymentsExternalPayees |
| PayEachDocumentAloneOption | String | Indicates whether documents payable for an external payee are prevented from being grouped with other like documents payable for payment. |
| DefaultPaymentMethodCode | String | DefaultPaymentMethodCode of PaymentsExternalPayees |
| DefaultPaymentMethodName | String | DefaultPaymentMethodName of PaymentsExternalPayees |
| BankChargeBearerCode | String | Code of an external payee who is responsible for paying regular or express bank charges, such as Payee or Payer. Values are from the IBY_BANK_CHARGE_BEARER lookup. |
| BankChargeBearerName | String | Name of an external payee who is responsible for paying regular or express bank charges, such as Payee or Payer. |
| BankInstructionCodeOne | String | Code of the first bank instruction to an external payee. |
| BankInstructionNameOne | String | Name of the first bank instruction to the external payee. |
| BankInstructionCodeTwo | String | Code of the second bank instruction to the external payee. |
| BankInstructionNameTwo | String | Name of the second bank instruction to an external payee. |
| BankInstructionDetails | String | Details of an additional bank instruction to an external payee. |
| PaymentReasonCode | String | Code of the reason for paying an external payee. |
| PaymentReasonName | String | Name of the reason for paying an external payee. |
| PaymentReasonComments | String | Text field available for entering information about an external payee payment. |
| PaymentTextMessageOne | String | First text payment message to an external payee. |
| PaymentTextMessageTwo | String | Second text payment message to an external payee. |
| PaymentTextMessageThree | String | Third text payment message to an external payee. |
| DeliveryChannelCode | String | Code of the delivery channel for an external payee. |
| DeliveryChannelName | String | Name of the delivery channel for an external payee. |
| ServiceLevelCode | String | Code of the service level for an external payee. |
| ServiceLevelName | String | Name of the service level for an external payee. |
| SettlementPriority | String | Priority with which the financial institution or payment system settles payments for an external payee. |
| DeliveryMethod | String | Delivery method that is set on the external payee level. If the Override with Payee Delivery Method Preference option on the payment process profile is turned off, the setting is ignored. Values from the IBY_DELIVERY_METHODS lookup include EMAIL, FAX, and PRINTED. |
| String | Email address at which an external payee receives remittance advice. | |
| Fax | String | Fax number at which an external payee receives remittance advice. |
| PayeePartyIdentifier | Long | Identifier of an external payee. |
| PartyName | String | Name of an external payee. |
| PayeePartyNumber | String | Application-generated party number in Trading Community Architecture. |
| PayeePartySiteIdentifier | Long | Identifier of an external payee site. |
| SupplierNumber | String | Application-generated party number in Procurement. |
| SupplierSiteCode | String | Code of a supplier site. |
| SupplierSiteIdentifier | Long | Identifier of a supplier site. |
| PayeePartySiteNumber | String | Number of an external payee site. |
| PaymentFormatCode | String | Code of the payment format that is associated with an external payee. |
| PaymentFormatName | String | Name of the payment format that is associated with an external payee. |
| PersonId | Long | Person identifier when the external payee is an employee. |
| Intent | String | Purpose of the external payee. The value is based on the payment function of the external payee. The following are the expected values: PAYABLES_DISB - Supplier, EMPLOYEE_EXP - Person, EMPLOYEE_EXP - Employee, AR_CUSTOMER_REFUNDS - Refund, CUSTOMER_PAYMENT - Customer, ONETIME_PAYMENT - Onetime, and ADHOC_PAYMENT - Adhoc. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |