SOP (Sales Order Processing) to invoice your customers, the tables involved are these:
The SOP Type tells you what kind of document you’re dealing with. Only the Invoice and Return documents can post.
If, instead of SOP, you are using the Invoicing module, you’ll need to look in these tables
If you are simply entering documents directly in the Receivables Management module, you’ll need to look at the tables below. Keep in mind that once a transaction is posted from either the SOP or Invoicing module, they are moved to the RM posted sales documents table:
The RMDTYPAL (RM Document Type) field tells you what kind of receivables document you have.
|
SOP Tables |
|
|
SOP10100 |
SOP Header on unposted documents |
|
SOP10200 |
SOP Line items on unposted documents (For Kits, there is one record per kit component) |
|
SOP10101 |
Commissions on posted and unposted documents |
|
SOP10103 |
Payments on posted and unposted documents |
|
SOP10105 |
Sales Taxes on posted and unposted documents |
|
SOP10106 |
User Defined fields on posted and unposted documents (Also contains the transaction-level comment)) |
|
SOP10107 |
Tracking Number(s) on posted and unposted documents |
|
SOP10201 |
Serial/Lot Number(s) on posted and unposted documents |
|
SOP10202 |
Line Comment(s) on posted and unposted documents |
|
SOP30200 |
SOP Header on posted documents |
|
SOP30201 |
Sales Deposits on posted documents |
|
SOP30300 |
SOP Line items on posted documents (For Kits, there is one record per kit component) |
The SOP Type tells you what kind of document you’re dealing with. Only the Invoice and Return documents can post.
|
SOPTYPE (SOP Document Types): |
|
|
1
|
Quote |
|
2
|
Order |
|
3
|
Invoice |
|
4
|
Return |
|
5
|
Back Order |
|
6
|
Fulfillment Order |
If, instead of SOP, you are using the Invoicing module, you’ll need to look in these tables
|
IVC10100 |
Invoicing Header on unposted documents |
|
IVC10101 |
Invoicing Line Items on unposted documents |
|
IVC10102 |
Serial and Lot Numbers |
|
IVC10103 |
Line Item Comments |
|
IVC10200 |
Payments on documents |
|
IVC10400 |
Commissions |
|
IVC10500 |
Sales Tax |
|
IVC30101 |
Invoicing Headers on posted documents |
|
IVC30102 |
Invoicing Line Items on posted documents |
If you are simply entering documents directly in the Receivables Management module, you’ll need to look at the tables below. Keep in mind that once a transaction is posted from either the SOP or Invoicing module, they are moved to the RM posted sales documents table:
|
Receivables Documents |
|
|
RM10301 |
Receivables unposted sales documents |
|
RM10201 |
Receivables unposted cash receipts |
|
RM10501 |
Receivables commissions on unposted documents |
|
RM10601 |
Receivables Sales Tax on unposted documents |
|
RM20101 |
Receivables posted sales documents |
|
RM30101 |
Receivables history sales documents |
|
RM30601 |
Receivables Sales Tax history |
|
RM30501 |
Receivables commissions history |
The RMDTYPAL (RM Document Type) field tells you what kind of receivables document you have.
|
Receivables Document types |
|
|
0
|
Reserved for balance carried forward records |
|
1
|
Sales / Invoice document |
|
2
|
Reserved for scheduled payments |
|
3
|
Debit memo |
|
4
|
Finance Charge |
|
5
|
Service / Repair document |
|
6
|
Warranty document |
|
7
|
Credit memo |
|
8
|
Return document |
|
9
|
Payment document |
No comments:
Post a Comment