AR_DJACCT_EC

(SQL Table)
Index Back

AR Payload DJ Staging

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
2 LB_BANK_TRANS_ID Character(20) VARCHAR2(20) NOT NULL Bank Transmission ID
3 LOCKBOX_ID Character(15) VARCHAR2(15) NOT NULL Lockbox ID
4 LOCKBOX_BATCH_ID Character(5) VARCHAR2(5) NOT NULL Lockbox Batch Id
5 PAYMENT_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
6 DST_SEQ_NUM Number(6,0) INTEGER NOT NULL Distribution Sequence
7 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
9 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
10 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Prompt Table: SP_BU_GL_NONVW

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

Prompt Table: AR_ACCT_VW
Set Control Field: BUSINESS_UNIT_GL

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

Prompt Table: %EDIT_ALTACCT

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

Prompt Table: %EDIT_DEPT

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

Prompt Table: %EDIT_OPER_UNIT

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

Prompt Table: %EDIT_PRODUCT

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

Prompt Table: %EDIT_FUND_CODE

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

Prompt Table: %EDIT_CLASS_FLD

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

Prompt Table: %EDIT_PROG_CODE

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

Prompt Table: %EDIT_BUD_REF

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: %EDIT_CHARTFLD1

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

Prompt Table: %EDIT_CHARTFLD2

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

Prompt Table: %EDIT_CHARTFLD3

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

Prompt Table: %EDIT_BU_PC

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

Prompt Table: %EDIT_PROJECT

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

Prompt Table: %EDIT_ACTIVITY

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

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

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

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

33 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
34 CF_EDIT_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not accounting entries have been edited for valid ChartField combinations. If an edit has taken place the status indicates whether or not it was successful. The ChartField Combination Edit program populates the field as Complete Errors or Not Edited.
C=Complete
E=Errors
N=Not Edited
35 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.
36 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.
37 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
38 ACCOUNTING_DT Date(10) DATE NOT NULL The accounting entry construction date for a given transaction (a generic field that crosses multiple
39 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.
40 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.
41 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
42 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
43 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
44 SYSTEM_DEFINED Character(2) VARCHAR2(2) NOT NULL "A flag that indicates the accounting entry line type. The valid line types are pre-populated by PeopleSoft. For example the value is ""A"" if the line represents a debit or credit to the AR account. Some examples of other values are D (Draft Receivables entry) and L (Cash Control entry). "
45 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
46 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
47 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
48 CC_AFFECTED Character(1) VARCHAR2(1) NOT NULL Indicate whether commitment control (revenue estimate) is affected.
N=No
Y=Yes
49 FOREIGN_AMOUNT_CC Signed Number(28,3) DECIMAL(26,3) NOT NULL "The deal transaction amount in the denominated
50 MONETARY_AMOUNT_CC Signed Number(28,3) DECIMAL(26,3) NOT NULL Budget Base Amount
51 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).
52 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.
53 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.
54 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
55 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
56 DATA_SOURCE Character(3) VARCHAR2(3) NOT NULL Data Source
820=820 ANSI-X12
APP=Accounts Payable Payment
BST=Bank Statement
CDR=Cash Drawer Receipts
CRX=EDIFACT CREEXT
LBX=Lockbox
ONL=Online
XEL=Excel Upload