JDBC Driver for Oracle Financials Cloud

Build 22.0.8462

SalespersonReferenceAccounts

SalespersonReferenceAccounts

Columns

Name Type Description
SalespersonId [KEY] String The unique identifier of the salesperson.
SalespersonNumber String The number that identifies the salesperson. The salesperson number is part of the unique set that identifies a reference account.
SalespersonName String The name of the salesperson. The salesperson name is part of the unique set that identifies a reference account.
SalespersonSet String The reference set assigned to the salesperson during salesperson creation to support data partitioning.
SalespersonStatus String The status of the salesperson. Valid values are Active and Inactive.
SalespersonStartDate Date The date when the salesperson is hired.
SalespersonEndDate Date The date when the salesperson is terminated.
BusinessUnit String A unit of an enterprise that performs one or more business functions that can be rolled up in a management hierarchy. The business unit is part of the unique set that identifies a reference account.
Ledger String A ledger at the business unit level which holds all the accounting information details.
ReceivablesAccountCombination String The accounting flexfield combination for the Receivables account.
FreightAccountCombination String The accounting flexfield combination for the Freight account.
RevenueAccountCombination String The accounting flexfield combination for the Revenue account.
CreationDate Datetime The date when the record was created.
CreatedBy String The user who created the record.
LastUpdateDate Datetime The date when the record was last updated.
LastUpdatedBy String The user who last updated the record.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462