SUP_FLD_PYMT_VW (SQL View)	Index Back
Strat Sourcing Payment view 10/10/2016: CK Supplier/Bidder Payment view.

SUP_FLD_PYMT_VW

(SQL View)

Strat Sourcing Payment view

10/10/2016: CK Supplier/Bidder Payment view.

SELECT A.SUP_OB_REG_ID ,%subrec(AUC_BIDDER_PYMT ,B) ,B.ADDRESS1 %Concat ' '%Concat B.ADDRESS2 %Concat ' '%Concat B.ADDRESS3 FROM PS_AUC_BIDDER_HDR A ,PS_AUC_BIDDER_PYMT B WHERE B.SETID =A.SETID AND B.BIDDER_ID =A.BIDDER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SUP_OB_REG_ID Character(10) VARCHAR2(10) NOT NULL * Registration ID

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

3 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID

4 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

5 SUP_OB_INVOICE_ADR Character(1) VARCHAR2(1) NOT NULL Invoice Address
1=Primary Address
2=Remit To Address
3=Ship To Customer
4=Invoice Address

6 SUP_OB_REMIT_ADDR Character(1) VARCHAR2(1) NOT NULL Remit Address
1=Primary Address
2=Remit To Address
3=Ship To Customer
4=Invoice Address

7 EMAIL_ADVICE Character(1) VARCHAR2(1) NOT NULL Email Payment Advice
N=No
Y=Yes
Y/N Table Edit
Default Value: N

8 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

9 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
B=Global and 1099
G=Global
T=1099
Y/N Table Edit
Default Value: N

10 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

11 DESCR Character(30) VARCHAR2(30) NOT NULL Description

12 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

13 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

14 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

15 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

16 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

17 CITY Character(30) VARCHAR2(30) NOT NULL City

18 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

19 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2

20 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer

21 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

22 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

23 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

24 COUNTY Character(30) VARCHAR2(30) NOT NULL County

25 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: %EDIT_STATE

26 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

27 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

28 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit

29 BANK_ID_QUAL Character(3) VARCHAR2(3) NOT NULL "A bank/counterparty attribute that determines
Prompt Table: BNK_ID_QUAL_VW

30 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

31 BRANCH_ID Character(10) VARCHAR2(10) NOT NULL The local branch office identifier associated with a given bank/counterparty.

32 BANK_ACCT_TYPE Character(2) VARCHAR2(2) NOT NULL An account attribute that describes the ostensible purposes of a given bank/counterparty account.
01=Time Deposit
03=Checking Account
05=Stock
06=Bond
07=Life Insurance Value
08=Retirement Account
10=Business Account
11=Trust Fund Account
12=Stock & Bond Account
13=Life Insurance Acct
CA=Current Account
CH=Charges Account
DA=Demand Deposit
LN=Loan
RD=Return Items on DDA
RS=Return Items-Savings
SA=Settlement Account
SV=Savings Account
Z=Mutually Defined

33 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

34 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit

35 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

36 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

37 BENEFICIARY_BANK Character(30) VARCHAR2(30) NOT NULL The bank/counterparty associated with a given beneficiary.

38 BENEFICIARY_BNK_AC Character(30) VARCHAR2(30) NOT NULL Alternate Character Set field for BENEFICIARY_BANK

39 BENEF_BRANCH Character(30) VARCHAR2(30) NOT NULL Beneficiary Branch field

40 BENEF_BRANCH_AC Character(30) VARCHAR2(30) NOT NULL Branch Alternate Char

41 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Int'l Prefix

42 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

43 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone Extension

44 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number

45 IBAN_CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL IBAN Check Digit

46 IBAN_ID Character(34) VARCHAR2(34) NOT NULL IBAN - Internation Bank Account Number is used in European countries to uniquely identify Bank accounts across borders

47 COMMENTS_2000 Long Character CLOB Comment Text

48 ADDRESS_150 Character(150) VARCHAR2(150) NOT NULL Address

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SUP_OB_REG_ID	Character(10)	VARCHAR2(10) NOT NULL	* Registration ID
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
3	BIDDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Bidder ID
4	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
5	SUP_OB_INVOICE_ADR	Character(1)	VARCHAR2(1) NOT NULL	Invoice Address 1=Primary Address 2=Remit To Address 3=Ship To Customer 4=Invoice Address
6	SUP_OB_REMIT_ADDR	Character(1)	VARCHAR2(1) NOT NULL	Remit Address 1=Primary Address 2=Remit To Address 3=Ship To Customer 4=Invoice Address
7	EMAIL_ADVICE	Character(1)	VARCHAR2(1) NOT NULL	Email Payment Advice N=No Y=Yes Y/N Table Edit Default Value: N
8	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
9	WTHD_SW	Character(1)	VARCHAR2(1) NOT NULL	Withholding Applicable Flag B=Global and 1099 G=Global T=1099 Y/N Table Edit Default Value: N
10	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
11	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
12	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
13	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
14	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
15	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
16	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
17	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
18	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
19	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
20	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat WW=Trailer
21	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
22	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
23	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
24	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
25	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
26	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
27	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
28	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
29	BANK_ID_QUAL	Character(3)	VARCHAR2(3) NOT NULL	"A bank/counterparty attribute that determines Prompt Table: BNK_ID_QUAL_VW
30	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
31	BRANCH_ID	Character(10)	VARCHAR2(10) NOT NULL	The local branch office identifier associated with a given bank/counterparty.
32	BANK_ACCT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	An account attribute that describes the ostensible purposes of a given bank/counterparty account. 01=Time Deposit 03=Checking Account 05=Stock 06=Bond 07=Life Insurance Value 08=Retirement Account 10=Business Account 11=Trust Fund Account 12=Stock & Bond Account 13=Life Insurance Acct CA=Current Account CH=Charges Account DA=Demand Deposit LN=Loan RD=Return Items on DDA RS=Return Items-Savings SA=Settlement Account SV=Savings Account Z=Mutually Defined
33	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
34	CHECK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	Check Digit
35	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
36	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
37	BENEFICIARY_BANK	Character(30)	VARCHAR2(30) NOT NULL	The bank/counterparty associated with a given beneficiary.
38	BENEFICIARY_BNK_AC	Character(30)	VARCHAR2(30) NOT NULL	Alternate Character Set field for BENEFICIARY_BANK
39	BENEF_BRANCH	Character(30)	VARCHAR2(30) NOT NULL	Beneficiary Branch field
40	BENEF_BRANCH_AC	Character(30)	VARCHAR2(30) NOT NULL	Branch Alternate Char
41	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Int'l Prefix
42	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
43	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone Extension
44	FAX	Character(24)	VARCHAR2(24) NOT NULL	Fax Number
45	IBAN_CHECK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	IBAN Check Digit
46	IBAN_ID	Character(34)	VARCHAR2(34) NOT NULL	IBAN - Internation Bank Account Number is used in European countries to uniquely identify Bank accounts across borders
47	COMMENTS_2000	Long Character	CLOB	Comment Text
48	ADDRESS_150	Character(150)	VARCHAR2(150) NOT NULL	Address