Creating Accounting Entries for External Groups

You may choose to populate the PS_PENDING_DST table directly through your interface program, even though this approach is considered an exception within the system's accounting entries architecture.

The following table describes the fields on PS_PENDING_DST. The table specifies a field type for each field. Use the field type to determine how to populate system-maintained fields and optional fields that you want to leave blank. Supply a space for character fields, a null value for date fields, and a zero for numeric fields.

Note:

Use Application Designer to review the characteristics of each field in greater detail.

Column Field Name Field Type Option/ Condition/ Required Field Description

1

GROUP_BU

Character

Required

Use the same value as the GROUP_BU on PS_GROUP_ CONTROL.

2

GROUP_ID

Character

Required

Use the same value as the GROUP_ID on PS_GROUP_CONTROL.

3

BUSINESS_UNIT

Character

Required

Use the same value as the BUSINESS_UNIT on PS_PENDING_ ITEM.

4

CUST_ID

Character

Required

Use the same value as the CUST_ID on PS_PENDING_ITEM.

5

ITEM

Character

Required

Use the same value as the ITEM on PS_PENDING_ITEM.

6

ITEM_LINE

Number

Optional

Use the same value as the ITEM_LINE on PS_PENDING_ITEM.

7

GROUP_SEQ_NUM

Number

Optional

Use the same value as the GROUP_SEQ_NUM on PS_PENDING_ITEM.

8

LEDGER_GROUP

Character

Optional

Leave this field blank.

9

LEDGER

Character

Optional

Leave this field blank.

10

DST_SEQ_NUM

Number

Required

Provide a sequence number to make each accounting entry line unique.

11

PRIMARY_LEDGER

Character

Required

Default value: Y.

12

BUSINESS_UNIT_GL

Character

Required

Provide the value of the general ledger business unit to which you post this accounting entry.

13

ACCOUNT

Character

Required

Select from the values that you establish on PS_GL_ACCOUNT_TBL.

14

ALTACCT

Character

Optional

Select from the values that you establish on the PS_ALTACCT_TBL.

15

DEPTID

Character

Optional

Select from the values that you establish on PS_DEPARTMENT_TBL.

16

CF16_AN_SBR

Subrecord

Optional

ChartFields subrecord that contains these ChartFields:

  • Operating Unit (OPERATING_UNIT)

  • Product (PRODUCT)

  • Fund (FUND_CODE)

  • Class (CLASS_FLD)

  • Program (PROGRAM_CODE)

  • Budget Reference (BUDGET_REF)

  • Affiliate (AFFILIATE)

  • Fund Affiliate (AFFILIATE_INTRA1)

  • Operating Affiliate (AFFILIATE_INTRA2)

  • ChartField 1 (CHARTFIELD1)

  • ChartField 2 (CHARTFIELD2)

  • ChartField 3 (CHARTFIELD3)

Select from the ChartField values that you defined.

17

PC_CF1_N_SBR

Subrecord

Optional

ChartFields subrecord that contains these ChartFields used in PeopleSoft Project Costing:

  • PC Business Unit (BUSINESS_UNIT_PC)

  • Project (PROJECT_ID)

  • Activity (ACTIVITY_ID)

  • Source Type (RESOURCE_TYPE)

  • Category (RESOURCE_CATEGORY)

  • Subcategory (RESOURCE_SUB_CAT)

Select from the values that you defined in PeopleSoft Project Costing. The subrecord also contains a field for the analysis type. This value is not used in PeopleSoft Receivables.

18

STATISTICS_CODE

Character

Optional

Select from the values that you establish on PS_STAT_TBL as long as you do not enter a statistical account in the ACCOUNT field.

19

MONETARY_AMOUNT

Number

Optional

Provide the amount of the debit or credit in the business unit base currency. Debit entries must be positive. Credit entries must be negative. As long as you do not enter a statistical account in the ACCOUNT field, this value must be something other than zero. If you enter a statistical account, this value must be zero.

20

STATISTIC_AMOUNT

Number

Conditional

If you enter a statistical account in the ACCOUNT field, enter the appropriate statistical amount.

21

CF_EDIT_STATUS

Character

Required

Indicates if ChartFields are editable or restricted for edit.

22

JRNL_LN_REF

Character

Optional

If you supply a value and do not summarize accounting entries into fewer journal lines, the system places the value in this field on the PS_JRNL_LN table when you create journals by using the Journal Generator process.

23

LINE_DESCR

Character

Optional

If you supply a value and do not summarize accounting entries into fewer journal lines, the system places the value in this field on the PS_JRNL_LN table when you create journals by using the Journal Generator process.

24

SYSTEM_DEFINED

Character

Conditional

Accounting entry line type. Enter A if this line represents the debit or credit to the AR account (or control account) or if this line represents the offsetting information. PeopleSoft Receivables supports using more than one AR line per pending item.

25

ACCOUNTING_DT

Date

Required

Use the same value as the ACCOUNTING_DT on PS_PENDING_ITEM.

26

FOREIGN_CURRENCY

Character

Optional

Use the same value as the ENTRY_CURRENCY on PS_PENDING_ITEM.

27

FOREIGN_AMOUNT

Number

Optional

The debit or credit amount for this line in the entry currency of the item. The sum of the FOREIGN_AMOUNT values on all AR lines in PENDING_DST should equal the ENTRY_AMT field on PENDING_ITEM.

28

RT_TYPE

Character

Conditional

The rate type for the item. Required if the entry currency is different from the business unit base currency. Select from the values that are established on PS_CUR_RT_ TYPE_TBL or enter a space.

29

RATE_MULT

Number

Optional

Required if the entry currency differs from the business unit base currency.

30

RATE_DIV

Number

Optional

Required if the entry currency differs from the business unit base currency.

31

CURRENCY_CD

Character

Optional

Code that identifies the type of currency for an amount, such as USD or EUR.

32

GL_DISTRIB_STATUS

Character

Required

If you want to distribute this accounting entry from PeopleSoft Receivables to the general ledger system (after the Receivables Update process posts it), provide an N.

If you do not want to distribute this accounting entry, provide an I.

33

DOC_TYPE

Character

Optional

Document type represents the business purpose of the financial transaction. This value is assigned to one and only one journal code.

Note: If you have turn on the Document Sequencing option for your installation and the PeopleSoft General Ledger business unit that is associated with the PeopleSoft Receivables business unit, you must include a value in this field.

34

DOC_SEQ_NBR

Character

Required

The document sequencing number is either automatically assigned or manually entered sequentially based on the PeopleSoft General Ledger business period at either the journal code level or the document type level within the journal code.

Note: If you turn on the Document Sequencing option for your installation and the PeopleSoft General Ledger business unit that is associated with the PeopleSoft Receivables business unit, you must include a value in this field.

35

DOC_SEQ_DATE

Date

Optional

The date that the document sequencing number is assigned to a specific document or the date that the document is created.

Note: The Receivables Update process requires a value in this field to post an item if you turn on the Document Sequencing option for your installation and the PeopleSoft General Ledger business unit is associated with the PeopleSoft Receivables business unit.

36

DOC_SEQ_STATUS

Character

Optional

The status that is used for posting a document with the Document Sequencing option. If it's blank, then the document is valid for posting.

37

MOVEMENT_FLAG

Character

Optional

Activate to pass document sequencing that is performed in PeopleSoft Receivables to PeopleSoft General Ledger.

38

USER1

Character

Optional

This field is for your use, similar to the user fields on PS_PENDING_ITEM.

39

USER2

Character

Optional

This field is for your use, similar to the user fields on PS_PENDING_ITEM.

40

USER3

Character

Optional

This field is for your use, similar to the user fields on PS_PENDING_ITEM.

41

USER4

Character

Optional

This field is for your use, similar to the user fields on PS_PENDING_ITEM.

42

USER5

Character

Optional

This field is for your use, similar to the User fields on PS_PENDING_ITEM.

43

VAT_APPLICABILITY

Character

Optional

VAT applicability for the distribution line. Use the same value as on PS_PENDING_ITEM.

44

VAT_TXN_TYPE_CD

Character

Optional

VAT transaction type code for the item. Use the same value as on PS_PENDING_ITEM.

45

TAX_CD_VAT

Character

Optional

VAT tax code for the item. Use the same value as on PS_PENDING_ITEM.

46

VAT_DST_ACCT_TYPE

Character

Optional

VAT distribution account type. Use the same value as on PS_PENDING_ITEM.

47

ENTRY_EVENT

Character

Optional

Code that is used by the federal government to post pro-forma accounting information. The Entry Event Generator generates supplemental accounting lines if you enter this code.

48

IU_ANCHOR_FLAG

Character

Optional

Flag to indicate that this line is the anchor line for interunit and intraunit accounting entries and for inheritance. Enter Y or N.

49

IU_SYS_TRAN_CD

Character

Optional

System transaction code that is used to generate interunit and intraunit accounting entries. Enter ARIT.

50

IU_TRAN_CD

Character

Optional

Transaction code that is used to generate interunit and intraunit accounting entries. Enter GENERAL.

51

OPEN_ITEM_KEY

Character

Optional

If you selected OpenItem Account for the account in the distribution line during setup, enter a value for the prompt field and record that you specified for the account.

Note: The interface from PeopleSoft Billing to PeopleSoft Receivables sets this value to NULL.

52

PROCESS_INSTANCE

Number

Optional

Updated by the Receivables Update process with the process instance that is used for a given execution of the process. Because the system calculates this value for you, enter 0.