biuan SAP® BUSINESS ONE SDK
API OINS / / Customer Equipment Cards
OINS - Customer Equipment Card Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
insID KEY UNIQUEEquipment Card No.Int
11
PRIMARYYes
customer KEYCustomer CodenVarChar
15OCRD
Business Partner
C_ITM_SN_SNo
custmrNameCustomer NamenVarChar
100
contactCodContact Person CodeInt
11OCPR
Contact Persons
directCsmrDirect CustomernVarChar
15
drctCsmNamDirect Customer NamenVarChar
100
manufSNMfr Serial No.nVarChar
36
internalSNSerial NumbernVarChar
36
warrantyWarrantyVarChar
Y) Yes
N) No
1
N
wrrntyStrtWarranty Start DateDate
8
wrrntyEndWarranty End DateDate
8
responsValTime Required for ResponseInt
6
responsUntTime UnitVarChar
H) Hour(s)
D) Day(s)
1
D
itemCode KEYItem No.nVarChar
20OITM
Items
ITM_INTSNNo
itemNameItem DescriptionnVarChar
100
itemGroupItem GroupInt
6OITB
Item Groups
manufDateManufacture DateDate
8
deliveryDelivery KeyInt
11ODLN
Delivery
deliveryNoDelivery NumberInt
11
invoiceInvoice KeyInt
11OINV
A/R Invoice
invoiceNumInvoice NumberInt
11
dlvryDateDelivery DateDate
8
cntctPhoneContact PhonenVarChar
20
streetStreetnVarChar
100
blockBlocknVarChar
100
zipZip CodenVarChar
20
cityCitynVarChar
100
countyCountynVarChar
100
countryCountrynVarChar
3OCRY
Countries
stateStatenVarChar
3OCST
States
instLctionInstallation LocationnVarChar
127
contractContractInt
11OCTR
Service Contracts
cntrctStrtContract Start DateDate
8
cntrctEndContract End DateDate
8
attachmentAttachmentsText
16
objTypeObject TypenVarChar
20
176
logInstancLog InstanceInt
11
userSignCreating UserInt
6OUSR
Users
createDateCreation DateDate
8
userSign2Updating UserInt
6OUSR
Users
updateDateDate of UpdateDate
8
BuildingBuilding/Floor/RoomText
16
statusStatusVarChar
A) Active
R) Returned
T) Terminated
L) Loaned
I) In Repair Lab
1
A
replcInsThe CEC this replacedInt
11OINS
Customer Equipment Card
repByInsThe CEC this is replaced byInt
11OINS
Customer Equipment Card
technicianDefault TechnicianInt
11OHEM
Employees
territoryDefault TerritoryInt
11OTER
Territories
AtcEntryAttachment EntryInt
11OATC
Attachments
TransferedYear TransferVarChar
1
N
AddrTypeAddress TypenVarChar
100
InstanceInstanceInt
6
0
StreetNoStreet No.nVarChar
100

Table relationship map

SELECT statement

SELECT OINS.insID AS 'Equipment Card No.', OINS.customer AS 'Customer Code', OINS.custmrName AS 'Customer Name', OINS.contactCod AS 'Contact Person Code', OINS.directCsmr AS 'Direct Customer', OINS.drctCsmNam AS 'Direct Customer Name', OINS.manufSN AS 'Mfr Serial No.', OINS.internalSN AS 'Serial Number', OINS.warranty AS 'Warranty', OINS.wrrntyStrt AS 'Warranty Start Date', OINS.wrrntyEnd AS 'Warranty End Date', OINS.responsVal AS 'Time Required for Response', OINS.responsUnt AS 'Time Unit', OINS.itemCode AS 'Item No.', OINS.itemName AS 'Item Description', OINS.itemGroup AS 'Item Group', OINS.manufDate AS 'Manufacture Date', OINS.delivery AS 'Delivery Key', OINS.deliveryNo AS 'Delivery Number', OINS.invoice AS 'Invoice Key', OINS.invoiceNum AS 'Invoice Number', OINS.dlvryDate AS 'Delivery Date', OINS.cntctPhone AS 'Contact Phone', OINS.street AS 'Street', OINS.block AS 'Block', OINS.zip AS 'Zip Code', OINS.city AS 'City', OINS.county AS 'County', OINS.country AS 'Country', OINS.state AS 'State', OINS.instLction AS 'Installation Location', OINS.contract AS 'Contract', OINS.cntrctStrt AS 'Contract Start Date', OINS.cntrctEnd AS 'Contract End Date', OINS.attachment AS 'Attachments', OINS.objType AS 'Object Type', OINS.logInstanc AS 'Log Instance', OINS.userSign AS 'Creating User', OINS.createDate AS 'Creation Date', OINS.userSign2 AS 'Updating User', OINS.updateDate AS 'Date of Update', OINS.Building AS 'Building/Floor/Room', OINS.status AS 'Status', OINS.replcIns AS 'The CEC this replaced', OINS.repByIns AS 'The CEC this is replaced by', OINS.technician AS 'Default Technician', OINS.territory AS 'Default Territory', OINS.AtcEntry AS 'Attachment Entry', OINS.Transfered AS 'Year Transfer', OINS.AddrType AS 'Address Type', OINS.Instance AS 'Instance', OINS.StreetNo AS 'Street No.' FROM OINS AS OINS

Related information


Customer Equipment Cards CustomerEquipmentCards Object· Table: OINS
CustomerEquipmentCards is a business object that represents the customer equipment cards in the Services module. This object enables you to: Add a customer equipment card. Retrieve a customer equipment card by its key. Update a customer...


Document Installments Document_Installments Object
A child object of Documents object representing the installments feature in marketing documents. Source tables:  INV6, OPCH6.
   Parent: Documents Documents Object· Table: OIGE OIGN
Customer Equipment Card OINS SQL Table

Attachments OATC SQL Table

Contact Persons OCPR SQL Table

Service Contracts OCTR SQL Table

Countries OCRY SQL Table

Business Partner OCRD SQL Table

Delivery ODLN SQL Table

A/R Invoice OINV SQL Table

Items OITM SQL Table

Item Groups OITB SQL Table

States OCST SQL Table

Employees OHEM SQL Table

Territories OTER SQL Table

Users OUSR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates