Tplcentral

Tables in the Tplcentral connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	stock_details	33	_id	Full Refresh, Incremental	_cursor
2	orders	36	_id	Full Refresh, Incremental	_cursor	API Reference
3	customers	11	_id	Full Refresh		API Reference
4	inventory	47	_id	Full Refresh, Incremental	_cursor	API Reference
5	items	21	_id	Full Refresh, Incremental	_cursor	API Reference
6	stock_summaries	9	FacilityId, _item_identifier_id	Full Refresh

Table: stock_details

No	Column Name	Type	Notes
1	ReceiverId	INTEGER
2	Description	VARCHAR
3	Upc	VARCHAR
4	IsOnHold	BOOLEAN
5	InventoryUnitOfMeasureIdentifier	VARCHAR
6	ReferenceNum	VARCHAR
7	Cost	DOUBLE
8	Description2	VARCHAR
9	SecondaryUnitOfMeasureIdentifier	VARCHAR
10	WeightMetric	DOUBLE
11	ItemIdentifier	VARCHAR
12	InventoryUnitsPerSecondaryUnit	DOUBLE
13	WeightImperial	DOUBLE
14	Qualifier	VARCHAR
15	Available	DOUBLE
16	LotNumber	VARCHAR
17	SupplierIdentifier	VARCHAR
18	SecondaryReceived	DOUBLE
19	TrailerNumber	VARCHAR
20	Received	DOUBLE
21	PalletIdentifier	VARCHAR
22	Quarantined	BOOLEAN
23	OnHand	DOUBLE
24	ReceivedDate	VARCHAR
25	_cursor	VARCHAR	Incremental sync key
26	SerialNumber	VARCHAR
27	ExpirationDate	VARCHAR
28	_id	INTEGER	Primary Key
29	LocationIdentifier	VARCHAR
30	SavedElements	VARCHAR
31	SecondaryAvailable	DOUBLE
32	PoNum	VARCHAR
33	ReceiveItemId	INTEGER

Table: orders

No	Column Name	Type	Notes
1	RoutePickupDate	VARCHAR
2	ShippingNotes	VARCHAR
3	OrderItems	VARCHAR
4	Description	VARCHAR
5	ParcelOption	VARCHAR
6	EarliestShipDate	VARCHAR
7	BillingCode	VARCHAR
8	UpsServiceOptionCharge	DOUBLE
9	ReferenceNum	VARCHAR
10	Unit1Identifier	VARCHAR
11	MasterBillOfLadingId	VARCHAR
12	UpsIsResidential	BOOLEAN
13	BillTo	VARCHAR
14	InvoiceNumber	VARCHAR
15	Notes	VARCHAR
16	ReadOnly	VARCHAR
17	ExternalId	VARCHAR
18	ExportChannelIdentifier	VARCHAR
19	FulfillInvInfo	VARCHAR
20	ShipCancelDate	VARCHAR
21	RoutingInfo	VARCHAR
22	TotalWeight	DOUBLE
23	_cursor	VARCHAR	Incremental sync key
24	AsnNumber	VARCHAR
25	Billing	VARCHAR
26	AddFreightToCod	BOOLEAN
27	TotalVolume	DOUBLE
28	UpsTransportationCharge	DOUBLE
29	ShipTo	VARCHAR
30	_id	INTEGER	Primary Key
31	SavedElements	VARCHAR
32	PoNum	VARCHAR
33	NumUnits1	DOUBLE
34	SoldTo	VARCHAR
35	NumUnits2	DOUBLE
36	Unit2Identifier	VARCHAR

Table: customers

No	Column Name	Type	Notes
1	ReadOnly	VARCHAR
2	Options	VARCHAR
3	OtherContacts	VARCHAR
4	Groups	VARCHAR
5	ExternalId	VARCHAR
6	PrimaryFacilityIdentifier	VARCHAR
7	WebSite	VARCHAR
8	_id	INTEGER	Primary Key
9	CompanyInfo	VARCHAR
10	PrimaryContact	VARCHAR
11	Facilities	VARCHAR

Table: inventory

No	Column Name	Type	Notes
1	ReceiverId	INTEGER
2	OnHoldReason	VARCHAR
3	SecondaryAvailableQty	DOUBLE
4	SecondaryOnHoldQty	DOUBLE
5	WeightImperialOnHand	DOUBLE
6	CustomerIdentifier	VARCHAR
7	Upc	VARCHAR
8	OnHoldDate	VARCHAR
9	InventoryUnitOfMeasureIdentifier	VARCHAR
10	WeightMetricOnHand	DOUBLE
11	ReferenceNum	VARCHAR
12	ItemDescription	VARCHAR
13	Cost	DOUBLE
14	AvailableQty	DOUBLE
15	OnHoldUserIdentifier	VARCHAR
16	Description2	VARCHAR
17	SecondaryUnitOfMeasureIdentifier	VARCHAR
18	WeightMetric	DOUBLE
19	ItemIdentifier	VARCHAR
20	OnHoldQty	DOUBLE
21	InventoryUnitsPerSecondaryUnit	DOUBLE
22	WeightImperial	DOUBLE
23	Qualifier	VARCHAR
24	LotNumber	VARCHAR
25	SupplierIdentifier	VARCHAR
26	OnHold	BOOLEAN
27	WeightMetricAvailable	DOUBLE
28	FacilityIdentifier	VARCHAR
29	ReceivedQty	DOUBLE
30	TrailerNumber	VARCHAR
31	OnHandQty	DOUBLE
32	PalletIdentifier	VARCHAR
33	SecondaryOnHandQty	DOUBLE
34	SecondaryReceivedQty	DOUBLE
35	Quarantined	BOOLEAN
36	ReceivedDate	VARCHAR
37	_cursor	VARCHAR	Incremental sync key
38	SerialNumber	VARCHAR
39	ExpirationDate	VARCHAR
40	RowVersion	VARCHAR
41	WeightImperialAvailable	DOUBLE
42	_id	INTEGER	Primary Key
43	SavedElements	VARCHAR
44	LocationIdentifier	VARCHAR
45	StockRowVersion	VARCHAR
46	PoNum	VARCHAR
47	ReceiveItemId	INTEGER

Table: items

No	Column Name	Type	Notes
1	ReadOnly	VARCHAR
2	HarmonizedCode	VARCHAR
3	Options	VARCHAR
4	Temperature	DOUBLE
5	Description	VARCHAR
6	ClassificationIdentifier	VARCHAR
7	Upc	VARCHAR
8	AccountRef	VARCHAR
9	CountryOfManufacture	VARCHAR
10	ItemId	INTEGER
11	Cost	DOUBLE
12	Description2	VARCHAR
13	QualifierRenamers	VARCHAR
14	_cursor	VARCHAR	Incremental sync key
15	Price	DOUBLE
16	Kit	VARCHAR
17	Nmfc	VARCHAR
18	InventoryCategory	VARCHAR
19	_id	INTEGER	Primary Key
20	Qualifiers	VARCHAR
21	Sku	VARCHAR

Table: stock_summaries

No	Column Name	Type	Notes
1	_item_identifier_id	INTEGER	Primary Key
2	OnHold	DOUBLE
3	OnHand	DOUBLE
4	FacilityId	INTEGER	Primary Key
5	ItemIdentifier	VARCHAR
6	Qualifier	VARCHAR
7	Available	DOUBLE
8	TotalReceived	DOUBLE
9	Allocated	DOUBLE

External Resources

• Stocksummaries
• Stockdetails
• How To Get Your Apis Credentials

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.