| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
VCHR_BLD_KEY_C1 |
Character(25) |
VARCHAR2(25) NOT NULL |
Voucher Build Key Char 1
|
| 4 |
VCHR_BLD_KEY_C2 |
Character(25) |
VARCHAR2(25) NOT NULL |
Voucher Build Key Char 1
|
| 5 |
VCHR_BLD_KEY_N1 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Voucher Build Key Num 1
|
| 6 |
VCHR_BLD_KEY_N2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Vchr Build Key Num 2
|
| 7 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 8 |
VOUCHER_STYLE |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Style
A=Adjustment
ADJ=Adjustments
ERS=ERS Voucher
J=Journal
JRNL=Journal Voucher
P=Purchase Order
PPAY=Prepaid Voucher
R=Regular
REG=Regular Voucher
THRD=Third Party Voucher
TMPL=Template Voucher
|
| 9 |
INVOICE_ID |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice Number
|
| 10 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 11 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor Set ID
|
| 12 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 13 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 14 |
ADDRESS_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Address Sequence Number
|
| 15 |
GRP_AP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Control Group ID
|
| 16 |
ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
|
| 17 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 18 |
ACCOUNTING_DT |
Date(10) |
DATE |
Accounting Date
|
| 19 |
POST_VOUCHER |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Voucher Now
D=Post Later
N=Do Not Post
P=Post Immediately
|
| 20 |
DST_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Accounting Template
|
| 21 |
VOUCHER_ID_RELATED |
Character(8) |
VARCHAR2(8) NOT NULL |
Related Voucher
|
| 22 |
GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Invoice Amount
|
| 23 |
DSCNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amount
|
| 24 |
TAX_EXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Flag
|
| 25 |
SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 26 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 27 |
MISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc. Amount
|
| 28 |
PYMNT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment Terms ID
|
| 29 |
ENTERED_DT |
Date(10) |
DATE |
Entered on
|
| 30 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 31 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 32 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 33 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 34 |
VAT_ENTRD_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Entered VAT amount.
|
| 35 |
MATCH_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Action
E=ERS Match
N=No Matching
Y=Standard Match
|
| 36 |
CUR_RT_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Exchange Rate Source
T=Use Exchange Rate Tables
U=User Specified
|
| 37 |
DSCNT_AMT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount Amount Control
T=Controlled by Payment Terms
U=User Specified
|
| 38 |
DUE_DT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Due Date Control
T=Controlled by Terms
U=User Specified
|
| 39 |
VCHR_APPRVL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Approval Flag
D=Default from Higher Level
P=Pre-Approved
S=Specify at this Level
|
| 40 |
BUSPROCNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
|
| 41 |
APPR_RULE_SET |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Rule Set
|
| 42 |
VAT_DCLRTN_POINT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT declaration point.
D=Delivery
I=At Invoice Time
P=At Payment Time
|
| 43 |
VAT_CALC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT calculation type.
E=Exclusive
I=Inclusive
N=Not Applicable
|
| 44 |
VAT_CALC_GROSS_NET |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT calculate at gross or net.
G=Calculate at Gross
N=Calculate at Net
|
| 45 |
VAT_RECALC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT recalculation at payment.
|
| 46 |
VAT_CALC_FRGHT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT include freight.
|
| 47 |
VAT_TREATMENT_GRP |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment Group
|
| 48 |
COUNTRY_SHIP_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
Ship From Country
|
| 49 |
STATE_SHIP_FROM |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship From State
|
| 50 |
COUNTRY_SHIP_TO |
Character(3) |
VARCHAR2(3) NOT NULL |
Ship to Country
|
| 51 |
STATE_SHIP_TO |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship To State
|
| 52 |
COUNTRY_VAT_BILLFR |
Character(3) |
VARCHAR2(3) NOT NULL |
Seller's VAT Rgstrn Country
|
| 53 |
COUNTRY_VAT_BILLTO |
Character(3) |
VARCHAR2(3) NOT NULL |
Buyer's VAT Rgstrn Country
|
| 54 |
VAT_EXCPTN_CERTIF |
Character(20) |
VARCHAR2(20) NOT NULL |
VAT certification id.
|
| 55 |
VAT_ROUND_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
" Rounding rule to be applied to VAT calculations. Options are 'Natural'
D=Round Down
N=Natural Round
U=Round Up
|
| 56 |
COUNTRY_LOC_SELLER |
Character(3) |
VARCHAR2(3) NOT NULL |
Seller's Location Country - May be either the VAT Entity or the Trading Partner
|
| 57 |
STATE_LOC_SELLER |
Character(6) |
VARCHAR2(6) NOT NULL |
Seller's Location State - May be either the VAT Entity or the Trading Partner
|
| 58 |
COUNTRY_LOC_BUYER |
Character(3) |
VARCHAR2(3) NOT NULL |
Buyer's Location Country - May be either the VAT Entity or the Trading Partner
|
| 59 |
STATE_LOC_BUYER |
Character(6) |
VARCHAR2(6) NOT NULL |
Buyer's Location State - May be either the VAT Entity or the Trading Partner
|
| 60 |
COUNTRY_VAT_SUPPLY |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Place of Supply Country
|
| 61 |
STATE_VAT_SUPPLY |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Place of Supply State
|
| 62 |
COUNTRY_VAT_PERFRM |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Where Service Physically Performed
|
| 63 |
STATE_VAT_PERFRM |
Character(6) |
VARCHAR2(6) NOT NULL |
State Where Service Physically Performed
|
| 64 |
STATE_VAT_DEFAULT |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Defaulting State
|
| 65 |
PREPAID_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Prepayment Reference
|
| 66 |
PREPAID_AUTO_APPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatically Apply Prepayment
|
| 67 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 68 |
EIN_FEDERAL |
Character(9) |
VARCHAR2(9) NOT NULL |
EIN Federal
|
| 69 |
EIN_STATE_LOCAL |
Character(20) |
VARCHAR2(20) NOT NULL |
EIN State Local
|
| 70 |
IN_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
In Process
|
| 71 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 72 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 73 |
PACKSLIP_NO |
Character(22) |
VARCHAR2(22) NOT NULL |
Packing Slip Number
|
| 74 |
PAY_TRM_BSE_DT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Terms Basis Date Type
A=Accounting Date
C=Constructive Doc Receipt Date
I=Invoice Date
R=Receipt Date
S=Ship Date
U=User Specified Date
|
| 75 |
VAT_CALC_MISC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT include miscellaneous.
|
| 76 |
IMAGE_REF_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Image Reference ID
|
| 77 |
IMAGE_DATE |
Date(10) |
DATE |
Image Date
|
| 78 |
PAY_SCHEDULE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Schedule Type
|
| 79 |
TAX_GRP |
Character(4) |
VARCHAR2(4) NOT NULL |
Tax group.
|
| 80 |
TAX_PYMNT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Tax payment type.
|
| 81 |
INSPECT_DT |
Date(10) |
DATE |
Inspection Date
|
| 82 |
INV_RECPT_DT |
Date(10) |
DATE |
Invoice Receipt Date
|
| 83 |
RECEIPT_DT |
Date(10) |
DATE |
Received Date
|
| 84 |
BILL_OF_LADING |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
|
| 85 |
CARRIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Carrier ID
|
| 86 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Document Type
L=Letter
N=Notice
O=Other
Q=Request
R=Report
|
| 87 |
DSCNT_DUE_DT |
Date(10) |
DATE |
Discount Due Date
|
| 88 |
DSCNT_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Discount
|
| 89 |
DUE_DT |
Date(10) |
DATE |
Expected Birth Date
|
| 90 |
ECQUEUEINSTANCE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
|
| 91 |
ECTRANSID |
Character(15) |
VARCHAR2(15) NOT NULL |
Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
|
| 92 |
FRGHT_CHARGE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
|
| 93 |
LC_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Letter of Credit ID
|
| 94 |
MISC_CHARGE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
|
| 95 |
REMIT_ADDR_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Remitting Location
|
| 96 |
SALETX_CHARGE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
|
| 97 |
VCHR_BLD_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Voucher Build Code
|
| 98 |
BUSINESS_UNIT_AR |
Character(5) |
VARCHAR2(5) NOT NULL |
AR Business Unit
|
| 99 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer ID
|
| 100 |
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.
|
| 101 |
ITEM_LINE |
Number(3,0) |
SMALLINT NOT NULL |
Item Line
|
| 102 |
ERS_INV_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
ERS Invoice Sequence
|
| 103 |
LS_KEY |
Number(15,0) |
DECIMAL(15) NOT NULL |
Lease Key, Unique Key
|
| 104 |
VCHR_SRC |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Source
CNTR=Contracts
CONS=Consigned Inventory
EDI=EDI
MADJ=Match Adjustment
NERS=Non PO Evaluated Receipt
ONL=On Line
PAYR=Payroll Interface
PERS=PO Evaluated Receipts
QUCK=Quick Invoice
RTV=Return To Vendor
TADJ=Tax Adjustment
|
| 105 |
VAT_EXCPTN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT exception type.
N=None
S=Suspended
X=Exonerated
|
| 106 |
TERMS_BASIS_DT |
Date(10) |
DATE |
Payment Terms Basis Date
|
| 107 |
USER_VCHR_CHAR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Character Field
|
| 108 |
USER_VCHR_CHAR2 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Character Field 2
|
| 109 |
USER_VCHR_DEC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
User Amount Field
|
| 110 |
USER_VCHR_DATE |
Date(10) |
DATE |
User Date
|
| 111 |
USER_VCHR_NUM1 |
Number(3,0) |
SMALLINT NOT NULL |
User Number field
|
| 112 |
USER_HDR_CHAR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Header User Field
|