SAP DOCUMENT TYPE INVENTORY

SAP DOCUMENT TYPE INVENTORY DOC TYPE DESCRIPTION DOCUMENT TYPES IN PRODUCTION Asset Posting AA AB Accounting Document FUNCTIONAL TEAM(S) Fixed A...
Author: Octavia Pearson
225 downloads 0 Views 460KB Size
SAP DOCUMENT TYPE INVENTORY

DOC TYPE

DESCRIPTION

DOCUMENT TYPES IN PRODUCTION Asset Posting AA AB

Accounting Document

FUNCTIONAL TEAM(S)

Fixed Assets Various

PURPOSE OR TRIGGER

Any asset transaction with the exception of depreciation.

SAP TRANSACTION

Many Fixed Assets transactions codes. FBS1, FB08 and auto program

DOC NUMBER RANGE

DOCUMENT RANGE FROM

DOCUMENT RANGE TO

01

0100000000

0199999999

IS THIS DOC OR A RELATED ONE SENT TO TREASURY FROM SAP OR ANOTHER SYSTEM FOR PAYMENT OR RECEIPT?

REAL FM POSTING YES / NO

NO

REVERSING DOC TYPE

AUTH GROUP

None

SAP invoice documents posted via payroll system in SAP. For auditing of payments in payment program, the payroll system triggered invoices are required to be separated. Also reverses ZT documents. Also clearing documents for some OIM G/L accounts. Any asset depreciation transaction. AFABN

01

0100000000

0199999999

NO

No Sometimes

No

AB

KR01

DEBIT / CREDIT ENTRIES

GL ACCT CODE ITEM CAT (CONFIG)

D - Asset C - Expense

1900000 series

D - Expense C - Accum. Dep. D/C - Expense D/C - Revenue

1900000, 3100000 and 6800000 series Any Expense or Revenue accounts

D - Vendor C - Expense D - Adv. Acct C - Cash Replenish. Adv. Acct. D - Cash C - Cash or Cash-InTransit

Any Vendor or Expense Account D - 104xxx0 C - 1000001

AF

Depreciation Posting

Fixed Assets

03

0300000000

0399999999

NO

AF

KR01

AM

Adjustment Memo

Cash Management

Adjustment Memo postings in SAP. SAP prints paper form FB50, FV50 to send to Treasury.

00

0088000000

0088999999

YES, paper AM YES document sent to Treasury from SAP with SAP reference #.

AM

RV01

AZ

Accounts Payable

Reverse Document Type for ZA (Advancement Account)

FB08

17

1700000000

1799999999

NO

YES

AZ

ZA01

BA

Advancement Account Invoice Reversal BAI File Replenishment

Cash Management

Cash replenishment to Advancement Account.

FB50

01

0100000000

0199999999

NO

No

BA

KR01

CC

Cash Clearing

Cash Management

Post cash clearings based on file received from Treasury

FB50

01

0100000000

0199999999

NO

No - cash to cash or cash to cash-intransit postings only

CC

N/A

CK

Vendor Clearing

Grants; Procurement; Accounts Payable

Clear open vendor items

F.13, F-44, etc.

10

1092000000

1099999999

YES

No

CK

N/A

DA

Customer Document

Accounts Receivable

Accounts Receivable Customer adjustment document, includes transfer postings/clearing, reversal and write-off transactions.

FB08, FBRA, F-30

16

1600000000

1699999999

NO

YES

DA

ZA01

DB

Cust Write Off Doc

Accounts Receivable

Manual Accounts Receivable write offs

FB05, FB08, FB75

16

1600000000

1699999999

NO

YES

DB

ZA01

DC

GM Federal Billing

Grants

Resource Related Customer invoices posted in SAP for the custom transaction Grants Federal Billing process. calling VF01

23

2300000000

2399999999

NO

YES, but offset immediately by DD

DC

DD

GM Offset Fed Billng

Grants

Resource Related Customer invoice offset and clearing posted in SAP for the Grants Federal Billing process.

FB05

23

2300000000

2399999999

NO

YES, but offset immediately by DD

DC

DE

Payroll Receivables

Accounts Receivable

Accounts Receiveable Customer invoices posted in SAPfor Payroll Employee Recivables (BCPO use only).

FB70

18

1800000000

1899999999

NO

YES

DA

ZA01

DF

FSP Customer Invoice

Accounts Receivable

Accounts Receivable Federal Surplus Property customer invoices which are not generated from SAP, but the receivable information is stored and managed in SAP.

FB70

18

1800000000

1899999999

NO

YES

DA

ZA01

D - Customer (Trade C - 4435720 receivables) C - Revenue

DG

Customer Credit Memo

Accounts Receivable

Accounts Receivable Credit memos.

FB75

16

1600000000

1699999999

NO

YES

DA

ZA01

D - Revenue D - Any Revenue C - Customer (Trade Account receivables)

5/7/2012

Cash Account

D - Vendor C - Vendor

2100300, 2100400, 2100500, 2100600, 2100700, 2100800 D - Customer (Trade Various Revenue or receivables) Expense Accounts C - Customer (Trade receivables) D - Rev or Expense Various Revenue or C - Customer (Trade Expense Accounts receivables) D - Customer D - 1300510 (recon (Grantor) acct.) C - Grant Revenue C - 4000250 D - Customer D - 1300510 (recon (Grantor) acct.) C - Grant Revenue C - 4000250 D - Customer Various Expense C - Expense accounts

2:42 PM S:\Finance\FI_COMMON\Doc Types\Old Document Type for Web Version\Document Type Listing for WEB 05072012

Page 1 of 9

SAP DOCUMENT TYPE INVENTORY

DOC TYPE

DESCRIPTION

FUNCTIONAL TEAM(S)

PURPOSE OR TRIGGER

SAP TRANSACTION

DOC NUMBER RANGE

DOCUMENT RANGE FROM

DOCUMENT RANGE TO

IS THIS DOC OR A RELATED ONE SENT TO TREASURY FROM SAP OR ANOTHER SYSTEM FOR PAYMENT OR RECEIPT?

REAL FM POSTING YES / NO

REVERSING DOC TYPE

AUTH GROUP

DEBIT / CREDIT ENTRIES

GL ACCT CODE ITEM CAT (CONFIG)

DI

Customer Loxkbox Payment w/o Remit

Accounts Receivable

Accounts Receivable customer payments for the Insurance ZFLBMAIN Lockbox payment process. These types of payments require a unique Revenue Transmittal document, 'Transmittal without Remittance'. The program that automatically creates the Revenue Transmittal document needs a way to identify a Transmittal Without Remittance versus a Transmittal With Remittance (checks attached). This changed when Dpt of Rev became the lockbox bank. This Doc Type now generates a with remittance RT.

14

1400000000

1499999999

YES, Related Revenue Transmittal generated in SAP goes to Treas

YES

DI

ZA01

D - Lock box clearing D - 1399900 C-Customer

DL

Lockbox GL Posting

Accounts Receivable

ZFLBMAIN

01

0100000000

0199999999

NO

YES

AB

ZA01

D - Cash-in-Transit C - 1399900 C - Lockbox Clearing

DN

Adj Doc for NSF Checks

Accounts Receivable

FB50

01

0100000000

0199999999

NO

YES

DN

ZA01

D - Revenue D - Any Revenue GL C - Cash in Transit / Lockbox Clearing

DP

Federal Highway Administration (FHWA) Billing

Project Systems

FB70

18

1800000000

1899999999

NO

YES

DA

KR01

D - Customer C - Revenue

C - Any Revenue Account

DQ

Federal Highway Administration (FHWA) Credit Memo

Accounts Receivable

Accounts Receivable customer payments for Insurance Lockbox. When the Lockbox file is posted to SAP, the initial posting (entire deposit amount) is posted to the Bank G/L account and a Lockbox clearing account. This transaction is followed by a second interface transaction using document type DI. Accounts Recivable customer payment NSF Adjustment document bank statement reconciliation in revenue. Journal entry adjusts the Revenue Transmittal information in situations where the lockbox bank has notified the Comptroller Office of bounced checks. Accounts Receivable customer invoice for USDOT FHWA billing twice each week for the federal share of highway project expenditures. Accounts Receivable Credit memos posted in SAP, for PennDOT FHWA billing only.

FB75

16

1600000000

1699999999

NO

YES

DA

ZA01

D - Any Revenue Account

DR

Customer Invoice

Accounts Receivable

FB70

18

1800000000

1899999999

NO

YES

DA

ZA01

DS

Customer Payment to create Refund of Expenditures

Accounts Receivable

F-26; F-28

10

1092000000

1099999999

ZA01

Transfer Voucher Payment

Accounts Receivable

F-30

14

1400000000

1499999999

YES, Refund of YES Expenditures document YES, Reference YES document from legacy system

DS

DT

DT

ZA01

D - Revenue D - Any Revenue C - Customer (Trade Account receivables)

DW

Customer Payment w/o Remit

Accounts Receivable

Accounts Receivable - Invoices produced and printed in SAP. Accounts Receivable Customer payments received for which a Refund of Expenditures document is produced (with remittance). Accounts Receivable customer payments where a Revenue Transmittal is not to be generated (Transfer Voucher payments or where an RT was produced outside of SAP). Accounts Receivable customer payments that require a "Transmittal of Revenue without Remittance" be prepared by the sytstem. As of 2/4/03 PUC and Banking Lockbox processes utilize DW docs. The program that automatically creates the Revenue Transmittal document needs a way to identify a Transmittal without Remittance versus a Transmittal with Remittance (checks attached).

D - Revenue C - Customer (Trade receivables) D - Customer C - Revenue D - Cash in Transit C - Expense

F-26; F-28

14

1400000000

1499999999

YES, Revenue YES Transmittal document from SAP

DW

ZA01

D - Cash in Transit D - 1003000 C - Customer (Trade receivables)

DX

External Created Invoice

Accounts Receivable

Accounts Receivable customer invoices that are generated FB70 /printed external to SAP

18

1800000000

1899999999

NO

YES

DA

ZA01

DZ

Customer Payment w/ Remit

Accounts Receivable

Accounts Receivable customer payments received where a F-26; F-28 Revenue Transmital with remittance is required.

14

1400000000

1499999999

DZ

ZA01

EA

Expense Adjustment

General Ledger

Used to transfer expenses between BAs and/or Funds FB50, FV50 and/or expense commitment items. Documents are sent to Treasury only if the first seven positions of the Fund are different.

78

7800000000

7899999999

YES, Revenue YES Transmittal document from SAP YES, this document YES from SAP if 1st 7 pos. of Fund are different

D - Customer (Trade receivables) C - Revenue D - Cash in Transit C - Customer (Trade receivables) D - Expense CI C - Expense CI

5/7/2012

EA

C - Any Revenue Account C - Any Expense Account

C - Any Revenue Account D - 1003000

D - 103000 C - 120000 AR Recon acct

2:42 PM S:\Finance\FI_COMMON\Doc Types\Old Document Type for Web Version\Document Type Listing for WEB 05072012

Page 2 of 9

SAP DOCUMENT TYPE INVENTORY

DOC TYPE

DESCRIPTION

FUNCTIONAL TEAM(S)

PURPOSE OR TRIGGER

SAP TRANSACTION

DOC NUMBER RANGE

DOCUMENT RANGE FROM

DOCUMENT RANGE TO

IS THIS DOC OR A RELATED ONE SENT TO TREASURY FROM SAP OR ANOTHER SYSTEM FOR PAYMENT OR RECEIPT?

REAL FM POSTING YES / NO

REVERSING DOC TYPE

AUTH GROUP KR01

DEBIT / CREDIT ENTRIES

EB

Exp Adj - Work Comp

Payroll

Used to reclass Work Comp (Act 534 and Heart & Lung) FB50, FV50 expenses from a general restricted receipt account back to the employees' agency. Documents are sent to Treasury only if the first seven positions of the Fund are different.

78

7800000000

7899999999

YES, this document YES from SAP if 1st 7 pos. of Fund are different

EB

GD

GM Delay of Draw

Grants

23

2300000000

2399999999

NO

No statistical based on gl account

GD

D - Expense CI (real D - 6900999 (real grant) grant) C - 6900999 (z_non-rel C - Expense CI grant) (z_non-rel grant)

GL

GM LPO-Delay of Draw

Grants

23

2300000000

2399999999

NO

No statistical based on gl account

GL

D - Expense CI (real D - 6900999 (real grant) grant) C - 6900999 (z_non-rel C - Expense CI grant) (z_non-rel grant)

GN

GM No Delay of Draw

Grants

Created from nightly job run for program FB50 ZF_OTHE_GM_EXP_TRNS_TO_GMIA which creates GD documents for invoices and VT doc types posted to federal funds. Doc type used for posting directly to a grant for federal billing. Created from nightly job run for program FB50 ZF_OTHE_GM_EXP_TRNS_TO_GMIA which creates GL documents for ZO doc types posted to federal funds to create entry on GMIA. Doc type used for posting directly to a grant for federal billing. Created from nightly job run for program FB50 ZF_OTHE_GM_EXP_TRNS_TO_GMIA which creates GN documents for FI adjustment doc types and cost allocations posted to federal funds to show on GMIA. Doc type used for posting directly to a grant for federal billing.

23

2300000000

2399999999

NO

No statistical based on gl account

GN

D - Expense CI (real D - 6900999 (real grant) grant) C - 6900999 (z_non-rel C - Expense CI grant) (z_non-rel grant)

GR

GM Refunds-No Delay

Grants

FB50

23

2300000000

2399999999

NO

No statistical based on gl account

GR

D - Expense CI (real D - 6900999 (real grant) grant) C - 6900999 (z_non-rel C - Expense CI grant) (z_non-rel grant)

GT

Statutory Transfer

General Ledger

FB50, FV50

09

0993000000

0993999999

YES, this document from SAP

YES

GT

KR01

D- Expense CI C- Revenue CI

D- Expense CI C- Revenue CI

KA

Vendor Invoice Reversal

Accounts Payable

FB08

17

1700000000

1799999999

NO

YES

KA

KR01

KB

Vendor Invoice Reversal Decentralized Vendor Incoming Payment

Accounts Payable

FB08

17

1700000000

1799999999

NO

YES

KB

KD01

KC

F-52

10

1092000000

1099999999

NO

No

KC

KR01

D - Vendor C - Expense D - Vendor C - Expense D - Cash in Transit C - Vendor

Any Vendor or Expense Account Any Vendor or Expense Account D - 1003000 C - Any Vendor Account

KD

Vendor Invoice - Decentralized

Accounts Payable

Created from nightly job run for program ZF_OTHE_GM_EXP_TRNS_TO_GMIA which creates GR documents for refund doc types posted to federal funds to show on GMIA. Doc type used for posting directly to a grant for federal billing. Separate document type used for Statutory Transfers which require the Governor's designee's signature and a separate transaction code for Treasury. Reverse Document Type for Accounts Payable (Reverse KR) Reverse Document Type for Accounts Payable Decentralized (Reverse KD). Used to record payments received from vendors for overcharges/refunds. This transaction is preceded by transaction FB65 using doc type KS or KW. Non-PO invoice entered directly into SAP by the Agency

FB60

19

1900000000

1999999999

YES

KA

KD01

KG

Vendor Credit Memo

Accounts Payable

Used to record credit received from vendors to be applied against an existing unpaid or future vendor invoices.

FB65

17

1700000000

1799999999

YES, ZP clearing document from SAP NO

YES

KG

KD01

D - Expense C - Vendor D - Expense C - Vendor

Any Vendor or Expense Account Any Vendor or Expense Account

KH

Vendor Credit Interface

Grants

17

1700000000

1799999999

Yes, KS clearing document from SAP

YES

KH

KR01

D - Vendor C - Expense

KJ

Vendor Credit Offset

Grants

Used to record credit offset entry for subrecipient payments FB65 posted by Interface or Conversion program where amount is a negative amount (a credit or refund). This FB65 transaction mirrors the FB60 payment transaction made using doc type ZN and is only used to execute F-44 clearing transaction. Used to record credit offset entry for subrecipient payments FB65 posted by Interface or Conversion program where actual payment was a postive amount. This FB65 transaction mirrors the FB60 payment transaction made using doc type ZD and is only used to execute F-44 clearing transaction.

17

1700000000

1799999999

NO

YES

KJ

KR01

D - Vendor C - Expense

5/7/2012

Cash Management

D - Expense CI C - Expense CI

GL ACCT CODE ITEM CAT (CONFIG) D - 103000 C - 120000 AR Recon acct

2:42 PM S:\Finance\FI_COMMON\Doc Types\Old Document Type for Web Version\Document Type Listing for WEB 05072012

Page 3 of 9

SAP DOCUMENT TYPE INVENTORY

DOC TYPE

DESCRIPTION

FUNCTIONAL TEAM(S)

PURPOSE OR TRIGGER

SAP TRANSACTION

DOC NUMBER RANGE

DOCUMENT RANGE FROM

DOCUMENT RANGE TO

KL

LEG Refund w Remit

Cash Management

Vendor Refund of Expenditures - Legacy manual paper Refund documents with remittance. This transaction is followed by transaction F-52 using doc type KC to post Cash-In-Transit entry.

FB65

10

1092000000

1099999999

KO

LEG Refund wo Remit

Cash Management

Vendor Refund of Expenditures - Legacy manual paper Refund documents without remittance. This transaction is followed by transaction F-52 using doc type KC to post Cash-In-Transit entry.

FB65

10

1092000000

1099999999

KP

Account Maintenance

Procurement

MR11

48

4800000000

4899999999

KR

Vendor Invoice

Accounts Payable

Used to clear vendor account discrepancies due differences between Goods Receipt and Invoice Receipt. Non-PO invoice entered directly into SAP.

FB60 and FBR2

19

1900000000

1999999999

KS

Vend Refund w Remit

Cash Management

Vendor Refund of Expenditures (Subrecipient and others) with remittance. User prints the deposit transit slip from SAP via ZF_DEPOSIT transaction and SAP prints paper form to send to Treasury. Vendor Refund of Expenditure transactions are followed by transaction F-52 using doc type KC to post Cash-In-Transit entry. KS also identifies vendor clearing documents.

Auto program or FB65 or FV65

10

1092000000

1099999999

KT

Interagency Accounts Payable Adjustment

Accounts Receivable

System generated transaction to clear accounts payable document type RN for Correctional Industries Billings to other agencies. Effective 7/1/07 Plant Maint will also use KT to clear Print Shop inventory orders.

F.51

31

3100000000

3199999999

KU

Utility Invoices

Accounts Payable

19

1900000000

1999999999

KW

Vendor Refund wo Remit

Cash Management

10

1092000000

1099999999

KZ

Vendor Advancement Account Payment

Accounts Payable

Non-PO utility invoices entered via FB60, Web DynPro, and FB60 INTF_0492 Vendor Refund of Expenditures (Subrecipient and others) FB65 or FV65 without remittance. SAP prints paper form to send to Treasury. Vendor Refund of Expenditure transactions are followed by transaction F-52 using doc type KC to post Cash-In-Transit entry. Vendor Payment documents for post with advancement F-58 account payments

15

1500000000

LB

PCard Interface

Cost Allocation

37

LT

Travel Card Interface

Travel

Automated transaction to distribute Purchasing Card FB50 amounts billed to the correct agency and funding source. To be put in effect 3/1/2003 in conjunction with new PNC file process. Automated transaction to distribute Travel Card amounts FB50 billed to the correct agency and funding source. To be put in effect 2/11/2004 in conjunction with new Travel interface.

PR

Price Change

Procurement

Used to revalue finished inventory, equipment or supplies to current value.

Project Settlement Vendor Payment Reversal

Commonwealth-wide & Project Systems Accounts Payable

Provide project settlements with their own unique number FB50; AUAK; CJ8G; range for postings to avoid contention with other processes CJ88 Reversal document type for ZP. FBRA

PS PZ

5/7/2012

MR21

IS THIS DOC OR A RELATED ONE SENT TO TREASURY FROM SAP OR ANOTHER SYSTEM FOR PAYMENT OR RECEIPT?

REAL FM POSTING YES / NO

REVERSING DOC TYPE

AUTH GROUP

DEBIT / CREDIT ENTRIES

GL ACCT CODE ITEM CAT (CONFIG)

YES, paper RE document sent to Treasury with legacy reference # from agency system. YES, paper RE document sent to Treasury with legacy reference # from agency system. NO

YES

KL

RV01

D - Vendor C - Expense

Any Vendor or Expense Account

YES

KO

RV01

D - Vendor C - Expense

Any Vendor or Expense Account

NO

KP

YES, ZP clearing document from SAP SOMETIMES (1) This document from SAP if it clears RN or ZD & KH docs OR (2) Reference document from SAP if refund created; Otherwise, not sent YES, Reference document from SAP. Revenue line from KT and expense line from RN = Transfer Voucher to Treasury. YES, ZP clearing document from SAP YES, paper RE document sent to Treasury from SAP with SAP reference #.

YES

KA

KR01

YES

KS

RV01

D - Vendor C - Expense D - Vendor C - Expense

Any Vendor or Expense Account Any Vendor or Expense Account

KT

KR01

YES

KA

KD01

YES

KW

RV01

D - Expense C - Vendor D - Vendor C - Expense

Any Vendor or Expense Account Any Vednor or Expense Account

1599999999

YES, this document from SAP

YES

ZK

ZA01

D - Vendor C - Adv Acct

3700000000

3799999999

YES, reference document from SAP

LB

KR01

D - Expense C - Expense

Any Vendor and Advancement GL ending in "4" C - 6395000 D - Various

30

3000000000

3099999999

YES, reference document from SAP

LT

KR01

D - Expense C - Expense

C - 6395000 D - 6311040

48

4800000000

4899999999

NO

None

KR01

D/C - Inventory, Equip, Supplies D/C - RevaluationBudget Inventory Acct D/C - AUC D/C - Final Asset D/C - 6599999 D - Invoices Payable C - Vendor

D/C - 1520000 or 1670000 D/C - 6381112

11 17

1100000000 1700000000

1199999999 1799999999

No NO

NO

No YES

PS PZ

DR01 KR01

D/C - AUC D/C - Final Asset D/C - 6599999 Invoices Payable and any Vendor

2:42 PM S:\Finance\FI_COMMON\Doc Types\Old Document Type for Web Version\Document Type Listing for WEB 05072012

Page 4 of 9

SAP DOCUMENT TYPE INVENTORY

DOC TYPE

DESCRIPTION

SAP TRANSACTION

Used to record invoices based on Purchase orders. InvoicingMRIS Plan invoices.

DOCUMENT RANGE TO 5199999999 5199999999

51

REAL FM POSTING YES / NO

RN

Invoice - Net

Procurement

Used to record invoices based on Purchase Orders. Also MIRO and MRRL used to record Purchase Order refunds with and without remittance. RN documents with Bank Code 874 identiied on them will be picked up by a collection program and SAP prints paper form to send to Treasury.

51

SA

G/L Account Document

Various

01

0100000000

0199999999

SB

G/L Account Posting

Commonwealth-wide & Grants

This is default doc type for FB50 screen. Used for BAI file FB50 upload and for many other purposes. Used for journal entries prepared to accrue revenues and FB50 expenditures by fund type throughout the year.

YES, ZP clearing YES document from SAP YES, ZP or KS YES clearing document from SAP OR Reference document from SAP (if Correctional Industries A/R) NO Sometimes

12

1200000000

1299999999

NO

SC

WBS Element to Internal Order Posting

Commonwealth-wide & Project Systems

Used for journal entries to post Project Systems WBS Element expenditures and adjustments to Internal Orders to capture appropriate federal, state and local shares.

FB50

17

1700000000

1799999999

NO

SD

SAP/TABS Reconciliation Entry

General Ledger

30

3000000000

3099999999

Yes, reference document from SAP or legacy system

SE

Payroll Expense Adjustment (in SAP only)

General Ledger

30

3000000000

3099999999

Yes, reference document from SAP or legacy system

SF

Fed Rev Dep wo Remit

Cash Management

Used for journal entries made to correct SAP errors found FB50 during the SAP Fund reconciliation when no other entry is appropriate. Reference document is the document number originally sent to Treasury. This doc type also bypasses the Ledger 4, 5, 6 substitution rule that puts 00 in positions 6-7 of the Fund. Transfer payroll expenses from between SAP Funds to FB50 agree with either a Treasury only EA or a phone call to Treasury to change the Fund on payroll DSNs (documents) they are unable to process due to an invalid Fund or a Fund without sufficient funds. Reference document is either the paper EA document or the Merge Run ID related to the original ZX document. SAP postings to Federal Revenue without remittance. SAP FB50 prints paper form to send to Treasury.

14

1400000000

SG

NonSAP Adj Memo

Cash Management

Used for agencies that interface Adjustment Memos to SAP. SAP prints paper form to send to Treasury.

FB50

07

SH

Year-End Advancement Account Posting

Cash Management

For use in Interface 0261 to TREAS for FI year-end Advancement Account related documents. Do Not Use This Number Range for any OTHER Doc Type - EVER!

FB50

SI

LEG Revenue Document

Cash Management

Legacy paper miscellaneous Revenue document. (AM, DM, FB50 PY and TV)

5/7/2012

Procurement

PURPOSE OR TRIGGER

DOCUMENT RANGE FROM 5100000000 5100000000

RE

Invoice - Gross

FUNCTIONAL TEAM(S)

DOC NUMBER RANGE

IS THIS DOC OR A RELATED ONE SENT TO TREASURY FROM SAP OR ANOTHER SYSTEM FOR PAYMENT OR RECEIPT?

REVERSING DOC TYPE RE

AUTH GROUP

DEBIT / CREDIT ENTRIES

GL ACCT CODE ITEM CAT (CONFIG)

D - Expense C - Vendor D - Expense / Accrued Payble C - Vendor

Any Vendor or Expense Account Any Vendor or Expense Account

RN

RN01 RN01

SA

KR01

Various

AB

KR01

1300500 or 1300555 Balance Sheet and and offsetting to Revenue Accounts and 4000200 or 4000300 Commitment Items

SC

KR01

D - Expense C - Expense

YES

SD

KR01

Various

Revenue and Expense commitment items and 1000000

YES

SE

KR01

D/C - Expense CI D/C - Cash

Expense commitment items and 1000000

1499999999

YES, paper RT YES document sent to Treasury from SAP with SAP reference #.

SF

RV01

D - Drawdown D - 1300599 Federal Receivable C - 4xxxxxx C - Federal Revenue

0700000000

0799999999

SG

KR01

D-Exp or Rev C-Exp or Rev

D-6xxxxxx or 4xxxxxx C-6xxxxxx or 4xxxxxx

60

6000000000

6099999999

YES, paper AM YES document sent to Treasury from SAP with legacy reference #. YES, sent to Treasury via year-end file.

SH

KR01

D - 104xxxxx (Adv Acct) new fund year C - 104xxxx (Adv Acct) old fund year

D - 104xxxxx (AA Account new fund year) C - 104xxxx (AA Acount old fund year)

07

0700000000

0799999999

SI

KR01

Various

Various

Statistical

YES, paper AM, DM, YES PY or TV documents sent to Treasury with legacy reference # from agency system.

NO

2:42 PM S:\Finance\FI_COMMON\Doc Types\Old Document Type for Web Version\Document Type Listing for WEB 05072012

Page 5 of 9

SAP DOCUMENT TYPE INVENTORY

DOC TYPE

DESCRIPTION

FUNCTIONAL TEAM(S)

PURPOSE OR TRIGGER

SAP TRANSACTION

DOC NUMBER RANGE

DOCUMENT RANGE FROM

DOCUMENT RANGE TO

SJ

NonSAP RevDep w Rem

Cash Management

Used for agencies that interface Revenue with remittance FB50 to SAP. The agency prints the deposit transit slip from their system and SAP prints paper form to send to Treasury.

07

0700000000

0799999999

SK

NonSAP RevDep wo Rem

Cash Management

Used for agencies that interface Revenue without remittance to SAP. SAP prints paper form to send to Treasury.

FB50

07

0700000000

0799999999

SL

LEG RT w Remit

Cash Management

Legacy paper Revenue document with remittance.

FB50

14

1400000000

1499999999

SM

NonSAP Rev Doc

Cash Management

Used for RIS to SAP interface postings and Out of Scope Agency postings of Revenue documents (AMs, PYs and TVs).

FB50

07

0700000000

0799999999

SN

NonSAP Ref wo Remit

Cash Management

Used for agencies that interface Refund of Expenditures without remittance to SAP. Agency will send refund number. SAP prints paper form to send to Treasury.

08

0800000000

0899999999

SO

LEG RT wo Remit

Cash Management

Legacy paper Revenue document without remittance.

14

1400000000

1499999999

Post inter- and intra- agency transfers crediting a Revenue FB50 commitment item. SAP postings for Non-Accounts Receivable Revenue with FB50, FV50 remittance, User prints the deposit transit slip from SAP via ZF_DEPOSIT transaction and SAP prints paper form to send to Treasury.

09

0993000000

0993999999

14

1400000000

1499999999

FB50 FB50

IS THIS DOC OR A RELATED ONE SENT TO TREASURY FROM SAP OR ANOTHER SYSTEM FOR PAYMENT OR RECEIPT? YES, paper RT document sent to Treasury from SAP with legacy reference #. YES, paper RT document sent to Treasury from SAP with legacy reference #. YES, paper RT document sent to Treasury with legacy reference # from agency system. YES, paper AM, PY and TV documents sent to Treasury with legacy reference # from agency system. YES, paper RE document sent to Treasury from SAP with legacy reference #. YES, paper RT document sent to Treasury with legacy reference # from agency system. YES, this document from SAP YES, paper RT document sent to Treasury from SAP with SAP reference #.

REAL FM POSTING YES / NO

REVERSING DOC TYPE

AUTH GROUP

DEBIT / CREDIT ENTRIES

GL ACCT CODE ITEM CAT (CONFIG)

YES

SJ

KR01

D - Cash in Transit C - Revenue

D - 1003000, C - Any revenue account

YES

SK

KR01

D - Cash in Transit C - Revenue

D - 1003000, C - Any revenue account

YES

SL

RV01

D - Cash in Transit C - Revenue

D - 1003000, C - Any revenue account

YES

SM

KR01

Various

Various

Yes

SN

KR01

D - Cash in Transit C - Expense

D - 1003000 C - 6xxxxxx

YES

SO

RV01

D - Cash in Transit C - Revenue

D - 1003000, C - Any revenue account

YES

SP

KR01

YES

SQ

RV01

D - Expense CI C - Revenue CI D - Cash in Transit C - Revenue

D - Expense CI C - Revenue CI D - 1003000, C - Any revenue account

SP

SAP TV Credit Revenue

General Ledger

SQ

Rev Deposit w Remit

Cash Management

SR

NonSAP Rfd wo Remit

Cash Management

Used for agencies that interface Refund of Expenditures without remittance to SAP. Agency does not send refund number. SAP prints paper form to send to Treasury.

FB50

08

0800000000

0899999999

YES, paper RE No document sent to Treasury from SAP with SAP reference #.

SR

KR01

D-Cash in Transit C-Expense

D-1003000 C-6xxxxxx

SS

NonSAP Ref w Remit

Cash Management

Used for agencies that interface Refund of Expenditures with remittance to SAP. The agency prints the deposit transit slip from their system and SAP prints paper form to send to Treasury.

FB50

08

0800000000

0899999999

YES

SS

KR01

D-Cash in Transit C-Expense

D-1003000 C-6xxxxxx

ST

RAS Revenue posting

Cash Management

07

0700000000

0799999999

No

ST

KR01

SU

Adjustment Document

Various

01

0100000000

0199999999

NO

Sometimes

SU

D - Cash C - Cash In Transit Various

D- 1000000 C- 1003000 Various

SV

Rev Deposit wo Remit

Cash Management

RAS-SAP interface postings to G/L for Transmittals of FB50 Revenue - NO LONGER USED IN SAP. Post adjustments when no file for Treasury or the Revenue FB50 Interface System (RIS) is required. Also used for numerous other entries. SAP postings to Non-Accounts Receivable Revenue FB50, FV50 without remittance. SAP prints paper form to send to Treasury.

YES, paper RE document sent to Treasury from SAP with legacy reference #. No longer used

14

1400000000

1499999999

YES, paper RT YES document sent to Treasury from SAP with SAP reference #.

RV01

D - Cash in Transit C - Revenue

D - 1003000 C - Any revenue account

5/7/2012

SV

2:42 PM S:\Finance\FI_COMMON\Doc Types\Old Document Type for Web Version\Document Type Listing for WEB 05072012

Page 6 of 9

SAP DOCUMENT TYPE INVENTORY

DOC TYPE

DESCRIPTION

FUNCTIONAL TEAM(S)

PURPOSE OR TRIGGER

SAP TRANSACTION

DOC NUMBER RANGE

DOCUMENT RANGE FROM

DOCUMENT RANGE TO

IS THIS DOC OR A RELATED ONE SENT TO TREASURY FROM SAP OR ANOTHER SYSTEM FOR PAYMENT OR RECEIPT?

REAL FM POSTING YES / NO

REVERSING DOC TYPE

AUTH GROUP

DEBIT / CREDIT ENTRIES

GL ACCT CODE ITEM CAT (CONFIG)

D - Cash in Transit / Revenue C - Cash in Transit / Cash D - Cash in Transit C - Revenue

D - 1003000 / Any Revenue C - 1003000 / 1000000

SW

Revenue Reversal

Cash Management

To reverse refund and revenue postings made using doc types SR, ST, SY and SZ.

FB08, F.80

08

0800000000

0899999999

NO

YES

SW

KR01

SY

RIS Revenue Posting

Cash Management

RIS-SAP interface postings for Revenue.

FB50

07

0700000000

0799999999

SY

KR01

SZ

RIS Refund Posting

Cash Management

RIS-SAP interface postings for Refund of Expenditures.

FB50

08

0800000000

0899999999

SZ

KR01

D - Cash in Transit C - Expense

D - 1003000, C - Any expense account

VT

Legacy System VT

General Ledger & Grants Summarized Accounts Payable from various Legacy Systems. File is sent to Treasury from the legacy system.

Interface or manual FB50

VT

A000000000

Z999999999

YES, RT paper YES document sent to Treasury with legacy reference # from agency system. YES, RE paper YES document sent to Treasury with legacy reference # from agency system. YES - Last 8 positions YES of thIs document from legacy system

None

KR01

C - 2100200

WA

Goods Issue

Procurement

Used for distribution of materials from one agency to another or transfer of materials within an agency. Documents are sent to Treasury only if the first seven positions of the Fund are different and there is no revenue commitment item on the document.

MIGO and MB1A,B,C

49

4900000000

4999999999

YES, this document YES from SAP if 1st 7 pos. of Fund are different and there is no revenue commitment item on the document

None

D - Expense or Purchase of Investments C - Non-SAP Invoices Payable D - Expense 638* C - Inventory 16* C - 4200101 OR D - Expense C - Inventory 16*

WE

Goods Receipt

Procurement

Used to record receipt of goods or services

MIGO (Goods) and ML81 (Services)

50

5000000000

5099999999

NO

None

Balance Sheet and Expense Accounts and Commitment Items

WF

Production Order Costing

Plant Maintenance

CO12, CO13, CO88, KO88

49

4900000000

4999999999

YES, this document YES from SAP if 1st 7 pos. of Fund are different

WI

Inventory Document

Procurement

Used for recording consumption of materials in the Sign Shop production orders. Used for recording inventory produced in the Sign Shop production order. Also, used in the settlement process for sign shop production. Documents are sent to Treasury only if the first seven positions of the Fund are different. Adjustment of inventory differences.

D - Inventory D - Expenditure C - Accrued Payables GR/IR D/C - Expense D/C - Inventory 16*

MI07

49

4900000000

4999999999

NO

Statistical

D/C - Inventory D/C - P&L Acct

Balance Sheet and Expense Accounts and Commitment Items

ZA

Advancement Account Invoice

Accounts Payable

FB60

21

2100000000

2199999999

Yes, KZ clearing document from SAP

YES

AZ

ZA01

D - Expense C - Vendor

Any Vendor or Expense Account

ZB

Payroll Accrual

Commonwealth-wide & Payroll / Travel

Non-PO Invoice for Advancement Accounts. For separating security by document types, reporting and auditing. Used to post payroll expense accruals automatically in FI through accrual program. For GAAP purposes.

FB50

12

1200000000

1299999999

NO

Statistical

ZJ

KR01

D-Expenses (GAAP) GAAP Balance Sheet C-Payables (GAAP) and Expense Accounts and Commitment Items

ZC

Upload of CU Info

Commonwealth-wide

Used for year-end upload and reversal of component unit financial information into SAP to properly report in the Commonwealth's CAFR.

FB50

01

0100000000

0199999999

NO

NO

ZC

KR01

D-Expenses (GAAP) C-Revenues (GAAP) C-Liabilities C-Liabilities (GAAP) D/C-Fund Balance

5/7/2012

NO

WF

None

D - 1003000, C - Any revenue account

D - Expense 638* C - Inventory 16* C - 4200101 OR D - Expense C - Inventory 16*

Balance Sheet and GAAP Balance Sheet and GAAP Expense Accounts and Commitment Items

2:42 PM S:\Finance\FI_COMMON\Doc Types\Old Document Type for Web Version\Document Type Listing for WEB 05072012

Page 7 of 9

SAP DOCUMENT TYPE INVENTORY

DOC TYPE

DESCRIPTION

FUNCTIONAL TEAM(S)

PURPOSE OR TRIGGER

SAP TRANSACTION

DOC NUMBER RANGE

DOCUMENT RANGE FROM

DOCUMENT RANGE TO

IS THIS DOC OR A RELATED ONE SENT TO TREASURY FROM SAP OR ANOTHER SYSTEM FOR PAYMENT OR RECEIPT?

REAL FM POSTING YES / NO

REVERSING DOC TYPE

AUTH GROUP

DEBIT / CREDIT ENTRIES

GL ACCT CODE ITEM CAT (CONFIG)

ZD

Vendor Adjustment Invoice

Accounts Payable

Used to record debit offset entry for subrecipient payments FB60 posted by Interface or Conversion program where payment is a positive amount. This FB60 transaction mirrors the FB65 payment transaction made using doc type KJ and is only used to execute F-44 clearing transaction.

17

1700000000

1799999999

Yes, KS clearing document from SAP

YES

ZD

KR01

D - Expense C - Vendor

ZE

Employee Travel Vendor Invoice

HR / Travel Invoice postings to pay vendor.

auto program in payroll

27

2700000000

2799999999

AZ

KR01

Non-SAP Advance Account Replenishment

Unique document type used to accumulate amounts to replenish non-SAP Advancement Accounts.

FB50

88

8800000000

8899999999

YES, ZP clearing document from SAP YES, this document from SAP

YES

ZF

Accounts Payable & Payroll / Travel General Ledger

YES

None

KR01

D - Expense C - Vendor D - Expense C - Out of scope Adv Acct (e.g.,1046100 at DPW)

Any Employee Vendor or Expense Account D - Expense C - Advancement Acct for agency (e.g.,1046100 at DPW)

ZG

GAAP Accrual

Commonwealth-wide

Used for year-end journal entries to accrue revenues and expenditures by fund type for the Commonwealth's GAAP conversion.

FB50

12

1200000000

1299999999

NO

Sometimes statistical

ZJ

KR01

D/C - GAAP Exp/Rev D/C - GAAP Liab. D/C - GRIR Payables (various uses)

Balance Sheet and GAAP Balance Sheet and GAAP Income and Expense Accounts and Commitment Items

ZH

GAAP Reclass

Commonwealth-wide

Used for year-end journal entries to reclassify GL account FB50 balances within a CoPA fund to properly report the account balances on the Commonwealth's CAFR.

01

0100000000

0199999999

NO

YES, Some statistical

ZJ

KR01

D/C - Revenues D/C - Expenses D/C - Assets D/C - Liabilities D/C - Fund Balance GAAP or regular GLs

Balance Sheet and GAAP Balance Sheet, Income and Expense and GAAP Income and Expense Accounts and Commitment Items

ZI

Vendor Invoice Interface

Accounts Payable

SAP invoice documents posted via an external interface. IDOC interface For auditing of payments in payment program the interface triggered invoices are required to be separated.

22

2200000000

2299999999

YES, ZP clearing document from SAP

YES

KA

KR01

D - Expense C - Vendor

Any Vendor or Expense Account

ZJ

GAAP Reversal

Commonwealth-wide

Used for beginning of year mass reversal of accrual and F.80 deferral journal entries upon carryforward of GL balances to new fiscal year.

01

0100000000

0199999999

NO

YES, Some statistical

ZJ

KR01

Reversal of ZG and ZH documents

Balance Sheet and GAAP Balance Sheet, Income and Expense and GAAP Income and Expense Accounts and Commitment Items

ZK

Vendor Payment Advancement Account Reversal

Accounts Payable

Reversal document type for KZ (Advancment Account Payment).

FBRA & FCH8

17

1700000000

1799999999

NO

YES

ZK

ZA01

ZL

FI-CO Reconciliation Ledger Transaction

Cost Allocation & Commonwealth Wide

To identify all reconciliation ledger transactions, which will aid in error correction.

KALC

01

0100000000

0199999999

NO

NO

AB

KR01

Advancement GL ending in "4" and any Vendor Balance Sheet and Expense Accounts

ZN

Vendor Invoice Offset

Grants

Used to record debit offset entry for subrecipient payments FB60 posted by Interface or Conversion program where amount is a negative amount (a credit or refund). This FB60 transaction mirrors the FB65 payment transaction made using doc type KH and is only used to execute F-44 clearing transaction.

17

1700000000

1799999999

NO

YES

ZN

KR01

D - Adv Acct Clearing Account C - Vendor D/C - Expense D/C - FICO Recon Ledger D - Expense C - Vendor

5/7/2012

2:42 PM S:\Finance\FI_COMMON\Doc Types\Old Document Type for Web Version\Document Type Listing for WEB 05072012

Page 8 of 9

SAP DOCUMENT TYPE INVENTORY

DOC TYPE

DESCRIPTION

FUNCTIONAL TEAM(S)

ZO

Payroll Default Cost Center Correction Payroll & Leave Payout EA

ZP

Payment Posting

ZQ

Interface from FMIS and daily clearing General Ledger / GM of non-SAP payables account

Accounts Payable

PURPOSE OR TRIGGER

SAP TRANSACTION

DOC NUMBER RANGE

DOCUMENT RANGE FROM

DOCUMENT RANGE TO

IS THIS DOC OR A RELATED ONE SENT TO TREASURY FROM SAP OR ANOTHER SYSTEM FOR PAYMENT OR RECEIPT?

REAL FM POSTING YES / NO

REVERSING DOC TYPE

AUTH GROUP

GL ACCT CODE ITEM CAT (CONFIG)

Used for journal entries that will manually correct payroll posting made to the payroll default cost center and fund. These corrections will be an expense to expense posting. Documents are sent to Treasury only if the first seven positions of the Fund are different. Vendor Payment documents for posting using automated payment program.

FB50

78

7800000000

7899999999

YES, this document YES from SAP if 1st 7 pos. of Fund are different

ZO

KR01

D - Expense C - Expense

F110

20

2000000000

2099999999

YES, this document from SAP

YES

PZ

KR01

D - Vendor Any Vendor and C - Invoices Payable Invoices Payable.

Interface from FIMS to SAP, primarily to reallocate Payroll charges. Also used to post the clearing of non-SAP payables on a daily basis

FB50

99

9900000000

9999999999

ZQ

KR01

D/C - various

ZR

KR01

D/C - Exp/Rev D/C - Cash or NonSAP Invoices Payable D - Equity (Enc. by Value type) C - Equity (Res. for Encumbrances)

AB

KR01

D - Exp / Purchase of Investments C - Treas/Non-SAP Clearing

D - Expense or Purchase of Investments C - 1190100

ZU

KR01

D/C- HR Doc Split Clear D - Liability C - Vendor D - Expense D - HR Doc Split Clear C - Liability C - Payroll Cash Clearing D - Payroll Payable C - Pyrl Emp Payble Auto -----------------D - Pyrl Emp Payble Auto C - Cash-Pyrl Bank Clrng

D & C- HR Doc Split Clear (1190030) D - Liability (21*) C - Vendor D - Expense (61*) D & C - HR Doc Split Clear (1190010) C - Liability (21*) C - Payroll Cash Clearing (2100150) D - Payroll Payable (2100150) C - Pyrl Emp Payble Auto (2100153) D - Pyrl Emp Payble Auto (2100153) C - Cash-Pyrl Bank Clrng (1000002)

ZR

Commitment Posting to FI

Commonwealth-wide

Program to post FM Commitments to FI at month-end for FB50 financial statements generated from SPL. Commitments in FI are adjusted for expenditure recognition differences between FM and FI with this program.

01

0100000000

0199999999

YES, Reference YES document from legacy system or original Payroll doc No NO

ZT

Non-SAP Agency

General Ledger

Treasury interfaces to record payments for out-of-scope agencies

01

0100000000

0199999999

NO

ZU

Treasury Investment Upload

Commonwealth-wide

01

0100000000

0199999999

NO

ZW

PR Posting 3rd Party

AP / Payroll

Used for year-end upload of Treasury Investment ZFTR - auto program information to include in the Commonwealth's CAFR. Reports balances, difference between cost and fair market value, and accrued interest. 3rd Party Liability Payments. Payroll posting PC00_M10_CALC

24

2400000000

2499999999

YES, ZP clearing document from SAP

YES

ZW

KR01

ZX

Payroll Posting

Payroll

This entry is to record payroll expenses and payroll liabilities as a result of the payroll run. For example: Salaries, Medicare, Social Security, etc.

25

2500000000

2599999999

YES, Reference document relates to many DSNs, RTs, REs, and AMs from SAP

YES

ZX

KR01

ZY

Payroll Cash Clearing

Bank Clearing

The Payroll Posting (ZX) does not post directly to the cash Bank Clearing posting account, instead, a payroll cash clearing account is used. ZF_PAYROLL_BANK_ This entry (ZY) is to clear the payroll cash clearing account CLEARING and post to the cash account.

26

2600000000

2699999999

NO

NO

ZY

KR01

5/7/2012

DEBIT / CREDIT ENTRIES

FB50 or BAPI interface

Payroll posting PC00_M10_CALC

YES

D - Expense C - Expense

D/C - 1000000 or 2100200 Balance Sheet and Cash Accounts

2:42 PM S:\Finance\FI_COMMON\Doc Types\Old Document Type for Web Version\Document Type Listing for WEB 05072012

Page 9 of 9

Suggest Documents