Customer-Subsidiary Relationship

Internal ID: customersubsidiaryrelationship

Supports Custom Fields

Fields

Internal ID Type nlapiSubmitField Label Required Help
balance currency Balance false The customer's current accounts receivable balance due appears here. If you use the Multiple Currencies feature, the amount in this field is shown in the customer's currency.
depositbalance currency Deposit Balance false The Customer Deposit Balance field displays the total amount of unapplied deposits for the customer. Deposits are recorded in the general ledger, as a liability, when the customer makes an advance payment before delivery of goods or services. A deposit balance exists until the goods or services are delivered. Deposits do not affect the customer's accounts receivable balance. If you use the Multiple Currencies feature, the amount in this field is shown in the customer's currency.
entity select Customer false
externalid text External Id false
id integer Internal ID false The internal ID for this record is shown here. If you do not want to show internal IDs, clear the Show Internal IDs box at Home > Set Preferences.
internalid integer Internal ID false
isprimarysub checkbox Primary Subsidiary false
primarycurrency text Primary Currency false
subsidiary select Subsidiary false Select the subsidiary to associate with this entity or job. You cannot enter transactions for this entity or job unless a subsidiary is assigned. If you select this entity on a transaction, the transaction is associated with this subsidiary. The entity is able to access only information associated with this subsidiary. Note: Once a transaction has posted for the entity or job, you are not able to change the subsidiary selected on the entity or job record.
unbilledorders currency Unbilled Orders false This field displays the total amount of orders that have been entered but not yet billed. If you have enabled the preference Customer Credit Limit Includes Orders, then this total is included in credit limit calculations. Set this preference at Setup > Accounting > Preferences > Accounting Preferences > General. If you use the Multiple Currencies feature, the amount in this field is shown in the customer's currency.

Search Joins

Join ID Join Description Actual Join Name
customer Customer Customer
subsidiary Subsidiary Subsidiary

Search Filters

Internal ID Type Label
balance currency Balance
depositbalance currency Deposit Balance
entity select Customer
externalid select External ID
externalidstring text External ID (Text)
internalid select Internal ID
internalidnumber integer Internal ID (Number)
isprimarysub checkbox Primary (Y/N)
primarycurrency select Primary Currency
subsidiary select Subsidiary
unbilledorders currency Unbilled Orders

Search Columns

Internal ID Type Label
balance currency Balance
depositbalance currency Deposit Balance
entity select Customer
externalid select External ID
internalid integer Internal ID
isprimarysub checkbox Primary (Y/N)
primarycurrency select Primary Currency
subsidiary select Subsidiary
unbilledorders currency Unbilled Orders