CNAO_ARBAL_STG(SQL Table) |
Index Back |
|---|---|
CNAO AR Extract Staging record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT_GL |
Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 4 | 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. |
| 5 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 6 | CUST_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
| 7 | 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. |
| 8 | 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. |
| 9 | ITEM_LINE |
Number(6,0) | INTEGER NOT NULL | Item Line |
| 10 | ITEM_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Item Sequence Number |
| 11 | DST_SEQ_NUM |
Number(6,0) | INTEGER NOT NULL | Distribution Sequence |
| 12 | CNAO_ACCOUNT |
Character(20) | VARCHAR2(20) NOT NULL | CNAO Account |
| 13 | JRNL_CRTN_SDT | Character(8) | VARCHAR2(8) NOT NULL | Journal Creation Date |
| 14 | JRNL_POST_SDT | Character(8) | VARCHAR2(8) NOT NULL | Journal Post Date |
| 15 | JRNL_CTG_ID | Character(60) | VARCHAR2(60) NOT NULL | Journal Category ID |
| 16 | JRNL_CTG_NM | Character(60) | VARCHAR2(60) NOT NULL | Journal Category Name |
| 17 | JRNL_CTG_SHORT_NM | Character(1) | VARCHAR2(1) NOT NULL | Journal Category Short Name |
| 18 | CNAO_JRNL_NO | Character(12) | VARCHAR2(12) NOT NULL | CNAO Journal NO |
| 19 | 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. " |
| 20 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 21 | EXCHANGE_RATE | Number(18,4) | DECIMAL(17,4) NOT NULL | Exchange Rate |
| 22 | NATURAL_BALANCE | Character(2) | VARCHAR2(2) NOT NULL |
Natural Balance
CR=Credit DR=Debit |
| 23 | 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. |
| 24 | POSTED_TRAN_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Posted Transaction Amount |
| 25 | BASE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents a transaction amount calculated and stored in the base currency of its associated General Ledger bus |
| 26 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
| 27 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 28 | 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. |
| 29 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 30 | DUE_SDT | Character(8) | VARCHAR2(8) NOT NULL | Due Date |
| 31 | APPLIED_JRNL_NO | Character(12) | VARCHAR2(12) NOT NULL | Applied Journal Number |
| 32 | APPLIED_SDT | Character(8) | VARCHAR2(8) NOT NULL | Applied Date |
| 33 | CNAO_DOCT_ID | Character(60) | VARCHAR2(60) NOT NULL | CNAO Document Type ID |
| 34 | CNAO_DOCT_NM | Character(60) | VARCHAR2(60) NOT NULL | CNAO Document Type Name |
| 35 | CNAO_TRX_TY_ID | Character(60) | VARCHAR2(60) NOT NULL | CNAO Transaction Type ID |
| 36 | CNAO_TRX_TY_NM | Character(60) | VARCHAR2(60) NOT NULL | CNAO Transaction Type Name |
| 37 | CNAO_TRAN_NAME | Character(60) | VARCHAR2(60) NOT NULL | Transaction Name |
| 38 | CNAO_INV_NO | Character(60) | VARCHAR2(60) NOT NULL | Invoice Number |
| 39 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 40 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 41 | PAYMENT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft.
10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report |
| 42 | PAYMENT_SDT | Character(8) | VARCHAR2(8) NOT NULL | Payment Date |
| 43 | CLEAR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Closed
N=Not Closed Y=Closed Default Value: N |
| 44 | DRAFT_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies a payment draft. The Draft ID is system-generated during the Draft Creation process or manually entered. |
| 45 | RPTG_APPL_ID | Character(3) | VARCHAR2(3) NOT NULL |
Reporting Application
AP=Accounts Payable AR=Accounts Receivable BI=Billing EX=Expenses |