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