WebSphere Commerce database table: 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 Description(s):
Column NameColumn TypeDescription
PAYSUMMARY_ID BIGINT NOT NULL Generated unique key for this row.
ACCOUNT_ID BIGINT The business account ID of this payment summary. May be null if there is no business account.
SETCCURR CHAR(3) Currency of the Total Charge Amount field. Alphabetic currency code as per ISO 4217.
CREDITLINE_ID BIGINT CreditLine 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_ID INTEGER NOT NULL The ID of the Store.
POLICY_ID BIGINT The ID of the Payment Policy that this payment summary is for.
PERIODSTARTTIME TIMESTAMP NOT NULL Period start time.
PERIODENDTIME TIMESTAMP NOT NULL Period end time.
TOTALCHARGE DECIMAL (20,5) NOT NULL The Total charge amount represented by this Payment Summary in the default currency of the Store.
PAYSUMMARYXML CLOB The Payment Summary XML for the specified period.
STATUS INTEGER Flag to indicate if the Payment Summary has been sent to an external accounting system:
0 = not sent or 1 = sent.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031254220 PAYSUMMARY_ID Primary Key
I0000686 ACCOUNT_ID Non-Unique Index
I0000687 POLICY_ID Non-Unique Index
I0000689 CREDITLINE_ID Non-Unique Index
I0000690 STOREENT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_585 ACCOUNT_ID ACCOUNT ACCOUNT_ID Cascade
F_582 CREDITLINE_ID CREDITLINE CREDITLINE_ID Cascade
F_584 POLICY_ID POLICY POLICY_ID Cascade
F_580 SETCCURR SETCURR SETCCURR Cascade
F_581 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_537 PAYSUMMARY_ID ORDPAYMTHD PAYSUMMARY_ID Cascade
F_668 PAYSUMMARY_ID REFUNDMTHD PAYSUMMARY_ID Cascade

Feedback