purchaserequisition
Manages purchase requisitions, enabling internal requests for goods and services before purchase orders are issued.
Columns
| Name | Type | References | Description |
| approvalstatus | String | The approval status of the record, indicating whether it has been approved, pending, or requires review. | |
| class | String | The class assigned to the record, used for categorizing or grouping similar records for reporting or analysis. | |
| createddate | Datetime | The date and time when the record was created, used to track the origin and creation timeline. | |
| createdfrom | String | The source or origin from which the record was created, often used to link the record to a parent record or system. | |
| currency | String | The type of currency used for the transaction or record (such as USD, EUR, or GBP), specifying the denomination for monetary values. | |
| currencyname | String | The name of the currency associated with the record, such as 'United States Dollar' or 'Euro'. | |
| currencysymbol | String | The symbol representing the currency, such as '$' for USD or '€' for EUR. | |
| customform | String | The custom form used for the record, allowing personalized layouts and fields specific to the transaction or entity. | |
| department | String | The department associated with the record, used for internal tracking and resource allocation. | |
| duedate | Date | The date by which the record or transaction is due, marking the deadline for payments, deliveries, or other obligations. | |
| entity | String | The entity associated with the record (such as a customer, partner, or vendor), used to track relationships. | |
| entity_nexus_country | String | The country of nexus for the entity, used to define the tax jurisdiction or region in which the entity operates. | |
| entitynexus | String | The nexus or jurisdiction that the entity operates in, often used for tax and regulatory purposes. | |
| estimatedtotal | Decimal | The estimated total amount for the record, typically used for forecasting or budget tracking. | |
| exchangerate | Decimal | The exchange rate applied to the record, used for converting between currencies. | |
| externalid | String | A unique identifier assigned to the record by an external system, used for integration or synchronization. | |
| fob | String | The Free On Board (FOB) terms associated with the transaction, specifying shipping responsibilities and delivery terms. | |
| isbasecurrency | Boolean | Indicates whether the currency used is the base currency of the organization, often used for accounting purposes. | |
| lastmodifieddate | Datetime | The date and time when the record was last modified, used for tracking changes or updates to the record. | |
| linkedtrackingnumbers | String | The tracking numbers associated with linked shipments, used to track multiple shipments in relation to the record. | |
| location | String | The location associated with the record, typically used to track where goods are stored, delivered, or services provided. | |
| memo | String | A memo or note associated with the record, often used for providing additional context or comments. | |
| message | String | A message associated with the record, used for communication or notifications related to the transaction or record. | |
| messagesel | String | The selected message or template associated with the record, often used for communication or system-generated messages. | |
| nextapprover | String | The individual or role responsible for the next approval step in the approval workflow for the record. | |
| nexus | String | The nexus or tax jurisdiction associated with the record, used for determining tax obligations and regulatory compliance. | |
| nexus_country | String | The country associated with the nexus, used to track tax or business jurisdiction for the record. | |
| oldrevenuecommitment | String | A prior revenue commitment associated with the record, used for tracking previous agreements or sales forecasts. | |
| returntrackingnumbers | String | The tracking numbers for returned shipments, used to track the status of returned goods or materials. | |
| shipdate | Date | The date when the items are shipped, marking the start of the delivery process. | |
| source | String | The source from which the record originated, often used to track the origin of leads, sales, or transactions. | |
| status | String | The current status of the record (such as 'pending', 'shipped', 'completed', or 'closed'), used for tracking progress. | |
| statusRef | String | A reference to the status of the record, often used to link to another system or status for integration. | |
| subsidiary | String | The subsidiary or division of the organization associated with the record, used in multi-entity tracking and reporting. | |
| terms | String | The payment terms associated with the transaction, such as 'Net 30', 'Due on receipt', or 'Installments'. | |
| total | Decimal | The total value associated with the record, often representing the sum of charges, costs, or amounts due. | |
| trackingnumbers | String | The tracking numbers associated with the shipment or delivery, used for tracking the status of goods or services in transit. | |
| trandate | Date | The date when the transaction took place or was recorded, used to track the timing of financial or operational activities. | |
| tranid | String | A unique identifier for the transaction, used for referencing and tracking the specific transaction record. | |
| updatecurrency | String | Indicates the currency used for updates to the record, especially when adjusting currency values in transactions. |