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:

Name	Type	Description
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 codes 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 (1000000)	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	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

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_580	SETCCURR	SETCURR	SETCCURR	Cascade
F_581	STOREENT_ID	STOREENT	STOREENT_ID	Cascade
F_582	CREDITLINE_ID	CREDITLINE	CREDITLINE_ID	Cascade
F_584	POLICY_ID	POLICY	POLICY_ID	Cascade
F_585	ACCOUNT_ID	ACCOUNT	ACCOUNT_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_537	PAYSUMMARY_ID	ORDPAYMTHD	PAYSUMMARY_ID	Cascade
F_668	PAYSUMMARY_ID	REFUNDMTHD	PAYSUMMARY_ID	Cascade