ALEX_PR_VENDOR_TYPE (Staging table)
| Column name | Data type | Required | Default update able | Data target | Comments |
|---|---|---|---|---|---|
| EXTERNAL_KEY** | VARCHAR (255) | Yes* | No | ALCO_EXTERNAL_KEY.EXTERNAL_KEY | External key – primary key |
| VENDOR_TYPE_NAME | VARCHAR (255) | Yes* | Yes | ALPR_VENDOR_TYPE.VENDOR_TYPE_NAME | Vendor name |
| ACTIVE_STATUS | SMALLINT | Yes* | Yes | ALPR_VENDOR_TYPE.ACTIVE_STATUS | Determines whether vendor is active.
|
| CREDIT_CARD_EKEY | VARCHAR (255) | No | Yes | ALPR_VENDOR_TYPE.CCARD_ID | Not used |
| EXTERNAL_SYS_ID | VARCHAR (255) | No | Yes | ALPR_VENDOR_TYPE.EXTERNAL_SYS_ID | Not used |
| MARKETSITE_PARTICIPANT_ID | VARCHAR (255) | No | Not used | ||
| AGREEMENT_NUMBER | VARCHAR (255) | No | Not used | ||
| DELIVERY_DATE_CONSTANT | INTEGER (38) | No | Not used | ||
| PAYMENT_TERM_EKEY | VARCHAR (255) | No | Not used | ||
| RESPONSE_DATE_CONSTANT | INTEGER (38) | No | Not used | ||
| VENDOR_TERMS_EKEY | VARCHAR (255) | No | Yes | ALPR_VENDOR_TYPE.VENDOR_TERMS_ID | Vendor terms external key identifying the terms the vendor has agreed on. If not specified, the global default vendor terms are used. |
| VENDOR_ID | VARCHAR (255) | No | Yes | ALPR_VENDOR_TYPE.VENDOR_ID | An external identifier for the vendor, not necessarily the external key |
| IS_PAYMENT_TAXABLE | SMALLINT | No | Yes | ALPR_VENDOR_TYPE.IS_PAYMENT_TAXABLE | Does any payment made to this vendor require notification to
the government as taxable?
|
| TAX_CODE | VARCHAR (255) | No | Yes | ALPR_VENDOR_TYPE.TAX_CODE | If the payment is taxable, to what code should it be reported? In US this is 1099 and in Canada it is T4 code |
| TAX_ID | VARCHAR (255) | No | Yes | ALPR_VENDOR_TYPE.TAX_ID | The vendor identifier to the government as a tax id |
| SYSTEM_CODE1 | VARCHAR (255) | No | Yes | ALPR_VENDOR_TYPE.SYSTEM_CODE_1 | Implementation specific |
| SYSTEM_CODE2 | VARCHAR (255) | No | Yes | ALPR_VENDOR_TYPE.SYSTEM_CODE_1 | Implementation specific |
| SYSTEM_CODE3 | VARCHAR (255) | No | Yes | ALPR_VENDOR_TYPE.SYSTEM_CODE_1 | Implementation specific |
| SYSTEM_CODE4 | VARCHAR (255) | No | Yes | ALPR_VENDOR_TYPE.SYSTEM_CODE_1 | Implementation specific |
| SYSTEM_CODE5 | VARCHAR (255) | No | Yes | ALPR_VENDOR_TYPE.SYSTEM_CODE_1 | Implementation specific |
| SYSTEM_CODE6 | VARCHAR (255) | No | Yes | ALPR_VENDOR_TYPE.SYSTEM_CODE_1 | Implementation specific |
| SYSTEM_CODE7 | VARCHAR (255) | No | Yes | ALPR_VENDOR_TYPE.SYSTEM_CODE_1 | Implementation specific |
| SYSTEM_CODE8 | VARCHAR (255) | No | Yes | ALPR_VENDOR_TYPE.SYSTEM_CODE_1 | Implementation specific |
*System required field
** Value must be unique