Skip to main content

Customer Account

Summary

A data record that stores information about a customer, such as their name, address, contact information, and payment terms. It can be used to link all of the customer's interactions with the company, such as sales orders, invoices, and payments.

Schema

Relationships

  1. CustomerAccount belongs to zero or one CustomerCategory
  2. CustomerAccount belongs to zero or one CustomerPriceGroup : belongsTo
  3. CustomerAccount belongs to zero or one CustomerStatus

Definitions

Customer Account

Data TypeField NameRulesAbout
StringaccountCodeZero or OneBusiness identifier for a customer account
BusinessPartnerbusinessPartnerOne to ManyThe collection of business partners internally referenced from within this class
CustomerCategorycustomerCategoryZero or OneUsed to group customers by various criteria
StringcustomerNameZero or OneThe name of the customer associated with this account.
CustomerPriceGroupcustomerPriceGroupZero or One
BusinessPartnerdefaultReceiverZero or OnePoints to the default receiver entry in the business partner object of this class
ExtensionFieldextendedByZero to ManyRefer to: Extension Field
ExternalIDexternalIdentityZero to ManyRefer to: External ID
BusinessPartnerpayerZero or OneInternal reference to the business partner record for the party responsible for payment
RecordedByUserrecordedByZero to ManyThe user who captured the sales order in the originating system.
BusinessPartnersellerZero or OneInternal reference to the business partner record for the sales organization
StringsourceSystemCodeZero or OneRefer to: Source System
StringsourceSystemIDZero or OneRefer to: Source System
StringsalesRepNameZero or OneThe name of the sales rep

CustomerCategory

Data TypeField NameRulesAbout
StringcodeExactly 1
StringdescriptionZero or One

CustomerPriceGroup

Data TypeField NameRulesAbout
StringcodeExactly 1

CustomerStatus

Data TypeField NameRulesAbout
StringcodeExactly 1Active or
StringdescriptionZero or One

Sample JSON

{
"schemaName": "limber",
"schemaVersion": "2.1.0",
"shapeName": "CustomerAccount",
"dataId": {
"@type": "DataReference",
"schemaName": "limber",
"shapeName": "CustomerAccount",
"iri": "https://schema.limbergraph.com/limber/CustomerAccount#25679298-b31c-4090-94a8-1ed3d37e1637",
"externalIdentities": [
{
"integrationKey": "SapS4",
"externalId": "1000058::6900::10::00"
}
],
"keys": [
{
"accountCode": "SapS4-1000058::6900::10::00"
},
{
"uniqueText": "25679298-b31c-4090-94a8-1ed3d37e1637"
}
],
"label": "SapS4-1000058::6900::10::00"
},
"dataAction": "PUBLISH",
"mode": "LIVE",
"integrationKey": "SapS4",
"correlationId": "16c2a9c0-fc65-46ed-bb5a-17281dc380b7",
"data": {
"@type": "CustomerAccount",
"externalIdentity": [
{
"@type": "ExternalID",
"internalType": "CustomerAccount",
"externalSystemCode": "SapS4",
"externalId": "1000058::6900::10::00"
}
],
"extendedBy": [
{
"@type": "ExtensionField",
"key": "customerNumber",
"value": ["1000058"],
"uniqueText": "34def81f-7d2e-42cd-a82e-18c0d7ed197d"
},
{
"@type": "ExtensionField",
"key": "customerPriceGroup",
"value": ["Z0"],
"uniqueText": "79a29e30-0b5a-4ed2-b3a5-9fe8568e8d63"
},
{
"@type": "ExtensionField",
"key": "previousCustomerNumber",
"value": ["N001807"],
"uniqueText": "8c57782d-567d-43db-86a9-0ef1368258f7"
}
],
"attributeField": [
{
"@type": "AttributeField",
"key": "Division",
"attributeValue": [
{
"@type": "DataReference",
"schemaName": "limber",
"shapeName": "AttributeValue",
"iri": "https://schema.limbergraph.com/limber/AttributeValue#0783f18a-c0c6-4df1-864d-8524b3ba5516",
"externalIdentities": [
{
"integrationKey": "SapS4",
"externalId": "Division::00"
}
],
"keys": [
{
"discriminant": "Division",
"code": "00"
},
{
"uniqueText": "0783f18a-c0c6-4df1-864d-8524b3ba5516"
}
],
"label": "Flooring"
}
],
"uniqueText": "2f04f8cb-903e-41d1-9a7d-83cc0e3cf803"
},
{
"@type": "AttributeField",
"key": "distributionChannel",
"attributeValue": [
{
"@type": "DataReference",
"schemaName": "limber",
"shapeName": "AttributeValue",
"iri": "https://schema.limbergraph.com/limber/AttributeValue#19c02c8c-88b1-474f-b8d7-c34746864b1b",
"externalIdentities": [
{
"integrationKey": "SapS4",
"externalId": "DistributionChannel::10"
}
],
"keys": [
{
"discriminant": "DistributionChannel",
"code": "10"
},
{
"uniqueText": "19c02c8c-88b1-474f-b8d7-c34746864b1b"
}
],
"label": "Wholesale"
}
],
"uniqueText": "a2acde6c-69cb-4dc9-9021-47c87888002c"
},
{
"@type": "AttributeField",
"key": "CustomerGroup",
"attributeValue": [
{
"@type": "DataReference",
"schemaName": "limber",
"shapeName": "AttributeValue",
"iri": "https://schema.limbergraph.com/limber/AttributeValue#6c8a19ce-18e8-4cfd-a3cd-cf0d35ab3f07",
"externalIdentities": [
{
"integrationKey": "SapS4",
"externalId": "CustomerGroup::05"
}
],
"keys": [
{
"discriminant": "CustomerGroup",
"code": "05"
},
{
"uniqueText": "6c8a19ce-18e8-4cfd-a3cd-cf0d35ab3f07"
}
],
"label": "Flooring Other"
}
],
"uniqueText": "a1137dac-afb7-4d2e-b302-f64867ce89c9"
},
{
"@type": "AttributeField",
"key": "AnalyticalCustomerGroup",
"attributeValue": [
{
"@type": "DataReference",
"schemaName": "limber",
"shapeName": "AttributeValue",
"iri": "https://schema.limbergraph.com/limber/AttributeValue#47ed026f-96e7-4b0e-abe4-95cd3d13cec3",
"externalIdentities": [
{
"integrationKey": "SapS4",
"externalId": "AdditionalCustomerGroup1::A56"
}
],
"keys": [
{
"discriminant": "AdditionalCustomerGroup1",
"code": "A56"
},
{
"uniqueText": "47ed026f-96e7-4b0e-abe4-95cd3d13cec3"
}
],
"label": "Flooring Other"
}
],
"uniqueText": "7916aabf-b753-4b11-9668-643a1407a59b"
},
{
"@type": "AttributeField",
"key": "AccountsReceivableCustomerGroup",
"attributeValue": [
{
"@type": "DataReference",
"schemaName": "limber",
"shapeName": "AttributeValue",
"iri": "https://schema.limbergraph.com/limber/AttributeValue#36a3562f-fd27-4bae-9500-6d1cf6ac815c",
"externalIdentities": [
{
"integrationKey": "SapS4",
"externalId": "AdditionalCustomerGroup2::D01"
}
],
"keys": [
{
"discriminant": "AdditionalCustomerGroup2",
"code": "D01"
},
{
"uniqueText": "36a3562f-fd27-4bae-9500-6d1cf6ac815c"
}
],
"label": "Other"
}
],
"uniqueText": "806c4d79-6e95-4772-89ad-bf9ddead0e5d"
},
{
"@type": "AttributeField",
"key": "ForecastingCustomerGroup",
"attributeValue": [
{
"@type": "DataReference",
"schemaName": "limber",
"shapeName": "AttributeValue",
"iri": "https://schema.limbergraph.com/limber/AttributeValue#b5579ee2-4dd9-4692-b926-c30fce51a1d2",
"externalIdentities": [
{
"integrationKey": "SapS4",
"externalId": "AdditionalCustomerGroup4::I21"
}
],
"keys": [
{
"discriminant": "AdditionalCustomerGroup4",
"code": "I21"
},
{
"uniqueText": "b5579ee2-4dd9-4692-b926-c30fce51a1d2"
}
],
"label": "Flooring Other"
}
],
"uniqueText": "58c995f5-2b96-4f5f-84d2-620c80ba0540"
}
],
"sourceSystemCode": "SapS4",
"sourceSystemId": "1000058::6900::10::00",
"recordedBy": [
{
"@type": "RecordedByUser",
"externalSystemCode": "SapS4",
"createdByUserCode": "CB9980000170",
"modifiedByUserCode": "CB9980003692",
"createdOn": "2020-01-29T14:50:51Z",
"modifiedOn": "2023-04-26T16:09:42Z",
"uniqueText": "110c90e4-8994-4467-803e-3c6bf97cccca"
}
],
"accountCode": "SapS4-1000058::6900::10::00",
"seller": {
"@type": "InternalReference",
"id": "ab46952e-e1ec-4f1d-a1a0-0227ef87fb9a",
"className": "BusinessPartner",
"externalIdentities": [
{
"integrationKey": "SapS4",
"externalId": "6900"
}
],
"keys": [
{
"uniqueText": "ab46952e-e1ec-4f1d-a1a0-0227ef87fb9a"
}
]
},
"payer": {
"@type": "InternalReference",
"id": "8dec582b-b370-424f-88c8-bb7ba94d5dd4",
"className": "BusinessPartner",
"externalIdentities": [
{
"integrationKey": "SapS4",
"externalId": "1000058"
}
],
"keys": [
{
"uniqueText": "8dec582b-b370-424f-88c8-bb7ba94d5dd4"
}
]
},
"businessPartner": [
{
"@type": "BusinessPartner",
"externalIdentity": [
{
"@type": "ExternalID",
"internalType": "BusinessPartner",
"externalSystemCode": "SapS4",
"externalId": "1000058"
}
],
"extendedBy": [
{
"@type": "ExtensionField",
"key": "isActive",
"value": ["true"],
"uniqueText": "88dd7259-62cb-4ed1-be1e-b02b76b53dd2"
}
],
"emailAddress": {
"@type": "EmailAddress",
"email": "[email protected]",
"uniqueText": "2525da8b-de38-475a-9b2c-7ef01307574c"
},
"phoneAddress": {
"@type": "PhoneAddress",
"addressType": {
"@type": "DataReference",
"schemaName": "limber",
"shapeName": "PhoneAddressType",
"iri": "https://schema.limbergraph.com/limber/PhoneAddressType#Landline",
"keys": [
{
"code": "Landline"
}
],
"label": "Landline"
},
"phoneNumber": "021 123 4567",
"uniqueText": "7c9e5066-6879-4214-988c-05f6edb17bb2"
},
"physicalAddress": {
"@type": "PhysicalAddress",
"line1": "1",
"line2": "Some Road",
"regionName": "CAN",
"postalCode": "7400",
"cityName": "Somewhere",
"country": {
"@type": "DataReference",
"schemaName": "limber",
"shapeName": "Country",
"iri": "https://schema.limbergraph.com/limber/Country#NZ",
"keys": [
{
"uniqueText": "NZ"
}
],
"label": "New Zealand"
},
"uniqueText": "8d7e6756-0c40-41bd-92fc-54d6acd16872"
},
"primaryName": "Some Company Name on 26.04.20",
"businessPartnerRole": [
{
"@type": "DataReference",
"schemaName": "limber",
"shapeName": "BusinessPartnerRole",
"iri": "https://schema.limbergraph.com/limber/BusinessPartnerRole#Receiver",
"keys": [
{
"code": "Receiver"
}
],
"label": "Receiver"
},
{
"@type": "DataReference",
"schemaName": "limber",
"shapeName": "BusinessPartnerRole",
"iri": "https://schema.limbergraph.com/limber/BusinessPartnerRole#Buyer",
"keys": [
{
"code": "Buyer"
}
],
"label": "Buyer"
},
{
"@type": "DataReference",
"schemaName": "limber",
"shapeName": "BusinessPartnerRole",
"iri": "https://schema.limbergraph.com/limber/BusinessPartnerRole#Payer",
"keys": [
{
"code": "Payer"
}
],
"label": "Payer"
}
],
"uniqueText": "8dec582b-b370-424f-88c8-bb7ba94d5dd4"
},
{
"@type": "BusinessPartner",
"externalIdentity": [
{
"@type": "ExternalID",
"internalType": "BusinessPartner",
"externalSystemCode": "SapS4",
"externalId": "6900"
}
],
"code": "6900",
"primaryName": "NZ Sale Org",
"businessPartnerRole": [
{
"@type": "DataReference",
"schemaName": "limber",
"shapeName": "BusinessPartnerRole",
"iri": "https://schema.limbergraph.com/limber/BusinessPartnerRole#Seller",
"keys": [
{
"code": "Seller"
}
],
"label": "Seller"
}
],
"uniqueText": "ab46952e-e1ec-4f1d-a1a0-0227ef87fb9a"
}
],
"uniqueText": "25679298-b31c-4090-94a8-1ed3d37e1637",
"@version": 2,
"salesRepName": "John Smith"
},
"storeKey": "limber",
"stats": {
"label": "getData",
"time": 251,
"minTime": 251,
"maxTime": 251,
"count": 1,
"items": {
"prepare": {
"label": "prepare",
"time": 181,
"minTime": 181,
"maxTime": 181,
"count": 1
},
"retrieve": {
"label": "retrieve",
"time": 61,
"minTime": 61,
"maxTime": 61,
"count": 1,
"items": {
"byPrimaryKey": {
"label": "byPrimaryKey",
"time": 61,
"minTime": 61,
"maxTime": 61,
"count": 1
}
}
},
"provideReferences": {
"label": "provideReferences",
"time": 9,
"minTime": 9,
"maxTime": 9,
"count": 1,
"items": {
"provideExternalReferences": {
"label": "provideExternalReferences",
"time": 9,
"minTime": 9,
"maxTime": 9,
"count": 1
},
"filterInternalReferences": {
"label": "filterInternalReferences",
"time": 0,
"minTime": 0,
"maxTime": 0,
"count": 1
},
"filterExternalReferences": {
"label": "filterExternalReferences",
"time": 0,
"minTime": 0,
"maxTime": 0,
"count": 1
}
}
}
}
}
}