Sample Data to Create a Schema
Use the data below to create a CSV file to upload when creating a schema.
|
#Address (US~State~City~Address_ent~Address_org~Address_site~Street1~Street2~Street3~Zip~Latitude~Longitude~Time_zone) |
Alternate Address 1 (US~State~City~Address_ent~Address_org~Address_site~Street1~Street2~Street3~Zip~Latitude~Longitude~Time_zone) |
Alternate Address 2 (US~State~City~Address_ent~Address_org~Address_site~Street1~Street2~Street3~Zip~Latitude~Longitude~Time_zone) |
Contact |
* Creation Date (yyyy-MM-dd'T'HH:mm:ssZ) |
* Creation User |
Description |
Display Name |
* Enterprise Name |
External Ref No |
Last Computed Date (yyyy-MM-dd'T'HH:mm:ssZ) |
* Last Modified Date (yyyy-MM-dd'T'HH:mm:ssZ) |
* Last Modified User |
Latitude (#,###.###) |
Longitude (#,###.###) |
* Name |
* Organization Name |
Run Replenishment (0 or 1 [0=false, 1=true]) |
Activation Date (yyyy-MM-dd'T'HH:mm:ssZ) |
Authoritative Level (AUTHORITATIVE, NON_AUTHORITATIVE) |
Auto Gen Buffer (0 or 1 [0=false, 1=true]) |
Bar Code Delimiter |
Bar Code Format |
Bar Code Prefixing (0 or 1 [0=false, 1=true]) |
Billing Contact Email |
Billing Contact Fax |
Billing Contact Mobile |
Billing Contact Name |
Billing Contact Ph Num |
County |
Deactivation Date (yyyy-MM-dd'T'HH:mm:ssZ) |
Holiday Calendar Name |
Is Billing (0 or 1 [0=false, 1=true]) |
Is DC (0 or 1 [0=false, 1=true]) |
Is Plant (0 or 1 [0=false, 1=true]) |
Is Primary Sub Site (0 or 1 [0=false, 1=true]) |
Is Public (0 or 1 [0=false, 1=true]) |
Is Shipping (0 or 1 [0=false, 1=true]) |
Is Store (0 or 1 [0=false, 1=true]) |
Managing Org Enterprise Name |
Managing Org Name |
Parent Site Name |
Parent Site Organization Enterprise Name |
Parent Site Organization Name |
Primary Sub Site Name |
Receiving Calendar Name |
Receiving Contact Email |
Receiving Contact Fax |
Receiving Contact Mobile |
Receiving Contact Name |
Receiving Contact Ph Num |
Shipping Calendar Name |
Shipping Contact Email |
Shipping Contact Fax |
Shipping Contact Mobile |
Shipping Contact Name |
Shipping Contact Phone Num |
Transportation Instructions |
Trans Site Group Name |
Trans Site Group Organization Enterprise Name |
Trans Site Group Organization Name |
Appt Scheduling System |
Appt Scheduling System Changed Date (yyyy-MM-dd'T'HH:mm:ssZ) |
Enable Soft Appointments (0 or 1 [0=false, 1=true]) |
Site Group Name |
Tier |
Time Zone Id |
Default Dock Door Count (#,###) |
Notify VASP |
Type Name |
Allowed Detention Time (#,###) |
|
US~MI~Waterford~~~~92 Kirkland Road~~~48329~~~ |
Rita Bailey |
2022-08-10T11:03:51-0400 |
DefaultONEIValueChainAdmin |
Site 23 |
HUB4 |
|
|
2022-08-10T11:03:51-0400 |
DefaultONEIValueChainAdmin |
Site 23 |
HUB4 |
0 |
2022-08-10T11:03:51-0400 |
AUTHORITATIVE |
0 |
|
|
0 |
|
|
|
|
|
|
|
|
0 |
1 |
0 |
0 |
1 |
0 |
0 |
HUB4 |
HUB4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
Standard Site |
|
|
|
|
|
|
|
US~VA~Lynchburg~~~~20 Summit Street~~~24502~~~ |
Hugo Lee |
2022-08-10T11:03:51-0400 |
DefaultONEIValueChainAdmin |
Site 22A |
HUB4 |
|
|
2022-08-10T11:03:51-0400 |
DefaultONEIValueChainAdmin |
Site 22A |
HUB4 |
0 |
2022-08-10T11:03:51-0400 |
AUTHORITATIVE |
0 |
|
|
0 |
|
|
|
|
|
|
|
|
0 |
1 |
0 |
0 |
1 |
0 |
0 |
HUB4 |
HUB4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
Standard Site |
|
|
|
|
|
|
|
US~MI~Jenison~~~~394 Meadow Court~~~49428~~~ |
Marsha Oliver |
2022-08-10T11:03:51-0400 |
DefaultONEIValueChainAdmin |
Site 46 |
HUB4 |
|
|
2022-08-10T11:03:51-0400 |
DefaultONEIValueChainAdmin |
Site 46 |
HUB4 |
0 |
2022-08-10T11:03:51-0400 |
AUTHORITATIVE |
0 |
|
|
0 |
|
|
|
|
|
|
|
|
0 |
1 |
0 |
0 |
1 |
0 |
0 |
HUB4 |
HUB4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
Standard Site |
|
|
|
|
|
|
|
US~IL~Calumet City~~~~443 Orchard Drive~~~60409~~~ |
Dwayne Allen |
2022-08-10T11:03:51-0400 |
DefaultONEIValueChainAdmin |
Site 2B |
HUB4 |
|
|
2022-08-10T11:03:51-0400 |
DefaultONEIValueChainAdmin |
Site 2B |
HUB4 |
0 |
2022-08-10T11:03:51-0400 |
AUTHORITATIVE |
0 |
|
|
0 |
|
|
|
|
|
|
|
|
0 |
1 |
0 |
0 |
1 |
0 |
0 |
HUB4 |
HUB4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
Standard Site |
|
|
|
|
|
|
|
US~MD~Pasadena~~~~2 Park Circle~~~21122~~~ |
Arturo Mendoza |
2022-08-10T11:03:51-0400 |
DefaultONEIValueChainAdmin |
Site 6C |
HUB4 |
|
|
2022-08-10T11:03:51-0400 |
DefaultONEIValueChainAdmin |
Site 6C |
HUB4 |
0 |
2022-08-10T11:03:51-0400 |
AUTHORITATIVE |
0 |
|
|
0 |
|
|
|
|
|
|
|
|
0 |
1 |
0 |
0 |
1 |
0 |
0 |
HUB4 |
HUB4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
Standard Site |
|
|
|
|
|
|
|
US~FL~Palm Harbor~~~~9328 Edgemont Drive~~~34683~~~ |
Gene Tate |
2022-08-10T11:03:51-0400 |
DefaultONEIValueChainAdmin |
Site A3 |
HUB4 |
|
|
2022-08-10T11:03:51-0400 |
DefaultONEIValueChainAdmin |
Site A3 |
HUB4 |
0 |
2022-08-10T11:03:51-0400 |
AUTHORITATIVE |
0 |
|
|
0 |
|
|
|
|
|
|
|
|
0 |
1 |
0 |
0 |
1 |
0 |
0 |
HUB4 |
HUB4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
Standard Site |
|
|
|
|
|
|
|
US~GA~Stone Mountain~~~~732 Atlantic Street~~~30083~~~ |
Mae Underwood |
2022-08-10T11:03:51-0400 |
DefaultONEIValueChainAdmin |
Site A4 |
HUB4 |
|
|
2022-08-10T11:03:51-0400 |
DefaultONEIValueChainAdmin |
Site A4 |
HUB4 |
0 |
2022-08-10T11:03:51-0400 |
AUTHORITATIVE |
0 |
|
|
0 |
|
|
|
|
|
|
|
|
0 |
1 |
0 |
0 |
1 |
0 |
0 |
HUB4 |
HUB4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
Standard Site |
|
|
|
|
|
|
|
US~NY~West Islip~~~~54 Shipley Avenue~~~11795~~~ |
Ashley Garcia |
2022-08-10T11:03:51-0400 |
DefaultONEIValueChainAdmin |
Site A5 |
HUB4 |
|
|
2022-08-10T11:03:51-0400 |
DefaultONEIValueChainAdmin |
Site A5 |
HUB4 |
0 |
2022-08-10T11:03:51-0400 |
AUTHORITATIVE |
0 |
|
|
0 |
|
|
|
|
|
|
|
|
0 |
1 |
0 |
0 |
1 |
0 |
0 |
HUB4 |
HUB4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
Standard Site |
|
|
|
|
|
|
|
US~WI~Milwaukee~~~~7068 Fairfield Lane~~~53204~~~ |
Cory Stephens |
2022-08-10T11:03:51-0400 |
DefaultONEIValueChainAdmin |
Site 77 |
HUB4 |
|
|
2022-08-10T11:03:51-0400 |
DefaultONEIValueChainAdmin |
Site 77 |
HUB4 |
0 |
2022-08-10T11:03:51-0400 |
AUTHORITATIVE |
0 |
|
|
0 |
|
|
|
|
|
|
|
|
0 |
1 |
0 |
0 |
1 |
0 |
0 |
HUB4 |
HUB4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
Standard Site |
|
|
|
|
|
|