CA_AP_TXN_DST

(SQL Table)
Index Back

Dist Info for CRM Transactions

Distribution Information for CRM Transactions

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
2 ACCT_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Revenue Recognition Plan
3 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
4 CA_TXN_ID Number(12,0) DECIMAL(12) NOT NULL Transaction ID
5 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
6 POST_SEQ_NUM Number(3,0) SMALLINT NOT NULL POSTING SEQUENCE NUMBER
7 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
8 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
9 BUS_UNIT_GL_FROM Character(5) VARCHAR2(5) NOT NULL From Business Unit GL
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
11 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. "
12 AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
13 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
14 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code
15 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
16 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
17 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

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

Prompt Table: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

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

Prompt Table: %EDIT_BU_PC

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

Prompt Table: %EDIT_PROJECT

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

Prompt Table: %EDIT_ACTIVITY

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

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

37 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
38 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.
39 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
40 RVSL_LINE_FLG Character(1) VARCHAR2(1) NOT NULL Reversing Entry
0=Not Reversed (Reversible)
0=Not Reversed (Reversible)
1=Reversed Line
1=Reversed Line
2=Reversing Line (Not Rvsible)
2=Reversing Line (Not Rvsible)