SLS - M3 BE Sales Management

COS - Pricing and Conditions

  • 'Promotion. Archive/Delete' (OIS700)

This function archives the records in this table:

Table Description (TF=Transaction File, MF=Master data File)
OPROMH MF: Promotions
OPROML MF: Promotions lines
OPROMS MF: Scaled prices per promotions line
OPROMC MF: Promotion Customer
OPROMW MF: Promotion per Warehouse
OPROMT TF: Promotion Transactions
OSYTXH MF: Promotion Text, header
OSYTXL MF: Promotion Text, line
Note: 

Only promotions in status 90-'Ended' and their transactions are included in this archive function.

The soft selection in (OIS700) is promotion, valid to date, and promotion responsible.

You can archive or delete promotions configured for supplier rebate on sales with claim transactions in status 70-'Updated in accounts payable ledger' or 90-'Closed' in 'Supplier Rebate Inv Transaction. Display' (PPS127).

You can archive or delete promotions with initial supply orders if the demand order is in status 90-'Closed' in 'Demand Order. Open' (RPS170).

COP - Customer Order Processing

  • 'Batch Customer Order. File Transferred' (OIS080)

    This function archives the records in these tables:

    Table Description (TF=Transaction File, WF=Work File)
    OXLINE TF: Batch order line
    OXHEAD TF: Batch order header
    OXCNTR TF: Batch order, control records
    OXADRE TF: Batch order, addresses
    OSYTXH TF: Batch order, text header
    OSYTXL TF: Batch order, text lines
    OXCOPY WF: Copy parameters for batch orders
    OXQUOH TF: Batch order, CO quotation
    OXSREB TF: Manual Supplier Rebate – Batch order line
    OXCOLI TF: Batch order line
    TCERRM MF: Batch order, Error log file
    Note: Only batch orders in status 90 in 'Batch Customer Order. Open' (OIS275) are included in this archive function.

    The soft selection on customer order number in (OIS080) refers to the temporary customer order number, not the final customer order number.

  • 'Quotation, Del & Cld CO. Archive/Delete' (OIS702)

    This function archives customer orders without deliveries in status 05-'Quotation', 90-'Deleted', or 99-'Flagged as comp'.

    The soft selection criteria in (OIS702) are the lowest status – customer order, customer order number, customer, order date, payer, and customer order type.

    This function archives the records in these tables:

    Table Description (TF=Transaction File)
    OOHEAD TF: Customer order header
    OOQUOH TF: Quotation order header
    OOCHRG TF: Order charges per customer order
    OOSAEQ TF: Pricing of items sold against equipment
    OOPAYH TF: Customer order prepayment header
    OOPAYL TF: Customer order prepayment line
    OOHEAC TF: Commission receiver
    OOADRE TF: CO header address
    OODOCU TF: Customer order documents
    OOPINV TF: Pre-payment invoice
    OOLINE TF: CO lines
    OOLIPI TF: CO lines purchase information
    MATORL TF: Attribute order reference line
    OOPRED TF: Pre-payment control
    OOLICH TF: CO line charge
    OOLICT TF: CO line charge
    OOCOLI TF: CO line file
    OORESC TF: Re-scheduling CO line
    OOOREF TF: CO line reference - BO line
    OOSREB TF: One-time supplier rebate
    OIPROI TF: Price override information
    ORSNET TF: Delivery schedule
    OKITDI TF: Kit discount amt
    OEXPRI TF: External order prices
    OSYTXH TF: Text, head
    OSYTXL TF: Text, line
  • 'Customer Order. File' (OIS090)

    This function archives customer orders.

    Note: The statistics on orders received cannot be recreated in 'Order Received Stats. Re-create' (OSS990) based on the customer order lines if the customer orders are archived. The detailed information tracking for the customer order from a purchase order number is not available if the customer order line type is 1 or 2. The detailed information tracking between customer order and invoice number is also not available after the archiving.

    Customer orders in (OIS100) with a lowest status in the order header of 77 or 79 are included in the archiving. Customer orders with a lowest status of 66 can also be included in the archiving if invoicing is disabled for the customer order type.

    The soft selection criteria in (OIS090) are the invoice date, accounting date, invoice number, customer order number, customer number, payer, delivery date, currency, and customer order type.

    This function archives the records in these tables:

    Table Description (TF=Transaction File)
    OOHEAD TF: Customer order header
    OOLINE TF: Customer order, detail lines
    OODOCU TF: Customer order, documents
    OOCHRG TF: Customer order, charges
    OOLICH TF: Item charges per order line
    OOADRE TF: Customer order, address
    OOPINV TF: Pre-payment invoice
    OSYTXH TF: Order text, header
    OSYTXL TF: Order text, lines
    ODHEAD TF: Delivery customer order, header
    ODLINE TF: Delivery customer order, detail lines
    ODDOCU TF: Delivery customer order, documents
    OORESC TF: Rescheduled customer order lines
    OKITDI MF: Kit discount amt converted to percentage
    OCUMOT MF: Cumulative amounts for order total disc
  • 'CO Invoice. Archive/Delete' (OIS701)

    Only invoices that have the lowest status 90 in 'Invoice. Display' (OIS350) are included in this archive function.

    The soft selection criteria in (OIS701) are the entry date, invoice number, payer, voucher number, status, and accounting date.

    Invoices that have been paid in the cash desk must, however, be archived in 'CO Invoice. Archive' (OIS095).

    This function archives the records in these tables:

    Table Description (TF=Transaction File)
    OINVOH TF: Invoice header
    OINVOL TF: Invoice line
    OINACC TF: Invoice accounting
    CINXRF TF: Invoice number references
    CTAXLN TF: Tax calculation values
    OADDTX TF: Invoicing, additional tax description
    OICORR TF: Invoice correction
    OINREF TF: Invoice reference
    OIPRTD TF: Perception and Retention Tax Details
  • 'CO Invoice. File' (OIS095)

    Only invoices that have the lowest status 90 in (OIS350) are included in this archive function.

    The soft selection criteria in (OIS095) are the entry date, invoice number, payer, voucher number, status, accounting date, and filing transaction.

    This function archives the records in these tables:

    Table Description (TF=Transaction File)
    OINVOH TF: Invoice header
    OINVOL TF: Invoice line
    OINACC TF: Invoice accounting
    OPAYMH TF: Payments
    OPAYMD TF: Payments details
    OINREF TF: Invoice reference
    OIPRTD TF: Perception and Retention Tax Details
  • 'Bulk Order Batch. Archive' (OIS945)
    Note: Only bulk order batch transactions with status 90 and work in progress at 0 are included in this archive function.

    The soft selection criteria in (OIS945) are the bulk order batch origin, customer, message no, blanket agreement no, and start date.

    This function archives the records in these tables:

    Table Description (TF=Transaction File)
    OXBETR TF: Bulk order - batch entry transactions
    OXGRLN TF: Customer agreement - lines Batch
    OXGRPR TF: Customer agreement - price Batch
  • 'Delivery Schedule. Archive' (RSS190) archives customer delivery schedules viewed in 'Delivery Schedule. Display History' (RSS300).

    Records from these tables are archived:

    Table Description (TF=Transaction File)
    ORAHED TF: Historical delivery schedules, Head
    ORAITM TF: Historical delivery schedules, Item
    ORACUM TF: Historical delivery schedules, Cum
    ORADNR TF: Historical delivery schedules, Del Note
    ORAADR TF: Historical delivery schedules, Addresses
    ORAINS TF: Historical delivery schedules, Instr
  • 'Customer Return. Archive/Delete' (OIS094)

    The soft selection criteria in (OIS094) are the return date, warehouse, receiving number, customer, status credit, CO type, and lowest status.

    This function archives the records in these tables:

    Table Description (TF=Transaction File)
    OCHEAD TF: Customer returns header
    OCLINE TF: Customer returns - lines
    ORINSP MF: Inspection statistics
    OSYTXH TF: Customer returns, text header
    OSYTXL TF: Customer returns, text lines

COB - Bonus and Commission

  • 'Bunos/Comm Agreement. Archive/Delete' (OIS704)

This function archives the records in this table:

Table Description (TF=Transaction File, MF=Master data file)
OBONAG MF: Bonus agreement file
OBONST MF: Bonus Status per Recipient
OBOPER TF: Bonus Status per Recipient per Period
OBOTRA TF: B/C Transaction file
OBONSR MF: Bonus Agreement Staggered Rates
OBOACP MF: Bonus Allocation
OBOPAY TF: Bonus Payouts
OBONSU MF: Bonus Substitution Hierarchy
OXBORE TF: Bonus - reserved amount
OSYTXH MF: Text, head
OSYTXL MF: Text, line
Note: 

Only a bonus and commission agreement in status 90-'Inactive' and its transactions are included in this archive function.

The soft selection in (OIS704) is valid to date, facility, bonus and commission agreement, and customer.

SST - Sales Statistics and Performance

  • 'Sales Statistics. File' (OSS080)

    The only possible selection in (OSS080) is 'To invoice date'.

    This function archives the records in this table:

    Table Description (TF=Transaction File)
    OSBSTD TF: Sales statistics/details
  • 'Sales Statistics Details. Archive/Delete' (OSS085)

    This function archives or deletes records of sales statistics details.

    Archiving or deletion of records is executed with respect to the archiving policy set for (OSS085) in 'Archiving. Open Toolbox' (AMS100). The archiving policy sets a minimum period that data must remain in the system before it can be archived or deleted. If the 'Archiving Policy 1' field is left blank, the process does not consider any policy.

    If the user is logged in with a specific division, that division is used in (OSS085). If the user is logged in with a blank division, the user can specify the division to be used for archiving or deletion in the division field in (OSS085).

    Note: Only sales statistics details that have record status equal to or greater than 77 can be archived or deleted with this function.

    This function archives and deletes the records in this table:

    Table Description
    OSASTD HF: Order sales statistic/Detail

POS - Point of Sales Integration

  • 'Sales Ticket Entry. File Transferred' (OPS080)

    The selection criteria in (OPS080) are Facility, Warehouse, Transaction date, and Entry date.

    Note: Only sales ticket entries that have Record status equal to 80 are included in this archive function.

    This function archives the records in these tables:

    Table Description (TF=Transaction File)
    OPSALE TF: Sales ticket input
    OXSALE TF: Sales ticket stat info
    OXSCTR TF: Sales ticket batch order
    OXSERR TF: Sale ticket control
    OPSTAT TF: Sales ticket control error related
  • 'Sales Ticket Financial Info. File Transferred' (OPS090)

    The soft selection criteria in (OPS090) are Facility, Warehouse, Accounting date, and Entry date.

    Note: Only sales ticket entries that have Record status equal to 80 are included in this archive function.

    This function archives the records in this table:

    Table Description (TF=Transaction File)
    OPWFIN TF: Sales ticket finance input