Skip to Main Content

page_parts

AdventureWorks

Address
Output similar to the Address table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_STATEPROVINCEID VARCHAR2 Y
Example output:
{
"address":[
{
"ADDRESSID":1
,"ADDRESSLINE1":"430 Lefej Manor"
,"CITY":"Sacramento"
,"STATEPROVINCEID":2
,"POSTALCODE":"82601"
,"SPATIALLOCATION":"POINT (40.2311923428875 -94.4796942858665)"
,"ROWGUID":"FBB5ED92-0F5B-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-03-02T14:38:23.423000000Z"
}
,{
"ADDRESSID":2
,"ADDRESSLINE1":"260 Hadgadov Pike"
,"CITY":"Brockton"
,"STATEPROVINCEID":2
,"POSTALCODE":"31902"
,"SPATIALLOCATION":"POINT (41.7324335344554 -96.2312722816259)"
,"ROWGUID":"FBB5ED92-0F5C-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-04-18T13:11:42.243000000Z"
}
]
}
Addresstype
Output similar to the AddressType table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"addresstype":[
{
"ADDRESSTYPEID":1
,"NAME":"Engineering "
,"ROWGUID":"FBB5ED92-0D19-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-09-07T11:38:42.832000000Z"
}
,{
"ADDRESSTYPEID":2
,"NAME":"Risk Management"
,"ROWGUID":"FBB5ED92-0D1A-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-09-13T09:43:58.536000000Z"
}
]
}
Billofmaterials
Output similar to the BillOfMaterials table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_PRODUCTASSEMBLY VARCHAR2 Y
DIST_COMPONENTID VARCHAR2 Y
DIST_UNITMEASURECODE VARCHAR2 Y
Example output:
{
"billofmaterials":[
{
"BILLOFMATERIALSID":1
,"PRODUCTASSEMBLYID":1
,"COMPONENTID":1
,"STARTDATE":"2022-11-24T18:39:28Z"
,"UNITMEASURECODE":"KGV"
,"BOMLEVEL":2
,"PERASSEMBLYQTY":1
,"MODIFIEDDATE":"2023-05-17T12:44:58.126000000Z"
}
,{
"BILLOFMATERIALSID":2
,"PRODUCTASSEMBLYID":1
,"COMPONENTID":1
,"STARTDATE":"2022-10-18T11:18:41Z"
,"UNITMEASURECODE":"KGV"
,"BOMLEVEL":1
,"PERASSEMBLYQTY":1
,"MODIFIEDDATE":"2022-11-22T01:25:15.478000000Z"
}
]
}
Businessentity
Output similar to the BusinessEntity table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"businessentity":[
{
"BUSINESSENTITYID":1
,"ROWGUID":"FBB5ED92-0D25-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-12-17T08:19:47.789000000Z"
}
,{
"BUSINESSENTITYID":2
,"ROWGUID":"FBB5ED92-0D26-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-03-14T04:15:54.153000000Z"
}
]
}
Businessentityaddress
Output similar to the BusinessEntityAddress table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_BUSINESSENTITYI VARCHAR2 Y
DIST_ADDRESSID VARCHAR2 Y
DIST_ADDRESSTYPEID VARCHAR2 Y
Example output:
{
"businessentityaddress":[
{
"BUSINESSENTITYID":1
,"ADDRESSID":1
,"ADDRESSTYPEID":1
,"ROWGUID":"FBB5ED92-1115-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-09-27T01:36:28.171000000Z"
}
,{
"BUSINESSENTITYID":2
,"ADDRESSID":2
,"ADDRESSTYPEID":1
,"ROWGUID":"FBB5ED92-1116-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-05-23T05:44:34.928000000Z"
}
]
}
Businessentitycontact
Output similar to the BusinessEntityContact table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_BUSINESSENTITYI VARCHAR2 Y
DIST_PERSONID VARCHAR2 Y
DIST_CONTACTTYPEID VARCHAR2 Y
Example output:
{
"businessentitycontact":[
{
"BUSINESSENTITYID":1
,"PERSONID":1
,"CONTACTTYPEID":1
,"ROWGUID":"FBB5ED92-0EAC-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-04-24T01:24:29.664000000Z"
}
,{
"BUSINESSENTITYID":2
,"PERSONID":2
,"CONTACTTYPEID":1
,"ROWGUID":"FBB5ED92-0EAD-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-02-14T09:43:18.310000000Z"
}
]
}
Contacttype
Output similar to the ContactType table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"contacttype":[
{
"CONTACTTYPEID":1
,"NAME":"Quality Inspector"
,"MODIFIEDDATE":"2022-10-12T03:14:17.940000000Z"
}
,{
"CONTACTTYPEID":2
,"NAME":"Teacher"
,"MODIFIEDDATE":"2022-09-11T08:16:51.146000000Z"
}
]
}
Countryregion
Output similar to the CountryRegion table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"countryregion":[
{
"COUNTRYREGIONCODE":"PT"
,"NAME":"Portugal"
,"MODIFIEDDATE":"2023-04-17T03:41:14.478000000Z"
}
,{
"COUNTRYREGIONCODE":"DZ"
,"NAME":"Algeria"
,"MODIFIEDDATE":"2023-03-07T05:05:58.114000000Z"
}
]
}
Countryregioncurrency
Output similar to the CountryRegionCurrency table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_COUNTRYREGIONCO VARCHAR2 Y
DIST_CURRENCYCODE VARCHAR2 Y
Example output:
{
"countryregioncurrency":[
{
"COUNTRYREGIONCODE":"CL"
,"CURRENCYCODE":"USD"
,"MODIFIEDDATE":"2022-11-12T05:41:38.648000000Z"
}
]
}
Creditcard
Output similar to the CreditCard table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"creditcard":[
{
"CREDITCARDID":1
,"CARDTYPE":"dcintl"
,"CARDNUMBER":"36391272896217"
,"EXPMONTH":3
,"EXPYEAR":1926
,"MODIFIEDDATE":"2023-04-17T21:58:28.360000000Z"
}
,{
"CREDITCARDID":2
,"CARDTYPE":"amex"
,"CARDNUMBER":"341988627456335"
,"EXPMONTH":7
,"EXPYEAR":1980
,"MODIFIEDDATE":"2022-07-02T22:57:16.797000000Z"
}
]
}
Culture
Output similar to the Culture table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"culture":[
{
"CULTUREID":"GQ"
,"NAME":"Somali"
,"MODIFIEDDATE":"2023-03-16T12:50:19.784000000Z"
}
,{
"CULTUREID":"MN"
,"NAME":"Xiang"
,"MODIFIEDDATE":"2022-07-12T10:31:58.798000000Z"
}
]
}
Currency
Output similar to the Currency table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"currency":[
{
"CURRENCYCODE":"SGD"
,"NAME":"European euro"
,"MODIFIEDDATE":"2023-04-27T09:30:12.370000000Z"
}
,{
"CURRENCYCODE":"SCR"
,"NAME":"Pakistani rupee"
,"MODIFIEDDATE":"2022-09-17T12:06:20.676000000Z"
}
]
}
Currencyrate
Output similar to the CurrencyRate table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_TOCURRENCYCODE VARCHAR2 Y
Example output:
{
"currencyrate":[
{
"CURRENCYRATEID":1
,"CURRENCYRATEDATE":"2023-05-15T14:24:24Z"
,"FROMCURRENCYCODE":"USD"
,"TOCURRENCYCODE":"ETB"
,"AVERAGERATE":2.36
,"ENDOFDAYRATE":2.72
,"MODIFIEDDATE":"2022-11-25T02:35:41.989000000Z"
}
,{
"CURRENCYRATEID":2
,"CURRENCYRATEDATE":"2023-05-16T14:24:24Z"
,"FROMCURRENCYCODE":"USD"
,"TOCURRENCYCODE":"ETB"
,"AVERAGERATE":2.68
,"ENDOFDAYRATE":2.47
,"MODIFIEDDATE":"2022-08-11T18:11:44.818000000Z"
}
]
}
Customer
Output similar to the Customer table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_PERSONID VARCHAR2 Y
DIST_STOREID VARCHAR2 Y
DIST_TERRITORYID VARCHAR2 Y
Example output:
{
"customer":[
{
"CUSTOMERID":1
,"PERSONID":1
,"STOREID":1
,"TERRITORYID":9
,"ACCOUNTNUMBER":"FRRRPNTI0057"
,"ROWGUID":"FBB5ED92-11E0-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-06-22T09:55:43.440000000Z"
}
,{
"CUSTOMERID":2
,"PERSONID":2
,"STOREID":2
,"TERRITORYID":9
,"ACCOUNTNUMBER":"XTNVKDYT0021"
,"ROWGUID":"FBB5ED92-11E1-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-05-18T15:43:19.706000000Z"
}
]
}
Department
Output similar to the Department table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"department":[
{
"DEPARTMENTID":1
,"NAME":"Investor Relations"
,"GROUPNAME":"Shipping"
,"MODIFIEDDATE":"2022-12-12T07:28:06.332000000Z"
}
,{
"DEPARTMENTID":2
,"NAME":"Information Technology \/ Technology"
,"GROUPNAME":"Business Unit"
,"MODIFIEDDATE":"2022-05-09T10:03:12.100000000Z"
}
]
}
Document
Output similar to the Document table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_OWNER VARCHAR2 Y
Example output:
{
"document":[
{
"DOCUMENTNODE":"\/5\/8\/"
,"DOCUMENTLEVEL":2
,"TITLE":"The Tall"
,"OWNER":1
,"FOLDERFLAG":"1"
,"FILENAME":"had.docx"
,"FILEEXTENSION":"docx"
,"REVISION":"4"
,"CHANGENUMBER":7
,"STATUS":1
,"DOCUMENTSUMMARY":"Breath the possibilities of getting out logs in the significances fifty."
,"DOCUMENT":"h8lg72p1a7m83gy751713856488497"
,"ROWGUID":"FBB5ED92-0F98-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-02-25T12:54:54.243000000Z"
}
,{
"DOCUMENTNODE":"\/6\/6\/"
,"DOCUMENTLEVEL":2
,"TITLE":"One Chulas Juliet rolling When Baby"
,"OWNER":2
,"FOLDERFLAG":"1"
,"FILENAME":"vo.docx"
,"FILEEXTENSION":"docx"
,"REVISION":"0"
,"CHANGENUMBER":24
,"STATUS":2
,"DOCUMENTSUMMARY":"Not but the lunch wrapped in the yukon lay a."
,"DOCUMENT":"x4dl83i9c8e78qv848676592643364"
,"ROWGUID":"FBB5ED92-0F99-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-02-13T21:08:26.778000000Z"
}
]
}
Emailaddress
Output similar to the EmailAddress table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_BUSINESSENTITYI VARCHAR2 Y
Example output:
{
"emailaddress":[
{
"BUSINESSENTITYID":1
,"EMAILADDRESSID":1
,"EMAILADDRESS":"re@foseh.mil"
,"ROWGUID":"FBB5ED92-0EBE-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-02-02T03:19:31.935000000Z"
}
,{
"BUSINESSENTITYID":2
,"EMAILADDRESSID":2
,"EMAILADDRESS":"sos@nubbo.int"
,"ROWGUID":"FBB5ED92-0EBF-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-05-06T13:32:47.279000000Z"
}
]
}
Employee
Output similar to the Employee table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_BUSINESSENTITYI VARCHAR2 Y
Example output:
{
"employee":[
{
"BUSINESSENTITYID":1
,"NATIONALIDNUMBER":"632-67-6623"
,"LOGINID":"adventure-works\u005Cdffh04"
,"ORGANIZATIONNODE":"\/3\/3\/"
,"ORGANIZATIONLEVEL":2
,"JOBTITLE":"Hair Stylist"
,"BIRTHDATE":"1973-09-17T19:33:17Z"
,"MARITALSTATUS":"S"
,"GENDER":"M"
,"HIREDATE":"2022-09-07T00:54:45Z"
,"SALARIEDFLAG":"0"
,"VACATIONHOURS":61
,"SICKLEAVEHOURS":63
,"CURRENTFLAG":"1"
,"ROWGUID":"FBB5ED92-0EDB-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-10-07T05:31:46.210000000Z"
}
,{
"BUSINESSENTITYID":2
,"NATIONALIDNUMBER":"434-33-2572"
,"LOGINID":"adventure-works\u005Cmvbo08"
,"ORGANIZATIONNODE":"\/7\/7\/"
,"ORGANIZATIONLEVEL":2
,"JOBTITLE":"Gas Line Technician"
,"BIRTHDATE":"1959-06-24T02:26:16Z"
,"MARITALSTATUS":"M"
,"GENDER":"F"
,"HIREDATE":"2023-01-10T10:16:58Z"
,"SALARIEDFLAG":"1"
,"VACATIONHOURS":63
,"SICKLEAVEHOURS":50
,"CURRENTFLAG":"1"
,"ROWGUID":"FBB5ED92-0EDC-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-07-07T04:05:18.557000000Z"
}
]
}
Employeedepartmenthistory
Output similar to the EmployeeDepartmentHistory table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_BUSINESSENTITYI VARCHAR2 Y
DIST_DEPARTMENTID VARCHAR2 Y
DIST_SHIFTID VARCHAR2 Y
Example output:
{
"employeedepartmenthistory":[
{
"BUSINESSENTITYID":1
,"DEPARTMENTID":2
,"SHIFTID":2
,"STARTDATE":"2022-12-15T13:28:19Z"
,"MODIFIEDDATE":"2023-02-15T10:07:16.430000000Z"
}
,{
"BUSINESSENTITYID":2
,"DEPARTMENTID":2
,"SHIFTID":2
,"STARTDATE":"2023-05-16T08:32:45Z"
,"MODIFIEDDATE":"2022-07-18T07:38:48.690000000Z"
}
]
}
Employeepayhistory
Output similar to the EmployeePayHistory table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_BUSINESSENTITYI VARCHAR2 Y
Example output:
{
"employeepayhistory":[
{
"BUSINESSENTITYID":1
,"RATECHANGEDATE":"2022-06-30T06:45:15Z"
,"RATE":22.03
,"PAYFREQUENCY":1
,"MODIFIEDDATE":"2022-06-24T11:20:56.385000000Z"
}
,{
"BUSINESSENTITYID":2
,"RATECHANGEDATE":"2023-04-23T09:36:58Z"
,"RATE":14.64
,"PAYFREQUENCY":1
,"MODIFIEDDATE":"2023-01-31T01:13:50.501000000Z"
}
]
}
Illustration
Output similar to the Illustration table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"illustration":[
{
"ILLUSTRATIONID":4
,"DIAGRAM":"\u003C?xml version=\"1.0\"?\u003E\n\u003Cusers\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E1\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EBrayden Peterson\u003C\/name\u003E\n    \u003Cemail\u003Ekadni@tefor.com\u003C\/email\u003E\n    \u003Caddress\u003E366 Votlupnav Manor\u003C\/address\u003E\n    \u003Czipcode\u003E31707\u003C\/zipcode\u003E\n    \u003Cstate\u003EFlorida\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E2\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003ELucas Morris\u003C\/name\u003E\n    \u003Cemail\u003Ehikemtef@pine.net\u003C\/email\u003E\n    \u003Caddress\u003E41 Posrif Mill\u003C\/address\u003E\n    \u003Czipcode\u003E79985\u003C\/zipcode\u003E\n    \u003Cstate\u003EVermont\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E3\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EHannah Torres\u003C\/name\u003E\n    \u003Cemail\u003Enivuf@horos.gov\u003C\/email\u003E\n    \u003Caddress\u003E353 Gihko View\u003C\/address\u003E\n    \u003Czipcode\u003E74184\u003C\/zipcode\u003E\n    \u003Cstate\u003EAlabama\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E4\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EBentley Kelly\u003C\/name\u003E\n    \u003Cemail\u003Epoh@neciwi.int\u003C\/email\u003E\n    \u003Caddress\u003E250 Fupjo Road\u003C\/address\u003E\n    \u003Czipcode\u003E39505\u003C\/zipcode\u003E\n    \u003Cstate\u003EIndiana\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E5\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003ELogan Rogers\u003C\/name\u003E\n    \u003Cemail\u003Evibra@rig.net\u003C\/email\u003E\n    \u003Caddress\u003E459 Kufe River\u003C\/address\u003E\n    \u003Czipcode\u003E57701\u003C\/zipcode\u003E\n    \u003Cstate\u003EMaryland\u003C\/state\u003E\n  \u003C\/user\u003E\n\u003C\/users\u003E\n"
,"MODIFIEDDATE":"2022-09-13T10:45:17.889000000Z"
}
,{
"ILLUSTRATIONID":5
,"DIAGRAM":"\u003C?xml version=\"1.0\"?\u003E\n\u003Cusers\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E1\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EMariah Watson\u003C\/name\u003E\n    \u003Cemail\u003Ejived@vojdem.gov\u003C\/email\u003E\n    \u003Caddress\u003E15 Le Grove\u003C\/address\u003E\n    \u003Czipcode\u003E64502\u003C\/zipcode\u003E\n    \u003Cstate\u003EIowa\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E2\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EGenesis Lee\u003C\/name\u003E\n    \u003Cemail\u003Erop@dikwodoj.net\u003C\/email\u003E\n    \u003Caddress\u003E21 Maced Manor\u003C\/address\u003E\n    \u003Czipcode\u003E99725\u003C\/zipcode\u003E\n    \u003Cstate\u003EHawaii\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E3\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EMolly Adams\u003C\/name\u003E\n    \u003Cemail\u003Ewoca@wo.int\u003C\/email\u003E\n    \u003Caddress\u003E173 Vizhejdu Point\u003C\/address\u003E\n    \u003Czipcode\u003E85205\u003C\/zipcode\u003E\n    \u003Cstate\u003EWyoming\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E4\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EDaniel Baker\u003C\/name\u003E\n    \u003Cemail\u003Erazu@kacuc.int\u003C\/email\u003E\n    \u003Caddress\u003E115 Puhow View\u003C\/address\u003E\n    \u003Czipcode\u003E36398\u003C\/zipcode\u003E\n    \u003Cstate\u003EIndiana\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E5\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EJordan Stewart\u003C\/name\u003E\n    \u003Cemail\u003Ehahket@jufed.com\u003C\/email\u003E\n    \u003Caddress\u003E241 Wapem Ridge\u003C\/address\u003E\n    \u003Czipcode\u003E93703\u003C\/zipcode\u003E\n    \u003Cstate\u003EIndiana\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E6\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EOliver Simmons\u003C\/name\u003E\n    \u003Cemail\u003Ele@sec.org\u003C\/email\u003E\n    \u003Caddress\u003E279 Lelo Lane\u003C\/address\u003E\n    \u003Czipcode\u003E55103\u003C\/zipcode\u003E\n    \u003Cstate\u003ELouisiana\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E7\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EAiden Martin\u003C\/name\u003E\n    \u003Cemail\u003Ejufivo@ge.net\u003C\/email\u003E\n    \u003Caddress\u003E494 Vejtad Grove\u003C\/address\u003E\n    \u003Czipcode\u003E36372\u003C\/zipcode\u003E\n    \u003Cstate\u003EWashington\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E8\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EIan Hughes\u003C\/name\u003E\n    \u003Cemail\u003Emotnug@mod.com\u003C\/email\u003E\n    \u003Caddress\u003E43 Tetfam Circle\u003C\/address\u003E\n    \u003Czipcode\u003E98665\u003C\/zipcode\u003E\n    \u003Cstate\u003EOhio\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E9\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EWyatt Clark\u003C\/name\u003E\n    \u003Cemail\u003Eralhof@sewa.org\u003C\/email\u003E\n    \u003Caddress\u003E272 Fu Manor\u003C\/address\u003E\n    \u003Czipcode\u003E39532\u003C\/zipcode\u003E\n    \u003Cstate\u003ELouisiana\u003C\/state\u003E\n  \u003C\/user\u003E\n\u003C\/users\u003E\n"
,"MODIFIEDDATE":"2023-04-07T15:34:29.563000000Z"
}
]
}
Jobcandidate
Output similar to the JobCandidate table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_BUSINESSENTITYI VARCHAR2 Y
Example output:
{
"jobcandidate":[
{
"JOBCANDIDATEID":7
,"BUSINESSENTITYID":1
,"RESUME":"\u003C?xml version=\"1.0\"?\u003E\n\u003Cusers\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E1\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EElizabeth Martin\u003C\/name\u003E\n    \u003Cemail\u003Emeli@hi.edu\u003C\/email\u003E\n    \u003Caddress\u003E460 Kipli Court\u003C\/address\u003E\n    \u003Czipcode\u003E02893\u003C\/zipcode\u003E\n    \u003Cstate\u003EAlaska\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E2\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EChristopher Martinez\u003C\/name\u003E\n    \u003Cemail\u003Esot@hajva.gov\u003C\/email\u003E\n    \u003Caddress\u003E65 Mo Loop\u003C\/address\u003E\n    \u003Czipcode\u003E80241\u003C\/zipcode\u003E\n    \u003Cstate\u003ENew Jersey\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E3\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EChristian Jenkins\u003C\/name\u003E\n    \u003Cemail\u003Ejeb@fohmef.gov\u003C\/email\u003E\n    \u003Caddress\u003E299 Supfubo Court\u003C\/address\u003E\n    \u003Czipcode\u003E80943\u003C\/zipcode\u003E\n    \u003Cstate\u003EMontana\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E4\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003ERiley Wood\u003C\/name\u003E\n    \u003Cemail\u003Eno@melci.com\u003C\/email\u003E\n    \u003Caddress\u003E36 Guwbi Loop\u003C\/address\u003E\n    \u003Czipcode\u003E74122\u003C\/zipcode\u003E\n    \u003Cstate\u003EConnecticut\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E5\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EGabriel Adams\u003C\/name\u003E\n    \u003Cemail\u003Elopi@hokwuve.int\u003C\/email\u003E\n    \u003Caddress\u003E210 Pezjot Place\u003C\/address\u003E\n    \u003Czipcode\u003E26505\u003C\/zipcode\u003E\n    \u003Cstate\u003EWisconsin\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E6\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EJackson King\u003C\/name\u003E\n    \u003Cemail\u003Eci@ri.org\u003C\/email\u003E\n    \u003Caddress\u003E127 Nuhec Circle\u003C\/address\u003E\n    \u003Czipcode\u003E27511\u003C\/zipcode\u003E\n    \u003Cstate\u003EMississippi\u003C\/state\u003E\n  \u003C\/user\u003E\n\u003C\/users\u003E\n"
,"MODIFIEDDATE":"2022-09-21T06:34:13.634000000Z"
}
,{
"JOBCANDIDATEID":8
,"BUSINESSENTITYID":2
,"RESUME":"\u003C?xml version=\"1.0\"?\u003E\n\u003Cusers\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E1\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EAngel Garcia\u003C\/name\u003E\n    \u003Cemail\u003Ewemem@wete.gov\u003C\/email\u003E\n    \u003Caddress\u003E399 Toctuwen Terrace\u003C\/address\u003E\n    \u003Czipcode\u003E73003\u003C\/zipcode\u003E\n    \u003Cstate\u003EGeorgia\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E2\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EParker Mitchell\u003C\/name\u003E\n    \u003Cemail\u003Ejuvojof@muwo.net\u003C\/email\u003E\n    \u003Caddress\u003E165 Jowo Parkway\u003C\/address\u003E\n    \u003Czipcode\u003E21244\u003C\/zipcode\u003E\n    \u003Cstate\u003EVermont\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E3\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EMatthew James\u003C\/name\u003E\n    \u003Cemail\u003Eriwsefra@ji.org\u003C\/email\u003E\n    \u003Caddress\u003E461 Golef Boulevard\u003C\/address\u003E\n    \u003Czipcode\u003E58601\u003C\/zipcode\u003E\n    \u003Cstate\u003EVermont\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E4\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003ELogan Rodriguez\u003C\/name\u003E\n    \u003Cemail\u003Emetewo@pip.int\u003C\/email\u003E\n    \u003Caddress\u003E217 Nobaz Terrace\u003C\/address\u003E\n    \u003Czipcode\u003E32838\u003C\/zipcode\u003E\n    \u003Cstate\u003EWisconsin\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E5\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EMariah Rivera\u003C\/name\u003E\n    \u003Cemail\u003Ejiho@ha.gov\u003C\/email\u003E\n    \u003Caddress\u003E263 Rif Way\u003C\/address\u003E\n    \u003Czipcode\u003E28235\u003C\/zipcode\u003E\n    \u003Cstate\u003ENorth Dakota\u003C\/state\u003E\n  \u003C\/user\u003E\n\u003C\/users\u003E\n"
,"MODIFIEDDATE":"2022-10-09T07:53:05.472000000Z"
}
]
}
Location
Output similar to the Location table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"location":[
{
"LOCATIONID":1
,"NAME":"Finance"
,"COSTRATE":16.78
,"AVAILABILITY":114.79
,"MODIFIEDDATE":"2023-05-26T04:34:45.301000000Z"
}
,{
"LOCATIONID":5
,"NAME":"Marketing"
,"COSTRATE":0
,"AVAILABILITY":87.73
,"MODIFIEDDATE":"2022-08-08T19:48:50.566000000Z"
}
]
}
Password
Output similar to the Password table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_BUSINESSENTITYI VARCHAR2 Y
Example output:
{
"password":[
{
"BUSINESSENTITYID":1
,"PASSWORDHASH":"7ee4fc25152b64e9d19f7ac9921a06e7ea7d9929"
,"PASSWORDSALT":"883563b7ecd53ab110ef31def990d136"
,"ROWGUID":"FBB5ED92-0EED-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-04-10T19:49:32.990000000Z"
}
,{
"BUSINESSENTITYID":2
,"PASSWORDHASH":"9ee03098fa6cca0881b544ed793303cafee33b6e"
,"PASSWORDSALT":"af6c81bda8a117e18233373e95f06673"
,"ROWGUID":"FBB5ED92-0EEE-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-06-06T19:19:39.727000000Z"
}
]
}
Person
Output similar to the Person table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_BUSINESSENTITYI VARCHAR2 Y
Example output:
{
"person":[
{
"BUSINESSENTITYID":1
,"PERSONTYPE":"EM"
,"NAMESTYLE":true
,"FIRSTNAME":"Wyatt"
,"MIDDLENAME":"Reese"
,"LASTNAME":"Garcia"
,"EMAILPROMOTION":1
,"ROWGUID":"FBB5ED92-0E49-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-10-23T00:57:26.355000000Z"
}
,{
"BUSINESSENTITYID":2
,"PERSONTYPE":"EM"
,"NAMESTYLE":false
,"FIRSTNAME":"Thomas"
,"MIDDLENAME":"Kylie"
,"LASTNAME":"James"
,"EMAILPROMOTION":1
,"ROWGUID":"FBB5ED92-0E4A-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-06-10T14:23:51.443000000Z"
}
]
}
Personcreditcard
Output similar to the PersonCreditCard table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_BUSINESSENTITYI VARCHAR2 Y
DIST_CREDITCARDID VARCHAR2 Y
Example output:
{
"personcreditcard":[
{
"BUSINESSENTITYID":1
,"CREDITCARDID":1
,"MODIFIEDDATE":"2022-09-03T20:16:07.299000000Z"
}
,{
"BUSINESSENTITYID":2
,"CREDITCARDID":2
,"MODIFIEDDATE":"2022-07-02T23:38:06.387000000Z"
}
]
}
Personphone
Output similar to the PersonPhone table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_BUSINESSENTITYI VARCHAR2 Y
DIST_PHONENUMBERTYPE VARCHAR2 Y
Example output:
{
"personphone":[
{
"BUSINESSENTITYID":1
,"PHONENUMBER":"457 972 1488"
,"PHONENUMBERTYPEID":1
,"MODIFIEDDATE":"2023-04-13T09:08:07.725000000Z"
}
,{
"BUSINESSENTITYID":2
,"PHONENUMBER":"587 557 4524"
,"PHONENUMBERTYPEID":1
,"MODIFIEDDATE":"2023-02-02T22:51:22.115000000Z"
}
]
}
Phonenumbertype
Output similar to the PhoneNumberType table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"phonenumbertype":[
{
"PHONENUMBERTYPEID":1
,"NAME":"ksuy"
,"MODIFIEDDATE":"2022-10-20T07:26:52.553000000Z"
}
,{
"PHONENUMBERTYPEID":2
,"NAME":"popo"
,"MODIFIEDDATE":"2022-09-11T02:44:35.128000000Z"
}
]
}
Product
Output similar to the Product table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_SIZEUNITMEASURE VARCHAR2 Y
DIST_WEIGHTUNITMEASU VARCHAR2 Y
DIST_PRODUCTSUBCATEG VARCHAR2 Y
DIST_PRODUCTMODELID VARCHAR2 Y
Example output:
{
"product":[
{
"PRODUCTID":1
,"NAME":"The bright podijsi"
,"PRODUCTNUMBER":"TBP-8319"
,"MAKEFLAG":"1"
,"FINISHEDGOODSFLAG":"0"
,"SAFETYSTOCKLEVEL":1000
,"REORDERPOINT":375
,"STANDARDCOST":1269.19
,"LISTPRICE":159.51
,"SIZE_R":"48"
,"SIZEUNITMEASURECODE":"BOX"
,"WEIGHTUNITMEASURECODE":"BOX"
,"WEIGHT":19.38
,"DAYSTOMANUFACTURE":1
,"PRODUCTLINE":"R"
,"CLASS":"L"
,"STYLE":"W"
,"PRODUCTSUBCATEGORYID":1
,"PRODUCTMODELID":2
,"SELLSTARTDATE":"2023-04-09T05:03:01Z"
,"SELLENDDATE":"2023-06-11T02:23:46Z"
,"ROWGUID":"FBB5ED92-0F32-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-01-11T11:16:30.224000000Z"
}
,{
"PRODUCTID":2
,"NAME":"The blushing suhig"
,"PRODUCTNUMBER":"TBS-3178"
,"MAKEFLAG":"0"
,"FINISHEDGOODSFLAG":"0"
,"SAFETYSTOCKLEVEL":800
,"REORDERPOINT":600
,"STANDARDCOST":1339.81
,"LISTPRICE":599.19
,"SIZE_R":"M"
,"SIZEUNITMEASURECODE":"BOX"
,"WEIGHTUNITMEASURECODE":"BOX"
,"WEIGHT":16.7
,"DAYSTOMANUFACTURE":1
,"PRODUCTLINE":"M"
,"CLASS":"M"
,"STYLE":"W"
,"PRODUCTSUBCATEGORYID":1
,"PRODUCTMODELID":2
,"SELLSTARTDATE":"2022-09-20T06:55:36Z"
,"ROWGUID":"FBB5ED92-0F33-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-08-27T08:26:23.818000000Z"
}
]
}
Productcategory
Output similar to the ProductCategory table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"productcategory":[
{
"PRODUCTCATEGORYID":1
,"NAME":"CRX-322 CD Receiver"
,"ROWGUID":"FBB5ED92-0D92-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-04-01T10:18:16.877000000Z"
}
,{
"PRODUCTCATEGORYID":2
,"NAME":"Akyra Womens Printed Casual Shirt"
,"ROWGUID":"FBB5ED92-0D93-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-03-23T14:29:30.794000000Z"
}
]
}
Productcosthistory
Output similar to the ProductCostHistory table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_PRODUCTID VARCHAR2 Y
Example output:
{
"productcosthistory":[
{
"PRODUCTID":1
,"STARTDATE":"2022-06-29T03:47:58Z"
,"STANDARDCOST":1454.73
,"MODIFIEDDATE":"2023-05-03T19:58:22.942000000Z"
}
,{
"PRODUCTID":2
,"STARTDATE":"2022-07-06T05:53:18Z"
,"STANDARDCOST":123.33
,"MODIFIEDDATE":"2023-04-10T09:45:36.894000000Z"
}
]
}
Productdescription
Output similar to the ProductDescription table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"productdescription":[
{
"PRODUCTDESCRIPTIONID":1
,"DESCRIPTION":"The mini octagon notid"
,"ROWGUID":"FBB5ED92-0D9F-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-10-26T13:32:12.448000000Z"
}
,{
"PRODUCTDESCRIPTIONID":2
,"DESCRIPTION":"The curvy triangle zal"
,"ROWGUID":"FBB5ED92-0DA0-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-08-08T20:06:30.996000000Z"
}
]
}
Productdocument
Output similar to the ProductDocument table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_PRODUCTID VARCHAR2 Y
DIST_DOCUMENTNODE VARCHAR2 Y
Example output:
{
"productdocument":[
{
"PRODUCTID":1
,"DOCUMENTNODE":"\/5\/8\/"
,"MODIFIEDDATE":"2023-04-14T12:58:38.260000000Z"
}
,{
"PRODUCTID":2
,"DOCUMENTNODE":"\/5\/8\/"
,"MODIFIEDDATE":"2022-11-22T04:22:49.402000000Z"
}
]
}
Productinventory
Output similar to the ProductInventory table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_PRODUCTID VARCHAR2 Y
DIST_LOCATIONID VARCHAR2 Y
Example output:
{
"productinventory":[
{
"PRODUCTID":1
,"LOCATIONID":5
,"SHELF":"M"
,"BIN":6
,"QUANTITY":651
,"ROWGUID":"FBB5ED92-0FFA-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-03-26T19:04:30.761000000Z"
}
,{
"PRODUCTID":2
,"LOCATIONID":5
,"SHELF":"I"
,"BIN":4
,"QUANTITY":193
,"ROWGUID":"FBB5ED92-0FFB-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-02-22T00:22:24.648000000Z"
}
]
}
Productlistpricehistory
Output similar to the ProductListPriceHistory table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_PRODUCTID VARCHAR2 Y
Example output:
{
"productlistpricehistory":[
{
"PRODUCTID":2
,"STARTDATE":"2023-02-13T16:49:10Z"
,"ENDDATE":"2023-07-06T06:16:40.000000000Z"
,"LISTPRICE":517.67
,"MODIFIEDDATE":"2023-01-14T01:38:30.452000000Z"
}
,{
"PRODUCTID":2
,"STARTDATE":"2023-03-02T22:42:27Z"
,"ENDDATE":"2024-03-17T23:22:47.000000000Z"
,"LISTPRICE":2232.92
,"MODIFIEDDATE":"2022-07-23T16:52:06.390000000Z"
}
]
}
Productmodel
Output similar to the ProductModel table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"productmodel":[
{
"PRODUCTMODELID":1
,"NAME":"Micro pure"
,"CATALOGDESCRIPTION":"\u003C?xml version=\"1.0\"?\u003E\n\u003Cusers\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E1\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003ECharles Mitchell\u003C\/name\u003E\n    \u003Cemail\u003Emophehoj@ge.net\u003C\/email\u003E\n    \u003Caddress\u003E355 Jet Manor\u003C\/address\u003E\n    \u003Czipcode\u003E98003\u003C\/zipcode\u003E\n    \u003Cstate\u003EFlorida\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E2\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003ENevaeh Nelson\u003C\/name\u003E\n    \u003Cemail\u003Eheb@pa.mil\u003C\/email\u003E\n    \u003Caddress\u003E318 Suziwo Manor\u003C\/address\u003E\n    \u003Czipcode\u003E96782\u003C\/zipcode\u003E\n    \u003Cstate\u003ENew York\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E3\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EIsaiah Butler\u003C\/name\u003E\n    \u003Cemail\u003Epoh@munlar.gov\u003C\/email\u003E\n    \u003Caddress\u003E239 Honpop Grove\u003C\/address\u003E\n    \u003Czipcode\u003E23602\u003C\/zipcode\u003E\n    \u003Cstate\u003EArkansas\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E4\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EKennedy Miller\u003C\/name\u003E\n    \u003Cemail\u003Edivgo@nu.int\u003C\/email\u003E\n    \u003Caddress\u003E458 Rijku Glen\u003C\/address\u003E\n    \u003Czipcode\u003E05603\u003C\/zipcode\u003E\n    \u003Cstate\u003ETexas\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E5\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EAlexa Bennett\u003C\/name\u003E\n    \u003Cemail\u003Egub@gicon.gov\u003C\/email\u003E\n    \u003Caddress\u003E177 Sunzo Mill\u003C\/address\u003E\n    \u003Czipcode\u003E55311\u003C\/zipcode\u003E\n    \u003Cstate\u003ENorth Carolina\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E6\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EJulian Diaz\u003C\/name\u003E\n    \u003Cemail\u003Ewatat@jebat.int\u003C\/email\u003E\n    \u003Caddress\u003E24 Ripes Terrace\u003C\/address\u003E\n    \u003Czipcode\u003E89301\u003C\/zipcode\u003E\n    \u003Cstate\u003EDelaware\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E7\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EBrianna Price\u003C\/name\u003E\n    \u003Cemail\u003Etoder@sojuc.mil\u003C\/email\u003E\n    \u003Caddress\u003E447 Nenorma Loop\u003C\/address\u003E\n    \u003Czipcode\u003E28302\u003C\/zipcode\u003E\n    \u003Cstate\u003EFlorida\u003C\/state\u003E\n  \u003C\/user\u003E\n\u003C\/users\u003E\n"
,"ROWGUID":"FBB5ED92-0DAE-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-10-04T05:49:32.699000000Z"
}
,{
"PRODUCTMODELID":2
,"NAME":"Micro sungigi"
,"CATALOGDESCRIPTION":"\u003C?xml version=\"1.0\"?\u003E\n\u003Cusers\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E1\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EDavid Perez\u003C\/name\u003E\n    \u003Cemail\u003Eno@gepok.int\u003C\/email\u003E\n    \u003Caddress\u003E266 Lenop Pass\u003C\/address\u003E\n    \u003Czipcode\u003E60569\u003C\/zipcode\u003E\n    \u003Cstate\u003EColorado\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E2\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EEmma Ramirez\u003C\/name\u003E\n    \u003Cemail\u003Eco@muju.mil\u003C\/email\u003E\n    \u003Caddress\u003E170 Nehica Circle\u003C\/address\u003E\n    \u003Czipcode\u003E88015\u003C\/zipcode\u003E\n    \u003Cstate\u003ECalifornia\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E3\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EJosiah Torres\u003C\/name\u003E\n    \u003Cemail\u003Etuwal@deli.int\u003C\/email\u003E\n    \u003Caddress\u003E265 Nedvot Pike\u003C\/address\u003E\n    \u003Czipcode\u003E30906\u003C\/zipcode\u003E\n    \u003Cstate\u003EAlaska\u003C\/state\u003E\n  \u003C\/user\u003E\n\u003C\/users\u003E\n"
,"ROWGUID":"FBB5ED92-0DAF-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-06-28T10:37:23.308000000Z"
}
]
}
Productmodelillustration
Output similar to the ProductModelIllustration table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_PRODUCTMODELID VARCHAR2 Y
DIST_ILLUSTRATIONID VARCHAR2 Y
Example output:
{
"productmodelillustration":[
{
"PRODUCTMODELID":1
,"ILLUSTRATIONID":5
,"MODIFIEDDATE":"2022-10-27T22:16:45.722000000Z"
}
,{
"PRODUCTMODELID":2
,"ILLUSTRATIONID":5
,"MODIFIEDDATE":"2023-03-17T03:19:22.769000000Z"
}
]
}
Productmodelproductdescriptionculture
Output similar to the ProductModelProductDescriptionCulture table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_PRODUCTMODELID VARCHAR2 Y
DIST_PRODUCTDESCRIPT VARCHAR2 Y
DIST_CULTUREID VARCHAR2 Y
Example output:
{
"productmodelproductdescriptionculture":[
{
"PRODUCTMODELID":1
,"PRODUCTDESCRIPTIONID":1
,"CULTUREID":"AS"
,"MODIFIEDDATE":"2023-03-19T06:34:38.750000000Z"
}
,{
"PRODUCTMODELID":2
,"PRODUCTDESCRIPTIONID":2
,"CULTUREID":"AS"
,"MODIFIEDDATE":"2022-06-01T17:44:42.233000000Z"
}
]
}
Productphoto
Output similar to the ProductPhoto table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"productphoto":[
{
"PRODUCTPHOTOID":69
,"THUMBNAILPHOTO":"38247636261567361338j789243342"
,"THUMBNAILPHOTOFILENAME":"mowebci.gif"
,"LARGEPHOTO":"726718831739b5623778b944285683"
,"LARGEPHOTOFILENAME":"lizfife.gif"
,"MODIFIEDDATE":"2022-07-15T08:51:37.782000000Z"
}
,{
"PRODUCTPHOTOID":70
,"THUMBNAILPHOTO":"25734266819539388686h682338715"
,"THUMBNAILPHOTOFILENAME":"teb.gif"
,"LARGEPHOTO":"261511773423x8384582e445385265"
,"LARGEPHOTOFILENAME":"gezmes.gif"
,"MODIFIEDDATE":"2022-07-14T03:12:39.468000000Z"
}
]
}
Productproductphoto
Output similar to the ProductProductPhoto table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_PRODUCTID VARCHAR2 Y
DIST_PRODUCTPHOTOID VARCHAR2 Y
Example output:
{
"productproductphoto":[
{
"PRODUCTID":1
,"PRODUCTPHOTOID":69
,"PRIMARY":"0"
,"MODIFIEDDATE":"2022-09-29T10:21:45.721000000Z"
}
,{
"PRODUCTID":2
,"PRODUCTPHOTOID":69
,"PRIMARY":"0"
,"MODIFIEDDATE":"2022-10-15T05:46:55.458000000Z"
}
]
}
Productreview
Output similar to the ProductReview table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_PRODUCTID VARCHAR2 Y
Example output:
{
"productreview":[
{
"PRODUCTREVIEWID":2
,"PRODUCTID":1
,"REVIEWERNAME":"Noah Parker"
,"REVIEWDATE":"2022-12-19T08:05:42Z"
,"EMAILADDRESS":"Noah.Parker@jo.org"
,"RATING":3
,"COMMENTS":"To michael on bering sea a thousand miles."
,"MODIFIEDDATE":"2022-10-16T21:55:07.359000000Z"
}
,{
"PRODUCTREVIEWID":3
,"PRODUCTID":2
,"REVIEWERNAME":"Tyler Walker"
,"REVIEWDATE":"2022-08-10T15:14:57Z"
,"EMAILADDRESS":"Tyler.Walker@litli.net"
,"RATING":3
,"COMMENTS":"Life only in the sky the tremendous cold and the eager nose that thrust itself."
,"MODIFIEDDATE":"2023-04-05T19:44:27.216000000Z"
}
]
}
Productsubcategory
Output similar to the ProductSubcategory table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_PRODUCTCATEGORY VARCHAR2 Y
Example output:
{
"productsubcategory":[
{
"PRODUCTSUBCATEGORYID":1
,"PRODUCTCATEGORYID":2
,"NAME":"Votala Electric Eyebrow Trimmer and Shaver with LED Light for Men and Women, Rose Gold (Batteries not Included)"
,"ROWGUID":"FBB5ED92-0E74-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-08-11T19:34:57.704000000Z"
}
,{
"PRODUCTSUBCATEGORYID":2
,"PRODUCTCATEGORYID":2
,"NAME":"VRTYA Casual Sleeveless Solid Womens Blue Top"
,"ROWGUID":"FBB5ED92-0E75-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-02-01T02:39:01.270000000Z"
}
]
}
Productvendor
Output similar to the ProductVendor table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_PRODUCTID VARCHAR2 Y
DIST_BUSINESSENTITYI VARCHAR2 Y
DIST_UNITMEASURECODE VARCHAR2 Y
Example output:
{
"productvendor":[
{
"PRODUCTID":1
,"BUSINESSENTITYID":1
,"AVERAGELEADTIME":17
,"STANDARDPRICE":42.15
,"LASTRECEIPTCOST":34.75
,"LASTRECEIPTDATE":"2022-10-23T17:38:18Z"
,"MINORDERQTY":1849
,"MAXORDERQTY":3570
,"ONORDERQTY":1
,"UNITMEASURECODE":"M2"
,"MODIFIEDDATE":"2022-08-23T17:52:57.277000000Z"
}
,{
"PRODUCTID":2
,"BUSINESSENTITYID":2
,"AVERAGELEADTIME":27
,"STANDARDPRICE":36.32
,"LASTRECEIPTCOST":23.34
,"LASTRECEIPTDATE":"2022-11-11T17:40:16Z"
,"MINORDERQTY":608
,"MAXORDERQTY":1186
,"ONORDERQTY":300
,"UNITMEASURECODE":"M2"
,"MODIFIEDDATE":"2023-04-14T09:54:45.993000000Z"
}
]
}
Purchaseorderdetail
Output similar to the PurchaseOrderDetail table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_PURCHASEORDERID VARCHAR2 Y
DIST_PRODUCTID VARCHAR2 Y
Example output:
{
"purchaseorderdetail":[
{
"PURCHASEORDERID":1
,"PURCHASEORDERDETAILID":1
,"DUEDATE":"2022-11-27T14:50:18.000000000Z"
,"ORDERQTY":58
,"PRODUCTID":2
,"UNITPRICE":20.47
,"LINETOTAL":1187.26
,"RECEIVEDQTY":58
,"REJECTEDQTY":0
,"STOCKEDQTY":58
,"MODIFIEDDATE":"2022-11-12T02:48:42.820000000Z"
}
,{
"PURCHASEORDERID":2
,"PURCHASEORDERDETAILID":2
,"DUEDATE":"2022-07-19T16:51:06.000000000Z"
,"ORDERQTY":202
,"PRODUCTID":2
,"UNITPRICE":22.92
,"LINETOTAL":4629.84
,"RECEIVEDQTY":202
,"REJECTEDQTY":0
,"STOCKEDQTY":202
,"MODIFIEDDATE":"2022-09-16T19:43:20.463000000Z"
}
]
}
Purchaseorderheader
Output similar to the PurchaseOrderHeader table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_EMPLOYEEID VARCHAR2 Y
DIST_VENDORID VARCHAR2 Y
DIST_SHIPMETHODID VARCHAR2 Y
Example output:
{
"purchaseorderheader":[
{
"PURCHASEORDERID":1
,"REVISIONNUMBER":7
,"STATUS":3
,"EMPLOYEEID":1
,"VENDORID":1
,"SHIPMETHODID":2
,"ORDERDATE":"2023-05-21T05:14:02Z"
,"SHIPDATE":"2024-03-13T02:00:55.000000000Z"
,"SUBTOTAL":35699.64
,"TAXAMT":6477.45
,"FREIGHT":181.45
,"TOTALDUE":42358.54
,"MODIFIEDDATE":"2022-07-09T16:12:38.938000000Z"
}
,{
"PURCHASEORDERID":2
,"REVISIONNUMBER":4
,"STATUS":3
,"EMPLOYEEID":1
,"VENDORID":1
,"SHIPMETHODID":2
,"ORDERDATE":"2022-10-15T18:53:07Z"
,"SHIPDATE":"2023-03-24T16:43:44.000000000Z"
,"SUBTOTAL":4305.74
,"TAXAMT":331.9
,"FREIGHT":55.68
,"TOTALDUE":4693.32
,"MODIFIEDDATE":"2022-11-02T23:45:04.310000000Z"
}
]
}
Salesorderdetail
Output similar to the SalesOrderDetail table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_SALESORDERID VARCHAR2 Y
DIST_PRODUCTID VARCHAR2 Y
DIST_SPECIALOFFERID VARCHAR2 Y
Example output:
{
"salesorderdetail":[
{
"SALESORDERID":43590
,"SALESORDERDETAILID":1
,"CARRIERTRACKINGNUMBER":"JVGL4068974958"
,"ORDERQTY":4.87
,"PRODUCTID":1
,"SPECIALOFFERID":2
,"UNITPRICE":1607.92
,"UNITPRICEDISCOUNT":0
,"LINETOTAL":7830.57
,"ROWGUID":"FBB5ED92-1291-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-03-10T12:36:16.783000000Z"
}
,{
"SALESORDERID":43590
,"SALESORDERDETAILID":2
,"CARRIERTRACKINGNUMBER":"1YU764321"
,"ORDERQTY":1.28
,"PRODUCTID":1
,"SPECIALOFFERID":2
,"UNITPRICE":1456.94
,"UNITPRICEDISCOUNT":0
,"LINETOTAL":1864.88
,"ROWGUID":"FBB5ED92-1292-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-04-12T05:33:47.290000000Z"
}
]
}
Salesorderheader
Output similar to the SalesOrderHeader table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_CUSTOMERID VARCHAR2 Y
DIST_SALESPERSONID VARCHAR2 Y
DIST_TERRITORYID VARCHAR2 Y
DIST_BILLTOADDRESSID VARCHAR2 Y
DIST_SHIPTOADDRESSID VARCHAR2 Y
DIST_SHIPMETHODID VARCHAR2 Y
DIST_CREDITCARDID VARCHAR2 Y
DIST_CURRENCYRATEID VARCHAR2 Y
Example output:
{
"salesorderheader":[
{
"SALESORDERID":43589
,"REVISIONNUMBER":8
,"ORDERDATE":"2017-11-12T13:24:12Z"
,"DUEDATE":"2018-05-28T10:06:10.000000000Z"
,"SHIPDATE":"2018-05-19T01:09:10.000000000Z"
,"STATUS":5
,"ONLINEORDERFLAG":"1"
,"SALESORDERNUMBER":"SO83427"
,"PURCHASEORDERNUMBER":"PO99844396382"
,"ACCOUNTNUMBER":"10-4269-595724"
,"CUSTOMERID":1
,"SALESPERSONID":2
,"TERRITORYID":10
,"BILLTOADDRESSID":2
,"SHIPTOADDRESSID":2
,"SHIPMETHODID":2
,"CREDITCARDID":1
,"CREDITCARDAPPROVALCODE":"56696Vi73776"
,"CURRENCYRATEID":2
,"SUBTOTAL":40171.66
,"TAXAMT":3388.33
,"FREIGHT":328.83
,"TOTALDUE":43888.82
,"ROWGUID":"FBB5ED92-1233-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-11-17T04:23:30.643000000Z"
}
,{
"SALESORDERID":43590
,"REVISIONNUMBER":8
,"ORDERDATE":"2017-11-12T13:24:12Z"
,"DUEDATE":"2017-11-01T16:53:49.000000000Z"
,"SHIPDATE":"2018-05-27T22:04:22.000000000Z"
,"STATUS":5
,"ONLINEORDERFLAG":"1"
,"SALESORDERNUMBER":"SO61135"
,"PURCHASEORDERNUMBER":"PO88223285275"
,"ACCOUNTNUMBER":"10-4268-667562"
,"CUSTOMERID":1
,"SALESPERSONID":2
,"TERRITORYID":10
,"BILLTOADDRESSID":2
,"SHIPTOADDRESSID":2
,"SHIPMETHODID":2
,"CREDITCARDID":1
,"CREDITCARDAPPROVALCODE":"26518Vi98795"
,"CURRENCYRATEID":2
,"SUBTOTAL":15222.64
,"TAXAMT":1668.12
,"FREIGHT":152.77
,"TOTALDUE":17043.53
,"ROWGUID":"FBB5ED92-1234-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-08-14T12:51:27.878000000Z"
}
]
}
Salesorderheadersalesreason
Output similar to the SalesOrderHeaderSalesReason table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_SALESORDERID VARCHAR2 Y
DIST_SALESREASONID VARCHAR2 Y
Example output:
{
"salesorderheadersalesreason":[
{
"SALESORDERID":43589
,"SALESREASONID":1
,"MODIFIEDDATE":"2022-11-11T04:35:42.994000000Z"
}
,{
"SALESORDERID":43589
,"SALESREASONID":1
,"MODIFIEDDATE":"2022-07-06T05:58:28.776000000Z"
}
]
}
Salesperson
Output similar to the SalesPerson table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_BUSINESSENTITYI VARCHAR2 Y
DIST_TERRITORYID VARCHAR2 Y
Example output:
{
"salesperson":[
{
"BUSINESSENTITYID":1
,"TERRITORYID":9
,"BONUS":3600
,"COMMISSIONPCT":0.008
,"SALESYTD":1054637.68
,"SALESLASTYEAR":1341468.88
,"ROWGUID":"FBB5ED92-108C-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-02-11T04:57:15.684000000Z"
}
,{
"BUSINESSENTITYID":2
,"TERRITORYID":9
,"BONUS":6200
,"COMMISSIONPCT":0.008
,"SALESYTD":3941183.08
,"SALESLASTYEAR":774403.4
,"ROWGUID":"FBB5ED92-108D-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-07-26T16:33:01.730000000Z"
}
]
}
Salespersonquotahistory
Output similar to the SalesPersonQuotaHistory table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_BUSINESSENTITYI VARCHAR2 Y
Example output:
{
"salespersonquotahistory":[
{
"BUSINESSENTITYID":1
,"QUOTADATE":"2023-05-15T14:25:29Z"
,"SALESQUOTA":730863.37
,"ROWGUID":"FBB5ED92-116B-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-11-10T23:06:24.231000000Z"
}
,{
"BUSINESSENTITYID":1
,"QUOTADATE":"2023-05-21T14:25:29Z"
,"SALESQUOTA":337579.65
,"ROWGUID":"FBB5ED92-116C-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-09-19T06:17:39.765000000Z"
}
]
}
Salesreason
Output similar to the SalesReason table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"salesreason":[
{
"SALESREASONID":1
,"NAME":"Sponsorship"
,"REASONTYPE":"Other"
,"MODIFIEDDATE":"2022-09-23T16:53:49.682000000Z"
}
,{
"SALESREASONID":2
,"NAME":"Quality"
,"REASONTYPE":"Marketing"
,"MODIFIEDDATE":"2023-04-26T19:56:54.910000000Z"
}
]
}
Salestaxrate
Output similar to the SalesTaxRate table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_STATEPROVINCEID VARCHAR2 Y
Example output:
{
"salestaxrate":[
{
"SALESTAXRATEID":1
,"STATEPROVINCEID":1
,"TAXTYPE":3
,"TAXRATE":9.58
,"NAME":"Nauru Sales Tax"
,"ROWGUID":"FBB5ED92-10A0-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-04-14T10:08:11.601000000Z"
}
,{
"SALESTAXRATEID":2
,"STATEPROVINCEID":2
,"TAXTYPE":2
,"TAXRATE":7.32
,"NAME":"Micronesia Sales Tax"
,"ROWGUID":"FBB5ED92-10A1-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-04-01T21:53:21.101000000Z"
}
]
}
Salesterritory
Output similar to the SalesTerritory table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_COUNTRYREGIONCO VARCHAR2 Y
Example output:
{
"salesterritory":[
{
"TERRITORYID":9
,"COUNTRYREGIONCODE":"GY"
,"GROUP_R":"Caribbean"
,"SALESYTD":4069257.78
,"SALESLASTYEAR":2715644.81
,"COSTYTD":0
,"COSTLASTYEAR":0
,"ROWGUID":"FBB5ED92-0E87-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-10-24T15:58:00.978000000Z"
}
,{
"TERRITORYID":10
,"COUNTRYREGIONCODE":"PE"
,"GROUP_R":"Asia Pacific"
,"SALESYTD":8725023.98
,"SALESLASTYEAR":3281785.79
,"COSTYTD":0
,"COSTLASTYEAR":0
,"ROWGUID":"FBB5ED92-0E88-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-08-01T01:50:08.911000000Z"
}
]
}
Salesterritoryhistory
Output similar to the SalesTerritoryHistory table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_BUSINESSENTITYI VARCHAR2 Y
DIST_TERRITORYID VARCHAR2 Y
Example output:
{
"salesterritoryhistory":[
{
"BUSINESSENTITYID":2
,"TERRITORYID":10
,"STARTDATE":"2023-02-12T23:21:32Z"
,"ROWGUID":"FBB5ED92-1186-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-05-13T23:52:47.508000000Z"
}
,{
"BUSINESSENTITYID":2
,"TERRITORYID":9
,"STARTDATE":"2022-10-30T11:15:50Z"
,"ROWGUID":"FBB5ED92-1187-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-05-24T05:29:23.730000000Z"
}
]
}
Scrapreason
Output similar to the ScrapReason table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"scrapreason":[
{
"SCRAPREASONID":3
,"NAME":"The mammoth triangle pivad"
,"MODIFIEDDATE":"2022-10-16T03:40:49.678000000Z"
}
,{
"SCRAPREASONID":4
,"NAME":"The huge star we"
,"MODIFIEDDATE":"2022-11-04T13:38:57.743000000Z"
}
]
}
Shift
Output similar to the Shift table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"shift":[
{
"SHIFTID":2
,"NAME":"Evening"
,"STARTTIME":"22:41:36"
,"ENDTIME":"15:15:54"
,"MODIFIEDDATE":"2023-02-07T11:05:02.814000000Z"
}
,{
"SHIFTID":3
,"NAME":"Evening"
,"STARTTIME":"08:17:04"
,"ENDTIME":"14:16:12"
,"MODIFIEDDATE":"2022-08-28T19:59:48.293000000Z"
}
]
}
Shipmethod
Output similar to the ShipMethod table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"shipmethod":[
{
"SHIPMETHODID":1
,"NAME":"CBSL TRANSPORTATION SERVICES INC"
,"SHIPBASE":15.04
,"SHIPRATE":1.62
,"ROWGUID":"FBB5ED92-0DEB-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-03-03T01:52:34.940000000Z"
}
,{
"SHIPMETHODID":2
,"SHIPBASE":28.25
,"SHIPRATE":2.85
,"ROWGUID":"FBB5ED92-0DEC-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-10-18T05:41:13.420000000Z"
}
]
}
Shoppingcartitem
Output similar to the ShoppingCartItem table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_PRODUCTID VARCHAR2 Y
Example output:
{
"shoppingcartitem":[
{
"SHOPPINGCARTITEMID":2
,"SHOPPINGCARTID":15644
,"QUANTITY":8
,"PRODUCTID":2
,"DATECREATED":"2022-12-09T05:49:08.000000000Z"
,"MODIFIEDDATE":"2023-03-28T14:07:10.711000000Z"
}
,{
"SHOPPINGCARTITEMID":3
,"SHOPPINGCARTID":15644
,"QUANTITY":14
,"PRODUCTID":2
,"DATECREATED":"2022-10-10T15:23:13.000000000Z"
,"MODIFIEDDATE":"2022-11-22T23:36:16.787000000Z"
}
]
}
Specialoffer
Output similar to the SpecialOffer table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"specialoffer":[
{
"SPECIALOFFERID":1
,"DESCRIPTION":"The heavy square lihdo"
,"DISCOUNTPCT":0.16
,"TYPE":"Discontinued Product"
,"CATEGORY":"Reseller"
,"STARTDATE":"2022-10-28T11:12:36Z"
,"ENDDATE":"2023-07-04T03:59:52Z"
,"MINQTY":38
,"MAXQTY":29
,"ROWGUID":"FBB5ED92-0DFF-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-04-04T04:27:09.729000000Z"
}
,{
"SPECIALOFFERID":2
,"DESCRIPTION":"The strapping hexagon nenfiv"
,"DISCOUNTPCT":0.13
,"TYPE":"Excess Inventory"
,"CATEGORY":"Reseller"
,"STARTDATE":"2022-07-27T20:07:39Z"
,"ENDDATE":"2022-10-05T17:49:31Z"
,"MINQTY":15
,"ROWGUID":"FBB5ED92-0E00-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-11-18T06:21:16.273000000Z"
}
]
}
Specialofferproduct
Output similar to the SpecialOfferProduct table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_SPECIALOFFERID VARCHAR2 Y
DIST_PRODUCTID VARCHAR2 Y
Example output:
{
"specialofferproduct":[
{
"SPECIALOFFERID":2
,"PRODUCTID":2
,"ROWGUID":"FBB5ED92-10CC-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-04-25T18:36:36.855000000Z"
}
,{
"SPECIALOFFERID":2
,"PRODUCTID":2
,"ROWGUID":"FBB5ED92-10CD-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-01-02T02:52:13.995000000Z"
}
]
}
Stateprovince
Output similar to the StateProvince table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_COUNTRYREGIONCO VARCHAR2 Y
DIST_TERRITORYID VARCHAR2 Y
Example output:
{
"stateprovince":[
{
"STATEPROVINCEID":1
,"STATEPROVINCECODE":"CT"
,"COUNTRYREGIONCODE":"IC"
,"ISONLYSTATEPROVINCEFLAG":"0"
,"NAME":"South Dakota"
,"TERRITORYID":10
,"ROWGUID":"FBB5ED92-0F45-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-02-03T01:08:17.428000000Z"
}
,{
"STATEPROVINCEID":2
,"STATEPROVINCECODE":"ND"
,"COUNTRYREGIONCODE":"IC"
,"ISONLYSTATEPROVINCEFLAG":"0"
,"NAME":"South Carolina"
,"TERRITORYID":10
,"ROWGUID":"FBB5ED92-0F46-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-02-14T22:22:57.874000000Z"
}
]
}
Store
Output similar to the Store table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_BUSINESSENTITYI VARCHAR2 Y
DIST_SALESPERSONID VARCHAR2 Y
Example output:
{
"store":[
{
"BUSINESSENTITYID":1
,"NAME":"Ella Agency"
,"SALESPERSONID":2
,"DEMOGRAPHICS":"\u003C?xml version=\"1.0\"?\u003E\n\u003Cusers\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E1\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EMadison Sanchez\u003C\/name\u003E\n    \u003Cemail\u003Ewul@geli.org\u003C\/email\u003E\n    \u003Caddress\u003E159 Bu Pass\u003C\/address\u003E\n    \u003Czipcode\u003E19807\u003C\/zipcode\u003E\n    \u003Cstate\u003ENorth Carolina\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E2\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EJulian Kelly\u003C\/name\u003E\n    \u003Cemail\u003Epejvos@si.org\u003C\/email\u003E\n    \u003Caddress\u003E407 Kedka Pike\u003C\/address\u003E\n    \u003Czipcode\u003E60120\u003C\/zipcode\u003E\n    \u003Cstate\u003EMaine\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E3\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003ENatalie Cooper\u003C\/name\u003E\n    \u003Cemail\u003Ego@dil.mil\u003C\/email\u003E\n    \u003Caddress\u003E387 Lockiv Way\u003C\/address\u003E\n    \u003Czipcode\u003E29483\u003C\/zipcode\u003E\n    \u003Cstate\u003ENew Hampshire\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E4\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003ELillian Scott\u003C\/name\u003E\n    \u003Cemail\u003Ehowanno@pirre.gov\u003C\/email\u003E\n    \u003Caddress\u003E340 Wivmegtep Plaza\u003C\/address\u003E\n    \u003Czipcode\u003E30328\u003C\/zipcode\u003E\n    \u003Cstate\u003EOhio\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E5\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EKylie Walker\u003C\/name\u003E\n    \u003Cemail\u003Eluv@lemceb.int\u003C\/email\u003E\n    \u003Caddress\u003E293 Mam Junction\u003C\/address\u003E\n    \u003Czipcode\u003E53403\u003C\/zipcode\u003E\n    \u003Cstate\u003EMaine\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E6\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EJeremiah Walker\u003C\/name\u003E\n    \u003Cemail\u003Etelimew@fepimep.org\u003C\/email\u003E\n    \u003Caddress\u003E170 Ledof Loop\u003C\/address\u003E\n    \u003Czipcode\u003E36342\u003C\/zipcode\u003E\n    \u003Cstate\u003EMinnesota\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E7\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003ECarter Martin\u003C\/name\u003E\n    \u003Cemail\u003Ebelesmo@kisiw.net\u003C\/email\u003E\n    \u003Caddress\u003E321 Fonhofwi Loop\u003C\/address\u003E\n    \u003Czipcode\u003E60120\u003C\/zipcode\u003E\n    \u003Cstate\u003ENew York\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E8\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003ERyan Stewart\u003C\/name\u003E\n    \u003Cemail\u003Erapaj@ful.mil\u003C\/email\u003E\n    \u003Caddress\u003E90 Memem Manor\u003C\/address\u003E\n    \u003Czipcode\u003E23229\u003C\/zipcode\u003E\n    \u003Cstate\u003EIowa\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E9\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EAndrew Reed\u003C\/name\u003E\n    \u003Cemail\u003Ekocwo@jole.net\u003C\/email\u003E\n    \u003Caddress\u003E325 Dopgi Extension\u003C\/address\u003E\n    \u003Czipcode\u003E20857\u003C\/zipcode\u003E\n    \u003Cstate\u003EPennsylvania\u003C\/state\u003E\n  \u003C\/user\u003E\n\u003C\/users\u003E\n"
,"ROWGUID":"FBB5ED92-11A1-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2022-10-04T06:08:44.780000000Z"
}
,{
"BUSINESSENTITYID":2
,"NAME":"Sarah Chemicals"
,"SALESPERSONID":2
,"DEMOGRAPHICS":"\u003C?xml version=\"1.0\"?\u003E\n\u003Cusers\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E1\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EIan Lewis\u003C\/name\u003E\n    \u003Cemail\u003Efelgunib@cowawjuh.gov\u003C\/email\u003E\n    \u003Caddress\u003E485 Pev Way\u003C\/address\u003E\n    \u003Czipcode\u003E41011\u003C\/zipcode\u003E\n    \u003Cstate\u003EOklahoma\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E2\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EGavin Ramirez\u003C\/name\u003E\n    \u003Cemail\u003Ehivpadsid@sebumim.org\u003C\/email\u003E\n    \u003Caddress\u003E132 Nefek Heights\u003C\/address\u003E\n    \u003Czipcode\u003E68005\u003C\/zipcode\u003E\n    \u003Cstate\u003ETexas\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E3\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EMadeline Davis\u003C\/name\u003E\n    \u003Cemail\u003Ebefho@vo.net\u003C\/email\u003E\n    \u003Caddress\u003E61 Narvicwo Boulevard\u003C\/address\u003E\n    \u003Czipcode\u003E02138\u003C\/zipcode\u003E\n    \u003Cstate\u003EWashington\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E4\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EAllison Gray\u003C\/name\u003E\n    \u003Cemail\u003Ecog@je.mil\u003C\/email\u003E\n    \u003Caddress\u003E265 Ti View\u003C\/address\u003E\n    \u003Czipcode\u003E03839\u003C\/zipcode\u003E\n    \u003Cstate\u003ENew Jersey\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E5\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EAriana Wood\u003C\/name\u003E\n    \u003Cemail\u003Egeztivci@vila.mil\u003C\/email\u003E\n    \u003Caddress\u003E384 Witsu Circle\u003C\/address\u003E\n    \u003Czipcode\u003E83605\u003C\/zipcode\u003E\n    \u003Cstate\u003EColorado\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E6\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003ETrinity Ramirez\u003C\/name\u003E\n    \u003Cemail\u003Eko@kum.mil\u003C\/email\u003E\n    \u003Caddress\u003E112 Suhe Street\u003C\/address\u003E\n    \u003Czipcode\u003E64154\u003C\/zipcode\u003E\n    \u003Cstate\u003ETennessee\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E7\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EGavin Butler\u003C\/name\u003E\n    \u003Cemail\u003Egende@fejif.net\u003C\/email\u003E\n    \u003Caddress\u003E87 Fip Pass\u003C\/address\u003E\n    \u003Czipcode\u003E39287\u003C\/zipcode\u003E\n    \u003Cstate\u003ENevada\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E8\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EJuan Walker\u003C\/name\u003E\n    \u003Cemail\u003Ekifoj@pigmep.mil\u003C\/email\u003E\n    \u003Caddress\u003E89 Zuhzo Manor\u003C\/address\u003E\n    \u003Czipcode\u003E01608\u003C\/zipcode\u003E\n    \u003Cstate\u003ENebraska\u003C\/state\u003E\n  \u003C\/user\u003E\n  \u003Cuser\u003E\n    \u003Cuser_id\u003E9\u003C\/user_id\u003E\n    \u003Ccreate_date\u003E2023-05-15\u003C\/create_date\u003E\n    \u003Cname\u003EBrayden Moore\u003C\/name\u003E\n    \u003Cemail\u003Elohhem@gorce.mil\u003C\/email\u003E\n    \u003Caddress\u003E251 Fewu Glen\u003C\/address\u003E\n    \u003Czipcode\u003E23605\u003C\/zipcode\u003E\n    \u003Cstate\u003ENorth Dakota\u003C\/state\u003E\n  \u003C\/user\u003E\n\u003C\/users\u003E\n"
,"ROWGUID":"FBB5ED92-11A2-F791-E053-1910000A691B"
,"MODIFIEDDATE":"2023-04-09T04:27:22.992000000Z"
}
]
}
Transactionhistory
Output similar to the TransactionHistory table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_PRODUCTID VARCHAR2 Y
Example output:
{
"transactionhistory":[
{
"TRANSACTIONID":108481
,"PRODUCTID":2
,"REFERENCEORDERID":45000
,"REFERENCEORDERLINEID":13
,"TRANSACTIONDATE":"2022-09-06T09:07:59Z"
,"TRANSACTIONTYPE":"S"
,"QUANTITY":2
,"ACTUALCOST":1714.43
,"MODIFIEDDATE":"2023-02-26T06:36:53.547000000Z"
}
,{
"TRANSACTIONID":109672
,"PRODUCTID":2
,"REFERENCEORDERID":45000
,"REFERENCEORDERLINEID":13
,"TRANSACTIONDATE":"2023-04-28T06:45:43Z"
,"TRANSACTIONTYPE":"S"
,"QUANTITY":15
,"ACTUALCOST":238.17
,"MODIFIEDDATE":"2022-08-11T16:31:37.651000000Z"
}
]
}
Transactionhistoryarchive
Output similar to the TransactionHistoryArchive table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"transactionhistoryarchive":[
{
"TRANSACTIONID":15
,"PRODUCTID":136
,"REFERENCEORDERID":250
,"REFERENCEORDERLINEID":12
,"TRANSACTIONDATE":"2022-11-05T14:57:48Z"
,"TRANSACTIONTYPE":"S"
,"QUANTITY":5
,"ACTUALCOST":2184.66
,"MODIFIEDDATE":"2022-06-10T00:46:35.201000000Z"
}
,{
"TRANSACTIONID":20
,"PRODUCTID":830
,"REFERENCEORDERID":254
,"REFERENCEORDERLINEID":12
,"TRANSACTIONDATE":"2023-03-18T08:37:13Z"
,"TRANSACTIONTYPE":"S"
,"QUANTITY":3
,"ACTUALCOST":0
,"MODIFIEDDATE":"2022-07-16T08:44:52.175000000Z"
}
]
}
Unitmeasure
Output similar to the UnitMeasure table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
Example output:
{
"unitmeasure":[
{
"UNITMEASURECODE":"GAL"
,"NAME":"Gallon"
,"MODIFIEDDATE":"2023-02-27T04:52:04.000000000Z"
}
,{
"UNITMEASURECODE":"CM2"
,"NAME":"Square centimeter"
,"MODIFIEDDATE":"2022-10-21T21:08:48.408000000Z"
}
]
}
Vendor
Output similar to the Vendor table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_BUSINESSENTITYI VARCHAR2 Y
Example output:
{
"vendor":[
{
"BUSINESSENTITYID":1
,"ACCOUNTNUMBER":"JULIINDU0073"
,"NAME":"Julia Industries"
,"CREDITRATING":2
,"PREFERREDVENDORSTATUS":"0"
,"ACTIVEFLAG":"1"
,"MODIFIEDDATE":"2023-02-20T12:28:41.669000000Z"
}
,{
"BUSINESSENTITYID":2
,"ACCOUNTNUMBER":"DIEGASSO0013"
,"NAME":"Diego Associates"
,"CREDITRATING":1
,"PREFERREDVENDORSTATUS":"1"
,"ACTIVEFLAG":"1"
,"MODIFIEDDATE":"2022-06-24T05:59:50.148000000Z"
}
]
}
Workorder
Output similar to the WorkOrder table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_PRODUCTID VARCHAR2 Y
DIST_SCRAPREASONID VARCHAR2 Y
Example output:
{
"workorder":[
{
"WORKORDERID":1
,"PRODUCTID":2
,"ORDERQTY":108
,"STOCKEDQTY":108
,"SCRAPPEDQTY":0
,"STARTDATE":"2023-03-17T04:12:45.000000000Z"
,"ENDDATE":"2024-02-22T12:39:12.000000000Z"
,"DUEDATE":"2024-09-22T20:18:12.000000000Z"
,"SCRAPREASONID":4
,"MODIFIEDDATE":"2022-06-13T14:46:11.799000000Z"
}
,{
"WORKORDERID":2
,"PRODUCTID":2
,"ORDERQTY":46
,"STOCKEDQTY":46
,"SCRAPPEDQTY":0
,"STARTDATE":"2022-10-05T11:03:00.000000000Z"
,"ENDDATE":"2022-10-07T20:35:42.000000000Z"
,"DUEDATE":"2023-02-24T07:03:15.000000000Z"
,"SCRAPREASONID":4
,"MODIFIEDDATE":"2022-10-03T12:07:56.291000000Z"
}
]
}
Workorderrouting
Output similar to the WorkOrderRouting table from the AdventureWorks sample database.
Parameters:
Name Type Default Default Value
DIST_WORKORDERID VARCHAR2 Y
DIST_LOCATIONID VARCHAR2 Y
Example output:
{
"workorderrouting":[
{
"WORKORDERID":1
,"PRODUCTID":635
,"OPERATIONSEQUENCE":2
,"LOCATIONID":1
,"SCHEDULEDSTARTDATE":"2022-08-17T20:15:44Z"
,"SCHEDULEDENDDATE":"2023-06-23T04:29:24Z"
,"ACTUALSTARTDATE":"2023-03-28T01:05:21Z"
,"ACTUALENDDATE":"2024-01-23T17:55:08Z"
,"ACTUALRESOURCEHRS":4.13
,"PLANNEDCOST":56.17
,"ACTUALCOST":56.17
,"MODIFIEDDATE":"2022-08-26T07:52:45.183000000Z"
}
,{
"WORKORDERID":2
,"PRODUCTID":639
,"OPERATIONSEQUENCE":2
,"LOCATIONID":1
,"SCHEDULEDSTARTDATE":"2023-03-07T16:26:10Z"
,"SCHEDULEDENDDATE":"2023-04-22T21:22:39Z"
,"ACTUALSTARTDATE":"2023-06-22T16:09:15Z"
,"ACTUALENDDATE":"2023-06-02T02:54:40Z"
,"ACTUALRESOURCEHRS":3.83
,"PLANNEDCOST":27.21
,"ACTUALCOST":27.21
,"MODIFIEDDATE":"2022-08-26T14:20:39.750000000Z"
}
]
}

Anchor Points

On this page