1 files changed, 180 insertions, 0 deletions
diff --git a/config/poColumnsConfig.ts b/config/poColumnsConfig.ts
new file mode 100644
index 00000000..6466f3e1
--- /dev/null
+++ b/config/poColumnsConfig.ts
@@ -0,0 +1,180 @@
+import { Contract } from "@/db/schema/contract"
+
+export interface PoColumnConfig {
+  id: keyof Contract
+  label: string
+  group?: string
+  excelHeader?: string
+  type?: string
+}
+
+export const poColumnsConfig: PoColumnConfig[] = [
+  {
+    id: "id",
+    label: "ID",
+    excelHeader: "ID",
+    group: "Key Info",
+    type: "number",
+  },
+  {
+    id: "projectId",
+    label: "Project ID",
+    excelHeader: "Project ID",
+    group: "Key Info",
+    type: "number",
+  },
+  {
+    id: "vendorId",
+    label: "Vendor ID",
+    excelHeader: "Vendor ID",
+    group: "Key Info",
+    type: "number",
+  },
+  {
+    id: "contractNo",
+    label: "Form Code",
+    excelHeader: "Form Code",
+    group: "Basic Info",
+    type: "text",
+  },
+  {
+    id: "contractName",
+    label: "Contract Name",
+    excelHeader: "Contract Name",
+    group: "Basic Info",
+    type: "text",
+  },
+  {
+    id: "status",
+    label: "Status",
+    excelHeader: "Status",
+    group: "Basic Info",
+    type: "text",
+  },
+  {
+    id: "startDate",
+    label: "Start Date",
+    excelHeader: "Start Date",
+    group: "Dates",
+    type: "date",
+  },
+  {
+    id: "endDate",
+    label: "End Date",
+    excelHeader: "End Date",
+    group: "Dates",
+    type: "date",
+  },
+  {
+    id: "paymentTerms",
+    label: "Payment Terms",
+    excelHeader: "Payment Terms",
+    group: "PO Info",
+    type: "text",
+  },
+  {
+    id: "deliveryTerms",
+    label: "Delivery Terms",
+    excelHeader: "Delivery Terms",
+    group: "PO Info",
+    type: "text",
+  },
+  {
+    id: "deliveryDate",
+    label: "Delivery Date",
+    excelHeader: "Delivery Date",
+    group: "PO Info",
+    type: "date",
+  },
+  {
+    id: "deliveryLocation",
+    label: "Delivery Location",
+    excelHeader: "Delivery Location",
+    group: "PO Info",
+    type: "text",
+  },
+  {
+    id: "currency",
+    label: "Currency",
+    excelHeader: "Currency",
+    group: "Money",
+    type: "text",
+  },
+  {
+    id: "totalAmount",
+    label: "Total Amount",
+    excelHeader: "Total Amount",
+    group: "Money",
+    type: "number",
+  },
+  {
+    id: "discount",
+    label: "Discount",
+    excelHeader: "Discount",
+    group: "Money",
+    type: "number",
+  },
+  {
+    id: "tax",
+    label: "Tax",
+    excelHeader: "Tax",
+    group: "Money",
+    type: "number",
+  },
+  {
+    id: "shippingFee",
+    label: "Shipping Fee",
+    excelHeader: "Shipping Fee",
+    group: "Money",
+    type: "number",
+  },
+  {
+    id: "netTotal",
+    label: "Net Total",
+    excelHeader: "Net Total",
+    group: "Money",
+    type: "number",
+  },
+  {
+    id: "partialShippingAllowed",
+    label: "Partial Shipping",
+    excelHeader: "Partial Shipping",
+    group: "Options",
+    type: "boolean",
+  },
+  {
+    id: "partialPaymentAllowed",
+    label: "Partial Payment",
+    excelHeader: "Partial Payment",
+    group: "Options",
+    type: "boolean",
+  },
+  {
+    id: "remarks",
+    label: "Remarks",
+    excelHeader: "Remarks",
+    group: "Notes",
+    type: "text",
+  },
+  {
+    id: "version",
+    label: "Version",
+    excelHeader: "Version",
+    group: "Versioning",
+    type: "number",
+  },
+  {
+    id: "createdAt",
+    label: "Created At",
+    excelHeader: "Created At",
+    group: "System Info",
+    type: "date",
+  },
+  {
+    id: "updatedAt",
+    label: "Updated At",
+    excelHeader: "Updated At",
+    group: "System Info",
+    type: "date",
+  },
+]
+\ No newline at end of file