Questions and Answers

Q: This is an explanation of what the values mean in SOSCMT and SOSCMD. These values can be found in Doc on Disk in the Technical Reference section / Data Dictionary for Order Entry. The values can also be found through the Data Center by looking on the notes tab for each table and field

A:  field Doctype,  (Document type)

“I” = Invoice
“C” = Credit Memo
“S” = Order
“R” = Order Return
“V” = Void entry (invoice)
“D” = Void entry (credit memo)
“M” = Manual adjustment used to reopen invoice)
“T” = Commission change (i.e., salesperson was changed after the original commission was reportable

 

field Status,  (Commission status)

“S” = Shipped
“P” = Paid (commission paid to sales person)
“R” = Cash received on invoice from customer
“M” = Manual adjustment
“V” = Void (non-reportable entry)

Note: if new status is “V”, pd_pdate should be blank. This status should only be used to void a commission record that has not yet been made reportable.

“T” – Salesperson change (non-reportable entry)

Note: if new status is “T”, pd_pdate should be blank. This status should only be used to cancel a commission record that has not yet been made reportable

field COMTYPE,  (Commission type)

“P” = Person
“S” = Split
“N” = No Commission
field CMETHOD, (Commission method)

“S” SALE BASIS “P” PROFIT
“F” FLAT
“I” BY ITEM/PRODUCT LINE

© Copyright Sage Software