ࡱ >
bjbj pj1gpj1g b P P ! ! R# R# R# 4 # # # h # T B' # 5 p 6 9 X ": ": ": I R $ T $ [ R# F . I ! ! ": ": { 9 9 9 B ! ": R# ": 9 9 9 6 0 " h ": ڂ!$ 0 0 5 , 8 8 R# U ( } 9 u , U U U Z U U U 5 U U U U U U U U U P X :
General System Design
Document Review and Change SummaryVersion/
Review DateBrief Summary of Changes From Prior VersionChanged ByDocument
ReviewersVersion 1.0
11/04/05OriginalKishore AdabalaInterface TeamVersion 1.1
12/02/05Modified Kishore AdabalaOSCVersion 1.3
02/12/06ModifiedKishore AdabalaOSCVersion 1.4
03/02/06On page 18, added more business rules for BSA_CD.
On page 21, additional notes added for fields VEND_INV_NO, VEND_INV_LN_NO and VEND_INV_DT. These notes were communicated to all the agencies by email dated 02/14/2006.
On page 21, added new business rules for SUNIT_CD field. Value null should be passed in this field when BSA_CD is populated. This change affects only those agencies sending us a value in BSA_CD field.Kishore AdabalaOSC
Interface TeamVersion 1.5
04/05/06Added Data Repository SectionSharon Graves-OBrienInterface Team
OSCVersion 1.6
05/30/06Added Country Code (and list of codes)
Corrected miscellaneous errors on Pages 9 & 10Sharon Graves-OBrienInterface Team
OSCVersion 1.7
06/05/06Updated XML to include Country CodeSharon Graves-OBrienInterface Team
OSCVersion 1.8
07/10/06Added DFLT_DISB_FRMT to Vendor component. For NECSES EFT transactions only.Sharon Graves-OBrienInterface Team
OSCVersion 1.9
07/11/06Incident 2453: Provided list of valid values for DISB_CATSharon Graves-OBrienInterface Team
OSCVersion 1.10
08/01/06Moved Disbursement Category valid values from ACTG. DISB_CAT to VEND.VEND_DISB_CATSharon Graves-OBrienInterface Team
OSCVersion 1.11
08/21/06Include DOC_UNIT_CD on the Header componentSharon Graves-OBrienInterface Team
OSCVersion 1.12
03/21/2008Added notes for DFLT_DISB_FRMT data element in ABS_DOC_VEND section.
As of 07/01/2008 SVC_TO_DT and SVC_FRM_DT are required fields in ABS_DOC_ACTG section.Kishore AdabalaInterface Team
OSCVersion 1.13
08/08/2008Added DISB_PRTY_CD data element in ABS_DOC_VEND section.Doug JordanInterface Team
OSCVersion 2
11/10/2021Added Reporting Code (RPT_CD) in ABS_DOC_ACTG sectionKim HallOSC
MFASISGAX: General Accounting Expense (GAX)
Table of Contents
TOC \o "1-3" \h \z \u HYPERLINK \l "_Toc87430707" 1. Overview PAGEREF _Toc87430707 \h 4
HYPERLINK \l "_Toc87430708" 1.1. Document Definitions and Naming Conventions PAGEREF _Toc87430708 \h 4
HYPERLINK \l "_Toc87430709" 1.2. Document Usage PAGEREF _Toc87430709 \h 6
HYPERLINK \l "_Toc87430710" 1.3. Logical Document Component Structure PAGEREF _Toc87430710 \h 7
HYPERLINK \l "_Toc87430711" 2. Publishable Specification PAGEREF _Toc87430711 \h 8
HYPERLINK \l "_Toc87430712" 2.1. Transaction Layout: GAX PAGEREF _Toc87430712 \h 8
HYPERLINK \l "_Toc87430713" 2.1.1 Document Prefixes PAGEREF _Toc87430713 \h 9
HYPERLINK \l "_Toc87430714" 2.1.2 Data Repository PAGEREF _Toc87430714 \h 11
HYPERLINK \l "_Toc87430715" 2.1.3 DOC_ID Standard PAGEREF _Toc87430715 \h 14
HYPERLINK \l "_Toc87430716" 2.1.4 GAX AMS_DOC_EXPORT_XML_FILE root element attributes PAGEREF _Toc87430716 \h 14
HYPERLINK \l "_Toc87430717" 2.1.5 GAX AMS_DOCUMENT root element attributes PAGEREF _Toc87430717 \h 15
HYPERLINK \l "_Toc87430718" 2.1.6 GAX Document Component: ABS_DOC_HDR PAGEREF _Toc87430718 \h 16
HYPERLINK \l "_Toc87430719" 2.1.7 GAX Document Component: ABS_DOC_VEND PAGEREF _Toc87430719 \h 18
HYPERLINK \l "_Toc87430720" 2.1.8 GAX Document Component: ABS_DOC_ACTG PAGEREF _Toc87430720 \h 21
HYPERLINK \l "_Toc87430721" 2.1.9 Original Entry GAX Example PAGEREF _Toc87430721 \h 28
HYPERLINK \l "_Toc87430722" 2.1.10 Copy Book PAGEREF _Toc87430722 \h 32
HYPERLINK \l "_Toc87430723" 3. Valid Country Codes PAGEREF _Toc87430723 \h 42
Overview
Document Definitions and Naming Conventions
This section describes/defines the DTD naming conventions applied in this document.
Transaction Layout Definitions
Attribute The name of the data element in the database, as well as the name of the XML tag.
Caption The label on the User Interface that defines the data element.
Description A textual description of the data element.
R/C Required/Conditional. Required specifies that the data element is required by the interface for the transaction to successful submit. Conditional means that specified conditions must be adhere to by the interface for the transaction to successful submit. No value specifies that the data element is optional by the interface for the transaction to submit.
Type The data type of the data element.
VarChar Variable Character text. Alphanumeric data.
Byte Unsigned character.
Char Character. Fixed length alphanumeric text, required to meet the exact specified size.
Date Date Format YYYY-MM-DD
Decimal Numeric value with a specified decimal position (9,3) = 999999999.999
Boolean True/False. True conditions = true, False conditions = false.
Memo Alphanumeric Text with a maximum of 1500 characters.
Currency Numeric, with two decimal positions. Format 9999.99.
Integer Numeric value, a whole number.
Long - Numeric value, a long whole number.
Size The (numeric) size of the data element
MFASIS (ADV3.x) Notes Notes specific to the MFASIS (ADV3.x) data element.
CVL Coded Value List, the value of the data element must come from the CVL table specified in the MFASIS (ADV3.x) Notes.
MFASIS (ADV2.x) Derivation Notes Notes specific to translating MFASIS (ADV2.x) document layout data to MFASIS (ADV3.x).
D.TEXT Data element from the header or document section of the MFASIS (ADV2.x) document layout.
L.TEXT Data element from the line or detail section of the MFASIS (ADV2.x) document layout.
XML Definitions and Conventions
Root - The upgraded MFASIS XML file and document root declaration identify the required root elements that must be contained for the XML file or document (transaction) to load into MFASIS. The upgraded MFASIS XML file must contain a single root element that contains specified attributes, at the file level. Each document transaction contained within the XML file must also contain a root element that contains the specified attributes, at the document level.
Attributes - Attributes are name-value pairs that occur inside start-tags after the element name.
Elements - Elements are the most common form of markup. Delimited by angle brackets, most elements identify the nature of the content they surround. Elements normally begins with a start-tag, , and ends with an end-tag, .
CDATA Tags - In a document, CDATA instructs the parser to ignore (most) markup characters. Between the start of the section, , all character data is passed directly to the application, without interpretation. Elements, entity references, comments, and processing instructions are all unrecognized and the characters that comprise them are passed literally to the application.
Document Usage
Within the State of fb88 financial system, departments and external agencies generate payment requests directly in their own, independent, external systems. These systems interface PV (payment voucher) documents to MFASIS. At the current time only the creation of new documents is supported through document interface. Although the payment request processes delivered with Advantage 3.x support both original entry payments and payment modifications, the business rules at the State of fb88 do not allow agencies to submit payment modifications.
In the MFASIS Advantage 3 system, there are two types of payment request documents: Commodity-Based Payment Requests (PRCs) which are commodity-based documents and General Accounting Expenses/Expenditures (GAX) which are accounting based documents. These 2 types of documents must be sent in two separate interface files. GAXs are generated for existing non-commodity based encumbrances. Only one vendor line and maximum of 99 accounting lines are allowed on each interface GAX document. At the State of fb88, GAXs will be generated for payment vouchers produced by the agencies specified in section 2.1.1.
Parts of the General Accounting Expense/Expenditure Payment Request:
The General Accounting Expense/Expenditure Payment Request has 3 components. These components will be populated through the States PV interface:
Header - contains information common to all lines, such as date-of-record, budget fiscal year, accounting period, and bank account.
Vendor contains information specific to the vendor, such as discount terms, disbursement options, and address information.
Accounting Line Fields in this section include Event Type, Line Amount, Chart of Accounts fields that comprise a funding distribution, and additional reference information.
Logical Document Component Structure
The Payment has the following logical document structure:
Current Inbound PV Document Structure Advantage 3 GAX Document Structure
Publishable Specification
Transaction Layout: GAX
Action Code (OE)Component DescriptionDocument Component HYPERLINK \l "_RE_AMS_DOC_EXPORT_XML_FILE_root_ele" AMS_DOC_EXPORT_XML_FILERXML file root element. HYPERLINK \l "_AMS_DOCUMENT_root_element" AMS_DOCUMENTRDocument root element. HYPERLINK \l "_Document_Component:_PO_DOC_HDR" ABS_DOC_HDRRLists general information associated with the entire procurement. HYPERLINK \l "_Document_Component:_PO_DOC_VEND" ABS_DOC_VENDRLists selected Vendor for providing the goods/services. Vendors are selected from a pick list that is populated by the Vendor/Customer (VCUST) table. HYPERLINK \l "_Document_Component:_PO_DOC_ACTG" ABS_DOC_ACTGRLists the accounting funds for each accounting line.
R Required
CR Conditionally Required: Required only if modifying a field within that component
O Optional
NOTE: Every field listed in the following tables MUST be included in the XML script. For this purpose, null may be a valid value (see the XML sample attached).
Document Prefixes
In order to identify the interfaces by agency and type, the following codes have been assigned. References will be made to these codes throughout the mapping document:
External InterfaceAdvantage 2 Interface TypeDOC PrefixDocument Creator IDCOURTSWitness FeesPV type 8WITINTFWITIndigent DefensePV type 10INDINTFINDJuror PaymentsPV type QJURINTFJURDAFS/DFPSWCC Workers CompPV type 11WCCINTFWCCWCC Workers Comp MedicalPV type 12WCMINTFWCMDHHSChild Welfare PaymentsPV type GCHWINTFCHWMisc BillsPV type IMBLINTFMBLfb88 Care (Medicaid) PaymentsPV type PMCSINTFMCSDHHS Contract PaymentsPV type TCONINTFCONMEPOPS (Pharmacy Payments)PV type 13MEPINTFMEPDDS Development Disability ServicesPV type 5DDSINTFDDSDHHS (ACES)Aspire PaymentsPV type FASPINTFASPSSI / Personal NeedsPV type RSSIINTFSSINew Grants (Retro TANF)PV type SNWGINTFNWGTANF (Public Assistance)PV type UTNFINTFTNFDHHS(NECSES)NECSIS Child SupportPV type JNECINTFNECDOTnon-commodity paymentsPV type YDT2INTFDT2EDUCATIONEducation Construction Payments.PV type AECNINTFECNEducation Subsidies.PV type DESBINTFESBEducation School Lunch Payments.PV type EESLINTFESLEducation Local Entitlement Special EdPV Type CSPEINTFSPELABORLabor Rehab PaymentsPV type WLRPINTFLRPLEGISLATURELegislature PaymentsPV type 6LEGINTFLEGTAX (MRS)Indiv. Income Tax RefundsPV type BITRINTFITRMisc Tax RefundsPV type HMTRINTFMTRCorp Tax RefundsPV type KCTRINTFCTRGen'l Tax & Rent RefundsPV type LGTRINTFGTRBETR RefundsPV type MBETINTFBETSales/Use/Excise RefundsPV type NSUEINTFSUEWithholding Tax RefundsPV type VWTRINTFWTRTREASURY PVRevenue SharingPV type ORSHINTFRSHUnclaimed PropertyPV type 14UNPINTFUNP
Data Repository
A central repository will exist for each interface partner. The server location is momentum3.bis.state.me.us. Security permissions will be such that only the agency partner specified can access the file structure(s) assigned to them. Note: Advantage technical personnel and OIT systems personnel will have permission to access all folders.
Each agency will PUSH their Payment (GAX) files to corresponding inbound folder (see below). A copy of the file is automatically archived for historical purposes.
The directory structure will look like this:
momentum3.bis.state.me.usInbout\AccountCodemomentum3.bis.state.me.usInbout\Customermomentum3.bis.state.me.usInbout\Inbound\INTFASP\ASP0325GAX1.xml\ASP0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFBET\BET0325GAX1.xml\BET0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFCHW\CHW0325GAX1.xml\CHW0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFCON\CON0325GAX1.xml\CON0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFCTR\CTR0325GAX1.xml\CTR0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFDDS\DDS0325GAX1.xml\DDS0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFDT2\DT20325GAX1.xml\DT20325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFECN\ECN0325GAX1.xml\ECN0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFESB\ESB0325GAX1.xml\ESB0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFESL\ESL0325GAX1.xml\ESL0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFGTR\GTR0325GAX1.xml\GTR0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFIND\IND0325GAX1.xml\IND0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFITR\ITR0325GAX1.xml\ITR0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFJUR\JUR0325GAX1.xml\JUR0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFLEG\LEG0325GAX1.xml\LEG0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFLRP\LRP0325GAX1.xml\LRP0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFMBL\MBL0325GAX1.xml\MBL0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFMCS\MCS0325GAX1.xml\MCS0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFMTR\MTR0325GAX1.xml\MTR0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFNEC\NEC0325GAX1.xml\NEC0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFNWG\NWG0325GAX1.xml\NWG0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFRSH\RSH0325GAX1.xml\RSH0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFSSI\SSI0325GAX1.xml\SSI0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFSUE\SUE0325GAX1.xml\SUE0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFTNF\TNF0325GAX1.xml\TNF0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFUNP\UNP0325GAX1.xml\UNP0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFWCC\WCC0325GAX1.xml\WCC0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFWCM\WCM0325GAX1.xml\WCM0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFWIT\WIT0325GAX1.xml\WIT0325 GAX1.infmomentum3.bis.state.me.usInbout\Inbound\INTFWTR\WTR0325GAX1.xml\WTR0325 GAX1.infmomentum3.bis.state.me.usInbout\Outboundmomentum3.bis.state.me.usInbout\Vendor
**Agency Access and Read/Write Permissions
Each interface partner will have permission to write to their own inbound GAX interface folder.
DOC_ID Standard
PREFIX DATE SEQ AGENCY ID
NECMMDDYY1##########
The format of the DOC_ID is defined by the State of fb88. The format is:
PREFIX: 3-character document prefix such as NEC for NECSIS Child Support
DATE: 6-character date (mmddyy)
SEQ: 1-digit sequence number. Will always be set to 1
10 characters provided by agency to uniquely identify each of their documents
GAX AMS_DOC_EXPORT_XML_FILE root element attributes
AttributeCaption DescriptionR/CTypeSizeMFASIS (ADV3.x) NotesMFASIS (ADV2.x) Derivation NotesVERSIONVersion of the XML fileRVarCharDefault Value: 1
This field is required for documentation purpose does not have any impact on the interface.EXPORT_DATEExport date and time.RVarCharFormat :yyyy-mm-dd hh:mm:ss
Default Value: Current System date
This field is required for documentation purpose does not have any impact on the interface.
GAX AMS_DOCUMENT root element attributes
AttributeCaption DescriptionR/CTypeSizeMFASIS (ADV3.x) NotesMFASIS (ADV2.x) Derivation NotesDOC_CATDocument CategoryThe category in which the document is located. RVarChar8ABSDOC_TYPDocument TypeThe type of document, defined in the Document Type table. Each document code must be assigned a document type.RVarChar8ABSDOC_CDDocument CodeThe alpha-numeric identification code assigned to the document on the Document Control table. RVarChar8GAXDOC_DEPT_CDDepartment CodeThe department code assigned to this document.RVarChar4Must be valid in the DEPARTMENT table , i.e. R_DEPT.D.DOC-AGENCYDOC_UNIT_CDUnit CodeThe unit code associated with this document. RVarChar4May be used to determine a contact number printed on check stub. If not populated contact number is determined using DOC_DEPT_CD.
May be NULL, but field must be included.DOC_UNIT_CD must contain the Unit-Code from which the contact phone will be derivedDOC_IDDocument IdThe document ID to identify this document. RVarChar20Assigned by agency. See section 2.1.2.D.DOCUMENT_NUMBER
Use the first 10 characters.DOC_VERS_NODocument Version NumberThe version number assigned to this document. The version is incremented with each modification draft and after with a cancellation. RInteger1AUTO_DOC_NUMAutomatic document numbering is turned on.RInteger3falseDOC_IMPORT_MODEDocument Import ModeThe import mode determining the phase of the document on import. Will be set to OE for Original Entry.RVarChar4OE
GAX Document Component: ABS_DOC_HDR
ABS_DOC_HDRAttributeCaption DescriptionR/CTypeSizeMFASIS (ADV3.x) NotesMFASIS (ADV2.x) Derivation NotesDOC_CATThe category in which the document is located.RVarChar8Same as in AMS_DOCUMENTDOC_TYPThe type of document, defined in the Document Type table. Each document code must be assigned a document type.RVarChar8Same as in AMS_DOCUMENTDOC_CDThe alpha-numeric identification code assigned to the document on the Document Control table. Each document code must be unique within the application. The document code is a required field when creating a new document. It also may be selection criteria on a parameter table, a key to a specific business rule on a control table, or the document code recorded on a historical record.RVarChar8Same as in AMS_DOCUMENTDOC_DEPT_CDThe department code assigned to this document.RVarChar4DOC_UNIT_CDUnit CodeThe unit code associated with this document. RVarChar4Same as in AMS_DOCUMENTMay be used to determine a contact number printed on check stub. If not populated contact number is determined using DOC_DEPT_CD.DOC_IDThe document code and number that is either manually assigned or automatically generated by the system if you do not enter this information. The version number is assigned automatically. Duplicate document identification numbers are not allowed in the system.RVarChar20Same as in AMS_DOCUMENTDOC_VERS_NOThe version number assigned to this document. The version is incremented with each modification draft and after with a cancellation.RInteger10Same as in AMS_DOCUMENTDOC_CREA_USIDThe user identification code assigned by the system for the user creating this document.RVarChar20Unique id for each interface.
INTF + assigned interface prefix
E.g.: INTFNEC.DOC_UNIT_CDThe unit code associated with this document.RVarChar4Same as in AMS_DOCUMENTDOC_REC_DT_DCThe record date manually entered on the document header. If not manually entered, the date becomes the one when the document was submitted successfully.CDateyyyy-mm-ddD.YEAR+D.MONTH+D.DAYDOC_DSCRThe description associated with the document.OVarChar60"GAX Interface"DOC_NMName for the document.OVarChar60"GAX Interface"DEPT_CDAn identification code assigned to a central organizational level element where the decentralize structure is set. The department field may be used as an input field on a document, an additional key to another chart of account element, a selection criteria on a parameter table, a key to a specific business rule on a control table, a field to be inferred on a document, or the department value on a historical record.RVarChar4Must be valid in the DEPARTMENT table , i.e. R_DEPT.D.DOC-AGENCY
GAX Document Component: ABS_DOC_VEND
ABS_DOC_VENDAttributeCaption DescriptionR/CTypeSizeMFASIS (ADV3.x) NotesMFASIS (ADV2.x) Derivation NotesDOC_CATThe category in which the document is located.RInteger8Same as in AMS_DOCUMENTDOC_TYPThe type of document, defined in the Document Type table. Each document code must be assigned a document type.RInteger8Same as in AMS_DOCUMENTDOC_CDThe alpha-numeric identification code assigned to the document on the Document Control table. Each document code must be unique within the application. The document code is a required field when creating a new document. It also may be selection criteria on a parameter table, a key to a specific business rule on a control table, or the document code recorded on a historical record.RVarChar8Same as in AMS_DOCUMENTDOC_DEPT_CDThe department code assigned to this document.RVarChar4Same as in AMS_DOCUMENTDOC_IDThe document code and number that is either manually assigned or automatically generated by the system if you do not enter this information. The version number is assigned automatically. Duplicate document identification numbers are not allowed in the system.RVarChar20Same as in AMS_DOCUMENTDOC_VERS_NOThe version number assigned to this document. The version is incremented with each modification draft and after with a cancellation.RInteger10Same as in AMS_DOCUMENTDOC_VEND_LN_NOThe vendor line number visible to a user that uniquely identifies each vendor line within a document.RInteger101VEND_CUST_CDThe unique identifier assigned to the vendor/customer. In ADVANTAGE Financial, a vendor can also be a customer, allowing you to enter information only one time when a particular contact is both a vendor (payable) and a customer (receivable). On a GAX document, these will be all the vendors.RVarChar20New MFASIS Vendor/Customer Number. Through "crosswalk"
VC or VS + 10 charactersD.VENDOR_CODELGL_NMThe legally defined name of the company or individual represented by this record. The field is used for reporting if defined as not alias/DBA.CVarChar60Inferred from vendor unless misc. vendor specified then requiredD.VENDOR-NAMEAD_LN_1The first line of the address.CVarChar75Inferred from vendor unless misc. vendor specified then requiredD.VENDOR-ADD-LINE-1AD_LN_2The second line of the address.CVarChar75Inferred from vendor unless misc. vendor specified then requiredD.VENDOR-ADD-LINE-2CITYThe city name associated with the address.CVarChar60Inferred from vendor unless misc. vendor specified then requiredD.CITYSTThe state or province.CVarChar2Inferred from vendor unless misc. vendor specified then requiredD.STATEZIPThe zip code associated with the address.CVarChar10Inferred from vendor unless misc. vendor specified then requiredD.ZIP-CODECTRYThe country code associated with the address. Required if country in not US.CVarChar3Inferred from vendor unless misc. vendor specified. Required only if miscellaneous vendor address is not in US.Must be valid code. See section 3VEND_SNGL_CHK_FLIndicates if multiple disbursements should be combined into a single check for this vendor.CInteger3True/False
Translated by Advantage3 to 0 or 1IF D.SINGLE-CHECK-FLAG = 'Y' Then True Else FalseVEND_DISB_CATThe vendor/customer disbursement category associated with the document.CVarChar4Must be null or one of the following:D.CHECK-CATEGORYCSChild ServicesFORForeign AddressMRSMRS Tax RefundMRSFMRS Tax Refund with foreign addressesMSProvider ChecksTRTreasury PickupSCHED_PYMT_DTThe date that a vendor is scheduled to receive payment.ODateyyyy-mm-ddD.SCHED-PYMT+MONTH, D.SCHED-PYMT-DAY+
D.SCHED-PYMT-YEARDFLT_DISB_FRMTThe default disbursement format to be used when generating payments to this record. Will be pushed down to accounting lines when documents are submitted to Advantage..CVarChar4If interface partner is NECSES and this is an EFT transaction, then must be entered as CCDN.
If a paper check is requested for a EFT vendor, then the value must be entered as REG.
Otherwise omit or null.DISB_PRTY_CDDISB_PRTY_CD must be populated with 99 until further notice. Each interface agency partner will notified of the numeric change in the future.RInteger1099
GAX Document Component: ABS_DOC_ACTG
ABS_DOC_ACTGAttributeCaption DescriptionR/CTypeSizeMFASIS (ADV3.x) NotesMFASIS (ADV2.x) Derivation NotesDOC_CATThe category in which the document is located.RVarChar8Same as in AMS_DOCUMENTDOC_TYPThe type of document, defined in the Document Type table. Each document code must be assigned a document type.RVarChar8Same as in AMS_DOCUMENTDOC_CDThe alpha-numeric identification code assigned to the document on the Document Control table. Each document code must be unique within the application. The document code is a required field when creating a new document. It also may be selection criteria on a parameter table, a key to a specific business rule on a control table, or the document code recorded on a historical record.RVarChar8Same as in AMS_DOCUMENTDOC_DEPT_CDThe department code assigned to this document.RVarChar4Same as in AMS_DOCUMENTDOC_IDThe document code and number that is either manually assigned or automatically generated by the system if you do not enter this information. The version number is assigned automatically. Duplicate document identification numbers are not allowed in the system.RVarChar20Same as in AMS_DOCUMENTDOC_VERS_NOThe version number assigned to this document. The version is incremented with each modification draft and after with a cancellation.RInteger10Same as in AMS_DOCUMENTDOC_ACTG_LN_NOThe accounting line number visible to a user that uniquely identifies each accounting line within a document.RInteger10L.LINE-NODOC_VEND_LN_NOThe vendor line number visible to a user that uniquely identifies each vendor line within a document.RInteger10Same as in ABS_DOC_VENDLN_AMThe amount of an individual record of a document component, be it the header, vendor line, commodity line, accounting line, budget line, or allotment. The amount could also be the amount recorded to a table that tracks document updates such as the Statement Detail table or a journal.RCurrency14,2L.LINE-AMOUNTFUND_CDThe identification code associated with a fund record, which is an essential part of a governmental accounting system. Values may be entered as a chart of account element on a budget or accounting document. The Fund may also be used as selection criteria on an input parameter. The Fund may be entered to associate rules with a fund that are designated on other tables than the fund table. Lastly, it can be the fund recorded on a historical record.RVarChar4Must be valid in the FUND table, i.e. R_FUND.L.FUNDOBJ_CDThe identification code associated with an object of expenditure. Object is a fund accounting Chart of Accounts element. These codes can then be used to create expense budgets, track spending activity, trigger business rules, and serve as selection criteria for batch jobs.CVarChar4Must be valid in the OBJECT table, i.e. R_OBJ.
Required when event type is null.
L.OBJECTRSRC_CDRevenue sources are used to track individual sources of revenue taken in.CVarChar4Must be valid in the REVENUE SOURCES table, i.e. R_RSRC.
Required when event type is AP10.L.REVENUE-SOURCESRSRC_CDThe identification code associated with the sub-revenue source.OVarChar4Must be valid in the SUB REVENUE SOURCES table, i.e. R_SRSRC.L.SUB-REV-SOURCEBSA_CDThe identification code assigned to the balance sheet account. The balance sheet account code is the first level of six allowed rollups. The progression of the rollups is: Balance sheet account class, Balance sheet account category, Balance sheet account type, Balance sheet account group, Major balance sheet account group, and Minor balance sheet account group. Similar balance sheet accounts make a balance sheet account class, and similar balance sheet account classes make a balance sheet account category, and so on. The balance sheet account is always required; however the remainder of the hierarchy is optional with ADVANTAGE Financial.CVarChar4Must be valid in the BALANCE SHEET ACCOUNT table, i.e. R_BSA.
Asset account required when event type is AP18.
Liability account required when event type is AP17.
Equity account required when event type is AP16.L.BS-ACCOUNT
Asset = account type 01 Liability = account type 02 Equity = account type 03DEPT_CDAn identification code assigned to a central organizational level element where the decentralize structure is set. The department field may be used as an input field on a document, an additional key to another chart of account element, a selection criteria on a parameter table, a key to a specific business rule on a control table, a field to be inferred on a document, or the department value on a historical record.RVarChar4Must be valid in the DEPT table, i.e. R_DEPT.L.AGENCYUNIT_CDUnit is the lowest organizational level in the main organizational structure. Only sub unit is lower, but it is not necessarily required as unit is. At the unit level, all the organizational elements it reports to are defined so that they are inferred to accounting documents. Unit codes themselves can be values entered on budgeting and accounting documents, keys to business rule tables, and values seen in historical records.RVarChar4Must be valid in the UNIT table, i.e. R_SUNIT.L.APPROP-REPORT-ORGACTV_CDThe identification code associated with the activity. An activity is an internal program that you want to define for budgeting and/or reporting purposes. Activities can cut across agency and fund boundaries.OVarChar4Must be valid in the Activity table, i.e. R_ACTV.L.ACTIVITYFUNC_CDThe identification code associated with the function. The function code defines broad operational objectives, such as instruction, support services, and facilities acquisition.OVarChar10Must be valid in the Function table, i.e. R_FUNC.L.FUNCTIONDOBJ_CDThe identification code assigned to the Department object.OVarChar4Must be valid in the Department Object table, i.e. R_DOBJ.DRSRC_CDThe code assigned to the department revenue source.OVarChar4Must be valid in the Department Revenue Source table, i.e. R_DRSRCPROG_CDThe identification code assigned to the program. Program is a cost accounting Chart of Accounts element. The program field may be used as an input field on a document, a selection criteria on a parameter table, a key to a specific business rule on a control table, a field to be inferred on a document, or the program value on a historical record.OVarChar10Must be valid in the Program table, i.e. R_PROG.L.REPORTING-CATEGORY
PHASE_CDThe identification code assigned to the phase. Phase is a cost accounting Chart of Accounts element representing a phase of a program.OVarChar6Must be valid in the Phase table, i.e. R_PHASE.PPC_CDThe identification code assigned to the program period.OVarChar6Must be valid in the Program Period table, i.e. R_PPC.RPT_CDReporting codes give provides additional element on which to reportOVarChar10Must be valid reporting code on the R_RPT table.ACTG_LN_DSCRThe description associated with the line.OVarChar100L.DESCRIPTIONEVNT_TYP_IDThe alpha-numeric identification code assigned to an event type. Each event type ID must be unique within the application. It is required when completing any accounting or budgeting document with the exception of certain journal vouchers.CVarChar4Valid Values:
AP01 = Auth. Normal Payment
AP10 = Auth. ER Refund
AP16 = Equity Payout Auth.
AP17 = Liability Payout Auth.
AP18 = Asset Payout
Required for non-expenditure objects (MRS)SVC_FRM_DTService Dates (From/To Dates) on payment request documents are used to identify when goods or services were received from the vendor. RDateUsed to report on information for separate manual accrual. Used at fiscal YE (July & August)
As of 07/01/2008 this field is required.
yyyy-mm-ddSVC_TO_DTService Dates (From/To Dates) on payment request documents are used to identify when goods or services were received from the vendor.RDateUsed to report on information for separate manual accrual. Used at fiscal YE (July & August)
As of 07/01/2008 this field is required.
yyyy-mm-ddVEND_INV_NOThe invoice number from the invoice received from the vendor. The Vendor Invoice Number must be unique and cannot already exist on the Vendor Invoice Registry table for the referenced vendor. On the Scheduled Invoice Generation table, the Vendor Invoice Number is required when the Reconciling Period Indicator option is selected.RVarChar30Optional with Misc. vendor codes.
Interfaces not having invoice details may use DOC_ID of this GAX document.L.VENDOR-INVOICEVEND_INV_LN_NOThe invoice line number from the invoice received from the vendorRNumber10Must be a unique value within the document.
Interfaces not having invoice details may use DOC_ACTG_LN_NO.L.VENDOR-INV-LINE-NUMVEND_INV_DTThe date of the invoice received from the vendor.RDateFormat: yyyy-mm-dd
Interfaces not having invoice details may use DOC_REC_DT_DC from ABS_DOC_HDR section of this GAX document.SUNIT_CDSub Unit is a means of breaking down a unit code into smaller measurements. It is the lowest level of organizational structure.CVarChar4If BSA_CD is populated then this field is prohibited
Pass null when BSA_CD is populated.
Must be valid in the SUNIT table, i.e. R_SUNIT.First 2 digits of APPROP-UNITCHK_DSCRThe text to be printed on the check stub.CVarChar250Free-form textL.DESCRIPTION
or
CHECK-LINES from trailer records are concatenated and updated in the First Accounting line of each DocumentDISB_CATDisbursement CategoryOVarChar4L.CHECK-CATEGORY
Original Entry GAX Example
This example is for an Original Entry GAX with one vendor and two accounting lines.
< CTRY Attribute="Y"> CTRY >
DISB_PRTY_CD >
Copy Book
PV BATCH HEADER RECORD Record Length 396 Cols.
(used only by NECSES. Not included in mappings)
01 PV-BATCH-HEADER-RECORD.
03 DSF-KEY.
05 RECORD-TYPE PIC X(01) Value B. 1-1
05 PAGE-TYPE PIC X(01) Value Spaces. 2-2
05 BATCH-ID.
07 BATCH-TRANS-CODE PIC X(04) Value PV . 3-6
07 BATCH-AGENCY PIC X(04). (Your Agency code followed by a space.) 7-10
07 BATCH-NUMBER PIC X(06). (Assigned by Agency.) 11-16
05 FILLER PIC X(20) Value Spaces. 17-36
03 PV-BATH.
05 BATCH-TRANS-CODE PIC X(02) Value PV. 37-38
05 BATCH-CTL-AMOUNT PIC 9(12)V99. (Total amount of document header 39-52
amounts in batch.)
05 BATCH-NUMB PIC X(06). (Same as BATCH-NUMBER.) 53-58
05 BATCH-MONTH PIC X(02). (Month record was prepared.) 59-60
05 BATCH-DAY PIC X(02). (Day record was prepared.) 61-62
05 BATCH-YEAR PIC X(02). (Year record was prepared.) 63-64
05 BATCH-CTL-COUNT PIC 9(04). (Total number of document header 65-68
records in batch.)
05 FILLER PIC X(328) Value Spaces. 69-396
PV DOCUMENT HEADER RECORD Record Length 396 Cols.
01 PR-DOCUMENT-HEADER-RECORD.
03 DSF-KEY.
05 RECORD-TYPE PIC X(01) Value D. 1-1
05 PAGE-TYPE PIC X(01) Value Spaces. 2-2
05 BATCH-ID.
07 BATCH-TRANS-CODE PIC X(04). (Spaces if no batch record or PV .) 3-6
07 BATCH-AGENCY PIC X(04). (Spaces if no batch record or your 7-10
Agency code followed by a space.)
07 BATCH-NUMBER PIC X(06). (Spaces if no batch record or same as 11-16
BATCH-NUMBER in batch header record.)
05 DOC-ID.
07 DOC-TRANS-CODE PIC X(02) Value PV. 17-18
07 DOC-TRANS-CODE-UNUSED PIC X(02) Value Spaces. 19-20
07 DOC-AGENCY PIC X(03). (Your Agency code.) 21-23
07 DOC-AGENCY-UNUSED PIC X(01) Value Spaces. 24-24
07 DOC-NUMBER PIC X(11). (Assigned by Agency.) 25-35
07 DOC-NUMBER-UNUSED PIC X(01) Value Spaces. 36-36
03 PV-DOCH.
05 TRANS-ID.
07 TRANS-CODE PIC X(02). PV 37-38
07 TRANS-AGENCY-NUMBER.
09 TRANS-AGENCY PIC X(03). (Same as DOC-AGENCY.) 39-41
09 TRANS-NUMBER PIC X(11). (Same as DOC-NUMBER.) 42-52
05 RECORD-DATE.
05 RECORD-MONTH PIC X(02). (Month record was prepared or spaces.) 53-54
05 RECORD-DAY PIC X(02). (Day record was prepared or spaces.) 55-56
05 RECORD-YEAR PIC X(02). (Year record was prepared or spaces.) 57-58
05 FISCAL-MONTH PIC X(02) Value Spaces. 59-60
05 FISCAL-YEAR PIC X(02) Value Spaces. 61-62
05 BUDGET-FY PIC X(02) Value Spaces. 63-64
05 DOCUMENT-ACTION PIC X(01) Value Spaces. 65-65
05 TYPE-OF-VOUCHER PIC X(01). (Voucher Type assigned for payment. If this 66-66
is a numeric external, enter 1. If this
is an alphabetic external, enter the
assigned letter, A-Z.)
05 SCHED-PYMT-MONTH PIC X(02). (Filled in by Agency.) 67-68
05 SCHED-PYMT-DAY PIC X(02). (Filled in by Agency.) 69-70
05 SCHED-PYMT-YEAR PIC X(02). (Filled in by Agency.) 71-72
05 OFFSET-LIAB-ACCT PIC X(04) Value Spaces. 73-76
05 VENDOR-CODE PIC X(11). (Vendor Code of Payee or Misc Vendor.) 77-87
05 CHECK-CATEGORY PIC X(02). (Filled in by Agency in accordance 88-89
with Accounts & Control.)
05 SINGLE-CHECK-FLAG PIC X(01) Value Y. 90-90
05 FIXED-ASSETS-IND PIC X(01) Value Spaces. 91-91
05 DOCUMENT-TOTAL PIC X(14). (Total amount of document.) 92-105
05 VENDOR-NAME PIC X(30). (Fill if Misc Vendor is coded.) 106-135
05 VENDOR-ADD-LINE-1 PIC X(30). (Fill if Misc Vendor is coded.) 136-165
05 VENDOR-ADD-LINE-2 PIC X(30). (Fill if Misc Vendor is coded.) 166-195
05 VENDOR-ADD-LINE-3.
07 CITY PIC X(18). (Fill if Misc Vendor is coded.) 196-213
07 STATE PIC X(02). (Fill if Misc Vendor is coded.) 214-215
07 ZIP-CODE PIC X(10). (Fill if Misc Vendor is coded.) 216-225
05 OFFSET-REC-ACCT PIC X(04) Value Spaces. 226-229
05 SELLER-FUND PIC X(04) Value Spaces. 230-233
05 SELLER-AGENCY PIC X(03) Value Spaces. 234-236
05 SELLER-ORGANIZATION PIC X(04) Value Spaces. 237-240
05 SELLER-SUB-ORG PIC X(02) Value Spaces. 241-242
05 SELLER-ACTIVITY PIC X(04) Value Spaces. 243-246
05 SELLER-REV-SOURCE PIC X(04) Value Spaces. 247-250
05 SELLER-SUB-REV PIC X(02) Value Spaces. 251-252
05 SELLER-JOB.
07 SELLER-JOB-NUMBER-E PIC X(04) Value Spaces. 253-256
07 SELLER-FUNCTION PIC X(04) Value Spaces. 257-260
05 SELLER-REPT-CAT PIC X(04) Value Spaces. 261-264
05 SELLER-OBJECT PIC X(04) Value Spaces. 265-268
05 SELLER-SUB-OBJECT PIC X(02) Value Spaces. 269-270
05 SELLER-BS-ACCOUNT PIC X(04) Value Spaces. 271-274
05 ACTUAL-DOC-TOTAL PIC X(14) Value Spaces. 275-288
05 SELLER-APPR-UNIT PIC X(09) Value Spaces. 289-297
05 SELLER-FUNCTION PIC X(04) Value Spaces. 298-301
05 ACTLINE-AGENCY PIC X(03) Value Spaces. 302-304
05 CX-TYPE-4-FLAG PIC X(01) Value Spaces. 305-305
05 HEADER-TAX-CODE PIC X(03) Value Spaces. 306-308
05 USE-TAX-AMOUNT PIC X(14) Value Spaces. 309-322
05 EFT-IND PIC X(01) Value Spaces. 323-323
05 APPLICATION-TYPE PIC X(02) Value Spaces. 324-325
05 FREIGHT-IND PIC X(01) Value Spaces. 326-326
05 FREIGHT-TOTAL PIC X(14) Value Spaces. 327-340
05 FREIGHT-TOTAL-I-D PIC X(01) Value Spaces. 341-341
05 TOTAL-QUANTITY PIC X(12) Value Spaces. 342-353
05 TOTAL-QUANTITY-I-D PIC X(01) Value Spaces. 354-354
05 TOTAL-AMOUNT PIC X(14) Value Spaces. 355-368
05 TOTAL-AMOUNT-I-D PIC X(01) Value Spaces. 369-369
05 CALC-TOTAL-QUANTITY PIC X(12) Value Spaces. 370-381
05 CALC-TOTAL-AMOUNT PIC X(14) Value Spaces. 382-395
05 ACCRUAL-IND PIC X(01) Value N, A, or Spaces. N or A if PV 396-396
is dated in July or August.
A indicates the product or
service was received in the
previous fiscal year.)
PV DOCUMENT LINE RECORD Record Length 396 Cols.
01 PR-DOCUMENT-LINE-RECORD.
03 DSF-KEY.
05 RECORD-TYPE PIC X(01) Value L. 1-1
05 PAGE-TYPE PIC X(01) Value Spaces. 2-2
05 BATCH-ID.
07 BATCH-TRANS-CODE PIC X(04). (Spaces if no batch record or PV .) 3-6
07 BATCH-AGENCY PIC X(04). (Spaces if no batch record or your 7-10
Agency code followed by a space.)
07 BATCH-NUMBER PIC X(06). (Spaces if no batch record or same as 11-16
batch number in batch header record.)
05 DOC-ID.
07 DOC-TRANS-CODE PIC X(02) Value PV. 17-18
07 DOC-TRANS-CODE-UNUSED PIC X(02) Value Spaces. 19-20
07 DOC-AGENCY PIC X(03). (Same as DOC-AGENCY in header record.) 21-23
07 DOC-AGENCY-UNUSED PIC X(01) Value Spaces. 24-24
07 DOC-NUMBER PIC X(11). (Same as DOC-NUMBER in header record.) 25-35
07 DOC-NUMBER-UNUSED PIC X(01) Value Spaces. 36-36
03 PV-DOCD.
05 LINE-NO PIC X(02). (Assigned by Agency.) 37-38
05 REF-TRANS-CODE PIC X(02) Value Spaces. 39-40
05 REF-TRANS-NUMBER.
07 REF-TRANS-NUMBER-AGY PIC X(03) Value Spaces. 41-43
07 REF-TRANS-NUMBER-NUM PIC X(11) Value Spaces. 44-54
05 REF-TRANS-LINE PIC X(02) Value Spaces. 55-56
05 VENDOR-INVOICE PIC X(12). (Filled in by Agency.) 57-68
05 FUND PIC X(04). (Filled in by Agency.) 69-72
05 AGENCY PIC X(03). (Filled in by Agency.) 73-75
05 APPROP-REPORT-ORG PIC X(04). (Filled in by Agency.) 76-79
05 SUB-ORG PIC X(02). (Filled in by Agency.) 80-81
05 ACTIVITY PIC X(04). (Filled in by Agency.) 82-85
05 OBJECT PIC X(04). (Filled in by Agency.) 86-89
05 SUB-OBJECT PIC X(02). (Filled in by Agency.) 90-91
05 REVENUE-SOURCE PIC X(04). (Filled in by Agency.) 92-95
05 SUB-REV-SOURCE PIC X(02). (Filled in by Agency.) 96-97
05 JOB-NUMBER.
07 JOB-NUMBER-E PIC X(04). (Filled in by Agency.) 98-101
07 FUNCTION PIC X(04). (Filled in by Agency.) 102-105
05 REPORTING-CATEGORY PIC X(04). (Filled in by Agency.) 106-109
05 BS-ACCOUNT PIC X(04). (Filled in by Agency.) 110-113
05 DISCOUNT-TYPE PIC X(01) Value Spaces. 114-114
05 LINE-DESCRIPTION.
07 DESCRIPTION PIC X(27). (Filled in by Agency.) 115-141
07 PC-LINE-NUMBER PIC X(03) Value Spaces. 142-144
05 EPS-AMOUNT PIC X(14) Value Spaces. 145-158
05 LINE-AMOUNT-I-D PIC X(01). (Space if Line-Amount is > or = zero; D 159-159
for decrease if Line-Amount is < zero.)
05 PARTIAL-FINAL-IND PIC X(01) Value Spaces. 160-160
05 QUANTITY PIC X(12). (Filled in by Agency.) 161-172
05 APPROP-UNIT PIC X(09). (Filled in by Agency.) 173-181
05 FUNCTION PIC X(04). (Filled in by Agency.) 182-185
05 EPPV-ERROR-MSG PIC X(01) Value Spaces. 186-186
05 LINE-TAX-CODE PIC X(03) Value Spaces. 187-189
05 ADJUSTMENT-AMOUNT PIC X(14) Value Spaces. 190-203
05 LINE-AMOUNT PIC X(14). (Amount for the line.) 204-217
05 VENDOR-INV-LINE-NUM PIC X(03) Value Spaces. 218-220
05 QUANTITY-INC-DEC PIC X(01) Value Spaces. 221-221
05 FREIGHT-AMOUNT PIC X(14) Value Spaces. 222-235
05 FREIGHT-AMOUNT-I-D PIC X(01) Value Spaces. 236-236
05 FILLER-2 PIC X(160) Value Spaces. 237-396
PV TRAILER RECORD 1 (Not preferred) Record Length 864 Cols.
This record is expanded to a length of 6859 before it is loaded into the trailer VSAM file. This is done in MFA210. The external types which still submit this format are A, C, D, E, O, P, Q, and Z.
01 PV-DOCUMENT-TRAILER-RECORD-1.
03 DOCUMENT-ID
05 DOCUMENT-TYPE PIC X(02) Value PV. 1-2
05 DOCUMENT-AGENCY PIC X(03). (Your Agency Code.) 3-5
05 DOCUMENT-NUMBER PIC X(11). (Same as DOC-NUMBER from Header Record.) 6-16
03 RECORD-TYPE-1 PIC X(02) Value 01. 17-18
03 CHECK-WRITTEN-FLAG PIC X(01) Value Spaces. 19-19
03 COMMENT-LINE-1 PIC X(65). (Filled in by Agency.) 20-84
03 COMMENT-LINE-2 PIC X(65). (Filled in by Agency.) 85-149
03 COMMENT-LINE-3 PIC X(65). (Filled in by Agency.) 150-214
03 COMMENT-LINE-4 PIC X(65). (Filled in by Agency.) 215-279
03 COMMENT-LINE-5 PIC X(65). (Filled in by Agency.) 280-344
03 COMMENT-LINE-6 PIC X(65). (Filled in by Agency.) 345-409
03 COMMENT-LINE-7 PIC X(65). (Filled in by Agency.) 410-474
03 COMMENT-LINE-8 PIC X(65). (Filled in by Agency.) 475-539
03 COMMENT-LINE-9 PIC X(65). (Filled in by Agency.) 540-604
03 COMMENT-LINE-10 PIC X(65). (Filled in by Agency.) 605-669
03 COMMENT-LINE-11 PIC X(65). (Filled in by Agency.) 670-734
03 COMMENT-LINE-12 PIC X(65). (Filled in by Agency.) 735-799
03 COMMENT-LINE-13 PIC X(65). (Filled in by Agency.) 800-864
PV TRAILER RECORD 2 (Preferred) Record Length 6859 Cols.
This is a columnar format.
01 PV-DOCUMENT-TRAILER-RECORD-2.
03 DOCUMENT-ID
05 DOCUMENT-TYPE PIC X(02) Value PV. 1-2
05 DOCUMENT-AGENCY PIC X(03). (Your Agency Code.) 3-5
05 DOCUMENT-NUMBER PIC X(11). (Same as DOC-NUMBER from Header Record.) 6-16
03 RECORD-TYPE-2 PIC X(02) Value 02. 17-18
03 CHECK-WRITTEN-FLAG PIC X(01) Value Spaces. 19-19
03 MAIN-TITLE PIC X(30). (Filled in by Agency.) 20-49
03 STUB-LINE-1 PIC X(12). (Filled in by Agency.) 50-61
03 STUB-LINE-2 PIC X(12). (Filled in by Agency.) 62-73
03 STUB-LINE-3 PIC X(12). (Filled in by Agency.) 74-85
03 STUB-LINE-4 PIC X(12). (Filled in by Agency.) 86-97
03 STUB-LINE-5 PIC X(12). (Filled in by Agency.) 98-109
03 STUB-LINE-6 PIC X(12). (Filled in by Agency.) 110-121
03 STUB-LINE-7 PIC X(12). (Filled in by Agency.) 122-133
03 STUB-LINE-8 PIC X(12). (Filled in by Agency.) 134-145
03 STUB-LINE-9 PIC X(12). (Filled in by Agency.) 146-157
03 STUB-LINE-10 PIC X(12). (Filled in by Agency.) 158-169
03 STUB-LINE-11 PIC X(12). (Filled in by Agency.) 170-181
03 STUB-LINE-12 PIC X(12). (Filled in by Agency.) 182-193
03 ID-NUMBER PIC X(09). (Filled in by Agency.) 194-202
03 FILLER PIC X(6657) Value Spaces. 203-6859
PV TRAILER RECORD 3 (Preferred) Record Length 6859 Cols.
This is a textual format.
01 PV-DOCUMENT-TRAILER-RECORD-3.
03 DOCUMENT-ID
05 DOCUMENT-TYPE PIC X(02) Value PV. 1-2
05 DOCUMENT-AGENCY PIC X(03). (Your Agency Code.) 3-5
05 DOCUMENT-NUMBER PIC X(11). (Same as DOC-NUMBER from Header Record.) 6-16
03 RECORD-TYPE-3 PIC X(02) Value 03. 17-18
03 CHECK-WRITTEN-FLAG PIC X(01) Value Spaces. 19-19
03 STUB-LINE-1 PIC X(120). (Filled in by Agency.) 20-139
03 STUB-LINE-2 PIC X(120). (Filled in by Agency.) 140-259
03 STUB-LINE-3 PIC X(120). (Filled in by Agency.) 260-379
03 STUB-LINE-4 PIC X(120). (Filled in by Agency.) 380-499
03 STUB-LINE-5 PIC X(120). (Filled in by Agency.) 500-619
03 STUB-LINE-6 PIC X(120). (Filled in by Agency.) 620-739
03 STUB-LINE-7 PIC X(120). (Filled in by Agency.) 740-859
03 STUB-LINE-8 PIC X(120). (Filled in by Agency.) 860-979
03 STUB-LINE-9 PIC X(120). (Filled in by Agency.) 980-1099
03 STUB-LINE-10 PIC X(120). (Filled in by Agency.) 1100-1219
03 STUB-LINE-11 PIC X(120). (Filled in by Agency.) 1220-1339
03 STUB-LINE-12 PIC X(120). (Filled in by Agency.) 1340-1459
03 STUB-LINE-13 PIC X(120). (Filled in by Agency.) 1460-1579
03 STUB-LINE-14 PIC X(120). (Filled in by Agency.) 1580-1699
03 STUB-LINE-15 PIC X(120). (Filled in by Agency.) 1700-1819
03 STUB-LINE-16 PIC X(120). (Filled in by Agency.) 1820-1939
03 STUB-LINE-17 PIC X(120). (Filled in by Agency.) 1940-2059
03 STUB-LINE-18 PIC X(120). (Filled in by Agency.) 2060-2179
03 STUB-LINE-19 PIC X(120). (Filled in by Agency.) 2180-2299
03 STUB-LINE-20 PIC X(120). (Filled in by Agency.) 2300-2419
03 STUB-LINE-21 PIC X(120). (Filled in by Agency.) 2420-2539
03 STUB-LINE-22 PIC X(120). (Filled in by Agency.) 2540-2659
03 STUB-LINE-23 PIC X(120). (Filled in by Agency.) 2660-2779
03 STUB-LINE-24 PIC X(120). (Filled in by Agency.) 2780-2899
03 STUB-LINE-25 PIC X(120). (Filled in by Agency.) 2900-3019
03 STUB-LINE-26 PIC X(120). (Filled in by Agency.) 3020-3139
03 STUB-LINE-27 PIC X(120). (Filled in by Agency.) 3140-3259
03 STUB-LINE-28 PIC X(120). (Filled in by Agency.) 3260-3379
03 STUB-LINE-29 PIC X(120). (Filled in by Agency.) 3380-3499
03 STUB-LINE-30 PIC X(120). (Filled in by Agency.) 3500-3619
03 STUB-LINE-31 PIC X(120). (Filled in by Agency.) 3620-3739
03 STUB-LINE-32 PIC X(120). (Filled in by Agency.) 3740-3859
03 STUB-LINE-33 PIC X(120). (Filled in by Agency.) 3860-3979
03 STUB-LINE-34 PIC X(120). (Filled in by Agency.) 3980-4099
03 STUB-LINE-35 PIC X(120). (Filled in by Agency.) 4100-4219
03 STUB-LINE-36 PIC X(120). (Filled in by Agency.) 4220-4339
03 STUB-LINE-37 PIC X(120). (Filled in by Agency.) 4340-4459
03 STUB-LINE-38 PIC X(120). (Filled in by Agency.) 4460-4579
03 STUB-LINE-39 PIC X(120). (Filled in by Agency.) 4580-4699
03 STUB-LINE-40 PIC X(120). (Filled in by Agency.) 4700-4819
03 STUB-LINE-41 PIC X(120). (Filled in by Agency.) 4820-4939
03 STUB-LINE-42 PIC X(120). (Filled in by Agency.) 4940-5059
03 STUB-LINE-43 PIC X(120). (Filled in by Agency.) 5060-5179
03 STUB-LINE-44 PIC X(120). (Filled in by Agency.) 5180-5299
03 STUB-LINE-45 PIC X(120). (Filled in by Agency.) 5300-5419
03 STUB-LINE-46 PIC X(120). (Filled in by Agency.) 5420-5539
03 STUB-LINE-47 PIC X(120). (Filled in by Agency.) 5540-5659
03 STUB-LINE-48 PIC X(120). (Filled in by Agency.) 5660-5779
03 STUB-LINE-49 PIC X(120). (Filled in by Agency.) 5780-5899
03 STUB-LINE-50 PIC X(120). (Filled in by Agency.) 5900-6019
03 STUB-LINE-51 PIC X(120). (Filled in by Agency.) 6020-6139
03 STUB-LINE-52 PIC X(120). (Filled in by Agency.) 6140-6259
03 STUB-LINE-53 PIC X(120). (Filled in by Agency.) 6260-6379
03 STUB-LINE-54 PIC X(120). (Filled in by Agency.) 6380-6499
03 STUB-LINE-55 PIC X(120). (Filled in by Agency.) 6500-6619
03 STUB-LINE-56 PIC X(120). (Filled in by Agency.) 6620-6739
03 STUB-LINE-57 PIC X(120). (Filled in by Agency.) 6740-6859
PV TRAILER RECORD 3 (NECSES) Record Length 6859 Cols.
This is a special format specifically for NECSES ACH PVs (external type J.) This data is in an EDI format and is used to create the ACH addenda records for NECSES ACH payments.
01 TRAILER-RECORD-3.
03 DOCUMENT-TYPE PIC X(02) Value PV. 1-2
03 DOCUMENT-AGENCY PIC X(03). (Your Agency Code.) 3-5
03 DOCUMENT-NUMBER PIC X(11). (Same as DOC-NUMBER from Header Record.) 6-16
03 RECORD-TYPE-3 PIC X(02) Value 03. 17-18
03 CHECK-WRITTEN-FLAG PIC X(01) Value Spaces. 19-19
03 STUB-LINE-3 OCCURS 57 TIMES.
05 PRIMARY-79.
07 DED-SEGMENT-ID PIC X(03).
07 SEPARATOR-1 PIC X(01).
07 DED-APP-ID PIC X(02).
07 SEPARATOR-2 PIC X(01).
07 DED-CASE-IDENT PIC X(20).
07 SEPARATOR-3 PIC X(01).
07 DED-PAY-DATE.
10 DED-PAY-YY PIC X(02).
10 DED-PAY-MM PIC X(02).
10 DED-PAY-DD PIC X(02).
07 SEPARATOR-4 PIC X(01).
07 DED-PAY-AMT PIC X(10).
07 SEPARATOR-5 PIC X(01).
07 DED-NCP-SSN PIC X(09).
07 SEPARATOR-6 PIC X(01).
07 DED-MED-SUPPORT PIC X(01).
07 SEPARATOR-7 PIC X(01).
07 DED-NCP-NAME PIC X(10).
07 SEPARATOR-8 PIC X(01).
07 DED-FIPS-CODE PIC X(07).
07 SEPARATOR-9 PIC X(01).
07 DED-EMP-TERM PIC X(01).
07 DED-END-FLAG PIC X(01).
05 DED-FILLER PIC X(41).
Valid Country Codes
For Miscellaneous Vendors with international addresses (Country not US), a valid country code must be entered. State and Zip should also be entered to assist the postal services with deliveries. Below is a list of 240 countries with their corresponding country codes.
Country Name (alphabetical listing)Advantage 3 Country CodeAfghanistan AFAland Islands AXAlbania ALAlgeria DZAmerican Samoa ASAndorra ADAngola AOAnguilla AIAntarctica AQAntigua And Barbuda AGArgentina ARArmenia AMAruba AWAustralia AUAustria ATAzerbaijan AZBahamas BSBahrain BHBangladesh BDBarbados BBBelarus BYBelgium BEBelize BZBenin BJBermuda BMBhutan BTBolivia BOBosnia And Herzegovina BABotswana BWBouvet Island BVBrazil BRBritish Indian Ocean Territory IOBrunei Darussalam BNBulgaria BGBurkina Faso BFBurundi BICambodia KHCameroon CMCanada CACape Verde CVCayman Islands KYCentral African Republic CFChad TDChile CLChina CNChristmas Island CXCocos (Keeling) Islands CCColombia COComoros KMCongo CGCongo, The Democratic Republic Of The CDCook Islands CKCosta Rica CRCote D'ivoire CICroatia HRCuba CUCyprus CYCzech Republic CZDenmark DKDjibouti DJDominica DMDominican Republic DOEcuador ECEgypt EGEl Salvador SVEquatorial Guinea GQEritrea EREstonia EEEthiopia ETFalkland Islands (Malvinas) FKFaroe Islands FOFiji FJFinland FIFrance FRFrench Guiana GFFrench Polynesia PFFrench Southern Territories TFGabon GAGambia GMGeorgia GEGermany DEGhana GHGibraltar GIGreece GRGreenland GLGrenada GDGuadeloupe GPGuam GUGuatemala GTGuinea GNGuinea-Bissau GWGuyana GYHaiti HTHeard Island And Mcdonald Islands HMHoly See (Vatican City State) VAHonduras HNHong Kong HKHungary HUIceland ISIndia INIndonesia IDIran, Islamic Republic Of IRIraq IQIreland IEIsrael ILItaly ITJamaica JMJapan JPJordan JOKazakhstan KZKenya KEKiribati KIKorea, Democratic People's Republic Of KPKorea, Republic Of KRKuwait KWKyrgyzstan KGLao People's Democratic Republic LALatvia LVLebanon LBLesotho LSLiberia LRLibyan Arab Jamahiriya LYLiechtenstein LILithuania LTLuxembourg LUMacao MOMacedonia, The Former Yugoslav Republic Of MKMadagascar MGMalawi MWMalaysia MYMaldives MVMali MLMalta MTMarshall Islands MHMartinique MQMauritania MRMauritius MUMayotte YTMexico MXMicronesia, Federated States Of FMMoldova, Republic Of MDMonaco MCMongolia MNMontserrat MSMorocco MAMozambique MZMyanmar MMNamibia NANauru NRNepal NPNetherlands NLNetherlands Antilles ANNew Caledonia NCNew Zealand NZNicaragua NINiger NENigeria NGNiue NUNorfolk Island NFNorthern Mariana Islands MPNorway NOOman OMPakistan PKPalau PWPalestinian Territory, Occupied PSPanama PAPapua New Guinea PGParaguay PYPeru PEPhilippines PHPitcairn PNPoland PLPortugal PTPuerto Rico PRQatar QAReunion RERomania RORussian Federation RURwanda RWSaint Helena SHSaint Kitts And Nevis KNSaint Lucia LCSaint Pierre And Miquelon PMSaint Vincent And The Grenadines VCSamoa WSSan Marino SMSao Tome And Principe STSaudi Arabia SASenegal SNSerbia And Montenegro CSSeychelles SCSierra Leone SLSingapore SGSlovakia SKSlovenia SISolomon Islands SBSomalia SOSouth Africa ZASouth Georgia And The South Sandwich Island GSSpain ESSri Lanka LKSudan SDSuriname SRSvalbard And Jan Mayen SJSwaziland SZSweden SESwitzerland CHSyrian Arab Republic SYTaiwan, Province Of China TWTajikistan TJTanzania, United Republic Of TZThailand THTimor-Leste TLTogo TGTokelau TKTonga TOTrinidad And Tobago TTTunisia TNTurkey TRTurkmenistan TMTurks And Caicos Islands TCTuvalu TVUganda UGUkraine UAUnited Arab Emirates AEUnited Kingdom GBUnited States USUnited States Minor Outlying Islands UMUruguay UYUzbekistan UZVanuatu VUVenezuela VEViet Nam VNVirgin Islands, British VGVirgin Islands, U.S. VIWallis And Futuna WFWestern Sahara EHYemen YEZambia ZMZimbabwe ZW
PAGE
Page PAGE 1 of NUMPAGES 48
FILENAME MFASIS-GAX-GSD-03-21-2008.doc
SOW4 Deliverable DSD TitleDSD AuthorNewMMARS Detailed Interface DesignDateReq. Pro X-RefVersionStatusParent Interface GSD TitleGSD Author4/11/03TBD1.0In Progress
IC-02 Interface Offline Process Model (Version 2.0 DRAFT: 4/11/03) PAGE 1
PV-DOCUMENT-HEADER-RECORD
Document Header
Vendor
PV-DOCUMENT-LINE-RECORD
Accounting
: ; D P |
% . 6 = > B C P Y
2
3
;
=
! " / 8 U V ·h7[ hd} h_> hd} hd} OJ QJ ^J hd} hd} mHsH hd} 5\mHsH hd} 56OJ QJ \mHsHhd} 56OJ QJ \hS(p 5\ hS(p 56OJ QJ \hS(p OJ QJ hS(p 6]: : ; D P | r n kd $$If H 2 2 @
0 2 4
H aH p
$ d $If a$ gdS(p d gdS(p d gdS(p
7 ) ) d <