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 |