Documentation
Difficulty level:
Columns Order
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 | 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 |