Tableau Connector for Oracle Fusion Cloud SCM

Build 24.0.9060

SalesOrdersForOrderHubbillToCustomer

The Bill-to Customers resource manages the bill-to customer that the sales order header references.

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHubbillToCustomer
AddressId [KEY] Long AddressId of SalesOrdersForOrderHubbillToCustomer
CustomerAccountId Long Value that uniquely identifies the account that is legally responsible for payment. This account exists when a selling relationship exists between the deploying company and the party.
PartyName String Name of the party who is legally responsible for payment.
AccountNumber String Number of the customer account who is legally responsible for payment. This account exists when a selling relationship exists between the deploying company and the party.
PersonFirstName String If a person is legally responsible for payment, then this attribute contains the first name of the person.
PersonLastName String If a person is legally responsible for payment, then this attribute contains the last name of the person.
PersonMiddleName String If a person is legally responsible for payment, then this attribute contains the middle name of the person.
PersonNameSuffix String If a person is legally responsible for payment, then this attribute contains the name suffix of the person.
PersonTitle String If a person is legally responsible for payment, then this attribute contains the title of the person.
SiteUseId Long Value that uniquely identifies the account site that is legally responsible for payment.
Address1 String First line of the bill-to customer address.
Address2 String Second line of the bill-to customer address.
Address3 String Third line of the bill-to customer address.
Address4 String Fourth line of the bill-to customer address.
City String City of the bill-to customer address.
State String State of the bill-to customer address.
PostalCode String Postal code of the bill-to customer address.
County String County of the bill-to customer address.
Province String Province of the bill-to customer address.
Country String Country of the bill-to customer address.
ContactId Long Value that uniquely identifies the contact for the billing account.
ContactName String Person to contact at the bill-to customer site.
ContactNumber String Telephone number of the person to contact at the bill-to customer site.
ContactFirstName String First name of the person to contact at the bill-to customer site.
ContactMiddleName String Middle name of the person to contact at the bill-to customer site.
ContactLastName String Last name of the person to contact at the bill-to customer site.
ContactNameSuffix String Name suffix of the person to contact at the bill-to customer site.
ContactTitle String Title of the person to contact at the bill-to customer site.
PreferredContactPointId Long Value that uniquely identifies the email for the preferred contact point for the contact at the account who is responsible for payment.
SourceAddressId String Value that uniquely identifies the bill-to customer address. Value is 1.
Finder String Finder of SalesOrdersForOrderHubbillToCustomer
FromDate Date FromDate of SalesOrdersForOrderHubbillToCustomer
HeaderId Long HeaderId of SalesOrdersForOrderHubbillToCustomer
OrderKey String OrderKey of SalesOrdersForOrderHubbillToCustomer
OrderNumber String OrderNumber of SalesOrdersForOrderHubbillToCustomer
SourceTransactionNumber String SourceTransactionNumber of SalesOrdersForOrderHubbillToCustomer
SourceTransactionSystem String SourceTransactionSystem of SalesOrdersForOrderHubbillToCustomer
ToDate Date ToDate of SalesOrdersForOrderHubbillToCustomer

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060