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 Name Column Type Column Description
ACCOUNT_ID BIGINT
NULL
The business account ID of this payment summary. May be null if there is no business account.
CREDITLINE_ID BIGINT
NULL
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.
PAYSUMMARYXML LONG VARCHAR
NULL
The Payment Summary XML for the specified period.
PAYSUMMARY_ID BIGINT
NOT NULL
Generated unique key for this row.
PERIODENDTIME TIMESTAMP
NOT NULL
Period end time.
PERIODSTARTTIME TIMESTAMP
NOT NULL
Period start time.
POLICY_ID BIGINT
NULL
The ID of the Payment Policy that this payment summary is for.
SETCCURR CHARACTER (3)
NULL
Currency of the Total Charge Amount field. Alphabetic currency code as per ISO 4217.
STATUS INTEGER
NULL
Flag to indicate if the Payment Summary has been sent to an external accounting system:
0 = not sent or 1 = sent.
STOREENT_ID INTEGER
NOT NULL
The ID of the Store.
TOTALCHARGE DECIMAL (20,5)
NOT NULL
The Total charge amount represented by this Payment Summary in the default currency of the Store.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035030640 PAYSUMMARY_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_580 SETCCURR SETCURR SETCCURR Cascade
F_581 STOREENT_ID STOREENT STOREENT_ID Cascade
F_582 CREDITLINE_ID CREDITLINE CREDITLINE_ID Cascade
F_583 ACCOUNT_ID TRADING TRADING_ID Cascade
F_584 POLICY_ID POLICY POLICY_ID Cascade
F_585 ACCOUNT_ID ACCOUNT ACCOUNT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_537 PAYSUMMARY_ID ORDPAYMTHD PAYSUMMARY_ID Cascade
F_668 PAYSUMMARY_ID REFUNDMTHD PAYSUMMARY_ID Cascade