그룹(수탁)

테이블 (4)

T_GROUP_TRADE_DETAIL (CopyOf거래원장)

  • SEQ_TRADE (Key) — \ — 기본 키 — NOT NULL
  • SEQ_SHOP (Field)
  • SEQ_BUYER (Field2)
  • TOTAL_TAX_PRICE (Field3)
  • TOTAL_SUPPLY_PRICE (Field4)
  • TRADE_DAY (Field5)
  • SYSTEM_DATE (Field6)
  • POS_DAY (Field7)
  • TRADE_TYPE (Field8)
  • AFTER_IN_OUT_PRICE (Field9)
  • AFTER_IN_OUT_DISCOUNT (Field10)
  • SEQ_BUYER_GROUP (Field11)
  • BEFORE_TAB (Field12)
  • AFTER_TAB (Field13)
  • POS_DATE (Field14)
  • MODIFY_DATE (Field15)
  • REGISTER (Field16)
  • MODIFY_USER (Field17)
  • AFTER_IN_OUT_DISCOUNT (Field18)
  • TOTAL_ITEM_COUNT (Field19)
  • RECEIPT_NUMBER (Field20)
  • DISCOUNT_PRICE (Field21)
  • TOTAL_PRICE (Field22)
  • TOTAL_TAB_PRICE (Field23)
  • AFTER_IN_OUT_METHOD_CHOICE (Field24)
  • AFTER_IN_OUT_ACCOUNT_VIEW (Field25)
  • RECEIPT_MEMO (Field26)
  • TOTAL_DEDUCT_PRICE (Field27)
  • AFTER_IN_OUT_PROXY_PRICE (Field28)
  • TOTAL_MINUS_DEBUCT (Field29)
  • SEQ_EMPLOYEE (Field30)
  • BEFORE_TAB_SALES (Field31)
  • AFTER_TAB_SALES (Field34)
  • BEFORE_TAB_BUY (Field32)
  • AFTER_TAB_BUY (Field33)
  • DETAIL_ORDER (Field37)
  • Field35

T_GROUP_TRADE_SUMMARY (CopyOfCopyOf거래원장)

  • SEQ_TRADE_GROUP (Key) — \ — 기본 키 — NOT NULL
  • SEQ_SHOP (Field)
  • TOTAL_TAX_PRICE (Field3)
  • TOTAL_SUPPLY_PRICE (Field4)
  • TRADE_DAY (Field5)
  • SYSTEM_DATE (Field6)
  • POS_DAY (Field7)
  • AFTER_IN_OUT_PRICE (Field9)
  • SEQ_BUYER_GROUP (Field11)
  • BEFORE_TAB (Field12)
  • AFTER_TAB (Field13)
  • POS_DATE (Field14)
  • MODIFY_DATE (Field15)
  • REGISTER (Field16)
  • MODIFY_USER (Field17)
  • AFTER_IN_OUT_DISCOUNT (Field18)
  • TOTAL_ITEM_COUNT (Field19)
  • RECEIPT_NUMBER (Field20)
  • DISCOUNT_PRICE (Field21)
  • TOTAL_PRICE (Field22)
  • TOTAL_TAB_PRICE (Field23)
  • RECEIPT_MEMO (Field26)
  • TOTAL_DEDUCT_PRICE (Field27)
  • AFTER_IN_OUT_PROXY_PRICE (Field28)
  • TOTAL_MINUS_DEBUCT (Field29)
  • SEQ_EMPLOYEE (Field30)
  • BEFORE_TAB_SALES (Field31)
  • AFTER_TAB_SALES (Field34)
  • BEFORE_TAB_BUY (Field32)
  • AFTER_TAB_BUY (Field33)
  • TRADE_TYPE (Field35)
  • AFTER_IN_OUT_METHOD_CHOICE (Field24)
  • AFTER_IN_OUT_ACCOUNT_VIEW (Field25)

T_TRADE_DETAIL (거래원장 상세)

  • SEQ_TRADE_DETAIL (Key) — 기본 키 — NOT NULL
  • ITEM_COUNT (Field)
  • UNIT_VIEW (Field2)
  • UNIT_PRICE (Field3)
  • SUBTOTAL_PRICE (Field4)
  • TAX_PRICE (Field5)
  • SUPPLY_PRICE (Field6)
  • SEQ_TRADE (Field7)
  • SEQ_PRODUCT (Field8)
  • ITEM_NAME (Field9)
  • ITEM_SIZE (Field10)
  • ITEM_COUNTRY (Field11)
  • ITEM_NAME_VIEW (Field12)
  • ITEM_NAME_TABLET (Field13)
  • ITEM_NAME_RECEIPT (Field14)
  • DETAIL_ORDER (Field15)
  • BEFORE_STOCK (Field16)
  • AFTER_STOCK (Field17)
  • BEFORE_UNIT_PRICE (Field18)

T_TRADE_SUMMARY (거래원장)

  • SEQ_TRADE (Key) — \ — 기본 키 — NOT NULL
  • SEQ_SHOP (Field)
  • SEQ_BUYER (Field2)
  • TOTAL_TAX_PRICE (Field3)
  • TOTAL_SUPPLY_PRICE (Field4)
  • TRADE_DAY (Field5)
  • SYSTEM_DATE (Field6)
  • POS_DAY (Field7)
  • TRADE_TYPE (Field8)
  • AFTER_IN_OUT_PRICE (Field9)
  • AFTER_IN_OUT_DISCOUNT (Field10)
  • SEQ_BUYER_GROUP (Field11)
  • BEFORE_TAB (Field12)
  • AFTER_TAB (Field13)
  • POS_DATE (Field14)
  • MODIFY_DATE (Field15)
  • REGISTER (Field16)
  • MODIFY_USER (Field17)
  • AFTER_IN_OUT_DISCOUNT (Field18)
  • TOTAL_ITEM_COUNT (Field19)
  • RECEIPT_NUMBER (Field20)
  • DISCOUNT_PRICE (Field21)
  • TOTAL_PRICE (Field22)
  • TOTAL_TAB_PRICE (Field23)
  • AFTER_IN_OUT_METHOD_CHOICE (Field24)
  • AFTER_IN_OUT_ACCOUNT_VIEW (Field25)
  • RECEIPT_MEMO (Field26)
  • TOTAL_DEDUCT_PRICE (Field27)
  • AFTER_IN_OUT_PROXY_PRICE (Field28)
  • TOTAL_MINUS_DEBUCT (Field29)
  • SEQ_EMPLOYEE (Field30)
  • BEFORE_TAB_SALES (Field31)
  • AFTER_TAB_SALES (Field34)
  • BEFORE_TAB_BUY (Field32)
  • AFTER_TAB_BUY (Field33)
  • C_PRINT_COUNT (Field35)
  • D_PRINT_COUNT (Field36)
  • S_PRINT_COUNT (Field37)