CNAO_AP_STG(SQL Table) |
Index Back |
|---|---|
CNAO AP staging table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 3 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 4 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 5 | ACCOUNT |
Character(10) | VARCHAR2(10) NOT NULL | Account |
| 6 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 7 | 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. |
| 8 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 9 | PYMNT_CNT |
Number(5,0) | INTEGER NOT NULL | Payments |
| 10 | 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. |
| 11 | DOC_SEQ_NBR |
Character(12) | VARCHAR2(12) NOT NULL | Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated. |
| 12 | JRNL_CRTN_SDT | Character(8) | VARCHAR2(8) NOT NULL | Journal Creation Date |
| 13 | JRNL_POST_SDT | Character(8) | VARCHAR2(8) NOT NULL | Journal Post Date |
| 14 | CNAO_ACCOUNT | Character(20) | VARCHAR2(20) NOT NULL | CNAO Account |
| 15 | CNAO_JRNL_NO | Character(12) | VARCHAR2(12) NOT NULL | CNAO Journal NO |
| 16 | JRNL_CTG_ID | Character(60) | VARCHAR2(60) NOT NULL | Journal Category ID |
| 17 | JRNL_CTG_NM | Character(60) | VARCHAR2(60) NOT NULL | Journal Category Name |
| 18 | JRNL_CTG_SHORT_NM | Character(1) | VARCHAR2(1) NOT NULL | Journal Category Short Name |
| 19 | NATURAL_BALANCE | Character(2) | VARCHAR2(2) NOT NULL |
Natural Balance
CR=Credit DR=Debit |
| 20 | APPLIED_JRNL_NO | Character(12) | VARCHAR2(12) NOT NULL | Applied Journal Number |
| 21 | APPLIED_SDT | Character(8) | VARCHAR2(8) NOT NULL | Applied Date |
| 22 | CNAO_DOCT_ID | Character(60) | VARCHAR2(60) NOT NULL | CNAO Document Type ID |
| 23 | CNAO_DOCT_NM | Character(60) | VARCHAR2(60) NOT NULL | CNAO Document Type Name |
| 24 | CNAO_TRX_TY_ID | Character(60) | VARCHAR2(60) NOT NULL | CNAO Transaction Type ID |
| 25 | CNAO_TRX_TY_NM | Character(60) | VARCHAR2(60) NOT NULL | CNAO Transaction Type Name |
| 26 | 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. " |
| 27 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 28 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
| 29 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 30 | EXCHANGE_RATE | Number(18,4) | DECIMAL(17,4) NOT NULL | Exchange Rate |
| 31 | 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 |
| 32 | 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. |
| 33 | 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. |
| 34 | POSTED_TRAN_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Posted Transaction Amount |
| 35 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 36 | DUE_SDT | Character(8) | VARCHAR2(8) NOT NULL | Due Date |
| 37 | TRANSACTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Transaction ID |
| 38 | CNAO_INV_NO | Character(60) | VARCHAR2(60) NOT NULL | Invoice Number |
| 39 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 40 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 41 | PYMNT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer |
| 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 |
| 44 | PYMNT_ID_REF | Character(20) | VARCHAR2(20) NOT NULL | Payment Reference |