XAF Customer and Vendor Information

The <customerSupplier> element includes information about the debtors and creditors with whom your company had transactions in a given period. The information is sourced from the customer or vendor record. To view a customer or vendor record, go to Lists > Relationships > Customers, or Lists > Relationships > Vendors.

Tag Name	Source Information
custSupID	Entry in the Customer ID or Vendor ID field (entityid) on the customer or vendor record, respectively.
custSupName	Entry in the Company Name (companyname) field on the customer or vendor record.
contact	Entry in the Contact (entityid) field on the Relationships subtab of the customer or vendor record.
telephone	Entry in the Phone (phone) field on the customer or vendor record.
fax	Entry in the Fax (fax) field on the customer or vendor record.
eMail	Entry in the Email (email) field on the customer or vendor record.
website	Entry in the Web Address (url) field on the customer or vendor record.
taxRegistrationCountry	If your NetSuite account is using SuiteTax, the data is derived from the entry in the Country column under Tax Registrations on the Financial subtab of the customer or vendor record. The XAF report only displays the country code even if the country is spelled out in the Country column. If, on the Financial subtab, the Default Tax Reg. field is empty, then this tag will not be filled in the XAF report. If your NetSuite account is not using SuiteTax, the data is derived from the country code in the tax registration number entered in the Tax Reg. Number field on the Financial subtab of the customer or vendor record.
taxRegIdent	If your NetSuite account is using SuiteTax, the data is sourced from the entry in the Default Tax. Reg. (defaulttagreg) column under Tax Registrations on the Financial subtab of the customer or vendor record. If your NetSuite account is not using SuiteTax, the data is sourced from the entry in the Tax Reg. Number field on the Financial subtab of the customer or vendor record.
custSupTp	Filled in with any of the following codes: B – If on the vendor record, the field Other Relationships on the Relationships subtab is filled in with Customer, or if on the customer record, the field Other Relationships is filled in with Vendor C – If the entity is entered on a customer record. You can find customer records at Lists > Relationships > Customers O – If the entity is entered on an Other Name record. You can find these records at Lists > Relationships > Other Names. S – This code refers to supplier and is used if the entity is entered on a vendor record. You can find vendor records at Lists > Relationships > Vendors.
custCreditLimit	Entry in the Credit Limit field on the Financial subtab of the customer record.
supplierLimit	Entry in the Credit Limit field on the Financial subtab of the vendor record.

Tag Name

Source Information

custSupID

Entry in the Customer ID or Vendor ID field (entityid) on the customer or vendor record, respectively.

custSupName

Entry in the Company Name (companyname) field on the customer or vendor record.

contact

Entry in the Contact (entityid) field on the Relationships subtab of the customer or vendor record.

telephone

Entry in the Phone (phone) field on the customer or vendor record.

fax

Entry in the Fax (fax) field on the customer or vendor record.

Entry in the Email (email) field on the customer or vendor record.

website

Entry in the Web Address (url) field on the customer or vendor record.

taxRegistrationCountry

If your NetSuite account is using SuiteTax, the data is derived from the entry in the Country column under Tax Registrations on the Financial subtab of the customer or vendor record. The XAF report only displays the country code even if the country is spelled out in the Country column. If, on the Financial subtab, the Default Tax Reg. field is empty, then this tag will not be filled in the XAF report.

If your NetSuite account is not using SuiteTax, the data is derived from the country code in the tax registration number entered in the Tax Reg. Number field on the Financial subtab of the customer or vendor record.

taxRegIdent

If your NetSuite account is using SuiteTax, the data is sourced from the entry in the Default Tax. Reg. (defaulttagreg) column under Tax Registrations on the Financial subtab of the customer or vendor record.

If your NetSuite account is not using SuiteTax, the data is sourced from the entry in the Tax Reg. Number field on the Financial subtab of the customer or vendor record.

custSupTp

Filled in with any of the following codes:

B – If on the vendor record, the field Other Relationships on the Relationships subtab is filled in with Customer, or if on the customer record, the field Other Relationships is filled in with Vendor
C – If the entity is entered on a customer record. You can find customer records at Lists > Relationships > Customers
O – If the entity is entered on an Other Name record. You can find these records at Lists > Relationships > Other Names.
S – This code refers to supplier and is used if the entity is entered on a vendor record. You can find vendor records at Lists > Relationships > Vendors.

custCreditLimit

Entry in the Credit Limit field on the Financial subtab of the customer record.

supplierLimit

Entry in the Credit Limit field on the Financial subtab of the vendor record.

Customer and Vendor Address Information

The <streetAddress> and <postalAddress> tags in the <customerSupplier> element include your debtors' and creditors' address information. The data in the <streetAddress> tag are sourced from the Address (addrtext) field that is marked as the default billing address. You can find this field on the Address subtab of the customer or vendor record.

The data<postalAddress> tag is sourced from the Address (addrtext) field that is marked as the default shipping address. For information about the specific fields, where this information is sourced, see Field Sources for Entity Addresses.

Customer and Vendor Bank Account Information

The <bankAccount> element includes the bank account details of your debtors and creditors. The data is sourced from the Bank Payment Details subtab on the customer or vendor record.

Tag Name	Source Information
bankAccNr	Entry in the Bank Account Number (custpage_eft_custrecord_2663_entity_acct_no) field on the Bank Details page. If this field is empty, the data is obtained from the IBAN (custpage_eft_custrecord_2663_entity_iban) field.
bankIdCd	Entry in the Bank Number (custpage_eft_custrecord_2663_entity_bank_no) field on the Bank Details page. If this field is empty, the data is obtained from the BIC (custpage_eft_custrecord_2663_entity_bic) field.

Tag Name

Source Information

bankAccNr

Entry in the Bank Account Number (custpage_eft_custrecord_2663_entity_acct_no) field on the Bank Details page.

If this field is empty, the data is obtained from the IBAN (custpage_eft_custrecord_2663_entity_iban) field.

bankIdCd

Entry in the Bank Number (custpage_eft_custrecord_2663_entity_bank_no) field on the Bank Details page.

If this field is empty, the data is obtained from the BIC (custpage_eft_custrecord_2663_entity_bic) field.

Note:

If Bank Account Number and Bank Number fields are not filled, then the <bankAccount> tag will not be included in the XAF report.

Customer and Vendor Address Information

Customer and Vendor Bank Account Information

Related Topics: