ti

Tables (33)

API_LOG

  • API_LOG_ID — BIGINT
  • REQUEST_URL — VARCHAR(200) — NOT NULL
  • HTTP_METHOD — VARCHAR(10) — NOT NULL
  • REQUEST_HEADERS — VARCHAR(250)
  • REQUEST_BODY — TEXT
  • HTTP_STATUS — VARCHAR(20)
  • RESPONSE_HEADERS — TEXT
  • RESPONSE_BODY — TEXT
  • ERROR_MESSAGE — TEXT
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

ASN

  • ASN_ID — BIGINT
  • ORDER_ID — BIGINT — Foreign key → ORDERS.ORDER_ID
  • WAYBILL_NUMBER — VARCHAR(50) — NOT NULL — Supplier waybill shipment number.
  • WAYBILL_CREATION_DATE — TIMESTAMP — NOT NULL — Waybill creation datetime.
  • HAS_PDF — BOOLEAN — Indicates whether waybill PDF content is available.
  • PDF_FILE_ID — INT
  • DELETE_YN — VARCHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

ASN_INVOICE

  • INVOICE_ID — BIGINT
  • ASN_ID — BIGINT — Foreign key → ASN.ASN_ID
  • PDF_FILE_ID — INT
  • COMMERCIAL_INVOICE_NUMBER — VARCHAR(50) — Commercial invoice number used by customs.
  • INVOICE_DATE — TIMESTAMP — NOT NULL — Invoice creation datetime.
  • INVOICE_VALUE — DECIMAL(12, 3) — Invoice value of goods purchased.
  • CURRENCY — VARCHAR(3) — Currency used for the invoice.
  • HAS_PDF — BOOLEAN — Indicates whether commercial invoice PDF content is available.

CATALOG

  • CATALOG_ID — BIGINT
  • CURRENCY — VARCHAR(10) — USD
  • DESCRIPTION — VARCHAR(255) — A full list of orderable part numbers.
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

CONFIG

  • CONFIG_ID — BIGINT
  • PARTNER_ID — INT — Foreign key → PARTNER.PARTNER_ID — NOT NULL — Partner Id
  • SYSTEM_TYPE — VARCHAR(20) — NOT NULL — TI, CONNECT
  • CONFIG_KEY — VARCHAR(50) — NOT NULL — Config Key
  • CONFIG_VALUE — VARCHAR(50) — NOT NULL — Config Value
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

FILE_STORAGE

  • FILE_ID — BIGINT
  • PAYLOAD — MEDIUMTEXT — base64 encoded binary data
  • DELETE_YN — VARCHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

FINANCIAL_DOCUMENT

  • DOCUMENT_ID — BIGINT
  • ORDER_ID — BIGINT — Foreign key → ORDERS.ORDER_ID
  • WAYBILL_NUMBER — VARCHAR(50) — 공급업체 운송장 번호.
  • DOCUMENT_TYPE — VARCHAR(20) — 공급업체 문서 유형.
  • CARRIER — VARCHAR(50) — 공급업체 운송업체.
  • TOTAL_AMOUNT — DECIMAL(12, 2)
  • CURRENCY_CODE — VARCHAR(3) — 문서 통화 코드.
  • INVOICE_DATE — TIMESTAMP — NOT NULL — 문서 생성 날짜.
  • STATUS — VARCHAR(20)
  • HAS_PDF — BOOLEAN — PDF 콘텐츠 포함 여부.
  • PDF_FILE_ID — INT — financial PDF file
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

MENU

  • MENU_ID — INT
  • PARENT_MENU_ID — INT — NOT NULL
  • MENU_NAME — VARCHAR(100) — NOT NULL
  • MENU_URL — VARCHAR(255) — NOT NULL
  • MENU_DISPLAY_ORDER — INT
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

MENU_AUTH

  • MENU_AUTH_ID — INT
  • MENU_ID — INT — Foreign key → MENU.MENU_ID
  • USER_ID — INT — Foreign key → USERS.USER_ID
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

MENU_CODE

  • MENU_CODE_ID — INT
  • MENU_ID — INT — Foreign key → MENU.MENU_ID
  • MENU_CODE_TYPE — VARCHAR(20) — MENU, GRID, TAB
  • MENU_CODE_NAME — VARCHAR(50) — Menu code name
  • DEFAULT_YN — CHAR(1) — NOT NULL
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

MENU_CODE_DETAIL

  • MENU_CODE_DETAIL_ID — INT
  • MENU_CODE_ID — INT — Foreign key → MENU_CODE.MENU_CODE_ID
  • MENU_CODE_DETAIL_NAME — VARCHAR(50)
  • MENU_CODE_DETAIL_DISPLAY_NAME — VARCHAR(50)
  • MENU_CODE_DETAIL_DISPLAY_ORDER — INT
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

ORDERS

  • ORDER_ID — BIGINT
  • USER_ID — INT — Foreign key → USERS.USER_ID — NOT NULL
  • ORDER_NUMBER — VARCHAR(50) — NOT NULL — The TI order number for the order that was created.
  • ORDER_DATE — TIMESTAMP — NOT NULL — As of date/time (UTC) when the API was executed.
  • CUSTOMER_PURCHASE_ORDER_NUMBER — VARCHAR(50) — NOT NULL — An order identifier that identifies this order request.
  • END_CUSTOMER_COMPANY_NAME — VARCHAR(50) — NOT NULL — Customer's end customer company name.
  • TERMS_OF_SALE — VARCHAR(250) — Terms governing TI's sale or provision of products.
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL
  • INDEX — IDX_ORDERS_USER_ID
  • INDEX — IDX_ORDERS_USER_ID_ORDER_DATE
  • INDEX — IDX_ORDERS_CUSTOMER_PURCHASE_ORDER_NUMBER
  • INDEX — IDX_ORDERS_ORDER_NUMBER
  • INDEX — IDX_ORDERS_ORDER_DATE
  • INDEX — IDX_ORDERS_INSERT_DATE
  • INDEX — IDX_ORDERS_UPDATE_DATE

ORDER_ITEM

  • ORDER_ITEM_ID — BIGINT
  • ORDER_ID — BIGINT — Foreign key → ORDERS.ORDER_ID — NOT NULL
  • TI_LINE_ITEM_NUMBER — VARCHAR(50) — NOT NULL — The TI line item number for the line item that was created.
  • ITEM_SHIP_TO_ACCOUNT_NUMBER — VARCHAR(50) — NOT NULL — A line item ship to account number.
  • CUSTOMER_LINE_ITEM_NUMBER — VARCHAR(50) — NOT NULL — A line item identifier that identifies the line item for this order.
  • STATUS — VARCHAR(20) — NOT NULL — Denotes the status of the line item.
  • CANCELLATION_WINDOW_WEEKS — INT — Orders with estimated shipping dates beyond this window can be cancelled.
  • RESCHEDULE_WINDOW_WEEKS — INT — Orders with estimated shipping dates beyond this window are eligible for rescheduling.
  • NON_CANCELLABLE_NON_RETURNABLE — BOOLEAN — Indicates if the product is non-cancellable and non-returnable.
  • TI_PART_NUMBER — VARCHAR(50) — NOT NULL — The TI orderable part number.
  • CUSTOMER_PART_NUMBER — VARCHAR(50) — Customer's material number provided in the request. If null then TI_PART_NUMBER
  • TI_TOTAL_ORDER_ITEM_QUANTITY — INT — NOT NULL — Total item quantity at the line level.
  • QUOTE_NUMBER — VARCHAR(10) — The TI quoteNumber for the tiPartNumber.
  • CUSTOMER_ANTICIPATED_UNIT_PRICE — DECIMAL(12, 3) — The expected price per unit.
  • CUSTOMER_CURRENCY_CODE — VARCHAR(5) — Currency for Customer's expected unit price.
  • TI_UNIT_PRICE — DECIMAL(12, 3) — The unit price as agreed upon in the pricing agreement.
  • TI_CURRENCY_CODE — VARCHAR(5) — NOT NULL — Currency for Supplier unit price.
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL
  • INDEX — IDX_ORDER_ITEM_ORDER_ID
  • INDEX — IDX_ORDER_ITEM_CUSTOMER_LINE_ITEM_NUMBER
  • INDEX — IDX_ORDER_ITEM_TI_LINE_ITEM_NUMBER
  • INDEX — IDX_ORDER_ITEM_STATUS
  • INDEX — IDX_ORDER_ITEM_INSERT_DATE
  • INDEX — IDX_ORDER_ITEM_UPDATE_DATE

ORDER_ITEM_MESSAGE

  • ORDER_ITEM_MESSAGE_ID — BIGINT
  • ORDER_ITEM_ID — BIGINT — Foreign key → ORDER_ITEM.ORDER_ITEM_ID — NOT NULL — Reference to the line item.
  • CODE — VARCHAR(50) — Indicates a code assigned to troubleshoot any issues.
  • TYPE — VARCHAR(50) — Indicates the type of message (Validation Error, Info).
  • REASON — VARCHAR(255) — Indicates the reason for this message.
  • MESSAGE — TEXT — Provides a more detailed description or suggested action to take.
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL
  • INDEX — IDX_ORDER_ITEM_MESSAGE_ORDER_ITEM_ID
  • INDEX — IDX_ORDER_ITEM_MESSAGE_INSERT_DATE
  • INDEX — IDX_ORDER_ITEM_MESSAGE_UPDATE_DATE

ORDER_ITEM_SCHEDULE

  • ORDER_SCHEDULE_ID — BIGINT
  • ORDER_ITEM_ID — BIGINT — Foreign key → ORDER_ITEM.ORDER_ITEM_ID — NOT NULL — Reference to the line item.
  • REQUESTED_QUANTITY — INT — NOT NULL — The requested quantity to be ordered for a particular date.
  • REQUESTED_DELIVERY_DATE — TIMESTAMP — NOT NULL — The desired delivery date for the associated quantity of product.
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL
  • INDEX — IDX_ORDER_ITEM_SCHEDULE_ORDER_ITEM_ID
  • INDEX — IDX_ORDER_ITEM_SCHEDULE_INSERT_DATE
  • INDEX — IDX_ORDER_ITEM_SCHEDULE_UPDATE_DATE

ORDER_ITEM_SCHEDULE_CONFIRM

  • CONFIRMATION_ID — BIGINT
  • ORDER_SCHEDULE_ID — BIGINT — Foreign key → ORDER_ITEM_SCHEDULE.ORDER_SCHEDULE_ID — NOT NULL — Reference to the schedule.
  • TI_SCHEDULE_LINE_NUMBER — VARCHAR(50) — Supplier schedule line number.
  • SCHEDULED_QUANTITY — INT — NOT NULL — The quantity of product confirmed to be shipped.
  • ESTIMATED_SHIP_DATE — TIMESTAMP — NOT NULL — The estimated ship date from TI.
  • ESTIMATED_DELIVERY_DATE — TIMESTAMP — NOT NULL — Supplier estimated delivery date.
  • SHIPPED_QUANTITY — INT — NOT NULL — Supplier delivered quantity.
  • ESTIMATED_DELIVERY_DATE_STATUS — VARCHAR(20) — NOT NULL — The shipment status for schedules with an estimated ship date.
  • RESCHEDULED_SHIP_DATE — TIMESTAMP — NOT NULL — Supplier reschedule date.
  • CUSTOMER_REQUESTED_SHIP_DATE — TIMESTAMP — NOT NULL — The calculated desired ship date for the associated quantity of product.
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL
  • INDEX — IDX_ORDER_ITEM_SCHEDULE_CONFIRM_ORDER_SCHEDULE_ID
  • INDEX — IDX_ORDER_ITEM_SCHEDULE_CONFIRM_INSERT_DATE
  • INDEX — IDX_ORDER_ITEM_SCHEDULE_CONFIRM_UPDATE_DATE

ORDER_MESSAGE

  • ORDER_MESSAGE_ID — BIGINT
  • ORDER_ID — BIGINT — Foreign key → ORDERS.ORDER_ID — NOT NULL — Reference to the order.
  • CODE — VARCHAR(50) — Indicates a code assigned to troubleshoot any issues.
  • TYPE — VARCHAR(50) — Indicates the type of message (Validation Error, Info).
  • REASON — VARCHAR(255) — Indicates the reason for this message.
  • MESSAGE — TEXT — Provides a more detailed description or suggested action to take.
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL
  • INDEX — IDX_ORDER_MESSAGE_ORDER_ID
  • INDEX — IDX_ORDER_MESSAGE_INSERT_DATE
  • INDEX — IDX_ORDER_MESSAGE_UPDATE_DATE

ORDER_MONTHLY_STATISTIC

  • STATISTIC_ID — BIGINT
  • USER_ID — INT — Foreign key → USERS.USER_ID — NOT NULL — User Id
  • TI_PART_NUMBER — VARCHAR(50) — NOT NULL — The unique identifier of the product.
  • AMOUNT — INT — NOT NULL — Amount
  • QUANTITY — INT — NOT NULL — Quantity
  • MONTH_DATE — DATE — NOT NULL — Month
  • STATUS — VARCHAR(20) — NOT NULL — ORDERED, SCHEDULED, DELIVERED
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

ORDER_STATUS

  • ORDER_ID — BIGINT — Foreign key → ORDERS.ORDER_ID
  • USER_ID — INT
  • ORDER_NUMBER — VARCHAR(50) — NOT NULL — TI Order No
  • ORDER_DATE — TIMESTAMP — NOT NULL — Order Date
  • CUSTOMER_PURCHASE_ORDER_NUMBER — VARCHAR(50) — NOT NULL — PO No
  • ORDER_STATUS — VARCHAR(20) — NOT NULL — Status
  • END_CUSTOMER_COMPANY_NAME — VARCHAR(50) — NOT NULL — Customer's end customer company name.
  • ITEM_COUNT — INT — NOT NULL — Status
  • ASN_COUNT — INT — NOT NULL — ASN
  • INVOICE_COUNT — INT — NOT NULL — Invoice
  • REMITTANCE_COUNT — INT — NOT NULL — Remittance
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL
  • INDEX — IDX_ORDER_STATUS_USER_ID
  • INDEX — IDX_ORDER_STATUS_USER_ID_ORDER_DATE
  • INDEX — IDX_ORDER_STATUS_CUSTOMER_PURCHASE_ORDER_NUMBER
  • INDEX — IDX_ORDER_STATUS_ORDER_STATUS
  • INDEX — IDX_ORDER_STATUS_INSERT_DATE
  • INDEX — IDX_ORDER_STATUS_UPDATE_DATE

PARTNER

  • PARTNER_ID — INT
  • PARTNER_NAME — VARCHAR(50) — NOT NULL — Partner Name
  • COMPANY_NAME — VARCHAR(50) — NOT NULL — Company Name
  • PARTNER_EMAIL — VARCHAR(50) — NOT NULL
  • PARTNER_ROLE_TYPE — VARCHAR(10) — NOT NULL — ALL, BACKLOG, STORE' NOT NUL
  • DELETE_YN — VARCHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

PRODUCT

  • PRODUCT_ID — BIGINT
  • CATALOG_ID — BIGINT — Reference to the product catalog.
  • TI_PART_NUMBER — VARCHAR(255) — NOT NULL — The unique identifier of the product.
  • GENERIC_PART_NUMBER — VARCHAR(255) — The generic part number of the product.
  • BUY_NOW_URL — VARCHAR(255) — The URL to purchase the product in the TI store.
  • QUANTITY — INT — The inventory quantity currently on hand for sale in the TI store.
  • LIMIT_QUANTITY — INT — The order limit on TI.com store, if a limit exists.
  • DESCRIPTION — VARCHAR(255) — The description of the product.
  • MINIMUM_ORDER_QUANTITY — INT — The minimum order quantity (MOQ) of the product.
  • STANDARD_PACK_QUANTITY — INT — The standard package quantity (SPQ) of the product.
  • EXPORT_CONTROL_CLASSIFICATION_NUMBER — VARCHAR(255) — The Export Control Classification Number (ECCN) for the product.
  • HTS_CODE — VARCHAR(10) — The 10-digit Harmonized Tariff Schedule Code for the product.
  • PIN_COUNT — INT — The pin count of the product.
  • PACKAGE_TYPE — VARCHAR(50) — The package type of the product.
  • PACKAGE_CARRIER — VARCHAR(50) — The carrier type for the product.
  • CUSTOM_REEL — BOOLEAN — Indicates whether or not a custom reel carrier is available.
  • LIFE_CYCLE — VARCHAR(50) — The product lifecycle status.
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

PRODUCT_BACKLOG

  • PRODUCT_BACKLOG_ID — BIGINT
  • PRODUCT_ID — BIGINT — NOT NULL
  • USER_ID — INT — Foreign key → USERS.USER_ID — NOT NULL
  • REQUESTED_QUANTITY — INT — NOT NULL
  • CUSTOMER_ANTICIPATED_UNIT_PRICE — DECIMAL(12, 2) — The expected price per unit.
  • PRODUCT_BACKLOG_TYPE — VARCHAR(10) — NOT NULL — USER, QUOTE, ORDER
  • DELETE_YN — VARCHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

PRODUCT_FUTURE_INVENTORY

  • FUTURE_INVENTORY_ID — BIGINT
  • PRODUCT_ID — BIGINT — Foreign key → PRODUCT.PRODUCT_ID — Reference to the product.
  • FORECAST_QUANTITY — INT — The estimated inventory quantity that will become available.
  • FORECAST_DATE — TIMESTAMP — NOT NULL — The estimated week of availability (UTC, YYYY-MM-DD).
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

PRODUCT_PRICING

  • PRICING_ID — BIGINT
  • PRODUCT_ID — BIGINT — Foreign key → PRODUCT.PRODUCT_ID — Reference to the product.
  • CURRENCY — VARCHAR(3) — Pricing currency ISO 4217 code.
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

PRODUCT_PRICING_BREAK

  • PRICE_BREAK_ID — BIGINT
  • PRICING_ID — BIGINT — Foreign key → PRODUCT_PRICING.PRICING_ID — Reference to the pricing.
  • PRICE_BREAK_QUANTITY — INT — Price break quantity.
  • PRICE — DECIMAL(12, 2) — The corresponding price for the price break quantity.
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

PROFILE

  • PROFILE_ID — BIGINT — Unique identifier for each profile
  • PARTNER_ID — INT — Foreign key → PARTNER.PARTNER_ID — NOT NULL — Reference to the partner or customer (FK)
  • CLIENT_ID — VARCHAR(200) — NOT NULL — Client ID for TI Backlog API
  • CLIENT_SECRET — VARCHAR(200) — NOT NULL — Client Secret for TI Backlog API
  • SHIP_TO_ACCOUNT_NUMBER — VARCHAR(100) — shipToAccountNumber
  • END_CUSTOMER_COMPANY_NAME — VARCHAR(100) — End customer company name
  • IS_SAVE_PDF — BOOLEAN — NOT NULL — Whether to save PDF responses
  • PUSH_API_KEY — VARCHAR(100) — Push API key for TI Backlog
  • CURRENCY — VARCHAR(3) — NOT NULL — USD
  • IS_USE_CONNECT — BOOLEAN — NOT NULL — Is use connect
  • CONNECT_URL — VARCHAR(200) — Connect 2.0 API base URL
  • LANGUAGE — VARCHAR(2) — NOT NULL — EN, KO
  • DELETE_YN — CHAR(1) — NOT NULL — Indicates if the record is deleted
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL — Record creator
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL — Last operator
  • INSERT_DATE — TIMESTAMP — NOT NULL — Record creation timestamp
  • UPDATE_DATE — TIMESTAMP — NOT NULL — Record update timestamp
  • INDEX — IDX_PROFILE_PROFILE_ID
  • INDEX — IDX_PROFILE_PARTNER_ID

PUSH_LOG

  • PUSH_LOG_ID — BIGINT
  • PUSH_TYPE — VARCHAR(10) — NOT NULL — ORDER, ASN, FD
  • CUSTOMER_PURCHASE_ORDER_NUMBER — VARCHAR(50) — NOT NULL — PO No
  • REQUEST_PAYLOAD — TEXT — Requet payload
  • RESPONSE_PAYLOAD — TEXT — Response payload
  • STATUS — VARCHAR(20) — NOT NULL — PENDING, SUCCESS, ERROR
  • ERROR_MESSAGE — TEXT — Error Message
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

QUOTE

  • QUOTE_ID — BIGINT
  • CUSTOMER_QUOTE_NUMBER — VARCHAR(50) — NOT NULL — The Customer’s quote identifier.
  • QUOTE_NUMBER — VARCHAR(50) — NOT NULL — The Supplier's quote identifier.
  • USER_ID — INT — Foreign key → USERS.USER_ID — NOT NULL
  • END_CUSTOMER_COMPANY_NAME — VARCHAR(50) — The descriptive name of the end customer.
  • END_CUSTOMER_WEBSITE — VARCHAR(50) — End Customer Website.
  • QUOTE_STATUS — VARCHAR(10)
  • QUOTE_REASON — VARCHAR(2)
  • ITEMS — INT
  • QUOTE_START_DATE — TIMESTAMP — NOT NULL — The start date from which this quote will be valid.
  • QUOTE_END_DATE — TIMESTAMP — NOT NULL — The latest date that this quote will be valid.
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

QUOTE_ITEM

  • QUOTE_ITEM_ID — BIGINT
  • QUOTE_ID — BIGINT — Reference to the quote number in quotes table.
  • TI_LINE_ITEM_NUMBER — VARCHAR(10) — NOT NULL — TI’s quote line item number.
  • TI_UNIT_PRICE — DECIMAL(19, 2) — TI price for this product.
  • TI_UNIT_PRICE_CURRENCY_CODE — VARCHAR(20) — Currency of TI price for this product.
  • TI_PART_NUMBER — VARCHAR(50) — The TI product identifier for which a price quote is requested.
  • CUSTOMER_LINE_ITEM_NUMBER — VARCHAR(10) — Customer’s quote line item number.
  • QUANTITY — INT — The quantity of parts for which a price quote is requested.
  • REQUESTED_UNIT_PRICE — DECIMAL(19, 2) — The desired or expected price for this product.
  • REQUESTED_UNIT_PRICE_CURRENCY_CODE — VARCHAR(5) — The desired or expected currency code for this product.
  • STATUS — VARCHAR(20) — The status of this quote item.
  • QUOTE_ITEM_COMMENT — 'Additional — Additional comments from TI for this line item, if any.
  • S — VARCHAR(255) — RDER_LEAD_TIME INT COMMENT 'Order lead time.
  • MINIMUM_ORDER_QUANTITY — INT — Minimum order quantity.
  • NEXT_ORDER_QUANTITY_INCREMENT — INT — Next order quantity increment.
  • BOX_QUANTITY — INT — Box quantity.
  • PACKAGE_QUANTITY — INT — Package quantity.
  • PACKAGE_TYPE — INT — Package type.
  • RESTRICTION_OF_HAZARDOUS_SUBSTANCES_COMPLIANT — VARCHAR(50) — Restriction of hazardous substances compliance.
  • CANCELLATION_WINDOW_WEEKS — INT — Cancellation window in weeks.
  • RESCHEDULE_WINDOW_WEEKS — INT — Reschedule window in weeks.
  • NON_CANCELLABLE_NON_RETURNABLE — BOOLEAN — Indicates if the product is non-cancellable and non-returnable.
  • PRODUCT_TYPE — VARCHAR(20) — Type of product backlog terms: Standard, Custom, or Non-Cancelable/Non-Returnable.
  • INCOTERM_DESCRIPTION — VARCHAR(255) — Description of incoterm value.
  • MOISTURE_LEVEL — VARCHAR(50) — Moisture level.
  • EXPORT_CONTROL_CLASSIFICATION_NUMBER — VARCHAR(50) — Export control classification number.
  • PAYMENT_TERMS — VARCHAR(255) — Payment terms.
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

QUOTE_MESSAGE

  • QUOTE_MESSAGE_ID — BIGINT
  • QUOTE_ITEM_ID — BIGINT — Reference to the line item in the line_items table.
  • CODE — VARCHAR(20) — Message code.
  • TYPE — VARCHAR(20) — Message type (ERROR or INFO).
  • REASON — VARCHAR(255) — Indicates the reason for this error or message.
  • MESSAGE — VARCHAR(255) — Message content.
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

USERS

  • USER_ID — INT
  • USER_NAME — VARCHAR(100) — NOT NULL
  • PARTNER_ID — INT — Foreign key → PARTNER.PARTNER_ID — NOT NULL — Partner Id
  • PASSWORD — VARCHAR(255) — NOT NULL
  • ROLE_TYPE — VARCHAR(20) — NOT NULL
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

USER_COLUMN

  • USER_ID — INT — Foreign key → USERS.USER_ID
  • MENU_ID — INT — Foreign key → MENU.MENU_ID
  • MENU_CODE_DETAIL_ID_LIST — TEXT
  • DEFAULT_YN — CHAR(1) — NOT NULL
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

USER_STATUS

  • USER_ID — INT — Foreign key → USERS.USER_ID
  • MENU_ID — INT — Foreign key → MENU.MENU_ID
  • CUSTOM_STATUS — CHAR(45)
  • MENU_CODE_DETAIL_ID_LIST — TEXT
  • ORDER_INDEX — INT
  • DEFAULT_YN — CHAR(1) — NOT NULL
  • DELETE_YN — CHAR(1) — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL