| field name | data type | mnd. | description |
|---|---|---|---|
| sct_sim | character(80) | no | Cost Set |
| sct_part | character(30) | no | Item Number |
| sct_cst_tot | decimal(10) | no | Cost Total |
| sct_mtl_tl | decimal(10) | no | Material |
| sct_lbr_tl | decimal(10) | no | Labor |
| sct_bdn_tl | decimal(10) | no | Burden |
| sct_ovh_tl | decimal(10) | no | Overhead |
| sct_sub_tl | decimal(10) | no | Subcontract |
| sct_mtl_ll | decimal(10) | no | Material LL |
| sct_lbr_ll | decimal(10) | no | Labor LL |
| sct_bdn_ll | decimal(10) | no | Burden LL |
| sct_ovh_ll | decimal(10) | no | Overhead LL |
| sct_sub_ll | decimal(10) | no | Subcontract LL |
| sct_cst_date | date | no | Cost Update |
| sct_user1 | character(80) | no | Ufld1 |
| sct_user2 | character(80) | no | Ufld2 |
| sct_serial | character(50) | no | Lot/Serial |
| sct_site | character(80) | no | Site |
| sct_rollup | logical | no | Freeze |
| sct_rollup_id | character(30) | no | Rollup ID |
| sct_nrv | decimal(10) | no | Net Realized Value |
| sct__qadc01 | character(80) | no | |
| sct_cost_changed | logical | no | Cost Changed |
| sct_domain | character(8) | yes | Domain |
| oid_sct_det | 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 | mnd. | description |
|---|---|---|---|
| spt_sim | character(80) | no | Cost Set |
| spt_part | character(30) | no | Item Number |
| spt_element | character(80) | no | Cost Element |
| spt_cst_tl | decimal(10) | no | Cost |
| spt_cst_ll | decimal(10) | no | Cost LL |
| spt_user1 | character(80) | no | Ufld1 |
| spt_user2 | character(80) | no | Ufld2 |
| spt_userid | character(80) | no | User ID |
| spt_mod_date | date | no | Modified Date |
| spt_pct_tl | decimal(10) | no | Seq 2 |
| spt_pct_ll | decimal(10) | no | Seq 1 |
| spt_ao | logical | no | Add On |
| spt_site | character(80) | no | Site |
| spt__qadc01 | character(80) | no | |
| spt_domain | character(8) | yes | Domain |
| oid_spt_det | decimal(10) | no | |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = tsct_det.tc_Rowid |
| 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 |