Interface to AP Formats

Note: All of the interfaces described in this section except the DTI Standard format require a separate license fee to use. Contact the Newscycle Support Center for more information.

File type:

• The DTI Standard format is space delimited, with non-numeric fields in double quotes.

• Compu-Share, Lawson, Dunn and Bradstreet, and PeopleSoft formats are fixed length.

• The Great Plains format is comma-delimited, with each value (including the field names), enclosed in quotation marks.

Location:

/dti/exchange/cm/secure/apcheck.d. If credits are exported via Midmonth Pmt Export, the file name will be /dti/exchange/cm/secure/midmonthpmtMMDD, where “MMDD” are the month and day of the due date entered. If Misc. Charges Export exports the credits, the file name will be /dti/exchange/cm/secure/misccredsMMDD.

Note:

• The default file name for the AP interface file is apcheck.d. The Business Rule— “What is the default name for the credit balance file?” (Account Finance section) allows you to change this default.

• Circulation will append apcheck.d each time you run the Interface to AP. You should rename this file or move it to a different location to avoid interfacing duplicate transactions.

DTI Standard Format

Field
Carrier vendor company ID
Carrier vendor ID
Credit balance amount
Invoice date
Carrier Social Security #
Carrier ID
Vendor Payment Method

Sample Output

“001” “0250” 34.10 “04/10/96” “501-77- 7010” “4C4” “office”

The interface also creates a vendor file (apvendchk.d or midmonthvnd<mmdd>) in the /dti/exchange/cm directory. This file can be used to create vendor information in Accounts Payable. The format is space delimited with non-numeric fields in double quotes.

Field	Sample Output
Carrier vendor company ID	“001”
Carrier vendor ID	“0250”
Carrier last name	“Wilson”
Carrier first name	“Kari”
Carrier social security #	“501-77-7010”
Carrier home area code	“612”
Carrier home phone #	“6390121”
Carrier address (4 lines)	“2833 Fairview Ave N” “Roseville, MN 55113” “ “ “ “
Carrier city	“Roseville”
Carrier state	“MN”
Carrier ZIP	“55107”

Compu-Share Format

Record	Length	Description
Invoice Record	1	Record type (will always be I)
	10	Vendor code (will always be “CARREF” for carrier credits and “PIAREFUND” for subscriber refunds, with the remaining spaces blank)
	14	Invoice code (8 character carrier account ID followed by 6 blanks)
	10	PO Number (blank)
	8	Invoice date (formatted yyyymmdd)
	14	Invoice amount (10 integer, 1 for decimal point, 2 for decimals, 1 for minus)
	14	Invoice discount (blank)
	14	Report Amount (blank)
	2	Terms code entered in INTERFACE TO AP
	30	Invoice description (blank)
	8	COA date (same as invoice date)
	8	Due date 1 (due date entered in INTERFACE TO AP)
	8	Due date 2 (zero filled)
	8	Due date 3 (zero filled
	8	Due date 4 (zero filled)
	6	Discount percentage 1 (blank)
	6	Discount percentage 2(blank)
	6	Discount percentage 3(blank)
	6	Discount percentage 4 (blank)
	14	Discount amount 1 (blank)
	14	Discount amount 2 (blank)
	14	Discount amount 3 (blank)
	14	Discount amount 4 (blank)
	1	Invoice hold (will always be N)
	61	Blank
Account Record (1)	1	Record type (will always be A)
	19	Segment name (will always be MAIN)
	12	Component code (first 4 characters of liability account entered in INTERFACE TO AP)
	267	Blank
Account Record (2)	1	Record type (will always be A)
	19	Segment name (will always be DEPT)
	12	Component code (next 3 characters of liability account)
	267	Blank
Account Record (3)	1	Record type (will always be A)
	19	Segment name (will always be DIV)
	12	Component code (last 2 characters of liability account)
	267	Blank
Account Record (4)	1	Record type (will always be A)
	19	Segment name (will always be LEDGER)
	12	Component code (will always be A)
	267	Blank
Vendor Record	1	Record type (will always be a V
	40	Misc name (carrier first name, last name) followed by a comma
	40	Delivery address line 1
	40	Delivery address line 2
	25	City ID
	2	State ID
	10	ZIP Code
	141	Blank
Distribution Record	1	Record type (will always be D)
	14	Amount distributed (same as invoice amount)
	284	Blank
Account Record	1	Record type (will always be A)
	19	Segment name (will always be MAIN)
	12	Component code (first 4 characters of clearing account entered in INTERFACE TO AP)
	267	Blank
Account Record (2)	1	Record type (will always be A)
	19	Segment name (will always be DEPT)
	12	Component code (next 3 characters of clearing account)
	267	Blank
Account Record (3)	1	Record type (will always be A)
	19	Segment name (will always be DIV)
	12	Component code (last 2 characters of clearing account)
	267	Blank
Account Record (4)	1	Record type (will always be A)
	19	Segment name (will always be LEDGER)
	12	Component code (will always be A)
	267	Blank

Dunn and Bradstreet Format

Record	Field	L
Control	AP AST (will always be “*”)	1
	Filler	2
	AP Corp Number (will always be “16”)	2
	Filler	1
	Due Date (credit due date entered in INTERFACE TO AP, format YYMMDD)	6
	Fiscal Period (will be spaces)	4
	Filler	137
Detail	Payment Type (will always be “2”)	1
	Sub Type (will be a space)	1
	Alpha Vendor (will be a space)	1
	Alpha-numeric Vendor (will be zeros)	8
	AP Vendor Name (carrier’s first name + last name)	30
	AP Vendor Address Line 1 (carrier ID or distribution zone, based on Business Rules)	30
	AP Vendor Address Line 2 (blank)	30
	AP Vendor City (blank)	21
	AP Vendor State (blank)	2
	AP ZIP (zeroes)	5
	AP ZIP+4 (zeroes)	4
	Credit amount (amount of refund, format 9999999999). The last two digits are decimals. For negative numbers, use a Signed Overpunch (set last digit to a character as follows: 0=}, 1=J, 2=K, 3=L, 4=M, 5=N, 6=O, 7=P, 8=Q, 9=R)	10
	AP direct deposit indicator (“Y” if carrier’s bank account is entered in Circulation, otherwise space)	1
	AP SSN (carrier’s social security number, if carrier’s bank account is entered in Circulation; otherwise spaces)	9

Great Plains Format

Note: The first line of the export file will contain the field (column) headings. The remaining lines will contain data.

Field	Sample Output
PUB CODE	“1111” (from Business Rules)
ACCOUNT	“2222” (from Business Rules)
CYCLE END DATE	“04/29/09”
PAY AMT	374.68
SS NUMBER	“110349796”
CARRIER ID	“0349796A”
NAME	SHARON CUMMINGS
ADDRESS 1	“1041 MADISON”
ADDRESS 2	“APT 860”
CITY	ASHFORD
STATE	WV
ZIP	25009
TELEPHONE	3048365406

Lawson Format

Record	Field	Length/Type	Field Contents
Control	AP-Asterisk	x(1)	*
	AP-Company	9(4)	GL Company ID
	Filler	x(1)	Space
	AP-Due-Date	9(6)	Due date (prompted for). Format YYMMDD
	AP-Fiscal-Period	9(4)	Fiscal period (based on due date). Format MMYY
	Filler	x(154)	Spaces
Detail	AP-Payment-Type	x(1)	2 (carrier credit)
	AP-Sub-Type	x(1)	Space
	AP-Vendor-Number	x(9)	Carrier’s vendor ID
	AP-Vendor-Name	x(30)	Spaces
	AP-Vendor-Addr1	x(30)	Spaces
	AP-Vendor-Addr2	x(30)	Spaces
	AP-Vendor-City	x(21)	Spaces
	AP-Vendor-State	x(2)	Spaces
	AP-Zip-Code	x(9)	Spaces
	AP-Payment-Amount	9(10)	Credit amount—right justified, zero filled with last two spaces for cents (no decimal)
	AP-Direct-Deposit-Ind	x(1)	Space
	AP-Tax-ID	x(9)	Spaces
	AP-Income-Code	x(2)	Spaces
	AP-1099-Amount	9(10)	Zero-filled
	AP-Invoice-Group	x(4)	Spaces
	Filler	x(1)	Space

PeopleSoft II Format

Field	Length	Required	Description
TRANSACTION_TYPE	x(3)	Yes	Transaction type
BUSINESS_UNIT	x(5)	Yes	Newspaper business unit
AMOUNT	9(00.0)	Yes	Amount to be paid
INVOICE_ID	x(30)	Yes	Invoice number
INVOICE_DT	date (10)	Yes	Invoice date
ACCOUNTING_DT	date(10)	Yes	Accounting date
PYMNT_MESSAGE	x(70)	Yes	Payment message
BUSINESS_UNIT_GL	x(5)	Yes	GL business unit
ACCOUNT	x(6)	Yes	Account
DEPTID	x(3)	No	Not exported.
PRODUCT	x(2)	No	Not exported.
AFFILIATE	x(5)	No	Not exported.
CHARTFIELD1	x(3)	No	Not exported.
CHARTFIELD2	x(3)	No	Not exported.
CHARTFIELD3	x(6)	No	Not exported.
XX_CIRC_TYPE	x(1)	Yes	Circulation type
XX_CIRC_ID1	x(15)	Yes	Circulation ID 1
XX_CIRC_ID2	x(10)	Yes	Circulation ID 2
XX_GARN_ID1	x(15)	No	Not exported.
XX_GARN_ID2	x(10)	No	Not exported.
XX_CASE_ID	x(15)	No	Not exported.
NAME1	x(40)	No	Not exported.
ADDRESS1	x(55)	No	Not exported.
ADDRESS2	x(55)	No	Not exported.
ADDRESS3	x(55)	No	Not exported.
ADDRESS4	x(55)	No	Not exported.
CITY	x(30)	No	Not exported.
STATE	x(2)	No	Not exported.
POSTAL	x(12)	No	Not exported.
COUNTRY	x(3)	No	Not exported.
Trailer Record
TRANSACTION_TYPE	x(3)	Yes	Transaction type
BUSINESS_UNIT	x(5)	Yes	Newspaper business unit
REC_COUNT_SUM	9(5)	Yes	Total record count
PYMNT_TOTAL	9(00.000)	Yes	Total payment amount

PeopleSoft 3 Format

Required fields are marked with an asterisk. Each export produces two files: a voucher file with three records and a vendor file with six records. The same format is used for the subscriber refunds export to PeopleSoft 3.

PeopleSoft 3 Voucher File—Voucher Record

Field Name	Type	Start - End	Values
RECORD TYPE*	x(3)	1 - 3	"000"
BUSINESS_UNIT*	x(5)	4 - 8	Defined in Business Rules: What is the business unit when interfacing to the PeopleSoft accounting system? (General section).
VOUCHER_ID*	x(8)	9 - 16	Leave blank; will be auto-numbered by the PeopleSoft system
INVOICE_ID*	x(16)	17 - 32	Account ID + date + invoice number. For subscriber refunds, the subscription ID is exported.
INVOICE_DT*	date	33 - 42	YYYY-MM-DD
VENDOR_SETID*	x(5)	43 - 47	"SSC"
VENDOR_ID*	x(10)	48 - 57	Vendor prefix + vendor ID The prefix is defined in Business Rules: What is the prefix used for vendors when interfacing to the PeopleSoft accounting system? (General section). For subscriber refunds, the subscription ID is exported (the combo subscription ID is exported for combo subscriptions).
ADDRESS_SEQ_NUM*	9(3)	58 - 60	"001"
GRP_AP_ID	x(6)	61 - 66	Space Fill
ORIGIN*	x(3)	67 - 69	Defined in Business Rules: What is the origin code...(Account Finance and Subscriber Acctg sections).
OPRID*	x(8)	70 - 77	"BATCH"
VCHR_TTL_LINES*	9(5)	78 - 82	Total # of voucher lines (Rec Types 001). Most often = '00001'; increment by 1 as needed
CLOSE_STATUS	x(1)	83 - 83	Space Fill
ENTRY_STATUS	x(1)	84 - 84	Space Fill
ACCOUNTING_DT	date	85 - 94	Space Fill
POST_VOUCHER	x(1)	95 - 95	Space Fill
POST_STATUS_AP	x(1)	96 - 96	Space Fill
PROCESS_INSTANCE	9(10)	97 - 106	Space Fill
BUSINESS_UNIT_GL	x(5)	107 - 111	Entered on the user input screen
PROCESS_MAN_CLOSE	x(1)	112 - 112	Space Fill
DST_CNTRL_ID	x(10)	113 - 122	Space Fill
DUP_INVOICE_STATUS	x(1)	123 - 123	Space Fill
VOUCHER_ID_RELATED	x(8)	124 - 131	Space Fill
GROSS_AMT	-9(17)	132 - 148	S99999999999999.99
GROSS_AMT_BSE	-9(17)	149 - 165	Space Fill
TXN_CURRENCY_CD	x(3)	166 - 168	Space Fill
CUR_RT_TYPE	x(5)	169 - 173	Space Fill
CUR_EXCHNG_RT	9(16)	174 - 189	Space Fill
BASE_CURRENCY	x(3)	190 - 192	Space Fill
DSCNT_AMT	-9(17)	193 - 209	Space Fill
DSCNT_AMT_BSE	-9(17)	210 - 226	Space Fill
DSCNT_PRORATE_FLG	x(1)	227 - 227	Space Fill
USETAX_AMT	-9(17)	228 - 244	Space Fill
USETAX_AMT_BSE	-9(17)	245 - 261	Space Fill
USETAX_CD	x(8)	262 - 269	Space Fill
USETAX_PRORATE_FLG	x(1)	270 - 270	Space Fill
SALETX_AMT	-9(17)	271 - 287	Space Fill
SALETX_AMT_BSE	-9(17)	288 - 304	Space Fill
SALETX_CD	x(8)	305 - 312	Space Fill
SALETX_PRORATE_FLG	x(1)	313 - 313	Space Fill
VAT_INV_AMT	-9(17)	314 - 330	Space Fill
VAT_INV_AMT_BSE	-9(17)	331 - 347	Space Fill
VAT_NONINV_AMT	-9(17)	348 - 364	Space Fill
VAT_NONINV_AMT_BSE	-9(17)	365 - 381	Space Fill
FREIGHT_AMT	-9(17)	382 - 398	Space Fill
FREIGHT_AMT_BSE	-9(17)	399 - 415	Space Fill
FRGHT_PRORATE_FLG	x(1)	416 - 416	Space Fill
DUE_DT	date	417 - 426	Space Fill
DSCNT_DUE_DT	date	427 - 436	Space Fill
PYMNT_CNT_MAX	9(5)	437 - 441	Space Fill
PYMNT_CNT_TOTAL	9(5)	442 - 446	Space Fill
PYMNT_TERMS_CD	x(5)	447 - 451	Entered on the user input screen
ENTERED_DT	date	452 - 461	Space Fill
LAST_UPDATE_DT	date	462 - 471	Space Fill
TIME_EDIT	time	472 - 486	Space Fill
VCHR_TEMPLATE_ID	x(10)	487 - 496	Space Fill
VCHR_TMPLTE_DESCR	x(30)	497 - 526	Space Fill
M1099_ADJUST_FLG	x(1)	527 - 527	Space Fill
M1099_FISCAL_YR	9(4)	528 - 531	Space Fill
POST_STATUS_M1099	x(1)	532 - 532	Space Fill
ERROR_FLAG	x(1)	533 - 533	Space Fill
VAT_BASIS_AMT	-9(17)	534 - 550	Space Fill
VAT_BASIS_AMT_BSE	-9(17)	551 - 567	Space Fill
VAT_CALC_AMT	-9(17)	568 - 584	Space Fill
VAT_ENTRD_AMT	-9(17)	585 - 601	Space Fill
VAT_RCVRY_AMT	-9(17)	602 - 618	Space Fill
VAT_RCVRY_AMT_BSE	-9(17)	619 - 635	Space Fill
MATCH_ACTION	x(1)	636 - 636	Space Fill
MATCH_STATUS_VCHR	x(1)	637 - 637	Space Fill
BCM_HDR_STATUS	x(1)	638 - 638	Space Fill
BCM_TRAN_TYPE	x(2)	639 - 640	Space Fill
MERCHANDISE_AMT	-9(17)	641 - 657	Space Fill
MERCH_AMT_BSE	-9(17)	658 - 674	Space Fill
IN_PROCESS_FLG	x(1)	675 - 675	Space Fill
MANUAL_CLOSE_DT	date	676 - 685	Space Fill
CNTRCT_ID	x(25)	686 - 710	Space Fill
REMIT_ADDR_SEQ_NUM	9(3)	711 - 713	"001"
CUR_RT_SOURCE	x(1)	714 - 714	Space Fill
DSCNT_AMT_FLG	x(1)	715 - 715	Space Fill
DUE_DT_FLG	x(1)	716 - 716	Space Fill
VCHR_APPRVL_FLG	x(1)	717 - 717	Space Fill
BUSPROCNAME	x(30)	718 - 747	Space Fill
APPR_RULE_SET	x(30)	748 - 777	Space Fill
APPR_CHECK_FLG	x(1)	778 - 778	Space Fill
APPR_STATUS	x(1)	779 - 779	Space Fill
APPR_INSTANCE	9(9)	780 - 788	Space Fill
OPRID_LAST_UPDT	x(8)	789 - 796	Space Fill
VAT_DCLRTN_POINT	x(1)	797 - 797	Space Fill
VAT_CALC_TYPE	x(1)	798 - 798	Space Fill
VAT_ENTITY	x(20)	799 - 818	Space Fill
VAT_TXN_TYPE_CD	x(4)	819 - 822	Space Fill
TAX_CD_VAT	x(8)	823 - 830	Space Fill
VAT_RCRD_INPT_FLG	x(1)	831 - 831	Space Fill
VAT_RCRD_OUTPT_FLG	x(1)	832 - 832	Space Fill
VAT_RECOVERY_PCT	-9(7)	833 - 839	Space Fill
VAT_CALC_GROSS_NET	x(1)	840 - 840	Space Fill
VAT_RECALC_FLG	x(1)	841 - 841	Space Fill
VAT_CALC_FRGHT_FLG	x(1)	842 - 842	Space Fill
VAT_NRCVR_PRO_FLG	x(1)	843 - 843	Space Fill
VAT_CALC_AMT_BSE	-9(17)	844 - 860	Space Fill
ECTRANSID	x(15)	861 - 875	Space Fill
ECQUEUEINSTANCE	9(9)	876 - 884	Space Fill
ECTRANSINOUTSW	x(1)	885 - 885	Space Fill
VAT_RGSTRN_SELLER	x(12)	886 - 897	Space Fill
COUNTRY_ORIGIN	x(3)	898 - 900	Space Fill
COUNTRY_INVOICE_TO	x(3)	901 - 903	Space Fill
COUNTRY_SHIP_TO	x(3)	904 - 906	Space Fill
COUNTRY_VAT_RPTG	x(3)	907 - 909	Space Fill
VAT_DCMNT_ID	9(8)	910 - 917	Space Fill
VAT_DCMNT_LN_MAX	9(5)	918 - 922	Space Fill
DESCR254_MIXED	x(254)	923 - 1176	Space Fill

PeopleSoft 3 Voucher File—Voucher Line Record

Field Name	Type	Start - End	Values
RECORD TYPE*	x(3)	1 - 3	"001"
BUSINESS_UNIT*	x(5)	4 - 8	Defined in Business Rules: What is the business unit when interfacing to the PeopleSoft accounting system? (General section).
VOUCHER_ID*	x(8)	9 - 16	Leave blank; same as "000" record. Will be assigned by PeopleSoft system.
VOUCHER_LINE_NUM*	9(5)	17 - 21	Value = "00001"; increment by 1 as needed
TOTAL_DISTRIBS*	9(5)	22 - 26	Total # of distribution lines (Rec Type 002) for this voucher. Most often = “00001”; increment by 1 as needed.
MAX_DISTRIB_LINE	9(5)	27 - 31	Same as TOTAL_DISTRIBS
BUSINESS_UNIT_PO	x(5)	32 - 36	Space Fill
PO_ID	x(10)	37 - 46	Space Fill
LINE_NBR	9(5)	47 - 51	Space Fill
SCHED_NBR	9(3)	52 - 54	Space Fill
DESCR	x(30)	55 - 84	Check description
MERCHANDISE_AMT*	-9(17)	85 - 101	Check amount; S99999999999999.99
MERCH_AMT_BSE	-9(17)	102 - 118	Space Fill
ITM_SETID	x(5)	119 - 123	Space Fill
INV_ITEM_ID	x(18)	124 - 141	Space Fill
QTY_VCHR	-9(17)	142 - 158	Space Fill
STATISTIC_AMOUNT	-9(17)	159 - 175	Space Fill
UNIT_OF_MEASURE	x(3)	176 - 178	Space Fill
UNIT_PRICE	-9(17)	179 - 195	Space Fill
SALETX_APPL_FLG	x(1)	196 - 196	Space Fill
USETAX_APPL_FLG	x(1)	197 - 197	Space Fill
VAT_APPL_FLG	x(1)	198 - 198	Space Fill
FRGHT_PRORATE_FLG	x(1)	199 - 199	Space Fill
DSCNT_APPL_FLG	x(1)	200 - 200	Space Fill
ERROR_FLAG	x(1)	201 - 201	Space Fill
PROCESS_INSTANCE	9(10)	202 - 211	Space Fill
M1099_CD	x(2)	212 - 213	Space Fill
M1099_SW	x(1)	214 - 214	"N" if overriding vendor withholding; else leave blank
TAX_CD_VAT	x(8)	215 - 222	Space Fill
VAT_RECOVERY_PCT	-9(7)	223 - 229	Space Fill
FINAL_REF_IND	x(1)	230 - 230	Space Fill
BUSINESS_UNIT_RECV	x(5)	231 - 235	Space Fill
RECEIVER_ID	x(10)	236 - 245	Space Fill
RECV_LN_NBR	9(5)	246 - 250	Space Fill
RECV_SHIP_SEQ_NBR	9(3)	251 - 253	Space Fill
MATCH_LINE_OPT	x(1)	254 - 254	Space Fill
DISTRIB_MTHD_FLG	x(1)	255 - 255	Space Fill
TXN_CURRENCY_CD	x(3)	256 - 258	Space Fill
BASE_CURRENCY	x(3)	259 - 261	Space Fill
CURRENCY_CD	x(3)	262 - 264	Space Fill
VAT_TXN_TYPE_CD	x(4)	265 - 268	Space Fill
ECTRANSID	x(15)	269 - 283	Space Fill
ECQUEUEINSTANCE	9(9)	284 - 292	Space Fill
ECTRANSINOUTSW	x(1)	293 - 293	Space Fill

PeopleSoft 3 Voucher File—Distrib Line Record

Field Name	Type	Start - End	Value
RECORD TYPE*	x(3)	1 - 3	"002"
BUSINESS_UNIT*	x(5)	4 - 8	Defined in Business Rules: What is the business unit when interfacing to the PeopleSoft accounting system? (General section).
VOUCHER_ID*	x(8)	9 - 16	Leave blank; same as '000 & 001" record. Will be assigned by the PeopleSoft system.
VOUCHER_LINE_NUM*	9(5)	17 - 21	Same as 'VOUCHER_LINE_NUM' on '001' record
DISTRIB_LINE_NUM*	9(5)	22 - 26	Value = '00001'; increment by 1 as needed
SUSPENSE_REF_NUM	9(5)	27 - 31	Space Fill
BUSINESS_UNIT_GL*	x(5)	32 - 36	Entered on the user input screen
ACCOUNT*	x(6)	37 - 42	GL Account from the input screen
STATISTICS_CODE	x(3)	43 - 45	Space Fill
FOREIGN_AMOUNT	-9(17)	46 - 62	Space Fill
FOREIGN_CURRENCY	x(3)	63 - 65	Space Fill
CUR_RT_TYPE	x(5)	66 - 70	Space Fill
CUR_EXCHNG_RT	9(16)	71 - 86	Space Fill
MONETARY_AMOUNT	-9(17)	87 - 103	Space Fill
STATISTIC_AMOUNT	-9(17)	104 - 120	Space Fill
QTY_VCHR	-9(17)	121 - 137	Space Fill
JRNL_LN_REF	x(10)	138 - 147	Space Fill
OPEN_ITEM_STATUS	x(1)	148 - 148	Space Fill
DESCR	x(30)	149 - 178	Space Fill
CURRENCY_CD	x(3)	179 - 181	Space Fill
MERCHANDISE_AMT*	-9(17)	182 - 198	S99999999999999.99
MERCH_AMT_BSE	-9(17)	199 - 215	Space Fill
DSCNT_AMT_BSE	-9(17)	216 - 232	Space Fill
SALETX_AMT_BSE	-9(17)	233 - 249	Space Fill
USETAX_AMT_BSE	-9(17)	250 - 268	Space Fill
VAT_INV_AMT_BSE	-9(17)	267 - 283	Space Fill
VAT_NONINV_AMT_BSE	-9(17)	284 - 300	Space Fill
VAT_RCVRY_AMT_BSE	-9(17)	301 - 317	Space Fill
FREIGHT_AMT_BSE	-9(17)	318 - 334	Space Fill
CHART_EDIT_STATUS	x(1)	335 - 335	Space Fill
ACCOUNTING_DT	date	336 - 345	Space Fill
PROCESS_INSTANCE	9(10)	346 - 355	Space Fill
ERROR_FLAG	x(1)	356 - 356	Space Fill
FINAL_REF_IND	x(1)	357 - 357	Space Fill
REFERENCE_NUMBER	x(10)	358 - 367	Space Fill
REF_CLOSED	x(1)	368 - 368	Space Fill
REF_DIST_LINE	9(5)	369 - 373	Space Fill
REF_LINE_NUMBER	9(5)	374 - 378	Space Fill
BUSINESS_UNIT_PO	x(5)	379 - 383	Space Fill
PO_ID	x(10)	384 - 393	Space Fill
LINE_NBR	9(5)	394 - 398	Space Fill
SCHED_NBR	9(3)	399 - 401	Space Fill
PO_DIST_LINE_NUM	9(5)	402 - 406	Space Fill
BCM_LINE_STATUS	x(2)	407 - 408	Space Fill
BCM_POST_AMOUNT	-9(17)	409 - 425	Space Fill
BCM_POST_AMT_TOT	-9(17)	426 - 442	Space Fill
BUSINESS_UNIT_PC	x(5)	443 - 447	Space Fill
ACTIVITY_ID	x(15)	448 - 462	Space Fill
ANALYSIS_TYPE	x(3)	463 - 465	Space Fill
RESOURCE_TYPE	x(5)	466 - 470	Space Fill
RESOURCE_CATEGORY	x(5)	471 - 475	Space Fill
RESOURCE_SUB_CAT	x(5)	476 - 480	Space Fill
MONETARY_AMT_VCHR	-9(17)	481 - 497	Space Fill
EXCHNG_RT_INTR_BSE	9(16)	498 - 513	Space Fill
BASE_CURRENCY	x(3)	514 - 516	Space Fill
ASSET_FLG	x(1)	517 - 517	Space Fill
BUSINESS_UNIT_AM	x(5)	518 - 522	Space Fill
ASSET_ID	x(8)	523 - 530	Space Fill
PROFILE_ID	x(10)	531 - 540	Space Fill
VAT_TXN_TYPE_CD	x(4)	541 - 544	Space Fill
FREIGHT_AMT	-9(17)	545 - 561	Space Fill
SALETX_AMT	-9(17)	562 - 578	Space Fill
USETAX_AMT	-9(17)	579 - 595	Space Fill
VAT_INV_AMT	-9(17)	596 - 612	Space Fill
VAT_NONINV_AMT	-9(17)	613 - 629	Space Fill
BUSINESS_UNIT_RECV	x(5)	630 - 634	Space Fill
RECEIVER_ID	x(10)	635 - 644	Space Fill
RECV_LN_NBR	9(5)	645 - 649	Space Fill
RECV_SHIP_SEQ_NBR	9(3)	650 - 652	Space Fill
RECV_DIST_LINE_NUM	9(5)	653 - 657	Space Fill
VAT_RECOVERY_PCT	-9(7)	658 - 664	Space Fill
VAT_BASIS_AMT	-9(17)	665 - 681	Space Fill
VAT_BASIS_AMT_BSE	-9(17)	682 - 698	Space Fill
VAT_CALC_AMT	-9(17)	699 - 715	Space Fill
VAT_CALC_AMT_BSE	-9(17)	716 - 732	Space Fill
VAT_RCVRY_AMT	-9(17)	733 - 749	Space Fill
VAT_DSCNT_ADJ	-9(17)	750 - 766	Space Fill
VAT_DSCNT_ADJ_BSE	-9(17)	767 - 783	Space Fill
VAT_DSCNT_RCVRY	-9(17)	784 - 800	Space Fill
VAT_DSCNT_RCVR_BSE	-9(17)	801 - 817	Space Fill
OPERATING_UNIT	x(8)	818 - 825	Defined in Business Rules: What is the operating unit when interfacing to the PeopleSoft accounting system (General section).
TAX_CD_VAT_PCT	-9(8)	826 - 833	Space Fill
LEDGER_GROUP	x(10)	834 - 843	Space Fill
DSCNT_AMT	-9(17)	844 - 860	Space Fill
ECTRANSID	x(15)	861 - 875	Space Fill
ECQUEUEINSTANCE	9(9)	876 - 884	Space Fill
ECTRANSINOUTSW	x(1)	885 - 885	Space Fill
DEPTID	x(10)	886 - 895	Entered on the user input screen
PRODUCT	x(6)	896 - 901	Entered on the user input screen
PROJECT_ID	x(15)	902 - 916	Entered on the user input screen
AFFLIATE	x(5)	917 - 921	Space Fill

PeopleSoft 3 Vendor File—Vendor Record

Field Name	Type	Start - End	Values
TRANS_CODE*	x(3)	1 - 3	"001"
Space Fill	x(1)	4 - 4	Space Fill
SETID*	x(5)	5 - 9	"SSC"
VENDOR_ID	x(10)	10 - 19	Vendor prefix + vendor ID The prefix is defined in Business Rules: What is the prefix used for vendors when interfacing to the PeopleSoft accounting system? (General section).
VENDOR_NAME_SHORT	x(14)	20 - 33	Space Fill
VNDR_NAME_SHRT_USR*	x(10)	34 - 43	Space Fill
VNDR_NAME_SEQ_NUM	9(3)	44 - 46	"001"
NAME1*	x(40)	47 - 86	Vendor name
NAME2	x(40)	87 - 126	Space Fill
VENDOR_STATUS*	x(1)	127 - 127	"A"
VENDOR_CLASS*	x(1)	128 - 128	"R" = outside party. Default = “R”.
VENDOR_PERSISTENCE*	x(1)	129 - 129	"R" = Regular (the default), P = Permanent, "O" = One-time vendor. Set this field to “R” for regular vendors who can be archived if there is no activity for more than 2 years. Use "P" for permanent vendors who don’t need to be archived. Use “O” for vendors who should be de-activated when payment is processed.
REMIT_ADDR_SEQ_NUM	9(3)	130 - 132	"001"
PRIM_ADDR_SEQ_NUM	9(3)	133 - 135	"001"
ADDR_SEQ_NUM_ORDR	9(3)	136 - 138	"001"
REMIT_SETID	x(5)	139 - 143	Space Fill
REMIT_VENDOR	x(10)	144 - 153	Space Fill
CORPORATE_SETID	x(5)	154 - 158	Space Fill
CORPORATE_VENDOR	x(510)	159 - 168	Space Fill
CUST_SETID	x(5)	169 - 173	Space Fill
CUST_ID	x(15)	174 - 188	Space Fill
ENTERED_BY	x(8)	189 - 196	Space Fill
DB_NUMBER	9(9)	197 - 205	Space Fill
AR_NUM	x(15)	206 - 220	Space Fill
OLD_VENDOR_ID	x(15)	221 - 235	Space Fill
SIC_DIVISION	x(1)	236 - 236	Space Fill
SIC_GRP	x(2)	237 - 238	Space Fill
SIC_IND_GRP	x(1)	239 - 239	Space Fill
SIC_IND_CD	x(1)	240 - 240	Space Fill
SIC_IND_CD_SEQ	9(4)	241 - 244	Space Fill
M1099_SW*	x(1)	245 - 245	Default = "N".
VAT_SW*	x(1)	246 - 246	"N"
VNDR_STATUS_PO	x(1)	247 - 246	"Y"

PeopleSoft 3 Vendor File—Vendor Address Scroll Record

Field Name	Type	Start - End	Values
TRAN_CODE*	x(3)	1 - 3	"002"
FILLER	x(1)	4 - 4	Space Fill
SETID*	x(5)	5 - 9	"SSC"
VENDOR_ID*	x(10)	10 - 19	Vendor prefix + vendor ID The prefix is defined in Business Rules: What is the prefix used for vendors when interfacing to the PeopleSoft accounting system? (General section).
ADDRESS_SEQ_NUM	9(3)	20 - 22	"001"
DESCR	x(30)	23 - 52	"REMIT ADDRESS"

PeopleSoft 3 Vendor File—Vendor Addr Record

Field Name	Type	Start - End	Values
TRANS_CODE*	x(3)	1 - 3	"003"
FILLER	x(1)	4 - 4	Filler
SETID*	x(5)	5 - 9	"SSC"
VENDOR_ID*	x(10)	10 - 19	Vendor prefix + vendor ID The prefix is defined in Business Rules: What is the prefix used for vendors when interfacing to the PeopleSoft accounting system? (General section).
ADDRESS_SEQ_NUM	9(3)	20 - 22	"001"
EFFDT	date	23 - 32	Conversion = "2006-01-01". Format = YYYY-MM-DD
EFF_STATUS	x(1)	33 - 33	"A"
NAME1	x(40)	34 - 73	Vendor name
NAME2	x(40)	74 - 113	Filler
ADDRESS1	x(35)	114 - 148	Address information.
ADDRESS2	x(35)	149 - 183	Address information.
ADDRESS3	x(35)	184 - 218	Address information.
ADDRESS4	x(35)	219 - 253	Filler
CITY	x(30)	254 - 283	Vendor city
IN_CITY_LIMIT	x(1)	284 - 284	"N"
COUNTY	x(30)	285 - 314	Filler
STATE	x(4)	315 - 318	State
GEO_CODE	x(11)	319 - 329	Filler
POSTAL	x(12)	330 - 341	Zip code
COUNTRY	x(3)	342 - 344	Vendor country. Default = “USA”.
COUNTRY_CODE	x(3)	345 - 347	Filler
PHONE	x(24)	348 - 371	Main contact phone number; format = 9999999999 with no spaces, dashes, etc.
EXTENSION	x(6)	372 - 377	If you know the code, else Filler
FAX	x(24)	378 - 401	Filler

PeopleSoft 3 Vendor File—Vendor Invoice Record

Field Name	Type	Start - End	Values
TRAN_CODE*	x(3)	1 - 3	"004"
Space Fill	x(1)	4 - 4	Space Fill
SETID*	x(5)	5 - 9	"SSC"
VENDOR_ID*	x(10)	10 - 19	Vendor prefix + vendor ID The prefix is defined in Business Rules: What is the prefix used for vendors when interfacing to the PeopleSoft accounting system? (General section).
EFFDT	date	20 - 29	Conversion = "2006-01-01". Format = YYYY-MM-DD
EFF_STATUS	x(1)	30 - 30	"A"
CURRENCY_CD	x(3)	31 - 33	"USD"
CUR_RT_TYPE	x(5)	34 - 38	"CRRNT"
ADDRESS_SEQ_NUM	9(3)	39 - 41	"001"
DUP_INVOICE_IND	x(1)	42 - 42	"D"
DUP_INVOICE_ACTION	x(1)	43 - 43	"W"
DUP_INV_NUM_FLG	x(1)	44 - 44	Space Fill
DUP_INV_VENDOR_NUM	x(1)	45 - 45	Space Fill
DUP_INV_GROSS_AMT	x(1)	46 - 46	Space Fill
DUP_INV_DT	x(1)	47 - 47	Space Fill
DUP_INV_BUS_UNIT	x(1)	48 - 48	Space Fill
FREIGHT_TERMS	x(10)	49 - 58	Space Fill
SHIP_TYPE_ID	x(10)	59 - 68	Space Fill
DISP_METHOD	x(3)	69 - 71	Space Fill
PYMNT_TERMS_CD	x(5)	72 - 76	Entered on the user input screen
MATCH_CNTRL_ID	x(10)	77 - 86	Space Fill
MATCH_OPT	x(1)	87 - 87	"N"
ERS_ACTION	x(1)	88 - 88	Space Fill
ERS_FLAG	x(1)	89 - 89	Space Fill
VCHR_APPRVL_FLG	x(1)	90 - 90	"D"
BUSPROCNAME	x(30)	91 - 120	Space Fill
APPR_RUL_SET	x(30)	121 - 150	Space Fill
VAT_DCLRTN_POINT	x(1)	151 - 151	Space Fill
VAT_CALC_TYPE	x(1)	152 - 152	Space Fill
VAT_TXN_TYPE_CD	x(4)	153 - 156	Space Fill
TAX_CD_VAT	x(8)	157 - 164	Space Fill
VAT_RECOVERY_FLG	x(1)	165 - 165	Space Fill
VAT_RECOVERY_PCT	-9(5)	166 - 170	Space Fill
VAT_RCRD_DFLT_FLG	x(1)	171 - 171	Space Fill
VAT_RCRD_INPT_FLG	x(1)	172 - 172	Space Fill
VAT_RCRD_OUTPT_FLG	x(1)	173 - 173	Space Fill
VAT_TOL_FLG	x(1)	174 - 174	Space Fill
VAT_TOL_PCT	-9(7)	175 - 181	Space Fill
VAT_TOL_AMT	-9(15)	182 - 196	Space Fill
VAT_TOL_CUR_CD	x(3)	197 - 199	Space Fill
VAT_TOL_RT_TYPE	x(5)	200 - 204	Space Fill
BUYER_ID	x(30)	205 - 234	Space Fill

PeopleSoft 3 Vendor File—Vendor Pay Record

Field Name	Type	Start - End	Values
TRAN_CODE*	x(3)	1 - 3	"005"
Space Fill	x(1)	4 - 4	Space Fill
SETID*	x(5)	5 - 9	"SSC"
VENDOR_ID*	x(10)	10 - 19	Vendor prefix + vendor ID The prefix is defined in Business Rules: What is the prefix used for vendors when interfacing to the PeopleSoft accounting system? (General section).
EFFDT	date	20 - 29	Conversion = "2006-01-01". Format= YYYY-MM-DD
EFF_STATUS	x(1)	30 - 30	"A"
CURRENCY_CD	x(3)	31 - 33	Space Fill
CUR_RT_TYPE	x(5)	34 - 38	Space Fill
PYMNT_METHOD*	x(3)	39 - 41	"CHK" = Check, "EFT" = Electronic fund transfer. Default = “CHK”.
PYMNT_HOLD*	x(1)	42 - 42	Space Fill
PYMNT_GROUP_CD	x(2)	43 - 44	"RE"
PYMNT_SEPARATE	x(1)	45 - 45	Space Fill
PYMNT_HANDLING_CD	x(2)	46 - 47	"RE"
DSCNT_ALWAYS_FLG*	x(1)	48 - 48	"N"
DELAY_DAYS_FLG	x(1)	49 - 49	"D"
DSCNT_DELAY_DAYS	-9(4)	50 - 53	Space Fill
PYMNT_DELAY_DAYS	-9(4)	54 - 57	Space Fill
BANK_CD	x(15)	58 - 62	Space Fill
BANK_ACCT_KEY	x(4)	63 - 66	Space Fill
BANK_ACCOUNT_NUM	x(17)	67 - 83	If EFT, then enter vendor’s bank account number, else spaces
VNDR_PAYMENT_MSG	x(30)	84 - 113	Space Fill
DFI_ID_NUM	x(12)	114 - 125	If EFT, then enter the identification number of the bank to which the funds are transferred; the routing number
BANK_ACCT_TYPE	x(2)	126 - 127	If EFT, then "01” for savings account, "03" for checking, else spaces
EFT_PYMNT_FMT_CD	x(3)	128 - 130	Space Fill
EFT_RTNG_FLG	x(1)	131 - 131	Space Fill
EFT_RTNG_STATUS	x(1)	132 - 132	Space Fill
EFT_TRANS_HANDLING	x(1)	133 - 133	Space Fill
PRENOTE_DATE	date	134 - 143	Space Fill
PRENOTE_REQD	x(1)	144 - 144	Space Fill
PRENOTE_STATUS	x(1)	145 - 145	Space Fill
REP_RTNG_NUM	x(10)	146 - 155	Space Fill
RTNG_DESCR	x(254)	156 - 409	Space Fill
BRANCH_ID	x(10)	410 - 419	Space Fill
CHECK_DIGIT	x(2)	420 - 421	Space Fill

PeopleSoft 3 Vendor File—Vendor 1099 Record

Note: If a vendor is not a 1099 vendor, then only complete the first 6 fields and space fill the remainder of the record.

Field Name	Type	Start - End	Values
TRAN_CODE*	x(3)	1 - 3	"006"
Space Fill	x(1)	4 - 4	Space Fill
SETID*	x(5)	5 - 9	"SSC"
VENDOR_ID*	x(10)	10 - 19	Vendor prefix + vendor ID The prefix is defined in Business Rules: What is the prefix used for vendors when interfacing to the PeopleSoft accounting system? (General section).
EFFDT	date	20 - 29	Conversion = "2006-01-01". Format = YYYY-MM-DD
EFF_STATUS*	x(1)	30 - 30	"A"
M1099_TIN_TYPE*	x(1)	31 - 31	"S" = SSN, "F" = FED ID
M1099_TIN	x(10)	32 - 41	If TIN_TYPE is "S", then social security number. If TIN_TYPE = "F", then Federal ID number.
M1099_PRCNT_WTHHLD	9(6)	42 - 47	Space Fill
M1099_NAME1	x(40)	48 - 87	Space Fill
M1099_NAME2	x(40)	88 - 127	Space Fill
M1099_CONTROL_NAME	x(4)	128 - 131	Space Fill
M1099_ADDRESS	x(40)	132 - 171	Space Fill
M1099_CITY	x(30)	172 - 201	Space Fill
M1099_STATE	x(2)	202 - 203	Space Fill
M1099_POSTAL	x(10)	204 - 213	Space Fill
M1099_WTHHLD_IND*	x(1)	214 - 214	Space Fill
DIRECT_SALES*	x(1)	215 - 215	If direct sales vendor, then "Y", else "N". Default = “N”.
M1099_CD/DEFAULT_CLASS	x(2)	216 - 217	If 1099 vendor, then enter 1 of the 14 standard IRS withholding classes. If none sent, the default is "07” - Non-employee Compensation
M1099_COUNTRY	x(3)	218 - 220	Space Fill
SECOND_TIN	x(1)	221 - 221	Space Fill
STATE_TAX_WH	9(16)	222 - 237	Space Fill
CURRENCY_CD	x(3)	238 - 240	Space Fill