PP000001 - Deferral Setup
SQL Query Builder
19 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| UNIQKEY | char(1) '' | |||
| SOURCDOC | char(11) '' | |||
| TRXSRCPX | char(5) '' | |||
| NTRXSNUM | int 0 | |||
| PP_Document_Number | char(21) '' | |||
| PP_Open_Closed_Periods | smallint 0 | |||
| PP_Auto_Post | smallint 0 | |||
| PP_Auto_Post_Back | smallint 0 | |||
| PP_RM_Initial_Posting | smallint 0 | |||
| PP_PM_Initial_Posting | smallint 0 | |||
| PP_Calculation_Method | smallint 0 | |||
| PPPRTRPT | tinyint 0 | |||
| PPPRTPRT | tinyint 0 | |||
| PPPRTSCN | tinyint 0 | |||
| PRNTOFIL | tinyint 0 | |||
| PP_Void_Trns | smallint 0 | |||
| PP_Overide_Access | smallint 0 | |||
| PP_Profile_Account_Overw | smallint 0 | |||
| DEX_ROW_ID | int auto number (1,1) |
Related Tables
Tables that share columns with PP000001. Click "Join" to add to your query.
PRNTOFIL