CA_ACCTG_LN_P_H

(SQL Table)
Index Back

Accounting line tbl for CA/PC

Accounting line table for Contracts and Projects. Takes accounting information from Proj_Resource table and creates entries that are passed to the Jrnl Generator. 2 existing subrecords: CA_ACCTLNPC_SBR - keys CA_ACCT_NOK_SBR - no keys

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
4 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
5 ACCT_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Revenue Recognition Plan
6 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
7 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
8 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
9 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit
10 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
11 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
12 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
13 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
14 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
15 BUS_UNIT_GL_FROM Character(5) VARCHAR2(5) NOT NULL From Business Unit GL
16 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
17 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
18 RESOURCE_ID Character(40) VARCHAR2(40) NOT NULL Transaction ID
19 DISC_SUR_ID Character(15) VARCHAR2(15) NOT NULL Identifier
20 POST_SEQ_NUM Number(3,0) SMALLINT NOT NULL POSTING SEQUENCE NUMBER
21 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
22 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.
23 BILLING_DATE Date(10) DATE Billing Date
24 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
25 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
26 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
27 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
28 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.
29 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
30 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
31 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.
32 COMBO_STATUS Character(1) VARCHAR2(1) NOT NULL Combo Status
I=Invalid
V=Valid
33 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
34 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
35 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
36 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
37 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
38 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
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 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.
42 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
43 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
44 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
45 BUSINESS_UNIT_TO Character(5) VARCHAR2(5) NOT NULL 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
46 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.
47 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.
48 DESCR Character(30) VARCHAR2(30) NOT NULL Description
49 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. "
50 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
51 AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
52 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code
53 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
54 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
55 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

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

Prompt Table: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

68 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
69 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
70 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
71 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

72 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

73 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.
74 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.
75 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.
76 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
77 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
78 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
79 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
80 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
81 RESOURCE_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Quantity
82 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
83 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.
84 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
85 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
86 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
87 DST_SEQ_NUM Number(6,0) INTEGER NOT NULL Distribution Sequence
88 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.
89 DUE_DATE Date(10) DATE Delivery Due Date from PO
90 TRANS_DT Date(10) DATE Transaction Date
91 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
92 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
93 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Documentation ID
94 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
95 INCENTIVE_ID Character(10) VARCHAR2(10) NOT NULL Investment Incentive ID
96 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
97 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
98 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.
99 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
100 ITEM_SEQ_NUM Number(3,0) SMALLINT NOT NULL Item Sequence Number
101 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.
102 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)
103 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
104 MSTONE_SEQ Number(3,0) SMALLINT NOT NULL Milestone Sequence
105 OPEN_ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Open Item Status
C=Closed Item
N=Not an Open Item Account
O=Open Item
106 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
107 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
108 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
109 PAY_END_DT Date(10) DATE Pay Period End Date
110 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
111 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
112 PROJ_TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Project Transaction Code
113 PROJ_TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Project Transaction Type
114 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
115 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
116 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
117 RESOURCE_ID_FROM Character(40) VARCHAR2(40) NOT NULL Original Transaction ID
118 RESOURCE_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status
A=Resource Approved
U=Unapproved Resource
119 RES_USER1 Character(10) VARCHAR2(10) NOT NULL Transaction User 1
120 RES_USER2 Character(10) VARCHAR2(10) NOT NULL Transaction User 2
121 RES_USER3 Character(10) VARCHAR2(10) NOT NULL Transaction User 3
122 RES_USER4 Character(10) VARCHAR2(10) NOT NULL Transaction User 4
123 RES_USER5 Character(10) VARCHAR2(10) NOT NULL Transaction User 5
124 SCHED_LINE_NO Number(7,2) DECIMAL(6,2) NOT NULL Sched Line NO
125 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
126 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.
127 TIME_RPTG_CD Character(5) VARCHAR2(5) NOT NULL Time Reporting Code
128 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
129 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".
130 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
131 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
132 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
133 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).
134 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.
135 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.
136 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order

Prompt Table: SP_BU_WM_NONVW

137 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification

Prompt Table: %EDIT_WO_ID

138 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number

Prompt Table: %EDIT_WO_TASK

139 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
1=Labor
2=Tools
3=Material
140 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.

Prompt Table: %EDIT_RES_LINE