Copyright (c) 1996, 2015, Oracle and/or its affiliates. All rights reserved.
This material is the confidential property of Oracle Corporation or its licensors and may be used, reproduced, stored or transmitted only in accordance with a valid Oracle license or sublicense agreement.

Field Index SQL Mapping

Class /ledger_report

The ledger report object is created as a result of executing the PCM_OP_GL_LEDGER_REPORT opcode. This object stores the resulting data from running the ledger report procedures.

Notes

  • This object can be read by the owner or any billing group leader within the brand who is an ancestor of the owner.
  • This object can be modified by the owner or any billing group leader within the brand who is an ancestor of the owner.
  • This object can be created by anyone.

Links



Field Index

Type Field Name
poid PIN_FLD_POID
timestamp PIN_FLD_CREATED_T
timestamp PIN_FLD_MOD_T
string PIN_FLD_READ_ACCESS
string PIN_FLD_WRITE_ACCESS
string PIN_FLD_CREATE_ACCESS
poid PIN_FLD_ACCOUNT_OBJ
array PIN_FLD_ACCOUNT_GROUPS
int
int
enum
int PIN_FLD_ACCTS_NUM_FOR_GROUP
int PIN_FLD_CURRENCY_ONLY
timestamp PIN_FLD_END_T
string PIN_FLD_GL_SEGMENT
array PIN_FLD_GL_SEGMENTS_ARRAY
string
array PIN_FLD_GL_ACCTS
string
string
string
string
timestamp
int
int
decimal
decimal
string
decimal
decimal
string
decimal
decimal
string
decimal
decimal
string
decimal
decimal
string
decimal
decimal
string
decimal
decimal
string
decimal
decimal
string
int PIN_FLD_GL_REPORT_TYPE
string PIN_FLD_NAME
timestamp PIN_FLD_START_T
array PIN_FLD_TOTAL_GROUPS_ARRAY
int
int
enum PIN_FLD_TYPE


Field Details

poid PIN_FLD_POID

Object Identifier for an instance of this class. Portal object ids have four pieces of information: database number, class type, sequence id, revision.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

timestamp PIN_FLD_CREATED_T

Time the object was created.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

timestamp PIN_FLD_MOD_T

Time the object was last modified.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

string PIN_FLD_READ_ACCESS

Read Access level for object. Valid values are S(Self), G(Global), L(BrandLineage), B(BrandGroup), A(Ancestral).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

string PIN_FLD_WRITE_ACCESS

Write Access level for object. Valid values are S(Self), G(Global), L(BrandLineage), B(BrandGroup), A(Ancestral).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

string PIN_FLD_CREATE_ACCESS

Create Access level for object. Valid values are O(BrandOwner), R(Root), N(Any).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

poid PIN_FLD_ACCOUNT_OBJ

Link to account object for which this object was created.

Notes

  • Required on object creation
  • Can be modified

Links

array PIN_FLD_ACCOUNT_GROUPS

Array of A/R account groups information. Element Id is significant (from 1 to n sequentially).

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_BEG_ACCT

The first account for this group.

Notes

Links

int PIN_FLD_END_ACCT

The last account for this group.

Notes

Links

enum PIN_FLD_GRP_STAT

The status for this group. (1 for updated, 0 for not updated)

Notes

Links

int PIN_FLD_ACCTS_NUM_FOR_GROUP

Specifies how many A/R accounts need to be grouped together into a single transaction.

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_CURRENCY_ONLY

Specifies whether the report is for non-currency resources (0 - PIN_GL_REPORT_NON_CURRENCY_TYPE), currency resources(1 - PIN_GL_REPORT_CURRENCY_TYPE) or all resources(2 - PIN_GL_REPORT_ANY_TYPE). The default value is 1 to indicate that only currency resources are considered in the report.

Notes

  • Required on object creation
  • Can be modified

Links

timestamp PIN_FLD_END_T

End of the posting period of the ledger report. End time is NOT inclusive.

Notes

  • Required on object creation
  • Can be modified

Links

string PIN_FLD_GL_SEGMENT

Name of GL segment for which this ledger report has been created. The report will only include GL data for the accounts that belong to this GL segment.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 255 bytes

Links

array PIN_FLD_GL_SEGMENTS_ARRAY

This array will include all the individual segments under the hierarchy starting from the one in PIN_FLD_GL_SEGMENT.

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_GL_SEGMENT

Segment included for ledger report generation

Notes

Links

array PIN_FLD_GL_ACCTS

Array of GL account information. Element Id is not significant.

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_ACCOUNT_NO

Account number of the transaction being reported. Used only in the detailed report.

Notes

Links

string PIN_FLD_BILL_NO

Bill number of the transaction being reported. Used only in the detailed report.

Notes

Links

string PIN_FLD_ITEM_NO

Item number of the transaction being reported. Used only in the detailed report.

Notes

Links

string PIN_FLD_ITEM_NAME

Item name of the transaction being reported. Used only in the detailed report.

Notes

Links

timestamp PIN_FLD_EFFECTIVE_T

Date when this item was opened (billed). 0 means item has not yet been billed. Used only in the detailed report.

Notes

Links

int PIN_FLD_RESOURCE_ID

Numeric value of the resource that is impacted.

Notes

Links

int PIN_FLD_GL_ID

GLID associated with this balance impact. To get information about available ranges of G/L ID please refer to Portal documentation and /config/glid object

Notes

Links

decimal PIN_FLD_CR_AR_GROSS_AMT

Amount that impacts the credit side of the gross AR G/L account. This is the absolute value of the sum of all negative balance impacts for the given glid/resource pair.

Notes

Links

decimal PIN_FLD_DB_AR_GROSS_AMT

Amount that impacts the debit side of the gross AR G/L account. This is the absolute value of the sum of all positive balance impacts for the given glid/resource pair.

Notes

Links

string PIN_FLD_AR_GROSS_GL_ACCT

AR G/L account for the gross amount.

Notes

Links

decimal PIN_FLD_CR_OFF_GROSS_AMT

Amount that impacts the credit side of the gross Offset G/L account. The value in this field is exactly the same as the one in the PIN_FLD_DB_AR_GROSS_AMT.

Notes

Links

decimal PIN_FLD_DB_OFF_GROSS_AMT

Amount that impacts the debit side of the gross Offset G/L account. The value in this field is exactly the same as the one in the PIN_FLD_CR_AR_GROSS_AMT.

Notes

Links

string PIN_FLD_OFF_GROSS_GL_ACCT

Offset G/L account for gross amount.

Notes

Links

decimal PIN_FLD_CR_AR_NET_AMT

Amount that impacts the credit side of the net AR G/L account. This is the absolute value of the sum of all negative balance impacts for the given glid/resource pair.

Notes

Links

decimal PIN_FLD_DB_AR_NET_AMT

Amount that impacts the debit side of the net AR G/L account. This is the absolute value of the sum of all positive balance impacts for the given glid/resource pair.

Notes

Links

string PIN_FLD_AR_NET_GL_ACCT

AR G/L account for the net amount.

Notes

Links

decimal PIN_FLD_CR_OFF_NET_AMT

Amount that impacts the credit side of the net Offset G/L account. The value in this field is exactly the same as the one in the PIN_FLD_DB_AR_NET_AMT.

Notes

Links

decimal PIN_FLD_DB_OFF_NET_AMT

Amount that impacts the debit side of the net Offset G/L account. The value in this field is exactly the same as the one in the PIN_FLD_CR_AR_NET_AMT.

Notes

Links

string PIN_FLD_OFF_NET_GL_ACCT

Offset G/L account for net amount.

Notes

Links

decimal PIN_FLD_CR_AR_DISC_AMT

Amount that impacts the credit side of the disc AR G/L account. This is the absolute value of the sum of all negative balance impacts for the given glid/resource pair.

Notes

Links

decimal PIN_FLD_DB_AR_DISC_AMT

Amount that impacts the debit side of the disc AR G/L account. This is the absolute value of the sum of all positive balance impacts for the given glid/resource pair.

Notes

Links

string PIN_FLD_AR_DISC_GL_ACCT

AR G/L account for disc amount.

Notes

Links

decimal PIN_FLD_CR_OFF_DISC_AMT

Amount that impacts the credit side of the disc Offset G/L account.

Notes

Links

decimal PIN_FLD_DB_OFF_DISC_AMT

Amount that impacts the debit side of the disc Offset G/L account.

Notes

Links

string PIN_FLD_OFF_DISC_GL_ACCT

Offset G/L account for disc amount.

Notes

Links

decimal PIN_FLD_CR_AR_TAX_AMT

Amount that impacts the credit side of the tax AR G/L account. This is the absolute value of the sum of all negative balance impacts for the given glid/resource pair.

Notes

Links

decimal PIN_FLD_DB_AR_TAX_AMT

Amount that impacts the debit side of the tax AR G/L account. This is the absolute value of the sum of all positive balance impacts for the given glid/resource pair.

Notes

Links

string PIN_FLD_AR_TAX_GL_ACCT

AR G/L account for tax amount.

Notes

Links

decimal PIN_FLD_CR_OFF_TAX_AMT

Amount that impacts the credit side of the tax Offset G/L account. The value in this field is exactly the same as the one in the PIN_FLD_DB_AR_TAX_AMT.

Notes

Links

decimal PIN_FLD_DB_OFF_TAX_AMT

Amount that impacts the debit side of the tax Offset G/L account. The value in this field is exactly the same as the one in the PIN_FLD_CR_AR_TAX_AMT.

Notes

Links

string PIN_FLD_OFF_TAX_GL_ACCT

Offset G/L account for tax amount.

Notes

Links

int PIN_FLD_GL_REPORT_TYPE

Indicates characteristics of the report with bit values set as follows. Bit value 0x01 (PIN_GL_REPORT_TYPE_DETAIL) indicates it is a detailed report as opposed to a summary report. Bit value 0x10 (PIN_GL_REPORT_TYPE_CUSTOMIZED) indicates it is a customized report derived from a basic report that was summary or detailed. Bit value 0x100 (PIN_GL_REPORT_TYPE_INCREMENTAL) indicates it is an incremental report in relation to a report for the previous period.

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_NAME

User-defined name of the object. Currently not used.

Notes

  • Required on object creation
  • Can be modified
  • Maximum length is 255 bytes

Links

timestamp PIN_FLD_START_T

Start time of the posting period for this ledger report. Start time is Inclusive.

Notes

  • Required on object creation
  • Can be modified

Links

array PIN_FLD_TOTAL_GROUPS_ARRAY

This stores the numbers for the total groups (split and updated).

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_TOTAL_GROUPS

The total split groups.

Notes

Links

int PIN_FLD_UPDATED_GROUPS

The total updated groups.

Notes

Links

enum PIN_FLD_TYPE

Indicates the type of ledger report. Possible types are, 1 (unbilled), 2 (billed), 4 (unbilled_earned), 8 (billed_earned), 16 (unbilled_unearned), 32 (billed_unearned), 64 (prev_billed_earned).

Notes

  • Required on object creation
  • Can be modified

Links



SQL Mapping


Type Field Name Table Column Name
base-class /ledger_report ledger_report_t
poid PIN_FLD_POID poid*
timestamp PIN_FLD_CREATED_T created_t
timestamp PIN_FLD_MOD_T mod_t
string PIN_FLD_READ_ACCESS read_access
string PIN_FLD_WRITE_ACCESS wrtie_access
string PIN_FLD_CREATE_ACCESS create_access
poid PIN_FLD_ACCOUNT_OBJ account_obj*
array PIN_FLD_ACCOUNT_GROUPS ledger_report_account_groups_t
int
PIN_FLD_BEG_ACCT
 		beg_acct
int
PIN_FLD_END_ACCT
 		end_acct
enum
PIN_FLD_GRP_STAT
 		grp_stat
int PIN_FLD_ACCTS_NUM_FOR_GROUP accts_num_for_group
int PIN_FLD_CURRENCY_ONLY currency_only
timestamp PIN_FLD_END_T end_t
string PIN_FLD_GL_SEGMENT gl_segment
array PIN_FLD_GL_SEGMENTS_ARRAY ledger_report_gl_segments_t
string
PIN_FLD_GL_SEGMENT
 		gl_segment
array PIN_FLD_GL_ACCTS ledger_report_accts_t
string
PIN_FLD_ACCOUNT_NO
 		account_no
string
PIN_FLD_BILL_NO
 		bill_no
string
PIN_FLD_ITEM_NO
 		item_no
string
PIN_FLD_ITEM_NAME
 		item_name
timestamp
PIN_FLD_EFFECTIVE_T
 		effective_t
int
PIN_FLD_RESOURCE_ID
 		resource_id
int
PIN_FLD_GL_ID
 		gl_id
decimal
PIN_FLD_CR_AR_GROSS_AMT
 		cr_ar_gross_amt
decimal
PIN_FLD_DB_AR_GROSS_AMT
 		db_ar_gross_amt
string
PIN_FLD_AR_GROSS_GL_ACCT
 		ar_gross_gl_acct
decimal
PIN_FLD_CR_OFF_GROSS_AMT
 		cr_off_gross_amt
decimal
PIN_FLD_DB_OFF_GROSS_AMT
 		db_off_gross_amt
string
PIN_FLD_OFF_GROSS_GL_ACCT
 		off_gross_gl_acct
decimal
PIN_FLD_CR_AR_NET_AMT
 		cr_ar_net_amt
decimal
PIN_FLD_DB_AR_NET_AMT
 		db_ar_net_amt
string
PIN_FLD_AR_NET_GL_ACCT
 		ar_net_gl_acct
decimal
PIN_FLD_CR_OFF_NET_AMT
 		cr_off_net_amt
decimal
PIN_FLD_DB_OFF_NET_AMT
 		db_off_net_amt
string
PIN_FLD_OFF_NET_GL_ACCT
 		off_net_gl_acct
decimal
PIN_FLD_CR_AR_DISC_AMT
 		cr_ar_disc_amt
decimal
PIN_FLD_DB_AR_DISC_AMT
 		db_ar_disc_amt
string
PIN_FLD_AR_DISC_GL_ACCT
 		ar_disc_gl_acct
decimal
PIN_FLD_CR_OFF_DISC_AMT
 		cr_off_disc_amt
decimal
PIN_FLD_DB_OFF_DISC_AMT
 		db_off_disc_amt
string
PIN_FLD_OFF_DISC_GL_ACCT
 		off_disc_gl_acct
decimal
PIN_FLD_CR_AR_TAX_AMT
 		cr_ar_tax_amt
decimal
PIN_FLD_DB_AR_TAX_AMT
 		db_ar_tax_amt
string
PIN_FLD_AR_TAX_GL_ACCT
 		ar_tax_gl_acct
decimal
PIN_FLD_CR_OFF_TAX_AMT
 		cr_off_tax_amt
decimal
PIN_FLD_DB_OFF_TAX_AMT
 		db_off_tax_amt
string
PIN_FLD_OFF_TAX_GL_ACCT
 		off_tax_gl_acct
int PIN_FLD_GL_REPORT_TYPE gl_report_type
string PIN_FLD_NAME name
timestamp PIN_FLD_START_T start_t
array PIN_FLD_TOTAL_GROUPS_ARRAY ledger_report_total_groups_t
int
PIN_FLD_TOTAL_GROUPS
 		total_groups
int
PIN_FLD_UPDATED_GROUPS
 		updated_groups
enum PIN_FLD_TYPE type
Column names marked with * are actually column prefixes. For poid type fields, the column prefix is used to create the columns poid_id0, poid_db and poid_type if the prefix is "poid". For PIN_FLD_POID in the base table, an additional column named poid_rev is created to hold the poid revision. For buffer fields, two columns are created - one in the containing table and one in the buffer table. For example if the prefix is "buf", then the column name in the buffer table is buffer_buf and the column name in the containing table is buffer_size.

Field Index This Class