PAYMENTSOURCE
The PAYMENTSOURCE table is the abstract supertype for the various payment source subtypes in the system: BANKACCOUNT, CHARGECARD, and PAYROLLDEDUCTION.
This table is used by the following domain.
Name | Comment | Datatype | Null Option | Is PK |
---|---|---|---|---|
PAYMENT_SOURCE_ID | A unique, system-generated key that identifies a payment source in the system. | BIGINT | Not Null | Yes |
PAYMENT_SRC_CODE | Designates the type of payment source as follows: P - Payroll deduction; C - Charge card; B - Bank account. | CHAR(1) | Not Null | No |
START_DT | The date that the payroll deduction, charge card, or bank account record became effective or was recorded. | TIMESTAMP | Not Null | No |
END_DT | The date that the payroll deduction, charge card, or bank account record is no longer effective. | TIMESTAMP | Null | No |
LAST_UPDATE_DT | When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. | TIMESTAMP | Not Null | No |
LAST_UPDATE_USER | The ID of the user who last updated the data. | VARCHAR(20) | Null | No |
LAST_UPDATE_TX_ID | A unique, system-generated key that identifies the specific transaction within the log system that either created, updated, or deleted the data row. | BIGINT | Null | No |
CONT_ID | A unique, system-generated key that identifies a party in the system. | BIGINT | Not Null | No |