PAYSUMMARY

Each row of this table stores a payment summary XML that could be sent to an external accounting system. The summary is by Store, Account, and payment policy.

Column Descriptions:

NameTypeDescription
PAYSUMMARY_IDBIGINT NOT NULLGenerated unique key for this row.
ACCOUNT_IDBIGINTThe business account ID of this payment summary. May be null if there is no business account.
SETCCURRCHAR (3)Currency of the Total Charge Amount field. Alphabetic currency codes as per ISO 4217.
CREDITLINE_IDBIGINTCreditLine ID. If the payment policy for this payment summary is the Credit Payment Policy, the ID of the Credit Line is also store here. Foreign key to the CREDITLINE table.
STOREENT_IDINTEGER NOT NULLThe ID of the Store.
POLICY_IDBIGINTThe ID of the Payment Policy that this payment summary is for.
PERIODSTARTTIMETIMESTAMP NOT NULLPeriod start time.
PERIODENDTIMETIMESTAMP NOT NULLPeriod end time.
TOTALCHARGEDECIMAL (20,5) NOT NULLThe Total charge amount represented by this Payment Summary in the default currency of the Store.
PAYSUMMARYXMLCLOB (1000000)The Payment Summary XML for the specified period.
STATUSINTEGERFlag to indicate if the Payment Summary has been sent to an external accounting system: 0 = not sent or 1 = sent.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PAYSUMMARY_IDPrimary Key
I0000686ACCOUNT_IDNon-Unique Index
I0000687POLICY_IDNon-Unique Index
I0000689CREDITLINE_IDNon-Unique Index
I0000690STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_580SETCCURRSETCURRSETCCURRCascade
F_581STOREENT_IDSTOREENTSTOREENT_IDCascade
F_582CREDITLINE_IDCREDITLINECREDITLINE_IDCascade
F_584POLICY_IDPOLICYPOLICY_IDCascade
F_585ACCOUNT_IDACCOUNTACCOUNT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_537PAYSUMMARY_IDORDPAYMTHDPAYSUMMARY_IDCascade
F_668PAYSUMMARY_IDREFUNDMTHDPAYSUMMARY_IDCascade