Business Operating in Taiwan - Chinese names (Taiwanese identifiers) - 4K
Business operating in Taiwan, given the presence of Chinese names and references to Taiwanese identifiers. The dataset includes various fields related to orders, customer information, shipping details, and invoicing.
Field Breakdown:
- ord_no: Order Number
- ord_date2: Order Date (formatted)
- ord_date: Order Date (timestamp)
- jit_no: JIT (Just In Time) Number
- mb_no: Member/Customer Number
- mb_name: Member/Customer Name
- add_send: Shipping Address
- send_method: Shipping Method
- tel_send: Contact Number
- pv_date: Delivery Date
- pv_month: Delivery Month
- remark: Remarks or Notes
- io_kind: Order Type or Category
- week_no: Week Number of the Order
- order_kind: Order Category/Type
- jit_name: JIT (Just In Time) Name
- country_id: Country Identifier
- sn: Serial Number
- order_pv: Order PV (Possibly Point Value or similar metric)
- order_money: Total Order Value
- total_pv: Total Point Value
- total_money: Total Money (including all orders)
- total_paid_money: Total Paid Amount
- invoice_date: Date of Invoice
- invoice_no: Invoice Number
- update_user: User who updated the record
- data_timestamp: Timestamp of Data Creation or Update
- create_date: Date of Record Creation
- send_money: Shipping Cost
- update_state: Status of Update
- ord_m_no: Order Member Number
- ps: Additional Notes
- memo: Memo/Comments
- ord_state: Order Status
- boss_id: Supervisor/Boss ID
- service_no: Service Number
- name_send: Name of the Recipient
- sub_no: Sub-Order Number
- sub_name: Sub-Order Name
- b_tax_oym: Business Tax OYM
- b_tax_oform: Business Tax Form
- b_tax_omoney: Business Tax Amount
- b_tax_okind: Business Tax Type
- b_tax_otax: Business Tax Value
- flag: Status Flag (indicating specific states such as completed, pending, etc.)
- b_tax_ocf: Business Tax Confirmation
- user_confirm: Confirmation by User
- order_seq: Order Sequence
- create_user: User who created the record
- ds_no: Distribution/Sales Number
- ds_name: Distribution/Sales Name
- out_date: Date of Shipment
- dis: Distribution Indicator
- out_no: Outbound Number (Shipment)
- out_ok: Outbound Status
- true_intro_no: Actual Introduction Number
- intro_no: Introduction Number
- true_intro_name: Actual Introducer Name
- intro_name: Introducer Name
- line_kind: Type of Order Line
- deduct_mo: Deduction Month
- deduct: Deduction Amount
- printmark: Print Mark (whether the order has been printed)
- spgateway: Payment Gateway Information
- CarrierType: Type of Carrier (related to invoice or shipping)
- CarrierType2: Additional Carrier Type
- CarrierType1: Primary Carrier Type
- invoice_title: Title on the Invoice
- city3: City (possibly related to the shipping or billing address)
- area3: Area/District
- areas3: Additional Area Details
- invoice_back: Invoice Backup/Record
- NPOBAN: Non-Profit Organization BAN (Business Number?)
- RelateNumber: Related Number (possibly linking to another record)
- man_memo: Manual Memo/Notes
- son_mb_no: Sub-Member Number
- vord_no_myself: Self-Order Number
- veget: Possibly "vegetarian" or another indicator related to the order
- city3_2: Secondary City Information
- areas3_2: Secondary Area Information
- area3_2: Secondary Area Information (further detailed)
- add_send_2: Secondary Shipping Address
Sample Data Breakdown:
- Order 22072200001
- Customer: 王柏森
- Order Date: 2022-07-22
- Shipping Address: 安康路315巷7-1號2樓
- Total Money: 0
- Order Status: Not yet paid or shipped
- Invoice Date: N/A
- Order 22072400002
- Customer: 王柏森二
- Order Date: 2022-07-24
- Shipping Address: 安樂街72巷17弄135號
- Total Money: 3750
- Order Status: Paid and invoiced on 2022-07-24
- Invoice Number: XC11011129