Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse POSTING KEY Table


Contains a list of all SAP posting key codes and their descriptions.


Field Name

Description

Data Type

Length

POSTING_KEY

Key required by SAP for each document line item, indicating the type of posting represented in the line item. "Posting Key" is the description for "Posting Key Code".

VARCHAR2

3

POSTING_KEY_CODE

2 digit code identifing the type of posting. Example: 09 - Security Deposit, 08 - Payment Clearing, 09 - Pledge, 09 - Special G/L Debit, 09 - Interest Due, 11 - Credit Memo, 40 - Debit, 50 - Credit, etc.

VARCHAR2

2

POSTING_KEY_DESCRIPTION

Test describing the type of Posting Key (Example: Security Deposit, Payment Clearing, Pledge, Special G/L Debit, Interest Due, Credit Memo, etc?)

VARCHAR2

20

SPECIAL_GL_INDICATOR_CODE

XXX

VARCHAR2

1

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8