APD_MANDFT_SRCH

(SQL Table)
 Index Back

AP Non-System Generated Pymnts

This table used as a search record for manual payment entry.

  • Related Language Record: APD_MANDFT_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

    Default Value: OPR_BANK_VW_AP.BANK_SETID

    Prompt Table: SP_SETBNK_NONVW

    2 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

    Prompt Table: BANK_CD_VW2

    3 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

    Prompt Table: BANK_ACCT_VW

    4 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

    Prompt Table: %EDITTABLE

    5 PYMNT_ID Character(10) VARCHAR2(10) NOT NULL Payment Number

    Default Value: NEXT

    6 WS_ID Character(15) VARCHAR2(15) NOT NULL Worksheet ID

    Default Value: NEXT

    7 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID

    Default Value: OPR_REMIT_VW_AP.REMIT_SETID

    Prompt Table: SP_SETRMT_NONVW

    8 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor

    Prompt Table: VNDR_RMT_NS_VW

    9 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

    Prompt Table: VNDR_RMLOC_VW

    10 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency

    Prompt Table: APD_ACCT_CUR_VW

    11 PYMNT_ID_REF Character(20) VARCHAR2(20) NOT NULL Payment Reference

    Default Value: NEXT

    12 DFT_CONTROL_ID Character(20) VARCHAR2(20) NOT NULL Draft Control ID

    Default Value: NEXT

    13 PYMNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Amount
    14 CREATION_DT Date(10) DATE Creation Date

    Default Value: %Date

    15 DFT_MAT_DT Date(10) DATE Draft Maturity Date
    16 DFT_SCHED_MAT_DT Date(10) DATE Draft Scheduled Maturity Date
    17 DFT_STMP_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Draft StampTax Amount
    18 DFT_MASTER_ID Character(10) VARCHAR2(10) NOT NULL Draft Master ID

    Default Value: NEXT

    19 PYMNT_DT Date(10) DATE Payment Date

    Default Value: %DATE

    20 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

    Default Value: %Date

    21 DESCRLONG Long Character CLOB Long Description
    22 DFT_DRAWEE Character(40) VARCHAR2(40) NOT NULL Draft Drawee
    23 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
    N=Payment Not Applied
    P=Posted
    U=Unposted

    Default Value: U

    24 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    25 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    26 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    27 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    28 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    29 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    30 CITY Character(30) VARCHAR2(30) NOT NULL City
    31 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    32 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    33 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat
    WW=Trailer
    34 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    35 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    36 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    37 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    38 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: %EDIT_STATE

    39 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    40 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    41 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    42 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
    43 BRANCH_ID Character(10) VARCHAR2(10) NOT NULL The local branch office identifier associated with a given bank/counterparty.
    44 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
    45 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
    46 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
    47 BRANCH_NAME Character(10) VARCHAR2(10) NOT NULL Branch Name
    48 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
    49 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.
    50 DOC_SEQ Character(1) VARCHAR2(1) NOT NULL Enable Document Sequencing
    51 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.
    52 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.
    53 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
    54 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    55 MICR_LINE Character(50) VARCHAR2(50) NOT NULL MICR Line
    56 CUR_RT_TYPE_BNK Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
    57 BANK_ACCT_SEQ_NBR Number(3,0) SMALLINT NOT NULL Bank Account Sequence Number

    Prompt Table: RMT_BANK_SEQ_VW

    58 MATCH_FLG Character(1) VARCHAR2(1) NOT NULL Match FLag

    Y/N Table Edit

    Default Value: Y

    59 DISC_APPLY_FLG Character(1) VARCHAR2(1) NOT NULL Discount Apply Flag

    Y/N Table Edit

    Default Value: Y

    60 WTHD_CALC_FLG Character(1) VARCHAR2(1) NOT NULL Withholding Calculated

    Y/N Table Edit

    Default Value: Y

    61 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
    B=Global and 1099
    G=Global
    T=1099