blanketpurchaseorder
Stores details of blanket purchase orders, allowing businesses to pre-authorize multiple purchases with a vendor over time.
Columns
| Name | Type | References | Description |
| billedamount | Decimal | The total monetary amount that has been billed for this transaction. | |
| billinginstructions | String | Special instructions or notes related to the billing process. | |
| carrier | String | The shipping carrier responsible for delivering the goods or services. | |
| class | String | The classification category used for tracking and reporting transactions, such as department or business unit. | |
| createddate | Datetime | The date and time when this record was created in the system. | |
| createdfrom | String | The original record from which this transaction was generated, such as a sales order or purchase order. | |
| currency | String | The currency in which the transaction is recorded. | |
| currencyname | String | The name of the currency used in this transaction. | |
| currencysymbol | String | The symbol of the currency used in this transaction, such as $ or €. | |
| customform | String | The custom form template applied to this record for specific business needs. | |
| department | String | The department associated with this transaction, used for financial reporting and categorization. | |
| effectivitybasedon | String | Specifies whether the transaction's effectivity is based on date, approval status, or other criteria. | |
| employee | String | The employee associated with this transaction, if applicable. | |
| enddate | Date | The date when the transaction, contract, or agreement ends. | |
| entity | String | The customer, vendor, or other entity associated with this transaction. | |
| entitynexus | String | The tax nexus applicable to the entity in this transaction. | |
| exchangerate | Decimal | The exchange rate used to convert foreign currency amounts into the base currency. | |
| externalid | String | A unique identifier used for integration with external systems or data imports. | |
| incoterm | String | The international commercial term (Incoterm) that defines the delivery terms and responsibilities. | |
| isbasecurrency | Boolean | Indicates whether this currency is the base currency for the subsidiary or company. | |
| lastmodifieddate | Datetime | The date and time when this record was last modified. | |
| location | String | The physical or logical location associated with this transaction or record. | |
| maximumamount | String | The maximum allowable amount for this transaction or contract. | |
| memo | String | A free-text field for adding notes or comments related to this transaction. | |
| nexus | String | The tax jurisdiction or nexus associated with this transaction. | |
| oldrevenuecommitment | String | The previous revenue commitment associated with this transaction, if applicable. | |
| orderstatus | String | The current status of the order, such as Pending, Approved, or Shipped. | |
| otherrefnum | String | An additional reference number used for tracking this transaction. | |
| packinglistinstructions | String | Special instructions related to the packing list for this transaction. | |
| productlabelinginstructions | String | Guidelines or requirements for labeling the products in this transaction. | |
| purchasedamount | Decimal | The total amount spent on purchases related to this transaction. | |
| purchaseorderinstructions | String | Special instructions or notes related to the purchase order. | |
| receivedamount | Decimal | The total amount received for this transaction, such as payments or goods. | |
| source | String | The origin of this transaction, such as an online order, import, or manual entry. | |
| startdate | Date | The date when the transaction, contract, or agreement begins. | |
| status | String | The current status of this transaction, such as Open, Closed, or In Progress. | |
| statusRef | String | A system reference for the status of this transaction. | |
| subsidiary | String | The subsidiary associated with this transaction, relevant for multi-entity organizations. | |
| terms | String | The payment terms applied to this transaction, such as Net 30 or Due on Receipt. | |
| trandate | Date | The date on which this transaction occurred or was recorded. | |
| tranid | String | The unique transaction ID assigned to this record. | |
| updatecurrency | String | Indicates whether the currency details for this transaction have been updated. |