| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 3 |
UA_VI_FOUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Upgrade VI_FOUND
|
| 4 |
UA_VI_DONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Upgrade VI_DONE
|
| 5 |
UA_VP_FOUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Upgrade VP_FOUND
|
| 6 |
UA_VP_DONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Upgrade VP_DONE
|
| 7 |
UA_ALL_DONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Upgrade ALL_DONE
|
| 8 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 9 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 10 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
| 11 |
REMIT_ADDR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Remitting Location
|
| 12 |
ADDR_SEQ_NUM_ORDR |
Number(5,0) |
INTEGER NOT NULL |
Ordering Location
|
| 13 |
PRIM_ADDR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Invoicing Location
|
| 14 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 15 |
UA_VP1_EFFDT |
Date(10) |
DATE |
Upgrades VP1 EFFDT
|
| 16 |
UA_VL_EFFDT |
Date(10) |
DATE |
Upgrades VL DATE
|
| 17 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
|
| 18 |
UA_VP1_EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status as of Effective Date
A=Active
I=Inactive
|
| 19 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 20 |
UA_VP1_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 21 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 22 |
UA_VP1_CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Exchange Rate Type
|
| 23 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
|
| 24 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
|
| 25 |
DISP_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Dispatch Method
EDX=Electronic Document Exchange
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print
|
| 26 |
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.
|
| 27 |
MATCH_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Match Rule
|
| 28 |
MATCH_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Requires Matching
|
| 29 |
ERS_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
ERS Action
N=No
Y=Yes
|
| 30 |
ERS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Eval Rcpt Settlement
|
| 31 |
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
|
| 32 |
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
|
| 33 |
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.
|
| 34 |
VAT_TOL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates at what level PeopleSoft General Ledger should handle the difference between VAT amount and the calculated VAT amount. The tolerance check, either as an amount or a percentage, can be specified at the Journal Source, Account, or Business Unit level.
D=Default from Higher Level
S=Specify at this Level
|
| 35 |
VAT_TOL_PCT |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Specifies the allowable percentage difference between an entered VAT amount and the calculated VAT amount. If the VAT amount is outside the specified tolerance, the journal line will not post.
|
| 36 |
VAT_TOL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the allowable amount difference between the entered VAT amount and the calculated VAT amount. If the VAT amount is outside the specified tolerance, the journal line will not post.
|
| 37 |
VAT_TOL_CUR_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the currency code for a specified VAT tolerance amount (VAT_TOL_AMT).
|
| 38 |
VAT_TOL_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the type of currency exchange rate used to convert the VAT Tolerance amount from its entry currency to the base currency of the business unit.
|
| 39 |
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
|
| 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 |
BUYER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Buyer
|
| 43 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 44 |
PYMNT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer
|
| 45 |
PYMNT_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Payment
N=No
Y=Yes
|
| 46 |
PYMNT_GROUP_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Group Code
|
| 47 |
PYMNT_SEPARATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Separate Payment
|
| 48 |
PYMNT_HANDLING_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
|
| 49 |
DSCNT_ALWAYS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Always take discount
|
| 50 |
DELAY_DAYS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Delay Days Flag
D=Default from BU
N=Do Not Employ
S=Specify
|
| 51 |
DSCNT_DELAY_DAYS |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Discount Delay Days
|
| 52 |
PYMNT_DELAY_DAYS |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Payment Delay Days
|
| 53 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 54 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
|
| 55 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 56 |
VNDR_PAYMENT_MSG |
Character(30) |
VARCHAR2(30) NOT NULL |
Supplier Remit Message
|
| 57 |
DFI_ID_NUM |
Character(12) |
VARCHAR2(12) NOT NULL |
A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
|
| 58 |
DFI_ID_QUAL |
Character(2) |
VARCHAR2(2) NOT NULL |
A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
01=Transit Number
02=Swift ID/BIC
03=CHIPS Participant ID
04=Canadian Bank Branch/Institute
05=CHIPS Universal ID
ZZ=Mutually Defined
|
| 59 |
EFT_PYMNT_FMT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Format
00=Standard SWIFT transfer
10=Urgent SWIFT
15=Euro-Transfer
21=Check, w/ receipt confirmation
22=Check, Urgent
23=Check, urgent w/ receipt
40=Postal Order
CTX=Corp Trade Exchange
PBC=Check, standard
PPD=Prearranged Pay & Deposit
WRT=Wire Transfer
|
| 60 |
EFT_RTNG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Complex Routing
D=Use DFI ID
N=None
R=Use Complex Routing
|
| 61 |
EFT_RTNG_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Routing Status
C=Complete
I=Incomplete
|
| 62 |
EFT_TRANS_HANDLING |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Handling
D=Payment Only
P=Prenotification
X=Payment and Advice
|
| 63 |
PRENOTE_DATE |
Date(10) |
DATE |
Prenotification Date
|
| 64 |
PRENOTE_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Prenotification Required
|
| 65 |
PRENOTE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Prenotification Status
C=Confirmed
N=New
P=Pending
R=Rejected
S=Submitted
|
| 66 |
EFT_DOM_COSTS_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Domestic Costs
1=Payer's Domestic Account
2=Payer's Foreign Account
3=Payee's Account
4=Trans Exp to Pyr, other to Pye
|
| 67 |
EFT_CORR_COSTS_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Correspondent's Costs
1=Payer's Domestic Account
2=Payer's Foreign Account
3=Payee's Account
|
| 68 |
EFT_CROSSED_CHECK |
Character(1) |
VARCHAR2(1) NOT NULL |
Crossed Check
|
| 69 |
EFT_CHECK_FWRD_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Forwarding
1=Payer's Bank
2=Payer
3=Payee
4=Payee's Bank
|
| 70 |
EFT_CHECK_DRAW_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Bank Check Drawn On
1=Payer's Bank
2=Payee's Bank
|
| 71 |
EFT_PAY_INST_CD1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Instruction 1
ACC=/ACC/
BEN=/BENONLY/
CHK=/CHECK/
COR=/CORPTRAD/
HLD=/HOLD/
INT=/INT/
IRR=PAYMENT IRREVOCABLE
PHB=/PHONEBEN/
PHI=/PHONIBK/
PHN=/PHON/
RC1=ADV BEN W/CHARGES
RC2=ADV BEN W/O CHARGES
RCB=/RCB/
REC=/REC/
REJ=/REJT/
RET=BEN UNKNOWN RETURN
TEB=/TELEBEN/
TEI=/TELEIBK/
TEL=/TELE/
XFR=INTERCOMPANY TRANSFER
|
| 72 |
EFT_PAY_INST_CD2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Instruction 2
|
| 73 |
EFT_PAY_INST_CD3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Instruction 3
|
| 74 |
EFT_PAY_INST_CD4 |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Instruction 4
|
| 75 |
EFT_PAY_INST_REF1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Payment Instruction Ref 1
|
| 76 |
EFT_PAY_INST_REF2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Payment Instruction Ref 2
|
| 77 |
FACTORING_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Factoring
|
| 78 |
BRANCH_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
The local branch office identifier associated with a given bank/counterparty.
|
| 79 |
RTNG_DESCR |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 80 |
CHECK_DIGIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Check Digit
|
| 81 |
UA_EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Upgrade Exist Flag
|
| 82 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 83 |
DB_NUMBER |
Character(9) |
VARCHAR2(9) NOT NULL |
DUNS Number
|
| 84 |
UA_DB_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 85 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 86 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 87 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 88 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 89 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 90 |
UA_VEN2_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 91 |
UA_VEN2_VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Supplier ID
|
| 92 |
UA_VEN2_DB_NUMBER |
Number(9,0) |
DECIMAL(9) NOT NULL |
D+B Number
|
| 93 |
UA_VEN2_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Invoicing Location
|
| 94 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 95 |
UA_I_ADDRESS1 |
Character(35) |
VARCHAR2(35) NOT NULL |
Address Line 1
|
| 96 |
UA_I_CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 97 |
UA_I_COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 98 |
UA_I_POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal Code
|
| 99 |
UA_I_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 100 |
UA_SIC_EFFDT |
Date(10) |
DATE |
Effective Date
|
| 101 |
UA_SIC_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 102 |
UA_SIC_VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Supplier ID
|
| 103 |
SIC_IND_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Industry Type Code
|
| 104 |
SIC_IND_CD_SEQ |
Number(4,0) |
SMALLINT NOT NULL |
SIC Type Sequence
|
| 105 |
SIC_IND_GRP |
Character(1) |
VARCHAR2(1) NOT NULL |
SubGroup
|
| 106 |
SIC_GRP |
Character(2) |
VARCHAR2(2) NOT NULL |
Industry Group
|
| 107 |
SIC_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Industry Code
|
| 108 |
UA_VN3_NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 109 |
UA_VN3_REMIT_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Remitting Location
|
| 110 |
UA_VN3_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 111 |
UA_VN3_VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Supplier ID
|
| 112 |
UA_VP2_BNK_ACT_NUM |
Character(17) |
VARCHAR2(17) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 113 |
UA_VP2_BRANCH_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
The local branch office identifier associated with a given bank/counterparty.
|
| 114 |
UA_VP2_CHECK_DIGIT |
Character(2) |
VARCHAR2(2) NOT NULL |
Check Digit
|
| 115 |
UA_VP2_EFFDT |
Date(10) |
DATE |
Effective Date
|
| 116 |
UA_ST2_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 117 |
UA_ST3_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 118 |
UA_CONTINUE |
Character(1) |
VARCHAR2(1) NOT NULL |
Upgrade Continue Flag
|
| 119 |
UA_BANK_CD_COUNT |
Number(4,0) |
SMALLINT NOT NULL |
Upgrade Bank code counter
|
| 120 |
UA_BANK_ID_FOUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Upgrade Bank ID flag
|
| 121 |
UA_BK_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
A unique key identifier that represents a bank or counterparty.
|
| 122 |
UA_BK_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 123 |
BANK_ID_QUAL |
Character(3) |
VARCHAR2(3) NOT NULL |
"A bank/counterparty attribute that determines
|
| 124 |
REP_RTNG_NUM |
Character(10) |
VARCHAR2(10) NOT NULL |
Routing Code
|
| 125 |
UA_LOCATION_COUNT |
Number(4,0) |
SMALLINT NOT NULL |
Upgrade Location Count
|
| 126 |
UA_NEW_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
A unique key identifier that represents a bank or counterparty.
|
| 127 |
UA_NEW_BANK_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 128 |
UA_NEW_BANK_SHORT |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 129 |
UA_NEW_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 130 |
UA_NEW_LOC_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 131 |
UA_VA2_ADDRESS1 |
Character(35) |
VARCHAR2(35) NOT NULL |
Address Line 1
|
| 132 |
UA_VA2_CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 133 |
UA_VA2_COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 134 |
UA_VA2_POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal Code
|
| 135 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 136 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 137 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 138 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 139 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 140 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 141 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
|
| 142 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Int'l Prefix
|
| 143 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 144 |
EXTENSION |
Character(6) |
VARCHAR2(6) NOT NULL |
Phone Extension
|
| 145 |
FAX |
Character(24) |
VARCHAR2(24) NOT NULL |
Fax Number
|
| 146 |
COMMENTS_2000 |
Long Character |
CLOB |
Comment Text
|
| 147 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
|
| 148 |
BANK_ACCT_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Bank Account Sequence Number
|
| 149 |
UA_NEW_BANK_ACCT |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
|
| 150 |
UA_ACCT_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 151 |
INTRMED_PYMNT_MSG |
Character(30) |
VARCHAR2(30) NOT NULL |
An internal work field that contains messaging associated with settlements subject to
|
| 152 |
UA_VA2_FOUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Upgrade Select Found Flag
|
| 153 |
UA_VU2_FOUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Upgrade VU2 found flag
|
| 154 |
VU_SEQ_NO |
Number(8,0) |
INTEGER NOT NULL |
Supplier Upgrade Seq Number
|
| 155 |
UA_D_EFFDT |
Date(10) |
DATE |
Effective Date
|
| 156 |
UA_D_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 157 |
UA_D_VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Supplier ID
|
| 158 |
UA_D_VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Supplier Location
|
| 159 |
UA_X_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 160 |
UA_X_VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 161 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 162 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 163 |
UA_VLOC_EFFDT |
Date(10) |
DATE |
Effective Date
|
| 164 |
UA_VLOC_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 165 |
UA_VLOC_VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Supplier ID
|
| 166 |
M1099_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
1099 Code
|
| 167 |
STD_ID_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
ID Number
|