1. Tables and Views for Sales and Fusion Service
  2. ZCA_AGREEMENT_ITEM

ZCA_AGREEMENT_ITEM

This table holds information about Agreement items. The grain of the table is at the Agreement Item level. It holds the price associated with each agreement lines, Agreement effective date and products covered. Each agreement item identifies the associated customer, the original quote, the product, the contact and the owner Organization.

Details

  • Schema: FUSION

  • Object owner: ZCA

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ZCA_AGREEMENT_ITEM_PK

AGREEMENT_ITEM_ID

Columns

Name Datatype Length Precision Not-null Comments
AGREEMENT_ITEM_ID NUMBER 18 Yes Agreement Item Id
AGREEMENT_ITEM_ORIG_SYSTEM VARCHAR2 30 Agreement Item source system name
AGREEMENT_ITEM_ORIG_SYSTEM_REF VARCHAR2 255 Agreement Item source system Id for the source system logical entity
AGREEMENT_ID NUMBER 18 Yes Agreement Id is the primary key value from Fusion CRM base table
AGREEMENT_ITEM_DELETED_FLAG VARCHAR2 1 Agreement Item Deleted Flag
AGREEMENT_ITEM_START_DATE DATE Agreement Item Start Date
AGREEMENT_ITEM_END_DATE DATE Agreement Item End Date
AGREEMENT_ITEM_STATUS_CODE VARCHAR2 50 Agreement Item Status Code
CUSTOMER_ID NUMBER 18 Customer Id is the primary key value from Fusion CRM base table
INVENTORY_ITEM_ID NUMBER 18 Inventory Item Id is the primary key value from Fusion CRM base table
INVENTORY_ORG_ID NUMBER 18 Item Organization Id as created by Fusion CRM
RESOURCE_ID NUMBER 18 Resource Id is the primary key value from Fusion CRM base table
REQUESTED_QUANTITY NUMBER Requested Quantity
NET_DOC_PRICE NUMBER 22 Net Doc Price
ENTERED_CURRENCY_CODE VARCHAR2 20 Currency Code
CURR_EXCHANGE_RATE NUMBER 22 Exchange Rate
CRM_CORP_CURRENCY_CODE VARCHAR2 20 CRM Corporate currency code.
CRM_CURR_CONV_RATE VARCHAR2 30 CRM Currency converstion rate type
BATCH_ID NUMBER 18 Batch Id to group data by batch
INTERFACE_ROW_ID NUMBER 18 Interface Row Id is the unique identifier for the record with in a batch.
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.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or 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
ZCA_AGREEMENT_ITEM zca_agreement AGREEMENT_ID

Indexes

Index Uniqueness Tablespace Columns
ZCA_AGREEMENT_ITEM_N1 Non Unique Default LAST_UPDATE_DATE
ZCA_AGREEMENT_ITEM_N2 Non Unique Default CUSTOMER_ID
ZCA_AGREEMENT_ITEM_N3 Non Unique Default INVENTORY_ITEM_ID
ZCA_AGREEMENT_ITEM_N4 Non Unique Default RESOURCE_ID
ZCA_AGREEMENT_ITEM_N5 Non Unique Default AGREEMENT_ITEM_ORIG_SYSTEM, AGREEMENT_ITEM_ORIG_SYSTEM_REF
ZCA_AGREEMENT_ITEM_U1 Unique Default AGREEMENT_ITEM_ID