Schema Info

Schema Name: sfdl_stage_drivethru.molo_moloinvoiceitemset

created: 2023-08-10 14:04:23
disabled: False
format: raw
id: 2060
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 3

Version 611755

created: 2023-10-16 01:58:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.molo_moloinvoiceitemset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 \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-stage/raw/molo_moloInvoiceItemSet/2023-10-16/1697439258'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.molo_moloinvoiceitemset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-stage/raw/molo_moloInvoiceItemSet/2023-10-16/1697439258
id: 611755
processed: 1

raw_data:

{
    "ARGLCode": 74,
    "AccountType": 80,
    "AddedAutomatically": 93,
    "AllocationType": 38,
    "AllowTotalPriceEntry": 92,
    "ApplicationCryptogram": 81,
    "AspNetUser_Id": 41,
    "AuthorizationCode": 82,
    "AuthorizationResponseCode": 83,
    "COGSGLCode": 76,
    "CardholderVerificationMethod": 84,
    "ChargeGroup": 18,
    "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,
    "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",
    "AllocationType": "string",
    "AllowTotalPriceEntry": "string",
    "ApplicationCryptogram": "string",
    "AspNetUser_Id": "string",
    "AuthorizationCode": "string",
    "AuthorizationResponseCode": "string",
    "COGSGLCode": "string",
    "CardholderVerificationMethod": "string",
    "ChargeGroup": "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",
    "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: 2060
schema_scan_id: 5253270
updated: 2023-10-16 01:58:28

Version 611031

created: 2023-10-15 01:55:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.molo_moloinvoiceitemset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 \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-stage/raw/molo_moloInvoiceItemSet/2023-10-15/1697352798'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.molo_moloinvoiceitemset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-stage/raw/molo_moloInvoiceItemSet/2023-10-15/1697352798
id: 611031
processed: 1

raw_data:

{
    "ARGLCode": 74,
    "AccountType": 80,
    "AddedAutomatically": 93,
    "AllocationType": 38,
    "AllowTotalPriceEntry": 92,
    "ApplicationCryptogram": 81,
    "AspNetUser_Id": 41,
    "AuthorizationCode": 82,
    "AuthorizationResponseCode": 83,
    "COGSGLCode": 76,
    "CardholderVerificationMethod": 84,
    "ChargeGroup": 18,
    "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,
    "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",
    "AllocationType": "string",
    "AllowTotalPriceEntry": "string",
    "ApplicationCryptogram": "string",
    "AspNetUser_Id": "string",
    "AuthorizationCode": "string",
    "AuthorizationResponseCode": "string",
    "COGSGLCode": "string",
    "CardholderVerificationMethod": "string",
    "ChargeGroup": "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",
    "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: 2060
schema_scan_id: 5251365
updated: 2023-10-15 01:55:12

Version 610423

created: 2023-10-14 01:59:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.molo_moloinvoiceitemset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 \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-stage/raw/molo_moloInvoiceItemSet/2023-10-14/1697266481'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.molo_moloinvoiceitemset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-stage/raw/molo_moloInvoiceItemSet/2023-10-14/1697266481
id: 610423
processed: 1

raw_data:

{
    "ARGLCode": 74,
    "AccountType": 80,
    "AddedAutomatically": 93,
    "AllocationType": 38,
    "AllowTotalPriceEntry": 92,
    "ApplicationCryptogram": 81,
    "AspNetUser_Id": 41,
    "AuthorizationCode": 82,
    "AuthorizationResponseCode": 83,
    "COGSGLCode": 76,
    "CardholderVerificationMethod": 84,
    "ChargeGroup": 18,
    "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,
    "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",
    "AllocationType": "string",
    "AllowTotalPriceEntry": "string",
    "ApplicationCryptogram": "string",
    "AspNetUser_Id": "string",
    "AuthorizationCode": "string",
    "AuthorizationResponseCode": "string",
    "COGSGLCode": "string",
    "CardholderVerificationMethod": "string",
    "ChargeGroup": "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",
    "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: 2060
schema_scan_id: 5249383
updated: 2023-10-14 02:00:02

Schema Scans: 3

Last at 2023-10-16 01:58:13

Scan 5253270

duration: 0:00:14.307530

exit_message:

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

id: 5253270

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-stage/raw/molo_moloInvoiceItemSet/2023-10-16/1697439258",
        "key": "raw/molo_moloInvoiceItemSet/2023-10-16/1697439258/InvoiceItemSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.molo_moloInvoiceItemSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18412239947979219668,
        "service_name": "drive-thru",
        "span_id": 6955375503279939145,
        "trace_id": 10339873220457777829
    }
}

running: False
schema_name_id: 2060
start_time: 2023-10-16 01:58:13
success: True
trace_id: 10339873220457777829

Scan 5251365

duration: 0:00:14.086053

exit_message:

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

id: 5251365

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-stage/raw/molo_moloInvoiceItemSet/2023-10-15/1697352798",
        "key": "raw/molo_moloInvoiceItemSet/2023-10-15/1697352798/InvoiceItemSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.molo_moloInvoiceItemSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11682268411381169995,
        "service_name": "drive-thru",
        "span_id": 16911911784087993083,
        "trace_id": 5254699159206485167
    }
}

running: False
schema_name_id: 2060
start_time: 2023-10-15 01:54:58
success: True
trace_id: 5254699159206485167

Scan 5249383

duration: 0:00:14.142713

exit_message:

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

id: 5249383

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-stage/raw/molo_moloInvoiceItemSet/2023-10-14/1697266481",
        "key": "raw/molo_moloInvoiceItemSet/2023-10-14/1697266481/InvoiceItemSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.molo_moloInvoiceItemSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13900584819095215396,
        "service_name": "drive-thru",
        "span_id": 14417116057499553243,
        "trace_id": 7839355306666938606
    }
}

running: False
schema_name_id: 2060
start_time: 2023-10-14 01:59:48
success: True
trace_id: 7839355306666938606

Partitions:

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

Schema:

attributes:

{
    "ARGLCode": "string",
    "AccountType": "string",
    "AddedAutomatically": "string",
    "AllocationType": "string",
    "AllowTotalPriceEntry": "string",
    "ApplicationCryptogram": "string",
    "AspNetUser_Id": "string",
    "AuthorizationCode": "string",
    "AuthorizationResponseCode": "string",
    "COGSGLCode": "string",
    "CardholderVerificationMethod": "string",
    "ChargeGroup": "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",
    "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: 2023-10-16 01:58:16

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 \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-stage/raw/molo_moloInvoiceItemSet/2023-10-16/1697439258'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.molo_moloinvoiceitemset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.molo_moloinvoiceitemset"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2023-08-10 14:04:23",
        "disabled": false,
        "format": "raw",
        "id": 2060,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_drivethru",
            "table": "molo_moloinvoiceitemset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "ARGLCode": "string",
            "AccountType": "string",
            "AddedAutomatically": "string",
            "AllocationType": "string",
            "AllowTotalPriceEntry": "string",
            "ApplicationCryptogram": "string",
            "AspNetUser_Id": "string",
            "AuthorizationCode": "string",
            "AuthorizationResponseCode": "string",
            "COGSGLCode": "string",
            "CardholderVerificationMethod": "string",
            "ChargeGroup": "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",
            "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": "2023-10-16 01:58:16",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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 \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-stage/raw/molo_moloInvoiceItemSet/2023-10-16/1697439258'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.molo_moloinvoiceitemset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.molo_moloinvoiceitemset"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}