|
|
API ARCT
ARCT - Incoming Payment - History Table
House Bank Accounts DSC1 SQL Table
Countries OCRY SQL Table
Tax Definition OVTG SQL Table
Bill of Exchange for Payment OBOE SQL Table
G/L Accounts OACT SQL Table
Agent Name OAGP SQL Table
Business Place OBPL SQL Table
CIG Codes OCIG SQL Table
Contact Persons OCPR SQL Table
CUP Codes OCUP SQL Table
Currency Codes OCRN SQL Table
Payment Draft OPDF SQL Table
Posting Period OFPR SQL Table
Location OLCT SQL Table
Object Settings - History ADP1 SQL Table
Payment Methods for Payment Wizard OPYM SQL Table
Period Indicator OPID SQL Table
Project Codes OPRJ SQL Table
Documents Numbering - Series NNM1 SQL Table
Journal Entry Codes OTRC SQL Table
Journal Entry OJDT SQL Table
Users OUSR SQL Table
Withholding Tax OWHT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| DocNum KEY UNIQUE | Document Number | Int | 11 | NUM | Yes | |||
| DocType | Document Type | VarChar | C) Customer A) Account S) Vendor P) P.L.A D) Yes T) TDS | 1 | C | |||
| Canceled KEY | Canceled | VarChar | Y) No N) Yes | 1 | N | CANCELED | No | |
| Handwrtten KEY | Manual Numbering | VarChar | Y) No N) Copy | 1 | N | HANDWRITEN | No | |
| Printed | Printed | VarChar | Y) Original N) Yes | 1 | N | |||
| DocDate | Posting Date | Date | 8 | |||||
| DocDueDate | Due Date | Date | 8 | |||||
| CardCode KEY | BP Code | nVarChar | 15 | CARD | No | |||
| CardName | BP Name | nVarChar | 100 | |||||
| Address | Address | nVarChar | 127 | |||||
| DdctPrcnt | Deduction % | Num | 20 | |||||
| DdctSum | Total Deductions | Num | 20 | |||||
| DdctSumFC | Total Deductions (FC) | Num | 20 | |||||
| CashAcct | Cash Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CashSum | Cash Amount | Num | 20 | |||||
| CashSumFC | Cash Amount (FC) | Num | 20 | |||||
| CreditSum | Credit Amount | Num | 20 | |||||
| CredSumFC | Credit Amount (FC) | Num | 20 | |||||
| CheckAcct | Cash Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CheckSum | Check Amount | Num | 20 | |||||
| CheckSumFC | Check Amount (FC) | Num | 20 | |||||
| TrsfrAcct | Bank Transfer Account | nVarChar | 15 | OACT G/L Accounts | ||||
| TrsfrSum | Bank Transfer Amount | Num | 20 | |||||
| TrsfrSumFC | Bank Transfer Amount (FC) | Num | 20 | |||||
| TrsfrDate | Bank Transfer Date | Date | 8 | |||||
| TrsfrRef | Intended Purpose | nVarChar | 27 | |||||
| PayNoDoc | Non-Calculated Payment | VarChar | Y) No N) No | 1 | N | |||
| NoDocSum | Non-Calculated Amount | Num | 20 | |||||
| NoDocSumFC | Non-Calculated Amount (FC) | Num | 20 | |||||
| DocCurr | Document Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| DiffCurr | Entered in LC | VarChar | N) Yes Y) Yes | 1 | N | |||
| DocRate | Document Rate | Num | 20 | |||||
| SysRate | Price (SC) | Num | 20 | |||||
| DocTotal | Total Document | Num | 20 | |||||
| DocTotalFC | Total Document (FC) | Num | 20 | |||||
| Ref1 | Ref. 2 | nVarChar | 8 | |||||
| Ref2 | Ref. 3 | nVarChar | 8 | |||||
| CounterRef | Counter Reference | nVarChar | 8 | |||||
| Comments | Remarks | nVarChar | 127 | |||||
| JrnlMemo | Journal Remark | nVarChar | 50 | |||||
| TransId | Transaction Number | Int | 11 | OJDT Journal Entry | ||||
| DocTime | Creation Time | Int | 6 | |||||
| ShowAtCard | Display Customer Ref. No. | VarChar | Y) No N) Yes | 1 | N | |||
| SpiltTrans | Split Journal Entry | VarChar | Y) No N) Yes | 1 | N | |||
| CreateTran | Create Journal Entry | VarChar | Y) No N) Yes | 1 | Y | |||
| Flags | Flags | Int | 11 | 0 | ||||
| CntctCode | Contact Person | Int | 11 | OCPR Contact Persons | ||||
| DdctSumSy | Deduction Amount (SC) | Num | 20 | |||||
| CashSumSy | Cash Amount in (SC) | Num | 20 | |||||
| CredSumSy | Credit Amount (SC) | Num | 20 | |||||
| CheckSumSy | Check Amount (SC) | Num | 20 | |||||
| TrsfrSumSy | Bank Transfer Amount (SC) | Num | 20 | |||||
| NoDocSumSy | Not Invoiced Amount (SC) | Num | 20 | |||||
| DocTotalSy | Total Document (SC) | Num | 20 | |||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | ||||
| StornoRate | Cancellation Rate | Num | 20 | |||||
| UpdateDate | Date of Update | Date | 8 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| ApplyVAT | Tax Definition | VarChar | Y) No N) Yes | 1 | N | |||
| TaxDate | Document Date | Date | 8 | |||||
| Series KEY | Series | Int | 6 | NNM1 Documents Numbering - Series | SERIES | No | ||
| confirmed | Approved | VarChar | Y) No N) Yes | 1 | N | |||
| ShowJDT | Display Journal Entries | VarChar | Y) No N) Unknown | 1 | N | |||
| BankCode | Bank Code for Bank Transfer | nVarChar | 30 | |||||
| BankAcct | Account for Bank Transfer | nVarChar | 50 | |||||
| DataSource | Data Source | VarChar | N) Interface I) Update U) Import M) DI API O) Doc. Generation Wizard A) Restore Wizard D) Partner Implementation P) Year Transfer T) Yes B) BSP | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| VatGroup | Tax Group | nVarChar | 8 | OVTG Tax Definition | ||||
| VatSum | Tax Amount | Num | 20 | |||||
| VatSumFC | Tax Amount (FC) | Num | 20 | |||||
| VatSumSy | Tax Amount (SC) | Num | 20 | |||||
| FinncPriod | Posting Period | Int | 11 | OFPR Posting Period | ||||
| VatPrcnt | Tax % | Num | 20 | |||||
| Dcount | Discount | Num | 20 | |||||
| DcntSum | Discount Amount | Num | 20 | |||||
| DcntSumFC | Discount Amount (FC) | Num | 20 | |||||
| DcntSumSy | Discount Amount (SC) | Num | 20 | |||||
| SpltCredLn | Split Credit Voucher | VarChar | Y) No N) Yes | 1 | N | |||
| PrjCode | Project Code | nVarChar | 20 | OPRJ Project Codes | ||||
| PaymentRef | Payment Reference No. | nVarChar | 27 | |||||
| Submitted | Submitted | VarChar | Y) No N) Yes | 1 | N | |||
| Status | Created by Payment Wizard | VarChar | Y) No N) BoE Canceled C) Yes | 1 | N | |||
| PayMth | Payment Method | nVarChar | 15 | OPYM Payment Methods for Payment Wizard | ||||
| BankCountr | Bank Country | nVarChar | 3 | OCRY Countries | ||||
| FreightSum | Freight Sum | Num | 20 | |||||
| FreigtFC | Freight Sum (FC) | Num | 20 | |||||
| FreigtSC | Freight Sum (SC) | Num | 20 | |||||
| BoeAcc | Boe Account | nVarChar | 15 | OACT G/L Accounts | ||||
| BoeNum | Bill of Exchange No. | Int | 11 | |||||
| BoeSum | Bill of Exchange Amount | Num | 20 | |||||
| BoeSumFc | Bill of Exchange Amount (FC) | Num | 20 | |||||
| BoeSumSc | Bill of Exchange Amount (SC) | Num | 20 | |||||
| BoeAgent | Bill of Exchange Agent | nVarChar | 32 | OAGP Agent Name | ||||
| BoeStatus | Bill of Exchange Status | VarChar | 1 | |||||
| WtCode | WTax Code | nVarChar | 4 | OWHT Withholding Tax | ||||
| WtSum | WTax Amount | Num | 20 | |||||
| WtSumFrgn | WTax Amount (FC) | Num | 20 | |||||
| WtSumSys | WTax Amount (FC) | Num | 20 | |||||
| WtAccount | WTax Account | nVarChar | 15 | OACT G/L Accounts | ||||
| WtBaseAmnt | WTax Taxable Amount | Num | 20 | |||||
| Proforma | Proforma | VarChar | Y) No N) No | 1 | N | |||
| BoeAbs | Boe Key | Int | 11 | OBOE Bill of Exchange for Payment | ||||
| BpAct | BP Account | nVarChar | 15 | OACT G/L Accounts | ||||
| BcgSum | Bank Charges Amount | Num | 20 | |||||
| BcgSumFC | Bank Charges Amount (FC) | Num | 20 | |||||
| BcgSumSy | Bank Charges Amount (SC) | Num | 20 | |||||
| PIndicator | Period Indicator | nVarChar | 10 | OPID Period Indicator | ' ' | |||
| PaPriority | Payment Priority | VarChar | 1) 2) 3) 4) 5) 6) | 1 | 6 | |||
| PayToCode | Pay to | nVarChar | 50 | |||||
| IsPaytoBnk | Is Pay to Bank | VarChar | N) Yes Y) No. | 1 | N | |||
| PBnkCnt | Pay to Bank Country | nVarChar | 3 | OCRY Countries | ||||
| PBnkCode | Pay to Bank Code | nVarChar | 30 | |||||
| PBnkAccnt | Pay to Bank Account No. | nVarChar | 50 | |||||
| PBnkBranch | Pay to Bank Branch | nVarChar | 50 | |||||
| WizDunBlck | Wizard Dunning Block | VarChar | N) YES Y) Yes | 1 | N | |||
| WtBaseSum | WTax Base Sum | Num | 20 | |||||
| WtBaseSumF | WTax Base Sum (FC) | Num | 20 | |||||
| WtBaseSumS | WTax Base Sum (SC) | Num | 20 | |||||
| UndOvDiff | Under/Overpayment Difference | Num | 20 | |||||
| UndOvDiffS | Under/Overpayment Diff. (SC) | Num | 20 | |||||
| BankActKey | Bank Account Internal ID | Int | 11 | DSC1 House Bank Accounts | ||||
| VersionNum | Version Number | nVarChar | 11 | |||||
| VatDate | Tax Date | Date | 8 | |||||
| TransCode | Transaction Code | nVarChar | 4 | OTRC Journal Entry Codes | ||||
| PaymType | Payment Type | VarChar | N) E) Mail P) Telegraph T) Express X) Without | 1 | N | |||
| TfrRealAmt | Transfer Real Amount | Num | 20 | |||||
| CancelDate | Cancelation Date | Date | 8 | |||||
| OpenBal | Open Balance Amount | Num | 20 | |||||
| OpenBalFc | Open Balance Amount (FC) | Num | 20 | |||||
| OpenBalSc | Open Balance Amount (SC) | Num | 20 | |||||
| BcgTaxSum | Bank Charge Tax Amount | Num | 20 | |||||
| BcgTaxSumF | Bank Charge Tax Amount(FC) | Num | 20 | |||||
| BcgTaxSumS | Bank Charge Tax Amount(SC) | Num | 20 | |||||
| TpwID | Tax Payment Wizard ID | Int | 11 | 0 | ||||
| ChallanNo | Challan No. | nVarChar | 32 | |||||
| ChallanBak | Challan Bank Name | nVarChar | 60 | |||||
| ChallanDat | Challan Received Date | Date | 8 | |||||
| WddStatus | Authorization Status | VarChar | -) Pending W) Approved Y) Rejected N) Generated P) Generated by Authorizer A) Canceled C) Canceled | 1 | ||||
| BcgVatGrp | Bank Charge Tax Group | nVarChar | 8 | OVTG Tax Definition | ||||
| BcgVatPcnt | Bank Charge Tax % | Num | 20 | |||||
| SeqCode | Sequence Code | Int | 6 | |||||
| Serial | Serial Number | Int | 11 | |||||
| SeriesStr | Series String | nVarChar | 3 | |||||
| SubStr | Subseries String | nVarChar | 3 | |||||
| BSRCode | BSR Code | nVarChar | 25 | |||||
| LocCode | Location Code | Int | 11 | OLCT Location | ||||
| WTOnhldPst | WTax On Hold, Posted | Num | 20 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| BuildDesc | Build Descriptor | nVarChar | 50 | |||||
| ResidenNum | Residence Number | VarChar | 1) Spanish Fiscal ID 2) VAT Registration Number 3) Passport 4) Fiscal ID Issued by the Residence Country 5) Certificate of Fiscal Residence 6) Other Document | 1 | 1 | |||
| OperatCode | Operation Code | VarChar | 1 | |||||
| UndOvDiffF | Under/Overpayment Diff. (FC) | Num | 20 | |||||
| MIEntry | MI Entry Include this Payment | Int | 11 | 0 | ||||
| FreeText1 | Free Text 1 | nVarChar | 100 | |||||
| FreeText2 | Free Text 2 | nVarChar | 100 | |||||
| FreeText3 | Free Text 3 | nVarChar | 100 | |||||
| ShowDocNo | Display Document No. | VarChar | Y) Yes N) No | 1 | Y | |||
| TDSInterst | TDS Interest | Num | 20 | 0 | ||||
| TDSCharges | TDS Other Charges | Num | 20 | 0 | ||||
| CUP | Unique Code of Project | Int | 11 | OCUP CUP Codes | ||||
| CIG | Contract Code Identification | Int | 11 | OCIG CIG Codes | ||||
| MIType | MI Type Include this Payment | nVarChar | 270) A/R Monthly Invoice 140000014) A/P Monthly Invoice | 20 | ||||
| SupplCode | Supplementary Code | nVarChar | 127 | |||||
| BPLId | Branch | Int | 11 | OBPL Business Place | ||||
| BPLName | Branch Name | nVarChar | 100 | |||||
| VATRegNum | VAT Reg. Number | nVarChar | 32 | |||||
| BPLCentPmt | Centralized Payment | VarChar | N) No Y) Yes | 1 | N | |||
| DraftKey | Payment Draft Internal ID | Int | 11 | OPDF Payment Draft | ||||
| TDSFee | TDS Fee | Num | 20 | |||||
| MinHeadCL | Minor Head of Challan | Int | 200) TDS Payable by Taxpayer 400) TDS Regular Assessment (Raised by IT Dept) | 11 | ||||
| SEPADate | Requested SEPA Pmt Date | Date | 8 |
Table relationship map
SELECT statement
SELECT
ARCT.DocEntry AS 'Internal Number',
ARCT.DocNum AS 'Document Number',
ARCT.DocType AS 'Document Type',
ARCT.Canceled AS 'Canceled',
ARCT.Handwrtten AS 'Manual Numbering',
ARCT.Printed AS 'Printed',
ARCT.DocDate AS 'Posting Date',
ARCT.DocDueDate AS 'Due Date',
ARCT.CardCode AS 'BP Code',
ARCT.CardName AS 'BP Name',
ARCT.Address AS 'Address',
ARCT.DdctPrcnt AS 'Deduction %',
ARCT.DdctSum AS 'Total Deductions',
ARCT.DdctSumFC AS 'Total Deductions (FC)',
ARCT.CashAcct AS 'Cash Account',
ARCT.CashSum AS 'Cash Amount',
ARCT.CashSumFC AS 'Cash Amount (FC)',
ARCT.CreditSum AS 'Credit Amount',
ARCT.CredSumFC AS 'Credit Amount (FC)',
ARCT.CheckAcct AS 'Cash Account',
ARCT.CheckSum AS 'Check Amount',
ARCT.CheckSumFC AS 'Check Amount (FC)',
ARCT.TrsfrAcct AS 'Bank Transfer Account',
ARCT.TrsfrSum AS 'Bank Transfer Amount',
ARCT.TrsfrSumFC AS 'Bank Transfer Amount (FC)',
ARCT.TrsfrDate AS 'Bank Transfer Date',
ARCT.TrsfrRef AS 'Intended Purpose',
ARCT.PayNoDoc AS 'Non-Calculated Payment',
ARCT.NoDocSum AS 'Non-Calculated Amount',
ARCT.NoDocSumFC AS 'Non-Calculated Amount (FC)',
ARCT.DocCurr AS 'Document Currency',
ARCT.DiffCurr AS 'Entered in LC',
ARCT.DocRate AS 'Document Rate',
ARCT.SysRate AS 'Price (SC)',
ARCT.DocTotal AS 'Total Document',
ARCT.DocTotalFC AS 'Total Document (FC)',
ARCT.Ref1 AS 'Ref. 2',
ARCT.Ref2 AS 'Ref. 3',
ARCT.CounterRef AS 'Counter Reference',
ARCT.Comments AS 'Remarks',
ARCT.JrnlMemo AS 'Journal Remark',
ARCT.TransId AS 'Transaction Number',
ARCT.DocTime AS 'Creation Time',
ARCT.ShowAtCard AS 'Display Customer Ref. No.',
ARCT.SpiltTrans AS 'Split Journal Entry',
ARCT.CreateTran AS 'Create Journal Entry',
ARCT.Flags AS 'Flags',
ARCT.CntctCode AS 'Contact Person',
ARCT.DdctSumSy AS 'Deduction Amount (SC)',
ARCT.CashSumSy AS 'Cash Amount in (SC)',
ARCT.CredSumSy AS 'Credit Amount (SC)',
ARCT.CheckSumSy AS 'Check Amount (SC)',
ARCT.TrsfrSumSy AS 'Bank Transfer Amount (SC)',
ARCT.NoDocSumSy AS 'Not Invoiced Amount (SC)',
ARCT.DocTotalSy AS 'Total Document (SC)',
ARCT.ObjType AS 'Object Type',
ARCT.StornoRate AS 'Cancellation Rate',
ARCT.UpdateDate AS 'Date of Update',
ARCT.CreateDate AS 'Creation Date',
ARCT.ApplyVAT AS 'Tax Definition',
ARCT.TaxDate AS 'Document Date',
ARCT.Series AS 'Series',
ARCT.confirmed AS 'Approved',
ARCT.ShowJDT AS 'Display Journal Entries',
ARCT.BankCode AS 'Bank Code for Bank Transfer',
ARCT.BankAcct AS 'Account for Bank Transfer',
ARCT.DataSource AS 'Data Source',
ARCT.UserSign AS 'User Signature',
ARCT.LogInstanc AS 'Log Instance',
ARCT.VatGroup AS 'Tax Group',
ARCT.VatSum AS 'Tax Amount',
ARCT.VatSumFC AS 'Tax Amount (FC)',
ARCT.VatSumSy AS 'Tax Amount (SC)',
ARCT.FinncPriod AS 'Posting Period',
ARCT.VatPrcnt AS 'Tax %',
ARCT.Dcount AS 'Discount',
ARCT.DcntSum AS 'Discount Amount',
ARCT.DcntSumFC AS 'Discount Amount (FC)',
ARCT.DcntSumSy AS 'Discount Amount (SC)',
ARCT.SpltCredLn AS 'Split Credit Voucher',
ARCT.PrjCode AS 'Project Code',
ARCT.PaymentRef AS 'Payment Reference No.',
ARCT.Submitted AS 'Submitted',
ARCT.Status AS 'Created by Payment Wizard',
ARCT.PayMth AS 'Payment Method',
ARCT.BankCountr AS 'Bank Country',
ARCT.FreightSum AS 'Freight Sum',
ARCT.FreigtFC AS 'Freight Sum (FC)',
ARCT.FreigtSC AS 'Freight Sum (SC)',
ARCT.BoeAcc AS 'Boe Account',
ARCT.BoeNum AS 'Bill of Exchange No.',
ARCT.BoeSum AS 'Bill of Exchange Amount',
ARCT.BoeSumFc AS 'Bill of Exchange Amount (FC)',
ARCT.BoeSumSc AS 'Bill of Exchange Amount (SC)',
ARCT.BoeAgent AS 'Bill of Exchange Agent',
ARCT.BoeStatus AS 'Bill of Exchange Status',
ARCT.WtCode AS 'WTax Code',
ARCT.WtSum AS 'WTax Amount',
ARCT.WtSumFrgn AS 'WTax Amount (FC)',
ARCT.WtSumSys AS 'WTax Amount (FC)',
ARCT.WtAccount AS 'WTax Account',
ARCT.WtBaseAmnt AS 'WTax Taxable Amount',
ARCT.Proforma AS 'Proforma',
ARCT.BoeAbs AS 'Boe Key',
ARCT.BpAct AS 'BP Account',
ARCT.BcgSum AS 'Bank Charges Amount',
ARCT.BcgSumFC AS 'Bank Charges Amount (FC)',
ARCT.BcgSumSy AS 'Bank Charges Amount (SC)',
ARCT.PIndicator AS 'Period Indicator',
ARCT.PaPriority AS 'Payment Priority',
ARCT.PayToCode AS 'Pay to',
ARCT.IsPaytoBnk AS 'Is Pay to Bank',
ARCT.PBnkCnt AS 'Pay to Bank Country',
ARCT.PBnkCode AS 'Pay to Bank Code',
ARCT.PBnkAccnt AS 'Pay to Bank Account No.',
ARCT.PBnkBranch AS 'Pay to Bank Branch',
ARCT.WizDunBlck AS 'Wizard Dunning Block',
ARCT.WtBaseSum AS 'WTax Base Sum',
ARCT.WtBaseSumF AS 'WTax Base Sum (FC)',
ARCT.WtBaseSumS AS 'WTax Base Sum (SC)',
ARCT.UndOvDiff AS 'Under/Overpayment Difference',
ARCT.UndOvDiffS AS 'Under/Overpayment Diff. (SC)',
ARCT.BankActKey AS 'Bank Account Internal ID',
ARCT.VersionNum AS 'Version Number',
ARCT.VatDate AS 'Tax Date',
ARCT.TransCode AS 'Transaction Code',
ARCT.PaymType AS 'Payment Type',
ARCT.TfrRealAmt AS 'Transfer Real Amount',
ARCT.CancelDate AS 'Cancelation Date',
ARCT.OpenBal AS 'Open Balance Amount',
ARCT.OpenBalFc AS 'Open Balance Amount (FC)',
ARCT.OpenBalSc AS 'Open Balance Amount (SC)',
ARCT.BcgTaxSum AS 'Bank Charge Tax Amount',
ARCT.BcgTaxSumF AS 'Bank Charge Tax Amount(FC)',
ARCT.BcgTaxSumS AS 'Bank Charge Tax Amount(SC)',
ARCT.TpwID AS 'Tax Payment Wizard ID',
ARCT.ChallanNo AS 'Challan No.',
ARCT.ChallanBak AS 'Challan Bank Name',
ARCT.ChallanDat AS 'Challan Received Date',
ARCT.WddStatus AS 'Authorization Status',
ARCT.BcgVatGrp AS 'Bank Charge Tax Group',
ARCT.BcgVatPcnt AS 'Bank Charge Tax %',
ARCT.SeqCode AS 'Sequence Code',
ARCT.Serial AS 'Serial Number',
ARCT.SeriesStr AS 'Series String',
ARCT.SubStr AS 'Subseries String',
ARCT.BSRCode AS 'BSR Code',
ARCT.LocCode AS 'Location Code',
ARCT.WTOnhldPst AS 'WTax On Hold, Posted',
ARCT.UserSign2 AS 'Updating User',
ARCT.BuildDesc AS 'Build Descriptor',
ARCT.ResidenNum AS 'Residence Number',
ARCT.OperatCode AS 'Operation Code',
ARCT.UndOvDiffF AS 'Under/Overpayment Diff. (FC)',
ARCT.MIEntry AS 'MI Entry Include this Payment',
ARCT.FreeText1 AS 'Free Text 1',
ARCT.FreeText2 AS 'Free Text 2',
ARCT.FreeText3 AS 'Free Text 3',
ARCT.ShowDocNo AS 'Display Document No.',
ARCT.TDSInterst AS 'TDS Interest',
ARCT.TDSCharges AS 'TDS Other Charges',
ARCT.CUP AS 'Unique Code of Project',
ARCT.CIG AS 'Contract Code Identification',
ARCT.MIType AS 'MI Type Include this Payment',
ARCT.SupplCode AS 'Supplementary Code',
ARCT.BPLId AS 'Branch',
ARCT.BPLName AS 'Branch Name',
ARCT.VATRegNum AS 'VAT Reg. Number',
ARCT.BPLCentPmt AS 'Centralized Payment',
ARCT.DraftKey AS 'Payment Draft Internal ID',
ARCT.TDSFee AS 'TDS Fee',
ARCT.MinHeadCL AS 'Minor Head of Challan',
ARCT.SEPADate AS 'Requested SEPA Pmt Date'
FROM ARCT AS ARCT
Related information
House Bank Accounts DSC1 SQL Table
Countries OCRY SQL Table
Tax Definition OVTG SQL Table
Bill of Exchange for Payment OBOE SQL Table
G/L Accounts OACT SQL Table
Agent Name OAGP SQL Table
Business Place OBPL SQL Table
CIG Codes OCIG SQL Table
Contact Persons OCPR SQL Table
CUP Codes OCUP SQL Table
Currency Codes OCRN SQL Table
Payment Draft OPDF SQL Table
Posting Period OFPR SQL Table
Location OLCT SQL Table
Object Settings - History ADP1 SQL Table
Payment Methods for Payment Wizard OPYM SQL Table
Period Indicator OPID SQL Table
Project Codes OPRJ SQL Table
Documents Numbering - Series NNM1 SQL Table
Journal Entry Codes OTRC SQL Table
Journal Entry OJDT SQL Table
Users OUSR SQL Table
Withholding Tax OWHT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
