purchaserequisition
The purchaserequisition table.
Columns
| Name | Type | References | Description |
| approvalstatus | String | Approvalstatus | |
| class | String | Class | |
| createddate | Datetime | Createddate | |
| createdfrom | String | Createdfrom | |
| currency | String | Currency | |
| currencyname | String | Currencyname | |
| currencysymbol | String | Currencysymbol | |
| customform | String | Customform | |
| department | String | Department | |
| duedate | Date | Duedate | |
| entity | String | Entity | |
| entity_nexus_country | String | Entity_nexus_country | |
| entitynexus | String | Entitynexus | |
| estimatedtotal | Decimal | Estimatedtotal | |
| exchangerate | Decimal | Exchangerate | |
| externalid | String | Externalid | |
| fob | String | Fob | |
| isbasecurrency | Boolean | Isbasecurrency | |
| lastmodifieddate | Datetime | Lastmodifieddate | |
| linkedtrackingnumbers | String | Linkedtrackingnumbers | |
| location | String | Location | |
| memo | String | Memo | |
| message | String | Message | |
| messagesel | String | Messagesel | |
| nextapprover | String | Nextapprover | |
| nexus | String | Nexus | |
| nexus_country | String | Nexus_country | |
| oldrevenuecommitment | String | Oldrevenuecommitment | |
| returntrackingnumbers | String | Returntrackingnumbers | |
| shipdate | Date | Shipdate | |
| source | String | Source | |
| status | String | Status | |
| statusRef | String | Statusref | |
| subsidiary | String | Subsidiary | |
| terms | String | Terms | |
| total | Decimal | Total | |
| trackingnumbers | String | Trackingnumbers | |
| trandate | Date | Trandate | |
| tranid | String | Tranid | |
| updatecurrency | String | Updatecurrency |