|
|
SQL Finance / Accrual Type
API Accrual Types / Accrual Type
OACR - Accrual Type Table
Accrual Type AccrualType Object· Table: OACR
Parent: Accrual Types AccrualTypes Collection
Accrual Type Params AccrualTypeParams Object· Table: OACR Parent: Accrual Types Params AccrualTypesParams Collection
Accrual Types Service AccrualTypesService Service· Table: OACR
G/L Accounts OACT SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Accrual Type Code | nVarChar | 8 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name | Accrual Type Name | nVarChar | 30 | |||||
| PostingAct | Posting Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CalcAcct | Calculation Account | nVarChar | 15 | OACT G/L Accounts | ||||
| InterimAct | Interim Account | nVarChar | 15 | OACT G/L Accounts | ||||
| Locked | Locked | VarChar | Y) Yes N) No | 1 | N | |||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users |
Table relationship map
SELECT statement
SELECT
OACR.Code AS 'Accrual Type Code',
OACR.Name AS 'Accrual Type Name',
OACR.PostingAct AS 'Posting Account',
OACR.CalcAcct AS 'Calculation Account',
OACR.InterimAct AS 'Interim Account',
OACR.Locked AS 'Locked',
OACR.DataSource AS 'Data Source',
OACR.UserSign AS 'User Signature'
FROM OACR AS OACR
Related information
Accrual Type AccrualType Object· Table: OACR
Represents an accrual type.
Source table: OACR.
Parent: Accrual Types AccrualTypes CollectionAccrual Type Params AccrualTypeParams Object· Table: OACR
Holds the key of an accrual type.
This object is used to pass keys to and retrieve keys from AccrualTypesService methods.
Source table: OACR.
Parent: Accrual Types Params AccrualTypesParams CollectionAccrual Types Service AccrualTypesService Service· Table: OACR
An accrual type is a set of conditions used to represent the differences between cost accounting and financial accounting.
The AccrualTypesService service enables you to add, look up, update, and remove accrual types.
Source table: OACR.
G/L Accounts OACT SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
