Skip to content

Instantly share code, notes, and snippets.

@peppertech

peppertech/erpData2.json

Last active April 8, 2019 10:14
Show Gist options
  • Save peppertech/8a9691dc68b0a1466b0b7012b86e2578 to your computer and use it in GitHub Desktop.
Save peppertech/8a9691dc68b0a1466b0b7012b86e2578 to your computer and use it in GitHub Desktop.
Download ZIP
Sample data from ERP type service
Raw
erpData2.json
{
"items": [
{
"InvoiceId": 45,
"InvoiceNumber": "JGA 2012155",
"InvoiceCurrency": "USD",
"InvoiceAmount": 98346.33,
"InvoiceDate": "2012-01-21",
"BusinessUnit": "US1 Business Unit",
"Supplier": "JGA",
"SupplierNumber": "1254",
"ProcurementBU": null,
"SupplierSite": "JGA US1",
"Requester": null,
"InvoiceGroup": null,
"ConversionRateType": null,
"ConversionDate": null,
"ConversionRate": null,
"AccountingDate": "2012-01-21",
"Description": "Professional Fees",
"DeliveryChannelCode": null,
"DeliveryChannel": null,
"PayAloneFlag": false,
"InvoiceSource": "External",
"InvoiceType": "Standard",
"PayGroup": "Standard",
"InvoiceReceivedDate": null,
"PaymentReasonCode": null,
"PaymentReason": null,
"PaymentReasonComments": null,
"PaymentTerms": "2/10 Net 30",
"TermsDate": "2012-01-21",
"PaymentMethodCode": "CHECK",
"PaymentMethod": "Check",
"SupplierTaxRegistrationNumber": null,
"FirstPartyTaxRegistrationNumber": null,
"LegalEntity": "US1 Legal Entity",
"LegalEntityIdentifier": "LE_US_1",
"LiabilityDistribution": "101.10.22100.000.000.000",
"DocumentCategory": "STD INV - Standard Invoices",
"DocumentSequence": null,
"VoucherNumber": null,
"ApprovalStatus": "Not required",
"PaidStatus": "Paid",
"ValidationStatus": "Validated",
"AccountingStatus": "Accounted",
"CanceledFlag": false,
"AmountPaid": 98346.33,
"CanceledDate": null,
"CanceledBy": null,
"CreationDate": "2013-12-05T07:53:20+00:00",
"CreatedBy": "EA1258B1B3123D77E040548C2C040FC9",
"LastUpdatedBy": "CASEY.BROWN",
"LastUpdateDate": "2014-01-08T12:14:12+00:00",
"LastUpdateLogin": "ECB0EF74B453605CE0436204548C81EB",
"ApprovedStatus": "Rejected"
},
{
"InvoiceId": 46,
"InvoiceNumber": "JGA 2012163",
"InvoiceCurrency": "USD",
"InvoiceAmount": 118014.72,
"InvoiceDate": "2012-01-23",
"BusinessUnit": "US1 Business Unit",
"Supplier": "JGA",
"SupplierNumber": "1254",
"ProcurementBU": null,
"SupplierSite": "JGA US1",
"Requester": null,
"InvoiceGroup": null,
"ConversionRateType": null,
"ConversionDate": null,
"ConversionRate": null,
"AccountingDate": "2012-01-23",
"Description": "Recruiting expenses",
"DeliveryChannelCode": null,
"DeliveryChannel": null,
"PayAloneFlag": false,
"InvoiceSource": "External",
"InvoiceType": "Standard",
"PayGroup": "Standard",
"InvoiceReceivedDate": null,
"PaymentReasonCode": null,
"PaymentReason": null,
"PaymentReasonComments": null,
"PaymentTerms": "2/10 Net 30",
"TermsDate": "2012-01-23",
"PaymentMethodCode": "CHECK",
"PaymentMethod": "Check",
"SupplierTaxRegistrationNumber": null,
"FirstPartyTaxRegistrationNumber": null,
"LegalEntity": "US1 Legal Entity",
"LegalEntityIdentifier": "LE_US_1",
"LiabilityDistribution": "101.10.22100.000.000.000",
"DocumentCategory": "STD INV - Standard Invoices",
"DocumentSequence": null,
"VoucherNumber": null,
"ApprovalStatus": "Not required",
"PaidStatus": "Paid",
"ValidationStatus": "Validated",
"AccountingStatus": "Accounted",
"CanceledFlag": false,
"AmountPaid": 118014.72,
"CanceledDate": null,
"CanceledBy": null,
"CreationDate": "2013-12-03T07:53:20+00:00",
"CreatedBy": "EA1258B1B3123D77E040548C2C040FC9",
"LastUpdatedBy": "CASEY.BROWN",
"LastUpdateDate": "2014-01-08T12:14:12+00:00",
"LastUpdateLogin": "ECB0EF74B453605CE0436204548C81EB",
"ApprovedStatus": "AutoApproved"
},
{
"InvoiceId": 47,
"InvoiceNumber": "SS 201219046",
"InvoiceCurrency": "USD",
"InvoiceAmount": 191773.92,
"InvoiceDate": "2012-01-25",
"BusinessUnit": "US1 Business Unit",
"Supplier": "Staffing Services",
"SupplierNumber": "1253",
"ProcurementBU": null,
"SupplierSite": "Staffing US1",
"Requester": null,
"InvoiceGroup": null,
"ConversionRateType": null,
"ConversionDate": null,
"ConversionRate": null,
"AccountingDate": "2012-01-25",
"Description": null,
"DeliveryChannelCode": null,
"DeliveryChannel": null,
"PayAloneFlag": false,
"InvoiceSource": "External",
"InvoiceType": "Standard",
"PayGroup": "Standard",
"InvoiceReceivedDate": null,
"PaymentReasonCode": null,
"PaymentReason": null,
"PaymentReasonComments": null,
"PaymentTerms": "Net 45",
"TermsDate": "2012-01-25",
"PaymentMethodCode": "CHECK",
"PaymentMethod": "Check",
"SupplierTaxRegistrationNumber": null,
"FirstPartyTaxRegistrationNumber": null,
"LegalEntity": "US1 Legal Entity",
"LegalEntityIdentifier": "LE_US_1",
"LiabilityDistribution": "101.10.22100.000.000.000",
"DocumentCategory": "STD INV - Standard Invoices",
"DocumentSequence": null,
"VoucherNumber": null,
"ApprovalStatus": "Not required",
"PaidStatus": "Paid",
"ValidationStatus": "Validated",
"AccountingStatus": "Accounted",
"CanceledFlag": false,
"AmountPaid": 191773.92,
"CanceledDate": null,
"CanceledBy": null,
"CreationDate": "2013-12-07T07:53:20+00:00",
"CreatedBy": "EA1258B1B3123D77E040548C2C040FC9",
"LastUpdatedBy": "CASEY.BROWN",
"LastUpdateDate": "2014-01-08T12:16:43+00:00",
"LastUpdateLogin": "ECB0EF74B453605CE0436204548C81EB",
"ApprovedStatus": "Approved"
},
{
"InvoiceId": 48,
"InvoiceNumber": "JGA 2012162",
"InvoiceCurrency": "USD",
"InvoiceAmount": 40977.09,
"InvoiceDate": "2012-01-23",
"BusinessUnit": "US1 Business Unit",
"Supplier": "JGA",
"SupplierNumber": "1254",
"ProcurementBU": null,
"SupplierSite": "JGA US1",
"Requester": null,
"InvoiceGroup": null,
"ConversionRateType": null,
"ConversionDate": null,
"ConversionRate": null,
"AccountingDate": "2012-01-23",
"Description": "Cafeteria Subsidies",
"DeliveryChannelCode": null,
"DeliveryChannel": null,
"PayAloneFlag": false,
"InvoiceSource": "External",
"InvoiceType": "Standard",
"PayGroup": "Standard",
"InvoiceReceivedDate": null,
"PaymentReasonCode": null,
"PaymentReason": null,
"PaymentReasonComments": null,
"PaymentTerms": "2/10 Net 30",
"TermsDate": "2012-01-23",
"PaymentMethodCode": "CHECK",
"PaymentMethod": "Check",
"SupplierTaxRegistrationNumber": null,
"FirstPartyTaxRegistrationNumber": null,
"LegalEntity": "US1 Legal Entity",
"LegalEntityIdentifier": "LE_US_1",
"LiabilityDistribution": "101.10.22100.000.000.000",
"DocumentCategory": "STD INV - Standard Invoices",
"DocumentSequence": null,
"VoucherNumber": null,
"ApprovalStatus": "Not required",
"PaidStatus": "Paid",
"ValidationStatus": "Validated",
"AccountingStatus": "Accounted",
"CanceledFlag": false,
"AmountPaid": 40977.09,
"CanceledDate": null,
"CanceledBy": null,
"CreationDate": "2013-12-04T07:53:20+00:00",
"CreatedBy": "EA1258B1B3123D77E040548C2C040FC9",
"LastUpdatedBy": "CASEY.BROWN",
"LastUpdateDate": "2014-01-08T12:14:12+00:00",
"LastUpdateLogin": "ECB0EF74B453605CE0436204548C81EB",
"ApprovedStatus": "Requested"
},
{
"InvoiceId": 53,
"InvoiceNumber": "OD 2012114",
"InvoiceCurrency": "USD",
"InvoiceAmount": 86940.81,
"InvoiceDate": "2012-01-26",
"BusinessUnit": "US1 Business Unit",
"Supplier": "Office Depot",
"SupplierNumber": "1264",
"ProcurementBU": null,
"SupplierSite": "OD US1",
"Requester": null,
"InvoiceGroup": null,
"ConversionRateType": null,
"ConversionDate": null,
"ConversionRate": null,
"AccountingDate": "2012-01-26",
"Description": "Office Supplies",
"DeliveryChannelCode": null,
"DeliveryChannel": null,
"PayAloneFlag": false,
"InvoiceSource": "External",
"InvoiceType": "Standard",
"PayGroup": "Standard",
"InvoiceReceivedDate": null,
"PaymentReasonCode": null,
"PaymentReason": null,
"PaymentReasonComments": null,
"PaymentTerms": "Net 45",
"TermsDate": "2012-01-26",
"PaymentMethodCode": "CHECK",
"PaymentMethod": "Check",
"SupplierTaxRegistrationNumber": null,
"FirstPartyTaxRegistrationNumber": null,
"LegalEntity": "US1 Legal Entity",
"LegalEntityIdentifier": "LE_US_1",
"LiabilityDistribution": "101.10.22100.000.000.000",
"DocumentCategory": "STD INV - Standard Invoices",
"DocumentSequence": null,
"VoucherNumber": null,
"ApprovalStatus": "Not required",
"PaidStatus": "Paid",
"ValidationStatus": "Validated",
"AccountingStatus": "Accounted",
"CanceledFlag": false,
"AmountPaid": 86940.81,
"CanceledDate": null,
"CanceledBy": null,
"CreationDate": "2013-12-03T08:28:00+00:00",
"CreatedBy": "EA1258B1B3123D77E040548C2C040FC9",
"LastUpdatedBy": "CASEY.BROWN",
"LastUpdateDate": "2014-01-08T12:16:43+00:00",
"LastUpdateLogin": "ECB0EF74B45B605CE0436204548C81EB",
"ApprovedStatus": "Requested"
},
{
"InvoiceId": 54,
"InvoiceNumber": "DI 2012163",
"InvoiceCurrency": "USD",
"InvoiceAmount": 97167.02,
"InvoiceDate": "2012-01-27",
"BusinessUnit": "US1 Business Unit",
"Supplier": "Dell Inc.",
"SupplierNumber": "1255",
"ProcurementBU": null,
"SupplierSite": "Dell US1",
"Requester": null,
"InvoiceGroup": null,
"ConversionRateType": null,
"ConversionDate": null,
"ConversionRate": null,
"AccountingDate": "2012-01-27",
"Description": "Computer Supplies",
"DeliveryChannelCode": null,
"DeliveryChannel": null,
"PayAloneFlag": false,
"InvoiceSource": "External",
"InvoiceType": "Standard",
"PayGroup": "Standard",
"InvoiceReceivedDate": null,
"PaymentReasonCode": null,
"PaymentReason": null,
"PaymentReasonComments": null,
"PaymentTerms": "Net 45",
"TermsDate": "2012-01-27",
"PaymentMethodCode": "CHECK",
"PaymentMethod": "Check",
"SupplierTaxRegistrationNumber": null,
"FirstPartyTaxRegistrationNumber": null,
"LegalEntity": "US1 Legal Entity",
"LegalEntityIdentifier": "LE_US_1",
"LiabilityDistribution": "101.10.22100.000.000.000",
"DocumentCategory": "STD INV - Standard Invoices",
"DocumentSequence": null,
"VoucherNumber": null,
"ApprovalStatus": "Not required",
"PaidStatus": "Paid",
"ValidationStatus": "Validated",
"AccountingStatus": "Accounted",
"CanceledFlag": false,
"AmountPaid": 97167.02,
"CanceledDate": null,
"CanceledBy": null,
"CreationDate": "2013-12-07T08:28:00+00:00",
"CreatedBy": "EA1258B1B3123D77E040548C2C040FC9",
"LastUpdatedBy": "CASEY.BROWN",
"LastUpdateDate": "2014-01-08T12:16:43+00:00",
"LastUpdateLogin": "ECB0EF74B45B605CE0436204548C81EB",
"ApprovedStatus": "Approved"
},
{
"InvoiceId": 55,
"InvoiceNumber": "SS 201219015",
"InvoiceCurrency": "USD",
"InvoiceAmount": 778568,
"InvoiceDate": "2012-01-27",
"BusinessUnit": "US1 Business Unit",
"Supplier": "Staffing Services",
"SupplierNumber": "1253",
"ProcurementBU": null,
"SupplierSite": "Staffing US1",
"Requester": null,
"InvoiceGroup": null,
"ConversionRateType": null,
"ConversionDate": null,
"ConversionRate": null,
"AccountingDate": "2012-01-27",
"Description": "Business Liability Insurance",
"DeliveryChannelCode": null,
"DeliveryChannel": null,
"PayAloneFlag": false,
"InvoiceSource": "External",
"InvoiceType": "Standard",
"PayGroup": "Standard",
"InvoiceReceivedDate": null,
"PaymentReasonCode": null,
"PaymentReason": null,
"PaymentReasonComments": null,
"PaymentTerms": "Net 45",
"TermsDate": "2012-01-27",
"PaymentMethodCode": "CHECK",
"PaymentMethod": "Check",
"SupplierTaxRegistrationNumber": null,
"FirstPartyTaxRegistrationNumber": null,
"LegalEntity": "US1 Legal Entity",
"LegalEntityIdentifier": "LE_US_1",
"LiabilityDistribution": "101.10.22100.000.000.000",
"DocumentCategory": "STD INV - Standard Invoices",
"DocumentSequence": null,
"VoucherNumber": null,
"ApprovalStatus": "Not required",
"PaidStatus": "Paid",
"ValidationStatus": "Validated",
"AccountingStatus": "Accounted",
"CanceledFlag": false,
"AmountPaid": 778568,
"CanceledDate": null,
"CanceledBy": null,
"CreationDate": "2013-12-03T08:28:00+00:00",
"CreatedBy": "EA1258B1B3123D77E040548C2C040FC9",
"LastUpdatedBy": "CASEY.BROWN",
"LastUpdateDate": "2014-01-08T12:16:43+00:00",
"LastUpdateLogin": "ECB0EF74B45B605CE0436204548C81EB",
"ApprovedStatus": "Approved"
},
{
"InvoiceId": 1001,
"InvoiceNumber": "ERS-50001-1",
"InvoiceCurrency": "USD",
"InvoiceAmount": 305.51,
"InvoiceDate": "2013-12-11",
"BusinessUnit": "US1 Business Unit",
"Supplier": "JGA",
"SupplierNumber": "1254",
"ProcurementBU": null,
"SupplierSite": "JGA US1",
"Requester": null,
"InvoiceGroup": null,
"ConversionRateType": null,
"ConversionDate": null,
"ConversionRate": null,
"AccountingDate": "2013-12-11",
"Description": "The receipt invoice ERS-50001-1 has a creation date of 2013-12-11.",
"DeliveryChannelCode": null,
"DeliveryChannel": null,
"PayAloneFlag": false,
"InvoiceSource": "ERS",
"InvoiceType": "Standard",
"PayGroup": "Standard",
"InvoiceReceivedDate": "2013-12-11",
"PaymentReasonCode": null,
"PaymentReason": null,
"PaymentReasonComments": null,
"PaymentTerms": "Net 30",
"TermsDate": "2013-12-11",
"PaymentMethodCode": "EFT",
"PaymentMethod": "Electronic",
"SupplierTaxRegistrationNumber": null,
"FirstPartyTaxRegistrationNumber": null,
"LegalEntity": "US1 Legal Entity",
"LegalEntityIdentifier": "LE_US_1",
"LiabilityDistribution": "101.10.22100.000.000.000",
"DocumentCategory": "STD INV - Standard Invoices",
"DocumentSequence": null,
"VoucherNumber": null,
"ApprovalStatus": "Not required",
"PaidStatus": "Paid",
"ValidationStatus": "Validated",
"AccountingStatus": "Accounted",
"CanceledFlag": false,
"AmountPaid": 305.51,
"CanceledDate": null,
"CanceledBy": null,
"CreationDate": "2013-12-11T21:34:27+00:00",
"CreatedBy": "CALVIN.ROTH",
"LastUpdatedBy": "CALVIN.ROTH",
"LastUpdateDate": "2013-12-11T21:36:36+00:00",
"LastUpdateLogin": "EA1258B1B3113D77E040548C2C040FC9",
"ApprovedStatus": "Approved"
},
{
"InvoiceId": 300000048648187,
"InvoiceNumber": "16027inv",
"InvoiceCurrency": "USD",
"InvoiceAmount": 163.16,
"InvoiceDate": "2013-12-11",
"BusinessUnit": "US1 Business Unit",
"Supplier": "Lee Supplies",
"SupplierNumber": "1252",
"ProcurementBU": null,
"SupplierSite": "Lee US1",
"Requester": null,
"InvoiceGroup": null,
"ConversionRateType": null,
"ConversionDate": null,
"ConversionRate": null,
"AccountingDate": "2013-12-11",
"Description": null,
"DeliveryChannelCode": null,
"DeliveryChannel": null,
"PayAloneFlag": false,
"InvoiceSource": "Manual invoice entry",
"InvoiceType": "Standard",
"PayGroup": "Standard",
"InvoiceReceivedDate": null,
"PaymentReasonCode": null,
"PaymentReason": null,
"PaymentReasonComments": null,
"PaymentTerms": "Net 30",
"TermsDate": "2013-12-11",
"PaymentMethodCode": "EFT",
"PaymentMethod": "Electronic",
"SupplierTaxRegistrationNumber": null,
"FirstPartyTaxRegistrationNumber": null,
"LegalEntity": "US1 Legal Entity",
"LegalEntityIdentifier": "LE_US_1",
"LiabilityDistribution": "101.10.22100.000.000.000",
"DocumentCategory": null,
"DocumentSequence": null,
"VoucherNumber": null,
"ApprovalStatus": "Not required",
"PaidStatus": "Paid",
"ValidationStatus": "Validated",
"AccountingStatus": "Accounted",
"CanceledFlag": false,
"AmountPaid": 163.16,
"CanceledDate": null,
"CanceledBy": null,
"CreationDate": "2013-12-11T23:32:37+00:00",
"CreatedBy": "CALVIN.ROTH",
"LastUpdatedBy": "CALVIN.ROTH",
"LastUpdateDate": "2013-12-11T23:35:10+00:00",
"LastUpdateLogin": "ED4A167071CC04F6E0436204548C7C65",
"ApprovedStatus": "AutoApproved"
},
{
"InvoiceId": 300000049373131,
"InvoiceNumber": "162034inv",
"InvoiceCurrency": "USD",
"InvoiceAmount": 830.01,
"InvoiceDate": "2013-12-16",
"BusinessUnit": "US1 Business Unit",
"Supplier": "Lee Supplies",
"SupplierNumber": "1252",
"ProcurementBU": null,
"SupplierSite": "Lee US1",
"Requester": null,
"InvoiceGroup": null,
"ConversionRateType": null,
"ConversionDate": null,
"ConversionRate": null,
"AccountingDate": "2013-12-16",
"Description": null,
"DeliveryChannelCode": null,
"DeliveryChannel": null,
"PayAloneFlag": false,
"InvoiceSource": "Internet supplier portal",
"InvoiceType": "Standard",
"PayGroup": "Standard",
"InvoiceReceivedDate": null,
"PaymentReasonCode": null,
"PaymentReason": null,
"PaymentReasonComments": null,
"PaymentTerms": "Net 30",
"TermsDate": "2013-12-16",
"PaymentMethodCode": "EFT",
"PaymentMethod": "Electronic",
"SupplierTaxRegistrationNumber": null,
"FirstPartyTaxRegistrationNumber": null,
"LegalEntity": "US1 Legal Entity",
"LegalEntityIdentifier": "LE_US_1",
"LiabilityDistribution": "101.10.22100.000.000.000",
"DocumentCategory": null,
"DocumentSequence": null,
"VoucherNumber": null,
"ApprovalStatus": "Not required",
"PaidStatus": "Paid",
"ValidationStatus": "Validated",
"AccountingStatus": "Accounted",
"CanceledFlag": false,
"AmountPaid": 830.01,
"CanceledDate": null,
"CanceledBy": null,
"CreationDate": "2013-12-16T22:16:47.001+00:00",
"CreatedBy": "RYAN.LEE",
"LastUpdatedBy": "CALVIN.ROTH",
"LastUpdateDate": "2013-12-16T22:23:17+00:00",
"LastUpdateLogin": "EDAEEE647E2F429DE0436204548C4ADA",
"ApprovedStatus": "Approved"
}
],
"count": 10,
"hasMore": true,
"limit": 10,
"offset": 0,
"links": [
{
"rel": "self",
"href": "https://ucf1-ecst-fa-ext.oracledemos.com:443/fscmRestApi/resources/11.13.18.05/invoices",
"name": "invoices",
"kind": "collection"
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment