purchasecontract
Stores purchase contract details, used for long-term vendor agreements and procurement planning.
Columns
| Name | Type | References | Description |
| billedamount | Decimal | The total amount that has been billed for the record, typically used in invoicing or financial reporting. | |
| billinginstructions | String | The instructions related to billing, often used to define special billing requirements or conditions for the record. | |
| carrier | String | The carrier associated with the order or shipment, used to track the delivery service or logistics provider handling the items. | |
| class | String | The classification or category assigned to the record, often used to group records by type or business function for reporting and management. | |
| createddate | Datetime | The date and time when the record was created, used to track the origin and timeline of the entry. | |
| createdfrom | String | The origin of the record, typically used to link the record to another source or transaction from which it was created. | |
| currency | String | The currency used for the transaction or record (such as USD, EUR, or GBP), indicating the monetary unit. | |
| currencyname | String | The name of the currency associated with the record, such as 'United States Dollar' or 'Euro'. | |
| currencysymbol | String | The symbol associated with the currency, such as '$' for USD or '€' for EUR. | |
| customform | String | The custom form associated with the record, often used to define the layout and structure of fields for specific transactions or entities. | |
| department | String | The department within the organization associated with the record, often used for tracking or allocating costs or tasks. | |
| effectivitybasedon | String | The basis for determining the effectiveness of the record, such as a specific date, event, or other criteria. | |
| employee | String | The employee associated with the record, typically used to track assignments, tasks, or responsibilities. | |
| enddate | Date | The end date for the record, often used to mark the conclusion of a contract, project, or service period. | |
| entity | String | The entity associated with the record (such as a customer, supplier, or partner), used to track relationships. | |
| entitynexus | String | The nexus or connection between the entity and the transaction, often used to track the relationship for tax or reporting purposes. | |
| exchangerate | Decimal | The exchange rate used for currency conversion, representing the value of one currency in terms of another. | |
| externalid | String | A unique identifier for the record assigned by an external system, used for integration or synchronization across platforms. | |
| incoterm | String | The Incoterm associated with the transaction, used to define the terms of shipment and responsibility for shipping costs. | |
| isbasecurrency | Boolean | Indicates whether the currency used for the record is the base currency for the organization, used for financial reporting. | |
| lastmodifieddate | Datetime | The date and time when the record was last modified, used for tracking changes or updates to the record. | |
| location | String | The location associated with the record, typically used to track where the transaction, item, or service is taking place. | |
| maximumamount | String | The maximum amount associated with the record, often used to define limits or thresholds for financial transactions. | |
| memo | String | A memo or note associated with the record, often used for providing additional context or information about the transaction. | |
| minimumamount | String | The minimum amount associated with the record, often used to define the lower limit for a transaction or order. | |
| nexus | String | The nexus or legal entity associated with the record, used to track tax jurisdictions or business relationships. | |
| oldrevenuecommitment | String | A prior or legacy revenue commitment associated with the record, often used for tracking historical sales or agreements. | |
| orderstatus | String | The current status of the order (such as 'pending', 'shipped', 'delivered', or 'canceled'), used to track order progress. | |
| otherrefnum | String | An additional reference number associated with the record, often used for cross-referencing with other systems or records. | |
| packinglistinstructions | String | The instructions related to the packing list for the order, typically used for packaging or shipment preparation. | |
| productlabelinginstructions | String | The instructions for labeling the product, used for defining how products should be marked or identified for shipping or inventory. | |
| purchasedamount | Decimal | The total amount purchased for the record, typically used in purchasing or procurement transactions. | |
| purchaseorderinstructions | String | Instructions related to the purchase order, used to define special conditions or terms for the purchase. | |
| receivedamount | Decimal | The amount that has been received for the record, typically used in receiving or inventory transactions to track items received. | |
| source | String | The source of the record, often used to track where the record originated, such as a lead source or sales channel. | |
| startdate | Date | The start date for the record, often used to mark the beginning of a contract, project, or service period. | |
| status | String | The current status of the record (such as 'active', 'completed', 'pending', or 'closed'), used for tracking its state in the workflow. | |
| statusRef | String | A reference to the status associated with the record, typically used for external systems or integration purposes. | |
| subsidiary | String | The subsidiary or division of the organization associated with the record, used for multi-entity financial tracking or reporting. | |
| terms | String | The terms associated with the record, such as payment terms, shipping terms, or contractual terms. | |
| trandate | Date | The transaction date associated with the record, used to track when the transaction or event occurred. | |
| tranid | String | A unique identifier for the transaction, used to track and reference the specific transaction record. | |
| updatecurrency | String | Indicates the currency used for updates to the record, used when adjusting or converting currency values in transactions. | |
| updateitemvendor | Boolean | Indicates whether the item vendor should be updated, often used in inventory or purchase order management. |