Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloinvoiceitemset

created: 2023-10-17 01:57:34
disabled: False
format: raw
id: 1663
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_drivethru",
    "table": "molo_moloinvoiceitemset"
}

type: drivethrucsv

Schema Versions: 15

Version 1717695

created: 2026-04-17 03:07:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceitemset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceitemset`\n(\n `Id`  string , `Prefix`  string , `Quantity`  string , `Title`  string , `Type`  string , `Value`  string , `Discount`  string , `DiscountType`  string , `Taxable`  string , `Tax`  string , `Misc`  string , `DiscountTotal`  string , `PriceSuffix`  string , `SubTotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Total`  string , `InvoiceId`  string , `ChargeGroup`  string , `PaymentAccount`  string , `PriceStr`  string , `IsVoid`  string , `Date`  string , `TextAux`  string , `TextAux2`  string , `DiscountDateTime`  string , `DiscountUserId`  string , `Notes`  string , `PR_Type`  string , `Status`  string , `DeletionUserId`  string , `DeletionDateTime`  string , `OverpaymentId`  string , `VoidUser`  string , `VoidDateTime`  string , `Misc2`  string , `PrepaymentId`  string , `CreditInvoiceId`  string , `AllocationType`  string , `Reservation_Id`  string , `ItemMaster_Id`  string , `AspNetUser_Id`  string , `InvoiceItemType_Id`  string , `SeasonalPrice_Id`  string , `TransientPrice_Id`  string , `SVJobId`  string , `OriginalCreditItem`  string , `TaxExempt`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `DeletionReason`  string , `VoidReason`  string , `StartDateTime`  string , `EndDateTime`  string , `CreationPartnerId`  string , `DeletePartnerId`  string , `VoidPartnerId`  string , `OriginalPrice`  string , `OverrideXeroTaxRate`  string , `OverrideXeroSalesAccount`  string , `OriginalReservationPrice`  string , `NumberOfDecimals`  string , `StripeTransactionData_Id`  string , `ValueAlternative`  string , `StripeTerminalId`  string , `StripeApplicationName`  string , `StripeAID`  string , `EnteredAmount`  string , `ExchangeRate`  string , `Currencies_Id`  string , `SV_ChargeInstance_Id`  string , `SV_LaborInstance_Id`  string , `SV_PartInstance_Id`  string , `RevenueGLCode`  string , `ARGLCode`  string , `PaymentGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `SalesTaxGLCode`  string , `PrepaymentGLCode`  string , `AccountType`  string , `ApplicationCryptogram`  string , `AuthorizationCode`  string , `AuthorizationResponseCode`  string , `CardholderVerificationMethod`  string , `TerminalVerificationResults`  string , `TransactionStatusInformation`  string , `TrackingCode`  string , `DiscountGLCode`  string , `OverrideTrackingCategory1`  string , `OverrideTrackingCategory2`  string , `QuickbooksPaymentId`  string , `AllowTotalPriceEntry`  string , `AddedAutomatically`  string , `AllocationPerformedDate`  string , `CreatedDate`  string , `IsHidden`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-17/1776412777'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceitemset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-17/1776412777
id: 1717695
processed: 1

raw_data:

{
    "ARGLCode": 74,
    "AccountType": 80,
    "AddedAutomatically": 93,
    "AllocationPerformedDate": 94,
    "AllocationType": 38,
    "AllowTotalPriceEntry": 92,
    "ApplicationCryptogram": 81,
    "AspNetUser_Id": 41,
    "AuthorizationCode": 82,
    "AuthorizationResponseCode": 83,
    "COGSGLCode": 76,
    "CardholderVerificationMethod": 84,
    "ChargeGroup": 18,
    "CreatedDate": 95,
    "CreationPartnerId": 54,
    "CreditInvoiceId": 37,
    "Currencies_Id": 69,
    "Date": 22,
    "DeletePartnerId": 55,
    "DeletionDateTime": 31,
    "DeletionReason": 50,
    "DeletionUserId": 30,
    "Discount": 6,
    "DiscountDateTime": 25,
    "DiscountGLCode": 88,
    "DiscountTotal": 11,
    "DiscountType": 7,
    "DiscountUserId": 26,
    "EndDateTime": 53,
    "EnteredAmount": 67,
    "ExchangeRate": 68,
    "Id": 0,
    "InventoryGLCode": 77,
    "InvoiceId": 17,
    "InvoiceItemType_Id": 42,
    "IsHidden": 96,
    "IsVoid": 21,
    "ItemMaster_Id": 40,
    "LastModifiedAspNetUser": 49,
    "LastModifiedDateTime": 48,
    "Misc": 10,
    "Misc2": 35,
    "Notes": 27,
    "NumberOfDecimals": 61,
    "OriginalCreditItem": 46,
    "OriginalPrice": 57,
    "OriginalReservationPrice": 60,
    "OverpaymentId": 32,
    "OverrideTrackingCategory1": 89,
    "OverrideTrackingCategory2": 90,
    "OverrideXeroSalesAccount": 59,
    "OverrideXeroTaxRate": 58,
    "PR_Type": 28,
    "PaymentAccount": 19,
    "PaymentGLCode": 75,
    "Prefix": 1,
    "PrepaymentGLCode": 79,
    "PrepaymentId": 36,
    "PriceStr": 20,
    "PriceSuffix": 12,
    "Quantity": 2,
    "QuickbooksPaymentId": 91,
    "Reservation_Id": 39,
    "RevenueGLCode": 73,
    "SVJobId": 45,
    "SV_ChargeInstance_Id": 70,
    "SV_LaborInstance_Id": 71,
    "SV_PartInstance_Id": 72,
    "SalesTaxGLCode": 78,
    "SeasonalPrice_Id": 43,
    "StartDateTime": 52,
    "Status": 29,
    "StripeAID": 66,
    "StripeApplicationName": 65,
    "StripeTerminalId": 64,
    "StripeTransactionData_Id": 62,
    "SubTotal": 13,
    "SubtotalWoDiscount": 14,
    "Tax": 9,
    "TaxExempt": 47,
    "TaxTotal": 15,
    "Taxable": 8,
    "TerminalVerificationResults": 85,
    "TextAux": 23,
    "TextAux2": 24,
    "Title": 3,
    "Total": 16,
    "TrackingCode": 87,
    "TransactionStatusInformation": 86,
    "TransientPrice_Id": 44,
    "Type": 4,
    "Value": 5,
    "ValueAlternative": 63,
    "VoidDateTime": 34,
    "VoidPartnerId": 56,
    "VoidReason": 51,
    "VoidUser": 33
}

schema_attributes:

{
    "ARGLCode": "string",
    "AccountType": "string",
    "AddedAutomatically": "string",
    "AllocationPerformedDate": "string",
    "AllocationType": "string",
    "AllowTotalPriceEntry": "string",
    "ApplicationCryptogram": "string",
    "AspNetUser_Id": "string",
    "AuthorizationCode": "string",
    "AuthorizationResponseCode": "string",
    "COGSGLCode": "string",
    "CardholderVerificationMethod": "string",
    "ChargeGroup": "string",
    "CreatedDate": "string",
    "CreationPartnerId": "string",
    "CreditInvoiceId": "string",
    "Currencies_Id": "string",
    "Date": "string",
    "DeletePartnerId": "string",
    "DeletionDateTime": "string",
    "DeletionReason": "string",
    "DeletionUserId": "string",
    "Discount": "string",
    "DiscountDateTime": "string",
    "DiscountGLCode": "string",
    "DiscountTotal": "string",
    "DiscountType": "string",
    "DiscountUserId": "string",
    "EndDateTime": "string",
    "EnteredAmount": "string",
    "ExchangeRate": "string",
    "Id": "string",
    "InventoryGLCode": "string",
    "InvoiceId": "string",
    "InvoiceItemType_Id": "string",
    "IsHidden": "string",
    "IsVoid": "string",
    "ItemMaster_Id": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "Misc": "string",
    "Misc2": "string",
    "Notes": "string",
    "NumberOfDecimals": "string",
    "OriginalCreditItem": "string",
    "OriginalPrice": "string",
    "OriginalReservationPrice": "string",
    "OverpaymentId": "string",
    "OverrideTrackingCategory1": "string",
    "OverrideTrackingCategory2": "string",
    "OverrideXeroSalesAccount": "string",
    "OverrideXeroTaxRate": "string",
    "PR_Type": "string",
    "PaymentAccount": "string",
    "PaymentGLCode": "string",
    "Prefix": "string",
    "PrepaymentGLCode": "string",
    "PrepaymentId": "string",
    "PriceStr": "string",
    "PriceSuffix": "string",
    "Quantity": "string",
    "QuickbooksPaymentId": "string",
    "Reservation_Id": "string",
    "RevenueGLCode": "string",
    "SVJobId": "string",
    "SV_ChargeInstance_Id": "string",
    "SV_LaborInstance_Id": "string",
    "SV_PartInstance_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonalPrice_Id": "string",
    "StartDateTime": "string",
    "Status": "string",
    "StripeAID": "string",
    "StripeApplicationName": "string",
    "StripeTerminalId": "string",
    "StripeTransactionData_Id": "string",
    "SubTotal": "string",
    "SubtotalWoDiscount": "string",
    "Tax": "string",
    "TaxExempt": "string",
    "TaxTotal": "string",
    "Taxable": "string",
    "TerminalVerificationResults": "string",
    "TextAux": "string",
    "TextAux2": "string",
    "Title": "string",
    "Total": "string",
    "TrackingCode": "string",
    "TransactionStatusInformation": "string",
    "TransientPrice_Id": "string",
    "Type": "string",
    "Value": "string",
    "ValueAlternative": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string"
}

schema_name_id: 1663
schema_scan_id: 162167684
updated: 2026-04-17 03:07:30

Version 1716427

created: 2026-04-16 03:08:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceitemset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceitemset`\n(\n `Id`  string , `Prefix`  string , `Quantity`  string , `Title`  string , `Type`  string , `Value`  string , `Discount`  string , `DiscountType`  string , `Taxable`  string , `Tax`  string , `Misc`  string , `DiscountTotal`  string , `PriceSuffix`  string , `SubTotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Total`  string , `InvoiceId`  string , `ChargeGroup`  string , `PaymentAccount`  string , `PriceStr`  string , `IsVoid`  string , `Date`  string , `TextAux`  string , `TextAux2`  string , `DiscountDateTime`  string , `DiscountUserId`  string , `Notes`  string , `PR_Type`  string , `Status`  string , `DeletionUserId`  string , `DeletionDateTime`  string , `OverpaymentId`  string , `VoidUser`  string , `VoidDateTime`  string , `Misc2`  string , `PrepaymentId`  string , `CreditInvoiceId`  string , `AllocationType`  string , `Reservation_Id`  string , `ItemMaster_Id`  string , `AspNetUser_Id`  string , `InvoiceItemType_Id`  string , `SeasonalPrice_Id`  string , `TransientPrice_Id`  string , `SVJobId`  string , `OriginalCreditItem`  string , `TaxExempt`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `DeletionReason`  string , `VoidReason`  string , `StartDateTime`  string , `EndDateTime`  string , `CreationPartnerId`  string , `DeletePartnerId`  string , `VoidPartnerId`  string , `OriginalPrice`  string , `OverrideXeroTaxRate`  string , `OverrideXeroSalesAccount`  string , `OriginalReservationPrice`  string , `NumberOfDecimals`  string , `StripeTransactionData_Id`  string , `ValueAlternative`  string , `StripeTerminalId`  string , `StripeApplicationName`  string , `StripeAID`  string , `EnteredAmount`  string , `ExchangeRate`  string , `Currencies_Id`  string , `SV_ChargeInstance_Id`  string , `SV_LaborInstance_Id`  string , `SV_PartInstance_Id`  string , `RevenueGLCode`  string , `ARGLCode`  string , `PaymentGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `SalesTaxGLCode`  string , `PrepaymentGLCode`  string , `AccountType`  string , `ApplicationCryptogram`  string , `AuthorizationCode`  string , `AuthorizationResponseCode`  string , `CardholderVerificationMethod`  string , `TerminalVerificationResults`  string , `TransactionStatusInformation`  string , `TrackingCode`  string , `DiscountGLCode`  string , `OverrideTrackingCategory1`  string , `OverrideTrackingCategory2`  string , `QuickbooksPaymentId`  string , `AllowTotalPriceEntry`  string , `AddedAutomatically`  string , `AllocationPerformedDate`  string , `CreatedDate`  string , `IsHidden`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-16/1776326533'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceitemset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-16/1776326533
id: 1716427
processed: 1

raw_data:

{
    "ARGLCode": 74,
    "AccountType": 80,
    "AddedAutomatically": 93,
    "AllocationPerformedDate": 94,
    "AllocationType": 38,
    "AllowTotalPriceEntry": 92,
    "ApplicationCryptogram": 81,
    "AspNetUser_Id": 41,
    "AuthorizationCode": 82,
    "AuthorizationResponseCode": 83,
    "COGSGLCode": 76,
    "CardholderVerificationMethod": 84,
    "ChargeGroup": 18,
    "CreatedDate": 95,
    "CreationPartnerId": 54,
    "CreditInvoiceId": 37,
    "Currencies_Id": 69,
    "Date": 22,
    "DeletePartnerId": 55,
    "DeletionDateTime": 31,
    "DeletionReason": 50,
    "DeletionUserId": 30,
    "Discount": 6,
    "DiscountDateTime": 25,
    "DiscountGLCode": 88,
    "DiscountTotal": 11,
    "DiscountType": 7,
    "DiscountUserId": 26,
    "EndDateTime": 53,
    "EnteredAmount": 67,
    "ExchangeRate": 68,
    "Id": 0,
    "InventoryGLCode": 77,
    "InvoiceId": 17,
    "InvoiceItemType_Id": 42,
    "IsHidden": 96,
    "IsVoid": 21,
    "ItemMaster_Id": 40,
    "LastModifiedAspNetUser": 49,
    "LastModifiedDateTime": 48,
    "Misc": 10,
    "Misc2": 35,
    "Notes": 27,
    "NumberOfDecimals": 61,
    "OriginalCreditItem": 46,
    "OriginalPrice": 57,
    "OriginalReservationPrice": 60,
    "OverpaymentId": 32,
    "OverrideTrackingCategory1": 89,
    "OverrideTrackingCategory2": 90,
    "OverrideXeroSalesAccount": 59,
    "OverrideXeroTaxRate": 58,
    "PR_Type": 28,
    "PaymentAccount": 19,
    "PaymentGLCode": 75,
    "Prefix": 1,
    "PrepaymentGLCode": 79,
    "PrepaymentId": 36,
    "PriceStr": 20,
    "PriceSuffix": 12,
    "Quantity": 2,
    "QuickbooksPaymentId": 91,
    "Reservation_Id": 39,
    "RevenueGLCode": 73,
    "SVJobId": 45,
    "SV_ChargeInstance_Id": 70,
    "SV_LaborInstance_Id": 71,
    "SV_PartInstance_Id": 72,
    "SalesTaxGLCode": 78,
    "SeasonalPrice_Id": 43,
    "StartDateTime": 52,
    "Status": 29,
    "StripeAID": 66,
    "StripeApplicationName": 65,
    "StripeTerminalId": 64,
    "StripeTransactionData_Id": 62,
    "SubTotal": 13,
    "SubtotalWoDiscount": 14,
    "Tax": 9,
    "TaxExempt": 47,
    "TaxTotal": 15,
    "Taxable": 8,
    "TerminalVerificationResults": 85,
    "TextAux": 23,
    "TextAux2": 24,
    "Title": 3,
    "Total": 16,
    "TrackingCode": 87,
    "TransactionStatusInformation": 86,
    "TransientPrice_Id": 44,
    "Type": 4,
    "Value": 5,
    "ValueAlternative": 63,
    "VoidDateTime": 34,
    "VoidPartnerId": 56,
    "VoidReason": 51,
    "VoidUser": 33
}

schema_attributes:

{
    "ARGLCode": "string",
    "AccountType": "string",
    "AddedAutomatically": "string",
    "AllocationPerformedDate": "string",
    "AllocationType": "string",
    "AllowTotalPriceEntry": "string",
    "ApplicationCryptogram": "string",
    "AspNetUser_Id": "string",
    "AuthorizationCode": "string",
    "AuthorizationResponseCode": "string",
    "COGSGLCode": "string",
    "CardholderVerificationMethod": "string",
    "ChargeGroup": "string",
    "CreatedDate": "string",
    "CreationPartnerId": "string",
    "CreditInvoiceId": "string",
    "Currencies_Id": "string",
    "Date": "string",
    "DeletePartnerId": "string",
    "DeletionDateTime": "string",
    "DeletionReason": "string",
    "DeletionUserId": "string",
    "Discount": "string",
    "DiscountDateTime": "string",
    "DiscountGLCode": "string",
    "DiscountTotal": "string",
    "DiscountType": "string",
    "DiscountUserId": "string",
    "EndDateTime": "string",
    "EnteredAmount": "string",
    "ExchangeRate": "string",
    "Id": "string",
    "InventoryGLCode": "string",
    "InvoiceId": "string",
    "InvoiceItemType_Id": "string",
    "IsHidden": "string",
    "IsVoid": "string",
    "ItemMaster_Id": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "Misc": "string",
    "Misc2": "string",
    "Notes": "string",
    "NumberOfDecimals": "string",
    "OriginalCreditItem": "string",
    "OriginalPrice": "string",
    "OriginalReservationPrice": "string",
    "OverpaymentId": "string",
    "OverrideTrackingCategory1": "string",
    "OverrideTrackingCategory2": "string",
    "OverrideXeroSalesAccount": "string",
    "OverrideXeroTaxRate": "string",
    "PR_Type": "string",
    "PaymentAccount": "string",
    "PaymentGLCode": "string",
    "Prefix": "string",
    "PrepaymentGLCode": "string",
    "PrepaymentId": "string",
    "PriceStr": "string",
    "PriceSuffix": "string",
    "Quantity": "string",
    "QuickbooksPaymentId": "string",
    "Reservation_Id": "string",
    "RevenueGLCode": "string",
    "SVJobId": "string",
    "SV_ChargeInstance_Id": "string",
    "SV_LaborInstance_Id": "string",
    "SV_PartInstance_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonalPrice_Id": "string",
    "StartDateTime": "string",
    "Status": "string",
    "StripeAID": "string",
    "StripeApplicationName": "string",
    "StripeTerminalId": "string",
    "StripeTransactionData_Id": "string",
    "SubTotal": "string",
    "SubtotalWoDiscount": "string",
    "Tax": "string",
    "TaxExempt": "string",
    "TaxTotal": "string",
    "Taxable": "string",
    "TerminalVerificationResults": "string",
    "TextAux": "string",
    "TextAux2": "string",
    "Title": "string",
    "Total": "string",
    "TrackingCode": "string",
    "TransactionStatusInformation": "string",
    "TransientPrice_Id": "string",
    "Type": "string",
    "Value": "string",
    "ValueAlternative": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string"
}

schema_name_id: 1663
schema_scan_id: 162111860
updated: 2026-04-16 03:09:02

Version 1715244

created: 2026-04-15 03:06:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceitemset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceitemset`\n(\n `Id`  string , `Prefix`  string , `Quantity`  string , `Title`  string , `Type`  string , `Value`  string , `Discount`  string , `DiscountType`  string , `Taxable`  string , `Tax`  string , `Misc`  string , `DiscountTotal`  string , `PriceSuffix`  string , `SubTotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Total`  string , `InvoiceId`  string , `ChargeGroup`  string , `PaymentAccount`  string , `PriceStr`  string , `IsVoid`  string , `Date`  string , `TextAux`  string , `TextAux2`  string , `DiscountDateTime`  string , `DiscountUserId`  string , `Notes`  string , `PR_Type`  string , `Status`  string , `DeletionUserId`  string , `DeletionDateTime`  string , `OverpaymentId`  string , `VoidUser`  string , `VoidDateTime`  string , `Misc2`  string , `PrepaymentId`  string , `CreditInvoiceId`  string , `AllocationType`  string , `Reservation_Id`  string , `ItemMaster_Id`  string , `AspNetUser_Id`  string , `InvoiceItemType_Id`  string , `SeasonalPrice_Id`  string , `TransientPrice_Id`  string , `SVJobId`  string , `OriginalCreditItem`  string , `TaxExempt`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `DeletionReason`  string , `VoidReason`  string , `StartDateTime`  string , `EndDateTime`  string , `CreationPartnerId`  string , `DeletePartnerId`  string , `VoidPartnerId`  string , `OriginalPrice`  string , `OverrideXeroTaxRate`  string , `OverrideXeroSalesAccount`  string , `OriginalReservationPrice`  string , `NumberOfDecimals`  string , `StripeTransactionData_Id`  string , `ValueAlternative`  string , `StripeTerminalId`  string , `StripeApplicationName`  string , `StripeAID`  string , `EnteredAmount`  string , `ExchangeRate`  string , `Currencies_Id`  string , `SV_ChargeInstance_Id`  string , `SV_LaborInstance_Id`  string , `SV_PartInstance_Id`  string , `RevenueGLCode`  string , `ARGLCode`  string , `PaymentGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `SalesTaxGLCode`  string , `PrepaymentGLCode`  string , `AccountType`  string , `ApplicationCryptogram`  string , `AuthorizationCode`  string , `AuthorizationResponseCode`  string , `CardholderVerificationMethod`  string , `TerminalVerificationResults`  string , `TransactionStatusInformation`  string , `TrackingCode`  string , `DiscountGLCode`  string , `OverrideTrackingCategory1`  string , `OverrideTrackingCategory2`  string , `QuickbooksPaymentId`  string , `AllowTotalPriceEntry`  string , `AddedAutomatically`  string , `AllocationPerformedDate`  string , `CreatedDate`  string , `IsHidden`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-15/1776240003'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceitemset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-15/1776240003
id: 1715244
processed: 1

raw_data:

{
    "ARGLCode": 74,
    "AccountType": 80,
    "AddedAutomatically": 93,
    "AllocationPerformedDate": 94,
    "AllocationType": 38,
    "AllowTotalPriceEntry": 92,
    "ApplicationCryptogram": 81,
    "AspNetUser_Id": 41,
    "AuthorizationCode": 82,
    "AuthorizationResponseCode": 83,
    "COGSGLCode": 76,
    "CardholderVerificationMethod": 84,
    "ChargeGroup": 18,
    "CreatedDate": 95,
    "CreationPartnerId": 54,
    "CreditInvoiceId": 37,
    "Currencies_Id": 69,
    "Date": 22,
    "DeletePartnerId": 55,
    "DeletionDateTime": 31,
    "DeletionReason": 50,
    "DeletionUserId": 30,
    "Discount": 6,
    "DiscountDateTime": 25,
    "DiscountGLCode": 88,
    "DiscountTotal": 11,
    "DiscountType": 7,
    "DiscountUserId": 26,
    "EndDateTime": 53,
    "EnteredAmount": 67,
    "ExchangeRate": 68,
    "Id": 0,
    "InventoryGLCode": 77,
    "InvoiceId": 17,
    "InvoiceItemType_Id": 42,
    "IsHidden": 96,
    "IsVoid": 21,
    "ItemMaster_Id": 40,
    "LastModifiedAspNetUser": 49,
    "LastModifiedDateTime": 48,
    "Misc": 10,
    "Misc2": 35,
    "Notes": 27,
    "NumberOfDecimals": 61,
    "OriginalCreditItem": 46,
    "OriginalPrice": 57,
    "OriginalReservationPrice": 60,
    "OverpaymentId": 32,
    "OverrideTrackingCategory1": 89,
    "OverrideTrackingCategory2": 90,
    "OverrideXeroSalesAccount": 59,
    "OverrideXeroTaxRate": 58,
    "PR_Type": 28,
    "PaymentAccount": 19,
    "PaymentGLCode": 75,
    "Prefix": 1,
    "PrepaymentGLCode": 79,
    "PrepaymentId": 36,
    "PriceStr": 20,
    "PriceSuffix": 12,
    "Quantity": 2,
    "QuickbooksPaymentId": 91,
    "Reservation_Id": 39,
    "RevenueGLCode": 73,
    "SVJobId": 45,
    "SV_ChargeInstance_Id": 70,
    "SV_LaborInstance_Id": 71,
    "SV_PartInstance_Id": 72,
    "SalesTaxGLCode": 78,
    "SeasonalPrice_Id": 43,
    "StartDateTime": 52,
    "Status": 29,
    "StripeAID": 66,
    "StripeApplicationName": 65,
    "StripeTerminalId": 64,
    "StripeTransactionData_Id": 62,
    "SubTotal": 13,
    "SubtotalWoDiscount": 14,
    "Tax": 9,
    "TaxExempt": 47,
    "TaxTotal": 15,
    "Taxable": 8,
    "TerminalVerificationResults": 85,
    "TextAux": 23,
    "TextAux2": 24,
    "Title": 3,
    "Total": 16,
    "TrackingCode": 87,
    "TransactionStatusInformation": 86,
    "TransientPrice_Id": 44,
    "Type": 4,
    "Value": 5,
    "ValueAlternative": 63,
    "VoidDateTime": 34,
    "VoidPartnerId": 56,
    "VoidReason": 51,
    "VoidUser": 33
}

schema_attributes:

{
    "ARGLCode": "string",
    "AccountType": "string",
    "AddedAutomatically": "string",
    "AllocationPerformedDate": "string",
    "AllocationType": "string",
    "AllowTotalPriceEntry": "string",
    "ApplicationCryptogram": "string",
    "AspNetUser_Id": "string",
    "AuthorizationCode": "string",
    "AuthorizationResponseCode": "string",
    "COGSGLCode": "string",
    "CardholderVerificationMethod": "string",
    "ChargeGroup": "string",
    "CreatedDate": "string",
    "CreationPartnerId": "string",
    "CreditInvoiceId": "string",
    "Currencies_Id": "string",
    "Date": "string",
    "DeletePartnerId": "string",
    "DeletionDateTime": "string",
    "DeletionReason": "string",
    "DeletionUserId": "string",
    "Discount": "string",
    "DiscountDateTime": "string",
    "DiscountGLCode": "string",
    "DiscountTotal": "string",
    "DiscountType": "string",
    "DiscountUserId": "string",
    "EndDateTime": "string",
    "EnteredAmount": "string",
    "ExchangeRate": "string",
    "Id": "string",
    "InventoryGLCode": "string",
    "InvoiceId": "string",
    "InvoiceItemType_Id": "string",
    "IsHidden": "string",
    "IsVoid": "string",
    "ItemMaster_Id": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "Misc": "string",
    "Misc2": "string",
    "Notes": "string",
    "NumberOfDecimals": "string",
    "OriginalCreditItem": "string",
    "OriginalPrice": "string",
    "OriginalReservationPrice": "string",
    "OverpaymentId": "string",
    "OverrideTrackingCategory1": "string",
    "OverrideTrackingCategory2": "string",
    "OverrideXeroSalesAccount": "string",
    "OverrideXeroTaxRate": "string",
    "PR_Type": "string",
    "PaymentAccount": "string",
    "PaymentGLCode": "string",
    "Prefix": "string",
    "PrepaymentGLCode": "string",
    "PrepaymentId": "string",
    "PriceStr": "string",
    "PriceSuffix": "string",
    "Quantity": "string",
    "QuickbooksPaymentId": "string",
    "Reservation_Id": "string",
    "RevenueGLCode": "string",
    "SVJobId": "string",
    "SV_ChargeInstance_Id": "string",
    "SV_LaborInstance_Id": "string",
    "SV_PartInstance_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonalPrice_Id": "string",
    "StartDateTime": "string",
    "Status": "string",
    "StripeAID": "string",
    "StripeApplicationName": "string",
    "StripeTerminalId": "string",
    "StripeTransactionData_Id": "string",
    "SubTotal": "string",
    "SubtotalWoDiscount": "string",
    "Tax": "string",
    "TaxExempt": "string",
    "TaxTotal": "string",
    "Taxable": "string",
    "TerminalVerificationResults": "string",
    "TextAux": "string",
    "TextAux2": "string",
    "Title": "string",
    "Total": "string",
    "TrackingCode": "string",
    "TransactionStatusInformation": "string",
    "TransientPrice_Id": "string",
    "Type": "string",
    "Value": "string",
    "ValueAlternative": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string"
}

schema_name_id: 1663
schema_scan_id: 162055979
updated: 2026-04-15 03:06:43

Version 1714015

created: 2026-04-14 03:05:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceitemset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceitemset`\n(\n `Id`  string , `Prefix`  string , `Quantity`  string , `Title`  string , `Type`  string , `Value`  string , `Discount`  string , `DiscountType`  string , `Taxable`  string , `Tax`  string , `Misc`  string , `DiscountTotal`  string , `PriceSuffix`  string , `SubTotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Total`  string , `InvoiceId`  string , `ChargeGroup`  string , `PaymentAccount`  string , `PriceStr`  string , `IsVoid`  string , `Date`  string , `TextAux`  string , `TextAux2`  string , `DiscountDateTime`  string , `DiscountUserId`  string , `Notes`  string , `PR_Type`  string , `Status`  string , `DeletionUserId`  string , `DeletionDateTime`  string , `OverpaymentId`  string , `VoidUser`  string , `VoidDateTime`  string , `Misc2`  string , `PrepaymentId`  string , `CreditInvoiceId`  string , `AllocationType`  string , `Reservation_Id`  string , `ItemMaster_Id`  string , `AspNetUser_Id`  string , `InvoiceItemType_Id`  string , `SeasonalPrice_Id`  string , `TransientPrice_Id`  string , `SVJobId`  string , `OriginalCreditItem`  string , `TaxExempt`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `DeletionReason`  string , `VoidReason`  string , `StartDateTime`  string , `EndDateTime`  string , `CreationPartnerId`  string , `DeletePartnerId`  string , `VoidPartnerId`  string , `OriginalPrice`  string , `OverrideXeroTaxRate`  string , `OverrideXeroSalesAccount`  string , `OriginalReservationPrice`  string , `NumberOfDecimals`  string , `StripeTransactionData_Id`  string , `ValueAlternative`  string , `StripeTerminalId`  string , `StripeApplicationName`  string , `StripeAID`  string , `EnteredAmount`  string , `ExchangeRate`  string , `Currencies_Id`  string , `SV_ChargeInstance_Id`  string , `SV_LaborInstance_Id`  string , `SV_PartInstance_Id`  string , `RevenueGLCode`  string , `ARGLCode`  string , `PaymentGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `SalesTaxGLCode`  string , `PrepaymentGLCode`  string , `AccountType`  string , `ApplicationCryptogram`  string , `AuthorizationCode`  string , `AuthorizationResponseCode`  string , `CardholderVerificationMethod`  string , `TerminalVerificationResults`  string , `TransactionStatusInformation`  string , `TrackingCode`  string , `DiscountGLCode`  string , `OverrideTrackingCategory1`  string , `OverrideTrackingCategory2`  string , `QuickbooksPaymentId`  string , `AllowTotalPriceEntry`  string , `AddedAutomatically`  string , `AllocationPerformedDate`  string , `CreatedDate`  string , `IsHidden`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-14/1776153729'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceitemset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-14/1776153729
id: 1714015
processed: 1

raw_data:

{
    "ARGLCode": 74,
    "AccountType": 80,
    "AddedAutomatically": 93,
    "AllocationPerformedDate": 94,
    "AllocationType": 38,
    "AllowTotalPriceEntry": 92,
    "ApplicationCryptogram": 81,
    "AspNetUser_Id": 41,
    "AuthorizationCode": 82,
    "AuthorizationResponseCode": 83,
    "COGSGLCode": 76,
    "CardholderVerificationMethod": 84,
    "ChargeGroup": 18,
    "CreatedDate": 95,
    "CreationPartnerId": 54,
    "CreditInvoiceId": 37,
    "Currencies_Id": 69,
    "Date": 22,
    "DeletePartnerId": 55,
    "DeletionDateTime": 31,
    "DeletionReason": 50,
    "DeletionUserId": 30,
    "Discount": 6,
    "DiscountDateTime": 25,
    "DiscountGLCode": 88,
    "DiscountTotal": 11,
    "DiscountType": 7,
    "DiscountUserId": 26,
    "EndDateTime": 53,
    "EnteredAmount": 67,
    "ExchangeRate": 68,
    "Id": 0,
    "InventoryGLCode": 77,
    "InvoiceId": 17,
    "InvoiceItemType_Id": 42,
    "IsHidden": 96,
    "IsVoid": 21,
    "ItemMaster_Id": 40,
    "LastModifiedAspNetUser": 49,
    "LastModifiedDateTime": 48,
    "Misc": 10,
    "Misc2": 35,
    "Notes": 27,
    "NumberOfDecimals": 61,
    "OriginalCreditItem": 46,
    "OriginalPrice": 57,
    "OriginalReservationPrice": 60,
    "OverpaymentId": 32,
    "OverrideTrackingCategory1": 89,
    "OverrideTrackingCategory2": 90,
    "OverrideXeroSalesAccount": 59,
    "OverrideXeroTaxRate": 58,
    "PR_Type": 28,
    "PaymentAccount": 19,
    "PaymentGLCode": 75,
    "Prefix": 1,
    "PrepaymentGLCode": 79,
    "PrepaymentId": 36,
    "PriceStr": 20,
    "PriceSuffix": 12,
    "Quantity": 2,
    "QuickbooksPaymentId": 91,
    "Reservation_Id": 39,
    "RevenueGLCode": 73,
    "SVJobId": 45,
    "SV_ChargeInstance_Id": 70,
    "SV_LaborInstance_Id": 71,
    "SV_PartInstance_Id": 72,
    "SalesTaxGLCode": 78,
    "SeasonalPrice_Id": 43,
    "StartDateTime": 52,
    "Status": 29,
    "StripeAID": 66,
    "StripeApplicationName": 65,
    "StripeTerminalId": 64,
    "StripeTransactionData_Id": 62,
    "SubTotal": 13,
    "SubtotalWoDiscount": 14,
    "Tax": 9,
    "TaxExempt": 47,
    "TaxTotal": 15,
    "Taxable": 8,
    "TerminalVerificationResults": 85,
    "TextAux": 23,
    "TextAux2": 24,
    "Title": 3,
    "Total": 16,
    "TrackingCode": 87,
    "TransactionStatusInformation": 86,
    "TransientPrice_Id": 44,
    "Type": 4,
    "Value": 5,
    "ValueAlternative": 63,
    "VoidDateTime": 34,
    "VoidPartnerId": 56,
    "VoidReason": 51,
    "VoidUser": 33
}

schema_attributes:

{
    "ARGLCode": "string",
    "AccountType": "string",
    "AddedAutomatically": "string",
    "AllocationPerformedDate": "string",
    "AllocationType": "string",
    "AllowTotalPriceEntry": "string",
    "ApplicationCryptogram": "string",
    "AspNetUser_Id": "string",
    "AuthorizationCode": "string",
    "AuthorizationResponseCode": "string",
    "COGSGLCode": "string",
    "CardholderVerificationMethod": "string",
    "ChargeGroup": "string",
    "CreatedDate": "string",
    "CreationPartnerId": "string",
    "CreditInvoiceId": "string",
    "Currencies_Id": "string",
    "Date": "string",
    "DeletePartnerId": "string",
    "DeletionDateTime": "string",
    "DeletionReason": "string",
    "DeletionUserId": "string",
    "Discount": "string",
    "DiscountDateTime": "string",
    "DiscountGLCode": "string",
    "DiscountTotal": "string",
    "DiscountType": "string",
    "DiscountUserId": "string",
    "EndDateTime": "string",
    "EnteredAmount": "string",
    "ExchangeRate": "string",
    "Id": "string",
    "InventoryGLCode": "string",
    "InvoiceId": "string",
    "InvoiceItemType_Id": "string",
    "IsHidden": "string",
    "IsVoid": "string",
    "ItemMaster_Id": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "Misc": "string",
    "Misc2": "string",
    "Notes": "string",
    "NumberOfDecimals": "string",
    "OriginalCreditItem": "string",
    "OriginalPrice": "string",
    "OriginalReservationPrice": "string",
    "OverpaymentId": "string",
    "OverrideTrackingCategory1": "string",
    "OverrideTrackingCategory2": "string",
    "OverrideXeroSalesAccount": "string",
    "OverrideXeroTaxRate": "string",
    "PR_Type": "string",
    "PaymentAccount": "string",
    "PaymentGLCode": "string",
    "Prefix": "string",
    "PrepaymentGLCode": "string",
    "PrepaymentId": "string",
    "PriceStr": "string",
    "PriceSuffix": "string",
    "Quantity": "string",
    "QuickbooksPaymentId": "string",
    "Reservation_Id": "string",
    "RevenueGLCode": "string",
    "SVJobId": "string",
    "SV_ChargeInstance_Id": "string",
    "SV_LaborInstance_Id": "string",
    "SV_PartInstance_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonalPrice_Id": "string",
    "StartDateTime": "string",
    "Status": "string",
    "StripeAID": "string",
    "StripeApplicationName": "string",
    "StripeTerminalId": "string",
    "StripeTransactionData_Id": "string",
    "SubTotal": "string",
    "SubtotalWoDiscount": "string",
    "Tax": "string",
    "TaxExempt": "string",
    "TaxTotal": "string",
    "Taxable": "string",
    "TerminalVerificationResults": "string",
    "TextAux": "string",
    "TextAux2": "string",
    "Title": "string",
    "Total": "string",
    "TrackingCode": "string",
    "TransactionStatusInformation": "string",
    "TransientPrice_Id": "string",
    "Type": "string",
    "Value": "string",
    "ValueAlternative": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string"
}

schema_name_id: 1663
schema_scan_id: 162000488
updated: 2026-04-14 03:06:10

Version 1712784

created: 2026-04-13 02:58:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceitemset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceitemset`\n(\n `Id`  string , `Prefix`  string , `Quantity`  string , `Title`  string , `Type`  string , `Value`  string , `Discount`  string , `DiscountType`  string , `Taxable`  string , `Tax`  string , `Misc`  string , `DiscountTotal`  string , `PriceSuffix`  string , `SubTotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Total`  string , `InvoiceId`  string , `ChargeGroup`  string , `PaymentAccount`  string , `PriceStr`  string , `IsVoid`  string , `Date`  string , `TextAux`  string , `TextAux2`  string , `DiscountDateTime`  string , `DiscountUserId`  string , `Notes`  string , `PR_Type`  string , `Status`  string , `DeletionUserId`  string , `DeletionDateTime`  string , `OverpaymentId`  string , `VoidUser`  string , `VoidDateTime`  string , `Misc2`  string , `PrepaymentId`  string , `CreditInvoiceId`  string , `AllocationType`  string , `Reservation_Id`  string , `ItemMaster_Id`  string , `AspNetUser_Id`  string , `InvoiceItemType_Id`  string , `SeasonalPrice_Id`  string , `TransientPrice_Id`  string , `SVJobId`  string , `OriginalCreditItem`  string , `TaxExempt`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `DeletionReason`  string , `VoidReason`  string , `StartDateTime`  string , `EndDateTime`  string , `CreationPartnerId`  string , `DeletePartnerId`  string , `VoidPartnerId`  string , `OriginalPrice`  string , `OverrideXeroTaxRate`  string , `OverrideXeroSalesAccount`  string , `OriginalReservationPrice`  string , `NumberOfDecimals`  string , `StripeTransactionData_Id`  string , `ValueAlternative`  string , `StripeTerminalId`  string , `StripeApplicationName`  string , `StripeAID`  string , `EnteredAmount`  string , `ExchangeRate`  string , `Currencies_Id`  string , `SV_ChargeInstance_Id`  string , `SV_LaborInstance_Id`  string , `SV_PartInstance_Id`  string , `RevenueGLCode`  string , `ARGLCode`  string , `PaymentGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `SalesTaxGLCode`  string , `PrepaymentGLCode`  string , `AccountType`  string , `ApplicationCryptogram`  string , `AuthorizationCode`  string , `AuthorizationResponseCode`  string , `CardholderVerificationMethod`  string , `TerminalVerificationResults`  string , `TransactionStatusInformation`  string , `TrackingCode`  string , `DiscountGLCode`  string , `OverrideTrackingCategory1`  string , `OverrideTrackingCategory2`  string , `QuickbooksPaymentId`  string , `AllowTotalPriceEntry`  string , `AddedAutomatically`  string , `AllocationPerformedDate`  string , `CreatedDate`  string , `IsHidden`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-13/1776066923'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceitemset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-13/1776066923
id: 1712784
processed: 1

raw_data:

{
    "ARGLCode": 74,
    "AccountType": 80,
    "AddedAutomatically": 93,
    "AllocationPerformedDate": 94,
    "AllocationType": 38,
    "AllowTotalPriceEntry": 92,
    "ApplicationCryptogram": 81,
    "AspNetUser_Id": 41,
    "AuthorizationCode": 82,
    "AuthorizationResponseCode": 83,
    "COGSGLCode": 76,
    "CardholderVerificationMethod": 84,
    "ChargeGroup": 18,
    "CreatedDate": 95,
    "CreationPartnerId": 54,
    "CreditInvoiceId": 37,
    "Currencies_Id": 69,
    "Date": 22,
    "DeletePartnerId": 55,
    "DeletionDateTime": 31,
    "DeletionReason": 50,
    "DeletionUserId": 30,
    "Discount": 6,
    "DiscountDateTime": 25,
    "DiscountGLCode": 88,
    "DiscountTotal": 11,
    "DiscountType": 7,
    "DiscountUserId": 26,
    "EndDateTime": 53,
    "EnteredAmount": 67,
    "ExchangeRate": 68,
    "Id": 0,
    "InventoryGLCode": 77,
    "InvoiceId": 17,
    "InvoiceItemType_Id": 42,
    "IsHidden": 96,
    "IsVoid": 21,
    "ItemMaster_Id": 40,
    "LastModifiedAspNetUser": 49,
    "LastModifiedDateTime": 48,
    "Misc": 10,
    "Misc2": 35,
    "Notes": 27,
    "NumberOfDecimals": 61,
    "OriginalCreditItem": 46,
    "OriginalPrice": 57,
    "OriginalReservationPrice": 60,
    "OverpaymentId": 32,
    "OverrideTrackingCategory1": 89,
    "OverrideTrackingCategory2": 90,
    "OverrideXeroSalesAccount": 59,
    "OverrideXeroTaxRate": 58,
    "PR_Type": 28,
    "PaymentAccount": 19,
    "PaymentGLCode": 75,
    "Prefix": 1,
    "PrepaymentGLCode": 79,
    "PrepaymentId": 36,
    "PriceStr": 20,
    "PriceSuffix": 12,
    "Quantity": 2,
    "QuickbooksPaymentId": 91,
    "Reservation_Id": 39,
    "RevenueGLCode": 73,
    "SVJobId": 45,
    "SV_ChargeInstance_Id": 70,
    "SV_LaborInstance_Id": 71,
    "SV_PartInstance_Id": 72,
    "SalesTaxGLCode": 78,
    "SeasonalPrice_Id": 43,
    "StartDateTime": 52,
    "Status": 29,
    "StripeAID": 66,
    "StripeApplicationName": 65,
    "StripeTerminalId": 64,
    "StripeTransactionData_Id": 62,
    "SubTotal": 13,
    "SubtotalWoDiscount": 14,
    "Tax": 9,
    "TaxExempt": 47,
    "TaxTotal": 15,
    "Taxable": 8,
    "TerminalVerificationResults": 85,
    "TextAux": 23,
    "TextAux2": 24,
    "Title": 3,
    "Total": 16,
    "TrackingCode": 87,
    "TransactionStatusInformation": 86,
    "TransientPrice_Id": 44,
    "Type": 4,
    "Value": 5,
    "ValueAlternative": 63,
    "VoidDateTime": 34,
    "VoidPartnerId": 56,
    "VoidReason": 51,
    "VoidUser": 33
}

schema_attributes:

{
    "ARGLCode": "string",
    "AccountType": "string",
    "AddedAutomatically": "string",
    "AllocationPerformedDate": "string",
    "AllocationType": "string",
    "AllowTotalPriceEntry": "string",
    "ApplicationCryptogram": "string",
    "AspNetUser_Id": "string",
    "AuthorizationCode": "string",
    "AuthorizationResponseCode": "string",
    "COGSGLCode": "string",
    "CardholderVerificationMethod": "string",
    "ChargeGroup": "string",
    "CreatedDate": "string",
    "CreationPartnerId": "string",
    "CreditInvoiceId": "string",
    "Currencies_Id": "string",
    "Date": "string",
    "DeletePartnerId": "string",
    "DeletionDateTime": "string",
    "DeletionReason": "string",
    "DeletionUserId": "string",
    "Discount": "string",
    "DiscountDateTime": "string",
    "DiscountGLCode": "string",
    "DiscountTotal": "string",
    "DiscountType": "string",
    "DiscountUserId": "string",
    "EndDateTime": "string",
    "EnteredAmount": "string",
    "ExchangeRate": "string",
    "Id": "string",
    "InventoryGLCode": "string",
    "InvoiceId": "string",
    "InvoiceItemType_Id": "string",
    "IsHidden": "string",
    "IsVoid": "string",
    "ItemMaster_Id": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "Misc": "string",
    "Misc2": "string",
    "Notes": "string",
    "NumberOfDecimals": "string",
    "OriginalCreditItem": "string",
    "OriginalPrice": "string",
    "OriginalReservationPrice": "string",
    "OverpaymentId": "string",
    "OverrideTrackingCategory1": "string",
    "OverrideTrackingCategory2": "string",
    "OverrideXeroSalesAccount": "string",
    "OverrideXeroTaxRate": "string",
    "PR_Type": "string",
    "PaymentAccount": "string",
    "PaymentGLCode": "string",
    "Prefix": "string",
    "PrepaymentGLCode": "string",
    "PrepaymentId": "string",
    "PriceStr": "string",
    "PriceSuffix": "string",
    "Quantity": "string",
    "QuickbooksPaymentId": "string",
    "Reservation_Id": "string",
    "RevenueGLCode": "string",
    "SVJobId": "string",
    "SV_ChargeInstance_Id": "string",
    "SV_LaborInstance_Id": "string",
    "SV_PartInstance_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonalPrice_Id": "string",
    "StartDateTime": "string",
    "Status": "string",
    "StripeAID": "string",
    "StripeApplicationName": "string",
    "StripeTerminalId": "string",
    "StripeTransactionData_Id": "string",
    "SubTotal": "string",
    "SubtotalWoDiscount": "string",
    "Tax": "string",
    "TaxExempt": "string",
    "TaxTotal": "string",
    "Taxable": "string",
    "TerminalVerificationResults": "string",
    "TextAux": "string",
    "TextAux2": "string",
    "Title": "string",
    "Total": "string",
    "TrackingCode": "string",
    "TransactionStatusInformation": "string",
    "TransientPrice_Id": "string",
    "Type": "string",
    "Value": "string",
    "ValueAlternative": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string"
}

schema_name_id: 1663
schema_scan_id: 161941710
updated: 2026-04-13 02:59:12

Version 1711585

created: 2026-04-12 03:00:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceitemset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceitemset`\n(\n `Id`  string , `Prefix`  string , `Quantity`  string , `Title`  string , `Type`  string , `Value`  string , `Discount`  string , `DiscountType`  string , `Taxable`  string , `Tax`  string , `Misc`  string , `DiscountTotal`  string , `PriceSuffix`  string , `SubTotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Total`  string , `InvoiceId`  string , `ChargeGroup`  string , `PaymentAccount`  string , `PriceStr`  string , `IsVoid`  string , `Date`  string , `TextAux`  string , `TextAux2`  string , `DiscountDateTime`  string , `DiscountUserId`  string , `Notes`  string , `PR_Type`  string , `Status`  string , `DeletionUserId`  string , `DeletionDateTime`  string , `OverpaymentId`  string , `VoidUser`  string , `VoidDateTime`  string , `Misc2`  string , `PrepaymentId`  string , `CreditInvoiceId`  string , `AllocationType`  string , `Reservation_Id`  string , `ItemMaster_Id`  string , `AspNetUser_Id`  string , `InvoiceItemType_Id`  string , `SeasonalPrice_Id`  string , `TransientPrice_Id`  string , `SVJobId`  string , `OriginalCreditItem`  string , `TaxExempt`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `DeletionReason`  string , `VoidReason`  string , `StartDateTime`  string , `EndDateTime`  string , `CreationPartnerId`  string , `DeletePartnerId`  string , `VoidPartnerId`  string , `OriginalPrice`  string , `OverrideXeroTaxRate`  string , `OverrideXeroSalesAccount`  string , `OriginalReservationPrice`  string , `NumberOfDecimals`  string , `StripeTransactionData_Id`  string , `ValueAlternative`  string , `StripeTerminalId`  string , `StripeApplicationName`  string , `StripeAID`  string , `EnteredAmount`  string , `ExchangeRate`  string , `Currencies_Id`  string , `SV_ChargeInstance_Id`  string , `SV_LaborInstance_Id`  string , `SV_PartInstance_Id`  string , `RevenueGLCode`  string , `ARGLCode`  string , `PaymentGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `SalesTaxGLCode`  string , `PrepaymentGLCode`  string , `AccountType`  string , `ApplicationCryptogram`  string , `AuthorizationCode`  string , `AuthorizationResponseCode`  string , `CardholderVerificationMethod`  string , `TerminalVerificationResults`  string , `TransactionStatusInformation`  string , `TrackingCode`  string , `DiscountGLCode`  string , `OverrideTrackingCategory1`  string , `OverrideTrackingCategory2`  string , `QuickbooksPaymentId`  string , `AllowTotalPriceEntry`  string , `AddedAutomatically`  string , `AllocationPerformedDate`  string , `CreatedDate`  string , `IsHidden`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-12/1775980637'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceitemset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-12/1775980637
id: 1711585
processed: 1

raw_data:

{
    "ARGLCode": 74,
    "AccountType": 80,
    "AddedAutomatically": 93,
    "AllocationPerformedDate": 94,
    "AllocationType": 38,
    "AllowTotalPriceEntry": 92,
    "ApplicationCryptogram": 81,
    "AspNetUser_Id": 41,
    "AuthorizationCode": 82,
    "AuthorizationResponseCode": 83,
    "COGSGLCode": 76,
    "CardholderVerificationMethod": 84,
    "ChargeGroup": 18,
    "CreatedDate": 95,
    "CreationPartnerId": 54,
    "CreditInvoiceId": 37,
    "Currencies_Id": 69,
    "Date": 22,
    "DeletePartnerId": 55,
    "DeletionDateTime": 31,
    "DeletionReason": 50,
    "DeletionUserId": 30,
    "Discount": 6,
    "DiscountDateTime": 25,
    "DiscountGLCode": 88,
    "DiscountTotal": 11,
    "DiscountType": 7,
    "DiscountUserId": 26,
    "EndDateTime": 53,
    "EnteredAmount": 67,
    "ExchangeRate": 68,
    "Id": 0,
    "InventoryGLCode": 77,
    "InvoiceId": 17,
    "InvoiceItemType_Id": 42,
    "IsHidden": 96,
    "IsVoid": 21,
    "ItemMaster_Id": 40,
    "LastModifiedAspNetUser": 49,
    "LastModifiedDateTime": 48,
    "Misc": 10,
    "Misc2": 35,
    "Notes": 27,
    "NumberOfDecimals": 61,
    "OriginalCreditItem": 46,
    "OriginalPrice": 57,
    "OriginalReservationPrice": 60,
    "OverpaymentId": 32,
    "OverrideTrackingCategory1": 89,
    "OverrideTrackingCategory2": 90,
    "OverrideXeroSalesAccount": 59,
    "OverrideXeroTaxRate": 58,
    "PR_Type": 28,
    "PaymentAccount": 19,
    "PaymentGLCode": 75,
    "Prefix": 1,
    "PrepaymentGLCode": 79,
    "PrepaymentId": 36,
    "PriceStr": 20,
    "PriceSuffix": 12,
    "Quantity": 2,
    "QuickbooksPaymentId": 91,
    "Reservation_Id": 39,
    "RevenueGLCode": 73,
    "SVJobId": 45,
    "SV_ChargeInstance_Id": 70,
    "SV_LaborInstance_Id": 71,
    "SV_PartInstance_Id": 72,
    "SalesTaxGLCode": 78,
    "SeasonalPrice_Id": 43,
    "StartDateTime": 52,
    "Status": 29,
    "StripeAID": 66,
    "StripeApplicationName": 65,
    "StripeTerminalId": 64,
    "StripeTransactionData_Id": 62,
    "SubTotal": 13,
    "SubtotalWoDiscount": 14,
    "Tax": 9,
    "TaxExempt": 47,
    "TaxTotal": 15,
    "Taxable": 8,
    "TerminalVerificationResults": 85,
    "TextAux": 23,
    "TextAux2": 24,
    "Title": 3,
    "Total": 16,
    "TrackingCode": 87,
    "TransactionStatusInformation": 86,
    "TransientPrice_Id": 44,
    "Type": 4,
    "Value": 5,
    "ValueAlternative": 63,
    "VoidDateTime": 34,
    "VoidPartnerId": 56,
    "VoidReason": 51,
    "VoidUser": 33
}

schema_attributes:

{
    "ARGLCode": "string",
    "AccountType": "string",
    "AddedAutomatically": "string",
    "AllocationPerformedDate": "string",
    "AllocationType": "string",
    "AllowTotalPriceEntry": "string",
    "ApplicationCryptogram": "string",
    "AspNetUser_Id": "string",
    "AuthorizationCode": "string",
    "AuthorizationResponseCode": "string",
    "COGSGLCode": "string",
    "CardholderVerificationMethod": "string",
    "ChargeGroup": "string",
    "CreatedDate": "string",
    "CreationPartnerId": "string",
    "CreditInvoiceId": "string",
    "Currencies_Id": "string",
    "Date": "string",
    "DeletePartnerId": "string",
    "DeletionDateTime": "string",
    "DeletionReason": "string",
    "DeletionUserId": "string",
    "Discount": "string",
    "DiscountDateTime": "string",
    "DiscountGLCode": "string",
    "DiscountTotal": "string",
    "DiscountType": "string",
    "DiscountUserId": "string",
    "EndDateTime": "string",
    "EnteredAmount": "string",
    "ExchangeRate": "string",
    "Id": "string",
    "InventoryGLCode": "string",
    "InvoiceId": "string",
    "InvoiceItemType_Id": "string",
    "IsHidden": "string",
    "IsVoid": "string",
    "ItemMaster_Id": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "Misc": "string",
    "Misc2": "string",
    "Notes": "string",
    "NumberOfDecimals": "string",
    "OriginalCreditItem": "string",
    "OriginalPrice": "string",
    "OriginalReservationPrice": "string",
    "OverpaymentId": "string",
    "OverrideTrackingCategory1": "string",
    "OverrideTrackingCategory2": "string",
    "OverrideXeroSalesAccount": "string",
    "OverrideXeroTaxRate": "string",
    "PR_Type": "string",
    "PaymentAccount": "string",
    "PaymentGLCode": "string",
    "Prefix": "string",
    "PrepaymentGLCode": "string",
    "PrepaymentId": "string",
    "PriceStr": "string",
    "PriceSuffix": "string",
    "Quantity": "string",
    "QuickbooksPaymentId": "string",
    "Reservation_Id": "string",
    "RevenueGLCode": "string",
    "SVJobId": "string",
    "SV_ChargeInstance_Id": "string",
    "SV_LaborInstance_Id": "string",
    "SV_PartInstance_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonalPrice_Id": "string",
    "StartDateTime": "string",
    "Status": "string",
    "StripeAID": "string",
    "StripeApplicationName": "string",
    "StripeTerminalId": "string",
    "StripeTransactionData_Id": "string",
    "SubTotal": "string",
    "SubtotalWoDiscount": "string",
    "Tax": "string",
    "TaxExempt": "string",
    "TaxTotal": "string",
    "Taxable": "string",
    "TerminalVerificationResults": "string",
    "TextAux": "string",
    "TextAux2": "string",
    "Title": "string",
    "Total": "string",
    "TrackingCode": "string",
    "TransactionStatusInformation": "string",
    "TransientPrice_Id": "string",
    "Type": "string",
    "Value": "string",
    "ValueAlternative": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string"
}

schema_name_id: 1663
schema_scan_id: 161892612
updated: 2026-04-12 03:00:46

Version 1710419

created: 2026-04-11 03:05:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceitemset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceitemset`\n(\n `Id`  string , `Prefix`  string , `Quantity`  string , `Title`  string , `Type`  string , `Value`  string , `Discount`  string , `DiscountType`  string , `Taxable`  string , `Tax`  string , `Misc`  string , `DiscountTotal`  string , `PriceSuffix`  string , `SubTotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Total`  string , `InvoiceId`  string , `ChargeGroup`  string , `PaymentAccount`  string , `PriceStr`  string , `IsVoid`  string , `Date`  string , `TextAux`  string , `TextAux2`  string , `DiscountDateTime`  string , `DiscountUserId`  string , `Notes`  string , `PR_Type`  string , `Status`  string , `DeletionUserId`  string , `DeletionDateTime`  string , `OverpaymentId`  string , `VoidUser`  string , `VoidDateTime`  string , `Misc2`  string , `PrepaymentId`  string , `CreditInvoiceId`  string , `AllocationType`  string , `Reservation_Id`  string , `ItemMaster_Id`  string , `AspNetUser_Id`  string , `InvoiceItemType_Id`  string , `SeasonalPrice_Id`  string , `TransientPrice_Id`  string , `SVJobId`  string , `OriginalCreditItem`  string , `TaxExempt`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `DeletionReason`  string , `VoidReason`  string , `StartDateTime`  string , `EndDateTime`  string , `CreationPartnerId`  string , `DeletePartnerId`  string , `VoidPartnerId`  string , `OriginalPrice`  string , `OverrideXeroTaxRate`  string , `OverrideXeroSalesAccount`  string , `OriginalReservationPrice`  string , `NumberOfDecimals`  string , `StripeTransactionData_Id`  string , `ValueAlternative`  string , `StripeTerminalId`  string , `StripeApplicationName`  string , `StripeAID`  string , `EnteredAmount`  string , `ExchangeRate`  string , `Currencies_Id`  string , `SV_ChargeInstance_Id`  string , `SV_LaborInstance_Id`  string , `SV_PartInstance_Id`  string , `RevenueGLCode`  string , `ARGLCode`  string , `PaymentGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `SalesTaxGLCode`  string , `PrepaymentGLCode`  string , `AccountType`  string , `ApplicationCryptogram`  string , `AuthorizationCode`  string , `AuthorizationResponseCode`  string , `CardholderVerificationMethod`  string , `TerminalVerificationResults`  string , `TransactionStatusInformation`  string , `TrackingCode`  string , `DiscountGLCode`  string , `OverrideTrackingCategory1`  string , `OverrideTrackingCategory2`  string , `QuickbooksPaymentId`  string , `AllowTotalPriceEntry`  string , `AddedAutomatically`  string , `AllocationPerformedDate`  string , `CreatedDate`  string , `IsHidden`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-11/1775894398'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceitemset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-11/1775894398
id: 1710419
processed: 1

raw_data:

{
    "ARGLCode": 74,
    "AccountType": 80,
    "AddedAutomatically": 93,
    "AllocationPerformedDate": 94,
    "AllocationType": 38,
    "AllowTotalPriceEntry": 92,
    "ApplicationCryptogram": 81,
    "AspNetUser_Id": 41,
    "AuthorizationCode": 82,
    "AuthorizationResponseCode": 83,
    "COGSGLCode": 76,
    "CardholderVerificationMethod": 84,
    "ChargeGroup": 18,
    "CreatedDate": 95,
    "CreationPartnerId": 54,
    "CreditInvoiceId": 37,
    "Currencies_Id": 69,
    "Date": 22,
    "DeletePartnerId": 55,
    "DeletionDateTime": 31,
    "DeletionReason": 50,
    "DeletionUserId": 30,
    "Discount": 6,
    "DiscountDateTime": 25,
    "DiscountGLCode": 88,
    "DiscountTotal": 11,
    "DiscountType": 7,
    "DiscountUserId": 26,
    "EndDateTime": 53,
    "EnteredAmount": 67,
    "ExchangeRate": 68,
    "Id": 0,
    "InventoryGLCode": 77,
    "InvoiceId": 17,
    "InvoiceItemType_Id": 42,
    "IsHidden": 96,
    "IsVoid": 21,
    "ItemMaster_Id": 40,
    "LastModifiedAspNetUser": 49,
    "LastModifiedDateTime": 48,
    "Misc": 10,
    "Misc2": 35,
    "Notes": 27,
    "NumberOfDecimals": 61,
    "OriginalCreditItem": 46,
    "OriginalPrice": 57,
    "OriginalReservationPrice": 60,
    "OverpaymentId": 32,
    "OverrideTrackingCategory1": 89,
    "OverrideTrackingCategory2": 90,
    "OverrideXeroSalesAccount": 59,
    "OverrideXeroTaxRate": 58,
    "PR_Type": 28,
    "PaymentAccount": 19,
    "PaymentGLCode": 75,
    "Prefix": 1,
    "PrepaymentGLCode": 79,
    "PrepaymentId": 36,
    "PriceStr": 20,
    "PriceSuffix": 12,
    "Quantity": 2,
    "QuickbooksPaymentId": 91,
    "Reservation_Id": 39,
    "RevenueGLCode": 73,
    "SVJobId": 45,
    "SV_ChargeInstance_Id": 70,
    "SV_LaborInstance_Id": 71,
    "SV_PartInstance_Id": 72,
    "SalesTaxGLCode": 78,
    "SeasonalPrice_Id": 43,
    "StartDateTime": 52,
    "Status": 29,
    "StripeAID": 66,
    "StripeApplicationName": 65,
    "StripeTerminalId": 64,
    "StripeTransactionData_Id": 62,
    "SubTotal": 13,
    "SubtotalWoDiscount": 14,
    "Tax": 9,
    "TaxExempt": 47,
    "TaxTotal": 15,
    "Taxable": 8,
    "TerminalVerificationResults": 85,
    "TextAux": 23,
    "TextAux2": 24,
    "Title": 3,
    "Total": 16,
    "TrackingCode": 87,
    "TransactionStatusInformation": 86,
    "TransientPrice_Id": 44,
    "Type": 4,
    "Value": 5,
    "ValueAlternative": 63,
    "VoidDateTime": 34,
    "VoidPartnerId": 56,
    "VoidReason": 51,
    "VoidUser": 33
}

schema_attributes:

{
    "ARGLCode": "string",
    "AccountType": "string",
    "AddedAutomatically": "string",
    "AllocationPerformedDate": "string",
    "AllocationType": "string",
    "AllowTotalPriceEntry": "string",
    "ApplicationCryptogram": "string",
    "AspNetUser_Id": "string",
    "AuthorizationCode": "string",
    "AuthorizationResponseCode": "string",
    "COGSGLCode": "string",
    "CardholderVerificationMethod": "string",
    "ChargeGroup": "string",
    "CreatedDate": "string",
    "CreationPartnerId": "string",
    "CreditInvoiceId": "string",
    "Currencies_Id": "string",
    "Date": "string",
    "DeletePartnerId": "string",
    "DeletionDateTime": "string",
    "DeletionReason": "string",
    "DeletionUserId": "string",
    "Discount": "string",
    "DiscountDateTime": "string",
    "DiscountGLCode": "string",
    "DiscountTotal": "string",
    "DiscountType": "string",
    "DiscountUserId": "string",
    "EndDateTime": "string",
    "EnteredAmount": "string",
    "ExchangeRate": "string",
    "Id": "string",
    "InventoryGLCode": "string",
    "InvoiceId": "string",
    "InvoiceItemType_Id": "string",
    "IsHidden": "string",
    "IsVoid": "string",
    "ItemMaster_Id": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "Misc": "string",
    "Misc2": "string",
    "Notes": "string",
    "NumberOfDecimals": "string",
    "OriginalCreditItem": "string",
    "OriginalPrice": "string",
    "OriginalReservationPrice": "string",
    "OverpaymentId": "string",
    "OverrideTrackingCategory1": "string",
    "OverrideTrackingCategory2": "string",
    "OverrideXeroSalesAccount": "string",
    "OverrideXeroTaxRate": "string",
    "PR_Type": "string",
    "PaymentAccount": "string",
    "PaymentGLCode": "string",
    "Prefix": "string",
    "PrepaymentGLCode": "string",
    "PrepaymentId": "string",
    "PriceStr": "string",
    "PriceSuffix": "string",
    "Quantity": "string",
    "QuickbooksPaymentId": "string",
    "Reservation_Id": "string",
    "RevenueGLCode": "string",
    "SVJobId": "string",
    "SV_ChargeInstance_Id": "string",
    "SV_LaborInstance_Id": "string",
    "SV_PartInstance_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonalPrice_Id": "string",
    "StartDateTime": "string",
    "Status": "string",
    "StripeAID": "string",
    "StripeApplicationName": "string",
    "StripeTerminalId": "string",
    "StripeTransactionData_Id": "string",
    "SubTotal": "string",
    "SubtotalWoDiscount": "string",
    "Tax": "string",
    "TaxExempt": "string",
    "TaxTotal": "string",
    "Taxable": "string",
    "TerminalVerificationResults": "string",
    "TextAux": "string",
    "TextAux2": "string",
    "Title": "string",
    "Total": "string",
    "TrackingCode": "string",
    "TransactionStatusInformation": "string",
    "TransientPrice_Id": "string",
    "Type": "string",
    "Value": "string",
    "ValueAlternative": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string"
}

schema_name_id: 1663
schema_scan_id: 161841199
updated: 2026-04-11 03:05:31

Version 1709208

created: 2026-04-10 03:04:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceitemset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceitemset`\n(\n `Id`  string , `Prefix`  string , `Quantity`  string , `Title`  string , `Type`  string , `Value`  string , `Discount`  string , `DiscountType`  string , `Taxable`  string , `Tax`  string , `Misc`  string , `DiscountTotal`  string , `PriceSuffix`  string , `SubTotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Total`  string , `InvoiceId`  string , `ChargeGroup`  string , `PaymentAccount`  string , `PriceStr`  string , `IsVoid`  string , `Date`  string , `TextAux`  string , `TextAux2`  string , `DiscountDateTime`  string , `DiscountUserId`  string , `Notes`  string , `PR_Type`  string , `Status`  string , `DeletionUserId`  string , `DeletionDateTime`  string , `OverpaymentId`  string , `VoidUser`  string , `VoidDateTime`  string , `Misc2`  string , `PrepaymentId`  string , `CreditInvoiceId`  string , `AllocationType`  string , `Reservation_Id`  string , `ItemMaster_Id`  string , `AspNetUser_Id`  string , `InvoiceItemType_Id`  string , `SeasonalPrice_Id`  string , `TransientPrice_Id`  string , `SVJobId`  string , `OriginalCreditItem`  string , `TaxExempt`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `DeletionReason`  string , `VoidReason`  string , `StartDateTime`  string , `EndDateTime`  string , `CreationPartnerId`  string , `DeletePartnerId`  string , `VoidPartnerId`  string , `OriginalPrice`  string , `OverrideXeroTaxRate`  string , `OverrideXeroSalesAccount`  string , `OriginalReservationPrice`  string , `NumberOfDecimals`  string , `StripeTransactionData_Id`  string , `ValueAlternative`  string , `StripeTerminalId`  string , `StripeApplicationName`  string , `StripeAID`  string , `EnteredAmount`  string , `ExchangeRate`  string , `Currencies_Id`  string , `SV_ChargeInstance_Id`  string , `SV_LaborInstance_Id`  string , `SV_PartInstance_Id`  string , `RevenueGLCode`  string , `ARGLCode`  string , `PaymentGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `SalesTaxGLCode`  string , `PrepaymentGLCode`  string , `AccountType`  string , `ApplicationCryptogram`  string , `AuthorizationCode`  string , `AuthorizationResponseCode`  string , `CardholderVerificationMethod`  string , `TerminalVerificationResults`  string , `TransactionStatusInformation`  string , `TrackingCode`  string , `DiscountGLCode`  string , `OverrideTrackingCategory1`  string , `OverrideTrackingCategory2`  string , `QuickbooksPaymentId`  string , `AllowTotalPriceEntry`  string , `AddedAutomatically`  string , `AllocationPerformedDate`  string , `CreatedDate`  string , `IsHidden`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-10/1775808155'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceitemset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-10/1775808155
id: 1709208
processed: 1

raw_data:

{
    "ARGLCode": 74,
    "AccountType": 80,
    "AddedAutomatically": 93,
    "AllocationPerformedDate": 94,
    "AllocationType": 38,
    "AllowTotalPriceEntry": 92,
    "ApplicationCryptogram": 81,
    "AspNetUser_Id": 41,
    "AuthorizationCode": 82,
    "AuthorizationResponseCode": 83,
    "COGSGLCode": 76,
    "CardholderVerificationMethod": 84,
    "ChargeGroup": 18,
    "CreatedDate": 95,
    "CreationPartnerId": 54,
    "CreditInvoiceId": 37,
    "Currencies_Id": 69,
    "Date": 22,
    "DeletePartnerId": 55,
    "DeletionDateTime": 31,
    "DeletionReason": 50,
    "DeletionUserId": 30,
    "Discount": 6,
    "DiscountDateTime": 25,
    "DiscountGLCode": 88,
    "DiscountTotal": 11,
    "DiscountType": 7,
    "DiscountUserId": 26,
    "EndDateTime": 53,
    "EnteredAmount": 67,
    "ExchangeRate": 68,
    "Id": 0,
    "InventoryGLCode": 77,
    "InvoiceId": 17,
    "InvoiceItemType_Id": 42,
    "IsHidden": 96,
    "IsVoid": 21,
    "ItemMaster_Id": 40,
    "LastModifiedAspNetUser": 49,
    "LastModifiedDateTime": 48,
    "Misc": 10,
    "Misc2": 35,
    "Notes": 27,
    "NumberOfDecimals": 61,
    "OriginalCreditItem": 46,
    "OriginalPrice": 57,
    "OriginalReservationPrice": 60,
    "OverpaymentId": 32,
    "OverrideTrackingCategory1": 89,
    "OverrideTrackingCategory2": 90,
    "OverrideXeroSalesAccount": 59,
    "OverrideXeroTaxRate": 58,
    "PR_Type": 28,
    "PaymentAccount": 19,
    "PaymentGLCode": 75,
    "Prefix": 1,
    "PrepaymentGLCode": 79,
    "PrepaymentId": 36,
    "PriceStr": 20,
    "PriceSuffix": 12,
    "Quantity": 2,
    "QuickbooksPaymentId": 91,
    "Reservation_Id": 39,
    "RevenueGLCode": 73,
    "SVJobId": 45,
    "SV_ChargeInstance_Id": 70,
    "SV_LaborInstance_Id": 71,
    "SV_PartInstance_Id": 72,
    "SalesTaxGLCode": 78,
    "SeasonalPrice_Id": 43,
    "StartDateTime": 52,
    "Status": 29,
    "StripeAID": 66,
    "StripeApplicationName": 65,
    "StripeTerminalId": 64,
    "StripeTransactionData_Id": 62,
    "SubTotal": 13,
    "SubtotalWoDiscount": 14,
    "Tax": 9,
    "TaxExempt": 47,
    "TaxTotal": 15,
    "Taxable": 8,
    "TerminalVerificationResults": 85,
    "TextAux": 23,
    "TextAux2": 24,
    "Title": 3,
    "Total": 16,
    "TrackingCode": 87,
    "TransactionStatusInformation": 86,
    "TransientPrice_Id": 44,
    "Type": 4,
    "Value": 5,
    "ValueAlternative": 63,
    "VoidDateTime": 34,
    "VoidPartnerId": 56,
    "VoidReason": 51,
    "VoidUser": 33
}

schema_attributes:

{
    "ARGLCode": "string",
    "AccountType": "string",
    "AddedAutomatically": "string",
    "AllocationPerformedDate": "string",
    "AllocationType": "string",
    "AllowTotalPriceEntry": "string",
    "ApplicationCryptogram": "string",
    "AspNetUser_Id": "string",
    "AuthorizationCode": "string",
    "AuthorizationResponseCode": "string",
    "COGSGLCode": "string",
    "CardholderVerificationMethod": "string",
    "ChargeGroup": "string",
    "CreatedDate": "string",
    "CreationPartnerId": "string",
    "CreditInvoiceId": "string",
    "Currencies_Id": "string",
    "Date": "string",
    "DeletePartnerId": "string",
    "DeletionDateTime": "string",
    "DeletionReason": "string",
    "DeletionUserId": "string",
    "Discount": "string",
    "DiscountDateTime": "string",
    "DiscountGLCode": "string",
    "DiscountTotal": "string",
    "DiscountType": "string",
    "DiscountUserId": "string",
    "EndDateTime": "string",
    "EnteredAmount": "string",
    "ExchangeRate": "string",
    "Id": "string",
    "InventoryGLCode": "string",
    "InvoiceId": "string",
    "InvoiceItemType_Id": "string",
    "IsHidden": "string",
    "IsVoid": "string",
    "ItemMaster_Id": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "Misc": "string",
    "Misc2": "string",
    "Notes": "string",
    "NumberOfDecimals": "string",
    "OriginalCreditItem": "string",
    "OriginalPrice": "string",
    "OriginalReservationPrice": "string",
    "OverpaymentId": "string",
    "OverrideTrackingCategory1": "string",
    "OverrideTrackingCategory2": "string",
    "OverrideXeroSalesAccount": "string",
    "OverrideXeroTaxRate": "string",
    "PR_Type": "string",
    "PaymentAccount": "string",
    "PaymentGLCode": "string",
    "Prefix": "string",
    "PrepaymentGLCode": "string",
    "PrepaymentId": "string",
    "PriceStr": "string",
    "PriceSuffix": "string",
    "Quantity": "string",
    "QuickbooksPaymentId": "string",
    "Reservation_Id": "string",
    "RevenueGLCode": "string",
    "SVJobId": "string",
    "SV_ChargeInstance_Id": "string",
    "SV_LaborInstance_Id": "string",
    "SV_PartInstance_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonalPrice_Id": "string",
    "StartDateTime": "string",
    "Status": "string",
    "StripeAID": "string",
    "StripeApplicationName": "string",
    "StripeTerminalId": "string",
    "StripeTransactionData_Id": "string",
    "SubTotal": "string",
    "SubtotalWoDiscount": "string",
    "Tax": "string",
    "TaxExempt": "string",
    "TaxTotal": "string",
    "Taxable": "string",
    "TerminalVerificationResults": "string",
    "TextAux": "string",
    "TextAux2": "string",
    "Title": "string",
    "Total": "string",
    "TrackingCode": "string",
    "TransactionStatusInformation": "string",
    "TransientPrice_Id": "string",
    "Type": "string",
    "Value": "string",
    "ValueAlternative": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string"
}

schema_name_id: 1663
schema_scan_id: 161785888
updated: 2026-04-10 03:04:55

Version 1708094

created: 2026-04-09 03:02:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceitemset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceitemset`\n(\n `Id`  string , `Prefix`  string , `Quantity`  string , `Title`  string , `Type`  string , `Value`  string , `Discount`  string , `DiscountType`  string , `Taxable`  string , `Tax`  string , `Misc`  string , `DiscountTotal`  string , `PriceSuffix`  string , `SubTotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Total`  string , `InvoiceId`  string , `ChargeGroup`  string , `PaymentAccount`  string , `PriceStr`  string , `IsVoid`  string , `Date`  string , `TextAux`  string , `TextAux2`  string , `DiscountDateTime`  string , `DiscountUserId`  string , `Notes`  string , `PR_Type`  string , `Status`  string , `DeletionUserId`  string , `DeletionDateTime`  string , `OverpaymentId`  string , `VoidUser`  string , `VoidDateTime`  string , `Misc2`  string , `PrepaymentId`  string , `CreditInvoiceId`  string , `AllocationType`  string , `Reservation_Id`  string , `ItemMaster_Id`  string , `AspNetUser_Id`  string , `InvoiceItemType_Id`  string , `SeasonalPrice_Id`  string , `TransientPrice_Id`  string , `SVJobId`  string , `OriginalCreditItem`  string , `TaxExempt`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `DeletionReason`  string , `VoidReason`  string , `StartDateTime`  string , `EndDateTime`  string , `CreationPartnerId`  string , `DeletePartnerId`  string , `VoidPartnerId`  string , `OriginalPrice`  string , `OverrideXeroTaxRate`  string , `OverrideXeroSalesAccount`  string , `OriginalReservationPrice`  string , `NumberOfDecimals`  string , `StripeTransactionData_Id`  string , `ValueAlternative`  string , `StripeTerminalId`  string , `StripeApplicationName`  string , `StripeAID`  string , `EnteredAmount`  string , `ExchangeRate`  string , `Currencies_Id`  string , `SV_ChargeInstance_Id`  string , `SV_LaborInstance_Id`  string , `SV_PartInstance_Id`  string , `RevenueGLCode`  string , `ARGLCode`  string , `PaymentGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `SalesTaxGLCode`  string , `PrepaymentGLCode`  string , `AccountType`  string , `ApplicationCryptogram`  string , `AuthorizationCode`  string , `AuthorizationResponseCode`  string , `CardholderVerificationMethod`  string , `TerminalVerificationResults`  string , `TransactionStatusInformation`  string , `TrackingCode`  string , `DiscountGLCode`  string , `OverrideTrackingCategory1`  string , `OverrideTrackingCategory2`  string , `QuickbooksPaymentId`  string , `AllowTotalPriceEntry`  string , `AddedAutomatically`  string , `AllocationPerformedDate`  string , `CreatedDate`  string , `IsHidden`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-09/1775721492'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceitemset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-09/1775721492
id: 1708094
processed: 1

raw_data:

{
    "ARGLCode": 74,
    "AccountType": 80,
    "AddedAutomatically": 93,
    "AllocationPerformedDate": 94,
    "AllocationType": 38,
    "AllowTotalPriceEntry": 92,
    "ApplicationCryptogram": 81,
    "AspNetUser_Id": 41,
    "AuthorizationCode": 82,
    "AuthorizationResponseCode": 83,
    "COGSGLCode": 76,
    "CardholderVerificationMethod": 84,
    "ChargeGroup": 18,
    "CreatedDate": 95,
    "CreationPartnerId": 54,
    "CreditInvoiceId": 37,
    "Currencies_Id": 69,
    "Date": 22,
    "DeletePartnerId": 55,
    "DeletionDateTime": 31,
    "DeletionReason": 50,
    "DeletionUserId": 30,
    "Discount": 6,
    "DiscountDateTime": 25,
    "DiscountGLCode": 88,
    "DiscountTotal": 11,
    "DiscountType": 7,
    "DiscountUserId": 26,
    "EndDateTime": 53,
    "EnteredAmount": 67,
    "ExchangeRate": 68,
    "Id": 0,
    "InventoryGLCode": 77,
    "InvoiceId": 17,
    "InvoiceItemType_Id": 42,
    "IsHidden": 96,
    "IsVoid": 21,
    "ItemMaster_Id": 40,
    "LastModifiedAspNetUser": 49,
    "LastModifiedDateTime": 48,
    "Misc": 10,
    "Misc2": 35,
    "Notes": 27,
    "NumberOfDecimals": 61,
    "OriginalCreditItem": 46,
    "OriginalPrice": 57,
    "OriginalReservationPrice": 60,
    "OverpaymentId": 32,
    "OverrideTrackingCategory1": 89,
    "OverrideTrackingCategory2": 90,
    "OverrideXeroSalesAccount": 59,
    "OverrideXeroTaxRate": 58,
    "PR_Type": 28,
    "PaymentAccount": 19,
    "PaymentGLCode": 75,
    "Prefix": 1,
    "PrepaymentGLCode": 79,
    "PrepaymentId": 36,
    "PriceStr": 20,
    "PriceSuffix": 12,
    "Quantity": 2,
    "QuickbooksPaymentId": 91,
    "Reservation_Id": 39,
    "RevenueGLCode": 73,
    "SVJobId": 45,
    "SV_ChargeInstance_Id": 70,
    "SV_LaborInstance_Id": 71,
    "SV_PartInstance_Id": 72,
    "SalesTaxGLCode": 78,
    "SeasonalPrice_Id": 43,
    "StartDateTime": 52,
    "Status": 29,
    "StripeAID": 66,
    "StripeApplicationName": 65,
    "StripeTerminalId": 64,
    "StripeTransactionData_Id": 62,
    "SubTotal": 13,
    "SubtotalWoDiscount": 14,
    "Tax": 9,
    "TaxExempt": 47,
    "TaxTotal": 15,
    "Taxable": 8,
    "TerminalVerificationResults": 85,
    "TextAux": 23,
    "TextAux2": 24,
    "Title": 3,
    "Total": 16,
    "TrackingCode": 87,
    "TransactionStatusInformation": 86,
    "TransientPrice_Id": 44,
    "Type": 4,
    "Value": 5,
    "ValueAlternative": 63,
    "VoidDateTime": 34,
    "VoidPartnerId": 56,
    "VoidReason": 51,
    "VoidUser": 33
}

schema_attributes:

{
    "ARGLCode": "string",
    "AccountType": "string",
    "AddedAutomatically": "string",
    "AllocationPerformedDate": "string",
    "AllocationType": "string",
    "AllowTotalPriceEntry": "string",
    "ApplicationCryptogram": "string",
    "AspNetUser_Id": "string",
    "AuthorizationCode": "string",
    "AuthorizationResponseCode": "string",
    "COGSGLCode": "string",
    "CardholderVerificationMethod": "string",
    "ChargeGroup": "string",
    "CreatedDate": "string",
    "CreationPartnerId": "string",
    "CreditInvoiceId": "string",
    "Currencies_Id": "string",
    "Date": "string",
    "DeletePartnerId": "string",
    "DeletionDateTime": "string",
    "DeletionReason": "string",
    "DeletionUserId": "string",
    "Discount": "string",
    "DiscountDateTime": "string",
    "DiscountGLCode": "string",
    "DiscountTotal": "string",
    "DiscountType": "string",
    "DiscountUserId": "string",
    "EndDateTime": "string",
    "EnteredAmount": "string",
    "ExchangeRate": "string",
    "Id": "string",
    "InventoryGLCode": "string",
    "InvoiceId": "string",
    "InvoiceItemType_Id": "string",
    "IsHidden": "string",
    "IsVoid": "string",
    "ItemMaster_Id": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "Misc": "string",
    "Misc2": "string",
    "Notes": "string",
    "NumberOfDecimals": "string",
    "OriginalCreditItem": "string",
    "OriginalPrice": "string",
    "OriginalReservationPrice": "string",
    "OverpaymentId": "string",
    "OverrideTrackingCategory1": "string",
    "OverrideTrackingCategory2": "string",
    "OverrideXeroSalesAccount": "string",
    "OverrideXeroTaxRate": "string",
    "PR_Type": "string",
    "PaymentAccount": "string",
    "PaymentGLCode": "string",
    "Prefix": "string",
    "PrepaymentGLCode": "string",
    "PrepaymentId": "string",
    "PriceStr": "string",
    "PriceSuffix": "string",
    "Quantity": "string",
    "QuickbooksPaymentId": "string",
    "Reservation_Id": "string",
    "RevenueGLCode": "string",
    "SVJobId": "string",
    "SV_ChargeInstance_Id": "string",
    "SV_LaborInstance_Id": "string",
    "SV_PartInstance_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonalPrice_Id": "string",
    "StartDateTime": "string",
    "Status": "string",
    "StripeAID": "string",
    "StripeApplicationName": "string",
    "StripeTerminalId": "string",
    "StripeTransactionData_Id": "string",
    "SubTotal": "string",
    "SubtotalWoDiscount": "string",
    "Tax": "string",
    "TaxExempt": "string",
    "TaxTotal": "string",
    "Taxable": "string",
    "TerminalVerificationResults": "string",
    "TextAux": "string",
    "TextAux2": "string",
    "Title": "string",
    "Total": "string",
    "TrackingCode": "string",
    "TransactionStatusInformation": "string",
    "TransientPrice_Id": "string",
    "Type": "string",
    "Value": "string",
    "ValueAlternative": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string"
}

schema_name_id: 1663
schema_scan_id: 161730134
updated: 2026-04-09 03:02:21

Version 1706849

created: 2026-04-08 03:03:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceitemset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceitemset`\n(\n `Id`  string , `Prefix`  string , `Quantity`  string , `Title`  string , `Type`  string , `Value`  string , `Discount`  string , `DiscountType`  string , `Taxable`  string , `Tax`  string , `Misc`  string , `DiscountTotal`  string , `PriceSuffix`  string , `SubTotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Total`  string , `InvoiceId`  string , `ChargeGroup`  string , `PaymentAccount`  string , `PriceStr`  string , `IsVoid`  string , `Date`  string , `TextAux`  string , `TextAux2`  string , `DiscountDateTime`  string , `DiscountUserId`  string , `Notes`  string , `PR_Type`  string , `Status`  string , `DeletionUserId`  string , `DeletionDateTime`  string , `OverpaymentId`  string , `VoidUser`  string , `VoidDateTime`  string , `Misc2`  string , `PrepaymentId`  string , `CreditInvoiceId`  string , `AllocationType`  string , `Reservation_Id`  string , `ItemMaster_Id`  string , `AspNetUser_Id`  string , `InvoiceItemType_Id`  string , `SeasonalPrice_Id`  string , `TransientPrice_Id`  string , `SVJobId`  string , `OriginalCreditItem`  string , `TaxExempt`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `DeletionReason`  string , `VoidReason`  string , `StartDateTime`  string , `EndDateTime`  string , `CreationPartnerId`  string , `DeletePartnerId`  string , `VoidPartnerId`  string , `OriginalPrice`  string , `OverrideXeroTaxRate`  string , `OverrideXeroSalesAccount`  string , `OriginalReservationPrice`  string , `NumberOfDecimals`  string , `StripeTransactionData_Id`  string , `ValueAlternative`  string , `StripeTerminalId`  string , `StripeApplicationName`  string , `StripeAID`  string , `EnteredAmount`  string , `ExchangeRate`  string , `Currencies_Id`  string , `SV_ChargeInstance_Id`  string , `SV_LaborInstance_Id`  string , `SV_PartInstance_Id`  string , `RevenueGLCode`  string , `ARGLCode`  string , `PaymentGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `SalesTaxGLCode`  string , `PrepaymentGLCode`  string , `AccountType`  string , `ApplicationCryptogram`  string , `AuthorizationCode`  string , `AuthorizationResponseCode`  string , `CardholderVerificationMethod`  string , `TerminalVerificationResults`  string , `TransactionStatusInformation`  string , `TrackingCode`  string , `DiscountGLCode`  string , `OverrideTrackingCategory1`  string , `OverrideTrackingCategory2`  string , `QuickbooksPaymentId`  string , `AllowTotalPriceEntry`  string , `AddedAutomatically`  string , `AllocationPerformedDate`  string , `CreatedDate`  string , `IsHidden`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-08/1775635312'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceitemset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-08/1775635312
id: 1706849
processed: 1

raw_data:

{
    "ARGLCode": 74,
    "AccountType": 80,
    "AddedAutomatically": 93,
    "AllocationPerformedDate": 94,
    "AllocationType": 38,
    "AllowTotalPriceEntry": 92,
    "ApplicationCryptogram": 81,
    "AspNetUser_Id": 41,
    "AuthorizationCode": 82,
    "AuthorizationResponseCode": 83,
    "COGSGLCode": 76,
    "CardholderVerificationMethod": 84,
    "ChargeGroup": 18,
    "CreatedDate": 95,
    "CreationPartnerId": 54,
    "CreditInvoiceId": 37,
    "Currencies_Id": 69,
    "Date": 22,
    "DeletePartnerId": 55,
    "DeletionDateTime": 31,
    "DeletionReason": 50,
    "DeletionUserId": 30,
    "Discount": 6,
    "DiscountDateTime": 25,
    "DiscountGLCode": 88,
    "DiscountTotal": 11,
    "DiscountType": 7,
    "DiscountUserId": 26,
    "EndDateTime": 53,
    "EnteredAmount": 67,
    "ExchangeRate": 68,
    "Id": 0,
    "InventoryGLCode": 77,
    "InvoiceId": 17,
    "InvoiceItemType_Id": 42,
    "IsHidden": 96,
    "IsVoid": 21,
    "ItemMaster_Id": 40,
    "LastModifiedAspNetUser": 49,
    "LastModifiedDateTime": 48,
    "Misc": 10,
    "Misc2": 35,
    "Notes": 27,
    "NumberOfDecimals": 61,
    "OriginalCreditItem": 46,
    "OriginalPrice": 57,
    "OriginalReservationPrice": 60,
    "OverpaymentId": 32,
    "OverrideTrackingCategory1": 89,
    "OverrideTrackingCategory2": 90,
    "OverrideXeroSalesAccount": 59,
    "OverrideXeroTaxRate": 58,
    "PR_Type": 28,
    "PaymentAccount": 19,
    "PaymentGLCode": 75,
    "Prefix": 1,
    "PrepaymentGLCode": 79,
    "PrepaymentId": 36,
    "PriceStr": 20,
    "PriceSuffix": 12,
    "Quantity": 2,
    "QuickbooksPaymentId": 91,
    "Reservation_Id": 39,
    "RevenueGLCode": 73,
    "SVJobId": 45,
    "SV_ChargeInstance_Id": 70,
    "SV_LaborInstance_Id": 71,
    "SV_PartInstance_Id": 72,
    "SalesTaxGLCode": 78,
    "SeasonalPrice_Id": 43,
    "StartDateTime": 52,
    "Status": 29,
    "StripeAID": 66,
    "StripeApplicationName": 65,
    "StripeTerminalId": 64,
    "StripeTransactionData_Id": 62,
    "SubTotal": 13,
    "SubtotalWoDiscount": 14,
    "Tax": 9,
    "TaxExempt": 47,
    "TaxTotal": 15,
    "Taxable": 8,
    "TerminalVerificationResults": 85,
    "TextAux": 23,
    "TextAux2": 24,
    "Title": 3,
    "Total": 16,
    "TrackingCode": 87,
    "TransactionStatusInformation": 86,
    "TransientPrice_Id": 44,
    "Type": 4,
    "Value": 5,
    "ValueAlternative": 63,
    "VoidDateTime": 34,
    "VoidPartnerId": 56,
    "VoidReason": 51,
    "VoidUser": 33
}

schema_attributes:

{
    "ARGLCode": "string",
    "AccountType": "string",
    "AddedAutomatically": "string",
    "AllocationPerformedDate": "string",
    "AllocationType": "string",
    "AllowTotalPriceEntry": "string",
    "ApplicationCryptogram": "string",
    "AspNetUser_Id": "string",
    "AuthorizationCode": "string",
    "AuthorizationResponseCode": "string",
    "COGSGLCode": "string",
    "CardholderVerificationMethod": "string",
    "ChargeGroup": "string",
    "CreatedDate": "string",
    "CreationPartnerId": "string",
    "CreditInvoiceId": "string",
    "Currencies_Id": "string",
    "Date": "string",
    "DeletePartnerId": "string",
    "DeletionDateTime": "string",
    "DeletionReason": "string",
    "DeletionUserId": "string",
    "Discount": "string",
    "DiscountDateTime": "string",
    "DiscountGLCode": "string",
    "DiscountTotal": "string",
    "DiscountType": "string",
    "DiscountUserId": "string",
    "EndDateTime": "string",
    "EnteredAmount": "string",
    "ExchangeRate": "string",
    "Id": "string",
    "InventoryGLCode": "string",
    "InvoiceId": "string",
    "InvoiceItemType_Id": "string",
    "IsHidden": "string",
    "IsVoid": "string",
    "ItemMaster_Id": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "Misc": "string",
    "Misc2": "string",
    "Notes": "string",
    "NumberOfDecimals": "string",
    "OriginalCreditItem": "string",
    "OriginalPrice": "string",
    "OriginalReservationPrice": "string",
    "OverpaymentId": "string",
    "OverrideTrackingCategory1": "string",
    "OverrideTrackingCategory2": "string",
    "OverrideXeroSalesAccount": "string",
    "OverrideXeroTaxRate": "string",
    "PR_Type": "string",
    "PaymentAccount": "string",
    "PaymentGLCode": "string",
    "Prefix": "string",
    "PrepaymentGLCode": "string",
    "PrepaymentId": "string",
    "PriceStr": "string",
    "PriceSuffix": "string",
    "Quantity": "string",
    "QuickbooksPaymentId": "string",
    "Reservation_Id": "string",
    "RevenueGLCode": "string",
    "SVJobId": "string",
    "SV_ChargeInstance_Id": "string",
    "SV_LaborInstance_Id": "string",
    "SV_PartInstance_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonalPrice_Id": "string",
    "StartDateTime": "string",
    "Status": "string",
    "StripeAID": "string",
    "StripeApplicationName": "string",
    "StripeTerminalId": "string",
    "StripeTransactionData_Id": "string",
    "SubTotal": "string",
    "SubtotalWoDiscount": "string",
    "Tax": "string",
    "TaxExempt": "string",
    "TaxTotal": "string",
    "Taxable": "string",
    "TerminalVerificationResults": "string",
    "TextAux": "string",
    "TextAux2": "string",
    "Title": "string",
    "Total": "string",
    "TrackingCode": "string",
    "TransactionStatusInformation": "string",
    "TransientPrice_Id": "string",
    "Type": "string",
    "Value": "string",
    "ValueAlternative": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string"
}

schema_name_id: 1663
schema_scan_id: 161675422
updated: 2026-04-08 03:03:29

Version 1705740

created: 2026-04-07 02:58:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceitemset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceitemset`\n(\n `Id`  string , `Prefix`  string , `Quantity`  string , `Title`  string , `Type`  string , `Value`  string , `Discount`  string , `DiscountType`  string , `Taxable`  string , `Tax`  string , `Misc`  string , `DiscountTotal`  string , `PriceSuffix`  string , `SubTotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Total`  string , `InvoiceId`  string , `ChargeGroup`  string , `PaymentAccount`  string , `PriceStr`  string , `IsVoid`  string , `Date`  string , `TextAux`  string , `TextAux2`  string , `DiscountDateTime`  string , `DiscountUserId`  string , `Notes`  string , `PR_Type`  string , `Status`  string , `DeletionUserId`  string , `DeletionDateTime`  string , `OverpaymentId`  string , `VoidUser`  string , `VoidDateTime`  string , `Misc2`  string , `PrepaymentId`  string , `CreditInvoiceId`  string , `AllocationType`  string , `Reservation_Id`  string , `ItemMaster_Id`  string , `AspNetUser_Id`  string , `InvoiceItemType_Id`  string , `SeasonalPrice_Id`  string , `TransientPrice_Id`  string , `SVJobId`  string , `OriginalCreditItem`  string , `TaxExempt`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `DeletionReason`  string , `VoidReason`  string , `StartDateTime`  string , `EndDateTime`  string , `CreationPartnerId`  string , `DeletePartnerId`  string , `VoidPartnerId`  string , `OriginalPrice`  string , `OverrideXeroTaxRate`  string , `OverrideXeroSalesAccount`  string , `OriginalReservationPrice`  string , `NumberOfDecimals`  string , `StripeTransactionData_Id`  string , `ValueAlternative`  string , `StripeTerminalId`  string , `StripeApplicationName`  string , `StripeAID`  string , `EnteredAmount`  string , `ExchangeRate`  string , `Currencies_Id`  string , `SV_ChargeInstance_Id`  string , `SV_LaborInstance_Id`  string , `SV_PartInstance_Id`  string , `RevenueGLCode`  string , `ARGLCode`  string , `PaymentGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `SalesTaxGLCode`  string , `PrepaymentGLCode`  string , `AccountType`  string , `ApplicationCryptogram`  string , `AuthorizationCode`  string , `AuthorizationResponseCode`  string , `CardholderVerificationMethod`  string , `TerminalVerificationResults`  string , `TransactionStatusInformation`  string , `TrackingCode`  string , `DiscountGLCode`  string , `OverrideTrackingCategory1`  string , `OverrideTrackingCategory2`  string , `QuickbooksPaymentId`  string , `AllowTotalPriceEntry`  string , `AddedAutomatically`  string , `AllocationPerformedDate`  string , `CreatedDate`  string , `IsHidden`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-07/1775548473'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceitemset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-07/1775548473
id: 1705740
processed: 1

raw_data:

{
    "ARGLCode": 74,
    "AccountType": 80,
    "AddedAutomatically": 93,
    "AllocationPerformedDate": 94,
    "AllocationType": 38,
    "AllowTotalPriceEntry": 92,
    "ApplicationCryptogram": 81,
    "AspNetUser_Id": 41,
    "AuthorizationCode": 82,
    "AuthorizationResponseCode": 83,
    "COGSGLCode": 76,
    "CardholderVerificationMethod": 84,
    "ChargeGroup": 18,
    "CreatedDate": 95,
    "CreationPartnerId": 54,
    "CreditInvoiceId": 37,
    "Currencies_Id": 69,
    "Date": 22,
    "DeletePartnerId": 55,
    "DeletionDateTime": 31,
    "DeletionReason": 50,
    "DeletionUserId": 30,
    "Discount": 6,
    "DiscountDateTime": 25,
    "DiscountGLCode": 88,
    "DiscountTotal": 11,
    "DiscountType": 7,
    "DiscountUserId": 26,
    "EndDateTime": 53,
    "EnteredAmount": 67,
    "ExchangeRate": 68,
    "Id": 0,
    "InventoryGLCode": 77,
    "InvoiceId": 17,
    "InvoiceItemType_Id": 42,
    "IsHidden": 96,
    "IsVoid": 21,
    "ItemMaster_Id": 40,
    "LastModifiedAspNetUser": 49,
    "LastModifiedDateTime": 48,
    "Misc": 10,
    "Misc2": 35,
    "Notes": 27,
    "NumberOfDecimals": 61,
    "OriginalCreditItem": 46,
    "OriginalPrice": 57,
    "OriginalReservationPrice": 60,
    "OverpaymentId": 32,
    "OverrideTrackingCategory1": 89,
    "OverrideTrackingCategory2": 90,
    "OverrideXeroSalesAccount": 59,
    "OverrideXeroTaxRate": 58,
    "PR_Type": 28,
    "PaymentAccount": 19,
    "PaymentGLCode": 75,
    "Prefix": 1,
    "PrepaymentGLCode": 79,
    "PrepaymentId": 36,
    "PriceStr": 20,
    "PriceSuffix": 12,
    "Quantity": 2,
    "QuickbooksPaymentId": 91,
    "Reservation_Id": 39,
    "RevenueGLCode": 73,
    "SVJobId": 45,
    "SV_ChargeInstance_Id": 70,
    "SV_LaborInstance_Id": 71,
    "SV_PartInstance_Id": 72,
    "SalesTaxGLCode": 78,
    "SeasonalPrice_Id": 43,
    "StartDateTime": 52,
    "Status": 29,
    "StripeAID": 66,
    "StripeApplicationName": 65,
    "StripeTerminalId": 64,
    "StripeTransactionData_Id": 62,
    "SubTotal": 13,
    "SubtotalWoDiscount": 14,
    "Tax": 9,
    "TaxExempt": 47,
    "TaxTotal": 15,
    "Taxable": 8,
    "TerminalVerificationResults": 85,
    "TextAux": 23,
    "TextAux2": 24,
    "Title": 3,
    "Total": 16,
    "TrackingCode": 87,
    "TransactionStatusInformation": 86,
    "TransientPrice_Id": 44,
    "Type": 4,
    "Value": 5,
    "ValueAlternative": 63,
    "VoidDateTime": 34,
    "VoidPartnerId": 56,
    "VoidReason": 51,
    "VoidUser": 33
}

schema_attributes:

{
    "ARGLCode": "string",
    "AccountType": "string",
    "AddedAutomatically": "string",
    "AllocationPerformedDate": "string",
    "AllocationType": "string",
    "AllowTotalPriceEntry": "string",
    "ApplicationCryptogram": "string",
    "AspNetUser_Id": "string",
    "AuthorizationCode": "string",
    "AuthorizationResponseCode": "string",
    "COGSGLCode": "string",
    "CardholderVerificationMethod": "string",
    "ChargeGroup": "string",
    "CreatedDate": "string",
    "CreationPartnerId": "string",
    "CreditInvoiceId": "string",
    "Currencies_Id": "string",
    "Date": "string",
    "DeletePartnerId": "string",
    "DeletionDateTime": "string",
    "DeletionReason": "string",
    "DeletionUserId": "string",
    "Discount": "string",
    "DiscountDateTime": "string",
    "DiscountGLCode": "string",
    "DiscountTotal": "string",
    "DiscountType": "string",
    "DiscountUserId": "string",
    "EndDateTime": "string",
    "EnteredAmount": "string",
    "ExchangeRate": "string",
    "Id": "string",
    "InventoryGLCode": "string",
    "InvoiceId": "string",
    "InvoiceItemType_Id": "string",
    "IsHidden": "string",
    "IsVoid": "string",
    "ItemMaster_Id": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "Misc": "string",
    "Misc2": "string",
    "Notes": "string",
    "NumberOfDecimals": "string",
    "OriginalCreditItem": "string",
    "OriginalPrice": "string",
    "OriginalReservationPrice": "string",
    "OverpaymentId": "string",
    "OverrideTrackingCategory1": "string",
    "OverrideTrackingCategory2": "string",
    "OverrideXeroSalesAccount": "string",
    "OverrideXeroTaxRate": "string",
    "PR_Type": "string",
    "PaymentAccount": "string",
    "PaymentGLCode": "string",
    "Prefix": "string",
    "PrepaymentGLCode": "string",
    "PrepaymentId": "string",
    "PriceStr": "string",
    "PriceSuffix": "string",
    "Quantity": "string",
    "QuickbooksPaymentId": "string",
    "Reservation_Id": "string",
    "RevenueGLCode": "string",
    "SVJobId": "string",
    "SV_ChargeInstance_Id": "string",
    "SV_LaborInstance_Id": "string",
    "SV_PartInstance_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonalPrice_Id": "string",
    "StartDateTime": "string",
    "Status": "string",
    "StripeAID": "string",
    "StripeApplicationName": "string",
    "StripeTerminalId": "string",
    "StripeTransactionData_Id": "string",
    "SubTotal": "string",
    "SubtotalWoDiscount": "string",
    "Tax": "string",
    "TaxExempt": "string",
    "TaxTotal": "string",
    "Taxable": "string",
    "TerminalVerificationResults": "string",
    "TextAux": "string",
    "TextAux2": "string",
    "Title": "string",
    "Total": "string",
    "TrackingCode": "string",
    "TransactionStatusInformation": "string",
    "TransientPrice_Id": "string",
    "Type": "string",
    "Value": "string",
    "ValueAlternative": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string"
}

schema_name_id: 1663
schema_scan_id: 161618479
updated: 2026-04-07 02:58:45

Version 1704452

created: 2026-04-06 03:03:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceitemset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceitemset`\n(\n `Id`  string , `Prefix`  string , `Quantity`  string , `Title`  string , `Type`  string , `Value`  string , `Discount`  string , `DiscountType`  string , `Taxable`  string , `Tax`  string , `Misc`  string , `DiscountTotal`  string , `PriceSuffix`  string , `SubTotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Total`  string , `InvoiceId`  string , `ChargeGroup`  string , `PaymentAccount`  string , `PriceStr`  string , `IsVoid`  string , `Date`  string , `TextAux`  string , `TextAux2`  string , `DiscountDateTime`  string , `DiscountUserId`  string , `Notes`  string , `PR_Type`  string , `Status`  string , `DeletionUserId`  string , `DeletionDateTime`  string , `OverpaymentId`  string , `VoidUser`  string , `VoidDateTime`  string , `Misc2`  string , `PrepaymentId`  string , `CreditInvoiceId`  string , `AllocationType`  string , `Reservation_Id`  string , `ItemMaster_Id`  string , `AspNetUser_Id`  string , `InvoiceItemType_Id`  string , `SeasonalPrice_Id`  string , `TransientPrice_Id`  string , `SVJobId`  string , `OriginalCreditItem`  string , `TaxExempt`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `DeletionReason`  string , `VoidReason`  string , `StartDateTime`  string , `EndDateTime`  string , `CreationPartnerId`  string , `DeletePartnerId`  string , `VoidPartnerId`  string , `OriginalPrice`  string , `OverrideXeroTaxRate`  string , `OverrideXeroSalesAccount`  string , `OriginalReservationPrice`  string , `NumberOfDecimals`  string , `StripeTransactionData_Id`  string , `ValueAlternative`  string , `StripeTerminalId`  string , `StripeApplicationName`  string , `StripeAID`  string , `EnteredAmount`  string , `ExchangeRate`  string , `Currencies_Id`  string , `SV_ChargeInstance_Id`  string , `SV_LaborInstance_Id`  string , `SV_PartInstance_Id`  string , `RevenueGLCode`  string , `ARGLCode`  string , `PaymentGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `SalesTaxGLCode`  string , `PrepaymentGLCode`  string , `AccountType`  string , `ApplicationCryptogram`  string , `AuthorizationCode`  string , `AuthorizationResponseCode`  string , `CardholderVerificationMethod`  string , `TerminalVerificationResults`  string , `TransactionStatusInformation`  string , `TrackingCode`  string , `DiscountGLCode`  string , `OverrideTrackingCategory1`  string , `OverrideTrackingCategory2`  string , `QuickbooksPaymentId`  string , `AllowTotalPriceEntry`  string , `AddedAutomatically`  string , `AllocationPerformedDate`  string , `CreatedDate`  string , `IsHidden`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-06/1775462440'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceitemset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-06/1775462440
id: 1704452
processed: 1

raw_data:

{
    "ARGLCode": 74,
    "AccountType": 80,
    "AddedAutomatically": 93,
    "AllocationPerformedDate": 94,
    "AllocationType": 38,
    "AllowTotalPriceEntry": 92,
    "ApplicationCryptogram": 81,
    "AspNetUser_Id": 41,
    "AuthorizationCode": 82,
    "AuthorizationResponseCode": 83,
    "COGSGLCode": 76,
    "CardholderVerificationMethod": 84,
    "ChargeGroup": 18,
    "CreatedDate": 95,
    "CreationPartnerId": 54,
    "CreditInvoiceId": 37,
    "Currencies_Id": 69,
    "Date": 22,
    "DeletePartnerId": 55,
    "DeletionDateTime": 31,
    "DeletionReason": 50,
    "DeletionUserId": 30,
    "Discount": 6,
    "DiscountDateTime": 25,
    "DiscountGLCode": 88,
    "DiscountTotal": 11,
    "DiscountType": 7,
    "DiscountUserId": 26,
    "EndDateTime": 53,
    "EnteredAmount": 67,
    "ExchangeRate": 68,
    "Id": 0,
    "InventoryGLCode": 77,
    "InvoiceId": 17,
    "InvoiceItemType_Id": 42,
    "IsHidden": 96,
    "IsVoid": 21,
    "ItemMaster_Id": 40,
    "LastModifiedAspNetUser": 49,
    "LastModifiedDateTime": 48,
    "Misc": 10,
    "Misc2": 35,
    "Notes": 27,
    "NumberOfDecimals": 61,
    "OriginalCreditItem": 46,
    "OriginalPrice": 57,
    "OriginalReservationPrice": 60,
    "OverpaymentId": 32,
    "OverrideTrackingCategory1": 89,
    "OverrideTrackingCategory2": 90,
    "OverrideXeroSalesAccount": 59,
    "OverrideXeroTaxRate": 58,
    "PR_Type": 28,
    "PaymentAccount": 19,
    "PaymentGLCode": 75,
    "Prefix": 1,
    "PrepaymentGLCode": 79,
    "PrepaymentId": 36,
    "PriceStr": 20,
    "PriceSuffix": 12,
    "Quantity": 2,
    "QuickbooksPaymentId": 91,
    "Reservation_Id": 39,
    "RevenueGLCode": 73,
    "SVJobId": 45,
    "SV_ChargeInstance_Id": 70,
    "SV_LaborInstance_Id": 71,
    "SV_PartInstance_Id": 72,
    "SalesTaxGLCode": 78,
    "SeasonalPrice_Id": 43,
    "StartDateTime": 52,
    "Status": 29,
    "StripeAID": 66,
    "StripeApplicationName": 65,
    "StripeTerminalId": 64,
    "StripeTransactionData_Id": 62,
    "SubTotal": 13,
    "SubtotalWoDiscount": 14,
    "Tax": 9,
    "TaxExempt": 47,
    "TaxTotal": 15,
    "Taxable": 8,
    "TerminalVerificationResults": 85,
    "TextAux": 23,
    "TextAux2": 24,
    "Title": 3,
    "Total": 16,
    "TrackingCode": 87,
    "TransactionStatusInformation": 86,
    "TransientPrice_Id": 44,
    "Type": 4,
    "Value": 5,
    "ValueAlternative": 63,
    "VoidDateTime": 34,
    "VoidPartnerId": 56,
    "VoidReason": 51,
    "VoidUser": 33
}

schema_attributes:

{
    "ARGLCode": "string",
    "AccountType": "string",
    "AddedAutomatically": "string",
    "AllocationPerformedDate": "string",
    "AllocationType": "string",
    "AllowTotalPriceEntry": "string",
    "ApplicationCryptogram": "string",
    "AspNetUser_Id": "string",
    "AuthorizationCode": "string",
    "AuthorizationResponseCode": "string",
    "COGSGLCode": "string",
    "CardholderVerificationMethod": "string",
    "ChargeGroup": "string",
    "CreatedDate": "string",
    "CreationPartnerId": "string",
    "CreditInvoiceId": "string",
    "Currencies_Id": "string",
    "Date": "string",
    "DeletePartnerId": "string",
    "DeletionDateTime": "string",
    "DeletionReason": "string",
    "DeletionUserId": "string",
    "Discount": "string",
    "DiscountDateTime": "string",
    "DiscountGLCode": "string",
    "DiscountTotal": "string",
    "DiscountType": "string",
    "DiscountUserId": "string",
    "EndDateTime": "string",
    "EnteredAmount": "string",
    "ExchangeRate": "string",
    "Id": "string",
    "InventoryGLCode": "string",
    "InvoiceId": "string",
    "InvoiceItemType_Id": "string",
    "IsHidden": "string",
    "IsVoid": "string",
    "ItemMaster_Id": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "Misc": "string",
    "Misc2": "string",
    "Notes": "string",
    "NumberOfDecimals": "string",
    "OriginalCreditItem": "string",
    "OriginalPrice": "string",
    "OriginalReservationPrice": "string",
    "OverpaymentId": "string",
    "OverrideTrackingCategory1": "string",
    "OverrideTrackingCategory2": "string",
    "OverrideXeroSalesAccount": "string",
    "OverrideXeroTaxRate": "string",
    "PR_Type": "string",
    "PaymentAccount": "string",
    "PaymentGLCode": "string",
    "Prefix": "string",
    "PrepaymentGLCode": "string",
    "PrepaymentId": "string",
    "PriceStr": "string",
    "PriceSuffix": "string",
    "Quantity": "string",
    "QuickbooksPaymentId": "string",
    "Reservation_Id": "string",
    "RevenueGLCode": "string",
    "SVJobId": "string",
    "SV_ChargeInstance_Id": "string",
    "SV_LaborInstance_Id": "string",
    "SV_PartInstance_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonalPrice_Id": "string",
    "StartDateTime": "string",
    "Status": "string",
    "StripeAID": "string",
    "StripeApplicationName": "string",
    "StripeTerminalId": "string",
    "StripeTransactionData_Id": "string",
    "SubTotal": "string",
    "SubtotalWoDiscount": "string",
    "Tax": "string",
    "TaxExempt": "string",
    "TaxTotal": "string",
    "Taxable": "string",
    "TerminalVerificationResults": "string",
    "TextAux": "string",
    "TextAux2": "string",
    "Title": "string",
    "Total": "string",
    "TrackingCode": "string",
    "TransactionStatusInformation": "string",
    "TransientPrice_Id": "string",
    "Type": "string",
    "Value": "string",
    "ValueAlternative": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string"
}

schema_name_id: 1663
schema_scan_id: 161561506
updated: 2026-04-06 03:04:03

Version 1703324

created: 2026-04-05 03:06:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceitemset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceitemset`\n(\n `Id`  string , `Prefix`  string , `Quantity`  string , `Title`  string , `Type`  string , `Value`  string , `Discount`  string , `DiscountType`  string , `Taxable`  string , `Tax`  string , `Misc`  string , `DiscountTotal`  string , `PriceSuffix`  string , `SubTotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Total`  string , `InvoiceId`  string , `ChargeGroup`  string , `PaymentAccount`  string , `PriceStr`  string , `IsVoid`  string , `Date`  string , `TextAux`  string , `TextAux2`  string , `DiscountDateTime`  string , `DiscountUserId`  string , `Notes`  string , `PR_Type`  string , `Status`  string , `DeletionUserId`  string , `DeletionDateTime`  string , `OverpaymentId`  string , `VoidUser`  string , `VoidDateTime`  string , `Misc2`  string , `PrepaymentId`  string , `CreditInvoiceId`  string , `AllocationType`  string , `Reservation_Id`  string , `ItemMaster_Id`  string , `AspNetUser_Id`  string , `InvoiceItemType_Id`  string , `SeasonalPrice_Id`  string , `TransientPrice_Id`  string , `SVJobId`  string , `OriginalCreditItem`  string , `TaxExempt`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `DeletionReason`  string , `VoidReason`  string , `StartDateTime`  string , `EndDateTime`  string , `CreationPartnerId`  string , `DeletePartnerId`  string , `VoidPartnerId`  string , `OriginalPrice`  string , `OverrideXeroTaxRate`  string , `OverrideXeroSalesAccount`  string , `OriginalReservationPrice`  string , `NumberOfDecimals`  string , `StripeTransactionData_Id`  string , `ValueAlternative`  string , `StripeTerminalId`  string , `StripeApplicationName`  string , `StripeAID`  string , `EnteredAmount`  string , `ExchangeRate`  string , `Currencies_Id`  string , `SV_ChargeInstance_Id`  string , `SV_LaborInstance_Id`  string , `SV_PartInstance_Id`  string , `RevenueGLCode`  string , `ARGLCode`  string , `PaymentGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `SalesTaxGLCode`  string , `PrepaymentGLCode`  string , `AccountType`  string , `ApplicationCryptogram`  string , `AuthorizationCode`  string , `AuthorizationResponseCode`  string , `CardholderVerificationMethod`  string , `TerminalVerificationResults`  string , `TransactionStatusInformation`  string , `TrackingCode`  string , `DiscountGLCode`  string , `OverrideTrackingCategory1`  string , `OverrideTrackingCategory2`  string , `QuickbooksPaymentId`  string , `AllowTotalPriceEntry`  string , `AddedAutomatically`  string , `AllocationPerformedDate`  string , `CreatedDate`  string , `IsHidden`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-05/1775376065'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceitemset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-05/1775376065
id: 1703324
processed: 1

raw_data:

{
    "ARGLCode": 74,
    "AccountType": 80,
    "AddedAutomatically": 93,
    "AllocationPerformedDate": 94,
    "AllocationType": 38,
    "AllowTotalPriceEntry": 92,
    "ApplicationCryptogram": 81,
    "AspNetUser_Id": 41,
    "AuthorizationCode": 82,
    "AuthorizationResponseCode": 83,
    "COGSGLCode": 76,
    "CardholderVerificationMethod": 84,
    "ChargeGroup": 18,
    "CreatedDate": 95,
    "CreationPartnerId": 54,
    "CreditInvoiceId": 37,
    "Currencies_Id": 69,
    "Date": 22,
    "DeletePartnerId": 55,
    "DeletionDateTime": 31,
    "DeletionReason": 50,
    "DeletionUserId": 30,
    "Discount": 6,
    "DiscountDateTime": 25,
    "DiscountGLCode": 88,
    "DiscountTotal": 11,
    "DiscountType": 7,
    "DiscountUserId": 26,
    "EndDateTime": 53,
    "EnteredAmount": 67,
    "ExchangeRate": 68,
    "Id": 0,
    "InventoryGLCode": 77,
    "InvoiceId": 17,
    "InvoiceItemType_Id": 42,
    "IsHidden": 96,
    "IsVoid": 21,
    "ItemMaster_Id": 40,
    "LastModifiedAspNetUser": 49,
    "LastModifiedDateTime": 48,
    "Misc": 10,
    "Misc2": 35,
    "Notes": 27,
    "NumberOfDecimals": 61,
    "OriginalCreditItem": 46,
    "OriginalPrice": 57,
    "OriginalReservationPrice": 60,
    "OverpaymentId": 32,
    "OverrideTrackingCategory1": 89,
    "OverrideTrackingCategory2": 90,
    "OverrideXeroSalesAccount": 59,
    "OverrideXeroTaxRate": 58,
    "PR_Type": 28,
    "PaymentAccount": 19,
    "PaymentGLCode": 75,
    "Prefix": 1,
    "PrepaymentGLCode": 79,
    "PrepaymentId": 36,
    "PriceStr": 20,
    "PriceSuffix": 12,
    "Quantity": 2,
    "QuickbooksPaymentId": 91,
    "Reservation_Id": 39,
    "RevenueGLCode": 73,
    "SVJobId": 45,
    "SV_ChargeInstance_Id": 70,
    "SV_LaborInstance_Id": 71,
    "SV_PartInstance_Id": 72,
    "SalesTaxGLCode": 78,
    "SeasonalPrice_Id": 43,
    "StartDateTime": 52,
    "Status": 29,
    "StripeAID": 66,
    "StripeApplicationName": 65,
    "StripeTerminalId": 64,
    "StripeTransactionData_Id": 62,
    "SubTotal": 13,
    "SubtotalWoDiscount": 14,
    "Tax": 9,
    "TaxExempt": 47,
    "TaxTotal": 15,
    "Taxable": 8,
    "TerminalVerificationResults": 85,
    "TextAux": 23,
    "TextAux2": 24,
    "Title": 3,
    "Total": 16,
    "TrackingCode": 87,
    "TransactionStatusInformation": 86,
    "TransientPrice_Id": 44,
    "Type": 4,
    "Value": 5,
    "ValueAlternative": 63,
    "VoidDateTime": 34,
    "VoidPartnerId": 56,
    "VoidReason": 51,
    "VoidUser": 33
}

schema_attributes:

{
    "ARGLCode": "string",
    "AccountType": "string",
    "AddedAutomatically": "string",
    "AllocationPerformedDate": "string",
    "AllocationType": "string",
    "AllowTotalPriceEntry": "string",
    "ApplicationCryptogram": "string",
    "AspNetUser_Id": "string",
    "AuthorizationCode": "string",
    "AuthorizationResponseCode": "string",
    "COGSGLCode": "string",
    "CardholderVerificationMethod": "string",
    "ChargeGroup": "string",
    "CreatedDate": "string",
    "CreationPartnerId": "string",
    "CreditInvoiceId": "string",
    "Currencies_Id": "string",
    "Date": "string",
    "DeletePartnerId": "string",
    "DeletionDateTime": "string",
    "DeletionReason": "string",
    "DeletionUserId": "string",
    "Discount": "string",
    "DiscountDateTime": "string",
    "DiscountGLCode": "string",
    "DiscountTotal": "string",
    "DiscountType": "string",
    "DiscountUserId": "string",
    "EndDateTime": "string",
    "EnteredAmount": "string",
    "ExchangeRate": "string",
    "Id": "string",
    "InventoryGLCode": "string",
    "InvoiceId": "string",
    "InvoiceItemType_Id": "string",
    "IsHidden": "string",
    "IsVoid": "string",
    "ItemMaster_Id": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "Misc": "string",
    "Misc2": "string",
    "Notes": "string",
    "NumberOfDecimals": "string",
    "OriginalCreditItem": "string",
    "OriginalPrice": "string",
    "OriginalReservationPrice": "string",
    "OverpaymentId": "string",
    "OverrideTrackingCategory1": "string",
    "OverrideTrackingCategory2": "string",
    "OverrideXeroSalesAccount": "string",
    "OverrideXeroTaxRate": "string",
    "PR_Type": "string",
    "PaymentAccount": "string",
    "PaymentGLCode": "string",
    "Prefix": "string",
    "PrepaymentGLCode": "string",
    "PrepaymentId": "string",
    "PriceStr": "string",
    "PriceSuffix": "string",
    "Quantity": "string",
    "QuickbooksPaymentId": "string",
    "Reservation_Id": "string",
    "RevenueGLCode": "string",
    "SVJobId": "string",
    "SV_ChargeInstance_Id": "string",
    "SV_LaborInstance_Id": "string",
    "SV_PartInstance_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonalPrice_Id": "string",
    "StartDateTime": "string",
    "Status": "string",
    "StripeAID": "string",
    "StripeApplicationName": "string",
    "StripeTerminalId": "string",
    "StripeTransactionData_Id": "string",
    "SubTotal": "string",
    "SubtotalWoDiscount": "string",
    "Tax": "string",
    "TaxExempt": "string",
    "TaxTotal": "string",
    "Taxable": "string",
    "TerminalVerificationResults": "string",
    "TextAux": "string",
    "TextAux2": "string",
    "Title": "string",
    "Total": "string",
    "TrackingCode": "string",
    "TransactionStatusInformation": "string",
    "TransientPrice_Id": "string",
    "Type": "string",
    "Value": "string",
    "ValueAlternative": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string"
}

schema_name_id: 1663
schema_scan_id: 161514905
updated: 2026-04-05 03:06:27

Version 1702132

created: 2026-04-04 03:04:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceitemset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceitemset`\n(\n `Id`  string , `Prefix`  string , `Quantity`  string , `Title`  string , `Type`  string , `Value`  string , `Discount`  string , `DiscountType`  string , `Taxable`  string , `Tax`  string , `Misc`  string , `DiscountTotal`  string , `PriceSuffix`  string , `SubTotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Total`  string , `InvoiceId`  string , `ChargeGroup`  string , `PaymentAccount`  string , `PriceStr`  string , `IsVoid`  string , `Date`  string , `TextAux`  string , `TextAux2`  string , `DiscountDateTime`  string , `DiscountUserId`  string , `Notes`  string , `PR_Type`  string , `Status`  string , `DeletionUserId`  string , `DeletionDateTime`  string , `OverpaymentId`  string , `VoidUser`  string , `VoidDateTime`  string , `Misc2`  string , `PrepaymentId`  string , `CreditInvoiceId`  string , `AllocationType`  string , `Reservation_Id`  string , `ItemMaster_Id`  string , `AspNetUser_Id`  string , `InvoiceItemType_Id`  string , `SeasonalPrice_Id`  string , `TransientPrice_Id`  string , `SVJobId`  string , `OriginalCreditItem`  string , `TaxExempt`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `DeletionReason`  string , `VoidReason`  string , `StartDateTime`  string , `EndDateTime`  string , `CreationPartnerId`  string , `DeletePartnerId`  string , `VoidPartnerId`  string , `OriginalPrice`  string , `OverrideXeroTaxRate`  string , `OverrideXeroSalesAccount`  string , `OriginalReservationPrice`  string , `NumberOfDecimals`  string , `StripeTransactionData_Id`  string , `ValueAlternative`  string , `StripeTerminalId`  string , `StripeApplicationName`  string , `StripeAID`  string , `EnteredAmount`  string , `ExchangeRate`  string , `Currencies_Id`  string , `SV_ChargeInstance_Id`  string , `SV_LaborInstance_Id`  string , `SV_PartInstance_Id`  string , `RevenueGLCode`  string , `ARGLCode`  string , `PaymentGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `SalesTaxGLCode`  string , `PrepaymentGLCode`  string , `AccountType`  string , `ApplicationCryptogram`  string , `AuthorizationCode`  string , `AuthorizationResponseCode`  string , `CardholderVerificationMethod`  string , `TerminalVerificationResults`  string , `TransactionStatusInformation`  string , `TrackingCode`  string , `DiscountGLCode`  string , `OverrideTrackingCategory1`  string , `OverrideTrackingCategory2`  string , `QuickbooksPaymentId`  string , `AllowTotalPriceEntry`  string , `AddedAutomatically`  string , `AllocationPerformedDate`  string , `CreatedDate`  string , `IsHidden`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-04/1775289548'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceitemset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-04/1775289548
id: 1702132
processed: 1

raw_data:

{
    "ARGLCode": 74,
    "AccountType": 80,
    "AddedAutomatically": 93,
    "AllocationPerformedDate": 94,
    "AllocationType": 38,
    "AllowTotalPriceEntry": 92,
    "ApplicationCryptogram": 81,
    "AspNetUser_Id": 41,
    "AuthorizationCode": 82,
    "AuthorizationResponseCode": 83,
    "COGSGLCode": 76,
    "CardholderVerificationMethod": 84,
    "ChargeGroup": 18,
    "CreatedDate": 95,
    "CreationPartnerId": 54,
    "CreditInvoiceId": 37,
    "Currencies_Id": 69,
    "Date": 22,
    "DeletePartnerId": 55,
    "DeletionDateTime": 31,
    "DeletionReason": 50,
    "DeletionUserId": 30,
    "Discount": 6,
    "DiscountDateTime": 25,
    "DiscountGLCode": 88,
    "DiscountTotal": 11,
    "DiscountType": 7,
    "DiscountUserId": 26,
    "EndDateTime": 53,
    "EnteredAmount": 67,
    "ExchangeRate": 68,
    "Id": 0,
    "InventoryGLCode": 77,
    "InvoiceId": 17,
    "InvoiceItemType_Id": 42,
    "IsHidden": 96,
    "IsVoid": 21,
    "ItemMaster_Id": 40,
    "LastModifiedAspNetUser": 49,
    "LastModifiedDateTime": 48,
    "Misc": 10,
    "Misc2": 35,
    "Notes": 27,
    "NumberOfDecimals": 61,
    "OriginalCreditItem": 46,
    "OriginalPrice": 57,
    "OriginalReservationPrice": 60,
    "OverpaymentId": 32,
    "OverrideTrackingCategory1": 89,
    "OverrideTrackingCategory2": 90,
    "OverrideXeroSalesAccount": 59,
    "OverrideXeroTaxRate": 58,
    "PR_Type": 28,
    "PaymentAccount": 19,
    "PaymentGLCode": 75,
    "Prefix": 1,
    "PrepaymentGLCode": 79,
    "PrepaymentId": 36,
    "PriceStr": 20,
    "PriceSuffix": 12,
    "Quantity": 2,
    "QuickbooksPaymentId": 91,
    "Reservation_Id": 39,
    "RevenueGLCode": 73,
    "SVJobId": 45,
    "SV_ChargeInstance_Id": 70,
    "SV_LaborInstance_Id": 71,
    "SV_PartInstance_Id": 72,
    "SalesTaxGLCode": 78,
    "SeasonalPrice_Id": 43,
    "StartDateTime": 52,
    "Status": 29,
    "StripeAID": 66,
    "StripeApplicationName": 65,
    "StripeTerminalId": 64,
    "StripeTransactionData_Id": 62,
    "SubTotal": 13,
    "SubtotalWoDiscount": 14,
    "Tax": 9,
    "TaxExempt": 47,
    "TaxTotal": 15,
    "Taxable": 8,
    "TerminalVerificationResults": 85,
    "TextAux": 23,
    "TextAux2": 24,
    "Title": 3,
    "Total": 16,
    "TrackingCode": 87,
    "TransactionStatusInformation": 86,
    "TransientPrice_Id": 44,
    "Type": 4,
    "Value": 5,
    "ValueAlternative": 63,
    "VoidDateTime": 34,
    "VoidPartnerId": 56,
    "VoidReason": 51,
    "VoidUser": 33
}

schema_attributes:

{
    "ARGLCode": "string",
    "AccountType": "string",
    "AddedAutomatically": "string",
    "AllocationPerformedDate": "string",
    "AllocationType": "string",
    "AllowTotalPriceEntry": "string",
    "ApplicationCryptogram": "string",
    "AspNetUser_Id": "string",
    "AuthorizationCode": "string",
    "AuthorizationResponseCode": "string",
    "COGSGLCode": "string",
    "CardholderVerificationMethod": "string",
    "ChargeGroup": "string",
    "CreatedDate": "string",
    "CreationPartnerId": "string",
    "CreditInvoiceId": "string",
    "Currencies_Id": "string",
    "Date": "string",
    "DeletePartnerId": "string",
    "DeletionDateTime": "string",
    "DeletionReason": "string",
    "DeletionUserId": "string",
    "Discount": "string",
    "DiscountDateTime": "string",
    "DiscountGLCode": "string",
    "DiscountTotal": "string",
    "DiscountType": "string",
    "DiscountUserId": "string",
    "EndDateTime": "string",
    "EnteredAmount": "string",
    "ExchangeRate": "string",
    "Id": "string",
    "InventoryGLCode": "string",
    "InvoiceId": "string",
    "InvoiceItemType_Id": "string",
    "IsHidden": "string",
    "IsVoid": "string",
    "ItemMaster_Id": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "Misc": "string",
    "Misc2": "string",
    "Notes": "string",
    "NumberOfDecimals": "string",
    "OriginalCreditItem": "string",
    "OriginalPrice": "string",
    "OriginalReservationPrice": "string",
    "OverpaymentId": "string",
    "OverrideTrackingCategory1": "string",
    "OverrideTrackingCategory2": "string",
    "OverrideXeroSalesAccount": "string",
    "OverrideXeroTaxRate": "string",
    "PR_Type": "string",
    "PaymentAccount": "string",
    "PaymentGLCode": "string",
    "Prefix": "string",
    "PrepaymentGLCode": "string",
    "PrepaymentId": "string",
    "PriceStr": "string",
    "PriceSuffix": "string",
    "Quantity": "string",
    "QuickbooksPaymentId": "string",
    "Reservation_Id": "string",
    "RevenueGLCode": "string",
    "SVJobId": "string",
    "SV_ChargeInstance_Id": "string",
    "SV_LaborInstance_Id": "string",
    "SV_PartInstance_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonalPrice_Id": "string",
    "StartDateTime": "string",
    "Status": "string",
    "StripeAID": "string",
    "StripeApplicationName": "string",
    "StripeTerminalId": "string",
    "StripeTransactionData_Id": "string",
    "SubTotal": "string",
    "SubtotalWoDiscount": "string",
    "Tax": "string",
    "TaxExempt": "string",
    "TaxTotal": "string",
    "Taxable": "string",
    "TerminalVerificationResults": "string",
    "TextAux": "string",
    "TextAux2": "string",
    "Title": "string",
    "Total": "string",
    "TrackingCode": "string",
    "TransactionStatusInformation": "string",
    "TransientPrice_Id": "string",
    "Type": "string",
    "Value": "string",
    "ValueAlternative": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string"
}

schema_name_id: 1663
schema_scan_id: 161460306
updated: 2026-04-04 03:04:21

Version 1700946

created: 2026-04-03 03:09:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceitemset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceitemset`\n(\n `Id`  string , `Prefix`  string , `Quantity`  string , `Title`  string , `Type`  string , `Value`  string , `Discount`  string , `DiscountType`  string , `Taxable`  string , `Tax`  string , `Misc`  string , `DiscountTotal`  string , `PriceSuffix`  string , `SubTotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Total`  string , `InvoiceId`  string , `ChargeGroup`  string , `PaymentAccount`  string , `PriceStr`  string , `IsVoid`  string , `Date`  string , `TextAux`  string , `TextAux2`  string , `DiscountDateTime`  string , `DiscountUserId`  string , `Notes`  string , `PR_Type`  string , `Status`  string , `DeletionUserId`  string , `DeletionDateTime`  string , `OverpaymentId`  string , `VoidUser`  string , `VoidDateTime`  string , `Misc2`  string , `PrepaymentId`  string , `CreditInvoiceId`  string , `AllocationType`  string , `Reservation_Id`  string , `ItemMaster_Id`  string , `AspNetUser_Id`  string , `InvoiceItemType_Id`  string , `SeasonalPrice_Id`  string , `TransientPrice_Id`  string , `SVJobId`  string , `OriginalCreditItem`  string , `TaxExempt`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `DeletionReason`  string , `VoidReason`  string , `StartDateTime`  string , `EndDateTime`  string , `CreationPartnerId`  string , `DeletePartnerId`  string , `VoidPartnerId`  string , `OriginalPrice`  string , `OverrideXeroTaxRate`  string , `OverrideXeroSalesAccount`  string , `OriginalReservationPrice`  string , `NumberOfDecimals`  string , `StripeTransactionData_Id`  string , `ValueAlternative`  string , `StripeTerminalId`  string , `StripeApplicationName`  string , `StripeAID`  string , `EnteredAmount`  string , `ExchangeRate`  string , `Currencies_Id`  string , `SV_ChargeInstance_Id`  string , `SV_LaborInstance_Id`  string , `SV_PartInstance_Id`  string , `RevenueGLCode`  string , `ARGLCode`  string , `PaymentGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `SalesTaxGLCode`  string , `PrepaymentGLCode`  string , `AccountType`  string , `ApplicationCryptogram`  string , `AuthorizationCode`  string , `AuthorizationResponseCode`  string , `CardholderVerificationMethod`  string , `TerminalVerificationResults`  string , `TransactionStatusInformation`  string , `TrackingCode`  string , `DiscountGLCode`  string , `OverrideTrackingCategory1`  string , `OverrideTrackingCategory2`  string , `QuickbooksPaymentId`  string , `AllowTotalPriceEntry`  string , `AddedAutomatically`  string , `AllocationPerformedDate`  string , `CreatedDate`  string , `IsHidden`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-03/1775203322'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceitemset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-03/1775203322
id: 1700946
processed: 1

raw_data:

{
    "ARGLCode": 74,
    "AccountType": 80,
    "AddedAutomatically": 93,
    "AllocationPerformedDate": 94,
    "AllocationType": 38,
    "AllowTotalPriceEntry": 92,
    "ApplicationCryptogram": 81,
    "AspNetUser_Id": 41,
    "AuthorizationCode": 82,
    "AuthorizationResponseCode": 83,
    "COGSGLCode": 76,
    "CardholderVerificationMethod": 84,
    "ChargeGroup": 18,
    "CreatedDate": 95,
    "CreationPartnerId": 54,
    "CreditInvoiceId": 37,
    "Currencies_Id": 69,
    "Date": 22,
    "DeletePartnerId": 55,
    "DeletionDateTime": 31,
    "DeletionReason": 50,
    "DeletionUserId": 30,
    "Discount": 6,
    "DiscountDateTime": 25,
    "DiscountGLCode": 88,
    "DiscountTotal": 11,
    "DiscountType": 7,
    "DiscountUserId": 26,
    "EndDateTime": 53,
    "EnteredAmount": 67,
    "ExchangeRate": 68,
    "Id": 0,
    "InventoryGLCode": 77,
    "InvoiceId": 17,
    "InvoiceItemType_Id": 42,
    "IsHidden": 96,
    "IsVoid": 21,
    "ItemMaster_Id": 40,
    "LastModifiedAspNetUser": 49,
    "LastModifiedDateTime": 48,
    "Misc": 10,
    "Misc2": 35,
    "Notes": 27,
    "NumberOfDecimals": 61,
    "OriginalCreditItem": 46,
    "OriginalPrice": 57,
    "OriginalReservationPrice": 60,
    "OverpaymentId": 32,
    "OverrideTrackingCategory1": 89,
    "OverrideTrackingCategory2": 90,
    "OverrideXeroSalesAccount": 59,
    "OverrideXeroTaxRate": 58,
    "PR_Type": 28,
    "PaymentAccount": 19,
    "PaymentGLCode": 75,
    "Prefix": 1,
    "PrepaymentGLCode": 79,
    "PrepaymentId": 36,
    "PriceStr": 20,
    "PriceSuffix": 12,
    "Quantity": 2,
    "QuickbooksPaymentId": 91,
    "Reservation_Id": 39,
    "RevenueGLCode": 73,
    "SVJobId": 45,
    "SV_ChargeInstance_Id": 70,
    "SV_LaborInstance_Id": 71,
    "SV_PartInstance_Id": 72,
    "SalesTaxGLCode": 78,
    "SeasonalPrice_Id": 43,
    "StartDateTime": 52,
    "Status": 29,
    "StripeAID": 66,
    "StripeApplicationName": 65,
    "StripeTerminalId": 64,
    "StripeTransactionData_Id": 62,
    "SubTotal": 13,
    "SubtotalWoDiscount": 14,
    "Tax": 9,
    "TaxExempt": 47,
    "TaxTotal": 15,
    "Taxable": 8,
    "TerminalVerificationResults": 85,
    "TextAux": 23,
    "TextAux2": 24,
    "Title": 3,
    "Total": 16,
    "TrackingCode": 87,
    "TransactionStatusInformation": 86,
    "TransientPrice_Id": 44,
    "Type": 4,
    "Value": 5,
    "ValueAlternative": 63,
    "VoidDateTime": 34,
    "VoidPartnerId": 56,
    "VoidReason": 51,
    "VoidUser": 33
}

schema_attributes:

{
    "ARGLCode": "string",
    "AccountType": "string",
    "AddedAutomatically": "string",
    "AllocationPerformedDate": "string",
    "AllocationType": "string",
    "AllowTotalPriceEntry": "string",
    "ApplicationCryptogram": "string",
    "AspNetUser_Id": "string",
    "AuthorizationCode": "string",
    "AuthorizationResponseCode": "string",
    "COGSGLCode": "string",
    "CardholderVerificationMethod": "string",
    "ChargeGroup": "string",
    "CreatedDate": "string",
    "CreationPartnerId": "string",
    "CreditInvoiceId": "string",
    "Currencies_Id": "string",
    "Date": "string",
    "DeletePartnerId": "string",
    "DeletionDateTime": "string",
    "DeletionReason": "string",
    "DeletionUserId": "string",
    "Discount": "string",
    "DiscountDateTime": "string",
    "DiscountGLCode": "string",
    "DiscountTotal": "string",
    "DiscountType": "string",
    "DiscountUserId": "string",
    "EndDateTime": "string",
    "EnteredAmount": "string",
    "ExchangeRate": "string",
    "Id": "string",
    "InventoryGLCode": "string",
    "InvoiceId": "string",
    "InvoiceItemType_Id": "string",
    "IsHidden": "string",
    "IsVoid": "string",
    "ItemMaster_Id": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "Misc": "string",
    "Misc2": "string",
    "Notes": "string",
    "NumberOfDecimals": "string",
    "OriginalCreditItem": "string",
    "OriginalPrice": "string",
    "OriginalReservationPrice": "string",
    "OverpaymentId": "string",
    "OverrideTrackingCategory1": "string",
    "OverrideTrackingCategory2": "string",
    "OverrideXeroSalesAccount": "string",
    "OverrideXeroTaxRate": "string",
    "PR_Type": "string",
    "PaymentAccount": "string",
    "PaymentGLCode": "string",
    "Prefix": "string",
    "PrepaymentGLCode": "string",
    "PrepaymentId": "string",
    "PriceStr": "string",
    "PriceSuffix": "string",
    "Quantity": "string",
    "QuickbooksPaymentId": "string",
    "Reservation_Id": "string",
    "RevenueGLCode": "string",
    "SVJobId": "string",
    "SV_ChargeInstance_Id": "string",
    "SV_LaborInstance_Id": "string",
    "SV_PartInstance_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonalPrice_Id": "string",
    "StartDateTime": "string",
    "Status": "string",
    "StripeAID": "string",
    "StripeApplicationName": "string",
    "StripeTerminalId": "string",
    "StripeTransactionData_Id": "string",
    "SubTotal": "string",
    "SubtotalWoDiscount": "string",
    "Tax": "string",
    "TaxExempt": "string",
    "TaxTotal": "string",
    "Taxable": "string",
    "TerminalVerificationResults": "string",
    "TextAux": "string",
    "TextAux2": "string",
    "Title": "string",
    "Total": "string",
    "TrackingCode": "string",
    "TransactionStatusInformation": "string",
    "TransientPrice_Id": "string",
    "Type": "string",
    "Value": "string",
    "ValueAlternative": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string"
}

schema_name_id: 1663
schema_scan_id: 161401902
updated: 2026-04-03 03:10:10

Schema Scans: 15

Last at 2026-04-17 03:07:14

Scan 162167684

duration: 0:00:16.744192

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162167684

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-17/1776412777",
        "key": "raw/molo_moloInvoiceItemSet/2026-04-17/1776412777/InvoiceItemSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15840536232683035741,
        "service_name": "drive-thru",
        "span_id": 5084761122948362728,
        "trace_id": 17364688644687726297
    }
}

running: False
schema_name_id: 1663
start_time: 2026-04-17 03:07:14
success: True
trace_id: 17364688644687726297

Scan 162111860

duration: 0:00:17.058058

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162111860

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-16/1776326533",
        "key": "raw/molo_moloInvoiceItemSet/2026-04-16/1776326533/InvoiceItemSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5262253439939242362,
        "service_name": "drive-thru",
        "span_id": 12509188088554790860,
        "trace_id": 15455482715050609562
    }
}

running: False
schema_name_id: 1663
start_time: 2026-04-16 03:08:45
success: True
trace_id: 15455482715050609562

Scan 162055979

duration: 0:00:14.573532

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162055979

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-15/1776240003",
        "key": "raw/molo_moloInvoiceItemSet/2026-04-15/1776240003/InvoiceItemSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12129581407643133509,
        "service_name": "drive-thru",
        "span_id": 6657376845218306606,
        "trace_id": 9796867835289366303
    }
}

running: False
schema_name_id: 1663
start_time: 2026-04-15 03:06:29
success: True
trace_id: 9796867835289366303

Scan 162000488

duration: 0:00:16.933644

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162000488

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-14/1776153729",
        "key": "raw/molo_moloInvoiceItemSet/2026-04-14/1776153729/InvoiceItemSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 174239392860177713,
        "service_name": "drive-thru",
        "span_id": 11320021436293729965,
        "trace_id": 16581969893925925549
    }
}

running: False
schema_name_id: 1663
start_time: 2026-04-14 03:05:53
success: True
trace_id: 16581969893925925549

Scan 161941710

duration: 0:00:24.741405

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161941710

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-13/1776066923",
        "key": "raw/molo_moloInvoiceItemSet/2026-04-13/1776066923/InvoiceItemSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9133449219601299537,
        "service_name": "drive-thru",
        "span_id": 14065829932199666236,
        "trace_id": 4471817027179781733
    }
}

running: False
schema_name_id: 1663
start_time: 2026-04-13 02:58:47
success: True
trace_id: 4471817027179781733

Scan 161892612

duration: 0:00:16.736967

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161892612

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-12/1775980637",
        "key": "raw/molo_moloInvoiceItemSet/2026-04-12/1775980637/InvoiceItemSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17976539582311858658,
        "service_name": "drive-thru",
        "span_id": 2266512892805544505,
        "trace_id": 3200166518729992
    }
}

running: False
schema_name_id: 1663
start_time: 2026-04-12 03:00:30
success: True
trace_id: 3200166518729992

Scan 161841199

duration: 0:00:14.410039

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161841199

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-11/1775894398",
        "key": "raw/molo_moloInvoiceItemSet/2026-04-11/1775894398/InvoiceItemSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16578677660171416407,
        "service_name": "drive-thru",
        "span_id": 13077841839204921036,
        "trace_id": 14624762016595149224
    }
}

running: False
schema_name_id: 1663
start_time: 2026-04-11 03:05:16
success: True
trace_id: 14624762016595149224

Scan 161785888

duration: 0:00:16.762734

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161785888

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-10/1775808155",
        "key": "raw/molo_moloInvoiceItemSet/2026-04-10/1775808155/InvoiceItemSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13953836620890946251,
        "service_name": "drive-thru",
        "span_id": 6425050107703390706,
        "trace_id": 5062935981154878237
    }
}

running: False
schema_name_id: 1663
start_time: 2026-04-10 03:04:39
success: True
trace_id: 5062935981154878237

Scan 161730134

duration: 0:00:16.761063

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161730134

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-09/1775721492",
        "key": "raw/molo_moloInvoiceItemSet/2026-04-09/1775721492/InvoiceItemSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1533461629422520800,
        "service_name": "drive-thru",
        "span_id": 2853028819614726433,
        "trace_id": 537539969133022242
    }
}

running: False
schema_name_id: 1663
start_time: 2026-04-09 03:02:04
success: True
trace_id: 537539969133022242

Scan 161675422

duration: 0:00:17.039089

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161675422

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-08/1775635312",
        "key": "raw/molo_moloInvoiceItemSet/2026-04-08/1775635312/InvoiceItemSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4856528785128309482,
        "service_name": "drive-thru",
        "span_id": 6325711363652761744,
        "trace_id": 2837189299908962321
    }
}

running: False
schema_name_id: 1663
start_time: 2026-04-08 03:03:12
success: True
trace_id: 2837189299908962321

Scan 161618479

duration: 0:00:16.807809

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161618479

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-07/1775548473",
        "key": "raw/molo_moloInvoiceItemSet/2026-04-07/1775548473/InvoiceItemSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4049517315001195153,
        "service_name": "drive-thru",
        "span_id": 838349640389872618,
        "trace_id": 17833455570581111940
    }
}

running: False
schema_name_id: 1663
start_time: 2026-04-07 02:58:28
success: True
trace_id: 17833455570581111940

Scan 161561506

duration: 0:00:14.190093

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161561506

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-06/1775462440",
        "key": "raw/molo_moloInvoiceItemSet/2026-04-06/1775462440/InvoiceItemSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2202635021192477273,
        "service_name": "drive-thru",
        "span_id": 6535344869319136111,
        "trace_id": 14950056069376851316
    }
}

running: False
schema_name_id: 1663
start_time: 2026-04-06 03:03:49
success: True
trace_id: 14950056069376851316

Scan 161514905

duration: 0:00:16.810081

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161514905

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-05/1775376065",
        "key": "raw/molo_moloInvoiceItemSet/2026-04-05/1775376065/InvoiceItemSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17758682166314806265,
        "service_name": "drive-thru",
        "span_id": 9950177088808060043,
        "trace_id": 3971580034834680139
    }
}

running: False
schema_name_id: 1663
start_time: 2026-04-05 03:06:11
success: True
trace_id: 3971580034834680139

Scan 161460306

duration: 0:00:16.665508

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161460306

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-04/1775289548",
        "key": "raw/molo_moloInvoiceItemSet/2026-04-04/1775289548/InvoiceItemSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7292171866135332579,
        "service_name": "drive-thru",
        "span_id": 5521033366302178589,
        "trace_id": 11644898066496323586
    }
}

running: False
schema_name_id: 1663
start_time: 2026-04-04 03:04:04
success: True
trace_id: 11644898066496323586

Scan 161401902

duration: 0:00:14.297309

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161401902

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-03/1775203322",
        "key": "raw/molo_moloInvoiceItemSet/2026-04-03/1775203322/InvoiceItemSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloInvoiceItemSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1689864610687969802,
        "service_name": "drive-thru",
        "span_id": 12786692154443885020,
        "trace_id": 10063073146714455595
    }
}

running: False
schema_name_id: 1663
start_time: 2026-04-03 03:09:56
success: True
trace_id: 10063073146714455595

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "ARGLCode": "string",
    "AccountType": "string",
    "AddedAutomatically": "string",
    "AllocationPerformedDate": "string",
    "AllocationType": "string",
    "AllowTotalPriceEntry": "string",
    "ApplicationCryptogram": "string",
    "AspNetUser_Id": "string",
    "AuthorizationCode": "string",
    "AuthorizationResponseCode": "string",
    "COGSGLCode": "string",
    "CardholderVerificationMethod": "string",
    "ChargeGroup": "string",
    "CreatedDate": "string",
    "CreationPartnerId": "string",
    "CreditInvoiceId": "string",
    "Currencies_Id": "string",
    "Date": "string",
    "DeletePartnerId": "string",
    "DeletionDateTime": "string",
    "DeletionReason": "string",
    "DeletionUserId": "string",
    "Discount": "string",
    "DiscountDateTime": "string",
    "DiscountGLCode": "string",
    "DiscountTotal": "string",
    "DiscountType": "string",
    "DiscountUserId": "string",
    "EndDateTime": "string",
    "EnteredAmount": "string",
    "ExchangeRate": "string",
    "Id": "string",
    "InventoryGLCode": "string",
    "InvoiceId": "string",
    "InvoiceItemType_Id": "string",
    "IsHidden": "string",
    "IsVoid": "string",
    "ItemMaster_Id": "string",
    "LastModifiedAspNetUser": "string",
    "LastModifiedDateTime": "string",
    "Misc": "string",
    "Misc2": "string",
    "Notes": "string",
    "NumberOfDecimals": "string",
    "OriginalCreditItem": "string",
    "OriginalPrice": "string",
    "OriginalReservationPrice": "string",
    "OverpaymentId": "string",
    "OverrideTrackingCategory1": "string",
    "OverrideTrackingCategory2": "string",
    "OverrideXeroSalesAccount": "string",
    "OverrideXeroTaxRate": "string",
    "PR_Type": "string",
    "PaymentAccount": "string",
    "PaymentGLCode": "string",
    "Prefix": "string",
    "PrepaymentGLCode": "string",
    "PrepaymentId": "string",
    "PriceStr": "string",
    "PriceSuffix": "string",
    "Quantity": "string",
    "QuickbooksPaymentId": "string",
    "Reservation_Id": "string",
    "RevenueGLCode": "string",
    "SVJobId": "string",
    "SV_ChargeInstance_Id": "string",
    "SV_LaborInstance_Id": "string",
    "SV_PartInstance_Id": "string",
    "SalesTaxGLCode": "string",
    "SeasonalPrice_Id": "string",
    "StartDateTime": "string",
    "Status": "string",
    "StripeAID": "string",
    "StripeApplicationName": "string",
    "StripeTerminalId": "string",
    "StripeTransactionData_Id": "string",
    "SubTotal": "string",
    "SubtotalWoDiscount": "string",
    "Tax": "string",
    "TaxExempt": "string",
    "TaxTotal": "string",
    "Taxable": "string",
    "TerminalVerificationResults": "string",
    "TextAux": "string",
    "TextAux2": "string",
    "Title": "string",
    "Total": "string",
    "TrackingCode": "string",
    "TransactionStatusInformation": "string",
    "TransientPrice_Id": "string",
    "Type": "string",
    "Value": "string",
    "ValueAlternative": "string",
    "VoidDateTime": "string",
    "VoidPartnerId": "string",
    "VoidReason": "string",
    "VoidUser": "string"
}

created: 2026-04-17 03:07:17

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceitemset`\n(\n `Id`  string , `Prefix`  string , `Quantity`  string , `Title`  string , `Type`  string , `Value`  string , `Discount`  string , `DiscountType`  string , `Taxable`  string , `Tax`  string , `Misc`  string , `DiscountTotal`  string , `PriceSuffix`  string , `SubTotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Total`  string , `InvoiceId`  string , `ChargeGroup`  string , `PaymentAccount`  string , `PriceStr`  string , `IsVoid`  string , `Date`  string , `TextAux`  string , `TextAux2`  string , `DiscountDateTime`  string , `DiscountUserId`  string , `Notes`  string , `PR_Type`  string , `Status`  string , `DeletionUserId`  string , `DeletionDateTime`  string , `OverpaymentId`  string , `VoidUser`  string , `VoidDateTime`  string , `Misc2`  string , `PrepaymentId`  string , `CreditInvoiceId`  string , `AllocationType`  string , `Reservation_Id`  string , `ItemMaster_Id`  string , `AspNetUser_Id`  string , `InvoiceItemType_Id`  string , `SeasonalPrice_Id`  string , `TransientPrice_Id`  string , `SVJobId`  string , `OriginalCreditItem`  string , `TaxExempt`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `DeletionReason`  string , `VoidReason`  string , `StartDateTime`  string , `EndDateTime`  string , `CreationPartnerId`  string , `DeletePartnerId`  string , `VoidPartnerId`  string , `OriginalPrice`  string , `OverrideXeroTaxRate`  string , `OverrideXeroSalesAccount`  string , `OriginalReservationPrice`  string , `NumberOfDecimals`  string , `StripeTransactionData_Id`  string , `ValueAlternative`  string , `StripeTerminalId`  string , `StripeApplicationName`  string , `StripeAID`  string , `EnteredAmount`  string , `ExchangeRate`  string , `Currencies_Id`  string , `SV_ChargeInstance_Id`  string , `SV_LaborInstance_Id`  string , `SV_PartInstance_Id`  string , `RevenueGLCode`  string , `ARGLCode`  string , `PaymentGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `SalesTaxGLCode`  string , `PrepaymentGLCode`  string , `AccountType`  string , `ApplicationCryptogram`  string , `AuthorizationCode`  string , `AuthorizationResponseCode`  string , `CardholderVerificationMethod`  string , `TerminalVerificationResults`  string , `TransactionStatusInformation`  string , `TrackingCode`  string , `DiscountGLCode`  string , `OverrideTrackingCategory1`  string , `OverrideTrackingCategory2`  string , `QuickbooksPaymentId`  string , `AllowTotalPriceEntry`  string , `AddedAutomatically`  string , `AllocationPerformedDate`  string , `CreatedDate`  string , `IsHidden`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-17/1776412777'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceitemset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceitemset"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2023-10-17 01:57:34",
        "disabled": false,
        "format": "raw",
        "id": 1663,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloinvoiceitemset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "ARGLCode": "string",
            "AccountType": "string",
            "AddedAutomatically": "string",
            "AllocationPerformedDate": "string",
            "AllocationType": "string",
            "AllowTotalPriceEntry": "string",
            "ApplicationCryptogram": "string",
            "AspNetUser_Id": "string",
            "AuthorizationCode": "string",
            "AuthorizationResponseCode": "string",
            "COGSGLCode": "string",
            "CardholderVerificationMethod": "string",
            "ChargeGroup": "string",
            "CreatedDate": "string",
            "CreationPartnerId": "string",
            "CreditInvoiceId": "string",
            "Currencies_Id": "string",
            "Date": "string",
            "DeletePartnerId": "string",
            "DeletionDateTime": "string",
            "DeletionReason": "string",
            "DeletionUserId": "string",
            "Discount": "string",
            "DiscountDateTime": "string",
            "DiscountGLCode": "string",
            "DiscountTotal": "string",
            "DiscountType": "string",
            "DiscountUserId": "string",
            "EndDateTime": "string",
            "EnteredAmount": "string",
            "ExchangeRate": "string",
            "Id": "string",
            "InventoryGLCode": "string",
            "InvoiceId": "string",
            "InvoiceItemType_Id": "string",
            "IsHidden": "string",
            "IsVoid": "string",
            "ItemMaster_Id": "string",
            "LastModifiedAspNetUser": "string",
            "LastModifiedDateTime": "string",
            "Misc": "string",
            "Misc2": "string",
            "Notes": "string",
            "NumberOfDecimals": "string",
            "OriginalCreditItem": "string",
            "OriginalPrice": "string",
            "OriginalReservationPrice": "string",
            "OverpaymentId": "string",
            "OverrideTrackingCategory1": "string",
            "OverrideTrackingCategory2": "string",
            "OverrideXeroSalesAccount": "string",
            "OverrideXeroTaxRate": "string",
            "PR_Type": "string",
            "PaymentAccount": "string",
            "PaymentGLCode": "string",
            "Prefix": "string",
            "PrepaymentGLCode": "string",
            "PrepaymentId": "string",
            "PriceStr": "string",
            "PriceSuffix": "string",
            "Quantity": "string",
            "QuickbooksPaymentId": "string",
            "Reservation_Id": "string",
            "RevenueGLCode": "string",
            "SVJobId": "string",
            "SV_ChargeInstance_Id": "string",
            "SV_LaborInstance_Id": "string",
            "SV_PartInstance_Id": "string",
            "SalesTaxGLCode": "string",
            "SeasonalPrice_Id": "string",
            "StartDateTime": "string",
            "Status": "string",
            "StripeAID": "string",
            "StripeApplicationName": "string",
            "StripeTerminalId": "string",
            "StripeTransactionData_Id": "string",
            "SubTotal": "string",
            "SubtotalWoDiscount": "string",
            "Tax": "string",
            "TaxExempt": "string",
            "TaxTotal": "string",
            "Taxable": "string",
            "TerminalVerificationResults": "string",
            "TextAux": "string",
            "TextAux2": "string",
            "Title": "string",
            "Total": "string",
            "TrackingCode": "string",
            "TransactionStatusInformation": "string",
            "TransientPrice_Id": "string",
            "Type": "string",
            "Value": "string",
            "ValueAlternative": "string",
            "VoidDateTime": "string",
            "VoidPartnerId": "string",
            "VoidReason": "string",
            "VoidUser": "string"
        },
        "created": "2026-04-17 03:07:17",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloinvoiceitemset`\n(\n `Id`  string , `Prefix`  string , `Quantity`  string , `Title`  string , `Type`  string , `Value`  string , `Discount`  string , `DiscountType`  string , `Taxable`  string , `Tax`  string , `Misc`  string , `DiscountTotal`  string , `PriceSuffix`  string , `SubTotal`  string , `SubtotalWoDiscount`  string , `TaxTotal`  string , `Total`  string , `InvoiceId`  string , `ChargeGroup`  string , `PaymentAccount`  string , `PriceStr`  string , `IsVoid`  string , `Date`  string , `TextAux`  string , `TextAux2`  string , `DiscountDateTime`  string , `DiscountUserId`  string , `Notes`  string , `PR_Type`  string , `Status`  string , `DeletionUserId`  string , `DeletionDateTime`  string , `OverpaymentId`  string , `VoidUser`  string , `VoidDateTime`  string , `Misc2`  string , `PrepaymentId`  string , `CreditInvoiceId`  string , `AllocationType`  string , `Reservation_Id`  string , `ItemMaster_Id`  string , `AspNetUser_Id`  string , `InvoiceItemType_Id`  string , `SeasonalPrice_Id`  string , `TransientPrice_Id`  string , `SVJobId`  string , `OriginalCreditItem`  string , `TaxExempt`  string , `LastModifiedDateTime`  string , `LastModifiedAspNetUser`  string , `DeletionReason`  string , `VoidReason`  string , `StartDateTime`  string , `EndDateTime`  string , `CreationPartnerId`  string , `DeletePartnerId`  string , `VoidPartnerId`  string , `OriginalPrice`  string , `OverrideXeroTaxRate`  string , `OverrideXeroSalesAccount`  string , `OriginalReservationPrice`  string , `NumberOfDecimals`  string , `StripeTransactionData_Id`  string , `ValueAlternative`  string , `StripeTerminalId`  string , `StripeApplicationName`  string , `StripeAID`  string , `EnteredAmount`  string , `ExchangeRate`  string , `Currencies_Id`  string , `SV_ChargeInstance_Id`  string , `SV_LaborInstance_Id`  string , `SV_PartInstance_Id`  string , `RevenueGLCode`  string , `ARGLCode`  string , `PaymentGLCode`  string , `COGSGLCode`  string , `InventoryGLCode`  string , `SalesTaxGLCode`  string , `PrepaymentGLCode`  string , `AccountType`  string , `ApplicationCryptogram`  string , `AuthorizationCode`  string , `AuthorizationResponseCode`  string , `CardholderVerificationMethod`  string , `TerminalVerificationResults`  string , `TransactionStatusInformation`  string , `TrackingCode`  string , `DiscountGLCode`  string , `OverrideTrackingCategory1`  string , `OverrideTrackingCategory2`  string , `QuickbooksPaymentId`  string , `AllowTotalPriceEntry`  string , `AddedAutomatically`  string , `AllocationPerformedDate`  string , `CreatedDate`  string , `IsHidden`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloInvoiceItemSet/2026-04-17/1776412777'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloinvoiceitemset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloinvoiceitemset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}