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