1. HCM Data Loading Business Objects
  2. Example of Loading Payment Source Costing

Example of Loading Payment Source Costing

Use HCM Data Loader to enter account information for your payment sources.

Imagine a scenario where a delay exists between the date the payment is issued by using a cheque and the date the cheque is cleared. In such a case, your company wants to create a cash clearing account to track payments.

Using HCM Data Loader, you load a payment source and create liability, cash clearing, and cash accounts for it.

Note: You load the same account information that you use for the cash and cash clearing account that you created in the General Ledger.

This table summarizes the values that you load for the various accounts:

Parameter

Cash Account

Cash Clearing Account

Liability Account

Fund (Segment1)

All Funds; 0001

Pooled Cash Fund;0900

All Funds; 0001

Appropriation (Segment2)

Salaries Appropriation ; 1001

Salaries Appropriation; 1002

Salaries Appropriation; 1002

Funding Source (Segment3)

Original Funding Source; 1010

Funding Source; 1999

Balance Sheet; 0000

Department (Segment4)

Progress Top Level; 0001

General Government Agencies; 1000

Balance Sheet; 0000

Organization (Segment5)

Administration; 1001

Administration; 1001

Payroll; 1003

Program (Segment6)

Programs; 0001

Programs; 0001

Legislative;1100

Object (Segment7)

Cash; 11110

Object; 11140

On Account Cash; 11150

Project (Segment8)

Administrative Projects; 100000

Capital Project; 100001

Broadway Extension; 100004

This dat file loads these account values for the payment source Vision Corp Check PS in Vision Corp Check PM payment method:

METADATA|CostInfoV3|EffectiveEndDate|EffectiveStartDate|SourceType|PaymentSourceCode|OrganizationPaymentMethodCode|LegislativeDataGroupName|CostableType|CostedFlag|TransferToGlFlag|GUID|SourceSystemId|SourceSystemOwner
MERGE|CostInfoV3|4712/12/31|2010/01/01|PM|Vision Corp Check PS|Vision Corp Check PM|Vision Corp|Y|Y|Y|
METADATA|CostAllocationV3|EffectiveEndDate|EffectiveStartDate|SourceType|PaymentSourceCode|OrganizationPaymentMethodCode|LegislativeDataGroupName|GUID|SourceSystemId|SourceSystemOwner
MERGE|CostAllocationV3|4712/12/31|2010/01/01|PM|Vision Corp Check PS|Vision Corp Check PM|Vision Corp||

METADATA|CostAllocationAccountV3|SourceType|PaymentSourceCode|OrganizationPaymentMethodCode|LegislativeDataGroupName|EffectiveDate|SourceSubType|Proportion|SubTypeSequence|ConcatenatedSegment| GUID|SourceSystemId|SourceSystemOwner
MERGE|CostAllocationAccountV3|PM|Vision Corp Check PS|Vision Corp Check PM|Vision Corp|2010/01/01|CLRNG|1|1|0900.1002. 1999.1000.1001.0001.11140.100001||
MERGE|CostAllocationAccountV3|PM|Vision Corp Check PS|Vision Corp Check PM|Vision Corp|2010/01/01|CASH|1|1|0001.1001.1010.0001.1001.0001.11110.100000||
MERGE|CostAllocationAccountV3|PM|Vision Corp Check PS|Vision Corp Check PM|Vision Corp|2010/01/01|LBLTY|1|1|0001.1002.0000.0000.1003.1100.11150.100004||

Related Topics