ARCUST
Customer
Sales customer
Properties
APINVDETs (
APINVDET, reference, collection)
Invoice details ARCONTACTSs (
ARCONTACTS, reference, collection)
Contacts ARCUSCCs (
ARCUSCC, reference, collection)
ARCUSCCs ARCUSDETs (
ARCUSDET, reference, collection)
ARCUSDETs ARCUSSITEs (
ARCUSSITES, reference, collection)
ARCUSSITEs ARCUSTAXDETs (
ARCUSTAXDET, reference, collection)
Tax details ARCUSTAXs (
ARCUSTAX, reference, collection)
Tax exemptions ARCUSTs (
ARCUST, reference, collection)
Customers ARINVDETs (
ARINVDET, reference, collection)
Invoice details ARINVPMTs (
ARINVPMT, reference, collection)
ARINVPMTs ARQTs (
ARQT, reference, collection)
Proposals ARSHIPs (
ARSHIP, reference, collection)
Shipments AUTOID (
EbmsAutoID, String, read-only)
Auto IDThe id that identifies the record in EBMS Balance (
Currency, Decimal, virtual, read-only)
BalanceCustomer's current balance BANK_ROUTE (
EbmsText, String)
Routing number BillingARINVs (
ARINV, reference, collection)
Billing invoices BillingTanks (
ARFBTANK, reference, collection)
Billing tanks CASH (
Option, Boolean)
Allow payment by cash CHARGE (
EbmsFormulaText, String)
Sales due termFormula for determining how a customer is charged for payment CHARGEDFLT (
Option, Boolean)
Charge by defaultCharge customer by default instead of requiring payment CHARGEPYMT (
Option, Boolean)
Allow payment by charge CHECK (
Option, Boolean)
Allow payment by check CRED_LIM (
Currency, Decimal)
Credit limitMaximum amount of credit allowed CREDITCARD (
Boolean, Boolean)
Allow payment by credit card DEF_CLI_ID (
EbmsText, String)
Default CLI id DIRECTIONS (
MultilineText, String)
DirectionsSpecific directions to the customer's location DISCOUNT (
EbmsFormulaText, String)
Sales discount termFormula for determining what type of discount the customer is eligible for DocumentsPath (
String, String, virtual, read-only)
Documents path DocumentsStatus (
String, String, virtual, read-only)
Documents status E_DATE (
DateDefaultedToday, Nullable`1, required)
Date enteredThe date the record was created EC_RPT_NO (
Integer, Int32)
Report number EC_RPT_PDF (
BlobInfo, BlobInfo)
EC_RPT_PDF EC_RPT_RUN (
Boolean, Boolean)
EC_RPT_RUN EMAIL_LIST (
Boolean, Boolean)
Include in email list EXTERNALID (
EbmsText, String)
External ID F_NAME (
EbmsName, String)
First nameCustomer First Name FC_RATE (
Decimal, Decimal)
Finance charge rate GPS_ADD1 (
Text, String)
GPS address 1 GPS_ADD2 (
Text, String)
GPS address 2 ID (
EbmsNaturalKey, String, required)
Customer IDThe ID of the customer IDCHARGE (
EbmsID, String)
Charge formula id IDCHARGE_Reference (
ChargeFormula, reference)
Charge formulaCustomer charge formula IDDISCOUNT (
EbmsID, String)
Discount formula id IDDISCOUNT_Reference (
DiscountFormula, reference)
Discount formulaCustomer discount formula IDGRACE (
EbmsID, String)
Grace formula id IDGRACE_Reference (
GraceFormula, reference)
Grace formulaGrace period formula IN_LEVEL (
EbmsID, String)
Price level id IN_LEVEL_Reference (
INPRICE, reference, required)
Price levelDefault inventory price level for this customer's invoices INACTIVE (
Option, Boolean)
InactiveNot an active customer INREDETs (
INREDET, reference, collection)
INREDETs INREs (
INRE, reference, collection)
INREs IsApplicable (
Boolean, Boolean, virtual, read-only)
Is applicableIs this home view applicable to the user IsDeleted (
Boolean, Boolean, virtual, read-only)
IsDeleted IsNewEntity (
Boolean, Boolean, virtual)
Is new entityA virtual property that we can base computes off of to show if an entity is virtual JCJBArchitects (
JCJB, reference, collection)
JCJB architects JCJBContractors (
JCJB, reference, collection)
JCJB contractors JCJBs (
JCJB, reference, collection)
Jobs L_NAME (
EbmsNameLast, String)
Last nameCustomer Last Name or Company Name MAIL_LIST (
Option, Boolean)
Include in mail list MEMO (
MultilineText, String)
MemoGeneral notes about this customer MIN_FC (
Currency, Decimal)
Minimum finance charge NAMESTR (
Text, String)
Name string NonEmptyContacts (
ARCONTACTS, reference, collection, virtual)
Contacts Order (
RowOrder, Decimal, virtual, read-only)
OrderOrder to place this home view in relative to other home views OUT_CITY (
Boolean, Boolean)
Outside city limits PayOrders (
ARINV, reference, collection, virtual, read-only)
Pay ordersProperty is needed for web queries PayProcessedInvoices (
ARINV, reference, collection, virtual, read-only)
Pay processed invoicesThis is needed for Web requests SALESMAN (
EbmsID, String)
Salesman ID SALESMAN_Reference (
ARSALESP, reference)
Salesman SAVINGS (
Savings, Savings)
Account type SHIP_TO (
EbmsIDSearch, String)
Ship to idThe customer id that this customer's invoices should be shipped to SHIP_TO_Reference (
ARCUST, reference)
Ship toThe customer that this customer's invoices should be shipped to ShippingAPINVs (
APINV, reference, collection)
Shipping invoices ShippingARINVs (
ARINV, reference, collection)
Shipping invoices ShippingARQTs (
ARQT, reference, collection)
Shipping arq ts ShippingTanks (
ARFBTANK, reference, collection)
Shipping tanks TASKs (
TASK, reference, collection)
Tasks Title (
Title, String, virtual, read-only)
Title TYPE (
EbmsType, String)
TypeMiscellaneous information field.
Version 1.5.47, Updated on Tuesday, March 14, 2023
Creating a new customer
POSThttps://ecc123456789012345.servicebus.windows.net/MyEbms/ABC/OData/ARCUST
{
"TREE_ID": "123",
"ID": "DOEJOH",
"F_NAME": "John",
"L_NAME": "Doe",
"ADDRESS1": "123 Main Street",
"ADDRESS2": "Apt 5",
"ZIP": "12345",
"PHONE": "1234567890",
"EMAIL": "johndoe@outlook.com",
"MEMO": "Multi-line memo \r\nWrite a book in here"
}