| Name | Description | Type | Additional information |
|---|---|---|---|
| ACCTNO | string |
None. |
|
| SUBC | string |
None. |
|
| CUST_VEND | string |
None. |
|
| RCV_OVER_SHIP | decimal number |
None. |
|
| SHIPTO | integer |
None. |
|
| BILLTO | integer |
None. |
|
| PAYTO | integer |
None. |
|
| SHIP_DEF_NO | integer |
None. |
|
| BILL_DEF_NO | integer |
None. |
|
| PAY_DEF_NO | integer |
None. |
|
| PAY_US | string |
None. |
|
| SHIP_DEF_SUBC | string |
None. |
|
| BILL_DEF_SUBC | string |
None. |
|
| PAY_DEF_SUBC | string |
None. |
|
| COMPANYNO | integer |
None. |
|
| DIVISION | string |
None. |
|
| DEPART | string |
None. |
|
| LANG_KEY | string |
None. |
|
| FORM_1099 | string |
None. |
|
| FORM_1099TYPE | string |
None. |
|
| DISC_CODE | string |
None. |
|
| REGISTRATION_NO | string |
None. |
|
| REGISTRATION_UPD | date |
None. |
|
| REGISTRATION_VALID | date |
None. |
|
| HOLD | string |
None. |
|
| HOLD_DATE | date |
None. |
|
| HOLD_BY | string |
None. |
|
| APPROVED | string |
None. |
|
| APPROVED_DATE | date |
None. |
|
| APPROVED_BY | string |
None. |
|
| ULINES | string |
None. |
|
| PRINT_PN | string |
None. |
|
| PRINT_OUR | string |
None. |
|
| PICK_TICKET_PER_PN | string |
None. |
|
| SUM_DOC_LINES | string |
None. |
|
| CCODE | string |
None. |
|
| TERM_CODE | string |
None. |
|
| CREDIT | decimal number |
None. |
|
| GLOBAL_CREDIT | string |
None. |
|
| WGHT_TO | string |
None. |
|
| VOL_TO | string |
None. |
|
| LENGTH_TO | string |
None. |
|
| SHIP_COMPLETE | string |
None. |
|
| POST_SHIP_DOC | string |
None. |
|
| POST_RECV_HDR | string |
None. |
|
| AUTO_RFQ_DEALERS | string |
None. |
|
| INV_TYPE | string |
None. |
|
| ACCOUNT_TYPE | string |
None. |
|
| ACCOUNT_RATE | string |
None. |
|
| PRIORITY | string |
None. |
|
| COPY_PRIORITY | string |
None. |
|
| EARLY_SHIPMENT | string |
None. |
|
| DAYS_BEFORE_SHIPPING | integer |
None. |
|
| SHIPVIA | string |
None. |
|
| FOB | string |
None. |
|
| FOB_LBL | string |
None. |
|
| GL_ACCOUNT | string |
None. |
|
| LATE_CHARGE_GL_ACCOUNT | string |
None. |
|
| CURENCY_CONV | string |
None. |
|
| MIN_ORDER_LINE | decimal number |
None. |
|
| MIN_ORDER | decimal number |
None. |
|
| PRICETBL_CELL | integer |
None. |
|
| QT_TYPE_DEF | string |
None. |
|
| SO_TYPE_DEF | string |
None. |
|
| RF_TYPE_DEF | string |
None. |
|
| PO_TYPE_DEF | string |
None. |
|
| IMP_EXP_FILETYPE | string |
None. |
|
| SMAN1_CODE | string |
None. |
|
| SMAN2_CODE | string |
None. |
|
| SMAN3_CODE | string |
None. |
|
| SMAN4_CODE | string |
None. |
|
| SMAN5_CODE | string |
None. |
|
| AGENT_CODE | string |
None. |
|
| SMAN1_PERC | decimal number |
None. |
|
| SMAN2_PERC | decimal number |
None. |
|
| SMAN3_PERC | decimal number |
None. |
|
| SMAN4_PERC | decimal number |
None. |
|
| SMAN5_PERC | decimal number |
None. |
|
| AGENT_PERC | decimal number |
None. |
|
| ADD_AGENT_PRICE | string |
None. |
|
| SMAN1_NG | string |
None. |
|
| SMAN2_NG | string |
None. |
|
| SMAN3_NG | string |
None. |
|
| SMAN4_NG | string |
None. |
|
| SMAN5_NG | string |
None. |
|
| SMAN1_DOCLN | string |
None. |
|
| SMAN2_DOCLN | string |
None. |
|
| SMAN3_DOCLN | string |
None. |
|
| SMAN4_DOCLN | string |
None. |
|
| SMAN5_DOCLN | string |
None. |
|
| DISC_TYPE | string |
None. |
|
| DISC_DOCLN | string |
None. |
|
| DISC_PERC | decimal number |
None. |
|
| MISC1_DOCLN | string |
None. |
|
| MISC2_DOCLN | string |
None. |
|
| MISC3_DOCLN | string |
None. |
|
| MISC4_DOCLN | string |
None. |
|
| MISC5_DOCLN | string |
None. |
|
| MISC6_DOCLN | string |
None. |
|
| MISC1_TYPE | string |
None. |
|
| MISC2_TYPE | string |
None. |
|
| MISC3_TYPE | string |
None. |
|
| MISC4_TYPE | string |
None. |
|
| MISC5_TYPE | string |
None. |
|
| MISC6_TYPE | string |
None. |
|
| MISC1_PERC | decimal number |
None. |
|
| MISC2_PERC | decimal number |
None. |
|
| MISC3_PERC | decimal number |
None. |
|
| MISC4_PERC | decimal number |
None. |
|
| MISC5_PERC | decimal number |
None. |
|
| MISC6_PERC | decimal number |
None. |
|
| MISC1_PRN | string |
None. |
|
| MISC2_PRN | string |
None. |
|
| MISC3_PRN | string |
None. |
|
| MISC4_PRN | string |
None. |
|
| MISC5_PRN | string |
None. |
|
| MISC6_PRN | string |
None. |
|
| MISC1_TTL | string |
None. |
|
| MISC2_TTL | string |
None. |
|
| MISC3_TTL | string |
None. |
|
| MISC4_TTL | string |
None. |
|
| MISC5_TTL | string |
None. |
|
| MISC6_TTL | string |
None. |
|
| SUBT_TAX_A | string |
None. |
|
| SUBT_TAX_B | string |
None. |
|
| SUBT_TAX_C | string |
None. |
|
| M1_TAX_A | string |
None. |
|
| M1_TAX_B | string |
None. |
|
| M1_TAX_C | string |
None. |
|
| M2_TAX_A | string |
None. |
|
| M2_TAX_B | string |
None. |
|
| M2_TAX_C | string |
None. |
|
| M3_TAX_A | string |
None. |
|
| M3_TAX_B | string |
None. |
|
| M3_TAX_C | string |
None. |
|
| M4_TAX_A | string |
None. |
|
| M4_TAX_B | string |
None. |
|
| M4_TAX_C | string |
None. |
|
| M5_TAX_A | string |
None. |
|
| M5_TAX_B | string |
None. |
|
| M5_TAX_C | string |
None. |
|
| M6_TAX_A | string |
None. |
|
| M6_TAX_B | string |
None. |
|
| M6_TAX_C | string |
None. |
|
| TAX_A_CODE | string |
None. |
|
| TAX_B_CODE | string |
None. |
|
| TAX_C_CODE | string |
None. |
|
| TAX_A_GL | string |
None. |
|
| TAX_B_GL | string |
None. |
|
| TAX_C_GL | string |
None. |
|
| TAX_A_TTL | string |
None. |
|
| TAX_B_TTL | string |
None. |
|
| TAX_C_TTL | string |
None. |
|
| TAX_ON_TAX_B | string |
None. |
|
| EXCH_CORE_CHRG | string |
None. |
|
| EXCH_CORE_RETURN | integer |
None. |
|
| EXCH_CORE_NOTE | string |
None. |
|
| EXCH_CHARGE_FROM | string |
None. |
|
| EXCH_CHARGE_COST | string |
None. |
|
| EXCH_CORE_COST | string |
None. |
|
| EXCH_CORE_PERC | integer |
None. |
|
| CV_ALERT | string |
None. |
|
| NO_AUTO_IMG_PRINT | string |
None. |
|
| DEFAULT_CONTACT | string |
None. |
|
| INV_ENTRY_NOT_APPROVED | string |
None. |
|
| AUTO_SPEC2000_CREATION | string |
None. |
|
| EDI_SPEC_2000_ACTIVE | string |
None. |
|
| EDI_WEB_SITE | string |
None. |
|
| EDI_ACCOUNT | string |
None. |
|
| EDI_PASSWORD | string |
None. |
|
| EDI_USER_RESP_FILE | string |
None. |
|
| EDI_USER_TRANS_FILE | string |
None. |
|
| CV_TAX_ENTITY | string |
None. |
|
| VAT_EXEMPTION | string |
None. |
|
| PROCESS_AUTOMATICALLY | string |
None. |
|
| CHECK_LIMIT_PRICE | string |
None. |
|
| LIMIT_PRICE | decimal number |
None. |
|
| SITA | string |
None. |
|
| SITA_USER | string |
None. |
|
| AUTOMATIC_SHIPPING | string |
None. |
|
| SITA_AIRLINE | string |
None. |
|
| SITA_CITY | string |
None. |
|
| SITA_DEPARTMENT | string |
None. |
|
| AEROXCHANGE | string |
None. |
|
| AUTOMATED_QUOTE_TO_RFQ | string |
None. |
|
| END_USER_STATEMENT_REQUIRED | string |
None. |
|
| END_USER_STATEMENT_LAST_USER | string |
None. |
|
| END_USER_STATEMENT_REVIEW_DATE | date |
None. |
|
| DO_NOT_RECEIVE_MSG_VIA_EMAIL | string |
None. |
|
| RECEIVE_RFQ_PO_AS_SMS | string |
None. |
|
| E_MAX_OPEN_PO | integer |
None. |
|
| E_MAX_PO_TOTAL_AMOUNT | integer |
None. |
|
| MIN_GROSS_PROFIT | decimal number |
None. |
|
| FLOOR_COST_PERCENT | decimal number |
None. |
|
| RECLOCK | string |
None. |
|
| ADDED_USR | string |
None. |
|
| ADDED_DTE | date |
None. |
|
| UPDATED_USR | string |
None. |
|
| UPDATED_DTE | date |
None. |