| ACTIVITY_ID | Activity ID | Example: 1 | ||
| KEY | Type: character | Format: Upper | Length: 15 | Decimals: 0 |
| Activity is the unit of work in PS Projects that Provides a further breakdown of projects, usually into specific tasks. Resources are assigned directly to Activities within a Project. | ||||
| BUSINESS_UNIT | Business Unit | Example: UOD01 | ||
| KEY | Type: character | Format: Upper | Length: 5 | Decimals: 0 |
| Business Unit | ||||
| CHARTFIELD1 | Purpose | Example: BUAD312111 | ||
| KEY | Type: character | Format: Upper | Length: 10 | Decimals: 0 |
| Expansion chartfield 1 | ||||
| PROJECT_ID | Project | Example: BUAD31211105000 | ||
| KEY | Type: character | Format: Upper | Length: 15 | Decimals: 0 |
| Chartfield which identifies contract and grant activities and facilities projects (eg. ARTC37211199000). Adds designators to a "Purpose" (eg. ARTC372111) indicating fiscal year, building, or other coded details. | ||||
| RESOURCE_ID | Resource ID | Example: 10413356 | ||
| KEY | Type: character | Format: Upper | Length: 40 | Decimals: 0 |
| Resource ID | ||||
| ACCOUNT | Account | Example: 195000 | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Identifies the nature of a transaction. | ||||
| ACCOUNTING_DT | Accounting Date | Example: 11/30/2004 | ||
| Type: date | Format: Upper | Length: 10 | Decimals: 0 | |
| The accounting entry construction date for a given transaction (a generic field that crosses multiple | ||||
| ACCOUNTING_PERIOD | Accounting Period | Example: 5 | ||
| Type: number | Format: Upper | Length: 3 | Decimals: 0 | |
| 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 define | ||||
| AFFILIATE | Affiliate | Example: | ||
| Type: character | Format: Upper | Length: 5 | Decimals: 0 | |
| Chartfield used to map transactions between business units when using a single interunit account. | ||||
| AFFILIATE_INTRA1 | Fund Affiliate | Example: | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| IntraUnit Affiliate1 | ||||
| ALTACCT | Alternate Account | Example: | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Alternate Account | ||||
| AM_DISTRIB_STATUS | AM Distribution Status | Example: N | ||
| Type: character | Format: Upper | Length: 1 | Decimals: 0 | |
| AM Distribution Status | ||||
| ANALYSIS_TYPE | Resource Analysis Type | Example: SFA | ||
| Type: character | Format: Upper | Length: 3 | Decimals: 0 | |
| A three-character identifier that enables you to label the different types of costs in Projects. For example, you may want to track budgeted costs(BUD), Committed costs (COM), and actual costs (ACT) | ||||
| APPL_JRNL_ID | Journal Template | Example: ACCRUAL | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Journal Template | ||||
| ASSET_ID | Asset Identification | Example: | ||
| Type: character | Format: Upper | Length: 12 | Decimals: 0 | |
| Asset Identification | ||||
| BD_DISTRIB_STATUS | BD Distribution Status | Example: I | ||
| Type: character | Format: Upper | Length: 1 | Decimals: 0 | |
| BD Distribution Status | ||||
| BI_DISTRIB_STATUS | Billing Distribution Status | Example: P | ||
| Type: character | Format: Upper | Length: 1 | Decimals: 0 | |
| Billing Distribution Status | ||||
| BILLING_DATE | Billing Date | Example: | ||
| Type: date | Format: Upper | Length: 10 | Decimals: 0 | |
| Billing Date | ||||
| BOOK | Asset Book Name | Example: | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Asset Book Name | ||||
| BUDGET_DT | Budget Date | Example: 11/30/2004 | ||
| Type: date | Format: Upper | Length: 10 | Decimals: 0 | |
| Budget Date | ||||
| BUDGET_HDR_STATUS | Budget Checking Header Status | Example: V | ||
| Type: character | Format: Upper | Length: 1 | Decimals: 0 | |
| Budget Checking Header Status | ||||
| BUDGET_LINE_STATUS | Budget Checking Line Status | Example: V | ||
| Type: character | Format: Upper | Length: 1 | Decimals: 0 | |
| Budget Checking Line Status | ||||
| BUDGET_OVER_ALLOW | Budget Overrun Allowed | Example: | ||
| Type: character | Format: Upper | Length: 1 | Decimals: 0 | |
| Budget Overrun Allowed | ||||
| BUDGET_REF | Budget Reference | Example: 2003 | ||
| Type: character | Format: Upper | Length: 8 | Decimals: 0 | |
| Budget Reference | ||||
| BUS_UNIT_GL_FROM | From Business Unit GL | Example: UOD01 | ||
| Type: character | Format: Upper | Length: 5 | Decimals: 0 | |
| From Business Unit GL | ||||
| BUSINESS_UNIT_AM | Asset Management Business Unit | Example: UOD01 | ||
| Type: character | Format: Upper | Length: 5 | Decimals: 0 | |
| Business Unit (Always = UOD01) | ||||
| BUSINESS_UNIT_AP | AP Business Unit | Example: UOD01 | ||
| Type: character | Format: Upper | Length: 5 | Decimals: 0 | |
| AP Business Unit | ||||
| BUSINESS_UNIT_AR | AR Business Unit | Example: | ||
| Type: character | Format: Upper | Length: 5 | Decimals: 0 | |
| AR Business Unit | ||||
| BUSINESS_UNIT_BD | Budgeting Business Unit | Example: UOD01 | ||
| Type: character | Format: Upper | Length: 5 | Decimals: 0 | |
| Budgeting Business Unit | ||||
| BUSINESS_UNIT_BI | Billing Business Unit | Example: UOD01 | ||
| Type: character | Format: Upper | Length: 5 | Decimals: 0 | |
| Business Unit (Always = UOD01) | ||||
| BUSINESS_UNIT_GL | General Ledger Unit | Example: UOD01 | ||
| Type: character | Format: Upper | Length: 5 | Decimals: 0 | |
| General Ledger Unit | ||||
| BUSINESS_UNIT_IN | Inventory Unit | Example: | ||
| Type: character | Format: Upper | Length: 5 | Decimals: 0 | |
| Inventory Unit | ||||
| BUSINESS_UNIT_OM | Order Management Business Unit | Example: | ||
| Type: character | Format: Upper | Length: 5 | Decimals: 0 | |
| Order Management Business Unit | ||||
| BUSINESS_UNIT_PO | PO Business Unit | Example: | ||
| Type: character | Format: Upper | Length: 5 | Decimals: 0 | |
| PO Business Unit | ||||
| CHARTFIELD2 | Source | Example: 3300000000 | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Expansion Chartfield 2 | ||||
| CHARTFIELD3 | UD Chartfield | Example: 0000000501 | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Expansion Chartfield 3 | ||||
| CLASS_FLD | Class Field | Example: 301 | ||
| Type: character | Format: Upper | Length: 5 | Decimals: 0 | |
| Class Field | ||||
| COMPANY | Company | Example: | ||
| Type: character | Format: Upper | Length: 3 | Decimals: 0 | |
| Company | ||||
| CONTRACT_LINE_NUM | Contract Line Num | Example: 1 | ||
| Type: number | Format: Upper | Length: 3 | Decimals: 0 | |
| Specific line number of contract | ||||
| CONTRACT_NUM | Contract | Example: SES-0422772 | ||
| Type: character | Format: Upper | Length: 25 | Decimals: 0 | |
| Unique identifier of a single contract. Same as "reference award number". Assigned at the point that the contract is awarded. | ||||
| CONTRACT_PPD_SEQ | Prepaid Add Sequence | Example: 0 | ||
| Type: number | Format: Upper | Length: 5 | Decimals: 0 | |
| Prepaid Add Sequence | ||||
| COST_TYPE | Cost Type | Example: | ||
| Type: character | Format: Upper | Length: 1 | Decimals: 0 | |
| Cost Type | ||||
| CUR_EFFDT | Currency Effective Date | Example: 11/30/2004 | ||
| Type: date | Format: Upper | Length: 10 | Decimals: 0 | |
| Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header. | ||||
| CURRENCY_CD | Currency Code | Example: USD | ||
| Type: character | Format: Upper | Length: 3 | Decimals: 0 | |
| Currency Code | ||||
| CUST_ID | Customer ID | Example: 0400 | ||
| Type: character | Format: Upper | Length: 15 | Decimals: 0 | |
| 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 bil | ||||
| DEMAND_LINE_NO | Demand Line No | Example: 0 | ||
| Type: number | Format: Upper | Length: 4 | Decimals: 0 | |
| Demand Line No | ||||
| DEPTID | Department | Example: 02710 | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Indicates who is responsible for or affected by the transaction. | ||||
| DESCR | Description | Example: SEMI MONTHLY BENEFITS CHARGE | ||
| Type: character | Format: Mixed | Length: 30 | Decimals: 0 | |
| Description | ||||
| DISTRIB_LINE_NUM | Distribution Line Number | Example: 0 | ||
| Type: number | Format: Upper | Length: 5 | Decimals: 0 | |
| Distribution Line Number | ||||
| DST_ACCT_TYPE | Accounting Entry Type | Example: DST | ||
| Type: character | Format: Upper | Length: 4 | Decimals: 0 | |
| 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment | ||||
| DST_SEQ_NUM | Distribution Sequence | Example: 0 | ||
| Type: number | Format: Upper | Length: 3 | Decimals: 0 | |
| Distribution Sequence | ||||
| DTTM_STAMP | Date/Time Stamp | Example: 12/08/2004 10:36:48PM | ||
| Type: date-time | Format: Seconds | Length: 26 | Decimals: 0 | |
| Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. | ||||
| DUE_DATE | Delivery Due Date from PO | Example: | ||
| Type: date | Format: Upper | Length: 10 | Decimals: 0 | |
| Delivery Due Date from PO | ||||
| EMPL_RCD | Empl Rcd Nbr | Example: 0 | ||
| Type: number | Format: Upper | Length: 3 | Decimals: 0 | |
| Empl Rcd Nbr | ||||
| EMPLID | EmplID | Example: | ||
| Type: character | Format: Upper | Length: 11 | Decimals: 0 | |
| Employee ID | ||||
| EX_DOC_ID | Expenses Document ID | Example: | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Documentation ID | ||||
| EX_DOC_TYPE | Expenses Document Type | Example: | ||
| Type: character | Format: Upper | Length: 1 | Decimals: 0 | |
| Identifies Expenses Document Type | ||||
| FA_STATUS | F&A Status | Example: D | ||
| Type: character | Format: Upper | Length: 1 | Decimals: 0 | |
| F&A Status | ||||
| FISCAL_YEAR | Fiscal Year | Example: 2005 | ||
| Type: number | Format: Upper | Length: 4 | Decimals: 0 | |
| Fiscal Year | ||||
| FOREIGN_AMOUNT | Foreign Amount | Example: 20.4 | ||
| Type: signed number | Format: Upper | Length: 28 | Decimals: 3 | |
| 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. | ||||
| FOREIGN_CURRENCY | Foreign Currency Code | Example: USD | ||
| Type: character | Format: Upper | Length: 3 | Decimals: 0 | |
| Foreign Currency Code | ||||
| FUND_CODE | Fund Code | Example: OPBAL | ||
| Type: character | Format: Upper | Length: 5 | Decimals: 0 | |
| Fund Code | ||||
| GL_DISTRIB_STATUS | Distribution Status | Example: D | ||
| Type: character | Format: Upper | Length: 1 | Decimals: 0 | |
| Distribution Status | ||||
| INCENTIVE_ID | Investment Incentive ID | Example: | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Investment Incentive ID | ||||
| INV_ITEM_ID | Item ID | Example: | ||
| Type: character | Format: Upper | Length: 18 | Decimals: 0 | |
| Item ID | ||||
| INVOICE | Invoice | Example: | ||
| Type: character | Format: Upper | Length: 22 | Decimals: 0 | |
| Invoice | ||||
| ITEM | Item ID | Example: | ||
| Type: character | Format: Upper | Length: 30 | Decimals: 0 | |
| Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number. | ||||
| ITEM_LINE | Item Line | Example: 0 | ||
| Type: number | Format: Upper | Length: 6 | Decimals: 0 | |
| Item Line | ||||
| ITEM_SEQ_NUM | Item Sequence Number | Example: 0 | ||
| Type: number | Format: Upper | Length: 2 | Decimals: 0 | |
| Item Sequence Number | ||||
| JOBCODE | Job Code | Example: | ||
| Type: character | Format: Upper | Length: 6 | Decimals: 0 | |
| Job Code | ||||
| JOURNAL_DATE | Journal Date | Example: 11/30/2004 | ||
| Type: date | Format: Upper | Length: 10 | Decimals: 0 | |
| Specifies the date the journal was created. | ||||
| JOURNAL_ID | Journal ID | Example: BENF000029 | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier. | ||||
| JOURNAL_LINE | GL Journal Line Number | Example: 25 | ||
| Type: number | Format: Upper | Length: 9 | Decimals: 0 | |
| Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header | ||||
| JOURNAL_LINE_DATE | Journal Line Date | Example: 11/30/2004 | ||
| Type: date | Format: Upper | Length: 10 | Decimals: 0 | |
| Specifies the date of a journal line. This date must be the same as the journal date on the header (JOURNAL_DATE) in order for the Parent/Child relationship to remain intact. | ||||
| JRNL_LINE_STATUS | Journal Line Status | Example: 0 | ||
| Type: character | Format: | Length: 1 | Decimals: 0 | |
| A flag that indicates the stage of processing of a journal entry. | ||||
| JRNL_LN_REF | Journal Line Reference | Example: 57320 | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| 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 | ||||
| KK_AMOUNT_TYPE | Commitment Control Amount Type | Example: | ||
| Type: character | Format: Upper | Length: 1 | Decimals: 0 | |
| Commitment Control Amount Type | ||||
| KK_TRAN_OVER_DTTM | Override Date | Example: 08/12/2004 7:01:28PM | ||
| Type: date-time | Format: Seconds | Length: 26 | Decimals: 0 | |
| Commitment Control source transaction override datetime | ||||
| KK_TRAN_OVER_FLAG | Override Transaction | Example: | ||
| Type: character | Format: Upper | Length: 1 | Decimals: 0 | |
| Commitment Control source transaction override flag | ||||
| KK_TRAN_OVER_OPRID | Override User ID | Example: cecook | ||
| Type: character | Format: Mixed | Length: 30 | Decimals: 0 | |
| Commitment Control source transaction override operator | ||||
| LEDGER | Ledger | Example: CANG_BUD | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Ledger | ||||
| LEDGER_GROUP | Ledger Group | Example: ACTUALS | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Ledger Group | ||||
| LINE_DESCR | Journal Line Description | Example: SEMI MONTHLY BENEFITS CHARGE | ||
| Type: character | Format: Mixed | Length: 30 | Decimals: 0 | |
| Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered. | ||||
| LINE_NBR | Line Number | Example: 0 | ||
| Type: number | Format: Upper | Length: 5 | Decimals: 0 | |
| Line Number | ||||
| MSTONE_SEQ | Milestone Sequence | Example: 0 | ||
| Type: number | Format: Upper | Length: 3 | Decimals: 0 | |
| Milestone Sequence | ||||
| OPEN_ITEM_STATUS | Open Item Status | Example: | ||
| Type: character | Format: Upper | Length: 1 | Decimals: 0 | |
| Open Item Status | ||||
| OPERATING_UNIT | Operating Unit | Example: | ||
| Type: character | Format: Upper | Length: 8 | Decimals: 0 | |
| Operating Unit | ||||
| OPRID | User ID | Example: GA_SCHED | ||
| Type: character | Format: Mixed | Length: 30 | Decimals: 0 | |
| A user's ID | ||||
| ORDER_INT_LINE_NO | Order Line | Example: 0 | ||
| Type: number | Format: Upper | Length: 5 | Decimals: 0 | |
| Order Line | ||||
| ORDER_NO | Order No | Example: | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop | ||||
| PAY_END_DT | Pay Period End Date | Example: | ||
| Type: date | Format: Upper | Length: 10 | Decimals: 0 | |
| Pay Period End Date | ||||
| PC_DISTRIB_STATUS | PC Distribution Status | Example: D | ||
| Type: character | Format: Upper | Length: 1 | Decimals: 0 | |
| PC Distribution Status | ||||
| PO_DISTRIB_STATUS | PO Distribution Status | Example: 0 | ||
| Type: character | Format: Upper | Length: 1 | Decimals: 0 | |
| PO Distribution Status | ||||
| PO_ID | Purchase Order | Example: | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Purchase Order | ||||
| PROCESS_INSTANCE | Process Instance | Example: 139276 | ||
| Type: number | Format: Upper | Length: 10 | Decimals: 0 | |
| Process Instance | ||||
| PRODUCT | Product | Example: | ||
| Type: character | Format: Upper | Length: 6 | Decimals: 0 | |
| Product - Captures additional information useful for profitability and cash flow analysis by product sold. | ||||
| PROFILE_ID | Asset Profile ID | Example: | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Asset Profile ID | ||||
| PROGRAM_CODE | Program Code | Example: RSCH1 | ||
| Type: character | Format: Upper | Length: 5 | Decimals: 0 | |
| Program Code | ||||
| PROJ_TRANS_CODE | Project Transaction Code | Example: | ||
| Type: character | Format: Upper | Length: 5 | Decimals: 0 | |
| Project Transaction Code | ||||
| PROJ_TRANS_TYPE | Project Transaction Type | Example: VCH | ||
| Type: character | Format: Upper | Length: 3 | Decimals: 0 | |
| Project Transaction Type | ||||
| PYMNT_CNT | Payments | Example: 0 | ||
| Type: number | Format: Upper | Length: 5 | Decimals: 0 | |
| Payments | ||||
| RATE_DIV | Rate Divisor | Example: 1 | ||
| Type: number | Format: Upper | Length: 16 | Decimals: 8 | |
| Rate Divisor | ||||
| RATE_MULT | Rate Multiplier | Example: 1 | ||
| Type: signed number | Format: Upper | Length: 17 | Decimals: 8 | |
| Rate Multiplier | ||||
| REQ_DISTRIB_NBR | Requisition Distrib Number | Example: 0 | ||
| Type: number | Format: Upper | Length: 5 | Decimals: 0 | |
| Requisition Distrib Number | ||||
| REQ_ID | Requisition ID | Example: | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Requisition ID | ||||
| REQ_LINE_NBR | Requisition Line Number | Example: 0 | ||
| Type: number | Format: Upper | Length: 5 | Decimals: 0 | |
| Requisition Line Number | ||||
| REQ_SCHED_NBR | Requisition Schedule Number | Example: 0 | ||
| Type: number | Format: Upper | Length: 3 | Decimals: 0 | |
| Requisition Schedule Number | ||||
| RES_USER1 | Resource User 1 | Example: | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Resource User 1 | ||||
| RES_USER2 | Resource User 2 | Example: | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Resource User 2 | ||||
| RES_USER3 | Resource User 3 | Example: | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Resource User 3 | ||||
| RES_USER4 | Resource User 4 | Example: | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Resource User 4 | ||||
| RES_USER5 | Resource User 5 | Example: | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Resource User 5 | ||||
| RESOURCE_AMOUNT | Resource Amount | Example: 20.4 | ||
| Type: signed number | Format: Upper | Length: 28 | Decimals: 3 | |
| Resource Amount | ||||
| RESOURCE_CATEGORY | Resource Category | Example: | ||
| Type: character | Format: Upper | Length: 5 | Decimals: 0 | |
| Resource Category | ||||
| RESOURCE_ID_FROM | Original Resource ID | Example: GUOD01BENF0000292004-11-30025 | ||
| Type: character | Format: Upper | Length: 40 | Decimals: 0 | |
| Original Resource ID | ||||
| RESOURCE_QUANTITY | Resource Quantity | Example: 0 | ||
| Type: signed number | Format: Upper | Length: 16 | Decimals: 2 | |
| Resource Quantity | ||||
| RESOURCE_STATUS | Resource Status | Example: | ||
| Type: character | Format: Upper | Length: 1 | Decimals: 0 | |
| Resource Status | ||||
| RESOURCE_SUB_CAT | Resource SubCategory | Example: | ||
| Type: character | Format: Upper | Length: 5 | Decimals: 0 | |
| Resource SubCategory | ||||
| RESOURCE_TYPE | Resource Type | Example: | ||
| Type: character | Format: Upper | Length: 5 | Decimals: 0 | |
| Resource Type | ||||
| REV_DISTRIB_STATUS | Revenue Distribution Status | Example: I | ||
| Type: character | Format: Upper | Length: 1 | Decimals: 0 | |
| Revenue Distribution Status | ||||
| RT_TYPE | Rate Type | Example: CRRNT | ||
| Type: character | Format: Upper | Length: 5 | Decimals: 0 | |
| Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. | ||||
| SCHED_LINE_NO | Sched Line No | Example: 0 | ||
| Type: number | Format: Upper | Length: 7 | Decimals: 2 | |
| Sched Line No | ||||
| SCHED_NBR | Schedule Number | Example: 0 | ||
| Type: number | Format: Upper | Length: 3 | Decimals: 0 | |
| Schedule Number | ||||
| SEQ_NBR | Sequence Number | Example: 0 | ||
| Type: number | Format: Upper | Length: 15 | Decimals: 0 | |
| Sequence Number | ||||
| STATISTICS_CODE | Statistics Code | Example: | ||
| Type: character | Format: Upper | Length: 3 | Decimals: 0 | |
| Statistics Code | ||||
| SYSTEM_SOURCE | System Source | Example: BGM | ||
| Type: character | Format: Upper | Length: 3 | Decimals: 0 | |
| Identifies the application or source system that generated a journal entry. | ||||
| TIME_RPTG_CD | Time Reporting Code | Example: | ||
| Type: character | Format: Upper | Length: 5 | Decimals: 0 | |
| Time Reporting Code | ||||
| TRANS_DT | Transaction Date | Example: 12/8/2004 | ||
| Type: date | Format: Upper | Length: 10 | Decimals: 0 | |
| Transaction Date | ||||
| UNIT_OF_MEASURE | Unit of Measure | Example: EA | ||
| Type: character | Format: Upper | Length: 3 | Decimals: 0 | |
| Used on an approval rule set. | ||||
| UNPOST_SEQ | UnPost Sequence | Example: 0 | ||
| Type: number | Format: Upper | Length: 2 | Decimals: 0 | |
| Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1". | ||||
| VENDOR_ID | Vendor ID | Example: E43596 | ||
| Type: character | Format: Upper | Length: 10 | Decimals: 0 | |
| Vendor Identifier | ||||
| VOUCHER_ID | Voucher ID | Example: B0404386 | ||
| Type: character | Format: Upper | Length: 8 | Decimals: 0 | |
| Voucher ID | ||||
| VOUCHER_LINE_NUM | Voucher Line Number | Example: 0 | ||
| Type: number | Format: Upper | Length: 5 | Decimals: 0 | |
| Voucher Line Number | ||||