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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035030640 | PAYSUMMARY_ID | Primary Key |
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 |
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 |