...
You may create payment files in the external systems and upload the file to the SFTP(XFER) server. In the new process, you will be required to create vendors manually with W-9 and reference the vendor number and address in your payment upload file.
XML Element Definition
Element / Attribute | Data Type |
Length | Required? | Description / Format | Example |
<pdp_file> |
Req |
xmlns | String | Req | Always: |
xmlns:xsi | String | Req | Always: |
xsi:schemaLocation | String | Req | Always: |
version |
Req | Always: |
<header> |
Req |
<campus> |
<chart>
String | Fixed: 2 | Req | Chart of accounts code. First part of the PDP Customer Profile | IR |
<unit>
The tag was changed from <chart> to <campus> on 8/26/2022 | |||
<unit> | String | Min: 1 / Max: 4 | Req |
Four character description of the unit. Second part of the PDP Customer Profile. |
SBS
<sub_unit>
Format: | SBS | |||
<sub_unit> | String | Min: 1 / Max: 4 | Req | Four |
character code that describes the source of the PDP file. The last part of the PDP Customer Profile. Format: | ACCT | |||
<creation_date> | String | Fixed: 19 | Req | Date file is created. Format |
: | 2013-01-10T09:00:00 |
</header> |
Req |
<group> |
Req | The <group> element combines payments to a single vendor or payee. Each <group> element will contain one or more <detail> elements (described below) to provide information about individual payments. |
<payee_name> | String |
Min: 1 / Max: 40 | Req | Name of the vendor or individual for which the payment is intended. | ABC CLEARNING SERVICES | |
<payee_id> | String |
Len: |
25 | Opt | This is the Vendor Number that exists in KFS. This would also be the Student ID for students. | 12345678 |
<id_type> | String |
Fixed: 1 | Req | This will equal "V" for vendor number. This will equal "D" for students. For Plus Loan checks mailed to parents send "P". Format: | V |
<payee_own_cd> | String |
Fixed: 2 | Opt | This would be similar to Individual or Sole Proprietor. Format: |
CF | |
<customer_institution_identifier> | String |
Len: 30 | Opt | Unit defined. For example, the customer number the vendor associates with our account. | TEST |
<address1> |
<address_id>
Numeric Len: 1Max Len: 10
Opt
Unique address id assigned to each vendor address by the system
1022
E - Exempt (sales tax is assumed to be included, or not to be charged)
U - Used Tax (calculate use tax)
<address1>
StringMin Len: 1Max Len: 45
Req
String | Min: 1 / Max: 45 | Req | Address to which payment is to be sent. There may be up to four address lines. Do not include city, state, or zip code. | CUSTOMER PAYMENT CENTER |
<address2> | String |
Len: 45 | Opt | Address to which payment is to be sent. There may be up to four address lines. Do not include city, state, or zip code. | PO BOX 1234 |
<city> |
String | Len: |
45 | Opt | City to which payment is to be sent. | Irvine |
<state> | String |
Len: 30 | Opt | State to which payment is to be sent. | CA |
<zip> | String |
Len: |
20 | Opt | Zipcode to which payment is to be sent. | 92697-4600 |
<country> | String |
Len: |
30 | Opt | Country to which payment is to be sent. | USA | |
<campus_address_ind> | String | Len: 1 | Opt | Format: |
|
Opt
Y – Payee address is on-campus. | N | |||
<payment_date> | String | Fixed: 10 | Req | Date payment is due or the check produced. |
This would normally be the due date. Format: | 2011-04-09 | |||
<attachment_ind> | String | Len: 1 | Opt | Format: |
|
Y – Indicates that an attachment has been mailed or faxed | N |
<special_handling_ind> | String |
Len: 1 | Opt | Format: |
Y – Indicates special handling is required. Use this to indicate Pick Up check. | N | |||
<taxable_ind> | String | Len: 1 | Opt | Format: |
|
Opt
Y – Taxable expense (Y for 1042S) |
<nra_ind> | String |
Len: 1 | Opt | Format: |
Y – Vendor is non-resident alien |
There's currently a bug related to removing the tax hold where the folks who should have that permission don't appear to. This is reported in JIRA as KFSMI-5595.
N
<combine_group_ind>
N | ||||
<combine_group_ind> | String | Len: 1 | Opt | Format: |
Y – Payment may be combined with other payments to the same vendor | Y |
<bank_code> | String |
Len: 4 | Opt | Bank code. Not used anymore, leave blank. It will be ignored by PDP. |
<disbursement_date> | String | Len: 10 | Opt | Not used for uploading payments, leave blank. |
<disbursement_number> |
Integer | Len: 9 | Opt | Not used for uploading payments, leave blank. |
<disbursement_type> | String | Len: 4 | Opt | Not used for uploading payments, leave blank. |
<pmt_stat_cd> | String | Len: 4 | Opt | Not used for uploading payments, leave blank. |
<detail> |
Req | Every <group> element must contain at least one <detail> sub-element. The contents of the <detail> element provide information about a single payment to the vendor described in the parent <group> element (described above). Each <detail> element will contain one or more <accounting> elements (described below). KFS supports up to 200 details per group. |
<source_doc_nbr> | String |
Min: 1 / Max: 14 | Req | This will be an identifying number that can be searched on. Could be used to identify a batch of payments. From KFS, it is the same as the document number. Use this attribute to pass the Image Id if you are using DDM scanning services. |
12345
<invoice_nbr>
<po_nbr>
Format: | 12345 | |||
<invoice_nbr> | String | Min: 1 / Max: 14 | Opt | The number that identifies the payment. This can be searched on. From KFS, it is the same as the Payment Request Number. |
INV1
Format: | INV1 | ||||
<po_nbr> | String | Len: 9 | Opt | Purchase Order number | 12345 |
<req_nbr> | String |
Len: |
8 | Opt | Requisition number | 12345 |
<org_doc_nbr> |
String | Len: 10 | Opt | Additional identifying internal number at the header level. | 12345 | |
<invoice_date> | String | Opt | Invoice Date. Format is yyyy-mm-dd. It is advisable to send your source document date in this attribute for recording purposes. | 2011-04-09 | |
<orig_invoice_amt> |
Decimal | Opt | Original Invoice Amount | 29.77 | |
<net_payment_amt> |
Decimal | Opt | Net Payment Amount | 29.77 | |
<invoice_tot_discount_amt> |
Decimal | Opt | Invoice total discount amount | 0 | |
<invoice_tot_ship_amt> |
Decimal | Opt | Invoice total shipping amount | 0 | |
<invoice_tot_other_debits> |
Decimal | Opt | Invoice total other debits | 0 | |
<invoice_tot_other_credits> |
Decimal | Opt | Invoice total other credits | 0 | |
<fs_origin_cd> |
String | Fixed: 2 | Opt | Origin Code specific to the unit, please reference your Origin Code. | SB | |
<fdoc_typ_cd> | String |
Len: 4 | Opt | Document type code will be EPAY. | EPAY |
<accounting>
Req
<extension> | Opt | ||||
<use_tax_type_cd> | String | Len: 1 | Opt | I - for Invoice Date driven use tax calculation D – for Delivery Date driven use tax calculation Format: | D |
<delivery_date> | String | Len: 10 | Opt | To allow medical center to specify which date to calculate use tax (delivery date vs. invoice date) YYYY-MM-DD. Populate this tag only if the use_tax_type_cd is D. | 2007-07-09 |
</extension> | Opt | ||||
<accounting> | Req | Every <detail> element must contain at least one <accounting> sub-element. Each <accounting> element provides information about a source for the payment in the parent <detail> element. The combined value of the amount fields in the <accounting> sub-elements must equal the <net_payment_amt> value in the parent <detail> element. |
<coa_cd> |
String | Fixed: 2 | Req | Chart of accounts code. | IR |
<account_nbr> |
String | Fixed: 7 | Req | Account number | BF10002 | |
<sub_account_nbr> | String | Len: 5 | Opt | Sub-account number. | |
<object_cd> |
String | Fixed: 4 | Req | Object code | 5000 | |
<sub_object_cd> | String | Len: 4 | Opt | Sub-object code | — |
<org_ref_id> |
String | Len: |
10 | Opt | Unit-defined reference number used at the transaction level. Normally carries FS Source. |
<project_cd> | String | Len: 10 | Opt | Project Code ID. This attribute is pre-defined in the Project table and it is validated if used. If you use it make sure it is a valid Project. | 133 |
<amount> |
Decimal | Req | Amount | 100.00 | |
</accounting> |
Req |
<payment_text> | String |
Len: 90 | Opt | Each <detail> element may contain multiple <payment_text> sub-elements. The text contained within each <payment_text> element will appear as a single line of text printed on the payment stub remitted to the vendor. |
</detail> |
Req |
<capital_asset_information> |
Opt |
<new_asset> |
Opt |
<asset_type_code> | String | Len: 7 | Opt |
<vendor_number> | String | Len: 40 | Opt |
<asset_manufacturer_name> | String | Len: 45 | Opt |
<asset_manufacturer_model_number> | String | Len: 25 | Opt |
<asset_description> | String | Len: 40 | Opt |
</new_asset> |
Opt |
<asset_info_detail> |
Opt |
<asset_tag_number> | String | Len: 8 | Opt |
<asset_serial_number> | String | Len: 25 | Opt |
<campus_code> | String | Len: 2 | Opt |
<building_code> | String | Len: 10 | Opt |
<building_room_number> | String | Len: 8 | Opt |
<building_sub_room_number> | String | Len: 2 | Opt |
</asset_info_detail> |
Opt |
<existing_asset> |
Opt |
<asset_number> | String | Len: 12 | Opt |
</existing_asset> |
Opt |
</capital_asset_information> |
Opt |
</group> |
Req |
<trailer> |
Req |
<detail_count> |
Integer | Req | Number of transactions in the file. |
<detail_tot_amt> |
Decimal | Req | Total amount of the payment lines. |
</trailer> |
Req |
</pdp_file> |
Req |
Anchor | ||||
---|---|---|---|---|
|
The following is the sample XML file that is acceptable by the PDP upload screen:
<?xml version="1.0" encoding="UTF-8"?> <pdp_file xmlns="http://www.kuali.org/kfs/pdp/payment" |
<campus>IR</ |
campus> |
<extension>
|
<tax_type_cd>U</tax_type_cd>
</extension>
<payment_date>2011-05-05</payment_date> |
Complex XML Input File With Capital Asset Information
<?xml version="1.0" encoding="UTF-8"?> |
<campus>BL</ |
campus> |
XSD for Payment Upload (please see the attachments for the payment.xsd, types.xsd, and ddTypes.xsd files)
Code Block |
---|
<?xml version="1.0" encoding="UTF-8"?> <!-- Copyright 2007-2008 The Kuali Foundation Licensed under the Educational Community License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.opensource.org/licenses/ecl2.php Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. --> <xsd:schema elementFormDefault="qualified" targetNamespace="http://www.kuali.org/kfs/pdp/payment" xmlns:kfs="http://www.kuali.org/kfs/sys/types" xmlns:dd="http://www.kuali.org/kfs/sys/ddTypes" xmlns="http://www.kuali.org/kfs/pdp/payment" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <xsd:import namespace="http://www.kuali.org/kfs/sys/types" schemaLocation="@externalizable.static.content.url@/xsd/sys/types.xsd" the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. --> <xsd:schema elementFormDefault="qualified" targetNamespace="http://www.kuali.org/kfs/pdp/payment" xmlns:kfs="http://www.kuali.org/kfs/sys/types" xmlns:dd="http://www.kuali.org/kfs/sys/ddTypes" xmlns="http://www.kuali.org/kfs/pdp/payment" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <xsd:import namespace="http://www.kuali.org/kfs/sys/types" schemaLocation="http://localhost:8080/kfs-dev/static/xsd/sys/types.xsd" /> <xsd:import namespace="http://www.kuali.org/kfs/sys/ddTypes" schemaLocation="http://localhost:8080/kfs-dev/static/xsd/sys/ddTypes.xsd" /> <!-- simple data types --> <xsd:simpleType name="versionType"> <xsd:restriction base="xsd:string"> <xsd:pattern value="1.0"/> </xsd:restriction> </xsd:simpleType> <!-- BEGIN UCI CODE --> <xsd:simpleType name="oneToSevenCharType"> <xsd:restriction base="xsd:string"> <xsd:minLength value="1"/> <xsd:maxLength value="7"/> </xsd:restriction> </xsd:simpleType> <xsd:simpleType name="useTaxTypeCodeType"> <xsd:restriction base="xsd:string"> <!-- WARREN CHANGE: change codes from E/U to D/I --> <!-- <xsd:enumeration value="E"/> <xsd:enumeration value="U"/> --> <xsd:enumeration value="D"/> <xsd:enumeration value="I"/> </xsd:restriction> </xsd:simpleType> <!-- END UCI CODE --> <!-- definition of simple type elements --> <xsd:element name="campus" type="xsd:normalizedString"/> <xsd:element name="unit" type="xsd:normalizedString"/> <xsd:element name="sub_unit" type="xsd:normalizedString"/> <!-- KFSI-1202 just make create date xsd:datetime --> <xsd:element name="creation_date" type="xsd:dateTime"/> <xsd:element name="source_doc_nbr" type="xsd:normalizedString"/> <xsd:element name="invoice_nbr" type="xsd:normalizedString"/> <xsd:element name="po_nbr" type="xsd:normalizedString"/> <xsd:element name="req_nbr" type="xsd:normalizedString"/> <xsd:element name="org_doc_nbr" type="xsd:normalizedString"/> <xsd:element name="payee_name" type="xsd:normalizedString"/> <xsd:element name="payee_own_cd" type="xsd:normalizedString"/> <xsd:element name="customer_institution_identifier" type="xsd:normalizedString"/> <xsd:element name="address1" type="xsd:normalizedString"/> <xsd:element name="address2" type="xsd:normalizedString"/> <xsd:element name="address3" type="xsd:normalizedString"/> <xsd:element name="address4" type="xsd:normalizedString"/> <xsd:importelement namespacename="http://www.kuali.org/kfs/sys/ddTypescity" schemaLocationtype="@externalizable.static.content.url@/xsd/sys/ddTypes.xsd" xsd:normalizedString"/> <xsd:element name="state" type="xsd:normalizedString"/> <xsd:element <!-- simple data types --name="zip" type="xsd:normalizedString"/> <xsd:simpleTypeelement name="country" type="versionTypexsd:normalizedString"/> <xsd:restriction baseelement name="campus_address_ind" type="xsd:stringnormalizedString"/> <!-- KFSI-1202 just make date xsd:date --> <xsd:pattern value="1.0element name="payment_date" type="xsd:date"/> </xsd:restriction> </xsd:simpleType> !-- KFSI-1202 just make date xsd:date --> <!-- BEGIN UCI CODE --<xsd:element name="invoice_date" type="xsd:date"/> <xsd:simpleTypeelement name="attachment_ind" type="oneToSevenCharTypexsd:normalizedString"/> <xsd:restriction baseelement name="special_handling_ind" type="xsd:stringnormalizedString"> /> <xsd:minLength value="1element name="taxable_ind" type="xsd:normalizedString"/> <xsd:maxLength value="7<xsd:element name="orig_invoice_amt" type="xsd:decimal"/> <xsd:element </xsd:restriction> </xsd:simpleType> name="net_payment_amt" type="xsd:decimal"/> <xsd:simpleTypeelement name="invoice_tot_discount_amt" type="taxTypeCodeTypexsd:decimal"/> <xsd:restriction baseelement name="invoice_tot_ship_amt" type="xsd:stringdecimal"/> <xsd:enumeration value="E"/> <xsd:element name="invoice_tot_other_debits" type="xsd:decimal"/> <xsd:enumerationelement valuename="U"/> </xsd:restriction> </xsd:simpleType> invoice_tot_other_credits" type="xsd:decimal"/> <!-- END UCI CODE --<xsd:element name="nra_ind" type="xsd:normalizedString"/> <xsd:element name="combine_group_ind" type="xsd:normalizedString"/> <!-- definition of simple type elements --> <xsd:element name="coa_cd" type="xsd:normalizedString"/> <xsd:element name="chartaccount_nbr" type="${xsd:normalizedString,dd:PaymentFileLoad.chart}"/> <xsd:element name="unitsub_account_nbr" type="${xsd:normalizedString,dd:PaymentFileLoad.unit}"/> <xsd:element name="subobject_unitcd" type="${xsd:normalizedString,dd:PaymentFileLoad.subUnit}normalizedString"/> <!-- KFSI-1202 just make create date xsd:datetime --<xsd:element name="sub_object_cd" type="xsd:normalizedString"/> <xsd:element name="creationorg_ref_dateid" type="xsd:dateTimenormalizedString"/> <xsd:element name="sourceproject_doc_nbrcd" type="${xsd:normalizedString,dd:PaymentDetail.custPaymentDocNbr}"/> <xsd:element name="invoice_nbramount" type="${xsd:normalizedString,dd:PaymentDetail.invoiceNbr}"/> <xsd:element name="popayment_nbrtext" type="${xsd:normalizedString,dd:PaymentDetail.purchaseOrderNbr}"/> <xsd:element name="reqdetail_nbrcount" type="${xsd:normalizedString,dd:PaymentDetail.requisitionNbr}integer"/> <xsd:element name="orgdetail_doctot_nbramt" type="${xsd:normalizedString,dd:PaymentDetail.organizationDocNbr}decimal"/> <xsd:element name="payeebank_namecode" type="${xsd:normalizedString,dd:PaymentGroup.payeeName}"/> <xsd:element name="payeefs_ownorigin_cd" type="${xsd:normalizedString,dd:PaymentGroup.payeeOwnerCd}"/> <xsd:element name="customerfdoc_institutiontyp_identifiercd" type="${xsd:normalizedString,dd:PaymentGroup.customerInstitutionNumber}"/>"/> <!-- BEGIN UCI CODE: [FSI-142] INT-PDP-004 Manual/Local Check Upload --> <!-- KFSI-1202 just make date xsd:date --> <xsd:element name="address1disbursement_date" type="${xsd:normalizedString,dd:PaymentGroup.line1Address}"/>xsd:date" /> <xsd:element name="address2disbursement_number" type="${xsd:normalizedString,dd:PaymentGroup.line2Address}"string" /> <xsd:element name="address3disbursement_type" type="${xsd:normalizedString,dd:PaymentGroup.line3Address}"kfs:zeroToFourCharType" /> <xsd:element name="address4pmt_stat_cd" type="${xsd:normalizedString,dd:PaymentGroup.line4Address}"kfs:zeroToFourCharType" /> <xsd:element name="citygenerate_gl_entries" type="${xsd:normalizedString,dd:PaymentGroup.city}"boolean" /> <!-- END UCI --> <!-- BEGIN UCI CODE KFSI-191 --> <xsd:element name="stateasset_type_code" type="${xsd:normalizedString,dd:PaymentGroup.state}"oneToSevenCharType" /> <xsd:element name="zipvendor_number" type="${xsd:normalizedString,dd:PaymentGroup.zipCd}"kfs:oneToFortyCharType" /> <xsd:element name="countryasset_number" type="${xsd:normalizedString,dd:PaymentGroup.country}"integer" /> <xsd:element name="campusasset_addressmanufacturer_indname" type="${xsd:normalizedString,dd:PaymentGroup.campusAddress}"/> <!-- KFSI-1202 just make date xsd:date --> kfs:zeroToFortyFiveCharType" /> <xsd:element name="payment_dateasset_manufacturer_model_number" type="xsdkfs:dateoneToTwentyFiveCharType" /> <!-- KFSI-1202 just make date xsd:date --> <xsd:element name="invoiceasset_datedescription" type="xsdkfs:dateoneToFortyCharType" /> <xsd:element name="attachmentasset_tag_indnumber" type="${xsd:normalizedString,dd:PaymentGroup.pymtAttachment}"kfs:oneToEightCharType" /> <xsd:element name="specialasset_handlingserial_indnumber" type="${xsd:normalizedString,dd:PaymentGroup.pymtSpecialHandling}"kfs:oneToTwentyFiveCharType" /> <xsd:element name="taxablecampus_indcode" type="${xsd:normalizedString,dd:PaymentGroup.taxablePayment}""kfs:oneToTwoCharType" /> <xsd:element name="origbuilding_invoice_amtcode" type="${xsd:decimal,dd:PaymentDetail.origInvoiceAmount}"kfs:oneToTenCharType" /> <xsd:element name="netbuilding_paymentroom_amtnumber" type="${xsd:decimal,dd:PaymentDetail.netPaymentAmount}"kfs:oneToEightCharType" /> <xsd:element name="invoicebuilding_totsub_discountroom_amtnumber" type="${xsd:decimal,dd:PaymentDetail.invTotDiscountAmount}"kfs:oneToTwoCharType" /> <!-- END UCI CODE KFSI-191 --> <!-- BEGIN <xsd:element name="invoice_tot_ship_amt" type="${xsd:decimal,dd:PaymentDetail.invTotShipAmount}"/UCI CODE KFSI-470 --> <xsd:element name="invoiceuse_tottax_othertype_debitscd" type="${xsd:decimal,dd:PaymentDetail.invTotOtherDebitAmount}"useTaxTypeCodeType" /> <!-- END UCI <xsd:element name="invoice_tot_other_credits" type="${xsd:decimal,dd:PaymentDetail.invTotOtherCreditAmount}"/>CODE KFSI-470 --> <xsd:element name="nra_ind" type="${xsd:normalizedString,dd:PaymentGroup.nraPayment}"/<!-- WARREN ADD delivery date --> <xsd:element name="combinedelivery_group_inddate" type="${xsd:normalizedString,dd:PaymentGroup.combineGroups}"/>date"/> <!-- definition of attributes --> <!-- definition of complex type elements --> <xsd:element name="coapdp_cdfile" type="${xsd:normalizedString,dd:PaymentAccountDetail.finChartCode}"/>> <xsd:complexType> <xsd:sequence> <xsd:element nameref="account_nbr" type="${xsd:normalizedString,dd:PaymentAccountDetail.accountNbr}header"/> <xsd:element name="sub_account_nbr" type="${xsd:normalizedString,dd:PaymentAccountDetail.subAccountNbr}"/> <xsd:element name maxOccurs="unbounded" minOccurs="object_cd1" typeref="${xsd:normalizedString,dd:PaymentAccountDetail.finObjectCode}group"/> <xsd:element name="sub_object_cd" type="${xsd:normalizedString,dd:PaymentAccountDetail.finSubObjectCode}"/> <xsd:element name="org_ref_id" type="${xsd:normalizedString,dd:PaymentAccountDetail.orgReferenceId}trailer"/> <xsd:element name="project_cd" type="${xsd:normalizedString,dd:PaymentAccountDetail.projectCode}"/> </xsd:sequence> <xsd:elementattribute name="amountversion" type="${xsd:normalizedString,dd:PaymentAccountDetail.accountNetAmount}versionType" use="required"/> <xsd:element name="payment_text" type="${xsd:normalizedString,dd:PaymentNoteText.customerNoteText}"/> </xsd:complexType> </xsd:element> <xsd:element name="detail_count" type="${xsd:integer,dd:PaymentFileLoad.paymentCount}"/>accounting"> <xsd:complexType> <xsd:element name="detail_tot_amt" type="${xsd:decimal,dd:PaymentFileLoad.paymentTotalAmount}"/>sequence> <xsd:element namemaxOccurs="1" minOccurs="bank_code0" typeref="${xsd:normalizedString,dd:Bank.bankCode}coa_cd"/> <xsd:element namemaxOccurs="1" minOccurs="fs_origin_cd1" typeref="${xsd:normalizedString,dd:PaymentDetail.financialSystemOriginCode}account_nbr"/> <xsd:element namemaxOccurs="fdoc_typ_cd1" minOccurs="0" type="${xsd:normalizedString,dd:PaymentDetail.financialDocumentTypeCode}ref="sub_account_nbr"/> <!-- BEGIN UCI CODE: [FSI-142] INT-PDP-004 Manual/Local Check Upload -- <xsd:element ref="object_cd"/> <!-- KFSI-1202 just make date xsd:date --> <xsd:element namemaxOccurs="disbursement_date1" typeminOccurs="xsd:date0" ref="sub_object_cd"/> <xsd:element namemaxOccurs="disbursement_number1" typeminOccurs="xsd:string0" ref="org_ref_id"/> <xsd:element namemaxOccurs="disbursement_type1" typeminOccurs="kfs:zeroToFourCharType0" ref="project_cd"/> <xsd:element name="pmt_stat_cd" type="kfs:zeroToFourCharType" <xsd:element ref="amount"/> <!-- END UCI --> </xsd:sequence> <!-- BEGIN UCI CODE KFSI-191 --></xsd:complexType> </xsd:element> <xsd:element name="asset_type_code" type="oneToSevenCharType" /> <xsd:element name="vendor_number" type="kfs:oneToFortyCharType" />header"> <xsd:element name="asset_number" type="xsd:integer" />complexType> <xsd:element name="asset_manufacturer_name" type="kfs:zeroToFortyFiveCharType" /> <xsd:sequence> <xsd:element name="asset_manufacturer_model_number" type="kfs:oneToTwentyFiveCharType" /> <xsd:element nameref="asset_description" type="kfs:oneToFortyCharType" campus"/> <xsd:element name="asset_tag_number" type="kfs:oneToEightCharType" /> <xsd:element nameref="asset_serial_number" type="kfs:oneToTwentyFiveCharType" />unit"/> <xsd:element name="campus_code" type="kfs:oneToTwoCharType" /> <xsd:element nameref="buildingsub_code" type="kfs:oneToTenCharType" unit"/> <xsd:element name="building_room_number" type="kfs:oneToEightCharType" /> <xsd:element nameref="building_sub_room_number" type="kfs:oneToTwoCharType" creation_date"/> <!-- END UCI CODE KFSI-191 --> <!-- BEGIN UCI CODE KFSI-470142 --> <xsd:element name="tax_type_cd" type="taxTypeCodeType" /> <!-- END UCI CODE KFSI-470 --> <!-- definition of attributes --><xsd:element maxOccurs="1" minOccurs="0" ref="generate_gl_entries"/> <!-- definitionEND ofUCI complex typeCODE elements --> <xsd:element name="pdp_file"> <xsd:complexType></xsd:sequence> <xsd:sequence></xsd:complexType> </xsd:element> <xsd:element refname="headertrailer"/> <xsd:complexType> <xsd:element maxOccurs="unbounded" minOccurs="1" ref="group"/> <xsd:sequence> <xsd:element ref="trailerdetail_count"/> </xsd:sequence> <xsd:element ref="detail_tot_amt"/> <xsd:attribute name="version" type="versionType" use="required"/> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="accountinggroup"> <xsd:complexType> <xsd:sequence> <xsd:element maxOccurs="1" minOccurs="0" ref="coapayee_cdname"/> <xsd:element maxOccurs="1" minOccurs="10" ref="accountpayee_nbrid"/> <xsd:element maxOccurs="1" minOccurs="0" ref="subpayee_account_nbr"/> <xsd:element ref="object_own_cd"/> <xsd:element maxOccurs="1" minOccurs="0" ref="subcustomer_objectinstitution_cdidentifier"/> <xsd:element maxOccurs="1" minOccurs="0" ref="org_ref_id"/<!-- BEGIN UCI CODE: [KFSI-98] INT-PDP-003 Payment Upload Using PURAP Vendor--> <xsd:element maxOccurs="1" minOccurs="0" refname="project_cdextension"/> <xsd:element ref="amount"/> </xsd:sequence> </xsd:<xsd:complexType> </xsd:element> <xsd:element name="header"> <xsd:complexType> sequence> <xsd:sequence> <xsd:element refmaxOccurs="chart1"/> <xsd:element ref="unit"/> <xsd:element ref="sub_unit"/> minOccurs="0" name="address_id" type="kfs:oneToTenCharType"/> <xsd:element ref="creation_date"/> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="trailer"> <!-- UCI <xsd:complexType> CODE KFSI-470 --> <xsd:sequence> <!-- WARREN DELETE <xsd:element maxOccurs="1" minOccurs="0" ref="tax_type_cd" /> --> <xsd:element ref="detail_count"/> <xsd:element ref="detail_tot_amt"/> </xsd:sequence> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd</xsd:element name="group">element> <xsd:complexType> <xsd:element maxOccurs="1" minOccurs="0" ref="address1"/> <xsd:sequence> <!-- END UCI <xsd:element ref="payee_name"/CODE --> <xsd:element maxOccurs="1" minOccurs="0" ref="payee_idaddress2"/> <xsd:element maxOccurs="1" minOccurs="0" ref="payee_own_cdaddress3"/> <xsd:element maxOccurs="1" minOccurs="0" ref="customer_institution_identifieraddress4"/> <!-- BEGIN UCI CODE: [KFSI-98] INT-PDP-003 Payment Upload Using PURAP Vendor--<xsd:element maxOccurs="1" minOccurs="0" ref="city"/> <xsd:element maxOccurs="1" minOccurs="0" nameref="extensionstate"/> <xsd:element maxOccurs="1" minOccurs="0" <xsd:complexType>ref="zip"/> <xsd:element maxOccurs="1" minOccurs="0" ref="country"/> <xsd:sequence> <xsd:element maxOccurs="1" minOccurs="0" ref="campus_address_ind"/> <xsd:element maxOccurs="1" minOccurs="0" nameref="address_id" type="kfs:oneToTenCharTypepayment_date"/> <xsd:element maxOccurs="1" minOccurs="0" ref="attachment_ind"/> <xsd:element maxOccurs="1" minOccurs="0" ref="special_handling_ind"/> <xsd:element maxOccurs="1" minOccurs="0" ref="taxable_ind"/> <xsd:element maxOccurs="1" <!-- UCI CODE KFSI-470 --> minOccurs="0" ref="nra_ind"/> <xsd:element maxOccurs="1" minOccurs="0" ref="taxcombine_typegroup_cdind" /> <xsd:element maxOccurs="1" </xsd:sequence>minOccurs="0" ref="bank_code"/> <!-- BEGIN UCI </xsdCODE:complexType> [FSI-142] INT-PDP-004 Manual/Local Check Upload --> </xsd:element> <xsd:element maxOccurs="1" minOccurs="0" ref="address1disbursement_date" /> <!-- END UCI CODE --<xsd:element maxOccurs="1" minOccurs="0" ref="disbursement_number" /> <xsd:element maxOccurs="1" minOccurs="0" ref="address2disbursement_type" /> <xsd:element maxOccurs="1" minOccurs="0" ref="address3pmt_stat_cd" /> <xsd:element maxOccurs="1" minOccurs="0" ref="address4"/><!-- END UCI --> <xsd:element maxOccurs="1" minOccurs="0" ref="city"/> <xsd:element maxOccurs="1" minOccurs="0" ref="state"/> <!-- Default check stub holds 27 note lines. There is a line printed for each detail <xsd:element maxOccurs="1" minOccurs="0" ref="zip"/> so the number of detail items on a check needs to be subtracted from the <xsd:element maxOccurs="1" minOccurs="0" ref="country"/> total allowed <xsd:element maxOccurs="1" minOccurs="0" ref="campus_address_ind"/> note lines. This can't be enforced in the schema so it is possible <xsd:element maxOccurs="1" minOccurs="0" ref="payment_date"/> to provide too many <xsd:element maxOccurs="1" minOccurs="0" ref="attachment_ind"/> note lines in some cases. This rule will be enforced in <xsd:element maxOccurs="1" minOccurs="0" ref="special_handling_ind"/> code. <xsd:element maxOccurs="1" minOccurs="0" ref="taxable_ind"/> <xsd:element maxOccurs="1" minOccurs="0" ref="nra_ind"/> <xsd:element maxOccurs="1" minOccurs="0" ref="combine_group_ind"/> Because of this, the maximum number of detail segments is 27 (assuming they <xsd:element maxOccurs="1" minOccurs="0" ref="bank_code"/> have no <!-- BEGIN UCI CODE: [FSI-142] INT-PDP-004 Manual/Local Check Upload -->notes). <xsd:element maxOccurs="1" minOccurs="0" ref="disbursement_date" /> If your check stub <xsd:element maxOccurs="1" minOccurs="0" ref="disbursement_number" /> holds more or less than 27 note lines, you need to change this, <xsd:element maxOccurs="1" minOccurs="0" ref="disbursement_type" /> the maximum number of detail segments in this file <xsd:element maxOccurs="1" minOccurs="0" ref="pmt_stat_cd" />and the setting MAX_NOTE_LINES <!-- END UCI --> in the application settings file. <!--> Default check stub holds 27 note lines. There is a line printed for each detail<!-- BEGIN UCI CODE KFSI-4582 up limit to 200 payment details so the number of detail items on a check needs to be subtracted from the <xsd:element maxOccurs="27" minOccurs="1" ref="detail"/> --> <xsd:element maxOccurs="200" minOccurs="1" ref="detail"/> total allowed note lines. This can't be enforced in the schema so it is possible<!-- END UCI CODE KFSI-4582 --> <!-- toBEGIN provideUCI tooCODE many note lines in some cases. This rule will be enforced inKFSI-191 --> <xsd:element maxOccurs="1" minOccurs="0" ref="capital_asset_information"/> code. <!-- END UCI CODE KFSI-191 --> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="detail"> Because of this, the maximum number of detail segments<xsd:complexType> is 27 (assuming they <xsd:sequence> have no notes). <xsd:element ref="source_doc_nbr"/> <xsd:element maxOccurs="1" minOccurs="0" ref="invoice_nbr"/> <xsd:element maxOccurs="1" minOccurs="0" ref="po_nbr"/> If your check stub holds more or less than 27 note lines, you need to change this,<xsd:element maxOccurs="1" minOccurs="0" ref="req_nbr"/> <xsd:element maxOccurs="1" minOccurs="0" ref="org_doc_nbr"/> the maximum number of detail segments in this file and the setting MAX_NOTE_LINES <xsd:element maxOccurs="1" minOccurs="0" ref="invoice_date"/> in the application settings file.<xsd:element maxOccurs="1" minOccurs="0" ref="orig_invoice_amt"/> <xsd:element maxOccurs="1" --minOccurs="0" ref="net_payment_amt"/> <xsd:element maxOccurs="271" minOccurs="10" ref="detailinvoice_tot_discount_amt"/> <!-- BEGIN UCI CODE KFSI-191 --<xsd:element maxOccurs="1" minOccurs="0" ref="invoice_tot_ship_amt"/> <xsd:element maxOccurs="1" minOccurs="0" ref="capitalinvoice_tot_assetother_informationdebits"/> <!-- END UCI CODE KFSI-191 -- <xsd:element maxOccurs="1" minOccurs="0" ref="invoice_tot_other_credits"/> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="detail"maxOccurs="1" minOccurs="0" ref="fs_origin_cd"/> <xsd:complexType> <xsd:element maxOccurs="1" minOccurs="0" ref="fdoc_typ_cd"/> <xsd:sequence> <!-- WARREN <xsd:element ref="source_doc_nbr"/ADD extension --> <xsd:element maxOccurs="1" minOccurs="0" refname="invoice_nbrextension"/> <xsd:element maxOccurs="1" minOccurs="0" ref="po_nbr"/> <xsd:complexType> <xsd:element maxOccurs="1" minOccurs="0" ref="req_nbr"/> <xsd:sequence> <xsd:element maxOccurs="1" minOccurs="0" ref="org_doc_nbr"/> <xsd:element maxOccurs="1" minOccurs="0" refname="invoice_dateaddress_id" type="kfs:oneToTenCharType"/> <xsd:element maxOccurs="1" minOccurs="0" ref="orig_invoice_amt"/> <xsd:element maxOccurs="1" minOccurs="0" ref="net_payment_amt"/> <xsd:element maxOccurs="1" minOccurs="0" ref="invoice_tot_discount_amt"/> <!-- UCI CODE KFSI-470 --> <xsd:element maxOccurs="1" minOccurs="0" ref="invoice_tot_ship_amt"/> <!-- WARREN ADD --> <xsd:element maxOccurs="1" minOccurs="0" ref="invoiceuse_tottax_othertype_debitscd" /> <xsd:element maxOccurs="1" minOccurs="0" ref="invoice_tot_other_credits"delivery_date" /> </xsd:sequence> <xsd:element maxOccurs="1" minOccurs="0" ref="fs_origin_cd"/> </xsd:complexType> <xsd:element maxOccurs="1" minOccurs="0" ref="fdoc_typ_cd"/> </xsd:element> <xsd:element maxOccurs="unbounded" minOccurs="1" ref="accounting"/> <!-- Default check stub holds 27 note lines. There is a line printed for each detail so the number of detail items on a check needs to be subtracted from the total allowed note lines. This can't be enforced in the schema so it is possible to provide too many note lines in some cases. This rule will be enforced in code. Because of this, the maximum note lines a detail can have is 26 (assuming there is only one detail in the payment group). If your check stub holds more or less than 27 note lines, you need to change this, the maximum number of detail segments in this file and the setting MAX_NOTE_LINES in the application settings file. --> <xsd:element maxOccurs="26" minOccurs="0" ref="payment_text"/> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="payee_id"> <xsd:complexType> <xsd:simpleContent> <xsd:extension base="kfs:oneToTwentyFiveCharType"> <xsd:attribute name="id_type" type="kfs:oneAlphaType" use="required"/> </xsd:extension> </xsd:simpleContent> </xsd:complexType> </xsd:element> <!-- BEGIN UCI CODE KFSI-191 --> <xsd:element name="capital_asset_information"> <xsd:complexType> <xsd:choice> "> <xsd:complexType> <xsd:choice> <xsd:element minOccurs="0" maxOccurs="1" ref="new_asset"/> <xsd:element minOccurs="0" maxOccurs="1" ref="existing_asset"/> </xsd:choice> </xsd:complexType> </xsd:element> <xsd:element name="existing_asset"> <xsd:complexType> <xsd:all> </xsd:element> <xsd:element name="existing_asset"> <xsd:complexType> <xsd:all> <xsd:element minOccurs="0" maxOccurs="1" ref="asset_number"/> </xsd:all> </xsd:complexType> </xsd:element> <xsd:element name="new_asset"> <xsd:complexType> <xsd:sequence> <xsd:complexType> <xsd:sequence> <xsd:element minOccurs="0" maxOccurs="1" ref="asset_type_code"/> <xsd:element minOccurs="0" maxOccurs="1" ref="vendor_number"/> <xsd:element minOccurs="0" maxOccurs="1" ref="asset_manufacturer_name" /> <xsd:element minOccurs="0" maxOccurs="1" ref="asset_manufacturer_model_number"/> <xsd:element minOccurs="0" maxOccurs="1" ref="asset_description"/> maxOccurs="1" ref="asset_description"/> <xsd:element minOccurs="0" maxOccurs="unbounded" ref="asset_info_detail"/> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="asset_info_detail"> <xsd:complexType> <xsd:all> <xsd:element minOccurs="0" maxOccurs="1" ref="asset_tag_number"/> "/> <xsd:element minOccurs="0" maxOccurs="1" ref="asset_serial_number"/> <xsd:element minOccurs="0" maxOccurs="1" ref="campus_code"/> <xsd:element minOccurs="0" maxOccurs="1" ref="building_code"/> <xsd:element minOccurs="0" maxOccurs="1" ref="building_room_number"/> <xsd:element minOccurs="0" maxOccurs="1" ref="building_sub_room_number"/> </xsd:all> </xsd:complexType> </xsd:element> <!-- END UCI CODE KFSI-191 --> </xsd:schema> |
Uploading Payment Batch Files Through Secure FTP
...