DOUBUL

Tables (27)

ASN_DTM

  • ASN_DTM_ID — BIGINT
  • ASN_HEADER_ID — BIGINT — NOT NULL — FK: ASN_HEADER.ASN_HEADER_ID
  • DATE_TIME_QUALIFIER — VARCHAR(10) — NOT NULL — DTM01: Date/Time Qualifier
  • DATE_VALUE — CHAR(8) — NOT NULL — DTM02: Date (CCYYMMDD)
  • DELETE_YN — BOOLEAN — 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_HEADER

  • ASN_HEADER_ID — BIGINT
  • BSN_PURPOSE_CODE — VARCHAR(10) — NOT NULL — BSN01: Purpose Code
  • SHIPMENT_IDENTIFICATION — VARCHAR(50) — NOT NULL — BSN02: Shipment Identification
  • SHIPMENT_DATE — CHAR(8) — NOT NULL — BSN03: Shipment Date (CCYYMMDD)
  • SHIPMENT_TIME — CHAR(8) — NOT NULL — BSN04: Shipment Time
  • LINE_ITEM_COUNT — INT — NOT NULL — CTT01: Total Line Item Count
  • DELETE_YN — BOOLEAN — 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_HL

  • ASN_HL_ID — BIGINT
  • ASN_HEADER_ID — BIGINT — NOT NULL — FK: ASN_HEADER.ASN_HEADER_ID
  • HIERARCHICAL_ID — VARCHAR(12) — NOT NULL — HL01: Hierarchical ID
  • PARENT_HIERARCHICAL_ID — VARCHAR(12) — HL02: Parent Hierarchical ID
  • HIERARCHICAL_LEVEL_CODE — VARCHAR(5) — NOT NULL — HL03: Hierarchical Level Code
  • DELETE_YN — BOOLEAN — 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_HL_ITEM

  • ASN_HL_ITEM_ID — BIGINT
  • ASN_HL_ID — BIGINT — NOT NULL — FK: ASN_HL.ASN_HL_ID
  • HL_ITEM_HIERARCHICAL_ID — VARCHAR(12) — NOT NULL — HL_ITEM HL01: Hierarchical ID
  • HL_ITEM_PARENT_ID — VARCHAR(12) — NOT NULL — HL_ITEM HL02: Parent Hierarchical ID
  • HL_ITEM_LEVEL_CODE — VARCHAR(5) — NOT NULL — HL_ITEM HL03: Hierarchical Level Code
  • ASSIGNED_ITEM_NUMBER — VARCHAR(20) — NOT NULL — LIN01: Assigned Item Number
  • PRODUCT_SERVICE_ID_QUALIFIER — VARCHAR(10) — NOT NULL — LIN02: Product/Service ID Qualifier
  • PRODUCT_SERVICE_ID — VARCHAR(50) — NOT NULL — LIN03: Product/Service ID
  • NUMBER_OF_UNITS_SHIPPED — DECIMAL(10, 2) — NOT NULL — SN102: Number of Units Shipped
  • UNIT_OF_MEASURE — VARCHAR(5) — NOT NULL — SN103: Unit of Measure
  • PURCHASE_ORDER_REFERENCE — VARCHAR(50) — NOT NULL — PRF01: Purchase Order Reference
  • RELEASE_NUMBER — VARCHAR(20) — PRF02: Release Number
  • PO_ISSUE_DATE — CHAR(8) — PRF04: Purchase Order Issue Date
  • ORDER_QUANTITY — DECIMAL(10, 2) — NOT NULL — PRF05: Order Quantity
  • DELETE_YN — BOOLEAN — 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_HL_N1

  • ASN_HL_N1_ID — BIGINT
  • ASN_HL_ID — BIGINT — NOT NULL — FK: ASN_HL.ASN_HL_ID
  • PARTY_ENTITY_IDENTIFIER — VARCHAR(10) — NOT NULL — N101: Party Entity Identifier
  • PARTY_NAME — VARCHAR(60) — NOT NULL — N102: Party Name
  • PARTY_ID_CODE_QUALIFIER — VARCHAR(10) — NOT NULL — N103: Identification Code Qualifier
  • PARTY_IDENTIFICATION — VARCHAR(80) — NOT NULL — N104: Identification Code
  • CITY — VARCHAR(50) — NOT NULL — N401: City Name
  • STATE — VARCHAR(10) — NOT NULL — N402: State/Province Code
  • POSTAL_CODE — VARCHAR(20) — NOT NULL — N403: Postal Code
  • COUNTRY_CODE — VARCHAR(10) — NOT NULL — N404: Country Code
  • DELETE_YN — BOOLEAN — 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_HL_N1_N3

  • ASN_HL_N1_N3_ID — BIGINT
  • ASN_HL_N1_ID — BIGINT — NOT NULL — FK: ASN_HL_N1.ASN_HL_N1_ID
  • ADDRESS_LINE — VARCHAR(100) — NOT NULL — N301: Address Line
  • DELETE_YN — BOOLEAN — 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_HL_REF

  • ASN_HL_REF_ID — BIGINT
  • ASN_HL_ID — BIGINT — NOT NULL — FK: ASN_HL.ASN_HL_ID
  • REFERENCE_QUALIFIER — VARCHAR(10) — NOT NULL — REF01: Reference Qualifier
  • REFERENCE_IDENTIFICATION — VARCHAR(50) — NOT NULL — REF02: Reference Identification
  • DELETE_YN — BOOLEAN — 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_HL_TD1

  • ASN_HL_TD1_ID — BIGINT
  • ASN_HL_ID — BIGINT — NOT NULL — FK: ASN_HL.ASN_HL_ID
  • PACKAGING_CODE — VARCHAR(10) — NOT NULL — TD101: Packaging Code
  • LADING_QUANTITY — VARCHAR(10) — NOT NULL — TD102: Lading Quantity
  • WEIGHT_QUALIFIER — VARCHAR(5) — NOT NULL — TD106: Weight Qualifier
  • WEIGHT_VALUE — DECIMAL(15, 3) — NOT NULL — TD107: Weight Value
  • WEIGHT_UNIT — VARCHAR(5) — NOT NULL — TD108: Weight Unit
  • DELETE_YN — BOOLEAN — 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_HL_TD5

  • ASN_HL_TD5_ID — BIGINT
  • ASN_HL_ID — BIGINT — NOT NULL — FK: ASN_HL.ASN_HL_ID
  • ROUTING_SEQUENCE_CODE — VARCHAR(10) — NOT NULL — TD501: Routing Sequence Code
  • IDENTIFICATION_CODE_QUALIFIER — VARCHAR(10) — NOT NULL — TD502: Identification Code Qualifier
  • CARRIER_CODE — VARCHAR(20) — NOT NULL — TD503: Carrier Code
  • SERVICE_QUALIFIER — VARCHAR(10) — NOT NULL — TD504: Service Qualifier
  • TRANSPORT_MODE — VARCHAR(20) — NOT NULL — TD505: Transport Mode
  • DELETE_YN — BOOLEAN — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

COMPANY

  • COMPANY_ID — INT — NOT NULL
  • COMPANY_NAME — VARCHAR(200) — NOT NULL — 회사명
  • BUSINESS_REGISTRATION_NUMBER — VARCHAR(10) — NOT NULL — 사업자등록번호
  • CEO_NAME — VARCHAR(100) — NOT NULL — 대표자 성명
  • COMPANY_ADDR — VARCHAR(300) — NOT NULL — 회사 주소
  • COMPANY_BIZ_TYPE — VARCHAR(100) — NOT NULL — 회사 업태
  • COMPANY_BIZ_CLASS — VARCHAR(100) — NOT NULL — 회사 종목
  • DELETE_YN — BOOLEAN — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

INVOICE_DTM

  • INVOICE_DTM_ID — BIGINT
  • INVOICE_HEADER_ID — BIGINT — NOT NULL — 참조: INVOICE_HEADER.INVOICE_HEADER_ID
  • DATE_TIME_QUALIFIER — VARCHAR(3) — NOT NULL — DTM01: Date/Time Qualifier
  • DATE_VALUE — CHAR(8) — DTM02: Date (CCYYMMDD)
  • TIME_VALUE — VARCHAR(8) — DTM03: Time (옵션)
  • DELETE_YN — BOOLEAN — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

INVOICE_HEADER

  • INVOICE_HEADER_ID — BIGINT
  • TRANSACTION_SET_IDENTIFIER — VARCHAR(3) — NOT NULL — ST01: Transaction Set Identifier (예: "810")
  • TRANSACTION_SET_CONTROL_NUMBER — VARCHAR(9) — NOT NULL — ST02: Transaction Set Control Number
  • INVOICE_ISSUE_DATE — CHAR(8) — NOT NULL — BIG01: Invoice Issue Date (CCYYMMDD)
  • INVOICE_NUMBER — VARCHAR(22) — NOT NULL — BIG02: Invoice Number
  • INVOICE_DATE — CHAR(8) — BIG03: Invoice Date (CCYYMMDD)
  • PURCHASE_ORDER_NUMBER — VARCHAR(22) — BIG04: Purchase Order Number
  • TRANSACTION_TYPE_CODE — VARCHAR(2) — BIG07: Transaction Type Code (예: DI 또는 CR)
  • CURRENCY_ENTITY_IDENTIFIER — VARCHAR(3) — CUR01: Currency Entity Identifier (예: "SE")
  • CURRENCY_CODE — VARCHAR(3) — NOT NULL — CUR02: Currency Code (ISO, 예: "USD")
  • PARTY_ENTITY_IDENTIFIER — VARCHAR(3) — N101: Party Entity Identifier (예: "ST")
  • PARTY_NAME — VARCHAR(60) — N102: Party Name
  • PARTY_IDENTIFICATION_CODE_QUALIFIER — VARCHAR(2) — N103: Party Identification Code Qualifier
  • PARTY_IDENTIFICATION_CODE — VARCHAR(80) — N104: Party Identification Code
  • GEOGRAPHIC_CITY — VARCHAR(30) — N401: City Name
  • GEOGRAPHIC_STATE — VARCHAR(2) — N402: State or Province Code
  • GEOGRAPHIC_POSTAL_CODE — VARCHAR(15) — N403: Postal Code
  • GEOGRAPHIC_COUNTRY — VARCHAR(3) — N404: Country Code
  • TOTAL_AMOUNT — DECIMAL(15, 2) — NOT NULL — TDS01: Total Invoice Amount
  • LINE_ITEM_COUNT — INT — NOT NULL — CTT01: Number of Invoice Line Items
  • DELETE_YN — BOOLEAN — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

INVOICE_ITEM

  • INVOICE_ITEM_ID — BIGINT
  • INVOICE_HEADER_ID — BIGINT — NOT NULL — 참조: INVOICE_HEADER.INVOICE_HEADER_ID
  • ASSIGNED_IDENTIFICATION — VARCHAR(20) — IT101: Assigned Identification
  • QUANTITY_INVOICED — DECIMAL(10, 2) — NOT NULL — IT102: Quantity Invoiced
  • UNIT_OF_MEASURE — VARCHAR(2) — NOT NULL — IT103: Unit or Basis for Measurement (예: "EA")
  • UNIT_PRICE — DECIMAL(15, 2) — NOT NULL — IT104: Unit Price
  • PRODUCT_SERVICE_ID_QUALIFIER — VARCHAR(2) — NOT NULL — IT106: Product/Service ID Qualifier (예: "VP")
  • PRODUCT_SERVICE_ID — VARCHAR(48) — NOT NULL — IT107: Product/Service ID
  • ITEM_DESCRIPTION_TYPE — VARCHAR(1) — PID01: Item Description Type (예: "F")
  • ITEM_DESCRIPTION — VARCHAR(80) — PID05: Item Description
  • DELETE_YN — BOOLEAN — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

INVOICE_ITEM_TAX

  • INVOICE_ITEM_TAX_ID — BIGINT
  • INVOICE_ITEM_ID — BIGINT — NOT NULL — 참조: INVOICE_ITEM.INVOICE_ITEM_ID
  • TAX_TYPE_CODE — VARCHAR(2) — NOT NULL — TXI01: Tax Type Code
  • TAX_AMOUNT — DECIMAL(15, 2) — TXI02: Tax Amount
  • TAX_PERCENT — DECIMAL(5, 2) — TXI03: Tax Percent
  • DELETE_YN — BOOLEAN — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

INVOICE_NOTE

  • INVOICE_NOTE_ID — BIGINT
  • INVOICE_HEADER_ID — BIGINT — NOT NULL — 참조: INVOICE_HEADER.INVOICE_HEADER_ID
  • NOTE_TEXT — VARCHAR(255) — NTE: Note or Special Instruction
  • DELETE_YN — BOOLEAN — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

INVOICE_REFERENCE

  • INVOICE_REFERENCE_ID — BIGINT
  • INVOICE_HEADER_ID — BIGINT — NOT NULL — 참조: INVOICE_HEADER.INVOICE_HEADER_ID
  • REFERENCE_ID_QUALIFIER — VARCHAR(10) — NOT NULL — REF01: Reference Identification Qualifier
  • REFERENCE_IDENTIFICATION — VARCHAR(30) — REF02: Reference Identification
  • DELETE_YN — BOOLEAN — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

PO_DTM

  • PO_DTM_ID — BIGINT
  • PO_HEADER_ID — BIGINT — NOT NULL — FK: PO_HEADER
  • DATE_TIME_QUALIFIER — VARCHAR(10) — NOT NULL — DTM01: 날짜/시간 구분 코드
  • DATE_VALUE — CHAR(8) — NOT NULL — DTM02: 날짜 (CCYYMMDD)
  • DELETE_YN — BOOLEAN — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

PO_HEADER

  • PO_HEADER_ID — BIGINT
  • TRANSACTION_SET_PURPOSE_CODE — VARCHAR(10) — NOT NULL — BEG01: 거래 목적 코드
  • PURCHASE_ORDER_TYPE_CODE — VARCHAR(10) — NOT NULL — BEG02: 구매 주문 유형 코드
  • PURCHASE_ORDER_NUMBER — VARCHAR(50) — NOT NULL — BEG03: 구매 주문 번호
  • ORDER_DATE — CHAR(8) — NOT NULL — BEG05: 주문일 (CCYYMMDD)
  • REFERENCE_QUALIFIER — VARCHAR(10) — REF01: 참조 식별자 구분
  • REFERENCE_IDENTIFICATION — VARCHAR(50) — REF02: 참조 식별자
  • LINE_ITEM_COUNT — INT — NOT NULL — CTT01: 라인 아이템 수
  • DELETE_YN — BOOLEAN — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

PO_ITEM

  • PO_ITEM_ID — BIGINT
  • PO_HEADER_ID — BIGINT — NOT NULL — FK: PO_HEADER
  • LINE_ITEM_NUMBER — VARCHAR(20) — NOT NULL — PO101: 라인 아이템 번호
  • QUANTITY_ORDERED — DECIMAL(10, 2) — NOT NULL — PO102: 주문 수량
  • UNIT_OF_MEASURE — VARCHAR(5) — NOT NULL — PO103: 단위
  • UNIT_PRICE — DECIMAL(15, 2) — NOT NULL — PO104: 단가
  • PRICE_CODE — VARCHAR(10) — PO105: 단가 기준 코드
  • PRODUCT_SERVICE_ID_QUALIFIER — VARCHAR(10) — NOT NULL — PO106: 상품/서비스 ID 구분
  • PRODUCT_SERVICE_ID — VARCHAR(50) — NOT NULL — PO107: 상품/서비스 ID
  • DELETE_YN — BOOLEAN — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

PO_PARTY

  • PO_PARTY_ID — BIGINT
  • PO_HEADER_ID — BIGINT — NOT NULL — FK: PO_HEADER
  • PARTY_ENTITY_IDENTIFIER — VARCHAR(10) — NOT NULL — N101: 파티 식별 코드
  • PARTY_NAME — VARCHAR(60) — N102: 파티 명
  • PARTY_ID_CODE_QUALIFIER — VARCHAR(10) — N103: 식별 코드 구분
  • PARTY_IDENTIFICATION — VARCHAR(80) — N104: 식별 코드
  • CITY — VARCHAR(50) — N4.N401: 도시명
  • STATE — VARCHAR(10) — N4.N402: 주/도 코드
  • POSTAL_CODE — VARCHAR(20) — N4.N403: 우편번호
  • COUNTRY_CODE — VARCHAR(10) — N4.N404: 국가 코드
  • DELETE_YN — BOOLEAN — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

PO_PARTY_ADDRESS

  • PO_PARTY_ADDRESS_ID — BIGINT
  • PO_PARTY_ID — BIGINT — NOT NULL — FK: PO_PARTY
  • ADDRESS_LINE — VARCHAR(100) — NOT NULL — N3.N301: 주소 정보
  • DELETE_YN — BOOLEAN — 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_HEADER

  • PRODUCT_ID — BIGINT
  • CATEGORY — VARCHAR(50) — CATEGORY
  • PRODUCT_NO — VARCHAR(100) — NOT NULL — PN
  • CUSTOMER_PRODUCT_NO — VARCHAR(100) — ERP PN (DOUBUL)
  • PRODUCT_DESC — VARCHAR(255) — DESCRIPTION (INVOICE)
  • CUSTOMER_PRODUCT_DESC — VARCHAR(255) — ERP DESCRIPTION (DOUBUL)
  • ORDER_PRICE_WO_VAT — DECIMAL(15, 2) — ORDER PRICE (w/o VAT)
  • CARTON — VARCHAR(50) — CARTON
  • DELETE_YN — BOOLEAN — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

PURCHASE_ORDER_ACK

  • PURCHASE_ORDER_ACK_ID — BIGINT
  • TRANSACTION_SET_PURPOSE_CODE — VARCHAR(2) — NOT NULL — BAK01: 거래 목적 코드 (예: "00")
  • ACKNOWLEDGMENT_TYPE — VARCHAR(2) — NOT NULL — BAK02: ACK 타입 (예: "AC")
  • PURCHASE_ORDER_NUMBER — VARCHAR(22) — NOT NULL — BAK03: 구매 주문 번호
  • PURCHASE_ORDER_DATE — DATE — NOT NULL — BAK04: 날짜 (YYYYMMDD)
  • LINE_ITEM_COUNT — INT — NOT NULL — CTT01: PO1 라인 아이템 수
  • DELETE_YN — BOOLEAN — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

PURCHASE_ORDER_ACK_ITEM

  • PURCHASE_ORDER_ACK_ITEM_ID — BIGINT
  • PURCHASE_ORDER_ACK_ID — BIGINT — NOT NULL — 참조: PURCHASE_ORDER_ACK.PURCHASE_ORDER_ACK_ID
  • LINE_ITEM_IDENTIFIER — VARCHAR(20) — NOT NULL — PO101: 라인 아이템 식별자
  • QUANTITY_ORDERED — DECIMAL(10, 2) — NOT NULL — PO102: 주문 수량
  • UNIT_OF_MEASURE — VARCHAR(2) — NOT NULL — PO103: 단위 (예: "EA")
  • UNIT_PRICE — DECIMAL(10, 2) — NOT NULL — PO104: 단가
  • ADDITIONAL_CODE — VARCHAR(2) — PO105: 추가 코드 (옵션, 예: "WE", "VN")
  • PRODUCT_SERVICE_ID_QUALIFIER — VARCHAR(2) — NOT NULL — PO106: 상품/서비스 ID 구분 (예: "VP")
  • PRODUCT_SERVICE_ID — VARCHAR(48) — PO107: 상품/서비스 ID
  • DELETE_YN — BOOLEAN — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

PURCHASE_ORDER_ACK_ITEM_ACK

  • PURCHASE_ORDER_ACK_ITEM_ACK_ID — BIGINT
  • PURCHASE_ORDER_ACK_ITEM_ID — BIGINT — NOT NULL — 참조: PURCHASE_ORDER_ACK_ITEM.PURCHASE_ORDER_ACK_ITEM_ID
  • LINE_ITEM_STATUS_CODE — VARCHAR(2) — NOT NULL — ACK01: 라인 아이템 상태 코드 (예: "IA", "IP", "IB")
  • ACK_QUANTITY — DECIMAL(10, 2) — NOT NULL — ACK02: 수량
  • ACK_UNIT_OF_MEASURE — VARCHAR(2) — NOT NULL — ACK03: 단위 (예: "EA")
  • ACK_DATE — DATE — NOT NULL — ACK04: 날짜 (YYYYMMDD)
  • DELETE_YN — BOOLEAN — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL

PURCHASE_ORDER_ACK_PARTY

  • PURCHASE_ORDER_ACK_PARTY_ID — BIGINT
  • PURCHASE_ORDER_ACK_ID — BIGINT — NOT NULL — 참조: PURCHASE_ORDER_ACK.PURCHASE_ORDER_ACK_ID
  • ENTITY_IDENTIFIER_CODE — VARCHAR(3) — NOT NULL — N101: Entity Identifier Code (예: "ST", "BT")
  • PARTY_NAME — VARCHAR(60) — N102: 파티 이름
  • IDENTIFICATION_CODE_QUALIFIER — VARCHAR(2) — N103: 식별자 코드 구분 (예: "92", "91")
  • IDENTIFICATION_CODE — VARCHAR(80) — N104: 식별자 코드
  • DELETE_YN — BOOLEAN — 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 — NOT NULL
  • USER_NAME — VARCHAR(100) — NOT NULL
  • COMPANY_ID — INT — NOT NULL — Company Id
  • PASSWORD — VARCHAR(255) — NOT NULL
  • ROLE_TYPE — VARCHAR(20) — NOT NULL
  • DELETE_YN — BOOLEAN — NOT NULL
  • INSERT_OPERATOR — VARCHAR(50) — NOT NULL
  • UPDATE_OPERATOR — VARCHAR(50) — NOT NULL
  • INSERT_DATE — TIMESTAMP — NOT NULL
  • UPDATE_DATE — TIMESTAMP — NOT NULL