|
|
API SITM
SITM - Items Table
SITM SQL Table
Asset Classes OACS SQL Table
Asset Groups OAGS SQL Table
Brazil String Indexer OBSI SQL Table
Brazil Numeric Indexer OBNI SQL Table
Business Partner OCRD SQL Table
India Chapter ID OCHP SQL Table
Commission Groups OCOG SQL Table
Customs Groups OARG SQL Table
Depreciation Groups OADG SQL Table
DNF Code ODNF SQL Table
Employees OHEM SQL Table
G/L Accounts OACT SQL Table
Manufacturers OMRC SQL Table
Brazil Fuel Indexer OBFI SQL Table
UoM Master Data OUOM SQL Table
Service Code Table OSCD SQL Table
Item Groups OITB SQL Table
Location OLCT SQL Table
Material Group OMGP SQL Table
Material Type OMTP SQL Table
NCM Code ONCM SQL Table
Object Settings - History ADP1 SQL Table
Cycle OCYC SQL Table
Product Source Code OPSC SQL Table
Checking Rule ODCR SQL Table
Documents Numbering - Series NNM1 SQL Table
Service Category OSCG SQL Table
Service Group for Brazil OSGP SQL Table
Delivery Types OSHP SQL Table
Sales Tax Codes OSTC SQL Table
UoM Group OUGP SQL Table
Users OUSR SQL Table
Tax Definition OVTG SQL Table
Contract Template OCTT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ItemCode KEY UNIQUE | Item No. | nVarChar | 20 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ItemName KEY | Item Description | nVarChar | 100 | ITEM_NAME | No | |||
| FrgnName | Description in Foreign Lang. | nVarChar | 100 | |||||
| ItmsGrpCod | Item Group | Int | 6 | OITB Item Groups | 100 | |||
| CstGrpCode | Customs Group | Int | 6 | OARG Customs Groups | -1 | |||
| VatGourpSa | Sales Tax Definition | nVarChar | 8 | OVTG Tax Definition | ||||
| CodeBars | Bar Code | nVarChar | 127 | |||||
| VATLiable | Tax Definition | VarChar | Y) Yes N) No | 1 | Y | |||
| PrchseItem KEY | Purchase Item [Yes/No] | VarChar | Y) Yes N) No | 1 | Y | PURCHASE | No | |
| SellItem KEY | Sales Item [Yes/No] | VarChar | Y) Yes N) No | 1 | Y | SALE | No | |
| InvntItem KEY | Inventory Item [Yes/No] | VarChar | Y) Yes N) No | 1 | Y | INVENTORY | No | |
| OnHand | In Stock | Num | 20 | |||||
| IsCommited | Qty Ordered by Customers | Num | 20 | |||||
| OnOrder | Qty Ordered from Vendors | Num | 20 | |||||
| IncomeAcct | Revenue Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ExmptIncom | Exempt Revenue Account | nVarChar | 15 | OACT G/L Accounts | ||||
| MaxLevel | Maximum Inventory Level | Num | 20 | |||||
| DfltWH | Default Warehouse | nVarChar | 8 | |||||
| CardCode | Preferred Vendor | nVarChar | 15 | OCRD Business Partner | ||||
| SuppCatNum | Mfr Catalog No. | nVarChar | 17 | |||||
| BuyUnitMsr | Purchasing UoM | nVarChar | 100 | |||||
| NumInBuy | No. of Items per Purchase Unit | Num | 20 | |||||
| ReorderQty | Pref. Qty in Purchase Units | Num | 20 | |||||
| MinLevel | Minimum Inventory Level | Num | 20 | |||||
| LstEvlPric | Last Evaluated Price | Num | 20 | |||||
| LstEvlDate | Date of Last Reval. Price | Date | 8 | |||||
| CustomPer | Customs Rate | Num | 20 | |||||
| Canceled | Canceled Item [Yes/No] | VarChar | Y) Yes N) No | 1 | N | |||
| MnufctTime | Production Date in Days | Int | 11 | |||||
| WholSlsTax | Tax Rate for Wholesaler | VarChar | 1 | |||||
| RetilrTax | Sales Tax in % | VarChar | 1 | |||||
| SpcialDisc | Special Discount % | Num | 20 | |||||
| DscountCod | Discount Code | Int | 6 | |||||
| TrackSales | Follow-Up [Yes/No] | VarChar | Y) Yes N) No | 1 | N | |||
| SalUnitMsr | Sales UoM | nVarChar | 100 | |||||
| NumInSale | No. of Items per Sales Unit | Num | 20 | |||||
| Consig | Consignment Goods Whse | Num | 20 | |||||
| QueryGroup | Properties | Int | 11 | 0 | ||||
| Counted | Quantity Counted in Inventory | Num | 20 | |||||
| OpenBlnc | Initial Stock | Num | 20 | |||||
| EvalSystem | Valuation Method | VarChar | A) Moving Average S) Standard F) FIFO B) Serial/Batch | 1 | ||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| FREE | Free [Yes/No] | VarChar | Y) Yes N) No | 1 | N | |||
| PicturName | Picture | nVarChar | 127 | |||||
| Transfered | Year Transfer [Y/N] | VarChar | Y) Yes N) No | 1 | N | |||
| BlncTrnsfr | Balances transferred [Yes/No] | VarChar | Y) Yes N) No | 1 | N | |||
| UserText | Item Remarks | Text | 16 | |||||
| SerialNum | Serial Number | nVarChar | 17 | |||||
| CommisPcnt | % Commission for Item | Num | 20 | |||||
| CommisSum | Total Commission for Item | Num | 20 | |||||
| CommisGrp KEY | Commission Group | Int | 6 | OCOG Commission Groups | 0 | COM_GROUP | No | |
| TreeType KEY | BOM Type | VarChar | N) Not a BOM A) Assembly S) Sales P) Production T) Template | 1 | N | TREE_TYPE | No | |
| TreeQty | No. of Units | Num | 20 | |||||
| LastPurPrc | Last Purchase Price | Num | 20 | |||||
| LastPurCur | Last Purchase Currency | nVarChar | 3 | |||||
| LastPurDat | Last Purchase Date | Date | 8 | |||||
| ExitCur | Issue Currency | nVarChar | 3 | |||||
| ExitPrice | Issue Price | Num | 20 | |||||
| ExitWH | Release Warehouse | nVarChar | 8 | |||||
| AssetItem | Fixed Assets | VarChar | Y) Yes N) No | 1 | N | |||
| WasCounted | Counted | VarChar | Y) Yes N) No | 1 | N | |||
| ManSerNum | Serial No. Management | VarChar | Y) Yes N) No | 1 | N | |||
| SHeight1 | Height 1 - Sales Unit | Num | 20 | |||||
| SHght1Unit | Height 1 - UoM for Sales | Int | 6 | |||||
| SHeight2 | Height 2 - Sales Unit | Num | 20 | |||||
| SHght2Unit | Height 2 - UoM for Sales | Int | 6 | |||||
| SWidth1 | Width 1 - Sales Unit | Num | 20 | |||||
| SWdth1Unit | Width 1 - UoM for Sales | Int | 6 | |||||
| SWidth2 | Width 2 - Sales Unit | Num | 20 | |||||
| SWdth2Unit | Width 2 - UoM for Sales | Int | 6 | |||||
| SLength1 | Length 1 - Sales Unit | Num | 20 | |||||
| SLen1Unit | Length 1 - UoM for Sales | Int | 6 | |||||
| Slength2 | Length 2 - Sales Unit | Num | 20 | |||||
| SLen2Unit | Length 2 - UoM for Sales | Int | 6 | |||||
| SVolume | Volume - Sales Unit | Num | 20 | |||||
| SVolUnit | Volume - UoM for Sales | Int | 6 | |||||
| SWeight1 | Weight 1 - Sales Unit | Num | 20 | |||||
| SWght1Unit | Weight 1 - UoM for Sales | Int | 6 | |||||
| SWeight2 | Weight 2 - Sales Unit | Num | 20 | |||||
| SWght2Unit | Weight 2 - UoM for Sales | Int | 6 | |||||
| BHeight1 | Height 1 - Purchasing Unit | Num | 20 | |||||
| BHght1Unit | Height 1 - UoM for Purchasing | Int | 6 | |||||
| BHeight2 | Height 2 - Purchasing Unit | Num | 20 | |||||
| BHght2Unit | Height 2 - UoM for Purchasing | Int | 6 | |||||
| BWidth1 | Width 1 - Purchasing Unit | Num | 20 | |||||
| BWdth1Unit | Width 1 - UoM for Purchasing | Int | 6 | |||||
| BWidth2 | Width 2 - Purchasing Unit | Num | 20 | |||||
| BWdth2Unit | Width 2 - UoM for Purchasing | Int | 6 | |||||
| BLength1 | Length 1 - Purchase Unit | Num | 20 | |||||
| BLen1Unit | Length 1 - UoM for Purchasing | Int | 6 | |||||
| Blength2 | Length 2 - Purchase Unit | Num | 20 | |||||
| BLen2Unit | Length 2 - UoM for Purchasing | Int | 6 | |||||
| BVolume | Quantity - Purchasing Unit | Num | 20 | |||||
| BVolUnit | Volume - UoM for Purchasing | Int | 6 | |||||
| BWeight1 | Weight 1 - Purchasing Unit | Num | 20 | |||||
| BWght1Unit | Weight 1 - UoM for Purchasing | Int | 6 | |||||
| BWeight2 | Weight 2 - Purchasing Unit | Num | 20 | |||||
| BWght2Unit | Weight 2 - UoM for Purchasing | Int | 6 | |||||
| FixCurrCms | Currency of Fixed Commission | nVarChar | 3 | |||||
| FirmCode | Manufacturer | Int | 6 | OMRC Manufacturers | -1 | |||
| LstSalDate | Last Sale Date | Date | 8 | |||||
| QryGroup1 | Property 1 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup2 | Property 2 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup3 | Property 3 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup4 | Property 4 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup5 | Property 5 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup6 | Property 6 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup7 | Property 7 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup8 | Property 8 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup9 | Property 9 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup10 | Property 10 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup11 | Property 11 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup12 | Property 12 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup13 | Property 13 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup14 | Property 14 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup15 | Property 15 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup16 | Property 16 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup17 | Property 17 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup18 | Property 18 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup19 | Property 19 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup20 | Property 20 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup21 | Property 21 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup22 | Property 22 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup23 | Property 23 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup24 | Property 24 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup25 | Property 25 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup26 | Property 26 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup27 | Property 27 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup28 | Property 28 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup29 | Property 29 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup30 | Property 30 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup31 | Property 31 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup32 | Property 32 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup33 | Property 33 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup34 | Property 34 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup35 | Property 35 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup36 | Property 36 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup37 | Property 37 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup38 | Property 38 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup39 | Property 39 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup40 | Property 40 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup41 | Property 41 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup42 | Property 42 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup43 | Property 43 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup44 | Property 44 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup45 | Property 45 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup46 | Property 46 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup47 | Property 47 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup48 | Property 48 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup49 | Property 49 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup50 | Property 50 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup51 | Property 51 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup52 | Property 52 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup53 | Property 53 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup54 | Property 54 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup55 | Property 55 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup56 | Property 56 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup57 | Property 57 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup58 | Property 58 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup59 | Property 59 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup60 | Property 60 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup61 | Property 61 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup62 | Property 62 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup63 | Property 63 | VarChar | Y) Yes N) No | 1 | N | |||
| QryGroup64 | Property 64 | VarChar | Y) Yes N) No | 1 | N | |||
| CreateDate | Production Date | Date | 8 | |||||
| UpdateDate | Date of Update | Date | 8 | |||||
| ExportCode | Data Export Code | nVarChar | 20 | |||||
| SalFactor1 | Sales Factor 1 | Num | 20 | |||||
| SalFactor2 | Sales Factor 2 | Num | 20 | |||||
| SalFactor3 | Sales Factor 3 | Num | 20 | |||||
| SalFactor4 | Sales Factor 4 | Num | 20 | |||||
| PurFactor1 | Purchasing Factor 1 | Num | 20 | |||||
| PurFactor2 | Purchasing Factor 2 | Num | 20 | |||||
| PurFactor3 | Purchasing Factor 3 | Num | 20 | |||||
| PurFactor4 | Purchasing Factor 4 | Num | 20 | |||||
| SalFormula | Sales Formula | nVarChar | 40 | |||||
| PurFormula | Purchasing Formula | nVarChar | 40 | |||||
| VatGroupPu | Purchase Tax Definition | nVarChar | 8 | OVTG Tax Definition | ||||
| AvgPrice | Item Cost | Num | 20 | |||||
| PurPackMsr | Packaging UoM (Purchasing) | nVarChar | 30 | |||||
| PurPackUn | Qty per Packaging (Purchasing) | Num | 20 | |||||
| SalPackMsr | Packaging UoM (Sales) | nVarChar | 30 | |||||
| SalPackUn | Qty per Packaging (Sales) | Num | 20 | |||||
| SCNCounter | SCN Counter | Int | 6 | |||||
| ManBtchNum | Manage Batch No. [Yes/No] | VarChar | Y) Yes N) No | 1 | N | |||
| ManOutOnly | Manage SN Only on Exit | VarChar | Y) Yes N) No | 1 | N | |||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer G) Fixed Assets Migration | 1 | N | |||
| validFor | Active | VarChar | Y) Yes N) No | 1 | N | |||
| validFrom | Active From | Date | 8 | |||||
| validTo | Active To | Date | 8 | |||||
| frozenFor | Inactive | VarChar | Y) Yes N) No | 1 | N | |||
| frozenFrom | Inactive From | Date | 8 | |||||
| frozenTo | Inactive To | Date | 8 | |||||
| BlockOut | Force selection of serial no. | VarChar | Y) Yes N) No | 1 | Y | |||
| ValidComm | Active Remarks | nVarChar | 30 | |||||
| FrozenComm | Inactive Remarks | nVarChar | 30 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 4 | |||
| SWW | Additional Identifier | nVarChar | 16 | |||||
| Deleted | Deleted | VarChar | Y) Yes N) No | 1 | N | |||
| DocEntry | Internal Number | Int | 11 | |||||
| ExpensAcct | Expense Account | nVarChar | 15 | OACT G/L Accounts | ||||
| FrgnInAcct | Revenue Account - Foreign | nVarChar | 15 | OACT G/L Accounts | ||||
| ShipType | Shipping Type | Int | 6 | OSHP Delivery Types | ||||
| GLMethod | Set G/L Account by | VarChar | W) Warehouse C) Item Group L) Item Level | 1 | W | |||
| ECInAcct | Revenue Account - EU | nVarChar | 15 | |||||
| FrgnExpAcc | Expense Account - Foreign | nVarChar | 15 | |||||
| ECExpAcc | Expense Account - EU | nVarChar | 15 | |||||
| TaxType | Tax Type | VarChar | Y) Regular Tax U) Use Tax N) No Tax | 1 | Y | |||
| ByWh | Inventory Management by Whse | VarChar | 1 | |||||
| WTLiable | WTax Liable | VarChar | Y) Yes N) No | 1 | Y | |||
| ItemType | Item Type | VarChar | I) Items L) Labor T) Travel F) Fixed Assets | 1 | I | |||
| WarrntTmpl | Warranty Template | nVarChar | 20 | OCTT Contract Template | ||||
| BaseUnit | Base Unit Name | nVarChar | 20 | |||||
| CountryOrg | Country of Origin | nVarChar | 3 | |||||
| StockValue | Inventory Value | Num | 20 | |||||
| Phantom | Phantom Item | VarChar | Y) Yes N) No | 1 | N | |||
| IssueMthd | Issue Method | VarChar | B) Backflush M) Manual | 1 | ||||
| FREE1 | Yield in % | VarChar | 1 | |||||
| PricingPrc | Pricing Percentage | Num | 20 | |||||
| MngMethod | Management Method | VarChar | A) On Every Transaction R) On Release Only | 1 | R | |||
| ReorderPnt | Reorder Point | Num | 20 | |||||
| InvntryUom | Inventory UoM | nVarChar | 100 | |||||
| PlaningSys | Planning Method | VarChar | M) MRP N) None | 1 | N | |||
| PrcrmntMtd | Procurement Method | VarChar | B) Buy M) Make | 1 | B | |||
| OrdrIntrvl | Order Intervals | Int | 6 | OCYC Cycle | ||||
| OrdrMulti | Order Multiple | Num | 20 | |||||
| MinOrdrQty | Minimum Order Quantity | Num | 20 | |||||
| LeadTime | Lead Time | Int | 11 | |||||
| IndirctTax | Indirect Tax | VarChar | Y) Yes N) No | 1 | N | |||
| TaxCodeAR | Tax Code (A/R) | nVarChar | 8 | OSTC Sales Tax Codes | ||||
| TaxCodeAP | Tax Code (A/P) | nVarChar | 8 | OSTC Sales Tax Codes | ||||
| OSvcCode | Outgoing Service Code | Int | 11 | OSCD Service Code Table | -1 | |||
| ISvcCode | Incoming Service Code | Int | 11 | OSCD Service Code Table | -1 | |||
| ServiceGrp | Service Group | Int | 11 | OSGP Service Group for Brazil | -1 | |||
| NCMCode | NCM Code | Int | 11 | ONCM NCM Code | -1 | |||
| MatType | Material Type | nVarChar | 3 | OMTP Material Type | 1 | |||
| MatGrp | Material Group | Int | 11 | OMGP Material Group | -1 | |||
| ProductSrc | Product Source | nVarChar | 2 | OPSC Product Source Code | 0 | |||
| ServiceCtg | Service Category | Int | -1) | 11 | OSCG Service Category | -1 | ||
| ItemClass | Service or Material | VarChar | 2) Material 1) Service | 1 | 2 | |||
| Excisable | Excisable [Yes/No] | VarChar | Y) Yes N) No | 1 | N | |||
| ChapterID | Chapter ID | Int | 11 | OCHP India Chapter ID | -1 | |||
| NotifyASN | Notification Availed SN. | nVarChar | 40 | |||||
| ProAssNum | Provisional Assessment No. | nVarChar | 20 | |||||
| AssblValue | Assessable Value | Num | 20 | |||||
| DNFEntry | DNF Code Entry | Int | 11 | ODNF DNF Code | -1 | |||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| Spec | Item Specification | nVarChar | 30 | |||||
| TaxCtg | Tax Category | nVarChar | 4 | |||||
| Series | Series | Int | 6 | NNM1 Documents Numbering - Series | ||||
| Number | Number | Int | 11 | |||||
| FuelCode | Fuel | Int | 11 | OBFI Brazil Fuel Indexer | -1 | |||
| BeverTblC | Beverage Table | nVarChar | 2 | OBSI Brazil String Indexer | ||||
| BeverGrpC | Beverage Group | nVarChar | 2 | OBSI Brazil String Indexer | ||||
| BeverTM | Beverage Brand | Int | 11 | OBNI Brazil Numeric Indexer | -1 | |||
| Attachment | Attachment | Text | 16 | |||||
| AtcEntry | Attachment Entry | Int | 11 | |||||
| ToleranDay | Tolerance Days | Int | 11 | |||||
| UgpEntry | UoM Group | Int | 11 | OUGP UoM Group | ||||
| PUoMEntry | Default Purchase UoM | Int | 11 | OUOM UoM Master Data | ||||
| SUoMEntry | Default Sales UoM | Int | 11 | OUOM UoM Master Data | ||||
| IUoMEntry | Inventory UoM | Int | 11 | OUOM UoM Master Data | ||||
| IssuePriBy | Issue Primarily By SnB or Bin | Int | 0 1) Issue Primarily by Bin Location | 6 | ||||
| AssetClass | Asset Class | nVarChar | 20 | OACS Asset Classes | ||||
| AssetGroup | Asset Group | nVarChar | 15 | OAGS Asset Groups | ||||
| InventryNo | Inventory Number of Asset | nVarChar | 12 | |||||
| Technician | Technician of Fixed Asset | Int | 11 | OHEM Employees | ||||
| Employee | Employee of Fixed Asset | Int | 11 | OHEM Employees | ||||
| Location | Location | Int | 11 | OLCT Location | ||||
| StatAsset | Owned by Company | VarChar | Y) Yes N) No | 1 | N | |||
| Cession | Cession | VarChar | Y) Yes N) No | 1 | N | |||
| DeacAftUL | Deactivate After Useful Life | VarChar | Y) Yes N) No | 1 | N | |||
| AsstStatus | Asset Status | VarChar | N) New A) Active I) Inactive | 1 | N | |||
| CapDate | Capitalization Date | Date | 8 | |||||
| AcqDate | Acquisition Date | Date | 8 | |||||
| RetDate | Retirement Date | Date | 8 | |||||
| GLPickMeth | G/L Account Pick Method | VarChar | A) General W) Warehouse C) Item Group | 1 | A | |||
| NoDiscount | No Discounts | VarChar | Y) Yes N) No | 1 | N | |||
| MgrByQty | Manage Asset by Quantity | VarChar | Y) Yes N) No | 1 | N | |||
| AssetRmk1 | Asset Remark 1 | nVarChar | 100 | |||||
| AssetRmk2 | Asset Remark 2 | nVarChar | 100 | |||||
| AssetAmnt1 | Asset Amount 1 | Num | 20 | |||||
| AssetAmnt2 | Asset Amount 2 | Num | 20 | |||||
| DeprGroup | Depreciation Group | nVarChar | 15 | OADG Depreciation Groups | ||||
| AssetSerNo | Asset Serial Number | nVarChar | 32 | |||||
| CntUnitMsr | Inventory Counting UoM Name | nVarChar | 100 | |||||
| NumInCnt | No. of Items per Counting Unit | Num | 20 | |||||
| INUoMEntry | Inventory Counting UoM Entry | Int | 11 | OUOM UoM Master Data | ||||
| OneBOneRec | One Batch One Receipt | VarChar | Y) Yes N) No | 1 | N | |||
| RuleCode | Checking Rule Code | nVarChar | 2 | ODCR Checking Rule | ||||
| ScsCode | Scs Code | nVarChar | 10 | |||||
| SpProdType | Special Product Type | nVarChar | MT) Cellular Phones IO) Integrated Circuits | 2 | ||||
| IWeight1 | Weight 1 - Inventory | Num | 20 | |||||
| IWght1Unit | Weight 1 - Inventory Unit | Int | 6 | |||||
| IWeight2 | Weight 2 - Inventory | Num | 20 | |||||
| IWght2Unit | Weight 2 - Inventory Unit | Int | 6 | |||||
| CompoWH | Component Warehouse | VarChar | B) From Bill of Materials Line P) From Parent Item Document Line | 1 | B |
Table relationship map
SELECT statement
SELECT
SITM.ItemCode AS 'Item No.',
SITM.ItemName AS 'Item Description',
SITM.FrgnName AS 'Description in Foreign Lang.',
SITM.ItmsGrpCod AS 'Item Group',
SITM.CstGrpCode AS 'Customs Group',
SITM.VatGourpSa AS 'Sales Tax Definition',
SITM.CodeBars AS 'Bar Code',
SITM.VATLiable AS 'Tax Definition',
SITM.PrchseItem AS 'Purchase Item [Yes/No]',
SITM.SellItem AS 'Sales Item [Yes/No]',
SITM.InvntItem AS 'Inventory Item [Yes/No]',
SITM.OnHand AS 'In Stock',
SITM.IsCommited AS 'Qty Ordered by Customers',
SITM.OnOrder AS 'Qty Ordered from Vendors',
SITM.IncomeAcct AS 'Revenue Account',
SITM.ExmptIncom AS 'Exempt Revenue Account',
SITM.MaxLevel AS 'Maximum Inventory Level',
SITM.DfltWH AS 'Default Warehouse',
SITM.CardCode AS 'Preferred Vendor',
SITM.SuppCatNum AS 'Mfr Catalog No.',
SITM.BuyUnitMsr AS 'Purchasing UoM',
SITM.NumInBuy AS 'No. of Items per Purchase Unit',
SITM.ReorderQty AS 'Pref. Qty in Purchase Units',
SITM.MinLevel AS 'Minimum Inventory Level',
SITM.LstEvlPric AS 'Last Evaluated Price',
SITM.LstEvlDate AS 'Date of Last Reval. Price',
SITM.CustomPer AS 'Customs Rate',
SITM.Canceled AS 'Canceled Item [Yes/No]',
SITM.MnufctTime AS 'Production Date in Days',
SITM.WholSlsTax AS 'Tax Rate for Wholesaler',
SITM.RetilrTax AS 'Sales Tax in %',
SITM.SpcialDisc AS 'Special Discount %',
SITM.DscountCod AS 'Discount Code',
SITM.TrackSales AS 'Follow-Up [Yes/No]',
SITM.SalUnitMsr AS 'Sales UoM',
SITM.NumInSale AS 'No. of Items per Sales Unit',
SITM.Consig AS 'Consignment Goods Whse',
SITM.QueryGroup AS 'Properties',
SITM.Counted AS 'Quantity Counted in Inventory',
SITM.OpenBlnc AS 'Initial Stock',
SITM.EvalSystem AS 'Valuation Method',
SITM.UserSign AS 'User Signature',
SITM.FREE AS 'Free [Yes/No]',
SITM.PicturName AS 'Picture',
SITM.Transfered AS 'Year Transfer [Y/N]',
SITM.BlncTrnsfr AS 'Balances transferred [Yes/No]',
SITM.UserText AS 'Item Remarks',
SITM.SerialNum AS 'Serial Number',
SITM.CommisPcnt AS '% Commission for Item',
SITM.CommisSum AS 'Total Commission for Item',
SITM.CommisGrp AS 'Commission Group',
SITM.TreeType AS 'BOM Type',
SITM.TreeQty AS 'No. of Units',
SITM.LastPurPrc AS 'Last Purchase Price',
SITM.LastPurCur AS 'Last Purchase Currency',
SITM.LastPurDat AS 'Last Purchase Date',
SITM.ExitCur AS 'Issue Currency',
SITM.ExitPrice AS 'Issue Price',
SITM.ExitWH AS 'Release Warehouse',
SITM.AssetItem AS 'Fixed Assets',
SITM.WasCounted AS 'Counted',
SITM.ManSerNum AS 'Serial No. Management',
SITM.SHeight1 AS 'Height 1 - Sales Unit',
SITM.SHght1Unit AS 'Height 1 - UoM for Sales',
SITM.SHeight2 AS 'Height 2 - Sales Unit',
SITM.SHght2Unit AS 'Height 2 - UoM for Sales',
SITM.SWidth1 AS 'Width 1 - Sales Unit',
SITM.SWdth1Unit AS 'Width 1 - UoM for Sales',
SITM.SWidth2 AS 'Width 2 - Sales Unit',
SITM.SWdth2Unit AS 'Width 2 - UoM for Sales',
SITM.SLength1 AS 'Length 1 - Sales Unit',
SITM.SLen1Unit AS 'Length 1 - UoM for Sales',
SITM.Slength2 AS 'Length 2 - Sales Unit',
SITM.SLen2Unit AS 'Length 2 - UoM for Sales',
SITM.SVolume AS 'Volume - Sales Unit',
SITM.SVolUnit AS 'Volume - UoM for Sales',
SITM.SWeight1 AS 'Weight 1 - Sales Unit',
SITM.SWght1Unit AS 'Weight 1 - UoM for Sales',
SITM.SWeight2 AS 'Weight 2 - Sales Unit',
SITM.SWght2Unit AS 'Weight 2 - UoM for Sales',
SITM.BHeight1 AS 'Height 1 - Purchasing Unit',
SITM.BHght1Unit AS 'Height 1 - UoM for Purchasing',
SITM.BHeight2 AS 'Height 2 - Purchasing Unit',
SITM.BHght2Unit AS 'Height 2 - UoM for Purchasing',
SITM.BWidth1 AS 'Width 1 - Purchasing Unit',
SITM.BWdth1Unit AS 'Width 1 - UoM for Purchasing',
SITM.BWidth2 AS 'Width 2 - Purchasing Unit',
SITM.BWdth2Unit AS 'Width 2 - UoM for Purchasing',
SITM.BLength1 AS 'Length 1 - Purchase Unit',
SITM.BLen1Unit AS 'Length 1 - UoM for Purchasing',
SITM.Blength2 AS 'Length 2 - Purchase Unit',
SITM.BLen2Unit AS 'Length 2 - UoM for Purchasing',
SITM.BVolume AS 'Quantity - Purchasing Unit',
SITM.BVolUnit AS 'Volume - UoM for Purchasing',
SITM.BWeight1 AS 'Weight 1 - Purchasing Unit',
SITM.BWght1Unit AS 'Weight 1 - UoM for Purchasing',
SITM.BWeight2 AS 'Weight 2 - Purchasing Unit',
SITM.BWght2Unit AS 'Weight 2 - UoM for Purchasing',
SITM.FixCurrCms AS 'Currency of Fixed Commission',
SITM.FirmCode AS 'Manufacturer',
SITM.LstSalDate AS 'Last Sale Date',
SITM.QryGroup1 AS 'Property 1',
SITM.QryGroup2 AS 'Property 2',
SITM.QryGroup3 AS 'Property 3',
SITM.QryGroup4 AS 'Property 4',
SITM.QryGroup5 AS 'Property 5',
SITM.QryGroup6 AS 'Property 6',
SITM.QryGroup7 AS 'Property 7',
SITM.QryGroup8 AS 'Property 8',
SITM.QryGroup9 AS 'Property 9',
SITM.QryGroup10 AS 'Property 10',
SITM.QryGroup11 AS 'Property 11',
SITM.QryGroup12 AS 'Property 12',
SITM.QryGroup13 AS 'Property 13',
SITM.QryGroup14 AS 'Property 14',
SITM.QryGroup15 AS 'Property 15',
SITM.QryGroup16 AS 'Property 16',
SITM.QryGroup17 AS 'Property 17',
SITM.QryGroup18 AS 'Property 18',
SITM.QryGroup19 AS 'Property 19',
SITM.QryGroup20 AS 'Property 20',
SITM.QryGroup21 AS 'Property 21',
SITM.QryGroup22 AS 'Property 22',
SITM.QryGroup23 AS 'Property 23',
SITM.QryGroup24 AS 'Property 24',
SITM.QryGroup25 AS 'Property 25',
SITM.QryGroup26 AS 'Property 26',
SITM.QryGroup27 AS 'Property 27',
SITM.QryGroup28 AS 'Property 28',
SITM.QryGroup29 AS 'Property 29',
SITM.QryGroup30 AS 'Property 30',
SITM.QryGroup31 AS 'Property 31',
SITM.QryGroup32 AS 'Property 32',
SITM.QryGroup33 AS 'Property 33',
SITM.QryGroup34 AS 'Property 34',
SITM.QryGroup35 AS 'Property 35',
SITM.QryGroup36 AS 'Property 36',
SITM.QryGroup37 AS 'Property 37',
SITM.QryGroup38 AS 'Property 38',
SITM.QryGroup39 AS 'Property 39',
SITM.QryGroup40 AS 'Property 40',
SITM.QryGroup41 AS 'Property 41',
SITM.QryGroup42 AS 'Property 42',
SITM.QryGroup43 AS 'Property 43',
SITM.QryGroup44 AS 'Property 44',
SITM.QryGroup45 AS 'Property 45',
SITM.QryGroup46 AS 'Property 46',
SITM.QryGroup47 AS 'Property 47',
SITM.QryGroup48 AS 'Property 48',
SITM.QryGroup49 AS 'Property 49',
SITM.QryGroup50 AS 'Property 50',
SITM.QryGroup51 AS 'Property 51',
SITM.QryGroup52 AS 'Property 52',
SITM.QryGroup53 AS 'Property 53',
SITM.QryGroup54 AS 'Property 54',
SITM.QryGroup55 AS 'Property 55',
SITM.QryGroup56 AS 'Property 56',
SITM.QryGroup57 AS 'Property 57',
SITM.QryGroup58 AS 'Property 58',
SITM.QryGroup59 AS 'Property 59',
SITM.QryGroup60 AS 'Property 60',
SITM.QryGroup61 AS 'Property 61',
SITM.QryGroup62 AS 'Property 62',
SITM.QryGroup63 AS 'Property 63',
SITM.QryGroup64 AS 'Property 64',
SITM.CreateDate AS 'Production Date',
SITM.UpdateDate AS 'Date of Update',
SITM.ExportCode AS 'Data Export Code',
SITM.SalFactor1 AS 'Sales Factor 1',
SITM.SalFactor2 AS 'Sales Factor 2',
SITM.SalFactor3 AS 'Sales Factor 3',
SITM.SalFactor4 AS 'Sales Factor 4',
SITM.PurFactor1 AS 'Purchasing Factor 1',
SITM.PurFactor2 AS 'Purchasing Factor 2',
SITM.PurFactor3 AS 'Purchasing Factor 3',
SITM.PurFactor4 AS 'Purchasing Factor 4',
SITM.SalFormula AS 'Sales Formula',
SITM.PurFormula AS 'Purchasing Formula',
SITM.VatGroupPu AS 'Purchase Tax Definition',
SITM.AvgPrice AS 'Item Cost',
SITM.PurPackMsr AS 'Packaging UoM (Purchasing)',
SITM.PurPackUn AS 'Qty per Packaging (Purchasing)',
SITM.SalPackMsr AS 'Packaging UoM (Sales)',
SITM.SalPackUn AS 'Qty per Packaging (Sales)',
SITM.SCNCounter AS 'SCN Counter',
SITM.ManBtchNum AS 'Manage Batch No. [Yes/No]',
SITM.ManOutOnly AS 'Manage SN Only on Exit',
SITM.DataSource AS 'Data Source',
SITM.validFor AS 'Active',
SITM.validFrom AS 'Active From',
SITM.validTo AS 'Active To',
SITM.frozenFor AS 'Inactive',
SITM.frozenFrom AS 'Inactive From',
SITM.frozenTo AS 'Inactive To',
SITM.BlockOut AS 'Force selection of serial no.',
SITM.ValidComm AS 'Active Remarks',
SITM.FrozenComm AS 'Inactive Remarks',
SITM.LogInstanc AS 'Log Instance',
SITM.ObjType AS 'Object Type',
SITM.SWW AS 'Additional Identifier',
SITM.Deleted AS 'Deleted',
SITM.DocEntry AS 'Internal Number',
SITM.ExpensAcct AS 'Expense Account',
SITM.FrgnInAcct AS 'Revenue Account - Foreign',
SITM.ShipType AS 'Shipping Type',
SITM.GLMethod AS 'Set G/L Account by',
SITM.ECInAcct AS 'Revenue Account - EU',
SITM.FrgnExpAcc AS 'Expense Account - Foreign',
SITM.ECExpAcc AS 'Expense Account - EU',
SITM.TaxType AS 'Tax Type',
SITM.ByWh AS 'Inventory Management by Whse',
SITM.WTLiable AS 'WTax Liable',
SITM.ItemType AS 'Item Type',
SITM.WarrntTmpl AS 'Warranty Template',
SITM.BaseUnit AS 'Base Unit Name',
SITM.CountryOrg AS 'Country of Origin',
SITM.StockValue AS 'Inventory Value',
SITM.Phantom AS 'Phantom Item',
SITM.IssueMthd AS 'Issue Method',
SITM.FREE1 AS 'Yield in %',
SITM.PricingPrc AS 'Pricing Percentage',
SITM.MngMethod AS 'Management Method',
SITM.ReorderPnt AS 'Reorder Point',
SITM.InvntryUom AS 'Inventory UoM',
SITM.PlaningSys AS 'Planning Method',
SITM.PrcrmntMtd AS 'Procurement Method',
SITM.OrdrIntrvl AS 'Order Intervals',
SITM.OrdrMulti AS 'Order Multiple',
SITM.MinOrdrQty AS 'Minimum Order Quantity',
SITM.LeadTime AS 'Lead Time',
SITM.IndirctTax AS 'Indirect Tax',
SITM.TaxCodeAR AS 'Tax Code (A/R)',
SITM.TaxCodeAP AS 'Tax Code (A/P)',
SITM.OSvcCode AS 'Outgoing Service Code',
SITM.ISvcCode AS 'Incoming Service Code',
SITM.ServiceGrp AS 'Service Group',
SITM.NCMCode AS 'NCM Code',
SITM.MatType AS 'Material Type',
SITM.MatGrp AS 'Material Group',
SITM.ProductSrc AS 'Product Source',
SITM.ServiceCtg AS 'Service Category',
SITM.ItemClass AS 'Service or Material',
SITM.Excisable AS 'Excisable [Yes/No]',
SITM.ChapterID AS 'Chapter ID',
SITM.NotifyASN AS 'Notification Availed SN.',
SITM.ProAssNum AS 'Provisional Assessment No.',
SITM.AssblValue AS 'Assessable Value',
SITM.DNFEntry AS 'DNF Code Entry',
SITM.UserSign2 AS 'Updating User',
SITM.Spec AS 'Item Specification',
SITM.TaxCtg AS 'Tax Category',
SITM.Series AS 'Series',
SITM.Number AS 'Number',
SITM.FuelCode AS 'Fuel',
SITM.BeverTblC AS 'Beverage Table',
SITM.BeverGrpC AS 'Beverage Group',
SITM.BeverTM AS 'Beverage Brand',
SITM.Attachment AS 'Attachment',
SITM.AtcEntry AS 'Attachment Entry',
SITM.ToleranDay AS 'Tolerance Days',
SITM.UgpEntry AS 'UoM Group',
SITM.PUoMEntry AS 'Default Purchase UoM',
SITM.SUoMEntry AS 'Default Sales UoM',
SITM.IUoMEntry AS 'Inventory UoM',
SITM.IssuePriBy AS 'Issue Primarily By SnB or Bin',
SITM.AssetClass AS 'Asset Class',
SITM.AssetGroup AS 'Asset Group',
SITM.InventryNo AS 'Inventory Number of Asset',
SITM.Technician AS 'Technician of Fixed Asset',
SITM.Employee AS 'Employee of Fixed Asset',
SITM.Location AS 'Location',
SITM.StatAsset AS 'Owned by Company',
SITM.Cession AS 'Cession',
SITM.DeacAftUL AS 'Deactivate After Useful Life',
SITM.AsstStatus AS 'Asset Status',
SITM.CapDate AS 'Capitalization Date',
SITM.AcqDate AS 'Acquisition Date',
SITM.RetDate AS 'Retirement Date',
SITM.GLPickMeth AS 'G/L Account Pick Method',
SITM.NoDiscount AS 'No Discounts',
SITM.MgrByQty AS 'Manage Asset by Quantity',
SITM.AssetRmk1 AS 'Asset Remark 1',
SITM.AssetRmk2 AS 'Asset Remark 2',
SITM.AssetAmnt1 AS 'Asset Amount 1',
SITM.AssetAmnt2 AS 'Asset Amount 2',
SITM.DeprGroup AS 'Depreciation Group',
SITM.AssetSerNo AS 'Asset Serial Number',
SITM.CntUnitMsr AS 'Inventory Counting UoM Name',
SITM.NumInCnt AS 'No. of Items per Counting Unit',
SITM.INUoMEntry AS 'Inventory Counting UoM Entry',
SITM.OneBOneRec AS 'One Batch One Receipt',
SITM.RuleCode AS 'Checking Rule Code',
SITM.ScsCode AS 'Scs Code',
SITM.SpProdType AS 'Special Product Type',
SITM.IWeight1 AS 'Weight 1 - Inventory',
SITM.IWght1Unit AS 'Weight 1 - Inventory Unit',
SITM.IWeight2 AS 'Weight 2 - Inventory',
SITM.IWght2Unit AS 'Weight 2 - Inventory Unit',
SITM.CompoWH AS 'Component Warehouse'
FROM SITM AS SITM
Related information
SITM SQL Table
Asset Classes OACS SQL Table
Asset Groups OAGS SQL Table
Brazil String Indexer OBSI SQL Table
Brazil Numeric Indexer OBNI SQL Table
Business Partner OCRD SQL Table
India Chapter ID OCHP SQL Table
Commission Groups OCOG SQL Table
Customs Groups OARG SQL Table
Depreciation Groups OADG SQL Table
DNF Code ODNF SQL Table
Employees OHEM SQL Table
G/L Accounts OACT SQL Table
Manufacturers OMRC SQL Table
Brazil Fuel Indexer OBFI SQL Table
UoM Master Data OUOM SQL Table
Service Code Table OSCD SQL Table
Item Groups OITB SQL Table
Location OLCT SQL Table
Material Group OMGP SQL Table
Material Type OMTP SQL Table
NCM Code ONCM SQL Table
Object Settings - History ADP1 SQL Table
Cycle OCYC SQL Table
Product Source Code OPSC SQL Table
Checking Rule ODCR SQL Table
Documents Numbering - Series NNM1 SQL Table
Service Category OSCG SQL Table
Service Group for Brazil OSGP SQL Table
Delivery Types OSHP SQL Table
Sales Tax Codes OSTC SQL Table
UoM Group OUGP SQL Table
Users OUSR SQL Table
Tax Definition OVTG SQL Table
Contract Template OCTT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
