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