Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/18
Table Type: Company
Table Name: Customer
Database Table Name: CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972
Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Customer can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972]
Show/hide an example select of all columns by name
SELECT
[timestamp]
,[No_]
,[Name]
,[Search Name]
,[Name 2]
,[Address]
,[Address 2]
,[City]
,[Contact]
,[Phone No_]
,[Telex No_]
,[Document Sending Profile]
,[Ship-to Code]
,[Our Account No_]
,[Territory Code]
,[Global Dimension 1 Code]
,[Global Dimension 2 Code]
,[Chain Name]
,[Budgeted Amount]
,[Credit Limit (LCY)]
,[Customer Posting Group]
,[Currency Code]
,[Customer Price Group]
,[Language Code]
,[Statistics Group]
,[Payment Terms Code]
,[Fin_ Charge Terms Code]
,[Salesperson Code]
,[Shipment Method Code]
,[Shipping Agent Code]
,[Place of Export]
,[Invoice Disc_ Code]
,[Customer Disc_ Group]
,[Country_Region Code]
,[Collection Method]
,[Amount]
,[Blocked]
,[Invoice Copies]
,[Last Statement No_]
,[Print Statements]
,[Bill-to Customer No_]
,[Priority]
,[Payment Method Code]
,[Last Modified Date Time]
,[Last Date Modified]
,[Application Method]
,[Prices Including VAT]
,[Location Code]
,[Fax No_]
,[Telex Answer Back]
,[VAT Registration No_]
,[Combine Shipments]
,[Gen_ Bus_ Posting Group]
,[Picture]
,[GLN]
,[Post Code]
,[County]
,[EORI Number]
,[Use GLN in Electronic Document]
,[E-Mail]
,[Home Page]
,[Reminder Terms Code]
,[No_ Series]
,[Tax Area Code]
,[Tax Liable]
,[VAT Bus_ Posting Group]
,[Reserve]
,[Block Payment Tolerance]
,[IC Partner Code]
,[Prepayment _]
,[Partner Type]
,[Image]
,[Privacy Blocked]
,[Disable Search by Name]
,[Preferred Bank Account Code]
,[Coupled to CRM]
,[Cash Flow Payment Terms Code]
,[Primary Contact No_]
,[Contact Type]
,[Mobile Phone No_]
,[Responsibility Center]
,[Shipping Advice]
,[Shipping Time]
,[Shipping Agent Service Code]
,[Service Zone Code]
,[Price Calculation Method]
,[Allow Line Disc_]
,[Base Calendar Code]
,[Copy Sell-to Addr_ to Qte From]
,[Validate EU Vat Reg_ No_]
,[Id]
,[Currency Id]
,[Payment Terms Id]
,[Shipment Method Id]
,[Payment Method Id]
,[Tax Area ID]
,[Contact ID]
,[Contact Graph Id]
,[Type of Supply Code]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972]
Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
[CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
ON
[Customer].[Territory Code] = [Territory].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
ON
[Customer].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Customer].[Currency Code] = [Currency].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
ON
[Customer].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
ON
[Customer].[Language Code] = [Language].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
ON
[Customer].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
ON
[Customer].[Salesperson Code] = [Salesperson_Purchaser].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
ON
[Customer].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
ON
[Customer].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
ON
[Customer].[Customer Disc_ Group] = [Customer Discount Group].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
ON
[Customer].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
ON
[Customer].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
ON
[Customer].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
ON
[Customer].[Location Code] = [Location].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Reminder Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Terms]
ON
[Customer].[Reminder Terms Code] = [Reminder Terms].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
ON
[Customer].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
[CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
ON
[Customer].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
ON
[Customer].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Type of Supply$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Type of Supply]
ON
[Customer].[Type of Supply Code] = [Type of Supply].[Code]
Show/hide columns in Customer table
Column ID | Column Name | Data Type | ||||
---|---|---|---|---|---|---|
1 | timestamp ![]() | timestamp | ||||
2 | No_ ![]() ![]() | nvarchar(40) | ||||
3 | Name ![]() | nvarchar(200) | ||||
4 | Search Name ![]() | nvarchar(200) | ||||
5 | Name 2 ![]() | nvarchar(100) | ||||
6 | Address ![]() | nvarchar(200) | ||||
7 | Address 2 ![]() | nvarchar(100) | ||||
8 | City ![]() | nvarchar(60) | ||||
9 | Contact ![]() | nvarchar(200) | ||||
10 | Phone No_ ![]() | nvarchar(60) | ||||
11 | Telex No_ ![]() | nvarchar(40) | ||||
12 | Document Sending Profile ![]() | nvarchar(40) | ||||
13 | Ship-to Code ![]() | nvarchar(20) | ||||
14 | Our Account No_ ![]() | nvarchar(40) | ||||
15 | Territory Code ![]() | nvarchar(20) | ||||
Key to join to the Territory table.Show/hide example querySELECT
[Customer].[Territory Code]
,[Territory].[Code]
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
[CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
ON
[Customer].[Territory Code] = [Territory].[Code] | ||||||
16 | Global Dimension 1 Code ![]() | nvarchar(40) | ||||
17 | Global Dimension 2 Code ![]() | nvarchar(40) | ||||
18 | Chain Name ![]() | nvarchar(20) | ||||
19 | Budgeted Amount ![]() | decimal(38,38) | ||||
20 | Credit Limit (LCY) ![]() | decimal(38,38) | ||||
21 | Customer Posting Group ![]() | nvarchar(40) | ||||
Key to join to the Customer Posting Group table.Show/hide example querySELECT
[Customer].[Customer Posting Group]
,[Customer Posting Group].[Code]
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
[CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
ON
[Customer].[Customer Posting Group] = [Customer Posting Group].[Code] | ||||||
22 | Currency Code ![]() | nvarchar(20) | ||||
Key to join to the Currency table.Show/hide example querySELECT
[Customer].[Currency Code]
,[Currency].[Code]
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Customer].[Currency Code] = [Currency].[Code] | ||||||
23 | Customer Price Group ![]() | nvarchar(20) | ||||
Key to join to the Customer Price Group table.Show/hide example querySELECT
[Customer].[Customer Price Group]
,[Customer Price Group].[Code]
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
[CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
ON
[Customer].[Customer Price Group] = [Customer Price Group].[Code] | ||||||
24 | Language Code ![]() | nvarchar(20) | ||||
Key to join to the Language table.Show/hide example querySELECT
[Customer].[Language Code]
,[Language].[Code]
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
ON
[Customer].[Language Code] = [Language].[Code] | ||||||
25 | Statistics Group ![]() | int | ||||
26 | Payment Terms Code ![]() | nvarchar(20) | ||||
Key to join to the Payment Terms table.Show/hide example querySELECT
[Customer].[Payment Terms Code]
,[Payment Terms].[Code]
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
[CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
ON
[Customer].[Payment Terms Code] = [Payment Terms].[Code] | ||||||
27 | Fin_ Charge Terms Code ![]() | nvarchar(20) | ||||
28 | Salesperson Code ![]() | nvarchar(40) | ||||
Key to join to the Salesperson_Purchaser table.Show/hide example querySELECT
[Customer].[Salesperson Code]
,[Salesperson_Purchaser].[No_]
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
[CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
ON
[Customer].[Salesperson Code] = [Salesperson_Purchaser].[No_] | ||||||
29 | Shipment Method Code ![]() | nvarchar(20) | ||||
Key to join to the Shipment Method table.Show/hide example querySELECT
[Customer].[Shipment Method Code]
,[Shipment Method].[Code]
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
[CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
ON
[Customer].[Shipment Method Code] = [Shipment Method].[Code] | ||||||
30 | Shipping Agent Code ![]() | nvarchar(20) | ||||
Key to join to the Shipping Agent table.Show/hide example querySELECT
[Customer].[Shipping Agent Code]
,[Shipping Agent].[Code]
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
[CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
ON
[Customer].[Shipping Agent Code] = [Shipping Agent].[Code] | ||||||
31 | Place of Export ![]() | nvarchar(40) | ||||
32 | Invoice Disc_ Code ![]() | nvarchar(40) | ||||
33 | Customer Disc_ Group ![]() | nvarchar(40) | ||||
Key to join to the Customer Discount Group table.Show/hide example querySELECT
[Customer].[Customer Disc_ Group]
,[Customer Discount Group].[No_]
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
[CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
ON
[Customer].[Customer Disc_ Group] = [Customer Discount Group].[No_] | ||||||
34 | Country_Region Code ![]() | nvarchar(20) | ||||
Key to join to the Country_Region table.Show/hide example querySELECT
[Customer].[Country_Region Code]
,[Country_Region].[Code]
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
[CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
ON
[Customer].[Country_Region Code] = [Country_Region].[Code] | ||||||
35 | Collection Method ![]() | nvarchar(40) | ||||
36 | Amount ![]() | decimal(38,38) | ||||
37 | Blocked ![]() | int | ||||
38 | Invoice Copies ![]() | int | ||||
39 | Last Statement No_ ![]() | int | ||||
40 | Print Statements ![]() | tinyint | ||||
41 | Bill-to Customer No_ ![]() | nvarchar(40) | ||||
42 | Priority ![]() | int | ||||
43 | Payment Method Code ![]() | nvarchar(20) | ||||
Key to join to the Payment Method table.Show/hide example querySELECT
[Customer].[Payment Method Code]
,[Payment Method].[Code]
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
[CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
ON
[Customer].[Payment Method Code] = [Payment Method].[Code] | ||||||
44 | Last Modified Date Time ![]() | datetime | ||||
45 | Last Date Modified ![]() | datetime | ||||
46 | Application Method ![]() | int | ||||
47 | Prices Including VAT ![]() | tinyint | ||||
48 | Location Code ![]() | nvarchar(20) | ||||
Key to join to the Location table.Show/hide example querySELECT
[Customer].[Location Code]
,[Location].[Code]
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
[CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
ON
[Customer].[Location Code] = [Location].[Code] | ||||||
49 | Fax No_ ![]() | nvarchar(60) | ||||
50 | Telex Answer Back ![]() | nvarchar(40) | ||||
51 | VAT Registration No_ ![]() | nvarchar(40) | ||||
52 | Combine Shipments ![]() | tinyint | ||||
53 | Gen_ Bus_ Posting Group ![]() | nvarchar(40) | ||||
54 | Picture ![]() | image | ||||
55 | GLN ![]() | nvarchar(26) | ||||
56 | Post Code ![]() | nvarchar(40) | ||||
57 | County ![]() | nvarchar(60) | ||||
58 | EORI Number ![]() | nvarchar(80) | ||||
59 | Use GLN in Electronic Document ![]() | tinyint | ||||
60 | E-Mail ![]() | nvarchar(160) | ||||
61 | Home Page ![]() | nvarchar(160) | ||||
62 | Reminder Terms Code ![]() | nvarchar(20) | ||||
Key to join to the Reminder Terms table.Show/hide example querySELECT
[Customer].[Reminder Terms Code]
,[Reminder Terms].[No_]
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
[CRONUS UK Ltd_$Reminder Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Terms]
ON
[Customer].[Reminder Terms Code] = [Reminder Terms].[No_] | ||||||
63 | No_ Series ![]() | nvarchar(40) | ||||
64 | Tax Area Code ![]() | nvarchar(40) | ||||
Key to join to the Tax Area table.Show/hide example querySELECT
[Customer].[Tax Area Code]
,[Tax Area].[Code]
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
[CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
ON
[Customer].[Tax Area Code] = [Tax Area].[Code] | ||||||
65 | Tax Liable ![]() | tinyint | ||||
66 | VAT Bus_ Posting Group ![]() | nvarchar(40) | ||||
67 | Reserve ![]() | int | ||||
68 | Block Payment Tolerance ![]() | tinyint | ||||
69 | IC Partner Code ![]() | nvarchar(40) | ||||
Key to join to the IC Partner table.Show/hide example querySELECT
[Customer].[IC Partner Code]
,[IC Partner].[Code]
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
[CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
ON
[Customer].[IC Partner Code] = [IC Partner].[Code] | ||||||
70 | Prepayment _ ![]() | decimal(38,38) | ||||
71 | Partner Type ![]() | int | ||||
72 | Image ![]() | uniqueidentifier | ||||
73 | Privacy Blocked ![]() | tinyint | ||||
74 | Disable Search by Name ![]() | tinyint | ||||
75 | Preferred Bank Account Code ![]() | nvarchar(40) | ||||
76 | Coupled to CRM ![]() | tinyint | ||||
77 | Cash Flow Payment Terms Code ![]() | nvarchar(20) | ||||
78 | Primary Contact No_ ![]() | nvarchar(40) | ||||
79 | Contact Type ![]() | int | ||||
80 | Mobile Phone No_ ![]() | nvarchar(60) | ||||
81 | Responsibility Center ![]() | nvarchar(20) | ||||
82 | Shipping Advice ![]() | int | ||||
83 | Shipping Time ![]() | varchar(32) | ||||
84 | Shipping Agent Service Code ![]() | nvarchar(20) | ||||
Key to join to the Shipping Agent Services table.Show/hide example querySELECT
[Customer].[Shipping Agent Service Code]
,[Shipping Agent Services].[Code]
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
[CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
ON
[Customer].[Shipping Agent Service Code] = [Shipping Agent Services].[Code] | ||||||
85 | Service Zone Code ![]() | nvarchar(20) | ||||
86 | Price Calculation Method ![]() | int | ||||
87 | Allow Line Disc_ ![]() | tinyint | ||||
88 | Base Calendar Code ![]() | nvarchar(20) | ||||
89 | Copy Sell-to Addr_ to Qte From ![]() | int | ||||
90 | Validate EU Vat Reg_ No_ ![]() | tinyint | ||||
91 | Id ![]() | uniqueidentifier | ||||
92 | Currency Id ![]() | uniqueidentifier | ||||
93 | Payment Terms Id ![]() | uniqueidentifier | ||||
94 | Shipment Method Id ![]() | uniqueidentifier | ||||
95 | Payment Method Id ![]() | uniqueidentifier | ||||
96 | Tax Area ID ![]() | uniqueidentifier | ||||
97 | Contact ID ![]() | uniqueidentifier | ||||
98 | Contact Graph Id ![]() | nvarchar(500) | ||||
99 | Type of Supply Code ![]() | nvarchar(20) | ||||
Key to join to the Type of Supply table.Show/hide example querySELECT
[Customer].[Type of Supply Code]
,[Type of Supply].[Code]
FROM
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
LEFT JOIN
[CRONUS UK Ltd_$Type of Supply$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Type of Supply]
ON
[Customer].[Type of Supply Code] = [Type of Supply].[Code] | ||||||
100 | $systemId ![]() | uniqueidentifier | ||||
101 | $systemCreatedAt ![]() | datetime | ||||
102 | $systemCreatedBy ![]() | uniqueidentifier | ||||
103 | $systemModifiedAt ![]() | datetime | ||||
104 | $systemModifiedBy ![]() | uniqueidentifier |
Show/hide tables related from Customer table
Country_RegionCurrencyCustomerCustomer Discount GroupCustomer Posting GroupCustomer Price GroupIC PartnerLanguageLocationPayment MethodPayment TermsReminder TermsSalesperson_PurchaserShipment MethodShipping AgentShipping Agent ServicesTax AreaTerritoryType of Supply
Show/hide tables related to Customer table
Contract Gain_Loss EntryCustomerCustomer AmountCustomer Bank AccountCustomer Templ_Cust_ Ledger EntryCust_ Ledger EntryDetailed Cust_ Ledg_ EntryDirect Debit Collection EntryFiled Contract LineFiled Service Contract HeaderFiled Service Contract HeaderFinance Charge Memo HeaderHandled IC Inbox Purch_ HeaderHandled IC Inbox Sales HeaderHandled IC Inbox Sales HeaderHandled IC Outbox Purch_ HdrHandled IC Outbox Sales HeaderHandled IC Outbox Sales HeaderIC Inbox Purchase HeaderIC Inbox Sales HeaderIC Inbox Sales HeaderIC Outbox Purchase HeaderIC Outbox Sales HeaderIC Outbox Sales HeaderIC PartnerInventory ProfileIssued Fin_ Charge Memo HeaderIssued Reminder HeaderJobJobLoaner EntryLP ML Input DataMy CustomerNative – PaymentO365 Sales DocumentPurchase HeaderPurchase Header ArchivePurch_ Cr_ Memo Hdr_Purch_ Inv_ HeaderPurch_ Rcpt_ HeaderReminder HeaderReminder_Fin_ Charge EntryRequisition LineReturn Receipt HeaderReturn Receipt HeaderReturn Receipt LineReturn Receipt LineReturn Shipment HeaderSales & Receivables SetupSales & Receivables SetupSales Cr_ Memo Entity BufferSales Cr_ Memo Entity BufferSales Cr_Memo HeaderSales Cr_Memo HeaderSales Cr_Memo LineSales Cr_Memo LineSales HeaderSales HeaderSales Header ArchiveSales Header ArchiveSales Invoice Entity AggregateSales Invoice Entity AggregateSales Invoice HeaderSales Invoice HeaderSales Invoice LineSales Invoice LineSales LineSales LineSales Line ArchiveSales Line ArchiveSales Order Entity BufferSales Order Entity BufferSales Price and Line Disc BuffSales Quote Entity BufferSales Quote Entity BufferSales Shipment HeaderSales Shipment HeaderSales Shipment LineSales Shipment LineSEPA Direct Debit MandateService Contract HeaderService Contract HeaderService Contract LineService Cr_Memo HeaderService Cr_Memo HeaderService Cr_Memo LineService Cr_Memo LineService HeaderService HeaderService Invoice HeaderService Invoice HeaderService Invoice LineService Invoice LineService ItemService Item LineService Ledger EntryService Ledger EntryService LineService LineService Shipment HeaderService Shipment HeaderService Shipment Item LineService Shipment LineService Shipment LineShip-to AddressStandard Customer Sales CodeUnplanned DemandWarranty Ledger EntryWarranty Ledger Entry