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 |