AppliedToTxnRet (old ->AppliedToTxnDetail)

FIELD NAMEFIELD NAME (old)QUERYABLEUPDATEABLEREQUIRED
ON UPDATE
INSERTABLEREQUIRED
ON INSERT
TxnIDtruefalsetruetruetrue
TxnTypetruetrueoptionaloptionaloptional 
TxnDatetruetrueoptionaloptionaloptional 
RefNumbertruetrueoptionaloptionaloptional 
BalanceRemainingtruetrueoptionaloptionaloptional 
CreditRemainingnewtruetrueoptionaloptionaloptional 
CreditRemainingInHomeCurrencynewtruetrueoptionaloptionaloptional 
RefundAmountInHomeCurrencynewtruetrueoptionaloptionaloptional 
Amounttruetrueoptionaloptionaloptional 
DiscountAmounttruetrueoptionaloptionaloptional 
DiscountAccountRef_ListIDtruetrueoptionaloptionaloptional 
DiscountAccountRef_FullNametruetrueoptionaloptionaloptional 
DiscountClassRef_ListIDtruetrueoptionaloptionaloptional 
DiscountClassRef_FullNametruetrueoptionaloptionaloptional 
PARENT_IDKEYIDKEYtrueoptionaloptionaloptional 
SeqNumkeeps the seqtrueoptionaloptionaloptional

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 –>

Parent.TxnID -> Child.PARENT_IDKEY 

Powered by BetterDocs