What's on your clipboard right now?
This file shows you how to make text files to import into Posim. The first column
Shows you the import code to use. In a Posim Import file, each line must have an import code.
For example, the import code UITM is used to add inventory items to your database.
You would enter UITM as the import code -- without the "*" -- the asterisk means that the line
is a comment and will be skipped.
For an example of an import file, see the file named "Sample Data".
Item Card
* UITM Prev Item ID Item ID Description Manufacturer Mfr Item ID Vendor ID Vendor Cost Vendor Item ID Vendor Lead Time Last Cost Avg Cost Sugg Retail Our Retail Avg Retail Available Leave Blank Max Stock Reorder Pt Misc #1 Misc #2 Misc #3 Misc #4 Misc #5 Commission Tax Serial Num Issuage Bar Code Type Price Code Reorder Lot Unit In Qty/Unit Case Cost Case Price Itemize Components Track Inv Acct Group Code Print Code Updt Ven Cost Units Sold Style Row Column Location Transfer Group Committed Leave Blank Date Created Last Update Remote Vendor TransCode Active Web Item Out of Stock Mesg Short Web Desc Web Title Leave Blank Leave Blank itemRewardCode UnitOfMeasure
* AITM Item ID Description Manufacturer Mfr Item ID Vendor ID Vendor Cost Vendor Item ID Ignored Vendor Lead Time Last Cost Avg Cost Sugg Retail Our Retail Avg Retail Available Ignored Field Max Stock Reorder Pt Misc #1 Misc #2 Misc #3 Misc #4 Misc #5 Commission Tax Serial Num Issuage Bar Code Type Price Code Reorder Lot Unit In Qty/Unit Case Cost Case Price Itemize Components Track Inv Acct Group Code Print Code Updt Ven Cost Units Sold Style Row Column Location Transfer Group Committed Leave Blank Date Created Last Update Remote Vendor TransCode Active Web Item Out of Stock Mesg Short Web Desc Web Title Leave Blank Leave Blank itemRewardCode UnitOfMeasure
* IAV Item ID Qty Invoice ID Date Comments
* UAV Item ID Qty Date Comment
* IVEN Item ID Vendor ID Vendor ItemID Ven Lead Time Vendor Cost
* DIVL Item ID
* DITM Item ID
* ITCL Item ID Component Item ID Leave Blank Comp. Qty. Comp. Cost Comp. Retail
* ITVL Item ID LeaveBlank Vendor ID Leave Blank Vendor Item ID Lead Time Vendor Cost
* DICL Item ID
* CITM {same as UITM}
* UVCP Vendor ID Vendor Item ID Vendor Cost Sugg Retail Our Retail Description
* UVCP_ALL Vendor ID Vendor Item ID Vendor Cost Sugg Retail Our Retail Description
Sites
* USIT Old Site ID Site ID Site Name Short Name Misc 1 Misc 2 Misc 3 Misc 4 Serial Number Generation Connection Type Notes Transfer Type
Site Items
* SITI Site Short Name Item ID Amt Available Amt Committed On Order Max Stock Reorder Point Last Update
Vendor Card
* UVEN Prev Vendor ID Vendor ID Vendor Name Address Address 2 City State Zip Phone Ext Sales Rep Sales Rep Phone Credit Mgr Credit Mgr Phone Terms Ship Via Min Order Flooring Acct Vendor Acct Other Acct Comment Fax Number EMail Number Sales Rep. Ext. Credit Mgr Ext. Business Hours Contact 1 Cont. 1 Phone Cont. 1 Ext Contact 2 Cont. 2 Phone Cont. 2 Ext.
* DVEN Vendor ID
* CVEN {same as UVEN}
Customer Card
* UCUS Prev Customer ID Customer ID Bill Company Bill First Name Bill Middle Initial Bill Last Name Bill Address Bill Address 2 Bill City Bill State Bill Zip Bill Country Bill Phone Bill Ext A/R Contact Ship Company Ship First Name Ship Middle Initial Ship Last Name Ship Address Ship Address 2 Ship City Ship State Ship Zip Ship Country Ship Phone Ship Ext Terms Tax ID FOB Point Ship Via Credit Limit Discount Level Tax District Current Past 30 Past 60 Past 90 <Leave Blank> MTD YTD Misc 1 Misc 2 Salesperson Date Created Last Update Credit Card Number CC Exp (00/00) E-Mail FAX Comment Option 1 Option 2
* ACUS Customer ID Date Reference Num. Sales Amt. Payment Amt. Balance Apply to Invoice Trans. Type Post to GL
* HCUS Customer ID Date Invoice Num. Item ID Serial Num. Item Desc.
* DCUS Customer ID
* CCUS {same as UCUS}
* MERGECUST Keep Customer ID Dead Customer ID
* APFI Customer ID Line No TransCode Qty Item ID Description Unit Price Tax Code
* DPFI Customer ID
Serial Number Card
* USN Prev Serial Num Serial Number Item ID Date In Date Out Invoice ID Customer ID Cost OrderID Comment
* DSN Serial Number
Working Invoices
* UWIV Prev. Inv. ID New Inv. ID Customer ID Customer PO Dept. Number Sales Person Date Bill Company Bill First Name Bill M I Bill Last Name Bill Address Bill Address 2 Bill City Bill State Bill Zip Bill Country Bill Phone Bill Ext. Ship Company Ship First Name Ship MI Ship Last Name Ship Address Ship Address 2 Ship City Ship State Ship Zip Ship Country Ship Phone Ship Ext. Terms Ship Via Invoice Taxable Tax Rate 1 Discount Rate Tax District Comment Tax Rate 2 Tax Amt. 1 Tax Amt. 2 Leave Blank Tax Calc Meth. Total Tax Amt. Tax Amt.Valid Tax Amt. Incl. Billing ID CC No CC Expire Register ID CC Auth
* WIL Invoice ID Leave Blank Trans Code Qty Item ID Description Level Price Leave Blank Tax Code Tax Amt. Incl. Cost On Hand
* DWIV Invoice ID
* DWIL Invoice ID
* CWIV {same as UWIV}
Processed Invoices
* UPIV Prev. Inv. ID New Inv. ID Customer ID Customer PO Dept. Num. Sales Person Date Bill Company Bill First Name Bill M I Bill Last Name Bill Address Bill Address 2 Bill City Bill State Bill Zip Code Bill Country Bill Phone Bill Ext. Ship Company Ship First Name Ship MI Ship Last Name Ship Address Ship Address 2 Ship City Ship State Ship Zip Code Ship Country Ship Phone Ship Extension Terms Ship Via Invoice Taxable Tax Rate 1 Discount Rate Tax District Tax Rate 2 Tax Amt 1 Tax Amt 2 Leave Blank Leave Blank Tax Calc Method Total Tax Amt. is tax amt valid Sales Order ID Tax Amt Incl. Posted To GL Line Item Discount Billing ID Post Status CC No CC Expire Register ID User CC Auth
* PIL Invoice ID Leave Blank Trans Code Qty Item ID Description Level Price Leave Blank Tax Code Tax Amt Incl. Cost On Hand
* PINV invoice ID
* DPIV Invoice ID
* DPIL Invoice ID
* CPIV {same as UPIV}
Split Billing
* UWBD Prev Billing ID Prev Line # New Billing ID New Line # Customer ID Name Acct # Misc 1 Amt Billed Total Split Amt Percent of Total Leave Blank Invoice ID
* DWBD Billing ID Line #
* UPBD Prev Billing ID Prev Line # New Billing ID New Line # Customer ID Name Acct # Misc 1 Amt Billed Total Split Amt Percent of Total Leave Blank Invoice ID
* DPBD Billing ID Line #
Layaways
* ULWYH Prev LayawayID LayawayID Customer ID Salesperson Origin Date-Time Pickup Date-Time Status Final Invoice ID L Disc Rate L Taxable L Tax Rate 1 L Tax Rate 2 L Tax Amt 1 L Tax Amt 2 L Tax Dist L Tax Calc Meth L Total Tax Amt L Tax Included
* DLWYH LayawayID
* ALWYL LayawayID Line No Qty Item ID Description Unit Price
* DLWYL LayawayID
* ALWYP LayawayID Pay Date Invoice ID Amount
* DLWYP LayawayID
Working Order
* UWOH Prev. Order ID Order ID Vendor ID Acct Number Ship Via Order Date Ship Date Cancel Date Posted Ord. Freight Leave Blank Leave Blank Leave Blank Comment Vendor Name Vendor Address Vendor Add. 2 Vendor City Vendor State Vendor Zip Vendor Ph. Vendor Ext. Bill to 1 Bill to 2 Bill to 3 Bill to 4 Bill to 5 Bill to Ph. Bill to Ext. Bill to Fax Bill to EMail Ship to 1 Ship to 2 Ship to 3 Ship to 4 Ship to 5 Ship to Ph. Ship to Ext. Ship to Fax Fax to EMail Expiration Days Terms
* WOL Order ID Qty Item ID Description Cost Leave Blank Vendor Item ID No Cost Update Our Retail Leave Blank
* DWPO Working PO ID
* DWOL Working PO ID
* CWOH {same as UWOH}
Processed Orders
* UPOH Prev. Order ID Order ID Vendor ID Account Num. Ship Via Order Date Ship Date Cancel Date Posted Ord. Freight Recvd. Freight Leave Blank Leave Blank Comment Vendor Name Vendor Address Ven. Address 2 Vendor City Vendor State Vendor Zip Vendor Ph. Vendor Ext. Bill to 1 Bill to 2 Bill to 3 Bill to 4 Bill to 5 Bill to Ph. Bill to Ext. Bill to Fax Bill to EMail Ship to 1 Ship to 2 Ship to 3 Ship to 4 Ship to 5 Ship to Ph. Ship to Ext. Ship to Fax Ship to EMail Expiraton Days Terms
* POL Order ID Qty Item ID Description Cost Remaining Vendor Item ID No Cost Update Our Retail Leave Blank
* DPOL Proc. Order ID
* DPPO Proc. Order ID
* CPOH {same as UPOH}
* KANCO Proc. Order ID Item ID Date Qty
Working Receiving Logs
* UWRL Prev. RecLog ID New RecLog ID Proc. PO ID Vendor Inv. ID Received Date Received By Freight Amt. Reconciled
* AWRLL Recv. Log ID Leave Blank Leave Blank Qty Received Qty Canceled Vendor Item ID Description Cost Freight Old Retail Item ID No Cost Update Our Retail Leave Blank
* DWRL Reciving Log ID
* DWRLL Reciving Log ID
Prosessed Receiving Logs
* UPRL PP Rec. Log ID New Recv. Log ID Prev. PO ID Vendor Inv. ID Received Date Received By Freight Amt. Leave Blank Posted Posted to GL Date Posted Vendor ID Vendor Invoice Date Terms
* APRLL Proc RecLog ID Qty Ordered Qty Remaining Qty Received Qty Canceled Vendor Item ID Description Cost Freight Old Retail Item ID No Cost Update Our Retail Leave Blank
* APRLSN Prev RecLog ID Serial# in/out Serial Number Item ID Cost
* DPRL Proc RecLog ID
* DPRLL Proc RecLog ID
Transfer Docs
* UWXF Prev ID ID Reference Clerk Source Destination Ship On Tot Qty Tot Cost Post Date/Time Status
* DWXF ID
* UPXF Prev ID ID Reference Clerk Source Destination Ship On Tot Qty Tot Cost Post Date/Time Status
* DPXF ID
* URXF Prev ID ID Reference Clerk Source Destination Ship On Tot Qty Tot Cost Post Date/Time Status
* DRXF ID
* AWXFL ID <blank> Item ID Description Qty In Qty Out Cost <blank> Available On Order
* DWXFL ID
* APXFL ID <blank> Item ID Description Qty In Qty Out Cost <blank> Available On Order
* DPXFL ID
* ARXFL ID <blank> Item ID Description Qty In Qty Out Cost <blank> Available On Order
* DRXFL ID
* PXFR ID
* FINX ID
Transactions
* IOO Order ID Item ID Qty Cost
* TRAN Item ID Date Qty Cost Loc From Loc To
* SIN Serial Number Item ID Date Cost PO ID Unit Freight Recv Log ID Str
* SOUT Serial Number Item ID Date Invoice ID Customer ID
* PRL Proc RecLog ID
* PORD Proc. Order ID
* CMT Working Inv. ID
* UCMT Working Inv. ID Date
* POSTAR Proc. Inv. ID
* ATXH Invoice ID Date Tax Detail Code Tax District Totl. Subj. to Tax Tax Amt. Pre Tax Totl.Amt. Total Inv. Amt. Qty Qty Subj to Tax Tax Amt. Included
Tax Setups
* UTXD Detail Code Description Tax Authority GL Acct #1 GL Acct #2 Tax Rate 1st Penney Min. Taxable Amt Max Taxable Amt Tax is dollar amt Use Max Amt Itemize on Invoice Basis Is Tax Included Tax Exempt Max on line Item
* UTXG Item Group ID Description Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank
* UCTX Cust Tax District Description Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank
Codes for Other Functions
* PHYS Item ID Qty
* ACGR Acc. Group Code Sales Acc. Num. COGS Acc. Num. Inv. Acc. Num. Acc. Group Disc. Return Acc. Num. Trans. Acc. Num. Shrkage Acc.#
* USP Prev SalPers ID SalPers Name
* UPC Prv PriceCode ID New PriceCode ID Formula 1 Formula 2 Formula 3 Formula 4 Formula 5 Formula 6 Formula 7 Formula 8 Price Code Disc. Extra Decimals
* UPRICE Prev ID ID Description DB Field1 Method1 Amount1 DB Field2 Method2 Amount2 DB Field3 Method3 Amount3 DB Field4 Method4 Amount4 DB Field5 Method5 Amount5 DB Field6 Method6 Amount6 DB Field7 Method7 Amount7
* DSP SalPerson ID
* DPC Price Code
* DPRICE Price Code ID
Ending Tills
* UET Site ID Date Deposit Amount End Balance Over/Short Hi Temp Lo Temp Weather Events Comments Cash Check On Account Gift Cert. Pay Credit Slip Other 1 Other 2 MC Visa Amex Discover House CC Other CC Debit Card Pymt Total Sales Returns Freight Misc Labor Pymt On Acct Deposits Transfers Sales Tax Gift Cert. Bought Paid Outs Advances Draws Drops Trans. Total Register ID
Rental Items
* URITM Prev Item ID Item ID Description Misc 1 Misc 2 Rent Code Leave Blank Date Placed In Service Cost
Market Analysis
* UMARKT Prev Invoice ID Invoice ID Date Time Category 1 Category 2 Category 3
* UCATG Group (1, 2, 3) Prev Name Name
Backorders
* UBOHD Prev Backorder ID Backorder ID Invoice ID Backorder Date Time Customer ID Company Name First Name Last Name Item ID Qty Qty Remaining Unit Price Delivery Date
* DBOHD Backorder ID
* UBOOL Backorder ID Order Date Ship Date Purch Order ID Qty Ordered Qty Allocated Vendor ID
* UBORL Backorder ID Receive Date PO ID Rcv Log ID Rcv Qty Alloc Qty Vendor ID Sales Order ID
* UBOCL Backorder ID Cancel Qty Name Reason Cancel Date
* UBOFR Invoice ID Freight Amt
* DBOFR Invoice ID
* BOGO Backorder ID
Shows you the import code to use. In a Posim Import file, each line must have an import code.
For example, the import code UITM is used to add inventory items to your database.
You would enter UITM as the import code -- without the "*" -- the asterisk means that the line
is a comment and will be skipped.
For an example of an import file, see the file named "Sample Data".
Item Card
* UITM Prev Item ID Item ID Description Manufacturer Mfr Item ID Vendor ID Vendor Cost Vendor Item ID Vendor Lead Time Last Cost Avg Cost Sugg Retail Our Retail Avg Retail Available Leave Blank Max Stock Reorder Pt Misc #1 Misc #2 Misc #3 Misc #4 Misc #5 Commission Tax Serial Num Issuage Bar Code Type Price Code Reorder Lot Unit In Qty/Unit Case Cost Case Price Itemize Components Track Inv Acct Group Code Print Code Updt Ven Cost Units Sold Style Row Column Location Transfer Group Committed Leave Blank Date Created Last Update Remote Vendor TransCode Active Web Item Out of Stock Mesg Short Web Desc Web Title Leave Blank Leave Blank itemRewardCode UnitOfMeasure
* AITM Item ID Description Manufacturer Mfr Item ID Vendor ID Vendor Cost Vendor Item ID Ignored Vendor Lead Time Last Cost Avg Cost Sugg Retail Our Retail Avg Retail Available Ignored Field Max Stock Reorder Pt Misc #1 Misc #2 Misc #3 Misc #4 Misc #5 Commission Tax Serial Num Issuage Bar Code Type Price Code Reorder Lot Unit In Qty/Unit Case Cost Case Price Itemize Components Track Inv Acct Group Code Print Code Updt Ven Cost Units Sold Style Row Column Location Transfer Group Committed Leave Blank Date Created Last Update Remote Vendor TransCode Active Web Item Out of Stock Mesg Short Web Desc Web Title Leave Blank Leave Blank itemRewardCode UnitOfMeasure
* IAV Item ID Qty Invoice ID Date Comments
* UAV Item ID Qty Date Comment
* IVEN Item ID Vendor ID Vendor ItemID Ven Lead Time Vendor Cost
* DIVL Item ID
* DITM Item ID
* ITCL Item ID Component Item ID Leave Blank Comp. Qty. Comp. Cost Comp. Retail
* ITVL Item ID LeaveBlank Vendor ID Leave Blank Vendor Item ID Lead Time Vendor Cost
* DICL Item ID
* CITM {same as UITM}
* UVCP Vendor ID Vendor Item ID Vendor Cost Sugg Retail Our Retail Description
* UVCP_ALL Vendor ID Vendor Item ID Vendor Cost Sugg Retail Our Retail Description
Sites
* USIT Old Site ID Site ID Site Name Short Name Misc 1 Misc 2 Misc 3 Misc 4 Serial Number Generation Connection Type Notes Transfer Type
Site Items
* SITI Site Short Name Item ID Amt Available Amt Committed On Order Max Stock Reorder Point Last Update
Vendor Card
* UVEN Prev Vendor ID Vendor ID Vendor Name Address Address 2 City State Zip Phone Ext Sales Rep Sales Rep Phone Credit Mgr Credit Mgr Phone Terms Ship Via Min Order Flooring Acct Vendor Acct Other Acct Comment Fax Number EMail Number Sales Rep. Ext. Credit Mgr Ext. Business Hours Contact 1 Cont. 1 Phone Cont. 1 Ext Contact 2 Cont. 2 Phone Cont. 2 Ext.
* DVEN Vendor ID
* CVEN {same as UVEN}
Customer Card
* UCUS Prev Customer ID Customer ID Bill Company Bill First Name Bill Middle Initial Bill Last Name Bill Address Bill Address 2 Bill City Bill State Bill Zip Bill Country Bill Phone Bill Ext A/R Contact Ship Company Ship First Name Ship Middle Initial Ship Last Name Ship Address Ship Address 2 Ship City Ship State Ship Zip Ship Country Ship Phone Ship Ext Terms Tax ID FOB Point Ship Via Credit Limit Discount Level Tax District Current Past 30 Past 60 Past 90 <Leave Blank> MTD YTD Misc 1 Misc 2 Salesperson Date Created Last Update Credit Card Number CC Exp (00/00) E-Mail FAX Comment Option 1 Option 2
* ACUS Customer ID Date Reference Num. Sales Amt. Payment Amt. Balance Apply to Invoice Trans. Type Post to GL
* HCUS Customer ID Date Invoice Num. Item ID Serial Num. Item Desc.
* DCUS Customer ID
* CCUS {same as UCUS}
* MERGECUST Keep Customer ID Dead Customer ID
* APFI Customer ID Line No TransCode Qty Item ID Description Unit Price Tax Code
* DPFI Customer ID
Serial Number Card
* USN Prev Serial Num Serial Number Item ID Date In Date Out Invoice ID Customer ID Cost OrderID Comment
* DSN Serial Number
Working Invoices
* UWIV Prev. Inv. ID New Inv. ID Customer ID Customer PO Dept. Number Sales Person Date Bill Company Bill First Name Bill M I Bill Last Name Bill Address Bill Address 2 Bill City Bill State Bill Zip Bill Country Bill Phone Bill Ext. Ship Company Ship First Name Ship MI Ship Last Name Ship Address Ship Address 2 Ship City Ship State Ship Zip Ship Country Ship Phone Ship Ext. Terms Ship Via Invoice Taxable Tax Rate 1 Discount Rate Tax District Comment Tax Rate 2 Tax Amt. 1 Tax Amt. 2 Leave Blank Tax Calc Meth. Total Tax Amt. Tax Amt.Valid Tax Amt. Incl. Billing ID CC No CC Expire Register ID CC Auth
* WIL Invoice ID Leave Blank Trans Code Qty Item ID Description Level Price Leave Blank Tax Code Tax Amt. Incl. Cost On Hand
* DWIV Invoice ID
* DWIL Invoice ID
* CWIV {same as UWIV}
Processed Invoices
* UPIV Prev. Inv. ID New Inv. ID Customer ID Customer PO Dept. Num. Sales Person Date Bill Company Bill First Name Bill M I Bill Last Name Bill Address Bill Address 2 Bill City Bill State Bill Zip Code Bill Country Bill Phone Bill Ext. Ship Company Ship First Name Ship MI Ship Last Name Ship Address Ship Address 2 Ship City Ship State Ship Zip Code Ship Country Ship Phone Ship Extension Terms Ship Via Invoice Taxable Tax Rate 1 Discount Rate Tax District Tax Rate 2 Tax Amt 1 Tax Amt 2 Leave Blank Leave Blank Tax Calc Method Total Tax Amt. is tax amt valid Sales Order ID Tax Amt Incl. Posted To GL Line Item Discount Billing ID Post Status CC No CC Expire Register ID User CC Auth
* PIL Invoice ID Leave Blank Trans Code Qty Item ID Description Level Price Leave Blank Tax Code Tax Amt Incl. Cost On Hand
* PINV invoice ID
* DPIV Invoice ID
* DPIL Invoice ID
* CPIV {same as UPIV}
Split Billing
* UWBD Prev Billing ID Prev Line # New Billing ID New Line # Customer ID Name Acct # Misc 1 Amt Billed Total Split Amt Percent of Total Leave Blank Invoice ID
* DWBD Billing ID Line #
* UPBD Prev Billing ID Prev Line # New Billing ID New Line # Customer ID Name Acct # Misc 1 Amt Billed Total Split Amt Percent of Total Leave Blank Invoice ID
* DPBD Billing ID Line #
Layaways
* ULWYH Prev LayawayID LayawayID Customer ID Salesperson Origin Date-Time Pickup Date-Time Status Final Invoice ID L Disc Rate L Taxable L Tax Rate 1 L Tax Rate 2 L Tax Amt 1 L Tax Amt 2 L Tax Dist L Tax Calc Meth L Total Tax Amt L Tax Included
* DLWYH LayawayID
* ALWYL LayawayID Line No Qty Item ID Description Unit Price
* DLWYL LayawayID
* ALWYP LayawayID Pay Date Invoice ID Amount
* DLWYP LayawayID
Working Order
* UWOH Prev. Order ID Order ID Vendor ID Acct Number Ship Via Order Date Ship Date Cancel Date Posted Ord. Freight Leave Blank Leave Blank Leave Blank Comment Vendor Name Vendor Address Vendor Add. 2 Vendor City Vendor State Vendor Zip Vendor Ph. Vendor Ext. Bill to 1 Bill to 2 Bill to 3 Bill to 4 Bill to 5 Bill to Ph. Bill to Ext. Bill to Fax Bill to EMail Ship to 1 Ship to 2 Ship to 3 Ship to 4 Ship to 5 Ship to Ph. Ship to Ext. Ship to Fax Fax to EMail Expiration Days Terms
* WOL Order ID Qty Item ID Description Cost Leave Blank Vendor Item ID No Cost Update Our Retail Leave Blank
* DWPO Working PO ID
* DWOL Working PO ID
* CWOH {same as UWOH}
Processed Orders
* UPOH Prev. Order ID Order ID Vendor ID Account Num. Ship Via Order Date Ship Date Cancel Date Posted Ord. Freight Recvd. Freight Leave Blank Leave Blank Comment Vendor Name Vendor Address Ven. Address 2 Vendor City Vendor State Vendor Zip Vendor Ph. Vendor Ext. Bill to 1 Bill to 2 Bill to 3 Bill to 4 Bill to 5 Bill to Ph. Bill to Ext. Bill to Fax Bill to EMail Ship to 1 Ship to 2 Ship to 3 Ship to 4 Ship to 5 Ship to Ph. Ship to Ext. Ship to Fax Ship to EMail Expiraton Days Terms
* POL Order ID Qty Item ID Description Cost Remaining Vendor Item ID No Cost Update Our Retail Leave Blank
* DPOL Proc. Order ID
* DPPO Proc. Order ID
* CPOH {same as UPOH}
* KANCO Proc. Order ID Item ID Date Qty
Working Receiving Logs
* UWRL Prev. RecLog ID New RecLog ID Proc. PO ID Vendor Inv. ID Received Date Received By Freight Amt. Reconciled
* AWRLL Recv. Log ID Leave Blank Leave Blank Qty Received Qty Canceled Vendor Item ID Description Cost Freight Old Retail Item ID No Cost Update Our Retail Leave Blank
* DWRL Reciving Log ID
* DWRLL Reciving Log ID
Prosessed Receiving Logs
* UPRL PP Rec. Log ID New Recv. Log ID Prev. PO ID Vendor Inv. ID Received Date Received By Freight Amt. Leave Blank Posted Posted to GL Date Posted Vendor ID Vendor Invoice Date Terms
* APRLL Proc RecLog ID Qty Ordered Qty Remaining Qty Received Qty Canceled Vendor Item ID Description Cost Freight Old Retail Item ID No Cost Update Our Retail Leave Blank
* APRLSN Prev RecLog ID Serial# in/out Serial Number Item ID Cost
* DPRL Proc RecLog ID
* DPRLL Proc RecLog ID
Transfer Docs
* UWXF Prev ID ID Reference Clerk Source Destination Ship On Tot Qty Tot Cost Post Date/Time Status
* DWXF ID
* UPXF Prev ID ID Reference Clerk Source Destination Ship On Tot Qty Tot Cost Post Date/Time Status
* DPXF ID
* URXF Prev ID ID Reference Clerk Source Destination Ship On Tot Qty Tot Cost Post Date/Time Status
* DRXF ID
* AWXFL ID <blank> Item ID Description Qty In Qty Out Cost <blank> Available On Order
* DWXFL ID
* APXFL ID <blank> Item ID Description Qty In Qty Out Cost <blank> Available On Order
* DPXFL ID
* ARXFL ID <blank> Item ID Description Qty In Qty Out Cost <blank> Available On Order
* DRXFL ID
* PXFR ID
* FINX ID
Transactions
* IOO Order ID Item ID Qty Cost
* TRAN Item ID Date Qty Cost Loc From Loc To
* SIN Serial Number Item ID Date Cost PO ID Unit Freight Recv Log ID Str
* SOUT Serial Number Item ID Date Invoice ID Customer ID
* PRL Proc RecLog ID
* PORD Proc. Order ID
* CMT Working Inv. ID
* UCMT Working Inv. ID Date
* POSTAR Proc. Inv. ID
* ATXH Invoice ID Date Tax Detail Code Tax District Totl. Subj. to Tax Tax Amt. Pre Tax Totl.Amt. Total Inv. Amt. Qty Qty Subj to Tax Tax Amt. Included
Tax Setups
* UTXD Detail Code Description Tax Authority GL Acct #1 GL Acct #2 Tax Rate 1st Penney Min. Taxable Amt Max Taxable Amt Tax is dollar amt Use Max Amt Itemize on Invoice Basis Is Tax Included Tax Exempt Max on line Item
* UTXG Item Group ID Description Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank
* UCTX Cust Tax District Description Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank Leave Blank
Codes for Other Functions
* PHYS Item ID Qty
* ACGR Acc. Group Code Sales Acc. Num. COGS Acc. Num. Inv. Acc. Num. Acc. Group Disc. Return Acc. Num. Trans. Acc. Num. Shrkage Acc.#
* USP Prev SalPers ID SalPers Name
* UPC Prv PriceCode ID New PriceCode ID Formula 1 Formula 2 Formula 3 Formula 4 Formula 5 Formula 6 Formula 7 Formula 8 Price Code Disc. Extra Decimals
* UPRICE Prev ID ID Description DB Field1 Method1 Amount1 DB Field2 Method2 Amount2 DB Field3 Method3 Amount3 DB Field4 Method4 Amount4 DB Field5 Method5 Amount5 DB Field6 Method6 Amount6 DB Field7 Method7 Amount7
* DSP SalPerson ID
* DPC Price Code
* DPRICE Price Code ID
Ending Tills
* UET Site ID Date Deposit Amount End Balance Over/Short Hi Temp Lo Temp Weather Events Comments Cash Check On Account Gift Cert. Pay Credit Slip Other 1 Other 2 MC Visa Amex Discover House CC Other CC Debit Card Pymt Total Sales Returns Freight Misc Labor Pymt On Acct Deposits Transfers Sales Tax Gift Cert. Bought Paid Outs Advances Draws Drops Trans. Total Register ID
Rental Items
* URITM Prev Item ID Item ID Description Misc 1 Misc 2 Rent Code Leave Blank Date Placed In Service Cost
Market Analysis
* UMARKT Prev Invoice ID Invoice ID Date Time Category 1 Category 2 Category 3
* UCATG Group (1, 2, 3) Prev Name Name
Backorders
* UBOHD Prev Backorder ID Backorder ID Invoice ID Backorder Date Time Customer ID Company Name First Name Last Name Item ID Qty Qty Remaining Unit Price Delivery Date
* DBOHD Backorder ID
* UBOOL Backorder ID Order Date Ship Date Purch Order ID Qty Ordered Qty Allocated Vendor ID
* UBORL Backorder ID Receive Date PO ID Rcv Log ID Rcv Qty Alloc Qty Vendor ID Sales Order ID
* UBOCL Backorder ID Cancel Qty Name Reason Cancel Date
* UBOFR Invoice ID Freight Amt
* DBOFR Invoice ID
* BOGO Backorder ID
BARENAKED LADIES LYRICS
"Sound Of Your Voice"
The moon is full but there is an incompleteness
The days are beautiful but I feel a bitter sweetness
If I had a wish, or even a choice
I'd wake up to the sound of your voice
How I miss waking up to the sound of your voice
I let you down and fell right off of your good list
I hope each day you'll find peace and forgiveness
The alarm clock rings, What a lonely noise
And I long for the sound of your voice
Oh, how I miss waking up to the sound of your voice
Take it from me: there's not much to see
In this void
The saying goes there will be other dances (don't give up)
This little song is about second chances
Just say the word and I will rejoice
And wake up to the sound of your voice
Oh, how I miss waking up to the sound
To the sound (sound)
To the sound (to the sound)
To the sound
Waking up to the sound of your voice
Take it from me: there's not much to see
In this void
"Sound Of Your Voice"
The moon is full but there is an incompleteness
The days are beautiful but I feel a bitter sweetness
If I had a wish, or even a choice
I'd wake up to the sound of your voice
How I miss waking up to the sound of your voice
I let you down and fell right off of your good list
I hope each day you'll find peace and forgiveness
The alarm clock rings, What a lonely noise
And I long for the sound of your voice
Oh, how I miss waking up to the sound of your voice
Take it from me: there's not much to see
In this void
The saying goes there will be other dances (don't give up)
This little song is about second chances
Just say the word and I will rejoice
And wake up to the sound of your voice
Oh, how I miss waking up to the sound
To the sound (sound)
To the sound (to the sound)
To the sound
Waking up to the sound of your voice
Take it from me: there's not much to see
In this void







