ARQT

Sales quote

Properties

ACC_BY (EbmsName, String)
Approval person
Person who approved the quote
ACC_DATE (Date, Nullable`1)
Quote approval date
Date that job was approved
AppName (Text, String, virtual)
App name
ARQTDETs (ARQTDET, reference, collection)
Quote details
ArqtReason (ARQTRSN, reference, virtual)
Reason
Reasons for not accepting the proposal
AUTOID (EbmsAutoID, String, read-only)
Auto ID
The ID that identifies the record in EBMS
B_ADDRESS1 (EbmsAddress, String)
Customer address line 1
1st address of Customer
B_ADDRESS2 (EbmsAddress, String)
Customer address line 2
2nd address of Customer
B_CITY (EbmsCity, String)
City
Address City
B_COUNTRY (EbmsCountry, String)
Country
B_ID (EbmsIDSearch, String)
Customer ID
B_ID_Reference (ARCUST, reference)
Billing customer
B_NAME (EbmsText, String)
Name
Name of Customer
B_STATE (EbmsState, String)
State
Address State
B_ZIP (EbmsPostalCode, String)
Postal code
Address zip code
Barcode (Barcode, String, virtual)
Barcode
BarcodeType (Text, String, virtual)
Barcode type
C_ADDRESS1 (EbmsAddress, String)
Shipping address line 1
C_ADDRESS2 (EbmsAddress, String)
Shipping address line 2
C_CITY (EbmsCity, String)
Shipping city
C_COUNTRY (EbmsCountry, String)
Shipping country
C_ID (EbmsIDSearch, String)
Ship to
C_ID_Reference (ARCUST, reference)
Shipping customer
C_NAME (EbmsText, String)
Shipping name
C_STATE (EbmsState, String)
Shipping state
C_ZIP (EbmsPostalCode, String)
Shipping postal code
CHG_ORDER (Boolean, Boolean)
Change Order
cmdAccept (ARQTCmdAccept, Accept)
Accept
cmdAcceptAndChangeTerms (ARQTCmdAcceptAndChangeTerms, AcceptAndChangeTerms)
Accept and change terms
For web
cmdCalculateFreight (ISalesDocCmdCalculateFreight, CalculateFreight)
Estimate shipping
cmdClose (ARQTCmdClose, Close)
Close
cmdGetHiddenColumns (ISalesDocCmdGetHiddenColumns, GetHiddenColumns)
Get hidden columns
cmdGetPdfReport (ARQTCmdGetPdfReport, GetPdfReport)
Get pdf report
This is needed for Web
cmdRecalculateAllPrices (ISalesDocCmdRecalculateAllPrices, RecalculateAllPrices)
Recalculate all prices
cmdSend (ISendableCmdSend, Send)
Send now
cmdSetStatus (ARQTCmdSetStatus, SetStatus)
Set status
Accept, Close, or Reopen a proposal, including other details as necessary.
cmdSign (ISignableCmdSign, Sign)
Sign
Add signature
cmdUpdateLocked (ILockableCmdUpdateLocked, UpdateLocked)
Update locked
read the DBDOCLOCK and check if this entity is locked
cmdUseBarcode (IBarcodeScannerCmdUseBarcode, UseBarcode)
Use barcode
CONID_1 (EbmsText, String)
CONID_1
CONID_2 (EbmsText, String)
CONID_2
CONID_3 (EbmsText, String)
CONID_3
CONID_4 (EbmsText, String)
CONID_4
CONID_5 (EbmsText, String)
CONID_5
CONTACT_1 (EbmsText, String)
CONTACT_1
CONTACT_2 (EbmsText, String)
CONTACT_2
CONTACT_3 (EbmsText, String)
CONTACT_3
CONTACT_4 (EbmsText, String)
CONTACT_4
CONTACT_5 (EbmsText, String)
CONTACT_5
CONTACT_D (Date, Nullable`1)
Next Contact
DAYSVALID (SmallPositiveInteger, Int32)
Valid quote days
DEF_DEPT (EbmsDepartment, String)
Department ID
DEF_DEPT_Reference (ReadOnlyGLDEPT, reference)
Department
DESCR (EbmsDescription, String)
Description
Details (ARQTDET, reference, collection, virtual)
Details
Top-level details
DISCOUNT (EbmsFormulaText, String)
Discount
Discount Terms associated with the quote
DocumentsBrowser (ServerFileBrowser, reference, virtual, read-only)
Documents browser
DocumentsPath (String, String, virtual, read-only)
Documents path
DocumentsStatus (String, String, virtual, read-only)
Documents status
DocumentSummaryText (BasicHtmlCompact, String, virtual)

DUE (EbmsFormulaText, String)
Sales due term
Net Terms associated with this quote
EC_RPT_ERR (EbmsMemo, String)
EC_RPT_ERR
EC_RPT_NO (Integer, Int32)
Report number
EC_RPT_PDF (BlobInfo, BlobInfo)
EC_RPT_PDF
EC_RPT_RUN (Boolean, Boolean)
EC_RPT_RUN
EXTERNALID (EbmsText, String)
External ID
FREIGHT (Currency, Decimal)
Freight
Amount of freight
HANDLING (Currency, Decimal)
Handling
Handling fee
HiddenColumns (Text, String, collection, virtual)
Hidden columns
HOURS (ReadOnlyDecimal, Decimal, read-only)
Hours
IDDISCOUNT (EbmsID, String)
Iddiscount
IDDISCOUNT_Reference (DiscountFormula, reference)
Discount reference
IDDUE (EbmsID, String)
IDDUE
IDDUE_Reference (ChargeFormula, reference)
Sales due reference
INTERNALNT (MultilineText, String)
Internal notes
INVOICE (EbmsIDSearch, String, read-only)
Most recent invoice number
INVOICE_Reference (ARINVHyperlink, reference, read-only)
Most recent invoice
IsAccepted (Boolean, Boolean, virtual)
Accepted
IsClosed (Boolean, Boolean, virtual)
Not accepted
IsDeleted (Boolean, Boolean, virtual, read-only)
Is deleted
IsLocked (Boolean, Boolean, virtual)
Locked
IsNewEntity (Boolean, Boolean, virtual)
Is new entity
A virtual property that we can base computes off of to show if an entity is virtual
JOB_ID (EbmsIDSearch, String)
Job ID
JOB_ID_Reference (JCJB, reference, virtual)
Job
LEVEL (EbmsID, String)
Level ID
LEVEL_Reference (INPRICE, reference)
Level
MAN_TAX (ReadOnlyBoolean, Boolean)
Manual tax
Select sales tax manually
MEMO (MultilineText, String)
Memo
OtherReasonText (EbmsText, String, virtual)
Other reason text
PO_NO (EbmsType, String)
PO number/Job
Customer PO number
PROFIT (ReadOnlyDecimal, Decimal, read-only)
Profit
PUR_COST (ReadOnlyDecimal, Decimal)
Cost
Total of costs
QT_DATE (DateDefaultedToday, Nullable`1, required)
Quote date
Date of Quote
QUOTE (ReadOnlyEbmsNaturalKey, String, required)
Quote
Quote information and details
R_END (Date, Nullable`1)
Recurring End Date
R_LBILL (Date, Nullable`1)
Recurring Last Bill Date
R_NBILL (DateTime, Nullable`1)
R_NBILL
R_START (Date, Nullable`1)
Recurring Start Date
R_STATUS_V (EbmsText, String)
R_STATUS_V
RBCOUNT (Integer, Int32, read-only)
Number of Billings
RBDAYLIST (EbmsText, String)
Recurring these days of the week
RBDAYNAME (Integer, Int32)
Day name of the week
RBDAYNUM (Integer, Int32)
Day of the month
RBEVERYD (Days, Int32)
Recurring every number of days
RBEVERYM1 (Integer, Int32)
Recurring every number of months
RBEVERYM2 (Integer, Int32)
Recurring every number of months
RBEVERYW (Integer, Int32)
Recurring every number of weeks
RBEVERYY (Integer, Int32)
Recurring every number of years
RBMONTH (Integer, Int32)
Month of the year
RBSHOWDATE (Integer, Int32)
Add Bill Dates to Inovice
RBTIMEPER (Integer, Int32)
RBTIMEPER
RBWHICHDAY (Days, Int32)
Which day of the month
REASON (EbmsText, String)
Reason for not accepting
Reasons for not accepting the proposal
SALESMAN (EbmsIDSearch, String)
Sales man
SALESMAN_Field (EbmsPerson, String)
Sales person
Salesperson entering this invoice
SALESMAN_Reference (ARSALESP, reference)
Salesman
Salesperson associated with the Quote
SelectedDetail (ARQTDET, reference, virtual)
Selected detail
SHIP_DATE (Date, Nullable`1)
Ship date
SHIP_VIA (EbmsID, String)
Ship via ID
SHIP_VIA_Reference (ARSHVIA, reference)
Ship via
SHIPPING (PositiveDecimal, Decimal)
Shipping
ShowCost (Boolean, Boolean, virtual)
Show cost
SIGNATURE (Signature, BlobInfo)
Signature
STATUS (ReadOnlyARQTStatus, ARQTStatus)
Status
Subtitle (BasicHtmlCompact, String, virtual, read-only)
Subtitle
SUBTOTAL (ReadOnlyCurrency, Decimal)
Subtotal
Sum of goods sold
T_PERC (ReadOnlyDecimal, Decimal, read-only)
Percent {$INOPTION.MARG_MARK}
TAX_TABLE (EbmsDescription, String, read-only)
Table
Title (Title, String, virtual, read-only)
Title
TO_B_SENT (Boolean, Boolean)
To be sent
TOT_TAX (ReadOnlyDecimal, Decimal)
Total tax
TOT_WEIGHT (ReadOnlyDecimal, Decimal, read-only)
Weight
TOTAL (Currency, Decimal, read-only)
Invoice Total
Total amount due
TOTAL_ITEM (ReadOnlyDecimal, Decimal, read-only)
Shipped products
WAREHOUSE (EbmsIDSearch, String)
Warehouse
WAREHOUSE_Reference (INWH, reference)
Warehouse
Warehouse associated with this proposal