|
|
API RCC4
RCC4 - Incoming Payment - Credit Vouchers Table
Credit Cards OCRC SQL Table
Incoming Payment ORCT SQL Table
Location OLCT SQL Table
Object Settings - History ADP1 SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
Sections OSEC SQL Table
Sales Tax Authorities Type OSTT SQL Table
Tax Definition OVTG SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocNum KEY UNIQUE | Document Number | Int | 11 | ORCT Incoming Payment | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineId | Row Number | Int | 11 | |||||
| AcctCode | Credit Card | nVarChar | 15 | OCRC Credit Cards | -1 | |||
| SumApplied | Credit Amount | Num | 20 | |||||
| AppliedFC | Credit Card Number | Num | 20 | |||||
| AppliedSys | Credit Card Validity | Num | 20 | |||||
| Descrip | Voucher Number | nVarChar | 127 | |||||
| VatGroup | ID Number | nVarChar | 8 | OVTG Tax Definition | ||||
| VatPrcnt | Telephone | Num | 20 | |||||
| AcctName | Payment Method Code | nVarChar | 100 | -1 | ||||
| ObjType | Number of Payments | nVarChar | 20 | ADP1 Object Settings - History | 1 | |||
| LogInstanc | First Payment Date | Int | 11 | |||||
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| Project | Project Code | nVarChar | 20 | OPRJ Project Codes | ||||
| GrossAmnt | Gross Amount | Num | 20 | |||||
| GrssAmntFC | Gross Amount (FC) | Num | 20 | |||||
| GrssAmntSC | Gross Amount (SC) | Num | 20 | |||||
| AmntBase | Base Amount | VarChar | E) Exclude Tax I) Include Tax | 1 | ||||
| VatAmnt | VAT Amount | Num | 20 | |||||
| VatAmntFC | VAT Amount (FC) | Num | 20 | |||||
| VatAmntSC | VAT Amount (SC) | Num | 20 | |||||
| UserChaVat | User Changed VAT | VarChar | N) No Y) Yes | 1 | N | |||
| TaxTypeID | Tax Type Component ID | Int | 11 | OSTT Sales Tax Authorities Type | ||||
| OcrCode2 | Distribution Rule2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode3 | Distribution Rule3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode4 | Distribution Rule4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode5 | Distribution Rule5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| Section | Section | Int | 11 | OSEC Sections | ||||
| AsseType | Assessee Type | VarChar | C) Company P) Others | 1 | ||||
| LocCode | Location Code | Int | 11 | OLCT Location | ||||
| MatType | Material Type | Int | 11 | 0 | ||||
| EquVatPer | Equalization Tax Rate | Num | 20 | |||||
| EquVatSum | Equalization VAT Amount | Num | 20 | |||||
| EquVatSumF | Equalization VAT Amount (FC) | Num | 20 | |||||
| EquVatSumS | Equalization VAT Amount (SC) | Num | 20 |
Table relationship map
SELECT statement
SELECT
RCC4.DocNum AS 'Document Number',
RCC4.LineId AS 'Row Number',
RCC4.AcctCode AS 'Credit Card',
RCC4.SumApplied AS 'Credit Amount',
RCC4.AppliedFC AS 'Credit Card Number',
RCC4.AppliedSys AS 'Credit Card Validity',
RCC4.Descrip AS 'Voucher Number',
RCC4.VatGroup AS 'ID Number',
RCC4.VatPrcnt AS 'Telephone',
RCC4.AcctName AS 'Payment Method Code',
RCC4.ObjType AS 'Number of Payments',
RCC4.LogInstanc AS 'First Payment Date',
RCC4.OcrCode AS 'Distribution Rule',
RCC4.Project AS 'Project Code',
RCC4.GrossAmnt AS 'Gross Amount',
RCC4.GrssAmntFC AS 'Gross Amount (FC)',
RCC4.GrssAmntSC AS 'Gross Amount (SC)',
RCC4.AmntBase AS 'Base Amount',
RCC4.VatAmnt AS 'VAT Amount',
RCC4.VatAmntFC AS 'VAT Amount (FC)',
RCC4.VatAmntSC AS 'VAT Amount (SC)',
RCC4.UserChaVat AS 'User Changed VAT',
RCC4.TaxTypeID AS 'Tax Type Component ID',
RCC4.OcrCode2 AS 'Distribution Rule2',
RCC4.OcrCode3 AS 'Distribution Rule3',
RCC4.OcrCode4 AS 'Distribution Rule4',
RCC4.OcrCode5 AS 'Distribution Rule5',
RCC4.Section AS 'Section',
RCC4.AsseType AS 'Assessee Type',
RCC4.LocCode AS 'Location Code',
RCC4.MatType AS 'Material Type',
RCC4.EquVatPer AS 'Equalization Tax Rate',
RCC4.EquVatSum AS 'Equalization VAT Amount',
RCC4.EquVatSumF AS 'Equalization VAT Amount (FC)',
RCC4.EquVatSumS AS 'Equalization VAT Amount (SC)'
FROM RCC4 AS RCC4
Related information
Credit Cards OCRC SQL Table
Incoming Payment ORCT SQL Table
Location OLCT SQL Table
Object Settings - History ADP1 SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
Sections OSEC SQL Table
Sales Tax Authorities Type OSTT SQL Table
Tax Definition OVTG SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
