SalesOrdersForOrderHubbillToCustomer
Manages billing information associated with customers linked to sales orders, ensuring accurate invoicing.
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | Unique identifier for the sales order header, linking the bill-to customer information to the specific sales order. |
| AddressId [KEY] | Long | Unique identifier for the bill-to customer address, used to track the specific address associated with the sales order for billing purposes. |
| CustomerAccountId | Long | Unique identifier for the account that is legally responsible for payment. This account represents the party with which the deploying company has a selling relationship. |
| PartyName | String | The name of the party (individual or organization) that is legally responsible for making payment on the sales order. |
| AccountNumber | String | Account number of the customer that is legally responsible for payment, typically used for reference and tracking within the billing system. |
| PersonFirstName | String | First name of the individual responsible for payment, applicable when a person (as opposed to an organization) is legally responsible. |
| PersonLastName | String | Last name of the individual responsible for payment, used to fully identify the person legally responsible for the sales order. |
| PersonMiddleName | String | Middle name of the individual responsible for payment, used to fully identify the person when applicable. |
| PersonNameSuffix | String | Suffix (for example, Jr., Sr., III) of the individual responsible for payment, providing additional clarity for identification. |
| PersonTitle | String | Title (for example, Mr., Mrs., Dr.) of the individual responsible for payment, used for formal identification. |
| SiteUseId | Long | Unique identifier for the account site where the billing responsibilities are associated, ensuring that the correct location is linked to the customer account. |
| Address1 | String | First line of the bill-to customer’s address, typically used to capture street address or P.O. box information. |
| Address2 | String | Second line of the bill-to customer’s address, often used for additional address information (for example, apartment or suite number). |
| Address3 | String | Third line of the bill-to customer’s address, used for further address details when necessary. |
| Address4 | String | Fourth line of the bill-to customer’s address, used for extra address information if required. |
| City | String | City of the bill-to customer’s address, used to identify the local geographic area for the customer’s billing location. |
| State | String | State of the bill-to customer’s address, helping to further define the location within a country. |
| PostalCode | String | Postal code of the bill-to customer’s address, providing the final part of the address for accurate delivery and identification. |
| County | String | County of the bill-to customer’s address, providing additional geographic information to help with location verification. |
| Province | String | Province of the bill-to customer’s address, used for regions where applicable, especially in countries like Canada. |
| Country | String | Country of the bill-to customer’s address, ensuring the address is complete for international orders. |
| ContactId | Long | Unique identifier for the contact associated with the billing account, helping to link the specific contact to the payment responsibilities. |
| ContactName | String | Full name of the contact person for the billing account, used for communication and identification purposes. |
| ContactNumber | String | Telephone number of the contact person at the bill-to customer site, used for follow-up and inquiries regarding the order. |
| ContactFirstName | String | First name of the person to contact for billing-related inquiries, used for direct communication. |
| ContactMiddleName | String | Middle name of the person to contact for billing-related inquiries, used for further clarification of the contact's full name. |
| ContactLastName | String | Last name of the person to contact for billing-related inquiries, ensuring accurate identification. |
| ContactNameSuffix | String | Suffix (for example, Jr., Sr.) of the contact person for the billing account, providing additional clarity for proper addressing. |
| ContactTitle | String | Title (for example, Mr., Ms., Dr.) of the person to contact for billing-related inquiries, used for formal communication. |
| PreferredContactPointId | Long | Unique identifier for the preferred method of contact for the person responsible for payment, typically an email address or phone number. |
| SourceAddressId | String | Value that uniquely identifies the bill-to customer’s address, ensuring that the correct address is used for the billing process. This value is typically set to '1'. |
| Finder | String | A tool or method used to search and locate specific billing details or information associated with the sales order. |
| FromDate | Date | The start date during which the billing information for the sales order is valid, used for tracking purposes. |
| HeaderId | Long | Unique identifier for the header of the sales order, helping to link the bill-to customer information to the specific sales order. |
| OrderKey | String | A unique key used to reference and track the sales order across various systems and processes. |
| OrderNumber | String | Order number associated with the sales order, helping to reference and track the specific order. |
| SourceTransactionNumber | String | The number associated with the source transaction that generated the sales order, helping to link it to the originating event. |
| SourceTransactionSystem | String | The system from which the original source transaction originated, providing context about the origin of the sales order. |
| ToDate | Date | The end date during which the billing information for the sales order is valid, ensuring the data is up-to-date and applicable for the correct period. |