SalesOrdersForOrderHublinesbillToCustomer
Records billing customer information referenced by sales order headers for invoicing purposes.
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | Unique identifier for the sales order header, linking the bill-to customer details to the parent order for tracking and reference. |
| LinesFulfillLineId [KEY] | Long | Identifier for the fulfillment line associated with the order, helping to connect the bill-to customer details with the specific order line. |
| AddressId [KEY] | Long | Unique identifier for the bill-to customer address, ensuring accurate billing information is associated with the correct location. |
| CustomerAccountId | Long | Unique identifier for the account that is legally responsible for payment, representing the relationship between the deploying company and the customer. |
| PartyName | String | Name of the party (either an individual or organization) responsible for making payments for the order, linked to the customer account. |
| AccountDescription | String | Description of the customer account responsible for payment, providing context about the account, such as type or purpose. |
| AccountNumber | String | Account number for the customer responsible for payment, used for referencing the customer's payment account in the billing system. |
| PersonFirstName | String | First name of the person responsible for payment, if the payer is an individual, ensuring proper identification for personal accounts. |
| PersonLastName | String | Last name of the person responsible for payment, included if the payer is an individual, helping to identify the responsible person. |
| PersonMiddleName | String | Middle name of the individual responsible for payment, helping to provide complete identification for personal accounts. |
| PersonNameSuffix | String | Suffix of the individual’s name responsible for payment (for example, Jr., Sr., III), helping to fully identify the individual responsible for payment. |
| PersonTitle | String | Title (for example, Mr., Mrs., Dr.) of the person responsible for payment, adding a formal layer of identification. |
| SiteUseId | Long | Unique identifier for the billing site associated with the account, used to specify which address is linked to the billing process. |
| Address1 | String | First line of the bill-to customer address, typically used for the street address, ensuring accuracy in billing information. |
| Address2 | String | Second line of the bill-to customer address, used for additional address details (for example, apartment or suite number), ensuring full address accuracy. |
| Address3 | String | Third line of the bill-to customer address, used when more address detail is needed to fully specify the billing location. |
| Address4 | String | Fourth line of the bill-to customer address, for any extra address details that are required for accurate billing or delivery. |
| City | String | City of the bill-to customer address, identifying the city for proper address formatting and delivery. |
| State | String | State of the bill-to customer address, helping to determine the region for tax and shipping purposes. |
| PostalCode | String | Postal code of the bill-to customer address, ensuring proper routing and delivery of bills or invoices. |
| County | String | County of the bill-to customer address, used for specific regional or jurisdictional tax purposes and identifying the area within the state. |
| Province | String | Province of the bill-to customer address, used when applicable (for example, Canada) for addressing purposes and regional tax assessments. |
| Country | String | Country of the bill-to customer address, helping to identify the country for international shipping and tax purposes. |
| ContactId | Long | Unique identifier for the contact person associated with the billing account, enabling reference to specific individuals for communications. |
| ContactName | String | Full name of the person to contact at the bill-to customer site, helping to identify the responsible individual for payment inquiries. |
| ContactNumber | String | Phone number of the person to contact at the bill-to customer site, ensuring easy communication for billing matters. |
| ContactFirstName | String | First name of the person to contact at the bill-to customer site, useful for addressing the individual in communications. |
| ContactMiddleName | String | Middle name of the contact person at the bill-to customer site, providing further details for identifying the individual. |
| ContactLastName | String | Last name of the contact person at the bill-to customer site, used for formal correspondence and identification. |
| ContactNameSuffix | String | Suffix for the contact person’s name at the bill-to customer site (for example, Jr., Sr.), helping to distinguish between similarly named individuals. |
| ContactTitle | String | Title (for example, Mr., Mrs., Dr.) of the contact person at the bill-to customer site, adding formality to communications. |
| PreferredContactPointId | Long | Unique identifier for the preferred contact method (for example, email) for the billing account contact person, ensuring smooth communication. |
| SourceAddressId | String | Unique identifier for the bill-to customer address, typically set to '1' for standard address referencing, linking to the primary billing address. |
| Finder | String | Tool or method used to search and locate specific billing records, helping users to filter and identify relevant information. |
| FromDate | Date | Start date for the validity of the billing information, marking the period when the billing details become applicable. |
| HeaderId | Long | Unique identifier for the order header, linking the bill-to customer details to the larger order structure. |
| OrderKey | String | Key used to uniquely identify the order line, helping track the specific order line details tied to the bill-to customer. |
| OrderNumber | String | Order number assigned to the sales order, used for tracking the order throughout its lifecycle and for referencing the bill-to customer details. |
| SourceTransactionNumber | String | Transaction number assigned by the source system, linking the bill-to customer details to its originating transaction in an external system. |
| SourceTransactionSystem | String | Name of the source transaction system, providing context for where the bill-to customer information originated and ensuring system integration. |
| ToDate | Date | End date after which the billing information is no longer valid, marking the point at which the customer’s billing responsibilities change or cease. |