INVENTORY_TRANSACTIONS

This API returns CAS Inventory Transaction information based on request.

Base URL: /domains/erp/fs/inventory_transactions

Version: v1

Default response content-types: application/json

Schemes: https

Summary

Path	Operation	Description
/*	GET

Paths

GET /*


item_id	Item ID	query	string (1 to 30 chars)
serial_id	Serial ID	query	string (1 to 30 chars)
item_group	Item Group	query	string (1 to 30 chars)
category_code	Category	query	string (1 to 30 chars)
cas_id	CAS Registry Number	query	string (1 to 60 chars)
transaction_type	Transaction Type	query	string (1 to 30 chars)
effective_date	Effective Date	query	string (1 to 10 chars)

Uses default content-types: application/json

200 OK

The default response type is JSON. Add an Accept header with value=application/xml to return an XML response.

inventory_transactions

Example for application/json

{
    "inventory_transactions": {
        "inventory_transaction": [
            {
                "cas_registry_number": "71-43-2",
                "category_code": "CH01",
                "category_id": "00255",
                "customer_name": "Mouse, Mickey",
                "item_description": "BENZENE, HPLC (1 LT)",
                "item_group": "CHEMS CH",
                "item_id": "000000000000005759",
                "item_received_date": "2017-01-20",
                "item_serial_id": "BYUCS00FEB",
                "item_unit_of_measure": "LT",
                "msr_number": "MSR0094564",
                "net_id": "xxxxxxxx",
                "po_id": {
                },
                "product_family_code": "CHEMICALS",
                "storage_location": "V-J-04",
                "storage_transfer_location": "C437 BNSN-Provo, UT  84602",
                "transaction_adjustment_description": {
                },
                "transaction_adjustment_type": {
                },
                "transaction_datetime": "2017-02-01 10:02:09",
                "transaction_line_number": "2",
                "transaction_line_quantity": "1.0000",
                "transaction_type": "Sale",
                "transaction_type_id": "030"
            },
            {
                "cas_registry_number": "67-63-0",
                "category_code": "CH01",
                "category_id": "00255",
                "customer_name": "Duck, Daisy",
                "item_description": "iso-PROPYL ALCOHOL (4 LT)",
                "item_group": "CHEMS CH",
                "item_id": "000000000000006746",
                "item_received_date": "2016-11-30",
                "item_serial_id": "BYUCS00EWD",
                "item_unit_of_measure": "LT",
                "msr_number": "MSR0094565",
                "net_id": "xxxxxxxx",
                "po_id": {
                },
                "product_family_code": "CHEMICALS",
                "storage_location": "V-U-04",
                "storage_transfer_location": "S161 ESC-Provo, UT  84602",
                "transaction_adjustment_description": {
                },
                "transaction_adjustment_type": {
                },
                "transaction_datetime": "2017-02-01 10:08:38",
                "transaction_line_number": "1",
                "transaction_line_quantity": "1.0000",
                "transaction_type": "Sale",
                "transaction_type_id": "030"
            }
        ]
    }
}

Schema definitions

cas_registry_number: string (up to 30 chars)

category_code: string (up to 18 chars)

category_id: string (up to 5 chars)

customer_name: string (up to 30 chars)

description: string (up to 60 chars)

error: string , x ∈ { 400 }

inventory_transaction: object

item_id: item_id
item_description: item_description
item_group: item_group
product_family_code: product_family_code
category_id: category_id
category_code: category_code
cas_registry_number: cas_registry_number
transaction_type_id: transaction_type_id
transaction_type: transaction_type
transaction_datetime: transaction_datetime
transaction_line_quantity: transaction_line_quantity
item_unit_of_measure: item_unit_of_measure
item_received_date: item_received_date
item_serial_id: item_serial_id
storage_location: storage_location
storage_transfer_location: storage_transfer_location
msr_number: msr_number
transaction_line_number: transaction_line_number
customer_name: customer_name
net_id: net_id
transaction_adjustment_type: transaction_adjustment_type
transaction_adjustment_description: transaction_adjustment_description
po_id: po_id

inventory_transactions: object[]

inventory_transaction

item_description: string (up to 60 chars)

item_group: string (up to 15 chars)

item_id: string (up to 18 chars)

item_received_date: string (date)

item_serial_id: string (up to 20 chars)

item_unit_of_measure: string (up to 3 chars)

msr_number: string (up to 10 chars)

net_id: string (up to 30 chars)

po_id: string (up to 10 chars)

product_family_code: string (up to 10 chars)

storage_location: string (up to 60 chars)

storage_transfer_location: string (up to 60 chars)

transaction_adjustment_description: string (up to 254 chars)

transaction_adjustment_type: string (up to 1 chars)

transaction_datetime: string (date-time)

transaction_line_number: integer (int32)

transaction_line_quantity: number (double)

transaction_type: string (up to 25 chars)

transaction_type_id: string (up to 3 chars)

Service Path:

/domains/erp/fs/inventory_transactions

Domain or University API: