CMK_ACCOUNT_NUMBERS
This table contains account numbers used in B2B message processing. Each account number must have an associated service provider, trading partner, supplier, a ship-to location and optionally a purchasing site and business unit and pay site and pay site business unit. The account number is included in the payload of the outbound purchase sent to your suppliers. The information in this table is also used during processing of invoices you receive to derive a pay site for your invoices that don't have a purchase order or to specify a pay site for your invoice that is different than the site on your purchase order.
Details
-
Schema: FUSION
-
Object owner: CMK
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
cmk_account_numbers_PK |
ACCOUNT_NUMBER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ACCOUNT_NUMBER_ID | NUMBER | 18 | Yes | This is the unique identifier of the account number record. It's value is an application generated unique id. | |
| ACCOUNT_NUMBER | VARCHAR2 | 256 | Yes | This is the identifier of the account number. | |
| SERVICE_PROVIDER_ID | NUMBER | 18 | This is the unique identifier of the service provider. | ||
| EXTERNAL_PARTNER_ID | NUMBER | 18 | Unique identifier of the trading partner. This is a foreign key to the CMK_EXTERNAL_PARTNERS. | ||
| VENDOR_ID | NUMBER | 18 | Yes | This is the unique identifier of the supplier. | |
| VENDOR_SITE_ID | NUMBER | 18 | This is the unique identifier of the supplier site. | ||
| BILL_TO_BU | NUMBER | 18 | This is the business unit that is used to create the invoice during message processing. | ||
| PAY_SITE_ID | NUMBER | 18 | This is the site that is used to create the invoice during message processing. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CMK_ACCOUNT_NUMBERS | cmk_service_providers_b | SERVICE_PROVIDER_ID |
| CMK_ACCOUNT_NUMBERS | cmk_external_partners | EXTERNAL_PARTNER_ID |
| cmk_acct_shipto_asgmts | cmk_account_numbers | ACCOUNT_NUMBER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| cmk_account_numbers_U1 | Unique | FUSION_TS_TX_IDX | ACCOUNT_NUMBER_ID |
| cmk_account_numbers_U2 | Unique | FUSION_TS_TX_IDX | EXTERNAL_PARTNER_ID, VENDOR_ID, VENDOR_SITE_ID, ACCOUNT_NUMBER |