field name | data type | mnd. | description |
---|---|---|---|
sro_nbr | character(80) | no | S/RO |
sro_cust | character(80) | no | Customer |
sro_ship | character(80) | no | Ship-To |
sro_taken | character(80) | no | Taken By |
sro_assign | character(80) | no | Assigned To |
sro_ent_date | date | no | Entered |
sro_cls_date | date | no | Closed |
sro_type | character(80) | no | Type |
sro_status | character(80) | no | Status |
sro_cr_terms | character(80) | no | Credit Terms |
sro_shipvia | character(30) | no | Ship Via |
sro_po | character(30) | no | PO |
sro_rga | character(80) | no | RGA |
sro_author | character(80) | no | Authorized By |
sro_print_rg | logical | no | Print RGA |
sro_print_pl | logical | no | Print Pack List |
sro_dspstn | character(80) | no | Disposition |
sro_part | character(30) | no | Item |
sro_desc | character(80) | no | Description |
sro_serial | character(50) | no | Lot/Serial |
sro_rev | character(30) | no | Rev |
sro_wrrnty | logical | no | Warranty |
sro_failure1 | character(80) | no | Failure Code |
sro_failure2 | character(80) | no | Failure Code 2 |
sro_failure3 | character(80) | no | Failure Code 3 |
sro_failure4 | character(80) | no | Failure Code 4 |
sro_failure5 | character(80) | no | Failure Code 5 |
sro_repair1 | character(80) | no | Repair Code |
sro_repair2 | character(80) | no | Repair Code 2 |
sro_repair3 | character(80) | no | Repair Code 3 |
sro_repair4 | character(80) | no | Repair Code 4 |
sro_repair5 | character(80) | no | Repair Code 5 |
sro_frt | decimal(10) | no | Freight |
sro_serv_chg | decimal(10) | no | Service |
sro_disc_pct | decimal(10) | no | Disc % |
sro_spec_chg | decimal(10) | no | Special |
sro_prepaid | decimal(10) | no | Prepaid Amount |
sro_to_inv | logical | no | Ready to Invoice |
sro_invoiced | logical | no | Invoiced |
sro__qadc05 | character(80) | no | |
sro__qadc06 | character(80) | no | |
sro_inv_date | date | no | Invoice Date |
sro_shp_date | date | no | Ship Date |
sro_closed | logical | no | Closed |
sro_due_date | date | no | Due Date |
sro_user1 | character(80) | no | Ufld1 |
sro_user2 | character(80) | no | Ufld2 |
sro_qty | decimal(10) | no | Qty |
sro_cmtindx | integer | no | Comment |
sro__chr01 | character(80) | no | |
sro__chr02 | character(80) | no | |
sro__chr03 | character(80) | no | |
sro__chr04 | character(80) | no | |
sro__chr05 | character(80) | no | |
sro__dte01 | date | no | |
sro__dte02 | date | no | |
sro__dec01 | decimal(10) | no | |
sro__dec02 | decimal(10) | no | |
sro__log01 | logical | no | |
sro_domain | character(8) | yes | Domain |
oid_sro_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 |