| field name | data type | mnd. | description |
|---|---|---|---|
| in_part | character(30) | yes | Item Number |
| in_site | character(80) | no | Site |
| in_qty_oh | decimal(10) | no | Qty On Hand |
| in_qty_req | decimal(10) | no | Qty Required |
| in_qty_all | decimal(10) | no | Qty Allocated |
| in_qty_ord | decimal(10) | no | Qty On Order |
| in_qty_chg | decimal(10) | no | Qty Change |
| in_qty_avail | decimal(10) | no | Avail Status Qty |
| in_sls_chg | decimal(10) | no | Qty Sales Change |
| in_iss_chg | decimal(10) | no | Qty Issue Change |
| in_iss_date | date | no | Last Issue |
| in_rec_date | date | no | Last Receipt |
| in_cnt_date | date | no | Last Count |
| in_avg_iss | decimal(10) | no | Average Issues |
| in_avg_sls | decimal(10) | no | Average Sales |
| in_avg_date | date | no | Last Average |
| in_user1 | character(80) | no | Ufld1 |
| in_user2 | character(80) | no | Ufld2 |
| in_rop | decimal(0) | no | Reorder Point |
| in_sfty_stk | decimal(0) | no | Safety Stk |
| in_qty_nonet | decimal(10) | no | QOH Non-nettable |
| in_mrp | logical | no | MRP Required |
| in_gl_set | character(80) | no | GL Cost Set |
| in_cur_set | character(80) | no | Current Cost Set |
| in__qadc02 | character(80) | no | ? |
| in__qadi01 | integer | no | ? |
| in__qadi02 | integer | no | ? |
| in_level | integer | no | Level |
| in_loc | character(80) | no | Location |
| in_loc_type | character(80) | no | Location Type |
| in_proj_use | integer | no | Projected Use |
| in_grade | character(30) | no | Grade |
| in_assay | decimal(10) | no | Assay % |
| in_rollup | logical | no | Rollup Reqd |
| in_rollup_id | character(80) | no | Rollup ID |
| in__qadc03 | character(80) | no | ? |
| in__qadc04 | character(80) | no | ? |
| in__qadl01 | logical | no | ? |
| in__qadl02 | logical | no | ? |
| in__qadc01 | character(80) | no | |
| in_wh | logical | no | Warehoused Item |
| in_gl_cost_site | character(80) | no | GL Cost Source Site |
| in_cust_consign_qty | decimal(10) | no | Customer Consignment Qty |
| in_supp_consign_qty | decimal(10) | no | Supplier Consignment Qty |
| in_domain | character(8) | yes | Domain |
| oid_in_mstr | decimal(10) | no | |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | no | empty string |
| tc_Status | character | no | update status |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |