Tuesday, March 27, 2012

RTLOG File - Main Codes

Main Code

Main Code Descr.

Codes

Codes Descriptions

TRAT

Transaction Types.

OPEN

opening of the cashier

LOAN

loan to the cashier

NOSALE

no sales transactions.

SALE

store sales

RETURN

store customers returns

EEXCH

exchange of items which the total value of the transactions is equal to 0.

VOID

total transaction cancelled

PVOID

transaction to cancel totally a previous transaction

PULL

pulls of cash from the register

PAIDIN

receiving some tenders value for customer services

PAIDOU

pulls of tender value from register for paying store expenses

CLOSE

closing of the cashier

DCLOSE

closing of the day

TOTAL

totals that are defined as coming from POS system to ReSA, like total store sales value or other totals, like total tenders roll-up for each tender.

TRAS

Sub-Transaction Types.

EMP

Employee.

DRIVEO

Fuel Drive Off.

MV

Merchandise Vendor Payout.

EV

Expense Vendor Payout.

EXCH

Exchange in Item Sale/Return transaction.

REAC

Reason Codes.

ACCT

Payment on Account

INC

Incident Payout

NSF

NSF Check Payment

PAYRL

Payroll Payout

LOTWIN

Lottery Winnings

SIGN

Quantity or Values Sign.

P

Positive

N

Negative

CIDT

Customer ID Types.

PHONE

Phone

DL

Drivers License

BNKACT

Bank Account

SSN

Social Security

HSCARD

House Card

VICARD

Visa Card

MCCARD

Mastercard

AXCARD

American Express Card

DSCARD

Discover Card

DCCARD

Diners Club Card

ZIP

Zip Code

IDCODE

Store-defined id code

SACA

Sales Audit Customer Attibutes.

SAGC

Sales Audit Gender Codes

SAIN

Sales Audit Income Codes

SARD

Sales Audit Retailer Defined Codes

SASI

Sales Audit Item Status

V

Voided

S

Sale

R

Return

O

Other

SAIT

Sales Audit Item Types.

ITEM

Item

REF

Reference Item

GCN

Voucher Number

NMITEM

Non Merchandise Item

UPCT

Item Number Type.

ITEM

Retek Item Number

UPC-A

UPC-A

UPC-AS

UPC-A with Supplement

UPC-E

UPC-E

UPC-ES

UPC-E with Supplement

EAN8

EAN8

EAN13

EAN13

EAN13S

EAN13 with Supplement

ISBN

ISBN

NDC

NDC/NHRIC - National Drug Code

PLU

PLU

VPLU

Variable Weight PLU

SSCC

SSCC Shipper Carton

UCC14

SCC-14

ORRC

Override Reason.

D

Damaged Goods

T

Incorrect Tag

S

Incorrect Signage

YSNO

Yes or No.

Y

Yes

N

No

SARR

Sales Audit Return Reason Codes.

01

Damaged

02

Defective

PRMT

RMS Promotion Types.

1000

Mix and Match

1001

Threshold

1002

Multi-Units

1003

Single Item and @MH4 Level

1004

In Store Discount

1005

Employee Discount

1006

Off Retail

1009

Promotions

SADT

Sales Audit Discount Types.

DMGD

Damaged Goods

CUST

Customer Accommodation

SCOUP

Store Coupon

TAXC

Taxes Codes.

STATE

State Tax

CITY

City Tax

TENT

Tender Type Groups.

CASH

Cash

CHECK

Personal Check

CCARD

Credit Card

VOUCH

Voucher (gift cert. or credit)

COUPON

Coupon

MORDER

Money Order

DCARD

Debit Card

DRIVEO

Drive Off

SOCASS

Social Assistance

CASH

Tender Type IDs (POS_Tender_Type_Head table)

1000

Cash

CASH

2020

Traveler Check

CCARD

3000

Visa

CCARD

3010

Mastercard

CCARD

3020

American Express

CCARD

3030

Discover

CCARD

3040

Diners Club - N. America

CCARD

3045

Diners Club - Non-N. America

CCARD

3049

Diners Club - Ancillary

CCARD

3050

WEX

CCARD

3060

Voyageur

CCARD

3070

Unocal

CCARD

3080

enRoute

CCARD

3090

Japanese Credit Bureau

CCARD

3100

Australian Bank Card

CCARD

3110

Carte Blanche - N. America

CCARD

3115

Carte Blanche - Non-N. America

CCARD

3120

House Card

CHECK

2000

Personal Check

CHECK

2010

Cashier Check

CHECK

2030

Electronic Check

COUPON

5000

Manufacturers Coupons

DCARD

8000

Interac

DRIVEO

9000

Fuel Drive Off

MORDER

6000

Money Orders

SOCASS

7000

Food Stamps

SOCASS

7010

Electronic Benefits System -EBS

VOUCH

4000

Credit Voucher

VOUCH

4010

Manual Credit

VOUCH

4020

Manual Imprint

VOUCH

4030

Gift Certificate

VOUCH

4040

Credit Due

CCAS

Credit Card Authorization Source.

E

Electronic

M

Manual

CCVF

Credit Card Verification.

S

Signature Verified

C

Card Shown

P

PIN Entered

M

Mail Order/Phone

E

e-commerce

CCEM

Credit Card Entry Mode.

T

Terminal Used

M1R

Magnetic Strip One Read

M1T

Magnetic Strip One Transmitted

M2R

Magnetic Strip Two Read

M2T

Magnetic Strip Two Transmitted

CCSC

Credit Card Special Conditions.

M

Mail

P

Phone

E

Electronic-secured

N

Electronic-non-secured

No comments: