Contracts

Below are the schemas and relationships for the Contracts.

---

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	Datetime
ContractId	Primary key for the Contracts schema	String
Title	Contract title	String
ClientCode	Customer code	String
SupplierId	Identifier of the supplier for the pre-order	String
SupplierIdentity	Supplier identity	String
SupplierName	Supplier name	String
SupplierTradingName	Supplier's trading name	String
CreatedDate	Contract creation date	Datetime
StartDate	Contract start date	Datetime
EndDate	Contract end date	Datetime
CurrencyCode	Contract currency code	String
Total	Total contract value	Double
PaymentConditionCode	Payment condition code	String
PaymentConditionDescription	Payment condition description	String
DeliveryCondition	Delivery condition	String
DeliveryDeadline	Delivery deadline in days	int
StatusCode	Contract status code	int
StatusDescription	Contract status description	String
ResponsibleBuyerId	Responsible buyer ID	String
ResponsibleBuyerName	Responsible buyer name	String
ControlBalance	In the contract, the user can select the balance control they want. For example: total amount, quantity, none, etc.	Double
Status	Contract situation. Possible values: 103, 1, 2, etc.	int

Contracts Schema Joins

The Contracts schema is related to the following schemas:

Schema	Relationship Column	Description
ContractItems	ContractId	Links the rows of Contracts with the rows of ContractItems
Products	Id	Links the rows of Contracts with the rows of Products
ContractAttributeValues	ContractId	Links the rows of Contracts with the rows of ContractAttributeValues
ContractApprovals	ContractId	Links the rows of Contracts with the rows of ContractApprovals
Orders	ContractId	Links the rows of Contracts with the rows of Orders
RequestItems	ContractId	Links the rows of Contracts with the rows of RequestItems

ContractItems

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	Datetime
ContractId	Primary key for the Contracts schema	String
ContractItemId	Contract item number	String
ProductId	Product item ID	String
ProductCode	Product item code	String
ProductClientCode	Product item client code	String
ProductDescription	Product item description	String
Price	Item price in the contract	Double
ProductMaterialType	Indicates if the product is a material or service	String
ProductGeneric	Indicates if the product is generic	Boolean
RfqId	RFQ identifier	String
RfqItem	RFQ item	Integer
CreatedDate	Date when the contract was created	Datetime
EndDate	Contract end date	Datetime

ContractItems Schema Joins

The ContractItems schema is related to the following schemas:

Schema	Relationship Column	Description
Contracts	ContractId	Links the rows of ContractItems with the rows of Contracts
ContractAttributeValues	ContractId	Links the rows of ContractItems with the rows of ContractAttributeValues
ContractApprovals	ContractId	Links the rows of ContractItems with the rows of ContractApprovals
Orders	ContractId	Links the rows of ContractItems with the rows of Orders
RequestItems	ContractId	Links the rows of ContractItems with the rows of RequestItems

ContractAttributeValues

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	Datetime
ContractId	Primary key for the Contracts schema	String
Name	Attribute name	String
Description	Attribute description	String
Value	Attribute content	String

ContractAttributeValues Schema Joins

The ContractAttributeValues schema is related to the following schemas:

Schema	Relationship Column	Description
Contracts	ContractId	Links the rows of ContractAttributeValues with the rows of Contracts
ContractItems	ContractId	Links the rows of ContractAttributeValues with the rows of ContractItems
ContractApprovals	ContractId	Links the rows of ContractAttributeValues with the rows of ContractApprovals
Orders	ContractId	Links the rows of ContractAttributeValues with the rows of Orders
RequestItems	ContractId	Links the rows of ContractAttributeValues with the rows of RequestItems

ContractApprovals

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	Datetime
ContractId	Primary key for the Contracts schema	String
StatusCode	Contract status code	Integer
Status	Contract status. Possible values: Submitted, In approval.	String
ApproverId	ID of the contract approver	String
ApproverName	Name of the contract approver	String
ApproverRoleId	Role ID of the person responsible for the contract	String
ApproverRoleName	Role name of the person responsible for the contract	String
CreatedDate	Date when the contract was created	Datetime
ClosedDate	Closure date	Datetime

ContractApprovals Schema Joins

The ContractApprovals schema is related to the following schemas:

Schema	Relationship Column	Description
Contracts	ContractId	Links the rows of ContractApprovals with the rows of Contracts
ContractItems	ContractId	Links the rows of ContractApprovals with the rows of ContractItems
ContractAttributeValues	ContractId	Links the rows of ContractApprovals with the rows of ContractAttributeValues
Orders	ContractId	Links the rows of ContractApprovals with the rows of Orders
RequestItems	ContractId	Links the rows of ContractApprovals with the rows of RequestItems

ContractBorgs

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	Datetime
ContractId	Primary key for the Contracts schema	String
BorgId	Business unit identifier	String
Code	Business unit code	String
Name	Business unit name	String
VentId	Virtual entity identifier (VEnt) of the business unit	String
VentName	Virtual entity name (VEnt) of the business unit	String
VentType	Virtual entity type (VEnt) of the business unit	String

ContractBorgs Schema Joins

The ContractBorgs schema is related to the following schemas:

Schema	Relationship Column	Description
Contracts	ContractId	Links the rows of ContractBorgs with the rows of Contracts
ContractItems	ContractId	Links the rows of ContractBorgs with the rows of ContractItems
ContractAttributeValues	ContractId	Links the rows of ContractBorgs with the rows of ContractAttributeValues
Orders	ContractId	Links the rows of ContractBorgs with the rows of Orders
RequestItems	ContractId	Links the rows of ContractBorgs with the rows of RequestItems
ContractApprovals	ContractId	Links the rows of ContractBorgs