Skip to content

Feature - Add New Data Sources for File SY12MONS

Release Date: 4/9/2016

Updated: 8/8/2018

Exanded the amount of data written to the SY12MONS file.

-----------------------

Invoice posting program CP0305 creates updated or new records that correspond to updates of the following files:

ARCUSFIL (SY12MONS-REFERENCE is Customer Number)
  TYPE 01
      AMOUNT 1: Total Sales for the customer by period
      AMOUNT 2: Total Cost for the customer by period
      AMOUNT 3: Number of invoices for the customer by period

ARCUSTYP (SY12MONS-REFERENCE is Customer Type)
  TYPE 01
      AMOUNT 1: Total Sales for the customer type by period
      AMOUNT 2: Total Cost for the customer type by period
      AMOUNT 3: Number of invoices for the customer type by period

ARCDEVIA (SY12MONS-REFERENCE is Ship Via Code)
  TYPE 01
      AMOUNT 1: Order Total Sale Amount for the ship via code by period
      AMOUNT 2: Order Total Weight for the ship via code by period
      AMOUNT 3: Order Total Volume for the ship via code by period
      AMOUNT 4: Number of invoices for the ship via code by period

ARSLMFIL (SY12MONS-REFERENCE is Salesman Number)
  TYPE 01
      AMOUNT 1: Total Sales for the Salesman by period
      AMOUNT 2: Total Cost for the Salesman by period
      AMOUNT 3: Total Commission for the Salesman by period
      AMOUNT 4: Number of invoices for the salesman by period

ARCDETAX (SY12MONS-REFERENCE is Tax Code from the Order Header File)
  TYPE 01
      AMOUNT 1: Sales amount for the Tax Code by period
      AMOUNT 2: Tax amount for the Tax Code by period
      AMOUNT 3: Miscellaneous amount for the Tax Code by period
      AMOUNT 4: Freight amount for the Tax Code by period

ARCDETRM (SY12MONS-REFERENCE is Order Terms Code)
      AMOUNT 1: Total Sales for the Order terms code by period
      AMOUNT 2: Number of invoices for the Order terms code by period

CPSHPFIL (SY12MONS-REFERENCE is Customer Number, Ship-To Number)
  TYPE 01
      AMOUNT 1: Total Sales for the customer by period
      AMOUNT 2: Total Cost for the customer by period
      AMOUNT 3: Number of invoices for the customer/Ship-To by period

IMCATFIL (SY12MONS-REFERENCE is the Product Category)
  TYPE 01
      AMOUNT 1: Line Item Sales amount for the Product Category by period
      AMOUNT 2: Line Item Cost amount for the Product Category by period

IMLOCFIL (SY12MONS-REFERENCE is Order Mfging Location)
  TYPE 01
      AMOUNT 1: Line Item Sales amount for the Location by period
      AMOUNT 2: Line Item Cost amount for the Location by period

-----------------------

AP transaction register program AP02P1 creates updated or new records that correspond to updates of the following files:

APVENFIL (SY12MONS-REFERENCE is the Vendor Number)
  TYPE 01
      AMOUNT 1: Vendor purchases for the Vendor by period
      AMOUNT 2: Vendor amount paid for the Vendor by period
      AMOUNT 3: Vendor discounts for the Vendor by period

-----------------------

AP Open Item adjustment program AP06P1 creates updated or new records that correspond to updates of the following files:

APVENFIL (SY12MONS-REFERENCE is the Vendor Number)
  TYPE 01
      AMOUNT 2: Vendor amount paid for the Vendor by period
      AMOUNT 3: Vendor discounts for the Vendor by period

-----------------------

AP Check Register program AP08P3 creates updated or new records that correspond to updates of the following files:

APVENFIL (SY12MONS-REFERENCE is the Vendor Number)
  TYPE 01
      AMOUNT 2: Vendor amount paid for the Vendor by period
      AMOUNT 3: Vendor discounts for the Vendor by period

-----------------------

AP Void checks program AP08P4 creates updated or new records that correspond to updates of the following files:

APVENFIL (SY12MONS-REFERENCE is the Vendor Number)
  TYPE 01
      AMOUNT 2: Vendor amount paid for the Vendor by period
      AMOUNT 3: Vendor discounts for the Vendor by period

-----------------------

PR Post Checks program PRPSTCHK creates updated or new records that correspond to updates of the following files:

EMPFILE (SY12MONS-REFERENCE is the Employee Number)
  TYPE 01
      AMOUNT 1: Gross Pay for the employee by period
      AMOUNT 2: Taxable Gross for the employee by period
      AMOUNT 3: FICA Tax for the employee by period
      AMOUNT 4: Federal Withholding Tax for the employee by period

  TYPE 02
      AMOUNT 1: Earned Income Credit for the employee by period
      AMOUNT 2: State Withholding Tax for the employee by period
      AMOUNT 3: Other State Tax for the employee by period
      AMOUNT 4: City Withholding Tax for the employee by period

  TYPE 03
      AMOUNT 1: Tips Reported for the employee by period
      AMOUNT 2: Employee Meals for the employee by period
      AMOUNT 3: Total Deductions for the employee by period
      AMOUNT 4: Tip Credit for the employee by period

  TYPE 04
      AMOUNT 1: Total Allowances for the employee by period
      AMOUNT 2: Net Pay for the employee by period
      AMOUNT 3: Union Deduction for the employee by period
      AMOUNT 4: Regular Hours for the employee by period

  TYPE 05
      AMOUNT 1: Special hous for the employee by period
      AMOUNT 2: Overtime Hours for the employee by period
      AMOUNT 3: Medicare Tax for the employee by period 

Modified Programs: CP0305, AP02P1, AP06P1, AP08P3, AP08P4, PRPSTCHK

DLM


Feedback and Knowledge Base