AR_CC_TRAN_VW

(SQL View)
 Index Back

AR Commitment Control Header

AR Commitment Control (Revenue Estimate) Header table.

SELECT A.BUSINESS_UNIT , A.CUST_ID , A.ITEM , A.ITEM_LINE , A.ITEM_SEQ_NUM , A.CC_GROUP_SEQ_NUM , A.CC_GROUP_TYPE , A.ITEM_SEQ_NUM_ORIG , A.PROCESS_INSTANCE , A.ARRE_STATUS , A.ARRE_STATUS_PRIOR , A.GROUP_ID_CC , A.AR_SOURCE_TRAN , A.ARRE_POST_FIX , A.ACCOUNTING_DT , A.GL_ACCTG_DT , A.BUDGET_HDR_STATUS , A.KK_AMOUNT_TYPE , A.KK_TRAN_OVER_FLAG , A.KK_TRAN_OVER_OPRID , A.KK_TRAN_OVER_DTTM FROM PS_AR_CC_TRAN_HDR A WHERE A.ARRE_STATUS IN ('P','C')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUARDS_NONVW

2 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

3 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.
4 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
5 ITEM_SEQ_NUM Number(3,0) SMALLINT NOT NULL Item Sequence Number
6 CC_GROUP_SEQ_NUM Number(6,0) INTEGER NOT NULL Group Sequency
7 CC_GROUP_TYPE Character(1) VARCHAR2(1) NOT NULL Revenue Estimate Transatiion Group Type
0=Main
1=PrePay
8 ITEM_SEQ_NUM_ORIG Number(3,0) SMALLINT NOT NULL Item Sequence Number
9 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
10 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
11 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
12 GROUP_ID_CC Character(15) VARCHAR2(15) NOT NULL Group ID
13 AR_SOURCE_TRAN Character(10) VARCHAR2(10) NOT NULL Transaction Type
14 ARRE_POST_FIX Character(1) VARCHAR2(1) NOT NULL Indicate whether ok to post the fix.
N=No
Y=Yes
15 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
16 GL_ACCTG_DT Date(10) DATE GL Accounting Date
17 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
18 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
19 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes
20 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator
21 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime