CA_ACCTG_REV_VW (SQL View)	Index Back
Rev acctg view for CAPCREV Revenue accounting view to be used in CAPCREV Accounting Definition.

CA_ACCTG_REV_VW

(SQL View)

Rev acctg view for CAPCREV

Revenue accounting view to be used in CAPCREV Accounting Definition.

SELECT A.CONTRACT_NUM , A.CONTRACT_LINE_NUM , A.ACCT_PLAN_ID , A.DST_USE , A.BUSINESS_UNIT_AM , A.BUSINESS_UNIT_AP , A.BUSINESS_UNIT_AR , A.BUSINESS_UNIT_BI , A.BUSINESS_UNIT_IN , A.BUSINESS_UNIT_OM , A.BUSINESS_UNIT_PO , A.BUSINESS_UNIT_PC , A.BUS_UNIT_GL_FROM , A.PROJECT_ID , A.ACTIVITY_ID , A.RESOURCE_ID , A.DISC_SUR_ID , A.POST_SEQ_NUM , A.ACCOUNTING_DT , A.ACCOUNTING_PERIOD , A.BILLING_DATE , A.APPL_JRNL_ID , A.BUSINESS_UNIT , A.BUSINESS_UNIT_GL , A.CURRENCY_CD , A.CUR_EFFDT , A.FISCAL_YEAR , A.FOREIGN_CURRENCY , A.FOREIGN_AMOUNT , A.COMBO_STATUS , A.AM_DISTRIB_STATUS , A.BI_DISTRIB_STATUS , A.GL_DISTRIB_STATUS , A.PC_DISTRIB_STATUS , A.PO_DISTRIB_STATUS , A.ASSET_ID , A.JOURNAL_ID , A.JOURNAL_DATE , A.JOURNAL_LINE , A.LEDGER , A.LEDGER_GROUP , A.PROCESS_INSTANCE , A.BUSINESS_UNIT_TO , A.JRNL_LN_REF , A.LINE_DESCR , A.DESCR , A.BASE_CURRENCY , A.AMOUNT , A.AMOUNT_BSE , A.DST_ID , A.ACCOUNT , A.ALTACCT , A.DEPTID , %subrec(CF16_AN_SBR,A) , A.STATISTICS_CODE , A.RATE_MULT , A.RATE_DIV , A.RT_TYPE , A.MOVEMENT_FLAG , A.DOC_TYPE , A.DOC_SEQ_NBR , A.DOC_SEQ_DATE , A.DOC_SEQ_STATUS , A.ANALYSIS_TYPE , A.RESOURCE_TYPE , A.RESOURCE_CATEGORY , A.RESOURCE_SUB_CAT , A.RESOURCE_QUANTITY , A.COMPANY , A.CUST_ID , A.DEMAND_LINE_NO , A.DISTRIB_LINE_NUM , A.DST_ACCT_TYPE , A.DST_SEQ_NUM , A.DTTM_STAMP , A.DUE_DATE , A.TRANS_DT , A.EMPLID , A.EMPL_RCD , A.EX_DOC_ID , A.EX_DOC_TYPE , A.INCENTIVE_ID , A.INVOICE , A.INV_ITEM_ID , A.ITEM , A.ITEM_LINE , A.ITEM_SEQ_NUM , A.JOURNAL_LINE_DATE , A.JRNL_LINE_STATUS , A.LINE_NBR , A.MSTONE_SEQ , A.OPEN_ITEM_STATUS , A.OPRID , A.ORDER_INT_LINE_NO , A.ORDER_NO , A.PAY_END_DT , A.PO_ID , A.PROFILE_ID , A.PROJ_TRANS_CODE , A.PROJ_TRANS_TYPE , A.PYMNT_CNT , A.REQ_ID , A.RESOURCE_AMOUNT , A.RESOURCE_ID_FROM , A.RESOURCE_STATUS , A.RES_USER1 , A.RES_USER2 , A.RES_USER3 , A.RES_USER4 , A.RES_USER5 , A.SCHED_LINE_NO , A.SCHED_NBR , A.SYSTEM_SOURCE , A.TIME_RPTG_CD , A.UNIT_OF_MEASURE , A.UNPOST_SEQ , A.VENDOR_ID , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.IU_ANCHOR_FLG , A.IU_SYS_TRAN_CD , A.IU_TRAN_CD FROM PS_CA_ACCTG_LN_PC A WHERE ANALYSIS_TYPE NOT IN ( SELECT ANALYSIS_TYPE FROM PS_PROJ_AN_GRP_MAP PROJ_AN , PS_SET_CNTRL_REC REC WHERE PROJ_AN.SETID = REC.SETID AND PROJ_AN.ANALYSIS_GROUP = 'PSCST' AND PROJ_AN.ANALYSIS_TYPE = A.ANALYSIS_TYPE AND REC.SETCNTRLVALUE = A.BUSINESS_UNIT_PC AND REC.RECNAME = 'PROJ_AN_GRP_MAP')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

3 ACCT_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Revenue Recognition Plan

4 DST_USE Character(3) VARCHAR2(3) NOT NULL Added the following inactive translates for Contracts 8.4: AP Accounts Payable Liability AS Fixed Asset CA Contra Asset CG Cost of Goods Sold CL Contra Liability EX Expense IN Inventory WP Work In Progress

5 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

6 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit

7 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit

8 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit

9 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

10 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit

11 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

12 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

13 BUS_UNIT_GL_FROM Character(5) VARCHAR2(5) NOT NULL From Business Unit GL

14 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

15 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

16 RESOURCE_ID Character(40) VARCHAR2(40) NOT NULL Transaction ID

17 DISC_SUR_ID Character(15) VARCHAR2(15) NOT NULL Identifier

18 POST_SEQ_NUM Number(3,0) SMALLINT NOT NULL POSTING SEQUENCE NUMBER

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

20 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.

21 BILLING_DATE Date(10) DATE Billing Date

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

23 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

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

26 CUR_EFFDT Date(10) DATE Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.

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

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

29 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.

30 COMBO_STATUS Character(1) VARCHAR2(1) NOT NULL Combo Status
I=Invalid
V=Valid

31 AM_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL AM Distribution Status
D=Distributed
I=Ignore
M=Modified
N=Not Distributed
P=Pending
V=Reversed

32 BI_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Billing Distribution Status
D=Distributed
I=Ignore
N=Not Distributed
P=Priced
U=Unbillable/Non-billable
W=Billing Worksheet

33 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

34 PC_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged

35 PO_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PO Distribution Status
0=Non-PO
1=Active
2=In-process
3=Error
4=Processed
5=Modified

36 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

37 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.

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

39 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.

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

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

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

43 BUSINESS_UNIT_TO Character(5) VARCHAR2(5) NOT NULL 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT

44 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.

45 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.

46 DESCR Character(30) VARCHAR2(30) NOT NULL Description

47 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "

48 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

49 AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

50 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code

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

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

53 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

54 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW

55 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Prompt Table: PRODUCT_BUGL_VW

56 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Prompt Table: FUND_BUGL_VW

57 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Prompt Table: CLASSCF_BUGL_VW

58 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW

59 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Prompt Table: BUD_REF_BUGL_VW

60 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
Prompt Table: AFFILIATE_VW

61 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01

62 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02

63 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Prompt Table: CF1_BUGL_VW

64 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW

65 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW

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

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

68 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

69 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.
Prompt Table: RT_TYPE_TBL

70 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
Default Value: N

71 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.

72 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.

73 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.

74 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

75 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

76 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

77 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

78 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

79 RESOURCE_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Quantity

80 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

81 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.

82 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No

83 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

84 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment

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

86 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.

87 DUE_DATE Date(10) DATE Delivery Due Date from PO

88 TRANS_DT Date(10) DATE Transaction Date

89 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

90 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

91 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Documentation ID

92 EX_DOC_TYPE Character(1) VARCHAR2(1) NOT NULL Identifies Expenses Document Type
A=Cash Advance
C=Time Report
J=Time Adjustment
M=Accrual - My Wallet
R=Accrual - Expense Report
S=Expense Report
T=Travel Authorization

93 INCENTIVE_ID Character(10) VARCHAR2(10) NOT NULL Investment Incentive ID

94 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

95 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

96 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.

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

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

99 JOURNAL_LINE_DATE Date(10) DATE Specifies the date of a journal line. This date must be the same as the journal date on the header (JOURNAL_DATE) in order for the Parent/Child relationship to remain intact.

100 JRNL_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates the stage of processing of a journal entry.
0=OK - No Errors
1=Uncorrected Error(s)

101 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

102 MSTONE_SEQ Number(3,0) SMALLINT NOT NULL Milestone Sequence

103 OPEN_ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Open Item Status
C=Closed Item
N=Not an Open Item Account
O=Open Item

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

105 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

106 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

107 PAY_END_DT Date(10) DATE Pay Period End Date

108 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

109 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

110 PROJ_TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Project Transaction Code

111 PROJ_TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Project Transaction Type

112 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments

113 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

114 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount

115 RESOURCE_ID_FROM Character(40) VARCHAR2(40) NOT NULL Original Transaction ID

116 RESOURCE_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status
A=Resource Approved
U=Unapproved Resource

117 RES_USER1 Character(10) VARCHAR2(10) NOT NULL Transaction User 1

118 RES_USER2 Character(10) VARCHAR2(10) NOT NULL Transaction User 2

119 RES_USER3 Character(10) VARCHAR2(10) NOT NULL Transaction User 3

120 RES_USER4 Character(10) VARCHAR2(10) NOT NULL Transaction User 4

121 RES_USER5 Character(10) VARCHAR2(10) NOT NULL Transaction User 5

122 SCHED_LINE_NO Number(7,2) DECIMAL(6,2) NOT NULL Sched Line NO

123 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

124 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.

125 TIME_RPTG_CD Character(5) VARCHAR2(5) NOT NULL Time Reporting Code

126 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

127 UNPOST_SEQ Number(2,0) SMALLINT NOT NULL Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".

128 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

129 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

130 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

131 IU_ANCHOR_FLG Character(1) VARCHAR2(1) NOT NULL Y/N flag used to specify which transaction line is the Inter/IntraUnit anchor flag (the line that contains the anchor Business Unit and ChartFields).

132 IU_SYS_TRAN_CD Character(8) VARCHAR2(8) NOT NULL System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.

133 IU_TRAN_CD Character(8) VARCHAR2(8) NOT NULL Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
2	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
3	ACCT_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Revenue Recognition Plan
4	DST_USE	Character(3)	VARCHAR2(3) NOT NULL	Added the following inactive translates for Contracts 8.4: AP Accounts Payable Liability AS Fixed Asset CA Contra Asset CG Cost of Goods Sold CL Contra Liability EX Expense IN Inventory WP Work In Progress
5	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit
6	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
7	BUSINESS_UNIT_AR	Character(5)	VARCHAR2(5) NOT NULL	AR Business Unit
8	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit
9	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
10	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
11	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
12	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
13	BUS_UNIT_GL_FROM	Character(5)	VARCHAR2(5) NOT NULL	From Business Unit GL
14	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
15	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
16	RESOURCE_ID	Character(40)	VARCHAR2(40) NOT NULL	Transaction ID
17	DISC_SUR_ID	Character(15)	VARCHAR2(15) NOT NULL	Identifier
18	POST_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	POSTING SEQUENCE NUMBER
19	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
20	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.
21	BILLING_DATE	Date(10)	DATE	Billing Date
22	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
23	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
24	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
25	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
26	CUR_EFFDT	Date(10)	DATE	Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.
27	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
28	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
29	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.
30	COMBO_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Combo Status I=Invalid V=Valid
31	AM_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	AM Distribution Status D=Distributed I=Ignore M=Modified N=Not Distributed P=Pending V=Reversed
32	BI_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Billing Distribution Status D=Distributed I=Ignore N=Not Distributed P=Priced U=Unbillable/Non-billable W=Billing Worksheet
33	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
34	PC_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PC Distribution Status B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged
35	PO_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PO Distribution Status 0=Non-PO 1=Active 2=In-process 3=Error 4=Processed 5=Modified
36	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
37	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.
38	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
39	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.
40	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
41	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
42	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
43	BUSINESS_UNIT_TO	Character(5)	VARCHAR2(5) NOT NULL	04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
44	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.
45	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.
46	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
47	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
48	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
49	AMOUNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
50	DST_ID	Character(10)	VARCHAR2(10) NOT NULL	Distribution Code
51	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
52	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
53	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
54	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
55	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
56	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
57	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
58	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
59	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
60	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
61	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
62	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
63	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
64	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
65	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
66	STATISTICS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Statistics Code
67	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
68	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
69	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. Prompt Table: RT_TYPE_TBL
70	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 Default Value: N
71	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.
72	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.
73	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.
74	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
75	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
76	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
77	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
78	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
79	RESOURCE_QUANTITY	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Quantity
80	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
81	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.
82	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
83	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
84	DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
85	DST_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Distribution Sequence
86	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.
87	DUE_DATE	Date(10)	DATE	Delivery Due Date from PO
88	TRANS_DT	Date(10)	DATE	Transaction Date
89	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
90	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
91	EX_DOC_ID	Character(10)	VARCHAR2(10) NOT NULL	Documentation ID
92	EX_DOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Identifies Expenses Document Type A=Cash Advance C=Time Report J=Time Adjustment M=Accrual - My Wallet R=Accrual - Expense Report S=Expense Report T=Travel Authorization
93	INCENTIVE_ID	Character(10)	VARCHAR2(10) NOT NULL	Investment Incentive ID
94	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
95	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
96	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.
97	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
98	ITEM_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Item Sequence Number
99	JOURNAL_LINE_DATE	Date(10)	DATE	Specifies the date of a journal line. This date must be the same as the journal date on the header (JOURNAL_DATE) in order for the Parent/Child relationship to remain intact.
100	JRNL_LINE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates the stage of processing of a journal entry. 0=OK - No Errors 1=Uncorrected Error(s)
101	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
102	MSTONE_SEQ	Number(3,0)	SMALLINT NOT NULL	Milestone Sequence
103	OPEN_ITEM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Open Item Status C=Closed Item N=Not an Open Item Account O=Open Item
104	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
105	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
106	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
107	PAY_END_DT	Date(10)	DATE	Pay Period End Date
108	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
109	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID
110	PROJ_TRANS_CODE	Character(5)	VARCHAR2(5) NOT NULL	Project Transaction Code
111	PROJ_TRANS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Project Transaction Type
112	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
113	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
114	RESOURCE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
115	RESOURCE_ID_FROM	Character(40)	VARCHAR2(40) NOT NULL	Original Transaction ID
116	RESOURCE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Transaction Status A=Resource Approved U=Unapproved Resource
117	RES_USER1	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 1
118	RES_USER2	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 2
119	RES_USER3	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 3
120	RES_USER4	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 4
121	RES_USER5	Character(10)	VARCHAR2(10) NOT NULL	Transaction User 5
122	SCHED_LINE_NO	Number(7,2)	DECIMAL(6,2) NOT NULL	Sched Line NO
123	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
124	SYSTEM_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
125	TIME_RPTG_CD	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code
126	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
127	UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
128	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
129	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
130	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
131	IU_ANCHOR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Y/N flag used to specify which transaction line is the Inter/IntraUnit anchor flag (the line that contains the anchor Business Unit and ChartFields).
132	IU_SYS_TRAN_CD	Character(8)	VARCHAR2(8) NOT NULL	System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.
133	IU_TRAN_CD	Character(8)	VARCHAR2(8) NOT NULL	Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.