| field name | data type | mnd. | description |
|---|---|---|---|
| tr_part | character(30) | no | Item Number |
| tr_date | date | no | Date |
| tr_per_date | date | no | Performance Date |
| tr_type | character(80) | no | Trans Type |
| tr_loc | character(80) | no | Loc |
| tr_loc_begin | decimal(10) | no | Begin Loc Bal |
| tr_begin_qoh | decimal(10) | no | Begin Balance |
| tr_qty_req | decimal(10) | no | Qty Required |
| tr_qty_chg | decimal(10) | no | Qty Change |
| tr_qty_short | decimal(10) | no | Qty Short |
| tr_um | character(30) | no | UM |
| tr_last_date | date | no | Last Activity |
| tr_nbr | character(30) | no | Order |
| tr_so_job | character(80) | no | Sales/Job |
| tr_ship_type | character(30) | no | Ship Type |
| tr_addr | character(80) | no | Address |
| tr_rmks | character(80) | no | Remarks |
| tr_xdr_acct | character(80) | no | Not used. Dr Acct |
| tr_xcr_acct | character(80) | no | Not Used. Cr Acct |
| tr_mtl_std | decimal(10) | no | Material |
| tr_lbr_std | decimal(10) | no | Labor |
| tr_bdn_std | decimal(10) | no | Burden |
| tr_price | decimal(10) | no | Price |
| tr_trnbr | integer | no | Trans |
| tr_gl_amt | decimal(10) | no | Amount |
| tr_xdr_cc | character(30) | no | Not used. Dr Cost Ctr |
| tr_xcr_cc | character(30) | no | Not Used. Cr Cost Ctr |
| tr_lot | character(80) | no | ID |
| tr_sub_std | decimal(10) | no | Subcontract |
| tr_gl_date | date | no | GL Date |
| tr_qty_loc | decimal(10) | no | Loc Qty Change |
| tr_userid | character(80) | no | User ID |
| tr_serial | character(50) | no | Lot/Serial |
| tr_effdate | date | no | Effective |
| tr_prod_line | character(30) | no | Product Line |
| tr_xslspsn1 | character(80) | no | Salesperson 1 |
| tr_xslspsn2 | character(80) | no | Salesperson 2 |
| tr_xcr_proj | character(80) | no | Not used. Cr Project |
| tr_xdr_proj | character(80) | no | Not used. Dr Project |
| tr_line | integer | no | Line |
| tr_user1 | character(80) | no | Ufld1 |
| tr_user2 | character(80) | no | Ufld2 |
| tr_curr | character(30) | no | Currency |
| tr_ex_rate | decimal(10) | no | Exch Rate |
| tr_rev | character(30) | no | Rev |
| tr_time | integer | no | Time |
| tr_ovh_std | decimal(10) | no | Overhead |
| tr_site | character(80) | no | Site |
| tr_status | character(80) | no | Inventory Status |
| tr_grade | character(30) | no | Grade |
| tr_expire | date | no | Expire Date |
| tr_assay | decimal(10) | no | Assay % |
| tr_xgl_ref | character(30) | no | Not used. GL Reference |
| tr__chr01 | character(80) | no | |
| tr__chr02 | character(80) | no | |
| tr__chr03 | character(80) | no | |
| tr__chr04 | character(80) | no | |
| tr__chr05 | character(80) | no | |
| tr__chr06 | character(80) | no | |
| tr__chr07 | character(80) | no | |
| tr__chr08 | character(80) | no | |
| tr__chr09 | character(80) | no | |
| tr__chr10 | character(80) | no | |
| tr__chr11 | character(80) | no | |
| tr__chr12 | character(80) | no | |
| tr__chr13 | character(80) | no | |
| tr__chr14 | character(80) | no | |
| tr__chr15 | character(80) | no | |
| tr__dte01 | date | no | |
| tr__dte02 | date | no | |
| tr__dte03 | date | no | |
| tr__dte04 | date | no | |
| tr__dte05 | date | no | |
| tr__dec01 | decimal(10) | no | |
| tr__dec02 | decimal(10) | no | |
| tr__dec03 | decimal(10) | no | |
| tr__dec04 | decimal(10) | no | |
| tr__dec05 | decimal(10) | no | |
| tr__log01 | logical | no | |
| tr__log02 | logical | no | |
| tr_ref | character(80) | no | Ref |
| tr_msg | integer | no | Message Number |
| tr_program | character(30) | no | Program |
| tr_ord_rev | integer | no | Revision |
| tr_ref_site | character(80) | no | Reference Site |
| tr_rsn_code | character(80) | no | Reason |
| tr_vend_lot | character(30) | no | Supplier Lot |
| tr_vend_date | date | no | Supplier Production Date |
| tr_daycode | character(80) | no | Day Code |
| tr_for | character(30) | no | Service Part |
| tr_fsm_type | character(80) | no | FSM Type |
| tr_upd_isb | logical | no | |
| tr_auto_install | logical | no | Auto Installed |
| tr_ca_int_type | character(80) | no | Work Code |
| tr_covered_amt | decimal(10) | no | Covered Amount |
| tr_fcg_code | character(80) | no | Charge Code |
| tr_batch | character(30) | no | Batch |
| tr_fsc_code | character(80) | no | Service Category |
| tr_sa_nbr | character(80) | no | Contract |
| tr_sv_code | character(80) | no | Contract Type |
| tr_eng_area | character(30) | no | Service Area |
| tr_sys_prod | character(30) | no | System Product Line |
| tr_svc_type | character(30) | no | |
| tr_ca_opn_date | date | no | |
| tr_cprice | decimal(10) | no | Price |
| tr_eng_code | character(80) | no | Engineer Code |
| tr_wod_op | integer | no | Operation |
| tr_enduser | character(80) | no | End User |
| tr_ship_inv_mov | character(80) | no | Inventory Movement Code |
| tr_ship_date | date | no | Ship Date |
| tr_ship_id | character(30) | no | Shipper Number |
| tr_ex_rate2 | decimal(10) | no | Exch Rate 2 |
| tr_ex_ratetype | character(80) | no | Rate Type |
| tr_exru_seq | integer | no | Sequence |
| tr_promise_date | date | no | Promise Date |
| tr_fldchg_cmtindx | integer | no | Comment |
| tr_domain | character(8) | yes | Domain |
| oid_tr_hist | decimal(10) | no | |
| tr_qty_cn_adj | decimal(10) | no | Consignment Qty Adjusted |
| tr_doc_id | character(24) | no | Document ID |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | no | empty string |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| trgl_cr_acct | character(80) | no | Cr Acct |
| trgl_cr_cc | character(30) | no | Cr Cost Ctr |
| trgl_dr_acct | character(80) | no | Dr Acct |
| trgl_dr_cc | character(30) | no | Dr Cost Ctr |
| trgl_trnbr | integer | no | Transaction |
| trgl_gl_amt | decimal(10) | no | Amount |
| trgl_gl_ref | character(30) | no | GL Reference |
| trgl_type | character(80) | no | Type |
| trgl_cr_proj | character(80) | no | Cr Project |
| trgl_dr_proj | character(80) | no | Dr Project |
| trgl_cr_line | integer | no | Line |
| trgl_dr_line | integer | no | Line |
| trgl_user1 | character(80) | no | Ufld1 |
| trgl_user2 | character(80) | no | Ufld2 |
| trgl_sequence | integer | no | Sequence |
| trgl__qadc01 | character(80) | no | |
| trgl_dy_code | character(80) | no | Daybook |
| trgl_dy_num | character(80) | no | Entry Number |
| trgl_cr_sub | character(80) | no | Cr Sub-Acct |
| trgl_dr_sub | character(80) | no | Dr Sub-Acct |
| trgl_domain | character(8) | yes | Domain |
| oid_trgl_det | decimal(10) | no | |
| trgl_eff_trans | logical | no | Current |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = ttr_hist.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 |