AR_CCTRN_HDR_H (SQL Table)	Index Back
Archive AR_CC_TRAN_HDR AR Commitment Control (Revenue Estimate) Header table.

AR_CCTRN_HDR_H

(SQL Table)

Archive AR_CC_TRAN_HDR

AR Commitment Control (Revenue Estimate) Header table.

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUARDS_NONVW

4 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.
Prompt Table: AR_CCTRAN_C_VW

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

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

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

8 CC_GROUP_SEQ_NUM Number(6,0) INTEGER NOT NULL Group Sequency

9 CC_GROUP_TYPE Character(1) VARCHAR2(1) NOT NULL Revenue Estimate Transatiion Group Type
0=Main
1=PrePay

10 ITEM_SEQ_NUM_ORIG Number(3,0) SMALLINT NOT NULL Item Sequence Number

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

12 ARRE_STATUS Character(1) VARCHAR2(1) NOT NULL Process status indicator for AR Commitment Control
B=Processed by Billing
C=Corrected online
E=Unknown Error
M=Unable dist to multi rev lines
N=No effect on revenue estimate
O=Transfered out of Bus Unit
P=Processed successfully
R=No item rev lines
S=Skip process
T=No transfer 'from' item found
U=No revenue lines
X=Error exists in prior activity

13 ARRE_STATUS_PRIOR Character(1) VARCHAR2(1) NOT NULL Revenue Estimate Status
B=Processed by Billing
C=Corrected online
E=Unknown Error
M=Unable dist to multi rev lines
N=No effect on revenue estimate
O=Transfered out of Bus Unit
P=Processed successfully
R=No item rev lines
S=Skip process
T=No transfer 'from' item found
U=No revenue lines
X=Error exists in prior activity

14 GROUP_ID_CC Character(15) VARCHAR2(15) NOT NULL Group ID

15 AR_SOURCE_TRAN Character(10) VARCHAR2(10) NOT NULL Transaction Type

16 ARRE_POST_FIX Character(1) VARCHAR2(1) NOT NULL Indicate whether ok to post the fix.
N=No
Y=Yes

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

18 GL_ACCTG_DT Date(10) DATE GL Accounting Date

19 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid

20 KK_AMOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic

21 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes

22 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator

23 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime

24 CC_AMT_MULTIPLIER Signed Number(2,0) DECIMAL(1) NOT NULL To reset the sign of the amount when generating commitment control source transaction.

25 CC_REV_BUCKET Character(1) VARCHAR2(1) NOT NULL Inidcate which revenue bucket to update.
B=Both
C=Collected
N=None
R=Recognized

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

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

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

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

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

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

32 ARRE_POST_SIGN Signed Number(2,0) DECIMAL(1) NOT NULL To reset the sign of the amount when generating commitment control source transaction.

33 ENTRY_USE_ID Character(5) VARCHAR2(5) NOT NULL Specifies the System Function or type of processing associated with an entry type.

34 GROUP_BU Character(5) VARCHAR2(5) NOT NULL Represents the high level grouping of multiple general ledger business units.

35 GROUP_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.

36 GROUP_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.

37 GROUP_TYPE Character(1) VARCHAR2(1) NOT NULL Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.

38 DRAFT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the Receivables business unit associated with a draft. This field is maintained by the Draft Creation process.

39 DRAFT_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a payment draft. The Draft ID is system-generated during the Draft Creation process or manually entered.

#	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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUARDS_NONVW
4	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. Prompt Table: AR_CCTRAN_C_VW
5	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.
6	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
7	ITEM_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Item Sequence Number
8	CC_GROUP_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Group Sequency
9	CC_GROUP_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Revenue Estimate Transatiion Group Type 0=Main 1=PrePay
10	ITEM_SEQ_NUM_ORIG	Number(3,0)	SMALLINT NOT NULL	Item Sequence Number
11	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
12	ARRE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Process status indicator for AR Commitment Control B=Processed by Billing C=Corrected online E=Unknown Error M=Unable dist to multi rev lines N=No effect on revenue estimate O=Transfered out of Bus Unit P=Processed successfully R=No item rev lines S=Skip process T=No transfer 'from' item found U=No revenue lines X=Error exists in prior activity
13	ARRE_STATUS_PRIOR	Character(1)	VARCHAR2(1) NOT NULL	Revenue Estimate Status B=Processed by Billing C=Corrected online E=Unknown Error M=Unable dist to multi rev lines N=No effect on revenue estimate O=Transfered out of Bus Unit P=Processed successfully R=No item rev lines S=Skip process T=No transfer 'from' item found U=No revenue lines X=Error exists in prior activity
14	GROUP_ID_CC	Character(15)	VARCHAR2(15) NOT NULL	Group ID
15	AR_SOURCE_TRAN	Character(10)	VARCHAR2(10) NOT NULL	Transaction Type
16	ARRE_POST_FIX	Character(1)	VARCHAR2(1) NOT NULL	Indicate whether ok to post the fix. N=No Y=Yes
17	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
18	GL_ACCTG_DT	Date(10)	DATE	GL Accounting Date
19	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid
20	KK_AMOUNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control Amount Type 0=Budget 1=Actuals and Recognized 2=Encumbrance 3=Pre-Encumbrance 4=Collected Revenue 5=Planned 7=Actuals, Recognize and Collect 9=Dynamic
21	KK_TRAN_OVER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control source transaction override flag N=No Y=Yes
22	KK_TRAN_OVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Commitment Control source transaction override operator
23	KK_TRAN_OVER_DTTM	DateTime(26)	TIMESTAMP	Commitment Control source transaction override datetime
24	CC_AMT_MULTIPLIER	Signed Number(2,0)	DECIMAL(1) NOT NULL	To reset the sign of the amount when generating commitment control source transaction.
25	CC_REV_BUCKET	Character(1)	VARCHAR2(1) NOT NULL	Inidcate which revenue bucket to update. B=Both C=Collected N=None R=Recognized
26	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.
27	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
28	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
29	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.
30	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
31	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
32	ARRE_POST_SIGN	Signed Number(2,0)	DECIMAL(1) NOT NULL	To reset the sign of the amount when generating commitment control source transaction.
33	ENTRY_USE_ID	Character(5)	VARCHAR2(5) NOT NULL	Specifies the System Function or type of processing associated with an entry type.
34	GROUP_BU	Character(5)	VARCHAR2(5) NOT NULL	Represents the high level grouping of multiple general ledger business units.
35	GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
36	GROUP_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.
37	GROUP_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.
38	DRAFT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the Receivables business unit associated with a draft. This field is maintained by the Draft Creation process.
39	DRAFT_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a payment draft. The Draft ID is system-generated during the Draft Creation process or manually entered.