| # |
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 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
|
| 5 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
|
| 6 |
VAT_ENTITY |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
|
| 7 |
ALL_PRODUCTS |
Character(1) |
VARCHAR2(1) NOT NULL |
All Products
|
| 8 |
ALL_BU |
Character(1) |
VARCHAR2(1) NOT NULL |
All Business Units
N=Specific Business Unit
Y=All Business Units
|
| 9 |
LAST_VAT_DCMNT_ID |
Number(8,0) |
INTEGER NOT NULL |
Last VAT Document ID Assigned
|
| 10 |
VAT_DCMNT_ID |
Number(8,0) |
INTEGER NOT NULL |
VAT Document ID
|
| 11 |
VAT_DCMNT_CNT |
Number(8,0) |
INTEGER NOT NULL |
VAT Document Count
|
| 12 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 13 |
VAT_LINE_CNT |
Number(5,0) |
INTEGER NOT NULL |
VAT Transaction Line Count
|
| 14 |
VAT_DCMNT_LN_MAX |
Number(5,0) |
INTEGER NOT NULL |
VAT Document Max Ln Count
|
| 15 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 16 |
UNPOST_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
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".
|
| 17 |
AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Payables
Y/N Table Edit
|
| 18 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 19 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
|
| 20 |
POSTING_PROCESS |
Character(4) |
VARCHAR2(4) NOT NULL |
Posting Process
ACAV=Period End Accruals
ACCR=AP Accrual
CANC=Payment Cancelations
CASH=Cash Clearing
CLOS=Voucher Closure
DFTA=Draft Accrual
PCAD=Card
PPAY=Prepaid Reversals
PREP=Prepaids
PYMN=Payments
RACC=Receipt Accrual
RCVL=Revaluation
REVL=Revaluations
VOID=Void
WTHA=Withholding Accrual
|
| 21 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 22 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
| 23 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 24 |
DST_ACCT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
07/20/04 st: added RCN for Advance Reconciliation
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
|
| 25 |
CF_BAL_LINE_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Chart Field Balancing Line Num
|
| 26 |
TAX_AUTHORITY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Tax Authority
|
| 27 |
BI |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing
|
| 28 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 29 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 30 |
AR |
Character(1) |
VARCHAR2(1) NOT NULL |
Receivables
|
| 31 |
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.
|
| 32 |
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.
|
| 33 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
|
| 34 |
ITEM_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Item Sequence Number
|
| 35 |
VAT_APPLICABILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated
|
| 36 |
VAT_TXN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
|
| 37 |
TAX_CD_VAT |
Character(8) |
VARCHAR2(8) NOT NULL |
Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
|
| 38 |
VAT_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
VAT Sequence Number
|
| 39 |
EX |
Character(1) |
VARCHAR2(1) NOT NULL |
Expenses
|
| 40 |
EX_DOC_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Documentation ID
|
| 41 |
EX_DOC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies Expenses Document Type
A=Cash Advance
C=Time Report
J=Time Adjustment
M=Accrual - My Wallet
R=Accrual - Expense Report
S=Expense Report
T=Travel Authorization
|
| 42 |
EX_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number
|
| 43 |
GL |
Character(1) |
VARCHAR2(1) NOT NULL |
General Ledger
Y/N Table Edit
|
| 44 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 45 |
JOURNAL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
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.
|
| 46 |
JOURNAL_DATE |
Date(10) |
DATE |
Specifies the date the journal was created.
|
| 47 |
JOURNAL_LINE |
Number(9,0) |
DECIMAL(9) NOT NULL |
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.
|
| 48 |
SYSTEM_DATE |
Date(10) |
DATE |
System Date
|
| 49 |
DOC_ID_COUNT |
Number(6,0) |
INTEGER NOT NULL |
Document ID Count
|
| 50 |
SEQUENCE_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 51 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 52 |
VAT_SOURCE_DEFN |
Character(10) |
VARCHAR2(10) NOT NULL |
Update VAT Source Definition
|
| 53 |
RECNAME_BU |
Character(15) |
VARCHAR2(15) NOT NULL |
Business Unit Recname
|
| 54 |
RECNAME_DOCID_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Doc ID Work Table
|
| 55 |
RECNAME_HEADER |
Character(15) |
VARCHAR2(15) NOT NULL |
Header Record
|
| 56 |
RECNAME_LINE |
Character(15) |
VARCHAR2(15) NOT NULL |
Line Record
|
| 57 |
RECNAME_SOURCE |
Character(15) |
VARCHAR2(15) NOT NULL |
Source Recname
|
| 58 |
RECNAME_UPD_SRC |
Character(15) |
VARCHAR2(15) NOT NULL |
VAT Transaction Update Source
|
| 59 |
RECNAME_UPD_SRC1 |
Character(15) |
VARCHAR2(15) NOT NULL |
VAT Transaction Update Source
|
| 60 |
RECNAME_UPD_SRC2 |
Character(15) |
VARCHAR2(15) NOT NULL |
VAT Transaction Update Source
|
| 61 |
RECNAME_XREF |
Character(15) |
VARCHAR2(15) NOT NULL |
Cross Reference Table
|
| 62 |
RECNAME_XREF_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Cross Reference Work Table
|
| 63 |
FIELDNAME_BU |
Character(18) |
VARCHAR2(18) NOT NULL |
Business Unit Field Name
|
| 64 |
FIELDNAME_BU_GL |
Character(18) |
VARCHAR2(18) NOT NULL |
Business Unit GL Field Name
|
| 65 |
FIELDNAME_PROC_FLG |
Character(18) |
VARCHAR2(18) NOT NULL |
In-Process Fieldname
|
| 66 |
ONVALUE |
Character(4) |
VARCHAR2(4) NOT NULL |
On Value
|
| 67 |
OFFVALUE |
Character(4) |
VARCHAR2(4) NOT NULL |
Off Value
|
| 68 |
FIELDNAME_TRN_DATE |
Character(18) |
VARCHAR2(18) NOT NULL |
Transaction Date
|
| 69 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 70 |
WHERE_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 71 |
WHERE_CLAUSE3 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 72 |
COUNTRY_VAT_RPTG |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Reporting Country
|
| 73 |
COUNTRY_VAT_FLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Country VAT Field
|
| 74 |
RESET_PROCINSTANCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Reset Proc Instance
|
| 75 |
VAT_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Distribution Status
D=Distributed
E=Error Flag
I=Ignored
M=Archival Entry
N=Not Distributed
P=Processed
R=Reversal Entry
U=Undefined
|
| 76 |
VAT_DST_ACCT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger.
|
| 77 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 78 |
BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Book Name
|
| 79 |
DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
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.
|
| 80 |
ACCOUNTING_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Represents the unique alphanumeric identifier for treasury-specific accounting entries.
|
| 81 |
ACCOUNTING_LINE |
Number(5,0) |
INTEGER NOT NULL |
The specific unique numeric identifier that distinguishes debit and credits for a given treasury accounting ent
|
| 82 |
VAT_DST_ACCT_TMP |
Character(4) |
VARCHAR2(4) NOT NULL |
Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger.
|
| 83 |
VAT_ENTITY_TXN |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
|