그룹(수탁)
테이블 (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)