CNAO_AR_EX_AET(SQL Table) |
Index Back |
---|---|
CNAO AR/AP Extract AET recordCNAO 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 |