| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 3 |
CLAIM_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Claim ID
|
| 4 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 5 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 6 |
TMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Field for holding temp data
|
| 7 |
CALLING_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
|
| 8 |
CLAIM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Claim Type
C=Claimbacks
R=Vendor Rebate
|
| 9 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 10 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 11 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 12 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPERUNT_BUGL_VW
|
| 13 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_BUGL_VW
|
| 14 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_BUGL_VW
|
| 15 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASSCF_BUGL_VW
|
| 16 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_BUGL_VW
|
| 17 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_BUGL_VW
|
| 18 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 19 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 20 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 21 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_BUGL_VW
|
| 22 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_BUGL_VW
|
| 23 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_BUGL_VW
|
| 24 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 25 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
|
| 26 |
SETTLEMENT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Vendor Rebate Settlement Method (Payment Method)
ACH=Automated Clearing House
AV=Adjustment Voucher
CHK=Check
CM=Credit Memo
DD=Direct Debit
DR=Draft
EFT=Electronic Funds Transfer
|
| 27 |
AE_INT_15 |
Number(15,0) |
DECIMAL(15) NOT NULL |
Number Work Field
|
| 28 |
GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
|
| 29 |
GROUP_ID_SEQ_NUM |
Number(15,0) |
DECIMAL(15) NOT NULL |
Group ID
|
| 30 |
BUSINESS_UNIT_AR |
Character(5) |
VARCHAR2(5) NOT NULL |
AR Business Unit
|
| 31 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
|
| 32 |
DRAFT_APPROVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
"Indicates whether or not a draft is pre-approved for payment by a bill-to customer. If the draft is pre-approved then it can be submitted to the customer's bank without the customer's sign-off. Otherwise the draft must be reviewed and approved by the customer before the enterprise can submit it to the bank for payment. This field is used only if the preferred payment method is ""Draft""."
P=Preapproved
R=Approval Required
|
| 33 |
DRAFT_DOC |
Character(1) |
VARCHAR2(1) NOT NULL |
"A flag that indicates whether or not (C or N) a draft document should be created for a Receivables item when the payment method is ""draft"". If the value is N then the system prints only a draft statement. If the value is C then the system creates a draft document. "
C=Create Document
N=Do Not Create Document
|
| 34 |
DRAFT_FORMAT |
Character(1) |
VARCHAR2(1) NOT NULL |
"A flag that indicates whether a draft will be associated with a single item or with multiple items. This field is used only when the payment method is ""draft""."
M=Multiple Items Per Draft
S=Single Item Per Draft
|
| 35 |
DD_PROFILE_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the Profile ID for a Direct Debit
|
| 36 |
ENTRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the monetary amount of a pending item transaction such as invoice or credit memo.
|
| 37 |
VRBT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Vendor Rebate ID
|
| 38 |
TOT_VAT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Amount
|
| 39 |
TOT_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 40 |
CLAIM_SETTLE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Claim Settlement Sequence
|
| 41 |
DOC_SEQ_DATE |
Date(10) |
DATE |
Specifies the date that a document sequence number is assigned to a document or the date the document was created.
|
| 42 |
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.
|
| 43 |
DOC_SEQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled
A=GL BU Undefined
B=GL BU Blank
C=Accounting Date blank
D=Doc Type Blank
E=Jrnl Type, Code, Doc Undefine
F=Sequence Range Undefine
G=Max. Sequence Number Reached
H=Manual Nbr for Auto Doc Type
I=No Manual Number Entered
J=Duplicate Manual Number
K=Invalid Ledger
L=Invalid Ledger Group
N=No Status
|
| 44 |
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.
|
| 45 |
VAT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Flag
|
| 46 |
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.
|
| 47 |
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
|