CA_PREPAID_TB_H

(SQL Table)
 Index Back

Contracts Prepaid Balance Tabl

# 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

Prompt Table: CA_PREPAID_SRCH

4 CONTRACT_PPD_SEQ Number(5,0) INTEGER NOT NULL Prepaid Add Sequence
5 PREPAID_USE_SEQ Number(5,0) INTEGER NOT NULL Prepaid Use Sequence
6 CA_PPD_STATUS Character(1) VARCHAR2(1) NOT NULL Prepaid Balance Status
A=Ready
C=Completed
I=Inactive
P=Pending
X=Cancelled

Default Value: P

7 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold

Y/N Table Edit

Default Value: N

8 PREPAID_TRANS_TYPE Character(3) VARCHAR2(3) NOT NULL Prepaid Transaction Type
BUN=Inclusive Services
UNB=Non-Inclusive Services
UNP=Non-Inclusive Add'l Purchase

Default Value: BUN

9 CA_PPD_UTL_DESCR Character(30) VARCHAR2(30) NOT NULL Utilization Descr for Billing
10 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
11 START_DT Date(10) DATE NOT NULL Start Date

Default Value: %Date

12 EXPIRATION_DT Date(10) DATE Expiration Date
13 DEPLETED_DATE Date(10) DATE Date on which a shipped demand line was depleted from on-hand inventory quantity balances.
14 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

Default Value: N

15 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID

Prompt Table: CA_PPD_BP_VW

16 BPLAN_LN_NBR Number(3,0) SMALLINT NOT NULL Bill Plan Line Number
17 USE_FOR_CONTRACT Character(1) VARCHAR2(1) NOT NULL Use for All Lines in Contract

Y/N Table Edit

Default Value: N

18 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
19 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

Prompt Table: CA_DTL_RATE_VW

20 PURCHASED_AMOUNT Number(27,3) DECIMAL(26,3) NOT NULL Purchased Amount
21 REMAINING_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Remaining Amount
22 COMMITTED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Committed Assets
23 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code

Prompt Table: DST_CODE_DFR_VW

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

Prompt Table: CA_ACCT_MONVW1
Set Control Field: BUSINESS_UNIT_GL

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

Prompt Table: CA_ALTX_MONVW
Set Control Field: BUSINESS_UNIT_GL

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

Prompt Table: DEPTID_BUGL_VW

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

Prompt Table: OPERUNT_BUGL_VW

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

Prompt Table: PRODUCT_BUGL_VW

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

Prompt Table: FUND_BUGL_VW

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

Prompt Table: CLASSCF_BUGL_VW

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

Prompt Table: PROGRAM_BUGL_VW

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

Prompt Table: BUD_REF_BUGL_VW

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: CF1_BUGL_VW

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

Prompt Table: CF2_BUGL_VW

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

Prompt Table: CF3_BUGL_VW

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

Prompt Table: %EDIT_BU_PC

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

Prompt Table: %EDIT_PROJECT

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

Prompt Table: %EDIT_ACTIVITY

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

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: STAT_BUGL_VW

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

Default Value: CA_CONTR_HDR.CURRENCY_CD

Prompt Table: CURRENCY_CD_TBL

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

Default Value: CA_CONTR_HDR.DFR_REV_ACCT_DT

49 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
50 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: %Date

51 PROCESSED_FLG Character(1) VARCHAR2(1) NOT NULL Plan Processed Flag
C=Complete
E=Errors
N=Initialize
P=In Process

Default Value: N

52 COMBO_VALID_FLG Character(1) VARCHAR2(1) NOT NULL ChartField Combinatn Valid Flg
?=Validation in Progress
V=Valid ChartField Combination
X=Invalid ChartField Combo
53 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
54 TAX_PPD_OPTION Character(3) VARCHAR2(3) NOT NULL Prepaid Tax Timing
INT=Tax on Initial Bill
UTL=Tax on Utilization
55 CA_BP_TMPL_ID Character(10) VARCHAR2(10) NOT NULL Bill Plan Template
56 BP_DTL_TMPL_ID Character(10) VARCHAR2(10) NOT NULL Bill Plan Detail Template ID