vendorsubsidiaryrelationship
Defines the relationship between vendors and subsidiaries, enabling multi-subsidiary vendor management in NetSuite.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | Unique internal identifier assigned to each vendor-subsidiary relationship. This ID is auto-generated by the system and cannot be modified. | |
| balance | Decimal | The current outstanding balance for the vendor within the specified subsidiary. This includes unpaid invoices and pending transactions. | |
| balancebase | Decimal | The outstanding balance for the vendor within the subsidiary, converted to the base currency of the NetSuite account for standardization. | |
| basecurrency | String | The default currency assigned to the subsidiary. This is used for reporting and financial transactions within the entity. | |
| creditlimit | Decimal | The maximum amount of credit that has been extended to the vendor by the subsidiary. Transactions exceeding this limit can require approval. | |
| externalid | String | An optional external identifier that can be used to reference the vendor-subsidiary relationship in external systems or integrations. | |
| isprimarysub | Boolean | Indicates whether this subsidiary is the vendor's primary subsidiary. A value of 'true' means this is the main subsidiary for transactions. | |
| name | String | The name of the vendor-subsidiary relationship. This field can be auto-generated and is often used internally for identification. | |
| primarycurrency | String | The primary currency used for transactions with the vendor within this subsidiary. This can differ from the base currency. | |
| subsidiary | String | The subsidiary associated with the vendor in this relationship. This defines the financial and operational entity responsible for managing transactions with the vendor. | |
| unbilledorders | Decimal | The total value of unbilled purchase orders and other pending vendor commitments within the subsidiary. | |
| unbilledordersbase | Decimal | The value of unbilled purchase orders and vendor commitments, converted into the base currency of the NetSuite account for consistency in financial reporting. |