SLS - M3 BE Sales Management

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.

  • 'Customer Order. File Deleted' (OIS085)

    The soft selection criteria in (OIS085) are the customer order number, customer number, 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
    Note: Only customer orders in status 90 can be archived. These orders were manually deleted in (OIS100).
  • 'Customer Order. File' (OIS090)

    This function archives customer orders.

    Note: The statistics on orders received cannot be recreated in (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. File' (OIS095)

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

    The soft selection criteria in 'CO Invoice. File' (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
    OOAPMT WF: Selected cash payments for archival
  • '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 'Bulk Order Batch. Archive' (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

SST - Sales Statistics and Performance

  • 'Sales Statistics. File' (OSS080)

    The only possible selection in 'Sales Statistics. File' (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 'Sales Ticket Entry. File Transferred' (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 'Sales Ticket Financial Info. File Transferred' (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