568 Contract Payment Management Report

Functional Group ID=D5

Introduction:

This Draft Standard for Trial Use contains the format and establishes the data contents of the Contract Payment Management Report Transaction Set (568) for use within the context of an Electronic Data Interchange (EDI) environment. This transaction set can be used to enable the transmission of a management report to provide the details of payments and collections made against funds obligated on contracts, orders, and other services.

Heading:

	Pos.	Seg.		Req.		Loop	Notes and
	No.	ID	Name	Des.	Max.Use	Repeat	Comments	
M	010	ST	Transaction Set Header	M	1									
M	020	BGN	Beginning Segment	M	1		n1							
M	030	AMT	Monetary Amount {Total Received)	M	2		n2							
			LOOP ID - N1			10								
	040	N1	Name {Distribution Company)	O	1		n3							
														
			LOOP ID - N1			10								
	040	N1	Name {Supplier)	O	1									

Detail:

	Pos.	Seg.		Req.		Loop	Notes and
	No.	ID	Name	Des.	Max.Use	Repeat	Comments	
			LOOP ID - CS			>1								
	010	CS	Contract Summary	O	1		n4							
	020	N9	Reference Identification {Non-Billing Party Account Id)	O	3		n5							
	020	N9	Reference Identification {Billing Party Old Account Id)	O	3									
			LOOP ID - REF			>1								
	060	REF	Reference Identification {Service Identifier)	O	1		n6							
			LOOP ID - LX			>1								
	080	LX	Assigned Number	O	1									
M	090	N9	Reference Identification {Transaction Reference Number)	M	1		n7							
	100	AMT	Monetary Amount	O	>1		n8							
			LOOP ID - N1			1								
	140	N1	Name {Customer Name)	O	1		n9							

Summary:

	Pos.	Seg.		Req.		Loop	Notes and
	No.	ID	Name	Des.	Max.Use	Repeat	Comments	
M	020	SE	Transaction Set Trailer	M	1									

Transaction Set Notes

1.	The BGN segment identifies the transaction set purpose code, a unique number used to identify this transmission, and the date and time of transaction set creation.
2.	The AMT segment identifies the collected amount and the disbursed amount to the extent that either amount applies to the transaction set.
3.	The N1 loop identifies the name and address information for the transmitting and receiving parties.
4.	The CS segment identifies the contract, modification, call, and order number of the procurement instrument, and the voucher number of the payment being reported on in this contract payment management report.
5.	The N9 segment identifies the number of the original voucher on which a payment was made if the voucher being reported on in this transmission is a change, correction, or adjustment to that previous voucher.
6.	The REF segment identifies a reference number associated with the following appropriation data.
7.	The N9 segment identifies a contract line item, exhibit line item, or subclassification of either against which specific data is being reported.
8.	The AMT segment identifies the gross, net, deducted, or collected amounts and the net variance amount applicable to the line item being reported.
9.	The N1 loop identifies address information for a quantity delivered in a specific shipment, to a specific ship-to address.

	Segment:	ST Transaction Set Header
	Position:	010
	Loop:
	Level:	Heading
	Usage:	Mandatory
	Max Use:	1
	Purpose:	To indicate the start of a transaction set and to assign a control number
	Syntax Notes:
	Semantic Notes:	1	The transaction set identifier (ST01) is used by the translation routines of the interchange partners to select the appropriate transaction set definition (e.g., 810 selects the Invoice Transaction Set).
	Comments:
Notes:		Required	
		ST~568~000000001	

Data Element Summary
	Ref.	Data	
	Des.	Element	Name	Attributes
Must Use	ST01	143	Transaction Set Identifier Code	M		ID 3/3	
	Code uniquely identifying a Transaction Set	
	Refer to 004010 Data Element Dictionary for acceptable code values.	
Must Use	ST02	329	Transaction Set Control Number	M		AN 4/9	
	Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set	

	Segment:	BGN Beginning Segment
	Position:	020
	Loop:
	Level:	Heading
	Usage:	Mandatory
	Max Use:	1
	Purpose:	To indicate the beginning of a transaction set
	Syntax Notes:	1	If BGN05 is present, then BGN04 is required.
	Semantic Notes:	1	BGN02 is the transaction set reference number.
		2	BGN03 is the transaction set date.
		3	BGN04 is the transaction set time.
		4	BGN05 is the transaction set time qualifier.
		5	BGN06 is the transaction set reference number of a previously sent transaction affected by the current transaction.
	Comments:
Notes:		Required	
		BGN~00~94852-34985-9~20051118	

Data Element Summary
	Ref.	Data	
	Des.	Element	Name	Attributes
Must Use	BGN01	353	Transaction Set Purpose Code	M		ID 2/2	
	Code identifying purpose of transaction set	
 	00		Original	
Must Use	BGN02	127	Reference Identification	M		AN 1/30	
	Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier	
	Unique Number identifying this transaction assigned by the sender of the transaction.  This number should be unique over all time.	
Must Use	BGN03	373	Date	M		DT 8/8	
	Date expressed as CCYYMMDD	
	The transaction creation date - the date that the data was processed by the sender's application system.	

	Segment:	AMT Monetary Amount {Total Received)
	Position:	030
	Loop:
	Level:	Heading
	Usage:	Mandatory
	Max Use:	2
	Purpose:	To indicate the total monetary amount
	Syntax Notes:
	Semantic Notes:
	Comments:
Notes:		Required	
		Total Monetary Amount allocated to the non-billing party in this transaction set.  The AMT02 element is the sum of all CS11s in this transaction set.	
		AMT~AT~1500.00	

Data Element Summary
	Ref.	Data	
	Des.	Element	Name	Attributes
Must Use	AMT01	522	Amount Qualifier Code	M		ID 1/3	
	Code to qualify amount	
 	AT		Total Received	
	The AMT02 element is the sum of all CS11s in this transaction set.	
Must Use	AMT02	782	Monetary Amount	M		R 1/18	
	Monetary amount	

	Segment:	N1 Name {Distribution Company)
	Position:	040
	Loop:	N1        Optional
	Level:	Heading
	Usage:	Optional
	Max Use:	1
	Purpose:	To identify a party by type of organization, name, and code
	Syntax Notes:	1	At least one of N102 or N103 is required.
		2	If either N103 or N104 is present, then the other is required.
	Semantic Notes:
	Comments:	1	This segment, used alone, provides the most efficient method of providing organizational identification. To obtain this efficiency the "ID Code" (N104) must provide a key to the table maintained by the transaction processing party.
		2	N105 and N106 further define the type of entity in N101.
Notes:		Required	
		N1~8S~DISCO LTD~1~007909411~~41	

Data Element Summary
	Ref.	Data	
	Des.	Element	Name	Attributes
Must Use	N101	98	Entity Identifier Code	M		ID 2/3	
	Code identifying an organizational entity, a physical location, property or an individual	
 	8S		Consumer Service Provider (CSP)	
	Distribution Company	
Used	N102	93	Name	X		AN 1/60	
	Free-form name	
	Distribution Company Name	
	This free-form text can not contain any characters that may be used as element delimiters, sub-element delimiters, segment terminators, or field separators.  (This includes: asterisk *, pipes |, tabs, linefeeds, carets ^, angle brackets < >, and tildes ~).	
Used	N103	66	Identification Code Qualifier	X		ID 1/2	
	Code designating the system/method of code structure used for Identification Code (67)	
 	1		D-U-N-S Number, Dun & Bradstreet	
 	9		D-U-N-S+4, D-U-N-S Number with Four Character Suffix	
Used	N104	67	Identification Code	X		AN 2/80	
	Code identifying a party or other code	
	Distribution Company Common Code Identifier	
Used	N106	98	Entity Identifier Code	O		ID 2/3	
	Code identifying an organizational entity, a physical location, property or an individual	
 	40		Receiver	
	Entity to accept transmission	
	The receiver is the 'Non-Billing Party'	
 	41		Submitter	
	Entity transmitting transaction set	
	The sender is the 'Billing Party'	

	Segment:	N1 Name {Supplier)
	Position:	040
	Loop:	N1        Optional
	Level:	Heading
	Usage:	Optional
	Max Use:	1
	Purpose:	To identify a party by type of organization, name, and code
	Syntax Notes:	1	At least one of N102 or N103 is required.
		2	If either N103 or N104 is present, then the other is required.
	Semantic Notes:
	Comments:	1	This segment, used alone, provides the most efficient method of providing organizational identification. To obtain this efficiency the "ID Code" (N104) must provide a key to the table maintained by the transaction processing party.
		2	N105 and N106 further define the type of entity in N101.
Notes:		Required	
		N1~SJ~SUPPLY LTD~9~007909422CRN1~~40	

Data Element Summary
	Ref.	Data	
	Des.	Element	Name	Attributes
Must Use	N101	98	Entity Identifier Code	M		ID 2/3	
	Code identifying an organizational entity, a physical location, property or an individual	
 	SJ		Service Provider	
	Identifies name and address information as pertaining to a service provider for which billing is being rendered	
	Supplier	
Used	N102	93	Name	X		AN 1/60	
	Free-form name	
	Supplier Name	
	This free-form text can not contain any characters that may be used as element delimiters, sub-element delimiters, segment terminators, or field separators.  (This includes: asterisk *, pipes |, tabs, linefeeds, carets ^, angle brackets < >, and tildes ~).	
Used	N103	66	Identification Code Qualifier	X		ID 1/2	
	Code designating the system/method of code structure used for Identification Code (67)	
 	1		D-U-N-S Number, Dun & Bradstreet	
 	9		D-U-N-S+4, D-U-N-S Number with Four Character Suffix	
Used	N104	67	Identification Code	X		AN 2/80	
	Code identifying a party or other code	
	Supplier Common Code Identifier	
Used	N106	98	Entity Identifier Code	O		ID 2/3	
	Code identifying an organizational entity, a physical location, property or an individual	
 	40		Receiver	
	Entity to accept transmission	
	The receiver is the 'Non-Billing Party'	
 	41		Submitter	
	Entity transmitting transaction set	
	The sender is the 'Billing Party'	

	Segment:	CS Contract Summary
	Position:	010
	Loop:	CS        Optional
	Level:	Detail
	Usage:	Optional
	Max Use:	1
	Purpose:	To provide information about a contract
	Syntax Notes:	1	If either CS04 or CS05 is present, then the other is required.
	Semantic Notes:	1	CS09 is the permissible overage as a percentage of the total contract line item number (CLIN) quantity.
		2	CS10 is the permissible shortage as a percentage of the total contract line item number (CLIN) quantity.
		3	CS11 is the permissible overage dollar value specified by the contract above which discrepancy action is taken.
		4	CS14 is the Unit of Measure stipulated in the contract.
		5	CS15 is the contract line item number (CLIN) unit price specified in the contract.
		6	CS17 conveys the Critical Application Indicator. A "Y" indicates that a Critical Application Indicator is specified in the contract; an "N" indicates that no Critical Application Indicator is specified in the contract.
		7	CS18 conveys the Special Requirements Indicator. A "Y" indicates that a Special Requirements Indicator (requiring special testing and or evaluation) is specified in the contract; an "N" indicates that no Special Requirements Indicator is specified in the contract.
	Comments:	1	CS04 may be used to identify the Contract Line Item Number (CLIN) or Extended (or Exhibit) Line Item Number (ELIN).
		2	CS07 and CS13 can be used to indicate two different types of special services required.
Notes:		Required	
		It has been agreed that each CS loop will only contain one LX loop (payment detail). This means if there are multiple payments on a specific account, there will be multiple CS loops for that account.	
		CS~~~~12~12345678988~~~~~~-50.00	

Data Element Summary
	Ref.	Data	
	Des.	Element	Name	Attributes
Used	CS04	128	Reference Identification Qualifier	X		ID 2/3	
	Code qualifying the Reference Identification	
	Required	
 	12		Billing Account	
	Account number under which billing is rendered	
	Billing Party-assigned account number for the end use customer.	
Used	CS05	127	Reference Identification	X		AN 1/30	
	Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier	
	Billing Party Account Number	
Used	CS11	782	Monetary Amount	O		R 1/18	
	Monetary amount	
	Total monetary amount allocated for this customer account by the billing party on behalf of the non-billing party or adjustment amount allocated by the billing party on behalf of the non-billing party.

The CS11 will equal the sum of all AMT02 elements under this Distribution Company Customer Account Number.

	Segment:	N9 Reference Identification {Non-Billing Party Account Id)
	Position:	020
	Loop:	CS        Optional
	Level:	Detail
	Usage:	Optional
	Max Use:	3
	Purpose:	To transmit identifying information as specified by the Reference Identification Qualifier
	Syntax Notes:	1	At least one of N902 or N903 is required.
		2	If N906 is present, then N905 is required.
		3	If either C04003 or C04004 is present, then the other is required.
		4	If either C04005 or C04006 is present, then the other is required.
	Semantic Notes:	1	N906 reflects the time zone which the time reflects.
		2	N907 contains data relating to the value cited in N902.
	Comments:
Notes:		Billing Party will store Non-Billing Party and be required to send it if it was previous provided to the Billing Party.	
		N9~11~333444555666	

Data Element Summary
	Ref.	Data	
	Des.	Element	Name	Attributes
Must Use	N901	128	Reference Identification Qualifier	M		ID 2/3	
	Code qualifying the Reference Identification	
 	11		Account Number	
	Number identifies a telecommunications industry account	
	Non-Billing Party Account ID - account number for end use customer.	
Used	N902	127	Reference Identification	X		AN 1/30	
	Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier	
	Customer Account ID assigned by Non-Billing Party.	

	Segment:	N9 Reference Identification {Billing Party Old Account Id)
	Position:	020
	Loop:	CS        Optional
	Level:	Detail
	Usage:	Optional
	Max Use:	3
	Purpose:	To transmit identifying information as specified by the Reference Identification Qualifier
	Syntax Notes:	1	At least one of N902 or N903 is required.
		2	If N906 is present, then N905 is required.
		3	If either C04003 or C04004 is present, then the other is required.
		4	If either C04005 or C04006 is present, then the other is required.
	Semantic Notes:	1	N906 reflects the time zone which the time reflects.
		2	N907 contains data relating to the value cited in N902.
	Comments:
Notes:		RBC	
		Required if Account Number has changed in last 45 days	
		N9~45~212345438756	

Data Element Summary
	Ref.	Data	
	Des.	Element	Name	Attributes
Must Use	N901	128	Reference Identification Qualifier	M		ID 2/3	
	Code qualifying the Reference Identification	
 	45		Old Account Number	
	Identifies accounts being changed	
	Previous Distribution Company assigned account number for end use customer.	
Used	N902	127	Reference Identification	X		AN 1/30	
	Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier	
	Old Customer Account ID assigned by Billing Party.	

	Segment:	REF Reference Identification {Service Identifier)
	Position:	060
	Loop:	REF        Optional
	Level:	Detail
	Usage:	Optional
	Max Use:	1
	Purpose:	To specify identifying information
	Syntax Notes:	1	At least one of REF02 or REF03 is required.
		2	If either C04003 or C04004 is present, then the other is required.
		3	If either C04005 or C04006 is present, then the other is required.
	Semantic Notes:	1	REF04 contains data relating to the value cited in REF02.
	Comments:
Notes:		Required	
		REF~QY~ELECTRIC	

Data Element Summary
	Ref.	Data	
	Des.	Element	Name	Attributes
Must Use	REF01	128	Reference Identification Qualifier	M		ID 2/3	
	Code qualifying the Reference Identification	
 	QY		Service Performed Code	
	Number indicating the type of service performed to repair a product	
	Service Type	
Used	REF02	127	Reference Identification	X		AN 1/30	
	Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier	
 	ELECTRIC		Electric Service	
 	GAS		Natural Gas Service	

	Segment:	LX Assigned Number
	Position:	080
	Loop:	LX        Optional
	Level:	Detail
	Usage:	Optional
	Max Use:	1
	Purpose:	To reference a line number in a transaction set
	Syntax Notes:
	Semantic Notes:
	Comments:
Notes:		Required	
		If there are multiple payments/adjustments on an account number there will be multiple CS loops.  The AMT02 element in this loop for this Billing Party Account Number should match the  CS11 value.	
		LX~1	

Data Element Summary
	Ref.	Data	
	Des.	Element	Name	Attributes
Must Use	LX01	554	Assigned Number	M		N0 1/6	
	Number assigned for differentiation within a transaction set	

	Segment:	N9 Reference Identification {Transaction Reference Number)
	Position:	090
	Loop:	LX        Optional
	Level:	Detail
	Usage:	Mandatory
	Max Use:	1
	Purpose:	To transmit identifying information as specified by the Reference Identification Qualifier
	Syntax Notes:	1	At least one of N902 or N903 is required.
		2	If N906 is present, then N905 is required.
		3	If either C04003 or C04004 is present, then the other is required.
		4	If either C04005 or C04006 is present, then the other is required.
	Semantic Notes:	1	N906 reflects the time zone which the time reflects.
		2	N907 contains data relating to the value cited in N902.
	Comments:
Notes:		Required	
		N9~TN~123223327~~19990225
N9~TN~123223532~CS~19990225 (Adjustment)

Data Element Summary
	Ref.	Data	
	Des.	Element	Name	Attributes
Must Use	N901	128	Reference Identification Qualifier	M		ID 2/3	
	Code qualifying the Reference Identification	
 	TN		Transaction Reference Number	
	Used to provide a unique identification number for this collection/adjustment.	
Used	N902	127	Reference Identification	X		AN 1/30	
	Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier	
	Transaction Tracking Number - Number used for identifying this collection/adjustment.	
Used	N903	369	Free-form Description	X		AN 1/45	
	Free-form descriptive text	
	Adjustment Reason Code.  Only used if AMT01 (within the LX) is equal to "BM"	
 	72		Returned Items	
 	CS		Adjustment	
 	IF		Insufficient Funds	
Used	N904	373	Date	O		DT 8/8	
	Date expressed as CCYYMMDD	
	Date  the payment was posted to the billing party if AMT01 is equal to "KL" or date the adjustment was posted by the billing party if AMT01 is equal to "BM".	

	Segment:	AMT Monetary Amount
	Position:	100
	Loop:	LX        Optional
	Level:	Detail
	Usage:	Optional
	Max Use:	>1
	Purpose:	To indicate the total monetary amount
	Syntax Notes:
	Semantic Notes:
	Comments:
Notes:		Required	
		AMT~KL~25.00
AMT~BM~-130.00

Data Element Summary
	Ref.	Data	
	Des.	Element	Name	Attributes
Must Use	AMT01	522	Amount Qualifier Code	M		ID 1/3	
	Code to qualify amount	
 	BM		Adjustments	
 	KL		Collected Amount	
Must Use	AMT02	782	Monetary Amount	M		R 1/18	
	Monetary amount	
	Collected or adjustment amount allocated to the non-billing party for this customer.

Leading negative sign must be sent if this is a negative number, e.g. in the case of a bounced check to indicate the original check amount is being reversed.  If the amount is positive, no sign is sent.

The sum of all AMT02 elements under this Billing Party Account Number is provided in the CS11.

	Segment:	N1 Name {Customer Name)
	Position:	140
	Loop:	N1        Optional
	Level:	Detail
	Usage:	Optional
	Max Use:	1
	Purpose:	To identify a party by type of organization, name, and code
	Syntax Notes:	1	At least one of N102 or N103 is required.
		2	If either N103 or N104 is present, then the other is required.
	Semantic Notes:
	Comments:	1	This segment, used alone, provides the most efficient method of providing organizational identification. To obtain this efficiency the "ID Code" (N104) must provide a key to the table maintained by the transaction processing party.
		2	N105 and N106 further define the type of entity in N101.
Notes:		Required	
		N1~8R~JOHN Q. CUSTOMER	

Data Element Summary
	Ref.	Data	
	Des.	Element	Name	Attributes
Must Use	N101	98	Entity Identifier Code	M		ID 2/3	
	Code identifying an organizational entity, a physical location, property or an individual	
 	8R		Consumer Service Provider (CSP) Customer	
	End Use Customer	
Used	N102	93	Name	X		AN 1/60	
	Free-form name	

	Segment:	SE Transaction Set Trailer
	Position:	020
	Loop:
	Level:	Summary
	Usage:	Mandatory
	Max Use:	1
	Purpose:	To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments)
	Syntax Notes:
	Semantic Notes:
	Comments:	1	SE is the last segment of each transaction set.
Notes:		Required	
		SE~28~000000001	

Data Element Summary
	Ref.	Data	
	Des.	Element	Name	Attributes
Must Use	SE01	96	Number of Included Segments	M		N0 1/10	
	Total number of segments included in a transaction set including ST and SE segments	
Must Use	SE02	329	Transaction Set Control Number	M		AN 4/9	
	Identifying control number that must be unique within the transaction set functional group assigned by the originator for a transaction set