...

alias="Ringo"

create_date="05/31/2007"

...

Field Name	Size	Description
Customer Number	25	Customer Code.
Customer Name	30	Customer Name.
Customer Address #1	30	Customer Address Line 1.
Customer Address #2	30	Customer Address Line 2.
Customer Address #3	30	Customer Address Line 3.
Customer City	15	Customer City.
Customer State	3	Customer State.
Customer Zip Code	10	Customer Zip.
Customer Country	10	Customer Country.
Customer Phone #1	15	Customer Phone 1.
Customer Phone #2	15	Customer Phone 2.
Customer Phone #3	15	Customer Phone 3.
Customer Create Date	8	Contains the date this customer was added. 'MM/DD/YY'
Add/Delete Flag	1	'A' for ADD, 'D' for DELETE.
Customer Type Code	1	'A' for Active, 'B' for bad check.
Customer Bad Check Id	20	Contains a code used for tracking bad checks; could be drivers lic., ssn, etc.
Card Code	2	Lost card code used for validating swiped card at POS.
Membership Amount	8	Dollar amount sold for membership card discounts.
Line Feed	1	Record separator.

...

AR Customer Balance Import

Imports credit limit changes, or opening balances.

ASCII Delimited Format

customer_acct	char	25	Required: student or customer id
agency_number	char	25	Required: must match account code from Acct Maint
current_balance	money		Will always use a “0” unless a custom interface sends the balance. not used.
credit_limit	money		credit limit for student this depends on b_set_credit_limit setting and the Set Account Limit in Account Maintainance. 0 is unlimited unless the limit is set then it is actually zero.
b_set_credit_limit	int		0 or N leaves the Set Limit unchecked. 1 or Y Checks the set limit for the account.
status OR status	char int		Required: "A"ctive, "I" = Inactive Required: "1" = active, "0" = inactive
start_date	datetime		“07/06/2006” no charges before this date
end_date	datetime		“08/26/2006” no charges after this date
po_number	char	25	Not used used to be voucher/po number
b_open_balance	int		Always use a “0” unless a custom interface wants to create an opening balance record
b_delete	int		Required: “0”= add, “1” = delete

If you want to stop a customer from charging either send the inactive flag or a new expiration date. Once the account limit is set by using a 1 in b_set_credit_limit it can only be changed back manually.

PrismCore Import_AR_Customer_Balance Table Names

(Use this for interfaces that bypass WPConsole and go directly to prism_trn)

Column	Data Type	Length	Prec	Scale	Description
customer_acct_id	int	4	10	0	Index Key
customer_acct	char	25	25		Customer ID
agency_number	char	25	25		Account Code
current_balance	money	8	19	4	Not used will be 0
credit_limit	money	8	19	4	Credit Limit
start_date	datetime	8	23	3	First date can charge
end_date	datetime	8	23	3	Last date can charge
b_set_credit_limit	tinyint	1	3	0	Credit Limit 0=unlimited 1=set limit
b_delete	tinyint	1	3	0	is always set to 0.
b_active	tinyint	1	3	0	1=active, 0=inactive
b_set_balance	tinyint	1	3	0	0=Leave unchecked, 1=Set Limit
tm_stamp	timestamp	8	8		SQL timestamp

XML Definition

All attributes are CDATA #IMPLIED.

Example:

<?xml version="1.0"?>

<trn_ar_cust_bal_imports>

<trn_ar_cust_bal_import

acct_num="C-17839"

code="BAD CHECKS "

curr_balance="150.0000"

cred_limit="12345.0000"

unlimited="1"

status="I"

start_date="07/04/2006"

exp_date="07/04/2008"

ponum="PONumber for C-17839"

b_open_balance="0"

b_delete="0"

/>

</trn_ar_cust_bal_imports>

PRISM Import Format for AR Customer Balance

Balance Record

Filename = Bxxxxxxx.yyy xxxxxxx = unique number, yyy=store number

Record Size: 122 bytes

Field Name	Size	Description
Customer Code	25	REQUIRED FIELD.
Account Code	25	REQUIRED FIELD.
Current Balance	8	COMPUTED IN-HOUSE FIELD. LEAVE BLANK
Credit Limit	8	OPTIONAL FIELD.
Limit Credit	1	OPTIONAL FIELD. This is a 0/1 field that indicates if the credit limit should be observed.
Add/Delete Flag	1	REQUIRED FIELD. 'A' for ADD, 'D' for DELETE.
Status	1	REQUIRED FIELD. 'A'=Active, 'I'=Inactive
Start Date	8	OPTIONAL FIELD. Start date of this account in the form 'MM/DD/YY'. If leaving blank, please include the slashes.
Expire Date	8	OPTIONAL FIELD. Expiration date of this account in the form 'MM/DD/YY'. If leaving blank, please include the slashes.
Last Payment Date	8	IN-HOUSE FIELD. LEAVE BLANK.
Payment Amount	8	IN-HOUSE FIELD. LEAVE BLANK.
Standing PO #	20	OPTIONAL FIELD. Requisition #
Line Feed	1	OPTIONAL FIELD. Use for record separators.

AR Customer Balance Export

Exports any credit limit or balance changes for a customer.

PrismCore Export_AR_Customer_Balance Table Names

(Use this for interfaces that bypass WPConsole and go directly to prism_trn)

Column	Data Type	Length	Prec	Scale	Description
customer_acct_id	int	4	10	0	Index Key
customer_acct	char	25	25		Customer ID
agency_number	char	25	25		Account Code
current_balance	money	8	19	4	Balance for this account
credit_limit	money	8	19	4	Credit limit for this account
start_date	datetime	8	23	3	First date can charge
end_date	datetime	8	23	3	Last date can charge
b_set_credit_limit	tinyint	1	3	0	1=Credit Limit set 0=Credit Limit Not set
b_delete	tinyint	1	3	0	Will be 0
b_active	tinyint	1	3	0	1=Active
tm_stamp	timestamp	8	8		SQL Timestamp

ASCII Delimited Format

customer_acct	char	25	Customer ID
agency_number	char	25	Account Code
current_balance	money		Balance for this account
credit_limit	money		Credit limit for this account
start_date	datetime		First date can charge
end_date	datetime		Last date can charge
b_set_credit_limit	int		1=Credit Limit set 0=Credit Limit
b_delete	int		Will be 0
b_active	int		1=Active

XML Definition

The XML definition uses the same fields as the ASCII Formats.

Note: some fields will be omitted if there is no corresponding data. All attributes are CDATA #IMPLIED.

Example:

<?xml version="1.0"?>

<trn_ar_cust_bal_exports>

<trn_ar_cust_bal_export

customer_acct="C-17839"

agency_number="BAD CHECKS"

current_balance="150.0000"

credit_limit=".0000"

start_date="01/01/1970"

end_date="01/01/1970"

b_set_credit_limit="0"

b_delete="0"

b_active="1"

/>

<trn_ar_cust_bal_export

customer_acct="C-17839"

agency_number="00000168"

current_balance="-1109.7300"

credit_limit="1175.5400"

start_date="01/01/2001"

end_date="03/11/2004"

b_set_credit_limit="1"

b_delete="0"

b_active="1"

/>

</trn_ar_cust_bal_exports>

PRISM Export Format for AR Customer Balance

Balance Record

Filename = Bxxxxxxx.yyy xxxxxxx = unique number, yyy=store number

Record Size: 122 bytes

Field Name	Size	Description
Customer Code	25	Customer Code.
Account Code	25	Account Code.
Current Balance	8	COMPUTED IN-HOUSE FIELD.
Credit Limit	8	Credit Limit.
Limit Credit	1	This is a 0/1 field that indicates if the credit limit should be observed.
Status	1	'1'=Active, '0'=Inactive
Start Date	8	Start date of this account in the form 'MM/DD/YY'.
Expire Date	8	Expiration date of this account in the form 'MM/DD/YY'.
Standing PO #	20	Requisition #
Add/Delete Flag	1	'0' for ADD/EDIT, '1' for DELETE
Last Payment Date	8	Last Payment Date.
Payment Amount	8	Payment Amount.
Line Feed	1	Used for record separators.

AR Agency Import

Imports Account information into Account Maintenance.

PrismCore Import_AR_Agency Table Names

(Use this for interfaces that bypass WPConsole and go directly to prism_trn)

Column	Data Type	Length	Prec	Scale	Description
agency_number	char	25	25		Account Code
agency_name	char	80	80		Account Description
address_1	char	80	80		Street Address
address_2	char	80	80		2^nd Line of Street Address
address_3	char	80	80		3^rd Line of Street Address
city	char	40	40		City for Account Address
state	char	4	4		State for Account Address
postal_code	char	20	20		Zip/Postal Code for Account Address
country	char	24	24		Country for Account Address
phone_1	char	16	16		1^st Phone for Account
phone_2	char	16	16		2^nd Phone for Account
phone_3	char	16	16		3^rd Phone for Account
agency_comment	varchar	255	255		Comment on Account
tax_exempt_id	char	25	25		Tax Exempt ID
agency_priority	int	4	10	0	Multi Account Priority number
tender_code	char	2	2		POS code of Tender linked to Account
discount_code	char	4	4		POS code of Discount linked to Account
change_limit	money	8	19	4	Maximum Amount of change permitted
dcc_array	varchar	300	300		6 Digit permissible DCC’s concatenate the DCC’s together
discount_array	varchar	150	150		6 Digit permissible DCC’s concatenate the DCC’s together
b_change_due	tinyint	1	3	0	0=No Change due 1=Permit Change Due
b_tax_exempt	tinyint	1	3	0	0= taxable; 1=tax exempt
b_open_drawer	tinyint	1	3	0	0=Do not open Drawer 1=Open Drawer
b_delete	tinyint	1	3	0	Required: 0= add, 1 = delete
b_debit	tinyint	1	3	0	Required: 0=debit, 1=credit, 2=Bad Check.
b_set_credit_limit	tinyint	1	3	0	0=Do not set limit 1=Set Credit Limit
f_print_endorse	tinyint	1	3	0	0
f_agency_type	tinyint	1	3	0	B=Bad Check, C=Campus, D=Catalogue Sales, F=Financial Aid, G=Gift Certificate, R=Revolving, S=Special Orders, X=Store Defined
f_agency_status	tinyint	1	3	0	Required: “0” = inactive, “1” = active
f_discount_type	tinyint	1	3	0	0=Off Retail 1=Above Cost
agency_id	int	4	10	0	Null
tm_stamp	timestamp	8	8		SQL timestamp

ASCII Delimited Format

Account_Type	char	1	Required: 'B' - Bad Check 'C' - Campus 'D' - Catalogue Sales 'F' - Financial Aid 'G' - Gift Certificate 'R' - Revolving 'S' - Special Orders 'X' - Store Defined
agency_number	char	25	Required: account code
agency_name	char	80	Account Description
address_1	char	80	Street Address
address_2	char	80	2^nd Line of Street Address
address_3	char	80	3^rd Line of Street Address
city	char	40	City for Account Address
state	char	4	State for Account Address
postal_code	char	20	Zip/Postal Code for Account Address
country	char	24	Country for Account Address
phone_1	char	16	1^st Phone for Account
phone_2	char	16	2^nd Phone for Account
phone_3	char	16	3^rd Phone for Account
tax_exempt_id	char	25	Tax Exempt ID
agency_comment	varchar	255	Comment on Account
tender_code	char	2	POS code of Tender linked to Account
discount_code	char	4	POS code of Discount linked to Account
agency_priority	int		Multi Account Priority number
change_limit	money		Maximum Amount of change permitted
b_change_due	int		0=No Change due 1=Permit Change Due
b_tax_exempt	int		0= taxable; 1=tax exempt
b_open_drawer	int		0=Do not open Drawer 1=Open Drawer
f_print_endorse	int		0
f_status	int		Required: 0=inactive, 1=active
b_debit	int		Required: 0=debit, 1=credit, 2=Bad Check
f_discount_type	int		0=Off Retail 1=Above Cost
b_set_credit_limit	int		0=Do not set limit 1=Set Credit Limit
dcc_array	varchar	300	6 Digit permissible DCC’s concatenate the DCC’s together maximum of 50 DCC’s
discount_array	varchar	150	6 Digit permissible DCC’s concatenate the DCC’s together
b_delete	tinyint	1	Required: “0”= add, “1” = delete

XML Definition

All attributes are CDATA #IMPLIED.

<?xml version="1.0"?>

<trn_ar_agency_imports>

<trn_ar_agency_import

acct_type="R"

acct_number="TestMeAcctAgency1"

acct_name="TestMeAcctAgency1 Name"

acct_addr1="5540 Shady Creek Ct"

acct_addr2="Apartment 16"

acct_addr3="PO Box 156"

city="Lincoln"

state="NE"

zip="68516"

country="USA"

phone1="402-423-6530"

phone2="402-333-7047"

phone3="402-697-0845"

acct_fed_id="0"

acct_cmt="Comment for TestMeAcctAgency1"

acct_tender_code="12"

acct_disc_code="0"

acct_priority="1"

change_limit=".0000"

fchange_due="0"

ftax_exempt="0"

fopen_drawer="0"

fprinter_endorse="0"

fstatus="1"

fdorc="2"

fdisc_type="0"

fset_cred_limit="0"

dcc_list="10 20 30 70"

dcc_disc="100100100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"

b_delete="0"

/>

</trn_ar_agency_imports>

PRISM Import Format for AR Agency Import

Filename = Axxxxxxx.yyy xxxxxxx = unique number, yyy=store number

Record Size: 775 bytes

Field Name	Size	Description
Account Type	1	REQUIRED FIELD. 'B' - Bad Check 'C' - Campus 'D' - Catalogue Sales 'F' - Financial Aid 'G' - Gift Certificate 'R' - Revolving 'S' - Special Orders 'X' - Store Defined
Account Code	25	Required FIELD account code.
Account Name	30	Required FIELD Account Description.
Account Address #1	30	OPTIONAL FIELD Street Address.
Account Address #2	30	OPTIONAL FIELD 2^nd Line of Street Address.
Account Address #3	30	OPTIONAL FIELD 3^rd Line of Street Address.
Account City	15	OPTIONAL FIELD City for Account Address.
Account State	3	OPTIONAL FIELD State for Account Address.
Account Zip Code	10	OPTIONAL FIELD Zip/Postal Code for Account Address.
Account Country	10	OPTIONAL FIELD Country for Account Address.
Account Phone #1	15	OPTIONAL FIELD 1^st Phone for Account.
Account Phone #2	15	OPTIONAL FIELD 2^nd Phone for Account.
Account Phone #3	15	OPTIONAL FIELD 3^rd Phone for Account.
Account Tax Exempt	1	OPTIONAL FIELD 0= taxable; 1=tax exempt.
Account Comment	60	OPTIONAL FIELD Comment on Account.
Account Tender Code	2	OPTIONAL FIELD POS code of Tender linked to Account.
Change Due Flag	1	OPTIONAL FIELD 0=No Change due 1=Permit Change Due.
Change Limit	8	OPTIONAL FIELD Maximum Amount of change permitted.
Open Cash Drawer	1	OPTIONAL FIELD 0=Do not open Drawer 1=Open Drawer.
Printer Endorse	1	OPTIONAL FIELD. This field indicates to the POS system which tender endorsement to use: 0 = None 1 = Check 2 = Gift Certificate 3 = Travelers Check 4 = Credit Memo 7 = Full Sheet 9 = Half Sheet
Allowable DCC 6*50	300	OPTIONAL FIELD 6 Digit permissible DCC’s concatenate the DCC’s together maximum of 50 DCC’s
Discount % by DCC 3*50	150	OPTIONAL FIELD. This is a list of up to 50 discount percentages to automatically apply to the corresponding DCC's. These are stored with no decimal point. (xx.y = xxy).
Add/Delete Flag	1	REQUIRED FIELD. 'A' for ADD, 'D' for DELETE.
Account Status	1	REQUIRED FILED 0=inactive, 1=active.
Discount Code	3	OPTIONAL FIELD. This is the numeric discount code to use on the POS system for discounted DCC sales.
Account Federal ID	10	OPTIONAL FIELD. This is the federal tax id to be used if the account is tax exempt.
Debit or Credit	1	'D'ebit, 'C'redit, or 'B'ad check
Discount type	1	'0' = off retail, '1' = above cost
Credit Limit	1	'1' = Set account limit '0' = Unlimited
Priority	3	Numeric Multi-Account Priority Level 0 = do not select. Otherwise select in order of lowest to highest.
Line Feed	1	OPTIONAL FIELD. Use for record separators.

AR Agency Export

Exports any agencies that have been added, deleted or updated.

PrismCore Export_AR_Agency Table Names

(Use this for interfaces that bypass WPConsole and go directly to prism_trn)

Column	Data Type	Length	Prec	Scale	Description
agency_number	char	25	25		Account Code
agency_name	char	80	80		Account Description
address_1	char	80	80		Street Address
address_2	char	80	80		2nd Line of Street Address
address_3	char	80	80		3rd Line of Street Address
city	char	40	40		City for Account Address
state	char	4	4		State for Account Address
country	char	24	24		Country for Account Address
postal_code	char	20	20		Zip/Postal Code for Account Address
phone_1	char	16	16		1st Phone for Account
phone_2	char	16	16		2nd Phone for Account
phone_3	char	16	16		3rd Phone for Account
agency_comment	varchar	255	255		Comment on Account
tax_exempt_id	char	25	25		Tax Exempt ID
agency_priority	int	4	10	0	Multi Account Priority number
tender_code	char	2	2		POS code of Tender linked to Account
discount_code	char	4	4		POS code of Discount linked to Account
change_limit	money	8	19	4	Maximum Amount of change permitted
dcc_array	varchar	300	300		6 Digit permissible DCC’s concatenated together
discount_array	varchar	150	150		6 Digit permissible DCC’s concatenate the DCC’s together
b_change_due	tinyint	1	3	0	0=No Change due 1=Permit Change Due
b_tax_exempt	tinyint	1	3	0	0= taxable; 1=tax exempt
b_open_drawer	tinyint	1	3	0	0=Do not open Drawer 1=Open Drawer
b_delete	tinyint	1	3	0	0= add, 1 = delete
b_debit	tinyint	1	3	0	0=debit, 1=credit, 2=Bad Check
b_set_credit_limit	tinyint	1	3	0	0=Do not set limit 1=Set Credit Limit
f_print_endorse	tinyint	1	3	0	0
f_agency_type	tinyint	1	3	0	B=Bad Check, C=Campus, D=Catalogue Sales, F=Financial Aid, G=Gift Certificate, R=Revolving, S=Special Orders, X=Store Defined
f_agency_status	tinyint	1	3	0	0=inactive, 1=active
f_discount_type	tinyint	1	3	0	0=Off Retail 1=Above Cost
agency_id	int	4	10	0	AgencyID from Acct_Agency
tm_stamp	timestamp	8	8		SQL timestamp

ASCII Delimited Format

f_Agency_Type	char	1	'B' - Bad Check 'C' - Campus 'D' - Catalogue Sales 'F' - Financial Aid 'G' - Gift Certificate 'R' - Revolving 'S' - Special Orders 'X' - Store Defined
agency_number	char	25	Account Code
agency_name	char	80	Account Description
address_1	char	80	Street Address
address_2	char	80	2nd Line of Street Address
address_3	char	80	3rd Line of Street Address
city	char	40	City for Account Address
state	char	4	State for Account Address
country	char	24	Country for Account Address
postal_code	char	20	Zip/Postal Code for Account Address
phone_1	char	16	1st Phone for Account
phone_2	char	16	2nd Phone for Account
phone_3	char	16	3rd Phone for Account
b_tax_exempt	int	1	0=taxable; 1=tax exempt
agency_comment	varchar	255	Comment on Account
tender_code	char	2	POS code of Tender linked to Account
b_change_due	int	1	0=No Change due 1=Permit Change Due
change_limit	money	8	Maximum Amount of change permitted
b_open_drawer	int	1	0=Do not open Drawer 1=Open Drawer
f_print_endorse	int	1	0=No Endorse, 8=Prism POS Half Sheet
dcc_array	varchar	300	6 Digit permissible DCC’s concatenated together
discount_array	varchar	150	6 Digit permissible DCC’s concatenated together
b_delete	tinyint	1	0= add, 1 = delete
f_status	int	1	0=inactive, 1=active
discount_code	char	4	POS code of Discount linked to Account
tax_exempt_id	char	25	Tax Exempt ID
b_debit	int	1	0=debit, 1=credit, 2=Bad Check
f_discount_type	int	1	0=Off Retail 1=Above Cost
b_set_credit_limit	int	1	0=Do not set limit 1=Set Credit Limit
agency_priority	int	1	Multi Account Priority number

XML Definition

The XML definition uses the same fields as the ASCII Formats. Note: some fields will be omitted if there is no corresponding data. All attributes are CDATA #IMPLIED.

<?xml version="1.0"?>

<trn_ar_agency_exports>

<trn_ar_agency_export

f_agency_type="F"

agency_number="TestMeAcctAgencyCODEwes" agency_name="TestMeAcctAgencyNAMEwes"

address_1="5240 Shady Creek Ct."

address_2="Apartment 25"

address_3=""

city="Omaha"

state="NE"

country="US"

postal_code="68544"

phone_1="402-692-7777"

phone_2=""

phone_3=""

b_tax_exempt="0"

agency_comment="TestMeAcctAgencyCOMMENTwes"

tender_code="12"

b_change_due="0"

change_limit=".0000"

b_open_drawer="0"

f_print_endorse="0"

dcc_array="10 30" discount_array="000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000"

b_delete="1"

f_agency_status="1"

discount_code="0"

tax_exempt_id=""

b_debit="C"

f_discount_type="0"

b_set_credit_limit="0"

agency_priority=""

/>

</trn_ar_agency_exports>

PRISM Export Format for AR Agency Export

Filename = Axxxxxxx.yyy xxxxxxx = unique number, yyy=store number

Record Size: 775 bytes

Field Name	Size	Description
Account Type	1	Includes the following account types: 'B' - Bad Check 'C' - Campus 'D' - Catalogue Sales 'F' - Financial Aid 'G' - Gift Certificate 'R' - Revolving 'S' - Special Orders 'X' - Store Defined
Account Code	25	Account Code.
Account Name	30	Account Name.
Account Address #1	30	Account Address Line 1.
Account Address #2	30	Account Address Line 2.
Account Address #3	30	Account Address Line 3.
Account City	15	Account Code.
Account State	3	Account State.
Account Country	10	Account Country.
Account Zip Code	10	Account Zip Code.
Account Phone #1	15	Account Phone #1.
Account Phone #2	15	Account Phone #2.
Account Phone #3	15	Account Phone #3.
Account Tax Exempt	1	This is a 0/1 flag that indicates to the POS system that this account is tax exempt.
Account Comment	60	Comment.
Account Tender Code	2	This is the numeric tender code used in the POS system.
Change Limit	1	This is a 0/1 flag that indicates to the POS system if change is allowed.
Change Limit	8	This is a numeric field that indicates to the POS system the amount of change allowed.
Open Cash Drawer	1	This is a 0/1 flag that indicates to the POS system if the cash drawer should be opened for this tender.
Printer Endorse	1	This field indicates to the POS system which tender endorsement to use: 0 = None 1 = Check 2 = Gift Certificate 3 = Travelers Check 4 = Credit Memo 7 = Full Sheet 9 = Half Sheet
Allowable DCC 6*50	300	This is a list of up to 50 allowable DCC's for this account.
Discount % by DCC 3*50	150	This is a list of up to 50 discount percentages to automatically apply to the corresponding DCC's. These are stored with no decimal point. (xx.y = xxy).
Add/Delete Flag	1	'A' for ADD, 'D' for DELETE.
Account Status	1	This is a 0/1 flag used to indicate 0=Inactive or 1=Active
Discount Code	3	This is the numeric discount code to use on the POS system for discounted DCC sales.
Account Federal ID	10	This is the federal tax id to be used if the account is tax exempt.
Debit or Credit	1	'D'ebit, 'C'redit, or 'B'ad check
Discount type	1	'0' = off retail, '1' = above cost
Credit Limit	1	'1' = Set account limit '0' = Unlimited
priority	3	Numeric Multi-Account Priority Level 0 = do not select. Otherwise select in order of lowest to highest.
Line Feed	1	Used for record separators.

AR Receipt Export

Exports all mail order, and POS receipt totals that have an A/R invoice.

PrismCore Export_AR_Customer_Receipt Table Names

(Use this for interfaces that bypass WPConsole and go directly to prism_trn)

Column	Data Type	Length	Prec	Scale	Description
receipt_id	int	4	10	0	Index Key
store_id	int	4	10	0	POSID of Store
invoice_id	int	4	10	0	InvoiceID code
customer_acct	char	25	25		CustomerID
agency_number	char	25	25		Account Description
receipt_number	char	25	25		Receipt Number
cashier	char	30	30		Cashier Name
receipt_date	datetime	8	23	3	Date of Receipt
receipt_total	money	8	19	4	Total Amount of receipt
tax_total	money	8	19	4	Total Tax on receipt
tax_exempt_total	money	8	19	4	Tax Exempt amount on receipt
ship_total	money	8	19	4	Amount of Shipping on receipt
discount_total	money	8	19	4	Total Discount amount on receipt
tender_total	money	8	19	4	Amount tendered on receipt
status	tinyint	2	3	0	89 BUYBACK, 65 CANCELLED, 67 CHECK CASHING, 88 CLOSING (EX), 78 NO SALE, 73 PAY IN, 79 PAY OUT, 0 POST VOID/SUSPENDED, 86 POST VOIDED, 82 REFUND, 83 SALE or EXCHANGE, 66 SUSPENDED
tran_code	char	2	2		AS Account Sale, SA Sale, RT Refund, AR Account Refund
request_number	char	25	25		Requisition Number
tm_stamp	timestamp	8	8		SQL timestamp

ASCII Delimited Format

customer_acct	char	25	CustomerID
agency_number	char	25	Account Code
receipt_number	char	25	Receipt Number
cashier	char	30	Cashier Name
receipt_date	datetime		Date of Receipt
receipt_total	money		Total Amount of receipt
tax_total	money		Total Tax on receipt
tax_exempt_total	money		Tax Exempt amount on receipt
ship_total	money		Amount of Shipping on receipt
discount_total	money		Total Discount amount on receipt
tender_total	money		Amount tendered on receipt
status	int	2	89 BUYBACK, 65 CANCELLED, 67 CHECK CASHING, 88 CLOSING (EX), 78 NO SALE, 73 PAY IN, 79 PAY OUT, 0 POST VOID/SUSPENDED, 86 POST VOIDED, 82 REFUND, 83 SALE or EXCHANGE, 66 SUSPENDED
tran_code	char	2	AS Account Sale, SA Sale, RT Refund, AR Account Refund, PI PayIn, PO PayOut
request_number	char	25	Requisition Number
store_id	int		POSID of Store

XML Definition

The XML definition uses the same fields as the ASCII Formats. Note: some fields will be omitted if there is no corresponding data. All attributes are CDATA #IMPLIED.

<?xml version="1.0"?>

<trn_ar_rcpt_exports>

<trn_ar_rcpt_export

customer_acct="001"

agency_number="100"

receipt_number="RC-000047-5"

cashier="PrismCore Admin"

receipt_date="06/04/2007"

receipt_total="87.3000"

tax_total="4.3700"

tax_exempt_total=".0000"

ship_total=".0000"

discount_total=""

tender_total="91.6700"

status="83"

tran_code="AS"

request_number=""

store_id="2"

/>

</trn_ar_rcpt_exports>

PRISM Export Format for AR Receipt Export

Filename = Hxxxxxxx.yyy xxxxxxx = unique number, yyy=store number

Notes:

Although the receipt_number field is defined as having a maximum length of 25 characters in the ASCII formats listed above, the PRISM format for Receipt Number (Transaction Number) is only 10 characters max. The same applies for AR Receipt Detail Export, i.e., Transaction (Transaction Number).
Concerning the PRISM format, other fields may have a different maximum size as compared to their ASCII counterparts as well, including the cashier field, etc. Just be aware of this and exercise due caution when using the various formats.

Field	Description	Length	Condition
Customer	Customer Code	25
Account	Charge Account Code	25
Transaction Date	Transaction Date	8	MM/DD/YY
Receipt Number	Transaction Number	10
Cashier	Cashier Login Id	10
Merchandise	Merchandise Total	8	No Decimal
Non Merchandise	Non Merchandise Total	8	No Decimal
Item Discounts	Total Item Discounts	8	No Decimal
Transaction Disc	Total Transaction Discount	8	No Decimal
Total Taxes	Total Taxes Paid	8	No Decimal
Transaction Tot	Transaction Total (All Items Less Tax)	8	No Decimal
Tender Total	Total Amount Tendered	8	No Decimal
Change Total	Total Change	8	No Decimal
Transaction Time	Transaction Time (HHMM military format)	4	(HHMM)
Total Lines	Total Transaction Lines	4
Exchanged Amount	Merchandise Exchanged Amount	8	No Decimal
Tax Exempt Total	Tax Exempt Total	8	No Decimal
Trans Dsc Per	Transaction Discount percent	4	No Decimal
Item Discount	Item Discount amount	8	No Decimal
Payin Amount	Payin/Payout Amount	8	No Decimal
Charged Amount	Amount Charged to this Account	8	No Decimal
Tender Code #1	POS Tender Code #1	2
Tender Code #2	POS Tender Code #2	2
Tender Code #3	POS Tender Code #3	2
Tender Code #4	POS Tender Code #4	2
Tender Code #5	POS Tender Code #5	2
Tender Amt #1	Tender Amount #1	8	No Decimal
Tender Amt #2	Tender Amount #2	8	No Decimal
Tender Amt #3	Tender Amount #3	8	No Decimal
Tender Amt #4	Tender Amount #4	8	No Decimal
Tender Amt #5	Tender Amount #5	8	No Decimal
Change Due	Amount of Change Due	8	No Decimal
Store	POS Store Number	3
Register	POS Register Number	3
Trans Disc Code	POS Transaction Discount Code	3
Payin Code	POS Payin Code	3
Manual Tax	Manual Tax (1=yes,0=No)	1	(0 or 1)
Tax Exempt #	Tax Exempt Number	10
Type	Filler	1
Transaction Code	Type of Transaction	2	(SA = sale, RT = Return, PV = Post Void, PI = Payin, PO = Payout)
Apply Number	POS entered apply number for payment	20
Create Date	Date Transaction was created	8	MM/DD/YY
Items	Total Items on Transaction	4
Status	Status	1	(S = Sales, R = Returns, V = Post Void, I = Payin, O = Payout)
		311 Bytes

AR Receipt Detail Export

Exports all mail order and POS receipt details that have an A/R invoice.

PrismCore Export_AR_Customer_Receipt_Detail Table Names

(Use this for interfaces that bypass WPConsole and go directly to prism_trn)

Column	Data Type	Length	Prec	Scale	Description
receipt_dtl_id	int	4	10	0	Index Key
receipt_id	int	4	10	0	Null
invoice_detail_id	int	4	10	0	Link to Invoice Detail
store_id	int	4	10	0	POSID of Store
customer_acct	char	25	25		CustomerID
agency_number	char	25	25		Account Code
receipt_number	char	25	25		Receipt Number
receipt_date	datetime	8	23	3	Date of Receipt
cat_isbn	char	20	20		ISBN of Book
dcc_code	char	10	10		6 digit DCC code for item
description	char	128	128		Description of item
sku	int	4	10	0	SKU of item
quantity	int	4	10	0	Quantity of item
price	money	8	19	4	Price per unit of item
discount	money	8	19	4	Amount of discount for item
tax	money	8	19	4	Tax on item
tm_stamp	timestamp	8	8		SQL timestamp

ASCII Delimited Format

customer_acct	char	25	CustomerID
agency_number	char	25	Account Code
receipt_number	char	25	Receipt Number
receipt_date	datetime		Date of Receipt
cat_isbn	char	20	ISBN of Book
dcc_code	char	10	6 digit DCC code for item
description	char	28	Description of item
sku	int		SKU of item
quantity	int		Quantity of item
price	money		Price per unit of item
discount	money		Amount of discount for item
tax	money		Tax on item
store_id	int		POSID of Store

XML Definition

The XML definition uses the same fields as the ASCII Formats. Note: some fields will be omitted if there is no corresponding data. All attributes are CDATA #IMPLIED.

<?xml version="1.0"?>

<trn_ar_rcpt_dtl_exports>

<trn_ar_rcpt_dtl_export

customer_acct="001"

agency_number="100"

receipt_number="RC-000047-5"

receipt_date="06/04/2007"

cat_isbn="978-0-415-56426-7"

dcc_code="201010"

description="CAMPBELL / ESSENTIAL BIOLOGY WITH PHYSIOLOGY (W/CD )"

sku="10000045"

quantity="1"

price="59.0700"

discount=".0000"

tax="2.8200"

store_id="2"

/>

</trn_ar_rcpt_dtl_exports>

PRISM Format for AR Receipt Detail Export

Filename = Ixxxxxxx.yyy xxxxxxx = unique number, yyy=store number

Note: Although the receipt_number field is defined as having a maximum length of 25 characters in the ASCII formats listed above, the PRISM format for Transaction (Transaction Number) is only 10 characters max. The same applies for AR Receipt Export, i.e., Receipt Number (Transaction Number).

Field	Description	Length	Condition
Transaction	Transaction Number	10
Line Number	Transaction Line	10
Catalog/ISBN	Catalog ISBN Number	15
DCC Code	Item Department/Class/Category	6
Description	Item Description	25
Item SKU	Item SKU number	8
Quantity	Quantity Sold	6
Item Price	Item Price	8
Extended Price	Extended Price (Quantity * Item Price)	8
Item Discount	Item Discount Amount	8
Non Merch Amount	Non Merchandise Amount	8
Non Merch Code	POS Non Merchandise Code	3
Item Disc Code	POS Item Discount Code	3
Item Disc Rate	POS Item Discount Rate	8	No Decimal
Store	POS Store Number	3
Transaction Disc	Transaction Discount for this item	8	No Decimal
Customer	Customer Code	25
Account	Charge Account Code	25
Tax Amount	Tax Amount for this item	8	No Decimal
		195 Bytes

Versions Compared

Old Version 2

New Version Current

Key

AR Customer Balance Import

ASCII Delimited Format

PrismCore Import_AR_Customer_Balance Table Names

XML Definition

PRISM Import Format for AR Customer Balance

AR Customer Balance Export

PrismCore Export_AR_Customer_Balance Table Names

ASCII Delimited Format

XML Definition

PRISM Export Format for AR Customer Balance

AR Agency Import

PrismCore Import_AR_Agency Table Names

ASCII Delimited Format

XML Definition

PRISM Import Format for AR Agency Import

AR Agency Export

PrismCore Export_AR_Agency Table Names

ASCII Delimited Format

XML Definition

PRISM Export Format for AR Agency Export

AR Receipt Export

PrismCore Export_AR_Customer_Receipt Table Names

ASCII Delimited Format

XML Definition

PRISM Export Format for AR Receipt Export

AR Receipt Detail Export

PrismCore Export_AR_Customer_Receipt_Detail Table Names

ASCII Delimited Format

XML Definition

PRISM Format for AR Receipt Detail Export

Page Comparison

Versions Compared

Old Version 2

New Version Current

Key

AR Customer Balance Import

ASCII Delimited Format

PrismCore Import_AR_Customer_Balance Table Names

XML Definition

PRISM Import Format for AR Customer Balance

AR Customer Balance Export

PrismCore Export_AR_Customer_Balance Table Names

ASCII Delimited Format

XML Definition

PRISM Export Format for AR Customer Balance

AR Agency Import

PrismCore Import_AR_Agency Table Names

ASCII Delimited Format

XML Definition

PRISM Import Format for AR Agency Import

AR Agency Export

PrismCore Export_AR_Agency Table Names

ASCII Delimited Format

XML Definition

PRISM Export Format for AR Agency Export

AR Receipt Export

PrismCore Export_AR_Customer_Receipt Table Names

ASCII Delimited Format

XML Definition

PRISM Export Format for AR Receipt Export

AR Receipt Detail Export

PrismCore Export_AR_Customer_Receipt_Detail Table Names

ASCII Delimited Format

XML Definition

PRISM Format for AR Receipt Detail Export