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