# 綠界科技 全方位金流

###### tags: `金流` `綠界`

| request<SUB>(產生訂單)</SUB> | response<SUB>(付款結果通知)</SUB> | attribute<SUB>(資料表欄位)</SUB> | data type<SUB>(資料型態)</SUB> | |
| - | - | - | - | - |
| `MerchantID` | `MerchantID` | `merchant_id` | `varchar(10)` | 特店編號 |
| `MerchantTradeNo` | `MerchantTradeNo` | `merchant_trade_no` | `varchar(20)` | 特店交易編號 |
| `StoreID` | `StoreID` | `store_id` | `varchar(20)` | 特店旗下店舖代號 |
| `MerchantTradeDate` | | `merchant_trade_date` | `varchar(20)` | 特店交易時間 |
| `PaymentType` | `PaymentType` | `payment_type` | `varchar(20)` | <UL><LI>交易類型<SUB>(request)</SUB></LI><LI>特店選擇的付款方式<SUB>(response)</SUB></LI></UL> |
| `TotalAmount` | | `total_amount` | `int` | 交易金額 |
| `TradeDesc` | | `trade_desc` | `varchar(200)` | 交易描述 |
| `ItemName` | | `item_name` | `varchar(400)` | 商品名稱 |
| `ReturnURL` | | `return_url` | `varchar(200)` | 付款完成通知回傳網址 |
| `ChoosePayment` | | `choose_payment` | `varchar(20)` | 預設付款方式 |
| `ClientBackURL` | | `client_back_url` | `varchar(200)` | 消費者端返回特店的按鈕連結 |
| `IgnorePayment` | | `ignore_payment` | `varchar(100)` | 隱藏付款方式 |
| `InvoiceMark` | | `invoice_mark` | `varchar(1)` | 電子發票開立註記 |
| `EncryptType` | | `encrypt_type` | `int` | 加密類型 |
| `ExpireDate` | | `expire_date` | `int` | 允許繳費有效天數 |
| `StoreExpireDate` | | `store_expire_date` | `int` | 超商繳費截止時間 |
| `Redeem` | | `redeem` | `varchar(1)` | 信用卡是否使用紅利折抵 |
| `CustomField1` | `CustomField1` | `custom_field1` | `varchar(50)` | 自訂名稱欄位1 |
| `CustomField2` | `CustomField2` | `custom_field2` | `varchar(50)` | 自訂名稱欄位2 |
| `CustomField3` | `CustomField3` | `custom_field3` | `varchar(50)` | 自訂名稱欄位3 |
| `CustomField4` | `CustomField4` | `custom_field4` | `varchar(50)` | 自訂名稱欄位4 |
| `CheckMacValue` | `CheckMacValue` | `check_mac_value` | `varchar` | 檢查碼 |
| | `RtnCode` | `rtn_code` | `int` | 交易狀態 |
| | `RtnMsg` | `rtn_msg` | `varchar(200)` | 交易訊息 |
| | `TradeNo` | `trade_no` | `varchar(20)` | 綠界的交易編號 |
| | `TradeAmt` | `trade_amt` | `int` | 交易金額 |
| | `PaymentDate` | `payment_date` | ~~`varchar(20)`~~`timestamptz` | 付款時間 |
| | ~~`PaymentType`~~ | ~~`payment_type`~~ | ~~`varchar(20)`~~ | ~~特店選擇的付款方式~~ |
| | `PaymentTypeChargeFee` | `payment_type_charge_fee` | `int` | 通路費 |
| | `TradeDate` | `trade_date` | ~~`varchar(20)`~~`timestamptz` | 訂單成立時間 |
| | `SimulatePaid` | `simulate_paid` | `int` | 是否為模擬付款 |

## DDL

CREATE TABLE"lu_jie_ke_ji_quan_fang_wei_jin_liu"(
	"id"uuid PRIMARY KEY,
	"merchant_id"varchar(10),
	"merchant_trade_no"varchar(20),
	"store_id"varchar(20),
	"merchant_trade_date"varchar(20),
	"payment_type"varchar(20),
	"total_amount"int,
	"trade_desc"varchar(200),
	"item_name"varchar(400),
	"return_url"varchar(200),
	"choose_payment"varchar(20),
	"client_back_url"varchar(200),
	"ignore_payment"varchar(100),
	"invoice_mark"varchar(1),
	"encrypt_type"int,
	"expire_date"int,
	"store_expire_date"int,
	"redeem"varchar(1),
	"check_mac_value"varchar,
	"rtn_code"int,
	"rtn_msg"varchar(200),
	"trade_no"varchar(20),
	"trade_amt"int,
	"payment_date"/*varchar(20)*/timestamptz,
--	"payment_type"varchar(20),
	"payment_type_charge_fee"int,
	"trade_date"/*varchar(20)*/timestamptz,
	"simulate_paid"int,
	"custom_field1"varchar(50),
	"custom_field2"varchar(50),
	"custom_field3"varchar(50),
	"custom_field4"varchar(50)
);
COMMENT ON TABLE"lu_jie_ke_ji_quan_fang_wei_jin_liu"IS'轮播';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."id"IS'主键';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."merchant_id"IS'特店編號';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."merchant_trade_no"IS'特店交易編號';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."store_id"IS'特店旗下店舖代號';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."merchant_trade_date"IS'特店交易時間';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."payment_type"IS'交易類型|特店選擇的付款方式';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."total_amount"IS'交易金額';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."trade_desc"IS'交易描述';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."item_name"IS'商品名稱';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."return_url"IS'付款完成通知回傳網址';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."choose_payment"IS'預設付款方式';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."client_back_url"IS'消費者端返回特店的按鈕連結';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."ignore_payment"IS'隱藏付款方式';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."invoice_mark"IS'電子發票開立註記';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."encrypt_type"IS'加密類型';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."expire_date"IS'允許繳費有效天數';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."store_expire_date"IS'超商繳費截止時間';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."redeem"IS'信用卡是否使用紅利折抵';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."check_mac_value"IS'檢查碼';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."rtn_code"IS'交易狀態';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."rtn_msg"IS'交易訊息';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."trade_no"IS'綠界的交易編號';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."trade_amt"IS'交易金額';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."payment_date"IS'付款時間';
--	COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."payment_type"IS'特店選擇的付款方式';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."payment_type_charge_fee"IS'通路費';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."trade_date"IS'訂單成立時間';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."simulate_paid"IS'是否為模擬付款';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."custom_field1"IS'自訂名稱欄位1';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."custom_field2"IS'自訂名稱欄位2';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."custom_field3"IS'自訂名稱欄位3';
COMMENT ON COLUMN"lu_jie_ke_ji_quan_fang_wei_jin_liu"."custom_field4"IS'自訂名稱欄位4';