| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUS_AP_NONVW
|
| 2 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
Default Value: NEXT
|
| 3 |
VOUCHER_STYLE |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher
|
| 4 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 5 |
ERS_INV_SEQ |
Number(5,0) |
INTEGER NOT NULL |
ERS Invoice Sequence
|
| 6 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 7 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
Default Value: VENDOR.SETID
|
| 8 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Default Value: VENDOR_SHRT_VW.VENDOR_ID
Prompt Table:
%EDITTABLE20
|
| 9 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
VNDR_LOC3_AP_VW
|
| 10 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Default Value: VENDOR.PRIM_ADDR_SEQ_NUM
Prompt Table:
VNDR_ADD3_AP_VW
|
| 11 |
GRP_AP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Control Group ID
Prompt Table:
%EDITTABLE
|
| 12 |
ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
Default Value: OPR_DEF_TBL_AP.ORIGIN
|
| 13 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_AP.OPRID
|
| 14 |
VCHR_TTL_LINES |
Number(5,0) |
INTEGER NOT NULL |
Lines Entered
|
| 15 |
CLOSE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Close Status Indicator
C=Closed
O=Open
Default Value: O
|
| 16 |
ENTRY_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: VCHR_SRCH_DEL.ENTRY_STATUS.SearchInit. Template Voucher status should not be visibile in the drop down.
C=Complete
D=Through batch defaults
E=Edited by Batch Voucher Module
L=Reviewed through Maintenance
M=Modified
O=Open
P=Postable
R=Recycle
S=Scheduled for Payment
T=Template Voucher
X=Deleted
Default Value: O
|
| 17 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 18 |
POST_VOUCHER |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Voucher Now
D=Post Later
N=Do Not Post
P=Post Immediately
Default Value: D
|
| 19 |
POST_STATUS_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Status
N=Payment Not Applied
P=Posted
U=Unposted
Default Value: U
|
| 20 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 21 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Default Value: BUS_UNIT_TBL_AP.BUSINESS_UNIT_GL
|
| 22 |
PROCESS_MAN_CLOSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Manual Close
N=No
P=Processed
Y=Yes
Default Value: N
|
| 23 |
DST_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Accounting Template
Prompt Table:
DST_CNTRL_VW
|
| 24 |
DUP_INVOICE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicate Invoice Status
Y/N Table Edit
Default Value: N
|
| 25 |
VOUCHER_ID_RELATED |
Character(8) |
VARCHAR2(8) NOT NULL |
Related Voucher
Prompt Table:
%EDITTABLE2
|
| 26 |
GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Invoice Amount
|
| 27 |
GROSS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Amount
|
| 28 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
Prompt Table:
CURR_TXN_VW
|
| 29 |
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.
Prompt Table:
RT_TYPE_TBL
|
| 30 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 31 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 32 |
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. "
|
| 33 |
DSCNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amount
|
| 34 |
DSCNT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Discount Amount
|
| 35 |
DSCNT_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Discount
Y/N Table Edit
|
| 36 |
TAX_EXEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Flag
Y/N Table Edit
Default Value: N
|
| 37 |
USETAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 38 |
USETAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Use Tax Amount
|
| 39 |
USETAX_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Use Tax
Y/N Table Edit
|
| 40 |
SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 41 |
SALETX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Sales Tax Amount
|
| 42 |
SALETX_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Sales Tax
Y/N Table Edit
|
| 43 |
VAT_INV_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Invoice Amount
|
| 44 |
VAT_INV_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Invoice Amt Base Curr
|
| 45 |
VAT_NONINV_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Non-Invoice Amount
|
| 46 |
VAT_NONINV_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Non-Invoice Amt Base Curr
|
| 47 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 48 |
FREIGHT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Freight Amount
|
| 49 |
MISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc. Amount
|
| 50 |
MISC_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Misc. Amount
|
| 51 |
FRGHT_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Freight Charges
Y/N Table Edit
|
| 52 |
DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
| 53 |
DSCNT_DUE_DT |
Date(10) |
DATE |
Discount Due Date
|
| 54 |
PYMNT_CNT_MAX |
Number(5,0) |
INTEGER NOT NULL |
Max payment count
Default Value: 1
|
| 55 |
PYMNT_CNT_TOTAL |
Number(5,0) |
INTEGER NOT NULL |
Total Payment Count
Default Value: 1
|
| 56 |
PYMNT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
Prompt Table:
PYMT_TRMS_VW
|
| 57 |
ENTERED_DT |
Date(10) |
DATE |
Entered on
Default Value: %clientdate
|
| 58 |
ENTERED_DTTM |
DateTime(26) |
TIMESTAMP |
Entered Datetime
Default Value: %Datetime
|
| 59 |
LAST_UPDATE_DT |
Date(10) |
DATE |
Last Updated
|
| 60 |
LAST_UPDATE_DTTM |
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.
Default Value: %Datetime
|
| 61 |
SES_LAST_DTTM |
DateTime(26) |
TIMESTAMP |
PTSF Last Modified DateTimestamp
Default Value: %Datetime
|
| 62 |
VCHR_PRIORITY |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a new field reserved for Mobile Approval. Added on April 24th 2012.
H=High
L=Low
M=Medium
Default Value: M
|
| 63 |
TIME_EDIT |
Time(15) |
TIMESTAMP |
Cumulative Edit Time
|
| 64 |
VCHR_TEMPLATE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Template ID
|
| 65 |
VCHR_TMPLTE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 66 |
WTHD_ADJUST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Withholding Adjustment Flag
Y/N Table Edit
Default Value: N
|
| 67 |
WTHD_FISCAL_YR |
Number(4,0) |
SMALLINT NOT NULL |
Withholding Fiscal Year
|
| 68 |
POST_STATUS_WTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Withholding Status
N=Not Postable
P=Posted
U=Unposted
X=Cancelled Withholding
Default Value: U
|
| 69 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
Y/N Table Edit
Default Value: N
|
| 70 |
VAT_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.
|
| 71 |
VAT_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Basis Amt in Base Curr
|
| 72 |
VAT_CALC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Calculated Amount
|
| 73 |
VAT_ENTRD_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Entered VAT Amount
|
| 74 |
VAT_RCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Recovery Amt
|
| 75 |
VAT_RCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Recovery Amt in Base Curr
|
| 76 |
MATCH_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Action
N=No Match
Y=Standard
Default Value: N
|
| 77 |
MATCH_STATUS_VCHR |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Status
C=Overridden - Credit Note
D=Match Dispute
E=Match Exceptions Exist
M=Matched
N=Not Applicable
O=Manually Overridden
T=To Be Matched
Default Value: N
|
| 78 |
BCM_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check
N=Not Budget Checked
V=Valid Budget Check
Default Value: N
|
| 79 |
BCM_TRAN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Transaction Type
AR=Accounts Receivable Item
EN=Encumbrance
EX=Expended
JU=Journal Unpost
JV=Journal Voucher
PM=AR Payment (Reference Item)
PN=AR Payment (No Reference Item)
PO=Purchase Order
PR=Pre Encumbrance
RQ=Requisition
Default Value: EX
|
| 80 |
MERCHANDISE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
|
| 81 |
MERCH_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Merchandise Amount
|
| 82 |
IN_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
In process flag
Y/N Table Edit
Default Value: N
|
| 83 |
MANUAL_CLOSE_DT |
Date(10) |
DATE |
Manual Close Date
|
| 84 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
Prompt Table:
CNTRCT_DRAW_VW
|
| 85 |
VERSION_NBR |
Number(5,0) |
INTEGER NOT NULL |
Contract Version number
|
| 86 |
REMIT_ADDR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Remitting Location
|
| 87 |
CUR_RT_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Exchange Rate Source
T=Use Exchange Rate Tables
U=User Specified
Default Value: T
|
| 88 |
DSCNT_AMT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount Amount Control
T=Controlled by Payment Terms
U=User Specified
Default Value: T
|
| 89 |
DUE_DT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Due Date Control
T=Controlled by Terms
U=User Specified
Default Value: T
|
| 90 |
VCHR_APPRVL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Approval Flag
D=Default from Higher Level
P=Pre-Approved
S=Virtual Approver
W=Approval Framework
Default Value: P
|
| 91 |
BUSPROCNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table:
BUSPROCNAME_VW
|
| 92 |
APPR_RULE_SET |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Rule Set
Prompt Table:
APPR_RULE_HDR
|
| 93 |
APPR_CHECK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Check Flag
Y/N Table Edit
Default Value: N
|
| 94 |
APPR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved
D=Denied
P=Pending
Default Value: P
|
| 95 |
APPR_INSTANCE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Unique number for each runtime occurrence of a virtual approver process
|
| 96 |
OPRID_LAST_UPDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Last User to Update
Default Value: OPR_DEF_TBL_AP.OPRID
|
| 97 |
VAT_DCLRTN_POINT |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time
|
| 98 |
VAT_CALC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
"A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount."
E=Exclusive
I=Inclusive
|
| 99 |
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.
|
| 100 |
VAT_RECOVERY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT Recovery Percent
|
| 101 |
VAT_CALC_GROSS_NET |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount.
G=Calculate at Gross
N=Calculate at Net
|
| 102 |
VAT_RECALC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.
Y/N Table Edit
|
| 103 |
VAT_CALC_FRGHT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Freight
Y/N Table Edit
|
| 104 |
VAT_NRCVR_PRO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Non-Recoverable VAT
Y/N Table Edit
|
| 105 |
VAT_NRCVR_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT NonRecoverable Amount
|
| 106 |
VAT_NRCVR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Non Recoverable
|
| 107 |
VAT_CALC_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Calculated Amount Base Cur
|
| 108 |
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)
|
| 109 |
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.
|
| 110 |
ECTRANSINOUTSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
|
| 111 |
VAT_RGSTRN_SELLER |
Character(20) |
VARCHAR2(20) NOT NULL |
Seller's VAT Registration
|
| 112 |
MISC_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Miscellaneous Charge
Y/N Table Edit
|
| 113 |
COUNTRY_VAT_BILLFR |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is generated (for VAT processing only).
Prompt Table:
COUNTRY_TBL
|
| 114 |
COUNTRY_VAT_BILLTO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is sent (for VAT processing only).
Prompt Table:
VAT_ENT_RGSTRN
|
| 115 |
COUNTRY_SHIP_TO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country to which the invoice contents were shipped (for VAT processing only).
Prompt Table:
COUNTRY_TBL
|
| 116 |
COUNTRY_VAT_RPTG |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Reporting Country
|
| 117 |
VAT_DCMNT_ID |
Number(8,0) |
INTEGER NOT NULL |
VAT Document ID
|
| 118 |
SALETX_CALC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Calculated Sales Tax Amount
|
| 119 |
SALETX_CLC_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Calculated Sales Tax Base Amt
|
| 120 |
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.
Prompt Table:
DOC_TYPE_TBL
|
| 121 |
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.
|
| 122 |
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.
|
| 123 |
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
|
| 124 |
VOUCHER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Type
A=Adjustment Voucher
B=Batch Edit Voucher
C=Recurring Voucher
E=ERS Voucher
J=Journal Voucher
N=Reversal Voucher
P=Prepaid Voucher
R=Regular Voucher
T=Third Party Voucher
V=Registered Voucher
X=Template Voucher
|
| 125 |
VNDR_TMPLTE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplier Template Flag
|
| 126 |
VAT_EXCPTN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
N=None
S=Suspended
X=Exonerated
|
| 127 |
VAT_EXCPTN_CERTIF |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.
|
| 128 |
COUNTRY_SHIP_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country from which the invoice contents were shipped (for VAT processing only).
|
| 129 |
VAT_REBATE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Rebate Amt
|
| 130 |
VAT_REBATE_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Rebate Amt in Base Curr
|
| 131 |
LC_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Treasury Letter of Credit Number Assigned by the System
Prompt Table:
LC_HDR_AP_VW
|
| 132 |
REVALUE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Can be either 'Y' or 'N'. This field is located on the ITEM Table and signifies whether or not an item will be considered by the Revaluation Process to be revaluated.
Y/N Table Edit
Default Value: Y
|
| 133 |
BUDGET_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
|
| 134 |
BUDGET_MISC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Checking Misc Status
E=Error in Budget Check
N=Not Budget Checked
P=Provisionally Valid
V=Valid Budget Check
|
| 135 |
KK_TRAN_OVER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control source transaction override flag
N=No
Y=Yes
|
| 136 |
KK_TRAN_OVER_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Commitment Control source transaction override operator
|
| 137 |
KK_TRAN_OVER_DTTM |
DateTime(26) |
TIMESTAMP |
Commitment Control source transaction override datetime
|
| 138 |
PREPAID_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Prepayment Reference
|
| 139 |
PREPAID_AUTO_APPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatically Apply Prepayment
Y/N Table Edit
Default Value: Y
|
| 140 |
SBI_DOC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
SelfBillingNumber
G=Group Vouchers (Auto-Num)
I=Individual Voucher (Auto-Num)
P=Individual Vchr-Invoice Number
Default Value: G
|
| 141 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
|
| 142 |
RECV_ONLY_MTCH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt Only Match
Y/N Table Edit
Default Value: N
|
| 143 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 144 |
ERS_TAX_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
ERS Tax Type
B=Sales Tax
N=No Taxes
U=Use Tax
V=Value Added Tax
|
| 145 |
ERS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
ERS Type
N=Not Applicable
P=PO Receipt
R=Non PO Receipt
Default Value: N
|
| 146 |
INV_RECPT_DT |
Date(10) |
DATE |
Invoice Receipt Date
|
| 147 |
PACKSLIP_NO |
Character(22) |
VARCHAR2(22) NOT NULL |
Packing Slip Number
|
| 148 |
RECEIPT_DT |
Date(10) |
DATE |
Received Date
|
| 149 |
SHIP_DATE |
Date(10) |
DATE |
Item Shipping Date
|
| 150 |
PAY_TRM_BSE_DT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Terms Basis Date Type
A=Acct Date
C=Doc Date
I=Inv Date
R=Recpt Date
S=Ship Date
U=User Date
|
| 151 |
TERMS_BASIS_DT |
Date(10) |
DATE |
Payment Terms Basis Date
|
| 152 |
UNMTCH_PAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay UnMatched Voucher
Y/N Table Edit
Default Value: N
|
| 153 |
UNMTCH_PAY_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
UnMatched Pay Status
N=Not Applicable
P=Paid
U=Unpaid
Default Value: N
|
| 154 |
VCHR_SRC |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Source
Default Value: ONL
|
| 155 |
VCHR_SYSGEN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
System Generated
Y/N Table Edit
Default Value: N
|
| 156 |
MEMO_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Memo Amount
|
| 157 |
MEMO_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Memo Amt Base
|
| 158 |
PAY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Amount
|
| 159 |
PAY_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Amt - Base Curr
|
| 160 |
SBI_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Selfbillingflag
Y/N Table Edit
Default Value: N
|
| 161 |
SBI_IN_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
SelfBillingProcFlag
Y/N Table Edit
Default Value: N
|
| 162 |
SBI_NUM |
Character(40) |
VARCHAR2(40) NOT NULL |
SBI_num
|
| 163 |
SBI_PROCESS_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
SelfBillingProcessinstance
|
| 164 |
DELETE_DT |
Date(10) |
DATE |
Deletion Date
|
| 165 |
CURRENCY_RPTG |
Character(3) |
VARCHAR2(3) NOT NULL |
Reporting Currency
|
| 166 |
VAT_RPTG_CURR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Amounts in Reporting Currency
|
| 167 |
RATE_MULT_VAT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored either as di
|
| 168 |
RATE_DIV_VAT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored either as direct
|
| 169 |
VAT_INV_AMT_RPTG |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Amt in Reporting Currency
|
| 170 |
VAT_TRANS_AMT_RPTG |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Transaction Amt Reporting
|
| 171 |
VAT_DCLRTN_DT |
Date(10) |
DATE |
"Specifies the date of the invoice when the VAT declaration point (VAT_DCLRTN_POINT) is ""Invoice"". The VAT declaration date is automatically set to the invoice date by the system. This field does not apply when the declaration point is ""payment"". "
|
| 172 |
VAT_DCLRTN_DT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Declaration Date Source
A=Delivery Date - Ext Process
D=Delivery Date - Txn Entry
I=Invoice Date
M=Manual Entry
N=Not Applicable
|
| 173 |
VAT_CALC_MISC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Miscellaneous
|
| 174 |
LC_EXTRCT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Landed Cost Extract Status
Default Value: N
|
| 175 |
EIN_FEDERAL |
Character(9) |
VARCHAR2(9) NOT NULL |
EIN Federal
|
| 176 |
EIN_STATE_LOCAL |
Character(20) |
VARCHAR2(20) NOT NULL |
EIN State Local
|
| 177 |
TAX_GRP |
Character(4) |
VARCHAR2(4) NOT NULL |
Tax Group Code
|
| 178 |
TAX_PYMNT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Tax Payment Type Code
|
| 179 |
VAT_ADVPAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT prepayment flag is to indicate if the VAT amount should be calculated on the advance payments
|
| 180 |
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
|
| 181 |
VAT_TRANS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the sale or purchase amount against which the VAT is applicable.
|
| 182 |
VAT_TRANS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the sale or purchase amount in base currency against which the VAT is applicable
|
| 183 |
WTHD_PREPAY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Signifies if Withholding applies to the prepayment
N=Not Applicable
V=Postpone to regular voucher
Default Value: N
|
| 184 |
VAT_CF_ANLSYS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Chartfield Analysis
E=Use Expense Line Chartfields
N=Not Applicable
V=Use VAT Accounting Chartfields
|
| 185 |
VAT_NRCVR_CHRG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
ProrateVAT Non-Recovery
Prompt Table:
BU_NRV_LC_CMPVW
|
| 186 |
VAT_RPTG_CURR_CTRL |
Character(1) |
VARCHAR2(1) NOT NULL |
VatCurrencyControl
E=Exchange Rate
N=None
T=VAT Transaction Amount
V=VAT Invoiced Amount
|
| 187 |
IMAGE_REF_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Image Reference ID
|
| 188 |
IMAGE_DATE |
Date(10) |
DATE |
Image Date
|
| 189 |
PAY_SCHEDULE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Schedule Type
MAN=Manual
OTH=Other Non Transportation
TRN=Transportation
|
| 190 |
VCHR_POADJ_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjust Purchase Order
A=Adjust Matched PO
D=Don't Adjust PO
Default Value: D
|
| 191 |
VCHR_MTCH_ADJ_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Exception Adjustment Opt
A=Automatic Generate
N=None
S=Stage
Default Value: N
|
| 192 |
INTERUNIT_ERR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Inter Unit Error Flag
Y/N Table Edit
Default Value: N
|
| 193 |
VCHR_BAL_ERR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Balance Error
Y/N Table Edit
Default Value: N
|
| 194 |
INSPECT_DT |
Date(10) |
DATE |
Inspection Date
|
| 195 |
DATE_CALC_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Calculation Basis
A=Agricultural Commodities
D=Dairy
M=Meat
O=Poultry
P=Prompt Pay Basis 7 Days
Q=Prompt Pay Basis 14 Days
|
| 196 |
BASIS_DATE |
Date(10) |
DATE |
Basis Date
|
| 197 |
PO_RECPT_DT |
Date(10) |
DATE |
Indicates date of receipt for PO
|
| 198 |
MTCH_LEVEL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Leve Status
E=Match Error
L=Line Level Matching
M=Matched
N=Not Matched
S=Standard
Default Value: N
|
| 199 |
MTCH_LEVEL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Matching Level
L=Line Leven
V=Voucher Total
Default Value: V
|
| 200 |
MATCH_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Override
N=No
O=Override Exception
Default Value: N
|
| 201 |
INVOICE_RCPT_DT |
Date(10) |
DATE |
InvoiceRecptDate
|
| 202 |
USER_VCHR_CHAR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Character Field
|
| 203 |
USER_VCHR_CHAR2 |
Character(1) |
VARCHAR2(1) NOT NULL |
User Character Field 2
|
| 204 |
USER_VCHR_DEC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
User Amount Field
|
| 205 |
USER_VCHR_DATE |
Date(10) |
DATE |
User Date
|
| 206 |
USER_VCHR_NUM1 |
Number(3,0) |
SMALLINT NOT NULL |
User Number field
|
| 207 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 208 |
DOC_TOL_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Heade Document Tolerance Status
E=Error
N=Not Checked
R=Reset
V=Valid
Default Value: V
|
| 209 |
USER_HDR_CHAR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Character 1
|
| 210 |
CUSTOM_C100_A1 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 1
|
| 211 |
CUSTOM_C100_A2 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 2
|
| 212 |
CUSTOM_C100_A3 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 3
|
| 213 |
CUSTOM_C100_A4 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 4
|
| 214 |
CUSTOM_DATE_A |
Date(10) |
DATE |
Custom Date
|
| 215 |
CUSTOM_C1_A |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Character 2
|
| 216 |
VNDR_AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor Affiliate
|
| 217 |
RTM_LOCK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
RTMLockflag
Default Value: N
|
| 218 |
VCHR_LINE_APPR |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Line Approval Status
0=Line Routing Not Required
1=Completed
2=Routed for Approval
Default Value: 0
|
| 219 |
EXD_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Tax Amount
|
| 220 |
EXD_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Duty in Base Currency
|
| 221 |
STX_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 222 |
STX_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SALES TAX IN BASE CURR
|
| 223 |
CSD_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Custom Duty Tax Amount
|
| 224 |
CSD_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Custom Duty Amount Base
|
| 225 |
COMBO_ERROR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Vouchers with Combo Errors
Y/N Table Edit
Default Value: N
|
| 226 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 227 |
VAT_TREATMENT_GRP |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment Group
|
| 228 |
COUNTRY_LOC_BUYER |
Character(3) |
VARCHAR2(3) NOT NULL |
Buyer's Location Country - May be either the VAT Entity or the Trading Partner
|
| 229 |
STATE_LOC_BUYER |
Character(6) |
VARCHAR2(6) NOT NULL |
Buyer's Location State - May be either the VAT Entity or the Trading Partner
|
| 230 |
COUNTRY_LOC_SELLER |
Character(3) |
VARCHAR2(3) NOT NULL |
Seller's Location Country - May be either the VAT Entity or the Trading Partner
|
| 231 |
STATE_LOC_SELLER |
Character(6) |
VARCHAR2(6) NOT NULL |
Seller's Location State - May be either the VAT Entity or the Trading Partner
|
| 232 |
VAT_SVC_SUPPLY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Services Place of Supply Flag
1=Supplier's Countries
2=Buyer's Countries
3=Where Physically Performed
|
| 233 |
VAT_SERVICE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Service Type
1=Freight Transport
2=Other
3=Electronics/Communication
|
| 234 |
COUNTRY_VAT_PERFRM |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Where Service Physically Performed
|
| 235 |
STATE_VAT_PERFRM |
Character(6) |
VARCHAR2(6) NOT NULL |
State Where Service Physically Performed
|
| 236 |
COUNTRY_VAT_SUPPLY |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Place of Supply Country
|
| 237 |
STATE_VAT_SUPPLY |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Place of Supply State
|
| 238 |
STATE_SHIP_FROM |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship From State
|
| 239 |
STATE_SHIP_TO |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship To State
|
| 240 |
STATE_VAT_DEFAULT |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Defaulting State
|
| 241 |
VAT_RPT_CNTRY_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Reporting Country Source
1=Ship From
2=Ship To
3=VAT Entity
4=Service Performed Country
5=Supplier Location Country
6=Buyer Location Country
7=Buyer VAT Registration Country
|
| 242 |
VAT_DFLT_DONE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Defaulting Done
N=Awaiting Defaulting
X=Do not default
Y=Defaulting Done
Y/N Table Edit
Default Value: N
|
| 243 |
FED_PROJDT_EDT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
ProjectEditFlag
Y/N Table Edit
Default Value: N
|
| 244 |
PERFORM_START_DT |
Date(10) |
DATE |
Performance Start Date
|
| 245 |
PERFORM_END_DT |
Date(10) |
DATE |
Performance End Date
|
| 246 |
PO_ROLLED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Rolled Flag
Y/N Table Edit
Default Value: N
|
| 247 |
LS_KEY |
Number(15,0) |
DECIMAL(15) NOT NULL |
Lease Key, Unique Key
|
| 248 |
MATCH_DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
| 249 |
AP_MATCH_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Type
C=Matched with Credit Note
D=Matched with Debit Memo
O=Matched with Override
P=Auto - Matched
|
| 250 |
DBMEMO_DISP_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Debit Memo Dispatch Method
EDX=EDI/XML
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print
|
| 251 |
DBMEMO_DISP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Debit Memo Status
D=Dispatched
N=Not Dispatched
Default Value: N
|
| 252 |
DBMEMO_DEST |
Character(70) |
VARCHAR2(70) NOT NULL |
Debit Memo Destination. Stores Email ID, or FAX number or Phone Number information based on the debit memo dispatch method.
|
| 253 |
MATCHED_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
| 254 |
MATCH_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Match Rule
Prompt Table:
MTCH_CNTRL
|
| 255 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
|
| 256 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 257 |
LEASE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Lease ID
|
| 258 |
LEASE_PYMNT_DT |
Date(10) |
DATE |
Lease Payment Date
|
| 259 |
CLAIM_NO |
Character(30) |
VARCHAR2(30) NOT NULL |
Claim Number for an item
|
| 260 |
POLICY_NUM |
Character(30) |
VARCHAR2(30) NOT NULL |
Policy Information
|
| 261 |
ENDORSER_PARTY |
Character(40) |
VARCHAR2(40) NOT NULL |
Endorser Party
|
| 262 |
VCHR_DRAFT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Draft Flag
N=Complete Voucher
Y=Incomplete Voucher
Default Value: N
|
| 263 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
|
| 264 |
BI_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Billing Invoice number
|