RVLPD011 - Sales Payment Document Remittances Header
SQL Query Builder
34 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| REMTYPE | smallint 0 | |||
| REMITID | char(15) '' | |||
| PMTDOCID | char(15) '' | |||
| OrigPmntDocStatus | smallint 0 | |||
| ORICBOOK | char(15) '' | |||
| DESCBOOK | char(15) '' | |||
| CURNCYID | Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | char(15) '' | ||
| CURRNIDX | smallint 0 | |||
| MCSTRUCT_1 | char(15) '' | |||
| MCSTRUCT_2 | smallint 0 | |||
| MCSTRUCT_3 | char(15) '' | |||
| MCSTRUCT_4 | char(15) '' | |||
| MCSTRUCT_5 | numeric(19,7) 0.00 | |||
| MCSTRUCT_6 | datetime '1/1/1900' | |||
| MCSTRUCT_7 | smallint 0 | |||
| MCSTRUCT_8 | datetime '1/1/1900' | |||
| MCSTRUCT_9 | smallint 0 | |||
| MCSTRUCT_10 | smallint 0 | |||
| MCSTRUCT_11 | smallint 0 | |||
| MCSTRUCT_12 | datetime '1/1/1900' | |||
| MCSTRUCT_13 | numeric(19,7) 0.00 | |||
| MCSTRUCT_14 | smallint 0 | |||
| TRXDATE | datetime '1/1/1900' | |||
| PSTGDATE | datetime '1/1/1900' | |||
| BANKACCT | char(35) '' | |||
| COMMAMNT | numeric(19,5) 0.00 | |||
| ACTINDX | Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. | int 0 | ||
| REMTSTAT | smallint 0 | |||
| NUMOFTRX | int 0 | |||
| FUNCTAMT | numeric(19,5) 0.00 | |||
| ORIGAMT | numeric(19,5) 0.00 | |||
| CMRecordNumber | numeric(19,5) 0.00 | |||
| NOTEINDX | numeric(19,5) 0.00 | |||
| DEX_ROW_ID | int auto number (1,1) |
Related Tables
Tables that share columns with RVLPD011. Click "Join" to add to your query.