Integration.PaymentMethod_Staging
Documentation | WideWorldImportersDW |
Schema | Integration |
Name | PaymentMethod_Staging |
Payment method staging table
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | Payment Method Staging Key | int | Identity | Row ID within the staging table | ||||
Row ID within the staging table Identity |
||||||||
2 | WWI Payment Method ID | int | Numeric ID for the payment method in the WWI database | |||||
Numeric ID for the payment method in the WWI database |
||||||||
3 | Payment Method | nvarchar(50) | Payment method name | |||||
Payment method name |
||||||||
4 | Valid From | datetime2(7) | Valid from this date and time | |||||
Valid from this date and time |
||||||||
5 | Valid To | datetime2(7) | Valid until this date and time | |||||
Valid until this date and time |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_Integration_Payment_Method_Staging | Payment Method Staging Key | Primary key (nonclustered) constraint. | |
Primary key (nonclustered) constraint. |
Exported: 2019-02-04 23:05, Last imported: 2018-08-10 09:59