AppliedToTxnRet

1 min read

AppliedToTxnRet (old ->AppliedToTxnDetail)

FIELD NAME	FIELD NAME (old)	QUERYABLE	UPDATEABLE	REQUIRED ON UPDATE	INSERTABLE	REQUIRED ON INSERT
TxnID		true	false	true	true	true
TxnType		true	true	optional	optional	optional
TxnDate		true	true	optional	optional	optional
RefNumber		true	true	optional	optional	optional
BalanceRemaining		true	true	optional	optional	optional
CreditRemaining	new	true	true	optional	optional	optional
CreditRemainingInHomeCurrency	new	true	true	optional	optional	optional
RefundAmountInHomeCurrency	new	true	true	optional	optional	optional
Amount		true	true	optional	optional	optional
DiscountAmount		true	true	optional	optional	optional
DiscountAccountRef_ListID		true	true	optional	optional	optional
DiscountAccountRef_FullName		true	true	optional	optional	optional
DiscountClassRef_ListID		true	true	optional	optional	optional
DiscountClassRef_FullName		true	true	optional	optional	optional
PARENT_IDKEY	IDKEY		true	optional	optional	optional
SeqNum	keeps the seq		true	optional	optional	optional

Parent tables:

ARRefundCreditCard
- Query
  - TxnID
  - TxnType
  - TxnDate
  - RefNumber
  - CreditRemaining
  - RefundAmount (Amount)
  - CreditRemainingInHomeCurrency
  - RefundAmountInHomeCurrency
- Add
  - TxnID <!– required –>
  - RefundAmount <!– required –>
BillPaymentCheck
- Query
  - TxnID
  - TxnType
  - TxnDate
  - RefNumber
  - BalanceRemaining
  - Amount
  - DiscountAmount
  - DiscountAccountRef_ListID
  - DiscountAccountRef_FullName
  - DiscountClassRef_ListID
  - DiscountClassRef_FullName
  - LinkedTxnRet (table)
- Add
  - TxnID <!– required –>
  - PaymentAmount (Amount) <!– optional –>
  - DiscountAmount <!– optional –>
  - DiscountAccountRef_ListID <!– optional –>
  - DiscountAccountRef_FullName <!– optional –>
  - DiscountClassRef_ListID <!– optional –>
  - DiscountClassRef_FullName <!– optional –>
- Update
  - TxnID <!– required –>
  - PaymentAmount (Amount) <!– optional –>
  - DiscountAmount <!– optional –>
  - DiscountAccountRef_ListID <!– optional –>
  - DiscountAccountRef_FullName <!– optional –>
  - DiscountClassRef_ListID <!– optional –>
  - DiscountClassRef_FullName <!– optional –>
BillPaymentCreditCard
- Query
  - TxnID
  - TxnType
  - RefNumber
  - BalanceRemaining
  - Amount
  - DiscountAmount
  - DiscountAccountRef_ListID
  - DiscountAccountRef_FullName
  - DiscountClassRef_ListID
  - DiscountClassRef_FullName
  - LinkedTxnRet (table)
- Add
  - TxnID <!– required –>
  - PaymentAmount (Amount) <!– optional –>
  - DiscountAmount <!– optional –>
  - DiscountAccountRef_ListID <!– optional –>
  - DiscountAccountRef_FullName <!– optional –>
  - DiscountClassRef_ListID <!– optional –>
  - DiscountClassRef_FullName <!– optional –>
Check
- Add
  - TxnID <!– required –>
  - Amount<!– optional –>
- Update
  - TxnID <!– required –>
  - Amount<!– optional –>
ReceivePayment
- Query
  - TxnID
  - TxnType
  - TxnDate
  - RefNumber
  - BalanceRemaining
  - Amount
  - DiscountAmount
  - DiscountAccountRef_ListID
  - DiscountAccountRef_FullName
  - DiscountClassRef_ListID
  - DiscountClassRef_FullName
  - LinkedTxnRet (table)
- Add
  - TxnID <!– required –>
  - PaymentAmount (Amount) <!– optional –>
  - DiscountAmount <!– optional –>
  - DiscountAccountRef_ListID <!– optional –>
  - DiscountAccountRef_FullName <!– optional –>
  - DiscountClassRef_ListID <!– optional –>
  - DiscountClassRef_FullName <!– optional –>
- Update
  - TxnID <!– required –>
  - PaymentAmount (Amount) <!– optional –>
  - DiscountAmount <!– optional –>
  - DiscountAccountRef_ListID <!– optional –>
  - DiscountAccountRef_FullName <!– optional –>
  - DiscountClassRef_ListID <!– optional –>
  - DiscountClassRef_FullName <!– optional –>