PersonalPaymentMethods

Columns


Name	Type	Description
PersonalPaymentMethodId [KEY]	Long	System-generated unique identifier for the personal payment method.
Name	String	Name of the personal payment method.
EffectiveStartDate [KEY]	Date	Date at the beginning of the date range within which the personal payment method is effective.
EffectiveEndDate [KEY]	Date	Date at the end of the date range within which the personal payment method is effective.
OrgPaymentMethodId	Long	Unique identifier of the organization payment method associated with the personal payment method.
BankAccountId	Long	Unique identifier of the bank account associated with the personal payment method.
PaymentAmountType	String	Payment type associated with the personal payment method, such as check.
Amount	Double	Amount to be paid using this payment method, such as $200 per payroll period.
Percentage	Double	Percentage value to be paid using this payment method, such as 5%.
Priority	Long	Order in which the personal payment methods are processed. The personal payment method with priority 1 is processed first.
PayrollRelationshipId	Long	Payroll relationship associated with this personal payment method.
PartyId [KEY]	Long	PartyId of PersonalPaymentMethods
PersonNumber	String	PersonNumber of PersonalPaymentMethods

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。