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
|
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
|
30 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
|
31 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
|
32 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDIT_ANALYSIS
|
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 |