Sbi Account Transfer Application Format by izz68954

VIEWS: 0 PAGES: 14

More Info
									                                 PEOPLESOFT REPORTING

                                      VENDOR TABLES

VENDOR                                                        Vendor Header table
  > VENDOR_ID_NBRS                                            Extra Vendor Identifiers
  > VNDR_VAT_RGSTRN                                           Vendor VAT Information
  > VNDR_LOC_SCROL                                            Vendor Location Sequence
      > VENDOR_LOC                                            Vendor Location
          > VENDOR_TYPE                                       Vendor Type
          > VNDR_BANK_ACCT                                    Vender Bank Account
          > VNDR_LOC_ID_NBR                                   Vendor Location ID Number
          > VNDR_URL                                          Vendor URLs
          > VENDOR_PAY                                        Vendor Payment Defaults
          > VNDR_IND_CLASS                                    Vendor Industry Class Codes
  > VENDOR_CONVER                                             Conversation with Vendors
  > VENDOR_INVOICE                                            Procurement Defaults
  > VNDR_ADDR_SCROL                                           Vendor Address Sequence
      > VENDOR_ADDR                                           Vendor Address
  > VNDR_CNTCT_SCR                                            Vendor Contact
      > VENDOR_CNTCT                                          Vendor Contact Detail
          > VNDR_CNTCT_PHN                                    Vendor Contact Telephone Nbr
  > VENDOR_WTHD                                               Vendor Withholding information
      > VENDOR_WTHD_JUR                                       Vendor Withholding Jurisdiction
VENDOR_CONTROL                                                Controls for a set of Vendors
VNDR_PYINQ_VW1 *                                              Vchr/Vchr line payment info
      *links VOUCHER, PYMNT_VCHR_XREF & VENDOR for vouchers not deleted




1 of 14                                   AP_VENDOR     1c383522-7924-4e3c-b322-bb43e02bcb31.xls
                                      PEOPLESOFT REPORTING

                                         VENDOR TABLES

VENDOR                                                          Vendor Header table
Y     SETID - SetID
Y     VENDOR_ID - Vendor ID
      VENDOR_NAME_SHORT - Short Vendor Name
      VNDR_NAME_SHRT_USR - Short Vendor Name
      VNDR_NAME_SEQ_NUM - Sequence Number
      NAME1 - Name 1
      NAME2 - Name 2
      VENDOR_STATUS - Vendor Status
      VENDOR_CLASS - Classification
      VENDOR_PERSISTENCE - Persistence
      REMIT_ADDR_SEQ_NUM - Remitting Location
      PRIM_ADDR_SEQ_NUM - Invoicing Location
      ADDR_SEQ_NUM_ORDR - Ordering Location
      REMIT_SETID - Remit SetID
      REMIT_VENDOR - Remit Vendor
      CORPORATE_SETID - SetID
      CORPORATE_VENDOR - Corporate Vendor
      CUST_SETID - Customer SetID
      CUST_ID - Customer ID
      ENTERED_BY - Entered by
      AR_NUM - Our Customer Number
      OLD_VENDOR_ID - Old Vendor ID
      WTHD_SW - Withholding Applicable
      VAT_SW - Display VAT Flag
      VNDR_STATUS_PO - Open For Ordering
      REMIT_LOC - Remit to Location
      DEFAULT_LOC - Default Location
      NAME1_AC - Name 1 Alternate Char Set
      NAME2_AC - Name 2 Alternate Char Set
      PRIMARY_VENDOR - Invoice Vendor
      LAST_ACTIVITY_DT - Last Activity Date
      WITHHOLD_LOC - Withholding Location



2 of 14                                       AP_VENDOR   1c383522-7924-4e3c-b322-bb43e02bcb31.xls
                                     PEOPLESOFT REPORTING

                                          VENDOR TABLES

      IN_PROCESS_FLG - In Process
      PROCESS_INSTANCE - Process Instance
      HUB_ZONE - HUB Zone
      EEO_CERTIF_DT - EEO Certification Date
      HRMS_CLASS - Human Resources Classification
      INTERUNIT_VNDR_FLG - InterUnit Vendor
      VNDR_AFFILIATE - Vendor Affiliate
      BUSINESS_UNIT - Business Unit
      VNDR_TIN - Vendor Tax Id Number


VENDOR_ID_NBRS                                                     Extra Vendor Identifiers
Y     SETID - SetID
Y     VENDOR_ID - Vendor ID
Y     STD_ID_NUM_QUAL - Standard ID Qualifier
      STD_ID_NUM - ID Number
      STD_ID_SETID - SetID


VENDOR_LOC                                                         Vendor Location
Y     SETID - SetID
Y     VENDOR_ID - Vendor ID
Y     VNDR_LOC - Vendor Location
Y     EFFDT - Effective Date
      EFF_STATUS - Status as of Effective Date
      CURRENCY_CD - Currency Code
      CUR_RT_TYPE - Exchange Rate Type
      FREIGHT_TERMS - Freight Terms Code
      SHIP_TYPE_ID - Ship Via Code
      DISP_METHOD - Dispatch Method
      PYMNT_TERMS_CD - Payment Terms ID
      MATCH_OPT_FLG - Matching Option Flag
      MATCH_CNTRL_ID - Match Rule
      MATCH_OPT - Requires Matching
      ERS_ACTION - ERS Action



3 of 14                                          AP_VENDOR   1c383522-7924-4e3c-b322-bb43e02bcb31.xls
                                      PEOPLESOFT REPORTING

                                         VENDOR TABLES

      ERS_FLAG - Allow Eval Rcpt Settlement
      VCHR_APPRVL_FLG - Voucher Approval Flag
      BUSPROCNAME - Business Process Name
      APPR_RULE_SET - Approval Rule Set
      VAT_DCLRTN_POINT - Declaration Point
      VAT_CALC_TYPE - Calculation Type
      VAT_TXN_TYPE_CD - VAT Transaction Type
      VAT_TOL_FLG - VAT Tolerance Check Indicator
      VAT_TOL_PCT - VAT Tolerance Percentage
      VAT_TOL_AMT - VAT Tolerance Amount
      VAT_TOL_CUR_CD - Currency
      VAT_TOL_RT_TYPE - Rate Type
      VAT_USE_ID - VAT Use Type
      BUYER_ID - Buyer
      REMIT_SETID - Remit SetID
      REMIT_VENDOR - Remit Vendor
      REMIT_LOC - Remit to Location
      REMIT_ADDR_SEQ_NUM - Remitting Location
      ADDR_SEQ_NUM_ORDR - Ordering Location
      PRICE_SETID - Price From Vendor SetID
      PRICE_VENDOR - Price Vendor ID
      PRICE_LOC - Price from Location
      RETURN_VENDOR - Return to Vendor
      RET_ADDR_SEQ_NUM - Return to Address
      DST_CNTRL_ID - Accounting Template
      PREFERRED_LANGUAGE - Preferred Language
      RFQ_DISP_MTHD - RFQ Dispatch Method
      CNTRCT_DISP_MTHD - Contract Dispatch Method
      PRIMARY_VENDOR - Invoice Vendor
      PRIM_ADDR_SEQ_NUM - Invoicing Location
      SHIPTO_ID - Ship To Location
      SUT_BASE_ID - Sales/Use Tax Destination
      SALETX_TOL_AMT - Sales Tax Tolerance Amount



4 of 14                                       AP_VENDOR   1c383522-7924-4e3c-b322-bb43e02bcb31.xls
                                     PEOPLESOFT REPORTING

                                           VENDOR TABLES

      SALETX_TOL_CUR_CD - Sales Tax Tolerance Curr Code
      SALETX_TOL_PCT - Sales Tax Tolerance Percent
      SALETX_TOL_RT_TYPE - Sales Tax Tolerance Rate Type
      SALETX_CD_ERS - ERS Sales Tax Cd
      SALES_USE_TX_FLG - Sales/Use Tax Code
      AUTO_ASN_FLG - Advanced Shipment Notification
      SALETX_TOL_FLG - Sales Tax Tolerance Flag
      SHIP_LOC_FLG - Ship To/End Location Flag
      WTHD_CD - Withholding Code
      WTHD_SW - Withholding Applicable
      DOC_TYPE - Document Type
      DOC_TYPE_FLG - Document Type Flag
      RTV_DISPATCH_METH - RTV Dispatch Method
      RTV_NOTIFY_METH - RTV Notification Method
      RTV_DEBIT_OPT - RTV Debit Option
      VNDR_SBI_FLG - Allow SBI
      SBI_APPROVAL_FLG - SBI Approval Option
      ACCOUNT - Account
      ALTACCT - Alternate Account
      DEPTID - Department
      OPERATING_UNIT - Operating Unit
      PRODUCT - Product
      FUND_CODE - Fund Code
      CLASS_FLD - Class Field
      PROGRAM_CODE - Program Code
      BUDGET_REF - Budget Reference
      AFFILIATE - Affiliate
      AFFILIATE_INTRA1 - Fund Affiliate
      AFFILIATE_INTRA2 - Operating Unit Affiliate
      CHARTFIELD1 - Chartfield 1
      CHARTFIELD2 - Chartfield 2
      CHARTFIELD3 - Chartfield 3
      PROJECT_ID - Project



5 of 14                                        AP_VENDOR   1c383522-7924-4e3c-b322-bb43e02bcb31.xls
                                   PEOPLESOFT REPORTING

                                         VENDOR TABLES

      CONSIGNED_FLAG - Consigned Flag
      VCHR_CONSIGN_OPT - Consigned Voucher Option
      BANK_ACCT_SEQ_NBR - Bank Account Seq Nbr
      ACCT_TEMPL_FLG - Accounting Template
      PAY_TRM_BSE_DT_DFT - Payment Terms Basis Date Type
      RECV_ONLY_MTCH_FLG - Receipt Only Match
      VCHR_MTCH_ADJ_DFLT - Match Adjustments
      ERS_INV_DT_OPT - ERS Invoice Date Option
      ERS_INV_DT_DFLT - ERS Invoice Date
      ERS_TAX_TYPE_DFLT - ERS Tax Type
      ERS_TAX_CD_OPT - ERS Sale Tax Code Override
      LAST_SBI_NUM - Last SBI Number Used
      SBI_DOC_DFLT - SBI Numbering Option
      SBI_PRINT_OPT - SBI Print Option
      VCHR_TAX_ADJ_DFT - Sales and Use Tax Adjustments
      RTV_VCHR_ADJ_DFLT - RTV Adjustment Option
      VAT_SUSPENSION_FLG - Use VAT Suspension
      VAT_ROUND_RULE - VAT Rounding Rule
      REPL_DISP_METHOD - Replenishment Dispatch Method
      VNDR_UPN_FLG - Vendor UPN Ready
      COMMENTS_2000 - Comment Text
      DISP_CO_FLAG - Dispatch Change Orders
      DATE_CALC_BASIS - Date Calculation Basis
      PAY_SCHEDULE_TYPE - Pay Schedule Type


VENDOR_TYPE                                                    Vendor Type
Y     SETID - SetID
Y     VENDOR_ID - Vendor ID
Y     VNDR_LOC - Vendor Location
Y     EFFDT - Effective Date
Y     VENDOR_TYPE - Vendor Type
      DESCRSHORT - Short Description
      VNDR_SERVICE_TYPE - Service Type



6 of 14                                     AP_VENDOR    1c383522-7924-4e3c-b322-bb43e02bcb31.xls
                                    PEOPLESOFT REPORTING

                                          VENDOR TABLES

      PRIMARY_SW - Primary


VENDOR_PAY                                                         Vendor Payment Defaults
Y     SETID - SetID
Y     VENDOR_ID - Vendor ID
Y     VNDR_LOC - Vendor Location
Y     EFFDT - Effective Date
Y     SEQ_NUM - Sequence
      EFF_STATUS - Status as of Effective Date
      CURRENCY_CD - Currency Code
      CUR_RT_TYPE - Exchange Rate Type
      PYMNT_METHOD - Payment Method
      PYMNT_HOLD - Hold Payment
      PYMNT_GROUP_CD - Pay Group Code
      PYMNT_SEPARATE - Separate Payment
      PYMNT_HANDLING_CD - Payment Handling
      DSCNT_ALWAYS_FLG - Always take discount
      DELAY_DAYS_FLG - Delay Days Flag
      DSCNT_DELAY_DAYS - Discount Delay Days
      PYMNT_DELAY_DAYS - Payment Delay Days
      BANK_CD - Bank Code
      BANK_ACCT_KEY - Bank Account
      CURRENCY_PYMNT - Payment Currency
      CUR_RT_TYPE_PYMNT - Payment Currency Rate Type
      EFT_PYMNT_FMT_CD - Payment Format
      EFT_RTNG_FLG - Complex Routing
      EFT_RTNG_STATUS - Routing Status
      EFT_TRANS_HANDLING - Transaction Handling
      PRENOTE_DATE - Prenotification Date
      PRENOTE_REQD - Prenotification Required
      PRENOTE_STATUS - Prenotification Status
      EFT_DOM_COSTS_CD - Domestic Costs
      EFT_CORR_COSTS_CD - Correspondent's Costs



7 of 14                                          AP_VENDOR   1c383522-7924-4e3c-b322-bb43e02bcb31.xls
                                   PEOPLESOFT REPORTING

                                         VENDOR TABLES

      EFT_CROSSED_CHECK - Crossed Check
      EFT_CHECK_FWRD_CD - Check Forwarding
      EFT_CHECK_DRAW_CD - Bank Check Drawn On
      EFT_PAY_INST_CD1 - Payment Instruction 1
      EFT_PAY_INST_CD2 - Payment Instruction 2
      EFT_PAY_INST_CD3 - Payment Instruction 3
      EFT_PAY_INST_CD4 - Payment Instruction 4
      EFT_PAY_INST_REF1 - Payment Instruction Ref 1
      EFT_PAY_INST_REF2 - Payment Instruction Ref 2
      FACTORING_FLG - Factoring
      HOL_PROC_OPT - Holiday Processing Option
      HOL_PROC_DAYS - Days before/after Holiday
      HOL_PROC_OVERFL - Allow due date in next month
      DFT_VNDR_PARAMS - Draft Vendor Parameters
      DFT_OPT_FLG - Draft Optimization
      DFT_MAX_NUM - Max Number of Drafts
      DFT_ROUND_FLG - Draft Rounding
      DFT_AMT_POS - Rounding Position
      DFT_REMAIN_OPT - Remaining Amount Action
      PYMNT_METHOD_ALT - Payment Method
      GRP_PYMNT_DT - Group by Payment Date
      APPLY_NETTING - Apply Netting
      DFT_SIGHT_CD - Draft Sight Code
      BCH_TRNCOST_CD - Transfer Cost Code
      BCH_CALC_SRC - Bank Charge source
      BCH_CURRENCY_CD - Currency CD
      AMOUNT - Amount
      SMT_SPLIT_ID - Payment Split ID
      SMT_SPLIT_FLG - Payment Split
      VNDR_PYMNT_HLD_FLG - Vendor Payment Hold
      PYMNT_HOLD_OPT - Payment Hold Option
      PYMNT_HLD_DT_OPT - Payment Hold Date Option
      PYMNT_HOLD_CD - Payment Hold Code



8 of 14                                     AP_VENDOR   1c383522-7924-4e3c-b322-bb43e02bcb31.xls
                                   PEOPLESOFT REPORTING

                                        VENDOR TABLES

      PYMN_HOLD_FRM_DT - Hold Payment From Date
      PYMN_HOLD_TO_DT - Hold Payment To Date
      PYMNT_HOLD_PCT - Payment Hold Percent
      PYMNT_HOLD_COMMENT - Payment Hold Comment
      PYMNT_HOLD_AMT - Payment Hold Amont
      HOLD_INV_MAX_AMT - Max Invoice Amount Hold
      LATE_CHRG_FLG - Late Charges
      LATE_CHRG_OPT - Late Charge Option
      LATE_CHRG_CD - Late Charge Code
      APPL_CREDIT_DFLT - Auto Credit Application
      GFAP_EFTDEPACCTNUM - Depositor Account Number
      GFAP_EFT_TIN_CODE - TIN Code
      GFAP_EFT_TREASURY - Treasury Payment
      GFAP_EFT_BBK_NAME - Beneficiary Bank Name
      GFAP_EFT_BBK_REM - Beneficiary Bank Remarks
      GFAP_EFT_BBKABANUM - Benficiary Bank's ABA Number
      GFAP_EFT_BNF_CODE - BNF Code
      GFAP_EFT_ENCL_CODE - Enclosure Code
      GFAP_EFT_LTD_PAY - Limited Payability Type
      GFAP_EFT_PROD_CODE - Product Code
      GFAP_EFT_RFB_INFO - RFB Information
      GFAP_EFT_TYPE_CODE - Type Code
      GFAP_EFTTOP_ELGBL - Vendor Offset Processing


VENDOR_CONVER                                                   Conversation with Vendors
Y     SETID - SetID
Y     VENDOR_ID - Vendor ID
Y     CONVER_DT - Conversation Date
Y     CONVER_SEQ_NUM - Conversation Sequence Number
      CNTCT_SEQ_NUM - Contact Sequence Number
      CONVER_TOPIC - Conversation Topic
      OPRID - User ID
      REVIEW_DAYS - Review Days



9 of 14                                     AP_VENDOR     1c383522-7924-4e3c-b322-bb43e02bcb31.xls
                                      PEOPLESOFT REPORTING

                                          VENDOR TABLES

      REVIEW_DATE - Review Date
      REVIEW_NEXT_DATE - Next Review Date
      KEYWORD1 - Keyword
      KEYWORD2 - Keyword
      KEYWORD3 - Keyword
      DESCRLONG - Description


VENDOR_ADDR                                                        Vendor Address
Y     SETID - SetID
Y     VENDOR_ID - Vendor ID
Y     ADDRESS_SEQ_NUM - Address Sequence Number
Y     EFFDT - Effective Date
      EFF_STATUS - Status as of Effective Date
      NAME1 - Name 1
      NAME2 - Name 2
      EMAILID - Email ID
      COUNTRY - Country
      ADDRESS1 - Address Line 1
      ADDRESS2 - Address Line 2
      ADDRESS3 - Address Line 3
      ADDRESS4 - Address Line 4
      CITY - City
      NUM1 - Number 1
      NUM2 - Number 2
      HOUSE_TYPE - House Type
      ADDR_FIELD1 - Address Field 1
      ADDR_FIELD2 - Address Field 2
      ADDR_FIELD3 - Address Field 3
      COUNTY - County
      STATE - State
      POSTAL - Postal Code
      GEO_CODE - Tax Vendor Geographical Code
      IN_CITY_LIMIT - In City Limit



10 of 14                                         AP_VENDOR   1c383522-7924-4e3c-b322-bb43e02bcb31.xls
                                    PEOPLESOFT REPORTING

                                          VENDOR TABLES


VENDOR_CNTCT                                                       Vendor Contact Detail
Y     SETID - SetID
Y     VENDOR_ID - Vendor ID
Y     CNTCT_SEQ_NUM - Contact Sequence Number
Y     EFFDT - Effective Date
      ADDRESS_SEQ_NUM - Address Sequence Number
      EFF_STATUS - Status as of Effective Date
      CONTACT_NAME - Contact Name
      CONTACT_TYPE - Contact Type
      CONTACT_TITLE - Contact Title
      PREFERRED_LANGUAGE - Preferred Language
      URL - URL
      DESCR - Description
      EMAILID - Email ID


VNDR_CNTCT_PHN                                                     Vendor Contact Telephone Nbr
Y     SETID - SetID
Y     VENDOR_ID - Vendor ID
Y     CNTCT_SEQ_NUM - Contact Sequence Number
Y     EFFDT - Effective Date
Y     PHONE_TYPE - Phone Type
      COUNTRY_CODE - Int'l Prefix
      PHONE - Telephone
      EXTENSION - Phone Extension


VENDOR_WTHD                                                        Vendor Withholding information
Y     SETID - SetID
Y     VENDOR_ID - Vendor ID
Y     VNDR_LOC - Vendor Location
Y     EFFDT - Effective Date
Y     WTHD_ENTITY - Withholding Entity
      ADDRESS_SEQ_NUM - Address Sequence Number



11 of 14                                         AP_VENDOR   1c383522-7924-4e3c-b322-bb43e02bcb31.xls
                                     PEOPLESOFT REPORTING

                                             VENDOR TABLES

      SEX - Gender
      BIRTHDATE - Date of Birth
      BIRTHPLACE - Birth Location
      NUM_CHILDREN - Number of children
      COMPANY_FLG - Company
      TAX_DIST_REF - Tax District Reference
      CERTIFICATE_TYPE - Certificate type
      CERTIFICATE_NUM - Certificate Number
      CERTIFICATE_EXP_DT - Certificate Expiration
      DIRECT_SALES - Direct Sales of $5000 or More
      SECOND_TIN - IRS Notified Twice of Invalid
      STATE_TAX_WH - State Income Tax Withheld
      TIN_TYPE - TIN Type
      TIN - Taxpayer Identification Number
      WTHD_CONTROL_NAME - Withholding Control Name
      PROFESSION - Profession


VENDOR_WTHD_JUR                                                  Vendor Withholding Jurisdiction
Y     SETID - SetID
Y     VENDOR_ID - Vendor ID
Y     VNDR_LOC - Vendor Location
Y     EFFDT - Effective Date
Y     WTHD_ENTITY - Withholding Entity
Y     WTHD_TYPE - Withholding Type
Y     WTHD_JUR_CD - Withholding Jurisdiction
      WTHD_IND - Withhold Rule Indicator
      WTHD_RULE - Withholding Rule
      HOLD_PAY_IND - Hold Pay Indicator
      HOLD_PAY_FLG - Hold Payment
      WTHD_FLG - Withhold if missing
      DEFAULT_JUR_FLG - Default Jurisdiction
Y     DEFAULT_CLASS - Default Withholding Class
      VENDOR_CATEGORY - Vendor Category



12 of 14                                       AP_VENDOR   1c383522-7924-4e3c-b322-bb43e02bcb31.xls
                                      PEOPLESOFT REPORTING

                                         VENDOR TABLES

      WTHD_CONDITION - Withholding Condition
      CONDITION_PCT - Condition %
      CONDITION_UNTIL - Condition Valid Until
      REMIT_WTHD_TO_FLG - Remit Withhold to Flag
      REMIT_VENDOR - Remit Vendor
      REMIT_LOC - Remit to Location
      REMIT_ADDR_SEQ_NUM - Remitting Location


VNDR_PYINQ_VW1                                                    Vchr/Vchr line payment info
Y     SETID - SetID
Y     VENDOR_ID - Vendor ID
Y     BUSINESS_UNIT - Business Unit
Y     VOUCHER_ID - Voucher ID
Y     PYMNT_CNT - Payments
      VENDOR_NAME_SHORT - Short Vendor Name
      NAME1 - Name 1
      AR_NUM - Our Customer Number
      PYMNT_GROSS_AMT - Gross Payment Amount
      DSCNT_PAY_AMT - Payment Discount Amount
      DUE_DT - Due Date
      DSCNT_DUE_DT - Discount Due Date
      SCHEDULED_PAY_DT - Scheduled to Pay
      PYMNT_METHOD - Payment Method
      PYMNT_SELCT_STATUS - Payment Selection Status
      PYMNT_HANDLING_CD - Payment Handling
      PYMNT_SEPARATE - Separate Payment
      PYMNT_HOLD - Hold Payment
      PYMNT_HOLD_WTHD - On Withholding Hold
      POST_STATUS_AP - Post Status
      INVOICE_ID - Invoice Number
      INVOICE_DT - Invoice Date
      GROSS_AMT - Gross Invoice Amount
      TXN_CURRENCY_CD - Transaction Currency



13 of 14                                        AP_VENDOR   1c383522-7924-4e3c-b322-bb43e02bcb31.xls
                                  PEOPLESOFT REPORTING

                                        VENDOR TABLES

      DSCNT_AMT - Discount Amount
      SALETX_AMT - Sales Tax Amount
      FREIGHT_AMT - Freight Amount
      REMIT_VENDOR - Remit Vendor
      PYMNT_TERMS_CD - Payment Terms ID
      VCHR_DSCNT_DUE_DT - Voucher Discount Due Date
      VCHR_DUE_DT - Voucher Due Date
      APPR_STATUS - Approval Status
      DESCR254_MIXED - More Information
      CLOSE_STATUS - Close Status Indicator




14 of 14                                      AP_VENDOR   1c383522-7924-4e3c-b322-bb43e02bcb31.xls

								
To top