| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BKKPOMND | Payment order Enriched with Mandate details | 16 | CHG_REASON | SEPA: Reason for Change | nvarchar | 5 | 0 | | |
2 | MSPT_OIGS | TD Shipment Header to store deleted records | 93 | CHG_REASON | OIL-TPI: Change reason code | nvarchar | 2 | 0 | | |
TOPBank |
3 | SEPA_MANDATE | SEPA Mandate | 16 | CHG_REASON | SEPA: Reason for Change | nvarchar | 5 | 0 | | |
TOPBasic Functions |
4 | UDMEVENT | Event | 4 | CHG_REASON | Change Reason | nvarchar | 1 | 0 | | |
TOPDSD Connector |
5 | /DSD/ME_CHG_RSN | DSD CN: Reasons for Changing Deliveries and Orders | 2 | CHG_REASON | DSD CN: Reasons for Delivery Changes | nvarchar | 2 | 0 | | |
6 | /DSD/ME_CHG_RSNT | DSD CN: Description of Reasons for Delivery Changes | 3 | CHG_REASON | DSD CN: Reasons for Delivery Changes | nvarchar | 2 | 0 | | |
TOPIncentive and Commission Management ICM |
7 | CACS_CTRTBDL | Contract Bundle | 18 | CHG_REASON | Reason for Changing Contract | nvarchar | 3 | 0 | | |
8 | CACS_CTRTBU | Commission Contract | 12 | CHG_REASON | Reason for Changing Contract | nvarchar | 3 | 0 | | |
9 | TCACS_BDRCH | Reason for Change to Contract Bundle | 3 | CHG_REASON | Reason for change | nvarchar | 3 | 0 | | |
10 | TCACS_BDRCHT | Reason for Change to Contract Bundle | 4 | CHG_REASON | Reason for change | nvarchar | 3 | 0 | | |
11 | TCACS_CTRCH | Reason for Changing Contract | 3 | CHG_REASON | Reason for Changing Contract | nvarchar | 3 | 0 | | |
12 | TCACS_CTRCHT | Reason for Changing Contract | 4 | CHG_REASON | Reason for Changing Contract | nvarchar | 3 | 0 | | |
TOPTransportation and Distribution |
13 | OIGS | TD Shipment Header | 93 | CHG_REASON | OIL-TPI: Change reason code | nvarchar | 2 | 0 | | |