ITEM_DST_CC_VW (SQL View)	Index Back
Item Distribution Selection Used when Commitment Control is installed for Receivables to pull in accounting entries only after they pass the budget check. If Commitment Control is not used, a simpler view ITEM_DST_GL_VW can be used.

ITEM_DST_CC_VW

(SQL View)

Item Distribution Selection

Used when Commitment Control is installed for Receivables to pull in accounting entries only after they pass the budget check. If Commitment Control is not used, a simpler view ITEM_DST_GL_VW can be used.

SELECT D.BUSINESS_UNIT , D.CUST_ID , D.ITEM , D.ITEM_LINE , D.ITEM_SEQ_NUM , D.LEDGER_GROUP , D.LEDGER , D.DST_SEQ_NUM , D.PRIMARY_LEDGER , D.BUSINESS_UNIT_GL , D.ACCOUNT , D.ALTACCT , D.DEPTID , %subrec(CF12_AN_SBR, D) , %subrec(PC_CF1_N_SBR, D) , D.BUDGET_DT , D.STATISTICS_CODE , D.MONETARY_AMOUNT , D.STATISTIC_AMOUNT , D.JRNL_LN_REF , D.LINE_DESCR , D.JOURNAL_ID , D.JOURNAL_DATE , D.GL_DISTRIB_STATUS , D.PROCESS_INSTANCE , D.APPL_JRNL_ID , D.GL_ACCTG_DT , D.FOREIGN_CURRENCY , D.FOREIGN_AMOUNT , D.RT_TYPE , D.RATE_MULT , D.RATE_DIV , D.CURRENCY_CD , D.SYSTEM_DEFINED , D.FISCAL_YEAR , D.ACCOUNTING_PERIOD , D.DOC_TYPE , D.DOC_SEQ_NBR , D.DOC_SEQ_DATE , D.DOC_SEQ_STATUS , D.MOVEMENT_FLAG , D.USER1 , D.USER2 , D.USER3 , D.USER4 , D.USER5 , D.JOURNAL_LINE , D.OPEN_ITEM_KEY , D.DTTM_STAMP , D.ENTERED_DTTM , D.OPRID , D.LAST_UPDATE_DTTM , D.OPRID_LAST_UPDT FROM PS_ITEM_DST D WHERE D.GL_DISTRIB_STATUS <> 'I' AND EXISTS ( SELECT 'X' FROM PS_ITEM_ACTIVITY A WHERE D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.CUST_ID = A.CUST_ID AND D.ITEM = A.ITEM AND D.ITEM_LINE = A.ITEM_LINE AND D.ITEM_SEQ_NUM = A.ITEM_SEQ_NUM AND (1 = ( SELECT 1 FROM PS_INSTALLATION I WHERE I.COMMITMENT_CNTL_AR <> 'Y') OR (A.ARRE_STATUS <> ' ' AND (A.ARRE_STATUS IN ('B', 'N') OR (EXISTS ( SELECT 'X' FROM PS_AR_CC_TRAN_HDR R WHERE R.BUSINESS_UNIT = A.BUSINESS_UNIT AND R.CUST_ID = A.CUST_ID AND R.ITEM = A.ITEM AND R.ITEM_LINE = A.ITEM_LINE AND R.ITEM_SEQ_NUM = A.ITEM_SEQ_NUM AND R.BUDGET_HDR_STATUS = 'V'))))))

Parent record: ITEM_ACTIVITY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

3 ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.

4 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line

5 ITEM_SEQ_NUM Number(3,0) SMALLINT NOT NULL Item Sequence Number

6 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

7 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

8 DST_SEQ_NUM Number(6,0) INTEGER NOT NULL Distribution Sequence

9 PRIMARY_LEDGER Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group.

10 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

11 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

12 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

14 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

15 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

16 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

17 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

18 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

19 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

20 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

21 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

22 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

23 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

24 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

25 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

26 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
Prompt Table: %EDIT_BU_PC

27 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: %EDIT_PROJECT

28 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: %EDIT_ACTIVITY

29 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

30 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

31 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

32 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

33 BUDGET_DT Date(10) DATE Budget Date

34 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

35 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.

36 STATISTIC_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.

37 JRNL_LN_REF Character(10) VARCHAR2(10) NOT NULL Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.

38 LINE_DESCR Character(30) VARCHAR2(30) NOT NULL Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.

39 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.

40 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.

41 GL_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Status
C=Available to Contracts
D=Distributed
G=Generated
H=Hold
I=Ignored
J=Creating Journals
M=Modified
N=None
P=To be processed
X=Waiting for Reversal

42 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

43 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template

44 ACCOUNTING_DT Date(10) DATE NOT NULL The accounting entry construction date for a given transaction (a generic field that crosses multiple

45 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

46 FOREIGN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.

47 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

48 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

49 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
Default Value: 1

50 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

51 SYSTEM_DEFINED Character(2) VARCHAR2(2) NOT NULL "A flag that indicates the accounting entry line type. The valid line types are pre-populated by PeopleSoft. For example the value is ""A"" if the line represents a debit or credit to the AR account. Some examples of other values are D (Draft Receivables entry) and L (Cash Control entry). "

52 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

53 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.

54 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.

55 DOC_SEQ_NBR Character(12) VARCHAR2(12) NOT NULL Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.

56 DOC_SEQ_DATE Date(10) DATE Specifies the date that a document sequence number is assigned to a document or the date the document was created.

57 DOC_SEQ_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled
A=GL BU Undefined
B=GL BU Blank
C=Accounting Date blank
D=Doc Type Blank
E=Jrnl Type, Code, Doc Undefine
F=Sequence Range Undefine
G=Max. Sequence Number Reached
H=Manual Nbr for Auto Doc Type
I=No Manual Number Entered
J=Duplicate Manual Number
K=Invalid Ledger
L=Invalid Ledger Group
N=No Status

58 MOVEMENT_FLAG Character(1) VARCHAR2(1) NOT NULL A flag associated with a journal line that indicates whether its amount is in the natural sign or the reversal sign.
N=Natural
R=Reversal

59 USER1 Character(1) VARCHAR2(1) NOT NULL Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).

60 USER2 Character(1) VARCHAR2(1) NOT NULL Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).

61 USER3 Character(1) VARCHAR2(1) NOT NULL Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).

62 USER4 Character(1) VARCHAR2(1) NOT NULL Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).

63 USER5 Character(1) VARCHAR2(1) NOT NULL Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).

64 JOURNAL_LINE Number(9,0) DECIMAL(9) NOT NULL Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.

65 OPEN_ITEM_KEY Character(30) VARCHAR2(30) NOT NULL Open Item Key

66 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %Datetime

67 ENTERED_DTTM DateTime(26) TIMESTAMP Entered Datetime

68 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

69 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

70 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
2	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
3	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
4	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
5	ITEM_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Item Sequence Number
6	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
7	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
8	DST_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Distribution Sequence
9	PRIMARY_LEDGER	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group.
10	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
11	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
12	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
13	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
14	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField
15	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField
16	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
17	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field
18	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField
19	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference
20	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate
21	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
22	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
23	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1
24	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
25	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
26	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDIT_BU_PC
27	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDIT_PROJECT
28	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDIT_ACTIVITY
29	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS Set Control Field: BUSINESS_UNIT_PC
30	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDIT_RES_CAT Set Control Field: BUSINESS_UNIT_PC
31	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDIT_RES_SUB Set Control Field: BUSINESS_UNIT_PC
32	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: %EDIT_ANALYSIS Set Control Field: BUSINESS_UNIT_PC
33	BUDGET_DT	Date(10)	DATE	Budget Date
34	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
35	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
36	STATISTIC_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
37	JRNL_LN_REF	Character(10)	VARCHAR2(10) NOT NULL	Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
38	LINE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.
39	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
40	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
41	GL_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Status C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal
42	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
43	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
44	ACCOUNTING_DT	Date(10)	DATE NOT NULL	The accounting entry construction date for a given transaction (a generic field that crosses multiple
45	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
46	FOREIGN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
47	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
48	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
49	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor Default Value: 1
50	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
51	SYSTEM_DEFINED	Character(2)	VARCHAR2(2) NOT NULL	"A flag that indicates the accounting entry line type. The valid line types are pre-populated by PeopleSoft. For example the value is ""A"" if the line represents a debit or credit to the AR account. Some examples of other values are D (Draft Receivables entry) and L (Cash Control entry). "
52	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
53	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
54	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
55	DOC_SEQ_NBR	Character(12)	VARCHAR2(12) NOT NULL	Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
56	DOC_SEQ_DATE	Date(10)	DATE	Specifies the date that a document sequence number is assigned to a document or the date the document was created.
57	DOC_SEQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting. 1=Document Sequencing Disabled A=GL BU Undefined B=GL BU Blank C=Accounting Date blank D=Doc Type Blank E=Jrnl Type, Code, Doc Undefine F=Sequence Range Undefine G=Max. Sequence Number Reached H=Manual Nbr for Auto Doc Type I=No Manual Number Entered J=Duplicate Manual Number K=Invalid Ledger L=Invalid Ledger Group N=No Status
58	MOVEMENT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	A flag associated with a journal line that indicates whether its amount is in the natural sign or the reversal sign. N=Natural R=Reversal
59	USER1	Character(1)	VARCHAR2(1) NOT NULL	Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
60	USER2	Character(1)	VARCHAR2(1) NOT NULL	Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
61	USER3	Character(1)	VARCHAR2(1) NOT NULL	Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
62	USER4	Character(1)	VARCHAR2(1) NOT NULL	Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
63	USER5	Character(1)	VARCHAR2(1) NOT NULL	Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
64	JOURNAL_LINE	Number(9,0)	DECIMAL(9) NOT NULL	Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
65	OPEN_ITEM_KEY	Character(30)	VARCHAR2(30) NOT NULL	Open Item Key
66	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. Default Value: %Datetime
67	ENTERED_DTTM	DateTime(26)	TIMESTAMP	Entered Datetime
68	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
69	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
70	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update