CNAO_AR_EX_AET

(SQL Table)
Index Back

CNAO AR/AP Extract AET record

CNAO AR/AP shared Extract AET record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
5 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
6 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
7 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
8 CNAO_ACCOUNT Character(20) VARCHAR2(20) NOT NULL CNAO Account
9 NATURAL_BALANCE Character(2) VARCHAR2(2) NOT NULL Natural Balance
CR=Credit
DR=Debit
10 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
11 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
12 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
13 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
14 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
15 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
16 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
17 POSTED_BASE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the net balance of debit and credit amounts that have been posted to a particular ChartField combination, in the base currency of the business unit. Unless the Separate Debit/Credit option is set up, the ledger stores net amounts only.
18 POSTED_TRAN_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Posted Transaction Amount
19 PREPAID_APPL_VCHR Character(8) VARCHAR2(8) NOT NULL Applied Voucher ID
20 RPTG_BEGIN_BALANCE Signed Number(28,3) DECIMAL(26,3) NOT NULL Reporting Beginning Balance
21 MONETARY_AMT_DR Signed Number(28,3) DECIMAL(26,3) NOT NULL Base DR Amount
22 MONETARY_AMT_CR Signed Number(28,3) DECIMAL(26,3) NOT NULL Base CR Amount
23 FOREIGN_BEG_BAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Foreign Begin Bal
24 FOREIGN_AMT_DR Signed Number(28,3) DECIMAL(26,3) NOT NULL Debit Amount
25 FOREIGN_AMT_CR Signed Number(28,3) DECIMAL(26,3) NOT NULL Credit Amount
26 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
27 PYMNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Amount
28 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
29 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
30 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
31 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.
32 RULE_SETID Character(5) VARCHAR2(5) NOT NULL Rule Setid
33 DOC_TYPE_SETID Character(5) VARCHAR2(5) NOT NULL Document Type SetId
34 CATEGORY_SETID Character(5) VARCHAR2(5) NOT NULL Category SetID
35 ACCOUNT_SETID Character(5) VARCHAR2(5) NOT NULL Account SETID
36 DUMMY_FIELD Character(1) VARCHAR2(1) NOT NULL Dummy Field for Hiding Groups
37 JRNL_CODE Character(8) VARCHAR2(8) NOT NULL Journal Code
38 JRNL_TYPE Character(2) VARCHAR2(2) NOT NULL Journal Type
39 JRNL_CTG_ID Character(60) VARCHAR2(60) NOT NULL Journal Category ID
40 JRNL_CTG_NM Character(60) VARCHAR2(60) NOT NULL Journal Category Name
41 JRNL_CTG_SHORT_NM Character(1) VARCHAR2(1) NOT NULL Journal Category Short Name
42 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
43 DESCR Character(30) VARCHAR2(30) NOT NULL Description
44 CNAO_DOCT_ID Character(60) VARCHAR2(60) NOT NULL CNAO Document Type ID
45 CNAO_DOCT_NM Character(60) VARCHAR2(60) NOT NULL CNAO Document Type Name
46 CNAO_TRX_TY_ID Character(60) VARCHAR2(60) NOT NULL CNAO Transaction Type ID
47 CNAO_TRX_TY_NM Character(60) VARCHAR2(60) NOT NULL CNAO Transaction Type Name
48 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
49 AR_OPT Character(1) VARCHAR2(1) NOT NULL AR Options
B=Business Unit
S=System
T=Bill Type
50 AR_LVL Character(1) VARCHAR2(1) NOT NULL AR Level
H=Header is AR Open Item
L=Bill Line is AR Open Item
N=No AR Open Items
51 AR_DST_OPT Character(1) VARCHAR2(1) NOT NULL AR Distribution Option
H=Use Header for Distribution
L=Use Line for Distribution
52 BUSINESS_UNIT_TXN Character(5) VARCHAR2(5) NOT NULL Transaction Business Unit
53 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier
54 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField
55 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code