Documentation

The columns for the context order.

These are auto generated.

Technical name Display Selectable Searchable Type Entity
ORDER_ID Order ID Yes Yes Number
ORDER_NUMBER Order Number Yes Yes Text
ORDER_DESC Order Description Yes Yes Text
ORDER_MEMO Order Memo Yes Yes Text
ORDER_DATE Order Date Yes Yes Date
ORDER_STATUS Order Status Yes Yes Text
ORDER_STATUSDESC Order Status Description Yes No Text
ORDER_STATUSCODE Order Status# Yes No Text
ORDER_PRICE Order Price Yes Yes Currency
ORDER_CURRENCY Order Currency Yes Yes Text
ORDER_PAY_PRICE Order Paid Yes Yes Currency
ORDER_PAY_CURRENCY Order Pay Currency Yes Yes Text
ORDER_OPEN_PRICE Order To be paid Yes Yes Currency
ORDER_OPEN_CURRENCY Order Open Currency Yes Yes Text
CUSTOMER_ID Customer Id Yes Yes Number
COMPANY_ID Company # Yes Yes Text
CUST_FULLNAME Customer name Yes No Text Customer
CUST_INFORMALNAME Customer informal Yes No Text Customer
CREATED Created Yes Yes Datetime
UPDATED updated Yes Yes Datetime
ORD_LABELS Order Labels Yes Yes Text
CUST_LABELS Customer Labels Yes Yes Text Customer
COMP_LABELS Company Labels Yes Yes Text Company
CUST_CUSTOM01 Customer custom 01 Yes Yes Custom Customer
CUST_CUSTOM02 Customer custom 02 Yes Yes Custom Customer
CUST_CUSTOM03 Customer custom 03 Yes Yes Custom Customer
CUST_CUSTOM04 Customer custom 04 Yes Yes Custom Customer
CUST_CUSTOM05 Customer custom 05 Yes Yes Custom Customer
CUST_CUSTOM06 Customer custom 06 Yes Yes Custom Customer
CUST_CUSTOM07 Customer custom 07 Yes Yes Custom Customer
CUST_CUSTOM08 Customer custom 08 Yes Yes Custom Customer
CUST_CUSTOM09 Customer custom 09 Yes Yes Custom Customer
CUST_CUSTOM10 Customer custom 10 Yes Yes Custom Customer
CUST_CUSTOM11 Customer custom 11 Yes Yes Custom Customer
CUST_CUSTOM12 Customer custom 12 Yes Yes Custom Customer
CUST_CUSTOM13 Customer custom 13 Yes Yes Custom Customer
CUST_CUSTOM14 Customer custom 14 Yes Yes Custom Customer
CUST_CUSTOM15 Customer custom 15 Yes Yes Custom Customer
CUST_CUSTOM16 Customer custom 16 Yes Yes Custom Customer
CUST_CUSTOM17 Customer custom 17 Yes Yes Custom Customer
CUST_CUSTOM18 Customer custom 18 Yes Yes Custom Customer
CUST_CUSTOM19 Customer custom 19 Yes Yes Custom Customer
CUST_CUSTOM20 Customer custom 20 Yes Yes Custom Customer
CUST_CUSTOM21 Customer custom 21 Yes Yes Custom Customer
CUST_CUSTOM22 Customer custom 22 Yes Yes Custom Customer
CUST_CUSTOM23 Customer custom 23 Yes Yes Custom Customer
CUST_CUSTOM24 Customer custom 24 Yes Yes Custom Customer
CUST_CUSTOM25 Customer custom 25 Yes Yes Custom Customer
CUST_CUSTOM26 Customer custom 26 Yes Yes Custom Customer
CUST_CUSTOM27 Customer custom 27 Yes Yes Custom Customer
CUST_CUSTOM28 Customer custom 28 Yes Yes Custom Customer
CUST_CUSTOM29 Customer custom 29 Yes Yes Custom Customer
CUST_CUSTOM30 Customer custom 30 Yes Yes Custom Customer
CUST_CUSTOM31 Customer custom 31 Yes Yes Custom Customer
CUST_CUSTOM32 Customer custom 32 Yes Yes Custom Customer
CUST_CUSTOM33 Customer custom 33 Yes Yes Custom Customer
CUST_CUSTOM34 Customer custom 34 Yes Yes Custom Customer
CUST_CUSTOM35 Customer custom 35 Yes Yes Custom Customer
CUST_CUSTOM36 Customer custom 36 Yes Yes Custom Customer
CUST_CUSTOM37 Customer custom 37 Yes Yes Custom Customer
CUST_CUSTOM38 Customer custom 38 Yes Yes Custom Customer
CUST_CUSTOM39 Customer custom 39 Yes Yes Custom Customer
CUST_CUSTOM40 Customer custom 40 Yes Yes Custom Customer
CUST_CUSTOM41 Customer custom 41 Yes Yes Custom Customer
CUST_CUSTOM42 Customer custom 42 Yes Yes Custom Customer
CUST_CUSTOM43 Customer custom 43 Yes Yes Custom Customer
CUST_CUSTOM44 Customer custom 44 Yes Yes Custom Customer
CUST_CUSTOM45 Customer custom 45 Yes Yes Custom Customer
CUST_CUSTOM46 Customer custom 46 Yes Yes Custom Customer
CUST_CUSTOM47 Customer custom 47 Yes Yes Custom Customer
CUST_CUSTOM48 Customer custom 48 Yes Yes Custom Customer
CUST_CUSTOM49 Customer custom 49 Yes Yes Custom Customer
CUST_CUSTOM50 Customer custom 50 Yes Yes Custom Customer
ORD_CUSTOM01 Custom 1 Yes Yes Custom
ORD_CUSTOM02 Custom 2 Yes Yes Custom
ORD_CUSTOM03 Custom 3 Yes Yes Custom
ORD_CUSTOM04 Custom 4 Yes Yes Custom
ORD_CUSTOM05 Custom 5 Yes Yes Custom
ORD_CUSTOM06 Custom 6 Yes Yes Custom
ORD_CUSTOM07 Custom 7 Yes Yes Custom
ORD_CUSTOM08 Custom 8 Yes Yes Custom
ORD_CUSTOM09 Custom 9 Yes Yes Custom
ORD_CUSTOM10 Custom 10 Yes Yes Custom
ORD_CUSTOM11 Custom 11 Yes Yes Custom
ORD_CUSTOM12 Custom 12 Yes Yes Custom
ORD_CUSTOM13 Custom 13 Yes Yes Custom
ORD_CUSTOM14 Custom 14 Yes Yes Custom
ORD_CUSTOM15 Custom 15 Yes Yes Custom
ORD_CUSTOM16 Custom 16 Yes Yes Custom
ORD_CUSTOM17 Custom 17 Yes Yes Custom
ORD_CUSTOM18 Custom 18 Yes Yes Custom
ORD_CUSTOM19 Custom 19 Yes Yes Custom
ORD_CUSTOM20 Custom 20 Yes Yes Custom
ORD_CUSTOM21 Custom 21 Yes Yes Custom
ORD_CUSTOM22 Custom 22 Yes Yes Custom
ORD_CUSTOM23 Custom 23 Yes Yes Custom
ORD_CUSTOM24 Custom 24 Yes Yes Custom
ORD_CUSTOM25 Custom 25 Yes Yes Custom
ORD_CUSTOM26 Custom 26 Yes Yes Custom
ORD_CUSTOM27 Custom 27 Yes Yes Custom
ORD_CUSTOM28 Custom 28 Yes Yes Custom
ORD_CUSTOM29 Custom 29 Yes Yes Custom
ORD_CUSTOM30 Custom 30 Yes Yes Custom
CUST_SEX Gender Yes Yes Sex Customer
CUST_SIGNUPDATE Signupdate Yes Yes Date Customer
CUST_EXPIREDATE Expiredate Yes Yes Date Customer
CUST_BIRTHDATE Birthdate Yes Yes Date Customer
CUST_CITY City Yes Yes Text Customer
CUST_COUNTRY Country Id Yes Yes Text Customer
CUST_STATE State Yes Yes Text Customer
CUST_POSTAL Postal Yes Yes Text Customer
CUST_HOUSENUM House Number Yes Yes Text Customer
CUST_HOUSENUMEXT House No Ext Yes Yes Text Customer
CUST_ADDRESS1 Address Yes No Text Customer
CUST_ADDRESS2 Address line 2 Yes Yes Text Customer
CUST_ADDRESS3 Address line 3 Yes Yes Text Customer
CUST_INITIALS Initials Yes Yes Text Customer
CUST_PREFIX Prefix Yes Yes Text Customer
CUST_LASTNAME Lastname Yes Yes Text Customer
CUST_EMAIL Email Yes No Text Customer
CUST_TEL_HOME Home phone Yes Yes Text Customer
CUST_TEL_MOB Cell phone Yes Yes Text Customer
CUST_TEL_WORK Work phone Yes Yes Text Customer
CUST_TEL_FAX Fax Yes Yes Text Customer
CUST_FACT_STATE Invoice state Yes Yes Text Customer
CUST_FACT_POSTAL Invoice postal Yes Yes Text Customer
CUST_FACT_HOUSENUM Invoice house number Yes Yes Number Customer
CUST_FACT_HOUSENUMEXT Invoice house number extension Yes Yes Text Customer
CUST_FACT_ADDRESS1 Invoice address Yes Yes Text Customer
CUST_FACT_ADDRESS2 Invoice address 2 Yes Yes Text Customer
CUST_FACT_ADDRESS3 Invoice address 3 Yes Yes Text Customer
CUST_FACT_CITY Invoice city Yes Yes Text Customer
CUST_FACT_COUNTRY Invoice country Yes Yes Country Customer
CUST_COMP_NAME Company name Yes Yes Text Customer
CUST_COMP_TEL Company phone Yes Yes Text Customer
CUST_COMP_FAX C-Fax Yes Yes Text Customer
CUST_MEMBER_ID Member ID Yes Yes Text Customer
CUST_ID_NUMBER ID Number Yes Yes Text Customer
CUST_ID_TYPE ID type Yes Yes Text Customer
CUST_STUDENT Student Yes Yes Text Customer
CUST_BANKNAME Bank Yes Yes Text Customer
CUST_BANKACCOUNT Bankaccount Yes Yes Bankaccount Customer
CUST_IBAN IBAN Yes Yes Iban Customer
CUST_BIC BIC Yes Yes Text Customer
CUST_VATCODE VAT Code Yes Yes Text Customer
CUST_PAYMENTMETHOD Payment customer method Yes Yes Text Customer
CUST_PAYMENTMETHOD_DESC Payment method customer desc Yes No Text Customer
DETAIL_ID Detail-ID Yes Yes Number
DETAIL_INVOICE_ID Detail-Invoice# Yes Yes Text
DETAIL_TYPE Detail-Type Yes Yes Text
DETAIL_DESC Detail-Description Yes Yes Text
DETAIL_FROMDATE Detail-Fromdate Yes Yes Date
DETAIL_FROMTIME Detail-Fromtime Yes Yes Time
DETAIL_TILLTIME Detail-Tilltime Yes Yes Time
DETAIL_TILLDATE Detail-Tilldate Yes Yes Date
DETAIL_CURRENCY Detail-Currency Yes Yes Text
DETAIL_NUMBER Detail-Number Yes Yes Text
DETAIL_PARTICIPANTS Detail-Participant Yes Yes Text
DETAIL_SUBTOTAL Detail-Subtotal Yes Yes Currency
DETAIL_DISCOUNT Detail-Discount desc Yes Yes Text
DETAIL_DISCOUNT_TOTAL Detail-Discount Yes Yes Text
DETAIL_PRICE Detail-Price Yes Yes Currency
DETAIL_VAT_ID Detail-VAT ID Yes Yes Text
DETAIL_VAT Detail-VAT Yes Yes Currency
DETAIL_VAT_EXCL Detail-VAT excl Yes Yes Currency
DETAIL_VAT_DESC Detail-VAT desc Yes Yes Text
DETAIL_NBR_NIGHTS Detail-Nights Yes Yes Number
DETAIL_NBR_DAYS Detail-Days Yes Yes Number
DETAIL_OBJ_DESC Detail-Product desc. Yes Yes Text
DETAIL_PRT_DESC Detail-Participant desc. Yes Yes Text
BLOCK_PRIO Block-prio Yes Yes Number
BLOCK_DESC Block-description Yes Yes Text
BLOCK_MEMO Block-memo Yes Yes Text
BLOCK_STATUS Block-status Yes Yes Text
BLOCK_TEAM_ID Block-team# Yes Yes Number
BLOCK_TEAM Block-team Yes Yes Text
BLOCK_TEAM_DESC Block-team-description Yes Yes Text
ORD_COMP_ID ORD_COMP_ID Yes Yes Number
BLOCK_REX_ID Block-resource# Yes Yes Number
BLOCK_RESOURCE_DESC Block-resource-description Yes Yes Text Resource
BLOCK_RESOURCE_LONG_DESC Block-resource-extended Yes Yes Text Resource
CMP_ID Company# Yes Yes Number Company
CMP_ACTIVE Company active Yes Yes Text Company
CMP_LANG Company language Yes Yes Text Company
CMP_STATUS Company status Yes Yes Text Company
CMP_COLLECTIEF Company collective Yes Yes Text Company
CMP_COLLECTIEF_ENROLL Company enroll Yes Yes Text Company
CMP_EMAIL Company email Yes Yes Text Company
CMP_EMAILLIST Company newletter Yes Yes Text Company
CMP_NAME Company Yes Yes Text Company
CMP_TEL Company-Phone Yes Yes Text Company
CMP_FAX Company fax Yes Yes Text Company
CMP_POSTAL Company postal Yes Yes Text Company
CMP_HOUSENUM Company house number Yes Yes Text Company
CMP_HOUSENUMEXT Company house number extension Yes Yes Text Company
CMP_ADDRESS1 Company address Yes Yes Text Company
CMP_ADDRESS2 Company address2 Yes Yes Text Company
CMP_ADDRESS3 Company address3 Yes Yes Text Company
CMP_CITY Company city Yes Yes Text Company
CMP_COUNTRY Company country Yes Yes Country Company
CMP_VATNUMBER Company vat number Yes Yes Text Company
CMP_FACT_POSTAL Company invoice postal Yes Yes Text Company
CMP_FACT_HOUSENUM Company invoice house number Yes Yes Text Company
CMP_FACT_HOUSENUMEXT Company invoice house number extension Yes Yes Text Company
CMP_FACT_ADDRESS1 Company invoice address Yes Yes Text Company
CMP_FACT_ADDRESS2 Company invoice address2 Yes Yes Text Company
CMP_FACT_ADDRESS3 Company invoice address3 Yes Yes Text Company
CMP_FACT_CITY Company invoice city Yes Yes Text Company
CMP_FACT_COUNTRY Company invoice country Yes Yes Country Company
CMP_SIGNUPDATE Company signup date Yes Yes Date Company
CMP_EXPIREDATE Company expiry date Yes Yes Date Company
CMP_STAFFEL Company staffel Yes Yes Number Company
COMP_CUSTOM01 Custom 1 Yes Yes Custom Company
COMP_CUSTOM02 Custom 2 Yes Yes Custom Company
COMP_CUSTOM03 Custom 3 Yes Yes Custom Company
COMP_CUSTOM04 Custom 4 Yes Yes Custom Company
COMP_CUSTOM05 Custom 5 Yes Yes Custom Company
COMP_CUSTOM06 Custom 6 Yes Yes Custom Company
COMP_CUSTOM07 Custom 7 Yes Yes Custom Company
COMP_CUSTOM08 Custom 8 Yes Yes Custom Company
COMP_CUSTOM09 Custom 9 Yes Yes Custom Company
COMP_CUSTOM10 Custom 10 Yes Yes Custom Company
COMP_CUSTOM11 Custom 11 Yes Yes Custom Company
COMP_CUSTOM12 Custom 12 Yes Yes Custom Company
COMP_CUSTOM13 Custom 13 Yes Yes Custom Company
COMP_CUSTOM14 Custom 14 Yes Yes Custom Company
COMP_CUSTOM15 Custom 15 Yes Yes Custom Company
COMP_CUSTOM16 Custom 16 Yes Yes Custom Company
COMP_CUSTOM17 Custom 17 Yes Yes Custom Company
COMP_CUSTOM18 Custom 18 Yes Yes Custom Company
COMP_CUSTOM19 Custom 19 Yes Yes Custom Company
COMP_CUSTOM20 Custom 20 Yes Yes Custom Company
COMP_CUSTOM21 Custom 21 Yes Yes Custom Company
COMP_CUSTOM22 Custom 22 Yes Yes Custom Company
COMP_CUSTOM23 Custom 23 Yes Yes Custom Company
COMP_CUSTOM24 Custom 24 Yes Yes Custom Company
COMP_CUSTOM25 Custom 25 Yes Yes Custom Company
COMP_CUSTOM26 Custom 26 Yes Yes Custom Company
COMP_CUSTOM27 Custom 27 Yes Yes Custom Company
COMP_CUSTOM28 Custom 28 Yes Yes Custom Company
COMP_CUSTOM29 Custom 29 Yes Yes Custom Company
COMP_CUSTOM30 Custom 30 Yes Yes Custom Company
COMP_CUSTOM31 Custom 31 Yes Yes Custom Company
COMP_CUSTOM32 Custom 32 Yes Yes Custom Company
COMP_CUSTOM33 Custom 33 Yes Yes Custom Company
COMP_CUSTOM34 Custom 34 Yes Yes Custom Company
COMP_CUSTOM35 Custom 35 Yes Yes Custom Company
COMP_CUSTOM36 Custom 36 Yes Yes Custom Company
COMP_CUSTOM37 Custom 37 Yes Yes Custom Company
COMP_CUSTOM38 Custom 38 Yes Yes Custom Company
COMP_CUSTOM39 Custom 39 Yes Yes Custom Company
COMP_CUSTOM40 Custom 40 Yes Yes Custom Company
COMP_CUSTOM41 Custom 41 Yes Yes Custom Company
COMP_CUSTOM42 Custom 42 Yes Yes Custom Company
COMP_CUSTOM43 Custom 43 Yes Yes Custom Company
COMP_CUSTOM44 Custom 44 Yes Yes Custom Company
COMP_CUSTOM45 Custom 45 Yes Yes Custom Company
COMP_CUSTOM46 Custom 46 Yes Yes Custom Company
COMP_CUSTOM47 Custom 47 Yes Yes Custom Company
COMP_CUSTOM48 Custom 48 Yes Yes Custom Company
COMP_CUSTOM49 Custom 49 Yes Yes Custom Company
COMP_CUSTOM50 Custom 50 Yes Yes Custom Company
CMP_LONGCUSTOM01 Company long custom 1 Yes Yes Text Company
CMP_LONGCUSTOM02 Company long custom 2 Yes Yes Text Company
CMP_LONGCUSTOM03 Company long custom 3 Yes Yes Text Company
CMP_LONGCUSTOM04 Company long custom 4 Yes Yes Text Company
CMP_LONGCUSTOM05 Company long custom 5 Yes Yes Text Company
CMP_PAYMENTMETHOD Company payment method Yes No Text Company
CMP_PAYMENTMETHOD_DESC Company payment method description Yes No Text Company
CMP_BANKNAME Company bankname Yes Yes Text Company
CMP_BANKACCOUNT Company bankaccount Yes Yes Text Company
CMP_IBAN Company IBAN Yes Yes Text Company
CMP_BIC Company BIC Yes Yes Text Company
CMP_VATCODE Company VAT Code Yes Yes Text Company
CMP_INVOICESENDING Company method invoice Yes Yes Text Company
CMP_MANDATEREF Company mandateref Yes Yes Text Company
CMP_MANDATEDATE Company mandatedate Yes Yes Date Company
CMP_ID_HIS Company id his Yes Yes Number Company
CMP_CUST_ID Company customer id Yes Yes Number Company
CMP_USER_ID Company user id Yes Yes Number Company
CMP_FRAME_ID Company frame id Yes Yes Number Company
DETAIL_ACCOUNT_CODE Detail-Account code Yes Yes Text
DETAIL_ACCOUNT_SIGN Detail-Account sign Yes Yes Text
ORD_PAYMENTMETHOD ORD_PAYMENTMETHOD No Yes
CUST_INVOICESENDING Method invoice No Yes
CMP_PYM_ID CMP_PYM_ID No Yes
COMMENT Comment No Yes