It contains the information of accounting documents (CONTRACTS-INVOICES-OTHER DOCUMENTS) for the execution of a work or work
Data model
Fields
| Field |
Type |
Description |
| area_id |
INT |
Identifier of the area related to the contract |
| area_id_contract |
INT |
Group identifier related to the contract |
| class_id |
INT |
Document Class Identifier |
| con_modified_date |
DATETIME |
Date of last modification of the document |
| con_modifier_id |
INT |
User ID related to the last modification of the document |
| contractfin |
DATETIME |
Document end date |
| contractid* |
INT |
Unique Object Identifier |
| contractini |
DATETIME |
Document Start Date |
| contractvalue |
NUMERIC |
Contract Value |
| days_warranty |
INT |
Contract Warranty Value in Days |
| fl_int_has_alarm* |
BIT |
Indicates whether the contract has an associated alarm (0 = no alarm, 1 = with alarm) |
| fl_int_limitdays |
INT |
Number of days in advance to inform about the termination of the contract |
| fl_int_user_id |
INT |
Identifier of the user responsible for the Contract |
| fl_str_contract_type |
INT |
Model representing the type of document |
| fl_str_description |
NVARCHAR (1000) |
Document Description |
| fl_str_statuscontract |
INT |
Current Contract Status Identifier |
| numbercontract |
NVARCHAR (120) |
Number that identifies the document for the user |
| schedule_flag |
BIT |
Indicates whether or not the contract is expired (0 = expired, 1 = active) |
| template_id |
INT |
Template identifier related to the contract |
| type_id |
INT |
Document type identifier |
| vendor_id_contract |
INT |
Supplier identifier related to the contract |
| vendorid |
INT |
Company or manufacturer identifier |
Primary Key
| PK_ASMS_CONTRACT |
| contractid |
References
